--
-- Host: localhost    Database: topappkw_realstat
-- ------------------------------------------------------


--
-- Table structure for table `ads`
--

CREATE TABLE `ads` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `status` enum('0','1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `area_id` bigint unsigned DEFAULT NULL,
  `service_id` bigint unsigned DEFAULT NULL,
  `type_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `marketed_id` bigint unsigned DEFAULT NULL,
  `price` double NOT NULL DEFAULT '0',
  `price_type` int NOT NULL DEFAULT '0',
  `number_of_apartments` int NOT NULL DEFAULT '0',
  `all_area` int NOT NULL DEFAULT '0',
  `lat` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `long` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `coverage` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `room` int NOT NULL DEFAULT '0',
  `hall` int NOT NULL DEFAULT '0',
  `bathroom` int NOT NULL DEFAULT '0',
  `interface` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `car_entrance` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `driver_room` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `maid_room` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `swimming_pool` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `kitchen` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `inner_staircase` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `appendix` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `furnished` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `property_age` int NOT NULL DEFAULT '0',
  `street_view` int NOT NULL DEFAULT '0',
  `determine_area` int NOT NULL DEFAULT '0',
  `office_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `office_num` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `office_reach` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `des` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `featured` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `administration` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `featured_ad` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `featured_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `count_view` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `package_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ads_area_id_foreign` (`area_id`),
  KEY `ads_service_id_foreign` (`service_id`),
  KEY `ads_type_id_foreign` (`type_id`),
  KEY `ads_user_id_foreign` (`user_id`),
  KEY `ads_marketed_id_foreign` (`marketed_id`),
  CONSTRAINT `ads_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ads_marketed_id_foreign` FOREIGN KEY (`marketed_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ads_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ads_type_id_foreign` FOREIGN KEY (`type_id`) REFERENCES `types` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ads_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ads`
--

INSERT INTO `ads` (`id`, `status`, `area_id`, `service_id`, `type_id`, `user_id`, `marketed_id`, `price`, `price_type`, `number_of_apartments`, `all_area`, `lat`, `long`, `bank`, `coverage`, `room`, `hall`, `bathroom`, `interface`, `car_entrance`, `driver_room`, `maid_room`, `swimming_pool`, `kitchen`, `inner_staircase`, `appendix`, `furnished`, `property_age`, `street_view`, `determine_area`, `office_name`, `office_num`, `office_reach`, `des`, `featured`, `administration`, `featured_ad`, `featured_type`, `count_view`, `created_at`, `updated_at`, `package_id`) VALUES (20,'1',1,1,1,34,9,22,1,2,0,'21.183925123459012','39.3518065578125','1','22',3,3,0,'3','1','1','1','1','1','1','1','0',3,3,3,'3','33','67782374','فيلا الرياض موقع مميز','1','1','0',NULL,202,'2022-04-03 21:01:58','2023-08-28 21:35:53',1),(22,'1',1,1,1,31,9,345,1,2,0,'21.485811','39.19250479999999','1','22',3,3,0,'3','1','1','1','1','1','1','1','1',3,3,3,'3','33','67782374','للايجار ارض في السالمية\r\nمساحة ١٩٩٢ متر\r\nتصلح نشاط ملاعب\r\nفترة سماح ٦ شهور','1','1','1',NULL,222,'2022-04-03 21:10:50','2023-12-04 08:53:04',1),(24,'1',1,1,1,31,9,80,1,2,0,'21.89351136274632','39.38648215595703','1','22',3,3,0,'3','1','1','1','1','1','1','1','1',33,33,33,'33','3','3','للايجار شقه دلكس في القادسية من المالك مباشر، صاله كبيرة، ٣ غرف نوم، ١ ماستر، اثنين بينهم حمام، غرفة خاد مه، بالدور الثاني (الاخير) مصعد، مواقف اثنين مضلله','1','1','1',NULL,260,'2022-04-05 05:31:52','2023-12-15 00:48:50',1),(25,'1',1,1,1,34,9,80,1,2,0,'21.5542975','39.2928329','0','22',3,3,0,'3','1','1','1','1','1','1','1','1',33,33,33,'33','3','3','للايجار شقه دلكس في القادسية من المالك مباشر، صاله كبيرة، ٣ غرف نوم، ١ ماستر، اثنين بينهم حمام، غرفة خاد مه، بالدور الثاني (الاخير) مصعد، مواقف اثنين مضلله','1','1','0',NULL,39,'2022-04-05 05:35:16','2023-07-26 20:56:22',1),(26,'1',1,1,1,34,28,88,1,2,0,'21.529571076700687','39.27215567890625','0','22',3,3,0,'3','1','1','1','1','1','1','1','1',33,33,33,'33','3','3','للايجار ارض في السالمية\r\nمساحة ١٩٩٢ متر\r\nتصلح نشاط ملاعب\r\nفترة سماح ٦ شهور','1','1','0',NULL,73,'2022-04-05 06:10:19','2023-09-16 07:31:05',1),(27,'1',1,1,1,34,9,75,1,2,0,'21.485811','39.19250479999999','0','22',3,3,0,'3','1','1','1','1','1','1','1','1',33,33,33,'33','3','3','للايجار ارض في السالمية\r\nمساحة ١٩٩٢ متر\r\nتصلح نشاط ملاعب\r\nفترة سماح ٦ شهور','1','1','0',NULL,87,'2022-04-05 06:15:54','2023-09-16 07:30:42',1),(28,'1',1,1,1,34,33,34,1,2,0,'21.4022801','39.4628528','0','22',3,3,0,'3','1','1','1','1','1','1','1','1',33,33,33,'33','3','3','للايجار ارض في السالمية\r\nمساحة ١٩٩٢ متر\r\nتصلح نشاط ملاعب\r\nفترة سماح ٦ شهور','1','1','1',NULL,222,'2022-04-05 06:27:50','2023-09-08 16:18:34',1),(29,'1',8,1,1,34,9,23,1,2,0,'21.3890824','39.8579118','0','22',3,3,0,'3','1','1','1','1','1','1','1','1',33,33,33,'33','3','3','للايجار ارض في السالمية\r\nمساحة ١٩٩٢ متر\r\nتصلح نشاط ملاعب\r\nفترة سماح ٦ شهور','1','1','0',NULL,51,'2022-04-05 06:32:25','2023-09-02 07:00:32',1),(30,'1',9,1,1,34,10,40,1,2,0,'21.485811','39.19250479999999','0','22',3,3,0,'3','1','1','1','1','1','1','1','1',33,33,33,'33','3','3','للايجار ارض في السالمية\r\nمساحة ١٩٩٢ متر\r\nتصلح نشاط ملاعب\r\nفترة سماح ٦ شهور','1','1','1',NULL,126,'2022-04-05 06:51:31','2023-08-14 00:59:52',1),(31,'1',9,1,1,31,9,23,1,2,0,'21.485811','39.19250479999999','0','22',3,3,0,'3','1','1','0','1','1','1','0','1',33,33,33,'33','3','3','للايجار ارض في السالمية\r\nمساحة ١٩٩٢ متر\r\nتصلح نشاط ملاعب\r\nفترة سماح ٦ شهور','1','1','0',NULL,52,'2022-04-05 06:57:13','2023-07-21 15:18:58',1);

--
-- Table structure for table `area_translations`
--

CREATE TABLE `area_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `area_id` bigint unsigned NOT NULL,
  `locale` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 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_locale_unique` (`area_id`,`locale`),
  KEY `area_translations_locale_index` (`locale`),
  CONSTRAINT `area_translations_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `area_translations`
--

INSERT INTO `area_translations` (`id`, `area_id`, `locale`, `name`, `created_at`, `updated_at`) VALUES (1,1,'en','Riyadh',NULL,NULL),(2,1,'ar','الرياض',NULL,NULL),(3,2,'en','الدرعية',NULL,NULL),(4,2,'ar','الدرعية',NULL,NULL),(5,3,'en','الخرج',NULL,NULL),(6,3,'ar','الخرج',NULL,NULL),(7,4,'en','الدوادمي',NULL,NULL),(8,4,'ar','الدوادمي',NULL,NULL),(9,5,'en','المجمعة',NULL,NULL),(10,5,'ar','المجمعة',NULL,NULL),(11,6,'en','القويعية',NULL,NULL),(12,6,'ar','القويعية',NULL,NULL),(13,7,'en','الأفلاج',NULL,NULL),(14,7,'ar','الأفلاج',NULL,NULL),(15,8,'en','مكة المكرمة',NULL,NULL),(16,8,'ar','مكة المكرمة',NULL,NULL),(17,9,'en','جدة',NULL,NULL),(18,9,'ar','جدة',NULL,NULL),(19,10,'en','الطائف',NULL,NULL),(20,10,'ar','الطائف',NULL,NULL),(21,11,'en','القنفذة',NULL,NULL),(22,11,'ar','القنفذة',NULL,NULL),(23,12,'en','الليث',NULL,NULL),(24,12,'ar','الليث',NULL,NULL),(25,13,'en','رابغ',NULL,NULL),(26,13,'ar','رابغ',NULL,NULL),(27,14,'en','خليص',NULL,NULL),(28,14,'ar','خليص',NULL,NULL),(29,15,'en','ينبع',NULL,NULL),(30,15,'ar','ينبع',NULL,NULL),(31,16,'en','العلا',NULL,NULL),(32,16,'ar','العلا',NULL,NULL),(33,17,'en','المهد',NULL,NULL),(34,17,'ar','المهد',NULL,NULL),(35,18,'en','الحناكية',NULL,NULL),(36,18,'ar','الحناكية',NULL,NULL),(37,19,'en','بريدة',NULL,NULL),(38,19,'ar','بريدة',NULL,NULL),(39,20,'en','عنيزة',NULL,NULL),(40,20,'ar','عنيزة',NULL,NULL),(41,21,'en','الرس',NULL,NULL),(42,21,'ar','الرس',NULL,NULL),(43,22,'en','المذنب',NULL,NULL),(44,22,'ar','المذنب',NULL,NULL),(45,23,'en','الأحساء',NULL,NULL),(46,23,'ar','الأحساء',NULL,NULL),(47,24,'en','حفر الباطن',NULL,NULL),(48,24,'ar','حفر الباطن',NULL,NULL),(49,25,'en','الجبيل',NULL,NULL),(50,25,'ar','الجبيل',NULL,NULL),(51,26,'en','خميس مشيط',NULL,NULL),(52,26,'ar','خميس مشيط',NULL,NULL),(53,27,'en','بيشة',NULL,NULL),(54,27,'ar','بيشة',NULL,NULL),(55,28,'en','النماص',NULL,NULL),(56,28,'ar','النماص',NULL,NULL),(57,29,'en','ظهران الجنوب',NULL,NULL),(58,29,'ar','ظهران الجنوب',NULL,NULL),(59,30,'en','الوجه',NULL,NULL),(60,30,'ar','الوجه',NULL,NULL),(61,31,'en','ضباء',NULL,NULL),(62,31,'ar','ضباء',NULL,NULL),(63,32,'en','تيماء',NULL,NULL),(64,32,'ar','تيماء',NULL,NULL),(65,33,'en','البدع',NULL,NULL),(66,33,'ar','البدع',NULL,NULL),(67,34,'en','صبيا',NULL,NULL),(68,34,'ar','صبيا',NULL,NULL),(69,35,'en','صامطة',NULL,NULL),(70,35,'ar','صامطة',NULL,NULL),(71,36,'en','شرورة',NULL,NULL),(72,36,'ar','شرورة',NULL,NULL);

--
-- Table structure for table `areas`
--

CREATE TABLE `areas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `city_id` bigint unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `areas_city_id_foreign` (`city_id`),
  CONSTRAINT `areas_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `areas`
--

INSERT INTO `areas` (`id`, `city_id`, `deleted_at`, `created_at`, `updated_at`) VALUES (1,1,NULL,'2022-04-03 06:42:33','2022-04-03 06:42:33'),(2,1,NULL,'2022-04-05 06:34:30','2022-04-05 06:34:30'),(3,1,NULL,'2022-04-05 06:34:41','2022-04-05 06:34:41'),(4,1,NULL,'2022-04-05 06:34:53','2022-04-05 06:34:53'),(5,1,NULL,'2022-04-05 06:35:03','2022-04-05 06:35:03'),(6,1,NULL,'2022-04-05 06:35:13','2022-04-05 06:35:13'),(7,1,NULL,'2022-04-05 06:35:22','2022-04-05 06:35:22'),(8,2,NULL,'2022-04-05 06:35:51','2022-04-05 06:35:51'),(9,2,NULL,'2022-04-05 06:36:04','2022-04-05 06:36:04'),(10,2,NULL,'2022-04-05 06:36:16','2022-04-05 06:36:16'),(11,2,NULL,'2022-04-05 06:36:25','2022-04-05 06:36:25'),(12,2,NULL,'2022-04-05 06:36:36','2022-04-05 06:36:36'),(13,2,NULL,'2022-04-05 06:36:46','2022-04-05 06:36:46'),(14,2,NULL,'2022-04-05 06:36:56','2022-04-05 06:36:56'),(15,3,NULL,'2022-04-05 06:37:13','2022-04-05 06:37:13'),(16,3,NULL,'2022-04-05 06:37:27','2022-04-05 06:37:27'),(17,3,NULL,'2022-04-05 06:37:38','2022-04-05 06:37:38'),(18,3,NULL,'2022-04-05 06:37:52','2022-04-05 06:37:52'),(19,4,NULL,'2022-04-05 06:38:08','2022-04-05 06:38:08'),(20,4,NULL,'2022-04-05 06:38:21','2022-04-05 06:38:21'),(21,3,NULL,'2022-04-05 06:38:30','2022-04-05 06:38:30'),(22,4,NULL,'2022-04-05 06:38:41','2022-04-05 06:38:41'),(23,5,NULL,'2022-04-05 06:44:12','2022-04-05 06:44:12'),(24,5,NULL,'2022-04-05 06:44:23','2022-04-05 06:44:23'),(25,5,NULL,'2022-04-05 06:44:33','2022-04-05 06:44:33'),(26,6,NULL,'2022-04-05 06:45:05','2022-04-05 06:45:05'),(27,6,NULL,'2022-04-05 06:45:13','2022-04-05 06:45:13'),(28,6,NULL,'2022-04-05 06:45:22','2022-04-05 06:45:22'),(29,6,NULL,'2022-04-05 06:45:31','2022-04-05 06:45:31'),(30,7,NULL,'2022-04-05 06:45:47','2022-04-05 06:45:47'),(31,7,NULL,'2022-04-05 06:45:58','2022-04-05 06:45:58'),(32,7,NULL,'2022-04-05 06:46:12','2022-04-05 06:46:12'),(33,7,NULL,'2022-04-05 06:46:25','2022-04-05 06:46:25'),(34,8,NULL,'2022-04-05 06:46:44','2022-04-05 06:46:44'),(35,8,NULL,'2022-04-05 06:46:53','2022-04-05 06:46:53'),(36,9,NULL,'2022-04-05 06:47:09','2022-04-05 06:47:09');

--
-- Table structure for table `auction_users`
--

CREATE TABLE `auction_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `status` enum('1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '2',
  `user_id` bigint unsigned NOT NULL,
  `auction_id` bigint unsigned NOT NULL,
  `price` double NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `auction_users_user_id_foreign` (`user_id`),
  KEY `auction_users_auction_id_foreign` (`auction_id`),
  CONSTRAINT `auction_users_auction_id_foreign` FOREIGN KEY (`auction_id`) REFERENCES `auctions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `auction_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `auction_users`
--

INSERT INTO `auction_users` (`id`, `status`, `user_id`, `auction_id`, `price`, `created_at`, `updated_at`) VALUES (13,'2',39,8,4000,'2022-05-17 08:26:01','2022-05-17 08:26:01'),(14,'2',39,8,8000,'2022-05-17 08:55:03','2022-05-17 08:55:03'),(15,'2',39,8,17008,'2022-05-17 09:17:21','2022-05-17 09:17:21'),(16,'2',40,8,25000,'2022-05-17 10:16:35','2022-05-17 10:16:35'),(17,'2',39,8,35000,'2022-05-17 10:16:57','2022-05-17 10:16:57'),(18,'2',40,8,45000,'2022-05-17 10:17:21','2022-05-17 10:17:21'),(19,'2',40,8,55000,'2022-05-17 10:18:11','2022-05-17 10:18:11'),(20,'2',39,8,65000,'2022-05-17 10:18:29','2022-05-17 10:18:29'),(21,'2',41,8,75000,'2022-05-17 10:42:12','2022-05-17 10:42:12'),(22,'2',43,8,950000,'2022-05-17 21:53:03','2022-05-17 21:53:03');

--
-- Table structure for table `auctions`
--

CREATE TABLE `auctions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `status` enum('1','2','3') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `min_price` double NOT NULL DEFAULT '0',
  `ad_id` bigint unsigned DEFAULT NULL,
  `start_date` timestamp NULL DEFAULT NULL,
  `end_date` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `auctions_ad_id_foreign` (`ad_id`),
  CONSTRAINT `auctions_ad_id_foreign` FOREIGN KEY (`ad_id`) REFERENCES `ads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `auctions`
--

INSERT INTO `auctions` (`id`, `status`, `min_price`, `ad_id`, `start_date`, `end_date`, `created_at`, `updated_at`) VALUES (8,'2',3444,28,'2022-05-17 07:44:00','2022-05-18 07:44:00','2022-05-17 04:44:25','2022-05-17 04:44:25');

--
-- Table structure for table `chats`
--

CREATE TABLE `chats` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sender_id` bigint NOT NULL,
  `sender_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `chats`
--

INSERT INTO `chats` (`id`, `sender_id`, `sender_name`, `message`, `created_at`, `updated_at`) VALUES (3,9,'abdelaziz elkholy','new test','2022-02-11 06:09:00','2022-02-11 06:09:00'),(5,10,'marketer no.1','test','2022-02-11 06:11:30','2022-02-11 06:11:30');

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `lat` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `long` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`id`, `lat`, `long`, `deleted_at`, `created_at`, `updated_at`) VALUES (1,'24.774265','46.738586',NULL,'2022-04-03 06:38:53','2022-04-03 06:38:53'),(2,'46.73858','31°15\'23.4',NULL,'2022-04-05 05:54:22','2022-04-05 05:58:52'),(3,'29°55\'52.4','31°15\'23.4',NULL,'2022-04-05 05:54:41','2022-04-05 05:54:41'),(4,'21.487979','31°15\'23.4',NULL,'2022-04-05 05:54:57','2022-04-05 05:54:57'),(5,'29°55\'52.4','31°15\'23.4',NULL,'2022-04-05 05:55:23','2022-04-05 05:55:23'),(6,'29°55\'52.4','39.191238',NULL,'2022-04-05 05:55:42','2022-04-05 05:55:42'),(7,'29°55\'52.4','31°15\'23.4',NULL,'2022-04-05 05:56:05','2022-04-05 05:56:05'),(8,'29°55\'52.4','39.191238',NULL,'2022-04-05 05:56:47','2022-04-05 05:56:47'),(9,'29°55\'52.4','39.191238',NULL,'2022-04-05 05:57:04','2022-04-05 05:57:04');

--
-- Table structure for table `city_translations`
--

CREATE TABLE `city_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `city_id` bigint unsigned NOT NULL,
  `locale` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 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_locale_unique` (`city_id`,`locale`),
  KEY `city_translations_locale_index` (`locale`),
  CONSTRAINT `city_translations_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `city_translations`
--

INSERT INTO `city_translations` (`id`, `city_id`, `locale`, `name`, `created_at`, `updated_at`) VALUES (1,1,'en','Riyadh',NULL,NULL),(2,1,'ar','الرياض',NULL,NULL),(3,2,'en','منطقة مكة المكرمة',NULL,NULL),(4,2,'ar','منطقة مكة المكرمة',NULL,NULL),(5,3,'en','منطقة المدينة المنورة',NULL,NULL),(6,3,'ar','منطقة المدينة المنورة',NULL,NULL),(7,4,'en','منطقة القصيم',NULL,NULL),(8,4,'ar','منطقة القصيم',NULL,NULL),(9,5,'en','المنطقة الشرقية',NULL,NULL),(10,5,'ar','المنطقة الشرقية',NULL,NULL),(11,6,'en','منطقة عسير',NULL,NULL),(12,6,'ar','منطقة عسير',NULL,NULL),(13,7,'en','منطقة تبوك',NULL,NULL),(14,7,'ar','منطقة تبوك',NULL,NULL),(15,8,'en','منطقة جازان',NULL,NULL),(16,8,'ar','منطقة جازان',NULL,NULL),(17,9,'en','منطقة نجران',NULL,NULL),(18,9,'ar','منطقة نجران',NULL,NULL);

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

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 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;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `favourites`
--

CREATE TABLE `favourites` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `ad_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `favourites_user_id_foreign` (`user_id`),
  KEY `favourites_ad_id_foreign` (`ad_id`),
  CONSTRAINT `favourites_ad_id_foreign` FOREIGN KEY (`ad_id`) REFERENCES `ads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `favourites_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `favourites`
--

INSERT INTO `favourites` (`id`, `user_id`, `ad_id`, `created_at`, `updated_at`) VALUES (2,28,27,'2022-04-06 09:10:23','2022-04-06 09:10:23'),(3,28,26,'2022-04-06 09:10:28','2022-04-06 09:10:28'),(4,28,26,'2022-04-06 09:12:40','2022-04-06 09:12:40'),(5,28,27,'2022-04-06 09:13:41','2022-04-06 09:13:41'),(6,33,27,'2022-04-06 09:13:50','2022-04-06 09:13:50'),(12,32,27,'2022-04-06 09:45:26','2022-04-06 09:45:26'),(13,32,26,'2022-04-06 09:45:27','2022-04-06 09:45:27'),(14,37,28,'2022-04-11 06:50:56','2022-04-11 06:50:56'),(15,37,30,'2022-04-11 06:54:39','2022-04-11 06:54:39'),(16,37,28,'2022-04-11 06:54:39','2022-04-11 06:54:39'),(17,37,24,'2022-04-11 06:54:40','2022-04-11 06:54:40'),(18,37,24,'2022-04-11 06:54:51','2022-04-11 06:54:51'),(19,37,24,'2022-04-11 06:54:51','2022-04-11 06:54:51'),(20,32,30,'2022-05-12 16:22:46','2022-05-12 16:22:46'),(22,32,30,'2022-05-12 16:22:50','2022-05-12 16:22:50'),(23,32,31,'2022-05-12 16:22:51','2022-05-12 16:22:51');

--
-- Table structure for table `followers`
--

CREATE TABLE `followers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `follower_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `followers_user_id_foreign` (`user_id`),
  KEY `followers_follower_id_foreign` (`follower_id`),
  CONSTRAINT `followers_follower_id_foreign` FOREIGN KEY (`follower_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `followers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `followers`
--

INSERT INTO `followers` (`id`, `user_id`, `follower_id`, `created_at`, `updated_at`) VALUES (2,11,10,'2022-02-05 06:51:47','2022-02-05 06:51:47'),(3,15,10,'2022-02-11 04:20:42','2022-02-11 04:20:42'),(31,27,15,'2022-02-20 15:57:13','2022-02-20 15:57:13'),(32,27,13,'2022-02-20 15:57:13','2022-02-20 15:57:13'),(33,27,11,'2022-02-20 15:57:14','2022-02-20 15:57:14'),(34,27,10,'2022-02-20 15:57:15','2022-02-20 15:57:15'),(35,9,15,'2022-02-27 11:42:33','2022-02-27 11:42:33'),(38,28,15,'2022-03-10 07:49:02','2022-03-10 07:49:02'),(39,28,13,'2022-03-10 07:49:02','2022-03-10 07:49:02'),(40,28,11,'2022-03-10 07:49:03','2022-03-10 07:49:03'),(41,28,10,'2022-03-10 07:49:04','2022-03-10 07:49:04'),(42,33,15,'2022-03-14 16:48:46','2022-03-14 16:48:46'),(43,33,13,'2022-03-14 16:51:12','2022-03-14 16:51:12'),(48,32,10,'2022-03-17 05:53:52','2022-03-17 05:53:52'),(50,32,13,'2022-05-12 16:24:59','2022-05-12 16:24:59'),(51,32,15,'2022-05-12 16:25:02','2022-05-12 16:25:02'),(52,32,9,'2022-05-21 18:42:33','2022-05-21 18:42:33');

--
-- Table structure for table `marketer_contracts`
--

CREATE TABLE `marketer_contracts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `owner_id` bigint unsigned NOT NULL,
  `marketer_id` bigint unsigned NOT NULL,
  `ad_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `marketer_contracts_owner_id_foreign` (`owner_id`),
  KEY `marketer_contracts_marketer_id_foreign` (`marketer_id`),
  KEY `marketer_contracts_ad_id_foreign` (`ad_id`),
  CONSTRAINT `marketer_contracts_ad_id_foreign` FOREIGN KEY (`ad_id`) REFERENCES `ads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `marketer_contracts_marketer_id_foreign` FOREIGN KEY (`marketer_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `marketer_contracts_owner_id_foreign` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketer_contracts`
--


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

CREATE TABLE `media` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `model_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `collection_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disk` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `conversions_disk` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size` bigint unsigned NOT NULL,
  `manipulations` json NOT NULL,
  `custom_properties` json NOT NULL,
  `responsive_images` json NOT NULL,
  `order_column` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_model_type_model_id_index` (`model_type`,`model_id`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media`
--

INSERT INTO `media` (`id`, `model_type`, `model_id`, `uuid`, `collection_name`, `name`, `file_name`, `mime_type`, `disk`, `conversions_disk`, `size`, `manipulations`, `custom_properties`, `responsive_images`, `order_column`, `created_at`, `updated_at`) VALUES (1,'App\\Models\\User',9,'d28db77a-d66d-4aa2-ab97-a862fc961b16','profile','CUT Admin Panal','CUT-Admin-Panal.png','image/png','public','public',1130929,'[]','[]','[]',1,'2022-02-04 16:29:23','2022-02-04 16:29:23'),(10,'App\\Models\\User',9,'68d0b96a-1333-4f86-a6e1-39b3df587c0f','profile','CUT Admin Panal','CUT-Admin-Panal.png','image/png','public','public',1130929,'[]','[]','[]',6,'2022-02-06 15:42:14','2022-02-06 15:42:14'),(11,'App\\Models\\User',9,'e43bcca5-a404-4fe1-b936-2a751d45aa42','contract','ecommerce','ecommerce.pdf','application/pdf','public','public',35807,'[]','[]','[]',7,'2022-02-06 15:53:49','2022-02-06 15:53:49'),(12,'App\\Models\\MarketerContract',1,'e26e7e9f-e671-4794-bfa6-40420c94eef3','default','ecommerce','ecommerce.pdf','application/pdf','public','public',35807,'[]','[]','[]',8,'2022-02-06 16:26:05','2022-02-06 16:26:05'),(22,'App\\Models\\User',15,'e71d8f96-a209-41c4-adca-a0e6cadfe4be','contract','ecommerce','ecommerce.pdf','application/pdf','public','public',35807,'[]','[]','[]',18,'2022-02-11 04:21:30','2022-02-11 04:21:30'),(23,'App\\Models\\MarketerContract',2,'fbdba98f-e775-42bd-8f68-e34703c1805b','default','ecommerce','ecommerce.pdf','application/pdf','public','public',35807,'[]','[]','[]',19,'2022-02-11 04:22:00','2022-02-11 04:22:00'),(25,'App\\Models\\User',10,'e1485352-a8e9-496d-9127-f4a3efa3f035','profile','CUT Admin Panal','CUT-Admin-Panal.png','image/png','public','public',1130929,'[]','[]','[]',21,'2022-02-13 19:21:13','2022-02-13 19:21:13'),(42,'App\\Models\\User',27,'64555849-8d28-4201-9c5d-402126aac06c','profile','22911100-91c5-11ec-955b-dd6db34e2ba3','22911100-91c5-11ec-955b-dd6db34e2ba3.jpeg','image/jpeg','public','public',200605,'[]','[]','[]',38,'2022-02-19 18:47:23','2022-02-19 18:47:23'),(43,'App\\Models\\User',27,'c303d241-65ea-4d47-abeb-99010fda8ea1','profile','34c9fbc0-91c5-11ec-8222-c1849d987339','34c9fbc0-91c5-11ec-8222-c1849d987339.jpeg','image/jpeg','public','public',200605,'[]','[]','[]',39,'2022-02-19 18:47:54','2022-02-19 18:47:54'),(44,'App\\Models\\User',27,'300829d8-f1e7-46a3-9dac-3876d852af45','profile','3e5f98c0-91c5-11ec-a4bc-b9edf141e82c','3e5f98c0-91c5-11ec-a4bc-b9edf141e82c.jpeg','image/jpeg','public','public',200605,'[]','[]','[]',40,'2022-02-19 18:48:09','2022-02-19 18:48:09'),(45,'App\\Models\\User',27,'89683985-5603-4763-9ba0-953eca7a96e5','profile','0829ec00-91c6-11ec-a8af-cb2fb23c55f6','0829ec00-91c6-11ec-a8af-cb2fb23c55f6.jpeg','image/jpeg','public','public',200488,'[]','[]','[]',41,'2022-02-19 18:53:48','2022-02-19 18:53:48'),(47,'App\\Models\\MarketerContract',3,'9fa5d3ac-34e5-46ed-9f6a-8d63e5175566','default','التعديلات الاخيرة للتطبيق العقارت (1)','التعديلات-الاخيرة-للتطبيق-العقارت-(1).pdf','application/pdf','public','public',45957,'[]','[]','[]',43,'2022-03-12 09:53:42','2022-03-12 09:53:42'),(51,'App\\Models\\User',35,'d1e9d68e-a6b2-4451-936d-e3808798f6e3','profile','78839961_2463795110522017_8423641107635634176_n','78839961_2463795110522017_8423641107635634176_n.jpg','image/jpeg','public','public',191705,'[]','[]','[]',47,'2022-03-22 17:23:24','2022-03-22 17:23:24'),(52,'App\\Models\\User',36,'6aac6c66-d2fc-4e73-8354-c689ed8c6625','profile','469-1619177422-944065-4','469-1619177422-944065-4.jpg','image/jpeg','public','public',78154,'[]','[]','[]',48,'2022-03-22 19:38:15','2022-03-22 19:38:15'),(53,'App\\Models\\Ad',30,'93942d26-99bd-4b60-abc5-d7dd54fcb413','default','container-what-is-container','container-what-is-container.png','image/png','public','public',300400,'[]','[]','[]',49,'2022-03-30 05:44:26','2022-03-30 05:44:26'),(54,'App\\Models\\Ad',31,'08e56df1-3a5f-4cdc-bb38-9125a3d76790','default','container-what-is-container','container-what-is-container.png','image/png','public','public',300400,'[]','[]','[]',50,'2022-03-30 05:46:59','2022-03-30 05:46:59'),(55,'App\\Models\\Ad',32,'a4c15cdd-ecaf-4a80-aeac-5c8d090a2c9b','default','1_bIQOZL_pZujjrfaaYlQ_gQ','1_bIQOZL_pZujjrfaaYlQ_gQ.png','image/png','public','public',31352,'[]','[]','[]',51,'2022-03-30 05:48:44','2022-03-30 05:48:44'),(56,'App\\Models\\Ad',34,'df314740-00f8-411b-adb0-57a0ddede358','default','download','download.jpg','image/jpeg','public','public',8886,'[]','[]','[]',52,'2022-04-03 05:31:51','2022-04-03 05:31:51'),(57,'App\\Models\\Ad',2,'a40527c0-85f4-4557-bdc9-b6373e765a56','default','37166','37166.jpg','image/jpeg','public','public',253070,'[]','[]','[]',53,'2022-04-03 06:59:59','2022-04-03 06:59:59'),(58,'App\\Models\\Ad',4,'52adcd5e-9810-4965-bdf5-51e66f6e411e','default','469-1619177422-944065-4','469-1619177422-944065-4.jpg','image/jpeg','public','public',78154,'[]','[]','[]',54,'2022-04-03 17:32:46','2022-04-03 17:32:46'),(59,'App\\Models\\Ad',5,'030e24a6-86e7-4973-a2e9-db0e2afbcd87','default','469-1619177422-944065-4','469-1619177422-944065-4.jpg','image/jpeg','public','public',78154,'[]','[]','[]',55,'2022-04-03 17:56:22','2022-04-03 17:56:22'),(60,'App\\Models\\Ad',6,'611811c7-c03c-40ef-b22b-c4b0f2784998','default','469-1619177422-944065-4','469-1619177422-944065-4.jpg','image/jpeg','public','public',78154,'[]','[]','[]',56,'2022-04-03 17:58:08','2022-04-03 17:58:08'),(61,'App\\Models\\Ad',7,'53172090-c725-429a-b4be-3ae2c831270f','default','469-1619177422-944065-4','469-1619177422-944065-4.jpg','image/jpeg','public','public',78154,'[]','[]','[]',57,'2022-04-03 17:59:34','2022-04-03 17:59:34'),(62,'App\\Models\\Ad',8,'b82d2a33-64c4-450c-a193-9115b3540729','default','469-1619177422-944065-4','469-1619177422-944065-4.jpg','image/jpeg','public','public',78154,'[]','[]','[]',58,'2022-04-03 17:59:48','2022-04-03 17:59:48'),(63,'App\\Models\\Ad',9,'15f43c11-4f3b-40cc-983b-c6bf4b8651a3','default','469-1619177422-944065-4','469-1619177422-944065-4.jpg','image/jpeg','public','public',78154,'[]','[]','[]',59,'2022-04-03 18:00:08','2022-04-03 18:00:08'),(64,'App\\Models\\Ad',10,'8ba4da20-ff15-49ea-874c-139366c613f3','default','469-1619177422-944065-4','469-1619177422-944065-4.jpg','image/jpeg','public','public',78154,'[]','[]','[]',60,'2022-04-03 18:00:37','2022-04-03 18:00:37'),(65,'App\\Models\\Ad',11,'f12bcac4-4c0d-4e83-aac9-e621d3d8db33','default','469-1619177422-944065-4','469-1619177422-944065-4.jpg','image/jpeg','public','public',78154,'[]','[]','[]',61,'2022-04-03 18:01:05','2022-04-03 18:01:05'),(66,'App\\Models\\Ad',12,'119b2d8e-c3d7-4f4c-b391-3ffad61cd107','default','469-1619177422-944065-4','469-1619177422-944065-4.jpg','image/jpeg','public','public',78154,'[]','[]','[]',62,'2022-04-03 18:01:20','2022-04-03 18:01:20'),(67,'App\\Models\\Ad',13,'af60a611-127a-4b67-9527-0639e6202a91','default','469-1619177422-944065-4','469-1619177422-944065-4.jpg','image/jpeg','public','public',78154,'[]','[]','[]',63,'2022-04-03 18:02:50','2022-04-03 18:02:50'),(68,'App\\Models\\Ad',14,'e39a7c80-2e96-40e7-b78e-16bf23fdf9f6','default','469-1619177422-944065-4','469-1619177422-944065-4.jpg','image/jpeg','public','public',78154,'[]','[]','[]',64,'2022-04-03 18:02:56','2022-04-03 18:02:56'),(69,'App\\Models\\Ad',15,'0697d771-6fdf-49ba-998d-de03b987f904','default','469-1619177422-944065-4','469-1619177422-944065-4.jpg','image/jpeg','public','public',78154,'[]','[]','[]',65,'2022-04-03 18:08:26','2022-04-03 18:08:26'),(75,'App\\Models\\Ad',20,'85a372e5-e643-4740-9bdb-2205b00035a6','default','7EC7B70B-1416-4DBC-948D-D0B77D69F08C','7EC7B70B-1416-4DBC-948D-D0B77D69F08C.jpeg','image/jpeg','public','public',194949,'[]','[]','[]',66,'2022-04-03 21:01:58','2022-04-03 21:01:58'),(77,'App\\Models\\Ad',22,'c0c314d7-102b-45f3-948c-98c6abc3ce56','default','Saudi-House','Saudi-House.jpeg','image/jpeg','public','public',110242,'[]','[]','[]',68,'2022-04-03 21:10:50','2022-04-03 21:10:50'),(79,'App\\Models\\Ad',24,'f02a0b27-0f89-47f8-a2ce-b0920b1c4752','default','image2','image2.jpg','image/jpeg','public','public',7651,'[]','[]','[]',70,'2022-04-05 05:31:52','2022-04-05 05:31:52'),(80,'App\\Models\\Ad',25,'93f241c2-245a-4dc1-9472-ac9ae2a8086e','default','image3','image3.jpg','image/jpeg','public','public',11232,'[]','[]','[]',71,'2022-04-05 05:35:16','2022-04-05 05:35:16'),(81,'App\\Models\\Ad',26,'6ed1e6c9-589a-4baa-9f8a-17841dcd6390','default','البيت11','البيت11.jpg','image/jpeg','public','public',46663,'[]','[]','[]',72,'2022-04-05 06:10:19','2022-04-05 06:10:19'),(82,'App\\Models\\Ad',27,'b8c8dfcd-a9d5-4675-ab09-38ab2667c291','default','image7','image7.jpg','image/jpeg','public','public',111813,'[]','[]','[]',73,'2022-04-05 06:15:54','2022-04-05 06:15:54'),(83,'App\\Models\\Ad',28,'be80d922-5bd8-4ccd-a59c-88e6d6ab0b90','default','image3','image3.jpg','image/jpeg','public','public',11232,'[]','[]','[]',74,'2022-04-05 06:27:50','2022-04-05 06:27:50'),(84,'App\\Models\\Ad',29,'82809644-e4f3-49bb-ad69-4b43b0721ded','default','image1','image1.jpg','image/jpeg','public','public',58557,'[]','[]','[]',75,'2022-04-05 06:32:25','2022-04-05 06:32:25'),(85,'App\\Models\\Ad',30,'c2cb18d3-10f1-4f29-8fd2-7b398ff29923','default','image2','image2.jpg','image/jpeg','public','public',94898,'[]','[]','[]',76,'2022-04-05 06:51:31','2022-04-05 06:51:31'),(86,'App\\Models\\Ad',30,'532cd022-cf75-4414-b654-972686c96a8a','default','image2','image2.jpg','image/jpeg','public','public',94898,'[]','[]','[]',77,'2022-04-05 06:53:42','2022-04-05 06:53:42'),(87,'App\\Models\\Ad',29,'623b73e1-8d92-4586-968c-7a4a067fd268','default','image3','image3.jpg','image/jpeg','public','public',8280,'[]','[]','[]',78,'2022-04-05 06:54:54','2022-04-05 06:54:54'),(88,'App\\Models\\Ad',31,'e8d90bb6-7a31-44f8-b4d7-1fafcddb98f1','default','image7','image7.jpg','image/jpeg','public','public',32473,'[]','[]','[]',79,'2022-04-05 06:57:13','2022-04-05 06:57:13'),(89,'App\\Models\\Ad',20,'58f1df47-ee19-43d6-a369-d15aee98585b','default','image6','image6.jpg','image/jpeg','public','public',260207,'[]','[]','[]',80,'2022-04-05 06:59:20','2022-04-05 06:59:20'),(90,'App\\Models\\Ad',22,'dea6a3ba-cb9b-48b1-958b-7dce8189531f','default','image6','image6.jpg','image/jpeg','public','public',260207,'[]','[]','[]',81,'2022-04-05 07:01:08','2022-04-05 07:01:08'),(91,'App\\Models\\Ad',24,'758fb8d3-643a-4b1d-afd7-fcdb8064be62','default','image4','image4.jpg','image/jpeg','public','public',9968,'[]','[]','[]',82,'2022-04-05 07:02:55','2022-04-05 07:02:55'),(92,'App\\Models\\Ad',24,'a9c9cec2-ba1c-4d76-9c87-5a52546efb2b','default','image2','image2.jpg','image/jpeg','public','public',94898,'[]','[]','[]',83,'2022-04-05 07:03:54','2022-04-05 07:03:54'),(93,'App\\Models\\Ad',26,'5c83ead9-f78f-4aaf-9a89-1f3c3b1232a2','default','image6','image6.jpg','image/jpeg','public','public',260207,'[]','[]','[]',84,'2022-04-05 07:05:04','2022-04-05 07:05:04'),(94,'App\\Models\\User',32,'b959f81f-8402-44e3-ac00-36af5341135b','profile','03b4a990-d92d-11ec-ae75-d95ae7cc486b','03b4a990-d92d-11ec-ae75-d95ae7cc486b.jpeg','image/jpeg','public','public',804910,'[]','[]','[]',85,'2022-05-21 18:39:54','2022-05-21 18:39:54'),(95,'App\\Models\\User',159,'f8835825-25e9-46b2-a322-b1e3337293d3','profile','d7c46700-92a7-11ed-b935-4d8207dc2ebe','d7c46700-92a7-11ed-b935-4d8207dc2ebe.jpeg','image/jpeg','public','public',38871,'[]','[]','[]',86,'2023-01-12 19:35:11','2023-01-12 19:35:11'),(96,'App\\Models\\User',159,'8c0145dc-997c-4c3b-99ca-f36ce15a6a95','profile','f2dce530-92a7-11ed-a028-47aa45563271','f2dce530-92a7-11ed-a028-47aa45563271.jpeg','image/jpeg','public','public',247669,'[]','[]','[]',87,'2023-01-12 19:35:56','2023-01-12 19:35:56'),(97,'App\\Models\\User',159,'52dd8a2e-9214-48cc-a4b4-55ef69f525fd','profile','194bea40-92a8-11ed-8da1-fdc5ba2c9241','194bea40-92a8-11ed-8da1-fdc5ba2c9241.jpeg','image/jpeg','public','public',247669,'[]','[]','[]',88,'2023-01-12 19:37:01','2023-01-12 19:37:01'),(98,'App\\Models\\User',159,'50986d90-7fa9-495c-be47-49f9316a1e8e','profile','1d16fc00-92a8-11ed-a51e-09f9e5a74e04','1d16fc00-92a8-11ed-a51e-09f9e5a74e04.jpeg','image/jpeg','public','public',247669,'[]','[]','[]',89,'2023-01-12 19:37:07','2023-01-12 19:37:07');

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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1,'2014_10_12_100000_create_password_resets_table',1),(2,'2019_08_19_000000_create_failed_jobs_table',1),(3,'2019_12_14_000001_create_personal_access_tokens_table',1),(4,'2021_07_14_141539_create_cities_table',1),(5,'2021_07_14_141648_create_city_translations_table',1),(6,'2021_07_15_100621_create_areas_table',1),(7,'2021_07_15_100658_create_area_translations_table',1),(8,'2021_07_15_100777_create_users_table',1),(9,'2022_01_16_083023_create_permission_tables',1),(10,'2022_01_16_083215_create_media_table',1),(11,'2022_01_16_094005_create_admins_table',1),(12,'2022_02_04_183459_create_types_table',2),(13,'2022_02_04_183508_create_type_translations_table',2),(14,'2022_02_04_183518_create_services_table',2),(15,'2022_02_04_183523_create_service_translations_table',2),(16,'2022_02_04_193649_create_ads_table',3),(17,'2022_02_04_193659_create_ads_table',4),(18,'2022_02_04_193660_create_ads_table',5),(19,'2022_02_04_193661_create_ads_table',6),(20,'2022_02_04_193662_create_ads_table',7),(21,'2022_02_04_193665_create_ads_table',8),(22,'2022_02_05_083921_create_followers_table',9),(23,'2022_02_06_172958_add_real_estate_advertiser_number_to_users_table',10),(24,'2022_02_06_173043_add_facility_name_to_users_table',10),(25,'2022_02_06_175957_create_marketer_contracts_table',11),(26,'2022_02_07_215144_create_favourites_table',12),(27,'2022_02_09_213345_add_lat_to_users_table',13),(28,'2022_02_09_213354_add_long_to_users_table',13),(29,'2022_02_09_220258_create_settings_table',14),(30,'2022_02_09_222508_create_request_ads_table',15),(31,'2022_02_09_235326_create_rates_table',16),(32,'2022_02_09_235328_create_rates_table',17),(33,'2022_02_09_235329_create_rates_table',18),(34,'2022_02_04_193666_create_ads_table',19),(35,'2022_02_04_193670_create_ads_table',20),(36,'2022_02_11_065626_add_fcm_token_to_users_table',21),(37,'2022_02_11_065829_create_chats_table',22),(38,'2022_02_15_052954_add_price_type_to_ads_table',23),(39,'2022_02_17_044316_add_price_number_of_apartments_to_ads_table',24),(40,'2022_02_17_045335_add_price_status_to_ads_table',24),(41,'2022_02_18_201641_add_text_to_users_table',25),(42,'2022_02_18_215220_add_all_area_to_ads_table',25),(43,'2022_03_09_164731_add_user_id_to_request_ads_table',26),(44,'2022_03_22_193940_add_featured_type_to_ads_table',27),(45,'2022_03_23_210656_create_packages_table',28),(46,'2022_03_23_213756_add_package_id_to_ads_table',29),(47,'2022_04_15_133913_create_auctions_table',30),(48,'2022_04_15_133920_create_auction_users_table',30),(49,'2022_04_15_170533_add_min_price_to_auctions_table',31);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(191) CHARACTER SET utf8mb4 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;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(191) CHARACTER SET utf8mb4 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;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES (1,'App\\Models\\User',9),(1,'App\\Models\\User',10),(1,'App\\Models\\User',11),(1,'App\\Models\\User',13),(1,'App\\Models\\User',15),(3,'App\\Models\\User',16),(3,'App\\Models\\User',17),(3,'App\\Models\\User',22),(3,'App\\Models\\User',23),(3,'App\\Models\\User',24),(3,'App\\Models\\User',25),(3,'App\\Models\\User',26),(3,'App\\Models\\User',27),(1,'App\\Models\\User',28),(3,'App\\Models\\User',29),(3,'App\\Models\\User',30),(2,'App\\Models\\User',31),(2,'App\\Models\\User',32),(1,'App\\Models\\User',33),(2,'App\\Models\\User',34),(3,'App\\Models\\User',35),(2,'App\\Models\\User',36),(1,'App\\Models\\User',37),(2,'App\\Models\\User',38),(3,'App\\Models\\User',39),(3,'App\\Models\\User',40),(3,'App\\Models\\User',41),(3,'App\\Models\\User',42),(3,'App\\Models\\User',43),(3,'App\\Models\\User',44),(3,'App\\Models\\User',45),(3,'App\\Models\\User',47),(3,'App\\Models\\User',48),(3,'App\\Models\\User',49),(3,'App\\Models\\User',50),(3,'App\\Models\\User',51),(2,'App\\Models\\User',52),(3,'App\\Models\\User',53),(3,'App\\Models\\User',54),(3,'App\\Models\\User',55),(3,'App\\Models\\User',56),(3,'App\\Models\\User',57),(3,'App\\Models\\User',58),(3,'App\\Models\\User',59),(3,'App\\Models\\User',60),(2,'App\\Models\\User',61),(2,'App\\Models\\User',62),(3,'App\\Models\\User',63),(3,'App\\Models\\User',64),(3,'App\\Models\\User',65),(2,'App\\Models\\User',66),(3,'App\\Models\\User',67),(3,'App\\Models\\User',68),(3,'App\\Models\\User',69),(3,'App\\Models\\User',70),(3,'App\\Models\\User',71),(3,'App\\Models\\User',72),(3,'App\\Models\\User',73),(3,'App\\Models\\User',74),(3,'App\\Models\\User',75),(3,'App\\Models\\User',76),(3,'App\\Models\\User',77),(2,'App\\Models\\User',78),(3,'App\\Models\\User',79),(3,'App\\Models\\User',80),(2,'App\\Models\\User',81),(3,'App\\Models\\User',82),(2,'App\\Models\\User',83),(3,'App\\Models\\User',84),(3,'App\\Models\\User',85),(3,'App\\Models\\User',86),(3,'App\\Models\\User',87),(3,'App\\Models\\User',88),(3,'App\\Models\\User',89),(3,'App\\Models\\User',90),(3,'App\\Models\\User',91),(3,'App\\Models\\User',92),(3,'App\\Models\\User',93),(3,'App\\Models\\User',94),(3,'App\\Models\\User',95),(3,'App\\Models\\User',96),(3,'App\\Models\\User',97),(3,'App\\Models\\User',98),(3,'App\\Models\\User',99),(3,'App\\Models\\User',100),(3,'App\\Models\\User',101),(3,'App\\Models\\User',102),(3,'App\\Models\\User',103),(3,'App\\Models\\User',104),(3,'App\\Models\\User',105),(3,'App\\Models\\User',106),(3,'App\\Models\\User',107),(3,'App\\Models\\User',108),(3,'App\\Models\\User',109),(3,'App\\Models\\User',110),(3,'App\\Models\\User',111),(3,'App\\Models\\User',112),(2,'App\\Models\\User',113),(2,'App\\Models\\User',114),(3,'App\\Models\\User',115),(3,'App\\Models\\User',116),(3,'App\\Models\\User',117),(2,'App\\Models\\User',118),(3,'App\\Models\\User',119),(3,'App\\Models\\User',120),(3,'App\\Models\\User',121),(3,'App\\Models\\User',122),(2,'App\\Models\\User',123),(3,'App\\Models\\User',124),(3,'App\\Models\\User',125),(3,'App\\Models\\User',126),(3,'App\\Models\\User',127),(3,'App\\Models\\User',128),(3,'App\\Models\\User',129),(3,'App\\Models\\User',130),(3,'App\\Models\\User',131),(3,'App\\Models\\User',132),(3,'App\\Models\\User',133),(3,'App\\Models\\User',134),(2,'App\\Models\\User',135),(3,'App\\Models\\User',136),(3,'App\\Models\\User',137),(3,'App\\Models\\User',138),(3,'App\\Models\\User',139),(3,'App\\Models\\User',140),(3,'App\\Models\\User',141),(2,'App\\Models\\User',142),(3,'App\\Models\\User',143),(3,'App\\Models\\User',144),(3,'App\\Models\\User',145),(3,'App\\Models\\User',146),(3,'App\\Models\\User',147),(3,'App\\Models\\User',148),(3,'App\\Models\\User',149),(3,'App\\Models\\User',150),(2,'App\\Models\\User',151),(3,'App\\Models\\User',152),(3,'App\\Models\\User',153),(3,'App\\Models\\User',154),(3,'App\\Models\\User',155),(3,'App\\Models\\User',156),(2,'App\\Models\\User',157),(3,'App\\Models\\User',158),(3,'App\\Models\\User',159),(3,'App\\Models\\User',160),(2,'App\\Models\\User',161),(2,'App\\Models\\User',162),(3,'App\\Models\\User',163),(2,'App\\Models\\User',164),(3,'App\\Models\\User',165),(3,'App\\Models\\User',166),(3,'App\\Models\\User',167),(3,'App\\Models\\User',168),(3,'App\\Models\\User',169),(3,'App\\Models\\User',170),(3,'App\\Models\\User',171),(2,'App\\Models\\User',172),(3,'App\\Models\\User',173),(2,'App\\Models\\User',174),(3,'App\\Models\\User',175),(3,'App\\Models\\User',176),(3,'App\\Models\\User',177),(3,'App\\Models\\User',178),(3,'App\\Models\\User',179),(2,'App\\Models\\User',180),(3,'App\\Models\\User',181),(3,'App\\Models\\User',182),(3,'App\\Models\\User',183),(2,'App\\Models\\User',184),(3,'App\\Models\\User',185),(3,'App\\Models\\User',186),(2,'App\\Models\\User',187),(3,'App\\Models\\User',188),(3,'App\\Models\\User',189),(3,'App\\Models\\User',190),(3,'App\\Models\\User',191),(3,'App\\Models\\User',192),(3,'App\\Models\\User',193),(3,'App\\Models\\User',194),(3,'App\\Models\\User',195),(3,'App\\Models\\User',196),(3,'App\\Models\\User',197),(3,'App\\Models\\User',198),(3,'App\\Models\\User',199),(2,'App\\Models\\User',200),(2,'App\\Models\\User',201),(3,'App\\Models\\User',202),(3,'App\\Models\\User',203),(3,'App\\Models\\User',204),(3,'App\\Models\\User',205),(3,'App\\Models\\User',206),(3,'App\\Models\\User',207),(3,'App\\Models\\User',208),(3,'App\\Models\\User',209),(3,'App\\Models\\User',210),(3,'App\\Models\\User',211),(3,'App\\Models\\User',212),(3,'App\\Models\\User',213),(3,'App\\Models\\User',214),(3,'App\\Models\\User',215),(3,'App\\Models\\User',216),(3,'App\\Models\\User',217),(3,'App\\Models\\User',218),(3,'App\\Models\\User',219),(3,'App\\Models\\User',220),(3,'App\\Models\\User',221),(3,'App\\Models\\User',222),(2,'App\\Models\\User',223),(3,'App\\Models\\User',224),(3,'App\\Models\\User',225),(3,'App\\Models\\User',226),(3,'App\\Models\\User',227),(3,'App\\Models\\User',228),(3,'App\\Models\\User',229),(3,'App\\Models\\User',230),(3,'App\\Models\\User',231),(3,'App\\Models\\User',232),(3,'App\\Models\\User',233),(3,'App\\Models\\User',234),(3,'App\\Models\\User',235),(3,'App\\Models\\User',236),(3,'App\\Models\\User',237),(3,'App\\Models\\User',238),(3,'App\\Models\\User',239),(3,'App\\Models\\User',240),(2,'App\\Models\\User',241),(3,'App\\Models\\User',242),(2,'App\\Models\\User',243),(3,'App\\Models\\User',244),(3,'App\\Models\\User',245),(3,'App\\Models\\User',246),(2,'App\\Models\\User',247),(3,'App\\Models\\User',248),(3,'App\\Models\\User',249),(3,'App\\Models\\User',250),(3,'App\\Models\\User',251),(3,'App\\Models\\User',252),(3,'App\\Models\\User',253),(3,'App\\Models\\User',254),(3,'App\\Models\\User',255),(3,'App\\Models\\User',256),(3,'App\\Models\\User',257),(3,'App\\Models\\User',258),(2,'App\\Models\\User',259),(3,'App\\Models\\User',260),(3,'App\\Models\\User',261),(3,'App\\Models\\User',262),(3,'App\\Models\\User',263),(3,'App\\Models\\User',264),(3,'App\\Models\\User',265),(3,'App\\Models\\User',266),(3,'App\\Models\\User',267),(3,'App\\Models\\User',268),(2,'App\\Models\\User',269),(3,'App\\Models\\User',270),(3,'App\\Models\\User',271),(3,'App\\Models\\User',272),(3,'App\\Models\\User',273),(3,'App\\Models\\User',274),(3,'App\\Models\\User',275),(3,'App\\Models\\User',276),(3,'App\\Models\\User',277),(3,'App\\Models\\User',278),(3,'App\\Models\\User',279),(3,'App\\Models\\User',280),(3,'App\\Models\\User',281),(3,'App\\Models\\User',282),(3,'App\\Models\\User',283),(3,'App\\Models\\User',284),(3,'App\\Models\\User',285),(3,'App\\Models\\User',286),(3,'App\\Models\\User',287),(3,'App\\Models\\User',288),(3,'App\\Models\\User',289),(3,'App\\Models\\User',290),(2,'App\\Models\\User',291),(3,'App\\Models\\User',292),(3,'App\\Models\\User',293),(3,'App\\Models\\User',294),(3,'App\\Models\\User',295),(3,'App\\Models\\User',296),(3,'App\\Models\\User',297),(3,'App\\Models\\User',298),(3,'App\\Models\\User',299),(3,'App\\Models\\User',300),(3,'App\\Models\\User',301),(3,'App\\Models\\User',302),(3,'App\\Models\\User',303),(3,'App\\Models\\User',304),(3,'App\\Models\\User',305),(3,'App\\Models\\User',306),(2,'App\\Models\\User',307),(3,'App\\Models\\User',308),(3,'App\\Models\\User',309),(3,'App\\Models\\User',310),(3,'App\\Models\\User',311),(3,'App\\Models\\User',312),(3,'App\\Models\\User',313),(3,'App\\Models\\User',314),(3,'App\\Models\\User',315),(3,'App\\Models\\User',316),(2,'App\\Models\\User',317),(3,'App\\Models\\User',318),(3,'App\\Models\\User',319),(3,'App\\Models\\User',320),(3,'App\\Models\\User',321),(3,'App\\Models\\User',322),(3,'App\\Models\\User',323),(3,'App\\Models\\User',324),(3,'App\\Models\\User',325),(3,'App\\Models\\User',326),(3,'App\\Models\\User',327),(3,'App\\Models\\User',328),(3,'App\\Models\\User',329),(3,'App\\Models\\User',330),(3,'App\\Models\\User',331),(3,'App\\Models\\User',332),(3,'App\\Models\\User',333),(3,'App\\Models\\User',334),(3,'App\\Models\\User',335),(3,'App\\Models\\User',336),(3,'App\\Models\\User',337),(2,'App\\Models\\User',338),(3,'App\\Models\\User',339),(3,'App\\Models\\User',340),(3,'App\\Models\\User',341),(2,'App\\Models\\User',342),(3,'App\\Models\\User',343),(3,'App\\Models\\User',344),(3,'App\\Models\\User',345),(3,'App\\Models\\User',346),(3,'App\\Models\\User',347),(3,'App\\Models\\User',348),(3,'App\\Models\\User',349),(3,'App\\Models\\User',350),(3,'App\\Models\\User',351),(3,'App\\Models\\User',352),(3,'App\\Models\\User',353),(3,'App\\Models\\User',354),(3,'App\\Models\\User',355),(3,'App\\Models\\User',356),(2,'App\\Models\\User',357),(3,'App\\Models\\User',358),(3,'App\\Models\\User',359),(3,'App\\Models\\User',360),(3,'App\\Models\\User',361),(3,'App\\Models\\User',362),(3,'App\\Models\\User',363),(3,'App\\Models\\User',364),(3,'App\\Models\\User',365),(3,'App\\Models\\User',366),(3,'App\\Models\\User',367),(3,'App\\Models\\User',368),(3,'App\\Models\\User',369),(3,'App\\Models\\User',370),(3,'App\\Models\\User',371),(3,'App\\Models\\User',372),(3,'App\\Models\\User',373),(3,'App\\Models\\User',374),(3,'App\\Models\\User',375),(3,'App\\Models\\User',376),(2,'App\\Models\\User',377),(3,'App\\Models\\User',378),(3,'App\\Models\\User',379),(3,'App\\Models\\User',380),(3,'App\\Models\\User',381),(3,'App\\Models\\User',382),(3,'App\\Models\\User',383),(3,'App\\Models\\User',384),(3,'App\\Models\\User',385),(3,'App\\Models\\User',386),(3,'App\\Models\\User',387),(3,'App\\Models\\User',388),(3,'App\\Models\\User',389),(3,'App\\Models\\User',390),(3,'App\\Models\\User',391),(3,'App\\Models\\User',392),(3,'App\\Models\\User',393),(3,'App\\Models\\User',394),(3,'App\\Models\\User',395),(3,'App\\Models\\User',396),(3,'App\\Models\\User',397),(3,'App\\Models\\User',398),(3,'App\\Models\\User',399),(3,'App\\Models\\User',400),(3,'App\\Models\\User',401),(3,'App\\Models\\User',402),(3,'App\\Models\\User',403),(3,'App\\Models\\User',404),(3,'App\\Models\\User',405),(3,'App\\Models\\User',406),(3,'App\\Models\\User',407),(3,'App\\Models\\User',408),(3,'App\\Models\\User',409),(2,'App\\Models\\User',410),(2,'App\\Models\\User',411),(3,'App\\Models\\User',412),(3,'App\\Models\\User',413),(3,'App\\Models\\User',414),(3,'App\\Models\\User',415),(3,'App\\Models\\User',416),(3,'App\\Models\\User',417),(3,'App\\Models\\User',418),(3,'App\\Models\\User',419),(3,'App\\Models\\User',420),(3,'App\\Models\\User',421),(3,'App\\Models\\User',422),(3,'App\\Models\\User',423),(3,'App\\Models\\User',424),(3,'App\\Models\\User',425),(2,'App\\Models\\User',426),(3,'App\\Models\\User',427),(3,'App\\Models\\User',428),(3,'App\\Models\\User',429),(3,'App\\Models\\User',430),(3,'App\\Models\\User',431),(3,'App\\Models\\User',432),(3,'App\\Models\\User',433),(3,'App\\Models\\User',434),(3,'App\\Models\\User',435),(3,'App\\Models\\User',436),(3,'App\\Models\\User',437),(3,'App\\Models\\User',438),(3,'App\\Models\\User',439),(3,'App\\Models\\User',440),(3,'App\\Models\\User',441),(3,'App\\Models\\User',442),(3,'App\\Models\\User',443),(3,'App\\Models\\User',444),(3,'App\\Models\\User',445),(2,'App\\Models\\User',446),(3,'App\\Models\\User',447),(3,'App\\Models\\User',448),(2,'App\\Models\\User',449),(3,'App\\Models\\User',450),(3,'App\\Models\\User',451),(3,'App\\Models\\User',452),(3,'App\\Models\\User',453),(3,'App\\Models\\User',454),(3,'App\\Models\\User',455),(3,'App\\Models\\User',456),(3,'App\\Models\\User',457),(3,'App\\Models\\User',458),(3,'App\\Models\\User',459),(3,'App\\Models\\User',460),(3,'App\\Models\\User',461),(3,'App\\Models\\User',462),(3,'App\\Models\\User',463),(3,'App\\Models\\User',464),(3,'App\\Models\\User',465),(3,'App\\Models\\User',466),(3,'App\\Models\\User',467),(3,'App\\Models\\User',468),(3,'App\\Models\\User',469),(3,'App\\Models\\User',470),(3,'App\\Models\\User',471),(3,'App\\Models\\User',472),(3,'App\\Models\\User',473),(2,'App\\Models\\User',474),(2,'App\\Models\\User',475),(3,'App\\Models\\User',476),(3,'App\\Models\\User',477),(3,'App\\Models\\User',478),(3,'App\\Models\\User',479),(3,'App\\Models\\User',480),(3,'App\\Models\\User',481),(2,'App\\Models\\User',482),(2,'App\\Models\\User',483),(3,'App\\Models\\User',484),(2,'App\\Models\\User',485),(3,'App\\Models\\User',486),(3,'App\\Models\\User',487),(3,'App\\Models\\User',488),(3,'App\\Models\\User',489),(3,'App\\Models\\User',490),(3,'App\\Models\\User',491),(3,'App\\Models\\User',492),(3,'App\\Models\\User',493),(3,'App\\Models\\User',494),(3,'App\\Models\\User',495),(3,'App\\Models\\User',496),(3,'App\\Models\\User',497),(3,'App\\Models\\User',498),(3,'App\\Models\\User',499),(3,'App\\Models\\User',500),(3,'App\\Models\\User',501),(3,'App\\Models\\User',502),(3,'App\\Models\\User',503),(3,'App\\Models\\User',504),(3,'App\\Models\\User',505),(2,'App\\Models\\User',506),(2,'App\\Models\\User',507),(2,'App\\Models\\User',508),(3,'App\\Models\\User',509),(3,'App\\Models\\User',510),(3,'App\\Models\\User',511),(3,'App\\Models\\User',512),(3,'App\\Models\\User',513),(2,'App\\Models\\User',514),(2,'App\\Models\\User',515),(3,'App\\Models\\User',516),(3,'App\\Models\\User',517),(3,'App\\Models\\User',518),(3,'App\\Models\\User',519),(3,'App\\Models\\User',520),(3,'App\\Models\\User',521),(3,'App\\Models\\User',522),(3,'App\\Models\\User',523),(3,'App\\Models\\User',524),(3,'App\\Models\\User',525),(3,'App\\Models\\User',526),(3,'App\\Models\\User',527),(3,'App\\Models\\User',528),(3,'App\\Models\\User',529),(3,'App\\Models\\User',530),(3,'App\\Models\\User',531),(3,'App\\Models\\User',532),(3,'App\\Models\\User',533),(3,'App\\Models\\User',534),(2,'App\\Models\\User',535),(3,'App\\Models\\User',536),(3,'App\\Models\\User',537),(3,'App\\Models\\User',538),(3,'App\\Models\\User',539),(3,'App\\Models\\User',540),(3,'App\\Models\\User',541),(2,'App\\Models\\User',542),(3,'App\\Models\\User',543),(3,'App\\Models\\User',544),(3,'App\\Models\\User',545),(3,'App\\Models\\User',546),(2,'App\\Models\\User',547),(3,'App\\Models\\User',548),(3,'App\\Models\\User',549),(3,'App\\Models\\User',550),(3,'App\\Models\\User',551),(3,'App\\Models\\User',552),(3,'App\\Models\\User',553),(3,'App\\Models\\User',554),(3,'App\\Models\\User',555),(3,'App\\Models\\User',556),(3,'App\\Models\\User',557),(2,'App\\Models\\User',558),(3,'App\\Models\\User',559),(3,'App\\Models\\User',560),(3,'App\\Models\\User',561),(3,'App\\Models\\User',562),(3,'App\\Models\\User',563),(3,'App\\Models\\User',564),(3,'App\\Models\\User',565),(3,'App\\Models\\User',566),(3,'App\\Models\\User',567),(3,'App\\Models\\User',568),(3,'App\\Models\\User',569),(3,'App\\Models\\User',570),(2,'App\\Models\\User',571),(3,'App\\Models\\User',572),(3,'App\\Models\\User',573),(3,'App\\Models\\User',574),(2,'App\\Models\\User',575),(3,'App\\Models\\User',576),(3,'App\\Models\\User',577),(3,'App\\Models\\User',578),(3,'App\\Models\\User',579),(3,'App\\Models\\User',580),(3,'App\\Models\\User',581),(3,'App\\Models\\User',582),(3,'App\\Models\\User',583),(3,'App\\Models\\User',584),(3,'App\\Models\\User',585),(3,'App\\Models\\User',586),(3,'App\\Models\\User',587),(2,'App\\Models\\User',588),(3,'App\\Models\\User',589),(3,'App\\Models\\User',590),(2,'App\\Models\\User',591),(2,'App\\Models\\User',592),(2,'App\\Models\\User',593),(3,'App\\Models\\User',594),(3,'App\\Models\\User',595),(3,'App\\Models\\User',596),(3,'App\\Models\\User',597),(3,'App\\Models\\User',598),(3,'App\\Models\\User',599),(3,'App\\Models\\User',600),(3,'App\\Models\\User',601),(3,'App\\Models\\User',602),(3,'App\\Models\\User',603),(3,'App\\Models\\User',604),(3,'App\\Models\\User',605),(2,'App\\Models\\User',606),(3,'App\\Models\\User',607),(3,'App\\Models\\User',608),(3,'App\\Models\\User',609),(3,'App\\Models\\User',610),(3,'App\\Models\\User',611),(3,'App\\Models\\User',612),(3,'App\\Models\\User',613),(3,'App\\Models\\User',614),(3,'App\\Models\\User',615),(3,'App\\Models\\User',616),(3,'App\\Models\\User',617),(3,'App\\Models\\User',618),(3,'App\\Models\\User',619),(3,'App\\Models\\User',620),(3,'App\\Models\\User',621),(3,'App\\Models\\User',622);

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `day` int NOT NULL,
  `value` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` (`id`, `start_date`, `end_date`, `day`, `value`, `created_at`, `updated_at`) VALUES (1,'2022-03-23','2022-03-24',10,100,'2022-03-23 19:31:35','2022-03-23 19:31:51');

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) CHARACTER SET utf8mb4 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `rates`
--

CREATE TABLE `rates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `area_id` bigint unsigned NOT NULL,
  `type` int NOT NULL,
  `rate` int NOT NULL,
  `comment` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `rates_user_id_foreign` (`user_id`),
  KEY `rates_area_id_foreign` (`area_id`),
  CONSTRAINT `rates_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE CASCADE,
  CONSTRAINT `rates_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rates`
--

INSERT INTO `rates` (`id`, `user_id`, `area_id`, `type`, `rate`, `comment`, `created_at`, `updated_at`) VALUES (1,9,1,1,3,'first commnet','2022-02-09 22:51:42','2022-02-09 22:51:42'),(2,9,1,1,4,'first commnet','2022-02-09 22:51:52','2022-02-09 22:51:52'),(3,9,2,1,4,'first commnet','2022-02-09 22:52:13','2022-02-09 22:52:13'),(4,9,2,2,4,'first commnet','2022-02-09 22:52:25','2022-02-09 22:52:25'),(5,9,2,2,1,'first commnet','2022-02-09 22:54:59','2022-02-09 22:54:59'),(6,9,1,2,1,'first commnet','2022-02-09 22:55:13','2022-02-09 22:55:13'),(7,9,1,2,1,'first commnet','2022-02-19 18:58:42','2022-02-19 18:58:42'),(8,9,1,2,1,'first commnet','2022-02-19 18:59:09','2022-02-19 18:59:09'),(9,9,1,2,1,'first commnet','2022-02-19 20:21:26','2022-02-19 20:21:26'),(10,9,1,2,1,'first commnet','2022-02-19 20:21:29','2022-02-19 20:21:29'),(11,27,1,4,4,'fghui','2022-02-19 20:33:41','2022-02-19 20:33:41'),(12,27,1,4,4,'fghui','2022-02-19 20:34:16','2022-02-19 20:34:16'),(13,27,1,4,4,'fghui','2022-02-19 20:34:40','2022-02-19 20:34:40'),(14,27,1,4,4,'fghui','2022-02-19 20:34:58','2022-02-19 20:34:58'),(15,27,1,4,4,'fghui','2022-02-19 20:36:01','2022-02-19 20:36:01'),(16,32,1,5,5,'Hh','2022-05-12 16:24:18','2022-05-12 16:24:18'),(17,32,9,5,5,'Mm','2022-05-21 18:41:00','2022-05-21 18:41:00'),(18,52,6,5,5,'جيد للسكن','2022-05-23 21:53:37','2022-05-23 21:53:37');

--
-- Table structure for table `request_ads`
--

CREATE TABLE `request_ads` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `request_ads`
--

INSERT INTO `request_ads` (`id`, `text`, `phone`, `user_id`, `created_at`, `updated_at`) VALUES (3,'محتاج فيلا علي البحر وتكون وحة اولي','67782374',37,'2022-04-11 05:48:07','2022-04-11 05:48:07'),(4,'مطلوب شقة غرفة وصالة','67782374',37,'2022-04-11 05:50:46','2022-04-11 05:50:46'),(5,'محتاج شقة','67782374',37,'2022-04-11 05:51:47','2022-04-11 05:51:47'),(6,'محتاج فيلا','45858855888',37,'2022-04-11 05:52:14','2022-04-11 05:52:14'),(7,'سأقوم بكتابة نص ترويجي بمتوسط عدد 300 - 500 كلمة لخدمتك سواء كانت خدمة تقدمها او دبلومة او كورس او نص ترويجي لفيديو او اي شئ متعلق بالنصوص الترويجية باحترافية شديدة وبشكل متوافق كليا مع محركات البحث واعلي الكلمات بحثا لضمان نجاح النص الترويجي بشكل كبير','67782374',37,'2022-04-11 07:35:36','2022-04-11 07:35:36'),(9,'سأقوم بكتابة نص ترويجي بمتوسط عدد 300 - 500 كلمة لخدمتك سواء كانت خدمة تقدمها او دبلومة او كورس او نص ترويجي لفيديو او اي شئ متعلق بالنصوص الترويجية باحترافية شديدة وبشكل متوافق كليا مع محركات البحث واعلي الكلمات بحثا لضمان نجاح النص الترويجي بشكل كبير','67782374',37,'2022-04-11 07:38:23','2022-04-11 07:38:23'),(10,'مطلوب عماره شمال الرياض','0549460455',52,'2022-05-23 21:52:26','2022-05-23 21:52:26');

--
-- Table structure for table `role_has_permissions`
--

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;

--
-- Dumping data for table `role_has_permissions`
--


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

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (1,'marketed','users','2022-02-02 18:13:00','2022-02-02 18:13:00'),(2,'owner','users','2022-02-02 18:13:05','2022-02-02 18:13:05'),(3,'user','users','2022-02-02 18:13:13','2022-02-02 18:13:13');

--
-- Table structure for table `service_translations`
--

CREATE TABLE `service_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `service_id` bigint unsigned NOT NULL,
  `locale` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `service_translations_service_id_locale_unique` (`service_id`,`locale`),
  KEY `service_translations_locale_index` (`locale`),
  CONSTRAINT `service_translations_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `service_translations`
--

INSERT INTO `service_translations` (`id`, `service_id`, `locale`, `name`, `created_at`, `updated_at`) VALUES (1,1,'en','operating companies','2022-02-04 03:21:32','2022-02-04 03:21:32'),(2,1,'ar','شركات تشعيل','2022-02-04 03:21:32','2022-02-04 03:21:32'),(3,2,'en','investment companies','2022-02-04 04:27:33','2022-02-04 04:27:33'),(4,2,'ar','شركات استثمار','2022-02-04 04:27:33','2022-02-04 04:27:33');

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

CREATE TABLE `services` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `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;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `created_at`, `updated_at`) VALUES (1,'2022-02-04 03:21:32','2022-02-04 03:21:32'),(2,'2022-02-04 03:21:32','2022-02-04 03:21:32');

--
-- Table structure for table `type_translations`
--

CREATE TABLE `type_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type_id` bigint unsigned NOT NULL,
  `locale` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `type_translations_type_id_locale_unique` (`type_id`,`locale`),
  KEY `type_translations_locale_index` (`locale`),
  CONSTRAINT `type_translations_type_id_foreign` FOREIGN KEY (`type_id`) REFERENCES `types` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `type_translations`
--

INSERT INTO `type_translations` (`id`, `type_id`, `locale`, `name`, `created_at`, `updated_at`) VALUES (1,1,'en','Villa for sale','2022-02-04 05:27:39','2022-02-04 05:27:39'),(2,1,'ar','فيلا للبيع','2022-02-04 05:27:39','2022-02-04 05:27:39'),(3,2,'en','Residential unit for sale','2022-02-04 05:26:36','2022-02-04 05:26:36'),(4,2,'ar','وحده سكنيه للبيع','2022-02-04 05:26:36','2022-02-04 05:26:36');

--
-- Table structure for table `types`
--

CREATE TABLE `types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `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;

--
-- Dumping data for table `types`
--

INSERT INTO `types` (`id`, `created_at`, `updated_at`) VALUES (1,'2022-02-04 06:32:00','2022-02-04 06:32:00'),(2,'2022-02-04 06:32:00','2022-02-04 06:32:00');

--
-- Dumping events for database 'topappkw_realstat'
--

--
-- Dumping routines for database 'topappkw_realstat'
--


