-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `funsecretos`
--

-- --------------------------------------------------------

--
-- Table structure for table `answers`
--

CREATE TABLE IF NOT EXISTS `answers` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `question_id` int(11) UNSIGNED NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `is_correct` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-Incorrect, 1-Correct',
  `status` tinyint(4) DEFAULT NULL COMMENT '0-Inactive, 1-Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_answers_questions1_idx` (`question_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `cities`
--

CREATE TABLE IF NOT EXISTS `cities` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0-Inactive. 1-Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Medellin', 1, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `comment_id` int(11) UNSIGNED DEFAULT NULL COMMENT 'Reply of specific comment in project',
  `project_id` int(11) UNSIGNED NOT NULL,
  `comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_comments_projects1_idx` (`project_id`),
  KEY `fk_comments_comments1_idx` (`comment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `contents`
--

CREATE TABLE IF NOT EXISTS `contents` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `theme_id` int(11) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tags` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `type` tinyint(4) DEFAULT '1' COMMENT '1-Video, 2-Documento, 3-Galeria, 4-Articulo',
  `status` tinyint(4) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_contents_themes1_idx` (`theme_id`)
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `contents`
--

INSERT INTO `contents` (`id`, `theme_id`, `name`, `tags`, `description`, `type`, `status`, `created_at`, `updated_at`) VALUES
(50, 2, 'Contenido  1 - UPDATED', NULL, NULL, 3, 0, '2018-09-24 16:06:30', '2018-09-24 17:04:04'),
(51, 136, 'Miss Bette Wintheiser Jr.', 'Stuart Mraz,Mr. Jocelyn Lindgren,Dr. Fatima Bins,Dortha Goodwin', 'Dignissimos magni repellat ex vel temporibus esse facilis. Et sapiente quis doloribus dolore temporibus nihil. Quia neque at pariatur. Dolores laborum et voluptatem ipsum.', 1, 0, '2018-09-27 20:43:11', '2018-09-27 20:43:11'),
(52, 79, 'Prof. Merl Casper', 'Terry Schroeder,Opal Simonis,Syble Fadel,Ms. Elfrieda Schmitt II', 'Recusandae aut ullam optio voluptatem. Accusantium nisi ducimus ut architecto ipsam rerum. Asperiores rerum dignissimos amet necessitatibus expedita natus totam.', 3, 1, '2018-09-27 20:43:11', '2018-09-27 20:43:11'),
(53, 108, 'Oceane Sawayn', 'Dr. Ophelia Cummerata Jr.,Makenzie Ullrich,Abbie White,Collin Beier', 'Numquam delectus voluptatem facere qui doloremque. Non amet dolorem dolor quasi mollitia eos exercitationem. Libero illo magni voluptates blanditiis.', 2, 0, '2018-09-27 20:43:11', '2018-09-27 20:43:11'),
(54, 122, 'Elenor Schaden', 'Kolby Moore,Tito Ruecker,Ellen Littel,Neva Lockman Jr.', 'Possimus amet occaecati et maiores quas minima. Laborum vero porro et consequatur accusamus. Enim sed esse libero magni expedita iusto. Id dolores enim sint necessitatibus.', 4, 1, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(55, 2, 'Antone Streich DDS', 'Mr. Linwood Marks,Vanessa Lynch,Effie Purdy,Waldo Hoeger', 'Rerum aliquid minus sed totam sunt. Nihil consequatur quia est error aut quo. Nihil perferendis necessitatibus voluptatum nihil deleniti libero vitae. Laboriosam veniam voluptate quia sint nulla.', 2, 1, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(56, 27, 'Dr. Stanford Feest MD', 'Iliana Pouros,Mr. Russell Homenick,Keegan Cronin IV,Mr. Darrin Thiel PhD', 'Et voluptatum voluptate exercitationem. Asperiores nisi consequuntur hic quos dolorem.', 3, 0, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(57, 48, 'Mackenzie Waelchi', 'Gisselle Eichmann,Mr. Anthony Shanahan,Prof. Era Murazik,Dawson Reilly', 'Rem dolores magni distinctio et. Non enim ad et harum et. Dignissimos sed totam optio ut. Culpa et dolorem blanditiis atque.', 3, 0, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(58, 43, 'Mr. Camden Durgan V', 'Miss Emmie Bartell Jr.,Thad Mante,Ms. Emmanuelle Franecki Jr.,Mr. Kip Marvin', 'Exercitationem nesciunt omnis iusto doloribus. Sit non qui itaque illum aperiam. Deserunt et maiores sint dolorem et.', 3, 0, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(59, 34, 'Luther Schulist', 'Hershel Hackett,Dr. Hazel Veum V,Dr. Jackson O\'Keefe V,Prof. Gus Mante DDS', 'Consequatur quae quia quas et laborum. Sit quis non itaque. Quia minus numquam ipsa dolores non.', 3, 0, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(60, 102, 'Dr. Leanne Veum V', 'Mr. Leonardo Pfeffer,Doris Rempel,Dr. Dillon Conn Jr.,Merle Marvin', 'Distinctio suscipit recusandae harum est laudantium minima quam. Doloribus alias voluptatem ut qui fuga. Exercitationem similique reprehenderit quos animi vitae.', 1, 1, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(61, 12, 'Abelardo Daugherty', 'Alanna Lakin,Garrison Welch,Mrs. Rosina Crona,Karlee Botsford IV', 'Aperiam laudantium quia ut sint. Nostrum excepturi id ea laboriosam quod distinctio voluptatem. Rerum rerum voluptatum quia sed quas.', 2, 1, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(62, 152, 'Jabari Flatley MD', 'Asia Gutkowski III,Miss Aida Simonis I,King Stehr,Clementine Kunze', 'Soluta temporibus impedit consequatur voluptatem odit. Ut consequatur distinctio in. Adipisci enim nisi rerum. Earum eligendi dignissimos blanditiis.', 1, 1, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(63, 117, 'Desiree Cremin', 'Prof. Leonard Wolf II,Roger Schmidt,Koby Hilll,Elvis Gusikowski', 'Ipsa dolorum laudantium rerum nemo a. Sapiente deleniti blanditiis qui voluptatum voluptas ut. Occaecati recusandae alias sed quo placeat fugiat tenetur.', 3, 1, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(64, 11, 'Amy Littel', 'Dawson Hodkiewicz,Daphne Crooks MD,Dr. Gudrun McGlynn,Mr. Dawson Wiza MD', 'Sit officiis quis voluptate dignissimos esse. Et voluptas molestiae maiores sapiente. Suscipit illum aut distinctio aut ut quia nesciunt.', 3, 1, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(65, 153, 'Corbin Lueilwitz I', 'Mrs. Dawn Wuckert,Laurie Ward PhD,Deron Dare DDS,Beulah Kutch DDS', 'Numquam tempore laudantium natus maiores. Architecto placeat vel inventore non. Rem laborum maiores accusantium.', 3, 1, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(66, 76, 'Layne Heaney', 'Dr. Rachelle Greenholt,Prof. Edmund Heller,Ms. Elise Skiles MD,Samir Cartwright III', 'Rerum ab magni eligendi officia. Vel nam ut pariatur delectus. Voluptates quos velit enim sit est impedit laudantium commodi.', 4, 1, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(67, 118, 'Jay O\'Keefe III', 'Jayce Schulist,Prof. Cecil Buckridge,Xzavier Friesen,Dr. Cordelia Murphy', 'Sit dolor vel nobis voluptatum similique voluptates tempore amet. Voluptas nulla possimus aut deleniti laborum optio eligendi. Dolores non voluptates assumenda fugiat.', 1, 0, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(68, 27, 'Maurine Franecki', 'Prof. Arden Rippin,Emmett Stiedemann,Dr. Verner Schmeler,Rashawn Hoeger', 'Explicabo accusantium cum ex consequatur assumenda fugiat molestias laboriosam. Aspernatur qui qui aut omnis nostrum labore corrupti. Amet sint aut est quo. Labore numquam a possimus eos.', 3, 1, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(69, 54, 'Kayleigh Brakus', 'Victor Runte,Prof. Dwight Ullrich II,Philip Reichert,Mr. Edgardo Littel DDS', 'Magni quia soluta est explicabo. Neque eligendi ut odit et dolorum est. Doloremque dicta non omnis expedita et rerum qui et. Placeat voluptatem laboriosam ut quo.', 2, 0, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(70, 60, 'Jarrod Block DVM', 'Christiana Gottlieb,Mr. Terence Hand,Marielle Reinger,Dean Beier', 'Impedit facere harum accusantium. Cum et nam ullam quo ad.', 4, 0, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(71, 72, 'Felicita Mante', 'Prof. Gregorio Gutkowski,Jane Sauer,Miss Nellie Smith PhD,Mayra Hilpert', 'Eveniet doloribus in aut eum veniam explicabo repellat dolor. Deserunt maxime exercitationem atque. Dolorum omnis aspernatur in quasi commodi quibusdam labore.', 4, 0, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(72, 76, 'Melvina Bins', 'Dr. Lauretta Braun PhD,Joyce Batz,Erich Schumm,Vern Kautzer', 'Sed repellat sit eaque minus tenetur. Recusandae ut aliquam mollitia rerum quibusdam atque nulla. Natus voluptatibus omnis soluta ea tempore. Corrupti rerum pariatur optio nihil aliquid aut.', 4, 1, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(73, 121, 'Tito Waters MD', 'Mrs. Hilda Mosciski MD,Gia Nienow,Horacio Kuvalis,Elenor Stoltenberg', 'Laborum molestias odio velit vero. Sit rerum omnis delectus nobis non ratione. Voluptatum deleniti aut quam incidunt ducimus.', 1, 1, '2018-09-27 20:43:12', '2018-09-27 20:43:12'),
(74, 48, 'Damaris Kulas', 'Sigrid Ankunding,Polly Hudson PhD,Niko Bednar Jr.,Shania Walter', 'Voluptatem beatae aut quo dicta earum molestias. Illum voluptas soluta perferendis perspiciatis ipsa in. Velit deleniti et earum eum.', 1, 1, '2018-09-27 20:43:13', '2018-09-27 20:43:13'),
(75, 2, 'Layla Ratke', 'Arnold Sauer,Jay Koepp,Mrs. Estell Reilly,Miss Athena Johnston', 'Sequi alias ut exercitationem quibusdam. Et sunt ea est rerum aliquid quos qui. Ratione asperiores culpa tenetur. Rerum et dignissimos accusamus consequuntur hic.', 4, 1, '2018-09-27 20:43:13', '2018-09-27 20:43:13'),
(76, 118, 'Ms. Maxie Jakubowski V', 'Santina Muller,Leanne Trantow,Dr. Nolan Bartell,Mr. Julien Dibbert', 'Cum totam sit ut magnam dolor enim voluptatem libero. Tenetur nesciunt voluptas a explicabo maxime quibusdam suscipit. Aut quidem aut id earum.', 3, 0, '2018-09-27 20:43:13', '2018-09-27 20:43:13'),
(77, 15, 'Waldo Ledner', 'Paxton Brakus IV,Isobel Gibson,Leopold Thompson,Kobe Cole', 'Numquam officia dolorem sed placeat suscipit. Voluptatem odio minus necessitatibus nulla dolor. Aut quaerat assumenda rem. Blanditiis similique ut dolor rem eligendi tenetur.', 1, 1, '2018-09-27 20:43:13', '2018-09-27 20:43:13'),
(78, 128, 'Adelle Nolan', 'Jennings Schowalter,Burley Marquardt,Elizabeth Robel,Lila West', 'Quisquam qui aliquam alias hic voluptas nam. Ullam quia itaque dicta reiciendis eos a.', 2, 1, '2018-09-27 20:43:13', '2018-09-27 20:43:13'),
(79, 34, 'Jacinthe Emard', 'Alejandra Marvin,Brock Yundt,Verlie Douglas IV,Lazaro Waelchi V', 'Animi similique aut neque eos quia voluptatem. Labore cupiditate ut sint repellat ducimus id voluptas. Provident magnam porro commodi quisquam et animi et.', 2, 1, '2018-09-27 20:43:13', '2018-09-27 20:43:13'),
(80, 53, 'Keenan Aufderhar', 'Prof. Cleve Bogan,Miss Vanessa Blick DVM,Mrs. Lexi Kuphal PhD,Mario Dickens', 'Praesentium voluptas vitae quis quia autem ut. Facere officia numquam nam debitis laudantium perferendis.', 2, 1, '2018-09-27 20:43:13', '2018-09-27 20:43:13'),
(81, 40, 'Travis Hackett', 'Brendon Monahan,Myrl Pacocha,Aubree Bogisich V,Zakary Ryan', 'Dolore repellat qui eius voluptatibus veniam facere. Optio sit possimus sit quisquam laborum et. Delectus quod mollitia ipsam totam ipsa ipsam. Amet doloribus quia non maiores.', 1, 1, '2018-09-27 20:43:13', '2018-09-27 20:43:13'),
(82, 115, 'Prof. Theresa Friesen IV', 'Rory Muller Jr.,Hosea DuBuque,Arvid Waters,Hildegard Hagenes', 'Et aut deleniti odit dolorem et culpa minus. Vel voluptate repudiandae ex totam alias recusandae dolor. Voluptatem ipsum repellendus accusantium facilis sit.', 3, 1, '2018-09-27 20:43:13', '2018-09-27 20:43:13'),
(83, 70, 'Carissa Renner', 'Mr. Gaetano Wintheiser II,Demetris Gleason,Mr. Salvatore Hermann DVM,Abigayle Parisian', 'Corporis sit ea dolorem explicabo reprehenderit est asperiores corrupti. Natus quia dolores nulla. Quidem necessitatibus illo rem nisi est adipisci.', 1, 1, '2018-09-27 20:43:13', '2018-09-27 20:43:13'),
(84, 113, 'Mrs. Peggie Orn', 'Andreane Homenick,Prof. Marjolaine Thiel DVM,Mr. Federico Barton MD,Mrs. Shania Mitchell I', 'Doloremque porro eaque ipsam nihil aut animi. Quaerat esse nam consequatur fugit doloremque. Dolores recusandae aliquid non. Dolores dolor ea mollitia minima repellendus quaerat pariatur.', 3, 1, '2018-09-27 20:43:13', '2018-09-27 20:43:13'),
(85, 100, 'Rosa Ernser', 'Alisha Kassulke,Isabella Metz,Lynn Cole,Alf Collins', 'Tempora quasi commodi placeat voluptatem neque autem voluptatem. Perspiciatis et et minus qui sit maiores sunt. Hic minima aut qui ea. Molestiae sunt dolores cupiditate nisi eum soluta et inventore.', 4, 1, '2018-09-27 20:43:13', '2018-09-27 20:43:13'),
(86, 86, 'Garett Kuphal', 'Prof. Kevin Kuhic,Valentin Willms,Cicero Runolfsdottir,Bethel Borer DDS', 'Ipsam perspiciatis voluptatem quasi corporis eius. Veniam adipisci ut esse. Enim id iure fugit molestiae sed qui quis placeat. Eaque vel eius odio laudantium corrupti.', 2, 1, '2018-09-27 20:43:13', '2018-09-27 20:43:13'),
(87, 31, 'Mr. Triston Ziemann', 'Columbus Ryan,Raymond Simonis,Leone Schuster,Miss Kristina Grady Sr.', 'Quia ea maxime ut enim. Quis dolorem temporibus modi beatae officiis expedita rerum. Doloribus laboriosam provident esse totam facere natus necessitatibus ducimus.', 4, 1, '2018-09-27 20:43:13', '2018-09-27 20:43:13'),
(88, 35, 'Mr. John Hoeger DVM', 'Mr. Dameon Langworth,Tanner Hilpert,Mozelle Hartmann,Dr. Kayli Wunsch MD', 'Similique et reprehenderit iure aut quia provident. Praesentium optio qui minus sed quasi quam officia explicabo. Omnis odio et inventore sequi iste quam explicabo.', 2, 1, '2018-09-27 20:43:13', '2018-09-27 20:43:13'),
(89, 38, 'Ricardo Marvin', 'Miss Kellie Balistreri DVM,Yasmine Lubowitz,Stan Stehr Jr.,Dr. Marcelo Shields I', 'Nulla natus velit sunt ea magnam magni reiciendis aut. Laudantium distinctio expedita laboriosam molestiae maxime fuga nesciunt. Quisquam dolore et impedit commodi.', 3, 1, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(90, 133, 'Dr. Colten Lind', 'Miss Micaela Dietrich,Gerson Heller Jr.,Dr. Odell Toy,Dr. Lavon Shanahan', 'Nulla maiores ducimus explicabo quisquam harum. Fugit mollitia quasi voluptatem quia. Quia repellendus eum error aliquam. Non harum nisi quidem incidunt eos provident dolores nobis.', 2, 0, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(91, 90, 'Gabe Russel MD', 'Willis Bayer,Kelley Braun,Maude Kirlin,Rosemary Braun', 'Occaecati consequuntur neque soluta ipsa. Impedit deserunt pariatur quidem qui. Sit ut ipsa incidunt expedita vel.', 3, 1, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(92, 146, 'Rasheed Jaskolski', 'Viola Schiller II,Green Reichert,Princess O\'Conner,Demario Block', 'Placeat ipsa assumenda similique at necessitatibus. Iusto architecto incidunt perspiciatis eos qui. Quas omnis voluptatem nihil temporibus at. Nam ab modi numquam qui.', 1, 1, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(93, 152, 'Garrick Gislason', 'Shaun Macejkovic,Dr. Salvatore Tromp V,Meggie Cronin,Vincenza Aufderhar', 'Eligendi dignissimos non ut laborum. Est quia numquam est ullam cum enim et aut. Voluptatem molestiae ut exercitationem repudiandae ut eum laborum.', 2, 0, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(94, 33, 'Madaline Hahn MD', 'Teagan Baumbach II,Dr. Polly Jones,Miss Luella Reichel,Mr. Nathanial Hirthe', 'Consequatur officiis voluptas error adipisci. Quo suscipit eum magni et earum et quibusdam. Earum dolorem molestiae sapiente quia. Provident quo vel fugit vitae ut dolorum.', 3, 1, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(95, 149, 'Timmothy Paucek IV', 'Megane Crist,Dr. Marian Bernier DDS,Jennie Fahey DDS,Prof. Laura Weissnat PhD', 'Sed sunt quia voluptates placeat quis explicabo. Architecto labore et est eum voluptatem consequatur.', 3, 0, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(96, 39, 'Dulce Towne', 'Dr. Lucio McDermott,Dr. Ursula Rolfson DVM,Keegan Beer,Arden Casper', 'Fuga aut pariatur et quos et distinctio. Maxime et earum recusandae voluptatibus saepe et possimus. Quam voluptas exercitationem nesciunt ea amet rerum.', 2, 1, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(97, 152, 'Percival Macejkovic I', 'Norris Emard,Flavie Maggio PhD,Aubree Graham,Prof. Mitchell Miller Sr.', 'Quibusdam sed nihil id eligendi sunt quia. Excepturi in voluptas corporis velit. Modi minima rerum sed est aut esse.', 2, 1, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(98, 107, 'Helga Hauck III', 'Retha Denesik,Ms. Ardith Hodkiewicz,Shanelle Prosacco,Henriette Hamill', 'Assumenda in et modi ut iure. Quisquam ducimus sed ab. Commodi et quia deserunt aut dicta ea.', 4, 1, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(99, 144, 'Eva Lehner', 'Prof. Jamel Hegmann PhD,Franco McGlynn,Jaquan Schiller,Marcella Boyle', 'Error iusto optio quod. Soluta sed fugit ipsum provident commodi sit id. Eius in qui ratione ab numquam.', 2, 0, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(100, 93, 'Arlene Osinski', 'Tristian Abshire,Dr. Jimmy Rau,Ms. Elena Torphy,Miguel Kulas Sr.', 'Aliquid inventore sapiente qui et. Asperiores qui possimus iste tempora. Quasi pariatur dolor placeat quia inventore.', 3, 0, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(101, 52, 'Emelia Heaney', 'Mr. Kamren Champlin Jr.,Samara Roob,Malika Kulas Sr.,Agustina Runte', 'Est delectus quia doloribus quia nisi expedita. Ut maxime nihil dolor quo dignissimos. Eos voluptatibus cupiditate ullam laborum odio.', 1, 1, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(102, 27, 'Toney Wunsch', 'Eva Hansen PhD,Norris Harber,Alexis Vandervort,Edgardo Nader II', 'Fuga quaerat id possimus iure dignissimos laboriosam suscipit itaque. Tempora iusto reiciendis inventore rerum architecto. Recusandae aut dolores libero tenetur.', 4, 1, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(103, 147, 'Prof. Elmer Hirthe DDS', 'Larue Brown,Dr. Larue Kessler,Ana Kuhn,Dereck Hudson PhD', 'Omnis sapiente pariatur iste cum nemo. Illo nihil esse doloribus sapiente voluptas fuga beatae. At iste cumque sed sed incidunt. Et voluptatem quos doloremque dolore.', 4, 0, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(104, 31, 'Doug Ryan PhD', 'Michel Roob Sr.,Anderson Koelpin III,Dr. Valentin Rohan PhD,Miss Dixie Langosh V', 'Consequatur dolorum voluptates et eligendi aut dolorem. Minus animi ut et sit eum. In maxime illo saepe velit aut molestias. Est est et perferendis fugit.', 3, 1, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(105, 150, 'Maximillia Herzog', 'Elna Hand,Candice Dibbert,Chasity Mohr,Hanna Thiel', 'Tempora nesciunt sunt et fuga. Voluptas ullam est voluptate atque deleniti. Atque iure omnis sit error nobis corrupti mollitia.', 3, 0, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(106, 44, 'Mrs. Naomie Vandervort', 'Jana Swift,Narciso Abbott,Aiyana Hintz,Eunice Braun', 'Quos iste perferendis aut architecto quam eligendi distinctio. Rerum dolorum sit doloremque dicta eum nobis aut soluta. Quia occaecati voluptatem quas.', 1, 1, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(107, 129, 'Susana Ortiz', 'Dr. Berta Wehner,Betsy Bins,Lera Ruecker,Elizabeth Parisian', 'Reprehenderit dolorem hic expedita est voluptas fugiat quasi. Occaecati quod voluptate dolores esse ipsam aut.', 2, 1, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(108, 91, 'Royal McClure', 'Isobel Sanford,Wilton White,Alisha Hahn Jr.,Otha Lakin', 'Veritatis in beatae et quibusdam quo doloribus aperiam. Dolorem cupiditate blanditiis dicta ut eos. Est doloribus ea saepe rerum temporibus et. A qui ducimus corrupti expedita.', 1, 0, '2018-09-27 20:43:14', '2018-09-27 20:43:14'),
(109, 95, 'Raven Zulauf', 'Mrs. Maxie Steuber III,Cedrick Walsh,Dr. Ulices Schimmel,Brooke Kemmer', 'Et soluta dolorum sint saepe porro sit. Voluptate inventore accusamus in et quibusdam aut. Reprehenderit dolorum omnis omnis laudantium est.', 4, 1, '2018-09-27 20:43:15', '2018-09-27 20:43:15'),
(110, 108, 'Cameron Brekke', 'Prof. Johathan Stark,Macy Paucek,Hermann Emmerich III,Bessie Konopelski', 'Ea magnam ea fugiat. Dolor odit sed delectus voluptatem vitae ut. Voluptatem non odit voluptas eligendi ut ut.', 4, 0, '2018-09-27 20:43:15', '2018-09-27 20:43:15'),
(111, 82, 'Gisselle Nienow', 'Deontae Veum,George Bruen II,Esta Leffler,Leonor Nikolaus', 'Voluptas dolorum voluptas est id. Suscipit vel nesciunt quasi.', 1, 1, '2018-09-27 20:43:15', '2018-09-27 20:43:15'),
(112, 17, 'Prof. Margarette Toy', 'Sadie Flatley Sr.,Dr. Domingo Weissnat,Dana Paucek,Mr. Christopher Dooley', 'Quis eveniet voluptatibus ratione architecto quia quidem sit. Voluptas esse quam saepe. Eius omnis reprehenderit libero fugiat.', 3, 0, '2018-09-27 20:43:15', '2018-09-27 20:43:15'),
(113, 104, 'Dr. Rubie Littel', 'Rachel Herzog,Lenny Hammes,Prof. Opal Pfeffer,Dawson Bernhard I', 'Corrupti aliquam commodi velit blanditiis maiores. Quo ab aut iste labore dolor. Beatae cupiditate ullam rerum quia. Fugiat dolor sed cumque earum nesciunt.', 2, 1, '2018-09-27 20:43:15', '2018-09-27 20:43:15'),
(114, 103, 'Hank Davis', 'Leanna Hahn V,Edmond Aufderhar,Hattie Osinski DDS,Gideon Cronin', 'Voluptas ut eaque ipsum dolor qui aut. Voluptas quas et veritatis et. Corrupti enim aliquam est non mollitia.', 2, 0, '2018-09-27 20:43:15', '2018-09-27 20:43:15'),
(115, 5, 'Albina Hamill PhD', 'Prof. Fay Parker,Omari Donnelly,Johnathon Lockman,Bria Ritchie', 'Eaque ab cum dolorem sit neque velit. Labore ea quasi tempora dolorum. Mollitia omnis incidunt numquam voluptas delectus.', 3, 1, '2018-09-27 20:43:15', '2018-09-27 20:43:15'),
(116, 90, 'Emmet Lynch', 'Destiney Koch V,Ms. Mollie Gottlieb V,Ken Hane,Ole Littel', 'Velit expedita dolorem nostrum assumenda cum a ut qui. Voluptates et dolores repellat voluptatem autem nostrum. Eum in laborum quod et vel commodi. Quam sunt et dolor et qui vel est.', 1, 0, '2018-09-27 20:43:15', '2018-09-27 20:43:15'),
(117, 40, 'Foster Swift', 'Else Sporer,Barrett Adams,Vernie Hansen,Keyon Heathcote MD', 'Repellendus asperiores autem rem aut. Explicabo dicta nam quod. Error ut id voluptas tenetur doloremque. Deleniti quia eius cupiditate omnis. Praesentium non officiis non repellat sed.', 3, 1, '2018-09-27 20:43:15', '2018-09-27 20:43:15'),
(118, 82, 'Boris Stoltenberg', 'Mr. Kian Wyman,Junior Mayert,Bulah Bashirian,Ruth Blick', 'Dolor fugiat distinctio molestiae voluptatum amet aut. Quia atque voluptatem et. Neque voluptates qui aut aliquam. Temporibus vero accusantium cum et.', 4, 0, '2018-09-27 20:43:15', '2018-09-27 20:43:15'),
(119, 31, 'Mr. Richmond Bode', 'Emery O\'Conner,Andres Schamberger PhD,Patsy Ullrich,Devyn Heathcote Sr.', 'Quia sint in voluptas voluptatum et nulla velit. Et velit sint asperiores maiores. Quasi quos sed harum mollitia rerum.', 3, 0, '2018-09-27 20:43:15', '2018-09-27 20:43:15'),
(120, 38, 'Verona Green', 'Dr. Davion Vandervort,Bethany Wolf,Ceasar Shields,Brandi Klein V', 'Quibusdam sapiente laboriosam aut eius sapiente et. Nisi corporis voluptas ipsa sint necessitatibus illo quibusdam. Quis rerum pariatur et qui dolor molestias impedit.', 2, 0, '2018-09-27 20:43:15', '2018-09-27 20:43:15'),
(121, 99, 'Ed Leffler II', 'Valerie Glover,Prof. Amely Gaylord,Ms. Nora Crooks V,Kathryn Jacobs', 'Rerum omnis enim molestiae et eveniet rerum ea consequatur. Reprehenderit accusantium similique doloribus iusto aut. Veniam ad aut illo nemo et. Eos veritatis voluptatibus aliquam voluptatem.', 2, 0, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(122, 70, 'Demetrius Rogahn', 'Leopold Towne,Ismael Bogisich Sr.,Dr. Sedrick Gorczany,Jalyn Upton I', 'Dolores iste sunt fugiat eligendi esse et ipsum. Perspiciatis blanditiis sapiente beatae molestiae modi. Quia et ullam itaque natus nihil id nisi distinctio. Voluptatem aut sed repellat maiores.', 3, 0, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(123, 116, 'Cali Beatty', 'Chyna Bode Jr.,Maximilian Effertz,Mrs. Flo Kuphal,Betty Rogahn', 'Unde enim delectus quasi earum quia nulla nobis. Placeat deserunt fuga neque quae corrupti est. Et consequatur aut voluptatem molestiae dolor. Repellendus soluta impedit quasi omnis quae quos.', 3, 0, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(124, 80, 'Dereck Will', 'Dr. Samir Huels,Miss Jewel Nolan,Garrison Jacobs,Ron Franecki IV', 'Consequatur quis aut recusandae est enim numquam libero. Perspiciatis commodi facilis dolor et deleniti illum. Fugit officia esse quam qui. Non vero non expedita totam.', 2, 0, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(125, 100, 'Olga Schowalter', 'Prof. Norval Terry,Ms. Beverly Powlowski,Mr. Deshawn Schaefer,Ms. Magdalena Pagac II', 'Ex enim dicta harum nihil. A molestiae est magni est. Libero mollitia accusantium vel delectus corrupti delectus impedit alias.', 3, 1, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(126, 139, 'Billie Hintz', 'Michael Gerlach MD,Abbey Lynch DDS,Yasmin Windler,Savanna Murazik', 'Qui ut eum magnam a esse nisi. Beatae eum voluptates itaque qui laboriosam. Omnis quis tempore accusamus repellendus iste. Similique aut enim et ipsam quaerat est quo. Sed ut officia autem sequi.', 4, 0, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(127, 39, 'Kelvin Blanda', 'Arden Marks,Carolanne Kuhn,Muhammad Buckridge,Otilia Rogahn', 'Pariatur repellendus aut esse natus eos. Possimus repellendus nesciunt dignissimos nam autem nihil officiis. Autem quo vero vel nobis. Quia cupiditate dolorem voluptate suscipit eveniet.', 4, 0, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(128, 100, 'Freddy Wolff', 'Prof. Jodie Dickinson,Art Senger II,Mrs. Caroline Walsh DVM,Mr. Domenico Wunsch', 'Adipisci aliquid quae omnis. Hic est eum temporibus quo sequi ducimus doloribus. Vitae perspiciatis doloremque inventore ut qui recusandae animi facere. Eius dolorum voluptatem tenetur.', 1, 1, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(129, 87, 'Kelly Daniel', 'Lisa Deckow,Savannah Wilkinson,Angus Frami,Keanu Macejkovic', 'Rem fugit explicabo minima error porro dolores. Aperiam quia provident voluptatem itaque qui. Dicta est placeat non magni atque. Aut voluptatem aut quia delectus dolores voluptatem.', 2, 1, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(130, 128, 'Jerrell Littel', 'Arjun Murray,Ulices Stiedemann,Dr. Antonia Borer MD,Marisol Waelchi DVM', 'Cumque ratione quidem est molestiae culpa. Iste ut minima et pariatur. Odio voluptas aut est.', 4, 0, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(131, 42, 'Kamryn O\'Connell', 'Sim Rutherford,Dr. Hobart Bergnaum,Stan Gleichner,Saul Schaefer', 'Officia architecto officiis quis voluptate rerum sit hic. Facilis ut in est voluptas. Est temporibus in ullam velit voluptatem ad.', 2, 1, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(132, 72, 'Miss Lenna Stehr', 'Effie Smitham DVM,Dr. Houston Conn,Casandra Mills,Laurianne Boyle', 'Ex aut quisquam amet accusamus vel. Non quo iusto minus aut. Id corrupti et tempore quia qui cum ut.', 1, 1, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(133, 117, 'Kaia Jerde', 'Prof. Adolfo Koch,Noel Satterfield,Dr. Branson Harber PhD,Alvena Sawayn II', 'Ipsam optio rerum explicabo voluptatibus non. Repudiandae impedit aperiam corrupti ex nesciunt rerum. Expedita dolores optio odit nihil quae blanditiis.', 4, 1, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(134, 132, 'Mr. Paul Wehner III', 'Humberto Kertzmann,Keagan Macejkovic I,Nickolas Kohler MD,Ms. Octavia Stiedemann V', 'Architecto corporis vitae sed perspiciatis dolor. Quas optio ratione magni et. Molestiae asperiores officiis vero iste aliquam eum atque.', 4, 0, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(135, 132, 'Chadrick Cruickshank I', 'Mrs. Ayana Ankunding,Annette Sporer,Kevon Dooley,Ms. Sophie Leannon', 'Sit accusantium amet ea ut iure sint. Beatae natus molestiae praesentium eum eveniet voluptas minima. Autem doloremque architecto eum est voluptas sit ut.', 3, 0, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(136, 9, 'Yasmeen Streich', 'Shemar Olson,Prof. Anibal Bauch,Dee Ryan PhD,Fern Goldner Jr.', 'Perferendis eveniet reiciendis dolorem dolores ab et voluptas. In nostrum hic ut nobis saepe nam. Et est minus natus aspernatur ut soluta. Incidunt alias vitae ut ea quo.', 1, 0, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(137, 49, 'Laney McClure', 'Dr. Alexandrea Okuneva I,Prof. Rowena Ondricka Sr.,Santa Lockman,Mr. Kristofer Hansen', 'Quo et et et dolores voluptatum aut dolor. Cupiditate ea dolorem nemo reiciendis saepe voluptates ullam. Sit qui aut omnis voluptate ut voluptatem maiores voluptas.', 2, 1, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(138, 36, 'Melyssa Stehr III', 'Brigitte Dare,Prof. Corrine Rempel,Santos Anderson,Carter Carroll Sr.', 'Error commodi laboriosam vero facere delectus modi accusantium. Ex voluptas eos magni possimus.', 4, 0, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(139, 83, 'Armand Pfannerstill Sr.', 'Ila McClure,Ed Luettgen,Paul Mueller,Virginia Howell DDS', 'Aut et eaque optio molestias. Impedit enim doloremque fugiat et est fugiat. Nam minima odio provident sit cumque fugit.', 1, 0, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(140, 40, 'Imogene Aufderhar', 'Jeffery Wyman,Oliver Romaguera,Tanner Reichel,Layne Streich', 'Pariatur quia amet ut quia. Dolorem quia ea voluptas molestias excepturi porro facere. Temporibus atque voluptas maxime itaque. Officiis deleniti unde neque quisquam.', 2, 0, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(141, 104, 'Prof. Florencio Hahn', 'Prof. Jakob Stoltenberg,Shana Pfannerstill III,Mrs. Nora Abbott Jr.,Dr. Tia Kuhic', 'Explicabo tenetur officiis reiciendis voluptate sed voluptatibus ipsum. Aperiam laboriosam quidem eveniet aspernatur maxime. Sapiente esse nostrum consectetur voluptatem.', 3, 1, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(142, 124, 'Tiffany King', 'Mrs. Lenore Purdy,Mr. Terrance Beer,Dr. Derick Abshire PhD,Ms. Betty McLaughlin', 'Autem eaque ducimus culpa laudantium. Atque officiis quis reprehenderit eum. Maxime provident veniam ut omnis. Ullam voluptas esse nostrum voluptas nam.', 3, 1, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(143, 126, 'Rahul Walter', 'Abigail Schneider,Edison Shanahan,Clark Bartell,Janiya Hamill', 'Blanditiis necessitatibus cumque error illo perspiciatis. Enim explicabo et illo. Numquam dolor iure odit delectus unde cupiditate dolor.', 4, 1, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(144, 142, 'Yvonne Lebsack', 'Cara Kertzmann DVM,Prof. Jaren Becker,Friedrich O\'Kon,Mr. Issac Torp', 'Molestiae illo unde similique temporibus at. Magni voluptatibus occaecati non. Deleniti non in aspernatur laboriosam. Mollitia voluptas ducimus reiciendis pariatur voluptatem.', 1, 0, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(145, 92, 'Melissa Lubowitz', 'Josephine Stokes,Olen Marvin DDS,Ms. Rosanna Mante,Hosea Hegmann', 'Voluptates ad non delectus omnis suscipit sit sint. Non quia et ut commodi repudiandae dolor nobis. Quos quia sunt repudiandae iste aspernatur aut. Est autem omnis earum molestias aut modi ut velit.', 2, 0, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(146, 126, 'Annabel Huels MD', 'Prof. Ada Schuster,Isabell Harvey,Dr. Juliet Herzog,Keagan Little II', 'Repudiandae ipsam recusandae quo est et error ut. Pariatur laudantium rem porro maxime omnis. Velit veritatis numquam unde natus. Dolorem voluptatum est totam.', 1, 0, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(147, 43, 'Ayla Kreiger', 'Gay Reilly,Zelda Mraz,Mr. Maurice Jenkins PhD,Elna Corkery', 'Possimus itaque voluptatibus aliquam dolor recusandae atque. Eius architecto quod quasi. Totam nisi est aliquam mollitia ratione. Et aliquid sit omnis.', 3, 0, '2018-09-27 20:43:16', '2018-09-27 20:43:16'),
(148, 104, 'Laila Rippin', 'Oswald Mayert,Mrs. Esta Jones DDS,Korey Johnston,Walker Trantow Jr.', 'Sunt tempore similique ex non. Consequatur nam earum et optio nostrum. Non et nesciunt dolores incidunt temporibus illum itaque in.', 3, 0, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(149, 83, 'Norwood Goldner', 'Daniela Monahan,Sabina Abshire,Sebastian Block MD,Mr. Stan Treutel V', 'Dolor enim vitae maiores id. Voluptatem voluptas mollitia occaecati similique nostrum aperiam. Mollitia ut nihil reiciendis libero libero et nostrum.', 1, 0, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(150, 95, 'Mrs. Marianne Nader', 'Pasquale Kautzer,Dr. Michele Greenholt IV,Ophelia Jones II,Art McCullough', 'Voluptatum exercitationem minus qui aut delectus a non. Fugiat dolor tempora sit qui quis alias ipsum. Ea eos et consectetur consequuntur.', 3, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(151, 76, 'Prof. Austin Blanda III', 'Tiana Dibbert,Prof. Madilyn Brekke,Joshuah DuBuque,Mrs. Ebony Satterfield DDS', 'Voluptatem sunt et cum. Molestias unde dolorum aut voluptatem nostrum est labore. Itaque quod itaque quia molestiae non veritatis veritatis. At architecto fuga accusantium quaerat.', 2, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(152, 51, 'Deon Kulas', 'Molly Feil,Prof. Reed Schultz DVM,Matilda Ward,Beth McCullough', 'Sint dolorem libero enim nam delectus exercitationem. Voluptates voluptatem sequi dolor. Dolor repellat sequi nihil ut eligendi repellat et voluptatibus.', 2, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(153, 143, 'Hailee Swaniawski Jr.', 'Mr. Gilbert Herman II,Ms. Everette Metz DDS,Lucious Skiles,Prof. Immanuel Schumm Jr.', 'Saepe neque enim omnis autem non. Iste praesentium voluptas sequi voluptas illo iste. Ratione velit molestiae voluptatem quasi repellat voluptatum. Rerum cum illo voluptates.', 4, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(154, 88, 'Ms. Chanel Watsica', 'Miss Constance O\'Kon II,Mr. Harry Sporer III,Dr. Barton Murphy,Irwin Spinka', 'Iste aperiam perferendis omnis. Nobis sint ipsum eius sit et ut. Qui iusto ut possimus.', 2, 0, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(155, 139, 'Prof. Heber Heller', 'Marlene Huel,Prof. Hattie Auer,Devonte Wunsch V,Ms. Leslie Jakubowski IV', 'Minima assumenda sunt deserunt magnam eveniet. Numquam aut earum necessitatibus optio. Aut inventore omnis voluptas et sint vitae. Excepturi velit et et eius est fugit eaque. Vel rerum sed est sed.', 4, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(156, 91, 'Melody Rau II', 'Shemar Jacobson MD,Dr. Kay Shields DDS,Oswald Gutmann I,Priscilla Hermiston', 'Non rerum libero voluptatem molestias ipsa iste corporis. Officia aut similique aliquid neque qui. Quo similique et possimus eos voluptate.', 2, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(157, 42, 'Jude Kozey', 'Prof. Astrid Shields MD,Marcelo Lang,Trenton Carroll IV,Aubree Zemlak', 'Eius doloremque odio et consequatur molestias neque harum explicabo. Ut a culpa quidem quod beatae autem id. Alias maiores deserunt sit fugiat et excepturi quia.', 2, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(158, 124, 'Cara Pouros', 'Kadin Jacobs IV,Virgie Sporer,Izabella Klein,Mrs. Baby Pagac Sr.', 'Quibusdam omnis quia atque nostrum nesciunt sunt. Eum voluptatem voluptas tenetur. In reprehenderit ut voluptatem ipsam. Facere omnis adipisci tempore quasi et.', 4, 0, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(159, 25, 'Hailee Lakin', 'Mr. Wilmer Borer DDS,Chanel Aufderhar IV,Scottie Von Jr.,Dr. Darrin Prosacco II', 'Aliquid eaque repellendus consequuntur quo consequatur dolorem atque voluptatem. Aliquid velit incidunt molestias et. Ut sed et saepe omnis. Ut et modi ut vitae consequatur.', 3, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(160, 68, 'Dr. Forrest Aufderhar I', 'Kailey Toy,Gerry Senger,Mr. Horace Little,Mr. Kris Stroman', 'Ex ipsa nihil quaerat ut sit. Cupiditate unde voluptas impedit ut.', 4, 0, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(161, 45, 'Prof. Christine Mann III', 'Prof. Monte Conn PhD,Ova Kris DVM,Dariana Eichmann DDS,Miss Christy Mohr', 'Quis velit magni itaque cumque quia qui. Sed itaque placeat repellendus voluptas aut ut at.', 1, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(162, 144, 'Miss Kaitlyn Feest III', 'Keon Bednar,Brant O\'Kon,Jaycee Mayer,Breana Rolfson', 'Quibusdam recusandae quam mollitia fugiat eveniet at. Sint ut rerum quis necessitatibus. Enim mollitia expedita quae ratione et. Quaerat fugit quisquam cumque velit.', 3, 0, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(163, 60, 'Louie Herman', 'Renee Green,Prof. Holden Treutel V,Prof. Elbert Schowalter PhD,Miss Iliana Borer', 'Sunt ut sunt ipsam sunt. Quia voluptatem consequatur blanditiis occaecati. Quaerat distinctio provident iure harum perspiciatis rem molestiae quasi. Quis pariatur nemo consequuntur ipsum sunt et.', 3, 0, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(164, 46, 'Buster Rolfson', 'Levi Hessel,Winifred Bernier,Rosanna Schumm V,Clint Breitenberg PhD', 'Atque sit commodi porro et eum. Nihil officiis accusantium ipsa voluptatum sint corrupti eligendi. Qui omnis blanditiis dicta at quo et nihil. Saepe aut consequatur qui ad voluptatem.', 2, 0, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(165, 20, 'Prof. Lulu Sawayn IV', 'Trinity Schamberger,Leilani Hilll,Elmira Osinski IV,Miss Robyn Cronin', 'Nesciunt sit error aspernatur omnis reiciendis quia vel. Perspiciatis odit nulla enim ipsa incidunt sed. Consequuntur et eveniet dolorem ut quia.', 2, 0, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(166, 75, 'Martin Nienow', 'Trystan Orn,Mr. Monty Predovic MD,Antwan Fritsch,Bridget Gleichner', 'Aut et qui consectetur tempora. Aut rerum amet accusantium quia saepe voluptas natus neque. Ex quia deleniti est aspernatur quod et esse.', 1, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(167, 78, 'Prof. Alfred Pagac', 'Mrs. Felicia Aufderhar PhD,Hellen Mitchell,Dr. Jakob Hahn I,Derick Daugherty', 'Qui consectetur nesciunt aut quas illo ab iusto dolores. Consequatur rem sunt doloribus consequuntur nemo qui. Autem omnis cum minima modi praesentium et nihil praesentium. Ut facere porro id nulla.', 2, 0, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(168, 6, 'Miss Mariana Rolfson IV', 'Bertha Koelpin,Coralie Heaney,Era Bayer IV,Yolanda Crona', 'Doloremque dolores repellendus cupiditate id cumque possimus. Dolorum qui rem repellat unde. A rerum aut voluptatibus asperiores. Quia quis tempore ipsam hic eius voluptas nam.', 1, 0, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(169, 128, 'Desmond Jakubowski', 'Cali Stark,Miss Robyn Green,Helene Pacocha,Myriam Schmidt', 'Consequatur rerum quos consequatur qui. Nemo cumque autem harum. Quia ut qui saepe. Dolor repellat quia molestiae et esse harum.', 4, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(170, 108, 'Ron Rosenbaum', 'Casimir Mueller,Moises Ratke DVM,Alisa Predovic,Zora Turcotte', 'Aliquam aliquid porro quo nobis sit iusto dicta. Nihil a deleniti et ad aut quia dolorum recusandae. Est voluptatem quis rem quos.', 3, 0, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(171, 113, 'Aidan Collier', 'Conner Schneider DDS,Misty Schuster,Roberta Cruickshank,Ervin Donnelly', 'Est ut ullam et cum. Illo ea dolores quas illum et. Et modi sunt suscipit tenetur. Autem est eos et doloremque saepe voluptas.', 3, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(172, 48, 'Hector Zulauf', 'Karelle Gaylord,Sydney Leffler,Liliane Hayes,Dr. Garrick Schamberger', 'Maxime quia voluptate sint doloremque. Rem adipisci qui nihil.', 3, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(173, 150, 'Herminio Hansen', 'Ervin Dooley,Rickey Jacobson,Prof. Shanelle Wilkinson,Tyson Wyman I', 'Molestias vel qui possimus modi non. Dolorum aut dignissimos veritatis sunt temporibus impedit vero minima. Accusamus quaerat aspernatur aliquam deleniti eveniet consequatur.', 1, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(174, 119, 'Kendrick Rosenbaum', 'Leann Crist,Prof. Kaya Altenwerth,Chelsie Jones,Mrs. Brandy Ruecker', 'Enim doloribus sit amet aut. Et distinctio perspiciatis asperiores cupiditate.', 2, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(175, 119, 'Oma Gleichner', 'Aiden DuBuque I,Jayden Lehner,Dr. Donnie Weissnat II,Hal Champlin', 'Distinctio qui ea quisquam consectetur et id. Aut ea aspernatur quae corrupti libero. Laborum dolor nihil quia aut.', 1, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(176, 121, 'Sheridan Hane', 'Major Murphy,Ron Schumm,Alva Howe IV,Ernestine Muller PhD', 'Dolorem adipisci id quo voluptates sit odio consequatur. Quis maiores cumque ea impedit architecto unde est sit. Deserunt earum maxime commodi repellat. Ut dolorem amet tenetur laborum libero.', 1, 0, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(177, 35, 'Prof. Syble Schultz I', 'Lawrence O\'Connell Jr.,Kirstin Hirthe,Vada Little,Dr. Gilda Considine', 'Minima maiores expedita laborum id. Saepe ea reiciendis officiis provident quasi et. Non vero ut dolores itaque aut. Dolores libero nesciunt vel quo omnis qui. Esse ratione sed doloremque laboriosam.', 3, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(178, 152, 'Fatima Hartmann', 'Carleton Mohr,Victor Mertz,Miss Ardith Rempel,Miss Chanel Turcotte', 'Quibusdam vitae dolor quae accusantium itaque expedita. Quod optio accusantium eos. Velit eum ex qui beatae quis labore et. Sed est soluta temporibus quo numquam.', 1, 0, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(179, 89, 'Simone Howell', 'Margot Gislason,Irving Gottlieb MD,Ms. Shanelle Herman,Miss Candice Glover PhD', 'Ut harum sequi labore temporibus velit magnam. In quia molestiae officia culpa. Voluptas voluptates accusantium sunt aut. Labore dolorem dolores repellat deserunt ea tempora voluptatem illo.', 2, 1, '2018-09-27 20:43:17', '2018-09-27 20:43:17'),
(180, 21, 'Mrs. Verda Mertz IV', 'Bell Kuphal MD,Sage Bruen,Simone Conroy,Parker Reichert', 'Nihil sint odit perspiciatis ullam sit in. Officiis eius sed deserunt eos aut deserunt incidunt. Excepturi eaque provident qui.', 3, 0, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(181, 19, 'Giovanni Pouros', 'Henriette Prosacco,Miss Abigale Fisher DVM,Gardner Schmeler,Winona Green', 'Ut quo atque quaerat qui totam minus exercitationem. Et consequatur in aut ea et eius mollitia. Voluptatibus eos ipsum dolorum neque ab voluptatum. Assumenda fugiat perferendis error.', 3, 1, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(182, 39, 'Torrey Predovic Jr.', 'Rodger Dare,Mr. Watson Murazik,Maida Schaden,Eldridge Grant V', 'Voluptates rerum voluptatem ut laboriosam sint perferendis exercitationem. Et odit recusandae aut id aut dolor ea. Molestiae ratione dicta libero ipsam molestiae.', 2, 1, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(183, 21, 'Dr. Cruz Ullrich III', 'Michale Smitham,Jordane Witting II,Preston Stark,Bernardo Bernier', 'Saepe dignissimos nihil voluptatem aut voluptatibus minus. Sint quaerat qui quisquam illo tenetur nostrum laudantium. Voluptatem vel sed dolorem commodi cumque at in sed.', 3, 1, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(184, 26, 'Prof. Hosea Hartmann', 'Prof. Oral Wehner Jr.,Jensen Runolfsson,Dewayne Grant III,Dereck Goodwin', 'Ut sequi magnam vitae aspernatur velit quia modi dolor. Et eligendi asperiores id reiciendis ab temporibus optio qui. Sunt porro et corrupti accusamus.', 4, 0, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(185, 15, 'Jenifer Skiles', 'Carolanne Reynolds,Dr. Armani Stiedemann II,Lola Hintz,Nettie Lueilwitz III', 'Deleniti sit maxime quos modi odio voluptates delectus dolor. Iste quae quas numquam modi consequatur. Tenetur dolores beatae non veniam perspiciatis doloribus aspernatur.', 2, 0, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(186, 90, 'Ciara Gleichner', 'Sandra Langosh,Prof. Julia Torphy Sr.,Prof. Wade Bins,Nelle Harris', 'Sint iure magni ab maiores ea magni. Voluptatem illo minima possimus earum. Quis dolorem reiciendis maiores et delectus eos vitae. Sint praesentium minus sapiente in laborum neque commodi eum.', 2, 0, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(187, 131, 'Mr. Keith Bruen', 'Mrs. Evie Rau,Jazlyn Torphy,Mr. Nathan Bauch,Prof. Triston Cruickshank II', 'Provident nobis animi et occaecati. Cupiditate quia sit quia nihil quasi. Saepe molestiae molestiae vel quia velit.', 2, 0, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(188, 17, 'Prof. Ansley Morissette', 'Justina Russel,Rosella Waelchi,Noemi Prohaska Sr.,Reina Romaguera Sr.', 'Ab unde est dolorem porro. Est qui et ratione. Quaerat quasi praesentium consectetur aut.', 1, 0, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(189, 25, 'Miss Clotilde Hermiston', 'Hazle Jacobs,Prof. Christelle Medhurst Jr.,Jadon Littel,Armand Wuckert', 'Eveniet aut inventore enim. Voluptate autem autem eaque provident ipsam consequatur. Quia voluptas magni omnis reiciendis corrupti at.', 2, 1, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(190, 132, 'Reuben Leannon', 'Dr. Hugh Luettgen,Izaiah Kuphal,Luna Bosco,Dr. Hilma Hermiston', 'Quia facilis tempora praesentium quidem. Sequi voluptas aut et quos earum occaecati consequatur. Sed suscipit explicabo voluptatem. Quae et rerum qui ut odio.', 2, 0, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(191, 130, 'Tavares Kulas DVM', 'Prof. Vicente Lehner DDS,Ryder Schinner,Prof. Javon Welch,Moises Green IV', 'Voluptas sunt quia rem ratione. Nisi qui magni quisquam repudiandae sed. Consequuntur voluptas praesentium laudantium sit. Et et saepe voluptas provident.', 4, 1, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(192, 68, 'Mrs. Britney Reichert', 'Royal Reynolds,Eugene Kohler,Miss Alysha Krajcik,Elouise Will IV', 'At nemo inventore veritatis nostrum. Voluptatem ipsum aut doloribus sed. Nam magnam est laudantium quod voluptas quos. Voluptatum vitae qui eos eos asperiores culpa deserunt.', 2, 0, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(193, 45, 'Greta Parisian', 'Hoyt Cremin,Shanelle Hettinger,Dr. Ricardo Schultz,Prof. Kobe Roberts MD', 'Atque deserunt architecto ullam. Quis quisquam excepturi illum. Vero qui distinctio soluta voluptatem et totam.', 1, 0, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(194, 8, 'Guillermo Hackett', 'Dr. Maya Rempel Jr.,Enoch Jacobs,Kallie Wilkinson,Jon Considine PhD', 'Et quia qui quia omnis aut. Ipsum modi nemo adipisci iure ab enim. Quo iure nemo magni quae qui quia eveniet. Et illo animi nihil optio.', 1, 0, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(195, 151, 'Arvilla Terry', 'Isaias Roberts DVM,Ardella Schowalter,Dr. Emiliano Klein,Mrs. Lauryn Hansen II', 'Nemo excepturi accusamus quasi mollitia corrupti illum. Vel autem ipsum earum qui aut sunt. Omnis nam occaecati eaque qui omnis enim. Magni alias cumque nulla dolorum. Illum libero sed modi cumque.', 2, 1, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(196, 58, 'Dr. Lulu Johnson MD', 'Hillary Bartell,Karl Feil,Mrs. Mikayla Kerluke,Joyce Bergnaum', 'Vero in adipisci ducimus voluptas eaque deleniti facere. Eum distinctio culpa molestiae id quis voluptas pariatur. Quis voluptas quo tenetur aspernatur laboriosam nihil.', 4, 0, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(197, 68, 'Bernie Hintz', 'Dr. Eldora Ruecker,Prof. Lucio Jacobi,Ettie Lowe,Fermin Wehner I', 'Quo harum qui quam molestiae non reiciendis. Fugiat saepe facere aspernatur. Dolor ullam est sequi qui ad qui exercitationem aperiam. Perspiciatis quis ad harum rerum.', 3, 1, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(198, 147, 'Mrs. Adell Pouros PhD', 'Sidney Kovacek,Luis Haag,George Jerde,Dr. Theo Dibbert', 'Est et et et itaque labore assumenda qui. Consequatur aliquam odit qui quos voluptate asperiores expedita et. Qui at et voluptatem officia.', 4, 1, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(199, 58, 'Ellsworth Greenholt', 'Prof. Jaron Pfeffer,Mr. Earnest Koss DDS,Carolyn Pacocha,Mrs. Cheyanne Gerlach Sr.', 'Harum qui quia magnam nesciunt qui. At soluta fuga dolor et voluptatum ut. Dolorum in incidunt cumque qui minima. Aut laboriosam possimus aut eius.', 3, 1, '2018-09-27 20:43:18', '2018-09-27 20:43:18'),
(200, 12, 'Marion Turcotte', 'Miss Susanna Goyette,Reece Wiza II,Noemie Mertz,Roman Swift', 'Dolores veniam nesciunt corporis sed ut ut enim. Consequatur consectetur asperiores et cum rerum et laborum. Enim aspernatur voluptatibus ut maxime.', 3, 0, '2018-09-27 20:43:18', '2018-09-27 20:43:18');

-- --------------------------------------------------------

--
-- Table structure for table `courses`
--

CREATE TABLE IF NOT EXISTS `courses` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `formation_level_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED DEFAULT NULL COMMENT 'User responsable of course',
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tags` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cover` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Image used for show in course presentation.',
  `certificate` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Image for generate certificate when student finish the course',
  `description` text COLLATE utf8_unicode_ci,
  `evaluable` tinyint(4) NOT NULL DEFAULT '0',
  `evaluation_time` float DEFAULT NULL COMMENT 'In hours',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0-Inactive, 1-Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_courses_users1_idx` (`user_id`),
  KEY `fk_courses_formation_levels1_idx` (`formation_level_id`)
) ENGINE=InnoDB AUTO_INCREMENT=455 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `courses`
--

INSERT INTO `courses` (`id`, `formation_level_id`, `user_id`, `name`, `tags`, `cover`, `certificate`, `description`, `evaluable`, `evaluation_time`, `status`, `created_at`, `updated_at`) VALUES
(3, 1, 1, 'Curso - 1 - UPDATE', 'matematicas,basico,calculo', 'XPUQRJPTXY_20180924104556.jpg', 'QDFKLLTUWH_20180919145911.jpg', NULL, 1, 2, 0, '2018-09-19 19:59:11', '2018-09-24 16:52:38'),
(4, 1, 1, 'Curso - 1', 'matematicas,basico,calculo', 'PMPAWCDAZH_20180924104002.jpg', NULL, NULL, 1, 2, 1, '2018-09-24 15:40:03', '2018-09-24 15:40:03'),
(305, 99, 221, 'Mrs. Myra Weber V', NULL, '742a238e-82dc-3045-b9d2-732025112152.png', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:41', '2018-09-27 20:27:41'),
(306, 168, 216, 'Ruthie Mertz I', NULL, '8b3c9c41-801a-3805-87f1-de5ec6698b9a.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:41', '2018-09-27 20:27:41'),
(307, 160, 128, 'Eli Harvey Sr.', NULL, 'f3690da6-4bff-3b20-8813-ded3ee1b59df.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:41', '2018-09-27 20:27:41'),
(308, 159, 252, 'Ruth Williamson', NULL, 'b4f3ad0e-4623-3f66-b01e-ab97f966c94e.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:42', '2018-09-27 20:27:42'),
(309, 181, 160, 'Deion Schiller V', NULL, 'b8583c29-e9e0-33ec-af7b-af6bb591097a.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:42', '2018-09-27 20:27:42'),
(310, 66, 109, 'Miss Madelynn Haley DDS', NULL, '3b66c05d-d3cb-3d6e-8a6a-ee5e4199d924.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:42', '2018-09-27 20:27:42'),
(311, 232, 127, 'Monserrat Wilderman DVM', NULL, 'f220ee4f-9b6b-37c3-b53a-09134cff9be3.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:42', '2018-09-27 20:27:42'),
(312, 146, 172, 'Caleigh Torp', NULL, '4705c149-5394-3146-9a12-ed714c10c1b6.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:42', '2018-09-27 20:27:42'),
(313, 91, 111, 'Dr. Raoul Larson MD', NULL, 'a27e254e-ade2-3ad9-bee9-2545a518cab8.png', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:42', '2018-09-27 20:27:42'),
(314, 141, 185, 'Kavon Schowalter', NULL, '698db90f-a6b4-3c20-963c-6fbc0b62587f.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:42', '2018-09-27 20:27:42'),
(315, 99, 244, 'Alessandra Deckow', NULL, '5d82e570-c6a5-3709-901b-cbed60c4d2ef.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:42', '2018-09-27 20:27:42'),
(316, 164, 111, 'Dr. Favian Emard IV', NULL, '648a8210-0b40-30e9-8029-dd0408b7adc8.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:42', '2018-09-27 20:27:42'),
(317, 180, 181, 'Kailee Nienow', NULL, 'c7acf539-4d53-34af-84ab-65c0a6205308.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:43', '2018-09-27 20:27:43'),
(318, 69, 199, 'Rossie Kunde', NULL, 'c1a8afa5-a667-3472-ba69-c0bdfe6c9da0.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:43', '2018-09-27 20:27:43'),
(319, 49, 228, 'Prof. Monte Heathcote DVM', NULL, '77bc4577-10ed-3f96-9d3e-874cf3eb28a0.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:43', '2018-09-27 20:27:43'),
(320, 182, 238, 'Asa Hegmann', NULL, 'a0033d79-21ee-38ea-a329-66e7782fb5b4.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:43', '2018-09-27 20:27:43'),
(321, 171, 198, 'Garnett Jacobi', NULL, 'a5aac4a9-8ee2-3968-86b4-b1b102cde120.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:43', '2018-09-27 20:27:43'),
(322, 55, 134, 'Zachary Koss', NULL, '3320b55a-10aa-33ea-a21c-7c2c8b9b0898.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:44', '2018-09-27 20:27:44'),
(323, 251, 180, 'Madelyn Turcotte', NULL, '6c001845-da88-3f32-a632-003ddc8a8402.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:44', '2018-09-27 20:27:44'),
(324, 76, 109, 'Leo Gaylord', NULL, 'da71d841-bfce-3fac-8756-037a6cee8a15.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:44', '2018-09-27 20:27:44'),
(325, 119, 168, 'Ronaldo Greenholt', NULL, '818d61d4-9588-3b76-91b0-4053b1c3f570.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:44', '2018-09-27 20:27:44'),
(326, 234, 205, 'Dr. Mercedes Jacobi PhD', NULL, '861e28ba-7677-37eb-b825-e1bbaf64efe4.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:44', '2018-09-27 20:27:44'),
(327, 197, 158, 'Emilia Heathcote', NULL, 'bd08f2ec-cc47-3171-9d2f-e7bd8f6a61c7.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:44', '2018-09-27 20:27:44'),
(328, 157, 173, 'Yazmin Macejkovic', NULL, '8b140b8f-ed77-31cd-bb38-39a69cef9bd3.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:44', '2018-09-27 20:27:44'),
(329, 95, 232, 'Krystal Grant', NULL, 'dc397dbe-ef4d-3d26-867a-0d3daf431878.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:44', '2018-09-27 20:27:44'),
(330, 169, 132, 'Clyde Murazik', NULL, '9946cb85-ca15-3461-86c5-0a2d7bec32c7.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:44', '2018-09-27 20:27:44'),
(331, 140, 178, 'Jeramy Cremin', NULL, '492e95a5-b351-3c9c-83b9-6ff6e1b46e99.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:44', '2018-09-27 20:27:44'),
(332, 70, 253, 'Leda Kshlerin V', NULL, '1a1deeda-303a-34d1-b50b-bfd2a60d3e22.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:44', '2018-09-27 20:27:44'),
(333, 227, 126, 'Prof. Chelsea Wunsch MD', NULL, 'd81ce1ac-bce3-3f1a-a162-01d8997d6511.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:44', '2018-09-27 20:27:44'),
(334, 9, 238, 'Ole Ward', NULL, 'fedd124b-0f6a-3af5-bdae-236d13543ea3.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:44', '2018-09-27 20:27:44'),
(335, 124, 215, 'Garnett Grady', NULL, 'c51db420-8d77-332c-8383-ec2d297ef1a2.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:45', '2018-09-27 20:27:45'),
(336, 165, 191, 'Katherine Stiedemann', NULL, '324c98c8-3730-389c-b45c-e2ec44c47389.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:45', '2018-09-27 20:27:45'),
(337, 127, 126, 'Alden Gerlach', NULL, '2781ffd8-d640-357d-aca4-85a38627b30e.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:45', '2018-09-27 20:27:45'),
(338, 121, 126, 'Prof. Pat Hammes', NULL, 'f4af04d1-3fc0-32e3-a8cb-b5d26a60010e.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:45', '2018-09-27 20:27:45'),
(339, 199, 148, 'Geraldine Mertz', NULL, 'bf74f5cb-1ca1-3bb8-a765-a181caa121d2.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:45', '2018-09-27 20:27:45'),
(340, 24, 203, 'Mittie Hoeger', NULL, '7dc07cbd-1dde-3d0a-8f06-10de4c4b2c39.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:45', '2018-09-27 20:27:45'),
(341, 42, 188, 'Jammie Monahan', NULL, '4ff3b966-4167-37ac-a30a-90f34f992212.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:45', '2018-09-27 20:27:45'),
(342, 59, 125, 'Cleta Daugherty', NULL, '1cedc037-aecb-3919-8755-ea61b19730bc.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:45', '2018-09-27 20:27:45'),
(343, 148, 125, 'Dr. Hilario Wilkinson', NULL, '49605ac2-38b1-3ddb-a943-fa4122a8ad94.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:45', '2018-09-27 20:27:45'),
(344, 57, 109, 'Prof. Junius Daniel', NULL, '9dac694f-3338-33f4-a78a-84009267657b.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:45', '2018-09-27 20:27:45'),
(345, 147, 242, 'Ted Strosin', NULL, '013b208a-f11f-3251-9d9d-9d9a3cf52cd2.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:45', '2018-09-27 20:27:45'),
(346, 212, 193, 'Janis Carter PhD', NULL, 'a4a0f503-6999-317e-8393-685c01cb4207.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:45', '2018-09-27 20:27:45'),
(347, 97, 178, 'Logan Krajcik', NULL, '6540db94-6d5b-3e6f-854d-b7e8b12e7246.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:45', '2018-09-27 20:27:45'),
(348, 212, 129, 'Selina Halvorson', NULL, '66017c2b-1deb-3bd0-b657-f44c824ca97e.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:46', '2018-09-27 20:27:46'),
(349, 43, 178, 'Mr. Darryl Sawayn', NULL, '31250988-9329-3d29-91d5-5f4f39918a00.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:46', '2018-09-27 20:27:46'),
(350, 76, 244, 'Alene Green V', NULL, '4c15aece-22cc-3f59-be85-ca10568e968f.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:46', '2018-09-27 20:27:46'),
(351, 143, 178, 'Amari Doyle', NULL, '8fb2f9db-3e07-3d64-bcee-b0af5fd0dbb6.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:46', '2018-09-27 20:27:46'),
(352, 164, 225, 'Marlin Stamm', NULL, '2fe07e59-29af-3949-9794-8903b4475d8a.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:46', '2018-09-27 20:27:46'),
(353, 196, 211, 'Sincere Effertz', NULL, '3d222e8e-77f4-390a-8c5f-65c9ce3be8b0.png', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:46', '2018-09-27 20:27:46'),
(354, 255, 193, 'Max Mante', NULL, 'beaad283-7bb0-34fc-86a4-a4954392f1e3.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:46', '2018-09-27 20:27:46'),
(355, 115, 171, 'Prof. Norris O\'Connell', NULL, 'ad3e36ef-5332-3969-ab10-e042af476793.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:46', '2018-09-27 20:27:46'),
(356, 39, 159, 'Prof. Davin Runolfsdottir PhD', NULL, 'c2fbc7ea-2b94-3871-b9c2-b07e869d1c21.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:46', '2018-09-27 20:27:46'),
(357, 121, 124, 'Selena Lesch', NULL, '6be57acd-f722-343d-b81a-2d6d30834a28.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:46', '2018-09-27 20:27:46'),
(358, 14, 117, 'Olin Pouros', NULL, '3224d62c-29c4-3bc2-b1b0-3ef1ff5a379d.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:46', '2018-09-27 20:27:46'),
(359, 219, 250, 'Filomena Mitchell', NULL, 'f44e41f2-265e-34f3-9d70-23b44ce5df4b.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:46', '2018-09-27 20:27:46'),
(360, 51, 173, 'Dr. Noemy Pagac', NULL, '1e05fc3a-a791-31b8-bec5-3c8b61b657f4.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:46', '2018-09-27 20:27:46'),
(361, 32, 201, 'Erwin Gutmann', NULL, '75f8d8c4-d060-3ddb-acb3-181320450dd3.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:46', '2018-09-27 20:27:46'),
(362, 190, 247, 'Prof. Grant Jerde', NULL, '22a2bf26-725c-3fe7-a5e7-48be4e82f410.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:46', '2018-09-27 20:27:46'),
(363, 243, 154, 'April Mann', NULL, 'd3367eb7-f31e-397a-8c25-4aa468572951.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:46', '2018-09-27 20:27:46'),
(364, 130, 129, 'Lukas Turner', NULL, '04f1d2c2-2da9-3a9a-8d78-eaa4475f2672.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:46', '2018-09-27 20:27:46'),
(365, 42, 122, 'Elliott Hudson', NULL, '9fa4afd1-9824-3644-bc03-557f5d3e2ff2.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:47', '2018-09-27 20:27:47'),
(366, 62, 150, 'Price Schroeder', NULL, 'd1784394-c083-3f2e-91eb-6643da18b273.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:47', '2018-09-27 20:27:47'),
(367, 245, 123, 'Emanuel Waelchi', NULL, '42d004f1-b4a8-3500-b4ff-57bc0d37b142.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:47', '2018-09-27 20:27:47'),
(368, 105, 124, 'Mr. Bailey Zulauf', NULL, '0f194db9-410f-351e-b22e-ebe64f0d7415.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:47', '2018-09-27 20:27:47'),
(369, 169, 140, 'Mrs. Lois Fahey DVM', NULL, '3269586d-228b-3fcc-b51d-6b996698d9a1.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:47', '2018-09-27 20:27:47'),
(370, 140, 107, 'Eulah Koelpin', NULL, '55401275-4cfe-3f21-8d08-31d70ab3bbe2.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:47', '2018-09-27 20:27:47'),
(371, 53, 131, 'Leonard Satterfield', NULL, '2ce83066-5cf7-3941-865e-6769fee29983.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:47', '2018-09-27 20:27:47'),
(372, 167, 138, 'Trudie Littel PhD', NULL, 'b2462d16-93a7-368b-868d-e30376d2049b.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:47', '2018-09-27 20:27:47'),
(373, 46, 202, 'Shanel Murphy II', NULL, '3ba7e5f8-ebcf-36a0-80d8-82ca29c3ab39.png', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:47', '2018-09-27 20:27:47'),
(374, 186, 227, 'Molly Reynolds', NULL, 'c797472b-81d2-3fff-a38f-485372a6b551.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:47', '2018-09-27 20:27:47'),
(375, 6, 195, 'Everette Hilpert', NULL, '4b7bbc4c-2d11-3914-9daa-bd0920409803.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:47', '2018-09-27 20:27:47'),
(376, 113, 221, 'Thea Williamson', NULL, '1d93aefc-d8e3-30e5-b792-821ea5919ba7.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:47', '2018-09-27 20:27:47'),
(377, 211, 214, 'Velma Pfannerstill', NULL, '5cb492c2-3874-3f58-9b5f-ed5251f9ebdb.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:47', '2018-09-27 20:27:47'),
(378, 113, 245, 'Brando Gulgowski', NULL, 'd0c3b15e-c9a1-3852-af55-3f51e5898cc5.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:47', '2018-09-27 20:27:47'),
(379, 231, 168, 'Antwan Blick', NULL, '7baeee1a-4e59-3e9a-968e-c954726783dc.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:47', '2018-09-27 20:27:47'),
(380, 132, 253, 'Prof. Joannie Kerluke', NULL, '8f3545c3-a527-33e7-8d5d-0da5226439df.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:47', '2018-09-27 20:27:47'),
(381, 144, 114, 'Mr. Rogers Schultz DVM', NULL, '647191fc-ce6a-3a52-a65e-b4109c56e270.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:48', '2018-09-27 20:27:48'),
(382, 98, 117, 'Donnie Frami IV', NULL, 'b7b8d138-caa3-3650-add7-24916b2a64ee.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:48', '2018-09-27 20:27:48'),
(383, 254, 238, 'Mabel Satterfield IV', NULL, '751a27ae-2f73-30e5-85de-99e8ca9a7e9a.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:48', '2018-09-27 20:27:48'),
(384, 178, 121, 'Dr. Maritza Hills', NULL, '4b2bf9fc-bc94-345a-9de9-629e5f86db62.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:48', '2018-09-27 20:27:48'),
(385, 236, 127, 'Prof. Leopoldo Eichmann III', NULL, '884a9435-003d-3733-a618-0b9ad0b94851.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:48', '2018-09-27 20:27:48'),
(386, 247, 187, 'Zachary Price MD', NULL, 'cafab80c-f815-37f4-b7e9-35e3d4105637.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:48', '2018-09-27 20:27:48'),
(387, 218, 236, 'Brigitte Rutherford DDS', NULL, 'c21cba34-3c1d-3dd9-914c-82ca4121e52f.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:48', '2018-09-27 20:27:48'),
(388, 46, 185, 'Tess Schmeler', NULL, 'e7921dd9-c049-32c8-b520-145e49d3a7af.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:48', '2018-09-27 20:27:48'),
(389, 232, 206, 'Grant Von', NULL, '45d8c80b-d086-30d4-b6e2-5394fceafcbb.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:48', '2018-09-27 20:27:48'),
(390, 144, 120, 'Marge Marks', NULL, '0ca369ef-9127-3328-b118-88c29711fea0.png', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:49', '2018-09-27 20:27:49'),
(391, 253, 203, 'Owen Hettinger', NULL, 'fca88bfa-b88e-38e3-a562-091488b4f623.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:49', '2018-09-27 20:27:49'),
(392, 69, 154, 'Melba Hilpert PhD', NULL, '23c4be54-950b-307d-b424-5fb4ffea8243.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:49', '2018-09-27 20:27:49'),
(393, 137, 131, 'Maye Cassin', NULL, '066ed89c-20f5-31a2-96ae-65bc017c8632.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:49', '2018-09-27 20:27:49'),
(394, 246, 249, 'Pietro Wisozk III', NULL, '822ab1ce-119a-399e-88b5-891b6d46e86c.png', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:49', '2018-09-27 20:27:49'),
(395, 81, 150, 'Prof. Julius Swaniawski', NULL, '1a2ca2f8-d951-36d5-97d4-74b8d7f2ffb8.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:50', '2018-09-27 20:27:50'),
(396, 66, 209, 'Gabriella Ziemann', NULL, '80f1db6e-abef-3800-bd2f-05217471aced.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:51', '2018-09-27 20:27:51'),
(397, 242, 198, 'Emmanuelle Mante IV', NULL, 'cd750dbc-d3e1-3c2a-9c39-9dbe28dd2ba8.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:51', '2018-09-27 20:27:51'),
(398, 28, 223, 'Muriel Rice', NULL, '346c053d-26cb-395c-a0ea-2c92ced3a934.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:51', '2018-09-27 20:27:51'),
(399, 48, 237, 'Deangelo Johnson', NULL, 'f24d83f9-1a14-3f97-9439-471697cb22bb.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:52', '2018-09-27 20:27:52'),
(400, 63, 178, 'Prof. Brooklyn Haag', NULL, 'c0988c26-d13a-370f-a2fb-636fd59e5587.png', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:52', '2018-09-27 20:27:52'),
(401, 152, 119, 'Prof. Lowell Gleichner', NULL, 'd579affc-9817-3104-93c9-60a2d00bf9a7.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:53', '2018-09-27 20:27:53'),
(402, 171, 146, 'Lolita Kozey', NULL, 'b8bfeea1-4fb2-31ac-8672-b4bee1455438.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:53', '2018-09-27 20:27:53'),
(403, 161, 216, 'Kenny Morissette', NULL, '8117ef55-2b33-3525-8fac-547be6aca9c2.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:54', '2018-09-27 20:27:54'),
(404, 48, 144, 'Ms. Alyson Fritsch', NULL, '9df4bd95-ee1b-3569-817e-590923535e84.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:54', '2018-09-27 20:27:54'),
(405, 71, 235, 'Mr. Dillon Denesik I', NULL, 'd96ecd1e-7dd5-3dd1-9204-0cdb97697d4f.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:54', '2018-09-27 20:27:54'),
(406, 97, 107, 'Frankie Ledner', NULL, '2a875e93-455e-38e9-9448-0a7a2254501b.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:27:55', '2018-09-27 20:27:55'),
(407, 77, 160, 'Esther Bartell', NULL, '111c8307-4486-392a-b964-4c5f7c6c0632.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:56', '2018-09-27 20:27:56'),
(408, 136, 185, 'Queenie Spinka', NULL, 'ffc1d945-48d5-33b9-836c-0ea96bdcc338.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:58', '2018-09-27 20:27:58'),
(409, 236, 165, 'Cicero Wolff', NULL, '145139de-e900-38d6-8480-f6df7b0eca26.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:27:58', '2018-09-27 20:27:58'),
(410, 112, 142, 'Estell Metz', NULL, '8ca8d8b0-a34a-33a5-b450-3a5d8cc719c5.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:27:59', '2018-09-27 20:27:59'),
(411, 104, 176, 'Guy Fisher MD', NULL, 'db15c1de-dc63-3de2-81f5-d5e6f7956373.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:59', '2018-09-27 20:27:59'),
(412, 81, 209, 'Haylee Kozey', NULL, 'f96e95f8-ccb3-388d-af50-d9050ce9163e.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:27:59', '2018-09-27 20:27:59'),
(413, 249, 222, 'Mr. Merritt Ortiz', NULL, 'f7005ac7-1904-31be-a587-54d0aabd92fb.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:28:00', '2018-09-27 20:28:00'),
(414, 30, 118, 'Corine Rodriguez', NULL, 'ad2e2e69-7dbd-30ad-a95e-2ef2e90c7a64.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:28:00', '2018-09-27 20:28:00'),
(415, 140, 190, 'Percival Hayes', NULL, '593b16bf-84a5-3a9d-b416-9b49ad58c432.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:28:00', '2018-09-27 20:28:00'),
(416, 11, 139, 'Zackery Ziemann', NULL, '65d922a5-9d50-3572-9288-368f924015f8.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:28:00', '2018-09-27 20:28:00'),
(417, 239, 122, 'Mr. Eleazar Cummings DDS', NULL, '25305b9d-c7d9-3610-a37c-62ec9df9bdac.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:28:00', '2018-09-27 20:28:00'),
(418, 235, 158, 'Eryn Pouros', NULL, 'a7e4ea8c-10c9-3878-9e32-a955e03bade9.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:28:01', '2018-09-27 20:28:01'),
(419, 176, 178, 'Mr. Hunter Lindgren', NULL, '7267444e-ef4e-3bff-8473-815db9ad0c46.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:28:01', '2018-09-27 20:28:01'),
(420, 195, 131, 'Federico Fahey II', NULL, 'd913b34a-4618-38d5-a4e2-183814dbbd4b.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:28:01', '2018-09-27 20:28:01'),
(421, 95, 190, 'Ollie Balistreri', NULL, '0cc80c3f-35fd-3f95-826f-0e5f20bdfbb6.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:28:01', '2018-09-27 20:28:01'),
(422, 207, 240, 'Catharine Kihn', NULL, '708dfc5c-a616-3189-b08d-25f92567d9a7.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:28:01', '2018-09-27 20:28:01'),
(423, 228, 246, 'Lane Carter Sr.', NULL, '7eda9d72-43a3-32dc-a633-92dabc5f66f2.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:28:01', '2018-09-27 20:28:01'),
(424, 25, 126, 'Meta Bayer', NULL, '4c64e880-06cd-38e2-b82a-7e8df7764ce8.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:28:01', '2018-09-27 20:28:01'),
(425, 238, 234, 'Delpha Gutkowski', NULL, '65ec08cb-787f-352e-8497-930e10d78a3d.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:28:01', '2018-09-27 20:28:01'),
(426, 59, 209, 'Miss Bette Auer', NULL, '7fdb74f7-edbb-37f9-8574-22448fd4f115.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:28:01', '2018-09-27 20:28:01'),
(427, 132, 159, 'Deja Graham', NULL, 'be6af9f3-064c-3c06-ac39-ae9e194e3434.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:28:01', '2018-09-27 20:28:01'),
(428, 251, 214, 'Hoyt Torphy', NULL, '93585f10-ecfb-32ee-aceb-fcb930173e1c.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:28:01', '2018-09-27 20:28:01'),
(429, 53, 159, 'Miss Clemmie Dickens Jr.', NULL, '3326925f-0ffa-3176-af8d-793a8a94723c.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:28:01', '2018-09-27 20:28:01'),
(430, 82, 195, 'Mattie Flatley', NULL, 'e976a7cc-fdb9-32c0-8752-edb5717a54a4.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:28:01', '2018-09-27 20:28:01'),
(431, 225, 216, 'Sven Doyle', NULL, '34614764-8716-3584-8e53-53edbae43cb7.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:28:01', '2018-09-27 20:28:01'),
(432, 177, 132, 'Eladio Strosin', NULL, '7e863fab-8763-3a30-b9cc-8b72f22c6879.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:28:01', '2018-09-27 20:28:01'),
(433, 51, 201, 'Ivah Gulgowski IV', NULL, 'f869128d-31b5-33e1-8d3d-5d204af32c77.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:28:02', '2018-09-27 20:28:02'),
(434, 81, 121, 'Mrs. Audra Luettgen', NULL, 'f3784153-1bda-3e06-9740-211f32f082da.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:28:02', '2018-09-27 20:28:02'),
(435, 53, 167, 'Dr. Alvah Kiehn', NULL, 'b48fcdfc-8cb4-3c32-8349-e4146d1e32db.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:28:02', '2018-09-27 20:28:02'),
(436, 2, 226, 'Alexys Turcotte DVM', NULL, 'fd6997b4-c1a7-3e19-bb46-2525e59d3fd0.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:28:02', '2018-09-27 20:28:02'),
(437, 84, 162, 'Lawson Lowe', NULL, '9015c278-fb9c-3aed-88cf-abc0c6b0fee8.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:28:02', '2018-09-27 20:28:02'),
(438, 167, 212, 'Ophelia Reinger', NULL, '3fa25600-115e-3c61-841b-dd7f184547cc.png', NULL, NULL, 0, NULL, 1, '2018-09-27 20:28:02', '2018-09-27 20:28:02'),
(439, 132, 150, 'Mr. Scottie Stamm', NULL, 'c002a368-84ff-3005-8953-20c8ac609520.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:28:02', '2018-09-27 20:28:02'),
(440, 5, 230, 'Winfield Cruickshank MD', NULL, '5f58aa73-bad4-3f24-a466-4c18d79d3341.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:28:02', '2018-09-27 20:28:02'),
(441, 78, 177, 'Elizabeth Koelpin', NULL, 'dd04f636-66c6-3af8-bf41-e37e089e2f46.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:28:02', '2018-09-27 20:28:02'),
(442, 6, 159, 'Elliot Ferry', NULL, 'cac71104-74ae-3f33-81df-b0913b047904.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:28:02', '2018-09-27 20:28:02'),
(443, 247, 249, 'Prof. Virginia McDermott II', NULL, '80a11ba1-7094-3169-9e8f-2ac7a28015b8.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:28:02', '2018-09-27 20:28:02'),
(444, 8, 119, 'Randy King', NULL, 'c2fcd54c-5ac3-36ef-8ab4-04cc3c6906b9.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:28:02', '2018-09-27 20:28:02'),
(445, 245, 156, 'Miss Aletha Moore IV', NULL, '90b00e2c-9791-393c-bd62-bfe8ff6315c1.jpg', NULL, NULL, 1, NULL, 1, '2018-09-27 20:28:03', '2018-09-27 20:28:03'),
(446, 31, 137, 'Jasper Rice', NULL, 'ac6e93ce-9c7b-335f-ae11-1f1ed7601319.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:28:03', '2018-09-27 20:28:03'),
(447, 60, 1, 'Mr. Nickolas Trantow', NULL, '729a8c15-cf85-3123-881f-42def298bddd.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:28:03', '2018-09-27 20:28:03'),
(448, 88, 217, 'Prof. Eriberto Kemmer PhD', NULL, 'd8101121-45db-37a7-b205-cefc10017ade.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:28:03', '2018-09-27 20:28:03'),
(449, 239, 145, 'Kallie Wyman', NULL, '447f9066-e2e9-399f-812f-36f6e3e90fef.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:28:03', '2018-09-27 20:28:03'),
(450, 168, 165, 'Zola Grant', NULL, '08ce637a-3f44-3910-9f4a-f8aa76ed3343.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:28:03', '2018-09-27 20:28:03'),
(451, 244, 109, 'Kelvin Armstrong', NULL, 'd9b85a56-e84f-309d-9b08-b9059487d8a4.jpg', NULL, NULL, 1, NULL, 0, '2018-09-27 20:28:03', '2018-09-27 20:28:03'),
(452, 42, 106, 'Efrain Cruickshank', NULL, '6c25e8b0-cea5-3dfe-a8a6-5034bc012f33.jpg', NULL, NULL, 0, NULL, 0, '2018-09-27 20:28:03', '2018-09-27 20:28:03'),
(453, 255, 212, 'Mrs. Bernadine Volkman V', NULL, '5d6755ac-d164-37b6-bbb0-7c4a31bce0f3.jpg', NULL, NULL, 0, NULL, 1, '2018-09-27 20:28:03', '2018-09-27 20:28:03'),
(454, 240, 218, 'Sidney Volkman IV', NULL, '28d44b60-f5cb-3bde-abe4-365297edc1bf.png', NULL, NULL, 0, NULL, 1, '2018-09-27 20:28:03', '2018-09-27 20:28:03');

-- --------------------------------------------------------

--
-- Table structure for table `course_timeline`
--

CREATE TABLE IF NOT EXISTS `course_timeline` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `course_user_id` int(11) UNSIGNED NOT NULL,
  `event` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_course_timeline_course_user1_idx` (`course_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `course_user`
--

CREATE TABLE IF NOT EXISTS `course_user` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `course_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `progress` int(11) DEFAULT '0' COMMENT 'Progress of user in the course',
  `image_certificate` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Certificate for specific user',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-Inactive, 1-Active, 2-Pending, 3-Finished.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `course_usercol` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_course_user_users1_idx` (`user_id`),
  KEY `fk_course_user_courses1_idx` (`course_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `course_user`
--

INSERT INTO `course_user` (`id`, `course_id`, `user_id`, `progress`, `image_certificate`, `status`, `created_at`, `updated_at`, `course_usercol`) VALUES
(1, 3, 1, 0, NULL, 1, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `documents`
--

CREATE TABLE IF NOT EXISTS `documents` (
  `id` int(11) NOT NULL,
  `project_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL COMMENT 'User that publish the document',
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `approved` tinyint(4) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_documents_projects1_idx` (`project_id`),
  KEY `fk_documents_users1_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `evaluations`
--

CREATE TABLE IF NOT EXISTS `evaluations` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `course_id` int(11) UNSIGNED NOT NULL,
  `theme_id` int(11) UNSIGNED DEFAULT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `time` float DEFAULT '0',
  `approved_with` int(11) NOT NULL COMMENT 'Percentage necessary for mark the evaluation how approved',
  `number_questions` int(11) NOT NULL COMMENT 'Number of questions that will be have the evaluation.',
  `attempts` tinyint(4) DEFAULT '1' COMMENT 'Number of times for do the evaluation',
  `complexity` enum('low','regular','expert','pro') COLLATE utf8_unicode_ci DEFAULT 'regular',
  `type` tinyint(4) DEFAULT NULL COMMENT 'Evaluation of 1-Course, 2-Theme',
  `status` tinyint(4) DEFAULT '0' COMMENT '0-Inactive, 1-Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_evaluations_courses1_idx` (`course_id`),
  KEY `fk_evaluations_themes1_idx` (`theme_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evaluations`
--

INSERT INTO `evaluations` (`id`, `course_id`, `theme_id`, `name`, `description`, `time`, `approved_with`, `number_questions`, `attempts`, `complexity`, `type`, `status`, `created_at`, `updated_at`) VALUES
(6, 3, NULL, 'Evaluacion 100', NULL, NULL, 40, 5, NULL, NULL, 1, 0, '2018-09-24 16:24:31', '2018-09-24 17:07:41');

-- --------------------------------------------------------

--
-- Table structure for table `evaluation_user`
--

CREATE TABLE IF NOT EXISTS `evaluation_user` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `evaluation_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `score` int(11) NOT NULL DEFAULT '0',
  `time` float NOT NULL COMMENT 'Time that take to student answer the evaluation',
  `attempt_number` tinyint(4) NOT NULL DEFAULT '1',
  `approved` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-No, 1-Yes',
  `comments` text COLLATE utf8_unicode_ci COMMENT 'Have a field for ask to student how did you rate the evaluation.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_evaluation_user_evaluations1_idx` (`evaluation_id`),
  KEY `fk_evaluation_user_users1_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `evaluation_user_answers`
--

CREATE TABLE IF NOT EXISTS `evaluation_user_answers` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `answer_id` int(11) UNSIGNED NOT NULL,
  `evaluation_user_id` int(11) UNSIGNED NOT NULL,
  `question_id` int(11) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_evaluation_user_answers_evaluation_user1_idx` (`evaluation_user_id`),
  KEY `fk_evaluation_user_answers_questions1_idx` (`question_id`),
  KEY `fk_evaluation_user_answers_answers1_idx` (`answer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `experts`
--

CREATE TABLE IF NOT EXISTS `experts` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int(11) UNSIGNED NOT NULL,
  `profession` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_experts_users1_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `expert_thematic`
--

CREATE TABLE IF NOT EXISTS `expert_thematic` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `expert_id` int(11) UNSIGNED NOT NULL,
  `thematic_id` int(11) UNSIGNED NOT NULL,
  `status` tinyint(4) DEFAULT '1' COMMENT '0-Inactive, 1-Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_atc` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_expert_thematic_experts1_idx` (`expert_id`),
  KEY `fk_expert_thematic_thematics1_idx` (`thematic_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `formation_levels`
--

CREATE TABLE IF NOT EXISTS `formation_levels` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0-Inactive, 1-Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=258 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `formation_levels`
--

INSERT INTO `formation_levels` (`id`, `name`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Master', NULL, 0, NULL, '2018-09-24 16:47:10'),
(2, 'Universitario', NULL, 0, NULL, NULL),
(5, 'Master', NULL, 1, '2018-09-19 15:51:46', '2018-09-19 15:52:12'),
(6, 'No aplica', NULL, 1, '2018-09-21 22:06:07', '2018-09-24 16:47:55'),
(7, 'Test Update', NULL, 0, '2018-09-24 15:09:51', '2018-09-24 15:30:52'),
(8, 'Angel Lehner', 'Autem nemo ut iure necessitatibus dolor. Praesentium error est aut nobis modi. Earum quasi placeat voluptas necessitatibus.', 1, '2018-09-26 21:51:46', '2018-09-26 21:51:46'),
(9, 'Louisa Grady', 'Voluptatem est debitis unde itaque nihil enim aut. Aut animi aut rem eos ut fugiat magni. Exercitationem quasi consequatur et eos ut sed consectetur porro. Porro laborum qui vel.', 1, '2018-09-26 21:51:46', '2018-09-26 21:51:46'),
(10, 'Joe Hayes', 'Et enim odio nulla quibusdam hic ratione deleniti numquam. Laborum ad quisquam quae voluptatum excepturi nemo. Minus laborum esse et veniam tenetur architecto nulla repellat.', 1, '2018-09-26 21:51:46', '2018-09-26 21:51:46'),
(11, 'Travon Hills', 'Qui doloremque reiciendis velit eum unde aliquam nesciunt. Ab magni aut ipsa minus. Perspiciatis incidunt enim fugit cum. In quidem sunt sed quod accusamus quis omnis.', 0, '2018-09-26 21:51:46', '2018-09-26 21:51:46'),
(12, 'Porter Mosciski', 'Veniam sint recusandae saepe consequuntur molestias ut. Harum molestiae quia perferendis eaque vitae alias qui autem.', 0, '2018-09-26 21:51:46', '2018-09-26 21:51:46'),
(13, 'Idella Goldner', 'Odio est tempora officiis et quod. Tempora et iure ut et. Magni debitis vel dolor nisi ex. Qui iusto vitae sed et.', 0, '2018-09-26 21:51:46', '2018-09-26 21:51:46'),
(14, 'Prof. Moshe Predovic II', 'Ut quidem non et placeat quas. Corporis omnis consequatur consequatur vel quam totam est. Quia quae iste sit asperiores deserunt. Atque officia quas autem nemo autem.', 1, '2018-09-26 21:51:46', '2018-09-26 21:51:46'),
(15, 'Mr. Marley Koepp', 'Minima autem consequuntur et quo sunt in. Minima est laboriosam inventore quam. Sunt minus consectetur rerum incidunt. Soluta cupiditate veritatis minima nulla.', 1, '2018-09-26 21:51:46', '2018-09-26 21:51:46'),
(16, 'Mary Crona', 'Quisquam corrupti molestias eos est occaecati vel et. Perferendis cumque rerum reprehenderit molestiae. Animi aut quidem sunt harum reprehenderit. Tempora quam expedita nisi odio aliquam.', 0, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(17, 'Mikayla Kertzmann', 'Nostrum rerum accusamus voluptas minima tempora velit enim ab. Quidem quis sit dolor delectus. Est qui quo modi doloremque quae quo. Minima est numquam autem iure consequatur.', 1, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(18, 'Judy Schamberger I', 'Ducimus est expedita iste soluta consequatur cumque nulla debitis. Eum quia animi omnis non sint. Aut fuga cumque perspiciatis qui. Incidunt atque quisquam ea vitae a.', 0, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(19, 'Brody Gutmann', 'Quae culpa perferendis consequatur eum molestiae. Qui itaque dolorem dolorem quia voluptate quia. Minima magnam quis inventore non quaerat et. Aut praesentium quo atque autem sint inventore.', 0, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(20, 'Nils Ullrich', 'Ducimus et veniam eius aspernatur veritatis corrupti. Fuga beatae adipisci velit consequatur. Architecto alias temporibus sed deserunt quis.', 0, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(21, 'Dr. Zachery Feeney DDS', 'Possimus eius eos est eveniet facere. Perferendis odio sapiente nobis non. Expedita veniam quos atque praesentium quis officiis. Hic dolorum cupiditate sint quia quas qui.', 1, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(22, 'Kaylin Muller', 'Est omnis occaecati dolores omnis et quasi placeat similique. Repellendus et quis voluptatem similique. Error est non consequuntur est aut possimus illo. Et et vel laudantium quisquam quia quod.', 1, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(23, 'Brennon Jenkins Jr.', 'Cumque est qui iusto aut accusantium ea. At hic animi corrupti non qui sint sunt. Amet sunt quia voluptas quisquam sed rerum aut.', 0, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(24, 'Ms. Leola Grimes', 'Quaerat eveniet est placeat at ut. Nulla ipsum corrupti asperiores. Nobis minima necessitatibus a qui eveniet provident et.', 0, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(25, 'Lizzie Pfannerstill', 'Quae excepturi quas asperiores et commodi sit. Numquam sed omnis animi veniam autem neque. Quis dicta sed totam laborum.', 0, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(26, 'Rico Simonis', 'Porro beatae praesentium fugiat asperiores aut. Dolor eos recusandae debitis fuga. Qui rerum fuga assumenda repudiandae. Voluptatem et est fuga repellat nihil est nesciunt.', 0, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(27, 'Test', 'lorem inpum', 0, '2018-09-26 21:51:47', '2018-09-26 22:00:00'),
(28, 'Jayson McClure II', 'Ab et quis cupiditate voluptatem. Omnis nisi eum temporibus hic recusandae iure dolor. Iste non voluptas reprehenderit suscipit. Rerum natus ipsum mollitia et sunt temporibus.', 0, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(29, 'Prof. Sylvan Cremin Sr.', 'Est nostrum consequatur accusantium dolor. Deleniti ea voluptatem aut rem. Nemo sunt enim ea. Ullam architecto quis expedita omnis laborum.', 0, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(30, 'Mrs. Karelle Ratke', 'Ab et eveniet aut suscipit rem. Qui corrupti libero reprehenderit aut. Dolor minus distinctio a deleniti fuga.', 0, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(31, 'Juanita Armstrong', 'Maxime distinctio temporibus dolorum sit. Velit similique et repudiandae porro labore dicta. Voluptatum soluta voluptatem esse praesentium possimus deleniti nulla.', 1, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(32, 'Dr. Emilie Mosciski', 'Autem in labore et quam qui qui enim. Omnis amet saepe dolor amet animi et assumenda tempore. Quisquam perferendis aut minima. Tenetur ut aut iure iure modi vel.', 0, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(33, 'Carleton Gutkowski', 'Et sit possimus in magnam. Neque quo nihil error esse. Eum quia quia temporibus voluptatibus molestiae. Sit itaque corrupti tempore qui possimus quae laudantium. Architecto aut quia est optio.', 1, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(34, 'Dr. Zoe Farrell I', 'Ipsa temporibus occaecati ad sit laboriosam totam itaque quam. Qui illum ex amet voluptas ea veniam odio. Temporibus voluptatem modi cum quos nihil dicta iusto explicabo. Aut quas vel et.', 0, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(35, 'Mrs. Bernice Walsh Jr.', 'Omnis rem consequatur veritatis assumenda. Iusto ab soluta aliquid omnis enim adipisci autem. Explicabo harum iure aut omnis sed. Dolorem cupiditate quo placeat nostrum et magni aperiam.', 1, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(36, 'Hettie Anderson', 'Delectus est aut placeat adipisci. Ut eligendi deleniti eos dolores recusandae amet. Aperiam unde nostrum voluptates odio est ullam quisquam. Magnam dolores quisquam quod et hic.', 1, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(37, 'Drew Kassulke', 'Deserunt harum sint voluptatem perferendis. Animi facere ea at eaque beatae sint. Itaque voluptatibus dolor veniam velit eligendi.', 0, '2018-09-26 21:51:47', '2018-09-26 21:51:47'),
(38, 'Rory Bogan', 'Earum perspiciatis quas dolor et accusamus. Ut sunt voluptatum optio quasi est.', 0, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(39, 'Theron Considine', 'Qui vitae molestiae repudiandae. Aut reprehenderit et veritatis. Eos sint aut aut incidunt quas. Eligendi esse soluta sint esse et odit.', 0, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(40, 'Jeromy Kuvalis', 'Vero iusto voluptatem architecto necessitatibus. Et qui autem veritatis consectetur ut saepe magni. Velit iste dolor ratione quo deserunt.', 1, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(41, 'Alexandria Hegmann', 'Repellat porro eligendi dolores perferendis debitis. Iste saepe ipsa earum libero. Quia vel facere doloremque iste est.', 0, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(42, 'Cleveland Gibson', 'Esse in aut dolorem voluptas tenetur ut quos voluptas. Enim explicabo necessitatibus doloremque omnis hic aut blanditiis. Fugiat ratione provident sed et et.', 1, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(43, 'Ms. Princess Beatty', 'Quis dolorem numquam molestias. Optio eligendi qui eum ut. Aut et iure porro aut.', 1, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(44, 'Leola Brown', 'Accusantium sed exercitationem nobis officiis cum. Dolorum et numquam est et dolore reprehenderit deserunt.', 0, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(45, 'Adrienne Heaney', 'Enim ullam laboriosam magnam repudiandae. Suscipit voluptas beatae perferendis nihil totam commodi eos. Ut explicabo omnis tempore amet. Aliquam cum aut ipsa in. Veniam et neque et animi modi id qui.', 0, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(46, 'Helmer Larkin', 'Rerum veritatis nihil facere culpa hic. Suscipit laboriosam alias consequatur. Ea similique quam doloremque ab sit. Hic eligendi et expedita neque.', 0, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(47, 'Adolfo Crona', 'Dignissimos quia dolorum quia ab vel. Delectus id et aut aliquid quo. Perferendis laboriosam possimus nihil sequi libero. Error sit in aperiam quidem.', 0, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(48, 'Mr. Thomas Murphy I', 'Autem quisquam tempore eaque et. Consectetur nihil dolores commodi. Tempore voluptate amet voluptatem aut placeat recusandae. Ullam eos aut aut molestiae enim aliquid.', 1, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(49, 'Prof. Morgan King DDS', 'Rerum voluptatem et sit vero corrupti. Tempora numquam quia placeat nihil excepturi sed praesentium.', 1, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(50, 'Frida Keebler', 'Maxime velit quia laboriosam quo. Ut consequuntur quo consequatur voluptatem accusamus sunt.', 0, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(51, 'Cali Fahey', 'Laborum praesentium neque ipsam vel repellendus iure dolorem. Veniam debitis qui aspernatur praesentium distinctio ipsam cumque itaque. Delectus exercitationem quam eos.', 0, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(52, 'Prof. Brent White III', 'Et in sapiente error delectus. Quia voluptatem ut explicabo corrupti voluptate. Repellat voluptas quas ratione mollitia nulla magnam in. Suscipit perferendis et atque exercitationem ullam est.', 0, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(53, 'Randi Thompson', 'Ipsa beatae tempora laudantium aut officia. Veritatis vitae iure voluptas sit quis aut nam. Est et ipsa sit asperiores et quia provident. In excepturi animi animi qui magnam molestiae cum.', 1, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(54, 'Shanie Gibson IV', 'Voluptate minima ut consequatur fuga. Architecto harum dolorem facilis qui. Qui totam eos sit nesciunt qui molestiae. A ad sed vitae id est architecto impedit autem.', 0, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(55, 'Frederique Bergnaum', 'Maiores in omnis eos omnis explicabo facilis quo aperiam. Et ipsa pariatur molestiae atque cum esse. Saepe quia laborum enim quos. A et quo perspiciatis nemo.', 0, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(56, 'Prof. Otho Fritsch', 'Quis itaque saepe eaque consequatur. Nobis odio distinctio consequatur harum. Excepturi omnis ut consectetur dolorem sed tempore numquam. Maxime eos molestiae sit saepe.', 0, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(57, 'Fernando Kemmer I', 'Voluptate impedit accusamus omnis non est fuga molestiae. Maiores temporibus qui dolore. Sed voluptate sapiente illo eius quam asperiores. Libero atque vel ipsum.', 1, '2018-09-26 21:51:48', '2018-09-26 21:51:48'),
(58, 'Darren Hettinger', 'Soluta cupiditate vel debitis facilis est voluptatem. Consequatur rerum in incidunt quaerat delectus aut. Nesciunt officiis omnis dolores.', 1, '2018-09-27 19:48:48', '2018-09-27 19:48:48'),
(59, 'Queen Frami', 'Alias non qui non omnis rerum numquam et. Nihil aut at illo magni. Ut quia odio perferendis quia et atque natus. Voluptatem iure qui quis eum nobis. Animi quidem ut reiciendis eos et et fugiat.', 0, '2018-09-27 19:48:48', '2018-09-27 19:48:48'),
(60, 'Melvina Schamberger', 'Qui nam quos qui blanditiis. Fugit et nisi quia necessitatibus sunt consectetur cupiditate. Recusandae sit doloremque ea nihil. At sint est inventore ut.', 0, '2018-09-27 19:48:48', '2018-09-27 19:48:48'),
(61, 'Ms. Reyna Medhurst', 'Enim neque aut eius sunt omnis. Beatae blanditiis dolor quos amet dolor architecto est. Placeat impedit aut inventore id. Est vel porro officia harum libero nihil molestiae perspiciatis.', 1, '2018-09-27 19:48:48', '2018-09-27 19:48:48'),
(62, 'Amiya Nitzsche', 'Repellendus in tenetur ut voluptatibus dolores. Earum ratione exercitationem placeat explicabo voluptas aut.', 1, '2018-09-27 19:48:48', '2018-09-27 19:48:48'),
(63, 'Megane Wilkinson', 'Ea id iste vel doloremque alias rerum voluptatibus occaecati. Possimus dolores harum nihil nostrum ipsum dolore nisi. Libero at aut odit voluptate doloremque odit sequi.', 1, '2018-09-27 19:48:48', '2018-09-27 19:48:48'),
(64, 'Nicholas Rosenbaum', 'Maxime cumque aliquid cupiditate. Dolores eius corporis sapiente voluptatum. Commodi culpa commodi sapiente modi perspiciatis et rerum.', 0, '2018-09-27 19:48:48', '2018-09-27 19:48:48'),
(65, 'Daren Senger', 'Rerum rerum quod minus est sapiente facere aperiam. Eius vero ipsam voluptatem ducimus beatae aut provident saepe. Illo dolor et sed optio vero.', 0, '2018-09-27 19:48:48', '2018-09-27 19:48:48'),
(66, 'Miss Mariela Sporer', 'Ipsam aut et voluptatem et qui. Et voluptates voluptatem velit consequatur recusandae ut. Voluptates sit reprehenderit non et voluptatem aperiam. In sunt similique ut ut culpa quo.', 0, '2018-09-27 19:48:49', '2018-09-27 19:48:49'),
(67, 'Tre Haley', 'Fugiat quia pariatur eum repudiandae cupiditate. Maiores numquam quo sed rem. Et necessitatibus assumenda et et dolor itaque autem. Omnis aut ex est incidunt odit accusamus corporis est.', 1, '2018-09-27 19:48:49', '2018-09-27 19:48:49'),
(68, 'Jazmyn Ullrich Jr.', 'Ut et optio adipisci commodi. Incidunt dolores commodi quia. Esse non modi et vero amet aut facilis. Est beatae eos a quos quidem sit.', 0, '2018-09-27 19:48:49', '2018-09-27 19:48:49'),
(69, 'Mrs. Florence Koepp IV', 'Possimus et doloribus incidunt. Veritatis saepe illo facere sequi consectetur quod. Perspiciatis sed quis et et. Ex et magni nisi.', 0, '2018-09-27 19:48:49', '2018-09-27 19:48:49'),
(70, 'Dr. Griffin Zemlak II', 'Qui quia itaque sapiente atque et reiciendis mollitia. Officiis sit quasi enim perspiciatis cumque occaecati velit earum. Ea non aspernatur autem quo iusto. Corrupti rerum quia sed eius.', 1, '2018-09-27 19:48:49', '2018-09-27 19:48:49'),
(71, 'Prof. Malvina Krajcik', 'Nesciunt quod dolores suscipit adipisci. Quia repellendus neque quia sit voluptas. Voluptatem voluptates suscipit atque qui placeat eveniet sed.', 1, '2018-09-27 19:48:49', '2018-09-27 19:48:49'),
(72, 'Clementine Koepp', 'Aut tempore aperiam nam saepe. Laboriosam quod eius sunt ipsum non et. Blanditiis iure suscipit ullam dolores hic inventore quis.', 1, '2018-09-27 19:48:49', '2018-09-27 19:48:49'),
(73, 'Kenyon Murray', 'Sit ipsam perspiciatis veritatis. Perspiciatis dolor eos dolor facere voluptatum. Sed id aut suscipit eum autem quia.', 0, '2018-09-27 19:48:49', '2018-09-27 19:48:49'),
(74, 'Rene Lueilwitz', 'Et quia nam harum ut quae. Et et fugit est voluptatem in consequatur. Tenetur ipsum temporibus et quos tempora ut enim.', 1, '2018-09-27 19:48:49', '2018-09-27 19:48:49'),
(75, 'Dr. Pierce Bradtke', 'Ea perspiciatis recusandae id. Architecto consequuntur magnam vel voluptatem et. Laudantium incidunt mollitia fugiat ipsam harum et alias. Est est consequatur aliquam est.', 1, '2018-09-27 19:48:49', '2018-09-27 19:48:49'),
(76, 'Marcus Fay', 'Rem enim enim est itaque corrupti. Et rerum deleniti qui adipisci soluta velit placeat.', 0, '2018-09-27 19:48:49', '2018-09-27 19:48:49'),
(77, 'Prof. Tremayne Lockman', 'Est debitis est non nobis. Tempore aspernatur consequatur veritatis qui blanditiis. Eum quisquam excepturi quisquam est harum. Sint quo molestiae iste. Non id asperiores deleniti rerum omnis magnam.', 1, '2018-09-27 19:48:49', '2018-09-27 19:48:49'),
(78, 'Ashlee Rohan', 'Ullam aut commodi et autem qui voluptatum ut. Dolor in sint in ex dignissimos. Maiores atque dolorum dolores ut. Vero molestias eos consequatur dolores et.', 0, '2018-09-27 19:48:49', '2018-09-27 19:48:49'),
(79, 'Prof. Maeve Stark IV', 'Voluptas beatae voluptatem ut ea necessitatibus aliquid. Maxime qui corporis ad non. Vel voluptatem aut architecto eius molestias tenetur veniam.', 1, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(80, 'Linnea Schinner', 'Quam et rem qui aut. Qui fuga mollitia qui enim fugit. Et minima expedita quia enim.', 0, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(81, 'Nelle Lebsack', 'Quia corporis exercitationem rerum autem dolorem magni error. Ex ipsam nihil voluptatum recusandae. Praesentium molestias saepe consectetur eos quia culpa.', 0, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(82, 'Mrs. Rosemarie Wisoky DDS', 'Quo earum et enim labore modi quaerat perferendis ut. Voluptatem repellendus voluptatum et quos quasi. Ea earum non ut atque atque placeat.', 0, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(83, 'Otho Simonis', 'Est recusandae unde nihil fugit magni. Quidem asperiores et quam repudiandae facilis eius qui autem. Quisquam aut atque vel molestiae porro ducimus sed.', 0, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(84, 'Garrison Kozey', 'Harum quae doloremque repellat qui. A repellendus laboriosam impedit est. Est itaque explicabo enim beatae id. Beatae occaecati quia illo fugit.', 0, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(85, 'Eleanore Russel', 'Fugit ab culpa quae dignissimos. Assumenda mollitia dolorem aut et eius.', 1, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(86, 'Onie Walter', 'Et illum rem doloribus. Recusandae in et dolores aliquam consequatur impedit odit. Consequatur quasi officia eligendi natus voluptas. Dolor voluptates nulla voluptate ex veniam est a autem.', 1, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(87, 'Cristian Mayert', 'Itaque voluptatem saepe iusto ab non. Et quo omnis laborum. Et ullam ut necessitatibus. Est porro quia temporibus eum. Ducimus molestiae possimus dignissimos earum nam consequatur molestiae.', 1, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(88, 'Dr. Camron Wiza MD', 'Voluptatem omnis quo veniam modi odit est. Velit et nostrum placeat. Sint qui explicabo omnis autem aut error atque.', 0, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(89, 'Gerson Bogan', 'Natus magni sed quia optio saepe. Incidunt ut et pariatur recusandae velit quasi ut. Maiores aut et eius sit itaque enim. Magni distinctio beatae perspiciatis quia necessitatibus est magni.', 1, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(90, 'Dr. Jimmy Rosenbaum', 'Atque occaecati ratione omnis et. Sed non et qui et mollitia in rerum. Quis et quasi fugit molestiae sed qui laborum et.', 0, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(91, 'Peyton Olson', 'Et dolor ratione ad id rerum suscipit. Inventore accusantium explicabo et cupiditate rem.', 1, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(92, 'Vaughn Macejkovic', 'Officia voluptatem aspernatur maxime ullam. Consequatur saepe iure est sint nihil ratione. Qui eaque quo aut est.', 1, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(93, 'Rylee Hand', 'Aut eaque enim atque optio. Sint explicabo amet sed eligendi eveniet doloribus. Vitae repellat rerum unde molestiae deserunt quia.', 1, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(94, 'Aliza Raynor', 'Quod sunt et soluta numquam. Porro voluptatem sequi ipsum ex soluta quia. Iure aut quis occaecati esse odit. Modi qui aut voluptate est qui et voluptates. Non fuga cupiditate exercitationem nam quia.', 0, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(95, 'Danny Donnelly Jr.', 'Voluptatem reprehenderit rerum laboriosam ipsa quia qui. Cupiditate ut sunt nostrum reprehenderit. Rem et modi est id.', 0, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(96, 'Tanya Schoen PhD', 'Et et molestiae consequatur sunt tenetur placeat molestiae. Laborum nulla id ut. Eum quia ut sed dolorum debitis. Eum earum omnis animi impedit porro autem.', 1, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(97, 'Prof. Donavon Prosacco', 'Sit perferendis aut est impedit sit in et. Magni fugiat vel molestias facilis vitae aut et amet. Veniam laborum aspernatur odit est eos. Dolor qui rem exercitationem animi.', 0, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(98, 'Dr. Nicholas Corkery', 'Dolor quasi vel numquam reiciendis omnis nobis. Magni mollitia autem alias molestias dolor architecto laboriosam impedit. Nostrum aut facere praesentium quod suscipit.', 1, '2018-09-27 19:48:50', '2018-09-27 19:48:50'),
(99, 'Alf Bernier', 'Repellat enim voluptatem aperiam natus illo voluptas quo. Dolorem illum voluptatem accusamus. Laboriosam quam dolorem consequatur est. Officiis sapiente animi quo qui soluta illo.', 1, '2018-09-27 19:48:51', '2018-09-27 19:48:51'),
(100, 'Prof. Dane Lynch IV', 'Vero quidem asperiores eum nobis. Hic quod in quibusdam dolorum.', 0, '2018-09-27 19:48:51', '2018-09-27 19:48:51'),
(101, 'Mrs. Verona Crona', 'Sequi suscipit quia sed sint nemo quo labore. Id et et unde voluptatem perferendis omnis rerum. Voluptatem vel veniam illum repellendus qui. Minus earum et ad quia.', 1, '2018-09-27 19:48:51', '2018-09-27 19:48:51'),
(102, 'Meda Reichert', 'Dolore hic accusantium tempora placeat corporis qui unde porro. Fuga ab aliquid impedit. Rerum velit voluptatem dolores non. Voluptatum reprehenderit nostrum consequatur iure hic.', 0, '2018-09-27 19:48:51', '2018-09-27 19:48:51'),
(103, 'Prof. Jayce Grant IV', 'Quo quia est impedit modi incidunt vitae illo. Rerum rerum impedit placeat. Rerum velit fugiat suscipit officia ut non in.', 1, '2018-09-27 19:48:51', '2018-09-27 19:48:51'),
(104, 'Mckayla Stroman DVM', 'Et aut ut ut animi veniam maxime magni. Ipsam sit rerum quod maxime qui. Velit eius fuga placeat numquam accusamus qui. Corporis sint iure nihil iure dicta.', 0, '2018-09-27 19:48:51', '2018-09-27 19:48:51'),
(105, 'Petra Torp', 'Voluptatum rerum reiciendis consequatur omnis. Voluptate et odio eligendi impedit.', 1, '2018-09-27 19:48:51', '2018-09-27 19:48:51'),
(106, 'Douglas Aufderhar', 'Beatae voluptatem qui laborum deserunt et. Asperiores et nam qui placeat quibusdam. Est fugit voluptatibus iure reprehenderit.', 0, '2018-09-27 19:48:51', '2018-09-27 19:48:51'),
(107, 'Werner Collier', 'Amet iure reiciendis et voluptatibus. Magnam aut reprehenderit aut. Tempore quia culpa asperiores sit. Rerum doloremque et tenetur.', 1, '2018-09-27 19:48:51', '2018-09-27 19:48:51'),
(108, 'Miss Jenifer Orn', 'Quia sint blanditiis nam asperiores nisi quo sed consequatur. Qui optio dolores quia dolores. Atque enim recusandae autem repellat sed et.', 0, '2018-09-27 19:49:10', '2018-09-27 19:49:10'),
(109, 'Lelah Weissnat', 'Non velit est esse rerum. In quos excepturi et odit doloremque cupiditate. Omnis magnam laboriosam minima voluptatem laborum. Incidunt et temporibus consequuntur odio.', 0, '2018-09-27 19:49:10', '2018-09-27 19:49:10'),
(110, 'Marcelle Schultz DDS', 'Neque nesciunt vel quasi rem suscipit pariatur. Aut quia similique quae vitae. Voluptatibus eligendi aut molestiae aut quam quia.', 1, '2018-09-27 19:49:10', '2018-09-27 19:49:10'),
(111, 'Mr. Ricardo Cartwright I', 'Natus praesentium sint quidem neque aperiam est. Et vitae aut ipsum unde. Et et facilis enim et illum excepturi.', 1, '2018-09-27 19:49:10', '2018-09-27 19:49:10'),
(112, 'Stone Hartmann', 'Id et illo alias occaecati blanditiis architecto. Ratione iure beatae quasi fugit quia et assumenda.', 0, '2018-09-27 19:49:10', '2018-09-27 19:49:10'),
(113, 'Buster Fahey', 'Placeat consectetur maxime maiores odio voluptatem beatae dolorem rerum. At accusamus quia molestiae fugit enim iste. Expedita eaque dolor reprehenderit sed repudiandae quisquam totam.', 1, '2018-09-27 19:49:10', '2018-09-27 19:49:10'),
(114, 'Chaim Bogisich MD', 'Impedit et eum harum doloribus. Fugiat sunt in amet alias et est libero. Officia necessitatibus eius et veritatis.', 0, '2018-09-27 19:49:10', '2018-09-27 19:49:10'),
(115, 'Miss Cassie Cole PhD', 'Et eaque illum dolor consequatur nihil voluptatem. Qui optio modi dicta asperiores voluptate. Excepturi velit optio debitis omnis voluptatem eos.', 1, '2018-09-27 19:49:10', '2018-09-27 19:49:10'),
(116, 'Mr. Garret Schmeler V', 'Ea dolores dolorem asperiores. Amet quasi minus recusandae quis. Possimus similique totam voluptas et. Dolorem harum labore nisi asperiores est.', 0, '2018-09-27 19:49:10', '2018-09-27 19:49:10'),
(117, 'Webster Shanahan', 'Officiis consequuntur libero dolores vitae. Voluptas fugit et laboriosam quos vel. Natus distinctio numquam consectetur pariatur.', 0, '2018-09-27 19:49:10', '2018-09-27 19:49:10'),
(118, 'Cierra Osinski', 'Quas eius a dolores quis earum illo. Perferendis beatae occaecati accusantium a error. Id optio necessitatibus magni qui vitae voluptatum facilis.', 0, '2018-09-27 19:49:10', '2018-09-27 19:49:10'),
(119, 'Mariah Wiegand', 'Sed aut qui nihil nisi rerum deleniti qui. Quia perspiciatis sit ab cupiditate reiciendis modi sed. Ea non aspernatur dolor est quisquam vitae.', 1, '2018-09-27 19:49:10', '2018-09-27 19:49:10'),
(120, 'Leanna Sipes', 'Culpa qui quia cumque repellat maiores. Ex velit architecto quasi dolor. Deleniti aliquid molestias ea laudantium qui et explicabo.', 1, '2018-09-27 19:49:11', '2018-09-27 19:49:11'),
(121, 'Omer Koch', 'Est et autem dolores eveniet et ut ipsa. Officiis et odio nesciunt ex qui. Accusamus eius ut itaque itaque assumenda ipsa quia. Occaecati sit quidem iusto modi dolorem.', 1, '2018-09-27 19:49:11', '2018-09-27 19:49:11'),
(122, 'Prof. Mac Kohler', 'Iure ut laudantium omnis officiis accusantium id cumque. Ipsa voluptatum minus libero fugiat. Maxime est nihil exercitationem veniam.', 0, '2018-09-27 19:49:11', '2018-09-27 19:49:11'),
(123, 'Lolita Torp', 'Iusto repellat maxime impedit quae sed sit illo. Inventore sint eos delectus officia est doloremque quo. Enim perspiciatis nulla quo repellat inventore error minima aliquid.', 0, '2018-09-27 19:49:11', '2018-09-27 19:49:11'),
(124, 'Dr. Colin Pacocha Jr.', 'Voluptates eos odit cupiditate. Numquam sequi modi earum. In in et debitis adipisci. Dolorem quis distinctio quia numquam dolor beatae rerum.', 0, '2018-09-27 19:49:12', '2018-09-27 19:49:12'),
(125, 'Miss Maye Wyman', 'Ut aut blanditiis iste incidunt cupiditate velit non. Asperiores similique similique accusamus. Voluptatibus beatae est voluptas quod harum laudantium qui quo. Non in est vitae et.', 1, '2018-09-27 19:49:12', '2018-09-27 19:49:12'),
(126, 'Dedrick Bahringer', 'Soluta doloremque harum sint voluptas tenetur explicabo. Ab praesentium est non sit. Consequatur consequatur error nam recusandae ullam optio at. Delectus sapiente corporis ut debitis animi.', 1, '2018-09-27 19:49:12', '2018-09-27 19:49:12'),
(127, 'Erich Schneider', 'Excepturi quo nobis vel et molestias architecto voluptatem. Beatae dolorem iure rem sit ex rerum ipsam. Saepe inventore similique dolor nobis nihil.', 1, '2018-09-27 19:49:13', '2018-09-27 19:49:13'),
(128, 'Miss Beryl Roob', 'Voluptates est reprehenderit unde harum eos sequi. Rem mollitia reiciendis dolorem est adipisci enim. Voluptate in reiciendis atque beatae dolorum qui.', 1, '2018-09-27 19:49:13', '2018-09-27 19:49:13'),
(129, 'Dr. Lindsey Osinski', 'Perferendis possimus ratione eligendi voluptatem laudantium fugiat. Voluptas vel minima dolores eligendi ad est corrupti. Veniam et est cupiditate adipisci nihil laborum.', 1, '2018-09-27 19:49:13', '2018-09-27 19:49:13'),
(130, 'Prof. Mitchell Fadel', 'Vel quia praesentium iure minus velit eos excepturi. Odit voluptas explicabo repellat facilis.', 0, '2018-09-27 19:49:13', '2018-09-27 19:49:13'),
(131, 'Grady Von', 'Quia laboriosam quia est minima. Corporis necessitatibus consectetur possimus voluptatem ullam mollitia. Blanditiis et nemo fugiat illo sint aut illo. Quo vitae dolorem eos sapiente est.', 1, '2018-09-27 19:49:13', '2018-09-27 19:49:13'),
(132, 'Beth Bahringer PhD', 'Provident aut architecto dicta dignissimos. Quo aut maxime assumenda. Dolores rerum quia nostrum incidunt. Laboriosam quo animi amet sit.', 1, '2018-09-27 19:49:14', '2018-09-27 19:49:14'),
(133, 'Ibrahim Gaylord DDS', 'Nihil doloremque quam cupiditate at eligendi eaque. Magnam et sit aut autem et qui.', 0, '2018-09-27 19:49:14', '2018-09-27 19:49:14'),
(134, 'Ms. Cierra Hettinger', 'Qui recusandae aut quod inventore repellat rerum. Quo quisquam maxime assumenda natus laboriosam ut. Et odio sint omnis et repudiandae vero. Et voluptatem deleniti consequatur accusamus veritatis.', 0, '2018-09-27 19:49:14', '2018-09-27 19:49:14'),
(135, 'German Wuckert', 'Modi laborum aperiam culpa fuga ut. Enim possimus et accusantium commodi. Aut facere numquam sapiente aut nihil quas. Architecto veniam qui tenetur eum cupiditate omnis.', 0, '2018-09-27 19:49:14', '2018-09-27 19:49:14'),
(136, 'Norberto Harber', 'Minima nihil laboriosam libero exercitationem. Quas harum deserunt molestiae laborum ex tempore. Eum consequatur itaque ullam ut.', 1, '2018-09-27 19:49:14', '2018-09-27 19:49:14'),
(137, 'Dr. David D\'Amore', 'Illo sunt autem eos molestiae. Sunt possimus unde et natus. In sapiente sapiente consequatur qui impedit.', 1, '2018-09-27 19:49:14', '2018-09-27 19:49:14'),
(138, 'Mr. Ubaldo Metz PhD', 'Alias consequatur vel excepturi qui. A quia nulla est possimus deserunt rerum. Dolorum neque eligendi iste.', 0, '2018-09-27 19:49:14', '2018-09-27 19:49:14'),
(139, 'Johnnie Langosh', 'Ipsum autem in eveniet nemo et. Beatae reprehenderit vitae et ut pariatur magni. Suscipit necessitatibus molestiae molestiae consequuntur corporis dolor omnis. Dolores occaecati nulla ab nobis.', 0, '2018-09-27 19:49:14', '2018-09-27 19:49:14'),
(140, 'Zaria Kertzmann', 'Ut culpa officiis est voluptas non. Sapiente maiores id perferendis temporibus tempore reiciendis asperiores. Aut aliquid recusandae ipsum quia quis. Laborum id quis culpa vel.', 1, '2018-09-27 19:49:14', '2018-09-27 19:49:14'),
(141, 'Oliver Strosin', 'Illum debitis dolor adipisci nisi quod. Aspernatur voluptatum dolores perspiciatis sed. Quo non et ratione voluptate velit debitis sint. Quaerat non id quia quod maxime reprehenderit.', 0, '2018-09-27 19:49:14', '2018-09-27 19:49:14'),
(142, 'Mr. Camryn Gutkowski', 'Saepe voluptas consequatur voluptatem ipsum voluptatibus. Et delectus nobis molestias quibusdam ut quibusdam laudantium quaerat. Totam pariatur et voluptatem itaque velit.', 0, '2018-09-27 19:49:15', '2018-09-27 19:49:15'),
(143, 'Josh Donnelly', 'Aut fugit magnam temporibus veritatis. Eaque provident dicta asperiores reiciendis delectus quia. Placeat doloremque dolorem reiciendis non.', 0, '2018-09-27 19:49:15', '2018-09-27 19:49:15'),
(144, 'Justus Leuschke', 'Laborum et assumenda ratione. Et eveniet dolores aspernatur.', 1, '2018-09-27 19:49:15', '2018-09-27 19:49:15'),
(145, 'Ms. Dorothy Bernier', 'Repudiandae facere architecto doloremque dolorem voluptas ipsam autem. Dicta nihil eius eos qui saepe est maiores. Perspiciatis aliquam omnis aut dicta necessitatibus.', 0, '2018-09-27 19:49:15', '2018-09-27 19:49:15'),
(146, 'Ms. Dortha Conroy III', 'Maxime delectus optio possimus atque distinctio non. Quisquam amet et distinctio et magni. Aut mollitia minus adipisci id. Recusandae itaque fugit quaerat perferendis non sunt quia possimus.', 0, '2018-09-27 19:49:15', '2018-09-27 19:49:15'),
(147, 'Cedrick Schoen', 'Quidem ea minima expedita quas quis. Officiis quos natus quas sit ad. Voluptatum dolor eum velit rerum consectetur. Dolorem eligendi modi nulla corrupti at at eaque.', 0, '2018-09-27 19:49:15', '2018-09-27 19:49:15'),
(148, 'Gaetano Konopelski II', 'Non assumenda consequatur aliquam assumenda. Dicta dolore facere est sunt. Excepturi animi porro officiis itaque dolor alias. Architecto facere qui quia eos.', 0, '2018-09-27 19:49:15', '2018-09-27 19:49:15'),
(149, 'Joel Kuhn', 'Quia quia error ut maiores necessitatibus doloribus mollitia. Totam officiis nobis perspiciatis esse ut. Repellat incidunt enim nostrum est molestias dignissimos quibusdam.', 0, '2018-09-27 19:49:15', '2018-09-27 19:49:15'),
(150, 'Declan Lubowitz', 'Odit soluta id mollitia tenetur soluta quis. Similique molestiae omnis cum ut exercitationem ex. Rerum cum inventore sed voluptas ex corrupti. Reprehenderit enim enim quod et temporibus et.', 0, '2018-09-27 19:49:15', '2018-09-27 19:49:15'),
(151, 'Maye Schoen', 'Eligendi officia et in dolore odit. Aut quasi vel nesciunt et. Consequatur consequatur itaque natus dolorum molestiae. Est totam qui et earum numquam aut soluta voluptatem.', 0, '2018-09-27 19:49:15', '2018-09-27 19:49:15'),
(152, 'Simone Robel', 'Dolorem quibusdam laudantium eum aspernatur. Voluptas eos veritatis vero debitis. Dicta ipsa eos dolor nulla. Aut sequi dolorem perferendis temporibus quia expedita.', 1, '2018-09-27 19:49:16', '2018-09-27 19:49:16'),
(153, 'Jeffry Hegmann', 'Ea veniam natus nesciunt non facere quia quae. Dolorem ratione eveniet provident ut incidunt voluptatem voluptatibus. Id iste corporis aut consequatur quasi possimus saepe.', 0, '2018-09-27 19:49:16', '2018-09-27 19:49:16'),
(154, 'Erika Ratke', 'Tempora beatae sit voluptas odio in harum placeat. Qui qui non neque enim praesentium corporis nostrum. Distinctio expedita dicta quis exercitationem. Similique tenetur delectus ratione iusto.', 0, '2018-09-27 19:49:16', '2018-09-27 19:49:16'),
(155, 'Danny Windler', 'Eos voluptas ab nihil pariatur quidem assumenda aut et. Esse voluptatibus quae quasi blanditiis sit sit. Soluta suscipit impedit nihil blanditiis. At est provident eos rerum.', 1, '2018-09-27 19:49:16', '2018-09-27 19:49:16'),
(156, 'Kaya Beier', 'Aperiam dicta vitae reiciendis distinctio. Eveniet repudiandae nisi voluptatem non esse. Assumenda eligendi iusto corporis aperiam. Quia quia quis praesentium repellendus soluta.', 1, '2018-09-27 19:49:16', '2018-09-27 19:49:16'),
(157, 'Olga Kiehn', 'Dolorem consequatur vero dicta accusamus nostrum corrupti. Officiis non velit sit aut. Iure blanditiis culpa nostrum velit aut libero sed.', 0, '2018-09-27 19:49:16', '2018-09-27 19:49:16'),
(158, 'Danial Vandervort', 'A et aut consequatur enim voluptas. Voluptas et quis voluptate dolores ullam dolor nemo voluptatem. Maiores et voluptatum nulla. Earum incidunt quaerat fuga assumenda nostrum nihil.', 0, '2018-09-27 19:49:16', '2018-09-27 19:49:16'),
(159, 'Minnie Donnelly', 'Sed et laudantium magnam quia ratione. Eum blanditiis ut dolores dolore. Animi nihil eveniet cum ab quia ut. Numquam repellat sapiente quidem quisquam odit.', 1, '2018-09-27 19:49:16', '2018-09-27 19:49:16'),
(160, 'Rhiannon Bartell', 'Ipsa dolorum velit quo omnis deleniti. Dolorum consectetur autem et sint. Aperiam quis totam alias tempore ipsam.', 0, '2018-09-27 19:49:16', '2018-09-27 19:49:16'),
(161, 'Alysa Gutkowski', 'Hic ut sit quidem suscipit eligendi enim. Eos iusto molestiae fugit vel cum possimus magnam.', 0, '2018-09-27 19:49:17', '2018-09-27 19:49:17'),
(162, 'Mr. Soledad Schoen', 'Odio sit et vitae sit sed sint. Animi et aspernatur odit praesentium. Maiores eum eos molestiae.', 1, '2018-09-27 19:49:17', '2018-09-27 19:49:17'),
(163, 'Mr. Tom Beatty', 'Nulla consequuntur quia laudantium ex accusamus ut aut. Possimus voluptas molestias voluptatem ad libero repellat. Tempore libero qui quia voluptates sed sint. In aut quia deleniti qui ea cumque.', 0, '2018-09-27 19:49:17', '2018-09-27 19:49:17'),
(164, 'Mr. Lavon Ward DDS', 'Autem dignissimos eos animi repudiandae. Eos eum vel aut cumque doloribus nihil omnis. Ad est eum in et doloribus. Cupiditate sequi adipisci dolore libero modi qui cum.', 1, '2018-09-27 19:49:17', '2018-09-27 19:49:17'),
(165, 'Evangeline Considine DDS', 'Et harum et mollitia recusandae quaerat. Et dolor ea sint et sint sint eaque.', 1, '2018-09-27 19:49:17', '2018-09-27 19:49:17'),
(166, 'Gilbert Schumm', 'Provident qui esse repellendus. Vel est explicabo omnis officia laboriosam quod ea. Ut ut laudantium sequi nesciunt ipsum amet esse similique. Accusamus ut aspernatur mollitia beatae.', 1, '2018-09-27 19:49:17', '2018-09-27 19:49:17'),
(167, 'Damion Lueilwitz', 'Totam quae omnis nulla et odit in nulla. Voluptatem assumenda repellat cumque repellendus omnis commodi rerum porro. Est quaerat qui saepe et quis. Enim molestiae ex cumque aut occaecati id.', 0, '2018-09-27 19:49:17', '2018-09-27 19:49:17'),
(168, 'Velda Wintheiser', 'Excepturi repudiandae facere eaque rerum voluptas error. Excepturi impedit rerum quo cum. Consequatur expedita voluptatem quasi. Fugiat ipsa natus architecto quisquam.', 1, '2018-09-27 19:49:17', '2018-09-27 19:49:17'),
(169, 'Cierra Kub', 'Id enim ut et minus voluptatem qui vitae tempore. Ut sequi qui corporis et et velit. Excepturi asperiores deleniti nesciunt facilis.', 1, '2018-09-27 19:49:17', '2018-09-27 19:49:17'),
(170, 'Mrs. Elnora Olson', 'Maiores illo voluptatibus dolorem nemo. Facere et omnis rerum architecto rerum et laudantium. Aut ducimus dolor est aliquam. Et consectetur molestiae rerum esse quo.', 0, '2018-09-27 19:49:17', '2018-09-27 19:49:17'),
(171, 'Prof. Foster Reichert', 'Sunt voluptas corporis vel sapiente earum. Aut voluptatibus ex a dolores eaque placeat nisi. At amet necessitatibus possimus nihil voluptatibus nostrum dolorum veritatis.', 1, '2018-09-27 19:49:17', '2018-09-27 19:49:17'),
(172, 'Devin Macejkovic', 'Culpa deleniti esse enim. Dignissimos eos aut ipsum dicta illum veniam. Sequi ipsum saepe blanditiis eligendi sed.', 0, '2018-09-27 19:49:17', '2018-09-27 19:49:17'),
(173, 'Ryleigh Altenwerth', 'Possimus praesentium dolore ut et autem autem. Quis quae soluta accusamus voluptatum qui.', 0, '2018-09-27 19:49:17', '2018-09-27 19:49:17'),
(174, 'Dr. Jaida Zulauf', 'Dignissimos iste rem odio iusto quia sint minima pariatur. Accusamus vero dolores eligendi vel qui aperiam.', 1, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(175, 'Prof. Marguerite Towne Sr.', 'In ipsam sunt sequi voluptate. Maxime aut sit possimus illum est sed harum. Nam quia aspernatur velit.', 1, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(176, 'Ethelyn Schuster', 'Sint atque ut voluptate cumque cupiditate. At enim quas nostrum deserunt sed. Earum explicabo ullam et quia totam consequatur. Molestiae cumque nemo ut. Id officia repudiandae aperiam quia illum.', 0, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(177, 'Dr. Jefferey Predovic', 'Accusamus quos eveniet deserunt fugiat voluptas labore ea. Eum et rem esse id. Et qui eaque explicabo dignissimos earum.', 0, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(178, 'Dr. Crystel Johnson', 'Vel dicta ut numquam. Cum sit ipsum aut quia voluptatem aliquid. Quos quod id ut qui. Eaque dolorem sed commodi distinctio.', 1, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(179, 'Darian Koch V', 'Beatae accusamus facilis et deleniti rerum et. Quod amet fuga qui sunt temporibus. Maxime et quae beatae laboriosam.', 0, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(180, 'Chadrick Romaguera Jr.', 'Quo rerum laudantium et omnis saepe cupiditate sed. Reprehenderit dicta non rerum et mollitia est et. Omnis consectetur natus quod saepe soluta. Non et aut laudantium suscipit.', 0, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(181, 'Braulio Zieme', 'Eos ut sit voluptatem perferendis. Omnis architecto id enim sed suscipit. At debitis consectetur consequatur. Animi doloribus laborum itaque libero.', 0, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(182, 'Leonel Volkman', 'Eveniet sit qui ducimus fugiat assumenda. Atque qui magni possimus sapiente est. Officiis laboriosam labore eaque in ut quidem officia.', 1, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(183, 'Miss Adela Brekke MD', 'Sit et rerum facere repudiandae. Enim alias enim iure assumenda. Quia enim eius minima minus veniam.', 1, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(184, 'Mr. Emanuel Rau DVM', 'Impedit tempore eaque neque in laboriosam est maiores. Vero ipsum voluptatem sed. Dolor qui delectus voluptatibus culpa rerum consequuntur. Perspiciatis doloribus fugit unde iste ut et.', 1, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(185, 'Dr. Stacy Aufderhar', 'Illum recusandae tempore tempore consequatur dolor. Autem modi fugit ad ducimus quae praesentium. Nisi recusandae dicta voluptatem ea dolorum occaecati. Et est et numquam fuga occaecati rerum.', 0, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(186, 'Billy Wisoky', 'Ut fugit unde deleniti quia excepturi est. Ullam vitae in at voluptas.', 0, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(187, 'Rowland Wolf', 'Aut voluptate ipsum earum est explicabo. Qui sint pariatur vitae praesentium. Et a doloribus animi eos necessitatibus. Ut dolorem perferendis et alias natus ut quis.', 1, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(188, 'Ellsworth Armstrong', 'Laboriosam sint qui saepe veniam. Et possimus excepturi commodi asperiores odio. Velit totam adipisci consequatur doloremque nihil enim.', 0, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(189, 'Margarett Johnston', 'Reprehenderit praesentium ullam in eos et deleniti voluptates debitis. Ut qui adipisci laborum et. Et natus necessitatibus sunt consequatur. Earum at a quisquam error.', 1, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(190, 'Tevin Pollich', 'Est modi rem id ut laborum. Sint molestiae est earum qui. Nihil error quae aut nostrum. Commodi qui nesciunt adipisci maxime excepturi.', 0, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(191, 'Mr. Spencer Goldner V', 'Repellat sed vitae omnis. Dolores qui et alias repellat velit ratione. Molestiae deserunt qui quae quaerat ipsum rerum. Omnis dolorum minima aliquam iste quas aut sequi.', 0, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(192, 'Mrs. Carmella Lindgren I', 'Id ipsam eligendi ut doloribus consequatur quam. Delectus aut aut voluptatem quia minima recusandae. Sit ducimus sint hic aliquid. Soluta sint rerum repellat et veritatis.', 1, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(193, 'Sabina Klein', 'Molestiae debitis dolorem fugit deserunt. Necessitatibus est doloremque aliquam ipsum harum vel aliquam et. Accusamus iusto velit exercitationem mollitia aliquam repellat commodi dolor.', 0, '2018-09-27 19:49:18', '2018-09-27 19:49:18'),
(194, 'Mrs. Loyce Bode II', 'Illum similique nemo enim aperiam earum dolores officia. Est dolore est tenetur error temporibus mollitia. Quo aut rem atque atque enim minus numquam. Consequatur alias quae enim nobis rem.', 0, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(195, 'Bud Braun II', 'Est fuga totam sit. Ut vitae suscipit maiores voluptas suscipit aut. Numquam corporis recusandae nobis nisi atque maiores sunt omnis.', 0, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(196, 'Dr. Trenton Boehm', 'Iusto repudiandae consequuntur quam quo. Eligendi aliquid dolorem est nisi fugit. Ipsum aut assumenda omnis hic est nobis eos. Quaerat autem quia et fugiat dolorem expedita.', 1, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(197, 'Prof. Charity Eichmann', 'Quos est alias accusamus. Dignissimos accusantium eligendi ea velit enim. Velit placeat consequatur ullam mollitia.', 0, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(198, 'Benton Paucek', 'Laborum repellendus harum et aut. Exercitationem distinctio quibusdam sed consequuntur commodi ea. Autem veritatis temporibus et corrupti quam voluptatem ducimus.', 0, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(199, 'Mr. Kiel Muller Sr.', 'Aperiam maiores voluptatibus velit molestiae tenetur. Enim accusamus sit doloribus enim iste tempora. Quasi quam explicabo rerum commodi est.', 0, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(200, 'Mr. Eloy Boyle DVM', 'Tenetur libero id quia et. Natus eligendi omnis qui est ut. Sapiente cupiditate similique hic omnis esse iste esse.', 0, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(201, 'Horace Legros', 'Ipsa quaerat eveniet blanditiis quidem minima et. Aspernatur ut quod alias aut quasi reprehenderit impedit. Eos et eos sit et. Maxime aut in quis mollitia corporis aliquam a.', 1, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(202, 'Terry Koelpin PhD', 'Impedit sapiente enim omnis quaerat maxime explicabo dolorem. Ut velit autem earum amet voluptates. Pariatur minus et incidunt hic. Hic doloribus unde quasi qui qui.', 0, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(203, 'Mrs. Emma Ledner', 'Aliquam sed magni iste doloremque quam quia. Ad libero ea quisquam ab sunt aspernatur quam. Soluta accusantium minus magnam ipsum autem minima.', 1, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(204, 'Dulce Langosh MD', 'Quia officiis odit minus voluptatem quasi placeat. Architecto ut laborum voluptatem accusantium. Blanditiis eum sunt voluptas dolor quibusdam commodi qui.', 1, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(205, 'Estefania Mayer', 'Harum deserunt et dignissimos laboriosam aliquid. Adipisci expedita magni iure facere officia tenetur. Est tenetur quia architecto doloribus adipisci ex officia. Ducimus sit dicta ipsam non et nam.', 0, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(206, 'Xzavier Hickle Sr.', 'Consectetur eius tenetur aut nesciunt. Magni quidem eligendi autem qui aspernatur omnis modi est.', 0, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(207, 'Verla Abshire', 'Veniam et et expedita omnis incidunt. Vitae corporis eligendi qui in eum. Voluptate ut quos corrupti ut explicabo aliquam vero.', 0, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(208, 'Prof. Ari Bernhard I', 'Ea voluptas sequi dolor perspiciatis molestias. Harum consequatur voluptatem impedit impedit nobis. Laudantium sunt quia numquam necessitatibus fugiat tempora nemo ipsum.', 1, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(209, 'Duane Yost', 'Voluptas eius consequatur vitae similique placeat aut. Laudantium placeat officiis vero rerum modi aut. Veniam molestiae nemo labore dolores placeat voluptatum.', 1, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(210, 'Larissa Howell', 'Consequatur est in inventore reprehenderit. Cumque quis eum sit repellat accusamus voluptas est. Exercitationem magni veniam sed eum voluptatem est illo reprehenderit.', 1, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(211, 'Dr. Sydnie Kuvalis II', 'Nostrum deserunt ipsam voluptas aspernatur. Qui laborum qui animi. Delectus excepturi sapiente illum quasi quia non.', 1, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(212, 'Dr. Diamond Steuber DDS', 'Amet dolorem est perspiciatis a. Sed error aut impedit et repellendus. Aliquid ex doloribus dolore maiores quis accusantium optio. Rem in nostrum porro ut consequatur.', 0, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(213, 'Mertie Hudson', 'Enim culpa velit ut dolores natus voluptatibus dolore. Ad iure id voluptas eos cum est sunt. Dolor ut quia fuga vel perferendis quibusdam.', 1, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(214, 'Sebastian Okuneva II', 'Aut officia eveniet voluptatum fugit beatae ut. Ipsam rerum ipsa qui repudiandae ut culpa qui. Necessitatibus inventore non illo recusandae quisquam quia. Quaerat expedita autem ea quo.', 1, '2018-09-27 19:49:19', '2018-09-27 19:49:19'),
(215, 'Juliet Schamberger', 'Minus et delectus molestias qui quaerat atque et. Iste expedita rerum quia voluptatem et natus rerum eius. Autem reiciendis blanditiis omnis veniam veritatis et alias eos.', 1, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(216, 'Damaris Raynor', 'Quod et laudantium quos laboriosam. Eveniet et libero magni in similique dicta. Voluptas magni odit ut est dolorem fugit exercitationem.', 0, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(217, 'Dr. Rick VonRueden', 'Non voluptatum totam ut reprehenderit vitae vitae aut eaque. Nostrum qui culpa itaque fugiat. Quam sunt sunt distinctio omnis et ex.', 0, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(218, 'Emmy Batz IV', 'Corrupti ea nulla quasi nisi illo natus. Reprehenderit ut tenetur fugit reprehenderit. Est facere aliquid provident.', 0, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(219, 'Parker McCullough', 'Nihil vero ipsa esse labore. Quis voluptatum praesentium nihil. Sint cumque sunt quas eos et vel. Quis labore sit et quia architecto autem.', 0, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(220, 'Prof. Graciela Corkery', 'Aut voluptatum deleniti consectetur inventore consequatur molestiae provident. Magnam quam repellat magni velit delectus eos amet consequatur. Necessitatibus ut dignissimos repellat in ut sunt.', 0, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(221, 'Karlie Witting', 'Eum ipsam ut nihil quisquam saepe voluptas numquam. Minima odio rerum nihil nulla hic voluptates asperiores.', 0, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(222, 'Emmitt Bechtelar', 'Qui est molestiae necessitatibus autem vitae. Ex et ex omnis earum est consequuntur nobis et.', 1, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(223, 'Dr. Chandler Labadie', 'Facere nihil rerum ad. Similique ullam cupiditate totam et. Atque debitis ipsa delectus repellat qui.', 1, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(224, 'Mr. Tito Bogisich', 'Quibusdam consequatur ut iste maxime voluptates ut qui. Accusamus sint cumque eos. Dolores doloremque repudiandae voluptatibus id nemo ut soluta dolor. Nemo tenetur animi inventore ut sit.', 0, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(225, 'Augustine Tremblay', 'Illum non sint impedit enim quae error. Inventore perspiciatis aut non velit et aut consequuntur. Animi ipsam voluptas voluptatum qui impedit.', 1, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(226, 'Gaylord Considine Jr.', 'Officia consectetur consequatur qui. Maxime sint distinctio quaerat dolor odio. Maxime id magni sed.', 0, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(227, 'Alexys Batz', 'Voluptas nobis sit cumque libero ducimus necessitatibus. Aut voluptatem aut non dicta commodi et. Voluptatibus vel pariatur reiciendis eligendi sit.', 1, '2018-09-27 19:49:20', '2018-09-27 19:49:20');
INSERT INTO `formation_levels` (`id`, `name`, `description`, `status`, `created_at`, `updated_at`) VALUES
(228, 'Alvah Rempel I', 'Nisi eos eaque quam vero nam quis. Nihil ratione fugit et aut. Deleniti perferendis quos repudiandae optio sed est rem. Nemo et ea debitis commodi libero. Et sequi autem eius.', 0, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(229, 'Aniyah Langworth', 'Omnis ratione architecto dolor vitae expedita. Voluptatum sint est quia ex. Et accusamus perspiciatis reprehenderit iste et ut.', 0, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(230, 'Kailey Beahan', 'Impedit non quia aut qui ut pariatur ea. Quo est soluta soluta cum. Amet ut quia qui aut nemo dicta facilis. Ducimus sit omnis et voluptatem veniam illum aliquid.', 0, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(231, 'Gavin Wuckert', 'Omnis iure modi libero ut dicta. Recusandae et error optio id non veritatis. Dolorem quo tempore molestiae ut natus. Molestias officia rerum placeat impedit iusto eaque.', 0, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(232, 'Oren Donnelly', 'Enim nisi blanditiis explicabo similique cum eaque dolores. Non ea dolore magni. Impedit sit quia rerum est voluptatibus dolores.', 0, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(233, 'Rosemarie Vandervort', 'Sed culpa autem voluptatibus omnis. Nihil amet et inventore eos. Voluptatem quam facilis consectetur voluptas et aut.', 0, '2018-09-27 19:49:20', '2018-09-27 19:49:20'),
(234, 'Miracle Nitzsche', 'Provident deleniti est alias eum suscipit accusantium voluptas. Dicta facilis earum sit fugit cumque quia. Nihil soluta voluptatem sit omnis ratione. Ea hic quia temporibus ea recusandae aut.', 1, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(235, 'Ryan Satterfield', 'Quia nihil veritatis dignissimos nihil pariatur. Est et possimus delectus fugiat quos. Minus voluptatem id sint doloribus non laborum.', 0, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(236, 'Jo Hane', 'Fugit consectetur commodi sed eos quis. Ut quisquam officia earum id vero voluptas sit dolorem. Non necessitatibus qui eos et.', 0, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(237, 'Alyson Doyle', 'Distinctio qui eum recusandae excepturi aliquid deserunt. Blanditiis numquam doloremque molestiae vel nobis qui. Et quia ut quod illum aspernatur ipsa ut.', 0, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(238, 'Jaren Schaden', 'Quaerat enim qui enim ut laborum. Consequatur dicta at autem ut. Commodi sapiente nobis ipsa eum molestiae. Eum itaque accusantium aspernatur perferendis dolorum itaque.', 1, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(239, 'Austin McDermott IV', 'Aut corrupti neque et et ea omnis vero. Aliquid quod et distinctio in eligendi occaecati. Ullam vel voluptatibus qui illum consequatur. Fugiat iste vel sit.', 1, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(240, 'Candace Kilback', 'Et doloribus quia qui non cumque perspiciatis. Et laboriosam accusamus nulla. Et illo molestias aut repellat assumenda consequatur voluptatum nostrum.', 1, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(241, 'Magdalena Frami', 'Assumenda consequatur fugit non voluptatem corporis. Tempore eos quasi expedita maiores fuga minima reiciendis. Mollitia natus rerum pariatur.', 1, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(242, 'Mrs. Candida Wolf DVM', 'Minus aut voluptatem magnam iusto. Ad id et fugit nobis doloremque aut. Dolore repellat enim neque qui maiores sit dolorem.', 0, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(243, 'Lila Barrows III', 'Consectetur iure laudantium occaecati amet et architecto. Voluptatem autem ut quis voluptate deleniti exercitationem. Molestiae alias est natus ipsum omnis eligendi sed eos.', 0, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(244, 'Mohammad Batz', 'Deleniti natus sapiente cupiditate enim iure atque. Est quas doloremque dolorum nihil vel corporis illum. Numquam facilis omnis rerum tempora pariatur deleniti a.', 1, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(245, 'Jaleel Lowe', 'Eum quaerat quis neque velit quod est. Ducimus hic libero cupiditate optio at. Aliquam ea debitis laudantium in dicta voluptatem ex. Mollitia sint voluptatem aut alias.', 1, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(246, 'Chelsea Schaden', 'Asperiores voluptatem deserunt deserunt possimus. Est quia tempora officia provident quis. Sint et et cupiditate libero. Voluptas saepe optio atque laudantium similique.', 1, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(247, 'Hilbert Kulas', 'Error dicta necessitatibus exercitationem suscipit est. Dolores aut magni ut consequuntur autem illum qui. Ea molestias explicabo voluptatem voluptas voluptate iste quis.', 1, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(248, 'Dr. Frederique Smith MD', 'Nisi aut minus rerum rerum officiis. Voluptatibus dolor libero id autem commodi ducimus laborum consequatur. Velit adipisci tenetur et at adipisci quas ea.', 1, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(249, 'Shawn Kihn', 'Maiores velit aperiam illo eveniet. Doloremque est cupiditate dolorem nisi est. Optio deserunt nemo ut et et.', 0, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(250, 'Ms. Daniella Deckow DVM', 'Incidunt est inventore quaerat. Accusamus officiis et aliquid aspernatur. Sed maiores est at deleniti velit et aut quibusdam.', 0, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(251, 'Otha Parker I', 'Expedita cupiditate repudiandae odit ea. Qui quidem dolorem vitae non et ut facere adipisci.', 0, '2018-09-27 19:49:21', '2018-09-27 19:49:21'),
(252, 'Trisha Ortiz', 'Hic ea hic reprehenderit iure. Odit officia voluptatum nobis explicabo repellat numquam dolor. Distinctio sunt facilis nihil ad nesciunt aspernatur id temporibus.', 1, '2018-09-27 19:49:22', '2018-09-27 19:49:22'),
(253, 'Lew Oberbrunner', 'Totam libero et vel repellendus. In eos beatae architecto porro reiciendis voluptate. Iusto non quibusdam totam quis sit vel aliquid. Et aspernatur cum debitis illo.', 1, '2018-09-27 19:49:22', '2018-09-27 19:49:22'),
(254, 'Raven Olson', 'Dolorem nemo reiciendis velit earum. Illum voluptas beatae officiis asperiores totam. Saepe ipsam temporibus illo quasi et occaecati in.', 0, '2018-09-27 19:49:22', '2018-09-27 19:49:22'),
(255, 'Noemi Harber', 'Inventore dignissimos quis iure reprehenderit beatae est consequatur nobis. Adipisci animi error velit impedit. Maxime dolorum dolor quae quis mollitia non. Quasi et enim dolorem repellat.', 1, '2018-09-27 19:49:22', '2018-09-27 19:49:22'),
(256, 'Carey Keebler', 'Possimus facere autem sint non odit. Voluptatem ipsam mollitia officiis velit aut aut iste. Maxime est sit et voluptatem. Molestiae corrupti non fugiat neque at.', 0, '2018-09-27 19:49:22', '2018-09-27 19:49:22'),
(257, 'Nona Eichmann', 'Ad quam in voluptatem quos qui ipsam. Illo id dolorum at quisquam perferendis quia aspernatur. Reprehenderit deserunt placeat non quisquam ut ullam.', 1, '2018-09-27 19:49:22', '2018-09-27 19:49:22');

-- --------------------------------------------------------

--
-- Table structure for table `institutions`
--

CREATE TABLE IF NOT EXISTS `institutions` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `city_id` int(11) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-Inactive, 1-Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_institutions_cities1_idx` (`city_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `institutions`
--

INSERT INTO `institutions` (`id`, `city_id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(2, 1, 'Institución 1', 1, '2018-09-25 14:19:42', '2018-09-25 14:20:08');

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2018_09_28_082347_create_permission_tables', 1);

-- --------------------------------------------------------

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE IF NOT EXISTS `model_has_permissions` (
  `permission_id` int(10) UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_type_model_id_index` (`model_type`,`model_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE IF NOT EXISTS `model_has_roles` (
  `role_id` int(10) UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_type_model_id_index` (`model_type`,`model_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\User', 1),
(2, 'App\\User', 256);

-- --------------------------------------------------------

--
-- Table structure for table `multimedia`
--

CREATE TABLE IF NOT EXISTS `multimedia` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `entity_id` int(11) UNSIGNED NOT NULL,
  `type` tinyint(4) NOT NULL COMMENT '1-Contents, 2-Thematics',
  `file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_multimedia_contents1_idx` (`entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `multimedia`
--

INSERT INTO `multimedia` (`id`, `entity_id`, `type`, `file`, `url`, `created_at`, `updated_at`) VALUES
(15, 50, 1, 'MWLDBCTQKF_20180924110728.jpg', NULL, '2018-09-24 16:07:29', '2018-09-24 16:07:29');

-- --------------------------------------------------------

--
-- Table structure for table `notifications`
--

CREATE TABLE IF NOT EXISTS `notifications` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `from_user_id` int(11) UNSIGNED NOT NULL,
  `to_user_id` int(11) UNSIGNED NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `viewed` tinyint(4) DEFAULT '0' COMMENT '0-Pending, 2-Viewed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_notifications_users1_idx` (`from_user_id`),
  KEY `fk_notifications_users2_idx` (`to_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE IF NOT EXISTS `permissions` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'create_users', 'api', '2018-09-28 13:57:12', '2018-09-28 14:09:57'),
(2, 'index_users', 'api', '2018-09-28 14:03:03', '2018-09-28 14:10:16');

-- --------------------------------------------------------

--
-- Table structure for table `places`
--

CREATE TABLE IF NOT EXISTS `places` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `institution_id` int(11) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0-Inactive, 1-Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_places_institutions1_idx` (`institution_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `places`
--

INSERT INTO `places` (`id`, `institution_id`, `name`, `address`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 'Medellin', NULL, 1, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `programs`
--

CREATE TABLE IF NOT EXISTS `programs` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-Inactive, 1-Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `programs`
--

INSERT INTO `programs` (`id`, `name`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'No aplica', NULL, 1, NULL, '2018-09-26 19:52:06');

-- --------------------------------------------------------

--
-- Table structure for table `projects`
--

CREATE TABLE IF NOT EXISTS `projects` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `score` int(11) NOT NULL DEFAULT '0',
  `total_comments` int(11) NOT NULL DEFAULT '0',
  `total_documents` int(11) NOT NULL DEFAULT '0',
  `total_ratings` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-Inactive, 1-Active, 2-In review, 3-Not approved',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`id`, `name`, `image`, `description`, `score`, `total_comments`, `total_documents`, `total_ratings`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Project 1', NULL, NULL, 0, 0, 0, 0, 1, '2018-09-25 21:45:48', '2018-09-25 21:45:48');

-- --------------------------------------------------------

--
-- Table structure for table `project_contents`
--

CREATE TABLE IF NOT EXISTS `project_contents` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `project_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL COMMENT 'Content creator',
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-Inactive, 1-Active, 2-Pending, 3-In review, 4-Not approved',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_project_contents_projects1_idx` (`project_id`),
  KEY `fk_project_contents_users1_idx` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `project_contents`
--

INSERT INTO `project_contents` (`id`, `project_id`, `user_id`, `name`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'Contenido 1', NULL, 0, '2018-09-27 16:26:47', '2018-09-27 16:27:23');

-- --------------------------------------------------------

--
-- Table structure for table `project_user`
--

CREATE TABLE IF NOT EXISTS `project_user` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `project_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-Not approved, 1-Approved',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_project_user_projects1_idx` (`project_id`),
  KEY `fk_project_user_users1_idx` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `project_user`
--

INSERT INTO `project_user` (`id`, `project_id`, `user_id`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1, '2018-09-25 21:46:07', '2018-09-28 15:30:34');

-- --------------------------------------------------------

--
-- Table structure for table `queries`
--

CREATE TABLE IF NOT EXISTS `queries` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `content_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL COMMENT 'Id of student that send the query',
  `question` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_queries_users1_idx` (`user_id`),
  KEY `fk_queries_contents1_idx` (`content_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `queries`
--

INSERT INTO `queries` (`id`, `content_id`, `user_id`, `question`, `description`, `created_at`, `updated_at`) VALUES
(5, 50, 1, 'Pregunta 1 - UPDATED', NULL, '2018-09-24 16:12:33', '2018-09-24 16:16:28');

-- --------------------------------------------------------

--
-- Table structure for table `questions`
--

CREATE TABLE IF NOT EXISTS `questions` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `evaluation_id` int(11) UNSIGNED NOT NULL,
  `question` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `help_image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `order` int(11) DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0-Inactive, 1-Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_questions_evaluations1_idx` (`evaluation_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `questions`
--

INSERT INTO `questions` (`id`, `evaluation_id`, `question`, `help_image`, `description`, `order`, `status`, `created_at`, `updated_at`) VALUES
(7, 6, 'Pregunta 1', NULL, 'Descripcion', 1212, 1, '2018-09-24 19:15:45', '2018-09-24 19:15:45');

-- --------------------------------------------------------

--
-- Table structure for table `ratings`
--

CREATE TABLE IF NOT EXISTS `ratings` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `project_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `score` int(11) NOT NULL DEFAULT '0',
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_ratings_projects1_idx` (`project_id`),
  KEY `fk_ratings_users1_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `replies`
--

CREATE TABLE IF NOT EXISTS `replies` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `query_id` int(11) UNSIGNED NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_replies_queries1_idx` (`query_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE IF NOT EXISTS `roles` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'Administrador', 'api', '2018-09-28 13:31:18', '2018-09-28 13:42:48'),
(2, 'Estudiante', 'api', '2018-09-28 16:35:14', '2018-09-28 16:35:14');

-- --------------------------------------------------------

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE IF NOT EXISTS `role_has_permissions` (
  `permission_id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1),
(1, 2),
(2, 1),
(2, 2);

-- --------------------------------------------------------

--
-- Table structure for table `thematics`
--

CREATE TABLE IF NOT EXISTS `thematics` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `status` tinyint(4) DEFAULT '1' COMMENT '0-Inactive, 1-Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `thematic_answers`
--

CREATE TABLE IF NOT EXISTS `thematic_answers` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `thematic_question_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL COMMENT 'Expert that send the answer',
  `description` text COLLATE utf8_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_thematic_answers_thematic_questions1_idx` (`thematic_question_id`),
  KEY `fk_thematic_answers_users1_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `thematic_questions`
--

CREATE TABLE IF NOT EXISTS `thematic_questions` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `thematic_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL COMMENT 'Student that do the question',
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `answered` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-No answers, 1-Already answered',
  `created_at` timestamp NULL DEFAULT NULL,
  `upated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_thematic_questions_users1_idx` (`user_id`),
  KEY `fk_thematic_questions_thematics1_idx` (`thematic_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `themes`
--

CREATE TABLE IF NOT EXISTS `themes` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `course_id` int(11) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tags` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `order` int(11) DEFAULT NULL,
  `evaluable` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-No, 1-Yes',
  `evaluation_time` float DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0-Inactive, 1-Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_themes_courses1_idx` (`course_id`)
) ENGINE=InnoDB AUTO_INCREMENT=154 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` (`id`, `course_id`, `name`, `tags`, `description`, `order`, `evaluable`, `evaluation_time`, `status`, `created_at`, `updated_at`) VALUES
(2, 3, 'Integrales Dobles', NULL, NULL, NULL, 0, NULL, 0, '2018-09-19 22:02:47', '2018-09-24 17:00:19'),
(3, 3, 'Integrales Dobles', NULL, NULL, NULL, 0, NULL, 1, '2018-09-24 15:49:16', '2018-09-24 15:49:16'),
(4, 368, 'Aurelio Kunze', NULL, NULL, 30, 0, NULL, 0, '2018-09-27 20:34:43', '2018-09-27 20:34:43'),
(5, 353, 'Dr. Willis Bogan', NULL, NULL, 30, 0, NULL, 0, '2018-09-27 20:34:43', '2018-09-27 20:34:43'),
(6, 321, 'Dr. Sharon Koepp DDS', NULL, NULL, 9, 1, NULL, 0, '2018-09-27 20:34:43', '2018-09-27 20:34:43'),
(7, 394, 'Prof. Skye Jakubowski', NULL, NULL, 43, 0, NULL, 0, '2018-09-27 20:34:43', '2018-09-27 20:34:43'),
(8, 365, 'Prof. Lucius Reichel', NULL, NULL, 58, 0, NULL, 1, '2018-09-27 20:34:43', '2018-09-27 20:34:43'),
(9, 370, 'Harrison Wisozk MD', NULL, NULL, 150, 1, NULL, 1, '2018-09-27 20:34:44', '2018-09-27 20:34:44'),
(10, 454, 'Janet D\'Amore', NULL, NULL, 99, 0, NULL, 0, '2018-09-27 20:34:44', '2018-09-27 20:34:44'),
(11, 454, 'Neil Bernhard', NULL, NULL, 5, 1, NULL, 1, '2018-09-27 20:34:44', '2018-09-27 20:34:44'),
(12, 361, 'Delmer Upton', NULL, NULL, 77, 1, NULL, 0, '2018-09-27 20:34:44', '2018-09-27 20:34:44'),
(13, 429, 'Mrs. Maymie Rice', NULL, NULL, 62, 0, NULL, 1, '2018-09-27 20:34:44', '2018-09-27 20:34:44'),
(14, 345, 'Libbie Bradtke', NULL, NULL, 35, 0, NULL, 0, '2018-09-27 20:34:44', '2018-09-27 20:34:44'),
(15, 314, 'Evangeline Nicolas', NULL, NULL, 7, 1, NULL, 1, '2018-09-27 20:34:44', '2018-09-27 20:34:44'),
(16, 396, 'Ms. Assunta Stokes', NULL, NULL, 37, 1, NULL, 0, '2018-09-27 20:34:44', '2018-09-27 20:34:44'),
(17, 398, 'Rosetta Crona', NULL, NULL, 118, 0, NULL, 1, '2018-09-27 20:34:45', '2018-09-27 20:34:45'),
(18, 444, 'Hassie Considine', NULL, NULL, 53, 1, NULL, 0, '2018-09-27 20:34:45', '2018-09-27 20:34:45'),
(19, 411, 'Jenifer Considine', NULL, NULL, 12, 0, NULL, 0, '2018-09-27 20:34:45', '2018-09-27 20:34:45'),
(20, 443, 'Dr. Carleton Hahn', NULL, NULL, 35, 1, NULL, 0, '2018-09-27 20:34:45', '2018-09-27 20:34:45'),
(21, 333, 'Alexandro Nikolaus V', NULL, NULL, 122, 0, NULL, 0, '2018-09-27 20:34:45', '2018-09-27 20:34:45'),
(22, 354, 'Mr. Braxton Hilll IV', NULL, NULL, 143, 1, NULL, 0, '2018-09-27 20:34:45', '2018-09-27 20:34:45'),
(23, 388, 'Lennie Fadel DVM', NULL, NULL, 138, 1, NULL, 1, '2018-09-27 20:34:45', '2018-09-27 20:34:45'),
(24, 408, 'Mr. Antwon Gibson Sr.', NULL, NULL, 133, 0, NULL, 0, '2018-09-27 20:34:45', '2018-09-27 20:34:45'),
(25, 366, 'Mr. Boyd Hayes', NULL, NULL, 12, 0, NULL, 0, '2018-09-27 20:34:45', '2018-09-27 20:34:45'),
(26, 3, 'Halie Ernser', NULL, NULL, 55, 0, NULL, 0, '2018-09-27 20:34:46', '2018-09-27 20:34:46'),
(27, 330, 'Ms. Anahi Thiel V', NULL, NULL, 70, 0, NULL, 1, '2018-09-27 20:34:46', '2018-09-27 20:34:46'),
(28, 321, 'Gonzalo Ward', NULL, NULL, 107, 1, NULL, 0, '2018-09-27 20:34:46', '2018-09-27 20:34:46'),
(29, 321, 'Eloise Mueller', NULL, NULL, 44, 0, NULL, 0, '2018-09-27 20:34:46', '2018-09-27 20:34:46'),
(30, 349, 'Ulises Kirlin', NULL, NULL, 78, 0, NULL, 0, '2018-09-27 20:34:46', '2018-09-27 20:34:46'),
(31, 422, 'Deontae Denesik', NULL, NULL, 38, 0, NULL, 1, '2018-09-27 20:34:47', '2018-09-27 20:34:47'),
(32, 390, 'Sydni Ebert IV', NULL, NULL, 4, 0, NULL, 0, '2018-09-27 20:34:47', '2018-09-27 20:34:47'),
(33, 369, 'Eleazar Sporer', NULL, NULL, 121, 1, NULL, 0, '2018-09-27 20:34:47', '2018-09-27 20:34:47'),
(34, 421, 'Chelsea Corwin', NULL, NULL, 12, 0, NULL, 0, '2018-09-27 20:34:47', '2018-09-27 20:34:47'),
(35, 427, 'Vilma Cartwright I', NULL, NULL, 16, 1, NULL, 1, '2018-09-27 20:34:47', '2018-09-27 20:34:47'),
(36, 414, 'Marielle Paucek', NULL, NULL, 144, 0, NULL, 0, '2018-09-27 20:34:47', '2018-09-27 20:34:47'),
(37, 432, 'Titus Lockman', NULL, NULL, 109, 1, NULL, 1, '2018-09-27 20:34:47', '2018-09-27 20:34:47'),
(38, 390, 'Brennan Okuneva PhD', NULL, NULL, 100, 0, NULL, 0, '2018-09-27 20:34:47', '2018-09-27 20:34:47'),
(39, 422, 'Kurt Cronin', NULL, NULL, 87, 0, NULL, 1, '2018-09-27 20:34:47', '2018-09-27 20:34:47'),
(40, 363, 'Yasmine Fadel', NULL, NULL, 52, 1, NULL, 1, '2018-09-27 20:34:47', '2018-09-27 20:34:47'),
(41, 446, 'Nedra Windler', NULL, NULL, 66, 0, NULL, 1, '2018-09-27 20:34:48', '2018-09-27 20:34:48'),
(42, 322, 'Leon Ruecker', NULL, NULL, 130, 1, NULL, 1, '2018-09-27 20:34:48', '2018-09-27 20:34:48'),
(43, 445, 'Ahmad Lynch', NULL, NULL, 31, 1, NULL, 0, '2018-09-27 20:34:48', '2018-09-27 20:34:48'),
(44, 449, 'Ruthe Effertz', NULL, NULL, 51, 0, NULL, 0, '2018-09-27 20:34:48', '2018-09-27 20:34:48'),
(45, 346, 'Mr. Shayne Simonis Jr.', NULL, NULL, 36, 1, NULL, 0, '2018-09-27 20:34:48', '2018-09-27 20:34:48'),
(46, 403, 'Norma Grimes', NULL, NULL, 145, 0, NULL, 1, '2018-09-27 20:34:48', '2018-09-27 20:34:48'),
(47, 383, 'Prof. Mable Hermann I', NULL, NULL, 40, 1, NULL, 0, '2018-09-27 20:34:48', '2018-09-27 20:34:48'),
(48, 380, 'Arielle Lebsack', NULL, NULL, 97, 1, NULL, 1, '2018-09-27 20:34:48', '2018-09-27 20:34:48'),
(49, 416, 'Maximillian Breitenberg', NULL, NULL, 78, 1, NULL, 0, '2018-09-27 20:34:48', '2018-09-27 20:34:48'),
(50, 441, 'Prof. Zachery Wilderman', NULL, NULL, 78, 1, NULL, 0, '2018-09-27 20:34:48', '2018-09-27 20:34:48'),
(51, 445, 'Zula Kuhn', NULL, NULL, 120, 0, NULL, 0, '2018-09-27 20:34:48', '2018-09-27 20:34:48'),
(52, 316, 'Cristal Wiegand', NULL, NULL, 61, 1, NULL, 0, '2018-09-27 20:34:48', '2018-09-27 20:34:48'),
(53, 403, 'Darrel Barrows', NULL, NULL, 139, 0, NULL, 1, '2018-09-27 20:34:49', '2018-09-27 20:34:49'),
(54, 414, 'Felicita Friesen', NULL, NULL, 103, 1, NULL, 1, '2018-09-27 20:34:49', '2018-09-27 20:34:49'),
(55, 382, 'Jakob Upton', NULL, NULL, 147, 0, NULL, 0, '2018-09-27 20:34:49', '2018-09-27 20:34:49'),
(56, 395, 'Prof. Icie Wunsch', NULL, NULL, 96, 0, NULL, 1, '2018-09-27 20:34:49', '2018-09-27 20:34:49'),
(57, 427, 'Dorian Beahan', NULL, NULL, 13, 0, NULL, 0, '2018-09-27 20:34:49', '2018-09-27 20:34:49'),
(58, 377, 'Mr. Arturo Sanford PhD', NULL, NULL, 91, 0, NULL, 0, '2018-09-27 20:34:49', '2018-09-27 20:34:49'),
(59, 434, 'Edmund Roob IV', NULL, NULL, 49, 1, NULL, 0, '2018-09-27 20:34:49', '2018-09-27 20:34:49'),
(60, 414, 'Garland Rippin', NULL, NULL, 107, 1, NULL, 1, '2018-09-27 20:34:49', '2018-09-27 20:34:49'),
(61, 421, 'Mariela Marquardt', NULL, NULL, 48, 0, NULL, 1, '2018-09-27 20:34:49', '2018-09-27 20:34:49'),
(62, 425, 'Viola Watsica', NULL, NULL, 120, 1, NULL, 0, '2018-09-27 20:34:50', '2018-09-27 20:34:50'),
(63, 379, 'Sebastian Powlowski', NULL, NULL, 52, 1, NULL, 0, '2018-09-27 20:34:50', '2018-09-27 20:34:50'),
(64, 357, 'Simone Kemmer I', NULL, NULL, 71, 1, NULL, 1, '2018-09-27 20:34:50', '2018-09-27 20:34:50'),
(65, 340, 'Tiara Muller I', NULL, NULL, 106, 0, NULL, 0, '2018-09-27 20:34:50', '2018-09-27 20:34:50'),
(66, 379, 'Kaylee Gorczany', NULL, NULL, 42, 1, NULL, 0, '2018-09-27 20:34:50', '2018-09-27 20:34:50'),
(67, 337, 'Audrey Hahn', NULL, NULL, 129, 0, NULL, 1, '2018-09-27 20:34:50', '2018-09-27 20:34:50'),
(68, 344, 'Ms. Fay Gutkowski DVM', NULL, NULL, 120, 0, NULL, 1, '2018-09-27 20:34:50', '2018-09-27 20:34:50'),
(69, 349, 'Roselyn Schulist', NULL, NULL, 59, 1, NULL, 0, '2018-09-27 20:34:50', '2018-09-27 20:34:50'),
(70, 423, 'Rose Aufderhar III', NULL, NULL, 62, 0, NULL, 1, '2018-09-27 20:34:50', '2018-09-27 20:34:50'),
(71, 397, 'Dr. Ramiro Nienow PhD', NULL, NULL, 62, 0, NULL, 1, '2018-09-27 20:34:50', '2018-09-27 20:34:50'),
(72, 320, 'Emmalee Russel', NULL, NULL, 81, 1, NULL, 1, '2018-09-27 20:34:51', '2018-09-27 20:34:51'),
(73, 406, 'Brannon Roob', NULL, NULL, 92, 0, NULL, 1, '2018-09-27 20:34:51', '2018-09-27 20:34:51'),
(74, 424, 'Dr. Sonya Stanton III', NULL, NULL, 146, 0, NULL, 0, '2018-09-27 20:34:51', '2018-09-27 20:34:51'),
(75, 337, 'Porter Russel I', NULL, NULL, 149, 0, NULL, 0, '2018-09-27 20:34:51', '2018-09-27 20:34:51'),
(76, 353, 'Christian Waters II', NULL, NULL, 15, 1, NULL, 1, '2018-09-27 20:34:51', '2018-09-27 20:34:51'),
(77, 345, 'Jeanie Weimann', NULL, NULL, 92, 1, NULL, 1, '2018-09-27 20:34:51', '2018-09-27 20:34:51'),
(78, 376, 'Dr. Al Barrows II', NULL, NULL, 117, 1, NULL, 1, '2018-09-27 20:34:51', '2018-09-27 20:34:51'),
(79, 450, 'Justus Carter', NULL, NULL, 87, 0, NULL, 0, '2018-09-27 20:34:51', '2018-09-27 20:34:51'),
(80, 320, 'Dr. Dasia Moore MD', NULL, NULL, 47, 0, NULL, 1, '2018-09-27 20:34:51', '2018-09-27 20:34:51'),
(81, 451, 'Miss Reba Nicolas', NULL, NULL, 1, 0, NULL, 1, '2018-09-27 20:34:51', '2018-09-27 20:34:51'),
(82, 349, 'Blanca Green', NULL, NULL, 66, 1, NULL, 0, '2018-09-27 20:34:51', '2018-09-27 20:34:51'),
(83, 438, 'Lyda Anderson IV', NULL, NULL, 24, 0, NULL, 0, '2018-09-27 20:34:51', '2018-09-27 20:34:51'),
(84, 310, 'Leola Cummerata', NULL, NULL, 51, 1, NULL, 0, '2018-09-27 20:34:51', '2018-09-27 20:34:51'),
(85, 396, 'Dr. Reinhold Schinner', NULL, NULL, 50, 0, NULL, 1, '2018-09-27 20:34:51', '2018-09-27 20:34:51'),
(86, 395, 'Valentin Roob', NULL, NULL, 106, 0, NULL, 1, '2018-09-27 20:34:52', '2018-09-27 20:34:52'),
(87, 309, 'Mr. Noel Morar IV', NULL, NULL, 60, 0, NULL, 1, '2018-09-27 20:34:52', '2018-09-27 20:34:52'),
(88, 419, 'Gloria O\'Kon IV', NULL, NULL, 50, 0, NULL, 1, '2018-09-27 20:34:52', '2018-09-27 20:34:52'),
(89, 322, 'Birdie Lakin', NULL, NULL, 90, 0, NULL, 0, '2018-09-27 20:34:52', '2018-09-27 20:34:52'),
(90, 316, 'Clint Kunde', NULL, NULL, 93, 0, NULL, 1, '2018-09-27 20:34:52', '2018-09-27 20:34:52'),
(91, 349, 'Tracey Schumm', NULL, NULL, 101, 1, NULL, 1, '2018-09-27 20:34:52', '2018-09-27 20:34:52'),
(92, 321, 'Mr. Lucio Stark', NULL, NULL, 128, 1, NULL, 0, '2018-09-27 20:34:52', '2018-09-27 20:34:52'),
(93, 409, 'Garnett Waters', NULL, NULL, 128, 1, NULL, 1, '2018-09-27 20:34:52', '2018-09-27 20:34:52'),
(94, 327, 'Mr. Garrison Gaylord', NULL, NULL, 30, 1, NULL, 0, '2018-09-27 20:34:52', '2018-09-27 20:34:52'),
(95, 321, 'Noble Spencer', NULL, NULL, 90, 0, NULL, 0, '2018-09-27 20:34:52', '2018-09-27 20:34:52'),
(96, 331, 'Cindy Connelly', NULL, NULL, 138, 1, NULL, 1, '2018-09-27 20:34:52', '2018-09-27 20:34:52'),
(97, 318, 'Dr. Ellsworth Watsica', NULL, NULL, 47, 1, NULL, 0, '2018-09-27 20:34:52', '2018-09-27 20:34:52'),
(98, 412, 'Corrine Muller DDS', NULL, NULL, 121, 1, NULL, 1, '2018-09-27 20:34:52', '2018-09-27 20:34:52'),
(99, 326, 'Mrs. Susan Auer', NULL, NULL, 100, 0, NULL, 0, '2018-09-27 20:34:53', '2018-09-27 20:34:53'),
(100, 427, 'Clare Hilll', NULL, NULL, 35, 1, NULL, 0, '2018-09-27 20:34:53', '2018-09-27 20:34:53'),
(101, 434, 'Dr. Pearline Sauer', NULL, NULL, 106, 0, NULL, 1, '2018-09-27 20:34:53', '2018-09-27 20:34:53'),
(102, 433, 'Emil Wiegand Sr.', NULL, NULL, 4, 1, NULL, 1, '2018-09-27 20:34:53', '2018-09-27 20:34:53'),
(103, 384, 'Mr. Ike Nolan V', NULL, NULL, 121, 0, NULL, 1, '2018-09-27 20:34:53', '2018-09-27 20:34:53'),
(104, 453, 'Daron Pagac', NULL, NULL, 79, 1, NULL, 0, '2018-09-27 20:34:53', '2018-09-27 20:34:53'),
(105, 327, 'Prof. Raina Cummings Sr.', NULL, NULL, 125, 0, NULL, 0, '2018-09-27 20:34:53', '2018-09-27 20:34:53'),
(106, 418, 'Dr. Juwan Hilpert', NULL, NULL, 66, 0, NULL, 0, '2018-09-27 20:34:53', '2018-09-27 20:34:53'),
(107, 387, 'Mrs. Loren Spinka', NULL, NULL, 5, 1, NULL, 1, '2018-09-27 20:34:53', '2018-09-27 20:34:53'),
(108, 371, 'Madge Lang', NULL, NULL, 79, 1, NULL, 0, '2018-09-27 20:34:53', '2018-09-27 20:34:53'),
(109, 318, 'Alysa Smitham', NULL, NULL, 99, 0, NULL, 0, '2018-09-27 20:34:53', '2018-09-27 20:34:53'),
(110, 382, 'Nikita Hammes', NULL, NULL, 94, 0, NULL, 0, '2018-09-27 20:34:54', '2018-09-27 20:34:54'),
(111, 360, 'Alejandra Zieme', NULL, NULL, 136, 0, NULL, 1, '2018-09-27 20:34:54', '2018-09-27 20:34:54'),
(112, 396, 'Jeremy Abernathy', NULL, NULL, 52, 0, NULL, 1, '2018-09-27 20:34:54', '2018-09-27 20:34:54'),
(113, 406, 'Timothy Ankunding', NULL, NULL, 95, 0, NULL, 0, '2018-09-27 20:34:55', '2018-09-27 20:34:55'),
(114, 380, 'Carley Kihn', NULL, NULL, 67, 1, NULL, 1, '2018-09-27 20:34:55', '2018-09-27 20:34:55'),
(115, 365, 'Miss Laurine Terry', NULL, NULL, 80, 0, NULL, 1, '2018-09-27 20:34:55', '2018-09-27 20:34:55'),
(116, 381, 'Elda Kreiger', NULL, NULL, 19, 1, NULL, 0, '2018-09-27 20:34:55', '2018-09-27 20:34:55'),
(117, 314, 'Demetris Schroeder I', NULL, NULL, 9, 0, NULL, 1, '2018-09-27 20:34:55', '2018-09-27 20:34:55'),
(118, 336, 'Mrs. Anya Rosenbaum III', NULL, NULL, 63, 0, NULL, 0, '2018-09-27 20:34:56', '2018-09-27 20:34:56'),
(119, 378, 'Noemi McClure', NULL, NULL, 72, 0, NULL, 1, '2018-09-27 20:34:56', '2018-09-27 20:34:56'),
(120, 425, 'Dr. Ramon Cummerata', NULL, NULL, 93, 1, NULL, 0, '2018-09-27 20:34:56', '2018-09-27 20:34:56'),
(121, 348, 'Desiree Witting', NULL, NULL, 4, 0, NULL, 1, '2018-09-27 20:34:56', '2018-09-27 20:34:56'),
(122, 454, 'Rosanna Cormier', NULL, NULL, 59, 0, NULL, 1, '2018-09-27 20:34:56', '2018-09-27 20:34:56'),
(123, 316, 'Mrs. Maribel Hartmann', NULL, NULL, 55, 0, NULL, 1, '2018-09-27 20:34:56', '2018-09-27 20:34:56'),
(124, 365, 'Shannon Bogisich', NULL, NULL, 53, 1, NULL, 1, '2018-09-27 20:34:57', '2018-09-27 20:34:57'),
(125, 408, 'Marilie Nader', NULL, NULL, 86, 0, NULL, 0, '2018-09-27 20:34:57', '2018-09-27 20:34:57'),
(126, 406, 'Mrs. Abigayle Dooley DDS', NULL, NULL, 123, 0, NULL, 0, '2018-09-27 20:34:57', '2018-09-27 20:34:57'),
(127, 351, 'Jayda Vandervort', NULL, NULL, 64, 0, NULL, 0, '2018-09-27 20:34:57', '2018-09-27 20:34:57'),
(128, 433, 'Gianni Ortiz IV', NULL, NULL, 140, 0, NULL, 1, '2018-09-27 20:34:57', '2018-09-27 20:34:57'),
(129, 326, 'Prof. Duane Simonis I', NULL, NULL, 33, 1, NULL, 1, '2018-09-27 20:34:57', '2018-09-27 20:34:57'),
(130, 383, 'Verla Emard', NULL, NULL, 129, 0, NULL, 1, '2018-09-27 20:34:57', '2018-09-27 20:34:57'),
(131, 348, 'Ms. Kaycee Rice MD', NULL, NULL, 101, 1, NULL, 1, '2018-09-27 20:34:57', '2018-09-27 20:34:57'),
(132, 334, 'Jerrod Wilkinson', NULL, NULL, 79, 1, NULL, 0, '2018-09-27 20:34:57', '2018-09-27 20:34:57'),
(133, 416, 'Jamal White', NULL, NULL, 48, 0, NULL, 1, '2018-09-27 20:34:57', '2018-09-27 20:34:57'),
(134, 340, 'Cathy Nikolaus', NULL, NULL, 141, 0, NULL, 0, '2018-09-27 20:34:58', '2018-09-27 20:34:58'),
(135, 382, 'Burley Legros', NULL, NULL, 99, 0, NULL, 1, '2018-09-27 20:34:58', '2018-09-27 20:34:58'),
(136, 338, 'Orval Breitenberg', NULL, NULL, 62, 1, NULL, 0, '2018-09-27 20:34:58', '2018-09-27 20:34:58'),
(137, 379, 'Miss Emmanuelle Brekke', NULL, NULL, 129, 1, NULL, 0, '2018-09-27 20:34:58', '2018-09-27 20:34:58'),
(138, 322, 'Danielle Cronin MD', NULL, NULL, 10, 1, NULL, 0, '2018-09-27 20:34:58', '2018-09-27 20:34:58'),
(139, 450, 'Esmeralda Kuhic', NULL, NULL, 147, 1, NULL, 1, '2018-09-27 20:34:58', '2018-09-27 20:34:58'),
(140, 319, 'Alycia Haley PhD', NULL, NULL, 108, 0, NULL, 0, '2018-09-27 20:34:58', '2018-09-27 20:34:58'),
(141, 338, 'Lillie Aufderhar', NULL, NULL, 88, 0, NULL, 1, '2018-09-27 20:34:58', '2018-09-27 20:34:58'),
(142, 424, 'Prof. Nathaniel Ondricka II', NULL, NULL, 72, 0, NULL, 0, '2018-09-27 20:34:58', '2018-09-27 20:34:58'),
(143, 375, 'Jabari Brakus', NULL, NULL, 77, 0, NULL, 1, '2018-09-27 20:34:58', '2018-09-27 20:34:58'),
(144, 312, 'Ben Feil', NULL, NULL, 31, 0, NULL, 0, '2018-09-27 20:34:59', '2018-09-27 20:34:59'),
(145, 442, 'Zakary Schultz', NULL, NULL, 47, 1, NULL, 1, '2018-09-27 20:34:59', '2018-09-27 20:34:59'),
(146, 443, 'Lowell Thiel', NULL, NULL, 14, 0, NULL, 0, '2018-09-27 20:34:59', '2018-09-27 20:34:59'),
(147, 396, 'Ocie Bruen', NULL, NULL, 74, 1, NULL, 0, '2018-09-27 20:34:59', '2018-09-27 20:34:59'),
(148, 450, 'Destini Padberg', NULL, NULL, 136, 1, NULL, 1, '2018-09-27 20:34:59', '2018-09-27 20:34:59'),
(149, 351, 'Herta Gleason DVM', NULL, NULL, 45, 1, NULL, 0, '2018-09-27 20:34:59', '2018-09-27 20:34:59'),
(150, 323, 'Lou Crooks', NULL, NULL, 26, 1, NULL, 1, '2018-09-27 20:34:59', '2018-09-27 20:34:59'),
(151, 414, 'Ursula Beer', NULL, NULL, 135, 0, NULL, 0, '2018-09-27 20:34:59', '2018-09-27 20:34:59'),
(152, 433, 'Thalia McDermott', NULL, NULL, 139, 0, NULL, 1, '2018-09-27 20:34:59', '2018-09-27 20:34:59'),
(153, 366, 'Mrs. Litzy Koss', NULL, NULL, 147, 0, NULL, 0, '2018-09-27 20:34:59', '2018-09-27 20:34:59');

-- --------------------------------------------------------

--
-- Table structure for table `user_workshop`
--

CREATE TABLE IF NOT EXISTS `user_workshop` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int(11) UNSIGNED NOT NULL,
  `workshop_id` int(11) UNSIGNED NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0: Active / 1: Inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_user_workshop_workshops1_idx` (`workshop_id`),
  KEY `fk_user_workshop_users1_idx` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_workshop`
--

INSERT INTO `user_workshop` (`id`, `user_id`, `workshop_id`, `status`, `created_at`, `updated_at`) VALUES
(7, 1, 1, 1, '2018-09-26 19:25:15', '2018-09-26 19:26:11');

-- --------------------------------------------------------

--
-- Table structure for table `visits`
--

CREATE TABLE IF NOT EXISTS `visits` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `place_id` int(11) UNSIGNED NOT NULL,
  `program_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `visit_type_id` int(11) UNSIGNED NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'Description of activities that will be do in the visit',
  `observations` text COLLATE utf8_unicode_ci COMMENT 'Visit findings',
  `date` datetime DEFAULT NULL,
  `contact` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact_phone` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-any, 1-review, 2-advisory, 3-support',
  `status` tinyint(4) NOT NULL DEFAULT '2' COMMENT '0-Canceled, 1-Approved, 2-Pending, 3-Complete',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_visits_places1_idx` (`place_id`),
  KEY `fk_visits_programs1_idx` (`program_id`),
  KEY `fk_visits_visit_types1_idx` (`visit_type_id`),
  KEY `fk_visits_users1_idx` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `visits`
--

INSERT INTO `visits` (`id`, `place_id`, `program_id`, `user_id`, `visit_type_id`, `description`, `observations`, `date`, `contact`, `contact_phone`, `type`, `status`, `created_at`, `updated_at`) VALUES
(2, 1, 1, 1, 2, 'Lorem inpsum', NULL, NULL, NULL, NULL, 1, 1, '2018-09-27 14:08:16', '2018-09-27 14:08:16');

-- --------------------------------------------------------

--
-- Table structure for table `visit_files`
--

CREATE TABLE IF NOT EXISTS `visit_files` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `visit_id` int(11) UNSIGNED NOT NULL,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_visit_files_visits1_idx` (`visit_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `visit_files`
--

INSERT INTO `visit_files` (`id`, `visit_id`, `name`, `url`, `created_at`, `updated_at`) VALUES
(3, 2, 'Informe test', 'QPUWFKYRCA_20180927090955.pdf', '2018-09-27 14:09:56', '2018-09-27 14:09:56');

-- --------------------------------------------------------

--
-- Table structure for table `visit_types`
--

CREATE TABLE IF NOT EXISTS `visit_types` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-Inactive, 1-Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `visit_types`
--

INSERT INTO `visit_types` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(2, 'Tipo 1', 0, '2018-09-25 14:45:57', '2018-09-25 14:46:17');

-- --------------------------------------------------------

--
-- Stand-in structure for view `v_contents`
-- (See below for the actual view)
--
DROP VIEW IF EXISTS `v_contents`;
CREATE TABLE IF NOT EXISTS `v_contents` (
`id` int(11) unsigned
,`name` varchar(100)
,`theme_id` int(11) unsigned
,`theme_name` varchar(100)
,`course_id` int(11) unsigned
,`course_name` varchar(100)
,`tags` varchar(100)
,`type` tinyint(4)
,`type_name` varchar(9)
,`status` tinyint(4)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `v_courses`
-- (See below for the actual view)
--
DROP VIEW IF EXISTS `v_courses`;
CREATE TABLE IF NOT EXISTS `v_courses` (
`id` int(11) unsigned
,`formation_level_id` int(11) unsigned
,`formation_level_name` varchar(45)
,`user_id` int(11) unsigned
,`user_name` varchar(45)
,`name` varchar(100)
,`tags` varchar(100)
,`cover` varchar(255)
,`evaluable` tinyint(4)
,`status` tinyint(4)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `v_evaluations`
-- (See below for the actual view)
--
DROP VIEW IF EXISTS `v_evaluations`;
CREATE TABLE IF NOT EXISTS `v_evaluations` (
`id` int(11) unsigned
,`type_name` varchar(105)
,`description` text
,`attempts` tinyint(4)
,`approved_with` int(11)
,`time` float
,`complexity` enum('low','regular','expert','pro')
,`status` tinyint(4)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `v_experts`
-- (See below for the actual view)
--
DROP VIEW IF EXISTS `v_experts`;
CREATE TABLE IF NOT EXISTS `v_experts` (
`id` int(11) unsigned
,`user_id` int(11) unsigned
,`user_name` varchar(45)
,`profession` varchar(100)
,`phone` varchar(45)
,`address` varchar(100)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `v_institutions`
-- (See below for the actual view)
--
DROP VIEW IF EXISTS `v_institutions`;
CREATE TABLE IF NOT EXISTS `v_institutions` (
`id` int(11) unsigned
,`name` varchar(100)
,`city_id` int(11) unsigned
,`city_name` varchar(45)
,`status` tinyint(4)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `v_project_users`
-- (See below for the actual view)
--
DROP VIEW IF EXISTS `v_project_users`;
CREATE TABLE IF NOT EXISTS `v_project_users` (
`id` int(11) unsigned
,`project_id` int(11) unsigned
,`user_id` int(11) unsigned
,`user_name` varchar(45)
,`status` tinyint(4)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `v_queries`
-- (See below for the actual view)
--
DROP VIEW IF EXISTS `v_queries`;
CREATE TABLE IF NOT EXISTS `v_queries` (
`id` int(11) unsigned
,`content_id` int(11) unsigned
,`content_name` varchar(100)
,`user_id` int(11) unsigned
,`user_name` varchar(45)
,`question` varchar(100)
,`description` text
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `v_themes`
-- (See below for the actual view)
--
DROP VIEW IF EXISTS `v_themes`;
CREATE TABLE IF NOT EXISTS `v_themes` (
`id` int(11) unsigned
,`course_id` int(11) unsigned
,`course_name` varchar(100)
,`name` varchar(100)
,`tags` varchar(100)
,`evaluable` tinyint(4)
,`status` tinyint(4)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `v_users`
-- (See below for the actual view)
--
DROP VIEW IF EXISTS `v_users`;
CREATE TABLE IF NOT EXISTS `v_users` (
`id` int(11) unsigned
,`role_id` varchar(10)
,`role_name` varchar(191)
,`formation_level_id` int(11) unsigned
,`formation_level_name` varchar(45)
,`place_id` int(11) unsigned
,`place_name` varchar(100)
,`name` varchar(45)
,`email` varchar(64)
,`phone` varchar(45)
,`document_number` varchar(20)
,`notifications` tinyint(4)
,`status` tinyint(4)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `v_visits`
-- (See below for the actual view)
--
DROP VIEW IF EXISTS `v_visits`;
CREATE TABLE IF NOT EXISTS `v_visits` (
`id` int(11) unsigned
,`place_id` int(11) unsigned
,`place_name` varchar(100)
,`program_id` int(11) unsigned
,`program_name` varchar(100)
,`user_id` int(11) unsigned
,`user_name` varchar(45)
,`visit_type_id` int(11) unsigned
,`visit_type_name` varchar(45)
,`date` datetime
,`contact` varchar(45)
,`contact_phone` varchar(45)
,`type` tinyint(4)
,`status` tinyint(4)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `v_workshops`
-- (See below for the actual view)
--
DROP VIEW IF EXISTS `v_workshops`;
CREATE TABLE IF NOT EXISTS `v_workshops` (
`id` int(11) unsigned
,`city_id` int(11) unsigned
,`city_name` varchar(45)
,`program_id` int(11) unsigned
,`program_name` varchar(100)
,`name` varchar(100)
,`date` date
,`status` tinyint(4)
);

-- --------------------------------------------------------

--
-- Table structure for table `workshops`
--

CREATE TABLE IF NOT EXISTS `workshops` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `city_id` int(11) UNSIGNED NOT NULL,
  `program_id` int(11) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `date` date DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-Inactive, 1-Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_workshops_programs1_idx` (`program_id`),
  KEY `fk_workshops_cities1_idx` (`city_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `workshops`
--

INSERT INTO `workshops` (`id`, `city_id`, `program_id`, `name`, `description`, `date`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'Taller 2', NULL, '2018-08-26', 1, '2018-09-26 16:00:49', '2018-09-26 16:00:49');

-- --------------------------------------------------------

--
-- Structure for view `v_contents`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_contents`  AS  select `contents`.`id` AS `id`,`contents`.`name` AS `name`,`contents`.`theme_id` AS `theme_id`,`themes`.`name` AS `theme_name`,`courses`.`id` AS `course_id`,`courses`.`name` AS `course_name`,`contents`.`tags` AS `tags`,`contents`.`type` AS `type`,(case when (`contents`.`type` = 1) then 'Video' when (`contents`.`type` = 2) then 'Documento' when (`contents`.`type` = 3) then 'Galería' when (`contents`.`type` = 3) then 'Artículo' end) AS `type_name`,`contents`.`status` AS `status` from ((`contents` join `themes` on((`themes`.`id` = `contents`.`theme_id`))) join `courses` on((`courses`.`id` = `themes`.`course_id`))) ;

-- --------------------------------------------------------

--
-- Structure for view `v_courses`
--

-- --------------------------------------------------------

--
-- Structure for view `v_evaluations`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_evaluations`  AS  select `evaluations`.`id` AS `id`,if(isnull(`evaluations`.`theme_id`),concat(`courses`.`name`,'Curso'),concat(`themes`.`name`,'Tema')) AS `type_name`,`evaluations`.`description` AS `description`,`evaluations`.`attempts` AS `attempts`,`evaluations`.`approved_with` AS `approved_with`,`evaluations`.`time` AS `time`,`evaluations`.`complexity` AS `complexity`,`evaluations`.`status` AS `status` from ((`evaluations` join `courses` on((`courses`.`id` = `evaluations`.`course_id`))) left join `themes` on((`themes`.`id` = `evaluations`.`theme_id`))) ;

-- --------------------------------------------------------

--
-- Structure for view `v_experts`
--

-- --------------------------------------------------------

--
-- Structure for view `v_institutions`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_institutions`  AS  select `institutions`.`id` AS `id`,`institutions`.`name` AS `name`,`institutions`.`city_id` AS `city_id`,`cities`.`name` AS `city_name`,`institutions`.`status` AS `status` from (`institutions` join `cities` on((`cities`.`id` = `institutions`.`city_id`))) ;

-- --------------------------------------------------------

--
-- Structure for view `v_project_users`
--

-- --------------------------------------------------------

--
-- Structure for view `v_queries`
--

-- --------------------------------------------------------

--
-- Structure for view `v_themes`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_themes`  AS  select `themes`.`id` AS `id`,`themes`.`course_id` AS `course_id`,`courses`.`name` AS `course_name`,`themes`.`name` AS `name`,`themes`.`tags` AS `tags`,`themes`.`evaluable` AS `evaluable`,`themes`.`status` AS `status` from (`themes` join `courses` on((`courses`.`id` = `themes`.`course_id`))) ;

-- --------------------------------------------------------

--
-- Structure for view `v_users`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_users`  AS  select `users`.`id` AS `id`,coalesce(`roles`.`id`,'') AS `role_id`,coalesce(`roles`.`name`,'') AS `role_name`,`users`.`formation_level_id` AS `formation_level_id`,`formation_levels`.`name` AS `formation_level_name`,`users`.`place_id` AS `place_id`,`places`.`name` AS `place_name`,`users`.`name` AS `name`,`users`.`email` AS `email`,`users`.`phone` AS `phone`,`users`.`document_number` AS `document_number`,`users`.`notifications` AS `notifications`,`users`.`status` AS `status` from ((((`users` left join `formation_levels` on((`formation_levels`.`id` = `users`.`formation_level_id`))) left join `places` on((`places`.`id` = `users`.`place_id`))) left join `model_has_roles` on((`model_has_roles`.`model_id` = `users`.`id`))) left join `roles` on((`roles`.`id` = `model_has_roles`.`role_id`))) ;

-- --------------------------------------------------------

--
-- Structure for view `v_visits`
--

-- --------------------------------------------------------

--
-- Structure for view `v_workshops`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_workshops`  AS  select `workshops`.`id` AS `id`,`workshops`.`city_id` AS `city_id`,`cities`.`name` AS `city_name`,`workshops`.`program_id` AS `program_id`,`programs`.`name` AS `program_name`,`workshops`.`name` AS `name`,`workshops`.`date` AS `date`,`workshops`.`status` AS `status` from ((`workshops` join `cities` on((`cities`.`id` = `workshops`.`city_id`))) join `programs` on((`programs`.`id` = `workshops`.`program_id`))) ;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `answers`
--
ALTER TABLE `answers`
  ADD CONSTRAINT `fk_answers_questions1` FOREIGN KEY (`question_id`) REFERENCES `questions` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `comments`
--
ALTER TABLE `comments`
  ADD CONSTRAINT `fk_comments_comments1` FOREIGN KEY (`comment_id`) REFERENCES `comments` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_comments_projects1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `contents`
--
ALTER TABLE `contents`
  ADD CONSTRAINT `fk_contents_themes1` FOREIGN KEY (`theme_id`) REFERENCES `themes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `courses`
--
ALTER TABLE `courses`
  ADD CONSTRAINT `fk_courses_formation_levels1` FOREIGN KEY (`formation_level_id`) REFERENCES `formation_levels` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_courses_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `course_timeline`
--
ALTER TABLE `course_timeline`
  ADD CONSTRAINT `fk_course_timeline_course_user1` FOREIGN KEY (`course_user_id`) REFERENCES `course_user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `course_user`
--
ALTER TABLE `course_user`
  ADD CONSTRAINT `fk_course_user_courses1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_course_user_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `documents`
--
ALTER TABLE `documents`
  ADD CONSTRAINT `fk_documents_projects1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_documents_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `evaluations`
--
ALTER TABLE `evaluations`
  ADD CONSTRAINT `fk_evaluations_courses1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_evaluations_themes1` FOREIGN KEY (`theme_id`) REFERENCES `themes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `evaluation_user`
--
ALTER TABLE `evaluation_user`
  ADD CONSTRAINT `fk_evaluation_user_evaluations1` FOREIGN KEY (`evaluation_id`) REFERENCES `evaluations` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_evaluation_user_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `evaluation_user_answers`
--
ALTER TABLE `evaluation_user_answers`
  ADD CONSTRAINT `fk_evaluation_user_answers_answers1` FOREIGN KEY (`answer_id`) REFERENCES `answers` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_evaluation_user_answers_evaluation_user1` FOREIGN KEY (`evaluation_user_id`) REFERENCES `evaluation_user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_evaluation_user_answers_questions1` FOREIGN KEY (`question_id`) REFERENCES `questions` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `experts`
--
ALTER TABLE `experts`
  ADD CONSTRAINT `fk_experts_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `expert_thematic`
--
ALTER TABLE `expert_thematic`
  ADD CONSTRAINT `fk_expert_thematic_experts1` FOREIGN KEY (`expert_id`) REFERENCES `experts` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_expert_thematic_thematics1` FOREIGN KEY (`thematic_id`) REFERENCES `thematics` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `institutions`
--
ALTER TABLE `institutions`
  ADD CONSTRAINT `fk_institutions_cities1` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `notifications`
--
ALTER TABLE `notifications`
  ADD CONSTRAINT `fk_notifications_users1` FOREIGN KEY (`from_user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_notifications_users2` FOREIGN KEY (`to_user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `places`
--
ALTER TABLE `places`
  ADD CONSTRAINT `fk_places_institutions1` FOREIGN KEY (`institution_id`) REFERENCES `institutions` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `project_contents`
--
ALTER TABLE `project_contents`
  ADD CONSTRAINT `fk_project_contents_projects1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_project_contents_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `project_user`
--
ALTER TABLE `project_user`
  ADD CONSTRAINT `fk_project_user_projects1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_project_user_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `queries`
--
ALTER TABLE `queries`
  ADD CONSTRAINT `fk_queries_contents1` FOREIGN KEY (`content_id`) REFERENCES `contents` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_queries_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `questions`
--
ALTER TABLE `questions`
  ADD CONSTRAINT `fk_questions_evaluations1` FOREIGN KEY (`evaluation_id`) REFERENCES `evaluations` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `ratings`
--
ALTER TABLE `ratings`
  ADD CONSTRAINT `fk_ratings_projects1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_ratings_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `replies`
--
ALTER TABLE `replies`
  ADD CONSTRAINT `fk_replies_queries1` FOREIGN KEY (`query_id`) REFERENCES `queries` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `thematic_answers`
--
ALTER TABLE `thematic_answers`
  ADD CONSTRAINT `fk_thematic_answers_thematic_questions1` FOREIGN KEY (`thematic_question_id`) REFERENCES `thematic_questions` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_thematic_answers_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `thematic_questions`
--
ALTER TABLE `thematic_questions`
  ADD CONSTRAINT `fk_thematic_questions_thematics1` FOREIGN KEY (`thematic_id`) REFERENCES `thematics` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_thematic_questions_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `themes`
--
ALTER TABLE `themes`
  ADD CONSTRAINT `fk_themes_courses1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `user_workshop`
--
ALTER TABLE `user_workshop`
  ADD CONSTRAINT `fk_user_workshop_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_user_workshop_workshops1` FOREIGN KEY (`workshop_id`) REFERENCES `workshops` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `visits`
--
ALTER TABLE `visits`
  ADD CONSTRAINT `fk_visits_places1` FOREIGN KEY (`place_id`) REFERENCES `places` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_visits_programs1` FOREIGN KEY (`program_id`) REFERENCES `programs` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_visits_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_visits_visit_types1` FOREIGN KEY (`visit_type_id`) REFERENCES `visit_types` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `visit_files`
--
ALTER TABLE `visit_files`
  ADD CONSTRAINT `fk_visit_files_visits1` FOREIGN KEY (`visit_id`) REFERENCES `visits` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `workshops`
--
ALTER TABLE `workshops`
  ADD CONSTRAINT `fk_workshops_cities1` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_workshops_programs1` FOREIGN KEY (`program_id`) REFERENCES `programs` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
COMMIT;

