-- MySQL dump 10.13 Distrib 8.0.45, for Linux (x86_64) -- -- Host: localhost Database: eclassify -- ------------------------------------------------------ -- Server version 8.0.45-0ubuntu0.22.04.1 /*!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 */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `area_translations` -- DROP TABLE IF EXISTS `area_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `area_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `area_id` bigint unsigned NOT NULL, `language_id` bigint unsigned NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `area_translations_area_id_language_id_unique` (`area_id`,`language_id`), KEY `area_translations_language_id_foreign` (`language_id`), CONSTRAINT `area_translations_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE CASCADE, CONSTRAINT `area_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `area_translations` -- LOCK TABLES `area_translations` WRITE; /*!40000 ALTER TABLE `area_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `area_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `areas` -- DROP TABLE IF EXISTS `areas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `areas` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `city_id` bigint unsigned NOT NULL, `state_id` bigint unsigned NOT NULL, `state_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country_id` bigint unsigned NOT NULL, `latitude` decimal(10,8) DEFAULT NULL, `longitude` decimal(11,8) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `areas_city_id_foreign` (`city_id`), KEY `areas_state_id_foreign` (`state_id`), KEY `areas_country_id_foreign` (`country_id`), CONSTRAINT `areas_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE, CONSTRAINT `areas_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE, CONSTRAINT `areas_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `areas` -- LOCK TABLES `areas` WRITE; /*!40000 ALTER TABLE `areas` DISABLE KEYS */; /*!40000 ALTER TABLE `areas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `block_users` -- DROP TABLE IF EXISTS `block_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `block_users` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `blocked_user_id` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `block_users_user_id_blocked_user_id_unique` (`user_id`,`blocked_user_id`), KEY `block_users_blocked_user_id_foreign` (`blocked_user_id`), CONSTRAINT `block_users_blocked_user_id_foreign` FOREIGN KEY (`blocked_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `block_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `block_users` -- LOCK TABLES `block_users` WRITE; /*!40000 ALTER TABLE `block_users` DISABLE KEYS */; /*!40000 ALTER TABLE `block_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `blog_translations` -- DROP TABLE IF EXISTS `blog_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `blog_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `blog_id` bigint unsigned NOT NULL, `language_id` bigint unsigned NOT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `tags` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `blog_translations_blog_id_foreign` (`blog_id`), KEY `blog_translations_language_id_foreign` (`language_id`), CONSTRAINT `blog_translations_blog_id_foreign` FOREIGN KEY (`blog_id`) REFERENCES `blogs` (`id`) ON DELETE CASCADE, CONSTRAINT `blog_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `blog_translations` -- LOCK TABLES `blog_translations` WRITE; /*!40000 ALTER TABLE `blog_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `blog_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `blogs` -- DROP TABLE IF EXISTS `blogs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `blogs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `title` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `image` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL, `tags` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `views` int NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `blogs` -- LOCK TABLES `blogs` WRITE; /*!40000 ALTER TABLE `blogs` DISABLE KEYS */; /*!40000 ALTER TABLE `blogs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `categories` -- DROP TABLE IF EXISTS `categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `categories` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `sequence` int DEFAULT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `parent_category_id` bigint unsigned DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `status` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `slug` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL, `is_job_category` tinyint(1) NOT NULL DEFAULT '0', `price_optional` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `categories_slug_unique` (`slug`), KEY `categories_parent_category_id_foreign` (`parent_category_id`), CONSTRAINT `categories_parent_category_id_foreign` FOREIGN KEY (`parent_category_id`) REFERENCES `categories` (`id`) ON DELETE RESTRICT ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `categories` -- LOCK TABLES `categories` WRITE; /*!40000 ALTER TABLE `categories` DISABLE KEYS */; INSERT INTO `categories` VALUES (1,1,'Automobile','0',7,'Automobile',1,'2026-03-07 07:24:00','2026-03-28 16:27:02','automobile',0,1),(2,2,'Motorcycles','0',NULL,NULL,1,'2026-03-07 07:35:40','2026-03-07 08:30:32','motorcycles',0,1),(5,3,'Trucks','0',NULL,NULL,1,'2026-03-07 07:43:57','2026-03-07 08:30:32','trucks',0,0),(6,5,'Excavator','0',NULL,NULL,1,'2026-03-07 07:49:55','2026-03-07 08:30:32','excavator',0,0),(7,6,'Mobile crane','0',NULL,NULL,1,'2026-03-07 07:51:16','2026-03-07 08:30:32','avtokran',0,0),(8,7,'Agricultural machinery','0',NULL,NULL,1,'2026-03-07 08:01:53','2026-03-07 08:30:32','qishloq-xojalik-texnika',0,0),(9,8,'Municipal machinery','0',NULL,NULL,1,'2026-03-07 08:03:32','2026-03-07 08:30:32','kommunal-texnika',0,0),(10,9,'Loader','0',NULL,NULL,1,'2026-03-07 08:12:42','2026-03-07 08:30:32','pogruschik',0,0),(11,10,'Semi-trailers','0',NULL,NULL,1,'2026-03-07 08:13:37','2026-03-07 08:30:32','polu-pritsep',0,0),(12,4,'Bus','0',NULL,NULL,1,'2026-03-07 08:14:10','2026-03-07 08:30:32','avtobus',0,0),(13,NULL,'Crawler excavator','0',6,NULL,1,'2026-03-07 08:57:26','2026-03-07 08:57:26','gusenichniy-ekskavator',0,0),(14,NULL,'Backhoe loader','0',6,NULL,1,'2026-03-07 08:58:56','2026-03-07 08:58:56','ekskavator-pogruschik',0,0),(15,NULL,'Wheeled excavator','0',6,NULL,1,'2026-03-07 09:00:47','2026-03-07 09:00:47','kolesniy-pogruschik',0,0); /*!40000 ALTER TABLE `categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `category_translations` -- DROP TABLE IF EXISTS `category_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `category_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `category_id` bigint unsigned NOT NULL, `language_id` bigint unsigned NOT NULL, `name` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `category_translations_category_id_language_id_unique` (`category_id`,`language_id`), KEY `category_translations_language_id_foreign` (`language_id`), CONSTRAINT `category_translations_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, CONSTRAINT `category_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `category_translations` -- LOCK TABLES `category_translations` WRITE; /*!40000 ALTER TABLE `category_translations` DISABLE KEYS */; INSERT INTO `category_translations` VALUES (1,1,2,'Avtomobillar','Avtomobillar','2026-03-07 07:28:51','2026-03-07 07:28:51'),(2,1,3,'Автомобили','Автомобили','2026-03-07 07:28:51','2026-03-07 07:28:51'),(3,2,2,'Mototexnika',NULL,'2026-03-07 07:35:40','2026-03-07 07:35:40'),(4,2,3,'Мототехника',NULL,'2026-03-07 07:35:40','2026-03-07 07:35:40'),(9,5,2,'Yuk mashinalari',NULL,'2026-03-07 07:43:57','2026-03-07 07:43:57'),(10,5,3,'Грузовики',NULL,'2026-03-07 07:43:57','2026-03-07 07:43:57'),(11,6,2,'Ekskavator',NULL,'2026-03-07 07:49:55','2026-03-07 07:49:55'),(12,6,3,'Экскаватор',NULL,'2026-03-07 07:49:55','2026-03-07 07:49:55'),(13,7,2,'Avtokran',NULL,'2026-03-07 07:51:16','2026-03-07 07:51:16'),(14,7,3,'Автокран',NULL,'2026-03-07 07:51:16','2026-03-07 07:51:16'),(15,8,2,'Qishloq xoʻjaligi texnikasi',NULL,'2026-03-07 08:01:53','2026-03-07 08:01:53'),(16,8,3,'Сельхозтехника',NULL,'2026-03-07 08:01:53','2026-03-07 08:01:53'),(17,9,2,'Kommunal texnika',NULL,'2026-03-07 08:03:32','2026-03-07 08:03:32'),(18,9,3,'Коммунальная техника',NULL,'2026-03-07 08:03:32','2026-03-07 08:03:32'),(19,10,2,'Yuklagich',NULL,'2026-03-07 08:12:42','2026-03-07 08:12:42'),(20,10,3,'Погрузчик',NULL,'2026-03-07 08:12:42','2026-03-07 08:12:42'),(21,11,2,'Yarim tirkamalar',NULL,'2026-03-07 08:13:37','2026-03-07 08:13:37'),(22,11,3,'Полуприцепы',NULL,'2026-03-07 08:13:37','2026-03-07 08:13:37'),(23,12,2,'Avtobus',NULL,'2026-03-07 08:14:10','2026-03-07 08:14:10'),(24,12,3,'Автобус',NULL,'2026-03-07 08:14:10','2026-03-07 08:14:10'),(25,13,2,'Zanjirli ekskavator',NULL,'2026-03-07 08:57:26','2026-03-07 08:57:26'),(26,13,3,'Гусеничный экскаватор',NULL,'2026-03-07 08:57:26','2026-03-07 08:57:26'),(27,14,2,'Ekskavator pogruzchik',NULL,'2026-03-07 08:58:56','2026-03-07 08:58:56'),(28,14,3,'Экскаватор-погрузчик',NULL,'2026-03-07 08:58:56','2026-03-07 08:58:56'),(29,15,2,'G\'ildirakli ekskavator',NULL,'2026-03-07 09:00:47','2026-03-07 09:00:47'),(30,15,3,'Колёсный экскаватор',NULL,'2026-03-07 09:00:47','2026-03-07 09:00:47'); /*!40000 ALTER TABLE `category_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chats` -- DROP TABLE IF EXISTS `chats`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `chats` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `sender_id` bigint unsigned NOT NULL, `item_offer_id` bigint unsigned NOT NULL, `message` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `audio` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `is_read` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `chats_sender_id_foreign` (`sender_id`), KEY `chats_item_offer_id_foreign` (`item_offer_id`), CONSTRAINT `chats_item_offer_id_foreign` FOREIGN KEY (`item_offer_id`) REFERENCES `item_offers` (`id`) ON DELETE CASCADE, CONSTRAINT `chats_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chats` -- LOCK TABLES `chats` WRITE; /*!40000 ALTER TABLE `chats` DISABLE KEYS */; /*!40000 ALTER TABLE `chats` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cities` -- DROP TABLE IF EXISTS `cities`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cities` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `state_id` bigint unsigned NOT NULL, `state_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `country_id` bigint unsigned NOT NULL, `country_code` char(2) COLLATE utf8mb4_unicode_ci NOT NULL, `latitude` decimal(8,2) DEFAULT NULL, `longitude` decimal(8,2) DEFAULT NULL, `flag` tinyint(1) DEFAULT NULL, `wikiDataId` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `cities_name_state_id_country_id_unique` (`name`,`state_id`,`country_id`), KEY `cities_state_id_foreign` (`state_id`), KEY `cities_country_id_foreign` (`country_id`), CONSTRAINT `cities_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE, CONSTRAINT `cities_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=130029 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cities` -- LOCK TABLES `cities` WRITE; /*!40000 ALTER TABLE `cities` DISABLE KEYS */; INSERT INTO `cities` VALUES (129894,'Andijon',2540,'AN',236,'UZ',40.78,72.34,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129895,'Andijon Tumani',2540,'AN',236,'UZ',40.80,72.42,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129896,'Angren',2549,'TO',236,'UZ',41.02,70.14,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129897,'Asaka',2540,'AN',236,'UZ',40.64,72.24,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129898,'Asaka Tumani',2540,'AN',236,'UZ',40.67,72.25,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129899,'Baliqchi Tumani',2540,'AN',236,'UZ',40.87,72.00,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129900,'Bekobod',2549,'TO',236,'UZ',40.22,69.27,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129901,'Bektemir',2536,'TK',236,'UZ',41.21,69.33,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129902,'Beruniy',2548,'QR',236,'UZ',41.69,60.75,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129903,'Beshariq',2538,'FA',236,'UZ',40.44,70.61,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129904,'Beshkent',2543,'QA',236,'UZ',38.82,65.65,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129905,'Boghot Tumani',2539,'XO',236,'UZ',41.31,60.85,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129906,'Boysun',2546,'SU',236,'UZ',38.21,67.21,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129907,'Bo‘ka',2549,'TO',236,'UZ',40.81,69.19,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129908,'Bo‘z Tumani',2540,'AN',236,'UZ',40.67,71.92,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129909,'Bukhara',2541,'BU',236,'UZ',39.77,64.43,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129910,'Buloqboshi Tumani',2540,'AN',236,'UZ',40.62,72.47,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129911,'Bulung’ur',2544,'SA',236,'UZ',39.76,67.27,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129912,'Charxin',2544,'SA',236,'UZ',39.70,66.77,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129913,'Chelak',2544,'SA',236,'UZ',39.92,66.86,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129914,'Chinoz',2549,'TO',236,'UZ',40.94,68.76,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129915,'Chirchiq',2549,'TO',236,'UZ',41.47,69.58,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129916,'Chiroqchi',2543,'QA',236,'UZ',39.03,66.57,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129917,'Chortoq',2537,'NG',236,'UZ',41.07,71.82,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129918,'Chust',2537,'NG',236,'UZ',41.00,71.24,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129919,'Dashtobod',2545,'JI',236,'UZ',40.13,68.49,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129920,'Daxbet',2544,'SA',236,'UZ',39.76,66.91,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129921,'Denov',2546,'SU',236,'UZ',38.27,67.90,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129922,'Dŭstlik',2545,'JI',236,'UZ',40.52,68.04,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129923,'Fergana',2538,'FA',236,'UZ',40.38,71.78,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129924,'Gagarin',2545,'JI',236,'UZ',40.66,68.17,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129925,'Galaosiyo',2541,'BU',236,'UZ',39.86,64.45,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129926,'Gazli',2541,'BU',236,'UZ',40.13,63.45,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129927,'Ghijduwon',2541,'BU',236,'UZ',40.10,64.68,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129928,'Guliston',2547,'SI',236,'UZ',40.49,68.78,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129929,'Gurlan',2539,'XO',236,'UZ',41.84,60.39,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129930,'G‘azalkent',2549,'TO',236,'UZ',41.56,69.77,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129931,'G‘uzor',2543,'QA',236,'UZ',38.62,66.25,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129932,'Hamza',2538,'FA',236,'UZ',40.43,71.51,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129933,'Haqqulobod',2537,'NG',236,'UZ',40.92,72.12,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129934,'Hazorasp',2539,'XO',236,'UZ',41.32,61.07,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129935,'Ishtixon',2544,'SA',236,'UZ',39.97,66.49,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129936,'Iskandar',2549,'TO',236,'UZ',41.55,69.70,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129937,'Izboskan Tumani',2540,'AN',236,'UZ',40.92,72.25,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129938,'Jalolkuduk Tumani',2540,'AN',236,'UZ',40.75,72.67,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129939,'Jizzax',2545,'JI',236,'UZ',40.12,67.84,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129940,'Jomboy',2544,'SA',236,'UZ',39.70,67.09,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129941,'Juma',2544,'SA',236,'UZ',39.72,66.66,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129942,'Karakul’',2541,'BU',236,'UZ',39.53,63.83,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129943,'Kattaqo‘rg‘on',2544,'SA',236,'UZ',39.90,66.26,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129944,'Kegeyli Shahar',2548,'QR',236,'UZ',42.78,59.61,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129945,'Khiwa',2539,'XO',236,'UZ',41.38,60.36,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129946,'Khŭjaobod Tumani',2540,'AN',236,'UZ',40.67,72.58,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129947,'Khŭjayli',2548,'QR',236,'UZ',42.40,59.46,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129948,'Kirguli',2538,'FA',236,'UZ',40.44,71.77,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129949,'Kitob',2543,'QA',236,'UZ',39.08,66.83,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129950,'Kogon',2541,'BU',236,'UZ',39.72,64.55,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129951,'Koson',2543,'QA',236,'UZ',39.04,65.59,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129952,'Kosonsoy',2537,'NG',236,'UZ',41.25,71.55,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129953,'Kyzyldzhar',2549,'TO',236,'UZ',41.57,70.02,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129954,'Manghit',2548,'QR',236,'UZ',42.12,60.06,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129955,'Marg‘ilon',2538,'FA',236,'UZ',40.47,71.72,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129956,'Marhamat',2540,'AN',236,'UZ',40.48,72.31,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129957,'Marhamat Tumani',2540,'AN',236,'UZ',40.50,72.32,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129958,'Muborak',2543,'QA',236,'UZ',39.26,65.15,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129959,'Mŭynoq',2548,'QR',236,'UZ',43.77,59.02,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129960,'Namangan',2537,'NG',236,'UZ',41.00,71.67,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129961,'Navoiy',2542,'NW',236,'UZ',40.08,65.38,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129962,'Nishon Tumani',2543,'QA',236,'UZ',38.69,65.68,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129963,'Novyy Turtkul’',2548,'QR',236,'UZ',41.55,61.02,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129964,'Nukus',2548,'QR',236,'UZ',42.45,59.61,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129965,'Nurota',2542,'NW',236,'UZ',40.56,65.69,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129966,'Ohangaron',2549,'TO',236,'UZ',40.91,69.64,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129967,'Olmaliq',2549,'TO',236,'UZ',40.84,69.60,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129968,'Olot',2541,'BU',236,'UZ',39.42,63.80,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129969,'Oltiariq',2538,'FA',236,'UZ',40.39,71.47,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129970,'Oltinko‘l',2548,'QR',236,'UZ',43.07,58.90,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129971,'Oltinkŭl Tumani',2540,'AN',236,'UZ',40.80,72.17,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129972,'Oqtosh',2544,'SA',236,'UZ',39.92,65.93,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129973,'Pakhtaobod Tumani',2540,'AN',236,'UZ',40.93,72.50,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129974,'Parkent',2549,'TO',236,'UZ',41.29,69.68,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129975,'Paxtakor',2545,'JI',236,'UZ',40.32,67.95,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129976,'Paxtaobod',2540,'AN',236,'UZ',40.93,72.50,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129977,'Payshanba',2544,'SA',236,'UZ',40.01,66.24,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129978,'Peshku Tumani',2541,'BU',236,'UZ',40.42,63.83,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129979,'Piskent',2549,'TO',236,'UZ',40.90,69.35,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129980,'Pop',2537,'NG',236,'UZ',40.87,71.11,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129981,'Qarshi',2543,'QA',236,'UZ',38.86,65.79,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129982,'Qibray',2549,'TO',236,'UZ',41.39,69.47,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129983,'Qiziltepa',2542,'NW',236,'UZ',40.03,64.85,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129984,'Qorako’l',2541,'BU',236,'UZ',39.50,63.85,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129985,'Qorovulbozor',2541,'BU',236,'UZ',39.50,64.79,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129986,'Qo‘qon',2538,'FA',236,'UZ',40.53,70.94,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129987,'Qo‘rg‘ontepa',2540,'AN',236,'UZ',40.73,72.76,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129988,'Quva',2538,'FA',236,'UZ',40.52,72.07,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129989,'Quvasoy',2538,'FA',236,'UZ',40.30,71.98,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129990,'Qŭrghontepa Tumani',2540,'AN',236,'UZ',40.75,72.83,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129991,'Qŭshkŭpir',2539,'XO',236,'UZ',41.54,60.35,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129992,'Rishton',2538,'FA',236,'UZ',40.36,71.28,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129993,'Romiton',2541,'BU',236,'UZ',39.93,64.38,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129994,'Salor',2549,'TO',236,'UZ',41.37,69.38,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129995,'Samarkand',2544,'SA',236,'UZ',39.65,66.96,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129996,'Shahrikhon Tumani',2540,'AN',236,'UZ',40.72,72.07,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129997,'Shahrisabz',2543,'QA',236,'UZ',39.06,66.83,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129998,'Shahrixon',2540,'AN',236,'UZ',40.71,72.06,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(129999,'Shofirkon',2541,'BU',236,'UZ',40.12,64.50,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130000,'Shohimardon',2538,'FA',236,'UZ',39.98,71.81,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130001,'Showot',2539,'XO',236,'UZ',41.66,60.30,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130002,'Sho‘rchi',2546,'SU',236,'UZ',38.00,67.79,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130003,'Sirdaryo',2547,'SI',236,'UZ',40.84,68.66,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130004,'So‘x Tumani',2538,'FA',236,'UZ',40.04,71.09,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130005,'Tashkent',2536,'TK',236,'UZ',41.26,69.22,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130006,'Termiz',2546,'SU',236,'UZ',37.25,67.28,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:16:07'),(130007,'Toshbuloq',2537,'NG',236,'UZ',40.92,71.58,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130008,'Toshloq',2538,'FA',236,'UZ',40.48,71.77,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130009,'To‘rqao‘rg‘on',2537,'NG',236,'UZ',41.00,71.51,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130010,'Tŭytepa',2549,'TO',236,'UZ',41.03,69.36,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130011,'Uchqŭrghon Shahri',2537,'NG',236,'UZ',41.11,72.08,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130012,'Ulug‘nor Tumani',2540,'AN',236,'UZ',40.75,71.70,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130013,'Urganch',2539,'XO',236,'UZ',41.55,60.63,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130014,'Urgut',2544,'SA',236,'UZ',39.40,67.24,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130015,'Uychi',2537,'NG',236,'UZ',41.08,71.92,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130016,'Wobkent',2541,'BU',236,'UZ',40.03,64.52,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130017,'Wobkent Tumani',2541,'BU',236,'UZ',40.00,64.50,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130018,'Xo‘jaobod',2540,'AN',236,'UZ',40.67,72.56,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130019,'Yangi Marg‘ilon',2538,'FA',236,'UZ',40.43,71.72,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130020,'Yangiobod',2549,'TO',236,'UZ',41.12,70.09,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130021,'Yangiqo‘rg‘on',2537,'NG',236,'UZ',41.19,71.72,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130022,'Yangirabot',2542,'NW',236,'UZ',40.03,65.96,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130023,'Yangiyer',2547,'SI',236,'UZ',40.28,68.82,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130024,'Yangiyŭl',2549,'TO',236,'UZ',41.11,69.05,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130025,'Yaypan',2538,'FA',236,'UZ',40.38,70.82,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130026,'Zafar',2549,'TO',236,'UZ',40.98,68.90,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130027,'Zomin',2545,'JI',236,'UZ',39.96,68.40,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(130028,'Ŭrtaowul',2549,'TO',236,'UZ',41.19,69.15,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'); /*!40000 ALTER TABLE `cities` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `city_translations` -- DROP TABLE IF EXISTS `city_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `city_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `city_id` bigint unsigned NOT NULL, `language_id` bigint unsigned NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `city_translations_city_id_language_id_unique` (`city_id`,`language_id`), KEY `city_translations_language_id_foreign` (`language_id`), CONSTRAINT `city_translations_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE, CONSTRAINT `city_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `city_translations` -- LOCK TABLES `city_translations` WRITE; /*!40000 ALTER TABLE `city_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `city_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contact_us` -- DROP TABLE IF EXISTS `contact_us`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `contact_us` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `subject` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `message` text COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contact_us` -- LOCK TABLES `contact_us` WRITE; /*!40000 ALTER TABLE `contact_us` DISABLE KEYS */; /*!40000 ALTER TABLE `contact_us` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `countries` -- DROP TABLE IF EXISTS `countries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `countries` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `iso3` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `numeric_code` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `iso2` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phonecode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `capital` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `currency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `currency_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `currency_symbol` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `tld` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `native` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `region` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `region_id` int DEFAULT NULL, `subregion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `subregion_id` int DEFAULT NULL, `nationality` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `timezones` text COLLATE utf8mb4_unicode_ci, `translations` text COLLATE utf8mb4_unicode_ci, `latitude` decimal(8,2) DEFAULT NULL, `longitude` decimal(8,2) DEFAULT NULL, `emoji` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `emojiU` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `flag` tinyint(1) DEFAULT NULL, `wikiDataId` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `currency_id` bigint unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `countries_currency_id_foreign` (`currency_id`), CONSTRAINT `countries_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=237 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `countries` -- LOCK TABLES `countries` WRITE; /*!40000 ALTER TABLE `countries` DISABLE KEYS */; INSERT INTO `countries` VALUES (236,'Uzbekistan','UZB','860','UZ',NULL,'Tashkent','UZS','Uzbekistani soʻm','лв','.uz','O‘zbekiston','Asia',NULL,'Central Asia',NULL,'Uzbekistani, Uzbek','[{\"zoneName\":\"Asia\\/Samarkand\",\"gmtOffset\":18000,\"gmtOffsetName\":\"UTC+05:00\",\"abbreviation\":\"UZT\",\"tzName\":\"Uzbekistan Time\"},{\"zoneName\":\"Asia\\/Tashkent\",\"gmtOffset\":18000,\"gmtOffsetName\":\"UTC+05:00\",\"abbreviation\":\"UZT\",\"tzName\":\"Uzbekistan Time\"}]','{\"kr\":\"\\uc6b0\\uc988\\ubca0\\ud0a4\\uc2a4\\ud0c4\",\"pt-BR\":\"Uzbequist\\u00e3o\",\"pt\":\"Usbequist\\u00e3o\",\"nl\":\"Oezbekistan\",\"hr\":\"Uzbekistan\",\"fa\":\"\\u0627\\u0632\\u0628\\u06a9\\u0633\\u062a\\u0627\\u0646\",\"de\":\"Usbekistan\",\"es\":\"Uzbekist\\u00e1n\",\"fr\":\"Ouzb\\u00e9kistan\",\"ja\":\"\\u30a6\\u30ba\\u30d9\\u30ad\\u30b9\\u30bf\\u30f3\",\"it\":\"Uzbekistan\",\"cn\":\"\\u4e4c\\u5179\\u522b\\u514b\\u65af\\u5766\",\"tr\":\"\\u00d6zbekistan\"}',41.00,64.00,'🇺🇿','U+1F1FA U+1F1FF',NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30',NULL); /*!40000 ALTER TABLE `countries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `country_translations` -- DROP TABLE IF EXISTS `country_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `country_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `country_id` bigint unsigned NOT NULL, `language_id` bigint unsigned NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `country_translations_country_id_language_id_unique` (`country_id`,`language_id`), KEY `country_translations_language_id_foreign` (`language_id`), CONSTRAINT `country_translations_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE, CONSTRAINT `country_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `country_translations` -- LOCK TABLES `country_translations` WRITE; /*!40000 ALTER TABLE `country_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `country_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `currencies` -- DROP TABLE IF EXISTS `currencies`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `currencies` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `country_id` bigint unsigned DEFAULT NULL, `iso_code` char(3) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ISO 4217 currency code', `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Currency name', `symbol` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Currency symbol', `symbol_position` enum('left','right') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'left' COMMENT 'Currency symbol position', `decimal_places` tinyint unsigned NOT NULL DEFAULT '2', `thousand_separator` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ',', `decimal_separator` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '.', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `currencies_iso_code_unique` (`iso_code`), UNIQUE KEY `currencies_name_unique` (`name`), KEY `currencies_country_id_foreign` (`country_id`), CONSTRAINT `currencies_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `currencies` -- LOCK TABLES `currencies` WRITE; /*!40000 ALTER TABLE `currencies` DISABLE KEYS */; INSERT INTO `currencies` VALUES (1,236,'UZS','So\'m','UZS','left',2,',','.','2026-03-07 09:16:53','2026-03-07 09:16:53'),(2,236,'USD','USD','$','left',2,',','.','2026-03-07 10:07:16','2026-03-07 10:07:16'); /*!40000 ALTER TABLE `currencies` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `custom_field_categories` -- DROP TABLE IF EXISTS `custom_field_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `custom_field_categories` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `category_id` bigint unsigned NOT NULL, `custom_field_id` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `custom_field_categories_category_id_foreign` (`category_id`), KEY `custom_field_categories_custom_field_id_foreign` (`custom_field_id`), CONSTRAINT `custom_field_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, CONSTRAINT `custom_field_categories_custom_field_id_foreign` FOREIGN KEY (`custom_field_id`) REFERENCES `custom_fields` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `custom_field_categories` -- LOCK TABLES `custom_field_categories` WRITE; /*!40000 ALTER TABLE `custom_field_categories` DISABLE KEYS */; INSERT INTO `custom_field_categories` VALUES (4,13,2,'2026-03-07 10:06:25','2026-03-07 10:06:25'),(5,14,2,'2026-03-07 10:06:25','2026-03-07 10:06:25'),(6,15,2,'2026-03-07 10:06:25','2026-03-07 10:06:25'); /*!40000 ALTER TABLE `custom_field_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `custom_fields` -- DROP TABLE IF EXISTS `custom_fields`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `custom_fields` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `required` tinyint(1) NOT NULL, `values` text COLLATE utf8mb4_unicode_ci, `min_length` int DEFAULT NULL, `max_length` int DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `custom_fields` -- LOCK TABLES `custom_fields` WRITE; /*!40000 ALTER TABLE `custom_fields` DISABLE KEYS */; INSERT INTO `custom_fields` VALUES (2,'Brand Excavator','dropdown','0',1,'[\"Zoomlion\",\"Liugong\",\"XCMG\",\"Hyundai\",\"Kato\",\"Mecalac\",\"JCB\",\"Heracles\",\"Doosan\",\"Gehl\",\"Rippa\",\"SAM\",\"Jonyang\",\"Komatsu\",\"SDLG\",\"Shantui\",\"Caterpillar\",\"Hitachi\",\"JGM\",\"Jingong\",\"Shanmon\",\"Case\",\"Sany\",\"VIAMAR\",\"MST\"]',NULL,NULL,1,'2026-03-07 10:06:25','2026-03-07 10:06:25'); /*!40000 ALTER TABLE `custom_fields` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `custom_fields_translations` -- DROP TABLE IF EXISTS `custom_fields_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `custom_fields_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `custom_field_id` bigint unsigned NOT NULL, `language_id` bigint unsigned NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `value` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `custom_fields_translations_custom_field_id_language_id_unique` (`custom_field_id`,`language_id`), KEY `custom_fields_translations_language_id_foreign` (`language_id`), CONSTRAINT `custom_fields_translations_custom_field_id_foreign` FOREIGN KEY (`custom_field_id`) REFERENCES `custom_fields` (`id`) ON DELETE CASCADE, CONSTRAINT `custom_fields_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `custom_fields_translations` -- LOCK TABLES `custom_fields_translations` WRITE; /*!40000 ALTER TABLE `custom_fields_translations` DISABLE KEYS */; INSERT INTO `custom_fields_translations` VALUES (3,2,2,'Brend ekskavatori',NULL,'2026-03-07 10:06:25','2026-03-07 10:06:25'),(4,2,3,'Бренд экскаваторов',NULL,'2026-03-07 10:06:25','2026-03-07 10:06:25'); /*!40000 ALTER TABLE `custom_fields_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `failed_jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faq_translations` -- DROP TABLE IF EXISTS `faq_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `faq_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `question` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `answer` text COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `faq_id` bigint unsigned NOT NULL, `language_id` bigint unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `faq_language_unique` (`faq_id`,`language_id`), KEY `faq_translations_language_id_foreign` (`language_id`), CONSTRAINT `faq_translations_faq_id_foreign` FOREIGN KEY (`faq_id`) REFERENCES `faqs` (`id`) ON DELETE CASCADE, CONSTRAINT `faq_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faq_translations` -- LOCK TABLES `faq_translations` WRITE; /*!40000 ALTER TABLE `faq_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `faq_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faqs` -- DROP TABLE IF EXISTS `faqs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `faqs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `question` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `answer` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faqs` -- LOCK TABLES `faqs` WRITE; /*!40000 ALTER TABLE `faqs` DISABLE KEYS */; /*!40000 ALTER TABLE `faqs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `favourites` -- DROP TABLE IF EXISTS `favourites`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `favourites` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `user_id` bigint unsigned NOT NULL, `item_id` bigint unsigned NOT NULL, PRIMARY KEY (`id`), KEY `favourites_user_id_foreign` (`user_id`), KEY `favourites_item_id_foreign` (`item_id`), CONSTRAINT `favourites_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE, CONSTRAINT `favourites_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `favourites` -- LOCK TABLES `favourites` WRITE; /*!40000 ALTER TABLE `favourites` DISABLE KEYS */; /*!40000 ALTER TABLE `favourites` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `feature_section_translations` -- DROP TABLE IF EXISTS `feature_section_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `feature_section_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `feature_section_id` bigint unsigned NOT NULL, `language_id` bigint unsigned NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `feature_section_language_unique` (`feature_section_id`,`language_id`), KEY `feature_section_translations_language_id_foreign` (`language_id`), CONSTRAINT `feature_section_translations_feature_section_id_foreign` FOREIGN KEY (`feature_section_id`) REFERENCES `feature_sections` (`id`) ON DELETE CASCADE, CONSTRAINT `feature_section_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `feature_section_translations` -- LOCK TABLES `feature_section_translations` WRITE; /*!40000 ALTER TABLE `feature_section_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `feature_section_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `feature_sections` -- DROP TABLE IF EXISTS `feature_sections`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `feature_sections` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL, `sequence` int NOT NULL, `filter` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `style` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `min_price` int DEFAULT NULL, `max_price` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `feature_sections_slug_unique` (`slug`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `feature_sections` -- LOCK TABLES `feature_sections` WRITE; /*!40000 ALTER TABLE `feature_sections` DISABLE KEYS */; /*!40000 ALTER TABLE `feature_sections` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `featured_items` -- DROP TABLE IF EXISTS `featured_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `featured_items` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `start_date` date NOT NULL, `end_date` date DEFAULT NULL, `item_id` bigint unsigned NOT NULL, `package_id` bigint unsigned NOT NULL, `user_purchased_package_id` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `featured_items_item_id_package_id_unique` (`item_id`,`package_id`), KEY `featured_items_package_id_foreign` (`package_id`), KEY `featured_items_user_purchased_package_id_foreign` (`user_purchased_package_id`), CONSTRAINT `featured_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE, CONSTRAINT `featured_items_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE, CONSTRAINT `featured_items_user_purchased_package_id_foreign` FOREIGN KEY (`user_purchased_package_id`) REFERENCES `user_purchased_packages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `featured_items` -- LOCK TABLES `featured_items` WRITE; /*!40000 ALTER TABLE `featured_items` DISABLE KEYS */; /*!40000 ALTER TABLE `featured_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_custom_field_values` -- DROP TABLE IF EXISTS `item_custom_field_values`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_custom_field_values` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `item_id` bigint unsigned NOT NULL, `custom_field_id` bigint unsigned NOT NULL, `value` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `language_id` bigint unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `item_field_language_unique` (`item_id`,`custom_field_id`,`language_id`), KEY `item_custom_field_values_language_id_foreign` (`language_id`), KEY `item_custom_field_values_custom_field_id_foreign` (`custom_field_id`), CONSTRAINT `item_custom_field_values_custom_field_id_foreign` FOREIGN KEY (`custom_field_id`) REFERENCES `custom_fields` (`id`) ON DELETE CASCADE, CONSTRAINT `item_custom_field_values_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE, CONSTRAINT `item_custom_field_values_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_custom_field_values` -- LOCK TABLES `item_custom_field_values` WRITE; /*!40000 ALTER TABLE `item_custom_field_values` DISABLE KEYS */; /*!40000 ALTER TABLE `item_custom_field_values` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_images` -- DROP TABLE IF EXISTS `item_images`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_images` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `item_id` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `item_images_item_id_foreign` (`item_id`), CONSTRAINT `item_images_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_images` -- LOCK TABLES `item_images` WRITE; /*!40000 ALTER TABLE `item_images` DISABLE KEYS */; /*!40000 ALTER TABLE `item_images` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_offers` -- DROP TABLE IF EXISTS `item_offers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_offers` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `seller_id` bigint unsigned NOT NULL, `buyer_id` bigint unsigned NOT NULL, `item_id` bigint unsigned NOT NULL, `amount` double(8,2) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `item_offers_buyer_id_item_id_unique` (`buyer_id`,`item_id`), KEY `item_offers_seller_id_foreign` (`seller_id`), KEY `item_offers_item_id_foreign` (`item_id`), CONSTRAINT `item_offers_buyer_id_foreign` FOREIGN KEY (`buyer_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, CONSTRAINT `item_offers_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE, CONSTRAINT `item_offers_seller_id_foreign` FOREIGN KEY (`seller_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_offers` -- LOCK TABLES `item_offers` WRITE; /*!40000 ALTER TABLE `item_offers` DISABLE KEYS */; /*!40000 ALTER TABLE `item_offers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_translations` -- DROP TABLE IF EXISTS `item_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `item_id` bigint unsigned NOT NULL, `language_id` bigint unsigned NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `address` text COLLATE utf8mb4_unicode_ci, `rejected_reason` text COLLATE utf8mb4_unicode_ci, `admin_edit_reason` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `item_translations_item_id_language_id_unique` (`item_id`,`language_id`), KEY `item_translations_language_id_foreign` (`language_id`), CONSTRAINT `item_translations_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE, CONSTRAINT `item_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_translations` -- LOCK TABLES `item_translations` WRITE; /*!40000 ALTER TABLE `item_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `item_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `items` -- DROP TABLE IF EXISTS `items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `items` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `price` double DEFAULT NULL, `currency_id` bigint unsigned DEFAULT NULL, `min_salary` double DEFAULT NULL, `max_salary` double DEFAULT NULL, `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `latitude` double NOT NULL, `longitude` double NOT NULL, `address` text COLLATE utf8mb4_unicode_ci NOT NULL, `contact` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `show_only_to_premium` tinyint(1) NOT NULL, `show_mobile_number` tinyint(1) NOT NULL DEFAULT '0', `status` enum('review','approved','soft rejected','permanent rejected','sold out','featured','resubmitted') COLLATE utf8mb4_unicode_ci NOT NULL, `rejected_reason` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `video_link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `city` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `area_id` bigint unsigned DEFAULT NULL, `user_id` bigint unsigned NOT NULL, `sold_to` bigint unsigned DEFAULT NULL, `category_id` bigint unsigned NOT NULL, `all_category_ids` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `expiry_date` date DEFAULT NULL, `clicks` int NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `is_edited_by_admin` tinyint(1) NOT NULL DEFAULT '0', `admin_edit_reason` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `package_id` bigint unsigned DEFAULT NULL, `region_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `items_slug_unique` (`slug`), KEY `items_user_id_foreign` (`user_id`), KEY `items_category_id_foreign` (`category_id`), KEY `items_area_id_foreign` (`area_id`), KEY `items_sold_to_foreign` (`sold_to`), KEY `items_package_id_foreign` (`package_id`), KEY `items_currency_id_foreign` (`currency_id`), CONSTRAINT `items_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE RESTRICT, CONSTRAINT `items_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE RESTRICT, CONSTRAINT `items_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE SET NULL, CONSTRAINT `items_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE SET NULL, CONSTRAINT `items_sold_to_foreign` FOREIGN KEY (`sold_to`) REFERENCES `users` (`id`) ON DELETE CASCADE, CONSTRAINT `items_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `items` -- LOCK TABLES `items` WRITE; /*!40000 ALTER TABLE `items` DISABLE KEYS */; /*!40000 ALTER TABLE `items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_applications` -- DROP TABLE IF EXISTS `job_applications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `job_applications` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `item_id` bigint unsigned NOT NULL, `user_id` bigint unsigned NOT NULL, `recruiter_id` bigint unsigned NOT NULL, `full_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `mobile` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `resume` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('pending','accepted','rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_user_item` (`user_id`,`item_id`), KEY `job_applications_item_id_foreign` (`item_id`), KEY `job_applications_recruiter_id_foreign` (`recruiter_id`), CONSTRAINT `job_applications_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE, CONSTRAINT `job_applications_recruiter_id_foreign` FOREIGN KEY (`recruiter_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, CONSTRAINT `job_applications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_applications` -- LOCK TABLES `job_applications` WRITE; /*!40000 ALTER TABLE `job_applications` DISABLE KEYS */; /*!40000 ALTER TABLE `job_applications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `attempts` tinyint unsigned NOT NULL, `reserved_at` int unsigned DEFAULT NULL, `available_at` int unsigned NOT NULL, `created_at` int unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `languages` -- DROP TABLE IF EXISTS `languages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `languages` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `name_in_english` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, `app_file` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `panel_file` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `web_file` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `rtl` tinyint(1) NOT NULL, `image` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `country_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `languages` -- LOCK TABLES `languages` WRITE; /*!40000 ALTER TABLE `languages` DISABLE KEYS */; INSERT INTO `languages` VALUES (1,'en','English','English','en_app.json','en.json','en_web.json',0,'language/en.svg',NULL,NULL,NULL),(2,'uz','O\'zbek','Uzbek','uz_app.json','uz.json','uz_web.json',0,'language/699d6a175c5ba1.230718441771923991.png','2026-02-24 09:06:31','2026-03-07 09:54:25','+998'),(3,'ru','Русский','Russian','','','ru_web.json',0,'language/699d6a7433e699.383635631771924084.png','2026-02-24 09:08:04','2026-03-02 10:53:15','+998'); /*!40000 ALTER TABLE `languages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `migrations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'2019_12_14_000001_create_personal_access_tokens_table',1),(2,'2023_03_18_033231_create_users_table',1),(3,'2023_03_18_033352_create_password_resets_table',1),(4,'2023_03_18_033442_create_failed_jobs_table',1),(5,'2024_02_19_120210_create_permission_tables',1),(6,'2024_02_20_051429_v1.0.0',1),(7,'2024_04_09_095310_v1.0.1',1),(8,'2024_04_25_075053_v1.0.2',1),(9,'2024_05_31_080315_v1.1.0',1),(10,'2024_05_31_080315_v1.1.0_data_changes',1),(11,'2024_06_21_122400_v2.0.0',1),(12,'2024_07_03_061134_v2.1.0',1),(13,'2024_10_08_091408_update_seller_ratings_table',1),(14,'2024_10_09_085627_update_seller_ratings_table',1),(15,'2024_11_15_071656_update_users_table',1),(16,'2024_12_23_054350_v2.3.0',1),(17,'2025_02_07_081104_v.2.4.0',1),(18,'2025_04_11_154517_v.2.5.0',1),(19,'2025_06_11_122312_v.2.6.0',1),(20,'2025_08_27_125732_v.2.7.0',1),(21,'2025_10_16_150000_v2.8.0',1),(22,'2025_12_03_113259_v2.9.0',1),(23,'2026_01_22_073809_v2.10.0',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `model_has_permissions` -- DROP TABLE IF EXISTS `model_has_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `model_has_permissions` ( `permission_id` bigint unsigned NOT NULL, `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `model_id` bigint unsigned NOT NULL, PRIMARY KEY (`permission_id`,`model_id`,`model_type`), KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`), CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `model_has_permissions` -- LOCK TABLES `model_has_permissions` WRITE; /*!40000 ALTER TABLE `model_has_permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `model_has_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `model_has_roles` -- DROP TABLE IF EXISTS `model_has_roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `model_has_roles` ( `role_id` bigint unsigned NOT NULL, `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `model_id` bigint unsigned NOT NULL, PRIMARY KEY (`role_id`,`model_id`,`model_type`), KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`), CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `model_has_roles` -- LOCK TABLES `model_has_roles` WRITE; /*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */; INSERT INTO `model_has_roles` VALUES (2,'App\\Models\\User',1); /*!40000 ALTER TABLE `model_has_roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notifications` -- DROP TABLE IF EXISTS `notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `notifications` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `title` text COLLATE utf8mb4_unicode_ci NOT NULL, `message` text COLLATE utf8mb4_unicode_ci NOT NULL, `image` text COLLATE utf8mb4_unicode_ci NOT NULL, `item_id` bigint unsigned DEFAULT NULL, `send_to` enum('all','selected') COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `notifications_item_id_foreign` (`item_id`), CONSTRAINT `notifications_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notifications` -- LOCK TABLES `notifications` WRITE; /*!40000 ALTER TABLE `notifications` DISABLE KEYS */; /*!40000 ALTER TABLE `notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `number_otps` -- DROP TABLE IF EXISTS `number_otps`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `number_otps` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `country_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `otp` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `expire_at` timestamp NULL DEFAULT NULL, `attempts` tinyint unsigned NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `number_otps_number_unique` (`number`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `number_otps` -- LOCK TABLES `number_otps` WRITE; /*!40000 ALTER TABLE `number_otps` DISABLE KEYS */; /*!40000 ALTER TABLE `number_otps` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `package_categories` -- DROP TABLE IF EXISTS `package_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `package_categories` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `package_id` bigint unsigned NOT NULL, `category_id` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `package_categories_package_id_category_id_unique` (`package_id`,`category_id`), KEY `package_categories_category_id_foreign` (`category_id`), CONSTRAINT `package_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, CONSTRAINT `package_categories_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `package_categories` -- LOCK TABLES `package_categories` WRITE; /*!40000 ALTER TABLE `package_categories` DISABLE KEYS */; /*!40000 ALTER TABLE `package_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `package_translations` -- DROP TABLE IF EXISTS `package_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `package_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `package_id` bigint unsigned NOT NULL, `language_id` bigint unsigned NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `key_points` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `package_translations_package_id_language_id_unique` (`package_id`,`language_id`), KEY `package_translations_language_id_foreign` (`language_id`), CONSTRAINT `package_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE, CONSTRAINT `package_translations_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `package_translations` -- LOCK TABLES `package_translations` WRITE; /*!40000 ALTER TABLE `package_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `package_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `packages` -- DROP TABLE IF EXISTS `packages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `packages` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `final_price` double NOT NULL, `discount_in_percentage` double(8,2) NOT NULL DEFAULT '0.00', `price` double NOT NULL DEFAULT '0', `duration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `listing_duration_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `listing_duration_days` int DEFAULT NULL, `item_limit` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `is_global` tinyint NOT NULL DEFAULT '1', `icon` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `key_points` longtext COLLATE utf8mb4_unicode_ci, `status` tinyint NOT NULL DEFAULT '1', `ios_product_id` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `packages` -- LOCK TABLES `packages` WRITE; /*!40000 ALTER TABLE `packages` DISABLE KEYS */; /*!40000 ALTER TABLE `packages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `password_resets` ( `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `password_resets_email_index` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payment_configurations` -- DROP TABLE IF EXISTS `payment_configurations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `payment_configurations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `payment_method` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `api_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `secret_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `webhook_secret_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `currency_code` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0 - Disabled, 1 - Enabled', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `additional_data_1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `additional_data_2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `payment_mode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `username` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payment_configurations` -- LOCK TABLES `payment_configurations` WRITE; /*!40000 ALTER TABLE `payment_configurations` DISABLE KEYS */; /*!40000 ALTER TABLE `payment_configurations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payment_transactions` -- DROP TABLE IF EXISTS `payment_transactions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `payment_transactions` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `package_id` bigint unsigned DEFAULT NULL, `amount` double(8,2) NOT NULL, `payment_gateway` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, `order_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'order_id / payment_intent_id', `payment_status` enum('failed','succeed','pending','under review','rejected') COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `payment_receipt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `payment_transactions_payment_gateway_order_id_unique` (`payment_gateway`,`order_id`), KEY `payment_transactions_user_id_foreign` (`user_id`), KEY `payment_transactions_package_id_foreign` (`package_id`), CONSTRAINT `payment_transactions_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE, CONSTRAINT `payment_transactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payment_transactions` -- LOCK TABLES `payment_transactions` WRITE; /*!40000 ALTER TABLE `payment_transactions` DISABLE KEYS */; /*!40000 ALTER TABLE `payment_transactions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `permissions` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`) ) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permissions` -- LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; INSERT INTO `permissions` VALUES (1,'role-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(2,'role-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(3,'role-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(4,'role-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(5,'staff-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(6,'staff-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(7,'staff-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(8,'staff-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(9,'category-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(10,'category-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(11,'category-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(12,'category-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(13,'custom-field-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(14,'custom-field-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(15,'custom-field-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(16,'custom-field-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(17,'advertisement-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(18,'advertisement-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(19,'advertisement-listing-package-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(20,'advertisement-listing-package-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(21,'advertisement-listing-package-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(22,'advertisement-listing-package-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(23,'featured-advertisement-package-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(24,'featured-advertisement-package-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(25,'featured-advertisement-package-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(26,'featured-advertisement-package-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(27,'user-package-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(28,'payment-transactions-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(29,'slider-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(30,'slider-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(31,'slider-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(32,'feature-section-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(33,'feature-section-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(34,'feature-section-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(35,'feature-section-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(36,'report-reason-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(37,'report-reason-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(38,'report-reason-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(39,'report-reason-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(40,'user-reports-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(41,'notification-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(42,'notification-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(43,'notification-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(44,'notification-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(45,'customer-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(46,'customer-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(47,'settings-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(48,'tip-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(49,'tip-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(50,'tip-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(51,'tip-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(52,'blog-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(53,'blog-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(54,'blog-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(55,'blog-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(56,'currency-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(57,'currency-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(58,'currency-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(59,'currency-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(60,'country-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(61,'country-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(62,'country-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(63,'country-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(64,'state-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(65,'state-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(66,'state-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(67,'state-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(68,'city-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(69,'city-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(70,'city-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(71,'city-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(72,'area-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(73,'area-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(74,'area-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(75,'area-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(76,'faq-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(77,'faq-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(78,'faq-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(79,'faq-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(80,'seller-verification-field-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(81,'seller-verification-field-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(82,'seller-verification-field-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(83,'seller-verification-field-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(84,'seller-verification-request-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(85,'seller-verification-request-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(86,'seller-review-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(87,'seller-review-create','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(88,'seller-review-update','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(89,'seller-review-delete','web','2026-02-24 08:35:47','2026-02-24 08:35:47'),(90,'user-queries-list','web','2026-02-24 08:35:47','2026-02-24 08:35:47'); /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `personal_access_tokens` -- DROP TABLE IF EXISTS `personal_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `personal_access_tokens` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint unsigned NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `personal_access_tokens_token_unique` (`token`), KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `personal_access_tokens` -- LOCK TABLES `personal_access_tokens` WRITE; /*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `report_reason_translations` -- DROP TABLE IF EXISTS `report_reason_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `report_reason_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `report_reason_id` bigint unsigned NOT NULL, `language_id` bigint unsigned NOT NULL, `reason` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `report_reason_translations_report_reason_id_language_id_unique` (`report_reason_id`,`language_id`), KEY `report_reason_translations_language_id_foreign` (`language_id`), CONSTRAINT `report_reason_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE, CONSTRAINT `report_reason_translations_report_reason_id_foreign` FOREIGN KEY (`report_reason_id`) REFERENCES `report_reasons` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `report_reason_translations` -- LOCK TABLES `report_reason_translations` WRITE; /*!40000 ALTER TABLE `report_reason_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `report_reason_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `report_reasons` -- DROP TABLE IF EXISTS `report_reasons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `report_reasons` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `reason` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `report_reasons` -- LOCK TABLES `report_reasons` WRITE; /*!40000 ALTER TABLE `report_reasons` DISABLE KEYS */; /*!40000 ALTER TABLE `report_reasons` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role_has_permissions` -- DROP TABLE IF EXISTS `role_has_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `role_has_permissions` ( `permission_id` bigint unsigned NOT NULL, `role_id` bigint unsigned NOT NULL, PRIMARY KEY (`permission_id`,`role_id`), KEY `role_has_permissions_role_id_foreign` (`role_id`), CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE, CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role_has_permissions` -- LOCK TABLES `role_has_permissions` WRITE; /*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `role_has_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `roles` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `custom_role` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; INSERT INTO `roles` VALUES (1,'User','web',0,'2026-02-24 08:35:47','2026-02-24 08:35:47'),(2,'Super Admin','web',0,'2026-02-24 08:35:47','2026-02-24 08:35:47'); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `seller_ratings` -- DROP TABLE IF EXISTS `seller_ratings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `seller_ratings` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `seller_id` bigint unsigned NOT NULL, `buyer_id` bigint unsigned NOT NULL, `item_id` bigint unsigned NOT NULL, `review` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ratings` double(8,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `report_status` enum('reported','rejected','approved') COLLATE utf8mb4_unicode_ci DEFAULT NULL, `report_reason` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `report_rejected_reason` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `seller_ratings_item_id_buyer_id_unique` (`item_id`,`buyer_id`), KEY `seller_ratings_seller_id_foreign` (`seller_id`), KEY `seller_ratings_buyer_id_foreign` (`buyer_id`), CONSTRAINT `seller_ratings_buyer_id_foreign` FOREIGN KEY (`buyer_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, CONSTRAINT `seller_ratings_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE, CONSTRAINT `seller_ratings_seller_id_foreign` FOREIGN KEY (`seller_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `seller_ratings` -- LOCK TABLES `seller_ratings` WRITE; /*!40000 ALTER TABLE `seller_ratings` DISABLE KEYS */; /*!40000 ALTER TABLE `seller_ratings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `seo_settings` -- DROP TABLE IF EXISTS `seo_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `seo_settings` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `page` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `keywords` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `seo_settings` -- LOCK TABLES `seo_settings` WRITE; /*!40000 ALTER TABLE `seo_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `seo_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `seo_settings_translations` -- DROP TABLE IF EXISTS `seo_settings_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `seo_settings_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `keywords` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `seo_setting_id` bigint unsigned NOT NULL, `language_id` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `seo_setting_language_unique` (`seo_setting_id`,`language_id`), KEY `seo_settings_translations_language_id_foreign` (`language_id`), CONSTRAINT `seo_settings_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE, CONSTRAINT `seo_settings_translations_seo_setting_id_foreign` FOREIGN KEY (`seo_setting_id`) REFERENCES `seo_settings` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `seo_settings_translations` -- LOCK TABLES `seo_settings_translations` WRITE; /*!40000 ALTER TABLE `seo_settings_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `seo_settings_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `setting_translations` -- DROP TABLE IF EXISTS `setting_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `setting_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `setting_id` bigint unsigned NOT NULL, `language_id` bigint unsigned NOT NULL, `translated_value` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `setting_translations_setting_id_language_id_unique` (`setting_id`,`language_id`), KEY `setting_translations_language_id_foreign` (`language_id`), CONSTRAINT `setting_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE, CONSTRAINT `setting_translations_setting_id_foreign` FOREIGN KEY (`setting_id`) REFERENCES `settings` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `setting_translations` -- LOCK TABLES `setting_translations` WRITE; /*!40000 ALTER TABLE `setting_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `setting_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `settings` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `value` text COLLATE utf8mb4_unicode_ci, `type` enum('string','file') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'string', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `settings_name_unique` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=182 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings` -- LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; INSERT INTO `settings` VALUES (1,'banner_ad_id_android','','string',NULL,'2026-02-24 08:35:47'),(2,'banner_ad_id_ios','','string',NULL,'2026-02-24 08:35:47'),(3,'banner_ad_status','','string',NULL,'2026-02-24 08:35:47'),(4,'interstitial_ad_id_android','','string',NULL,'2026-02-24 08:35:47'),(5,'interstitial_ad_id_ios','','string',NULL,'2026-02-24 08:35:47'),(6,'interstitial_ad_status','','string',NULL,'2026-02-24 08:35:47'),(7,'currency_symbol','$','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(8,'ios_version','1.0.0','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(9,'default_language','uz','string','2026-02-24 08:35:47','2026-02-24 17:19:38'),(10,'force_update','0','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(11,'android_version','1.0.0','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(12,'number_with_suffix','0','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(13,'maintenance_mode','0','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(14,'privacy_policy','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(15,'contact_us','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(16,'terms_conditions','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(17,'about_us','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(18,'company_tel1','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(19,'company_tel2','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(20,'system_version','2.10.1','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(21,'company_email','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(22,'company_name','Eclassify','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(23,'company_logo','assets/images/logo/sidebar_logo.png','file','2026-02-24 08:35:47','2026-02-24 08:35:47'),(24,'favicon_icon','assets/images/logo/favicon.png','file','2026-02-24 08:35:47','2026-02-24 08:35:47'),(25,'login_image','assets/images/bg/login.jpg','file','2026-02-24 08:35:47','2026-02-24 08:35:47'),(26,'pinterest_link','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(27,'linkedin_link','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(28,'facebook_link','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(29,'x_link','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(30,'instagram_link','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(31,'google_map_iframe_link','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(32,'app_store_link','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(33,'play_store_link','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(34,'footer_description','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(35,'web_theme_color','#00B2CA','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(36,'firebase_project_id','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(37,'company_address','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(38,'place_api_key','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(39,'placeholder_image','assets/images/logo/placeholder.png','file','2026-02-24 08:35:47','2026-02-24 08:35:47'),(40,'header_logo','assets/images/logo/Header Logo.svg','file','2026-02-24 08:35:47','2026-02-24 08:35:47'),(41,'footer_logo','assets/images/logo/Footer Logo.svg','file','2026-02-24 08:35:47','2026-02-24 08:35:47'),(42,'default_latitude','-23.2420','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(43,'default_longitude','-69.6669','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(44,'file_manager','public','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(45,'show_landing_page','1','','2026-02-24 08:35:47','2026-02-24 08:35:47'),(46,'mobile_authentication','1','','2026-02-24 08:35:47','2026-02-24 08:35:47'),(47,'google_authentication','1','','2026-02-24 08:35:47','2026-02-24 08:35:47'),(48,'email_authentication','1','','2026-02-24 08:35:47','2026-02-24 08:35:47'),(49,'min_length','5','','2026-02-24 08:35:47','2026-02-24 08:35:47'),(50,'max_length','100','','2026-02-24 08:35:47','2026-02-24 08:35:47'),(51,'currency_symbol_position','left','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(52,'free_ad_listing','0','','2026-02-24 08:35:47','2026-02-24 08:35:47'),(53,'auto_approve_item','0','','2026-02-24 08:35:47','2026-02-24 08:35:47'),(54,'auto_approve_edited_item','0','','2026-02-24 08:35:47','2026-02-24 08:35:47'),(55,'mail_mailer','smtp','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(56,'mail_host','mailhog','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(57,'mail_port','1025','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(58,'mail_username','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(59,'mail_password','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(60,'mail_encryption','tls','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(61,'mail_from_address','hello@example.com','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(62,'depp_link_scheme','eclassify','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(63,'otp_service_provider','firebase','string','2026-02-24 08:35:47','2026-03-07 10:10:27'),(64,'account_holder_name','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(65,'bank_name','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(66,'account_number','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(67,'ifsc_swift_code','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(68,'twilio_account_sid',NULL,'string','2026-02-24 08:35:47','2026-03-07 10:10:27'),(69,'twilio_auth_token',NULL,'string','2026-02-24 08:35:47','2026-03-07 10:10:27'),(70,'twilio_my_phone_number',NULL,'string','2026-02-24 08:35:47','2026-03-07 10:10:27'),(71,'map_provider','free_api','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(72,'refund_policy','','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(73,'free_ad_unlimited','1','','2026-02-24 08:35:47','2026-02-24 08:35:47'),(74,'watermark_enabled','0','','2026-02-24 08:35:47','2026-02-24 08:35:47'),(75,'watermark_image','','file','2026-02-24 08:35:47','2026-02-24 08:35:47'),(76,'watermark_opacity','50','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(77,'watermark_size','20','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(78,'watermark_style','single','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(79,'watermark_position','center','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(80,'watermark_rotation','-30','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(81,'currency_iso_code','USD','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(82,'decimal_places','2','','2026-02-24 08:35:47','2026-02-24 08:35:47'),(83,'thousand_separator',',','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(84,'decimal_separator','.','string','2026-02-24 08:35:47','2026-02-24 08:35:47'),(177,'free_ad_duration_days','unlimited','string','2026-03-07 10:10:27','2026-03-07 10:10:27'); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sliders` -- DROP TABLE IF EXISTS `sliders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sliders` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `country_id` bigint unsigned DEFAULT NULL, `state_id` bigint unsigned DEFAULT NULL, `city_id` bigint unsigned DEFAULT NULL, `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `sequence` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `third_party_link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `model_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `model_id` bigint unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `sliders_model_type_model_id_index` (`model_type`,`model_id`), KEY `sliders_country_id_foreign` (`country_id`), KEY `sliders_state_id_foreign` (`state_id`), KEY `sliders_city_id_foreign` (`city_id`), CONSTRAINT `sliders_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE SET NULL, CONSTRAINT `sliders_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE SET NULL, CONSTRAINT `sliders_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sliders` -- LOCK TABLES `sliders` WRITE; /*!40000 ALTER TABLE `sliders` DISABLE KEYS */; /*!40000 ALTER TABLE `sliders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `social_logins` -- DROP TABLE IF EXISTS `social_logins`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `social_logins` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `firebase_id` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL, `type` enum('google','email','phone','apple') COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `social_logins_user_id_type_unique` (`user_id`,`type`), CONSTRAINT `social_logins_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `social_logins` -- LOCK TABLES `social_logins` WRITE; /*!40000 ALTER TABLE `social_logins` DISABLE KEYS */; /*!40000 ALTER TABLE `social_logins` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `state_translations` -- DROP TABLE IF EXISTS `state_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `state_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `state_id` bigint unsigned NOT NULL, `language_id` bigint unsigned NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `state_translations_state_id_language_id_unique` (`state_id`,`language_id`), KEY `state_translations_language_id_foreign` (`language_id`), CONSTRAINT `state_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE, CONSTRAINT `state_translations_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `state_translations` -- LOCK TABLES `state_translations` WRITE; /*!40000 ALTER TABLE `state_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `state_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `states` -- DROP TABLE IF EXISTS `states`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `states` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `country_id` bigint unsigned NOT NULL, `state_code` char(2) COLLATE utf8mb4_unicode_ci NOT NULL, `fips_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `iso2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `latitude` decimal(8,2) DEFAULT NULL, `longitude` decimal(8,2) DEFAULT NULL, `flag` tinyint(1) DEFAULT NULL, `wikiDataId` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `states_country_id_foreign` (`country_id`), CONSTRAINT `states_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2550 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `states` -- LOCK TABLES `states` WRITE; /*!40000 ALTER TABLE `states` DISABLE KEYS */; INSERT INTO `states` VALUES (2536,'Tashkent',236,'TK',NULL,NULL,NULL,41.30,69.24,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(2537,'Namangan Region',236,'NG',NULL,NULL,NULL,41.05,71.10,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(2538,'Fergana Region',236,'FA',NULL,NULL,NULL,40.46,71.29,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(2539,'Xorazm Region',236,'XO',NULL,NULL,NULL,41.36,60.86,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(2540,'Andijan Region',236,'AN',NULL,NULL,NULL,40.77,72.24,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(2541,'Bukhara Region',236,'BU',NULL,NULL,NULL,40.25,63.20,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(2542,'Navoiy Region',236,'NW',NULL,NULL,NULL,42.70,64.63,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(2543,'Qashqadaryo Region',236,'QA',NULL,NULL,NULL,38.90,66.05,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(2544,'Samarqand Region',236,'SA',NULL,NULL,NULL,39.63,66.97,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(2545,'Jizzakh Region',236,'JI',NULL,NULL,NULL,40.47,67.57,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(2546,'Surxondaryo Region',236,'SU',NULL,NULL,NULL,37.94,67.57,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(2547,'Sirdaryo Region',236,'SI',NULL,NULL,NULL,40.39,68.72,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(2548,'Karakalpakstan',236,'QR',NULL,NULL,NULL,43.80,59.45,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'),(2549,'Tashkent Region',236,'TO',NULL,NULL,NULL,41.22,69.86,NULL,NULL,'2026-03-07 09:12:30','2026-03-07 09:12:30'); /*!40000 ALTER TABLE `states` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tip_translations` -- DROP TABLE IF EXISTS `tip_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tip_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tip_id` bigint unsigned NOT NULL, `language_id` bigint unsigned NOT NULL, `description` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `tip_translations_tip_id_language_id_unique` (`tip_id`,`language_id`), KEY `tip_translations_language_id_foreign` (`language_id`), CONSTRAINT `tip_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE, CONSTRAINT `tip_translations_tip_id_foreign` FOREIGN KEY (`tip_id`) REFERENCES `tips` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tip_translations` -- LOCK TABLES `tip_translations` WRITE; /*!40000 ALTER TABLE `tip_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `tip_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tips` -- DROP TABLE IF EXISTS `tips`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tips` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `description` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL, `sequence` int NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tips` -- LOCK TABLES `tips` WRITE; /*!40000 ALTER TABLE `tips` DISABLE KEYS */; /*!40000 ALTER TABLE `tips` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_fcm_tokens` -- DROP TABLE IF EXISTS `user_fcm_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_fcm_tokens` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `fcm_token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `platform_type` enum('Android','iOS') COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_fcm_tokens_fcm_token_unique` (`fcm_token`), KEY `user_fcm_tokens_user_id_foreign` (`user_id`), CONSTRAINT `user_fcm_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_fcm_tokens` -- LOCK TABLES `user_fcm_tokens` WRITE; /*!40000 ALTER TABLE `user_fcm_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `user_fcm_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_purchased_packages` -- DROP TABLE IF EXISTS `user_purchased_packages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_purchased_packages` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `package_id` bigint unsigned NOT NULL, `start_date` date NOT NULL, `end_date` date DEFAULT NULL, `total_limit` int DEFAULT NULL, `used_limit` int NOT NULL DEFAULT '0', `payment_transactions_id` bigint unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `listing_duration_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `listing_duration_days` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_purchased_packages_user_id_foreign` (`user_id`), KEY `user_purchased_packages_package_id_foreign` (`package_id`), KEY `user_purchased_packages_payment_transactions_id_foreign` (`payment_transactions_id`), CONSTRAINT `user_purchased_packages_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE, CONSTRAINT `user_purchased_packages_payment_transactions_id_foreign` FOREIGN KEY (`payment_transactions_id`) REFERENCES `payment_transactions` (`id`) ON DELETE CASCADE, CONSTRAINT `user_purchased_packages_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_purchased_packages` -- LOCK TABLES `user_purchased_packages` WRITE; /*!40000 ALTER TABLE `user_purchased_packages` DISABLE KEYS */; /*!40000 ALTER TABLE `user_purchased_packages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_reports` -- DROP TABLE IF EXISTS `user_reports`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_reports` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `report_reason_id` bigint unsigned DEFAULT NULL, `user_id` bigint unsigned NOT NULL, `item_id` bigint unsigned NOT NULL, `other_message` longtext COLLATE utf8mb4_unicode_ci, `reason` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_reports_report_reason_id_foreign` (`report_reason_id`), KEY `user_reports_user_id_foreign` (`user_id`), KEY `user_reports_item_id_foreign` (`item_id`), CONSTRAINT `user_reports_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE, CONSTRAINT `user_reports_report_reason_id_foreign` FOREIGN KEY (`report_reason_id`) REFERENCES `report_reasons` (`id`) ON DELETE CASCADE, CONSTRAINT `user_reports_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_reports` -- LOCK TABLES `user_reports` WRITE; /*!40000 ALTER TABLE `user_reports` DISABLE KEYS */; /*!40000 ALTER TABLE `user_reports` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `mobile` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `profile` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'remove in next update', `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `fcm_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'remove this in next update', `notification` tinyint(1) NOT NULL DEFAULT '1', `firebase_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'remove in next update', `address` text COLLATE utf8mb4_unicode_ci, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `country_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `region_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `show_personal_details` tinyint(1) NOT NULL DEFAULT '1', `is_verified` tinyint(1) NOT NULL DEFAULT '0', `auto_approve_item` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `users_firebase_id_type_unique` (`firebase_id`,`type`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'admin','admin@gmail.com',NULL,NULL,NULL,NULL,'$2y$10$7jEE5IfD8A0qCJMnGYOps.ajtnEn3E2Cy.yi9UnqAL/ldT7INjbhi','',1,NULL,NULL,NULL,'2026-02-24 08:35:47','2026-02-24 08:35:47',NULL,NULL,NULL,1,0,0); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `verification_field_values` -- DROP TABLE IF EXISTS `verification_field_values`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `verification_field_values` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `verification_field_id` bigint unsigned NOT NULL, `value` text COLLATE utf8mb4_unicode_ci, `user_id` bigint unsigned NOT NULL, `verification_request_id` bigint unsigned NOT NULL, `language_id` bigint unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_field_language_unique` (`user_id`,`verification_field_id`,`language_id`), KEY `verification_field_values_verification_request_id_foreign` (`verification_request_id`), KEY `verification_field_values_verification_field_id_foreign` (`verification_field_id`), KEY `verification_field_values_language_id_foreign` (`language_id`), CONSTRAINT `verification_field_values_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE, CONSTRAINT `verification_field_values_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, CONSTRAINT `verification_field_values_verification_field_id_foreign` FOREIGN KEY (`verification_field_id`) REFERENCES `verification_fields` (`id`) ON DELETE CASCADE, CONSTRAINT `verification_field_values_verification_request_id_foreign` FOREIGN KEY (`verification_request_id`) REFERENCES `verification_requests` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `verification_field_values` -- LOCK TABLES `verification_field_values` WRITE; /*!40000 ALTER TABLE `verification_field_values` DISABLE KEYS */; /*!40000 ALTER TABLE `verification_field_values` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `verification_fields` -- DROP TABLE IF EXISTS `verification_fields`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `verification_fields` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `values` text COLLATE utf8mb4_unicode_ci, `min_length` int DEFAULT NULL, `max_length` int DEFAULT NULL, `status` enum('review','approved','rejected','sold out','featured') COLLATE utf8mb4_unicode_ci NOT NULL, `is_required` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `verification_fields` -- LOCK TABLES `verification_fields` WRITE; /*!40000 ALTER TABLE `verification_fields` DISABLE KEYS */; INSERT INTO `verification_fields` VALUES (1,'OTP','number',NULL,1,4,'review',0,'2026-03-07 10:24:54','2026-03-07 10:24:54',NULL); /*!40000 ALTER TABLE `verification_fields` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `verification_fields_translations` -- DROP TABLE IF EXISTS `verification_fields_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `verification_fields_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `verification_field_id` bigint unsigned NOT NULL, `language_id` bigint unsigned NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `value` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `verification_language_unique` (`verification_field_id`,`language_id`), KEY `verification_fields_translations_language_id_foreign` (`language_id`), CONSTRAINT `verification_fields_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE, CONSTRAINT `verification_fields_translations_verification_field_id_foreign` FOREIGN KEY (`verification_field_id`) REFERENCES `verification_fields` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `verification_fields_translations` -- LOCK TABLES `verification_fields_translations` WRITE; /*!40000 ALTER TABLE `verification_fields_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `verification_fields_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `verification_requests` -- DROP TABLE IF EXISTS `verification_requests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `verification_requests` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `status` enum('pending','approved','rejected','resubmitted') COLLATE utf8mb4_unicode_ci NOT NULL, `rejection_reason` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `verification_requests_user_id_foreign` (`user_id`), CONSTRAINT `verification_requests_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `verification_requests` -- LOCK TABLES `verification_requests` WRITE; /*!40000 ALTER TABLE `verification_requests` DISABLE KEYS */; /*!40000 ALTER TABLE `verification_requests` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-03-28 17:00:57