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

START TRANSACTION;



--
-- Database: `laravel_ats`
--

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

--
-- Table structure for table `candidates`
--

CREATE TABLE `candidates` (
  `candidate_id` int(10) UNSIGNED NOT NULL,
  `is_hot` int(11) DEFAULT 0,
  `is_public` int(11) DEFAULT 0,
  `is_active` int(11) DEFAULT NULL,
  `can_relocate` int(11) DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `middle_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_home` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_cell` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_work` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pincode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `key_skills` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email1` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email2` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_pay` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desired_pay` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `best_time_to_call` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resume` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_available` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `candidates`
--

INSERT INTO `candidates` (`candidate_id`, `is_hot`, `is_public`, `is_active`, `can_relocate`, `first_name`, `middle_name`, `last_name`, `phone_home`, `phone_cell`, `phone_work`, `address`, `city`, `state`, `pincode`, `notes`, `key_skills`, `owner`, `email1`, `email2`, `website`, `gender`, `current_pay`, `desired_pay`, `best_time_to_call`, `resume`, `date_available`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES
(1, 0, 0, NULL, NULL, 'Pattie Collins', 'Mrs. Brenda Oberbrunner III', 'Horace Gottlieb', 'Dr. Lew Sawayn Sr.', 'Cecile Yundt', 'Walton Swaniawski', 'Dr. Juliana Schoen Jr.', 'Kitty Ziemann', 'Caleigh Sawayn', 'Providenci Bode DDS', 'Dexter Rempel V', 'Laurence Kuphal', 'Talia Wehner', 'Amiya Schroeder', 'Nash Smith', 'Maritza Quigley', 'Delphia Emmerich V', 'Mr. Willis O\'Hara', 'Coy Stehr DVM', 'Orland Kessler', 'Prof. Jess Christiansen', '2002-08-16', '2023-02-14 04:59:00', '2023-02-19 02:05:45', '2023-02-19 02:05:45', NULL, NULL, 1),
(2, 0, 0, NULL, NULL, 'Citlalli Hackett', 'Prof. Emmalee Koch Sr.', 'Dr. Ashlee Cummings IV', 'Isobel Ankunding II', 'Darryl Mayer', 'Drew O\'Kon', 'Ms. Daisha Adams', 'Abigale Lehner', 'Prof. Amya Stokes I', 'Mariah Murphy', 'Elda Simonis', 'Miss Letitia O\'Reilly', 'Kory Batz MD', 'Ladarius Schowalter', 'Gerard Wintheiser', 'Mrs. Myrtis Schroeder', 'Vernice Kertzmann', 'Rolando Smitham', 'Lauriane Torphy V', 'Mrs. Dayana Kris Jr.', 'Ola Osinski III', '1984-09-14', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(3, 0, 0, NULL, NULL, 'Dr. Joel Goldner Sr.', 'Nedra Bernhard', 'Vella Purdy', 'Clarabelle Balistreri', 'Cielo Kulas', 'Maximus Schneider V', 'Kurt Abshire', 'Trycia Goyette', 'Casimer Predovic Jr.', 'Lulu Mosciski', 'Eloisa Lemke', 'Nicolette Daugherty', 'Matilda Zemlak', 'Mr. Josiah Sauer III', 'Prof. Okey Brekke IV', 'Armand Weimann Jr.', 'Lucile Marvin', 'Nikolas Roob', 'Sharon Bosco', 'Kathleen Armstrong', 'Mr. Judd Mraz', '1979-01-13', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(4, 0, 0, NULL, NULL, 'Mr. Saige Bartell PhD', 'Lucinda Gleichner', 'Amely Langworth', 'Ettie Ernser PhD', 'Nat Schmeler', 'Mr. Adrain O\'Hara MD', 'Tyra Lynch Jr.', 'Litzy Douglas', 'Woodrow Gleason', 'Deion Barrows', 'Trever Robel', 'Josh Luettgen', 'Mrs. Beulah Larkin I', 'Carlie Pagac', 'Hailey Raynor II', 'Dr. Bret Johnson I', 'Pierre Parker', 'Roxanne Brakus', 'Prof. Webster Hettinger', 'Toy Prosacco', 'Prof. Ora Treutel', '1987-01-03', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(5, 0, 0, NULL, NULL, 'Wilhelmine Rolfson', 'Prof. Miguel Cole III', 'Keira Hickle V', 'Ms. Vilma Robel', 'Ms. Anjali Lowe MD', 'Sandra Kunze PhD', 'Mr. Jamar Lakin', 'Isadore Upton I', 'Wilma Rice', 'Mrs. Willow Walter', 'Mrs. Cassidy Sauer V', 'Mr. Berry Ondricka DVM', 'Shanon Rath', 'Irma Marquardt', 'Prof. Brenden Denesik DDS', 'Willie Brakus DVM', 'Pearl Bailey', 'Marco Von I', 'Enos Mohr DVM', 'Norbert Hills', 'Demario Kuhn', '1987-08-17', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(6, 0, 0, NULL, NULL, 'Prof. Johnny Windler II', 'Miss Aglae Nader', 'Esmeralda Muller', 'Crystel Hackett III', 'Cullen Schamberger', 'Prof. Noble Orn', 'Ashlynn Dietrich', 'Benjamin Lueilwitz', 'Myah Brakus', 'Johnpaul Huel DDS', 'Prof. Sage Fay', 'Anthony McCullough', 'Myrtle Shields', 'Prof. Morton Metz', 'Mia Schulist', 'Melissa Jakubowski', 'Meggie Muller', 'Frederique Walker', 'Omer Rogahn DVM', 'Mr. Boyd Padberg', 'Garrick D\'Amore', '2018-02-01', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(7, 0, 0, NULL, NULL, 'Aubree Walsh', 'Ms. Jaclyn Bradtke V', 'Prof. Perry Sporer III', 'Karlie Bode', 'Lucy Stanton', 'Chaz Cruickshank', 'Mekhi Greenholt II', 'Randall Ruecker', 'Gay Reinger II', 'Jackeline Kilback', 'Justyn Crona', 'Breanne Murray', 'Deontae Lakin', 'Florine Moore', 'Mireille Aufderhar', 'Kory Ryan', 'Delilah Boehm', 'Dr. Braden Mitchell PhD', 'Prof. Enola Klein PhD', 'Dr. Charlotte Doyle', 'Rosendo Abernathy', '2020-01-22', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(8, 0, 0, NULL, NULL, 'Brock Fay', 'Matt Hirthe', 'Althea Jaskolski', 'Lily Nolan', 'Mrs. Clementine Leannon', 'Joesph Olson', 'Grayson Erdman', 'Ms. Etha Muller', 'Mr. Dylan Kris', 'Dr. Rylan Volkman MD', 'Aimee King', 'Rosella Yundt', 'Georgiana Larkin', 'Cara McClure', 'Beatrice Carroll', 'Montana Kuhic', 'Jovanny Hermann', 'Cooper Renner', 'Gino Yundt', 'Danny Howell', 'Dashawn Quigley', '2006-11-14', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(9, 0, 0, NULL, NULL, 'Scot Abernathy', 'Georgette Effertz', 'Francisca Leuschke', 'Mrs. Elissa Carter Jr.', 'Mrs. Damaris Kerluke III', 'Kale Huels', 'Jaida O\'Connell', 'Brandon Boyer', 'Burnice Nienow', 'Ofelia Ryan', 'Candida Conn', 'Felipe Gerhold', 'Prof. George Dooley I', 'Vesta Gottlieb DDS', 'Dr. Raphaelle Wehner II', 'Clotilde VonRueden', 'Grady Block', 'Orpha Feil', 'Ms. Valentine Quitzon', 'Mr. Napoleon Howell I', 'Glennie Howell', '2022-06-08', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(10, 0, 0, NULL, NULL, 'Jaquan Lynch', 'Lila Kuhlman', 'Elisabeth Conroy', 'Adolph Langosh V', 'Julianne Wehner', 'Max Pfannerstill', 'Leonel Rolfson', 'Ferne Welch', 'Kailee Johnson Jr.', 'Ms. Viviane Blick MD', 'Prof. Laura Wolff IV', 'Dora Lowe', 'Jan Hyatt', 'Stefan Rogahn', 'Michael Parisian', 'Isadore Koss', 'Dr. Cullen Weissnat PhD', 'Nicole Stanton', 'Winnifred Roberts', 'Melisa Zieme', 'Rico O\'Keefe', '1986-08-12', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(11, 0, 0, NULL, NULL, 'Erin McCullough', 'Velva Maggio', 'Kimberly Kessler', 'Larue Nicolas', 'Steve Heaney', 'Herminio Gleason', 'Joesph Dickinson', 'Dr. Demario Ryan', 'Ollie Blick', 'Howard Lowe', 'Prof. Donato Wehner Jr.', 'Talia Homenick', 'Herta Mitchell', 'Idell Lowe', 'Aileen Schmitt MD', 'Ms. Elna Schultz', 'Alivia Schroeder', 'Chasity Boyer', 'Kennith Ritchie', 'Hassan Flatley', 'Christa Haag', '1980-10-14', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(12, 0, 0, NULL, NULL, 'Prof. Derrick Von', 'Trey Farrell', 'Mr. Pietro Bernier III', 'Ms. Alanis Schuppe', 'Miss Viola Wolff', 'Stephan Bode', 'Mrs. Mabel Bartoletti', 'Prof. Elaina Gerhold', 'Reanna D\'Amore', 'Polly Kihn', 'Uriel Ortiz', 'Terrence Swaniawski', 'Damien Senger', 'Miss Missouri Gibson IV', 'Mabel McKenzie', 'Adrianna Marvin', 'Adelbert Hills MD', 'Fatima Quigley', 'Marcelina Collier', 'Grover Zulauf', 'Madelynn Emmerich', '1974-09-12', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(13, 0, 0, NULL, NULL, 'Israel Boehm', 'Mrs. Ila Kessler Jr.', 'Camylle Kerluke', 'Torey Grimes', 'Easton O\'Kon IV', 'Newton Rau', 'Tina Stamm II', 'Gerhard Hickle', 'Mr. Ryley Emard PhD', 'Tobin Sporer', 'Fern Kilback', 'Mr. Gust Stamm III', 'Dr. Karine Quitzon', 'Mr. Jordan O\'Kon', 'Dr. Gabe Nader I', 'Kameron Boehm V', 'Ariel Torp', 'Marvin Swift V', 'Pat Lemke V', 'Connor Yost', 'Susie Auer', '2008-08-20', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(14, 0, 0, NULL, NULL, 'Akeem Mitchell DDS', 'Ms. Katarina Reichel MD', 'Mr. Jess Halvorson III', 'Reuben Macejkovic', 'Malvina Altenwerth DVM', 'Mr. Chadd Reinger I', 'Pascale Hilpert', 'Prof. Emmanuelle Hammes', 'Jerod Quigley', 'Mrs. Laurie Treutel', 'Anderson Hagenes', 'Braeden Monahan MD', 'Mekhi Hill', 'Prof. Cathrine Bechtelar IV', 'Prof. Sylvester Kessler I', 'Clair Lockman', 'Elena Kautzer Jr.', 'Maggie Gusikowski', 'Ricardo Schmitt', 'Miss Lela Dibbert III', 'Jaden Fritsch', '1994-07-29', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(15, 0, 0, NULL, NULL, 'Dr. Brandi Terry MD', 'Adella Blick', 'Carlee Abbott', 'Murray Cartwright', 'Madonna Haley', 'Alyce Breitenberg', 'Mr. Gus Gleason', 'Linnea Stracke', 'Xavier Reinger', 'Verlie Rohan', 'Dillan Trantow', 'Greyson Schneider', 'Brett Hammes', 'Carol Botsford', 'Mr. Josiah Prosacco Jr.', 'Mr. Caleb Wilkinson Jr.', 'Modesto Wisoky', 'Sammy Hartmann', 'Ms. Constance Tromp DDS', 'Roxanne Feeney', 'Dr. Kyleigh Schuster', '2006-10-31', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(16, 0, 0, NULL, NULL, 'Dr. Adrian Feeney', 'Beverly Raynor', 'Prof. Bartholome Cassin', 'Zita Jerde', 'Colin Bahringer DVM', 'Mrs. Yasmeen Breitenberg II', 'Prof. Scotty Fay', 'Sid Wisoky', 'Jeremy Koch', 'Prof. Eden Johns DVM', 'Coleman Kessler', 'Oliver Crist', 'Dr. Joyce Cummings Sr.', 'Nola Dach', 'Lula Buckridge', 'Julie Sawayn', 'Ms. Eulah Grimes II', 'Giuseppe Greenholt', 'Erin Reilly', 'Althea Kunde PhD', 'Miss Jaida Effertz MD', '1978-04-19', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(17, 0, 0, NULL, NULL, 'Prof. Emelie O\'Connell V', 'Duncan Schinner', 'Jettie Bahringer', 'Marlee Padberg', 'Tyson Harvey', 'Mr. Josiah Collier', 'Faustino Harvey', 'Emmet Hackett', 'Linwood Simonis Jr.', 'Cameron Carroll', 'Tevin Collier PhD', 'Krystina Kling V', 'Estevan Hartmann', 'Jaime Kirlin', 'Victoria Heller', 'Erwin Aufderhar', 'Prof. Westley Huel', 'Jo Nicolas', 'Ayana Lindgren', 'Prof. Micah Anderson MD', 'Lera O\'Keefe', '2001-01-11', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(18, 0, 0, NULL, NULL, 'Levi Beier Jr.', 'Joy Langosh', 'Neha Wuckert', 'Mrs. Eliane Kunde', 'Claire Stark', 'Jamie Schulist', 'Denis Lesch', 'Prof. Rogelio Pfannerstill', 'Dr. Bette D\'Amore', 'Irving Kshlerin', 'Tony Aufderhar', 'Claudie Pagac', 'Mollie Gulgowski', 'Dr. Madelynn McCullough', 'Rick Rolfson', 'Jameson Langosh', 'Nathen Hills', 'Dr. Edgar Dickinson', 'Dr. Chris Wisozk III', 'Roxanne King I', 'Sandy Streich', '2017-01-29', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(19, 0, 0, NULL, NULL, 'Jayda Dietrich III', 'Fermin Ullrich V', 'Sebastian Nader IV', 'Ms. Abby Beier', 'Otilia Weissnat', 'Mrs. Eloise Runolfsson', 'Prof. Meagan Ankunding Jr.', 'Mr. Demarco VonRueden V', 'Jerald Fisher', 'Dr. Ladarius Goldner III', 'Marley Mayer', 'Mr. Jordi Bergnaum DVM', 'Mr. Jed Parisian', 'Erwin Smitham', 'Mr. Walter Terry', 'Evie Cole IV', 'Prof. Kathryne Orn IV', 'Maria Bergstrom', 'Una Feeney', 'Dr. Destini Mertz V', 'Dr. Kayley Daniel III', '2019-04-05', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(20, 0, 0, NULL, NULL, 'Keyon Cremin', 'Prof. Adolf Nicolas', 'Rosario Wolff', 'Zita Koepp', 'Arden Kautzer', 'Mr. Korey Torphy DDS', 'Prof. Evan Daugherty', 'Estella Hodkiewicz', 'Haskell Dach', 'Willis Satterfield', 'Dr. Mike Satterfield I', 'Aiden Klein', 'Cassie McDermott', 'Cecelia Durgan', 'Prof. Esteban Lesch Sr.', 'Dr. Pablo Johnson', 'Lionel Wintheiser II', 'Junior Bradtke', 'Prof. Dina Parker', 'Ms. Elnora Gleason DDS', 'Clotilde Orn MD', '1999-01-11', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(21, 0, 0, NULL, NULL, 'Emmy Labadie', 'Dr. Ciara Gerlach Sr.', 'Oswald Kshlerin', 'Prof. Tina Larson', 'Ronaldo Roob', 'Ms. Ashtyn Little Sr.', 'Aiden Hoppe', 'Larissa Powlowski', 'Spencer Lesch', 'Terrance Lang', 'Elmo Bogisich', 'Emery Powlowski', 'Mr. Alfred Cormier Sr.', 'Emilia Hansen', 'Herbert Feest DVM', 'Gideon Rath', 'Doris Rohan', 'Selmer Johnson', 'Joanie Reilly', 'Weldon Fadel', 'Dr. Holly Senger I', '1981-02-25', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(22, 0, 0, NULL, NULL, 'Alba Okuneva', 'Dr. Claude Kuphal DVM', 'Dr. Heaven Simonis', 'Taylor Lang', 'Dr. Shanon Erdman III', 'Janice Dietrich V', 'Pearline Muller', 'Nick Marks', 'Effie Sanford', 'Prof. Jason Mueller', 'Skyla Gutmann PhD', 'Mossie Spencer III', 'Korbin Hermiston MD', 'Greta Howe', 'Willy Runolfsson', 'Pearlie Gislason', 'Prof. Jermey O\'Connell', 'Mr. Terence Beahan DVM', 'Mortimer Bernhard', 'Nolan Hauck Sr.', 'Prof. Keith Zemlak MD', '1974-10-11', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(23, 0, 0, NULL, NULL, 'Dion Barrows Sr.', 'Buster Corwin MD', 'Ms. Carlie Barton IV', 'Dr. Luther Green PhD', 'Finn Kautzer', 'Joaquin Moore', 'Sunny Walsh', 'Merle Jakubowski', 'Orie Legros', 'Rhiannon Morar DDS', 'Emmett Weissnat', 'Schuyler Conn MD', 'Juliet Becker', 'Gabe Moore', 'Dr. Stuart Okuneva I', 'Bartholome Bergstrom', 'Mr. Rod Walter', 'Jaron Tremblay', 'Mr. Zachary Bogisich', 'Lavern Hintz', 'Marco Rice', '1994-04-03', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(24, 0, 0, NULL, NULL, 'Mrs. Kelsie Stehr DDS', 'Blaise Howell', 'Abraham Hammes', 'Clement Torphy', 'Dean Cassin', 'Mattie Bradtke', 'Dudley Rippin', 'Ana Huels', 'Aron Berge', 'Naomi Beahan', 'Jeramy Johnston', 'Mr. Joey Hagenes DVM', 'Grace Stamm', 'Mrs. Marjory Williamson III', 'Mr. Jaron Dooley', 'Alysson Prosacco Sr.', 'Nia Gulgowski', 'Dr. Tremayne Hamill', 'Mr. Cody Sanford II', 'Prof. Kevin Dickens V', 'Melody Harvey', '2014-12-25', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(25, 0, 0, NULL, NULL, 'Mr. Hester Oberbrunner', 'Mr. Horace Corwin', 'Kara Considine', 'Immanuel Feeney', 'Maritza Boehm', 'Mara Jacobson', 'Laila Hauck DDS', 'Vivienne Cronin', 'Kacie Lindgren', 'Prof. Jailyn Bernier IV', 'Prof. Alexandra Gottlieb', 'Michael Willms', 'Mr. Hilario Kunze DVM', 'Jovani Turcotte', 'Ally Mayer', 'Katrina Jaskolski', 'Mr. Milford Bogan', 'Gisselle Spencer', 'Ms. Jaquelin Fisher DDS', 'Roberto Lockman MD', 'Dr. Terrance Feest', '2000-02-24', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(26, 0, 0, NULL, NULL, 'Dr. Vincenzo Strosin', 'Tracey Raynor', 'Mrs. Kathlyn Kohler', 'Hayley Ullrich', 'Ms. Brigitte Waters', 'Christop Kuphal', 'Mr. Micah Botsford DDS', 'Oliver Dibbert III', 'Joana Labadie', 'Magdalen Wehner', 'Miss Kailee Runolfsdottir', 'Mariah Kulas', 'Okey Hintz', 'Maya Buckridge', 'Prof. Chet Rippin', 'Prof. Jairo Bartoletti PhD', 'Jaida Gulgowski', 'Prof. Rosella Brown PhD', 'Mr. Webster Dicki', 'Dr. Jovany Koepp IV', 'Kenny Cummings', '2003-10-03', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(27, 0, 0, NULL, NULL, 'Mrs. Ozella Stroman', 'Raphaelle Mraz', 'Miss Vada Lockman I', 'Claudia Bogisich', 'Lelia Nitzsche', 'Vance Kilback', 'Brook Marquardt', 'Devyn Murazik DVM', 'Georgette Fadel', 'Mr. Kameron Feest', 'Moriah Paucek PhD', 'Kristy Nicolas V', 'Ephraim Greenfelder', 'Delphia Okuneva', 'Abdul Kohler', 'Shad McGlynn', 'Jeremy Schaefer', 'Margret Toy', 'Amber Armstrong Jr.', 'Jeanie Ledner', 'Estella Turner', '1974-08-14', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(28, 0, 0, NULL, NULL, 'Dahlia Hilpert', 'Elwyn Bosco', 'Dr. Clay Purdy III', 'Quinton Lang', 'Alaina DuBuque', 'Elliott Bednar', 'Ms. Michelle Ziemann', 'Prof. Janick Veum DDS', 'Prof. Horace Dicki', 'Rosamond Dicki', 'Antone Leuschke', 'Vladimir Shields', 'Mr. Gunnar Rogahn MD', 'Grover Lemke V', 'Clovis Schoen', 'Sabryna Beer PhD', 'Miss Jacklyn Ritchie III', 'Dr. Korbin Jacobi DDS', 'Cale McGlynn', 'Hallie Armstrong', 'Antonina Leffler Sr.', '2014-06-22', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(29, 0, 0, NULL, NULL, 'Cortez Schmitt', 'Allie Johnson', 'Prof. Nia Gutkowski Jr.', 'Prof. Joana Durgan Jr.', 'Prof. Dino Braun PhD', 'Nayeli Wunsch', 'Miss Kyla Daugherty V', 'Ellen Roberts', 'Dudley Ledner II', 'Dovie Kemmer', 'Dora Kirlin', 'Miss Dariana Bauch', 'Mozell Senger', 'Mr. Donnie Kulas IV', 'Jaunita Bahringer', 'Eliezer O\'Connell', 'Prof. Dane Bruen', 'Crawford Bayer', 'Viva Senger', 'Amely Eichmann', 'Prof. Jimmy Kessler', '2010-06-02', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(30, 0, 0, NULL, NULL, 'Mrs. Pattie Lebsack', 'Mr. Jeffrey Dare', 'Lowell Kertzmann DVM', 'Dr. Grayce Goodwin', 'Prof. Alisa Hyatt V', 'Princess Abshire III', 'Ellsworth Gaylord', 'Felicia Greenholt DDS', 'Rhea D\'Amore', 'Dena Fahey', 'Dr. Michael Harvey', 'Lillian Wiza', 'Mr. Milford Treutel', 'Flossie Runte', 'Miss Serenity Corkery', 'Kylie Doyle', 'Margarete Ondricka', 'Prof. Bert Stehr DDS', 'Stella Balistreri', 'Taurean Cartwright', 'Marcia Windler III', '1975-07-02', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(31, 0, 0, NULL, NULL, 'Odell Rogahn', 'Tracy Corwin', 'Mrs. Lucile Schinner', 'Oswaldo Beier', 'Jessika Koepp', 'Whitney Parisian DVM', 'Ms. Elva Beahan Sr.', 'Linnea Dickinson', 'Dr. Genesis Abbott II', 'Sigmund Heaney', 'Elwyn Emard', 'Damaris Feest', 'Providenci Conroy', 'Kaia Hills I', 'Felicita Herman', 'Antwon Jenkins', 'Autumn Howell Jr.', 'Janelle Pouros III', 'Elenora Walker II', 'Prof. Arely Barrows PhD', 'Reuben Ryan', '1971-01-29', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(32, 0, 0, NULL, NULL, 'Esmeralda Padberg', 'Ms. Cristal Reichert DDS', 'Mrs. Nelda Ferry I', 'Libbie Jast', 'Mrs. Celia Kshlerin', 'Wendell Balistreri', 'Julio Hamill IV', 'Baylee Denesik I', 'Brenden Mertz', 'Delbert Pfeffer', 'Gina Kovacek', 'Dr. Alexandro O\'Reilly', 'Tatyana Erdman', 'Ronaldo Hayes', 'Albert Quigley', 'Kari Mertz', 'Miss Pasquale Zieme I', 'Ms. Destiny Keeling IV', 'Ava Blick', 'Deondre Goodwin', 'Ralph Hauck', '1985-03-07', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(33, 0, 0, NULL, NULL, 'Dr. Monty Anderson', 'Prof. Maude Wyman I', 'Ms. Daphne Farrell', 'Mabelle Tromp', 'Prof. Derrick Turner I', 'Nils Schroeder', 'Cassandre Stracke', 'Christy Terry', 'Camden Balistreri', 'Horace Paucek', 'Mrs. Yolanda Leffler Jr.', 'Orrin Dickinson', 'Dr. Charlie Schinner DDS', 'Estell Stoltenberg V', 'Prof. Vernice Vandervort', 'Amari Mitchell', 'Monica Lockman', 'Lauriane Marks', 'Katrina Cummerata', 'Frieda Labadie PhD', 'Bria Boehm', '2011-11-30', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(34, 0, 0, NULL, NULL, 'Noemie Bashirian', 'Maida Medhurst', 'Felicita Nolan', 'Earlene Jones DDS', 'Guiseppe Moore', 'August Schaefer PhD', 'Werner Orn', 'Veronica Braun', 'Trevor Dicki', 'Mr. Fritz Kreiger I', 'Janiya McDermott', 'Ezekiel King', 'Juanita Russel', 'Katheryn Collier', 'Sarai Blanda', 'Joel Pfeffer', 'Miss Mayra Mann', 'Elsa Kris', 'Natalia Hickle', 'Royce Fay', 'Aracely Deckow', '2015-04-13', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(35, 0, 0, NULL, NULL, 'Prof. Lola Hermiston Jr.', 'Prof. Bud Moen', 'Adonis Macejkovic', 'Prof. Milan Thompson', 'Toby Wiegand', 'Winona Stroman', 'Kristin Smitham', 'Miss Gregoria Hahn DVM', 'Sigurd Cremin', 'Stefanie Funk', 'Lilian Schoen', 'Flo Conn Sr.', 'Gunner Klocko DVM', 'Alyce Kerluke', 'Bridgette O\'Kon', 'Melissa Keeling', 'Jeffery Lynch', 'Kavon White', 'Miss Sarai Casper I', 'Winona Becker', 'Fabiola Deckow', '1972-02-26', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(36, 0, 0, NULL, NULL, 'Otha Kutch', 'Cristina Bernier', 'Miss Maia Rosenbaum Sr.', 'Dr. Ike Simonis', 'Loyce Lindgren II', 'Mr. Emmanuel Harris', 'Prof. Eula Buckridge', 'Major Harvey', 'Albina Greenfelder', 'Antone Zulauf', 'Hortense Kulas', 'Mariah Hackett', 'Yesenia Altenwerth', 'Margaretta Kshlerin', 'Francis Crona', 'Prof. Rey Kilback', 'Prof. Jaydon Mayer DVM', 'Dr. Gerhard Mosciski', 'Jakob Wisoky', 'Ellie Champlin', 'Chanelle Baumbach', '1996-05-11', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(37, 0, 0, NULL, NULL, 'Prof. Josiah Harber', 'Miss Rita Ebert IV', 'Mariah Beer', 'Prof. Theron Hintz DDS', 'Mr. Brenden Collins V', 'Felix Wiegand', 'Amie Wyman', 'Miss Aliza Hauck PhD', 'Miss Brionna Ferry', 'Donavon Runolfsdottir', 'Fritz Volkman', 'Prof. Cristopher Kerluke', 'Jeremie Steuber', 'Jackson Hill', 'Marion Stamm', 'Joelle Lesch II', 'Isabelle King', 'Prof. Carmen Rice III', 'Ebony Carter', 'Dr. Juvenal Botsford', 'Federico Leuschke', '2018-05-13', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(38, 0, 0, NULL, NULL, 'Mireille Roberts', 'Alexandria Macejkovic', 'Rowan Monahan DVM', 'Ettie Schulist', 'Clifton Bosco', 'Dr. Juwan Zieme', 'Fiona Hettinger', 'Ivory Jacobs', 'Grayson Brekke', 'Jewel Kreiger', 'Ms. Camille Erdman', 'Dr. Rachael Turcotte', 'Hillard Nitzsche PhD', 'Aileen Dickens', 'Wilson Schneider Jr.', 'Laurine Parker', 'Berneice Gaylord', 'Augustus Koss', 'Prof. Laney Reinger', 'Beulah Ebert Sr.', 'Davion Kilback', '2012-11-23', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(39, 0, 0, NULL, NULL, 'Norwood Mraz DVM', 'Allene Medhurst', 'Christop Metz Sr.', 'Mr. Kim Bergstrom PhD', 'Bernie Padberg', 'Mr. Mckenna Corwin', 'Natasha Quigley I', 'Gaetano Schinner', 'Carley Carter', 'Dudley Waelchi', 'Salma Howell', 'Dr. Neva Greenholt', 'Ernest Lockman', 'Adelia Walsh', 'Michele Tromp', 'Katrina Anderson', 'Talon Ankunding V', 'Dasia Skiles', 'Miss Susanna Lehner', 'Athena Windler DVM', 'Odie Muller', '2007-11-07', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(40, 0, 0, NULL, NULL, 'Blaise Willms', 'Tanya Champlin', 'Mr. Cade Stoltenberg', 'Dr. Donny Funk IV', 'Kyra Haag', 'Delfina Aufderhar', 'Prof. Emile Stanton', 'Alda Stroman', 'Coby Stracke', 'Dr. Arne Hettinger', 'Darrell Schaefer', 'Danika Yundt', 'Domenica Howe', 'Bryon Will', 'Jordon Windler', 'Velva Hegmann', 'Nora Toy V', 'Dr. Verlie Prohaska', 'Prof. Grover Fadel DVM', 'Lydia Breitenberg', 'Dr. Giles Beatty I', '2017-07-01', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(41, 0, 0, NULL, NULL, 'Maci Reichel', 'Ms. Earline Greenholt IV', 'Barry Ullrich', 'Eleazar Dibbert V', 'Corbin Zemlak', 'Fae Block MD', 'Audra Goodwin', 'Jedidiah Nolan', 'Ruthie Sawayn', 'Mrs. Ramona Hermiston III', 'Mr. Stefan Yundt', 'Rosella Baumbach', 'Giuseppe Dickens V', 'Prof. Judy Hyatt', 'Dr. Lorenzo Berge Sr.', 'Carmine Bernhard', 'Gilbert Predovic', 'Percival Bednar', 'Shyanne Kris', 'Afton Keeling', 'Oral Dach', '2011-06-18', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(42, 0, 0, NULL, NULL, 'Wava Mertz', 'Steve Kuphal II', 'Donnell Corwin Sr.', 'Hipolito Borer', 'Prof. D\'angelo Davis DDS', 'Bella Turner MD', 'Dr. Hilma Leuschke', 'Tabitha Kassulke', 'Prof. Adriel Klein', 'Alyce Tillman', 'Miss Aniyah Stokes DVM', 'Malika Armstrong', 'Mr. Murphy Fisher', 'Millie Hermiston', 'Kylee Schamberger', 'Vena Emmerich', 'Alphonso Wunsch', 'Ransom Goyette MD', 'Miss Maybell Hudson MD', 'Jerel Rosenbaum', 'Graham Dach', '1992-09-19', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(43, 0, 0, NULL, NULL, 'Marianna Christiansen', 'Miss Zetta Kreiger', 'Cathrine Kerluke', 'Frankie Considine', 'Prof. Al Ullrich DDS', 'Malinda Ferry', 'Jessika Dibbert', 'Roxanne Shields', 'Naomi Crist IV', 'Jewell Langworth', 'Sebastian Bosco', 'Edna Kub V', 'Wanda Shanahan', 'Emmett Dare', 'Darby Ritchie', 'Ms. Tania Yundt', 'Gordon Weber', 'Libby Ziemann III', 'Arnaldo Rau', 'Mr. Miguel Hamill', 'Dr. Kirstin Haley', '2022-05-20', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(44, 0, 0, NULL, NULL, 'Kane Hammes I', 'Cecile Schowalter', 'Erna Haag', 'Brant Walter', 'Kristian Abbott', 'Carol Eichmann', 'Leo Carter', 'Lucienne Marvin', 'Mrs. Maryjane Brakus', 'Alisha Grant PhD', 'Ms. Macy Hansen IV', 'Dr. Billy Runte DDS', 'Benton Weber', 'Winifred Gleichner', 'Arnold Veum', 'Irving Dietrich', 'Prof. Alejandrin Kassulke', 'Hattie Funk', 'Alphonso Brekke', 'Marjorie Kuhn', 'Dimitri Schuster', '2003-01-12', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(45, 0, 0, NULL, NULL, 'Ms. Patsy Reichert IV', 'Dasia Carter', 'Cordell Haley', 'Cortez Greenfelder', 'Domenica Stanton', 'Johanna Kunze', 'Ava Hills', 'Enrico McDermott', 'Mr. Ron Bartell I', 'Shayna Sauer', 'Carolina Eichmann', 'Berry Lockman', 'Deja Kub', 'Jaiden Weimann', 'Miss Providenci Raynor', 'Nat Turcotte', 'Alicia Ruecker', 'Adalberto Armstrong', 'Mr. Jay Lynch DVM', 'Prof. Lelah Jacobi', 'Dr. Toney Abernathy IV', '1983-04-30', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(46, 0, 0, NULL, NULL, 'Edwin Stark II', 'Imogene Dare', 'Madison Moore', 'Mrs. Katlyn Batz', 'Brando Torp', 'Dr. Lessie Heaney Jr.', 'Geoffrey Kreiger', 'Lavern Konopelski', 'Mrs. Hettie Gerhold MD', 'Kira Heller', 'Dane Kovacek', 'Reva Hauck', 'Laron Larkin PhD', 'Yolanda Reichert', 'Ms. Sunny Lemke', 'Dr. Kyra Feeney DVM', 'Mertie Kuhn', 'Tanya Russel', 'Dr. Stephany Wilkinson III', 'Dr. Jacinthe Prohaska Sr.', 'Timmothy Casper Jr.', '1976-07-22', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(47, 0, 0, NULL, NULL, 'Guillermo Rosenbaum', 'Prof. Bailee Moen', 'Clemmie Trantow', 'Zoe Rolfson', 'Trent Bruen', 'Shawna Brakus', 'Cristal Cruickshank', 'Nona Hackett', 'Mr. Ali Sipes', 'Miss Mae Reinger', 'Adrain Hand Sr.', 'Joany Walsh', 'Linnea Goyette', 'Verona Luettgen', 'Therese Little', 'Prof. Aisha Denesik', 'Kira Maggio Sr.', 'Sandra Flatley', 'Roma Brekke DDS', 'Melba O\'Conner', 'Colby Toy', '1996-08-14', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(48, 0, 0, NULL, NULL, 'Dr. Ron Moore DVM', 'Mr. Harry Reichert I', 'Kenneth Goldner', 'Dorthy Torp', 'Mrs. Emie Moen', 'Estella Roberts', 'Ms. Orpha Thompson PhD', 'Adah Parisian', 'Carleton Morar', 'Ansel Parisian DVM', 'Prof. Kole Nolan', 'Vincenzo Ondricka', 'Salvador Beer', 'Mellie Mayert', 'Tyreek Strosin', 'Winnifred Mohr', 'Giuseppe Bartoletti', 'Nicola Gleichner', 'Jannie Witting', 'Eudora Swift', 'Vivienne Howe', '1974-08-05', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(49, 0, 0, NULL, NULL, 'Dr. Frederick Cremin IV', 'Aleen Koepp', 'Lindsay Dooley II', 'Ms. Verda Stracke', 'Marge Hayes', 'Kolby Fritsch', 'Susanna Senger', 'Avis Miller', 'Sylvia Kunze', 'Naomie Kris', 'Prof. Rosanna Hill', 'Francesca Reichert', 'Ms. Gretchen Collins', 'Bernadine Beer DDS', 'Mr. Ubaldo Dare I', 'Efren Block', 'Greyson Johns', 'Santos Reichert', 'Miller Reichert', 'Consuelo Kris', 'Toni Hessel', '1998-08-01', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(50, 0, 0, NULL, NULL, 'Prof. Rocky Hane', 'Ethel Satterfield', 'Felipa O\'Reilly', 'Assunta Kuphal', 'Mae Kutch', 'Carolyn Bosco', 'Carlee Parker', 'Ms. Kaia Gleason', 'Cecilia Stanton', 'Prof. Justyn Mueller', 'Virginia Johnston', 'Prof. Aliyah Kerluke V', 'Dr. Shyann Hyatt DVM', 'Arno O\'Conner', 'Cristal Willms IV', 'Carlos Lindgren', 'Dr. Deondre Keebler', 'Dr. Alf Kutch', 'Mr. Guido Kunze', 'Clara Ryan', 'Rigoberto Hegmann', '2018-07-28', '2023-02-14 04:59:00', '2023-02-14 04:59:00', NULL, NULL, NULL, NULL),
(51, 0, 0, NULL, NULL, 'ddsafdsfdsfdsfdsfdasfsadfas', NULL, 'ddsafdsfdsfdsfdsfdasfsadfas', NULL, '44654756547', '646854555756', 'ddsafdsfdsfdsfdsfdasfsadfas@sedf', 'ddsafdsfdsfdsfdsfdasfsadfas@sedf', 'ddsafdsfdsfdsfdsfdasfsadfas@sedf', '87565674', 'ddsafdsfdsfdsfdsfdasfsadfas@sedf', NULL, 'ddsafdsfdsfdsfdsfdasfsadfas@sedf', 'ddsafdsfdsfdsfdsfdasfsadfas@dfdhfg', 'ddsafdsfdsfdsfdsfdasfsadfas@sedf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-02-18 11:31:21', '2023-02-18 11:31:21', NULL, NULL, NULL, NULL),
(52, 0, 0, NULL, NULL, 'Mohd Akh', 'Akhlaque kh', 'Ahmad que', '675856785890789865', '5658658678967896', '5757867', 'Delhi 1', 'New Delhi 2', 'Uttar Pradesh delhi', '1100011', 'Employee orane', 'Java Dev php', 'Orane consult', 'orane11@mail.com', 'orane22@mail.com', 'https://www.google.com', 'Male m', '10million', '3.6m', '6:30 pm', 'C:\\xampp\\tmp\\php40C0.tmp', '2023-02-28', '2023-02-19 03:20:38', '2023-02-19 05:39:03', NULL, 1, 1, NULL),
(53, 0, 0, NULL, NULL, 'First Name', 'Middle  Name', 'Last Name', '1234567889', '345238957289', '33468340968', 'Delhi', 'New Delhi', 'Delhi Capital', '123129', 'Candidates Modules', 'Developer & SAP', 'Manoj Sir', 'akhlaque@123.com', 'akhlaque@1234.com', 'https:www.google.co.in', 'Na', '59k', '100k', 'After Lunch', 'C:\\xampp\\tmp\\phpEF07.tmp', '2023-02-20', '2023-02-19 05:47:44', '2023-02-19 06:07:26', NULL, 1, 1, NULL);

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

--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `company_id` int(10) UNSIGNED NOT NULL,
  `company_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fax_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pincode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `department` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `key_technologies` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `misc_notes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_hot` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `companies`
--

INSERT INTO `companies` (`company_id`, `company_name`, `mobile1`, `mobile2`, `fax_number`, `address`, `city`, `state`, `pincode`, `website`, `department`, `key_technologies`, `misc_notes`, `owner`, `is_hot`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES
(1, 'Mrs. Tia Balistreri IV', 'Henriette Dooley III', 'Devin Gerhold I', 'Ashly Mosciski', 'Dr. Esther Pfannerstill III', 'Meagan Tremblay', 'Helga Kuphal II', 'Reginald Walter', 'Marilou Murazik', 'Backend Developer', 'Prof. Kassandra Wintheiser', 'Carleton Hessel', 'Jamarcus Brakus', 0, '2023-02-14 04:59:01', '2023-02-19 01:44:57', '2023-02-19 01:44:57', 1, 1, 1),
(2, 'Prof. Maurine Pagac', 'Gussie Stiedemann', 'Hazel Marquardt', 'Elliot Runolfsdottir', 'Maryam Hoeger II', 'Dr. Francesca Wilderman', 'Roselyn Jenkins', 'Bria Schowalter V', 'Edison Lindgren', 'Mackenzie Greenholt', 'Andres Swift', 'Camilla Oberbrunner', 'Greg Green Jr.', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(3, 'Zena Feest', 'Rodolfo Cremin', 'Margot Heaney', 'Clementine Adams', 'Paul O\'Hara', 'Kale Steuber', 'Cecil Kreiger', 'Marianne Schaden', 'Dr. Jordan Roob', 'Dr. Kira Paucek PhD', 'Ruthie Wilderman', 'Angelica Thompson', 'Dr. Dejuan Ziemann', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(4, 'Enrique Tillman', 'Moises Boyer', 'Prof. Jesus Hermann Jr.', 'Miss Gia Cassin I', 'Vickie Spinka', 'Mr. Cullen Klein PhD', 'Marquise Feest', 'Leland Kertzmann', 'Jayda Schumm', 'Tyrell Wiegand', 'Presley Ritchie', 'Madie Sanford III', 'Jerod Halvorson', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(5, 'Eugenia Kirlin DDS', 'Luigi Koss Sr.', 'Dr. Dillan Barton', 'Ana Prohaska', 'Brando Gislason', 'Ms. Telly Armstrong I', 'Josianne Hirthe', 'Prof. Manley Schinner II', 'Elouise Harber', 'Dr. Sally Sporer', 'Mikayla Schuster', 'Dee Becker', 'Consuelo D\'Amore', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(6, 'Ms. Tiana Rohan III', 'Jillian Hintz Jr.', 'Tessie Larkin', 'Imani Hodkiewicz', 'Dr. Randal Rogahn', 'Jarvis Morar', 'Dr. Tito Kuphal', 'Mrs. Assunta Pollich V', 'Ricardo Farrell', 'Joanne Hintz III', 'Elenora Blick', 'Ricky Moore MD', 'Shaylee Konopelski', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(7, 'Malachi Kuhn', 'Stone Stark', 'Arnaldo Langworth', 'Ettie O\'Conner', 'Shyann Swift I', 'Hailie Wuckert', 'Macy Prohaska', 'Omer Buckridge DDS', 'Orie Lowe II', 'Prof. Branson Wyman', 'Maya Fadel', 'Prof. Anahi Rolfson', 'Mrs. Alvina Leannon', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(8, 'Bartholome Luettgen', 'Cleo Russel DDS', 'Kayla Hill', 'Helga Wisoky', 'Prof. Jasper Windler III', 'Antoinette Emard II', 'Janelle Nienow', 'Dashawn Gaylord MD', 'Anjali Collier', 'Salvatore Breitenberg', 'Angelita Koelpin', 'Lura Doyle', 'Gordon Legros', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(9, 'Grayson Kohler Sr.', 'Prof. Annabell Corkery III', 'Miss Annabelle Maggio', 'Gertrude Koss', 'Cruz Stark', 'Lura Carter', 'Dr. Colin Padberg', 'Walter Bins', 'Prof. Dan Franecki III', 'Rebekah Wiegand', 'Ladarius Corkery', 'Isai Strosin Jr.', 'Therese Kreiger', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(10, 'Julien Heller III', 'Marge Crona', 'Carolyne Bode', 'Prof. Imani Fritsch', 'Rowena Weber', 'Miss Caroline Barrows Sr.', 'Erica Crist II', 'Jo Quigley', 'Nellie Jacobs', 'Rhianna Volkman', 'Forest Hermiston', 'Hope Crooks', 'Stella Hessel', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(11, 'Verna Stiedemann', 'Adrian Kunde PhD', 'Ferne Wolff', 'Mikayla Franecki Jr.', 'Dock Breitenberg', 'Jimmie Gottlieb', 'Mr. Stanley Fadel III', 'Ransom Mertz II', 'Ms. Theresa Davis III', 'Cristal Kunde', 'Tyra Morar', 'Johnathan Pollich', 'Dr. Rogers Wisozk', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(12, 'Blanca Sipes II', 'Lloyd O\'Keefe', 'Cesar Will', 'Jayde Kuhlman II', 'Chris Hauck', 'Prof. Darrin Rippin III', 'Jasmin Ebert PhD', 'Dr. Rebekah Effertz IV', 'Torrance Reilly', 'Jadon Barrows', 'Giles Lemke', 'Ms. Kaci Reichel', 'Ethyl Lemke', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(13, 'Eleanora Bode', 'Adell Spinka', 'Christy Bode', 'Raphael Wilderman', 'Reynold Buckridge', 'Ray Bogisich', 'Precious Konopelski', 'Weston Carter', 'Dr. Jan Lang I', 'Brooklyn Hand', 'Jerry Fay', 'Davin Lowe III', 'Aubrey Volkman', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(14, 'Arlene Conn', 'Frederik Kutch', 'Helmer Bradtke', 'Josie Runte', 'Mckenna Heller', 'Ulises Homenick', 'Dr. Modesto Batz MD', 'Morton Adams', 'Garret Homenick', 'Elsa Maggio', 'Dr. Elouise Schroeder Sr.', 'Alvah Murray', 'Kenny Kub', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(15, 'Antone Koss', 'Jeffrey Gaylord', 'Braulio Jast', 'Sylvia Satterfield IV', 'Margarett Heidenreich V', 'Loren Green', 'Godfrey Schmitt', 'Carrie Herman', 'Alyson Schaefer', 'Dr. Jannie Walter', 'Antonia Streich', 'Carmen Kunze', 'Jordon Heaney I', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(16, 'Cielo Williamson', 'Xzavier Bosco MD', 'Alphonso Kreiger', 'Eusebio Padberg', 'Prof. Blake Cassin', 'Miss Marlen Lebsack III', 'Joanne Schaefer', 'Chadd Hauck', 'Logan Kling IV', 'Jarrod Schuppe', 'Andre Purdy', 'Mr. Triston VonRueden', 'Marlee Cassin IV', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(17, 'Mr. Dock Casper MD', 'Fabiola Emard MD', 'Anastasia Torphy', 'Janie Schuster', 'Dr. Brooklyn Klein', 'Miss Ava Kunde III', 'Ruben Littel', 'Caroline Wintheiser', 'Nels Doyle', 'Preston Robel', 'Elias Schinner', 'Carter Brekke', 'Lamar Hickle', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(18, 'Jadyn Will', 'Alena Kuvalis', 'Eryn Spencer', 'Prof. Thad Waters III', 'Dr. Katrina Gorczany', 'Schuyler Thompson', 'Charity Ebert', 'Stephanie Davis PhD', 'Russell Kirlin', 'Dr. Eldridge Jacobson', 'Mia Murazik', 'Laurine Goldner', 'Webster Sipes', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(19, 'Curtis Cassin', 'Brenden Nienow', 'Lulu Cruickshank DVM', 'Dr. Dashawn Rolfson', 'Gage Will', 'Lon Vandervort', 'Prof. Milton Auer', 'Kelley Johns', 'Omer O\'Reilly', 'Tavares Harris DVM', 'Tyree Beahan', 'Miss Taryn Boehm', 'Haleigh Farrell V', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(20, 'Prof. Koby Champlin', 'Alisa Douglas', 'Simone Wolff DDS', 'Loma Leffler', 'Parker Kuhic', 'Norene Mayer MD', 'Dr. Jacky Douglas III', 'Rudolph Hoeger I', 'Marisa Bernhard', 'Brandi Erdman', 'Jerod Ullrich', 'Dakota Farrell', 'Prof. Hilton O\'Keefe DDS', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(21, 'Dr. Robin Hartmann', 'Janiya Grimes', 'Raegan Johnston', 'Ruby Russel', 'Vanessa Osinski', 'Jerome Russel', 'Lon Ruecker', 'Mrs. Elda Little DDS', 'Sofia Barrows DDS', 'Madge Goodwin', 'Edmond Moen', 'Miss Natalia Pacocha DVM', 'Jada Torp Jr.', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(22, 'Kiley Hermann', 'Miss Danika Langosh IV', 'Randy Wiegand', 'Prof. Katharina Rath', 'Brianne Yundt', 'Annamarie Halvorson', 'Anderson Ledner', 'Stephania Bauch', 'Duane Hamill II', 'Rodrick Schneider', 'Mrs. Jayda Crona MD', 'Isidro Cummings', 'Sam Greenfelder', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(23, 'Prof. Adriel Brekke II', 'Prof. Kaleigh Hermann DDS', 'Kaden Willms', 'Lelah Durgan MD', 'Dr. Rebeka Monahan', 'Owen Moore PhD', 'Edgardo Rau', 'Dr. Jerome Wilkinson', 'Ms. Eileen Quigley V', 'Dayton Fisher I', 'Kenton Macejkovic', 'Margot Herman', 'Eulalia Batz', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(24, 'Orpha Bogisich', 'Destini Emmerich', 'Chet Cartwright', 'Rusty Veum', 'Mr. Marvin Cummerata DVM', 'Shania Kulas', 'Lolita Lueilwitz', 'Daphne Dare', 'Griffin Bogisich', 'Burdette Kirlin', 'Destini Bogisich', 'Kacey Gorczany', 'Alexa Treutel II', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(25, 'Rose Quitzon', 'Mr. Rico Pollich Sr.', 'Norbert Schumm', 'Sebastian O\'Conner', 'Patricia Wyman V', 'Everett Gutmann', 'Branson Lang', 'Jordon Kshlerin IV', 'Prof. Beulah Batz DDS', 'Charles Haley MD', 'Reilly Rosenbaum', 'Dr. Genesis Rath Jr.', 'Brody Nader', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(26, 'Alyson Schiller', 'Mr. Rahul Thiel V', 'Imani Green', 'Miss Naomi Terry', 'Mr. Miguel Wintheiser', 'Darryl Quitzon', 'Jaydon Hamill', 'Mara Schinner', 'Mr. Eddie Altenwerth DVM', 'Della Orn', 'Mose Tillman', 'Edwin Kunze Jr.', 'Albina Waelchi III', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(27, 'Alexandrine Torphy', 'Novella Hahn', 'Mrs. Nedra Roob DDS', 'Marilyne Parisian', 'Michele Swaniawski', 'Mr. Jamal Corkery', 'Bette Dooley Jr.', 'Danika Jones', 'Toney Wehner', 'Mrs. Mozelle Skiles', 'Bryana Hodkiewicz', 'Zoila Daniel', 'Aliza Will', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(28, 'Price Watsica', 'Maximillia Effertz DVM', 'Prof. Mckenna Veum DVM', 'Tiara Langosh', 'Agustina Roob', 'Estell Treutel', 'Jacques Cronin', 'Dennis Smitham', 'Murphy Balistreri Jr.', 'Jackie Turner', 'Karolann Nitzsche', 'Miss Princess Anderson', 'Mayra Bins DDS', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(29, 'Izabella Lindgren', 'Gladys Langworth DDS', 'Dr. Geraldine Smitham', 'Miss Eva Zboncak I', 'Mr. Kiley Raynor', 'Aiden Hintz PhD', 'Miss Otha Mraz PhD', 'Emilio Marquardt', 'Mr. Cedrick Lockman', 'Margarette Hoppe', 'Dr. Dolores Abbott', 'Elta Carter Sr.', 'Keven Grimes IV', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(30, 'Whitney Kautzer', 'Winnifred Dibbert', 'Mrs. Lynn Reichert', 'Prof. Wilber Torp', 'Raphaelle Grimes', 'Lorna Baumbach III', 'Mr. Frederic Murazik III', 'Simone Gorczany', 'Johnnie VonRueden', 'Mr. Manley Kunde II', 'Antone Schneider', 'Jazmyn Rath', 'Mr. Ashton Beer', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(31, 'Mariano Gerlach', 'Kristofer Skiles', 'Anais Bernier III', 'Miss Juanita Heathcote PhD', 'Mozell Huels', 'Icie Glover', 'Dr. Josue Turner', 'Prof. Natalia Haag', 'Rex Beatty Sr.', 'Abelardo Padberg', 'Prof. Linwood Bogan DVM', 'Wiley Rice', 'Dr. Hayden Armstrong', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(32, 'Filiberto Kohler', 'Dr. Santina Bauch', 'Xzavier Krajcik', 'Otilia Heller', 'Dr. Geo Feest', 'Stevie Borer', 'Wilber Sporer', 'Dr. Marco Kohler', 'Mrs. Marlen Shanahan V', 'Toni Robel', 'Theron Hamill', 'Kristofer Torphy', 'Everette Beer', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(33, 'Thaddeus Swift', 'Dr. Luciano Bashirian', 'Ressie Grimes', 'Astrid Hermann', 'Dorcas Buckridge', 'Camille Adams', 'Prof. Julie Bechtelar MD', 'Germaine Okuneva', 'Creola Satterfield I', 'Estelle Swaniawski III', 'Alek Funk', 'Tremayne Kuvalis', 'Orie Flatley', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(34, 'Dr. Alanna Nicolas II', 'Tony Smith', 'Prof. Wyatt Hyatt DVM', 'Miss Alysha Reichel II', 'Miss Raquel Ledner DVM', 'Dr. Maynard Fahey DVM', 'Dr. Marshall Padberg MD', 'Lavinia Abshire', 'Jacinthe Lehner', 'Kaylee Luettgen', 'Lavada Rogahn II', 'Mr. Stephen Hettinger', 'Sydni Stanton', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(35, 'Jerome Schuster', 'Kiley Johns', 'Mrs. Trycia Morar V', 'Landen Hamill', 'Elmer Howe', 'Tony Bode', 'Dr. Guy Friesen', 'Douglas Stroman', 'Shaina Schaefer', 'Mr. Werner D\'Amore I', 'Ms. Wilhelmine Huels V', 'Prof. Esteban Brakus III', 'Edgardo Bergstrom I', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(36, 'Prof. Jed Veum', 'Dr. Gregorio Lowe V', 'Wilma Berge', 'Kayley Strosin', 'Mr. Malcolm Padberg', 'Rahul Quitzon', 'Lon Bayer', 'Dr. Kiana Krajcik', 'Ms. Kassandra Stiedemann I', 'Roxane Ondricka', 'Dr. Sid Kuvalis', 'Hank Dickens', 'Miss Odie Olson I', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(37, 'Stanley Halvorson', 'Noah Bernhard', 'Ludwig Kirlin', 'Prof. Jailyn Bode', 'Brett Kemmer', 'Felipa Carter', 'Mollie Littel Jr.', 'Pete Armstrong IV', 'Jake Walter Jr.', 'Anahi Hane', 'Jarrett Mitchell', 'Peter Emard', 'Leopold Moen', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(38, 'Alexander Cruickshank', 'Ms. Isabell Moen', 'Ms. Bria Jast', 'Felicity Schmitt', 'Alexandro Jenkins', 'Dr. Nora Cremin III', 'Kory Kuvalis', 'Jessika Cummings', 'Daisy Dickinson MD', 'Clair Lebsack', 'Judge Kihn', 'Gabe Blanda', 'Sabryna Hartmann', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(39, 'Dr. Jalen Cormier MD', 'Prof. Hollis Lockman I', 'Tyra Eichmann DVM', 'Lesly Cremin', 'Mrs. Iliana Graham', 'Bailee Klocko IV', 'Rashawn Howe', 'Prof. Winona Bode I', 'Freida Beahan', 'Morris Botsford IV', 'Claudine Douglas', 'Juanita Schaden', 'Prof. Dennis Rempel', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(40, 'Daron Connelly', 'Charley Bruen', 'Mrs. Minerva Blick', 'Barrett Denesik', 'Johann Jast', 'Zelma Glover', 'Ellie Gulgowski', 'Prof. Louvenia Blanda DVM', 'Trey Turner', 'Amani O\'Conner', 'Blair Bartell', 'Dayne Hahn', 'Guiseppe Russel', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(41, 'Abigayle Pfannerstill', 'Eryn Abshire', 'Jarred Kub', 'Mrs. Rosie Robel PhD', 'Giovanna Zemlak', 'Prof. Kariane Mayert III', 'Dr. Filiberto Sanford', 'Daryl Pfannerstill', 'Prof. Kallie Pfeffer Sr.', 'Mrs. Aniya Cartwright', 'Doyle Langworth', 'Josue Corwin', 'Gladyce Bergstrom', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(42, 'Miss Virgie McDermott II', 'Desiree Breitenberg', 'Erika Mueller', 'Darian Franecki', 'Mr. Wilmer Sawayn Sr.', 'Kade Effertz PhD', 'Mathew Nader MD', 'Dessie Barton', 'Dejah Schulist', 'Ms. Retta Balistreri', 'Dr. Vito Marquardt III', 'Rafael Daugherty V', 'Jakayla Cassin', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(43, 'Tressa Glover', 'Prof. Sherman Koepp III', 'Prof. Ezekiel Hill', 'Ray Christiansen', 'Rylee Labadie', 'Brandy Huels', 'Shawna Douglas', 'Madonna Kunde Jr.', 'Kadin Fahey V', 'Rogers Schimmel', 'Kasey Hintz MD', 'Kathryne Altenwerth', 'Kasandra Schuster', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(44, 'Maxime Reilly', 'Chelsie Rogahn', 'Miss Tressie Mueller PhD', 'Prof. Tony Blanda I', 'Hans Kling', 'Ines Stoltenberg Jr.', 'Mrs. Marian Ondricka', 'Ms. Anya Lebsack', 'Miss Audra Goodwin', 'Prof. Ryleigh Bogan DDS', 'Morton Homenick', 'Kraig Lebsack', 'Jadyn Vandervort', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(45, 'Ramiro Ortiz IV', 'Dell Vandervort', 'Andy Blick', 'Bobby Schmitt I', 'Dallas Hansen', 'Myrtis Bradtke', 'Irving Carroll', 'Mr. Monroe Zulauf MD', 'Madelynn Hettinger', 'Dr. Cali Carter Sr.', 'Leon Kautzer', 'Tevin Paucek', 'Dr. Erna Mertz DVM', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(46, 'Americo Haag II', 'Audreanne Dibbert DVM', 'Garnett Rodriguez', 'Willa Leannon I', 'Miss Novella Johnson MD', 'Rudolph Johnston V', 'Dr. Glenna Raynor', 'Mr. Carroll Leffler Jr.', 'Mr. Jaleel Pollich DDS', 'Adele Weber', 'Cayla Ernser', 'Mr. Charlie Gislason', 'Oceane Legros', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(47, 'Miss Angela Ryan', 'Miss Celine Thompson', 'Giles Leuschke MD', 'Danial Medhurst', 'Delmer Swift', 'Elvera Schaden', 'Dr. Christophe Okuneva', 'Rico Kreiger', 'Josianne Baumbach', 'Alan Stark', 'Mr. Jalon Denesik', 'Lula Macejkovic', 'Bettie Luettgen', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(48, 'Miss Arielle Wuckert', 'Mrs. Anabel Pfannerstill MD', 'Prof. Tyler Pacocha DVM', 'Mr. Felton Hettinger DDS', 'Ms. Oceane Veum Jr.', 'Patrick Bradtke Sr.', 'Melody Powlowski', 'Thelma Bauch', 'Jorge Koss', 'Abigale Beier', 'Benjamin Haley', 'Eileen Kautzer', 'Marjory Beatty', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(49, 'Dr. Alessia Gibson DVM', 'Vesta Marvin I', 'Junior Wiza', 'Marisa Pouros DVM', 'Demarcus Greenfelder DVM', 'Kamron Murphy Sr.', 'Dr. Abby Kuvalis', 'Jarrod Reinger', 'Mr. Manuel Schmeler', 'Celestine Collins Jr.', 'Fatima Gulgowski', 'Mrs. Treva Wolff I', 'Daisha Rath II', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(50, 'Holly Casper', 'Brock Schoen', 'Dr. Alfredo Kemmer', 'Mr. Ignacio Bartoletti II', 'Olen Hodkiewicz', 'Eldon Murphy', 'Alba Mraz PhD', 'Arthur Herman IV', 'Dr. Brook Jacobi III', 'Kristian Denesik', 'Jerald Volkman Sr.', 'Dr. Jada Hermann V', 'Ahmad Batz', 0, '2023-02-14 04:59:01', '2023-02-14 04:59:01', NULL, 1, NULL, NULL),
(51, 'fgdsfsdfs', '5745645765', '4575', '475f', 'fgddss', 'sdfsdsf', 'sdfsdfs', '564', 'dfsdf@sdf.cxgf', NULL, 'fghfhgfh', 'fgjghf', NULL, 0, '2023-02-14 15:15:56', '2023-02-14 15:15:56', NULL, 1, NULL, NULL),
(52, 'fgdfsdfs', '6758657', 'dfgdgdghd', 'fdhfdh', 'dgfdhfgdh', 'fdhgfdgsdf', 'dsfsasdfadfa', 'sdfadsfa', 'dfsadfhsdf', NULL, 'fdsfsgdsf', 'sdfsgdfsgf', NULL, 0, '2023-02-16 06:05:24', '2023-02-16 06:05:24', NULL, 1, NULL, NULL),
(53, 'Orane', '1234567890', '0987654321', 'Fax', 'Address', 'City', 'State', '110001', 'www.google.com', 'Senior Developer', 'Technologies', 'Notes', NULL, 0, '2023-02-17 11:18:33', '2023-02-17 11:21:39', NULL, 1, 1, NULL);

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `contact_id` int(10) UNSIGNED NOT NULL,
  `is_hot` int(11) DEFAULT 0,
  `is_consultant` int(11) DEFAULT 0,
  `company_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_work` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_cell` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_other` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pincode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_department_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reports_to` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `left_company` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`contact_id`, `is_hot`, `is_consultant`, `company_id`, `first_name`, `last_name`, `title`, `email1`, `email2`, `phone_work`, `phone_cell`, `phone_other`, `address`, `city`, `state`, `pincode`, `owner`, `notes`, `company_department_id`, `reports_to`, `left_company`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES
(1, 0, 0, NULL, 'Prof. Amira Senger', 'Dr. Lorenz Heidenreich Jr.', 'Abdul Kessler', 'masr@qf.iu', 'gfsdz@sdgs.vch', 'Prof. Eriberto Kutch', 'Mr. Jordon Dare Jr.', 'Abigail Cummings', 'Karine Bins', 'Prof. Brennon Bayer PhD', 'Prof. Rashad Bergstrom', NULL, 'Destini O\'Keefe', 'Ewell Koch', 'Choose a Department', 'Demo2', NULL, '2023-02-20 01:09:50', '2023-02-22 01:29:37', NULL, 1, 1, NULL),
(2, 0, 0, NULL, 'Mrs. Yazmin Larkin Sr.', 'Enrico Nikolaus', 'Theresa Farrell', 'Marielle Johnson', 'Angelina Jenkins', 'Cordell Welch V', 'Federico Koch', 'Haven Romaguera', 'Leda Larson', 'Mr. Eriberto Kozey', 'Lelia Harber', 'Dr. Hortense Cronin', 'Franz Spencer', 'Nicholas Dare', 'Natalie Trantow', 'Mr. Gerald Ratke PhD', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(3, 0, 0, NULL, 'Savanah Macejkovic', 'Prof. Devin Brown', 'Lawrence Jaskolski', 'Margarette Ledner', 'Marianne Larkin', 'Dr. Alejandra Smitham IV', 'Angeline Gislason', 'Jermaine Robel', 'Mr. Theo Labadie', 'Dr. Anya Beer V', 'Tyra DuBuque IV', 'Scotty Prohaska', 'Mona Mraz', 'Lempi Howell', 'Ebony Johnson DVM', 'Dr. Maud Von', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(4, 0, 0, NULL, 'Owen Schamberger Jr.', 'Teresa Strosin', 'Luciano Grimes', 'Hattie Walter', 'Dr. Buddy Robel', 'Oswald Mills IV', 'Darron Aufderhar', 'Dr. Dariana Hickle III', 'Gaston Smitham Jr.', 'Adolfo Gottlieb', 'Dr. Gladys Barton', 'Mr. Sam Powlowski', 'Cierra Brakus', 'Mr. Abdullah Beatty MD', 'Erik Gibson', 'Josie Ledner', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(5, 0, 0, NULL, 'Krystina Schmeler Jr.', 'Romaine Murray', 'Dr. Jasper Zieme IV', 'Lavina Gutmann', 'Piper Langosh', 'Dr. Jany Bartoletti', 'Norene Bradtke', 'Kiana Grady', 'Celestine Renner', 'Rocio Corwin', 'Tyrel Dickens', 'Rylan Pouros', 'Anjali Gottlieb', 'Finn Gorczany MD', 'Aylin Carter', 'Dale Marks', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(6, 0, 0, NULL, 'Brooke Grimes', 'Walton Strosin', 'Jettie Gerlach II', 'Clementina Quitzon', 'Alexandria Murphy', 'Miss Retta Rempel MD', 'Dr. Johann Cruickshank I', 'Joelle Bogan', 'Shanon Greenholt', 'Kylee Yundt', 'Dolores Hirthe III', 'Toby Daniel MD', 'Eulalia Wolf', 'Evert Runolfsson', 'Celine Kunze', 'Dante Robel', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(7, 0, 0, NULL, 'Cassandra Kozey', 'Jarod Runte', 'Matilda Effertz', 'Cecil Langworth', 'Gust Rice', 'Janis Schinner', 'Javier Veum', 'Johan Gorczany', 'Avery Jacobson', 'Grayce Rosenbaum', 'Delaney Veum', 'Roberto Medhurst', 'Lionel Goldner', 'Dr. Darrell O\'Kon', 'Toni Schaden', 'Camilla Auer', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(8, 0, 0, NULL, 'Sigmund Reichel', 'Margret Baumbach', 'Hershel Legros', 'Mr. Marc Wintheiser V', 'Sheridan Oberbrunner', 'Maryse Borer', 'Mekhi Bergstrom', 'Katrine Sauer', 'Karson Herman', 'Kaya Kuphal Jr.', 'Darwin Nolan', 'Miss Mylene Runolfsson', 'Ms. Annabell Steuber', 'Emmanuelle Hansen', 'Miss Delilah Powlowski IV', 'Guadalupe Jacobs MD', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(9, 0, 0, NULL, 'Chet Mueller DVM', 'Keanu Luettgen DVM', 'Kendra Champlin', 'Davin Goyette', 'Nickolas Parisian', 'Santa Ankunding DDS', 'Prof. Devante Nicolas', 'Dr. Jammie Runte V', 'Carmen Wiza II', 'Margaretta Kshlerin', 'Donnell Murphy', 'Marguerite Ziemann', 'Bart Wolff', 'Magnus Stiedemann', 'Lorenz Bednar', 'Bennie Russel', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(10, 0, 0, NULL, 'Cordelia Mills', 'Charley Goodwin', 'Parker Halvorson', 'Dr. Ellen Skiles Sr.', 'Duane Kilback', 'Garrick Jast', 'Gwen O\'Keefe', 'Titus Lang', 'Mr. Colby Champlin DDS', 'Art Reichert', 'Kirstin Fadel', 'Ms. Kirsten Goyette', 'Amelia Padberg', 'Letha Erdman', 'Lorine Berge', 'Dr. Wallace Gusikowski Jr.', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(11, 0, 0, NULL, 'Aurore Russel', 'Rosalyn Hand DVM', 'Darren Casper', 'Gregory Gulgowski', 'Jan Langosh', 'Isadore Dare', 'Maribel Kuhic', 'Conor Shields', 'Lilly Armstrong I', 'Jeromy Luettgen II', 'Jaqueline Considine', 'Isidro Donnelly', 'Savion Johnson', 'Alexandria Hills PhD', 'Gardner Christiansen DVM', 'Jennyfer Weber', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(12, 0, 0, NULL, 'Otha Fay', 'Lonie Durgan', 'Noelia Haley', 'Bella Moen', 'Evelyn Raynor II', 'Lisandro Huel', 'Prof. Elias Renner III', 'Marilyne Kub', 'Caden Kuhic', 'Ms. Bernita Stark', 'Domenic Ondricka DDS', 'Ella Bashirian', 'Ms. Aniyah Dooley', 'Bell Kub', 'Payton Wunsch V', 'Berry Schowalter MD', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(13, 0, 0, NULL, 'Prof. Lera Hickle', 'Mr. Darryl Gulgowski DVM', 'Amie Little', 'Prof. Richard Conn', 'Adonis Hamill', 'Dr. Jeramie Ullrich Jr.', 'Prof. Frank Durgan', 'Prof. Dianna Wyman', 'Sydnie Gutmann', 'Prof. Kayla Keeling', 'Hermann Friesen PhD', 'Doug Farrell', 'Mr. Giovani Goyette', 'Elinor Reilly', 'Gus Heidenreich II', 'Major Dibbert', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(14, 0, 0, NULL, 'Daija Nitzsche', 'Judy Legros DVM', 'Dr. Gladyce Schiller', 'Giovanna Moore V', 'Raina Upton Sr.', 'Miss Jazmyn Fahey V', 'Brian West', 'Magdalen Feest DVM', 'Dustin Hudson', 'Prof. Edwina VonRueden', 'Ms. Dahlia Feest', 'Anissa Kuvalis', 'Ms. Gladys Glover MD', 'Raven Hyatt', 'Mayra Volkman Jr.', 'Cruz Kemmer', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(15, 0, 0, NULL, 'Mr. Arnoldo Thompson DDS', 'Maurice Senger', 'Alva Beier', 'Alan Schamberger', 'Carlie Kris', 'Jarod Carter', 'Santos Greenfelder', 'Mya Murazik', 'Della Farrell', 'Albert Simonis', 'Bonnie Streich', 'Sheila Lindgren PhD', 'Kayleigh Dicki IV', 'Domenica D\'Amore', 'Kari Boyer', 'Elouise Gaylord', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(16, 0, 0, NULL, 'Michelle Bayer', 'Orin Maggio', 'Humberto Schuster', 'Prof. Jimmy Powlowski', 'Olga Ledner II', 'Rachelle Kub', 'Christop Schinner', 'Howard Davis III', 'Miss Marta Dickens PhD', 'Dr. Grayce Wuckert', 'Prof. Aron Abshire', 'Miss Antonina Bednar IV', 'Prof. Eloisa Prohaska', 'Destany Huel', 'Ms. Kenna Johnson', 'Dr. Boris Sanford DDS', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(17, 0, 0, NULL, 'Nasir Hirthe', 'Madeline Terry', 'Dena Goodwin', 'Mr. Rene Schamberger', 'Dr. Gaston Mertz II', 'Dr. Darren Moen V', 'Leonie Gerlach', 'Mr. Kayden Doyle', 'Ericka Cole', 'Mr. Jerry Rempel', 'Dr. Adriana Kub MD', 'Miss River Terry', 'Daniela Hammes', 'Prof. Henriette Farrell I', 'Durward Crooks', 'Vernie Predovic', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(18, 0, 0, NULL, 'Dr. Katelin Russel', 'Dr. Blaze Champlin', 'Geo Predovic', 'Mr. Trey Hickle', 'Ashleigh Prohaska', 'Yvonne Corkery', 'Ahmed Schroeder', 'Rene Little', 'Mrs. Iliana Wolff MD', 'Megane Fisher', 'Oswaldo Rowe', 'Edythe Koss', 'Rosalia Okuneva PhD', 'Mr. Presley Rohan I', 'Nyah Huel', 'Miss Tressa Schaden DDS', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(19, 0, 0, NULL, 'Johathan Lebsack', 'Anastacio Farrell', 'Camille Powlowski PhD', 'Ms. Mathilde Hauck', 'Cyrus Blanda', 'Leif Corwin Sr.', 'Wendy Ratke', 'Prof. Leonie Hackett DDS', 'Mr. Tracey Beahan', 'Mrs. Jane Monahan IV', 'Dayana Hermiston PhD', 'Juvenal Haag', 'Randy Reichert', 'Mrs. Loyce Lind PhD', 'Beryl Ziemann', 'Hadley Glover', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(20, 0, 0, NULL, 'Ms. Jaquelin Labadie', 'Mrs. Jackeline Maggio', 'Maximo Fahey', 'May Wolff', 'Miss Vivienne Schroeder', 'Prof. Lamar Abbott', 'Miss Ophelia Miller II', 'Prof. Noe Towne Sr.', 'Jayme Ferry', 'Jaquelin Buckridge DDS', 'Miss Makenzie Heidenreich', 'Ms. Aletha Botsford PhD', 'Candido Beier', 'Dr. Orlando Lockman PhD', 'Dr. Ella Senger', 'Clementine Donnelly', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(21, 0, 0, NULL, 'Dr. Serena Miller DDS', 'Vena Lemke Sr.', 'Reed Gottlieb', 'Deron Wunsch', 'Lulu Barton', 'Kiley Bernier', 'Al Upton', 'Dr. Zackary Swaniawski', 'Gene Huels', 'Jayde Wuckert', 'Kendra Bednar', 'Jakayla Mitchell', 'Hailey Gottlieb', 'Herta Hermann', 'Delmer Fisher', 'Janis Harber', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(22, 0, 0, NULL, 'Luigi Cartwright', 'Tad Torp', 'Constantin Powlowski', 'Norberto Weber IV', 'Norbert Dooley', 'Juwan Kris V', 'Ellsworth Anderson', 'Mr. Ulises Rippin III', 'Alvina Lehner', 'Desmond Sporer', 'Vickie Heller', 'Liana Frami', 'Clay Torp', 'Mr. Terrill Bergstrom Sr.', 'Lexi Donnelly IV', 'Rhoda Morissette', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(23, 0, 0, NULL, 'Enrique Schroeder', 'Dr. Alfreda Mante', 'Marlon Brown', 'Mr. Cade Rice', 'Amy Torphy', 'Athena Swaniawski', 'Granville Raynor', 'Vicenta Conroy', 'Mr. Alvah Swaniawski', 'Torey Harris', 'Stefan Wuckert', 'Stacy Conroy', 'Horace Kris', 'Lorenz Veum Sr.', 'Prof. Lesly Strosin', 'Clementine Frami DDS', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(24, 0, 0, NULL, 'Prof. Verla Walker I', 'Dr. Newton Zemlak V', 'Miss Electa Gaylord', 'Rigoberto Weimann', 'Wilber Thiel', 'Ole Kozey', 'Dr. Piper Maggio I', 'Jacinto Steuber', 'Miss Sandrine White DDS', 'Mrs. Yvette Kunze III', 'Clovis Bahringer', 'Elena Spencer', 'Mr. Agustin Upton', 'Sammie Kirlin', 'Eric Sawayn', 'Casimer Corkery', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(25, 0, 0, NULL, 'Bryana Adams', 'Everette Stokes', 'Nyasia Weber', 'Eldred Eichmann', 'Prof. Jaycee King', 'Adrianna Hilpert PhD', 'Trudie Bode', 'Zander Romaguera', 'Prof. Adrian Goodwin', 'Natalia Kshlerin', 'Deshaun Larson', 'Mr. Myrl Volkman Jr.', 'Mr. Norbert Koelpin', 'Ralph Sipes', 'Jana Christiansen', 'Mable Quitzon', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(26, 0, 0, NULL, 'Mrs. Georgette Robel DVM', 'Mr. Savion Gutmann DVM', 'Christiana Wilderman', 'Robert Stroman II', 'Miss Polly Legros MD', 'Oda Thompson', 'Brayan Christiansen DVM', 'Ms. Lulu Lynch', 'Laury Wolf', 'Miss Yadira McDermott V', 'Consuelo Klocko', 'Dr. Hannah Hills IV', 'Dr. Florencio Spinka', 'Destini Berge', 'Mr. Mathew Jerde IV', 'Willie Powlowski', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(27, 0, 0, NULL, 'Prof. Gregoria Windler', 'Pansy McClure', 'Dave O\'Reilly', 'Marcel Schultz', 'Miss Della Wisozk', 'Boris Roob', 'Nellie Gaylord', 'Mrs. Elza Bernier', 'Jaquan Welch', 'Reinhold Dach', 'Kari Keebler', 'Rhea Hackett', 'Prof. Wilfrid Marks DVM', 'Johann Kreiger DDS', 'Tanner Strosin', 'Mr. Arnulfo Waelchi Jr.', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(28, 0, 0, NULL, 'Arnold Crooks', 'Arden Berge', 'Prof. Jocelyn Runolfsdottir', 'Florencio Veum PhD', 'Caleigh Koch', 'Marielle Will', 'Prof. Anahi Schulist', 'Rupert Lindgren', 'Edgardo Cassin DDS', 'Gwen Boehm', 'Dr. Matteo Ferry III', 'Dr. Arielle O\'Conner', 'Ayana Grimes', 'Meta Schoen', 'Drew Heller', 'Ashley Abshire Jr.', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(29, 0, 0, NULL, 'Prof. Jadyn McCullough DVM', 'Christ Quigley', 'Michelle Cruickshank', 'Lillian Swaniawski', 'Miss Marjorie Medhurst DDS', 'Mrs. Damaris Brakus Jr.', 'Theodora Lang', 'Icie Bailey', 'Prof. Jarrell Lynch', 'Jaquelin Walker', 'Adan Zboncak III', 'Karine Harvey', 'Dr. Meaghan Lesch', 'Dr. Brandt Pacocha MD', 'Prof. Abelardo Greenfelder', 'Prof. Brody Halvorson DVM', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(30, 0, 0, NULL, 'Izaiah Feil MD', 'Mr. Bernard Reichert', 'Mr. Constantin Orn IV', 'Kaycee Stanton', 'Miss Berenice Effertz DDS', 'Dr. Madilyn Pagac', 'Jacynthe Treutel', 'Matteo Terry', 'Kaya Langosh', 'Ms. Petra O\'Connell', 'Theo Kreiger', 'Bill Romaguera', 'Craig Schumm', 'Wilfrid Zemlak IV', 'Gwen Maggio', 'Colleen Torphy', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(31, 0, 0, NULL, 'Arthur Considine', 'Sonya Kub', 'Dr. Modesto Rau II', 'Rory Donnelly DDS', 'Keara Konopelski', 'Lourdes Bartoletti', 'Alta Miller V', 'Nikko Lang IV', 'Stacy Auer', 'Jazlyn Ruecker', 'Alejandrin Dicki III', 'Dr. Alf Larkin II', 'Elliott Kihn', 'Christelle Keebler DDS', 'Gail Stamm I', 'Deonte Predovic Sr.', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(32, 0, 0, NULL, 'Zackery Murray', 'Miss Adriana Borer III', 'Tianna Rodriguez', 'Mrs. Virgie Heathcote', 'Carlie Leannon', 'Edd Streich', 'Loyal Muller', 'Damaris Tromp', 'Stewart Dooley', 'Mr. Granville Schowalter', 'Mr. Colin Medhurst Jr.', 'Marion Doyle', 'Elisabeth Tillman', 'Dolly Stark', 'Layla Bradtke', 'Alexander Stoltenberg', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(33, 0, 0, NULL, 'Octavia Goyette', 'Nicklaus Spinka', 'Prof. Connor Kilback II', 'Ransom Sipes', 'Angel Legros', 'Peggie Witting', 'Asha Jacobi', 'Oswald Eichmann', 'Dr. Mattie Hammes', 'Rasheed Kuphal PhD', 'Nyah Crona', 'Gia Tremblay', 'Braden Brekke', 'Mrs. Breanna Bartoletti III', 'Vito Gislason', 'Zetta Nienow', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(34, 0, 0, NULL, 'Ms. Alyson Marquardt', 'Prof. Darion Franecki', 'Grayson Bartell', 'Mitchell Anderson', 'Eliseo Leuschke', 'Dr. Valentina Hoppe Sr.', 'Dr. Estefania Dietrich', 'Eliane Bergstrom', 'Dedric Lesch', 'Dr. Icie Spinka MD', 'Brad Kuhlman', 'Danial Denesik IV', 'Elissa Kuvalis Jr.', 'Arnaldo Kulas', 'Kameron McDermott DDS', 'Bart Bergstrom', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(35, 0, 0, NULL, 'Ms. Cleta Reichel IV', 'Prof. Brionna Rath MD', 'Mrs. Jayda Lemke DDS', 'Mr. Tristin Rowe IV', 'Josue Gulgowski', 'Muhammad Bruen PhD', 'Serena Hills', 'Dr. Brycen Bahringer PhD', 'Christop Goodwin II', 'Prof. Arnaldo Bartell', 'Griffin Mohr', 'Ryann Hill', 'Sid Murphy', 'Dr. Selena Hintz IV', 'Mrs. Zena Kreiger', 'Joanne Leffler', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(36, 0, 0, NULL, 'Yadira Lind DDS', 'Ms. Hailie Aufderhar', 'Elise Morissette', 'Harmony Okuneva', 'Vern Lubowitz MD', 'Onie Treutel', 'Charlene Klocko', 'Patience Jacobi', 'Sammy Lind', 'Ms. Yesenia Okuneva', 'Riley Ruecker', 'Prof. Michelle Morar', 'Darlene Nader', 'Dorothea Krajcik II', 'Joel Swaniawski', 'Norwood Cummings', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(37, 0, 0, NULL, 'Bulah Bernhard', 'Ramiro Gottlieb I', 'Mrs. Arielle Stehr III', 'Dr. Nikki Predovic Sr.', 'Brenda McKenzie', 'Brown Steuber', 'Dovie Larkin', 'Abraham Lockman', 'Kamryn Hackett', 'Muriel Hahn', 'Dr. Lemuel Mitchell', 'Lysanne Kassulke V', 'Savanah Jacobs', 'Laura Stanton', 'Bonita Smitham', 'Miss Leta Walker MD', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(38, 0, 0, NULL, 'Randal Satterfield', 'Manuela Treutel', 'Laurie Goyette', 'Sydnee Koepp', 'Paige Hammes', 'Jamie Gottlieb', 'Clovis Macejkovic', 'Simone Parisian II', 'Suzanne McCullough', 'Mrs. Nellie Haley', 'Abigayle Mayer', 'Maximus Kulas II', 'Logan Blanda', 'Sierra Johnson', 'Mr. Filiberto Ruecker', 'Ashly Steuber', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(39, 0, 0, NULL, 'Karl Lowe', 'Landen Bauch II', 'Bettye Murphy', 'Mr. Roosevelt Lemke III', 'Prof. Blaise Muller', 'Prof. Lilla Heathcote Sr.', 'Hassie Jast', 'Carlee Hackett', 'Prof. Fidel Ullrich II', 'Madelyn Corkery', 'Sabina Bednar', 'Dr. Thelma Bruen Jr.', 'Annamae Larkin IV', 'Sibyl Eichmann', 'Mr. Karson Hickle IV', 'Katelin Ankunding MD', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(40, 0, 0, NULL, 'Mr. Domenic Hamill IV', 'Dr. Jerel Gerlach', 'Roman Dach', 'Betsy Balistreri', 'Dr. Alec Kreiger Jr.', 'Whitney Fadel', 'Prof. Dina Morissette Sr.', 'Glenda Green MD', 'Ora Harvey', 'Melany Von', 'Makenzie Grant', 'Ms. Mable Bergnaum', 'Mr. Clifford Zieme', 'Stephen Stroman', 'Bonita Rempel', 'Mr. Seth Lowe IV', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(41, 0, 0, NULL, 'Mrs. Mikayla Kub', 'Joany Parisian', 'Celestino Ebert', 'Arielle Shields MD', 'Kaia Schuster', 'Mrs. Caleigh Kerluke', 'Dr. Jonathan Frami', 'Dale O\'Keefe II', 'Molly Mraz', 'Junius Cormier', 'Electa Orn', 'Mr. Bruce Rosenbaum I', 'Ansel Kuhic', 'Alvis Gerhold', 'Candido Strosin I', 'Mrs. Lucienne Pacocha III', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(42, 0, 0, NULL, 'Deontae Bogisich', 'Kaylin O\'Connell', 'Prof. Vilma Lindgren III', 'Tavares Sanford', 'Mr. Lucius Treutel DVM', 'Immanuel Gislason', 'Anjali Klocko', 'Ms. Zella Grant Jr.', 'Dr. Cordie Beahan', 'Salvatore Raynor', 'Ms. Maia Corkery V', 'Derrick Herman', 'Dr. Giles Gutmann MD', 'Haylee Harber', 'Prof. Jaylan Kihn DVM', 'Fannie Sanford', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(43, 0, 0, NULL, 'Kelli O\'Hara II', 'Fidel Smitham', 'Prof. Davon Kovacek', 'Ed Botsford IV', 'Hilda Schneider Jr.', 'Reynold Gleason', 'Ora Kozey', 'Queenie Kub IV', 'Scottie Strosin', 'Prof. Willie Bruen MD', 'Dr. Michaela McLaughlin', 'Tamia Kessler', 'Ms. Katharina Wilderman Sr.', 'Kacie Champlin', 'Betty Balistreri', 'Asia Nikolaus', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(44, 0, 0, NULL, 'Alexie Dooley I', 'Eleazar Little Sr.', 'Dr. Pearline Walker DDS', 'Rahul Considine', 'Kaycee Sawayn', 'Althea Kertzmann', 'Luella Nienow', 'Prof. Ayana Lang', 'Ali Legros', 'Justyn Johnston', 'Prof. Cornell Carroll Sr.', 'Kaylah VonRueden', 'Prof. Nolan Mueller', 'Miss Sandra Torp', 'Lowell Ortiz', 'Mr. Sebastian Bahringer', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(45, 0, 0, NULL, 'Wilfred Stanton', 'Mr. Wiley McCullough', 'Kylee Hammes', 'Beau McKenzie', 'Jamir Feest', 'Kurtis Mann', 'Kacie Hartmann', 'Cornell Kihn DVM', 'Lloyd Carroll I', 'Dr. Delaney Boyer', 'Madisen Terry III', 'Josh Stracke', 'Ms. Rosetta Yundt', 'Novella Jones', 'Miss Hosea McDermott IV', 'Grover Dicki', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(46, 0, 0, NULL, 'Jack McKenzie', 'Tremayne Fadel', 'Elroy Kilback', 'Jayden Sauer', 'Marques Corwin DDS', 'Miss Yesenia Johnston', 'Prof. Clarissa Erdman', 'Ova Ullrich', 'Dr. Mohammad Pacocha Sr.', 'Nelle Dare IV', 'Garnett Howell', 'Ms. Juliet Ullrich', 'Miss Lynn Runte Sr.', 'Marlon Botsford', 'Luella Heathcote', 'Malinda Altenwerth', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(47, 0, 0, NULL, 'Mrs. Selina Koss', 'Marina Hessel', 'Mr. Arlo Walsh', 'Rosalind Rogahn III', 'Devonte Schinner', 'Mr. Crawford Ledner PhD', 'Kylee Reichel', 'Kristina Kautzer', 'Jazmin Hudson', 'Bridie Roob DVM', 'Abner Zulauf', 'Prof. Velva Brakus II', 'Lisette Leffler', 'Mckenzie Auer', 'Marshall Trantow', 'Bailee Waelchi', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(48, 0, 0, NULL, 'Miss Burdette Ziemann Sr.', 'Spencer Kling Sr.', 'Effie Ward MD', 'Maverick Emmerich', 'Prof. Electa Stark DVM', 'Miss Delores Price', 'Ken Doyle', 'Mr. Dusty Ledner', 'Neva Bauch', 'Mr. Charley Hoeger Jr.', 'Dr. Miracle Schuster V', 'Jenifer Smitham', 'Nels Lind', 'May Toy Sr.', 'Florian Jenkins', 'Kaden Koelpin I', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(49, 0, 0, NULL, 'Murphy Bechtelar', 'Annie Green', 'Prof. Carole Keebler IV', 'Elmore Wolf', 'Prof. Bernie Pouros MD', 'Turner Torp', 'Cindy Cronin II', 'Charlene Wuckert', 'Jamel Hyatt', 'Camren Reinger MD', 'Mrs. Heidi Dietrich', 'Dorian Windler', 'Joseph Veum', 'Dr. Alvis Marquardt', 'Prof. Amely Greenholt', 'Carrie Muller', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(50, 0, 0, NULL, 'Lucie Marquardt', 'Lou Terry MD', 'Dr. Aliya Hudson V', 'June Bashirian', 'Miss Lisa Feeney', 'Avis Hintz', 'Omer Kassulke', 'Madeline Stracke', 'Thad Feil', 'Ferne Ryan', 'Miss Hildegard Ullrich', 'Uriah Williamson', 'Dr. Thurman Green', 'Miss May Spencer III', 'Dr. June Beatty', 'Melyna Collins V', NULL, '2023-02-20 01:09:50', '2023-02-20 01:09:50', NULL, 1, NULL, NULL),
(51, 0, 0, NULL, 'Akhlaque', 'Mohd', 'Dev', 'akhlaque1@gmail.com', 'akhlaque2@gmail.com', '986879689', '68976', '69876897689', 'asdfdsf', 'sdfdasf', 'lkklvbghgk', '97890790', 'sdfsadfds', 'dsfsdjl;kj', 'Demo2', 'Demo2', NULL, '2023-02-20 01:34:24', '2023-02-20 01:34:24', NULL, 1, NULL, NULL),
(52, 0, 0, NULL, 'adfsazfxgdxvx', 'sfgdsfgdxgfd', 'sdfsfsfgd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Choose a Department:', 'Choose a Reports to:', NULL, '2023-02-20 01:47:10', '2023-02-20 01:47:10', NULL, 1, NULL, NULL),
(53, 0, 1, NULL, 'xbvcxbcxv', 'cvxfdsdfsdfsdsdf', 'dhmgjuikutyu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Choose a Department:', 'Choose a Reports to:', NULL, '2023-02-20 01:55:14', '2023-02-20 01:55:14', NULL, 1, NULL, NULL),
(54, 0, NULL, NULL, 'sgdsgcfsgf', 'cfgssgf', 'cbxfjhfjbhytbjf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Choose a Department:', 'Choose a Reports to:', NULL, '2023-02-20 02:10:11', '2023-02-20 02:10:11', NULL, 1, NULL, NULL),
(55, 0, 0, NULL, 'cdekl', 'sasasa', 'sdfsfd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Choose a Department:', 'Choose a Reports to:', NULL, '2023-02-20 03:32:59', '2023-02-20 03:32:59', NULL, 1, NULL, NULL),
(56, 0, 0, NULL, 'cgfdhgdhgdgf', 'fgdgdfgfdf', 'dgdhfghdhg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Choose a Department:', 'Choose a Reports to:', NULL, '2023-02-20 12:34:44', '2023-02-20 12:34:44', NULL, 1, NULL, NULL),
(57, 0, NULL, NULL, 'fjgh', 'hgf', 'fgjgh', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Choose a Department:', 'Choose a Reports to:', NULL, '2023-02-20 12:37:30', '2023-02-20 12:37:30', NULL, 1, NULL, NULL),
(58, 0, 1, NULL, 'ncbvcnvcbncv', 'vbcnvbcnvb', 'cvcnvbcnbv', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Choose a Department', 'Choose a Reports to', NULL, '2023-02-20 12:38:32', '2023-02-20 13:13:33', NULL, 1, 1, NULL),
(59, 0, 1, NULL, 'testing', 'donne', 'working', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Choose a Department:', 'Choose a Reports to:', NULL, '2023-02-20 13:03:10', '2023-02-20 13:03:10', NULL, 1, NULL, NULL),
(60, 0, 1, NULL, 'bxxcvxxv cxv', 'cxbvxcvx', 'cxbxbvcx', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Choose a Department:', 'Choose a Reports to:', NULL, '2023-02-20 22:35:30', '2023-02-20 22:35:30', NULL, 1, NULL, NULL);

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

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `company_department_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` (`company_department_id`, `name`, `company_id`, `created_by`, `updated_by`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Hr Manager', 10, 1, 1, 1, '2023-02-14 17:38:13', '2023-02-14 11:26:39', '2023-02-14 12:08:13'),
(2, 'Human Resource Manager', 51, 1, 1, NULL, NULL, '2023-02-14 12:13:01', '2023-02-15 03:33:56'),
(3, 'Department', 12, 1, 1, 1, '2023-02-15 08:57:58', '2023-02-14 14:30:30', '2023-02-15 03:27:58'),
(4, 'Backend Developer', 7, 1, 1, NULL, NULL, '2023-02-14 14:58:48', '2023-02-14 23:04:13'),
(5, 'Senior Developer', 50, 1, NULL, NULL, NULL, '2023-02-15 03:28:28', '2023-02-15 03:28:28');

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

--
-- Table structure for table `extra_fields`
--

CREATE TABLE `extra_fields` (
  `extra_fields_id` int(10) UNSIGNED NOT NULL,
  `extra_field_settings_id` int(11) NOT NULL,
  `data_item_id` int(11) NOT NULL DEFAULT 0,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `extra_field_settings`
--

CREATE TABLE `extra_field_settings` (
  `extra_field_settings_id` int(10) UNSIGNED NOT NULL,
  `field_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data_item_type` int(11) NOT NULL DEFAULT 0,
  `extra_field_type` int(11) NOT NULL DEFAULT 1,
  `extra_field_options` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `joborders`
--

CREATE TABLE `joborders` (
  `joborder_id` int(10) UNSIGNED NOT NULL,
  `is_hot` int(11) DEFAULT 0,
  `is_public` int(11) DEFAULT 0,
  `openings` int(11) DEFAULT NULL,
  `department` int(11) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `designation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `recruiter` int(11) DEFAULT NULL,
  `owner` int(11) DEFAULT NULL,
  `hiring_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ecode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `grade` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `test` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `joborders`
--

INSERT INTO `joborders` (`joborder_id`, `is_hot`, `is_public`, `openings`, `department`, `status`, `designation`, `position_type`, `city`, `state`, `recruiter`, `owner`, `hiring_type`, `ecode`, `grade`, `position_code`, `test`, `position_number`, `notes`, `description`, `date`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES
(1, 1, 1, 8, 4, 'Full', 'Developer', 'Junior Developer', 'Noida', 'Uttar Pradesh', 1, 2, 'Internal', 'Dev001', 'A+', '8', 'hk', NULL, 'klhjlk', '<p>hjklhj</p>', '2023-02-22', '2023-02-22 04:25:14', '2023-02-22 04:25:14', NULL, 1, NULL, NULL),
(2, 1, 1, 6, 5, 'Lead', 'asdf dev', 'asdfsdf loper', 'adsfszfd', 'sfdgs', 2, 2, 'rty ok', 'thrf', 'fhg b', '67', '67576', NULL, 'dfd', '<p><b><u><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">dfdghdffg............</font></u></b></p>', '2023-02-28', '2023-02-22 04:35:09', '2023-02-22 04:39:29', NULL, 1, 1, NULL);

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_status`
--

CREATE TABLE `job_status` (
  `job_status_id` int(10) UNSIGNED NOT NULL,
  `id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `can_scheduled` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `triggers_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_enabled` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(18, '2022_12_14_143021_create_products_table', 1),
(42, '2014_10_12_000000_create_users_table', 2),
(43, '2014_10_12_100000_create_password_resets_table', 2),
(44, '2019_08_19_000000_create_failed_jobs_table', 2),
(45, '2019_12_14_000001_create_personal_access_tokens_table', 2),
(46, '2022_12_14_142911_create_permission_tables', 2),
(48, '2022_12_24_063916_create_companies_table', 2),
(49, '2022_12_26_144553_create_extra_fields_table', 2),
(50, '2022_12_29_064023_create_candidates_table', 2),
(52, '2023_01_05_195437_create_job_status_table', 2),
(53, '2023_01_24_085647_create_departments_table', 2),
(54, '2023_02_02_110103_create_extra_field_settings_table', 2),
(55, '2023_02_10_052350_create_saved_search_table', 2),
(58, '2022_12_30_085244_create_contacts_table', 3),
(63, '2023_02_21_151249_create_jobs_table', 5),
(71, '2022_12_22_054414_create_joborders_table', 6),
(72, '2023_02_17_092631_create_saved_list_table', 7),
(73, '2023_02_17_092759_create_saved_list_items', 7);

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

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

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB 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\\Models\\User', 1),
(2, 'App\\Models\\User', 2);

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

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

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB 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, 'role-list', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(2, 'role-create', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(3, 'role-edit', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(4, 'role-delete', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(5, 'user-list', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(6, 'user-create', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(7, 'user-edit', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(8, 'user-delete', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(9, 'activities-list', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(10, 'activities-create', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(11, 'activities-edit', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(12, 'activities-delete', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(13, 'candidates-list', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(14, 'candidates-create', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(15, 'candidates-edit', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(16, 'candidates-delete', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(17, 'companies-list', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(18, 'companies-create', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(19, 'companies-edit', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(20, 'companies-delete', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(21, 'Contacts-list', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(22, 'Contacts-create', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(23, 'Contacts-edit', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(24, 'Contacts-delete', 'web', '2023-02-14 04:57:34', '2023-02-14 04:57:34'),
(25, 'extrafields-list', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(26, 'extrafields-create', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(27, 'extrafields-edit', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(28, 'extrafields-delete', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(29, 'joborders-list', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(30, 'joborders-create', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(31, 'joborders-edit', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(32, 'joborders-delete', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(33, 'jobstatus-list', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(34, 'jobstatus-create', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(35, 'jobstatus-edit', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(36, 'jobstatus-delete', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(37, 'lists-list', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(38, 'lists-create', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(39, 'lists-edit', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(40, 'lists-delete', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(41, 'reports-list', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(42, 'reports-create', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(43, 'reports-edit', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(44, 'reports-delete', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(45, 'product-list', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(46, 'product-create', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(47, 'product-edit', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35'),
(48, 'product-delete', 'web', '2023-02-14 04:57:35', '2023-02-14 04:57:35');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `detail` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB 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, 'admin', 'web', NULL, NULL),
(2, 'recruiter', 'web', NULL, NULL);

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

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

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB 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),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(21, 2),
(22, 1),
(22, 2),
(23, 1),
(23, 2),
(24, 1),
(24, 2),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(29, 1),
(30, 1),
(31, 1),
(32, 1),
(33, 1),
(34, 1),
(35, 1),
(36, 1),
(37, 1),
(38, 1),
(39, 1),
(40, 1),
(41, 1),
(42, 1),
(43, 1),
(44, 1),
(45, 1),
(46, 1),
(47, 1),
(48, 1);

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

--
-- Table structure for table `saved_list`
--

CREATE TABLE `saved_list` (
  `list_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `data_item_type` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `saved_list_items`
--

CREATE TABLE `saved_list_items` (
  `job_status_id` int(10) UNSIGNED NOT NULL,
  `saved_list_id` int(11) NOT NULL,
  `data_item_type` int(11) NOT NULL,
  `data_item_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `saved_search`
--

CREATE TABLE `saved_search` (
  `search_id` int(10) UNSIGNED NOT NULL,
  `data_item_text` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_custom` int(11) DEFAULT NULL,
  `data_item_type` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `page` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `saved_search`
--

INSERT INTO `saved_search` (`search_id`, `data_item_text`, `url`, `is_custom`, `data_item_type`, `user_id`, `page`, `created_at`, `updated_at`) VALUES
(6, 'Darby Torphy', 'http://127.0.0.1:8000/contacts/?psearch=psearch&name=Darby Torphy&fieldName=first_name', NULL, NULL, 2, 'contacts', '2023-02-17 03:34:43', '2023-02-17 03:34:43');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `candidates`
--
ALTER TABLE `candidates`
  ADD PRIMARY KEY (`candidate_id`),
  ADD UNIQUE KEY `candidates_email1_unique` (`email1`),
  ADD UNIQUE KEY `candidates_email2_unique` (`email2`),
  ADD KEY `candidates_is_hot_index` (`is_hot`),
  ADD KEY `candidates_first_name_index` (`first_name`),
  ADD KEY `candidates_last_name_index` (`last_name`),
  ADD KEY `candidates_phone_home_index` (`phone_home`),
  ADD KEY `candidates_phone_cell_index` (`phone_cell`),
  ADD KEY `candidates_phone_work_index` (`phone_work`),
  ADD KEY `candidates_key_skills_index` (`key_skills`(768)),
  ADD KEY `candidates_owner_index` (`owner`);

--
-- Indexes for table `companies`
--
ALTER TABLE `companies`
  ADD PRIMARY KEY (`company_id`),
  ADD KEY `companies_company_name_index` (`company_name`),
  ADD KEY `companies_department_index` (`department`),
  ADD KEY `companies_key_technologies_index` (`key_technologies`(768)),
  ADD KEY `companies_owner_index` (`owner`),
  ADD KEY `companies_is_hot_index` (`is_hot`);

--
-- Indexes for table `contacts`
--
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`contact_id`),
  ADD KEY `contacts_is_hot_index` (`is_hot`),
  ADD KEY `contacts_company_id_index` (`company_id`),
  ADD KEY `contacts_first_name_index` (`first_name`),
  ADD KEY `contacts_last_name_index` (`last_name`),
  ADD KEY `contacts_title_index` (`title`),
  ADD KEY `contacts_owner_index` (`owner`);

--
-- Indexes for table `departments`
--
ALTER TABLE `departments`
  ADD PRIMARY KEY (`company_department_id`);

--
-- Indexes for table `extra_fields`
--
ALTER TABLE `extra_fields`
  ADD PRIMARY KEY (`extra_fields_id`);

--
-- Indexes for table `extra_field_settings`
--
ALTER TABLE `extra_field_settings`
  ADD PRIMARY KEY (`extra_field_settings_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `joborders`
--
ALTER TABLE `joborders`
  ADD PRIMARY KEY (`joborder_id`),
  ADD KEY `joborders_is_hot_index` (`is_hot`),
  ADD KEY `joborders_department_index` (`department`),
  ADD KEY `joborders_status_index` (`status`),
  ADD KEY `joborders_designation_index` (`designation`),
  ADD KEY `joborders_recruiter_index` (`recruiter`),
  ADD KEY `joborders_owner_index` (`owner`),
  ADD KEY `joborders_date_index` (`date`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `job_status`
--
ALTER TABLE `job_status`
  ADD PRIMARY KEY (`job_status_id`),
  ADD KEY `job_status_description_index` (`description`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `saved_list`
--
ALTER TABLE `saved_list`
  ADD PRIMARY KEY (`list_id`);

--
-- Indexes for table `saved_list_items`
--
ALTER TABLE `saved_list_items`
  ADD PRIMARY KEY (`job_status_id`);

--
-- Indexes for table `saved_search`
--
ALTER TABLE `saved_search`
  ADD PRIMARY KEY (`search_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `candidates`
--
ALTER TABLE `candidates`
  MODIFY `candidate_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;

--
-- AUTO_INCREMENT for table `companies`
--
ALTER TABLE `companies`
  MODIFY `company_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `contact_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;

--
-- AUTO_INCREMENT for table `departments`
--
ALTER TABLE `departments`
  MODIFY `company_department_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `extra_fields`
--
ALTER TABLE `extra_fields`
  MODIFY `extra_fields_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `extra_field_settings`
--
ALTER TABLE `extra_field_settings`
  MODIFY `extra_field_settings_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `joborders`
--
ALTER TABLE `joborders`
  MODIFY `joborder_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `job_status`
--
ALTER TABLE `job_status`
  MODIFY `job_status_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `saved_list`
--
ALTER TABLE `saved_list`
  MODIFY `list_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `saved_list_items`
--
ALTER TABLE `saved_list_items`
  MODIFY `job_status_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `saved_search`
--
ALTER TABLE `saved_search`
  MODIFY `search_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
COMMIT;

