-- MySQL dump 10.13 Distrib 5.7.44, for Linux (x86_64) -- -- Host: localhost Database: talabetnago_tgodb -- ------------------------------------------------------ -- Server version 5.7.44 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `addresses` -- DROP TABLE IF EXISTS `addresses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `addresses` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `customer_id` bigint(20) unsigned NOT NULL, `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `contact_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contact_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_line` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `building` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `floor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apartment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `area` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `delivery_instructions` text COLLATE utf8mb4_unicode_ci, `latitude` decimal(10,7) DEFAULT NULL, `longitude` decimal(10,7) DEFAULT NULL, `is_default` tinyint(1) NOT NULL DEFAULT '0', `is_active` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `addresses_customer_id_index` (`customer_id`), KEY `addresses_city_index` (`city`), KEY `addresses_area_index` (`area`), KEY `addresses_is_default_index` (`is_default`), CONSTRAINT `addresses_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `addresses` -- LOCK TABLES `addresses` WRITE; /*!40000 ALTER TABLE `addresses` DISABLE KEYS */; INSERT INTO `addresses` VALUES (1,1,'Home','Nour Lababidi','+961 71084364','Tripoli-kobbeh','building 12','5','block E','tripoli','Kobbeh','Please call when you arrive.\n',34.4367000,35.8497000,0,1,'2026-08-17 13:46:18','2026-08-17 13:46:18'); /*!40000 ALTER TABLE `addresses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `banners` -- DROP TABLE IF EXISTS `banners`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `banners` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `mobile_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `placement` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'top', `link_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'none', `link_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `business_id` bigint(20) unsigned DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `sort_order` int(10) unsigned NOT NULL DEFAULT '0', `starts_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `settings` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `banners_business_id_foreign` (`business_id`), KEY `banners_placement_index` (`placement`), KEY `banners_is_active_index` (`is_active`), KEY `banners_sort_order_index` (`sort_order`), CONSTRAINT `banners_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `banners` -- LOCK TABLES `banners` WRITE; /*!40000 ALTER TABLE `banners` DISABLE KEYS */; /*!40000 ALTER TABLE `banners` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `branches` -- DROP TABLE IF EXISTS `branches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `branches` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `business_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `area` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `latitude` decimal(10,7) DEFAULT NULL, `longitude` decimal(10,7) DEFAULT NULL, `delivery_radius_km` decimal(8,2) DEFAULT NULL, `minimum_order_amount` decimal(10,2) NOT NULL DEFAULT '0.00', `delivery_fee` decimal(10,2) NOT NULL DEFAULT '0.00', `is_active` tinyint(1) NOT NULL DEFAULT '1', `is_accepting_orders` tinyint(1) NOT NULL DEFAULT '1', `is_featured` tinyint(1) NOT NULL DEFAULT '0', `sort_order` int(10) unsigned NOT NULL DEFAULT '0', `working_hours` json DEFAULT NULL, `settings` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `branches_business_id_slug_unique` (`business_id`,`slug`), KEY `branches_business_id_index` (`business_id`), KEY `branches_city_index` (`city`), KEY `branches_area_index` (`area`), KEY `branches_is_active_index` (`is_active`), KEY `branches_is_accepting_orders_index` (`is_accepting_orders`), CONSTRAINT `branches_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `branches` -- LOCK TABLES `branches` WRITE; /*!40000 ALTER TABLE `branches` DISABLE KEYS */; INSERT INTO `branches` VALUES (1,1,'Bytuna Express - Tripoli','bytuna-express-tripoli','Main Bytuna Express branch serving Tripoli and nearby areas.\n','+961 70 123 322','Baytouna.Tr15@gmail.com',' Near Bank Audi, El Mina','tripoli','el mina',34.4440000,35.8360000,7.00,10.00,2.00,1,1,0,1,'[{\"day\": \"saturday\", \"open\": \"09:00\", \"close\": \"23:00\", \"is_closed\": false}, {\"day\": \"sunday\", \"open\": \"09:00\", \"close\": \"23:00\", \"is_closed\": false}, {\"day\": \"monday\", \"open\": \"09:00\", \"close\": \"23:00\", \"is_closed\": false}, {\"day\": \"tuesday\", \"open\": \"09:00\", \"close\": \"23:00\", \"is_closed\": false}, {\"day\": \"wednesday\", \"open\": \"09:00\", \"close\": \"23:00\", \"is_closed\": false}, {\"day\": \"thursday\", \"open\": \"09:00\", \"close\": \"23:00\", \"is_closed\": false}, {\"day\": \"friday\", \"open\": \"09:00\", \"close\": \"23:00\", \"is_closed\": false}]','{\"accepts_cash\": \"true\", \"accepts_online_payment\": \"no\", \"preparation_time_minutes\": \"true\", \"supports_scheduled_orders\": \"true\"}','2026-08-17 13:34:14','2026-08-17 13:34:14'); /*!40000 ALTER TABLE `branches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `business_types` -- DROP TABLE IF EXISTS `business_types`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `business_types` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `sort_order` int(10) unsigned NOT NULL DEFAULT '0', `settings` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `business_types_slug_unique` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `business_types` -- LOCK TABLES `business_types` WRITE; /*!40000 ALTER TABLE `business_types` DISABLE KEYS */; INSERT INTO `business_types` VALUES (1,'Restaurant','restaurant','Food restaurants and dining businesses.\n','heroicon-o-building-storefront','business-types/01M088NB2XK5J97CRTSC9H0XB7.jpg',1,1,'{\"supports_pickup\": \"true\", \"supports_delivery\": \"true\", \"supports_scheduled_orders\": \"true\"}','2026-08-17 13:25:18','2026-08-17 13:25:18'),(2,'Coffee','coffee','Coffee shops, cafés, breakfast and light meals.','heroicon-o-cake',NULL,1,2,'[]','2026-08-18 06:51:51','2026-08-18 06:51:51'); /*!40000 ALTER TABLE `business_types` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `businesses` -- DROP TABLE IF EXISTS `businesses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `businesses` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `business_type_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cover_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `latitude` decimal(10,7) DEFAULT NULL, `longitude` decimal(10,7) DEFAULT NULL, `commission_rate` decimal(5,2) NOT NULL DEFAULT '0.00', `is_active` tinyint(1) NOT NULL DEFAULT '1', `is_featured` tinyint(1) NOT NULL DEFAULT '0', `sort_order` int(10) unsigned NOT NULL DEFAULT '0', `settings` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `businesses_slug_unique` (`slug`), KEY `businesses_business_type_id_index` (`business_type_id`), KEY `businesses_city_index` (`city`), KEY `businesses_is_active_index` (`is_active`), KEY `businesses_is_featured_index` (`is_featured`), CONSTRAINT `businesses_business_type_id_foreign` FOREIGN KEY (`business_type_id`) REFERENCES `business_types` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `businesses` -- LOCK TABLES `businesses` WRITE; /*!40000 ALTER TABLE `businesses` DISABLE KEYS */; INSERT INTO `businesses` VALUES (1,1,'Baytuna Express','baytuna-express','Baytuna Express Restaurant offers burgers, sandwiches, pizzas, fresh meals and beverages with fast local delivery.\n','businesses/logos/01M088W9JAH1MWZW0ZV9XCB96E.jpg','businesses/covers/01M088W9JAH1MWZW0ZV9XCB96F.jpg','+961 70 123 322','Baytouna.Tr15@gmail.com',' Near Bank Audi, El Mina','El Mina, Tripoli, Lebanon',34.4440000,35.8360000,15.00,1,1,1,'{\"supports_pickup\": \"true\", \"supports_cash_payment\": \"true\", \"supports_online_payment\": \"true\", \"requires_preparation_time\": \"true\", \"supports_scheduled_orders\": \"true\"}','2026-08-17 13:29:06','2026-08-17 13:29:06'),(2,1,'Roadster Diner – Tripoli','roadster-diner-tripoli','Tripoli branch sample catalog for Talabetna Go speed and API testing.',NULL,NULL,NULL,NULL,'Dam w Farez, Ashir el Daye Street','Tripoli',NULL,NULL,15.00,1,1,2,'[]','2026-08-18 06:51:07','2026-08-18 06:51:07'),(3,2,'Sportino Coffeeshop','sportino-coffeeshop','Tripoli coffeeshop sample catalog for Talabetna Go speed and API testing.',NULL,NULL,'79194800',NULL,'Condor Street','Tripoli',NULL,NULL,15.00,1,1,3,'[]','2026-08-18 06:52:26','2026-08-18 06:52:26'); /*!40000 ALTER TABLE `businesses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache` -- DROP TABLE IF EXISTS `cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache` ( `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` bigint(20) NOT NULL, PRIMARY KEY (`key`), KEY `cache_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache` -- LOCK TABLES `cache` WRITE; /*!40000 ALTER TABLE `cache` DISABLE KEYS */; /*!40000 ALTER TABLE `cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache_locks` -- DROP TABLE IF EXISTS `cache_locks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache_locks` ( `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` bigint(20) NOT NULL, PRIMARY KEY (`key`), KEY `cache_locks_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache_locks` -- LOCK TABLES `cache_locks` WRITE; /*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */; /*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cart_items` -- DROP TABLE IF EXISTS `cart_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cart_items` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `cart_id` bigint(20) unsigned NOT NULL, `product_id` bigint(20) unsigned NOT NULL, `quantity` int(10) unsigned NOT NULL DEFAULT '1', `unit_price` decimal(12,2) NOT NULL, `modifiers_price` decimal(12,2) NOT NULL DEFAULT '0.00', `subtotal` decimal(12,2) NOT NULL, `selected_modifiers` json DEFAULT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `cart_items_cart_id_index` (`cart_id`), KEY `cart_items_product_id_index` (`product_id`), CONSTRAINT `cart_items_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `carts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `cart_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`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 `cart_items` -- LOCK TABLES `cart_items` WRITE; /*!40000 ALTER TABLE `cart_items` DISABLE KEYS */; /*!40000 ALTER TABLE `cart_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `carts` -- DROP TABLE IF EXISTS `carts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `carts` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `customer_id` bigint(20) unsigned NOT NULL, `branch_id` bigint(20) unsigned NOT NULL, `coupon_id` bigint(20) unsigned DEFAULT NULL, `coupon_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `items_count` int(10) unsigned NOT NULL DEFAULT '0', `subtotal` decimal(12,2) NOT NULL DEFAULT '0.00', `delivery_fee` decimal(12,2) NOT NULL DEFAULT '0.00', `discount` decimal(12,2) NOT NULL DEFAULT '0.00', `total` decimal(12,2) NOT NULL DEFAULT '0.00', `settings` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `carts_customer_branch_status_unique` (`customer_id`,`branch_id`,`status`), KEY `carts_customer_id_index` (`customer_id`), KEY `carts_branch_id_index` (`branch_id`), KEY `carts_status_index` (`status`), KEY `carts_coupon_id_index` (`coupon_id`), KEY `carts_coupon_code_index` (`coupon_code`), CONSTRAINT `carts_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `carts_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE SET NULL, CONSTRAINT `carts_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`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 `carts` -- LOCK TABLES `carts` WRITE; /*!40000 ALTER TABLE `carts` DISABLE KEYS */; /*!40000 ALTER TABLE `carts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `categories` -- DROP TABLE IF EXISTS `categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `categories` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `business_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `sort_order` int(10) unsigned NOT NULL DEFAULT '0', `settings` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `categories_business_id_slug_unique` (`business_id`,`slug`), KEY `categories_business_id_index` (`business_id`), KEY `categories_is_active_index` (`is_active`), CONSTRAINT `categories_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `categories` -- LOCK TABLES `categories` WRITE; /*!40000 ALTER TABLE `categories` DISABLE KEYS */; INSERT INTO `categories` VALUES (1,1,'Meals','meals','Main meals and Lebanese dishes.\n','categories/01M0897AEDQKJ1H3DXZ790A4FZ.jpg',1,1,'[]','2026-08-17 13:35:07','2026-08-17 13:35:07'),(2,2,'High Protein Burgers','high-protein-burgers','High-protein burger menu samples.',NULL,1,1,'[]','2026-08-18 06:53:00','2026-08-18 06:53:00'),(3,3,'Breakfast','breakfast','Breakfast menu samples.',NULL,1,1,'[]','2026-08-18 06:53:27','2026-08-18 06:53:27'); /*!40000 ALTER TABLE `categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `coupons` -- DROP TABLE IF EXISTS `coupons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `coupons` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `value` decimal(10,2) NOT NULL, `max_discount` decimal(12,2) DEFAULT NULL, `minimum_order_amount` decimal(12,2) NOT NULL DEFAULT '0.00', `usage_limit` int(10) unsigned DEFAULT NULL, `usage_count` int(10) unsigned NOT NULL DEFAULT '0', `per_customer_limit` int(10) unsigned DEFAULT NULL, `starts_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `settings` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `coupons_code_unique` (`code`), KEY `coupons_type_index` (`type`), KEY `coupons_is_active_index` (`is_active`), KEY `coupons_starts_at_index` (`starts_at`), KEY `coupons_expires_at_index` (`expires_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `coupons` -- LOCK TABLES `coupons` WRITE; /*!40000 ALTER TABLE `coupons` DISABLE KEYS */; /*!40000 ALTER TABLE `coupons` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customers` -- DROP TABLE IF EXISTS `customers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `is_verified` tinyint(1) NOT NULL DEFAULT '0', `total_orders` int(10) unsigned NOT NULL DEFAULT '0', `total_spent` decimal(12,2) NOT NULL DEFAULT '0.00', `settings` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `customers_phone_unique` (`phone`), KEY `customers_is_active_index` (`is_active`), KEY `customers_is_verified_index` (`is_verified`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customers` -- LOCK TABLES `customers` WRITE; /*!40000 ALTER TABLE `customers` DISABLE KEYS */; INSERT INTO `customers` VALUES (1,'Test Customer','+96170111111','test@example.com','$2y$12$F8I/c5t556AddFpitrqLyuM9ivt2MO0rPdLxIUVgp5BT1BH2G6p5S',NULL,NULL,1,0,0,0.00,NULL,'2026-08-17 13:04:25','2026-08-17 13:04:25',NULL); /*!40000 ALTER TABLE `customers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `deliveries` -- DROP TABLE IF EXISTS `deliveries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `deliveries` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `order_id` bigint(20) unsigned NOT NULL, `driver_id` bigint(20) unsigned DEFAULT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `assigned_at` timestamp NULL DEFAULT NULL, `picked_up_at` timestamp NULL DEFAULT NULL, `out_for_delivery_at` timestamp NULL DEFAULT NULL, `delivered_at` timestamp NULL DEFAULT NULL, `failed_at` timestamp NULL DEFAULT NULL, `failure_reason` text COLLATE utf8mb4_unicode_ci, `pickup_latitude` decimal(10,7) DEFAULT NULL, `pickup_longitude` decimal(10,7) DEFAULT NULL, `delivery_latitude` decimal(10,7) DEFAULT NULL, `delivery_longitude` decimal(10,7) DEFAULT NULL, `delivery_fee` decimal(12,2) NOT NULL DEFAULT '0.00', `settings` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `deliveries_order_id_unique` (`order_id`), KEY `deliveries_driver_id_index` (`driver_id`), KEY `deliveries_status_index` (`status`), CONSTRAINT `deliveries_driver_id_foreign` FOREIGN KEY (`driver_id`) REFERENCES `drivers` (`id`) ON DELETE SET NULL, CONSTRAINT `deliveries_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`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 `deliveries` -- LOCK TABLES `deliveries` WRITE; /*!40000 ALTER TABLE `deliveries` DISABLE KEYS */; /*!40000 ALTER TABLE `deliveries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `drivers` -- DROP TABLE IF EXISTS `drivers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `drivers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `vehicle_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `vehicle_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'offline', `is_active` tinyint(1) NOT NULL DEFAULT '1', `is_verified` tinyint(1) NOT NULL DEFAULT '0', `latitude` decimal(10,7) DEFAULT NULL, `longitude` decimal(10,7) DEFAULT NULL, `last_location_at` timestamp NULL DEFAULT NULL, `settings` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `drivers_phone_unique` (`phone`), KEY `drivers_status_index` (`status`), KEY `drivers_is_active_index` (`is_active`), KEY `drivers_is_verified_index` (`is_verified`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `drivers` -- LOCK TABLES `drivers` WRITE; /*!40000 ALTER TABLE `drivers` DISABLE KEYS */; /*!40000 ALTER TABLE `drivers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`), KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`) ) 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 `job_batches` -- DROP TABLE IF EXISTS `job_batches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `job_batches` ( `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `options` mediumtext COLLATE utf8mb4_unicode_ci, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) 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 `job_batches` -- LOCK TABLES `job_batches` WRITE; /*!40000 ALTER TABLE `job_batches` DISABLE KEYS */; /*!40000 ALTER TABLE `job_batches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `attempts` smallint(5) unsigned NOT NULL, `reserved_at` int(10) unsigned DEFAULT NULL, `available_at` int(10) unsigned NOT NULL, `created_at` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2026_08_16_141244_create_business_types_table',1),(5,'2026_08_16_143559_create_businesses_table',1),(6,'2026_08_16_144831_create_branches_table',1),(7,'2026_08_16_150749_create_categories_table',1),(8,'2026_08_16_152659_create_products_table',1),(9,'2026_08_16_154952_create_modifier_groups_table',1),(10,'2026_08_16_155046_create_modifier_options_table',1),(11,'2026_08_16_155115_create_product_modifier_group_table',1),(12,'2026_08_16_165155_create_customers_table',1),(13,'2026_08_16_165232_create_addresses_table',1),(14,'2026_08_16_170008_create_carts_table',1),(15,'2026_08_16_170051_create_cart_items_table',1),(16,'2026_08_16_182724_create_orders_table',1),(17,'2026_08_16_182758_create_order_items_table',1),(18,'2026_08_16_183918_create_order_status_histories_table',1),(19,'2026_08_16_184600_create_payments_table',1),(20,'2026_08_16_185055_create_drivers_table',1),(21,'2026_08_16_185137_create_deliveries_table',1),(22,'2026_08_16_190707_create_coupons_table',1),(23,'2026_08_16_190810_add_coupon_to_carts_table',1),(24,'2026_08_16_191048_add_coupon_snapshot_to_orders_table',1),(25,'2026_08_16_193919_create_personal_access_tokens_table',1),(26,'2026_08_16_193943_add_auth_fields_to_customers_table',1),(27,'2026_08_16_201618_create_banners_table',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `modifier_groups` -- DROP TABLE IF EXISTS `modifier_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `modifier_groups` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `business_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `is_required` tinyint(1) NOT NULL DEFAULT '0', `min_selections` int(10) unsigned NOT NULL DEFAULT '0', `max_selections` int(10) unsigned NOT NULL DEFAULT '1', `is_active` tinyint(1) NOT NULL DEFAULT '1', `sort_order` int(10) unsigned NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `modifier_groups_business_id_slug_unique` (`business_id`,`slug`), KEY `modifier_groups_business_id_index` (`business_id`), KEY `modifier_groups_is_active_index` (`is_active`), CONSTRAINT `modifier_groups_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `modifier_groups` -- LOCK TABLES `modifier_groups` WRITE; /*!40000 ALTER TABLE `modifier_groups` DISABLE KEYS */; INSERT INTO `modifier_groups` VALUES (1,1,'size','size','Choose your preferred meal size.\n',0,1,1,1,25,'2026-08-17 13:39:48','2026-08-17 13:39:48'),(2,1,'Extras','extras','Additional ingredients and side items.\n',0,1,5,1,14,'2026-08-17 13:40:40','2026-08-17 13:40:40'); /*!40000 ALTER TABLE `modifier_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `modifier_options` -- DROP TABLE IF EXISTS `modifier_options`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `modifier_options` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `modifier_group_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `price` decimal(10,2) NOT NULL DEFAULT '0.00', `is_default` tinyint(1) NOT NULL DEFAULT '0', `is_active` tinyint(1) NOT NULL DEFAULT '1', `sort_order` int(10) unsigned NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `modifier_options_group_slug_unique` (`modifier_group_id`,`slug`), KEY `modifier_options_modifier_group_id_index` (`modifier_group_id`), KEY `modifier_options_is_active_index` (`is_active`), CONSTRAINT `modifier_options_modifier_group_id_foreign` FOREIGN KEY (`modifier_group_id`) REFERENCES `modifier_groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `modifier_options` -- LOCK TABLES `modifier_options` WRITE; /*!40000 ALTER TABLE `modifier_options` DISABLE KEYS */; INSERT INTO `modifier_options` VALUES (1,2,'Extra Cheese ','extra-cheese',1.00,0,1,1,'2026-08-17 13:42:03','2026-08-17 13:42:03'),(2,1,'Regular','regular',2.00,0,1,1,'2026-08-17 13:42:27','2026-08-17 13:42:27'),(3,1,'Large','large',3.00,0,1,2,'2026-08-17 13:43:03','2026-08-17 13:43:03'),(4,2,'Extra Chicken','extra-chicken',3.00,0,1,2,'2026-08-17 13:43:34','2026-08-17 13:43:34'),(5,2,'French Fries','french-fries',2.00,0,1,3,'2026-08-17 13:44:10','2026-08-17 13:44:10'),(6,2,'Garlic Sauce','garlic-sauce',0.50,0,1,4,'2026-08-17 13:44:37','2026-08-17 13:44:37'); /*!40000 ALTER TABLE `modifier_options` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order_items` -- DROP TABLE IF EXISTS `order_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `order_items` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `order_id` bigint(20) unsigned NOT NULL, `product_id` bigint(20) unsigned DEFAULT NULL, `product_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `product_sku` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `unit_price` decimal(12,2) NOT NULL, `modifiers_price` decimal(12,2) NOT NULL DEFAULT '0.00', `quantity` int(10) unsigned NOT NULL DEFAULT '1', `subtotal` decimal(12,2) NOT NULL, `selected_modifiers` json DEFAULT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `order_items_order_id_index` (`order_id`), KEY `order_items_product_id_index` (`product_id`), CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `order_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `order_items` -- LOCK TABLES `order_items` WRITE; /*!40000 ALTER TABLE `order_items` DISABLE KEYS */; /*!40000 ALTER TABLE `order_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order_status_histories` -- DROP TABLE IF EXISTS `order_status_histories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `order_status_histories` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `order_id` bigint(20) unsigned NOT NULL, `from_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `to_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `changed_by` bigint(20) unsigned DEFAULT NULL, `note` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `order_status_histories_order_id_index` (`order_id`), KEY `order_status_histories_to_status_index` (`to_status`), KEY `order_status_histories_changed_by_index` (`changed_by`), CONSTRAINT `order_status_histories_changed_by_foreign` FOREIGN KEY (`changed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `order_status_histories_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`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 `order_status_histories` -- LOCK TABLES `order_status_histories` WRITE; /*!40000 ALTER TABLE `order_status_histories` DISABLE KEYS */; /*!40000 ALTER TABLE `order_status_histories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orders` -- DROP TABLE IF EXISTS `orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orders` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `order_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `customer_id` bigint(20) unsigned NOT NULL, `branch_id` bigint(20) unsigned NOT NULL, `cart_id` bigint(20) unsigned DEFAULT NULL, `coupon_id` bigint(20) unsigned DEFAULT NULL, `coupon_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `payment_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `delivery_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `customer_note` text COLLATE utf8mb4_unicode_ci, `subtotal` decimal(12,2) NOT NULL DEFAULT '0.00', `delivery_fee` decimal(12,2) NOT NULL DEFAULT '0.00', `discount` decimal(12,2) NOT NULL DEFAULT '0.00', `tax` decimal(12,2) NOT NULL DEFAULT '0.00', `total` decimal(12,2) NOT NULL DEFAULT '0.00', `delivery_address` json NOT NULL, `branch_snapshot` json NOT NULL, `settings` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `orders_order_number_unique` (`order_number`), KEY `orders_customer_id_index` (`customer_id`), KEY `orders_branch_id_index` (`branch_id`), KEY `orders_cart_id_index` (`cart_id`), KEY `orders_status_index` (`status`), KEY `orders_payment_status_index` (`payment_status`), KEY `orders_delivery_status_index` (`delivery_status`), KEY `orders_created_at_index` (`created_at`), KEY `orders_coupon_id_index` (`coupon_id`), CONSTRAINT `orders_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`), CONSTRAINT `orders_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `carts` (`id`) ON DELETE SET NULL, CONSTRAINT `orders_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE SET NULL, CONSTRAINT `orders_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orders` -- LOCK TABLES `orders` WRITE; /*!40000 ALTER TABLE `orders` DISABLE KEYS */; /*!40000 ALTER TABLE `orders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_reset_tokens` -- DROP TABLE IF EXISTS `password_reset_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `password_reset_tokens` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_reset_tokens` -- LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payments` -- DROP TABLE IF EXISTS `payments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `payments` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `order_id` bigint(20) unsigned NOT NULL, `method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `amount` decimal(12,2) NOT NULL, `currency` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'USD', `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `paid_at` timestamp NULL DEFAULT NULL, `failure_reason` text COLLATE utf8mb4_unicode_ci, `gateway_response` json DEFAULT NULL, `settings` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `payments_order_id_index` (`order_id`), KEY `payments_status_index` (`status`), KEY `payments_method_index` (`method`), KEY `payments_transaction_id_index` (`transaction_id`), CONSTRAINT `payments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`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 `payments` -- LOCK TABLES `payments` WRITE; /*!40000 ALTER TABLE `payments` DISABLE KEYS */; /*!40000 ALTER TABLE `payments` 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 */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `personal_access_tokens` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) unsigned NOT NULL, `name` text COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `personal_access_tokens_token_unique` (`token`), KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`), KEY `personal_access_tokens_expires_at_index` (`expires_at`) ) ENGINE=InnoDB AUTO_INCREMENT=3 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 */; INSERT INTO `personal_access_tokens` VALUES (1,'App\\Models\\Customer',1,'talabetna-mobile','1d7fa8cc3e41ce0826f043604bebad8ab564a103ae3200b4eacdf2ce06185683','[\"*\"]',NULL,NULL,'2026-08-17 13:04:25','2026-08-17 13:04:25'),(2,'App\\Models\\Customer',1,'talabetna-mobile','912aaa1f3b5913bf2977b5afcd7d63124f9b3ceac4d09cb08a670183f16e7bfe','[\"*\"]',NULL,NULL,'2026-08-17 13:04:46','2026-08-17 13:04:46'); /*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_modifier_group` -- DROP TABLE IF EXISTS `product_modifier_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `product_modifier_group` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `product_id` bigint(20) unsigned NOT NULL, `modifier_group_id` bigint(20) unsigned NOT NULL, `sort_order` int(10) unsigned NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `product_modifier_group_unique` (`product_id`,`modifier_group_id`), KEY `product_modifier_group_modifier_group_id_foreign` (`modifier_group_id`), CONSTRAINT `product_modifier_group_modifier_group_id_foreign` FOREIGN KEY (`modifier_group_id`) REFERENCES `modifier_groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `product_modifier_group_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`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 `product_modifier_group` -- LOCK TABLES `product_modifier_group` WRITE; /*!40000 ALTER TABLE `product_modifier_group` DISABLE KEYS */; /*!40000 ALTER TABLE `product_modifier_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products` -- DROP TABLE IF EXISTS `products`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `products` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `business_id` bigint(20) unsigned NOT NULL, `category_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `sku` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `price` decimal(10,2) NOT NULL, `sale_price` decimal(10,2) DEFAULT NULL, `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `preparation_time_minutes` int(11) DEFAULT NULL, `is_available` tinyint(1) NOT NULL DEFAULT '1', `is_featured` tinyint(1) NOT NULL DEFAULT '0', `is_active` tinyint(1) NOT NULL DEFAULT '1', `sort_order` int(10) unsigned NOT NULL DEFAULT '0', `settings` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `products_business_id_slug_unique` (`business_id`,`slug`), KEY `products_business_id_index` (`business_id`), KEY `products_category_id_index` (`category_id`), KEY `products_is_available_index` (`is_available`), KEY `products_is_active_index` (`is_active`), KEY `products_is_featured_index` (`is_featured`), CONSTRAINT `products_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `products` -- LOCK TABLES `products` WRITE; /*!40000 ALTER TABLE `products` DISABLE KEYS */; INSERT INTO `products` VALUES (1,1,1,'Chicken Meal','chicken-meal','BYT-MEAL-001','Grilled chicken served with french fries, coleslaw, pickles and garlic sauce.\n',9.50,8.50,'products/01M0899S4BGMZ61ZH3AS3X4891.jpg',25,1,0,1,1,'[]','2026-08-17 13:36:28','2026-08-17 13:36:28'),(2,1,1,'Beef Meal','beef-meal','BYT-MEAL-002','Seasoned beef strips served with french fries, fresh salad and house sauce.\n',11.50,10.50,'products/01M089DBHTMSHZ9AVPGTJGNREH.jpg',25,1,1,1,0,'[]','2026-08-17 13:38:25','2026-08-17 13:38:25'),(3,2,2,'High Protein Cheesy Double Crunch','high-protein-cheesy-double-crunch','RD-HP-001','High-protein double burger menu sample.',14.50,NULL,NULL,20,1,1,1,1,'[]','2026-08-18 06:53:57','2026-08-18 06:53:57'),(4,3,3,'Baladi Breakfast','baladi-breakfast','SP-BF-001','Traditional Lebanese breakfast menu sample.',10.00,NULL,NULL,15,1,1,1,1,'[]','2026-08-18 06:54:17','2026-08-18 06:54:17'); /*!40000 ALTER TABLE `products` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sessions` ( `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `last_activity` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `sessions_user_id_index` (`user_id`), KEY `sessions_last_activity_index` (`last_activity`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sessions` -- LOCK TABLES `sessions` WRITE; /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; INSERT INTO `sessions` VALUES ('ATB71ilPb38XxQtTx7H0O20h2QQdoUwcxxYueJ52',NULL,'34.105.96.163','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36','ZXlKcGRpSTZJbmRhY2toNE1VeFNXVWRaZUdSM1psZEhhalZpVkZFOVBTSXNJblpoYkhWbElqb2lLMFJqVUUxU1NFdEpTekpaYTJGRk0zVnZWbFZMYzBWSVRubFdiMDVJVGpadGJFZHhkeTlKYUZZNGMwaFBSSGhNZDNOMU1UUkdhV05zWjFJNWRGUkNNMjlEYjFsS1YwNUhSRU5tUVdodlVsRkdTM2N4YjBwTFUxcG5ZMDV0TWpoTGMzaERNaTlrUTBobE1taGFVVlprVW5OTlJURTVhRFJLVlZwblpFdFVVM2hpUTFab1ZUQmpja04yUW5sbE5WRnlRM1JDVjJSNFNreDZiRUl4TjJkaU1rMDNZemh6YkV4VGFHaEVVSHBJZERGRE5sRmlOVnBPTlZseFUyVmhiRUpLUTBWNlowZFpNbElyZVdNeVMwVkdlRUo2VFVSRFdVSTNOQzh2ZG01VWRHdEVOazlSZEhWaGJESllOeloxT1ZWWGJsUk5TMGxvV0dGSE1tY3ZjMmw1T1NJc0ltMWhZeUk2SWpZd05qRTBaR1JoWmpSaE16SmhNV0ZtTmpJeE1ERTFNbUUyWXpCbU0yUXlZakF3Wm1FNE1EQTNNbVk1WXpsak9Ua3hPVFZsWTJNNVlqVXlZVFZsTURFaUxDSjBZV2NpT2lJaWZRPT0=',1787041250),('eMFUzuWBYxupZnYFk9C5baX2IsyLBbH1gX9UiK2i',1,'5.31.241.127','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','ZXlKcGRpSTZJa0psWlhNeVlYaEJiMVZ3ZGxkNVYwcE9hRVZFT1ZFOVBTSXNJblpoYkhWbElqb2ljbUZVTTFka1ltTm5LMmQyVm5WbVJVaG5NakJIYzBveVNsVmpiV3BhV1docFRGY3dNbnBJVEhwa2NUQTJhMlpvVDFOQlVuQktVa2hxY1M5UGNGSjNRemRTVEZrclIwWkhVRlZYTDNWQmVuVmhNakZGVFU1dFJWZHZRVkYwUWpoV1duaE5aR2s1ZEZKS2RsRm9TbTVCUWxsQ1FuVjJPRkZFZEV0UEwzTjRkVUZYVkc1aFoxaDRSMnc1U0RGU1VYQldOMVF6YkdjNGIxRldTRXhzYWpKSkwyNVllbVZwVWt0eGNDOUhUa0ZtWTFFeFRuUlpNV0k1ZFVZNE1tY3lMM1J0VG5Vd2R6Wk1jVEJ5UkZsRFpFcGxiRXBDV2pBMFVGcHNUR1YwUm10WVRXUjVVRlprUW5GaVJFcHJUamt2TldSWVlWQnZObEZEV0RGb2RVMXRjM1puT1ZOdmRtd3ZPVVZKYVVWSWFVaG9RM1pYYW1nNGJuQnRSVmxNTkdNMVYxVlViVmRzUW05U1RWRXliblI2Y1M5UWFDdHZRV1pvTjNCcGVESkllREkySzJodFZIZEJjVEp4VGs5bFZuZHdUblJQUkZWUmN6UktZV2Q1ZEd0MlpXNWpOeXRhV1dGYWNVRXlPVVJXZFVWNFpXcGxaRVpyTUZBeVZrWnZhelpCZHpkYVRsQmtOV1pqVG10VWFHbERNM1pVVWxkTlNYVkNPR1JLTjJGdmFIZGhkbXRDWkRSYVNXaG1PVXBaWldzd00wUTBVbU5vYjNsbVdsSlhhSFIxZFZCbk9GcDRNSE5PY1VwUlpqSXlVMmczVFVST1RYVnRkbnBrUzJ0bFRFZEpUVlpMTUV4b1RuQlhLM0ZDUVRKNFQxVnlTMGtyU3pKdVdpOHlXazVFTDJsR01tSjNPWFZFVWtVdlZISkVXSFEyYlRaWmRYWjFjMVZwZFN0RGRteEhWRlZPZUZSdU5XeGtVREIzTWk5eFdsVktUR1JXV0U5d1FWaGxkMVF6Y1RaNWQyMHhkek5YZG1SU1l5OU1RblJHTW5Gb2NVRlRUR2xMTml0QmJGbGxOVkJWU25jeU9VcE9jMWxTZVVFemVtTmtZbXRvVTA1alVTOXNUMHg1VDJwb1Iwd3pTVVpaZDIxRVlsY3pSR28yYm1scmJqSk1aelZ3V0ZJd1ozSlpSMUo2WW5ONlJEbE9lakpZY1VJM2RVTnJZMDFyUkZCeVRVMTBLM05KUVRJeGN6QXJNRTAzYm1kVmFuYzVka2s0VUZsck1rWnBiV3BCTkhKU2FVUjBURnBVY0RKVVprbExaa293WlRkM2NXZEZhR2N4U1VwcU1USTVhVGRuWlhCdGFHYzBSV2xFTkVVeWJuWk9MM1JxTVVWR2NHa3dZV1JPYVZSRWNIVkhOUzlKUWxscVRXOUNhMlY1ZUdWQ1dHNDFVVU5JVFZSbVR6Y3pka2c1ZEM4eFNWSTVhMVUzUWxOck1sSnlibE5HZEZWeVFtbDRkME15YzFkeFJrVk9NV0ZUY0VGdFJHMUliVkVyWmsxbFNGRmtVWEJuZGxOSlZWRktjMHhKWkZGU1IxUkxhMGgxV0cwd2JGWjRLelF5V0ZOYVJXdFNLMk5MSzNaM2NHeGtWSGMxYUd0cU1FZDBhMUIxWjNOMWFrdHpkV3hoWWtwYVIxUXlUa2QwUkhCWmRIcEJOVGx4UVU5TWJUTndSbGxwZUVKUlNuTjVSMG96VHpaVmFrRlJkRXRhZVRrd2JubGlhVmxpYWxGdGFUbE5WVVV6T0ZoSWFXdDJSREJ6VEhkb0wwNTNiRzVEZUVKRU9FUjRTMUJZVlZGRksxYzFiVkJxZDB4dFkySnZVRFZNUjBZeE1FWTBUa1V2Wm1WTFVFSkJNSFpYYmxKcUwxZHFZMlJ1TlRZMFkwWlNZakkxWTI1clRGQmxTMFpZYVdwUFUyd3JlR2xhUTJkTk9HOHZTamRuUldaWlN6ZHBNbEJVTTJ4S2NXUkhNRmx2TVRWRk1tcE9TVVJ6YWxkUWFGbzJVbGQxVUZOdmVuWnVXbkphTTBGTVFrWkxRbGd4VUhSeU5YVTRialZrUzIxaFVIQkhXbWczUnpaTVVreGFlakV6Y1c1aGVGVXJibXBRV0dveWVXdGphelZKWm1KWkwySlVTRGhWVmxwb1JVWlhiRUZFVkhkWFdsWmhXWHBIZUhObVIwSlNZWE5wT0d0UU5rSjZOM1poU0dKTWVVMVpiVWc0TDFrMlJuTkVhR2hHY1ZJNFNtaDRjbEpFTW1NeEsyeHFZMVpRV1RsVGMyVmpLMmhHWlZWT1EwWldSSEVyWm5aTWNFVmtVMVJ2TTFVNWFFbGFVbE54UW5OWFIwVkhWRXhtTkV0SlZtbFBUMnBpUzBGd0x6VkpTa1V4WWxaVU1tUjRSRWxDU3l0RmJXeGliakEyTVhKWVpYaFZXR2xPVUZBMFdGcEZWMXBuY1VsMlFWUk9ZMjUyVnpKM1VUTTFkV2R2ZVRobWRrcEVVM0JzVkcxcVJFWktUa1J2YkU1bE9GTnBTRFZaUldNMlRpOW1ZMEpDUWxCWmQzRlpNakpqWXpoSFVYWjZhREZNYjJwcWIydFZTMDlPZERsWFlsWlViMWN2ZGtsS0wzWkJUbTlpYzNCc1ZuRlJRWE5PVlVwc2JHSnZRVlJTUjI5MFdsQjBZV1JrZEdSbU4wbEpTRUpMTlRWUGEwaHVSR1U0ZEUwNFlrZHNRMmRGT0dwUGNHMVFaR00zUlhCaFZFRk1NMnhMY2xVM1l5dGpiRGRVVFZCMFFVVmhVbHBuTlRWRFJFWmpPSEJFVWtaallsQlFURXg0VmpJM1ZHaHFjRU5TYUc5cldFOXBVbUZpVjBKVloxZEhZVzFyYkdWTk1qRkxVbWhYWWpKdlVDczNhalZNZVhBMk1Vc3lNbXgwTW5JMFFucENhR2swY1dwS1QzUXJNbnBZUVdKUWRqZEJlalZFTjNremR6QkdkWGxSYkhwalZqUktTM3BGVDA5ME5XNHdjV2hzV2prMWNrZE9hSEpPUVdaaVkzUXhZa2hUYkU1Tk9IWkdieTlHVW5WdGRsRjBWVFpVZEM4d1FtVkdRMmw0YlRSRFlrWnZialIyWXpWMldYRldSRGx4YjBJdlNUQjNaRmhPYkVseUwxWjBhbGhRZG1wcGNqTkRibVZoUWpOUVREVmpZemhPTmpob1ZVbERjSGh1Y1hOamFGbDZNbXBVYjNBMVpXSllWV1pYTjBka01qSlViME5VYTNSTWFHWndXV2hDU0VvMWJYZFNXblp2Vlc0emFtODFjRUV4T0U5amFHZ3hZMEp1YUd0U1dGRmliMU50TlVOVlkxaHVRMFpyZFU1a09HbENjRlpzZURobU9FWkpWMlpTZFdORlkzZFFWRkl3Y0ZkWFJWRlFORVZIWnpCd2JVMWxNM3BaTkc5bWNFWnBOblZwU2tRMmFWRkxNSEI1ZDJKWmNVdFBTMjl0ZWtwd2JVWmlRMlJOU0Zsak1tbHRaa3RzV1RKS2NHUlljREpWYUhST05HeG9ZalpSZG5SSldFUmxLMDEzYWtKblNrdERVRmd6Y21sVWVWcEpiR1pXYUdOVFEzRllXV1ZoUlRaeE1Vd3JjbFUxVkZoU2RXNXBhV1ZxYkU1aFNtNWpkM0pJZFdrMk5IQXJUVmxrUTFsVmRIVXJPVGhHTlRCbE1DOUNURk52YjBWblpsTTBia3BsV0RaUmVIZ3ZiR1ZxTjJNd05FSnJkMHhJVEVsR1YzaGFaR2szWkRjeVVtVkJkRmRNYTJwbmJsZzNUWEYxUkRCMFUwMVFXbWw0TWtaS1FVcFVOREZ2T1VkeU5XSmlTWHB6ZW5CNVNYUjNZVGRVVUZrdmMwUlRTV2x5UmpJMU9HUk9SVWhCT0hkT1IzcEtieXRTU0VOT2RrYzFja2hUY0hGS2IwTnNUVzRyTjBOMlFWWldTM2RyVnpSU1ZWRndiV2wwY1hkdVdtaGlWRkJHTVdoSVZqWllUVVJoVVVkVlIzWnRhV0ZNYTJOT1ZsTkdNRVJsZW1sM1R6UlNjME1yUlRSTVJtbEtNVVI1UXpGVU1tdzNRemxSYkZOaGQwaFZXakJzY0VObE9XczJWbmxUYWxvd1RYa3ZkRVpwVFhkNWEyeDNiRUkxWld0M2NWZHVTekEyYWtNM2R6TldXRk01Wldkb04zUlpVamRXUm10MU1uZFFNRkJVTjJ0bmNGZGplV2xVZVZWYWFIaEhRMUJMVEVkMU9FcEJZVlZNYVZGWVFtb3JaVGc0Um1oVU1rTlVlVW81UzNOdmJEZDZlakZFTlVoa2NWQlZkbEZYY21KMGJpczVjamszU1VWMk0wdzBiblZQVjB4NlRqSmtOVXR5VlU5cmNHRnBMMUEyZUdJclRtRTBNV2RYY0Zad2JqUXZaa2hHZUdkcGEydHZaa0l2VjAxUWIxbEdha1I0TDNGYVQzaHhZbk5ySzFSTFdtRklkVFYzUVZrMmJUTjZjRUpaTUhweFZrUlFRbmhxY0c1YWFFbElUV2hRV21jeldtRlNXVzk2TUdSclZsbzBibE5HYWt4aVVtVmtaMlJoV1hKcFVtYzBaVEJCYjJadVVWUmFjMXBEVkV0WFJqUkdRMUU0UTFwcGVXdzNialZtWVdJeE0wZFZaa1EzV2tKc2RsZEdWa1Z6UVhOWmJITjBUemxWTm1WWFoweHBlVFZ4VkRoNVR6aFpUVlJ3V1hKUVMwVlFLMm9yUzBoNGNHeGpOekI2VjFscVVuY3ZjbnBWWWtsV1IyWTFRV3hpVERsbVRFeDNOVVpDUkhSdmFWcGlhRkY2VGk5SVMxTmtUVTFMVUZrdlowRXJVV2N2YTBSUVkyMVZRa3hNVlVjdlN6ZFVTa2xGVXpGRlZuQmFMMDVxYTI1RE1HSlhTMUo2UjNSalZscE5TbU4wTXpWUE5HdFFWazh2TVRCQlRrOUljSGs0TmtwNVlXcFVWVzlzZFRKd1RXZGlaVUZVWlM5QmQyc3lkVkZCZWpkWlp5OWljV0pFYkRkbFVVNUxWalZDVFZad04zTXpNMmd6SzFaR05qaFBPRTV4VXpSbk0xZDBabWRpWkVGNWJVOUlOWEpGVEZsdVpuQmtUbk5IYzBKVlJrTjJMemQ0UmpWSVZ6ZDJiM00wTVU5V2REaGFOMlkwYmpsaFMxWnJWbVE0ZVVoMFlXRnJSVUl3UkVGbVUwMVBTR0Z2UVdRNFYxUmxMMWhSUTNocFVXcEhiRmxrYUUxRWFYVTRUbmRxTkV4SVkwb3lPV1JZZG14TldtdzNkbkV5TVZkeGQxcFBZM1ZGUmpac2EyUlRlaXR5VGk5dVVIZHVha05IVTNCdGRYWmhVWFJPWlhsQlNHRjBaRWd4U25wVU0wdFZibkJIY25KR01DdGtObU4wUW1SME0zQkhkVlY2ZEd4Q1drMVNURFZ4YUVsUVJWcFZRbW93TlhZM1NWbE9hVGRuY2xkaU1qYzVSVXBsWTA4NE0wSlRabGt6WjB0SVVGUjNNMlpEVmpkM1lrVXhSVFZIYVc1aldrNW5TMlJFVEdsMlFtdFhaR1pvYWpWVGEwWXhkVWx0VVhkbFFrUk1hamRzYTNONFNGTktURFZUUW1OeVkzVkVaVXQxWkZCbFVYbHFPUzlwWjA5VFRVOTFhbXRJZW5sNllsVm1lVUZDVmxsWVJWQjFVa3hPVmswdmJGVnRRbk5NUW10QlV6SnZOMVZ3YTJoQ1RrTjRjREl2YW5kTk9XTnpTMFU1ZUZwakt6ZEZabTFFVDJOdlZtcDBiMW94ZEhFNFRuWjJkakl4YkZJeFVYWmpXbTQzWTI4M2JqTjJUMm8wVldGSllWVlVZVVp1ZURaMFYxYzFPR1IyT0c1cU1uUnhRWGczWTBOd2FtNVRURFkwYkRCWVVFb3JhM1JTYWxCRmNHVnJSVll6U0RRMmFEWXZVRXd2YzJaME5pODVNSGRGVDBod1dtMVhkRTlDYjBWRFdXUlJZazV1SzIxaFRtdEVZaTkyWTJsclVHTXZTbkJrY0hFMEsyTndjVE5QZFV0Q05FTk1WM2g2ZFRKbVVYWnBORVo1WnpZMVNuQndOV2xLUTBoWGFIcEpVMFZsWmpOS1luUk1URzAzVTFSQk9VSXhObFZ6WmtwcmVGZG9VbFpUWkROUmJrOUVPR3hUUlhSbU5HWk1WVFZNV2pRNFdGWlNORTQzUWtGeFZsWnBTRmhuUzBoc1RXVjFjRkZPWkV4bmMyVnJabUZMVlZWMmJDdFRiVTVCZVdkaldEaFNkR3AyVGtOWlZHMVFVa3BOV0U1eE16RklRVUY2U0dsd1pHNDRaSFJHY21SaGVHdFFhR1U0VVZSV1NFRm9hM0YxYld4RVJXSk1SV1ZLVnpBM1RVWlVXbXRFVVU1SWNGTlVjVzlST1V0eVRGcDFNVUpRTkZRM2EzUXlTekprYTNWSE9YUm1ORlJ2T0V4UFUzZElWaTlMT0hSdVRHeHdWM1p1WkV4dk4wUlVhRTVFZG1SNGNVTmlWRlFyTkdSbk4ydzRialJ0YVUxVlEwY3JRVWxSVnpRcmVuUnJSRWwyTWxnd2JsRk9jRFprZEhCbGJqazBjVmRWVW5aeVp6UktjbTVRYVZCQ2IxUmFaR1J6UVdObVJVNVdaVXBIWjFSdk55c3JjRlJ5ZFUxUWVFMHZaM2RVVTBzNFVGVXhXVUl3TTJ0WmNHWkhRM2xyWm1aRlJGWnBTekZHTUU4dmJraFRWMmhEUnpsWFlVeElVWGw0T1hCTVNHb3lWbVJZUVV0WmNGbG5Za2RrVjJaaldDdGhNa3d5ZUZKb1J5dDVkREp6TTJabVUzb3hXRGcyT0hBMmFGRkdWR2g0UVZWWU9GcDVSSGRVYzNkamVGRTBiVXhDYjAxeVIzVlJaRkpOYkRSWlMyOVliSE52VG05U1NHSXdXRFExYW10aVpHbGFVbXBZVlZWS1ZVWkhObXhFY0ZCdlpXSnRVa1ZEZGtseWNFSk1aMEp2UzNoelNFdHRURk0wUlVGc1EyVlZVbGQzWWxCMkt6SkJOaXR6VXpRd1ZIQTNOakZNWlUxeVdrRnFNWEZTTkhOR0swcDZVakJYZFdsSWRYQTNSVFZZU1RoNVNtWlNhSFp6Y0djNFltcE5XbVJ3VWtwSk1Ib3hPSFJMUlVwMlJFOXJjME4wWWtSMU1EVkxRVVpWUmxwUVZ5dDJhR0Y0SzJ4bU5tWk9MMWx2U0ZsM01sZDJhbTVOY0dFd2VVRjRObFJSUkhNclNVcFZPRWR1UW1vMVZ6TlpNRGRGUzFweGRrTk9TMmNyUjI1cGJWUkxVRTF2TlVGM1FpdHdiRk5qUjFSMFFWSTJNeTlQYlhKVlpIcE5RbkZQYmpCbE1rbG1WMGw2YTJoVmVsRXphU3RXVEdoRmVFMHJTM0paYUdKQ2JVTkVZbXN2U2taV09FNWpiMWM0YlRSclZYUjJNV1l5Tm5oaWVGTXJWRzB5UTJsNVkzQk1OMlo0Ym5CTmJsSkRZMlZyVlhab05VcG5lRzlxYm01eVJEZzJLelV6U1RWa2RuVXZTMUF3Ums1UFluSmhSekpwZEZwSU9FWnhZaXN2ZUcwNWJHTXphVmw2VEd0SWRVcGhRakZ6TmxNMGMyUk5lbVp2UjNWdFVIWkZVMWtyVFZBMVVsaHVLMVI1YURaV1ZEZHRNa2hNWTBKUWFFcE5ibWxUVlM5a1ozaFlZMFEzWjFSS2VXUnlaVlpQUlVoRk1sWnRaWFJZWVN0M1JFTjBZVFUzVFcxSlRUUnVUMlpFYlRkdWVGWktablJoVTJGTGJucFpZemh4V0hKUVprcFpaWFJPVld4V1JqVkhMMWhhUVRKQlp6VXhSbFJrYkNzdlRGVXZjbFphWmxkd1dqSldjSEZRYW5RMVNqWlBiMjlFY0RJdlYwMXRjWFU0Y1ZOc1NVdGFPRWhxVURVd1oxTXdTVmREZUVwR01XaEhVVGNyZVdNd2VIcFZUR2xJTVVnM09EY3pZV3hTVFhWR1RIRlJkREEzVW1zd2RYcDZRVE0wTm1GU1kyODJOM2c1ZGpoSmMyRm1kMFp3UjJsc2FtTmtkbTV6SzBweE5rcEhRUzlYT0RKR2NqRjJTMFJyTTFaWFkwTjRPWGhXUTJGQ2JFZFpWamRQUzFWcU9USk9WWFJhT1ZsTVdGRlVVM05UT1VSYWJsWTRjVzVYV1hGUFZHcENVamRPV1dKdWNVNWtkbk55YzJkNldsbFFNVWxMYkVSVU0wOTRiek5YU2sxSWFVVm1ZeXRxWVdzMk1uWnJUR3h6T1V4TWFFdEZSM2xTV0U4MU0wcHJXV2xTUVZaSFpXVTJkVFZvWlRNMVEweHZjVVZRWXpSVlRUZHBlRTVNY21oWlNqZFBOWEphTjBsNGFHNXpLMmRxUnpSelluWlVTRkJsYVVzNE9EWXhVa1pHUlcxeWRWaFJTek5KVDI1UmRsRktZVFp6Tms5QlEyRjZabWRhUWt0aUwyRTBXbTlwZUZwTlZsUlFURzl0S3pKa2FIZ3hLM2xoVTBSd05ubDVRbXRNYmtFeVlYTllaVFZrZDBSa1NtNDBRMDF2V0UweWJWVlRaRGxqU1ZSMVJIUnJkV016VG1wTVEzZzNaSGREUnpKUFkybDVNVGRXUkV3MlIyaHdWVFJ6VG1SdWRDdEhjbVI2UVhaRFZESnVVRWxPVEV4VUwzWk1lV3RvTDNOeFowbEtNamd3YTFKRmRXZzRSamxzU0RSRWVtZHROWEpsVTJoRk1GSjBRVzVuZFdGUVdubG9ObFJQUW1Fd2VGRmhlWGxyVG13eUwxTTJVMk53YmpjNFkycDFkR3BvSzB3d1NXSkVTV2hrVjJsWlduSXhjMnRzU25aRVpqRTRkeTlYZEZkcE1teEVUMHRTTkdWU0sxaE5WRTFTVm14aFlURkVRVU40UzNBcmNtWk5ka0kwT1ZkSFV6ZEJWa1JzYlRsWlUwOTJiak40UWxveVdrNVZTR015YjBodk1uZEdVRzl1TURkRllVaExlaTgyY2tsdWRFeFRUV2hEVFd0clF6aG5hMmR0VW5KdlEyMW9jRTFDY2pnNFZqRllVMlJOUWt4SE0zZFdjVFFyVnpNclkzQmpORmhyVTJKS1p5dHNhSGg1S3paU1Z5dHRNVWRGT0VGcWVHbHRjVzUzVUVFeFUxVlpUMlZvS3pWeFRtTm9kRVZ1V1VsQksxRm9ObVJuWkRadlV6ZHVaV2RqVTBVdlpXeFZVVVJ4ZUd4VmNGcHRkbmxaUVVGSFJVTlZRMDQzTHpWRGRuTk1VakpsTkN0dkszVTFXREZEZDJ4RldETXpaMEpTYlhVNUszbFhVVXgyU0RZMWMzSjRWbmRHZUhwV01URjVPRnBCVFU1cE5HeHlhVVZVWjNoWVJHbExjRFZKYlRCRWMxazRTbmRYUVhCRWFtTlBiMXBSWkVOT1pUSkpRMVJFT1VvcmRHMURRM2RFVkdaWlVVMWtlakEzYUVvemJIVkJPQ3RLVFVKR05GUnRSbU56UmxadVJHaE1iWGN3VG5jd1V6RldOWEJoTlVNNE1WUnliRGhLTWpCUmMxWTJiVkEzYVdadmFXWkJTMjVYWjJNdlJtTXJaa0o1V21FdllrWkVhRlZFZHpoclFWWnlXV0o1SzBORmJsQnVjVVpFT0VaYWJ6SnpkWFEyV2xWTE4xVnBVaXRMUld0Q2VsRlpha3BDTUdOVlRrTm9ka3A0VDJWc1ZtMDJRVGx1UW01MFYzTlFaamN3YlZBNGVuaHNVVkZhUmxGaFFUQnlVVEZhTDBVM01rbFdPV2hSUldaMmRFcG9XR0ZFUmpSamFucFBWWFZVYm1sYVN5dGllRFoyZVhaclpGSkRPRnBySzA1WFRISkZVRTVHZVZKRE56aDFWMVp3UVVobFZ6ZENaeXN4TUVFMVMxbHlUVWd2U25Ca2QyNU1hekZVZDJWc2VuSTRSMkZ2VG01cGJUZHdWbGRoYms1NE1VaHlNbUozU0ZjMmVtZ3hWM0ZJUzAwemEycG1XVlIxUjBob2JEbGxaSEYwWW5FeE1WUlJiazFuVVRKS2FtWjZlbUZUUlZSS2QyTk1ZVmxNVUdZNVFtSklaV2xqZUdSa05VdzBVRGt4TVhKSGJrNXlUMjUwUm1od1dGSm5OM0ZJWlhJNGJuSlllVVJQYzJRMVkweFZkR2hNVlZSSmQweDNPR05ZVVhRMVptUk9kakZ5ZGpGNVJYVktUVkV4VTBWcFMzVlZUVTVhYlc1S1lVWkROM0puVW5SeE5EMGlMQ0p0WVdNaU9pSTFOV1UwTTJObU5UVm1Nak13T1RRME1XRTBaakZtWkRrMVlXRmlOakkxT0dVNU9UZGtaVGd6WkRJelptSTROR1ZqTWpRNU5EUmtPVGMxTVRVek5XRm1JaXdpZEdGbklqb2lJbjA9',1787046907),('VZ0DBsDxynInssf2oRHVjonNIz9kLS7NVyEo57Uf',NULL,'51.158.248.221','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.3','ZXlKcGRpSTZJbkpITTNKSE1tWm9lbEpLUjI5TGJYQkRiMGhZZEZFOVBTSXNJblpoYkhWbElqb2laMW9yU2xSUlJDdHVhMVJIVlVKcWRrZEdSMk15T0VOVlJDOUlaMHRGYkhJd1pUZDJSRlYwY3pSaE9IUklZMUF4Y0RFeWRXTlBaRzQyY0hZd1F6aHFlbm8zUnprNGNEbFRibFJKV1V0NFVGZDFUbUpGVmsxTFFWRk1hV3RpSzBwNGJEZG1OMGh2WWtGTmVFdG5RbUpSZVRNdlIzUlJUMlkwZUZRM05FeExPRVI1VjAwdksxSnVjVTFEY0djeksyOWtPWGhhVkRaU05HUjJNMjVDYjNWTWR6VnlaMFl2V2s5UWNWTklLMHgyTjNGa2FGZG5LMnBuU0ZaRFJtdHpTSFZ1Y2s5Sk5rZFNkV2ROVFdoRE4zbEJjMWx6Y2tvdlp6MDlJaXdpYldGaklqb2lOakppTVdNMU1tRXdabUptTnpSa1pEUTFNbUZrTURJeFpUQXlNV0kwWXpkaFpqRmxNV1UwWmpJeE9EWTJOamhqTXprM09ERXhNekkyTW1ZME5qazFNU0lzSW5SaFp5STZJaUo5',1787051755),('wFi2evZ5oOiMnPnG987I3AQy352KHEHhPRTLi4g5',NULL,'51.158.248.221','python-httpx/0.28.1','ZXlKcGRpSTZJazlDTUZSV1RGTnVXbkJ0TjNCUk56aHNVVTVVUzNjOVBTSXNJblpoYkhWbElqb2lhRUZSWldkcE1WVnZNMGhLUXl0SlduVndWMjVtVGxOUVYxQkNORUl4YTBoNlJFMVRUakI1UkU5dkx6bEpNRWxPWVhSR2MyWmpkV1Z3TlU1VkwyTjNNVFJ3UVdodGJ6aFJTRlJ1VlU0d2RXaG1ZWGcwT0ZsdWMxUTJabUpQV25KcFlYY3dPRmx2ZUVKUVMwSllTWFF5T0VWQmFuSk9hR3hRTkZwRmRXNDJVR1FpTENKdFlXTWlPaUk0TTJObU5HSmlNVGM0WWpVMU9EWTVPRGxrT1dZeVpURTNOVFUzWXprek56SmtaVFpsTlRFMk9XUXlPVEprTUdVMFpUTTVPVEF6WWpGak4yTTBZMkl4SWl3aWRHRm5Jam9pSW4wPQ==',1787051752),('xdmEO3GeUKwebdcU5OZocgTmxoVywfQ6q73cbJoZ',NULL,'51.158.248.221','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','ZXlKcGRpSTZJbVZIUXpKSU1WcDZPVkZsTDI5SE4wRnpaRVZKYUZFOVBTSXNJblpoYkhWbElqb2lURkF2TkRWdE5HOXpVRVJWUzBvM0x6Qm9aa0ZRTkRKeGNrY3ZORkozZWxCa1RWSkRZWFIxVGxCdGJXRk9SV1ZIVGtNdlJGcExXSFV6WjA5Mk0xRXZWM1pGWkZGbmIxSjZjMjhyT0VWd01ETnJSR04yVkdRNE5reDBXbXBDY2xneE5tVmhja2x3V214WVNHWlhSRWhGUmtvelpWUjVSRm8yUjFSNmNFOXNhQzh2ZFhJNVVtMHhXbVY1YkVaV1JUaExaREF6TUZFdmJsVTJZVVJRUzNaSFYyRm1TMUJHZVdsT2IzRktUSEV2Vm01NmFrRnVRbVJtWm13MFdEaDJiMEUzYlZsNlFsQmpRMUp2U1Vwb2R6VjNWbXRFVUhabFp6MDlJaXdpYldGaklqb2lOelk0WWpRMU4yTm1NR0ppWTJSalltUTBOR1ZsWlRoaE5UWmxPVFl3TldRMk1UVXdOV0pqWVRrM04yVTBZMlUyWXpGaVpqVTVOVE0xTmpCaE5XVTVNQ0lzSW5SaFp5STZJaUo5',1787051756); /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) 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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'Talabetna Go Administrator','admin@talabetna-go.com','2026-08-17 10:03:01','$2y$12$V2dlbMtszF4WB8/wMlRNL.Hy.Jh8EZfd0c5fXzk/tDTcr.pg4QWeW','vt5doOuno6Hly7v8SWSUezwkXFYkLC7enc3Z4HKGj7acnJV9qc00AzZwtLvX','2026-08-17 10:02:01','2026-08-17 10:03:01'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-08-18 14:40:53