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

START TRANSACTION;



--
-- Database: `laravel_event_management`
--

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

--
-- Table structure for table `count_downs`
--

CREATE TABLE `count_downs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `eventStartDate` varchar(255) COLLATE utf8mb4_unicode_ci 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 `count_downs`
--

INSERT INTO `count_downs` (`id`, `eventStartDate`, `created_at`, `updated_at`) VALUES
(1, '10/28/2023', '2023-10-13 22:17:49', '2023-10-25 04:48:23');

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

--
-- Table structure for table `event_information`
--

CREATE TABLE `event_information` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` 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 `event_information`
--

INSERT INTO `event_information` (`id`, `logo`, `name`, `phone`, `email`, `website`, `address`, `created_at`, `updated_at`) VALUES
(1, '1697702342.png', 'Event Management', '01923-001122', 'event@email.com', 'www.google.com', '123 Main Street, Anytown, Bangladesh', '2023-10-19 05:19:39', '2023-10-19 01:59:02');

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

--
-- Table structure for table `exhibitors`
--

CREATE TABLE `exhibitors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fb` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linked_in` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exhibitor_id_card` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `venue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pavilion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `exhibitors`
--

INSERT INTO `exhibitors` (`id`, `image`, `name`, `website`, `email`, `mobile`, `address`, `fb`, `linked_in`, `twitter`, `exhibitor_id_card`, `venue`, `pavilion`, `details`, `created_at`, `updated_at`, `user_id`) VALUES
(81, 'exhibitor-logo3.jpg', 'Tyson Bergstrom', 'http://www.collier.com/', 'aron.nicolas@example.com', '1-531-538-0710', '4429 Duane Terrace Apt. 986\nLake Juvenalton, NH 92181-3817', 'http://www.rosenbaum.com/', 'http://www.aufderhar.biz/aut-numquam-illo-minima-et-autem-rerum', 'http://fay.com/sit-aperiam-et-et-accusamus-beatae-perferendis', '060f39d3-e800-3ce2-a0bb-1384bd1eedb0', '9927 Elyse Island\nWiegandshire, OR 26949', 'libero', 'Saepe ea enim atque exercitationem fuga ut ea. Est quasi placeat vitae tempora nisi. Ut vel sed dolorum dicta perspiciatis dolorum delectus.', '2023-10-15 01:25:46', '2023-10-15 01:25:46', NULL),
(82, 'exhibitor-logo3.jpg', 'Prof. Khalid Gulgowski II', 'http://cremin.net/autem-est-non-magnam-accusamus-quaerat.html', 'wilton.roberts@example.net', '1-520-639-6747', '9040 Dibbert Crest Apt. 048\nSallybury, CA 06013-9627', 'http://www.mcdermott.com/et-reiciendis-expedita-eligendi.html', 'https://schaden.com/ut-enim-quo-veniam.html', 'http://www.labadie.com/quae-qui-voluptatem-eius-laborum-aut-sit-eum', '7d7365a5-1ed4-3184-bd98-6f7154e5dc77', '4563 Mertz Springs Suite 367\nLake Wendytown, CT 96645-8297', 'odit', 'Ut et dolorum incidunt. Quaerat architecto velit sint aliquam expedita ex. Ut veniam consequuntur excepturi dolor velit. Occaecati porro asperiores et molestiae alias ut incidunt. Veritatis iste eum corrupti expedita ad. Repudiandae impedit sit delectus optio ut accusantium porro non.', '2023-10-15 01:25:46', '2023-10-15 01:25:46', NULL),
(83, 'exhibitor-logo.jpg', 'Kip Upton', 'http://www.lueilwitz.com/non-asperiores-aut-rem-dolores-qui-ut-laboriosam', 'vergie.maggio@example.com', '(320) 910-9611', '8244 Daniela Parks\nSouth Natville, AL 17265', 'http://gislason.com/in-voluptatibus-sint-in-ea-nihil-veritatis', 'http://jacobson.net/', 'http://balistreri.com/', 'c84e06ff-cd46-39d0-be84-b61856b785c3', '49224 Braun Run\nEast Bell, NY 92992-2023', 'voluptas', 'Quaerat blanditiis quia ut beatae. Fugiat vitae et beatae aut illo ad sit eaque. Deserunt odio vero itaque sint saepe. Et quo magni perferendis cumque voluptatem. Officiis voluptatem et blanditiis perferendis facilis et ab.', '2023-10-15 01:25:46', '2023-10-15 01:25:46', NULL),
(84, 'exhibitor-logo2.jpg', 'Rhea Considine', 'http://walter.info/aut-et-dolorem-distinctio-odit-qui', 'pstroman@example.com', '+1-938-878-2764', '545 Lakin Wells Apt. 980\nWest Rachael, ME 90814-8382', 'http://www.wunsch.net/maiores-sit-saepe-animi-qui-aspernatur-et-officiis-qui', 'http://bradtke.org/', 'http://www.braun.com/quia-blanditiis-et-est.html', 'f39ebc81-41f2-3947-b8aa-9c335b293881', '463 Caterina Turnpike\nSouth Kip, MA 42684', 'veritatis', 'Praesentium id incidunt et ipsum qui ipsum. Quia laudantium quo iure vero eveniet sapiente quia. Ipsum quasi qui eveniet pariatur numquam. Magni doloremque et minus aut.', '2023-10-15 01:25:46', '2023-10-15 01:25:46', NULL),
(85, 'exhibitor-logo.jpg', 'Isac Steuber', 'https://www.kihn.com/similique-dignissimos-omnis-labore', 'jazmyn.mueller@example.net', '1-585-855-4602', '3835 Carmen Shoals Suite 773\nWendyborough, KY 01486', 'http://www.schimmel.net/est-sit-hic-sapiente-enim-voluptatem.html', 'https://www.bayer.com/enim-maxime-harum-sint-placeat', 'https://www.romaguera.com/nihil-quidem-quod-nostrum-sit', 'cf435b78-0732-39f7-8354-a4d2e156ed58', '40309 Moore Square\nBertramburgh, WY 58471', 'illum', 'Repellat iure dolorem consequuntur consequatur odit autem quis. Tempora et qui id nisi ratione in. Non cupiditate harum delectus ut ducimus.', '2023-10-15 01:25:46', '2023-10-15 01:25:46', NULL),
(86, 'exhibitor-logo5.jpg', 'Mrs. Aubrey Greenholt MD', 'http://www.kuhn.com/omnis-quidem-necessitatibus-quas', 'marco.bahringer@example.net', '928-472-7334', '966 Marian Isle Suite 418\nDouglasport, RI 71022-9351', 'http://corwin.com/soluta-sunt-enim-dolores-molestias-doloribus-facilis-quia-voluptates', 'http://www.beer.biz/facilis-reprehenderit-officiis-dolorem', 'https://davis.net/optio-a-natus-eligendi-aut-inventore.html', 'f2b7cf89-8f46-392f-bb11-042db82c683e', '3126 Alvera Summit\nMosciskiton, OK 18411', 'impedit', 'Et quae ullam dolore qui maiores necessitatibus eius. Quo dolores rerum sed quo consequatur et rerum aut. Dolorem assumenda quisquam et molestias nemo sed. Aut nam sint sunt soluta et earum. Voluptate iusto aut qui et corrupti impedit aspernatur.', '2023-10-15 01:25:46', '2023-10-15 01:25:46', NULL),
(87, 'exhibitor-logo5.jpg', 'Genesis Daniel Jr.', 'http://www.stokes.com/iusto-aut-ipsa-amet-explicabo-veniam-voluptate-nemo', 'wupton@example.org', '(678) 293-6642', '9813 Rose Row Apt. 256\nHilpertshire, DC 51295-6905', 'http://weimann.com/sequi-explicabo-consequatur-iste-id-dolorem-facilis.html', 'https://www.willms.com/impedit-quo-sint-quas', 'http://champlin.org/accusamus-nulla-eligendi-aut-et-suscipit.html', '096eaef1-a2e8-30fa-8185-647a8c1468bb', '5452 Terry Turnpike Suite 590\nLenniechester, FL 34503-3397', 'suscipit', 'Consequatur id doloremque assumenda quibusdam blanditiis eaque. Sequi aut exercitationem aut reprehenderit. Cupiditate expedita at est tenetur. Odio hic voluptas quas mollitia et molestiae rem maiores. Laboriosam ullam adipisci non illo.', '2023-10-15 01:25:46', '2023-10-15 01:25:46', NULL),
(88, 'exhibitor-logo3.jpg', 'Prof. Sierra Dickens Jr.', 'http://www.damore.com/eum-earum-suscipit-pariatur-aliquid-fugit.html', 'feeney.annamarie@example.net', '972-555-7548', '633 Amina Loop Suite 845\nWest Darbychester, NY 20429-3832', 'http://www.okeefe.com/iusto-sunt-in-eaque-modi.html', 'https://www.veum.com/repellat-autem-dolores-consequatur-magnam', 'http://www.lakin.com/sunt-sunt-temporibus-a-tempora-qui.html', '053361ad-4b4e-3d30-85f2-db55b43d0f47', '24363 Lucie Road\nSengerland, MO 04595-3233', 'error', 'In eos est libero iure quo et. Perspiciatis quo et illo nihil inventore quod ea. Non non veritatis ut enim enim dolorem. Et aut et accusantium odit expedita culpa. Consequatur rerum architecto sapiente omnis. Ad ipsam eius quas nisi sequi nihil consequatur.', '2023-10-15 01:25:46', '2023-10-15 01:25:46', NULL),
(89, 'exhibitor-logo2.jpg', 'Autumn McCullough', 'http://rolfson.com/non-sit-veniam-doloribus-amet-iusto-et-assumenda', 'agustin.morar@example.net', '1-864-630-0016', '57347 Parisian Inlet\nZulafort, OK 10326-5448', 'http://quigley.com/', 'http://pacocha.com/et-magni-non-quis-facere-illum-recusandae-esse-non.html', 'https://www.crona.biz/quae-architecto-vero-sunt', 'd00108b5-635a-3198-bb7f-28e2569e6b2a', '380 Bode Manors Apt. 091\nKeelingville, ND 92440-0993', 'nam', 'Cum cum occaecati saepe quam ea. Dolorem nihil ipsa sit distinctio ea sed eum. Eum saepe enim hic eos quis doloribus eos qui. Qui tempore ut quia distinctio. Dolor autem unde totam nulla sint incidunt. Commodi consequatur aut voluptatum ducimus id laborum cumque sunt.', '2023-10-15 01:25:46', '2023-10-15 01:25:46', NULL),
(90, 'exhibitor-logo.jpg', 'Teresa Streich', 'http://schultz.org/sunt-ut-odio-quasi-pariatur-iure-ea-placeat', 'izabella98@example.com', '1-757-732-8782', '86508 Marjolaine Forge Apt. 513\nNorth Sonya, NC 31370', 'http://emard.com/veritatis-voluptates-maxime-dolore-pariatur-praesentium', 'http://wisoky.net/sit-aperiam-et-dolor-facere-rerum-sint', 'http://www.emmerich.biz/', '03f0166c-6a5a-3833-932c-f87d184e05bb', '787 Larson Vista\nDelphiamouth, VT 32885-7646', 'repellendus', 'Autem provident porro maxime quaerat molestias facilis. Repellendus quo dicta pariatur rerum nostrum ut dolore. Id nihil autem rem quidem reprehenderit aut. Et quae et et quia ea earum eum dolorum. Impedit inventore aperiam laborum magni. Dolores illo alias consequuntur perspiciatis nostrum facere ab.', '2023-10-15 01:25:46', '2023-10-15 01:25:46', NULL),
(92, NULL, 'Exhibitor11', NULL, 'exhibitor11@gmail.com', '00990011', NULL, NULL, NULL, NULL, NULL, 'Dhaka', NULL, NULL, '2023-10-18 00:45:59', '2023-10-18 00:45:59', 59),
(93, '1697627628.jpg', 'Exhibitor222', 'https://www.web.com', 'exhibitor222@gmail.com', '222222', 'exhibitor address', 'ex-fb', 'linked_in', 'twitter', 'EVM-EXB-0093', 'China Convention Center2', NULL, 'ex details', '2023-10-18 01:41:37', '2023-10-18 06:25:29', 65),
(94, '1698208939.png', 'new exhibitor2', NULL, 'nexhibitor@gmail.com', '019222828', 'Dhaka', NULL, NULL, NULL, 'EVM-EXB-0094', 'chattogram', NULL, 'null', '2023-10-18 10:54:58', '2023-10-25 03:24:34', 66);

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

--
-- Table structure for table `exhibitor_visitor`
--

CREATE TABLE `exhibitor_visitor` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `exhibitor_id` bigint(20) UNSIGNED NOT NULL,
  `visitor_id` bigint(20) UNSIGNED 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 `exhibitor_visitor`
--

INSERT INTO `exhibitor_visitor` (`id`, `exhibitor_id`, `visitor_id`, `created_at`, `updated_at`) VALUES
(1, 94, 103, NULL, NULL),
(2, 94, 101, NULL, NULL),
(3, 93, 103, NULL, NULL),
(4, 93, 101, NULL, NULL),
(5, 93, 102, NULL, NULL),
(6, 93, 101, NULL, NULL),
(7, 93, 101, NULL, NULL),
(8, 94, 102, NULL, NULL),
(12, 94, 104, NULL, NULL),
(13, 94, 106, NULL, NULL),
(14, 94, 105, NULL, NULL);

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

--
-- 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 `guests`
--

CREATE TABLE `guests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `designation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `working_place` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` 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;

--
-- Dumping data for table `guests`
--

INSERT INTO `guests` (`id`, `name`, `image`, `designation`, `email`, `phone`, `type`, `working_place`, `details`, `created_at`, `updated_at`) VALUES
(36, 'Else Mueller', 'image-3.jpg', 'Founder of RFL', 'cbuckridge@example.net', '770-393-1446', 'Chief Guest', 'The People Republic of Bangladesh', 'Ut molestias quia ipsam voluptatibus totam dolorum. Harum quis omnis nesciunt quam architecto est ex ipsum. Facere iste accusantium consequuntur illum. Fuga omnis sed dolore aliquid illo. Deserunt itaque itaque beatae mollitia rerum accusamus suscipit. Doloremque tempora est laborum veritatis. Doloribus sed esse et est earum iste harum est. Consequatur repudiandae fugit possimus quas voluptate voluptatem corporis.', '2023-10-16 21:57:19', '2023-10-16 21:57:19'),
(37, 'Wilma Shields', 'image-4.jpg', 'Pakistan Ambassador', 'ogrant@example.net', '(423) 405-4600', 'Special Guest', 'The Bangladesh Parliament', 'Qui quia incidunt sint veritatis. Enim vitae perspiciatis aut qui laboriosam quasi sit. Officiis aut omnis officia cumque debitis itaque laborum. Sed quis id ut qui. Nihil labore reprehenderit dolore ea.', '2023-10-16 21:57:19', '2023-10-16 21:57:19'),
(38, 'Mr. Deven Pacocha', 'image-4.jpg', 'Founder of RFL', 'jledner@example.net', '971-377-6952', 'Special Guest', 'Pran RFL Company', 'Harum perferendis et culpa aut autem sed. Accusantium non sit quis dolor consectetur. Sunt tenetur eaque architecto nihil. Sint molestiae voluptatibus et voluptate error enim illum et. Quia eveniet perferendis totam fugit. Consequatur omnis et est. Fugiat sed harum saepe sint. Neque quia et earum blanditiis voluptas et voluptatem. Molestiae quasi incidunt qui et doloribus est.', '2023-10-16 21:57:19', '2023-10-16 21:57:19'),
(39, 'Dedrick Gleason', 'image-5.jpg', 'Pakistan Ambassador', 'gavin71@example.net', '+1.580.724.4430', 'Chief Guest', 'The People Republic of Bangladesh', 'Sint voluptas voluptate omnis animi eaque id. Est aperiam odio voluptatum. Blanditiis maxime sunt incidunt repudiandae. Rerum dolorem repellendus similique totam doloribus voluptatem harum ullam. Et qui enim placeat velit quos. Saepe possimus quibusdam aut. Aut a inventore ratione minus omnis voluptatem. Omnis molestiae ad aut cupiditate non quidem. Illo ut asperiores quas aliquam illum nihil nam consequatur. Est delectus ratione ut molestiae odio.', '2023-10-16 21:57:19', '2023-10-16 21:57:19'),
(40, 'Dora Lang', 'image.jpg', 'Chief Minister', 'wilfred31@example.org', '+13215078367', 'Chief Guest', 'Pran RFL Company', 'Eos corrupti odio vel voluptatibus. Corrupti aut molestias recusandae facilis commodi iste et voluptatum. Nulla et perspiciatis perspiciatis velit animi odio. Culpa accusantium accusantium ea quod corporis deserunt ut. Nostrum quis omnis dolor. Tempore suscipit repudiandae et nihil et. Dolore omnis eligendi voluptas labore.', '2023-10-16 21:57:19', '2023-10-16 21:57:19'),
(41, 'Major Hoeger', 'image.jpg', 'Founder of RFL', 'maximillian79@example.org', '+1.815.515.5417', 'Special Guest', 'The People Republic of Bangladesh', 'Aut maiores quia sit. Molestias voluptas et vero. Nulla incidunt neque qui ea soluta animi velit. Accusamus quibusdam rerum consequatur. Natus est atque in fugit qui. Voluptas aut quidem quas ut quo. Quibusdam omnis laboriosam molestiae consequatur libero. Cumque minima quas voluptas facere doloribus similique. Nisi et in voluptatem saepe qui nesciunt. Odio quod delectus non. Maiores soluta eos quidem. Aut natus voluptas et ea doloremque non consequatur.', '2023-10-16 21:57:19', '2023-10-16 21:57:19'),
(42, 'Annamarie Schmeler DVM', 'image.jpg', 'Founder of RFL', 'camryn.bailey@example.org', '+19085346658', 'Special Guest', 'Bangladesh Govt', 'Et est rerum quis aut non distinctio. Facilis odit voluptatem aspernatur molestiae aut et. Maiores dolorem voluptate blanditiis. Omnis rerum dignissimos dicta nam. Modi ab voluptatem sit deserunt sint corporis quibusdam aut. Nisi labore necessitatibus omnis optio voluptas dolorum. In voluptate molestiae placeat nostrum mollitia. Quidem natus optio sed autem veniam nemo. Dolores exercitationem quia voluptatem tempora.', '2023-10-16 21:57:19', '2023-10-16 21:57:19'),
(43, 'Loren Sanford', 'image-4.jpg', 'Pakistan Ambassador', 'jlindgren@example.org', '+1-774-351-0119', 'Special Guest', 'The Bangladesh Parliament', 'Exercitationem eos aut ratione. Consequatur laboriosam voluptatum dolores ut et ipsa. Quaerat odio perspiciatis ad magni et consequatur repudiandae eligendi. Quos illo ea eaque mollitia est commodi. Et corrupti quas officiis et quod omnis. Ullam et et repellendus dolorem. Perspiciatis cumque cupiditate molestiae non. Quas quaerat sint quo quo eveniet.', '2023-10-16 21:57:19', '2023-10-16 21:57:19'),
(44, 'Maryjane Stracke', 'image-4.jpg', 'State Minister', 'kacie.greenholt@example.net', '+1 (248) 708-8468', 'Special Guest', 'The Islamic Republic of Pakistan', 'Occaecati rem incidunt ipsum non. Facilis ipsam vitae enim quae dolorem numquam. Aut beatae minus corrupti itaque quaerat mollitia sapiente. Qui iusto culpa quidem numquam cumque temporibus voluptas. Temporibus occaecati aut optio. Laudantium aliquid non soluta consequatur asperiores. Quam asperiores debitis maiores aut exercitationem fuga et. Nam officiis corporis qui corrupti maiores non in.', '2023-10-16 21:57:19', '2023-10-16 21:57:19'),
(45, 'Carlos Schimmel', 'image-3.jpg', 'Chief Minister', 'vstroman@example.com', '954.919.4038', 'Chief Guest', 'The People Republic of Bangladesh', 'Eos repellendus fugiat et molestias eum voluptatem. Est libero ut omnis non rerum a. Voluptatem accusantium nisi perspiciatis recusandae. Harum maxime omnis quod quo nemo et accusamus. Aut odio fuga iure eveniet sed. Iure est aut non mollitia aperiam. Sapiente at sint possimus dolor. Nihil dolores qui corporis facere distinctio sunt aliquam.', '2023-10-16 21:57:19', '2023-10-16 21:57:19'),
(46, 'Mr. Torey Dickens', 'image-5.jpg', 'Founder of RFL', 'ratke.paul@example.com', '+1 (940) 786-3954', 'Special Guest', 'The Bangladesh Parliament', 'Dolor quidem voluptatem perferendis suscipit commodi. Vel praesentium quisquam molestiae perferendis ut velit impedit. Eveniet quo iusto molestias corporis velit est ut. Minus minima dicta mollitia ad consequuntur aut. Quia sit quis officiis sit qui. Inventore distinctio magni possimus quia tenetur nesciunt. Debitis vel in aut id cupiditate dignissimos. Facilis illum aut et explicabo rem vitae quia. Nihil et assumenda ea similique rerum est.', '2023-10-16 21:57:19', '2023-10-16 21:57:19'),
(47, 'Aditya Little', 'image-3.jpg', 'Chief Minister', 'aubree.funk@example.net', '+1-262-239-3926', 'Special Guest', 'Pran RFL Company', 'Harum maiores fugiat nulla nam optio qui. Quo quia ratione voluptas adipisci et doloribus. Architecto voluptatum est et eveniet. Impedit reiciendis et officiis ipsam rerum nesciunt sunt. Est non beatae incidunt commodi rerum sed. Amet ut quasi vel. Et reprehenderit ut voluptate earum expedita. Asperiores quibusdam dolores non dolorem rerum. Voluptates nesciunt alias nihil. Quaerat qui cupiditate consequatur omnis illum maxime veniam id.', '2023-10-16 21:57:19', '2023-10-16 21:57:19'),
(48, 'Irma Boyle', 'image-4.jpg', 'Honorable Speaker', 'uhansen@example.net', '+1 (773) 867-7929', 'Chief Guest', 'The Bangladesh Parliament', 'Vitae recusandae dolores dolorem aliquid. Voluptatum non asperiores dolorum rerum veniam dolor sed illo. Vel suscipit maxime ipsum aut accusantium porro. Totam quia repellendus dignissimos qui. Quia est rem ab beatae possimus inventore. Ex cum ea rerum doloribus voluptates et. Quibusdam quas sequi et iste est. Blanditiis est accusantium iure ab sequi distinctio corrupti ut.', '2023-10-16 21:57:19', '2023-10-16 21:57:19'),
(49, 'Marley Ratke', 'image-4.jpg', 'State Minister', 'caroline.miller@example.com', '+13366688156', 'Special Guest', 'The Islamic Republic of Pakistan', 'Officia nulla reiciendis amet accusamus. Aliquam aliquam aut est esse ea. Ut mollitia voluptate minima est alias. Doloremque id veniam maiores dolorem. Sed eaque hic corporis. Debitis dolorem possimus omnis omnis. Et quia enim minima sed. Quaerat et occaecati esse ex voluptas doloribus.', '2023-10-16 21:57:19', '2023-10-16 21:57:19'),
(50, 'Mrs. Ally Balistreri', 'image-5.jpg', 'Chief Minister', 'arturo.kling@example.com', '281-442-5268', 'Chief Guest', 'The Islamic Republic of Pakistan', 'Tenetur assumenda dolor quis amet. Aut voluptas sed et. Quia et a recusandae consequatur. Quo necessitatibus qui molestias delectus et. Velit ipsam et nam. Culpa delectus aut nihil rerum. Enim itaque et eveniet et nostrum iusto. Ipsum laboriosam inventore a ut quis cum. Dolor culpa sed officiis ut ab. Sequi quas temporibus ad qui tempora. Sint mollitia itaque nesciunt aut.', '2023-10-16 21:57:19', '2023-10-16 21:57:19');

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

--
-- Table structure for table `mega_events`
--

CREATE TABLE `mega_events` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `time-slot` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `venue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `speakers` int(11) NOT NULL,
  `details` text COLLATE utf8mb4_unicode_ci 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 `mega_events`
--

INSERT INTO `mega_events` (`id`, `image`, `name`, `date`, `time-slot`, `venue`, `speakers`, `details`, `created_at`, `updated_at`) VALUES
(7, '1697359424.jpg', 'Developer Conference', '2023-11-02', '10:00am - 12:00pm', '5639 Orville Walks Apt. 376\r\nSouth Biankaville, FL 63561-8218', 14, 'Sed qui et iste omnis nesciunt est suscipit. Nostrum quia beatae placeat laborum unde illo sapiente. Debitis possimus sed vel harum. Et animi quaerat illo aut. Et consequatur est eaque adipisci odio placeat reprehenderit unde.', '2023-10-14 02:25:21', '2023-10-15 02:43:44'),
(10, '1697346672.jpg', 'Braulio Gleason', '2023-10-29', '12:00pm - 02:00pm', '72141 Lilliana Garden\r\nNew Shaneview, OR 04643', 12, 'Corporis dignissimos ipsam quo et voluptatum. Perferendis ad eos laboriosam ex cum maxime maxime. Qui delectus tempora aut et. Id fuga quae consequatur ratione modi.', '2023-10-14 02:25:21', '2023-10-14 23:11:13'),
(15, '1698218322.jpg', 'Emmalee Crooks', '2023-10-23', '08:00pm - 10:00pm', '45389 Annamarie Drive\r\nLake Sylvanside, FL 52549', 10, 'Iusto veritatis dolorum impedit ab. Libero doloremque molestiae suscipit dolor et. Nihil dolorem a ea mollitia explicabo eaque enim. Odit voluptatibus voluptatem veritatis eligendi delectus. Id cupiditate consequuntur enim harum ea.', '2023-10-15 00:20:54', '2023-10-25 01:18:42'),
(16, '1698218339.jpg', 'Sheila Durgan DDS', '2023-11-08', '08:00pm - 10:00pm', '289 Bernhard Grove Suite 177\r\nDannieville, WI 10973', 10, 'Ut voluptas officia consequatur deleniti facilis quae. Vero sit autem molestiae deleniti. Quas ipsa explicabo et. Quaerat delectus et eligendi. Saepe doloremque quibusdam eligendi aut quia alias. Voluptas magni aut molestiae consequatur.', '2023-10-15 00:20:54', '2023-10-25 01:18:59');

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

--
-- 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
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2023_10_11_064245_add_role_to_users', 2),
(6, '2023_10_13_052532_make_name_nullable_in_users_table', 3),
(7, '2023_10_13_113529_create_sliders_table', 4),
(8, '2023_10_13_175254_create_photos_table', 5),
(9, '2023_10_14_034722_create_count_downs_table', 6),
(10, '2023_10_14_080402_create_mega_events_table', 7),
(11, '2023_10_15_064356_create_exhibitors_table', 8),
(12, '2023_10_15_071155_create_exhibitors_table', 9),
(13, '2023_10_15_175016_add_user_id_to_exhibitors', 10),
(14, '2023_10_16_111202_create_primary_attractions_table', 11),
(15, '2023_10_16_140047_create_visitors_table', 12),
(16, '2023_10_16_145638_create_visitor_mega_event_table', 12),
(17, '2023_10_16_151130_add_timestamps_to_visitors', 13),
(18, '2023_10_16_160810_add_user_id_to_visitors', 14),
(19, '2023_10_17_032043_create_guests_table', 15),
(20, '2023_10_17_032116_create_speakers_table', 15),
(21, '2023_10_18_145258_create_products_table', 16),
(22, '2023_10_19_041408_create_event_information_table', 17),
(23, '2023_10_21_073121_create_product_categories_table', 18),
(27, '2023_10_22_030751_add_columns_to_visitors', 19),
(28, '2023_10_23_061542_create_exhibitor_visitor_table', 20);

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

--
-- Table structure for table `photos`
--

CREATE TABLE `photos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` 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 `photos`
--

INSERT INTO `photos` (`id`, `name`, `path`, `created_at`, `updated_at`) VALUES
(1, '1697230218.jpg', 'photos/1697230218.jpg', '2023-10-13 14:50:19', '2023-10-13 14:50:19'),
(2, '1697233606.jpg', '1697233606.jpg', '2023-10-13 15:46:46', '2023-10-13 15:46:46'),
(3, '1697234567.jpg', '1697234567.jpg', '2023-10-13 16:02:47', '2023-10-13 16:02:47'),
(4, '1697234697.jpg', '1697234697.jpg', '2023-10-13 16:04:57', '2023-10-13 16:04:57'),
(5, '1697234716.png', '1697234716.png', '2023-10-13 16:05:16', '2023-10-13 16:05:16'),
(6, '1697234773.png', '1697234773.png', '2023-10-13 16:06:13', '2023-10-13 16:06:13'),
(7, '1697234784.png', '1697234784.png', '2023-10-13 16:06:24', '2023-10-13 16:06:24'),
(8, '1697234948.png', '1697234948.png', '2023-10-13 16:09:08', '2023-10-13 16:09:08'),
(9, '1697234965.png', '1697234965.png', '2023-10-13 16:09:25', '2023-10-13 16:09:25'),
(10, '1697235064.png', '1697235064.png', '2023-10-13 16:11:04', '2023-10-13 16:11:04'),
(11, '1697235081.png', '1697235081.png', '2023-10-13 16:11:21', '2023-10-13 16:11:21'),
(12, '1697235750.png', '1697235750.png', '2023-10-13 16:22:30', '2023-10-13 16:22:30'),
(13, '1697235763.gif', '1697235763.gif', '2023-10-13 16:22:43', '2023-10-13 16:22:43'),
(14, '1697235837.jpg', '1697235837.jpg', '2023-10-13 16:23:57', '2023-10-13 16:23:57'),
(15, '1697235847.jpg', '1697235847.jpg', '2023-10-13 16:24:07', '2023-10-13 16:24:07'),
(16, '1697235865.jpg', '1697235865.jpg', '2023-10-13 16:24:25', '2023-10-13 16:24:25'),
(17, '1697235886.jpg', '1697235886.jpg', '2023-10-13 16:24:46', '2023-10-13 16:24:46'),
(18, '1697235913.PNG', '1697235913.PNG', '2023-10-13 16:25:13', '2023-10-13 16:25:13'),
(19, '1697235925.png', '1697235925.png', '2023-10-13 16:25:25', '2023-10-13 16:25:25'),
(20, '1697236304.png', '1697236304.png', '2023-10-13 16:31:44', '2023-10-13 16:31:44'),
(21, '1697236318.jpg', '1697236318.jpg', '2023-10-13 16:31:58', '2023-10-13 16:31:58');

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

--
-- Table structure for table `primary_attractions`
--

CREATE TABLE `primary_attractions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `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 `primary_attractions`
--

INSERT INTO `primary_attractions` (`id`, `image`, `name`, `created_at`, `updated_at`) VALUES
(3, '1698218383.jpg', 'Dr. Guillermo Hauck', '2023-10-16 05:25:07', '2023-10-25 01:19:43'),
(5, '1698218401.jpg', 'Prof. Dessie Lynch V', '2023-10-16 05:25:07', '2023-10-25 01:20:01'),
(16, '1697462818.jpg', 'Demo Attraction New', '2023-10-16 07:06:05', '2023-10-16 07:26:58'),
(17, '1697462804.jpg', 'New Attraction2', '2023-10-16 07:06:50', '2023-10-16 07:26:44');

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

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

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exhibitor_id` bigint(20) UNSIGNED 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 `products`
--

INSERT INTO `products` (`id`, `name`, `company_name`, `category`, `link`, `image`, `details`, `exhibitor_id`, `created_at`, `updated_at`) VALUES
(1, 'New Software Product', 'Exhibitor222', 'Software Development/Customization', 'https://www.google.com/', '1697645539.png', '\"Spread love everywhere you go. Let no one ever come to you without leaving happier.\"\r\n\"If you judge people, you have no time to love them.\"\r\n\"Kind words can be short and easy to speak, but their echoes are truly endless.\"\r\n\"Not all of us can do great things. But we can do small things with great love.\"\r\n\"Peace begins with a smile.\"\r\n\"Intense love does not measure; it just gives.\"\r\n\"The hunger for love is much more difficult to remove than the hunger for bread.\"\r\n\"We ourselves feel that what we are doing is just a drop in the ocean. But the ocean would be less because of that missing drop.\"\r\n\"I alone cannot change the world, but I can cast a stone across the waters to create many ripples.\"\r\n\"Do not wait for leaders; do it alone, person to person.\"', 93, '2023-10-18 10:12:19', '2023-10-18 10:12:19'),
(3, 'New Software VAR', 'new exhibitor', 'VAR/Software Implementation', 'https://www.lipsum.com/feed/html', '1697648190.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec faucibus hendrerit efficitur. Donec id arcu sem. Maecenas at bibendum est, vel vestibulum nulla. Suspendisse eu leo sit amet dolor gravida ornare et in purus. Nullam lobortis turpis sed risus sodales molestie. Integer nunc enim, venenatis nec ipsum et, vehicula dignissim est. Vestibulum nec venenatis nisi. Maecenas pretium id ipsum sit amet efficitur. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae; Suspendisse semper metus eget mauris semper blandit. Quisque aliquet suscipit nulla sed aliquam.', 94, '2023-10-18 10:56:30', '2023-10-18 10:56:30'),
(4, 'New Bkash Software', 'new exhibitor', 'Software Development/Customization', 'https://www.bkash2.com/', '1697865810.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin eu mi in ipsum auctor fermentum. Cras ut leo sapien. Pellentesque feugiat diam sit amet tellus porttitor, ut venenatis diam elementum. In in elit sed massa molestie varius. Vivamus a mauris id orci congue accumsan. In dictum suscipit odio, a dapibus orci posuere at. Mauris fringilla arcu ac leo volutpat ultricies. Mauris cursus mattis ipsum, vitae commodo diam porttitor in. Vestibulum  fermentum tortor eget neque maximus tempor. 2\r\n\r\nProin varius consequat purus non egestas. Proin sit amet malesuada nunc. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed volutpat convallis lobortis. Nullam elit justo, lacinia eget nunc interdum, gravida maximus nunc. Aliquam scelerisque imperdiet maximus. Sed efficitur, tortor a volutpat mollis, lorem velit dictum lacus, in malesuada odio velit non ex. In ut dui at tortor venenatis viverra ut eu nunc. Phasellus sit amet mauris a leo hendrerit cursus in eu ipsum. Fusce nisl lacus, fermentum in tincidunt id, varius eu ex. Cras tristique augue id magna porta, dignissim dapibus leo tempor. Duis tempus felis vel faucibus mollis. Cras at nulla quis erat dignissim commodo et ut arcu. Quisque sollicitudin dui at nibh dictum, nec porta nulla tempor. Aliquam nisi libero, volutpat a interdum vel, congue non justo.', 94, '2023-10-20 23:22:28', '2023-10-20 23:23:30');

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

--
-- Table structure for table `product_categories`
--

CREATE TABLE `product_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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 `product_categories`
--

INSERT INTO `product_categories` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Software Development/Customization', '2023-10-21 07:36:19', '2023-10-22 07:36:19'),
(2, 'Cyber Security Services', '2023-10-21 07:36:48', NULL),
(3, 'VAR/Software Implementation', NULL, NULL),
(4, 'Other', NULL, NULL),
(7, 'db product category', NULL, NULL);

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` 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 `sliders`
--

INSERT INTO `sliders` (`id`, `title`, `image`, `created_at`, `updated_at`) VALUES
(1, 'Slider 1', '1698197441.jpg', '2023-10-13 06:16:30', '2023-10-24 19:30:41'),
(2, 'Slider 2', '1698197588.jpg', '2023-10-13 06:22:29', '2023-10-24 19:33:08'),
(3, 'Slider 3', '1698197683.jpg', '2023-10-13 07:16:05', '2023-10-24 19:34:43');

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

--
-- Table structure for table `speakers`
--

CREATE TABLE `speakers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `designation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `working_place` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` 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;

--
-- Dumping data for table `speakers`
--

INSERT INTO `speakers` (`id`, `name`, `image`, `designation`, `email`, `phone`, `type`, `working_place`, `details`, `created_at`, `updated_at`) VALUES
(33, 'Prof. Oscar Hudson', 'image-2.jpg', 'Founder', 'mparker@example.org', '458-240-5692', 'Keynote Presenter', 'ATN Bangla', 'Omnis et vel repellat quo ipsa numquam id. Dignissimos animi error temporibus eum aut nulla inventore. Blanditiis itaque est quam nam est. Est quos vel quo ut et quo ea. Aperiam quam aut non suscipit illo expedita alias. Nisi earum sed enim amet adipisci est. Mollitia ut voluptatem optio nemo non animi ad. Doloremque et occaecati veniam consequatur. Facilis exercitationem ut nisi. Accusamus impedit ex iste vero esse est sed.', '2023-10-16 21:57:28', '2023-10-16 21:57:28'),
(34, 'Brice Gutmann', 'image-4.jpg', 'President', 'graham.gerry@example.org', '952-973-2990', 'Keynote Presenter', 'FDC', 'Et voluptatem reprehenderit id ad vel eos nisi. Ad similique perspiciatis quasi nobis voluptatem. Quaerat accusantium aut enim dolorum. Excepturi quae alias tempore doloribus repellat dolores officiis. Molestiae blanditiis harum dolore sit ad. A ut quam ut ad ut. Sit perferendis adipisci aut ipsam commodi magni quisquam. Nobis quas quam recusandae. Facilis similique ipsum nihil voluptatem cupiditate natus voluptas.', '2023-10-16 21:57:28', '2023-10-16 21:57:28'),
(35, 'Jamal Labadie', 'image-5.jpg', 'Actor', 'ezulauf@example.net', '317-219-2773', 'Speaker', 'FDC', 'Itaque eligendi nostrum aut explicabo eum. Eos necessitatibus placeat illo explicabo unde consequuntur corrupti sit. Delectus quisquam eum blanditiis. Repellat accusantium vitae et et accusantium officiis. Nesciunt eveniet laudantium voluptatum repellat numquam consequuntur aliquam.', '2023-10-16 21:57:28', '2023-10-16 21:57:28'),
(36, 'Alanis Schimmel', 'image-2.jpg', 'CEO', 'wwunsch@example.net', '1-574-250-8317', 'Guest Speaker', 'ATN Bangla', 'Repudiandae illo officia laboriosam saepe atque. Neque eaque vel dignissimos autem. Accusantium aut est omnis et illum quis. Cum autem eos iusto ut. Voluptatem provident omnis sit deserunt esse velit rerum. Praesentium inventore excepturi debitis suscipit sit. Id ad incidunt eos unde. Et ipsum omnis mollitia numquam voluptas. Maxime ut occaecati facere omnis quasi molestias. Laboriosam est et repudiandae et blanditiis porro magnam. Dolorum qui sit ut aliquid quod.', '2023-10-16 21:57:28', '2023-10-16 21:57:28'),
(37, 'Willard Kessler Sr.', 'image-2.jpg', 'CEO', 'aryanna70@example.org', '828-567-2037', 'Guest Speaker', 'Channel I Bangladesh', 'Dolor iure perferendis totam aspernatur ab vero. Consequuntur corporis asperiores voluptatem dicta facilis nesciunt nesciunt quo. Est quia sit quia ipsam esse quam. Deserunt accusamus neque aut quibusdam aliquam architecto. Dolor est voluptatibus dolorem odit rerum. Veniam inventore doloribus aperiam enim consectetur molestias temporibus. Dicta ab similique sed nam dolorem omnis sapiente. Sint fugiat molestias incidunt totam quidem nostrum.', '2023-10-16 21:57:28', '2023-10-16 21:57:28'),
(38, 'Nedra Kessler', 'image-5.jpg', 'Founder', 'jocelyn47@example.net', '+15516987133', 'Speaker', 'Bongo Entertainment', 'Non voluptatem quia cumque. Enim ut molestiae dolor rerum et cupiditate nihil. Dolores laborum sint aut provident in laudantium. Iste quis corrupti ut quidem temporibus laudantium. Vel odio odit sed sint accusantium ipsam et. Sunt et voluptatibus ut est magni. Ducimus nemo sapiente corporis ut. Nemo ut tenetur aut libero quasi doloribus fuga. Animi quis dicta doloribus laborum dolor. Tempora voluptate maiores et. Quis delectus sint temporibus ut consectetur dolorem. Qui dolorem animi iure quos fugit et hic.', '2023-10-16 21:57:28', '2023-10-16 21:57:28'),
(39, 'Dr. Erna Conn DVM', 'image-3.jpg', 'Actor', 'luella.rau@example.com', '+1.220.340.9901', 'Keynote Presenter', 'Bongo Entertainment', 'Quam sit voluptatibus odit. Voluptatum impedit nobis minima necessitatibus consectetur. Possimus voluptas velit unde ea delectus et. Natus velit quam nisi eum. Occaecati quos odit et quos ab temporibus. Blanditiis numquam veniam porro eius blanditiis. In eos doloremque inventore iusto explicabo est id culpa. Accusantium dolor beatae est molestiae sit fuga tempore.', '2023-10-16 21:57:28', '2023-10-16 21:57:28'),
(40, 'Lionel Fisher', 'image-3.jpg', 'President', 'hoyt.jacobson@example.com', '+1 (978) 736-0581', 'Keynote Presenter', 'Tiger IT Limited', 'Omnis velit omnis amet deserunt. Qui enim quis ipsa delectus maxime ab illo. Sunt qui rem similique cum omnis eos in. Atque unde iusto nihil enim placeat et. Error dicta velit sint et nostrum quibusdam. Eos perferendis iure aliquam doloribus nam. Enim eveniet sit quia perspiciatis deserunt sit.', '2023-10-16 21:57:28', '2023-10-16 21:57:28'),
(41, 'Ursula Kirlin', 'image.jpg', 'Vice President', 'hickle.dahlia@example.com', '1-351-864-3282', 'Speaker', 'ATN Bangla', 'Repudiandae occaecati sed accusantium dolores sed. Quibusdam vel inventore necessitatibus est aliquam ex deleniti. Modi suscipit quia laudantium dolor sit aliquid. Doloribus qui blanditiis perspiciatis ut harum vel. Et nihil non molestiae. Magnam nihil modi consequuntur magni repudiandae totam dicta. Impedit qui et debitis enim qui velit. Ducimus saepe tenetur optio quam et iure aut. Quia omnis aspernatur non velit nam. Quas neque magni nihil molestiae dolorem et.', '2023-10-16 21:57:28', '2023-10-16 21:57:28'),
(42, 'Mona Tremblay', 'image-2.jpg', 'Founder', 'frami.lottie@example.org', '+1-743-386-3902', 'Guest Speaker', 'Bongo Entertainment', 'Omnis expedita ipsa temporibus sit. Laboriosam at fuga ratione labore. Ut blanditiis voluptas non. Dolores quo et quos et sit. Ut aut accusantium voluptate quibusdam numquam doloribus veniam. Et nostrum voluptatem labore minima. Ea porro adipisci voluptas quisquam. Aliquam accusamus distinctio corporis et ex quia reprehenderit. Id sequi dolores nihil sit qui. Ipsa voluptatem similique voluptatem dicta et ipsa ipsa quos. Praesentium ut ab optio adipisci est itaque. Aliquam officiis rerum ea beatae ipsa.', '2023-10-16 21:57:28', '2023-10-16 21:57:28'),
(43, 'Woodrow Witting', 'image-3.jpg', 'Vice President', 'emil.beatty@example.com', '(769) 484-2077', 'Keynote Presenter', 'Tiger IT Limited', 'Neque officia aut expedita et animi. Iste ut voluptas vero. Autem magnam non qui non quia excepturi aut. Hic provident sequi quia cupiditate quia vero fugit. Facilis dolorem qui sed labore veniam voluptates veritatis omnis. Assumenda ullam iure voluptas minus velit iure. Ut id autem eaque. Dolor pariatur tempora qui id dolorem pariatur ut. Possimus vel necessitatibus id sed velit non. Nihil dolores maiores nobis velit.', '2023-10-16 21:57:28', '2023-10-16 21:57:28'),
(44, 'Prudence Hackett', 'image-5.jpg', 'CEO', 'myah.gorczany@example.com', '763.399.8588', 'Keynote Presenter', 'Tiger IT Limited', 'Praesentium saepe in hic consequatur. Hic unde iusto nostrum consequatur delectus tenetur qui. Dolor soluta unde repellat alias similique. Quam et suscipit aliquam exercitationem non blanditiis. Amet nesciunt quis voluptas. Corrupti praesentium earum repellat accusantium id aut. Suscipit quisquam sed ut maiores ipsa eveniet. Facilis harum repudiandae unde a expedita sit. Commodi qui aliquid tempora ratione molestias vitae dicta. Alias consectetur et ab doloremque est repellendus sequi. Necessitatibus esse aut voluptas est sequi iusto qui non.', '2023-10-16 21:57:28', '2023-10-16 21:57:28'),
(45, 'Mayra Rohan', 'image-2.jpg', 'President', 'irobel@example.net', '1-424-413-0425', 'Keynote Presenter', 'Channel I Bangladesh', 'Omnis nisi et odio consequuntur et provident ullam. Tenetur beatae aut accusantium at. Et distinctio cum sapiente perferendis illo. Impedit eum molestiae itaque. Molestias quis quam consequatur ea unde temporibus alias. Quod et sint placeat ducimus voluptate quia. Delectus itaque voluptatum eveniet neque officia consequatur. Numquam est quia voluptatum rerum minus repellat veritatis. Culpa eum tenetur et consequatur repellat. Enim qui rerum reprehenderit voluptas. Aut fugiat aliquam fugiat nihil reprehenderit non.', '2023-10-16 21:57:28', '2023-10-16 21:57:28'),
(46, 'Helena Schuppe DDS', 'image.jpg', 'President', 'blakin@example.net', '949-648-1282', 'Speaker', 'ATN Bangla', 'Voluptatum quia sit eaque architecto accusantium. Numquam est non doloribus optio. Vero quo nostrum cum mollitia quos ut possimus qui. Quas distinctio ad est officia eum. Laborum hic vel voluptas unde pariatur deleniti natus. Et unde quia sed animi quia perferendis et. Assumenda voluptatem molestiae odio sit molestias. Consequatur voluptatibus non rerum consequatur deleniti.', '2023-10-16 21:57:28', '2023-10-16 21:57:28'),
(47, 'Arvel Abbott DDS', 'image-3.jpg', 'Vice President', 'stoltenberg.cyrus@example.net', '+1-346-623-3137', 'Keynote Presenter', 'ATN Bangla', 'Sit quis nobis magni sunt dolorem ea. Dolor ut ullam est iure. Qui reprehenderit et perspiciatis ut libero. Nemo porro iste et similique. Dicta iste illo perspiciatis qui esse non quibusdam. Sapiente qui est occaecati quas sed aut deserunt.', '2023-10-16 21:57:28', '2023-10-16 21:57:28'),
(48, 'Bethany Wilderman', 'image-4.jpg', 'CEO', 'reichert.maurine@example.org', '1-231-475-9496', 'Keynote Presenter', 'Tiger IT Limited', 'Ea sit natus et nisi temporibus. Distinctio et aspernatur quisquam ab. Vero illo velit reprehenderit enim maxime aperiam aut. Dolorem ut voluptas eos id libero animi et eligendi. Omnis nostrum et accusamus. Et sint rerum repellendus ipsam. Debitis unde vel sed quasi suscipit. Voluptas nihil amet maiores ipsa labore molestias dolores. Id nihil repellat expedita est non. Aut labore doloremque molestiae. Eum omnis suscipit est autem consequatur sint.', '2023-10-16 21:57:28', '2023-10-16 21:57:28'),
(49, 'Greyson Eichmann', 'image-5.jpg', 'Vice President', 'bernardo.marks@example.org', '+19142073725', 'Keynote Presenter', 'Bongo Entertainment', 'Sit atque ducimus consequatur ratione. Nostrum nihil ut quia repellendus nihil quia. Cum ut odit occaecati. Et est at sed fugiat laboriosam perspiciatis. Rerum quaerat laudantium aut corporis. Dolor sed recusandae in laborum consequatur. Et vel ipsum temporibus non in. Dolores voluptas sit eligendi incidunt enim. Vel exercitationem unde eligendi libero vel nemo cupiditate. Cum aut laudantium vitae aut deserunt fugiat. Omnis voluptatem facere eum iusto amet.', '2023-10-16 21:57:28', '2023-10-16 21:57:28'),
(50, 'Kellie Upton', 'image-3.jpg', 'CEO', 'peichmann@example.com', '1-541-404-2240', 'Speaker', 'FDC', 'Occaecati quidem voluptatem a voluptatibus. Itaque hic perspiciatis est adipisci neque. Omnis et eum voluptatem in eveniet rerum qui sint. Sequi deserunt esse ullam atque et architecto. Totam sed est quos aliquid soluta. Provident ut ea culpa. Corporis sunt in aut odio mollitia. Incidunt et qui eum a cum qui.', '2023-10-16 21:57:28', '2023-10-16 21:57:28');

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

--
-- Table structure for table `visitors`
--

CREATE TABLE `visitors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `visitor_id_card` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profession` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gender` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `education` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zip_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linkedin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `youtube` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `visitors`
--

INSERT INTO `visitors` (`id`, `name`, `image`, `visitor_id_card`, `phone`, `profession`, `email`, `gender`, `address`, `created_at`, `updated_at`, `user_id`, `education`, `organization`, `designation`, `zip_code`, `city`, `facebook`, `linkedin`, `youtube`, `twitter`) VALUES
(77, 'Gladyce Donnelly', 'image-3.jpg', '80050a3a-225f-3356-80dd-e5c67c42a522', '+1-561-398-9851', 'Business Man', 'kaia22@example.org', 'Female', '9916 Green Rapid\nLake Wymanport, NY 36816', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(78, 'Herbert Rippin', 'image-2.jpg', 'f0343788-cb7d-39c3-8bd3-99ae5b7cc622', '(283) 893-0022', 'Engineer', 'greenfelder.marielle@example.org', 'Male', '5600 Zoey View Apt. 033\nToreystad, MS 77609-7474', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(79, 'Prof. Michale Parker', 'image-5.jpg', 'bfd9f985-846c-36d9-927c-dcbc88f34350', '843.757.1416', 'Business Man', 'swift.toby@example.org', 'Male', '50488 Naomi Forges Apt. 563\nPort Russ, LA 90923', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(80, 'Dr. Aron Powlowski III', 'image.jpg', '5de8c799-6d43-34ab-9441-04f4bdafeb94', '929.968.5292', 'Student', 'beer.letitia@example.org', 'Male', '9899 Raymond Trace\nMetzfort, IA 05960', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(81, 'Robert Rempel', 'image-2.jpg', 'a62aa80f-350d-3a72-8760-6bac32d0c206', '772-671-9795', 'Engineer', 'amari.lakin@example.com', 'Female', '253 Marquardt Village Suite 295\nBeulahton, VA 57080', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(82, 'Kamron Mueller', 'image-4.jpg', 'b824b975-5633-3d1e-9913-87a358541af3', '1-209-486-5083', 'Teacher', 'raegan70@example.net', 'Female', '8980 Braun Mount Apt. 175\nLake Deontae, NC 48339-8057', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(83, 'Kayleigh McKenzie', 'image.jpg', '60eeb012-3a14-36ff-a511-226e76247bb8', '(531) 251-0937', 'Teacher', 'beaulah86@example.org', 'Male', '2735 Sydni Expressway\nMillerburgh, MT 28282-0335', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(84, 'Brown Hane', 'image-2.jpg', 'd2ec8886-9ccb-3d7b-bcec-8d0d82abf6fc', '858.977.3678', 'Business Man', 'myrtie78@example.org', 'Female', '67949 Oberbrunner Vista\nWest Marco, NV 87349-8434', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(85, 'Wendy Wehner', 'image-4.jpg', '3aebe52b-83fe-3f22-80d9-3cb519a386de', '1-414-949-9294', 'Business Man', 'brant55@example.net', 'Female', '863 Sporer Knolls\nKundeport, KY 44739-4386', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(86, 'Felipe Dooley MD', 'image-4.jpg', '93721ba0-7d9d-3229-bdaa-6f76b0d36328', '+1 (813) 921-3743', 'Student', 'jules74@example.net', 'Female', '1449 Zboncak Walk Apt. 767\nLowestad, SD 86419-0430', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(87, 'Jerome Grady', 'image-5.jpg', '8a6ba30f-b4e5-3929-af92-549f559ec023', '1-352-337-4860', 'Engineer', 'gust.sauer@example.net', 'Female', '8167 Rice Motorway\nLake Francismouth, PA 32846-7398', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(88, 'Prof. Clementine Tremblay V', 'image-5.jpg', '2a8403b5-a1a4-351b-af0e-545088008038', '912.454.3436', 'Business Man', 'plangosh@example.net', 'Female', '6976 Orrin Prairie Suite 169\nWest Kaylinberg, NM 45765', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(89, 'Cristina Orn', 'image-5.jpg', 'fc3f5b14-0b40-3ff3-a998-6a4b9f1a7f5e', '1-689-529-0673', 'Business Man', 'adele.dare@example.org', 'Female', '925 Dooley Rue\nDickinsonfort, WV 62206-2873', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(90, 'Abigale Doyle', 'image-2.jpg', '6b3fe1be-904f-33b1-8ba3-b78476ac891e', '(907) 372-3063', 'Business Man', 'karlee46@example.com', 'Female', '8618 West Gateway\nPort Miracle, NM 87129-1366', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(91, 'Ramona Sawayn', 'image-4.jpg', '8ff209fe-9542-31e0-88d3-b53d500c4fd4', '+1-484-630-4519', 'Student', 'tlubowitz@example.net', 'Male', '9457 Jerrold Hollow Apt. 137\nWest Christelle, AL 42166', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(92, 'Ashlynn Corkery', 'image-3.jpg', '8702b895-7cb0-39ae-8ad6-43ed97d1c6a4', '918-570-3406', 'Business Man', 'kozey.marcelina@example.com', 'Female', '84543 Wiegand Dam\nRyanstad, KY 20707', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(93, 'Ansel Trantow', 'image-4.jpg', 'e29863b3-1bb2-3974-87d6-b49a4b251abf', '+1-575-536-8033', 'Doctor', 'camylle64@example.org', 'Male', '338 Borer Underpass\nHaaghaven, NM 28459', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(100, 'Clarabelle Bartell', 'image-4.jpg', 'deb6c758-88aa-380c-9c77-75dcaaee8997', '248-446-4566', 'Business Man', 'aimee29@example.com', 'Male', '6031 Huels Park\nDarrinville, MD 37878', '2023-10-16 09:12:31', '2023-10-16 09:12:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(101, 'New Visitor', '1697855584.jpg', 'EVM-VIS-0101', '0991818181', 'Business Man', 'nvisitor@gmail.com', 'male', 'Dhaka', '2023-10-20 20:33:04', '2023-10-20 20:33:04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(102, 'Test Visitor2', '1697949857.jpg', 'EVM-VIS-0102', '99889911', 'Engineer', 'nvisitor2@gmail.com', 'female', 'Dummy Address Dhaka', '2023-10-21 05:08:36', '2023-10-21 23:58:14', 67, 'Graduation', 'Bangladesh Army', 'Site Engineer', '4210', 'Dhaka', 'www.facebook.com', 'www.linkedin.com', 'www.youtube.com', 'www.twitter.com'),
(103, 'Test Visitor 3', '1697989580.jpg', 'EVM-VIS-0103', '922828282', 'Business Man', 'nvisitor3@gmail.com', 'male', 'New Market, Chittagong', '2023-10-22 09:46:20', '2023-10-22 09:46:20', 68, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(104, 'Visitor Jisan', NULL, 'EVM-VIS-0104', NULL, NULL, 'visitorjisan3@gmail.com', NULL, NULL, '2023-10-23 20:44:11', '2023-10-23 20:44:11', 71, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(105, 'visitor jisan 4', NULL, 'EVM-VIS-0105', NULL, NULL, 'visitorjisan4@gmail.com', NULL, NULL, '2023-10-23 20:49:42', '2023-10-23 20:49:42', 72, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(106, 'Visitor Jisan 5', NULL, 'EVM-VIS-0106', NULL, NULL, 'visitorjisan5@gmail.com', NULL, NULL, '2023-10-23 21:33:52', '2023-10-23 21:33:52', 73, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(107, 'Jisank', NULL, 'EVM-VIS-0107', '123456', NULL, 'visitor@gmail.com', NULL, 'dhaka', '2023-10-24 10:04:32', '2023-10-25 03:57:31', 74, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `visitor_mega_events`
--

CREATE TABLE `visitor_mega_events` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `visitor_id` bigint(20) UNSIGNED NOT NULL,
  `mega_event_id` bigint(20) UNSIGNED 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 `visitor_mega_events`
--

INSERT INTO `visitor_mega_events` (`id`, `visitor_id`, `mega_event_id`, `created_at`, `updated_at`) VALUES
(1, 102, 10, '2023-10-22 07:27:05', '2023-10-22 07:27:05'),
(7, 102, 15, '2023-10-22 07:46:54', '2023-10-22 07:46:54'),
(20, 102, 7, '2023-10-22 09:18:59', '2023-10-22 09:18:59'),
(22, 103, 15, '2023-10-22 10:00:51', '2023-10-22 10:00:51');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `exhibitors`
--
ALTER TABLE `exhibitors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `exhibitors_user_id_foreign` (`user_id`);

--
-- Indexes for table `exhibitor_visitor`
--
ALTER TABLE `exhibitor_visitor`
  ADD PRIMARY KEY (`id`),
  ADD KEY `exhibitor_visitor_exhibitor_id_foreign` (`exhibitor_id`),
  ADD KEY `exhibitor_visitor_visitor_id_foreign` (`visitor_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 `guests`
--
ALTER TABLE `guests`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `guests_email_unique` (`email`);

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

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

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

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

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

--
-- Indexes for table `product_categories`
--
ALTER TABLE `product_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `product_categories_name_unique` (`name`);

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

--
-- Indexes for table `speakers`
--
ALTER TABLE `speakers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `speakers_email_unique` (`email`);

--
-- Indexes for table `visitors`
--
ALTER TABLE `visitors`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `visitors_visitor_id_card_unique` (`visitor_id_card`),
  ADD UNIQUE KEY `visitors_email_unique` (`email`),
  ADD KEY `visitors_user_id_index` (`user_id`);

--
-- Indexes for table `visitor_mega_events`
--
ALTER TABLE `visitor_mega_events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `visitor_mega_event_visitor_id_foreign` (`visitor_id`),
  ADD KEY `visitor_mega_event_mega_event_id_foreign` (`mega_event_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `exhibitors`
--
ALTER TABLE `exhibitors`
  ADD CONSTRAINT `exhibitors_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `exhibitor_visitor`
--
ALTER TABLE `exhibitor_visitor`
  ADD CONSTRAINT `exhibitor_visitor_exhibitor_id_foreign` FOREIGN KEY (`exhibitor_id`) REFERENCES `exhibitors` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `exhibitor_visitor_visitor_id_foreign` FOREIGN KEY (`visitor_id`) REFERENCES `visitors` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_exhibitor_id_foreign` FOREIGN KEY (`exhibitor_id`) REFERENCES `exhibitors` (`id`);

--
-- Constraints for table `visitors`
--
ALTER TABLE `visitors`
  ADD CONSTRAINT `visitors_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `visitor_mega_events`
--
ALTER TABLE `visitor_mega_events`
  ADD CONSTRAINT `visitor_mega_event_mega_event_id_foreign` FOREIGN KEY (`mega_event_id`) REFERENCES `mega_events` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `visitor_mega_event_visitor_id_foreign` FOREIGN KEY (`visitor_id`) REFERENCES `visitors` (`id`) ON DELETE CASCADE;
COMMIT;

