-- MySQL dump 10.13 Distrib 8.0.37, for Linux (x86_64) -- -- Host: localhost Database: topappkw_services -- ------------------------------------------------------ -- Server version 8.0.37 /*!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 */; -- -- Current Database: `topappkw_services` -- -- -- Table structure for table `cart_users` -- DROP TABLE IF EXISTS `cart_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cart_users` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(255) 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cart_users` -- LOCK TABLES `cart_users` WRITE; /*!40000 ALTER TABLE `cart_users` DISABLE KEYS */; /*!40000 ALTER TABLE `cart_users` 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` int unsigned NOT NULL AUTO_INCREMENT, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `parent_id` int NOT NULL, `status` int NOT NULL DEFAULT '0', `orderBy` int DEFAULT NULL, `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=26 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` (`id`, `image`, `parent_id`, `status`, `orderBy`, `time`, `price`, `created_at`, `updated_at`, `deleted_at`, `type`) VALUES (1,'420242-download (2).png',0,1,NULL,NULL,NULL,'2023-01-06 12:59:29','2023-01-09 21:26:08','2023-01-09 21:26:08',NULL),(2,'',0,1,NULL,NULL,NULL,'2023-01-06 12:59:38','2023-01-09 21:25:45','2023-01-09 21:25:45',NULL),(3,'883947-WhatsApp Image 2023-03-19 at 17.02.00.jpg',0,1,NULL,NULL,NULL,'2023-01-09 21:27:59','2023-03-20 12:58:06','2023-03-20 12:58:06',NULL),(4,'413280-Cleaning _ Jackson Cleaning Service LLC _ United States-PhotoRoom.png-PhotoRoom.png',0,0,NULL,NULL,NULL,'2023-01-09 21:28:41','2024-01-20 12:21:41',NULL,NULL),(5,'645072-e99c963d776c8771c68b30e946cbbda42860ceef.jpg',0,1,NULL,NULL,NULL,'2023-01-09 21:29:29','2023-03-27 18:03:06','2023-03-27 18:03:06',NULL),(6,'268440-what-to-serve-with-burgers-sq.webp',0,1,NULL,NULL,NULL,'2023-01-09 21:30:26','2023-03-27 18:03:11','2023-03-27 18:03:11',NULL),(7,'14911-458a39ff689e65e95305a33b57410ac6_w750_h500.jpg',0,1,NULL,NULL,NULL,'2023-01-09 21:31:15','2023-03-27 18:03:15','2023-03-27 18:03:15',NULL),(8,'',0,1,NULL,NULL,NULL,'2023-02-02 15:00:11','2023-03-19 14:39:23','2023-03-19 14:39:23','nationalty'),(9,'',0,1,NULL,NULL,NULL,'2023-03-19 14:36:07','2023-03-19 14:41:11','2023-03-19 14:41:11','nationalty'),(10,'',9,0,NULL,NULL,NULL,'2023-03-19 14:37:14','2023-03-19 14:37:14',NULL,NULL),(11,'',0,0,NULL,NULL,NULL,'2023-03-19 14:47:53','2023-03-19 15:04:11','2023-03-19 15:04:11','nationalty'),(12,'',0,0,NULL,NULL,NULL,'2023-03-19 14:48:53','2023-08-16 12:18:19',NULL,'nationalty'),(13,'',0,0,NULL,NULL,NULL,'2023-03-19 14:49:41','2023-03-20 12:58:21','2023-03-20 12:58:21',NULL),(14,'873986-download (70)-PhotoRoom.png-PhotoRoom.png',0,0,NULL,NULL,NULL,'2023-03-19 15:10:46','2024-01-20 12:21:41',NULL,NULL),(15,'952695-7492151e-7a3d-423c-917e-e5a8e64f280b-PhotoRoom.png-PhotoRoom.png',0,0,NULL,NULL,NULL,'2023-03-19 15:13:02','2024-01-20 12:21:43',NULL,NULL),(16,'',0,0,NULL,NULL,NULL,'2023-03-20 07:37:24','2023-08-16 12:18:21',NULL,'nationalty'),(17,'451968-favicon.ico',0,1,NULL,NULL,NULL,'2023-03-20 07:40:51','2023-03-20 07:44:43','2023-03-20 07:44:43',NULL),(18,'113790-IMG-20230327-WA0012.jpg',0,0,NULL,NULL,NULL,'2023-03-27 19:00:42','2023-03-27 19:01:32','2023-03-27 19:01:32',NULL),(19,'335785-IMG-20230403-WA0012.jpg',0,0,NULL,NULL,NULL,'2023-03-27 19:00:58','2024-01-20 12:21:45',NULL,NULL),(20,'640906-IMG-20230327-WA0012.jpg',0,0,NULL,NULL,NULL,'2023-03-27 19:00:59','2023-03-27 19:01:28','2023-03-27 19:01:28',NULL),(21,'',0,1,NULL,NULL,NULL,'2023-03-27 19:12:54','2023-03-27 19:16:54',NULL,'nationalty'),(22,'774854-IMG-20230403-WA0005.jpg',0,0,NULL,NULL,NULL,'2023-04-03 19:10:44','2024-01-20 12:21:44',NULL,NULL),(23,'129877-WhatsApp Image 2023-04-06 at 21.45.18.jpg',0,0,NULL,NULL,NULL,'2023-04-06 19:45:59','2024-01-20 12:21:45',NULL,NULL),(24,'',0,0,NULL,NULL,NULL,'2023-08-16 12:14:34','2023-08-16 12:14:34',NULL,'nationalty'),(25,'',0,1,NULL,NULL,NULL,'2023-08-16 12:15:10','2023-08-16 12:18:26',NULL,'nationalty'); /*!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` int unsigned NOT NULL AUTO_INCREMENT, `category_id` int unsigned NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `locale` varchar(255) 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 `category_translations_category_id_locale_unique` (`category_id`,`locale`), KEY `category_translations_locale_index` (`locale`), CONSTRAINT `category_translations_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=51 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` (`id`, `category_id`, `name`, `locale`, `created_at`, `updated_at`) VALUES (1,1,'السائقين','ar',NULL,NULL),(2,1,'السائقين','en',NULL,NULL),(3,2,'العاملين','ar',NULL,NULL),(4,2,'العاملين','en',NULL,NULL),(5,3,'تنظيف','ar',NULL,NULL),(6,3,'CLEANING','en',NULL,NULL),(7,4,'عامله منزليه مدربة سيريلانكا - سيلان','ar',NULL,NULL),(8,4,'CLEANING','en',NULL,NULL),(9,5,'دجاج','ar',NULL,NULL),(10,5,'chickens','en',NULL,NULL),(11,6,'برجر','ar',NULL,NULL),(12,6,'Burger','en',NULL,NULL),(13,7,'سمك','ar',NULL,NULL),(14,7,'fish','en',NULL,NULL),(15,8,'مصريه','ar',NULL,NULL),(16,8,'مصريه','en',NULL,NULL),(17,9,'تنظيف','ar',NULL,NULL),(18,9,'CLEANING','en',NULL,NULL),(19,10,'تنظيف','ar',NULL,NULL),(20,10,'CLEANING','en',NULL,NULL),(21,11,'عامل منزلى','ar',NULL,NULL),(22,11,'DOMESTIC HELPER','en',NULL,NULL),(23,12,'عامله منزلىه مدربه فلبينية','ar',NULL,NULL),(24,12,'DOMESTIC HELPER FILPINO','en',NULL,NULL),(25,13,'عامل منزلى','ar',NULL,NULL),(26,13,'DOMESTIC HELPER','en',NULL,NULL),(27,14,'عامله منزلىه مدربه نيباليه','ar',NULL,NULL),(28,14,'DOMESTIC HELPER','en',NULL,NULL),(29,15,'عامله منزليه مدربة فليبيه','ar',NULL,NULL),(30,15,'DOMESTIC HELPER','en',NULL,NULL),(31,16,'سائق هندى','ar',NULL,NULL),(32,16,'INDIA','en',NULL,NULL),(33,17,'سائق','ar',NULL,NULL),(34,17,'سائق','en',NULL,NULL),(35,18,'سائق','ar',NULL,NULL),(36,18,'DRIVER','en',NULL,NULL),(37,19,'سائق','ar',NULL,NULL),(38,19,'DRIVER','en',NULL,NULL),(39,20,'سائق','ar',NULL,NULL),(40,20,'DRIVER','en',NULL,NULL),(41,21,'عامله منزليه مدربة سيريلانكا - سيلان','ar',NULL,NULL),(42,21,'DOMESTIC HELPER SRILANKA','en',NULL,NULL),(43,22,'رعايه ذوى الاحتياجات الخاصة (كير جيفر )','ar',NULL,NULL),(44,22,'SPECIAL NEEDS CARE','en',NULL,NULL),(45,23,'خياطه','ar',NULL,NULL),(46,23,'SEWING','en',NULL,NULL),(47,24,'عامل منزلى','ar',NULL,NULL),(48,24,'DOMESTIC HELPER','en',NULL,NULL),(49,25,'عامله منزليه مدربة نيبالية','ar',NULL,NULL),(50,25,'DOMESTIC HELPER','en',NULL,NULL); /*!40000 ALTER TABLE `category_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(255) 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; /*!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 `government_translations` -- DROP TABLE IF EXISTS `government_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `government_translations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `government_id` int unsigned NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `locale` varchar(255) 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 `government_translations_government_id_locale_unique` (`government_id`,`locale`), KEY `government_translations_locale_index` (`locale`), CONSTRAINT `government_translations_government_id_foreign` FOREIGN KEY (`government_id`) REFERENCES `governments` (`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 `government_translations` -- LOCK TABLES `government_translations` WRITE; /*!40000 ALTER TABLE `government_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `government_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `governments` -- DROP TABLE IF EXISTS `governments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `governments` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `address_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_latitude` double DEFAULT NULL, `address_longitude` double 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 `governments` -- LOCK TABLES `governments` WRITE; /*!40000 ALTER TABLE `governments` DISABLE KEYS */; /*!40000 ALTER TABLE `governments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `landing_board_translations` -- DROP TABLE IF EXISTS `landing_board_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `landing_board_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `landing_board_id` bigint unsigned NOT NULL, `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `landing_board_translations_landing_board_id_locale_unique` (`landing_board_id`,`locale`), KEY `landing_board_translations_locale_index` (`locale`), CONSTRAINT `landing_board_translations_landing_board_id_foreign` FOREIGN KEY (`landing_board_id`) REFERENCES `landing_boards` (`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 `landing_board_translations` -- LOCK TABLES `landing_board_translations` WRITE; /*!40000 ALTER TABLE `landing_board_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `landing_board_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `landing_boards` -- DROP TABLE IF EXISTS `landing_boards`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `landing_boards` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `image` varchar(255) CHARACTER SET utf8mb4 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 `landing_boards` -- LOCK TABLES `landing_boards` WRITE; /*!40000 ALTER TABLE `landing_boards` DISABLE KEYS */; /*!40000 ALTER TABLE `landing_boards` 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(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=26 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` (`id`, `migration`, `batch`) VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2016_06_01_000001_create_oauth_auth_codes_table',1),(4,'2016_06_01_000002_create_oauth_access_tokens_table',1),(5,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(6,'2016_06_01_000004_create_oauth_clients_table',1),(7,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(8,'2019_08_19_000000_create_failed_jobs_table',1),(9,'2019_12_14_000001_create_personal_access_tokens_table',1),(10,'2021_07_13_111004_create_landing_boards_table',1),(11,'2021_07_13_111019_create_landing_board_translations_table',1),(12,'2021_10_06_143118_create_pages_table',1),(13,'2021_10_06_144323_create_page_translations_table',1),(14,'2021_11_09_130535_laratrust_setup_tables',1),(15,'2021_11_10_125654_create_categories_table',1),(16,'2021_11_10_125734_create_category_translations_table',1),(17,'2021_12_04_134842_create_word_dictionaries_table',1),(18,'2021_12_05_113718_create_public_notifcations_table',1),(19,'2022_04_06_112145_create_governments_table',1),(20,'2022_04_06_112222_create_government_translations_table',1),(21,'2022_04_06_112239_create_regions_table',1),(22,'2022_04_06_112319_create_region_translations_table',1),(23,'2022_12_31_130411_create_cart_users_table',1),(24,'2023_01_05_123151_create_workers_table',1),(25,'2023_01_06_153246_create_requests_table',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_access_tokens` -- DROP TABLE IF EXISTS `oauth_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_access_tokens` ( `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint unsigned DEFAULT NULL, `client_id` bigint unsigned NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `revoked` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `expires_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_access_tokens_user_id_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_access_tokens` -- LOCK TABLES `oauth_access_tokens` WRITE; /*!40000 ALTER TABLE `oauth_access_tokens` DISABLE KEYS */; INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES ('0644fb45e449ca795809fa59e2dce6ef53ae72a4866ab2bbb89d6911e45e7f2084e6a6fccb88eaea',9,1,'home','[]',0,'2023-02-19 20:40:51','2023-02-19 20:40:51','2024-02-19 22:40:51'),('0c131c93ccbfbdf4b40f311c2cdbf363d3095d1f9ef7618b75b7b013637ef2b843c0c2eac72a6121',146,1,'home','[]',0,'2024-01-21 20:11:04','2024-01-21 20:11:04','2025-01-21 21:11:04'),('0ca71c54194d416de7cc01eff7d12b618de9bef26b926e303ef273e239b8aec74684e83dd21ccbdf',7,1,'home','[]',0,'2023-01-09 21:02:34','2023-01-09 21:02:34','2024-01-09 23:02:34'),('17f437ee16329fe9429ef298a4b0fc6a4ee274ab0eeff7c7c1d0d4d6cf9ecfcc7cd3aa322d130546',7,1,'home','[]',0,'2023-01-09 20:46:29','2023-01-09 20:46:29','2024-01-09 22:46:29'),('1d0188c5731b6fa34572b6653372e2462319ff335852aea3634d756536a45fb23b3ceafb74d43e66',148,1,'home','[]',0,'2024-11-26 11:01:11','2024-11-26 11:01:11','2025-11-26 11:01:11'),('1e7b6168f49f8d984153cc6feb87354db25ca946ce27cbcba1310dcc86e64f90a2be80edda476b38',5,1,'home','[]',0,'2023-01-09 13:38:24','2023-01-09 13:38:24','2024-01-09 15:38:24'),('24ec65d25e5162212a7d922d15f95ece5d7e38d58a757fd2088bcd6904d6094c40b114e08bd816bb',145,1,'home','[]',0,'2023-09-02 00:06:58','2023-09-02 00:06:58','2024-09-02 00:06:58'),('299f02765d3174aeec6c6e051c780b230b6c82cdf5aa2f63592ccf2adbac9bc96e4a934244c0df47',12,1,'home','[]',0,'2023-02-21 23:57:03','2023-02-21 23:57:03','2024-02-22 01:57:03'),('2a5687fe2eee809e55d6b8f2ee4472db0bfbd77b67fb10faf9cdd821419bdca6cf9f9b213e574524',7,1,'home','[]',0,'2023-02-03 11:31:12','2023-02-03 11:31:12','2024-02-03 13:31:12'),('2cfdc915b3fbc83cff70e21580ba01e1df7926e49ff8f2b91074cff6b9bd5e36fad4b572abaa9992',12,1,'home','[]',0,'2023-03-21 07:25:20','2023-03-21 07:25:20','2024-03-21 09:25:20'),('37a0e8d12546c53971270b24b677653d1f0a0f2925cdcffe02ddb14225c14097ae4c849730b5623a',6,1,'home','[]',0,'2023-01-09 13:35:06','2023-01-09 13:35:06','2024-01-09 15:35:06'),('37dfe228b6f195df8b1389551503b3d0a5491fffb6301b3504b928064c7c2f4164c5f04e007f79b6',5,1,'home','[]',0,'2023-01-09 13:22:54','2023-01-09 13:22:54','2024-01-09 15:22:54'),('3d5c0e66e0ff3b6c0e2a25ffd3f395f785665d6d944e0998c67f7fcd439ec547cb17cd53b2d071b0',7,1,'home','[]',0,'2023-01-09 20:47:26','2023-01-09 20:47:26','2024-01-09 22:47:26'),('473a6a05e6af05417b02b3960e2a44f1f0b00c104c440151325bb83e441278918d5f2dadfa6ef093',12,1,'home','[]',0,'2023-03-21 09:18:13','2023-03-21 09:18:13','2024-03-21 11:18:13'),('4a8de66a17c7c7479f410badd6bdc122e1320add4c738cc397bcdb9100c67f0e2a4d856d1ffdb50f',157,1,'home','[]',0,'2025-10-03 21:18:45','2025-10-03 21:18:45','2026-10-03 21:18:45'),('50c0791cb92d8cfaa4448f08231e0004125773821ecae4f76bd733e47ee93244a7b26e6f662d639c',12,1,'home','[]',0,'2023-03-03 22:05:28','2023-03-03 22:05:28','2024-03-04 00:05:28'),('5398eee32c6fcb4189d178403ecaa7b2ed913bace3d0f90ad7edbc6d488d81b3900463499b2a56fa',13,1,'home','[]',0,'2023-03-16 18:35:20','2023-03-16 18:35:20','2024-03-16 20:35:20'),('5632ead453d3e558da5a8947faaed6e525099ca996bc70fc0ef8662ba2f8f30906da80d04b3f0308',153,1,'home','[]',0,'2025-02-01 17:27:30','2025-02-01 17:27:30','2026-02-01 17:27:30'),('589670893eed078296b96dfda8ee15047f9cd61cb85f70650015933ab99a68901b9d2476e242a092',12,1,'home','[]',0,'2023-03-04 09:35:56','2023-03-04 09:35:56','2024-03-04 11:35:56'),('5d58bdcc7523d413467242a4195d610115fd9065ee8f3edd31290fbee0a10f539ff8d5c06b42eb1d',157,1,'home','[]',0,'2025-10-03 21:18:49','2025-10-03 21:18:49','2026-10-03 21:18:49'),('61aa618df0d250d6038aaf5bf6c9f75646634c26bf489f623137c02f286252ee35a9e52360da3a30',12,1,'home','[]',0,'2023-02-27 18:25:36','2023-02-27 18:25:36','2024-02-27 20:25:36'),('65b96f03bbcb74f9829de27e5075e8d66d24bbb101302efbaf108d29dbe7232cbd80757933256e8b',146,1,'home','[]',0,'2024-01-21 20:20:21','2024-01-21 20:20:21','2025-01-21 21:20:21'),('6edbc6a31e70a4cc1e982d95606338bbfd1ec1193c5cfe2b5eebfd36baec5d08c9a38e7dccab6bcb',151,1,'home','[]',0,'2025-04-18 18:49:52','2025-04-18 18:49:52','2026-04-18 18:49:52'),('7142512bd6efbe5ab69cc95aa783a7261ef31f46550399e8a79cd70d8dafd0e82fa1fbb59e953489',5,1,'home','[]',0,'2023-01-09 13:25:25','2023-01-09 13:25:25','2024-01-09 15:25:25'),('7264cbc99d175f857a35a5614baa2a72d0d3e01b9672ffa3d2a128e83e88dab8d501482f1fffc88c',157,1,'home','[]',0,'2025-10-03 21:18:53','2025-10-03 21:18:53','2026-10-03 21:18:53'),('74332446f5874640904804315876bc4b686339d40267cdd13c63cbbb3f67ce441b9eec3eedc8d598',7,1,'home','[]',0,'2023-02-03 11:32:28','2023-02-03 11:32:28','2024-02-03 13:32:28'),('75a39e6c06aa6c474c21115342ffe6890a4b81a4d486c87d519b441201c9266f75654842e5426c33',7,1,'home','[]',0,'2023-02-02 23:05:44','2023-02-02 23:05:44','2024-02-03 01:05:44'),('75f6f8c303235f78dbebbf61685b6fd28b1da3966b3deae15e998b077a1a72aa238cab3eec5ed8c9',157,1,'home','[]',0,'2025-10-03 22:26:28','2025-10-03 22:26:28','2026-10-03 22:26:28'),('799573e71e6e87bbe86c173f755bc855af980b2fc7d95224843cc1bb227f3f6e4199a6433aac7673',5,1,'home','[]',0,'2023-01-09 12:37:25','2023-01-09 12:37:25','2024-01-09 14:37:25'),('7b024002c24f5ae062f55bf7d116bfaef4a07c9dc69c0d6f4e4ff03dde34aee64e2edbf4effff8f7',10,1,'home','[]',0,'2023-02-19 20:45:10','2023-02-19 20:45:10','2024-02-19 22:45:10'),('7bc38b16197c8a75d7ccdce544cf03ac0b0f4fa88fdf1c3b858a7b7f764ced51ee40f6ed60e7ea87',143,1,'home','[]',0,'2023-08-09 05:24:44','2023-08-09 05:24:44','2024-08-09 08:24:44'),('7e9451af6f843217d5a695d91f4c61563354243211b1a9adcfe8909eebe0b8dba8691a9a65339f82',154,1,'home','[]',0,'2025-02-23 10:33:12','2025-02-23 10:33:12','2026-02-23 10:33:12'),('8039adda7c7c8a650f818d3caeba2596223f333987b654361560fbf1a8b2ba54ba25347cd340c183',12,1,'home','[]',0,'2023-03-21 09:26:50','2023-03-21 09:26:50','2024-03-21 11:26:50'),('860a9088db1faac7e0bad612bebec65a3d144ed5db2c38fc5c850d2385b5e78690174836d5eef711',146,1,'home','[]',0,'2024-01-21 20:20:16','2024-01-21 20:20:16','2025-01-21 21:20:16'),('86470943fa58985d767f1270201e80e7b461a29dbd1a5d577c423c3d98561be7d0c97e2497cdb620',12,1,'home','[]',0,'2023-02-27 13:06:04','2023-02-27 13:06:04','2024-02-27 15:06:04'),('8b01066bfbc5af2ce91638023b734e74662f4e7181521f1dc62a5eb6fd361d6ae400da897a284737',145,1,'home','[]',0,'2023-09-02 00:06:56','2023-09-02 00:06:56','2024-09-02 00:06:56'),('8bc3ba4e168f29f52629ca8568016b5a3d8617440a3b5ba46c906f8604f27d83bf4663bad669c4d8',156,1,'home','[]',0,'2025-04-28 17:11:18','2025-04-28 17:11:18','2026-04-28 17:11:18'),('9543db9b5689d904422edc226bd155a8c8de15d1a0b4d86891773489a114fb4e46c6e8dafb731540',12,1,'home','[]',0,'2023-02-28 13:32:42','2023-02-28 13:32:42','2024-02-28 15:32:42'),('9584f20d07f958a1adc95a6799c2211a8e5a00ec21ee116f1dfd977149b728a85c4d9c6cb20b477f',12,1,'home','[]',0,'2023-03-03 20:24:15','2023-03-03 20:24:15','2024-03-03 22:24:15'),('973b00501ac2c9eb4510a2d2840f1b48280c8654c1362a15ceb415bcb491386eefb30f85971669b2',148,1,'home','[]',0,'2024-11-26 11:02:26','2024-11-26 11:02:26','2025-11-26 11:02:26'),('9a5c887de2dae4fc3e2e99653e30d2e136836a1bc3fdd3ca8e54d140f6d1babe07675c6ea9cefeac',156,1,'home','[]',0,'2025-04-28 17:11:22','2025-04-28 17:11:22','2026-04-28 17:11:22'),('9b696ad0897e511293c205ca645e6e4392ce5709cff86ac47c45c9053f698f79c3437491d8353005',12,1,'home','[]',0,'2023-02-20 22:37:09','2023-02-20 22:37:09','2024-02-21 00:37:09'),('9ca4764d5182656f1134f69a98a7c089059190a4be8337d10918b8d585d3103e2b2580c8d8806f36',5,1,'home','[]',0,'2023-01-09 13:25:53','2023-01-09 13:25:53','2024-01-09 15:25:53'),('9d5f2a67e9afeac178580d056aa818505453d8b64b752896fc4a60397c0b89e342caec867ac0626f',12,1,'home','[]',0,'2023-02-28 13:33:04','2023-02-28 13:33:04','2024-02-28 15:33:04'),('9dd5c81d6add2506c627f5aeae3883db3811cab666832d6f4b777748a4306ae45508d51c8c2e9d33',7,1,'home','[]',0,'2023-01-10 09:22:35','2023-01-10 09:22:35','2024-01-10 11:22:35'),('9e8cf6a5a9d3161b76617007ec65c6a1d18269daae6ffa391cb31802bbe033738cb84b6d541a784f',12,1,'home','[]',0,'2023-03-26 18:03:24','2023-03-26 18:03:24','2024-03-26 20:03:24'),('a186db261be0b46275d392dda542df13879364b6b02b827e0b61c17868742103ca5e1ac840a50bda',12,1,'home','[]',0,'2023-02-28 07:47:17','2023-02-28 07:47:17','2024-02-28 09:47:17'),('ac51e4ffb465879f39b4ba4d5a27cb98f681a491238102a418f71f34469d01c45f358ec9b8f646ef',5,1,'home','[]',0,'2023-01-09 12:39:50','2023-01-09 12:39:50','2024-01-09 14:39:50'),('ae530e1a19f4d772ae72813cb9ed60b3f153d10b0ccb9eb0473306585c1ee75cc07d738bb0e24d37',8,1,'home','[]',0,'2023-02-19 20:38:40','2023-02-19 20:38:40','2024-02-19 22:38:40'),('af081e0b85368b20a91bd0949ddfaac6565c270561d9c054c78a047282b287aee0788492e16a701d',156,1,'home','[]',0,'2025-04-28 17:12:09','2025-04-28 17:12:09','2026-04-28 17:12:09'),('b1adb62f4d599ba7c1727e94fecc7bc08a6fa2f8ef07b2c2661040aa57103d0919bee9edbf425375',148,1,'home','[]',0,'2024-11-26 11:02:30','2024-11-26 11:02:30','2025-11-26 11:02:30'),('b37cb6e3eb17c55f76f97cc217a11505777a8fae97939af068cc2e237f16c9036ad9639f459fa482',148,1,'home','[]',0,'2024-11-26 11:02:01','2024-11-26 11:02:01','2025-11-26 11:02:01'),('b4a03e60387028640032698dbb74042febf9e69da118f64c2d4cece4141f9bd49ab590e318286da7',146,1,'home','[]',0,'2024-01-21 20:20:19','2024-01-21 20:20:19','2025-01-21 21:20:19'),('bb8495077637b136a97d1b7801bc01925db4d47757f37f9e09ace54e6eb8b466172508356a680404',3,1,'home','[]',0,'2023-01-06 14:01:36','2023-01-06 14:01:36','2024-01-06 17:01:36'),('bb90e1afcc27471702fe20c96efcc49c982878e91a4b50a786e75d9e492efad7b8e154ef9d2a1e05',12,1,'home','[]',0,'2023-03-21 09:15:35','2023-03-21 09:15:35','2024-03-21 11:15:35'),('bcf6d1f05fa3a15d42a8581ac39f925e7a67137c4c4c3507760ab05df823eba6974b3f790930820c',5,1,'home','[]',0,'2023-01-09 13:24:58','2023-01-09 13:24:58','2024-01-09 15:24:58'),('bdc10cfb86bccded9d6899bfe0780557562eabd06d12c8c19ed76649edc598457720900f16a06a3c',5,1,'home','[]',0,'2023-01-09 13:24:29','2023-01-09 13:24:29','2024-01-09 15:24:29'),('beefb777ab35cc8b64d378ecc7a57d3d31802b41ca282780de32be17735489ee73de941968e28174',4,1,'home','[]',0,'2023-01-09 12:36:49','2023-01-09 12:36:49','2024-01-09 14:36:49'),('c0673a575885fc464bb98c9fcc9d90a1de1a9c37ac6cce2c72e27c8fa181ed330e1fc9effb747768',145,1,'home','[]',0,'2023-09-02 00:00:53','2023-09-02 00:00:53','2024-09-02 00:00:53'),('c0eb77bc2574784a6f10c64689ff7ce42d216d1bf48b07f811d8b1ebe2b124384def38c670e3184d',9,1,'home','[]',0,'2023-02-19 20:39:54','2023-02-19 20:39:54','2024-02-19 22:39:54'),('c18bb8ceb26704fc6d95c7d30b1f4722a90cb657ff94479f938032940767379c95ebe8f246e54529',146,1,'home','[]',0,'2024-01-21 20:11:44','2024-01-21 20:11:44','2025-01-21 21:11:44'),('c1b8d33d6346d956dc8d4bc7b03c5d81f46a2fdbc0df0a4b2cbd61ca9f88d7cf182dfc38fad486d1',12,1,'home','[]',0,'2023-02-20 22:37:28','2023-02-20 22:37:28','2024-02-21 00:37:28'),('c8fd7f4e6536d077e617508e77b84436d95d560e6e09df61e8245694403e699e8bb57b687a334da1',145,1,'home','[]',0,'2023-09-02 00:06:54','2023-09-02 00:06:54','2024-09-02 00:06:54'),('c986ce7cc982b5c733b3121253325c838e827aef378266cee4ce5b87e3c981ea7c8ef818d2f78368',12,1,'home','[]',0,'2023-04-06 14:52:17','2023-04-06 14:52:17','2024-04-06 16:52:17'),('ce0c36ff2c1c6f1ef8a8591753cdc0e61302925315fe6b9fcb0cb32e7fff9024db0562472242e940',12,1,'home','[]',0,'2023-02-28 15:32:24','2023-02-28 15:32:24','2024-02-28 17:32:24'),('d1760ec113f6b8dcb77044c6f31c4463339a02bd7172caf0cfb599fbc8fb5ad129488de5109057f3',7,1,'home','[]',0,'2023-01-09 20:47:10','2023-01-09 20:47:10','2024-01-09 22:47:10'),('dd9c7c18b63b9354b96e3752963e22c4b6ad3f09631e6aeecae00595c8c6bf3d56d2083b655f6684',11,1,'home','[]',0,'2023-02-20 22:34:14','2023-02-20 22:34:14','2024-02-21 00:34:14'),('e22ff7efb4671eab2ac0821894dae7fc46c262c31c2d03cd43d883d367d95ba704a2a6a36bc173ab',12,1,'home','[]',0,'2023-03-20 20:40:32','2023-03-20 20:40:32','2024-03-20 22:40:32'),('e361f36598a663e39f85a2bda2918975dde7213bef26579a403c71f19b3bd2b351d8d11ce540b7a9',13,1,'home','[]',0,'2023-08-20 15:36:12','2023-08-20 15:36:12','2024-08-20 18:36:12'),('e3e38e0a0a16914e9723a45fccf23370c69dcc3c190356d7497165a13e7818f5fce4d3e5316eb545',12,1,'home','[]',0,'2023-03-21 08:15:05','2023-03-21 08:15:05','2024-03-21 10:15:05'),('e68cc41a8eab8a39b38a7c35f970e9517748109bb628b37c7727f1bf9fb6c2c22269b7ceeae95997',5,1,'home','[]',0,'2023-01-09 13:25:01','2023-01-09 13:25:01','2024-01-09 15:25:01'),('e75ccc8172bcef750d8da4e71c807f4f1744b00792d7f4da147e60f26454f19d092fbac1536265d8',12,1,'home','[]',0,'2023-03-01 08:36:45','2023-03-01 08:36:45','2024-03-01 10:36:45'),('e7f92e6b50ee991372611afba85a2be03d148f009e9f03a5216fcd4d0c5c8a685ad5837cad036e34',12,1,'home','[]',0,'2023-03-06 20:56:48','2023-03-06 20:56:48','2024-03-06 22:56:48'),('ea02d9194a508ba8022b044a8070cd7cde8a328307708000e6907eee0ee9e476b4522aea4e8e3d02',1,1,'home','[]',0,'2023-03-20 07:36:02','2023-03-20 07:36:02','2024-03-20 09:36:02'),('ebfa4d28b12e904dc8e76c2d75e3350ed17be23ffb2b30955e12ec3a30faa98a153d9cac2004b617',155,1,'home','[]',0,'2025-08-06 21:31:15','2025-08-06 21:31:15','2026-08-06 21:31:15'),('f40e17dec4323f8ff918bdaba0328019da522424490185ad73e6d974a04d122f165832c0dafe1555',12,1,'home','[]',0,'2023-03-04 07:37:14','2023-03-04 07:37:14','2024-03-04 09:37:14'),('f50e8f752aea34499484187bac8a1eca4a16d372b2bd4baccae3a8acb6749812e1ad397e5750f90a',155,1,'home','[]',0,'2025-08-06 21:31:17','2025-08-06 21:31:17','2026-08-06 21:31:17'),('f962c05f619ce64f600b8c53ec6d29ab21800496320487f12c5207326a3df9299c0d2d37c49ab3c2',158,1,'home','[]',0,'2025-10-05 12:48:15','2025-10-05 12:48:15','2026-10-05 12:48:15'); /*!40000 ALTER TABLE `oauth_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_auth_codes` -- DROP TABLE IF EXISTS `oauth_auth_codes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_auth_codes` ( `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint unsigned NOT NULL, `client_id` bigint unsigned NOT NULL, `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `revoked` tinyint(1) NOT NULL, `expires_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_auth_codes_user_id_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_auth_codes` -- LOCK TABLES `oauth_auth_codes` WRITE; /*!40000 ALTER TABLE `oauth_auth_codes` DISABLE KEYS */; /*!40000 ALTER TABLE `oauth_auth_codes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_clients` -- DROP TABLE IF EXISTS `oauth_clients`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_clients` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `secret` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `provider` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `redirect` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `personal_access_client` tinyint(1) NOT NULL, `password_client` tinyint(1) NOT NULL, `revoked` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_clients_user_id_index` (`user_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 `oauth_clients` -- LOCK TABLES `oauth_clients` WRITE; /*!40000 ALTER TABLE `oauth_clients` DISABLE KEYS */; INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES (1,NULL,'Laravel Personal Access Client','VRks8F523IiY9GirGdNcmFyTjzGQLb6ZeY8bxMWz',NULL,'http://localhost',1,0,0,'2023-01-06 14:01:25','2023-01-06 14:01:25'); /*!40000 ALTER TABLE `oauth_clients` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_personal_access_clients` -- DROP TABLE IF EXISTS `oauth_personal_access_clients`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_personal_access_clients` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `client_id` bigint unsigned 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_personal_access_clients` -- LOCK TABLES `oauth_personal_access_clients` WRITE; /*!40000 ALTER TABLE `oauth_personal_access_clients` DISABLE KEYS */; INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES (1,1,'2023-01-06 14:01:25','2023-01-06 14:01:25'); /*!40000 ALTER TABLE `oauth_personal_access_clients` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_refresh_tokens` -- DROP TABLE IF EXISTS `oauth_refresh_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_refresh_tokens` ( `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `access_token_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `revoked` tinyint(1) NOT NULL, `expires_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_refresh_tokens` -- LOCK TABLES `oauth_refresh_tokens` WRITE; /*!40000 ALTER TABLE `oauth_refresh_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `oauth_refresh_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `page_translations` -- DROP TABLE IF EXISTS `page_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `page_translations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `page_id` bigint unsigned NOT NULL, `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), UNIQUE KEY `page_translations_page_id_locale_unique` (`page_id`,`locale`), KEY `page_translations_locale_index` (`locale`), CONSTRAINT `page_translations_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `pages` (`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 `page_translations` -- LOCK TABLES `page_translations` WRITE; /*!40000 ALTER TABLE `page_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `page_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pages` -- DROP TABLE IF EXISTS `pages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pages` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `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 `pages` -- LOCK TABLES `pages` WRITE; /*!40000 ALTER TABLE `pages` DISABLE KEYS */; /*!40000 ALTER TABLE `pages` 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(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) CHARACTER SET utf8mb4 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 `permission_role` -- DROP TABLE IF EXISTS `permission_role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `permission_role` ( `permission_id` bigint unsigned NOT NULL, `role_id` bigint unsigned NOT NULL, PRIMARY KEY (`permission_id`,`role_id`), KEY `permission_role_role_id_foreign` (`role_id`), CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`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 `permission_role` -- LOCK TABLES `permission_role` WRITE; /*!40000 ALTER TABLE `permission_role` DISABLE KEYS */; INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(28,1),(29,1),(30,1),(31,1),(32,1),(1,5),(2,5),(3,5),(4,5),(5,5),(6,5),(9,5),(10,5),(11,5),(12,5),(13,5),(14,5),(15,5),(16,5),(17,5),(18,5),(19,5),(20,5),(21,5),(22,5),(23,5),(24,5),(25,5),(26,5),(27,5),(28,5),(1,6),(2,6),(3,6),(4,6),(5,6),(6,6),(9,6),(10,6),(11,6),(12,6),(13,6),(14,6),(15,6),(16,6),(17,6),(18,6),(19,6),(20,6),(21,6),(22,6),(23,6),(24,6),(25,6),(26,6),(27,6),(28,6); /*!40000 ALTER TABLE `permission_role` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permission_user` -- DROP TABLE IF EXISTS `permission_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `permission_user` ( `permission_id` bigint unsigned NOT NULL, `user_id` bigint unsigned NOT NULL, `user_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`user_id`,`permission_id`,`user_type`), KEY `permission_user_permission_id_foreign` (`permission_id`), CONSTRAINT `permission_user_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`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 `permission_user` -- LOCK TABLES `permission_user` WRITE; /*!40000 ALTER TABLE `permission_user` DISABLE KEYS */; /*!40000 ALTER TABLE `permission_user` 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(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `permissions_name_unique` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=33 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` (`id`, `name`, `display_name`, `description`, `created_at`, `updated_at`) VALUES (1,'create_users','Create Users','Create Users','2023-01-06 12:58:58','2023-01-06 12:58:58'),(2,'read_users','Read Users','Read Users','2023-01-06 12:58:58','2023-01-06 12:58:58'),(3,'update_users','Update Users','Update Users','2023-01-06 12:58:58','2023-01-06 12:58:58'),(4,'delete_users','Delete Users','Delete Users','2023-01-06 12:58:58','2023-01-06 12:58:58'),(5,'create_settings','Create Settings','Create Settings','2023-01-06 12:58:58','2023-01-06 12:58:58'),(6,'read_settings','Read Settings','Read Settings','2023-01-06 12:58:58','2023-01-06 12:58:58'),(7,'update_settings','Update Settings','Update Settings','2023-01-06 12:58:58','2023-01-06 12:58:58'),(8,'delete_settings','Delete Settings','Delete Settings','2023-01-06 12:58:58','2023-01-06 12:58:58'),(9,'create_roles','Create Roles','Create Roles','2023-01-06 12:58:58','2023-01-06 12:58:58'),(10,'read_roles','Read Roles','Read Roles','2023-01-06 12:58:58','2023-01-06 12:58:58'),(11,'update_roles','Update Roles','Update Roles','2023-01-06 12:58:58','2023-01-06 12:58:58'),(12,'delete_roles','Delete Roles','Delete Roles','2023-01-06 12:58:58','2023-01-06 12:58:58'),(13,'create_clients','Create Clients','Create Clients','2023-01-06 12:58:58','2023-01-06 12:58:58'),(14,'read_clients','Read Clients','Read Clients','2023-01-06 12:58:58','2023-01-06 12:58:58'),(15,'update_clients','Update Clients','Update Clients','2023-01-06 12:58:58','2023-01-06 12:58:58'),(16,'delete_clients','Delete Clients','Delete Clients','2023-01-06 12:58:58','2023-01-06 12:58:58'),(17,'create_employee','Create Employee','Create Employee','2023-01-06 12:58:58','2023-01-06 12:58:58'),(18,'read_employee','Read Employee','Read Employee','2023-01-06 12:58:58','2023-01-06 12:58:58'),(19,'update_employee','Update Employee','Update Employee','2023-01-06 12:58:58','2023-01-06 12:58:58'),(20,'delete_employee','Delete Employee','Delete Employee','2023-01-06 12:58:58','2023-01-06 12:58:58'),(21,'create_services','Create Services','Create Services','2023-01-06 12:58:58','2023-01-06 12:58:58'),(22,'read_services','Read Services','Read Services','2023-01-06 12:58:58','2023-01-06 12:58:58'),(23,'update_services','Update Services','Update Services','2023-01-06 12:58:58','2023-01-06 12:58:58'),(24,'delete_services','Delete Services','Delete Services','2023-01-06 12:58:58','2023-01-06 12:58:58'),(25,'create_categories','Create Categories','Create Categories','2023-01-06 12:58:58','2023-01-06 12:58:58'),(26,'read_categories','Read Categories','Read Categories','2023-01-06 12:58:58','2023-01-06 12:58:58'),(27,'update_categories','Update Categories','Update Categories','2023-01-06 12:58:58','2023-01-06 12:58:58'),(28,'delete_categories','Delete Categories','Delete Categories','2023-01-06 12:58:58','2023-01-06 12:58:58'),(29,'create_workers','Create Workers','Create Workers','2023-01-06 12:58:58','2023-01-06 12:58:58'),(30,'read_workers','Read Workers','Read Workers','2023-01-06 12:58:58','2023-01-06 12:58:58'),(31,'update_workers','Update Workers','Update Workers','2023-01-06 12:58:58','2023-01-06 12:58:58'),(32,'delete_workers','Delete Workers','Delete Workers','2023-01-06 12:58:58','2023-01-06 12:58:58'); /*!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(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint unsigned NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `last_used_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 `public_notifcations` -- DROP TABLE IF EXISTS `public_notifcations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `public_notifcations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `user_id` int unsigned DEFAULT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `data` text 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 `public_notifcations_user_id_foreign` (`user_id`), CONSTRAINT `public_notifcations_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 `public_notifcations` -- LOCK TABLES `public_notifcations` WRITE; /*!40000 ALTER TABLE `public_notifcations` DISABLE KEYS */; /*!40000 ALTER TABLE `public_notifcations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `region_translations` -- DROP TABLE IF EXISTS `region_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `region_translations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `region_id` int unsigned NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `locale` varchar(255) 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 `region_translations_region_id_locale_unique` (`region_id`,`locale`), KEY `region_translations_locale_index` (`locale`), CONSTRAINT `region_translations_region_id_foreign` FOREIGN KEY (`region_id`) REFERENCES `regions` (`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 `region_translations` -- LOCK TABLES `region_translations` WRITE; /*!40000 ALTER TABLE `region_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `region_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `regions` -- DROP TABLE IF EXISTS `regions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `regions` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `status` tinyint(1) NOT NULL DEFAULT '1', `address_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_latitude` double DEFAULT NULL, `address_longitude` double DEFAULT NULL, `governments_id` int unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `regions_governments_id_foreign` (`governments_id`), CONSTRAINT `regions_governments_id_foreign` FOREIGN KEY (`governments_id`) REFERENCES `governments` (`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 `regions` -- LOCK TABLES `regions` WRITE; /*!40000 ALTER TABLE `regions` DISABLE KEYS */; /*!40000 ALTER TABLE `regions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `requests` -- DROP TABLE IF EXISTS `requests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `requests` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `order_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `worker_id` int unsigned DEFAULT NULL, `category_id` int unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `user_id` int DEFAULT NULL, `Occupation` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `note` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `requests_worker_id_foreign` (`worker_id`), KEY `requests_category_id_foreign` (`category_id`), CONSTRAINT `requests_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, CONSTRAINT `requests_worker_id_foreign` FOREIGN KEY (`worker_id`) REFERENCES `workers` (`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 `requests` -- LOCK TABLES `requests` WRITE; /*!40000 ALTER TABLE `requests` DISABLE KEYS */; /*!40000 ALTER TABLE `requests` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role_user` -- DROP TABLE IF EXISTS `role_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `role_user` ( `role_id` bigint unsigned NOT NULL, `user_id` bigint unsigned NOT NULL, `user_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`user_id`,`role_id`,`user_type`), KEY `role_user_role_id_foreign` (`role_id`), CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`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 `role_user` -- LOCK TABLES `role_user` WRITE; /*!40000 ALTER TABLE `role_user` DISABLE KEYS */; INSERT INTO `role_user` (`role_id`, `user_id`, `user_type`) VALUES (1,1,'App\\Models\\User'),(1,13,'App\\Models\\User'),(1,141,'App\\Models\\User'),(1,144,'App\\Models\\User'); /*!40000 ALTER TABLE `role_user` 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(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `roles_name_unique` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=7 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` (`id`, `name`, `display_name`, `description`, `created_at`, `updated_at`) VALUES (1,'super_admin','Super Admin','Super Admin','2023-01-06 12:58:58','2023-01-06 12:58:58'),(2,'admin','Admin','Admin','2023-01-06 12:58:58','2023-01-06 12:58:58'),(4,'employee','Employee','Employee','2023-01-06 12:58:58','2023-01-06 12:58:58'),(5,'MOATAZ ELANANY',NULL,NULL,'2023-04-06 20:01:23','2023-04-06 20:01:23'),(6,'HAMAD ASHKANANI (BO GASEM )',NULL,NULL,'2023-04-06 20:05:36','2023-04-16 20:29:53'); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `slider_translations` -- DROP TABLE IF EXISTS `slider_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `slider_translations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `slider_id` int unsigned NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `locale` varchar(255) 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 `slider_translations_slider_id_locale_unique` (`slider_id`,`locale`), KEY `slider_translations_locale_index` (`locale`), CONSTRAINT `slider_translations_slider_id_foreign` FOREIGN KEY (`slider_id`) REFERENCES `sliders` (`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 `slider_translations` -- LOCK TABLES `slider_translations` WRITE; /*!40000 ALTER TABLE `slider_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `slider_translations` 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` int unsigned NOT NULL AUTO_INCREMENT, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` enum('none','category','product') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'none', `id_number` int DEFAULT NULL, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `banner` int DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=76 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 */; INSERT INTO `sliders` (`id`, `image`, `type`, `id_number`, `status`, `created_at`, `updated_at`, `banner`) VALUES (9,'897944-VJGJKGHK1.jpg','none',NULL,'1','2023-01-10 10:11:36','2023-06-13 16:24:08',0),(32,'739732-WhatsApp Image 2023-04-20 at 21.57.53.jpg','none',NULL,'1','2023-04-03 19:23:34','2023-04-20 20:35:31',0),(33,'846573-WhatsApp Image 2023-04-15 at 22.44.17.jpg','none',NULL,'1','2023-04-03 19:23:53','2023-04-15 20:46:37',0),(35,'351529-WhatsApp Image 2023-04-08 at 20.37.06.jpg','none',NULL,'1','2023-04-03 19:24:25','2023-04-15 20:50:57',0),(36,'600120-IMG-20230403-WA0006.jpg','none',NULL,'1','2023-04-03 19:24:46','2023-04-03 19:24:46',0),(38,'816652-WhatsApp Image 2023-04-20 at 22.35.51.jpg','none',NULL,'1','2023-04-03 19:25:26','2023-04-20 20:37:03',0),(39,'860407-WhatsApp Image 2023-04-20 at 21.15.42.jpg','none',NULL,'1','2023-04-03 19:25:44','2023-04-20 19:18:23',0),(42,'136909-IMG-20230403-WA0003.jpg','none',NULL,'1','2023-04-03 19:26:49','2023-04-15 20:49:36',0),(45,'666955-WhatsApp Image 2023-04-24 at 14.02.28.jpg','none',NULL,'1','2023-04-03 19:27:53','2023-04-24 12:03:03',0),(49,'258842-WhatsApp Image 2023-04-20 at 21.21.44.jpg','none',NULL,'1','2023-04-03 19:33:32','2023-04-20 19:22:26',0),(51,'713859-WhatsApp Image 2023-04-20 at 22.47.58.jpg','none',NULL,'1','2023-04-03 19:36:41','2023-04-20 21:51:48',0),(52,'305412-WhatsApp Image 2023-04-20 at 21.43.48.jpg','none',NULL,'1','2023-04-03 19:39:49','2023-04-20 19:44:16',0),(58,'799535-WhatsApp Image 2023-04-03 at 21.58.01.jpg','none',NULL,'1','2023-04-03 20:50:56','2023-04-03 20:50:56',0),(63,'426289-WhatsApp Image 2023-04-08 at 22.54.12.jpg','none',NULL,'1','2023-04-08 20:54:48','2023-04-08 20:54:48',0),(66,'385190-WhatsApp Image 2023-04-15 at 22.25.42.jpg','none',NULL,'1','2023-04-15 20:26:34','2023-04-15 20:26:34',0),(69,'373539-WhatsApp Image 2023-04-19 at 23.21.04.jpg','none',NULL,'1','2023-04-19 21:21:39','2023-04-19 21:21:39',0),(75,'597513-WhatsApp Image 2023-08-16 at 16.56.59 (1).png','none',NULL,'1','2023-06-13 16:22:49','2023-08-16 14:00:11',0); /*!40000 ALTER TABLE `sliders` 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` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'defualt.png', `civil_id` int DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bocket_money` double(8,2) NOT NULL DEFAULT '0.00', `device_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `activation_code` int DEFAULT NULL, `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=159 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` (`id`, `name`, `email`, `email_verified_at`, `password`, `image`, `civil_id`, `status`, `phone`, `bocket_money`, `device_token`, `activation_code`, `remember_token`, `created_at`, `updated_at`) VALUES (1,'admin','admin@admin.com',NULL,'$2y$10$LnnUpCPgjnfq2fK5uPcrVepJuyfa0f2hIoch/SbPwge1fESAQ.nBG','defualt.png',NULL,1,NULL,0.00,NULL,NULL,NULL,'2023-01-06 12:58:58','2023-04-06 20:14:09'),(11,'Ahmed gmail','anwerasd@gmail.com',NULL,'$2y$10$In.j9/xsPRSzKReNXUq1uO7N7AE4XziYfMsCBrLgbeyzoO.KeyZ.S','defualt.png',NULL,1,'+96567782374',0.00,'123',57956,NULL,'2023-02-20 22:34:14','2023-02-20 22:34:14'),(13,'MOATAZ ELANANY','moatazelanany43@gmail.com',NULL,'$2y$10$Piq1N5si09SsgZYzpcLm1evrhZMii0/Y/mQzgIuBAc67ydgVIQ0da','defualt.png',NULL,1,'+96551546177',0.00,'123',45429,NULL,'2023-03-16 18:35:19','2023-04-06 20:02:12'),(141,'asd','asdasd@gmail.com',NULL,'$2y$10$zpozq47Cs4.thvxXgiF8Y.FEYrRoXG4L.ZJjf7MUhF1z4WD9yw8LW','defualt.png',NULL,0,NULL,0.00,NULL,NULL,NULL,'2023-04-16 17:40:30','2023-08-16 11:41:11'),(142,'Eqbal ALDHEFERI','gla_omi@hotmail.com',NULL,'$2y$10$1M8ARA7g7ZJ.d2Z84IGC.Ou5w6tdIMgxLUgUPbYz1QU38DeK9Tiuq','defualt.png',NULL,1,'+96566395679',0.00,'123',14537,NULL,'2023-05-06 21:00:43','2023-05-06 21:00:43'),(143,'Bashayer Alrashidi','ba7ad@hotmail.com',NULL,'$2y$10$pu2OlmdwNMJcmrv4eU/MDOvsrD1sIIdPsLTERyutHbD0s8PsZz5/2','defualt.png',NULL,1,'+96594040169',0.00,'123',45721,NULL,'2023-08-09 05:22:19','2023-08-09 05:22:19'),(144,'اينا ( AINIE MEDEL )','medelainie82@gmail.com',NULL,'$2y$10$AZgYaN5gkQBfAY0AVt63COj1ndXqiezDkhYhrKTvlBJ3wBZGqzm16','defualt.png',NULL,0,NULL,0.00,NULL,NULL,NULL,'2023-08-16 11:40:30','2024-01-20 12:24:41'),(145,'جميله الحربي','jamilah2283@gmail.com',NULL,'$2y$10$u3K88oAoY08L0ZY5Ugbcb.6mn9IYrnZQrvxbx1CGJeHO/eRz.c1Z.','defualt.png',NULL,1,'+96565763721',0.00,'123',65936,NULL,'2023-09-02 00:00:14','2023-09-02 00:00:14'),(146,'aldousari','alhajeri27@gmail.com',NULL,'$2y$10$15S080sgDODsduRBx5I5nuF2WvfOTYxF4niT6Vpf2gVSE4qOpAmoO','defualt.png',NULL,1,'+96599399462',0.00,'123',44035,NULL,'2024-01-21 20:10:25','2024-01-21 20:10:25'),(147,'خالد','sajeen120@gmail.com',NULL,'$2y$10$8ob41yHz6EfqZ3oBpKSfbOm9avk1r14k6Gu1TlB1tCy3obUYFXK6S','defualt.png',NULL,1,'+96599847414',0.00,'123',83837,NULL,'2024-05-19 21:52:11','2024-05-19 21:52:11'),(148,'Dima','dimarakji@gmail.com',NULL,'$2y$10$/.hv67LldDuXjoq/EAuWWusQxIJZ6Yo6VwrmdQPwMK1sJ8BGU3MGW','defualt.png',NULL,1,'+96599241741',0.00,'123',87731,NULL,'2024-11-26 11:00:47','2024-11-26 11:00:47'),(149,'زهرة مقامس','z97199928.b@gmail.com',NULL,'$2y$10$KpHe31hUXoeZTGJVTTWDK.6e5GAoZSN10k2M.twf./63KK76LyDeS','defualt.png',NULL,1,'+96597199928',0.00,'123',84457,NULL,'2025-01-08 16:40:40','2025-01-08 16:40:40'),(150,'جاسم','jassemalsharaf09@gmail.com',NULL,'$2y$10$cTsF9e9uBvAXiHD9TWU38etsBH9nD1N3NNsoCnPWsStM7PkO/5tzO','defualt.png',NULL,1,'+96596003775',0.00,'123',80666,NULL,'2025-01-08 23:17:47','2025-01-08 23:17:47'),(151,'محمد الشرف','mo.alsharaf1122@icloud.com',NULL,'$2y$10$GZ6D8AolY/TAhauQKIvCVeNI3jMC1dYUmV5/0AzEod0LSs44quLFy','defualt.png',NULL,1,'+96567611443',0.00,'123',29248,NULL,'2025-01-29 15:08:24','2025-01-29 15:08:24'),(152,'محمد الشرف','alsharafmohammad23@gmail.com',NULL,'$2y$10$lrkW5zItcXeQ58nIt4bpQu3OytPJl5EWDI/8n431gRWMiP3GJzjMS','defualt.png',NULL,1,'+96567611443',0.00,'123',78147,NULL,'2025-01-29 15:08:50','2025-01-29 15:08:50'),(153,'dana','d.aldebassi@hotmail.com',NULL,'$2y$10$cuY4F7bmN9a57mJaLkMbneXknsC/GBLDKXgTB3RzCNvtQbMKupKJ6','defualt.png',NULL,1,'+96599183927',0.00,'123',12929,NULL,'2025-02-01 17:27:08','2025-02-01 17:27:08'),(154,'ohoud','q8.aaa@hotmail.com',NULL,'$2y$10$k6d4cfD18Nn2oh9ELCflQO6zYkLstWcMc0KvJx85DHW6OMT.GcFBe','defualt.png',NULL,1,'+96596668354',0.00,'123',55486,NULL,'2025-02-19 18:46:06','2025-02-19 18:46:06'),(155,'محمد','mohammad122absss@gmail.com',NULL,'$2y$10$WFQ99.vz/cjOlVLH6yTQ.OO0yN2fN/kB5xDhHaj1sOIq6iyelsmjS','defualt.png',NULL,1,'+96567611443',0.00,'123',15978,NULL,'2025-04-18 18:50:21','2025-04-18 18:50:21'),(156,'وليد','omwaleedq33@gmail.com',NULL,'$2y$10$CbE0E0vUQWZOcx.M7JrPeON0D3PD6xRKcVAZNle5YoblTionD42BG','defualt.png',NULL,1,'+96599463339',0.00,'123',22587,NULL,'2025-04-28 17:10:44','2025-04-28 17:10:44'),(157,'خالد يوسف','kt.1989@yahoo.com',NULL,'$2y$10$..L6zeKqDXYwm7w/b1TkUetj5BXf7iW3UHBAu3jWPA1soVEG/u9/2','defualt.png',NULL,1,'+96599977336',0.00,'123',17964,NULL,'2025-10-03 21:14:07','2025-10-03 21:14:07'),(158,'mariam','mariam.qassm.85@gmail.com',NULL,'$2y$10$.BkYfE5pnmmwPPng2RwRM./cjhUf4Zji9qGSTujJv4otSu2aJ0yii','defualt.png',NULL,1,'+96599822455',0.00,'123',88648,NULL,'2025-10-05 12:46:06','2025-10-05 12:46:06'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `word_dictionaries` -- DROP TABLE IF EXISTS `word_dictionaries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `word_dictionaries` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `word` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `translation` text 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=151 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `word_dictionaries` -- LOCK TABLES `word_dictionaries` WRITE; /*!40000 ALTER TABLE `word_dictionaries` DISABLE KEYS */; INSERT INTO `word_dictionaries` (`id`, `word`, `locale`, `translation`, `created_at`, `updated_at`) VALUES (1,'الرئيسيه','ar','الرئيسيه','2023-01-06 12:59:06','2023-01-06 12:59:06'),(2,'services','ar','خدمات','2023-01-06 12:59:09','2023-01-06 12:59:09'),(3,'add services','ar','إضافة الخدمات','2023-01-06 12:59:09','2023-01-06 12:59:09'),(4,'Edit services','ar','تحرير الخدمات','2023-01-06 12:59:10','2023-01-06 12:59:10'),(5,'status','ar','الحالة','2023-01-06 12:59:10','2023-01-06 12:59:10'),(6,'create services','ar','إنشاء الخدمات','2023-01-06 12:59:17','2023-01-06 12:59:17'),(7,'modify','ar','تغير','2023-01-06 12:59:42','2023-01-06 12:59:42'),(8,'delete','ar','حذف','2023-01-06 12:59:42','2023-01-06 12:59:42'),(9,'active','ar','نشيط','2023-01-06 12:59:43','2023-01-06 12:59:43'),(10,'main services','ar','الخدمات الرئيسية','2023-01-06 12:59:43','2023-01-06 12:59:43'),(11,'pending','ar','ريثما','2023-01-06 12:59:57','2023-01-06 12:59:57'),(12,'السائقين','en','drivers','2023-01-06 14:03:54','2023-01-06 14:03:54'),(13,'العاملين','en','staff','2023-01-06 14:15:22','2023-01-06 14:15:22'),(14,'Twitter','ar','تويتر','2023-01-06 14:21:04','2023-01-06 14:21:04'),(15,'facebook','ar','موقع التواصل الاجتماعي الفيسبوك','2023-01-06 14:21:04','2023-01-06 14:21:04'),(16,'instgrame','ar','الانستغرام','2023-01-06 14:21:05','2023-01-06 14:21:05'),(17,'linkedin','ar','ينكدين','2023-01-06 14:21:05','2023-01-06 14:21:05'),(18,'snapchat','ar','سناب شات','2023-01-06 14:21:06','2023-01-06 14:21:06'),(19,'offers','ar','عروض','2023-01-06 14:51:39','2023-01-06 14:51:39'),(20,'offer number','ar','رقم العرض','2023-01-06 14:51:39','2023-01-06 14:51:39'),(21,'موافقه علي الطلب','ar','موافقه علي الطلب','2023-01-06 15:02:22','2023-01-06 15:02:22'),(22,'رفض الطلب','ar','رفض الطلب','2023-01-06 15:16:15','2023-01-06 15:16:15'),(23,'العاملين','ar','العاملين','2023-01-07 20:00:25','2023-01-07 20:00:25'),(24,'الاشكتراكات','ar','الاشكتراكات','2023-01-07 20:59:35','2023-01-07 20:59:35'),(25,'اضافة اشتراك','ar','اضافة اشتراك','2023-01-07 20:59:35','2023-01-07 20:59:35'),(26,'اضافة اسلايدر','ar','اضافة اسلايدر','2023-01-07 20:59:35','2023-01-07 20:59:35'),(27,'قبول الطلب','ar','قبول الطلب','2023-01-09 14:54:42','2023-01-09 14:54:42'),(28,'تم رفض الطلب ','ar','تم رفض الطلب','2023-01-09 14:57:47','2023-01-09 14:57:47'),(29,'سائقين','ar','سائقين','2023-01-09 21:38:53','2023-01-09 21:38:53'),(30,'امن وحراسة','ar','امن وحراسة','2023-01-09 21:44:41','2023-01-09 21:44:41'),(31,'صباغين','ar','صباغين','2023-01-09 21:44:41','2023-01-09 21:44:41'),(32,'drivers','en','drivers','2023-01-09 23:07:10','2023-01-09 23:07:10'),(33,'Security','en','Security','2023-01-09 23:07:11','2023-01-09 23:07:11'),(34,'Dyers','en','Dyers','2023-01-09 23:07:11','2023-01-09 23:07:11'),(35,'الرئيسيه','en','Main','2023-01-29 15:45:49','2023-01-29 15:45:49'),(36,'غير نشط','ar','غير نشط','2023-02-02 12:33:09','2023-02-02 12:33:09'),(37,'services','en','services','2023-02-02 12:33:13','2023-02-02 12:33:13'),(38,'add services','en','add services','2023-02-02 12:33:13','2023-02-02 12:33:13'),(39,'Edit services','en','Edit services','2023-02-02 12:33:13','2023-02-02 12:33:13'),(40,'status','en','status','2023-02-02 12:33:13','2023-02-02 12:33:13'),(41,'modify','en','modify','2023-02-02 12:33:15','2023-02-02 12:33:15'),(42,'delete','en','delete','2023-02-02 12:33:16','2023-02-02 12:33:16'),(43,'غير نشط','en','Inactive','2023-02-02 12:33:16','2023-02-02 12:33:16'),(44,'main services','en','main services','2023-02-02 12:33:16','2023-02-02 12:33:16'),(45,'الجنسيات','ar','الجنسيات','2023-02-02 12:37:01','2023-02-02 12:37:01'),(46,'الجنسيات','en','nationalities','2023-02-02 12:42:02','2023-02-02 12:42:02'),(47,'غير فعال','ar','غير فعال','2023-02-02 15:00:13','2023-02-02 15:00:13'),(48,'نشط','ar','نشط','2023-02-02 15:00:14','2023-02-02 15:00:14'),(49,'???????','ar','؟؟؟؟؟؟؟','2023-02-02 21:46:24','2023-02-02 21:46:24'),(50,'الجنسية','ar','الجنسية','2023-02-02 21:46:59','2023-02-02 21:46:59'),(51,'gender','ar','جنس تذكير أو تأنيث','2023-02-02 21:48:39','2023-02-02 21:48:39'),(52,'رجالي','ar','رجالي','2023-02-02 21:50:07','2023-02-02 21:50:07'),(53,'نسائي','ar','نسائي','2023-02-02 21:50:07','2023-02-02 21:50:07'),(54,'الجنسية','en','Nationality','2023-02-02 21:50:11','2023-02-02 21:50:11'),(55,'gender','en','gender','2023-02-02 21:50:11','2023-02-02 21:50:11'),(56,'رجالي','en','my men','2023-02-02 21:50:12','2023-02-02 21:50:12'),(57,'نسائي','en','female','2023-02-02 21:50:12','2023-02-02 21:50:12'),(58,'عمر','ar','عمر','2023-02-02 21:52:06','2023-02-02 21:52:06'),(59,'ارتفاع','ar','ارتفاع','2023-02-02 21:52:06','2023-02-02 21:52:06'),(60,'وزن','ar','وزن','2023-02-02 21:52:06','2023-02-02 21:52:06'),(61,'دين','ar','دين','2023-02-02 21:56:05','2023-02-02 21:56:05'),(62,'مسيحي','ar','مسيحي','2023-02-02 21:56:05','2023-02-02 21:56:05'),(63,'مسلم','ar','مسلم','2023-02-02 21:56:06','2023-02-02 21:56:06'),(64,'ديانه اخري','ar','ديانه اخري','2023-02-02 21:56:06','2023-02-02 21:56:06'),(65,'مستوي التعليم','ar','مستوي التعليم','2023-02-02 21:56:06','2023-02-02 21:56:06'),(66,'تحت التخرج','ar','تحت التخرج','2023-02-02 21:56:06','2023-02-02 21:56:06'),(67,'خريج','ar','خريج','2023-02-02 21:56:07','2023-02-02 21:56:07'),(68,'ماجستير','ar','ماجستير','2023-02-02 21:56:07','2023-02-02 21:56:07'),(69,'دكتوراه','ar','دكتوراه','2023-02-02 21:56:07','2023-02-02 21:56:07'),(70,'عمر','en','age','2023-02-02 21:56:17','2023-02-02 21:56:17'),(71,'ارتفاع','en','Height','2023-02-02 21:56:17','2023-02-02 21:56:17'),(72,'وزن','en','Weight','2023-02-02 21:56:17','2023-02-02 21:56:17'),(73,'دين','en','religion','2023-02-02 21:56:18','2023-02-02 21:56:18'),(74,'مسيحي','en','Christian','2023-02-02 21:56:18','2023-02-02 21:56:18'),(75,'مسلم','en','Muslim','2023-02-02 21:56:18','2023-02-02 21:56:18'),(76,'ديانه اخري','en','Another religion','2023-02-02 21:56:19','2023-02-02 21:56:19'),(77,'مستوي التعليم','en','education level','2023-02-02 21:56:19','2023-02-02 21:56:19'),(78,'تحت التخرج','en','under graduation','2023-02-02 21:56:19','2023-02-02 21:56:19'),(79,'خريج','en','a graduate','2023-02-02 21:56:19','2023-02-02 21:56:19'),(80,'ماجستير','en','Master\'s','2023-02-02 21:56:20','2023-02-02 21:56:20'),(81,'دكتوراه','en','Ph.D','2023-02-02 21:56:20','2023-02-02 21:56:20'),(82,'','en','','2023-02-02 22:27:09','2023-02-02 22:27:09'),(83,'men','en','men','2023-02-02 22:27:09','2023-02-02 22:27:09'),(84,'men','ar','رجال','2023-02-02 22:27:20','2023-02-02 22:27:20'),(85,'Twitter','en','Twitter','2023-02-15 15:46:51','2023-02-15 15:46:51'),(86,'facebook','en','facebook','2023-02-15 15:46:52','2023-02-15 15:46:52'),(87,'instgrame','en','instagram','2023-02-15 15:46:52','2023-02-15 15:46:52'),(88,'linkedin','en','linkedin','2023-02-15 15:46:52','2023-02-15 15:46:52'),(89,'snapchat','en','snapchat','2023-02-15 15:46:53','2023-02-15 15:46:53'),(90,'news','ar','أخبار','2023-02-19 20:23:22','2023-02-19 20:23:22'),(91,'كهربائي','ar','كهربائي','2023-03-01 08:26:56','2023-03-01 08:26:56'),(92,'سباكين','ar','سباكين','2023-03-01 08:26:56','2023-03-01 08:26:56'),(93,'Electrician','en','Electrician','2023-03-03 21:32:45','2023-03-03 21:32:45'),(94,'Plumbers','en','Plumbers','2023-03-03 21:32:45','2023-03-03 21:32:45'),(95,'مشويات','ar','مشويات','2023-03-03 21:53:15','2023-03-03 21:53:15'),(96,'سمك','ar','سمك','2023-03-03 21:53:15','2023-03-03 21:53:15'),(97,'برجر','ar','برجر','2023-03-03 21:53:16','2023-03-03 21:53:16'),(98,'وجبات سريعة','ar','وجبات سريعة','2023-03-03 21:53:16','2023-03-03 21:53:16'),(99,'دجاج','ar','دجاج','2023-03-03 21:53:16','2023-03-03 21:53:16'),(100,'grilled','en','grilled','2023-03-03 22:10:27','2023-03-03 22:10:27'),(101,'fish','en','fish','2023-03-03 22:10:27','2023-03-03 22:10:27'),(102,'Burger','en','Burger','2023-03-03 22:10:27','2023-03-03 22:10:27'),(103,'Fast food','en','Fast food','2023-03-03 22:10:27','2023-03-03 22:10:27'),(104,'chickens','en','chickens','2023-03-03 22:10:27','2023-03-03 22:10:27'),(105,'woman','ar','امرأة','2023-03-16 18:24:41','2023-03-16 18:24:41'),(106,' بدون تعليم','ar','بدون تعليم','2023-03-16 22:53:14','2023-03-16 22:53:14'),(107,' أعدادى','ar','أعدادى','2023-03-16 22:53:14','2023-03-16 22:53:14'),(108,'ثانوى','ar','ثانوى','2023-03-16 22:53:14','2023-03-16 22:53:14'),(109,'جامعي','ar','جامعي','2023-03-16 22:53:14','2023-03-16 22:53:14'),(110,'رقم الجواز','ar','رقم الجواز','2023-03-16 22:57:25','2023-03-16 22:57:25'),(111,'الحاله الاجتماعية','ar','الحاله الاجتماعية','2023-03-16 23:02:39','2023-03-16 23:02:39'),(112,'متزوج','ar','متزوج','2023-03-16 23:02:39','2023-03-16 23:02:39'),(113,'غير متزوج','ar','غير متزوج','2023-03-16 23:02:39','2023-03-16 23:02:39'),(114,'مدة العقد','ar','مدة العقد','2023-03-16 23:02:40','2023-03-16 23:02:40'),(115,'أعدادى','ar','أعدادى','2023-03-16 23:13:52','2023-03-16 23:13:52'),(116,'woman','en','woman','2023-03-19 11:20:13','2023-03-19 11:20:13'),(117,'CLEANING','en','CLEANING','2023-03-19 15:11:47','2023-03-19 15:11:47'),(118,'تنظيف','ar','تنظيف','2023-03-20 07:36:14','2023-03-20 07:36:14'),(119,'اعدادي','ar','اعدادي','2023-03-20 07:56:25','2023-03-20 07:56:25'),(120,'ثانوي','ar','ثانوي','2023-03-20 07:56:25','2023-03-20 07:56:25'),(121,'married','ar','متزوج','2023-03-20 07:59:23','2023-03-20 07:59:23'),(122,'سنه','ar','سنه','2023-03-20 08:05:07','2023-03-20 08:05:07'),(123,'اعدادي','en','preparatory','2023-03-20 14:50:16','2023-03-20 14:50:16'),(124,'بدون تعليم','en','without education','2023-03-20 15:46:44','2023-03-20 15:46:44'),(125,'married','en','married','2023-03-20 21:01:08','2023-03-20 21:01:08'),(126,'سنه','en','year','2023-03-20 21:01:08','2023-03-20 21:01:08'),(127,'ثانوي','en','secondary','2023-03-20 21:01:08','2023-03-20 21:01:08'),(128,'بدون تعليم','ar','بدون تعليم','2023-03-21 07:50:24','2023-03-21 07:50:24'),(129,'رقم الجواز','en','Passport number','2023-08-16 11:27:47','2023-08-16 11:27:47'),(130,'active','en','active','2023-08-16 11:27:48','2023-08-16 11:27:48'),(131,'الحاله الاجتماعية','en','marital status','2023-08-16 11:27:53','2023-08-16 11:27:53'),(132,'متزوج','en','married','2023-08-16 11:27:53','2023-08-16 11:27:53'),(133,'غير متزوج','en','single','2023-08-16 11:27:53','2023-08-16 11:27:53'),(134,' بدون تعليم','en','without education','2023-08-16 11:27:53','2023-08-16 11:27:53'),(135,' أعدادى','en','preparatory','2023-08-16 11:27:53','2023-08-16 11:27:53'),(136,'ثانوى','en','secondary','2023-08-16 11:27:53','2023-08-16 11:27:53'),(137,'جامعي','en','collegiate','2023-08-16 11:27:53','2023-08-16 11:27:53'),(138,'مدة العقد','en','Duration of the contract','2023-08-16 11:27:53','2023-08-16 11:27:53'),(139,'الاشكتراكات','en','Subscriptions','2023-08-16 11:42:53','2023-08-16 11:42:53'),(140,'اضافة اشتراك','en','Add a subscription','2023-08-16 11:42:53','2023-08-16 11:42:53'),(141,'اضافة اسلايدر','en','Add a slider','2023-08-16 11:42:53','2023-08-16 11:42:53'),(142,'عامله منزليه مدربة سيريلانكا - سيلان','ar','عامله منزليه مدربة سيريلانكا - سيلان','2023-08-16 12:35:35','2023-08-16 12:35:35'),(143,'سنين','ar','سنين','2023-08-16 12:35:35','2023-08-16 12:35:35'),(144,'عامله منزلىه مدربه نيباليه','ar','عامله منزلىه مدربه نيباليه','2023-08-16 12:50:56','2023-08-16 12:50:56'),(145,'pending','en','pending','2023-08-21 10:40:29','2023-08-21 10:40:29'),(146,'أعدادى','en','preparatory','2023-08-21 10:40:59','2023-08-21 10:40:59'),(147,'2 YEARS','ar','سنتان','2023-08-21 10:41:23','2023-08-21 10:41:23'),(148,'عامله منزليه مدربة فليبيه','ar','عامله منزليه مدربة فليبيه','2023-08-21 11:27:41','2023-08-21 11:27:41'),(149,'DOMESTIC HELPER','en','DOMESTIC HELPER','2024-04-16 12:30:28','2024-04-16 12:30:28'),(150,'2 YEARS','en','2 YEARS','2024-04-16 12:30:28','2024-04-16 12:30:28'); /*!40000 ALTER TABLE `word_dictionaries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `workers` -- DROP TABLE IF EXISTS `workers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `workers` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `civil_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Occupation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `experince` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `expect_sallary` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `extention` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nationalty_id` varchar(111) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gender` varchar(111) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `age` varchar(111) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `height` varchar(111) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `weight` varchar(111) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Religion` int DEFAULT NULL, `Education_Level` int DEFAULT NULL, `timeContract` varchar(111) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `statusGender` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `workers` -- LOCK TABLES `workers` WRITE; /*!40000 ALTER TABLE `workers` DISABLE KEYS */; INSERT INTO `workers` (`id`, `name`, `civil_id`, `Occupation`, `experince`, `expect_sallary`, `file`, `extention`, `status`, `created_at`, `updated_at`, `image`, `nationalty_id`, `gender`, `age`, `height`, `weight`, `Religion`, `Education_Level`, `timeContract`, `statusGender`) VALUES (23,'PUNAM MUKTAN','PA0836074','14','FIRST TIME','120KD','343818-MUKTAN, PUNAM_page-0001.jpg','jpg',1,'2023-08-21 10:40:18','2023-08-21 13:29:45','169090-punam.jpg','NEPALI','woman','24','5\'2\"','61 KG',0,1,'2 YEARS','married'),(24,'HEM KUMARI BHUJEL SHRESTHA','PA0618762','14','FIRST TIME','120KD','279582-SHRESTH, HEM.jpg','jpg',1,'2023-08-21 11:26:03','2023-08-21 11:30:33','358277-SHRESTH, HEM.jpg','NEPALI','woman','23','5\'3\"','54 KG',0,1,'2 YEARS','married'),(25,'BHUMISARA NEPALI','BA0014161','14','FIRST TIME','120KD','910521-BHUMISARA NEPALI_page-0001.jpg','jpg',1,'2023-08-21 13:22:18','2023-08-21 13:30:07','911034-Screenshot 2023-08-21 150329.png','NEPALI','woman','24','5\' 1\"','58 KG.',0,1,'2 YEARS','married'),(27,'DEBAKI NEPALI SARKI','PA1779165','14','FIRST TIME','120KD','152875-DEBAKI NEPALI SARKI_page-0001.jpg','png',1,'2023-08-21 14:12:05','2023-08-21 14:12:05','251949-Screenshot 2023-08-21 170114.png','NEPALI','woman','31','4\'11\"','51 KG.',0,1,'2 YEARS','married'),(28,'INDRA KUMARI PARIYAR','PA1779152','14','FIRST TIME','120KD','981241-INDRA KUMARI PARIYAR_page-0001.jpg','png',1,'2023-08-21 15:13:58','2023-08-21 15:13:58','48678-Screenshot 2023-08-21 180815.png','NEPALI','woman','32','5\'0\"','53 KG.',0,1,'2 YEARS','married'),(30,'SRIJANA B K','PA1707355','14','FIRST TIME','120KD','98254-SRIJANA BK_page-0001.jpg','png',1,'2023-08-21 16:18:38','2023-08-21 16:18:38','405540-Screenshot 2023-08-21 190806.png','NEPALI','woman','35','5\'2\"','51 KG.',0,1,'2 YEARS','married'),(31,'SAMJHANA PARIYAR','PA1672736','14','FIRST TIME','120KD','449557-SAMJHANA PARIYAR_page-0001.jpg','png',1,'2023-08-21 16:29:34','2023-08-21 16:29:34','766731-Screenshot 2023-08-21 192000.png','NEPALI','woman','31','5\'2\"','51 KG.',0,1,'2 YEARS','married'),(32,'RADHA NEUPANE','PA1662429','14','FIRST TIME','120KD','97406-NEUPANE, RADHA_page-0001.jpg','png',1,'2023-08-22 10:52:01','2023-08-22 10:52:01','734545-Screenshot 2023-08-22 134622.png','NEPALI','woman','32','5\'2\"','58 KG.',0,1,'2 YEARS','married'),(33,'SUNITA MAYA TAMANG','PA1582307','14','FIRST TIME','120KD','213784-TAMANG, SUNITA MAYA_page-0001.jpg','png',1,'2023-08-22 11:10:00','2023-08-22 11:10:00','600185-Screenshot 2023-08-22 140437.png','NEPALI','woman','23','5\' 1\"','51 KG.',0,1,'2 YEARS','married'),(34,'USHA MALLA','PA1502818','14','FIRST TIME','120KD','827749-USHA MALLA_page-0001.jpg','png',1,'2023-08-22 11:29:12','2023-08-22 11:29:12','153776-Screenshot 2023-08-22 141229.png','NEPALI','woman','40','5\'2\"','55 KG.',0,1,'2 YEARS','married'),(35,'CHANDRA KUMARI DHAMLA RANA','12182954','14','FIRST TIME','120KD','708593-CHANDRA KUMARI DHAMLA RANA_page-0001.jpg','png',1,'2023-08-22 13:42:30','2023-08-22 13:42:30','78506-Screenshot 2023-08-22 151943.png','NEPALI','woman','30','5\' 1\"','61 KG',0,1,'2 YEARS','married'),(36,'JUNA MAYA BISHWAKARMA','PA1822193','14','FIRST TIME','120KD','470935-JUNA MAYA BISHWAKARMA_page-0001.jpg','png',1,'2023-08-22 15:50:58','2023-08-22 15:50:58','493977-Screenshot 2023-08-22 173341.png','NEPALI','woman','35','5\'2\"','58 KG.',0,1,'2 YEARS','married'),(37,'RANJANA DARJI','PA0943042','14','FIRST TIME','120KD','33311-RANJAN DARJI_page-0001 .jpg','png',1,'2023-08-22 16:04:22','2023-08-22 16:04:22','60264-Screenshot 2023-08-22 185214.png','NEPALI','woman','29','5\' 1\"','53 KG.',0,1,'2 YEARS','married'),(38,'SAPANA TAMANG','PA1332541','14','FIRST TIME','120KD','240481-SAPANA TAMANG_page-0001.jpg','png',1,'2023-08-22 16:13:43','2023-08-22 16:13:43','873169-Screenshot 2023-08-22 190644.png','NEPALI','woman','26','5\'2\"','57 KG.',0,1,'2 YEARS','married'),(39,'SITA SARKI','PA1816144','14','FIRST TIME','120KD','698209-SITA SARKI_page-0001.jpg','png',1,'2023-08-22 16:26:03','2023-08-22 16:26:03','188464-Screenshot 2023-08-22 191642.png','NEPALI','woman','38','5\'2\"','57 KG.',0,1,'2 YEARS','married'),(40,'SUNITA RAI','12369595','14','FIRST TIME','120KD','228647-SUNITA RAI_page-0001.jpg','png',1,'2023-08-22 16:46:28','2023-08-22 16:46:28','319659-Screenshot 2023-08-22 192720.png','NEPALI','woman','30','5\'2\"','59 KG.',0,1,'2 YEARS','married'); /*!40000 ALTER TABLE `workers` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping events for database 'topappkw_services' -- -- -- Dumping routines for database 'topappkw_services' -- /*!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 2025-10-28 2:19:58