-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Mar 25, 2025 at 11:47 AM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `heritage%20conversation` -- -- -------------------------------------------------------- -- -- Table structure for table `about_us` -- CREATE TABLE `about_us` ( `id` bigint(20) UNSIGNED NOT NULL, `hero_image1` varchar(255) DEFAULT NULL, `hero_image2` varchar(255) DEFAULT NULL, `hero_title` varchar(255) DEFAULT NULL, `hero_text` longtext DEFAULT NULL, `our_history` longtext DEFAULT NULL, `dg_image` varchar(255) DEFAULT NULL, `dg_name` varchar(255) DEFAULT NULL, `mission_vision` longtext 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 `about_us` -- INSERT INTO `about_us` (`id`, `hero_image1`, `hero_image2`, `hero_title`, `hero_text`, `our_history`, `dg_image`, `dg_name`, `mission_vision`, `created_at`, `updated_at`) VALUES (1, 'about_images/1742443556_sixty1.jpg', 'about_images/1742383280_sixty_thumb.jpg', 'One of the government agency In Bangladesh', 'What can I do to help prevent looting? BLM law enforcement rangers and special agents and the San Juan County Sheriff’s Office in Utah understand the importance of these artifacts. They are working hard to protect them, but they need your help: • If you observe someone that you suspect is looting, stay away from that person! They may be armed. As soon as it is safe to do so, call the San Juan County Sheriff’s Office at 435-587-2237. • If you find an archaeological site that you suspect was looted, immediately call the BLM resource protection hotline in Utah at 435-587-2237.', 'What can I do to help prevent looting? BLM law enforcement rangers and special agents and the San Juan County Sheriff’s Office in Utah understand the importance of these artifacts. They are working hard to protect them, but they need your help: • If you observe someone that you suspect is looting, stay away from that person! They may be armed. As soon as it is safe to do so, call the San Juan County Sheriff’s Office at 435-587-2237. • If you find an archaeological site that you suspect was looted, immediately call the BLM resource protection hotline in Utah at 435-587-2237.', 'about_images/1742383280_sixty1.jpg', 'Mrs. Sabina Alam', 'What can I do to help prevent looting?\r\nBLM law enforcement rangers and special agents and the\r\nSan Juan County Sheriff’s Office in Utah understand the\r\nimportance of these artifacts. They are working hard to\r\nprotect them, but they need your help:\r\n• If you observe someone that you suspect is looting, stay\r\naway from that person! They may be armed. As soon as it\r\nis safe to do so, call the San Juan County Sheriff’s Office at\r\n435-587-2237.\r\n• If you find an archaeological site that you suspect was\r\nlooted, immediately call the BLM resource protection\r\nhotline in Utah at 435-587-2237.', '2025-03-19 05:21:20', '2025-03-19 22:05:57'); -- -------------------------------------------------------- -- -- Table structure for table `archeological_sites` -- CREATE TABLE `archeological_sites` ( `id` bigint(20) UNSIGNED NOT NULL, `site_name_en` text NOT NULL, `site_name_bn` text NOT NULL, `district_id` bigint(20) UNSIGNED NOT NULL, `thana_id` bigint(20) UNSIGNED NOT NULL, `thumbnail` varchar(255) DEFAULT NULL, `banner` varchar(255) DEFAULT NULL, `active` tinyint(1) 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 `archeological_sites` -- INSERT INTO `archeological_sites` (`id`, `site_name_en`, `site_name_bn`, `district_id`, `thana_id`, `thumbnail`, `banner`, `active`, `created_at`, `updated_at`) VALUES (1, 'Sixty Dome Mosque', 'ষাটগম্বুজ মসজিদ', 3, 4, 'thumbnail/1742794333_111111.jpg', 'banner/1742794333_111111.jpg', 1, '2025-03-18 00:24:54', '2025-03-23 23:32:13'), (2, 'Shilaidaha Rabindra Kuthibari', 'শিলাইদাহ রবীন্দ্র কুঠিবাড়ি', 3, 4, 'thumbnail/1742380212_WhatsApp Image 2025-03-09 at 09.26.56_34232e25.jpg', 'banner/1742380212_WhatsApp Image 2025-03-09 at 09.12.17_7aab27d2.jpg', 1, '2025-03-18 04:01:35', '2025-03-23 23:35:16'); -- -------------------------------------------------------- -- -- 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 `contacts` -- CREATE TABLE `contacts` ( `id` bigint(20) UNSIGNED NOT NULL, `contact_image` varchar(255) NOT NULL, `office_time` text NOT NULL, `office_location_url` text 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 `contacts` -- INSERT INTO `contacts` (`id`, `contact_image`, `office_time`, `office_location_url`, `created_at`, `updated_at`) VALUES (1, 'contact_images/1742730565_111111.jpg', 'Sun to Thurs 9am to 5pm', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d4304.605327408832!2d89.73925051147637!3d22.674502279333467!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x39fff4565f03d17d%3A0x657f7377a89d5da7!2z4Ka34Ka-4KafIOCml-CmruCnjeCmrOCngeCmnCDgpq7gprjgppzgpr_gpqY!5e1!3m2!1sbn!2sbd!4v1742728395377!5m2!1sbn!2sbd', '2025-03-22 01:19:05', '2025-03-23 05:49:25'); -- -------------------------------------------------------- -- -- Table structure for table `districts` -- CREATE TABLE `districts` ( `id` bigint(20) UNSIGNED NOT NULL, `name` 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 `districts` -- INSERT INTO `districts` (`id`, `name`, `created_at`, `updated_at`) VALUES (1, 'Khulna', '2025-03-17 23:59:55', '2025-03-17 23:59:55'), (2, 'Bagerhat', '2025-03-18 00:00:03', '2025-03-18 00:00:03'), (3, 'Kushtia', '2025-03-18 00:00:24', '2025-03-18 00:00:24'), (4, 'Barishal', '2025-03-23 02:05:25', '2025-03-23 07:51:04'), (7, 'new', '2025-03-23 08:49:47', '2025-03-23 08:49:47'), (8, 'test1', '2025-03-23 08:53:54', '2025-03-23 10:27:27'); -- -------------------------------------------------------- -- -- 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 `messages` -- CREATE TABLE `messages` ( `id` bigint(20) UNSIGNED NOT NULL, `message` text NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `subject` 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 `messages` -- INSERT INTO `messages` (`id`, `message`, `name`, `email`, `subject`, `created_at`, `updated_at`) VALUES (1, 'asdada asdadad', 'MD AHSAN HABIB', 'user@gmail.com', 'Archeological site', '2025-03-22 03:29:37', '2025-03-22 03:29:37'), (2, 'What are the attracted places in Khulna?', 'Abdur Rahim', 'abdur@gmail.com', 'Subject', '2025-03-22 04:30:28', '2025-03-22 04:30:28'); -- -------------------------------------------------------- -- -- 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 (1, '0001_01_01_000000_create_users_table', 1), (2, '0001_01_01_000001_create_cache_table', 1), (3, '0001_01_01_000002_create_jobs_table', 1), (4, '2025_03_08_054714_create_districts_table', 1), (5, '2025_03_08_055101_create_thanas_table', 1), (6, '2025_03_08_070256_create_archeological_sites_table', 1), (7, '2025_03_08_132952_create_site_descriptions_table', 1), (8, '2025_03_08_151425_create_site_maintenances_table', 1), (9, '2025_03_10_063041_create_site_media_table', 1), (10, '2025_03_19_064305_create_site_settings_table', 2), (11, '2025_03_19_095423_create_about_us_table', 3), (12, '2025_03_22_062641_create_contacts_table', 4), (13, '2025_03_22_080217_create_messages_table', 5); -- -------------------------------------------------------- -- -- 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 `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 ('SPaTKkm97Dvcl3wGUEHlVt8giQ8RlqJeVO4LV4OR', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiTURQQ2Y3ck45U0pSY1YwZ1F4bTF1c1RHOE9MbFEzUGM0UzRWVkV4USI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi9pbWFnZXMiO31zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=', 1742899519); -- -------------------------------------------------------- -- -- Table structure for table `site_descriptions` -- CREATE TABLE `site_descriptions` ( `id` bigint(20) UNSIGNED NOT NULL, `site_id` bigint(20) UNSIGNED NOT NULL, `site_description` longtext DEFAULT NULL, `current_condition` int(11) DEFAULT NULL, `immediate_problem` longtext DEFAULT NULL, `urgent_problem` longtext DEFAULT NULL, `threats` longtext DEFAULT NULL, `integrity` longtext DEFAULT NULL, `value` longtext DEFAULT NULL, `priorities` longtext DEFAULT NULL, `ownership` longtext DEFAULT NULL, `map_url` text DEFAULT NULL, `history` longtext DEFAULT NULL, `physical_integrity` longtext DEFAULT NULL, `structural_integrity` longtext DEFAULT NULL, `physical_features` longtext DEFAULT NULL, `historic_fabric` longtext DEFAULT NULL, `authentic_design` longtext DEFAULT NULL, `authentic_setting` longtext DEFAULT NULL, `authentic_material` longtext DEFAULT NULL, `demographic_growth` longtext 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 `site_descriptions` -- INSERT INTO `site_descriptions` (`id`, `site_id`, `site_description`, `current_condition`, `immediate_problem`, `urgent_problem`, `threats`, `integrity`, `value`, `priorities`, `ownership`, `map_url`, `history`, `physical_integrity`, `structural_integrity`, `physical_features`, `historic_fabric`, `authentic_design`, `authentic_setting`, `authentic_material`, `demographic_growth`, `created_at`, `updated_at`) VALUES (1, 1, '

description Enclosed originally by an outer wall, the mosque is located on the eastern bank of the Ghoradighi, about three miles west of the present Bagerhat town.

Shatgumbad Mosque plan

The enclosed compound was originally entered through two gateways - one in the east, now restored and repaired, and the other in the north, no longer extant. The eastern gateway, facing cardinally the central archway of the mosque proper, appears to be a monument by itself. It measures 7.92m by 2.44m and consists of an archway having a span of about 2.44m with a beautiful curvature on top.

', 1, 'Current condition is in danger', 'Current condition is in danger', 'Current condition is in danger', 'The Shatgumbad Mosque at Bagerhat appears to have been the earliest as well as the greatest architectural work of Khan Jahan. From outside, the mosque, with its four heavy and attractive corner towers and seventy-seven domes over the roof, offers a wonderful spectacle to the eye, while its interior is imposing. Architecturally the mosque shows the continuity of the building style that had already been started in Bengal and also some new developments taking inspiration both from the region and from outside. Its bastion-like tapering corner towers with their rounded cupolas and two-storied conception, which rises high above the roof, appears to have been dictated by similar Tughlaqian examples of the Khirki (c 1375) and the Kalan Mosques (1380) at Delhi. The circular shape of these corner towers is worth noting as it distinguishes the Khan Jahani group of monuments from other buildings of Khalifatabad.', 'Historical Site (Muslim history)', 'Very High', 'Bangladesh Government', 'https://www.google.com/maps/place/Sixty+Dome+Mosque/@22.6745023,89.7418308,706m/data=!3m2!1e3!4b1!4m6!3m5!1s0x39fff4565f03d17d:0x657f7377a89d5da7!8m2!3d22.6745023!4d89.7418308!16zL20vMDhjeTVk?entry=ttu&g_ep=EgoyMDI1MDMwNC4wIKXMDSoASAFQAw%3D%3D', 'Literally the term \'Shatgumbad\' means sixty domes, but in reality the mosque has eighty-one domes in total - seventy-seven over the roof and four smaller ones over the four corner towers. Two suggestions may be made in this regard. Firstly, the seven chau-chala vaults over the central nave might have given the building the name of Satgumbad (Sat = seven and gumbad means dome), which in course of time has possibly been transformed into Shatgumbad. Secondly, the sixty pillars, which support the huge domed-roof above, might also have originally given the mosque the name of \'Shat Khumbaz\' (shat means sixty and khumbaz means pillar). It is not unlikely that the word Khumbaz has subsequently been corrupted into gumbad to give the building the popular name of \'Shatgumbad\'. Of the two suggestions the latter seems to be more probable. [MA Bari]', 'An important feature of the mosque, though unusual in Bengal but noticed in many congregational mosques in northern India, is a small doorway in the back wall beside the central mihrab, the idea of which might have originally been borrowed from those of early mosques in Islam. In early Islam the postern opening of the mosque is known to have been used exclusively by the caliphs, governors or imams. It is therefore not unlikely that the western doorway of the Shatgumbad Mosque was reserved for Khan Jahan, the governor of Khalifatabad, who had his residence a few yards away to the north of the mosque. Of the two brick platforms, already cited, the one near the central mihrab was perhaps used by Khan Jahan while transacting administrative business, and the other near an eastern doorway was perhaps meant for a religious teacher, who sat on it and expounded Islamic teachings to the people or students. The Shatgumbad Mosque therefore appears to have served triple purposes - a congregational mosque, a parliament or assembly hall like those of early Islam and a madrasa like the Isfahan Jami and the Masjid-i-Jami at Ardistan in Persia.', 'An important feature of the mosque, though unusual in Bengal but noticed in many congregational mosques in northern India, is a small doorway in the back wall beside the central mihrab, the idea of which might have originally been borrowed from those of early mosques in Islam. In early Islam the postern opening of the mosque is known to have been used exclusively by the caliphs, governors or imams. It is therefore not unlikely that the western doorway of the Shatgumbad Mosque was reserved for Khan Jahan, the governor of Khalifatabad, who had his residence a few yards away to the north of the mosque. Of the two brick platforms, already cited, the one near the central mihrab was perhaps used by Khan Jahan while transacting administrative business, and the other near an eastern doorway was perhaps meant for a religious teacher, who sat on it and expounded Islamic teachings to the people or students. The Shatgumbad Mosque therefore appears to have served triple purposes - a congregational mosque, a parliament or assembly hall like those of early Islam and a madrasa like the Isfahan Jami and the Masjid-i-Jami at Ardistan in Persia.', 'The mosque proper, built mainly of bricks, forms a vast rectangle and measures externally, inclusive of the massive two-storied towers on the angles, 48.77m from north to south and 32.92m from east to west. The interior of the mosque could be entered through arched doorways - eleven on the east, seven on each of the north and south walls and only one on the west wall, which is placed at the western end of the bay immediately to the north of the large central nave. The interior of the mosque, 43.89m by 26.82m, is divided by six rows of pillars into seven longitudinal aisles from north to south and eleven bays running east to west. Each of the eleven bays, excepting that immediately to the north of the central one, ends with a semi-circular mihrab niche at the qibla wall. The mosque has therefore a total of ten mihrabs. The central mihrab, which corresponds to the central nave, is bigger than its flanking counterparts and shows a rectangular projection on the outer side, carried up to roof level.', 'Literally the term \'Shatgumbad\' means sixty domes, but in reality the mosque has eighty-one domes in total - seventy-seven over the roof and four smaller ones over the four corner towers. Two suggestions may be made in this regard. Firstly, the seven chau-chala vaults over the central nave might have given the building the name of Satgumbad (Sat = seven and gumbad means dome), which in course of time has possibly been transformed into Shatgumbad. Secondly, the sixty pillars, which support the huge domed-roof above, might also have originally given the mosque the name of \'Shat Khumbaz\' (shat means sixty and khumbaz means pillar). It is not unlikely that the word Khumbaz has subsequently been corrupted into gumbad to give the building the popular name of \'Shatgumbad\'. Of the two suggestions the latter seems to be more probable. [MA Bari]', 'The most attractive part of the mosque is its large central nave, running east to west in a longitudinal line. This nave, consisting of seven independent oblong bays about 4.88m x 3.96m each, divides the interior of the mosque into two equal wings and opens out to north and south by pointed archways. The side wings are divided into square bays, numbering seventy in total. The square bays of the side wings, each measuring 3.96m on each side, are covered with inverted cup-shaped domes, while the oblong bays of the central nave are roofed over with chau-chala vaults. These vaults and cup-shaped domes are carried on intersecting arches springing from the pillars, and the corners between the arches are filled with characteristic Bengali pendentives. The building thus exhibits eighty-one domes in total - four on the corner towers, seventy over the side wings and seven chau-chala vaults over the central nave.', 'The huge multi-domed roof of the building has been supported by ten rows of pillars, six in each row, running from east to west. The mosque has therefore a total of sixty pillars, the majority of whom were of slender stone, while six were massive, encased either with bricks or sized stone blocks and appear to be original. All the stone pillars, formed of two or three stone pieces one above the other and tightly joined together by a system of plug-holes and iron-craps, must also have been originally massive, with brick or stone casings. The slender stone pillars, depicting square capitals and pedestals with octagonal shafts, have recently been restored to their original shape by an outer veneer of bricks.', 'The mosque proper, built mainly of bricks, forms a vast rectangle and measures externally, inclusive of the massive two-storied towers on the angles, 48.77m from north to south and 32.92m from east to west. The interior of the mosque could be entered through arched doorways - eleven on the east, seven on each of the north and south walls and only one on the west wall, which is placed at the western end of the bay immediately to the north of the large central nave. The interior of the mosque, 43.89m by 26.82m, is divided by six rows of pillars into seven longitudinal aisles from north to south and eleven bays running east to west. Each of the eleven bays, excepting that immediately to the north of the central one, ends with a semi-circular mihrab niche at the qibla wall. The mosque has therefore a total of ten mihrabs. The central mihrab, which corresponds to the central nave, is bigger than its flanking counterparts and shows a rectangular projection on the outer side, carried up to roof level.', 'Normal', '2025-03-18 00:24:54', '2025-03-23 23:35:46'), (2, 2, 'sdfssssssssssssssssssssssssss', 2, 'asdddddddddddddddddddhhhhhhhhhhhh', '
', 'dfgd', '
', 'sdffffffffffffffffffffffffffffff', '
', '
', 'https://www.google.com/maps/place/Nine+Dome+Mosque/@22.6585021,89.7527755,706m/data=!3m2!1e3!4b1!4m6!3m5!1s0x39fff5b64b42531b:0x9dbe8285cfc39755!8m2!3d22.6584972!4d89.7553504!16s%2Fm%2F0m0mgf8?entry=ttu&g_ep=EgoyMDI1MDMxMi4wIKXMDSoASAFQAw%3D%3D', '
', 'sfdffffffffffffffffffffffffffnnnnnnnnnnnnnnnnnnn', '
', '
', '
', '
', '
', '
', 'ertreeeeeeeeeeeeeeeeeeee', '2025-03-18 04:01:36', '2025-03-19 23:14:20'); -- -------------------------------------------------------- -- -- Table structure for table `site_maintenances` -- CREATE TABLE `site_maintenances` ( `id` bigint(20) UNSIGNED NOT NULL, `site_id` bigint(20) UNSIGNED NOT NULL, `keep_watch` longtext DEFAULT NULL, `monitoring_reporting` varchar(255) DEFAULT NULL, `planning_action` varchar(255) DEFAULT NULL, `technical_assistance` varchar(255) DEFAULT NULL, `budget` longtext DEFAULT NULL, `long_plan` longtext DEFAULT NULL, `medium_plan` longtext DEFAULT NULL, `short_plan` longtext DEFAULT NULL, `financial_plan` longtext DEFAULT NULL, `management_plan` longtext DEFAULT NULL, `maintenance_strategy` longtext DEFAULT NULL, `relevant_doc` varchar(255) DEFAULT NULL, `special_care` longtext DEFAULT NULL, `intervension` longtext DEFAULT NULL, `interpretation` longtext DEFAULT NULL, `preventive_action` longtext DEFAULT NULL, `lack_maintenance` longtext DEFAULT NULL, `disaster_plan` longtext DEFAULT NULL, `initial_survey` varchar(255) DEFAULT NULL, `execution_work` varchar(255) DEFAULT NULL, `annual_plan` varchar(255) DEFAULT NULL, `edu_research` longtext DEFAULT NULL, `tourism` longtext DEFAULT NULL, `typology` longtext DEFAULT NULL, `condition` longtext DEFAULT NULL, `conservation_plan` longtext DEFAULT NULL, `master_plan` longtext DEFAULT NULL, `degree_intervension` longtext DEFAULT NULL, `social_impact` longtext DEFAULT NULL, `over_utilization` longtext 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 `site_maintenances` -- INSERT INTO `site_maintenances` (`id`, `site_id`, `keep_watch`, `monitoring_reporting`, `planning_action`, `technical_assistance`, `budget`, `long_plan`, `medium_plan`, `short_plan`, `financial_plan`, `management_plan`, `maintenance_strategy`, `relevant_doc`, `special_care`, `intervension`, `interpretation`, `preventive_action`, `lack_maintenance`, `disaster_plan`, `initial_survey`, `execution_work`, `annual_plan`, `edu_research`, `tourism`, `typology`, `condition`, `conservation_plan`, `master_plan`, `degree_intervension`, `social_impact`, `over_utilization`, `created_at`, `updated_at`) VALUES (1, 1, 'An important feature of the mosque, though unusual in Bengal but noticed in many congregational mosques in northern India, is a small doorway in the back wall beside the central mihrab, the idea of which might have originally been borrowed from those of early mosques in Islam. In early Islam the postern opening of the mosque is known to have been used exclusively by the caliphs, governors or imams. It is therefore not unlikely that the western doorway of the Shatgumbad Mosque was reserved for Khan Jahan, the governor of Khalifatabad, who had his residence a few yards away to the north of the mosque. Of the two brick platforms, already cited, the one near the central mihrab was perhaps used by Khan Jahan while transacting administrative business, and the other near an eastern doorway was perhaps meant for a religious teacher, who sat on it and expounded Islamic teachings to the people or students. The Shatgumbad Mosque therefore appears to have served triple purposes - a congregational mosque, a parliament or assembly hall like those of early Islam and a madrasa like the Isfahan Jami and the Masjid-i-Jami at Ardistan in Persia.', 'monitoring_reports/monitoring_reporting_1742794827.txt', 'plan_actions/plan_action_1742279094.pdf', 'funds/fund_1742279094.pdf', 'The interior plan of the mosque - a large central nave with the side wings - follows a style noticed for the first time in Bengal in the adina mosque (1375), which in turn might have been derived from other earlier mosques erected in imitation of the Damascus Jami (705-15). The chau-chala vaults over the central nave, hitherto not used in Bengal architecture and noticed subsequently in the chhota sona mosque (1493-1519) and the lattan mosque (early 16th century) at Gaur, appear to have originated from the chau-chala huts of Bengal.', 'The interior plan of the mosque - a large central nave with the side wings - follows a style noticed for the first time in Bengal in the adina mosque (1375), which in turn might have been derived from other earlier mosques erected in imitation of the Damascus Jami (705-15). The chau-chala vaults over the central nave, hitherto not used in Bengal architecture and noticed subsequently in the chhota sona mosque (1493-1519) and the lattan mosque (early 16th century) at Gaur, appear to have originated from the chau-chala huts of Bengal.', 'Updating', 'Updating', 'The interior plan of the mosque - a large central nave with the side wings - follows a style noticed for the first time in Bengal in the adina mosque (1375), which in turn might have been derived from other earlier mosques erected in imitation of the Damascus Jami (705-15). The chau-chala vaults over the central nave, hitherto not used in Bengal architecture and noticed subsequently in the chhota sona mosque (1493-1519) and the lattan mosque (early 16th century) at Gaur, appear to have originated from the chau-chala huts of Bengal.', 'The interior plan of the mosque - a large central nave with the side wings - follows a style noticed for the first time in Bengal in the adina mosque (1375), which in turn might have been derived from other earlier mosques erected in imitation of the Damascus Jami (705-15). The chau-chala vaults over the central nave, hitherto not used in Bengal architecture and noticed subsequently in the chhota sona mosque (1493-1519) and the lattan mosque (early 16th century) at Gaur, appear to have originated from the chau-chala huts of Bengal.', 'The interior plan of the mosque - a large central nave with the side wings - follows a style noticed for the first time in Bengal in the adina mosque (1375), which in turn might have been derived from other earlier mosques erected in imitation of the Damascus Jami (705-15). The chau-chala vaults over the central nave, hitherto not used in Bengal architecture and noticed subsequently in the chhota sona mosque (1493-1519) and the lattan mosque (early 16th century) at Gaur, appear to have originated from the chau-chala huts of Bengal.', 'inventories/inventory_1742279094.pdf', 'The interior plan of the mosque - a large central nave with the side wings - follows a style noticed for the first time in Bengal in the adina mosque (1375), which in turn might have been derived from other earlier mosques erected in imitation of the Damascus Jami (705-15). The chau-chala vaults over the central nave, hitherto not used in Bengal architecture and noticed subsequently in the chhota sona mosque (1493-1519) and the lattan mosque (early 16th century) at Gaur, appear to have originated from the chau-chala huts of Bengal.', 'There are many interventions of the local people', 'The interior plan of the mosque - a large central nave with the side wings - follows a style noticed for the first time in Bengal in the adina mosque (1375), which in turn might have been derived from other earlier mosques erected in imitation of the Damascus Jami (705-15). The chau-chala vaults over the central nave, hitherto not used in Bengal architecture and noticed subsequently in the chhota sona mosque (1493-1519) and the lattan mosque (early 16th century) at Gaur, appear to have originated from the chau-chala huts of Bengal.', 'The interior plan of the mosque - a large central nave with the side wings - follows a style noticed for the first time in Bengal in the adina mosque (1375), which in turn might have been derived from other earlier mosques erected in imitation of the Damascus Jami (705-15). The chau-chala vaults over the central nave, hitherto not used in Bengal architecture and noticed subsequently in the chhota sona mosque (1493-1519) and the lattan mosque (early 16th century) at Gaur, appear to have originated from the chau-chala huts of Bengal.', 'The interior plan of the mosque - a large central nave with the side wings - follows a style noticed for the first time in Bengal in the adina mosque (1375), which in turn might have been derived from other earlier mosques erected in imitation of the Damascus Jami (705-15). The chau-chala vaults over the central nave, hitherto not used in Bengal architecture and noticed subsequently in the chhota sona mosque (1493-1519) and the lattan mosque (early 16th century) at Gaur, appear to have originated from the chau-chala huts of Bengal.', 'The interior plan of the mosque - a large central nave with the side wings - follows a style noticed for the first time in Bengal in the adina mosque (1375), which in turn might have been derived from other earlier mosques erected in imitation of the Damascus Jami (705-15). The chau-chala vaults over the central nave, hitherto not used in Bengal architecture and noticed subsequently in the chhota sona mosque (1493-1519) and the lattan mosque (early 16th century) at Gaur, appear to have originated from the chau-chala huts of Bengal.', 'initial_survey/initial_survey_1742794827.txt', 'execution_works/execution_work_1742279094.pdf', 'annual_plans/annual_plan_1742279094.pdf', 'The interior plan of the mosque - a large central nave with the side wings - follows a style noticed for the first time in Bengal in the adina mosque (1375), which in turn might have been derived from other earlier mosques erected in imitation of the Damascus Jami (705-15). The chau-chala vaults over the central nave, hitherto not used in Bengal architecture and noticed subsequently in the chhota sona mosque (1493-1519) and the lattan mosque (early 16th century) at Gaur, appear to have originated from the chau-chala huts of Bengal.', 'The interior plan of the mosque - a large central nave with the side wings - follows a style noticed for the first time in Bengal in the adina mosque (1375), which in turn might have been derived from other earlier mosques erected in imitation of the Damascus Jami (705-15). The chau-chala vaults over the central nave, hitherto not used in Bengal architecture and noticed subsequently in the chhota sona mosque (1493-1519) and the lattan mosque (early 16th century) at Gaur, appear to have originated from the chau-chala huts of Bengal.', 'The interior plan of the mosque - a large central nave with the side wings - follows a style noticed for the first time in Bengal in the adina mosque (1375), which in turn might have been derived from other earlier mosques erected in imitation of the Damascus Jami (705-15). The chau-chala vaults over the central nave, hitherto not used in Bengal architecture and noticed subsequently in the chhota sona mosque (1493-1519) and the lattan mosque (early 16th century) at Gaur, appear to have originated from the chau-chala huts of Bengal.', 'The interior plan of the mosque - a large central nave with the side wings - follows a style noticed for the first time in Bengal in the adina mosque (1375), which in turn might have been derived from other earlier mosques erected in imitation of the Damascus Jami (705-15). The chau-chala vaults over the central nave, hitherto not used in Bengal architecture and noticed subsequently in the chhota sona mosque (1493-1519) and the lattan mosque (early 16th century) at Gaur, appear to have originated from the chau-chala huts of Bengal.', 'The interior plan of the mosque - a large central nave with the side wings - follows a style noticed for the first time in Bengal in the adina mosque (1375), which in turn might have been derived from other earlier mosques erected in imitation of the Damascus Jami (705-15). The chau-chala vaults over the central nave, hitherto not used in Bengal architecture and noticed subsequently in the chhota sona mosque (1493-1519) and the lattan mosque (early 16th century) at Gaur, appear to have originated from the chau-chala huts of Bengal.', 'master_plans/master_plan_1742279094.pdf', 'Third', 'The interior plan of the mosque - a large central nave with the side wings - follows a style noticed for the first time in Bengal in the adina mosque (1375), which in turn might have been derived from other earlier mosques erected in imitation of the Damascus Jami (705-15). The chau-chala vaults over the central nave, hitherto not used in Bengal architecture and noticed subsequently in the chhota sona mosque (1493-1519) and the lattan mosque (early 16th century) at Gaur, appear to have originated from the chau-chala huts of Bengal.', 'The interior plan of the mosque - a large central nave with the side wings - follows a style noticed for the first time in Bengal in the adina mosque (1375), which in turn might have been derived from other earlier mosques erected in imitation of the Damascus Jami (705-15). The chau-chala vaults over the central nave, hitherto not used in Bengal architecture and noticed subsequently in the chhota sona mosque (1493-1519) and the lattan mosque (early 16th century) at Gaur, appear to have originated from the chau-chala huts of Bengal.', '2025-03-18 00:24:54', '2025-03-23 23:40:27'); INSERT INTO `site_maintenances` (`id`, `site_id`, `keep_watch`, `monitoring_reporting`, `planning_action`, `technical_assistance`, `budget`, `long_plan`, `medium_plan`, `short_plan`, `financial_plan`, `management_plan`, `maintenance_strategy`, `relevant_doc`, `special_care`, `intervension`, `interpretation`, `preventive_action`, `lack_maintenance`, `disaster_plan`, `initial_survey`, `execution_work`, `annual_plan`, `edu_research`, `tourism`, `typology`, `condition`, `conservation_plan`, `master_plan`, `degree_intervension`, `social_impact`, `over_utilization`, `created_at`, `updated_at`) VALUES (2, 2, '
', 'monitoring_reports/monitoring_report_1742292096.pdf', NULL, NULL, '100000000000000', 'ppppppppppppppppppppp', '
', '
', '
', '
', '
', NULL, '
', 'mmmmmmmmmmmmmmmmmmmmmmmmmmmmm', '
', 'ac', '
', '
', 'initial_survey/initial_survey_1742292096.pdf', NULL, 'annual_plans/annual_plan_1742292096.pdf', 'eeeeeeeeeeeeeddddddddddddd', '
', '
', '
', '
', NULL, 'ddddddddddddddddddddddddd', '
', 'ovvvvvvvvvvvvvvvvvv', '2025-03-18 04:01:36', '2025-03-18 04:01:36'); -- -------------------------------------------------------- -- -- Table structure for table `site_media` -- CREATE TABLE `site_media` ( `id` bigint(20) UNSIGNED NOT NULL, `site_id` bigint(20) UNSIGNED NOT NULL, `file_path` varchar(255) NOT NULL, `file_type` enum('image','video') NOT NULL, `user_name` varchar(255) DEFAULT NULL, `phone_no` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `is_active` int(11) 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 `site_media` -- INSERT INTO `site_media` (`id`, `site_id`, `file_path`, `file_type`, `user_name`, `phone_no`, `status`, `is_active`, `created_at`, `updated_at`) VALUES (1, 1, 'gallery/1742279095_sixty_thumb.jpg', 'image', NULL, NULL, 1, NULL, '2025-03-18 00:24:55', '2025-03-18 00:24:55'), (2, 1, 'gallery/1742279095_sixty_banner.jpg', 'image', NULL, NULL, 1, NULL, '2025-03-18 00:24:55', '2025-03-18 00:24:55'), (3, 1, 'gallery/1742279095_sixty2.jpg', 'image', NULL, NULL, 1, NULL, '2025-03-18 00:24:55', '2025-03-18 00:24:55'), (4, 1, 'gallery/1742279096_sixty1.jpg', 'image', NULL, NULL, 1, NULL, '2025-03-18 00:24:56', '2025-03-18 00:24:56'), (5, 2, 'gallery/1742292096_Nine_Dome_Mosque,_Bagerhat,_Bangladesh.jpg', 'image', NULL, NULL, 1, NULL, '2025-03-18 04:01:37', '2025-03-18 04:01:37'), (6, 2, 'gallery/1742292097_NineDomedMosque.jpg', 'image', NULL, NULL, 1, NULL, '2025-03-18 04:01:37', '2025-03-18 04:01:37'), (7, 1, 'gallery/1742368937_WhatsApp Image 2025-03-09 at 09.29.10_6869301a.jpg', 'image', NULL, NULL, 1, NULL, '2025-03-19 01:22:17', '2025-03-19 01:22:17'), (8, 1, 'gallery/1742368937_WhatsApp Image 2025-03-09 at 09.06.32_19ba1589.jpg', 'image', NULL, NULL, 1, NULL, '2025-03-19 01:22:17', '2025-03-19 01:22:17'), (9, 1, 'gallery/1742368937_WhatsApp Image 2025-03-09 at 08.59.34_967290ad.jpg', 'image', NULL, NULL, 1, NULL, '2025-03-19 01:22:17', '2025-03-19 01:22:17'), (10, 2, 'gallery/1742380212_WhatsApp Image 2025-03-09 at 09.12.17_7aab27d2.jpg', 'image', NULL, NULL, 1, NULL, '2025-03-19 04:30:13', '2025-03-19 04:30:13'), (11, 2, 'gallery/1742380213_WhatsApp Image 2025-03-09 at 09.15.04_7d2146ab.jpg', 'image', NULL, NULL, 1, NULL, '2025-03-19 04:30:13', '2025-03-19 04:30:13'), (12, 2, 'gallery/1742380213_WhatsApp Image 2025-03-09 at 09.26.56_34232e25.jpg', 'image', NULL, NULL, 1, NULL, '2025-03-19 04:30:13', '2025-03-19 04:30:13'), (13, 1, 'gallery/1742796633_111111.jpg', 'image', NULL, NULL, 1, NULL, '2025-03-24 00:10:34', '2025-03-24 00:10:34'), (14, 1, 'gallery/1742796720_111111.jpg', 'image', NULL, NULL, 1, NULL, '2025-03-24 00:12:00', '2025-03-24 00:12:00'), (15, 1, 'gallery/Cniia0n19spCLwysLgZ9GXr69QOrpC3XlcVUIq3c.png', 'image', NULL, NULL, NULL, NULL, '2025-03-24 07:47:13', '2025-03-24 07:47:13'), (16, 1, 'gallery/uynrf87EuCusDvjfZq0RV5lia7rzII1bfNDz3meJ.png', 'image', NULL, NULL, NULL, NULL, '2025-03-24 07:47:13', '2025-03-24 07:47:13'), (17, 1, 'gallery/tf0CdNkSjtM09dbElEucsBg9aJEUdUYW2LpALKck.png', 'image', NULL, NULL, 1, NULL, '2025-03-24 07:48:22', '2025-03-24 08:36:15'), (18, 1, 'gallery/feA5VQnRnPUwyPjjzMwFMQxKdK4a80HlffcFzNA5.png', 'image', NULL, NULL, 1, NULL, '2025-03-24 07:48:22', '2025-03-24 08:36:18'), (19, 1, 'gallery/xuw4qVrAwrfSxvObmoyIcug0Pxmnzg1VQwvho7gZ.png', 'image', NULL, NULL, 2, NULL, '2025-03-24 07:50:35', '2025-03-24 08:40:00'), (20, 1, 'gallery/7WA935tG9hvEciZgDW3J2chPj5QhY5casTfOAlPy.png', 'image', NULL, NULL, 1, NULL, '2025-03-24 07:50:35', '2025-03-24 08:42:16'), (21, 1, 'gallery/lBJvnDWSvaficUhYeUu5onlw1zp87ehZgZ7CdDCV.png', 'image', NULL, NULL, 1, NULL, '2025-03-24 07:53:07', '2025-03-24 08:42:20'), (22, 1, 'gallery/zJrPR8j9GpifyaJmOvD2Tn6eWvFZfSDoxarU0aA2.png', 'image', NULL, NULL, 2, NULL, '2025-03-24 07:55:21', '2025-03-24 08:42:24'), (23, 1, 'gallery/v54dXMZVdoBAzIXD5Ve8R0AOrmRej6RSE5lx4hgA.png', 'image', NULL, NULL, 2, NULL, '2025-03-24 07:55:21', '2025-03-24 09:48:58'), (24, 1, 'gallery/pZfKGZasrZqb7wDcjuP4f4MeMSsjyQOFVFGMf0Z8.png', 'image', NULL, NULL, 0, NULL, '2025-03-24 08:02:27', '2025-03-24 08:02:27'), (26, 1, 'gallery/Bey0IFd3l1FpQv1KCmOqM8LP7W7rTMZixuatNAf4.png', 'image', NULL, NULL, 0, NULL, '2025-03-24 08:02:27', '2025-03-24 08:02:27'), (27, 1, 'gallery/STAUrKmjqNNRaR3YvTjaaXkYbLFUdhVZlQTc3d4G.jpg', 'image', NULL, NULL, 0, NULL, '2025-03-24 08:02:27', '2025-03-24 08:02:27'), (28, 2, 'gallery/TNZ97JoAVPQmarECXnmSgna8BI7hGwLgeHm7iFMZ.png', 'image', NULL, NULL, 1, NULL, '2025-03-24 09:06:46', '2025-03-24 09:07:24'), (32, 1, 'gallery/rSDSeIxqkwVffAVVTqcAt6KLXqezu4wt96IA2ql5.png', 'image', 'niam', '121212', 0, NULL, '2025-03-25 03:25:44', '2025-03-25 03:25:44'), (35, 1, 'gallery/9aVHXHp9PZdv50ri5IDTS3sSD6klCoAqoP9pw3Tx.png', 'image', 'naimn', '12121212121', 0, NULL, '2025-03-25 04:07:52', '2025-03-25 04:07:52'), (36, 1, 'gallery/POuRmjZiWArfl1negYKyfi9lVVT6gi95bDOOlOfD.png', 'image', 'naimn', '12121212121', 0, NULL, '2025-03-25 04:07:52', '2025-03-25 04:07:52'), (37, 1, 'gallery/Ry3jkOth0dtjYYyGocJEhanYGfJbXb9wdfI261cz.png', 'image', 'naim', '12212121212', 0, NULL, '2025-03-25 04:36:16', '2025-03-25 04:36:16'), (38, 1, 'gallery/GnJkjOytCwo45hdoSxoFx8VRxoZHfAiwwAEGPgHd.png', 'image', 'naim', '12212121212', 0, NULL, '2025-03-25 04:36:16', '2025-03-25 04:36:16'), (39, 1, 'gallery/YoukiDmiuixL1tL0GgkRp9uX6Cqk7douikWM8QN0.png', 'image', 'naim', '12121212121', 0, 1, '2025-03-25 04:37:34', '2025-03-25 04:37:34'), (40, 1, 'gallery/5G5eHrpha3l5Se08fjevr8FAYZy2GYhjnNlLRmhy.png', 'image', 'naim', '12121212121', 1, 1, '2025-03-25 04:37:34', '2025-03-25 04:37:55'); -- -------------------------------------------------------- -- -- Table structure for table `site_settings` -- CREATE TABLE `site_settings` ( `id` bigint(20) UNSIGNED NOT NULL, `email` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `address` text DEFAULT NULL, `twitter_link` varchar(255) DEFAULT NULL, `linkedin_link` varchar(255) DEFAULT NULL, `facebook_link` varchar(255) DEFAULT NULL, `website_url` varchar(255) DEFAULT NULL, `logo_image` varchar(255) DEFAULT NULL, `hero_image` varchar(255) DEFAULT NULL, `hero_image2` varchar(255) DEFAULT NULL, `preloader_img` text DEFAULT NULL, `hero_text1` varchar(255) DEFAULT NULL, `hero_text2` varchar(255) DEFAULT NULL, `hero_text3` varchar(255) DEFAULT NULL, `youtube_video_link` varchar(255) DEFAULT NULL, `youtube_text1` varchar(255) DEFAULT NULL, `youtube_text2` varchar(255) DEFAULT NULL, `youtube_text3` varchar(255) DEFAULT NULL, `footer_text` 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 `site_settings` -- INSERT INTO `site_settings` (`id`, `email`, `phone`, `address`, `twitter_link`, `linkedin_link`, `facebook_link`, `website_url`, `logo_image`, `hero_image`, `hero_image2`, `preloader_img`, `hero_text1`, `hero_text2`, `hero_text3`, `youtube_video_link`, `youtube_text1`, `youtube_text2`, `youtube_text3`, `footer_text`, `created_at`, `updated_at`) VALUES (1, 'fardaush1977@gmail.com', '02477-730137', 'Majid Saroni, Shibbari, Khulna', 'https://x.com', 'https://www.linkedin.com', 'https://www.facebook.com', 'https://www.facebook.com', 'site_images/1742820938_WhatsApp_Image_2025-03-24_at_13.15.33_1814203b-removebg-preview.png', 'site_images/1742731099_111111.jpg', 'site_images/1742718453_2.jpg', 'site_images/1742820881_WhatsApp_Image_2025-03-24_at_13.15.33_1814203b-removebg-preview.png', 'Find Your', 'Desired Place', 'Where would you like to go?', NULL, NULL, NULL, NULL, 'An archaeological site is a place (or group of physical sites) in which evidence of past activity is preserved (either prehistoric or historic or contemporary), and which has been, or may be, investigated using the discipline of archaeology and represents a part of the archaeological record.', '2025-03-19 02:54:43', '2025-03-24 08:57:28'); -- -------------------------------------------------------- -- -- Table structure for table `thanas` -- CREATE TABLE `thanas` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `district_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `thanas` -- INSERT INTO `thanas` (`id`, `name`, `district_id`, `created_at`, `updated_at`) VALUES (1, 'Sadar', 1, '2025-03-18 00:00:40', '2025-03-18 00:00:40'), (2, 'Sadar', 2, '2025-03-18 00:00:50', '2025-03-18 00:00:50'), (3, 'Sadar', 4, '2025-03-18 00:01:00', '2025-03-23 08:32:54'), (4, 'Sadar', 3, '2025-03-23 08:26:03', '2025-03-23 08:29:41'), (7, 'test', 7, '2025-03-23 08:53:23', '2025-03-23 08:53:23'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `profile_photo_path` text DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `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`, `profile_photo_path`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Admin', 'admin@gmail.com', NULL, NULL, '$2y$12$85twGBADLjAfiY7dRS3sX.XiH98l4eQRR7/lkZ1r8wg8ZF8dQ0GjW', 'Gt2grpty4K3sNbkh3BA6urrpJuCQCwgl6p8CQypTKvQshZHnICyPss3lqi1C', '2025-03-22 00:01:28', '2025-03-22 00:01:28'), (2, 'niam', 'naim@gmailc.com', NULL, NULL, '$2y$12$FapTecw7fUBnrCfn36NxuOBa36VIMGC0DbyPPcEK0DmaXPNi77z42', NULL, '2025-03-24 02:06:04', '2025-03-24 02:06:04'), (5, 'new3', 'naim1111@gmail.com', 'profile-photos/1742821764.png', NULL, '$2y$12$jmpqBgfDWbMzMb5NwSf3Cus2Th1kg5oD8WkTdsDirNSPFLPB/f1iK', NULL, '2025-03-24 07:06:43', '2025-03-24 07:09:24'), (6, 'pemeqivyb', 'jagaqadax@mailinator.com', 'profile-photos/AkTg1c3sVL7UtCJ1LZekPlTGUiKl743fSqV1iCLT.png', NULL, '$2y$12$ka9ZH2lOPomvkqAaqw03oORz0aTheMMirxcmNQhf2e330KOGaOu.K', NULL, '2025-03-24 07:07:23', '2025-03-24 07:07:23'); -- -- Indexes for dumped tables -- -- -- Indexes for table `about_us` -- ALTER TABLE `about_us` ADD PRIMARY KEY (`id`); -- -- Indexes for table `archeological_sites` -- ALTER TABLE `archeological_sites` ADD PRIMARY KEY (`id`), ADD KEY `archeological_sites_district_id_foreign` (`district_id`), ADD KEY `archeological_sites_thana_id_foreign` (`thana_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 `contacts` -- ALTER TABLE `contacts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `districts` -- ALTER TABLE `districts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `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 `messages` -- ALTER TABLE `messages` 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 `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 `site_descriptions` -- ALTER TABLE `site_descriptions` ADD PRIMARY KEY (`id`), ADD KEY `site_descriptions_site_id_foreign` (`site_id`); -- -- Indexes for table `site_maintenances` -- ALTER TABLE `site_maintenances` ADD PRIMARY KEY (`id`), ADD KEY `site_maintenances_site_id_foreign` (`site_id`); -- -- Indexes for table `site_media` -- ALTER TABLE `site_media` ADD PRIMARY KEY (`id`), ADD KEY `site_media_site_id_foreign` (`site_id`); -- -- Indexes for table `site_settings` -- ALTER TABLE `site_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `thanas` -- ALTER TABLE `thanas` ADD PRIMARY KEY (`id`), ADD KEY `thanas_district_id_foreign` (`district_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `about_us` -- ALTER TABLE `about_us` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `archeological_sites` -- ALTER TABLE `archeological_sites` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `contacts` -- ALTER TABLE `contacts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `districts` -- ALTER TABLE `districts` 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 `messages` -- ALTER TABLE `messages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `site_descriptions` -- ALTER TABLE `site_descriptions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `site_maintenances` -- ALTER TABLE `site_maintenances` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `site_media` -- ALTER TABLE `site_media` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41; -- -- AUTO_INCREMENT for table `site_settings` -- ALTER TABLE `site_settings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `thanas` -- ALTER TABLE `thanas` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- Constraints for dumped tables -- -- -- Constraints for table `archeological_sites` -- ALTER TABLE `archeological_sites` ADD CONSTRAINT `archeological_sites_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `archeological_sites_thana_id_foreign` FOREIGN KEY (`thana_id`) REFERENCES `thanas` (`id`) ON DELETE CASCADE; -- -- Constraints for table `site_descriptions` -- ALTER TABLE `site_descriptions` ADD CONSTRAINT `site_descriptions_site_id_foreign` FOREIGN KEY (`site_id`) REFERENCES `archeological_sites` (`id`) ON DELETE CASCADE; -- -- Constraints for table `site_maintenances` -- ALTER TABLE `site_maintenances` ADD CONSTRAINT `site_maintenances_site_id_foreign` FOREIGN KEY (`site_id`) REFERENCES `archeological_sites` (`id`) ON DELETE CASCADE; -- -- Constraints for table `site_media` -- ALTER TABLE `site_media` ADD CONSTRAINT `site_media_site_id_foreign` FOREIGN KEY (`site_id`) REFERENCES `archeological_sites` (`id`) ON DELETE CASCADE; -- -- Constraints for table `thanas` -- ALTER TABLE `thanas` ADD CONSTRAINT `thanas_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE; 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 */;