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

START TRANSACTION;



--
-- Database: `diutestweb1_icaeee`
--

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

--
-- Table structure for table `amenities`
--

CREATE TABLE `amenities` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `amenities`
--

INSERT INTO `amenities` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Regular Seating', '2023-10-05 01:30:31', '2023-10-05 01:30:31', NULL),
(2, 'Coffee Break', '2023-10-05 01:30:31', '2023-10-05 01:30:31', NULL),
(3, 'Custom Badge', '2023-10-05 01:30:31', '2023-10-05 01:30:31', NULL),
(4, 'Community Access', '2023-10-05 01:30:31', '2023-10-05 01:30:31', NULL),
(5, 'Workshop Access', '2023-10-05 01:30:31', '2023-10-05 01:30:31', NULL),
(6, 'After Party', '2023-10-05 01:30:31', '2023-10-05 01:30:31', NULL);

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

--
-- Table structure for table `amenity_price`
--

CREATE TABLE `amenity_price` (
  `price_id` int UNSIGNED NOT NULL,
  `amenity_id` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `amenity_price`
--

INSERT INTO `amenity_price` (`price_id`, `amenity_id`) VALUES
(1, 1),
(1, 2),
(1, 3),
(2, 1),
(2, 2),
(2, 3),
(2, 4),
(3, 1),
(3, 2),
(3, 3),
(3, 4),
(3, 5),
(3, 6);

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

--
-- Table structure for table `authors`
--

CREATE TABLE `authors` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `authors`
--

INSERT INTO `authors` (`id`, `name`, `email`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Tanvir Ahmed Chowdhury', 'tahmed@daffodilvarsity.edu.bd', '1', '2023-10-21 01:09:32', '2023-10-21 01:09:32', NULL),
(2, 'Ibrahim Hossain', 'Ibrahim.taf@diu.edu.bd', '1', '2023-10-21 01:10:43', '2023-10-21 01:10:43', NULL),
(3, 'K. M. Elias', 'kazi-elias@ttsl-bd.com', '1', '2023-10-21 01:12:03', '2023-10-21 01:12:03', NULL),
(4, 'M. O. Rahman', 'morahman@juniv.edu', '1', '2023-10-21 01:12:03', '2023-10-21 01:12:03', NULL),
(5, 'H.M. Zakir Hossain', 'engrzakir20009@yahoo.com', '1', '2023-10-21 01:12:03', '2023-10-21 01:12:03', NULL),
(6, 'Mahashinuzzaman Shishir', 'mahashinzaman20@gmail.com', '1', '2023-10-21 01:14:25', '2023-10-21 01:14:25', NULL),
(7, 'Mainul Morshed', 'mainul.te@diu.edu.bd', '1', '2023-10-21 03:05:01', '2023-10-21 03:05:01', NULL),
(8, 'Md. Al Amin Howldaer', 'tex89.rnd@gmail.com', '1', '2023-10-21 03:07:34', '2023-10-21 03:07:34', NULL),
(9, 'Md Mahbubul Haque', 'drhaque@diu.edu.bd', '1', '2023-10-21 03:07:34', '2023-10-21 03:07:34', NULL),
(10, 'Md. Asaduzzaman Rony', 'mdronytangail@gmail.com', '1', '2023-10-21 03:08:55', '2023-10-21 03:08:55', NULL),
(11, 'Md. Asib Iqbal', 'asibbjri@gmail.com', '1', '2023-10-21 03:10:59', '2023-10-21 03:10:59', NULL),
(12, 'Jannatul Bake Molla', 'parvez31tex@gmail.com', '1', '2023-10-21 03:10:59', '2023-10-21 03:10:59', NULL),
(13, 'Mohammad Moniruzzaman', 'monir_bjri@yahoo.com', '1', '2023-10-21 03:10:59', '2023-10-21 03:10:59', NULL),
(14, 'Md. Ebrahim Shaikh', 'ebrahim.shaikh@seu.edu.bd', '1', '2023-10-21 03:11:34', '2023-10-21 03:11:34', NULL),
(15, 'Md. Farhad Hossain', 'farhadhossain.te@diu.edu.bd', '1', '2023-10-21 03:13:07', '2023-10-21 03:13:07', NULL),
(16, 'Md. Kamrul Islam', 'kamrulislam.te@diu.edu.bd', '1', '2023-10-21 03:13:07', '2023-10-21 03:13:07', NULL),
(17, 'Hasan Mazharul Haque', 'mazharulbutex42@gmail.com', '1', '2023-10-21 03:13:07', '2023-10-21 03:13:07', NULL),
(18, 'Udoy Chand Panditd', 'udoy.pandit@sqgc.com', '1', '2023-10-21 03:13:07', '2023-10-21 03:13:07', NULL),
(19, 'Md. Hamim Khan', 'hamimtex316@gmail.com', '1', '2023-10-21 03:14:11', '2024-01-29 00:25:34', NULL),
(20, 'Kallol Saha', 'kallol23-5658@diu.edu.bd', '1', '2023-10-21 03:14:11', '2023-10-21 03:14:11', NULL),
(21, 'Md. Manik Parvez', 'parvez.te@diu.edu.bd', '1', '2023-10-21 03:14:38', '2023-10-21 03:14:38', NULL),
(22, 'Md. Mashud Raihan', 'masudraihan@daffodilvarsity.edu.bd', '1', '2023-10-21 03:15:20', '2023-10-21 03:15:20', NULL),
(23, 'Md. Abdul Motaleb', 'motaleb23-4386@diu.edu.bd', '1', '2023-10-21 03:15:20', '2023-10-21 03:15:20', NULL),
(24, 'Md. Sakhawat Hossain Rizvi', 'rizvi.universaldenim@gmail.com', '1', '2023-10-21 03:15:59', '2023-10-21 03:15:59', NULL),
(25, 'Mohammad Noor Nabi', 'nabi32-434@diu.edu.bd', '1', '2023-10-21 03:16:43', '2023-10-21 03:16:43', NULL),
(26, 'Mohammad Tauhiduzzaman', 'tauhiduzaman.te@diu.edu.bd', '1', '2023-10-21 03:17:23', '2023-10-21 03:17:23', NULL),
(27, 'Moshiur Rahman', 'md.moshiur2008@gmail.com', '1', '2023-10-21 03:17:57', '2023-10-21 03:17:57', NULL),
(28, 'Sanjib Kumar Talapatara', 's.k.talapatara@gmail.com', '1', '2023-10-21 03:19:31', '2023-10-21 03:19:31', NULL),
(29, 'Md. Obaidullah Kisar', 'mokaisar@yahoo.com', '1', '2023-10-21 03:19:31', '2023-10-21 03:19:31', NULL),
(30, 'Subrata Majudmer', 'subrata.te@daffodilvarsity.edu.bd', '1', '2023-10-21 03:21:00', '2023-10-21 03:21:00', NULL),
(31, 'Adnan Sanzid', 'adnansanzid154@gmail.com', '1', '2023-10-21 03:21:00', '2023-10-21 03:21:00', NULL),
(32, 'Suzon Kumar Paul', 'suzon.ged0227.c@diu.edu.bd', '1', '2023-10-21 03:21:42', '2023-10-21 03:21:42', NULL),
(33, 'Mohammad Mizanur Rahman Khan', 'mmrkhan-che@sust.edu', '1', '2023-10-21 03:21:42', '2023-10-21 03:21:42', NULL),
(34, 'Syed Iftakhar Ahmad', 'syed.iftakhar@seu.edu.bd', '1', '2023-10-22 00:01:08', '2023-10-22 00:01:08', NULL),
(35, 'Nazmul Haque Bappy', 'hoque32-435@diu.edu.bd', '1', '2023-10-25 03:24:25', '2023-10-25 03:24:25', NULL),
(36, 'Shreerup Bhattacharjee', 'shreer23-892@diu.edu.bd', '1', '2024-01-29 00:28:29', '2024-01-29 00:28:29', NULL),
(37, 'Alamgir Hossain', 'alamgir588@daffodilvarsity.edu.bd', '1', '2024-04-05 22:43:16', '2024-04-05 22:43:16', NULL),
(38, 'Mst. Murshida Khatun', 'murshida@daffodilvarsity.edu.bd', '1', '2024-04-05 22:51:09', '2024-04-05 22:51:09', NULL),
(39, 'Upama Nasrin', NULL, '1', '2024-04-05 22:51:44', '2024-04-05 22:51:44', NULL),
(40, 'Haqb Bebe Fatema Bristy', NULL, '1', '2024-04-05 22:52:37', '2024-04-05 22:52:37', NULL),
(41, 'Najmus Sakib', NULL, '1', '2024-04-05 22:53:00', '2024-04-05 22:53:00', NULL),
(42, 'Tayyaba Nadeem', 'asfandyar.khan@umt.edu.pk', '1', '2024-04-05 22:55:20', '2024-04-05 22:55:20', NULL),
(43, 'Kashif Javed', NULL, '1', '2024-04-05 22:55:38', '2024-04-05 22:55:38', NULL),
(44, 'Asfandyar Khan', NULL, '1', '2024-04-05 22:55:53', '2024-04-05 22:55:53', NULL),
(45, 'Jahirul Islam Khandaker', NULL, '1', '2024-04-05 22:57:55', '2024-04-05 22:57:55', NULL),
(46, 'Mohammad Abdul Gafur', NULL, '1', '2024-04-05 22:58:11', '2024-04-05 22:58:11', NULL),
(47, 'Naimur Rahman Nipu', NULL, '1', '2024-04-05 22:58:20', '2024-04-05 22:58:20', NULL),
(48, 'Tamrinul Islam Hamim', NULL, '1', '2024-04-05 22:58:31', '2024-04-05 22:58:31', NULL);

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

--
-- Table structure for table `author_book`
--

CREATE TABLE `author_book` (
  `id` bigint UNSIGNED NOT NULL,
  `book_id` bigint UNSIGNED NOT NULL,
  `author_id` bigint UNSIGNED NOT NULL,
  `serial` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `author_book`
--

INSERT INTO `author_book` (`id`, `book_id`, `author_id`, `serial`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 0, NULL, NULL),
(2, 1, 2, 1, NULL, NULL),
(3, 2, 3, 0, NULL, NULL),
(4, 2, 4, 0, NULL, NULL),
(5, 2, 5, 0, NULL, NULL),
(6, 3, 3, 0, NULL, NULL),
(7, 4, 3, 0, NULL, NULL),
(8, 5, 6, 0, NULL, NULL),
(9, 6, 7, 0, NULL, NULL),
(10, 7, 2, 0, NULL, NULL),
(11, 8, 8, 0, NULL, NULL),
(12, 8, 9, 0, NULL, NULL),
(13, 5, 9, 0, NULL, NULL),
(14, 9, 9, 1, NULL, NULL),
(15, 9, 10, 0, NULL, NULL),
(16, 10, 11, 0, NULL, NULL),
(17, 10, 12, 1, NULL, NULL),
(18, 10, 13, 2, NULL, NULL),
(19, 11, 14, 0, NULL, NULL),
(20, 12, 15, 0, NULL, NULL),
(21, 12, 16, 0, NULL, NULL),
(22, 12, 17, 0, NULL, NULL),
(23, 12, 18, 0, NULL, NULL),
(24, 13, 9, 2, NULL, NULL),
(25, 13, 19, 0, NULL, NULL),
(26, 13, 20, 1, NULL, NULL),
(27, 14, 21, 0, NULL, NULL),
(28, 15, 22, 0, NULL, NULL),
(29, 15, 23, 0, NULL, NULL),
(30, 16, 24, 0, NULL, NULL),
(31, 17, 9, 1, NULL, NULL),
(32, 17, 25, 0, NULL, NULL),
(33, 18, 26, 0, NULL, NULL),
(34, 19, 9, 1, NULL, NULL),
(35, 19, 27, 0, NULL, NULL),
(36, 20, 9, 1, NULL, NULL),
(50, 20, 35, 0, NULL, NULL),
(39, 21, 28, 0, NULL, NULL),
(41, 22, 30, 0, NULL, NULL),
(42, 22, 31, 0, NULL, NULL),
(43, 23, 32, 1, NULL, NULL),
(44, 23, 33, 2, NULL, NULL),
(45, 24, 34, 0, NULL, NULL),
(46, 21, 9, 1, NULL, NULL),
(47, 21, 29, 2, NULL, NULL),
(51, 16, 9, 1, NULL, NULL),
(52, 16, 36, 2, NULL, NULL),
(53, 14, 37, 0, NULL, NULL),
(54, 25, 38, 0, NULL, NULL),
(55, 25, 39, 0, NULL, NULL),
(56, 25, 40, 0, NULL, NULL),
(57, 25, 41, 0, NULL, NULL),
(58, 26, 42, 0, NULL, NULL),
(59, 26, 43, 0, NULL, NULL),
(60, 26, 44, 0, NULL, NULL),
(61, 27, 1, 0, NULL, NULL),
(62, 27, 45, 1, NULL, NULL),
(63, 27, 46, 2, NULL, NULL),
(64, 27, 47, 3, NULL, NULL),
(65, 27, 48, 4, NULL, NULL);

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

--
-- Table structure for table `books`
--

CREATE TABLE `books` (
  `id` bigint UNSIGNED NOT NULL,
  `title` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `books`
--

INSERT INTO `books` (`id`, `title`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Preferences on Quality Dimensions While Purchasing Punjabi: A Study in Dhaka City', '1', '2023-10-21 01:09:32', '2023-10-21 01:09:32', NULL),
(2, 'Study the Effect of Polyester Fiber Blend Ratio and Pilling Cycles on Blended Knit Fabrics', '1', '2023-10-21 01:12:03', '2023-10-21 01:12:03', NULL),
(3, 'Effect of Pre-conditioning on Fabric Weight of Different Types of Knit Fabrics', '1', '2023-10-21 01:12:28', '2023-10-21 01:12:28', NULL),
(4, 'Effect of Test Specimen Surface Area of Bursting Strength Test (kPa) on Different Types of Knit Fabric Construction', '1', '2023-10-21 01:13:05', '2023-10-21 01:13:05', NULL),
(5, 'Comparison of Various Test Results Before and After Denim Washing with Reference to Sustainable Production', '1', '2023-10-21 01:14:25', '2023-10-21 01:14:25', NULL),
(6, 'Structure Coloration: A Method of Sustainable Textile Coloration', '1', '2023-10-21 03:05:01', '2023-10-21 03:05:01', NULL),
(7, 'Comparative study of color strength (K/s Value) and color fastness between different fabric composition of the cellulosic and regenerated cellulosic fiber', '1', '2023-10-21 03:05:34', '2023-10-21 03:05:34', NULL),
(8, 'A Case Study Of Costing Of Woven Fabric Using A Computer Software', '1', '2023-10-21 03:07:34', '2023-10-21 03:07:34', NULL),
(9, 'Study on the performance of various lab tests required for denim fabrics and denim garments', '1', '2023-10-21 03:08:55', '2023-10-21 03:08:55', NULL),
(10, 'Optimization scouring recipe for jute and jute caddies for ecological conservation', '1', '2023-10-21 03:10:59', '2023-10-21 03:10:59', NULL),
(11, 'Interrelation among stitch length, input tension, yarn count, and GSM of various knit structures.', '1', '2023-10-21 03:11:34', '2023-10-21 03:11:34', NULL),
(12, 'Comparative analysis of the physical properties of (1×1) Rib and (2×2) Rib knitted fabric made with cotton, viscose, and modal fiber.', '1', '2023-10-21 03:13:07', '2023-10-21 03:13:07', NULL),
(13, 'Study on Water Consumption in Denim Manufacturing using various types of yarns', '1', '2023-10-21 03:14:11', '2023-10-21 03:14:11', NULL),
(14, 'Measures to Improve the Yarn Quality (spindle to spindle) in Ring Frame', '1', '2023-10-21 03:14:38', '2023-10-21 03:14:38', NULL),
(15, 'An investigation of flax yarn properties and its future scope', '1', '2023-10-21 03:15:20', '2023-10-21 03:15:20', NULL),
(16, 'Water efficiency in denim dyeing and pollution management of the textile industry in Bangladesh.', '1', '2023-10-21 03:15:59', '2023-10-21 03:15:59', NULL),
(17, 'Utilization of Textile Waste Fabrics and Used Garments in Concrete Structure', '1', '2023-10-21 03:16:43', '2023-10-21 03:16:43', NULL),
(18, 'Multiscale Modeling of Woven Composite under Ballistic Impact using Finite Element and Molecular Dynamics', '1', '2023-10-21 03:17:23', '2023-10-21 03:17:23', NULL),
(19, 'Impact of Non-Productive Time on Productivity of Basic, Semi-Critical and Critical Garments in Sewing Section.', '1', '2023-10-21 03:17:57', '2023-10-21 03:17:57', NULL),
(20, 'Impacts of Non-Compliance in Sample Submission: A Case Study in the Third-Party Testing Laboratories in Bangladesh', '1', '2023-10-21 03:18:33', '2023-10-21 03:18:33', NULL),
(21, 'Development of insect control nets for agricultural farming in Bangladesh', '1', '2023-10-21 03:19:31', '2023-10-21 03:19:31', NULL),
(22, 'Value Addition Through Switching to Finer Fabric as an Approach Towards The Establishment of Sustainable Weaving Industry in Bangladesh: Economic and Environmental Point Of View', '1', '2023-10-21 03:21:00', '2023-10-21 03:21:00', NULL),
(23, 'Synthesis of PPy-ZnO-ZnS composites for efficient dye and drug removal from waste water', '1', '2023-10-21 03:21:42', '2023-10-21 03:21:42', NULL),
(24, 'A Study on Ozone Wash against Bleaching Wash of Knit Fabric', '1', '2023-10-22 00:01:08', '2023-10-22 00:01:08', NULL),
(25, 'A Review on Life Cycle Assessment of Cotton Denim Jeans: Comparative Analysis on Conventional and Organic Approach', '1', '2024-04-05 22:54:07', '2024-04-05 22:54:07', NULL),
(26, 'Sustainable Dyeing of Wool and Silk with Conocarpus erectus L. Leaf Extract for Development of Functional Textiles', '1', '2024-04-05 22:56:50', '2024-04-05 22:56:50', NULL),
(27, 'Dyeing of Cellulosic Fiber Using Natural Dye and Biordant: An evaluation of Color characteristics', '1', '2024-04-05 22:59:21', '2024-04-05 22:59:21', NULL);

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

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` int UNSIGNED NOT NULL,
  `question` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` (`id`, `question`, `answer`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Earum est vero nihil itaque voluptate incidunt sapiente.', 'Omnis et qui est occaecati quas modi distinctio corrupti. Et qui dolor saepe voluptas et. Eum non nemo et.', '2023-10-05 01:30:31', '2023-10-05 01:30:31', NULL),
(2, 'Nulla maiores fugit veritatis nesciunt.', 'Non consequuntur quaerat fugiat asperiores. Soluta labore natus impedit eaque voluptatem.', '2023-10-05 01:30:31', '2023-10-05 01:30:31', NULL),
(3, 'Cupiditate saepe beatae eos non dolore.', 'Facilis dolores totam aperiam culpa quo temporibus. Atque rerum laudantium dolor nisi. Repudiandae sint animi dolor et vero enim. Saepe voluptatum veritatis illum et illum quia. Ut ipsam dolor tenetur repellat corrupti quia omnis id.', '2023-10-05 01:30:31', '2023-10-05 01:30:31', NULL),
(4, 'Eum unde est sint nulla animi.', 'Quaerat et voluptas eveniet vitae ut placeat. Error doloribus quasi maiores consequatur maxime ex.', '2023-10-05 01:30:31', '2023-10-05 01:30:31', NULL),
(5, 'Quidem corporis enim iure autem.', 'Consequatur sed enim sit quis possimus. Aut a deleniti cupiditate eum dolor. Quam et quo architecto eos aut vero. Et enim tempore animi quo recusandae.', '2023-10-05 01:30:31', '2023-10-05 01:30:31', NULL),
(6, 'Ratione ut repellendus voluptatem cupiditate minima unde cupiditate veniam.', 'Molestiae veniam explicabo voluptas ea reprehenderit odio. Eos soluta rerum saepe et. Eaque ex est ipsam saepe velit vitae.', '2023-10-05 01:30:31', '2023-10-16 02:19:13', '2023-10-16 02:19:13');

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

--
-- Table structure for table `galleries`
--

CREATE TABLE `galleries` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `galleries`
--

INSERT INTO `galleries` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Event', '2023-10-05 01:30:29', '2023-10-05 01:30:29', NULL);

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

--
-- Table structure for table `hotels`
--

CREATE TABLE `hotels` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `rating` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotels`
--

INSERT INTO `hotels` (`id`, `name`, `address`, `description`, `rating`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Hotel 1', NULL, '0.4 Mile from the Venue', 5, '2023-10-05 01:30:29', '2023-10-05 01:30:29', NULL),
(2, 'Hotel 2', NULL, '0.5 Mile from the Venue', 4, '2023-10-05 01:30:29', '2023-10-05 01:30:29', NULL),
(3, 'Hotel 3', NULL, '0.6 Mile from the Venue', 3, '2023-10-05 01:30:29', '2023-10-05 01:30:29', NULL);

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` int UNSIGNED NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `collection_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `conversions_disk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size` bigint UNSIGNED NOT NULL,
  `manipulations` json NOT NULL,
  `custom_properties` json NOT NULL,
  `responsive_images` json NOT NULL,
  `order_column` int 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 `media`
--

INSERT INTO `media` (`id`, `model_type`, `model_id`, `uuid`, `collection_name`, `name`, `file_name`, `mime_type`, `disk`, `conversions_disk`, `size`, `manipulations`, `custom_properties`, `responsive_images`, `order_column`, `created_at`, `updated_at`) VALUES
(1, 'App\\Speaker', 1, '3deedfd3-f41f-43ac-8e77-c71c730b7aba', 'photo', '1', '1.jpg', 'image/jpeg', 'public', 'public', 44376, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 1, '2023-10-05 01:30:27', '2023-10-05 01:30:27'),
(2, 'App\\Speaker', 2, '079e4ea8-a93d-4600-9400-19cf54ba008f', 'photo', '2', '2.jpg', 'image/jpeg', 'public', 'public', 49380, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 2, '2023-10-05 01:30:27', '2023-10-05 01:30:27'),
(3, 'App\\Speaker', 3, 'bc986616-cd82-4fd1-b6e3-8b4e39216a78', 'photo', '3', '3.jpg', 'image/jpeg', 'public', 'public', 14278, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 3, '2023-10-05 01:30:27', '2023-10-05 01:30:27'),
(4, 'App\\Speaker', 4, '20975b53-7e15-42a6-b1cd-d012637146c4', 'photo', '4', '4.jpg', 'image/jpeg', 'public', 'public', 53251, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 4, '2023-10-05 01:30:27', '2023-10-05 01:30:27'),
(5, 'App\\Speaker', 5, '95b5a6ef-d1de-4a5b-8ef9-c4edbeee794f', 'photo', '5', '5.jpg', 'image/jpeg', 'public', 'public', 30301, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 5, '2023-10-05 01:30:27', '2023-10-05 01:30:27'),
(6, 'App\\Speaker', 6, 'cc81780b-7b35-4075-91bd-7a3eed162138', 'photo', '6', '6.jpg', 'image/jpeg', 'public', 'public', 16133, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 6, '2023-10-05 01:30:27', '2023-10-05 01:30:28'),
(15, 'App\\Hotel', 1, 'af22fae1-8a0b-4419-94ee-a018c07124d6', 'photo', '1', '1.jpg', 'image/jpeg', 'public', 'public', 176612, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 15, '2023-10-05 01:30:29', '2023-10-05 01:30:29'),
(16, 'App\\Hotel', 2, 'a2905ee6-b67f-4428-ba65-b26b44fdfb8f', 'photo', '2', '2.jpg', 'image/jpeg', 'public', 'public', 207771, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 16, '2023-10-05 01:30:29', '2023-10-05 01:30:29'),
(17, 'App\\Hotel', 3, '9321425e-58e7-42dc-8179-2f4baa10f33e', 'photo', '3', '3.jpg', 'image/jpeg', 'public', 'public', 164509, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 17, '2023-10-05 01:30:29', '2023-10-05 01:30:29'),
(18, 'App\\Gallery', 1, 'a53b8fd3-8633-4009-be17-ee3859561160', 'photos', '1', '1.jpg', 'image/jpeg', 'public', 'public', 85253, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 18, '2023-10-05 01:30:29', '2023-10-05 01:30:29'),
(19, 'App\\Gallery', 1, '99e28fdf-03be-4978-868f-78672f1503a6', 'photos', '2', '2.jpg', 'image/jpeg', 'public', 'public', 107817, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 19, '2023-10-05 01:30:29', '2023-10-05 01:30:29'),
(20, 'App\\Gallery', 1, '74deebfb-c979-4785-b31c-981645ccb984', 'photos', '3', '3.jpg', 'image/jpeg', 'public', 'public', 182158, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 20, '2023-10-05 01:30:29', '2023-10-05 01:30:29'),
(21, 'App\\Gallery', 1, 'c8a9fd69-7cd7-4599-8030-e8c9789b2f95', 'photos', '4', '4.jpg', 'image/jpeg', 'public', 'public', 112256, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 21, '2023-10-05 01:30:29', '2023-10-05 01:30:30'),
(22, 'App\\Gallery', 1, '945fba7e-aa00-400a-90be-e326e782226d', 'photos', '5', '5.jpg', 'image/jpeg', 'public', 'public', 127200, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 22, '2023-10-05 01:30:30', '2023-10-05 01:30:30'),
(23, 'App\\Gallery', 1, '90a32387-9eec-4ce0-b195-d92895f7143a', 'photos', '6', '6.jpg', 'image/jpeg', 'public', 'public', 57440, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 23, '2023-10-05 01:30:30', '2023-10-05 01:30:30'),
(24, 'App\\Gallery', 1, 'e96d1e28-ab5e-4e0b-8ca6-119f59af1032', 'photos', '7', '7.jpg', 'image/jpeg', 'public', 'public', 64459, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 24, '2023-10-05 01:30:30', '2023-10-05 01:30:30'),
(25, 'App\\Gallery', 1, '170757bd-b4be-4d2a-9a39-f0b2d052f2c7', 'photos', '8', '8.jpg', 'image/jpeg', 'public', 'public', 88287, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 25, '2023-10-05 01:30:30', '2023-10-05 01:30:30'),
(26, 'App\\Sponsor', 1, '9f4b8a05-3263-45ac-8de6-6f1bfdc3674b', 'logo', '1', '1.png', 'image/png', 'public', 'public', 3994, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 26, '2023-10-05 01:30:30', '2023-10-05 01:30:30'),
(27, 'App\\Sponsor', 2, 'd83ec660-330e-435c-a3c3-2e39bf0c5408', 'logo', '2', '2.png', 'image/png', 'public', 'public', 2749, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 27, '2023-10-05 01:30:30', '2023-10-05 01:30:30'),
(28, 'App\\Sponsor', 3, '4f913a8b-1b35-42ed-bb33-94ae512ed21e', 'logo', '3', '3.png', 'image/png', 'public', 'public', 3281, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 28, '2023-10-05 01:30:30', '2023-10-05 01:30:30'),
(29, 'App\\Sponsor', 4, '736d7a97-7f19-4c97-a88c-01fc41214a09', 'logo', '4', '4.png', 'image/png', 'public', 'public', 2201, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 29, '2023-10-05 01:30:30', '2023-10-05 01:30:30'),
(30, 'App\\Sponsor', 5, '9face50e-bf55-411b-81bf-4cab58bb8aae', 'logo', '5', '5.png', 'image/png', 'public', 'public', 3748, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 30, '2023-10-05 01:30:30', '2023-10-05 01:30:30'),
(31, 'App\\Sponsor', 6, '45883cdc-0717-426a-9f12-2330e6037e7a', 'logo', '6', '6.png', 'image/png', 'public', 'public', 2150, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 31, '2023-10-05 01:30:30', '2023-10-05 01:30:30'),
(32, 'App\\Sponsor', 7, 'cfef2089-f298-4efd-a661-94a14a601963', 'logo', '7', '7.png', 'image/png', 'public', 'public', 2195, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 32, '2023-10-05 01:30:31', '2023-10-05 01:30:31'),
(33, 'App\\Sponsor', 8, '3fb6a718-41af-49b2-8a22-69c5835d210e', 'logo', '8', '8.png', 'image/png', 'public', 'public', 1984, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 33, '2023-10-05 01:30:31', '2023-10-05 01:30:31'),
(34, 'App\\Speaker', 1, '1ecd772b-e126-4acf-841a-d55d56e7b73e', 'photo', '652a7aab3956d_convener', '652a7aab3956d_convener.jpg', 'image/jpeg', 'public', 'public', 11761, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 34, '2023-10-14 05:25:33', '2023-10-14 05:25:33'),
(35, 'App\\Speaker', 1, '4db117e7-39ac-4482-86ef-195695fa5e40', 'photo', '652a7c01681ac_Logo-ISTIS', '652a7c01681ac_Logo-ISTIS.jpeg', 'image/jpeg', 'public', 'public', 33679, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 35, '2023-10-14 05:31:15', '2023-10-14 05:31:15'),
(36, 'App\\Speaker', 1, '88a50874-51ec-40df-bd31-57cf37beb0b0', 'photo', '652bba9a3ef85_convener', '652bba9a3ef85_convener.jpg', 'image/jpeg', 'public', 'public', 11761, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 36, '2023-10-15 04:10:37', '2023-10-15 04:10:37'),
(37, 'App\\Speaker', 1, '8d57deb5-e326-41b2-97f5-487449387833', 'photo', '652bbb1a431a8_conve', '652bbb1a431a8_conve.jpg', 'image/jpeg', 'public', 'public', 26692, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 37, '2023-10-15 04:12:44', '2023-10-15 04:12:44'),
(38, 'App\\Speaker', 1, '6bd9c83e-d316-443d-a21d-da9fa2e75b10', 'photo', '652bbb7a6d993_300', '652bbb7a6d993_300.jpg', 'image/jpeg', 'public', 'public', 21839, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 38, '2023-10-15 04:14:20', '2023-10-15 04:14:20'),
(39, 'App\\Speaker', 1, '78fd474c-126d-4a8b-b4c2-6b503a77e34c', 'photo', '652bc5efa645d_350', '652bc5efa645d_350.jpg', 'image/jpeg', 'public', 'public', 17938, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 39, '2023-10-15 04:58:57', '2023-10-15 04:58:57'),
(40, 'App\\Speaker', 1, 'd310303e-4b0d-4f15-a3db-062255bd9314', 'photo', '652bc76a32908_final', '652bc76a32908_final.jpg', 'image/jpeg', 'public', 'public', 22538, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 40, '2023-10-15 05:05:15', '2023-10-15 05:05:15'),
(41, 'App\\Speaker', 2, 'aac0833a-20bd-4fce-8fcd-3ea79b98bbea', 'photo', '652bc7e118dbf_shafiqur', '652bc7e118dbf_shafiqur.jpg', 'image/jpeg', 'public', 'public', 18305, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 41, '2023-10-15 05:07:14', '2023-10-15 05:07:14'),
(42, 'App\\Speaker', 3, 'b6a345ac-3ee6-4711-8fb6-0eb46825663f', 'photo', '652bc865698d4_khosru', '652bc865698d4_khosru.jpg', 'image/jpeg', 'public', 'public', 20808, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 42, '2023-10-15 05:09:54', '2023-10-15 05:09:54'),
(43, 'App\\Sponsor', 1, '3b310393-f34c-476d-aec2-3a9a7a04f884', 'logo', '652bc9a6b2df1_denim', '652bc9a6b2df1_denim.jpg', 'image/jpeg', 'public', 'public', 4693, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 43, '2023-10-15 05:14:48', '2023-10-15 05:14:48'),
(44, 'App\\Sponsor', 2, 'f9ae6fe1-e3e2-4e05-9713-b8ba5e00dce0', 'logo', '652bc9df8a3cd_atc', '652bc9df8a3cd_atc.jpg', 'image/jpeg', 'public', 'public', 4266, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 44, '2023-10-15 05:15:44', '2023-10-15 05:15:44'),
(45, 'App\\Sponsor', 3, '6a1efac4-bfb4-4c6e-ba43-a47370810478', 'logo', '652bca1f80522_smart', '652bca1f80522_smart.jpg', 'image/jpeg', 'public', 'public', 6703, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 45, '2023-10-15 05:16:48', '2023-10-15 05:16:48'),
(46, 'App\\Sponsor', 4, '3f531a12-a091-4e69-b523-6e95be522c39', 'logo', '652bca4ae48ad_akash', '652bca4ae48ad_akash.jpg', 'image/jpeg', 'public', 'public', 6094, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 46, '2023-10-15 05:17:32', '2023-10-15 05:17:32'),
(47, 'App\\Sponsor', 5, '7ef0981c-4a60-44d1-991b-f4ba3b706f22', 'logo', '652bca8d7880d_nipa', '652bca8d7880d_nipa.jpg', 'image/jpeg', 'public', 'public', 5263, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 47, '2023-10-15 05:18:39', '2023-10-15 05:18:39'),
(48, 'App\\Sponsor', 6, 'bc9ef8cc-a48b-41b9-a2c5-90c06b7e8ba0', 'logo', '652bcac7133c2_nz', '652bcac7133c2_nz.jpg', 'image/jpeg', 'public', 'public', 6078, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 48, '2023-10-15 05:19:36', '2023-10-15 05:19:36'),
(49, 'App\\Sponsor', 7, 'a59f0b1d-ae60-440a-a695-c797152abafa', 'logo', '652bcaf82b1ab_para', '652bcaf82b1ab_para.jpg', 'image/jpeg', 'public', 'public', 5212, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 49, '2023-10-15 05:20:25', '2023-10-15 05:20:25'),
(50, 'App\\Sponsor', 8, '34d9a20e-c05f-4a48-a8f0-e4b7cc5bc05a', 'logo', '652bcb2188969_hams', '652bcb2188969_hams.jpg', 'image/jpeg', 'public', 'public', 2554, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 50, '2023-10-15 05:21:07', '2023-10-15 05:21:07'),
(52, 'App\\Venue', 1, 'c00ac1fc-56ec-437b-9ae4-e71dcc284c0b', 'photos', '652bccc394c0b_diu', '652bccc394c0b_diu.jpeg', 'image/jpeg', 'public', 'public', 234905, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 51, '2023-10-15 05:28:06', '2023-10-15 05:28:06'),
(54, 'App\\Venue', 1, '447c4e02-59b1-4866-9787-0d48b56c6641', 'photos', '652bcd16b3b38_bg6', '652bcd16b3b38_bg6.jpeg', 'image/jpeg', 'public', 'public', 135688, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 52, '2023-10-15 05:29:29', '2023-10-15 05:29:29'),
(57, 'App\\Sponsor', 9, '20fc8ac3-0bbd-49b2-81ca-ff03cfd327de', 'logo', '652cd77327449_amg', '652cd77327449_amg.jpg', 'image/jpeg', 'public', 'public', 4831, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 55, '2023-10-16 00:26:00', '2023-10-16 00:26:00'),
(58, 'App\\Sponsor', 9, '96e38a31-6e83-4282-ac62-bd5b2dbcc3ee', 'logo', '652cd7c712673_amg', '652cd7c712673_amg.jpg', 'image/jpeg', 'public', 'public', 3124, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 56, '2023-10-16 00:27:20', '2023-10-16 00:27:20'),
(59, 'App\\Sponsor', 10, '26f92637-3b12-4d9d-ac84-25cf0265b93f', 'logo', '652cd7f4228f5_classical', '652cd7f4228f5_classical.jpg', 'image/jpeg', 'public', 'public', 2810, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 57, '2023-10-16 00:28:06', '2023-10-16 00:28:06'),
(60, 'App\\Sponsor', 11, '2b590842-eed5-449d-bd59-46cb79079629', 'logo', '652cd8431cc14_classical', '652cd8431cc14_classical.jpg', 'image/jpeg', 'public', 'public', 3147, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 58, '2023-10-16 00:29:24', '2023-10-16 00:29:25'),
(61, 'App\\Speaker', 7, '64f8edb2-0a44-4cfb-b9eb-943943344aae', 'photo', '652cd91618746_arifur', '652cd91618746_arifur.jpg', 'image/jpeg', 'public', 'public', 13063, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 59, '2023-10-16 00:32:55', '2023-10-16 00:32:55'),
(62, 'App\\Speaker', 8, '49d55592-5975-46ab-b39e-46efabf9913f', 'photo', '652cda67508b3_shamin', '652cda67508b3_shamin.jpg', 'image/jpeg', 'public', 'public', 21488, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 60, '2023-10-16 00:38:33', '2023-10-16 00:38:33'),
(63, 'App\\Speaker', 9, '9555ffe2-5f36-416d-b0ca-bfbcd9624539', 'photo', '652cda98e292f_Rizvi', '652cda98e292f_Rizvi.jpg', 'image/jpeg', 'public', 'public', 16724, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 61, '2023-10-16 00:39:22', '2023-10-16 00:39:22'),
(68, 'App\\Venue', 1, '9730dc3c-2740-4b00-b378-0591f6339d23', 'photos', '652ce2dee0f47_hall3', '652ce2dee0f47_hall3.jpg', 'image/jpeg', 'public', 'public', 148684, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 63, '2023-10-16 01:14:40', '2023-10-16 01:14:40'),
(69, 'App\\Venue', 1, 'f5a5e761-96c6-40fd-9c9c-f9eeb70beb6a', 'photos', '652ce3315ee13_hall4', '652ce3315ee13_hall4.jpg', 'image/jpeg', 'public', 'public', 146645, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 64, '2023-10-16 01:16:03', '2023-10-16 01:16:03'),
(70, 'App\\Sponsor', 12, 'e7ef6471-c9a7-4591-aa28-6727e5a67957', 'logo', '6534ec998efba_DIUJST', '6534ec998efba_DIUJST.jpg', 'image/jpeg', 'public', 'public', 3633, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 65, '2023-10-22 03:34:19', '2023-10-22 03:34:19'),
(71, 'App\\Sponsor', 13, '30c998e7-d19a-48fb-bbe6-a971fd9618bd', 'logo', '6534ecbf95088_diulogo', '6534ecbf95088_diulogo.jpg', 'image/jpeg', 'public', 'public', 11621, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 66, '2023-10-22 03:35:02', '2023-10-22 03:35:02'),
(72, 'App\\Sponsor', 13, 'de43bdaa-117b-4457-a54f-c690a553d1fe', 'logo', '6534ed03b1836_diulogo', '6534ed03b1836_diulogo.jpg', 'image/jpeg', 'public', 'public', 11621, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 67, '2023-10-22 03:36:05', '2023-10-22 03:36:05'),
(73, 'App\\Sponsor', 14, '06bc11dc-6414-4ffd-9cbc-66d0979b4258', 'logo', '6534ed2d7a2c7_te', '6534ed2d7a2c7_te.jpg', 'image/jpeg', 'public', 'public', 6258, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 68, '2023-10-22 03:36:51', '2023-10-22 03:36:51'),
(74, 'App\\Sponsor', 15, '11eb6152-88f9-4731-a0f8-c72bc27599e7', 'logo', '6534edcc99ee1_but', '6534edcc99ee1_but.png', 'image/png', 'public', 'public', 23560, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 69, '2023-10-22 03:39:30', '2023-10-22 03:39:30'),
(75, 'App\\Sponsor', 16, '289b9122-d3ad-4c9b-b2b7-8fe83280a928', 'logo', '6534ede35d44c_bgmea', '6534ede35d44c_bgmea.png', 'image/png', 'public', 'public', 33999, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 70, '2023-10-22 03:39:51', '2023-10-22 03:39:51'),
(76, 'App\\Sponsor', 17, '564d80fe-ce9f-4a11-ab69-a0fc2d42f9c3', 'logo', '6534edf5d55fe_btma', '6534edf5d55fe_btma.png', 'image/png', 'public', 'public', 12953, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 71, '2023-10-22 03:40:10', '2023-10-22 03:40:10'),
(77, 'App\\Speaker', 10, 'e219ecd1-3d64-44c5-b79a-180cb38f58f8', 'photo', '6611149ecdcfd_milton', '6611149ecdcfd_milton.jpeg', 'image/jpeg', 'public', 'public', 14339, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 72, '2024-04-06 03:33:58', '2024-04-06 03:33:59'),
(78, 'App\\Speaker', 10, '4852f146-2d00-4d79-aa27-9f277f2fbed4', 'photo', '661117450f18f_chu', '661117450f18f_chu.jpg', 'image/jpeg', 'public', 'public', 18204, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 73, '2024-04-06 03:35:28', '2024-04-06 03:35:28'),
(79, 'App\\Speaker', 13, 'a18df187-b200-461d-aa8a-ba70fb59db76', 'photo', '661117991f016_alam', '661117991f016_alam.jpg', 'image/jpeg', 'public', 'public', 17179, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 74, '2024-04-06 03:36:36', '2024-04-06 03:36:36'),
(80, 'App\\Speaker', 8, '00a3eca0-5bc7-4618-a22f-3da0afc8dba5', 'photo', '6611180310e59_sir', '6611180310e59_sir.jpg', 'image/jpeg', 'public', 'public', 12734, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 75, '2024-04-06 03:38:21', '2024-04-06 03:38:21'),
(81, 'App\\Speaker', 14, 'b956b767-4922-4f73-af3b-0a18278123e3', 'photo', '66111840cbada_abul', '66111840cbada_abul.jpg', 'image/jpeg', 'public', 'public', 9714, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 76, '2024-04-06 03:39:14', '2024-04-06 03:39:15'),
(82, 'App\\Speaker', 1, 'd49a246b-1ae6-4453-946b-cacc65818551', 'photo', '661373a446743_ray', '661373a446743_ray.JPG', 'image/jpeg', 'public', 'public', 205362, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 77, '2024-04-07 22:33:50', '2024-04-07 22:33:56'),
(83, 'App\\Speaker', 1, 'b59f0115-57b7-4e37-b08e-a17dd147431a', 'photo', '66137591f194e_ray1', '66137591f194e_ray1.jpg', 'image/jpeg', 'public', 'public', 35563, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 78, '2024-04-07 22:41:58', '2024-04-07 22:41:58'),
(84, 'App\\Speaker', 15, 'fa5f484a-6bfb-4abc-8717-95147896a133', 'photo', '6613763116428_repon', '6613763116428_repon.jpg', 'image/jpeg', 'public', 'public', 12035, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 79, '2024-04-07 22:44:38', '2024-04-07 22:44:38'),
(85, 'App\\Speaker', 16, 'afd729ff-05eb-4d8c-b468-5f5bbe86b493', 'photo', '6613765bb46ac_milon', '6613765bb46ac_milon.jpg', 'image/jpeg', 'public', 'public', 24722, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 80, '2024-04-07 22:45:32', '2024-04-07 22:45:32'),
(86, 'App\\Speaker', 17, '0095de7c-cc62-45ca-a385-eb08144fa807', 'photo', '66137683eb327_kabir', '66137683eb327_kabir.jpg', 'image/jpeg', 'public', 'public', 13368, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 81, '2024-04-07 22:46:01', '2024-04-07 22:46:01'),
(87, 'App\\Speaker', 18, 'a02f85fc-b140-4849-a89f-92621ed6c858', 'photo', '6613769d4bcc6_murat', '6613769d4bcc6_murat.jpg', 'image/jpeg', 'public', 'public', 20626, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 82, '2024-04-07 22:46:26', '2024-04-07 22:46:26'),
(88, 'App\\Speaker', 19, '7deda238-9e09-4431-b580-921637ab6fa8', 'photo', '661376b595222_zahedul', '661376b595222_zahedul.jpg', 'image/jpeg', 'public', 'public', 15435, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 83, '2024-04-07 22:46:50', '2024-04-07 22:46:50'),
(89, 'App\\Speaker', 20, 'ae89a8e8-24a0-4d18-afc0-43edaad51d4a', 'photo', '661376dd84125_reema', '661376dd84125_reema.jpg', 'image/jpeg', 'public', 'public', 20230, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 84, '2024-04-07 22:47:36', '2024-04-07 22:47:36'),
(90, 'App\\Speaker', 21, '6bf54eb2-3195-4242-87d9-4912d6a0595c', 'photo', '661376faacbc2_axel', '661376faacbc2_axel.jpg', 'image/jpeg', 'public', 'public', 11599, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 85, '2024-04-07 22:48:01', '2024-04-07 22:48:01'),
(91, 'App\\Speaker', 22, 'b19a2f94-37ff-49b4-9f2b-e881c20d3160', 'photo', '66137714de080_azad', '66137714de080_azad.jpg', 'image/jpeg', 'public', 'public', 13820, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 86, '2024-04-07 22:48:26', '2024-04-07 22:48:26'),
(92, 'App\\Speaker', 23, '78dc1680-7eb5-44fe-82d9-ce9431bc26fb', 'photo', '6613772c1734a_shamim', '6613772c1734a_shamim.jpg', 'image/jpeg', 'public', 'public', 12259, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 87, '2024-04-07 22:48:48', '2024-04-07 22:48:48'),
(93, 'App\\Speaker', 24, '031ef2d1-65df-4916-b02d-ee69d069c577', 'photo', '66137740cf105_ullah', '66137740cf105_ullah.jpg', 'image/jpeg', 'public', 'public', 11812, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 88, '2024-04-07 22:49:10', '2024-04-07 22:49:10'),
(94, 'App\\Speaker', 25, '4ef8d1f7-8e03-4aef-8821-53b83c47f575', 'photo', '6613775868ccc_haji', '6613775868ccc_haji.jpg', 'image/jpeg', 'public', 'public', 11307, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 89, '2024-04-07 22:49:33', '2024-04-07 22:49:33'),
(95, 'App\\Speaker', 26, '5b433e2e-2535-4b96-9eed-0e25aabda2b7', 'photo', '6613777cd0d74_nazmina', '6613777cd0d74_nazmina.jpg', 'image/jpeg', 'public', 'public', 14112, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 90, '2024-04-07 22:50:10', '2024-04-07 22:50:10'),
(96, 'App\\Speaker', 27, 'c79e5138-b560-4ae4-b222-824b1bbe57cd', 'photo', '66137953201dc_kabir', '66137953201dc_kabir.jpg', 'image/jpeg', 'public', 'public', 13368, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 91, '2024-04-07 22:58:08', '2024-04-07 22:58:08'),
(97, 'App\\Speaker', 2, '84e05a33-4e37-4fcc-ab9d-6be194bf512f', 'photo', '6730544743bfd_coming', '6730544743bfd_coming.png', 'image/png', 'public', 'public', 1234, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 92, '2024-11-10 00:36:04', '2024-11-10 00:36:04'),
(99, 'App\\Speaker', 2, '5dad7b74-554d-42ff-907b-47949b36f991', 'photo', '673ad7446d2d9_demo3', '673ad7446d2d9_demo3.jpg', 'image/jpeg', 'public', 'public', 35563, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 93, '2024-11-17 23:58:08', '2024-11-17 23:58:09'),
(100, 'App\\Speaker', 1, '83b7285c-55e3-4b33-8f5d-067757185466', 'photo', '673adee5df134_coming1', '673adee5df134_coming1.png', 'image/png', 'public', 'public', 1492, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 94, '2024-11-18 00:30:03', '2024-11-18 00:30:03'),
(101, 'App\\Speaker', 2, '024eb76f-8a3c-4167-93f6-cb28969067e2', 'photo', '673adefd0dfa1_coming2', '673adefd0dfa1_coming2.png', 'image/png', 'public', 'public', 1492, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 95, '2024-11-18 00:30:24', '2024-11-18 00:30:24'),
(102, 'App\\Speaker', 28, '520eee7a-207a-4236-9371-c6b7192b5dc4', 'photo', '673adf3c3909c_coming3', '673adf3c3909c_coming3.png', 'image/png', 'public', 'public', 1492, '[]', '{\"generated_conversions\": {\"thumb\": true}}', '[]', 96, '2024-11-18 00:31:29', '2024-11-18 00:31:29');

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

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

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int 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_100000_create_password_resets_table', 1),
(2, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
(3, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
(4, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
(5, '2016_06_01_000004_create_oauth_clients_table', 1),
(6, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
(7, '2019_09_24_000000_create_media_table', 1),
(8, '2019_09_24_000001_create_permissions_table', 1),
(9, '2019_09_24_000002_create_faqs_table', 1),
(10, '2019_09_24_000003_create_prices_table', 1),
(11, '2019_09_24_000004_create_users_table', 1),
(12, '2019_09_24_000005_create_amenities_table', 1),
(13, '2019_09_24_000006_create_settings_table', 1),
(14, '2019_09_24_000007_create_speakers_table', 1),
(15, '2019_09_24_000008_create_schedules_table', 1),
(16, '2019_09_24_000009_create_roles_table', 1),
(17, '2019_09_24_000010_create_venues_table', 1),
(18, '2019_09_24_000011_create_hotels_table', 1),
(19, '2019_09_24_000012_create_galleries_table', 1),
(20, '2019_09_24_000013_create_sponsors_table', 1),
(21, '2019_09_24_000014_create_amenity_price_pivot_table', 1),
(22, '2019_09_24_000015_create_role_user_pivot_table', 1),
(23, '2019_09_24_000016_create_permission_role_pivot_table', 1),
(24, '2019_09_24_000017_add_relationship_fields_to_schedules_table', 1),
(25, '2023_10_21_031953_create_authors_table', 2),
(26, '2023_10_21_032039_create_books_table', 2),
(27, '2023_10_21_042853_create_author_book_pivot_table', 2),
(28, '2023_10_21_103908_create_sponsor_type_table', 3);

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

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `client_id` bigint UNSIGNED NOT NULL,
  `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint UNSIGNED NOT NULL,
  `client_id` bigint UNSIGNED 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 `permissions`
--

CREATE TABLE `permissions` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `permissions` (`id`, `title`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'user_management_access', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(2, 'permission_create', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(3, 'permission_edit', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(4, 'permission_show', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(5, 'permission_delete', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(6, 'permission_access', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(7, 'role_create', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(8, 'role_edit', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(9, 'role_show', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(10, 'role_delete', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(11, 'role_access', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(12, 'user_create', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(13, 'user_edit', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(14, 'user_show', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(15, 'user_delete', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(16, 'user_access', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(17, 'setting_create', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(18, 'setting_edit', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(19, 'setting_show', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(20, 'setting_delete', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(21, 'setting_access', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(22, 'speaker_create', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(23, 'speaker_edit', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(24, 'speaker_show', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(25, 'speaker_delete', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(26, 'speaker_access', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(27, 'schedule_create', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(28, 'schedule_edit', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(29, 'schedule_show', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(30, 'schedule_delete', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(31, 'schedule_access', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(32, 'venue_create', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(33, 'venue_edit', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(34, 'venue_show', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(35, 'venue_delete', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(36, 'venue_access', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(37, 'hotel_create', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(38, 'hotel_edit', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(39, 'hotel_show', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(40, 'hotel_delete', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(41, 'hotel_access', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(42, 'gallery_create', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(43, 'gallery_edit', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(44, 'gallery_show', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(45, 'gallery_delete', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(46, 'gallery_access', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(47, 'sponsor_create', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(48, 'sponsor_edit', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(49, 'sponsor_show', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(50, 'sponsor_delete', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(51, 'sponsor_access', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(52, 'faq_create', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(53, 'faq_edit', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(54, 'faq_show', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(55, 'faq_delete', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(56, 'faq_access', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(57, 'amenity_create', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(58, 'amenity_edit', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(59, 'amenity_show', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(60, 'amenity_delete', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(61, 'amenity_access', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(62, 'price_create', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(63, 'price_edit', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(64, 'price_show', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(65, 'price_delete', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(66, 'price_access', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(67, 'author_create', NULL, NULL, NULL),
(68, 'author_edit', NULL, NULL, NULL),
(69, 'author_show', NULL, NULL, NULL),
(70, 'author_delete', NULL, NULL, NULL),
(71, 'author_access', NULL, NULL, NULL),
(72, 'book_create', NULL, NULL, NULL),
(73, 'book_edit', NULL, NULL, NULL),
(74, 'book_show', NULL, NULL, NULL),
(75, 'book_delete', NULL, NULL, NULL),
(76, 'book_access', NULL, NULL, NULL);

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

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `role_id` int UNSIGNED NOT NULL,
  `permission_id` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`role_id`, `permission_id`) VALUES
(1, 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, 22),
(1, 23),
(1, 24),
(1, 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, 49),
(1, 50),
(1, 51),
(1, 52),
(1, 53),
(1, 54),
(1, 55),
(1, 56),
(1, 57),
(1, 58),
(1, 59),
(1, 60),
(1, 61),
(1, 62),
(1, 63),
(1, 64),
(1, 65),
(1, 66),
(1, 67),
(1, 68),
(1, 69),
(1, 70),
(1, 71),
(1, 72),
(1, 73),
(1, 74),
(1, 75),
(1, 76),
(2, 76);

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

--
-- Table structure for table `prices`
--

CREATE TABLE `prices` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(15,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `prices`
--

INSERT INTO `prices` (`id`, `name`, `price`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Standard Access', 150.00, '2023-10-05 01:30:31', '2023-10-05 01:30:31', NULL),
(2, 'Pro Access', 250.00, '2023-10-05 01:30:31', '2023-10-05 01:30:31', NULL),
(3, 'Premium Access', 350.00, '2023-10-05 01:30:31', '2023-10-05 01:30:31', NULL);

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

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

CREATE TABLE `roles` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `title`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Admin', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL),
(2, 'User', '2019-09-24 13:16:02', '2019-09-24 13:16:02', NULL);

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

--
-- Table structure for table `role_user`
--

CREATE TABLE `role_user` (
  `user_id` int UNSIGNED NOT NULL,
  `role_id` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` (`user_id`, `role_id`) VALUES
(1, 1),
(2, 1);

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

--
-- Table structure for table `schedules`
--

CREATE TABLE `schedules` (
  `id` int UNSIGNED NOT NULL,
  `day_number` int NOT NULL,
  `start_time` time NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `speaker_id` int UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `schedules`
--

INSERT INTO `schedules` (`id`, `day_number`, `start_time`, `title`, `subtitle`, `created_at`, `updated_at`, `deleted_at`, `speaker_id`) VALUES
(1, 1, '09:30:00', 'Registration', 'Fugit voluptas iusto maiores temporibus autem numquam magnam.', '2023-10-05 01:30:28', '2023-10-05 01:30:28', NULL, NULL),
(2, 1, '10:00:00', 'Keynote', 'Facere provident incidunt quos voluptas.', '2023-10-05 01:30:28', '2023-10-05 01:30:28', NULL, 1),
(3, 1, '11:00:00', 'Et voluptatem iusto dicta nobis.', 'Maiores dignissimos neque qui cum accusantium ut sit sint inventore.', '2023-10-05 01:30:28', '2023-10-05 01:30:28', NULL, 2),
(4, 1, '12:00:00', 'Explicabo et rerum quis et ut ea.', 'Veniam accusantium laborum nihil eos eaque accusantium aspernatur.', '2023-10-05 01:30:28', '2023-10-05 01:30:28', NULL, 3),
(5, 1, '14:00:00', 'Qui non qui vel amet culpa sequi.', 'Nam ex distinctio voluptatem doloremque suscipit iusto.', '2023-10-05 01:30:28', '2023-10-05 01:30:28', NULL, 4),
(6, 1, '15:00:00', 'Quos ratione neque expedita asperiores.', 'Eligendi quo eveniet est nobis et ad temporibus odio quo.', '2023-10-05 01:30:28', '2023-10-05 01:30:28', NULL, 5),
(7, 1, '16:00:00', 'Quo qui praesentium nesciunt', 'Voluptatem et alias dolorum est aut sit enim neque veritatis.', '2023-10-05 01:30:28', '2023-10-05 01:30:28', NULL, 6),
(8, 2, '10:00:00', 'Libero corrupti explicabo itaque.', 'Facere provident incidunt quos voluptas.', '2023-10-05 01:30:28', '2023-10-15 04:10:01', '2023-10-15 04:10:01', 1),
(9, 2, '11:00:00', 'Et voluptatem iusto dicta nobis.', 'Maiores dignissimos neque qui cum accusantium ut sit sint inventore.', '2023-10-05 01:30:28', '2023-10-15 04:10:01', '2023-10-15 04:10:01', 2),
(10, 2, '12:00:00', 'Explicabo et rerum quis et ut ea.', 'Veniam accusantium laborum nihil eos eaque accusantium aspernatur.', '2023-10-05 01:30:28', '2023-10-15 04:10:01', '2023-10-15 04:10:01', 3),
(11, 2, '14:00:00', 'Qui non qui vel amet culpa sequi.', 'Nam ex distinctio voluptatem doloremque suscipit iusto.', '2023-10-05 01:30:28', '2023-10-15 04:10:01', '2023-10-15 04:10:01', 4),
(12, 2, '15:00:00', 'Quos ratione neque expedita asperiores.', 'Eligendi quo eveniet est nobis et ad temporibus odio quo.', '2023-10-05 01:30:28', '2023-10-15 04:10:01', '2023-10-15 04:10:01', 5),
(13, 2, '16:00:00', 'Quo qui praesentium nesciunt', 'Voluptatem et alias dolorum est aut sit enim neque veritatis.', '2023-10-05 01:30:28', '2023-10-15 04:10:01', '2023-10-15 04:10:01', 6),
(14, 3, '10:00:00', 'Et voluptatem iusto dicta nobis.', 'Maiores dignissimos neque qui cum accusantium ut sit sint inventore.', '2023-10-05 01:30:28', '2023-10-15 04:09:21', '2023-10-15 04:09:21', 2),
(15, 3, '11:00:00', 'Explicabo et rerum quis et ut ea.', 'Veniam accusantium laborum nihil eos eaque accusantium aspernatur.', '2023-10-05 01:30:28', '2023-10-15 04:09:21', '2023-10-15 04:09:21', 3),
(16, 3, '12:00:00', 'Libero corrupti explicabo itaque.', 'Facere provident incidunt quos voluptas.', '2023-10-05 01:30:28', '2023-10-15 04:09:21', '2023-10-15 04:09:21', 1),
(17, 3, '14:00:00', 'Qui non qui vel amet culpa sequi.', 'Nam ex distinctio voluptatem doloremque suscipit iusto.', '2023-10-05 01:30:28', '2023-10-15 04:09:21', '2023-10-15 04:09:21', 4),
(18, 3, '15:00:00', 'Quos ratione neque expedita asperiores.', 'Eligendi quo eveniet est nobis et ad temporibus odio quo.', '2023-10-05 01:30:28', '2023-10-15 04:09:21', '2023-10-15 04:09:21', 5),
(19, 3, '16:00:00', 'Quo qui praesentium nesciunt', 'Voluptatem et alias dolorum est aut sit enim neque veritatis.', '2023-10-05 01:30:28', '2023-10-15 04:09:21', '2023-10-15 04:09:21', 6);

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

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

CREATE TABLE `speakers` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `twitter` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linkedin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `full_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `serial` int NOT NULL DEFAULT '0',
  `is_active` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `speaker_category_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `speakers` (`id`, `name`, `description`, `twitter`, `facebook`, `linkedin`, `full_description`, `serial`, `is_active`, `speaker_category_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Demo1', 'Council Member & Chairman TXDB', '#', '#', '#', 'Council Member & Chairman TXDB of The Institution of Engineers (India)', 0, '1', 1, '2023-10-05 01:30:27', '2024-11-03 03:45:25', NULL),
(2, 'Demo2', 'Managing Director,  Hams Group Ltd.', '#', '#', '#', 'Managing Director,  Hams Group Ltd.', 1, '1', 1, '2023-10-05 01:30:27', '2024-11-10 00:39:56', NULL),
(3, 'Md. Khosru Chowdhury', 'Chairman & Managing Director,  Nipa Group Ltd., \r\nDirector, BGMEA', '#', '#', '#', 'Chairman & Managing Director,  Nipa Group Ltd., \r\nDirector, Bangladesh Garment Manufacturers and Exporters Association (BGMEA)', 0, '1', 0, '2023-10-05 01:30:27', '2024-01-29 00:22:26', '2024-01-29 00:22:26'),
(4, 'Jack Christiansen', 'Debitis iure vero', '#', '#', '#', 'Molestiae distinctio molestiae itaque tempore id aut et vel. Quisquam quia cumque possimus quia. Aut corporis aliquam soluta et veniam qui.', 0, '1', 0, '2023-10-05 01:30:27', '2023-10-14 05:21:13', '2023-10-14 05:21:13'),
(5, 'Alejandrin Littel', 'Qui molestiae natus', '#', '#', '#', 'Amet qui atque iure adipisci qui. Aspernatur rerum officiis at est accusamus. Quia non reprehenderit quos in possimus alias.', 0, '1', 0, '2023-10-05 01:30:27', '2023-10-14 05:21:10', '2023-10-14 05:21:10'),
(6, 'Willow Trantow', 'Non autem dicta', '#', '#', '#', 'Qui quaerat omnis voluptatum. Atque assumenda magnam hic et quia nam fuga. Quia non quos sunt exercitationem tempore ducimus.', 0, '1', 0, '2023-10-05 01:30:27', '2023-10-14 05:21:07', '2023-10-14 05:21:07'),
(7, 'Majumder Arifur Rahman', 'Managiing Director, Magpie Composite Textile Ltd.', NULL, NULL, NULL, 'Managiing Director, Magpie Composite Textile Ltd.', 0, '1', 0, '2023-10-16 00:32:55', '2024-01-29 00:22:30', '2024-01-29 00:22:30'),
(8, 'Dr. Md. Engr. Mahbubul Haque', 'Professor, Department of Textile Engineering, Daffodil International University', NULL, NULL, NULL, 'Professor, Department of Textile Engineering, Daffodil International University', 0, '1', 3, '2023-10-16 00:38:33', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(9, 'Engr. Shakhwat Hossain Rizvi', 'Executive Director, Universal Denim Ltd.', NULL, NULL, NULL, 'Executive Director, Universal Denim Ltd.', 1, '1', 4, '2023-10-16 00:39:22', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(10, 'Dr. Yanyan Chu', 'Professor, Zhongyuan University of Technology, China', NULL, NULL, NULL, 'Professor, Zhongyuan University of Technology, China', 1, '1', 2, '2024-04-06 02:37:35', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(11, 'Dr. Yanyan Chu', 'Professor, Zhongyuan University of Technology, China', NULL, NULL, NULL, 'Professor, Zhongyuan University of Technology, China', 1, '1', 2, '2024-04-06 02:38:03', '2024-04-06 02:58:13', '2024-04-06 02:58:13'),
(12, 'Dr. Yanyan Chu', 'Professor, Zhongyuan University of Technology, China', '#', '#', '#', 'Professor, Zhongyuan University of Technology, China', 1, '1', 2, '2024-04-06 02:39:22', '2024-04-06 02:58:20', '2024-04-06 02:58:20'),
(13, 'Prof. Dr. Mohammad Taufiq Alam', 'Professor, University of Rajshahi', NULL, NULL, NULL, 'Professor, University of Rajshahi', 2, '1', 2, '2024-04-06 03:36:36', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(14, 'Dr. Md. Abul Kalam Azad', 'Professor, Prime Asia University', NULL, NULL, NULL, 'Professor, Prime Asia University', 0, '1', 5, '2024-04-06 03:39:14', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(15, 'Dr. Md. Reazuddin Repon', 'Researcher, Nature Research Centre, Vilnius, Lithuania', NULL, NULL, NULL, 'Researcher , Nature Research Centre, Vilnius, Lithuania', 4, '1', 2, '2024-04-07 22:44:38', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(16, 'Engr. Zomir Uddin Milon', 'Executive Director, Knit Bazar Ltd.', NULL, NULL, NULL, 'Executive Director, Knit Bazar Ltd.', 2, '1', 3, '2024-04-07 22:45:32', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(17, 'Dr. Shekh Mamun Kabir', 'Associate Professor, Bangladesh University of Textiles', NULL, NULL, NULL, 'Associate Professor, Bangladesh University of Textiles', 3, '1', 3, '2024-04-07 22:46:01', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(18, 'Murat Sahinli', 'Regional Sales Manager, Pluvia', NULL, NULL, NULL, 'Regional Sales Manager, Pluvia', 4, '1', 3, '2024-04-07 22:46:26', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(19, 'Engr. Zahedul Huque', 'General Manager, Ocean Textile Effect', NULL, NULL, NULL, 'General Manager, Ocean Textile Effect', 5, '1', 3, '2024-04-07 22:46:49', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(20, 'Reema Solanki', 'Head, CKDL, Bitopi Group', NULL, NULL, NULL, 'Head, CKDL, Bitopi Group', 2, '1', 4, '2024-04-07 22:47:36', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(21, 'Axel Mueller', 'Technical Director, Ben Tech Chemical Co. Ltd.', NULL, NULL, NULL, 'Technical Director, Ben Tech Chemical Co. Ltd.', 3, '1', 4, '2024-04-07 22:48:01', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(22, 'Mujibul Haque Azad', 'Sr. General Manager, L’Esquire Ltd', NULL, NULL, NULL, 'Sr. General Manager, L’Esquire Ltd', 4, '1', 4, '2024-04-07 22:48:26', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(23, 'Engr. F M Shamim Bhuiyan', 'Executive Director, Al Muslim Group', NULL, NULL, NULL, 'Executive Director, Al Muslim Group', 5, '1', 4, '2024-04-07 22:48:48', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(24, 'Zamael Ullah', 'Managing Director and CEO, PlastChem Corporation, Dhaka', NULL, NULL, NULL, 'Managing Director and CEO, PlastChem Corporation, Dhaka', 6, '1', 4, '2024-04-07 22:49:10', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(25, 'Dr. Aminoddin Haji', 'Associate Professor, Department of Textile Engineering, Yazd University, Iran', NULL, NULL, NULL, 'Associate Professor, Department of Textile Engineering, Yazd University, Iran', 7, '1', 4, '2024-04-07 22:49:33', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(26, 'Dr. Nazmina Chowdhury', 'Chief Scientific Officer, BJRI', NULL, NULL, NULL, 'Chief Scientific Officer, BJRI', 2, '1', 5, '2024-04-07 22:50:10', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(27, 'Dr. Shekh Mamun Kabir', 'Associate Professor, Bangladesh University of Textiles', NULL, NULL, NULL, 'Associate Professor, Bangladesh University of Textiles', 3, '1', 5, '2024-04-07 22:58:08', '2024-11-03 03:43:12', '2024-11-03 03:43:12'),
(28, 'Demo3', 'Managing Director, ACI', NULL, NULL, NULL, 'Managing Director, ACI', 3, '1', 1, '2024-11-18 00:31:29', '2024-11-18 00:31:29', NULL);

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

--
-- Table structure for table `speaker_categories`
--

CREATE TABLE `speaker_categories` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `serial` int NOT NULL DEFAULT '0',
  `is_active` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `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 `speaker_categories`
--

INSERT INTO `speaker_categories` (`id`, `title`, `serial`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Chief Guest', 1, '1', NULL, NULL),
(2, 'Keynote Speakers', 2, '1', NULL, NULL),
(3, 'Speakers of Innovation Talk', 3, '1', NULL, NULL),
(4, 'Speakers of Technical Talk', 4, '1', NULL, NULL),
(5, 'Session Chair', 5, '1', NULL, NULL);

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

--
-- Table structure for table `sponsors`
--

CREATE TABLE `sponsors` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `serial` int NOT NULL DEFAULT '0',
  `sponsor_type_id` int UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sponsors`
--

INSERT INTO `sponsors` (`id`, `name`, `link`, `created_at`, `updated_at`, `deleted_at`, `serial`, `sponsor_type_id`) VALUES
(1, 'Strider', '#', '2023-10-05 01:30:30', '2023-10-21 21:34:07', NULL, 1, 3),
(2, 'Runtastic', '#', '2023-10-05 01:30:30', '2023-10-05 01:30:30', NULL, 0, 3),
(3, 'EditShare', '#', '2023-10-05 01:30:30', '2023-10-05 01:30:30', NULL, 0, 3),
(4, 'InFocus', '#', '2023-10-05 01:30:30', '2023-10-05 01:30:30', NULL, 0, 3),
(5, 'gategroup', '#', '2023-10-05 01:30:30', '2023-10-05 01:30:30', NULL, 0, 3),
(6, 'Cadent', '#', '2023-10-05 01:30:30', '2023-10-05 01:30:30', NULL, 0, 3),
(7, 'Ceph', '#', '2023-10-05 01:30:31', '2023-10-05 01:30:31', NULL, 0, 3),
(8, 'Alitalia', '#', '2023-10-05 01:30:31', '2023-10-05 01:30:31', NULL, 0, 3),
(9, '9', NULL, '2023-10-16 00:26:00', '2023-10-16 00:26:00', NULL, 0, 3),
(10, '10', NULL, '2023-10-16 00:28:06', '2023-10-16 00:28:06', NULL, 0, 3),
(11, '11', NULL, '2023-10-16 00:29:24', '2023-10-21 21:57:06', NULL, 0, 3),
(12, 'DIUJST', NULL, '2023-10-22 03:34:19', '2023-10-22 03:34:19', NULL, 1, 1),
(13, 'DIU', NULL, '2023-10-22 03:35:02', '2023-10-22 03:35:02', NULL, 2, 1),
(14, 'Textile Club', NULL, '2023-10-22 03:36:51', '2023-10-22 03:36:51', NULL, 3, 1),
(15, 'BUT', NULL, '2023-10-22 03:39:29', '2023-10-22 03:39:29', NULL, 1, 2),
(16, 'BGMEA', NULL, '2023-10-22 03:39:51', '2023-10-22 03:39:51', NULL, 2, 2),
(17, 'BTMA', NULL, '2023-10-22 03:40:10', '2023-10-22 03:40:10', NULL, 3, 2);

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

--
-- Table structure for table `sponsor_types`
--

CREATE TABLE `sponsor_types` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `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 `sponsor_types`
--

INSERT INTO `sponsor_types` (`id`, `title`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Technical Collaboration', '1', NULL, NULL),
(2, 'Academic and Industry Collaboration', '1', NULL, NULL),
(3, 'Sponsors', '1', NULL, NULL);

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

--
-- Table structure for table `venues`
--

CREATE TABLE `venues` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `latitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `longitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `venues`
--

INSERT INTO `venues` (`id`, `name`, `address`, `latitude`, `longitude`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Daffodil Smart City, Birulia, Savar, Dhaka, Bangladesh', 'Birulia, Savar, Dhaka, Bangladesh', '23.87693576241811', '90.32015515471744', 'Iste nobis eum sapiente sunt enim dolores labore accusantium autem. Cumque beatae ipsam. Est quae sit qui voluptatem corporis velit. Qui maxime accusamus possimus. Consequatur sequi et ea suscipit enim nesciunt quia velit.', '2023-10-05 01:30:28', '2023-10-16 02:31:01', NULL);

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `amenity_price`
--
ALTER TABLE `amenity_price`
  ADD KEY `price_id_fk_384063` (`price_id`),
  ADD KEY `amenity_id_fk_384063` (`amenity_id`);

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

--
-- Indexes for table `author_book`
--
ALTER TABLE `author_book`
  ADD PRIMARY KEY (`id`),
  ADD KEY `book_id_fk_9133600` (`book_id`),
  ADD KEY `author_id_fk_9133600` (`author_id`);

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

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

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

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

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD KEY `media_model_type_model_id_index` (`model_type`,`model_id`);

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

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

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

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

--
-- Indexes for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD KEY `role_id_fk_383833` (`role_id`),
  ADD KEY `permission_id_fk_383833` (`permission_id`);

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

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

--
-- Indexes for table `role_user`
--
ALTER TABLE `role_user`
  ADD KEY `user_id_fk_383842` (`user_id`),
  ADD KEY `role_id_fk_383842` (`role_id`);

--
-- Indexes for table `schedules`
--
ALTER TABLE `schedules`
  ADD PRIMARY KEY (`id`),
  ADD KEY `speaker_fk_383954` (`speaker_id`);

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `amenities`
--
ALTER TABLE `amenities`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `authors`
--
ALTER TABLE `authors`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT for table `author_book`
--
ALTER TABLE `author_book`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;

--
-- AUTO_INCREMENT for table `books`
--
ALTER TABLE `books`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `galleries`
--
ALTER TABLE `galleries`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `hotels`
--
ALTER TABLE `hotels`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=103;

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

--
-- AUTO_INCREMENT for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;

--
-- AUTO_INCREMENT for table `prices`
--
ALTER TABLE `prices`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `schedules`
--
ALTER TABLE `schedules`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `speakers`
--
ALTER TABLE `speakers`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `speaker_categories`
--
ALTER TABLE `speaker_categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `sponsors`
--
ALTER TABLE `sponsors`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `sponsor_types`
--
ALTER TABLE `sponsor_types`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `venues`
--
ALTER TABLE `venues`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `amenity_price`
--
ALTER TABLE `amenity_price`
  ADD CONSTRAINT `amenity_id_fk_384063` FOREIGN KEY (`amenity_id`) REFERENCES `amenities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `price_id_fk_384063` FOREIGN KEY (`price_id`) REFERENCES `prices` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD CONSTRAINT `permission_id_fk_383833` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_id_fk_383833` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_user`
--
ALTER TABLE `role_user`
  ADD CONSTRAINT `role_id_fk_383842` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_id_fk_383842` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `schedules`
--
ALTER TABLE `schedules`
  ADD CONSTRAINT `speaker_fk_383954` FOREIGN KEY (`speaker_id`) REFERENCES `speakers` (`id`);
COMMIT;

