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

START TRANSACTION;



--
-- Database: `tropitel_gitega_db`
--

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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `button` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `photo` varchar(191) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'inactive',
  `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 `banners`
--

INSERT INTO `banners` (`id`, `title`, `button`, `link`, `slug`, `photo`, `description`, `status`, `created_at`, `updated_at`) VALUES
(2, 'Welcome To Tropitel Hotel', 'Find More', 'https://0026.ufanisiafrica.info/about-us', 'welcome-to-tropitel-hotel', 'public/images/FqgVz8DywR5kmtSraMktAw24YGeJtCnQUeZgh11j.jpg', 'This hotel is located in the political capital of Burundi, Gitega. The hotel meets all the requirements of a high-class hotel that meets International standards.', 'active', '2023-04-14 20:42:32', '2023-04-14 20:42:32'),
(4, 'Tropitel Resto', 'FIND MORE', 'https://0026.ufanisiafrica.info/', 'tropitel-resto', 'public/images/g2Nqt5fjpKJhTIpt0aGcubKbtA9tFo4ISKCqQp2R.jpg', 'Experience culinary delight at our hotel restaurant and bar.', 'active', '2023-05-18 19:02:13', '2023-06-01 14:20:16'),
(5, 'Tropitel gitega', 'find more', 'https://0026.ufanisiafrica.info/', 'swimming-pool', 'public/images/ll03Pa6oBycQBNWwoKdZWG7p9K7hviPAneq7DSR3.jpg', 'A high-class hotel that meets International standards', 'active', '2023-06-01 22:03:29', '2023-06-01 22:06:26');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `summary` text DEFAULT NULL,
  `photo` varchar(191) DEFAULT NULL,
  `is_parent` tinyint(1) NOT NULL DEFAULT 1,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `added_by` bigint(20) UNSIGNED DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'inactive',
  `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 `categories`
--

INSERT INTO `categories` (`id`, `title`, `slug`, `summary`, `photo`, `is_parent`, `parent_id`, `added_by`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Technology', 'technology', 'This is a test please please', 'public/images/Hlyq7hxfIfVHUc6cMl4q79JqjCeYvLqo22yL2JVz.jpg', 1, NULL, NULL, 'active', '2023-04-26 20:06:45', '2023-04-26 20:06:45');

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

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

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

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

--
-- Table structure for table `images`
--

CREATE TABLE `images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `size` varchar(100) NOT NULL,
  `path` varchar(100) NOT NULL,
  `caption` varchar(100) DEFAULT NULL,
  `status` enum('active','in-active','','') NOT NULL,
  `room_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `images`
--

INSERT INTO `images` (`id`, `name`, `size`, `path`, `caption`, `status`, `room_id`, `created_at`, `updated_at`) VALUES
(8, '1682344319_presidential suite (17).jpg', '1820163', 'storage/1682344319_presidential suite (17).jpg', NULL, 'active', 8, '2023-04-24 20:51:59', '2023-04-24 20:51:59'),
(9, '1683704759_presidential suite (10).JPG', '8514833', 'storage/1683704759_presidential suite (10).JPG', NULL, 'active', 8, '2023-05-10 14:45:59', '2023-05-10 14:45:59'),
(10, '1683704861_presidential suite (29).JPG', '3194618', 'storage/1683704861_presidential suite (29).JPG', NULL, 'active', 8, '2023-05-10 14:47:41', '2023-05-10 14:47:41'),
(11, '1683704861_presidential suite (30).JPG', '3734980', 'storage/1683704861_presidential suite (30).JPG', NULL, 'active', 8, '2023-05-10 14:47:41', '2023-05-10 14:47:41'),
(12, '1683704861_presidential suite (42).JPG', '2664806', 'storage/1683704861_presidential suite (42).JPG', NULL, 'active', 8, '2023-05-10 14:47:41', '2023-05-10 14:47:41'),
(13, '1684830098_deluxe twin bed (2).jpg', '865582', 'storage/1684830098_deluxe twin bed (2).jpg', NULL, 'active', 6, '2023-05-23 15:21:38', '2023-05-23 15:21:38'),
(14, '1684830128_deluxe twin bed (5).jpg', '903064', 'storage/1684830128_deluxe twin bed (5).jpg', NULL, 'active', 6, '2023-05-23 15:22:08', '2023-05-23 15:22:08'),
(15, '1684830150_deluxe twin bed (8).jpg', '783239', 'storage/1684830150_deluxe twin bed (8).jpg', NULL, 'active', 6, '2023-05-23 15:22:30', '2023-05-23 15:22:30'),
(16, '1684830172_deluxe twin bed (14).jpg', '668581', 'storage/1684830172_deluxe twin bed (14).jpg', NULL, 'active', 6, '2023-05-23 15:22:52', '2023-05-23 15:22:52'),
(17, '1684830390_deluxe_twin_bed_10_400.jpg', '393664', 'storage/1684830390_deluxe_twin_bed_10_400.jpg', NULL, 'active', 6, '2023-05-23 15:26:30', '2023-05-23 15:26:30'),
(21, '1684832745_standard room (1).jpg', '614044', 'storage/1684832745_standard room (1).jpg', NULL, 'active', 9, '2023-05-23 16:05:45', '2023-05-23 16:05:45'),
(22, '1684833096_standard room (16).jpg', '551089', 'storage/1684833096_standard room (16).jpg', NULL, 'active', 9, '2023-05-23 16:11:36', '2023-05-23 16:11:36'),
(23, '1684833291_presidential suite (3).jpg', '195814', 'storage/1684833291_presidential suite (3).jpg', NULL, 'active', 9, '2023-05-23 16:14:51', '2023-05-23 16:14:51'),
(24, '1684833474_presidential suite (46).jpg', '854523', 'storage/1684833474_presidential suite (46).jpg', NULL, 'active', 8, '2023-05-23 16:17:54', '2023-05-23 16:17:54'),
(25, '1684833965_presidential suite (3).jpg', '2982804', 'storage/1684833965_presidential suite (3).jpg', NULL, 'active', 7, '2023-05-23 16:26:05', '2023-05-23 16:26:05'),
(26, '1684834816_deluxe twin bed (2).jpg', '865582', 'storage/1684834816_deluxe twin bed (2).jpg', NULL, 'active', 7, '2023-05-23 16:40:16', '2023-05-23 16:40:16'),
(27, '1684835331_presidential suite (41) (1).jpg', '725221', 'storage/1684835331_presidential suite (41) (1).jpg', NULL, 'active', 7, '2023-05-23 16:48:51', '2023-05-23 16:48:51'),
(28, '1684835517_deluxe twin bed (2).jpg', '865582', 'storage/1684835517_deluxe twin bed (2).jpg', NULL, 'active', 10, '2023-05-23 16:51:57', '2023-05-23 16:51:57'),
(29, '1684835517_deluxe twin bed (8).jpg', '783239', 'storage/1684835517_deluxe twin bed (8).jpg', NULL, 'active', 10, '2023-05-23 16:51:57', '2023-05-23 16:51:57'),
(30, '1684835517_deluxe twin bed (14).jpg', '668581', 'storage/1684835517_deluxe twin bed (14).jpg', NULL, 'active', 10, '2023-05-23 16:51:57', '2023-05-23 16:51:57'),
(36, '1684919405_presidential_suite_3_700.jpg', '668020', 'storage/1684919405_presidential_suite_3_700.jpg', NULL, 'active', 8, '2023-05-24 16:10:05', '2023-05-24 16:10:05'),
(37, '1684919405_presidential_suite_5_700.jpg', '697089', 'storage/1684919405_presidential_suite_5_700.jpg', NULL, 'active', 8, '2023-05-24 16:10:05', '2023-05-24 16:10:05'),
(38, '1684919405_presidential_suite_13_700.jpg', '646464', 'storage/1684919405_presidential_suite_13_700.jpg', NULL, 'active', 8, '2023-05-24 16:10:05', '2023-05-24 16:10:05'),
(39, '1684919405_presidential_suite_28_700.jpg', '688493', 'storage/1684919405_presidential_suite_28_700.jpg', NULL, 'active', 8, '2023-05-24 16:10:05', '2023-05-24 16:10:05'),
(40, '1684919405_standard_room_15_700.jpg', '698139', 'storage/1684919405_standard_room_15_700.jpg', NULL, 'active', 8, '2023-05-24 16:10:05', '2023-05-24 16:10:05'),
(41, '1686061246_presidential suite (19) (1) (1).jpg', '398336', 'storage/1686061246_presidential suite (19) (1) (1).jpg', NULL, 'active', 7, '2023-06-06 21:20:46', '2023-06-06 21:20:46'),
(42, '1695979142_standard room (16).jpg', '551050', 'storage/1695979142_standard room (16).jpg', NULL, 'active', 10, '2023-09-29 16:19:02', '2023-09-29 16:19:02');

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `subject` text NOT NULL,
  `email` varchar(191) NOT NULL,
  `photo` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `message` longtext NOT NULL,
  `read_at` timestamp NULL 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 `messages`
--

INSERT INTO `messages` (`id`, `name`, `subject`, `email`, `photo`, `phone`, `message`, `read_at`, `created_at`, `updated_at`) VALUES
(1, 'Rose Kika', 'Request help', 'rose@gmail.com', NULL, '09072567889', 'This is a test please', '2023-05-19 15:02:47', '2023-04-16 22:50:00', '2023-05-19 15:02:47'),
(2, 'Catherine Williams', 'Re:', 'nathansarmstrongs536@gmail.com', NULL, '5162064782', 'Hi,\r\n\r\nThis is Catherine.\r\n\r\nCan we speak right now?', NULL, '2023-08-26 04:48:39', '2023-08-26 04:48:39'),
(3, 'carine', 'testing the website', 'irangacarine@yahoo.fr', NULL, '75000000', 'testing the website email', '2023-09-30 18:57:48', '2023-09-29 16:51:36', '2023-09-30 18:57:48'),
(4, 'GeorgeBew', 'Mfheidjwhfuh HUJUHGUJH djwidjwfhuefejjifeh NUHUUUhufhedjefheuhufheudhuwfhu', 'yasen.krasen.13+89549@mail.ru', NULL, '85842759468', 'Nguheidjiwfefhei ijiwdwjurFEJDKWIJFEIF аоушвцшургаруш ШОРГПГОШРГРПГОГРГ iryuieoieifegjejj bvncehfedjiehfu tropitelgitega.com', NULL, '2023-10-29 08:40:53', '2023-10-29 08:40:53'),
(5, 'Philippriog', 'How to make money from email newsletters from $30,000 per month', 'vozhegovdok96@gmail.com', NULL, '85593189461', 'Stable income from email newsletters from $30,000 per month http://emailmarketing-26526559.magnetorepairs.com/offer?38410', NULL, '2023-10-30 19:17:34', '2023-10-30 19:17:34'),
(6, 'Philippriog', 'How to make money from email newsletters from $30,000 per month', 'vozhegovdok96@gmail.com', NULL, '86348963798', 'Stable income from email newsletters from $30,000 per month http://emailmarketing-26526559.magnetorepairs.com/offer?38410', NULL, '2023-10-30 19:17:36', '2023-10-30 19:17:36'),
(7, 'Philippriog', 'How to make money from email newsletters from $30,000 per month', 'vozhegovdok96@gmail.com', NULL, '86845568483', 'Stable income from email newsletters from $30,000 per month http://emailmarketing-26526559.magnetorepairs.com/offer?38410', NULL, '2023-10-30 19:17:38', '2023-10-30 19:17:38'),
(8, 'Philippriog', 'How to make money from email newsletters from $30,000 per month', 'vozhegovdok96@gmail.com', NULL, '83629728715', 'Stable income from email newsletters from $30,000 per month http://emailmarketing-26526559.magnetorepairs.com/offer?38410', NULL, '2023-10-30 19:17:39', '2023-10-30 19:17:39'),
(9, 'Philippriog', 'How to make money from email newsletters from $30,000 per month', 'vozhegovdok96@gmail.com', NULL, '89268715536', 'Stable income from email newsletters from $30,000 per month http://emailmarketing-26526559.magnetorepairs.com/offer?38410', NULL, '2023-10-30 19:17:41', '2023-10-30 19:17:41'),
(10, 'MiguelBah', 'URGENT MESSAGE! You have been credited $45,203.11. Withdraw money urgently', 'rojas.anthony7@gmail.com', NULL, '86275193245', 'IMPORTANT MESSAGE! They will transfer you $45,015.79. Withdraw money urgently http://withdrawspeedlaneway-4353040.musicbats.com/on?785', NULL, '2023-11-06 12:14:37', '2023-11-06 12:14:37'),
(11, 'MiguelBah', 'URGENT MESSAGE! You have been credited $45,203.11. Withdraw money urgently', 'rojas.anthony7@gmail.com', NULL, '81369267567', 'IMPORTANT MESSAGE! They will transfer you $45,015.79. Withdraw money urgently http://withdrawspeedlaneway-4353040.musicbats.com/on?785', NULL, '2023-11-06 12:14:39', '2023-11-06 12:14:39'),
(12, 'MiguelBah', 'URGENT MESSAGE! You have been credited $45,203.11. Withdraw money urgently', 'rojas.anthony7@gmail.com', NULL, '87762973972', 'IMPORTANT MESSAGE! They will transfer you $45,015.79. Withdraw money urgently http://withdrawspeedlaneway-4353040.musicbats.com/on?785', NULL, '2023-11-06 12:14:41', '2023-11-06 12:14:41'),
(13, 'MiguelBah', 'URGENT MESSAGE! You have been credited $45,203.11. Withdraw money urgently', 'rojas.anthony7@gmail.com', NULL, '86986179122', 'IMPORTANT MESSAGE! They will transfer you $45,015.79. Withdraw money urgently http://withdrawspeedlaneway-4353040.musicbats.com/on?785', NULL, '2023-11-06 12:14:42', '2023-11-06 12:14:42'),
(14, 'MiguelBah', 'URGENT MESSAGE! You have been credited $45,203.11. Withdraw money urgently', 'rojas.anthony7@gmail.com', NULL, '87554655667', 'IMPORTANT MESSAGE! They will transfer you $45,015.79. Withdraw money urgently http://withdrawspeedlaneway-4353040.musicbats.com/on?785', NULL, '2023-11-06 12:14:44', '2023-11-06 12:14:44'),
(15, 'Express Pickup Store', 'Room prices', 'info@express-pickup.com', NULL, '+41779427308', 'Hi,\r\nCould you please send me information about the prices for the hotel rooms in euros?\r\nThanks', NULL, '2023-12-20 18:54:36', '2023-12-20 18:54:36'),
(16, 'Melody Musser', 'Piscine', 'melody.musser@gmail.com', NULL, '62375237', 'Bonjour, on paie combien pour utiliser la piscine si on ne loge pas à l’hôtel?', NULL, '2023-12-22 14:51:48', '2023-12-22 14:51:48'),
(17, 'BitcoinSystem', '€1.000 in 60 minuten', 'bitcoinsystem@hotmail.com', NULL, '8008943572529', 'http://go.vemaqaov.com/0m3k Het enige wat u hoeft te doen is uw software nu GRATIS aan te schaffen.', NULL, '2024-01-01 16:43:45', '2024-01-01 16:43:45'),
(18, 'Westonavalp', 'VERY BEAUTIFUL GIRLS WANT SEX WITH YOU ONLY ON THIS DATING SITE', 'brianroberts59@yahoo.com', NULL, '85888666715', 'VERY SEXY GIRLS ARE LOOKING FOR SEX FOR ONE TIME ONLY ON THIS DATING SITE https://onlineuniversalwork.com/9xgl0 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\nn5vx4u9b9d1b4j7u \r\nm1rr8l8i7u1e1z7k \r\nn8yk8q3a1z3c4n6m', NULL, '2024-01-22 15:54:13', '2024-01-22 15:54:13'),
(19, 'Westonavalp', 'VERY BEAUTIFUL GIRLS WANT SEX WITH YOU ONLY ON THIS DATING SITE', 'brianroberts59@yahoo.com', NULL, '87243989447', 'VERY SEXY GIRLS ARE LOOKING FOR SEX FOR ONE TIME ONLY ON THIS DATING SITE https://onlineuniversalwork.com/9xgl0 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\nn5vx4u9b9d1b4j7u \r\nm1rr8l8i7u1e1z7k \r\nn8yk8q3a1z3c4n6m', NULL, '2024-01-22 15:54:15', '2024-01-22 15:54:15'),
(20, 'Westonavalp', 'VERY BEAUTIFUL GIRLS WANT SEX WITH YOU ONLY ON THIS DATING SITE', 'brianroberts59@yahoo.com', NULL, '88441632594', 'VERY SEXY GIRLS ARE LOOKING FOR SEX FOR ONE TIME ONLY ON THIS DATING SITE https://onlineuniversalwork.com/9xgl0 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\nn5vx4u9b9d1b4j7u \r\nm1rr8l8i7u1e1z7k \r\nn8yk8q3a1z3c4n6m', NULL, '2024-01-22 15:54:17', '2024-01-22 15:54:17'),
(21, 'Westonavalp', 'VERY BEAUTIFUL GIRLS WANT SEX WITH YOU ONLY ON THIS DATING SITE', 'brianroberts59@yahoo.com', NULL, '82244278973', 'VERY SEXY GIRLS ARE LOOKING FOR SEX FOR ONE TIME ONLY ON THIS DATING SITE https://onlineuniversalwork.com/9xgl0 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\nn5vx4u9b9d1b4j7u \r\nm1rr8l8i7u1e1z7k \r\nn8yk8q3a1z3c4n6m', NULL, '2024-01-22 15:54:18', '2024-01-22 15:54:18'),
(22, 'Westonavalp', 'VERY BEAUTIFUL GIRLS WANT SEX WITH YOU ONLY ON THIS DATING SITE', 'brianroberts59@yahoo.com', NULL, '85513973466', 'VERY SEXY GIRLS ARE LOOKING FOR SEX FOR ONE TIME ONLY ON THIS DATING SITE https://onlineuniversalwork.com/9xgl0 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\nn5vx4u9b9d1b4j7u \r\nm1rr8l8i7u1e1z7k \r\nn8yk8q3a1z3c4n6m', NULL, '2024-01-22 15:54:20', '2024-01-22 15:54:20'),
(23, 'Charlestiz', 'Miieefjief jiwjdwkijdwf iwkdqdjwifehfuwi kwkdwjejeieifw jwioodwijrewhe', 'yasen.krasen.13+92318@mail.ru', NULL, '85128116412', 'Ofokfojfief jwlkfeejereghfj iewojfekfjergij wiojewjfewitghuhwrgtjgh ewjhfwqjhdfuewgtuiwe huegfrwgyewgtywegt tropitelgitega.com', NULL, '2024-02-11 09:17:41', '2024-02-11 09:17:41'),
(24, 'Robertnef', 'Hello,   write about     price', 'lucido.leinteract@gmail.com', NULL, '84438236639', 'Salut, ech wollt Äre Präis wëssen.', NULL, '2024-02-15 10:13:15', '2024-02-15 10:13:15'),
(25, 'Robertnef', 'Hello,   write about     price', 'lucido.leinteract@gmail.com', NULL, '88818667956', 'Salut, ech wollt Äre Präis wëssen.', NULL, '2024-02-15 10:13:16', '2024-02-15 10:13:16'),
(26, 'Robertnef', 'Hello,   write about     price', 'lucido.leinteract@gmail.com', NULL, '88385113111', 'Salut, ech wollt Äre Präis wëssen.', NULL, '2024-02-15 10:13:18', '2024-02-15 10:13:18'),
(27, 'Robertnef', 'Hello,   write about     price', 'lucido.leinteract@gmail.com', NULL, '86321248757', 'Salut, ech wollt Äre Präis wëssen.', NULL, '2024-02-15 10:13:20', '2024-02-15 10:13:20'),
(28, 'Robertnef', 'Hello,   write about     price', 'lucido.leinteract@gmail.com', NULL, '82842289625', 'Salut, ech wollt Äre Präis wëssen.', NULL, '2024-02-15 10:13:22', '2024-02-15 10:13:22'),
(29, 'Robertnef', 'Hi, i am wrote about     price for reseller', 'lucido.leinteract@gmail.com', NULL, '81976711239', 'Hola, quería saber tu precio..', NULL, '2024-02-24 21:04:36', '2024-02-24 21:04:36'),
(30, 'Robertnef', 'Hi, i am wrote about     price for reseller', 'lucido.leinteract@gmail.com', NULL, '81732581873', 'Hola, quería saber tu precio..', NULL, '2024-02-24 21:04:38', '2024-02-24 21:04:38'),
(31, 'Robertnef', 'Hi, i am wrote about     price for reseller', 'lucido.leinteract@gmail.com', NULL, '88615375758', 'Hola, quería saber tu precio..', NULL, '2024-02-24 21:04:40', '2024-02-24 21:04:40'),
(32, 'Robertnef', 'Hi, i am wrote about     price for reseller', 'lucido.leinteract@gmail.com', NULL, '81957961299', 'Hola, quería saber tu precio..', NULL, '2024-02-24 21:04:41', '2024-02-24 21:04:41'),
(33, 'Robertnef', 'Hi, i am wrote about     price for reseller', 'lucido.leinteract@gmail.com', NULL, '82153245392', 'Hola, quería saber tu precio..', NULL, '2024-02-24 21:04:43', '2024-02-24 21:04:43'),
(34, 'Bella', 'The best offer for you today only!', 'bellaviatt@gmail.com', NULL, '83823331443', 'https://bit.ly/3IiX0dz Huge selection!', NULL, '2024-03-16 07:47:32', '2024-03-16 07:47:32'),
(35, 'Iirinabox', 'Very interesting offer!', 'Acagepef@gmail.com', NULL, '82355936338', 'Hi! Have s3x in your city today.  -  https://rb.gy/9pkq6l?box', NULL, '2024-03-20 19:57:51', '2024-03-20 19:57:51'),
(36, 'SpeedyIndex', 'SpeedyIndexBot - 100 links for FREE', 'speedyindex@gmail.com', NULL, '86478756454', 'https://bit.ly/3OV6orJ service for fast indexing of links in Google. First result in 48 hours. 100 links for FREE.', NULL, '2024-03-21 08:04:55', '2024-03-21 08:04:55'),
(37, 'KatyaLiainty1', 'Hey there, handsome!', 'Acagepef@gmail.com', NULL, '84545317374', 'Let\'s escape for the weekend to that charming bed and breakfast I found - just us, no distractions.  -   https://rb.gy/5nfvy9?box', NULL, '2024-03-24 00:33:31', '2024-03-24 00:33:31'),
(38, 'KatyaLiainty2', 'Hey there, handsome!', 'Acagepef@gmail.com', NULL, '89355267166', 'I\'ve heard about this rooftop jazz lounge with a stunning view - would you like to check it out with me?  -   https://u.to/DRuCIA?box', NULL, '2024-03-25 15:56:59', '2024-03-25 15:56:59'),
(39, 'Seoprogony', 'Прогоны Ваших сайтов, групп в соцсетях', 'seoprogony@gmail.com', NULL, '89331319922', 'https://seo-progony.ru/ обращайтесь, будем рады Вас видеть в качестве нашего клиента.', NULL, '2024-03-26 00:25:25', '2024-03-26 00:25:25'),
(40, 'KatyaLiainty3', 'Hi cutie, what\'s up?', 'affodOttofBug1@gmail.com', NULL, '84652376713', 'Fancy a moonlit stroll along the beach under the stars, followed by a bonfire picnic for two?  -   https://rb.gy/psrixq?box', NULL, '2024-03-27 04:33:03', '2024-03-27 04:33:03'),
(41, 'KatyaLiainty1', 'Hello dear, care to chat?', 'affodOttofBug1@gmail.com', NULL, '88728378449', 'Hi, let\'s create some unforgettable memories tonight.  -  https://u.to/CXOGIA?box', NULL, '2024-03-29 05:01:12', '2024-03-29 05:01:12'),
(42, 'KatyaLiainty3', 'Hi there, handsome stranger!', 'affodOttofBug2@gmail.com', NULL, '86221997657', 'Hey there, care to join me for a nightcap?  -  https://u.to/CXOGIA?box', NULL, '2024-03-31 06:14:37', '2024-03-31 06:14:37'),
(43, 'KatyaLiainty2', 'Hi sweetie, long time no see!', 'affodOttofBug1@gmail.com', NULL, '87887214439', 'Hello, I\'ve been dreaming of our intimate rendezvous.  -  https://u.to/CXOGIA?box', NULL, '2024-04-01 13:43:59', '2024-04-01 13:43:59'),
(44, 'KatyaLiainty3', 'Hello darling, feeling lucky?', 'affodOttofBug2@gmail.com', NULL, '85194613854', 'Hey cutie, want to see the stars with me?  -  https://rb.gy/psrixq?box', NULL, '2024-04-03 06:34:20', '2024-04-03 06:34:20'),
(45, 'Robertnef', 'Hallo,   writing about your   price for reseller', 'lucido.leinteract@gmail.com', NULL, '86316331254', 'Здравейте, исках да знам цената ви.', NULL, '2024-04-03 13:47:28', '2024-04-03 13:47:28'),
(46, 'Robertnef', 'Hallo,   writing about your   price for reseller', 'lucido.leinteract@gmail.com', NULL, '89146629161', 'Здравейте, исках да знам цената ви.', NULL, '2024-04-03 13:47:30', '2024-04-03 13:47:30'),
(47, 'Robertnef', 'Hallo,   writing about your   price for reseller', 'lucido.leinteract@gmail.com', NULL, '86114452662', 'Здравейте, исках да знам цената ви.', NULL, '2024-04-03 13:47:32', '2024-04-03 13:47:32'),
(48, 'Robertnef', 'Hallo,   writing about your   price for reseller', 'lucido.leinteract@gmail.com', NULL, '84898243742', 'Здравейте, исках да знам цената ви.', NULL, '2024-04-03 13:47:34', '2024-04-03 13:47:34'),
(49, 'Robertnef', 'Hallo,   writing about your   price for reseller', 'lucido.leinteract@gmail.com', NULL, '83638586536', 'Здравейте, исках да знам цената ви.', NULL, '2024-04-03 13:47:35', '2024-04-03 13:47:35'),
(50, 'Kahuma Andrew', 'Testings', 'kagsburg@gmail.com', NULL, '+255706499299', 'Updated to New Email on website', NULL, '2024-04-04 20:38:27', '2024-04-04 20:38:27'),
(51, 'Robertnef', 'Hi  i am writing about     price', 'lucido.leinteract@gmail.com', NULL, '84456415358', 'Szia, meg akartam tudni az árát.', NULL, '2024-04-13 11:05:52', '2024-04-13 11:05:52'),
(52, 'Robertnef', 'Hi  i am writing about     price', 'lucido.leinteract@gmail.com', NULL, '82673348526', 'Szia, meg akartam tudni az árát.', NULL, '2024-04-13 11:05:54', '2024-04-13 11:05:54'),
(53, 'Robertnef', 'Hi  i am writing about     price', 'lucido.leinteract@gmail.com', NULL, '86749479926', 'Szia, meg akartam tudni az árát.', NULL, '2024-04-13 11:05:55', '2024-04-13 11:05:55'),
(54, 'Robertnef', 'Hi  i am writing about     price', 'lucido.leinteract@gmail.com', NULL, '87317997124', 'Szia, meg akartam tudni az árát.', NULL, '2024-04-13 11:05:57', '2024-04-13 11:05:57'),
(55, 'Robertnef', 'Hi  i am writing about     price', 'lucido.leinteract@gmail.com', NULL, '82248326498', 'Szia, meg akartam tudni az árát.', NULL, '2024-04-13 11:05:59', '2024-04-13 11:05:59'),
(56, 'Robertnef', 'Aloha, i am writing about   the price for reseller', 'lucido.leinteract@gmail.com', NULL, '87927374514', 'Hola, volia saber el seu preu.', NULL, '2024-04-20 20:10:45', '2024-04-20 20:10:45'),
(57, 'Robertnef', 'Aloha, i am writing about   the price for reseller', 'lucido.leinteract@gmail.com', NULL, '87722216165', 'Hola, volia saber el seu preu.', NULL, '2024-04-20 20:10:47', '2024-04-20 20:10:47'),
(58, 'Robertnef', 'Aloha, i am writing about   the price for reseller', 'lucido.leinteract@gmail.com', NULL, '81863445138', 'Hola, volia saber el seu preu.', NULL, '2024-04-20 20:10:49', '2024-04-20 20:10:49'),
(59, 'Robertnef', 'Aloha, i am writing about   the price for reseller', 'lucido.leinteract@gmail.com', NULL, '88937477927', 'Hola, volia saber el seu preu.', NULL, '2024-04-20 20:10:51', '2024-04-20 20:10:51'),
(60, 'Robertnef', 'Aloha, i am writing about   the price for reseller', 'lucido.leinteract@gmail.com', NULL, '86815683867', 'Hola, volia saber el seu preu.', NULL, '2024-04-20 20:10:52', '2024-04-20 20:10:52'),
(61, 'MichaelVurgy', 'Mjewdjwjdw jwksqkowjfjj kkepwlw3jreklm kwldewkdjr3kdw2o keo2kswlkforejw', 'yasen.krasen.13+83269@mail.ru', NULL, '89513273515', 'Odowidjwoidwo wojdwkslqmwjfbjjdwkd jkwlsqswknfbjwjdmkqendj kedwjdbwhbdqjswkdwjfj eqwkdwknf tropitelgitega.com', NULL, '2024-04-22 08:01:28', '2024-04-22 08:01:28'),
(62, 'Robertkix', 'We invite you to a private crypto exchange', 'maski8wirty@mail.com', NULL, '82235187395', 'Good afternoon! We give you a promo code - ZBXM777 \r\nActivate it in your personal account after registering on www.cexasia.pro \r\nAnd you will receive up to 1000USDT on your deposit. Happy trading!', NULL, '2024-04-23 06:41:48', '2024-04-23 06:41:48'),
(63, 'Robertnef', 'Hallo,   write about   the prices', 'lucido.leinteract@gmail.com', NULL, '87584535456', 'Здравейте, исках да знам цената ви.', NULL, '2024-04-28 15:55:27', '2024-04-28 15:55:27'),
(64, 'Robertnef', 'Hallo,   write about   the prices', 'lucido.leinteract@gmail.com', NULL, '88176499676', 'Здравейте, исках да знам цената ви.', NULL, '2024-04-28 15:55:29', '2024-04-28 15:55:29'),
(65, 'Robertnef', 'Hallo,   write about   the prices', 'lucido.leinteract@gmail.com', NULL, '87727431755', 'Здравейте, исках да знам цената ви.', NULL, '2024-04-28 15:55:31', '2024-04-28 15:55:31'),
(66, 'Robertnef', 'Hallo,   write about   the prices', 'lucido.leinteract@gmail.com', NULL, '86798515683', 'Здравейте, исках да знам цената ви.', NULL, '2024-04-28 15:55:33', '2024-04-28 15:55:33'),
(67, 'Robertnef', 'Hallo,   write about   the prices', 'lucido.leinteract@gmail.com', NULL, '87675953589', 'Здравейте, исках да знам цената ви.', NULL, '2024-04-28 15:55:34', '2024-04-28 15:55:34'),
(68, 'Robertnef', 'Hi, i am wrote about your   prices', 'lucido.leinteract@gmail.com', NULL, '81166584478', 'Salam, qiymətinizi bilmək istədim.', NULL, '2024-05-07 00:57:28', '2024-05-07 00:57:28'),
(69, 'Robertnef', 'Hi, i am wrote about your   prices', 'lucido.leinteract@gmail.com', NULL, '83972983975', 'Salam, qiymətinizi bilmək istədim.', NULL, '2024-05-07 00:57:29', '2024-05-07 00:57:29'),
(70, 'Robertnef', 'Hi, i am wrote about your   prices', 'lucido.leinteract@gmail.com', NULL, '86934731228', 'Salam, qiymətinizi bilmək istədim.', NULL, '2024-05-07 00:57:31', '2024-05-07 00:57:31'),
(71, 'Robertnef', 'Hi, i am wrote about your   prices', 'lucido.leinteract@gmail.com', NULL, '87348622149', 'Salam, qiymətinizi bilmək istədim.', NULL, '2024-05-07 00:57:33', '2024-05-07 00:57:33'),
(72, 'Robertnef', 'Hi, i am wrote about your   prices', 'lucido.leinteract@gmail.com', NULL, '81115574181', 'Salam, qiymətinizi bilmək istədim.', NULL, '2024-05-07 00:57:35', '2024-05-07 00:57:35'),
(73, 'Robertnef', 'Hallo,   writing about     price', 'lucido.leinteract@gmail.com', NULL, '87413373721', 'Zdravo, htio sam znati vašu cijenu.', '2024-06-07 13:15:53', '2024-05-13 14:48:54', '2024-06-07 13:15:53'),
(74, 'Robertnef', 'Hallo,   writing about     price', 'lucido.leinteract@gmail.com', NULL, '81386516589', 'Zdravo, htio sam znati vašu cijenu.', NULL, '2024-05-13 14:48:56', '2024-05-13 14:48:56'),
(75, 'Robertnef', 'Hallo,   writing about     price', 'lucido.leinteract@gmail.com', NULL, '89934859773', 'Zdravo, htio sam znati vašu cijenu.', NULL, '2024-05-13 14:48:58', '2024-05-13 14:48:58'),
(76, 'Robertnef', 'Hallo,   writing about     price', 'lucido.leinteract@gmail.com', NULL, '85986593535', 'Zdravo, htio sam znati vašu cijenu.', NULL, '2024-05-13 14:48:59', '2024-05-13 14:48:59'),
(77, 'Robertnef', 'Hallo,   writing about     price', 'lucido.leinteract@gmail.com', NULL, '84381637873', 'Zdravo, htio sam znati vašu cijenu.', '2024-06-07 13:14:12', '2024-05-13 14:49:01', '2024-06-07 13:14:12'),
(78, 'Stevon Lack', 'Hi tropitelgitega.com Owner!', 'stevon+tv04@gmail.com', NULL, '795164978', 'I recently checked out your website and have a few inquiries. Is this the right way to reach you?', NULL, '2024-06-19 13:29:28', '2024-06-19 13:29:28'),
(79, 'mikeExpeddy', 'Use your online potential to obtain financial independence!  - https://rb.gy/9fznxm?Dems9nut', 'pros.p.er.i.ty.t.h.e.m.oneyuspen@gmail.com', NULL, '82592624886', 'Money is the best cure for all diseases! Earn up to $500 per day and show how you can live to the fullest!\r\n - https://rb.gy/9fznxm?Dems-nut', NULL, '2024-06-25 18:51:41', '2024-06-25 18:51:41'),
(80, 'Amandaflutrarka', 'Hey stud, ready for love?', 'amandabogegism3@gmail.com', NULL, '86521168611', 'Hey darling, want to hang out? -  https://rb.gy/7rnhss?theorp', NULL, '2024-06-27 19:51:47', '2024-06-27 19:51:47'),
(81, 'Malinda Speight', 'Dear tropitelgitega.com Owner!', 'speight.malinda@gmail.com', NULL, '645624870', 'Are you still looking at getting your website done/ completed? Contact e.solus@gmail.com', NULL, '2024-07-02 07:27:09', '2024-07-02 07:27:09'),
(82, 'John Holdsworth', 'Hi tropitelgitega.com Admin.', 'timmy.holdsworth@msn.com', NULL, '882775250', 'Are you still looking at getting your website\'s SEO done? Contact Now intrug@gmail.com', NULL, '2024-07-08 20:08:20', '2024-07-08 20:08:20'),
(83, 'Amandaflutrarkc', 'Hey stud, ready for love?', 'amandabogegism3@gmail.com', NULL, '85562995746', 'Hey darling, want to hang out? -  http://surl.li/ulebc?Raday', NULL, '2024-07-09 15:09:33', '2024-07-09 15:09:33'),
(84, 'Indira Truebridge', 'Hi tropitelgitega.com Admin!', 'truebridge.indira@googlemail.com', NULL, '7020798351', 'Work From Home With This 100% FREE Training..., I Promise...You Will Never Look Back\r\n$500+ per day, TRUE -100% Free Training, go here:\r\n\r\nezwayto1000aday.com', NULL, '2024-07-21 00:30:21', '2024-07-21 00:30:21'),
(85, 'ThomasTor', 'Mjewdjwjdw jwksqkowjfjj kkepwlw3jreklm kwldewkdjr3kdw2o keo2kswlkforejw', 'yasen.krasen.13+95567@mail.ru', NULL, '81688992644', 'Ofedkwdkjwkjdkwjdkjw jdwidjwijdwfw fjdkqwasqfoewofjewof ojqwejfqwkdokjwofjewofjewoi tropitelgitega.com', NULL, '2024-07-21 18:35:49', '2024-07-21 18:35:49'),
(86, 'RandyJulge', 'BIG WIN IPHONE 16 PRO MAX', 'boshkocamaj@icloud.com', NULL, '81366519147', 'CELEBRATE IPHONE 16 PRO MAX https://www.topwareshop.com/goto.php?URL=https%3A%2F%2Ftelegra.ph%2Fiphone-07-06-5%3F6088', NULL, '2024-08-04 21:13:58', '2024-08-04 21:13:58'),
(87, 'RandyJulge', 'You’re a Winner: iPhone 16 Pro Max', 'karasing23@icloud.com', NULL, '84443485647', 'You’ve Won Big: iPhone 16 Pro Max http://downorjustforme.com/telegra.ph%2Fiphone-07-06-5%3F2993', NULL, '2024-08-06 09:23:30', '2024-08-06 09:23:30'),
(88, 'Carley Wessel', 'Hello tropitelgitega.com Admin!', 'carley.wessel@googlemail.com', NULL, '6504749002', 'Are you still looking at getting your website done/ completed? Contact e.solus@gmail.com', NULL, '2024-08-09 08:04:32', '2024-08-09 08:04:32');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) 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_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2020_07_10_025334_create_banners_table', 1),
(5, '2020_07_10_112147_create_categories_table', 1),
(6, '2020_07_11_063857_create_rooms_table', 1),
(7, '2020_07_12_073132_create_post_categories_table', 1),
(8, '2020_07_12_073701_create_post_tags_table', 1),
(9, '2020_07_12_083638_create_posts_table', 1),
(10, '2020_07_13_151329_create_messages_table', 1),
(11, '2020_07_14_023748_create_shippings_table', 1),
(12, '2020_07_15_054356_create_orders_table', 1),
(13, '2020_07_15_102626_create_carts_table', 1),
(14, '2020_07_16_041623_create_notifications_table', 1),
(15, '2020_07_24_074930_create_room_reviews_table', 1),
(16, '2020_07_24_131727_create_post_comments_table', 1),
(17, '2020_08_01_143408_create_settings_table', 1),
(18, '2022_12_26_161828_create_services_table', 1);

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

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

CREATE TABLE `notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(191) NOT NULL,
  `notifiable_type` varchar(191) NOT NULL,
  `notifiable_id` bigint(20) UNSIGNED NOT NULL,
  `data` text NOT NULL,
  `read_at` timestamp NULL 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 `notifications`
--

INSERT INTO `notifications` (`id`, `type`, `notifiable_type`, `notifiable_id`, `data`, `read_at`, `created_at`, `updated_at`) VALUES
('2b75adcc-218d-4b73-a5e1-f16264dfb5ac', 'App\\Notifications\\StatusNotification', 'App\\User', 1, '{\"title\":\"New Comment created\",\"actionURL\":\"https:\\/\\/0026.ufanisiafrica.info\\/blog-detail\\/post-1\",\"fas\":\"fas fa-comment\"}', NULL, '2023-04-16 22:33:53', '2023-04-16 22:33:53'),
('4401c2d9-7db5-4e32-b0a9-b2eacd6eebe1', 'App\\Notifications\\StatusNotification', 'App\\User', 1, '{\"title\":\"New Room Rating!\",\"actionURL\":\"https:\\/\\/0026.ufanisiafrica.info\\/room-detail\\/standard1-bed\",\"fas\":\"fa-star\"}', '2024-02-20 14:11:17', '2023-04-16 23:05:38', '2024-02-20 14:11:17'),
('6ea98245-6a50-4c38-b5be-e9cbb159c789', 'App\\Notifications\\StatusNotification', 'App\\User', 1, '{\"title\":\"New Comment created\",\"actionURL\":\"https:\\/\\/0026.ufanisiafrica.info\\/blog-detail\\/visite\",\"fas\":\"fas fa-comment\"}', '2023-06-08 19:20:13', '2023-04-24 22:16:34', '2023-06-08 19:20:13'),
('8d4be869-00b6-4a7a-9050-94542b2a998d', 'App\\Notifications\\StatusNotification', 'App\\User', 1, '{\"title\":\"New Comment created\",\"actionURL\":\"https:\\/\\/0026.ufanisiafrica.info\\/blog-detail\\/post-2\",\"fas\":\"fas fa-comment\"}', '2023-04-20 22:24:25', '2023-04-16 23:05:53', '2023-04-20 22:24:25'),
('ee43d57f-249b-4e05-b9a1-469106c11e62', 'App\\Notifications\\StatusNotification', 'App\\User', 1, '{\"title\":\"New Comment created\",\"actionURL\":\"https:\\/\\/0026.ufanisiafrica.info\\/blog-detail\\/post-1\",\"fas\":\"fas fa-comment\"}', NULL, '2023-04-14 22:53:20', '2023-04-14 22:53:20');

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `first_name` varchar(191) NOT NULL,
  `last_name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `phone` varchar(191) NOT NULL,
  `country` varchar(191) NOT NULL,
  `post_code` varchar(191) DEFAULT NULL,
  `address1` text NOT NULL,
  `address2` text DEFAULT NULL,
  `room_id` bigint(20) UNSIGNED DEFAULT NULL,
  `fax` varchar(191) NOT NULL,
  `number_of_adults` varchar(191) NOT NULL,
  `number_of_kids` varchar(191) NOT NULL,
  `number_of_rooms` int(11) NOT NULL,
  `arrival_date` date NOT NULL,
  `arrival_time` time NOT NULL,
  `departure_date` date 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 `orders`
--

INSERT INTO `orders` (`id`, `user_id`, `first_name`, `last_name`, `email`, `phone`, `country`, `post_code`, `address1`, `address2`, `room_id`, `fax`, `number_of_adults`, `number_of_kids`, `number_of_rooms`, `arrival_date`, `arrival_time`, `departure_date`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Rose', 'Kika', 'rose@gmail.com', '0785432678', 'Tanzania', '345', 'Kampala, Uganda', NULL, NULL, '567', '4', '6', 0, '2023-04-17', '10:00:00', '2023-04-18', '2023-04-24 20:26:24', '2023-04-24 20:26:24'),
(2, NULL, 'Rose', 'Kika', 'rose@gmail.com', '07843578923', 'Uganda', '890', 'Kampala, Uganda', NULL, 6, '874', '4', '6', 0, '2023-04-27', '10:00:00', '2023-04-28', '2023-04-26 20:08:36', '2023-04-26 20:08:36'),
(3, NULL, 'Jane', 'test', 'jane@gmail.com', '0786543567', 'Tanzania', '567', '345', NULL, 6, '590', '4', '6', 0, '2023-04-27', '04:00:00', '2023-04-28', '2023-04-26 20:11:48', '2023-04-26 20:11:48'),
(4, NULL, 'jean', 'paul', 'jeanpaul@gmail.com', '25765656565', 'Burundi', '0000', 'Quartier Musinzira', NULL, 9, '2240454545', '1', '0', 0, '2023-05-10', '12:40:00', '2023-05-11', '2023-05-22 16:55:46', '2023-05-22 16:55:46'),
(5, NULL, 'carine', 'irangabiye', 'carine@gmail.com', '778464664', 'Burundi', '0000', 'Quartier Musinzira', NULL, 9, '2240454545', '1', '0', 0, '2023-05-18', '15:45:00', '2023-05-19', '2023-06-08 19:23:00', '2023-06-08 19:23:00'),
(6, NULL, 'test', 'test', 'test@gmail.com', '754545454', 'Burundi', '0000', 'Quartier Musinzira', NULL, 6, '2240454545', '1', '0', 0, '2023-06-02', '17:32:00', '2023-06-03', '2023-06-01 22:31:14', '2023-06-01 22:31:14'),
(7, NULL, 'test2', 'test', 'test@gmail.com', '75554554', 'Burundi', '0000', 'Quartier Musinzira', NULL, 8, '2240454545', '1', '0', 0, '2023-06-06', '14:38:00', '2023-06-07', '2023-06-08 18:42:23', '2023-06-08 18:42:23'),
(8, NULL, 'Kiyotaka', 'Takei', 'takeikiyotaka@icloud.com', '68833307', 'Japon', '186-0005', 'Nishi 2-30-105 Kunitachi-sho, Tokyo', NULL, 9, '+81-42-843-8850', '1', '0', 0, '2023-10-18', '14:00:00', '2023-10-21', '2023-10-16 22:09:37', '2023-10-16 22:09:37'),
(9, NULL, 'MARKIN', 'VADIM', 'm.andrianova1988@gmail.com', '+79152436283', 'RUSSIA', NULL, 'MOSCOW, ROGOVA ST., 4-20', NULL, NULL, '123123', '1', '0', 0, '2024-02-03', '14:00:00', '2024-02-04', '2024-02-20 14:12:51', '2024-02-20 14:12:51'),
(10, NULL, 'test2', 'test', 'test@gmail.com', '+2578888888', 'burundi', '00000', 'bujumbura', NULL, NULL, '+2222222', '1', '0', 0, '2024-02-21', '10:00:00', '2024-02-22', '2024-02-20 14:18:24', '2024-02-20 14:18:24'),
(11, NULL, 'test22', 'test', 'test@gmail.com', '+2578888888', 'burundi', NULL, 'bujumbura', NULL, 9, '+2222222', '1', '0', 0, '2024-02-23', '10:00:00', '2024-02-24', '2024-02-20 14:24:25', '2024-02-20 14:24:25'),
(12, NULL, 'pascal', 'irakoze', 'pascal@gmail.com', '+25555555', 'burundi', NULL, 'bujumbura', NULL, 9, '+22555255', '1', '0', 0, '2024-02-26', '10:00:00', '2024-02-27', '2024-05-15 17:09:46', '2024-05-15 17:09:46'),
(13, NULL, 'Faith', 'Nikobari', 'fnikobari@yahoo.com', '66510986', 'Burundi', NULL, '6eme Avenue, Bujumbura', NULL, NULL, '123456', '2', '0', 0, '2024-03-30', '10:30:00', '2024-03-31', '2024-05-15 17:08:53', '2024-05-15 17:08:53'),
(15, NULL, 'test book', 'test', 'test@gmail.com', '7523333233', 'burundi', '55555', 'burundi', NULL, 9, '22333333', '3', '0', 2, '2024-04-11', '00:00:00', '2024-04-12', '2024-06-07 13:13:00', '2024-06-07 13:13:00'),
(16, NULL, 'Emeline', 'Marcelin', 'emeline.marcelin@qeh.ox.ac.uk', '+447521006179', 'United Kingdom', 'OX1 3TB', '3 Mansfield Road, Oxford', NULL, NULL, 'no', '2', '0', 2, '2024-06-02', '14:00:00', '2024-06-07', '2024-06-07 13:12:52', '2024-06-07 13:12:52'),
(17, NULL, 'Anita', 'Fabbiano', 'anita.f@libero.it', '65298772', 'Burundi', NULL, 'Avenue Nyanzuki, Bujumbura', NULL, NULL, 'no', '2', '2', 1, '2024-06-25', '16:00:00', '2024-06-27', '2024-06-07 13:12:44', '2024-06-07 13:12:44'),
(18, NULL, 'test', 'email', 'testemail@gmail.com', '7505005050', 'burundi', '000000', 'bujumbura', NULL, 9, '0000000', '1', '0', 1, '2024-06-10', '15:00:00', '2024-06-12', '2024-06-10 14:09:27', '2024-06-10 14:09:27'),
(19, NULL, 'test', 'email', 'testemail@gmail.com', '7500000', 'burundi', '00000', 'burundi', NULL, 9, '20000000', '1', '0', 1, '2024-06-17', '10:00:00', '2024-06-18', '2024-06-17 01:20:37', '2024-06-17 01:20:37'),
(20, NULL, 'test', 'email2', 'testemail2@gmail.com', '750000000', 'burundi', '0000000', 'burundi', NULL, 7, '22222222', '1', '0', 1, '2024-06-18', '10:00:00', '2024-06-19', '2024-06-17 13:28:37', '2024-06-17 13:28:37'),
(21, NULL, 'Testing', 'Testing', 'testing@gmail.com', '0706499290', 'Abim', '222', 'Kampala', NULL, 6, '333', '3', '4', 1, '2024-06-17', '12:00:00', '2024-06-21', '2024-06-17 14:13:06', '2024-06-17 14:13:06'),
(22, NULL, 'Testing', 'Testing', 'test@gmail.com', '0706499299', 'Abim', '222', 'Kampala', NULL, 6, '333', '2', '1', 4, '2024-06-17', '12:00:00', '2024-06-21', '2024-06-17 15:06:17', '2024-06-17 15:06:17'),
(23, NULL, 'test', 'test', 'test@gmail.com', '25774774474', 'burundi', '00000', 'burundi', NULL, 6, '2000000', '1', '0', 1, '2024-06-18', '22:00:00', '2024-06-19', '2024-06-17 18:21:23', '2024-06-17 18:21:23'),
(24, NULL, 'Samart', 'Jangvittaya', 'smartcan@hotmail.com', '+66815596097', 'Thailand', '10100', '475 Luang Road', NULL, 10, '662222248', '9', '0', 4, '2024-07-23', '19:05:00', '2024-07-24', '2024-07-23 00:07:07', '2024-07-23 00:07:07'),
(25, NULL, 'Lee', 'Page', 'leepage@eml.cc', '14075950788', 'Florida, USA', 'Orlando, 32828', '16409 Bearle Rd.', NULL, NULL, 'aucun', '5', '0', 5, '2024-08-18', '14:00:00', '2024-08-20', '2024-08-02 04:27:00', '2024-08-02 04:27:00');

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `summary` text NOT NULL,
  `description` longtext DEFAULT NULL,
  `quote` text DEFAULT NULL,
  `photo` varchar(191) DEFAULT NULL,
  `tags` varchar(191) DEFAULT NULL,
  `post_cat_id` bigint(20) UNSIGNED DEFAULT NULL,
  `post_tag_id` bigint(20) UNSIGNED DEFAULT NULL,
  `added_by` bigint(20) UNSIGNED DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `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 `posts`
--

INSERT INTO `posts` (`id`, `title`, `slug`, `summary`, `description`, `quote`, `photo`, `tags`, `post_cat_id`, `post_tag_id`, `added_by`, `status`, `created_at`, `updated_at`) VALUES
(4, 'wedding ceremony', 'wedding-ceremony', 'a wonderful wedding in our beautiful hotel', '.', 'Love recognizes no barriers', 'public/images/bDKb1FLHAVkSxl1ani7tG0MEsyCAdvHnA6Dc5n4N.jpg', 'ceremony', 4, NULL, 1, 'active', '2023-06-08 19:07:01', '2023-06-08 19:07:01');

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

--
-- Table structure for table `post_categories`
--

CREATE TABLE `post_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `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 `post_categories`
--

INSERT INTO `post_categories` (`id`, `title`, `slug`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Music', 'music', 'active', '2023-04-14 22:49:13', '2023-04-14 22:49:13'),
(2, 'visite', 'visite', 'active', '2023-04-24 22:14:23', '2023-04-24 22:14:23'),
(3, 'seminaire', 'seminaire', 'active', '2023-06-06 23:39:52', '2023-06-06 23:39:52'),
(4, 'wedding', 'weeding', 'active', '2023-06-08 18:46:18', '2023-06-08 19:02:14');

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

--
-- Table structure for table `post_comments`
--

CREATE TABLE `post_comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `post_id` bigint(20) UNSIGNED DEFAULT NULL,
  `comment` text NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `replied_comment` text DEFAULT NULL,
  `parent_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 `post_comments`
--

INSERT INTO `post_comments` (`id`, `user_id`, `post_id`, `comment`, `status`, `replied_comment`, `parent_id`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, 'this is good', 'active', NULL, NULL, '2023-04-14 22:53:20', '2023-04-14 22:53:20'),
(2, 1, NULL, 'good', 'active', NULL, NULL, '2023-04-16 22:33:53', '2023-04-16 22:33:53'),
(3, 1, NULL, 'good', 'active', NULL, NULL, '2023-04-16 23:05:53', '2023-04-16 23:05:53'),
(4, 1, NULL, 'Nice', 'active', NULL, NULL, '2023-04-24 22:16:34', '2023-04-24 22:16:34');

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

--
-- Table structure for table `post_tags`
--

CREATE TABLE `post_tags` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `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 `post_tags`
--

INSERT INTO `post_tags` (`id`, `title`, `slug`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Music', 'music', 'active', '2023-04-14 22:48:28', '2023-04-14 22:48:28'),
(2, 'Technology', 'technology', 'active', '2023-04-14 22:48:37', '2023-04-14 22:48:37'),
(3, 'seminaire', 'seminaire', 'active', '2023-06-06 23:40:12', '2023-06-06 23:40:12'),
(4, 'ceremony', 'weeding', 'active', '2023-06-08 18:46:45', '2023-06-08 19:01:35');

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

--
-- Table structure for table `rooms`
--

CREATE TABLE `rooms` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `photo` varchar(191) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'inactive',
  `price` double(8,2) NOT NULL,
  `discount` double(8,2) DEFAULT NULL,
  `is_featured` tinyint(1) NOT NULL,
  `cat_id` bigint(20) UNSIGNED DEFAULT NULL,
  `child_cat_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 `rooms`
--

INSERT INTO `rooms` (`id`, `title`, `slug`, `description`, `photo`, `status`, `price`, `discount`, `is_featured`, `cat_id`, `child_cat_id`, `created_at`, `updated_at`) VALUES
(6, 'DELUXE TWIN BED', 'deluxe', '2 beds, smart TV, small fridge, room safe, tea/coffee facilities, direct dial telephone with VOIP\r\nWireless internet connectivity, private bath, shower and WC', 'public/images/LiyUeFfwXFzwpZ3c75qh9XF0bVSrmBkTvEOo2kJd.jpg', 'active', 150000.00, NULL, 1, NULL, NULL, '2023-04-14 23:46:58', '2023-09-30 16:22:42'),
(7, 'DELUXE ROOM', 'standard1-bed', '1 bed, smart TV, pool view, tea/coffee facilities, room safe, small fridge, direct dial telephone with VOIP Wireless internet connectivity, private bath, shower and WC', 'public/images/1ofzoJKNFao4wAIDGakBRHWI5nTPhlsg5wgLk5Jc.jpg', 'active', 110000.00, NULL, 1, NULL, NULL, '2023-04-15 00:08:35', '2023-09-30 16:24:54'),
(8, 'SUITE PRESIDENTIELLE', 'suite-presidentiel', '1 bed, smart TV, room safe, small fridge, tea/coffee facilities, direct dial telephone with VOIP Wireless internet connectivity, private bath, shower and WC', 'public/images/CVrUofu6yaGlUyaBC4r46Ow3ANrATcwjIestj7LQ.jpg', 'active', 150000.00, NULL, 1, NULL, NULL, '2023-04-24 20:05:56', '2023-09-30 16:27:17'),
(9, 'STANDARD', 'standard', '1 bed, smart TV, pool view, direct dial telephone with VOIP Wireless internet connectivity, private bath, shower and WC', 'public/images/tP3LHlHBhCgxXdbXBb3fmc2r82FlcUJGQ4to6nMd.jpg', 'active', 80000.00, NULL, 1, NULL, NULL, '2023-04-24 21:53:50', '2023-09-30 16:18:37'),
(10, 'STANDARD TWIN BED', 'standard-twin-bed', '2 beds, smart TV, pool view, direct dial telephone with VOIP Wireless internet connectivity, private bath, shower and WC', 'public/images/YsRDAvR2W0J7yqaCl5hHJvHJ5v1iSN92vlfeXKsZ.jpg', 'active', 120000.00, NULL, 1, NULL, NULL, '2023-05-18 17:28:36', '2023-09-30 16:20:59');

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

--
-- Table structure for table `room_reviews`
--

CREATE TABLE `room_reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `room_id` bigint(20) UNSIGNED DEFAULT NULL,
  `rate` tinyint(4) NOT NULL DEFAULT 0,
  `review` text DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `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 `room_reviews`
--

INSERT INTO `room_reviews` (`id`, `user_id`, `room_id`, `rate`, `review`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 7, 4, 'this is beautiful', 'active', '2023-04-16 23:05:38', '2023-04-16 23:05:38');

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `photo` varchar(191) DEFAULT NULL,
  `summary` text 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 `services`
--

INSERT INTO `services` (`id`, `title`, `slug`, `status`, `photo`, `summary`, `created_at`, `updated_at`) VALUES
(1, 'Parking', 'car-parking', 'active', 'public/images/UToxg5mX1rRgiArIMJWi8Ox18X5Pv2pziFDZ4cZe.jpg', 'Secure parking for vehicles is free for all guests.', '2023-04-14 22:44:48', '2023-05-24 17:00:27'),
(2, 'RESTO-BAR', 'restauration', 'active', 'public/images/4ZG6QK3txOIoCTpBkfoR2zcDBlbcVQLdvXXEBpjG.jpg', 'Experience culinary delight at our hotel restaurant and bar. Satisfy your cravings with our delicious dishes and cocktails.', '2023-04-24 20:12:47', '2023-05-24 17:37:42'),
(3, 'Conference and Events', 'salle-de-conference', 'active', 'public/images/A1hoht0pcNlo7T9rVOYfVO4X882exUFs3fdRCy49.jpg', 'With a modular meeting room with a capacity of 250 people, well equipped with a sound system, projection PowerPoint quality', '2023-04-24 20:54:43', '2023-05-24 17:18:59'),
(4, 'Swimming Pool', 'pool', 'active', 'public/images/hnS7JeARQOEnOJFWNk2cVTjOrAYMbxNFjmvGA7u4.jpg', 'Dive into our refreshing pool and escape the heat of the day. Surrounded by lush greenery, our pool is the perfect place to relax and unwind.', '2023-04-24 20:59:41', '2023-05-24 17:15:01'),
(5, 'Garden', 'garden', 'active', 'public/images/5WzmVL991VAmhWWNxPl1ZCfCo0aaakiTXGHQAbzE.jpg', 'With ample space for dining and mingling, our garden is the ideal setting for creating unforgettable memories.', '2023-04-24 21:13:01', '2023-05-24 17:31:46');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `description` longtext NOT NULL,
  `short_des` text NOT NULL,
  `logo` varchar(191) NOT NULL,
  `address` varchar(191) NOT NULL,
  `phone` varchar(191) NOT NULL,
  `email` varchar(191) 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 `settings`
--

INSERT INTO `settings` (`id`, `description`, `short_des`, `logo`, `address`, `phone`, `email`, `created_at`, `updated_at`) VALUES
(1, 'This hotel is located in the political capital of Burundi, Gitega. It enjoys an ideal location in a young and quiet high standing neighborhood, Bwoga I located in Gitega, with easy access by the RN2 Gitega-Bujumbura national road. The hotel meets all the requirements of a high-class hotel that meets International standards.', 'This hotel is located in the political capital of Burundi, Gitega.', 'public/images/gvkpXUiKMP2CpztgYXl5M7qp7yZqv1aWFYwZLym8.jpg', 'BWOGA I. Av du 28 Nov. No 03 BP 499 Gitega', '+257 22404802', 'info@tropitelgitega.com', NULL, '2023-04-14 20:37:20');

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

--
-- Table structure for table `testimonies`
--

CREATE TABLE `testimonies` (
  `id` bigint(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `message` text DEFAULT NULL,
  `slug` varchar(100) NOT NULL,
  `photo` varchar(100) DEFAULT NULL,
  `status` enum('in-active','active','','') NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `testimonies`
--

INSERT INTO `testimonies` (`id`, `name`, `message`, `slug`, `photo`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Rose Kika', 'This is a test please', '', 'public/images/JsB7Jgxbkt1eW9GDAOpiE9yUvFEwQ2LjYPvREdaQ.png', 'active', '2023-04-14 22:43:05', '2023-04-14 22:43:05'),
(2, 'Rose Kika', 'This is a test please', '-2304144337-956', 'public/images/ApDrykVy9zMOvlZFOxywhMuX5cx50tSiusbivZDX.png', 'active', '2023-04-14 22:43:37', '2023-04-14 22:43:37');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `banners`
--
ALTER TABLE `banners`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `banners_slug_unique` (`slug`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `categories_slug_unique` (`slug`),
  ADD KEY `categories_parent_id_foreign` (`parent_id`),
  ADD KEY `categories_added_by_foreign` (`added_by`);

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

--
-- Indexes for table `images`
--
ALTER TABLE `images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `images_room_id_foreign` (`room_id`);

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

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

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orders_user_id_foreign` (`user_id`),
  ADD KEY `orders_room_id_foreign` (`room_id`);

--
-- Indexes for table `posts`
--
ALTER TABLE `posts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `posts_slug_unique` (`slug`),
  ADD KEY `posts_post_cat_id_foreign` (`post_cat_id`),
  ADD KEY `posts_post_tag_id_foreign` (`post_tag_id`),
  ADD KEY `posts_added_by_foreign` (`added_by`);

--
-- Indexes for table `post_categories`
--
ALTER TABLE `post_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `post_categories_slug_unique` (`slug`);

--
-- Indexes for table `post_comments`
--
ALTER TABLE `post_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `post_comments_user_id_foreign` (`user_id`),
  ADD KEY `post_comments_post_id_foreign` (`post_id`);

--
-- Indexes for table `post_tags`
--
ALTER TABLE `post_tags`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `post_tags_slug_unique` (`slug`);

--
-- Indexes for table `rooms`
--
ALTER TABLE `rooms`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `rooms_slug_unique` (`slug`),
  ADD KEY `rooms_cat_id_foreign` (`cat_id`),
  ADD KEY `rooms_child_cat_id_foreign` (`child_cat_id`);

--
-- Indexes for table `room_reviews`
--
ALTER TABLE `room_reviews`
  ADD PRIMARY KEY (`id`),
  ADD KEY `room_reviews_user_id_foreign` (`user_id`),
  ADD KEY `room_reviews_room_id_foreign` (`room_id`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `services_slug_unique` (`slug`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `categories_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `categories_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_room_id_foreign` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `posts`
--
ALTER TABLE `posts`
  ADD CONSTRAINT `posts_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `posts_post_cat_id_foreign` FOREIGN KEY (`post_cat_id`) REFERENCES `post_categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `posts_post_tag_id_foreign` FOREIGN KEY (`post_tag_id`) REFERENCES `post_tags` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `post_comments`
--
ALTER TABLE `post_comments`
  ADD CONSTRAINT `post_comments_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `post_comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `rooms`
--
ALTER TABLE `rooms`
  ADD CONSTRAINT `rooms_cat_id_foreign` FOREIGN KEY (`cat_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `rooms_child_cat_id_foreign` FOREIGN KEY (`child_cat_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `room_reviews`
--
ALTER TABLE `room_reviews`
  ADD CONSTRAINT `room_reviews_room_id_foreign` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `room_reviews_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;
COMMIT;

