The Temple of the Sacred Tooth Relic, or Sri Dalada Maligawa, is one of the most revered religious sites in Sri Lanka. Located in the heart of Kandy, this sacred temple houses the relic of the tooth of the Buddha, making it a significant pilgrimage site for Buddhists worldwide. Join us as we explore the rich history, architectural beauty, and spiritual significance of this iconic temple.
The Temple of the Sacred Tooth Relic has a long and storied history. The tooth relic was brought to Sri Lanka in the 4th century AD from India and has since become a symbol of sovereignty. Over the centuries, the relic has been housed in various temples across the island, finally finding its home in Kandy during the reign of King Vimaladharmasuriya I in the late 16th century. The temple has been a focal point of Sri Lankan culture and politics, symbolizing the country\'s Buddhist heritage and royal lineage.
Nestled in the southeastern region of Sri Lanka, Yala National Park is a captivating wilderness that offers a thrilling wildlife experience like no other. As the second-largest national park in Sri Lanka, Yala is renowned for its stunning biodiversity, breathtaking landscapes, and one of the highest leopard densities in the world. This expansive park, spanning over 979 square kilometers, is a haven for wildlife enthusiasts, nature lovers, and adventure seekers alike. From majestic elephants and stealthy leopards to a myriad of bird species, Yala promises an unforgettable journey into the heart of Sri Lanka’s wild beauty.
Yala\'s rich history dates back to ancient times, with the park area encompassing several ancient ruins and historical sites, including the ancient Sithulpawwa monastery. This monastery, believed to be over 2,000 years old, adds a unique cultural and historical dimension to the park, offering visitors a glimpse into Sri Lanka’s ancient civilization.
Yala is divided into five blocks, with Block 1 being the most visited and famous for its abundant wildlife sightings. The park’s diverse ecosystems, ranging from dense jungles and open grasslands to freshwater lakes and coastal lagoons, create a perfect habitat for a wide variety of flora and fauna. Each ecosystem within the park contributes to its rich biodiversity, making Yala a premier destination for wildlife photography and eco-tourism.
', '2024-05-20 11:14:13', '2024-06-03 12:22:40'), (11, 'Colombo – The Vibrant Heart of Sri Lanka', '1717415892.jpg', '
Colombo, the bustling capital of Sri Lanka, is a vibrant city that seamlessly blends modern urban life with rich historical heritage. As the largest city and the commercial hub of the island, Colombo is a melting pot of cultures, cuisines, and traditions. This dynamic metropolis offers a diverse range of experiences, from its bustling markets and colonial architecture to its serene beaches and upscale shopping districts. Whether you’re a history buff, a foodie, or a shopaholic, Colombo promises an exciting and unforgettable journey.
Colombo\'s history dates back over 2,000 years, with its natural harbor attracting traders from around the world. The city has been influenced by various cultures and empires, including the Portuguese, Dutch, and British, each leaving its mark on Colombo\'s architecture, culture, and urban landscape. Today, Colombo stands as a testament to this rich and diverse heritage, with its colonial buildings, historic temples, and modern skyscrapers coexisting harmoniously.
1. Galle Face Green:
2. Colombo Fort and Pettah:
3. Gangaramaya Temple:
4. Viharamahadevi Park:
5. National Museum of Colombo:
1. Colombo City Centre:
2. Independence Square:
3. Beira Lake:
', '2024-06-03 11:58:12', '2024-06-03 12:29:03'), (15, 'Sigiriya – The Majestic Lion Rock', '1717567168.webp', '
Introduction
Sigiriya, also known as Lion Rock, is an ancient rock fortress located in the central Matale District of Sri Lanka. This UNESCO World Heritage Site is renowned for its stunning natural beauty, historical significance, and architectural marvels. Rising 200 meters above the surrounding plain, Sigiriya is a testament to the ingenuity and creativity of ancient Sri Lankan civilization. Join us as we explore the history, architecture, and cultural significance of this iconic rock fortress.
Historical Background
Sigiriya\'s history dates back to the 5th century AD when it was chosen by King Kashyapa as the site for his new capital. The king built a magnificent palace atop the rock and adorned its sides with colorful frescoes. However, Sigiriya served as a royal residence for only a brief period, as Kashyapa was defeated and killed by his brother, who later moved the capital to Anuradhapura. Over the centuries, Sigiriya was used as a monastery and later fell into disrepair. It was rediscovered in the 19th century and has since been a popular tourist destination.
Architectural Marvels
1. The Lion\'s Gate:
The entrance to Sigiriya is through the Lion\'s Gate, named for the lion statue that once flanked the entrance. Today, only the massive lion paws remain, but they offer a glimpse into the grandeur of the original structur
2. The Mirror Wall:
As you ascend the rock, you\'ll encounter the Mirror Wall, a polished wall that once reflected the frescoes painted on it. The wall is covered with ancient graffiti and poems left by visitors over the centuries.
3. The Frescoes:
One of the most famous features of Sigiriya is the gallery of frescoes located halfway up the rock. These colorful paintings, known as the Sigiriya Damsels, depict celestial maidens and are considered masterpieces of ancient art.
4. The Summit:
At the summit of Sigiriya, you\'ll find the remains of the ancient palace complex, including foundations, cisterns, and gardens. The summit offers panoramic views of the surrounding countryside and is a testament to the engineering prowess of ancient Sri Lankans.
Cultural Significance
Sigiriya is not just a historical site but also a cultural icon that holds immense significance for the people of Sri Lanka. It is a symbol of ancient Sri Lankan civilization and a reminder of the island\'s rich cultural heritage. The rock fortress is also a source of pride for Sri Lankans, who view it as a testament to their ancestors\' ingenuity and creativity.
', '2024-06-05 05:59:28', '2024-06-05 05:59:28'); -- -------------------------------------------------------- -- -- Table structure for table `bookings` -- CREATE TABLE `bookings` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `package_id` bigint(20) UNSIGNED NOT NULL, `date` date NOT NULL, `number_of_adult` int(11) NOT NULL, `number_of_child` int(11) NOT NULL, `pick_up_location` varchar(255) NOT NULL, `pick_up_location_details` longtext NOT NULL, `total_fee` decimal(8,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `reservation_status` varchar(255) NOT NULL DEFAULT 'pending', `invoice_status` varchar(255) NOT NULL DEFAULT 'pending', `payment_status` varchar(255) NOT NULL DEFAULT 'pending', `payment_receipt` longtext DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `bookings` -- INSERT INTO `bookings` (`id`, `user_id`, `package_id`, `date`, `number_of_adult`, `number_of_child`, `pick_up_location`, `pick_up_location_details`, `total_fee`, `created_at`, `updated_at`, `reservation_status`, `invoice_status`, `payment_status`, `payment_receipt`) VALUES (1, 20, 32, '2024-06-13', 1, 2, 'From Airport', 'i am from airport', 1400.00, '2024-06-02 06:16:27', '2024-06-03 13:09:30', 'Conform', 'pending', 'Success', '1717420170.jpg'), (2, 20, 32, '2024-06-10', 2, 1, 'From Hotel', 'I am in now, \r\nSerendib Road, Bentota, Sri Lanka.', 1150.00, '2024-06-03 07:48:39', '2024-06-16 02:55:27', 'Reject', 'pending', 'Success', '1718506527.jpg'), (3, 10, 37, '2024-07-12', 2, 2, 'From Airport', 'I am arriving at Colombo airport.', 2000.00, '2024-06-04 11:04:42', '2024-06-04 11:04:42', 'pending', 'pending', 'pending', NULL), (4, 9, 32, '2024-06-24', 1, 2, 'From Hotel', 'We are at the Grand Hotel in colombo', 1000.00, '2024-06-04 13:17:06', '2024-06-04 13:17:06', 'pending', 'pending', 'pending', NULL), (5, 9, 32, '2024-06-19', 2, 3, 'From Hotel', 'we are in shragila hotel in colombo', 1450.00, '2024-06-04 13:23:46', '2024-06-04 18:49:45', 'Conform', 'pending', 'Success', '1717507459.jpg'), (6, 10, 40, '2024-06-27', 4, 1, 'From Airport', 'from colombo', 1500.00, '2024-06-04 23:55:49', '2024-06-04 23:56:22', 'pending', 'pending', 'Success', '1717545382.jpg'), (7, 2, 36, '2024-06-30', 2, 1, 'From Hotel', 'we are stay in nisal hotel in colombo', 875.00, '2024-06-05 04:09:00', '2024-06-05 04:09:00', 'pending', 'pending', 'pending', NULL), (8, 2, 32, '2024-06-13', 2, 1, 'From Hotel', 'we staing in hotel', 1150.00, '2024-06-05 05:45:48', '2024-06-16 01:17:35', 'Conform', 'pending', 'Success', '1717566405.jpg'), (9, 2, 43, '2024-06-08', 2, 2, 'From Hotel', 'details', 680.00, '2024-06-16 02:57:44', '2024-06-16 02:57:44', 'pending', 'pending', 'pending', NULL); -- -------------------------------------------------------- -- -- Table structure for table `cache` -- CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache_locks` -- CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) 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 `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) UNSIGNED NOT NULL, `reserved_at` int(10) UNSIGNED DEFAULT NULL, `available_at` int(10) UNSIGNED NOT NULL, `created_at` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `job_batches` -- CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) 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 (7, '0001_01_01_000000_create_users_table', 1), (8, '0001_01_01_000001_create_cache_table', 1), (9, '0001_01_01_000002_create_jobs_table', 1), (10, '2024_05_12_233738_create_blogs_table', 2), (11, '2024_05_19_050444_create_travel_packages_table', 2), (13, '2024_05_21_224023_create_user_reviews_table', 4), (14, '2024_05_21_224447_create_user_massages_table', 4), (18, '2024_05_29_232537_create_service_for_travel_packages_table', 6), (19, '2024_05_21_034429_create_bookings_table', 7); -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `service_for_travel_packages` -- CREATE TABLE `service_for_travel_packages` ( `id` bigint(20) UNSIGNED NOT NULL, `includeOrExclude` varchar(255) NOT NULL, `service` varchar(255) DEFAULT NULL, `price` decimal(8,2) 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 `sessions` -- CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sessions` -- INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('KWwNtsZTEkBm9XH4TZIl04mDKTtnUijSADq6108b', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 OPR/110.0.0.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieklqMExzMFVoQm5XSTdIWEUxcjBoeXhQdkRIVENpdnI3S3dWYXZubCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fX0=', 1718506995), ('S8jAsPlEb3M2JunE5Mlly4rbgBZeX1jjOpRUtIcb', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 OPR/110.0.0.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaXVBSEluQWtyR1Nza1VGS2JVUjBNNUFTRDRRVUliWTgwZmN5YlczbSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1718518453); -- -------------------------------------------------------- -- -- Table structure for table `travel_packages` -- CREATE TABLE `travel_packages` ( `id` bigint(20) UNSIGNED NOT NULL, `package_name` varchar(255) NOT NULL, `image_1` varchar(255) DEFAULT NULL, `image_2` varchar(255) DEFAULT NULL, `image_3` varchar(255) DEFAULT NULL, `duration` varchar(255) NOT NULL, `tour_type` varchar(255) NOT NULL, `price_start_from` decimal(10,2) NOT NULL, `overview` longtext NOT NULL, `included_things` longtext NOT NULL, `Excludes_things` varchar(255) DEFAULT NULL, `tour_plane_description` longtext NOT NULL, `per_adult_fee` decimal(10,2) NOT NULL DEFAULT 200.00, `per_child_fee` decimal(10,2) NOT NULL DEFAULT 100.00, `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 `travel_packages` -- INSERT INTO `travel_packages` (`id`, `package_name`, `image_1`, `image_2`, `image_3`, `duration`, `tour_type`, `price_start_from`, `overview`, `included_things`, `Excludes_things`, `tour_plane_description`, `per_adult_fee`, `per_child_fee`, `created_at`, `updated_at`) VALUES (32, 'Sun-Kissed Shores Beach Journey', '1717397825_img1_665d69417e6046.85887790.jpg', '1717397825_img2_665d694190b5d0.09417408.webp', '1717397825_img3_665d69419eeef4.51854972.jfif', '3', 'Beach Holiday Tour', 400.00, 'Discover the serene beauty of Sri Lanka’s stunning coastline with our exclusive 3-day beach escape, Serenity Shores. This carefully curated package is perfect for those looking to relax, rejuvenate, and immerse themselves in the natural splendor and cultural richness of Sri Lanka’s coastal regions. Begin your journey with a warm welcome at Colombo Airport, followed by a scenic drive to the tranquil beaches of Bentota. Here, you\'ll unwind on golden sands, bask in the tropical sun, and explore the serene Bentota River through an enchanting river safari.\r\n\r\nThroughout the tour, enjoy the comfort of beachfront accommodations, daily breakfasts, private transportation, and the guidance of our knowledgeable English-speaking guides. Whether you’re a sun seeker, a history enthusiast, or a lover of local cuisine, Serenity Shores promises a delightful blend of relaxation, adventure, and cultural exploration, making it the perfect getaway for individuals, couples, and families alike.', '
☑ Accommodation in beachfront hotels
☑ Daily breakfast
☑ Airport transfers
☑ Private transportation during the tour
☑ English-speaking guide
☑ Entrance fees to specified attractions
', 'aaaaa
', '
☑ Accommodation in beachfront hotels
☑ Daily breakfast
☑ Airport transfers
☑ Private transportation during the tour
☑ English-speaking guide
☑ Entrance fees to specified attractions
', NULL, 'Evening at Leisure: Explore local eateries or relax on the beach.
Return to Colombo: Depart from Hikkaduwa and transfer to Colombo.
☑ Accommodation in comfortable hotels and eco-lodges
☑ Daily breakfast, lunch, and dinner
☑ Airport transfers and transportation during the tour
☑ Experienced English-speaking guide
☑ Entrance fees to specified attractions
☑ All activities mentioned in the itinerary
', NULL, '
☑ Accommodation in premium business hotels
☑ Daily breakfast
☑ Airport transfers and transportation during the tour
☑ High-speed Wi-Fi access
☑ Conference room facilities
☑ English-speaking assistant
☑ Entrance fees to specified attractions
☑ Business center access
', NULL, '
☑ Accommodation in comfortable hotels
☑ Daily breakfast
☑ Airport transfers and transportation during the tour
☑ Experienced English-speaking guide
☑ Entrance fees to specified attractions
', NULL, 'Arrival at Colombo Airport: Meet your guide and transfer to Kandy.
Visit to Pinnawala Elephant Orphanage: Witness the daily routines of rescued elephants.
Transfer to Kandy: Continue your journey to the cultural capital of Sri Lanka.
Check-in at Hotel: Relax and prepare for the evening activities.
Evening Visit to Temple of the Sacred Tooth Relic: Explore one of Buddhism\'s most sacred sites.
Cultural Dance Show: Enjoy a traditional Kandyan dance performance.
Overnight Stay: Comfortable hotel in Kandy.
Start your day with a hearty breakfast.
Peradeniya Botanical Gardens: Stroll through the beautifully manicured gardens.
Transfer to Colombo: Head back to the bustling capital.
Colombo City Tour: Visit key landmarks such as Gangaramaya Temple, Independence Square, and the National Museum.
Shopping and Leisure Time: Explore local markets and buy souvenirs.
Departure: Transfer to Colombo Airport for your onward journey.
', 150.00, 100.00, '2024-06-05 05:58:07', '2024-06-05 05:58:30'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `phone_number` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `user_country` varchar(255) NOT NULL, `role` enum('admin','user') NOT NULL DEFAULT 'user', `remember_token` varchar(100) 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 `users` -- INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `phone_number`, `password`, `user_country`, `role`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Admin', 'dilankanishka032@gmail.com', NULL, '', '$2y$12$vTjqexr.C3S3hZalCtZMCepJrMMPjDZvO81DlKvXX5FAlAV212X0q', 'sri lanka', 'admin', NULL, NULL, NULL), (2, 'nishal', 'dilankanishka2104@gmail.com', NULL, '0778865442', '$2y$12$goDn30aI3Ye2AM8wjRpPGedIRaooGyW9baa/WBmwaOwuP6Z.OakE.', 'japan', 'user', NULL, NULL, '2024-06-05 04:52:13'), (4, 'Joesph ', 'christop60@example.net', '2024-04-18 05:16:19', '', '$2y$12$cRv6UT9FhMLQX8b9YAgftOU9qO0hAOx.WvEPdO0StGBvzKbTi5p7.', 'Thailand', 'user', 'OLgLYlAkWK', '2024-04-18 05:16:19', '2024-04-18 05:16:19'), (5, 'Allan Luettgen', 'ethan.little@example.org', '2024-04-18 05:16:19', '', '$2y$12$cRv6UT9FhMLQX8b9YAgftOU9qO0hAOx.WvEPdO0StGBvzKbTi5p7.', 'Namibia', 'user', 'T1IYKR3eob', '2024-04-18 05:16:19', '2024-04-18 05:16:19'), (6, 'Mozell Mohr', 'sigrid50@example.com', '2024-04-18 05:16:19', '', '$2y$12$cRv6UT9FhMLQX8b9YAgftOU9qO0hAOx.WvEPdO0StGBvzKbTi5p7.', 'Sudan', 'user', '8Ef93Wwg6J', '2024-04-18 05:16:19', '2024-04-18 05:16:19'), (7, 'Bernard Crooks', 'lisa.gleichner@example.org', '2024-04-18 05:16:19', '', '$2y$12$cRv6UT9FhMLQX8b9YAgftOU9qO0hAOx.WvEPdO0StGBvzKbTi5p7.', 'Paraguay', 'user', '55We6ErNSc', '2024-04-18 05:16:19', '2024-04-18 05:16:19'), (8, 'Test User', 'test@example.com', '2024-04-18 05:16:19', '', '$2y$12$cRv6UT9FhMLQX8b9YAgftOU9qO0hAOx.WvEPdO0StGBvzKbTi5p7.', 'British Virgin Islands', 'user', '7IF1J2FFIV', '2024-04-18 05:16:19', '2024-04-18 05:16:19'), (9, 'sirimal', 'sirimal@gmail.com', NULL, '', '$2y$12$7J4ZNlkmbmvqmaMoLSa7POyzlukNmNZUb5FvspZGgXzn8DgFQ3wc.', 'japan', 'user', NULL, '2024-04-19 14:16:50', '2024-04-19 14:16:50'), (10, 'kanishka', 'kanishka@gmail.com', NULL, '0779966434', '$2y$12$GqEJKxL1Dd6iB49TvdrLRea2C7/G7iKRzwntfByw4XCicZ3VVlkbq', 'America', 'user', NULL, '2024-05-06 00:17:20', '2024-05-06 20:43:20'), (11, 'sivanthi', 'sivanthi@gmail.com', NULL, '0725489631', '$2y$12$tY.CuYT5W7KgrhJIKEVONOAWxoXABzmoOVjg3bxE6EHSuwT3sXpDK', 'sri lanka', 'user', NULL, '2024-05-06 00:32:30', '2024-05-06 00:32:30'), (12, 'vishwa', 'vishwa@gmail.com', NULL, '0789631578', '$2y$12$AZdRgqv1T5osIJf3/vSvHOr3pypaSTgMexixOF3e..h0SIlihDFMi', 'china', 'user', NULL, '2024-05-06 00:33:31', '2024-05-06 00:33:31'), (13, 'sirinimala', 'sirinimala@gmail.com', NULL, '0786541239', '$2y$12$d99estYlkDu.wX79Yo/kEemeWxBpMHLot5XvOfY3i9NA4ncubIY.q', 'japan', 'user', NULL, '2024-05-06 00:39:21', '2024-05-06 08:39:35'), (14, 'amali', 'amali@gmail.com', NULL, '0778523647', '$2y$12$BrxaDQqkzfalH32OURdrAuixOEE4UyCYYsplf96zKzTv9zUwLKZZS', 'japan', 'user', NULL, '2024-05-06 20:59:33', '2024-05-06 20:59:33'), (15, 'surith', 'surith@gmail.com', NULL, '0786452897', '$2y$12$KoeYQE0LRvu8cHQGk0WKFOLg8LHKZSTLp8a5n/ogLt6lyw.JFzLZi', 'london', 'user', NULL, '2024-05-07 10:00:45', '2024-05-07 10:00:45'), (16, 'avantha', 'avantha@gmail.com', NULL, '0798546322', '$2y$12$wAJqcl/xNxo4hoNOb41AIu9.xUG/xODXqT2ipZuKSM72XTFonS4R6', 'sri lanka', 'user', NULL, '2024-05-07 18:48:26', '2024-05-07 18:49:25'), (17, 'supun', 'supun@gmail.com', NULL, '0784569874', '$2y$12$Pdku0H.Sz9QWHRNKY/KoP.LgtNbAulvvmRVoRHliiekX7Z5FTJApK', 'japan', 'user', NULL, '2024-05-07 22:26:47', '2024-05-07 22:26:47'), (20, 'Dilan', 'dilannow@gmail.com', NULL, '0776644853', '$2y$12$foefw/Ae4vAgf83VgwwkAuw/i9cd2HQx66vgTaOr0Wgr65yT7yug2', 'Sri lanka', 'user', NULL, '2024-05-23 21:53:39', '2024-06-16 02:55:04'); -- -------------------------------------------------------- -- -- Table structure for table `user_massages` -- CREATE TABLE `user_massages` ( `id` bigint(20) UNSIGNED NOT NULL, `user_name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `subject` varchar(255) NOT NULL, `discription` varchar(255) 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 `user_massages` -- INSERT INTO `user_massages` (`id`, `user_name`, `email`, `subject`, `discription`, `created_at`, `updated_at`) VALUES (19, 'Nimal Shantha', 'nimalshantha67@gmail.com', 'Inquiry about Family Package', 'Hi, I would like to know more about the family package for this summer. Can you provide details on the pricing and itinerary?', '2024-05-23 17:19:40', '2024-05-23 17:19:40'), (20, 'Amarasinhge athapaththu', 'amarasinhge99@gmail.com', 'Payment Issue', 'I encountered an issue while trying to make a payment for the Thailand Adventure package. Please assist.', '2024-05-23 17:27:21', '2024-05-23 17:27:21'); -- -------------------------------------------------------- -- -- Table structure for table `user_reviews` -- CREATE TABLE `user_reviews` ( `id` bigint(20) UNSIGNED NOT NULL, `user_name` varchar(255) DEFAULT NULL, `user_counrty` varchar(255) DEFAULT NULL, `user_discription` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `blogs` -- ALTER TABLE `blogs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bookings` -- ALTER TABLE `bookings` ADD PRIMARY KEY (`id`), ADD KEY `bookings_user_id_foreign` (`user_id`), ADD KEY `bookings_package_id_foreign` (`package_id`); -- -- Indexes for table `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`); -- -- Indexes for table `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`), ADD KEY `jobs_queue_index` (`queue`); -- -- Indexes for table `job_batches` -- ALTER TABLE `job_batches` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `service_for_travel_packages` -- ALTER TABLE `service_for_travel_packages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sessions` -- ALTER TABLE `sessions` ADD PRIMARY KEY (`id`), ADD KEY `sessions_user_id_index` (`user_id`), ADD KEY `sessions_last_activity_index` (`last_activity`); -- -- Indexes for table `travel_packages` -- ALTER TABLE `travel_packages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- Indexes for table `user_massages` -- ALTER TABLE `user_massages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_reviews` -- ALTER TABLE `user_reviews` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `blogs` -- ALTER TABLE `blogs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `bookings` -- ALTER TABLE `bookings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `jobs` -- ALTER TABLE `jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `service_for_travel_packages` -- ALTER TABLE `service_for_travel_packages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `travel_packages` -- ALTER TABLE `travel_packages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `user_massages` -- ALTER TABLE `user_massages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `user_reviews` -- ALTER TABLE `user_reviews` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Constraints for dumped tables -- -- -- Constraints for table `bookings` -- ALTER TABLE `bookings` ADD CONSTRAINT `bookings_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `travel_packages` (`id`), ADD CONSTRAINT `bookings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`); COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;