-- MySQL dump 10.13 Distrib 8.0.41, for Win64 (x86_64) -- -- Host: 127.0.0.1 Database: myfairlady_new -- ------------------------------------------------------ -- Server version 8.0.41 /*!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 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 `bill_counters` -- DROP TABLE IF EXISTS `bill_counters`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `bill_counters` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `financial_year` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Format: YY-YY (e.g., 24-25)', `last_bill_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Last generated bill number', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `bill_counters_financial_year_unique` (`financial_year`), KEY `bill_counters_financial_year_index` (`financial_year`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bill_counters` -- LOCK TABLES `bill_counters` WRITE; /*!40000 ALTER TABLE `bill_counters` DISABLE KEYS */; INSERT INTO `bill_counters` VALUES (1,'25-26','MFL/25-26/00105','2025-10-27 03:39:59','2025-10-27 03:40:48'); /*!40000 ALTER TABLE `bill_counters` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `bill_items` -- DROP TABLE IF EXISTS `bill_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `bill_items` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `bill_id` bigint unsigned NOT NULL, `product_id` int unsigned NOT NULL, `product_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `price` decimal(10,2) NOT NULL DEFAULT '0.00', `our_price` decimal(10,2) NOT NULL DEFAULT '0.00', `qty` int NOT NULL DEFAULT '1', `amount` decimal(10,2) NOT NULL DEFAULT '0.00', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `bill_items_bill_id_foreign` (`bill_id`), KEY `bill_items_product_id_foreign` (`product_id`), CONSTRAINT `bill_items_bill_id_foreign` FOREIGN KEY (`bill_id`) REFERENCES `bills` (`id`) ON DELETE CASCADE, CONSTRAINT `bill_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`product_id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bill_items` -- LOCK TABLES `bill_items` WRITE; /*!40000 ALTER TABLE `bill_items` DISABLE KEYS */; INSERT INTO `bill_items` VALUES (1,94,1,'MFL00001 - N/A',250.00,210.00,5,1050.00,'2025-08-27 05:07:31','2025-08-27 05:07:31'),(2,95,1,'MFL00001 - N/A',250.00,210.00,1,210.00,'2025-08-27 05:21:16','2025-08-27 05:21:16'),(3,95,6,'25JUL00006 - N/A',600.00,550.00,5,2750.00,'2025-08-27 05:21:16','2025-08-27 05:21:16'),(4,96,1,'MFL00001 - N/A',250.00,210.00,2,420.00,'2025-08-27 06:22:54','2025-08-27 06:22:54'),(5,96,6,'25JUL00006 - N/A',600.00,550.00,5,2750.00,'2025-08-27 06:22:54','2025-08-27 06:22:54'),(6,97,1,'MFL00001 - N/A',250.00,210.00,1,210.00,'2025-09-08 06:44:06','2025-09-08 06:44:06'),(7,98,1,'MFL00001 - N/A',250.00,210.00,1,210.00,'2025-09-15 04:13:42','2025-09-15 04:13:42'),(8,99,1,'MFL00001 - N/A',250.00,210.00,1,210.00,'2025-09-15 05:58:47','2025-09-15 05:58:47'),(9,99,6,'25JUL00006',600.00,550.00,-1,-550.00,'2025-09-15 05:58:47','2025-09-15 05:58:47'),(10,100,1,'MFL00001 - N/A',250.00,210.00,1,210.00,'2025-10-27 03:26:02','2025-10-27 03:26:02'),(11,101,2,'MFL00002 - N/A',250.00,200.00,1,200.00,'2025-10-27 03:26:27','2025-10-27 03:26:27'); /*!40000 ALTER TABLE `bill_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `bills` -- DROP TABLE IF EXISTS `bills`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `bills` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `customer_id` bigint unsigned NOT NULL DEFAULT '0', `bill_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bill_date` date NOT NULL, `total_qty` int NOT NULL DEFAULT '0', `total_amount` decimal(10,2) NOT NULL DEFAULT '0.00', `discount` decimal(10,2) NOT NULL DEFAULT '0.00', `tax_percentage` decimal(5,2) NOT NULL DEFAULT '0.00', `final_amount` decimal(10,2) NOT NULL DEFAULT '0.00', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `bills_bill_no_unique` (`bill_no`) ) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bills` -- LOCK TABLES `bills` WRITE; /*!40000 ALTER TABLE `bills` DISABLE KEYS */; INSERT INTO `bills` VALUES (94,0,'MFL/25-26/00001','2025-08-27',5,1050.00,0.00,5.00,210.00,'2025-08-27 05:07:31','2025-08-27 05:07:31'),(95,0,'MFL/25-26/00095','2025-08-27',6,2960.00,0.00,5.00,760.00,'2025-08-27 05:21:16','2025-08-27 05:21:16'),(96,0,'MFL/25-26/00096','2025-08-27',7,3170.00,50.00,5.00,3165.00,'2025-08-27 06:22:54','2025-08-27 06:22:54'),(97,0,'MFL/25-26/00097','2025-09-08',1,210.00,0.00,5.00,0.00,'2025-09-08 06:44:06','2025-09-08 06:44:06'),(98,0,'MFL/25-26/00098','2025-09-15',1,210.00,0.00,5.00,210.00,'2025-09-15 04:13:42','2025-09-15 04:13:42'),(99,0,'MFL/25-26/00099','2025-09-15',0,-340.00,0.00,5.00,210.00,'2025-09-15 05:58:47','2025-09-15 05:58:47'),(100,0,'MFL/25-26/00100','2025-10-27',1,210.00,0.00,5.00,0.00,'2025-10-27 03:26:02','2025-10-27 03:26:02'),(101,0,'MFL/25-26/00101','2025-10-27',1,200.00,0.00,5.00,0.00,'2025-10-27 03:26:27','2025-10-27 03:26:27'); /*!40000 ALTER TABLE `bills` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `brands` -- DROP TABLE IF EXISTS `brands`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `brands` ( `brand_id` int unsigned NOT NULL AUTO_INCREMENT, `brand_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `active_status` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`brand_id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `brands` -- LOCK TABLES `brands` WRITE; /*!40000 ALTER TABLE `brands` DISABLE KEYS */; INSERT INTO `brands` VALUES (1,'Max',1,'2025-07-17 04:15:56','2025-07-17 04:19:10'),(2,'Pepe Jeans',1,'2022-09-02 07:26:10','2022-09-06 12:49:23'),(3,'Prisma',1,'2022-09-02 07:26:10','2022-09-06 12:49:23'),(4,'Jack',1,'2022-09-02 07:26:10','2022-09-06 12:49:23'),(5,'Louis Philippe',1,'2022-09-02 07:26:15','2022-09-06 12:49:11'),(6,'Blackberrys',1,'2022-09-02 07:26:20','2022-09-06 12:48:56'),(7,'Arrow',1,'2022-09-02 07:26:25','2023-01-22 19:35:11'),(8,'Levi\'s',1,'2022-09-02 07:26:30','2022-09-06 12:48:38'),(9,'Nike',0,'2022-09-07 05:19:33','2022-10-13 18:35:07'),(10,'SONARI',1,'2024-11-29 14:02:49','2024-11-29 08:32:49'),(11,'TRYLO',1,'2024-11-29 14:02:59','2024-11-29 08:32:59'),(12,'RIZA',1,'2024-11-29 14:03:07','2024-11-29 08:33:07'),(13,'LOVABLE',1,'2024-11-29 14:07:14','2024-11-29 08:37:14'),(14,'ANGELFORM',1,'2024-11-29 14:07:21','2024-11-29 08:37:21'); /*!40000 ALTER TABLE `brands` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache` -- DROP TABLE IF EXISTS `cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cache` ( `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` int NOT NULL, PRIMARY KEY (`key`) ) 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 */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cache_locks` ( `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` int NOT NULL, PRIMARY KEY (`key`) ) 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 `categories` -- DROP TABLE IF EXISTS `categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `categories` ( `category_id` int unsigned NOT NULL AUTO_INCREMENT, `category_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `active_status` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`category_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `categories` -- LOCK TABLES `categories` WRITE; /*!40000 ALTER TABLE `categories` DISABLE KEYS */; INSERT INTO `categories` VALUES (1,'Bra',1,'2025-07-17 03:58:39','2025-07-18 03:52:26'),(2,'T-shirt',1,'2025-07-17 06:41:03','2025-07-17 06:41:03'),(3,'Panties',1,'2025-07-18 04:00:17','2025-07-18 04:00:17'); /*!40000 ALTER TABLE `categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `colors` -- DROP TABLE IF EXISTS `colors`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `colors` ( `color_id` int unsigned NOT NULL AUTO_INCREMENT, `color_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `active_status` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`color_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `colors` -- LOCK TABLES `colors` WRITE; /*!40000 ALTER TABLE `colors` DISABLE KEYS */; INSERT INTO `colors` VALUES (1,'Red',1,'2025-07-17 04:23:42','2025-07-17 04:24:00'),(2,'Orange',1,'2025-07-22 00:48:27','2025-07-22 00:48:27'); /*!40000 ALTER TABLE `colors` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customers` -- DROP TABLE IF EXISTS `customers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customers` ( `customer_id` int unsigned NOT NULL AUTO_INCREMENT, `customer_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mobile_number` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`customer_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customers` -- LOCK TABLES `customers` WRITE; /*!40000 ALTER TABLE `customers` DISABLE KEYS */; INSERT INTO `customers` VALUES (1,'suresh','9687542100',NULL,NULL),(2,'sureshgobi','9999999997','2025-07-22 05:14:12','2025-07-22 05:14:12'),(3,'salman','8888888887','2025-07-22 05:21:09','2025-07-22 05:21:09'); /*!40000 ALTER TABLE `customers` 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) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_batches` -- DROP TABLE IF EXISTS `job_batches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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 NOT NULL, `pending_jobs` int NOT NULL, `failed_jobs` int NOT NULL, `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `options` mediumtext COLLATE utf8mb4_unicode_ci, `cancelled_at` int DEFAULT NULL, `created_at` int NOT NULL, `finished_at` int 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 */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `attempts` tinyint unsigned NOT NULL, `reserved_at` int unsigned DEFAULT NULL, `available_at` int unsigned NOT NULL, `created_at` int unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `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) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 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_000001_create_cache_table',1),(2,'0001_01_01_000002_create_jobs_table',1),(3,'2023_01_01_000000_create_roles_table',2),(4,'2014_10_12_000000_create_users_table',3),(5,'2023_01_01_000001_create_categories_table',3),(6,'2023_01_01_000002_create_brands_table',3),(7,'2023_01_01_000003_create_colors_table',3),(8,'2023_01_01_000004_create_styles_table',3),(9,'2023_01_01_000005_create_sizes_table',3),(10,'2023_01_01_000006_create_products_table',3),(11,'2023_01_01_000007_create_bills_table',4),(12,'2023_01_01_000008_create_bill_items_table',4),(13,'2023_01_01_000009_create_customers_table',5),(14,'2025_07_18_154105_create_personal_access_tokens_table',6),(15,'2025_07_22_074514_add_tax_to_products_table',7),(16,'2025_07_22_095144_add_customer_id_to_bills_table',8),(17,'2025_10_27_084546_create_bill_counters_table',9),(18,'2025_10_27_084547_create_bill_counters_table',10); /*!40000 ALTER TABLE `migrations` 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) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint 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`) ) ENGINE=InnoDB AUTO_INCREMENT=12 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\\User',1,'auth_token','36f34ed10a3e00e821e55140aaf297f10c1ff4c697edd1e7296b5c71fc2d35c4','[\"*\"]','2025-07-18 10:17:38',NULL,'2025-07-18 10:17:19','2025-07-18 10:17:38'),(2,'App\\Models\\User',1,'auth_token','c064db0f8607d3a1396126ddd9bf596c570e891e580c15d0aaa4103ada6b78dc','[\"*\"]','2025-07-19 03:16:43',NULL,'2025-07-19 03:15:07','2025-07-19 03:16:43'),(3,'App\\Models\\User',1,'auth_token','3493727c18f8e26dda2781c3e089ecd80012da7962af9885ebb00687dbb0fc39','[\"*\"]','2025-07-19 03:18:45',NULL,'2025-07-19 03:18:23','2025-07-19 03:18:45'),(4,'App\\Models\\User',1,'auth_token','b89f09058c1c7d09b09d673525b0e7600f9b13970d74c07b86f611e1086ee547','[\"*\"]','2025-07-19 04:46:22',NULL,'2025-07-19 04:46:19','2025-07-19 04:46:22'),(5,'App\\Models\\User',1,'auth_token','dd2f35bd15821934b1a9a4c436111c4260b1164639e816e82090998411d0f5ce','[\"*\"]','2025-07-19 05:23:52',NULL,'2025-07-19 05:10:43','2025-07-19 05:23:52'),(6,'App\\Models\\User',1,'auth_token','04eb5f907d16875363764f739553fb67fc9036ce24a647efd04a6882bdd31ace','[\"*\"]','2025-09-08 08:09:39',NULL,'2025-07-22 00:05:53','2025-09-08 08:09:39'),(7,'App\\Models\\User',1,'auth_token','8d9b67344f2e08dc10aa4e41e5ee66050d87320a4196ed6b212f0fbd3cc0bc16','[\"*\"]',NULL,NULL,'2025-08-20 00:42:57','2025-08-20 00:42:57'),(8,'App\\Models\\User',1,'auth_token','608d85495baa6737d8e67c84861773a26bd31472f034eb9ba2395a13f2d7452a','[\"*\"]',NULL,NULL,'2025-08-25 00:03:26','2025-08-25 00:03:26'),(9,'App\\Models\\User',1,'auth_token','fb4927c8e090595707bde2605b4081b3c7887e47308d1168c5f95899603af042','[\"*\"]','2025-08-27 05:52:27',NULL,'2025-08-27 03:53:30','2025-08-27 05:52:27'),(10,'App\\Models\\User',1,'auth_token','7d951373f2fa6ae2d683b0723697fa3912360faa2b61342f9015c81c043ea7a2','[\"*\"]',NULL,NULL,'2025-10-27 02:07:54','2025-10-27 02:07:54'),(11,'App\\Models\\User',1,'auth_token','0d45166f504f5a8d62f4e1756cb2d7302a78ec4eba3f9b914dbe63199adc45cb','[\"*\"]',NULL,NULL,'2025-10-27 02:14:48','2025-10-27 02:14:48'); /*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products` -- DROP TABLE IF EXISTS `products`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `products` ( `product_id` int unsigned NOT NULL AUTO_INCREMENT, `product_code` longtext COLLATE utf8mb4_unicode_ci, `category_id` int unsigned DEFAULT NULL, `brand_id` int unsigned DEFAULT NULL, `style_id` int unsigned DEFAULT NULL, `size_id` int unsigned DEFAULT NULL, `color_id` int unsigned DEFAULT NULL, `threshold` int NOT NULL DEFAULT '2', `product_quantity` int NOT NULL DEFAULT '0', `product_manual_quantity` int NOT NULL DEFAULT '0', `product_mrp` decimal(10,2) NOT NULL DEFAULT '0.00', `product_price` decimal(10,2) NOT NULL DEFAULT '0.00', `tax` decimal(5,2) NOT NULL DEFAULT '0.00', `active_status` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`product_id`), KEY `products_category_id_foreign` (`category_id`), KEY `products_brand_id_foreign` (`brand_id`), KEY `products_style_id_foreign` (`style_id`), KEY `products_size_id_foreign` (`size_id`), KEY `products_color_id_foreign` (`color_id`), CONSTRAINT `products_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`brand_id`) ON DELETE SET NULL, CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`category_id`) ON DELETE SET NULL, CONSTRAINT `products_color_id_foreign` FOREIGN KEY (`color_id`) REFERENCES `colors` (`color_id`) ON DELETE SET NULL, CONSTRAINT `products_size_id_foreign` FOREIGN KEY (`size_id`) REFERENCES `sizes` (`size_id`) ON DELETE SET NULL, CONSTRAINT `products_style_id_foreign` FOREIGN KEY (`style_id`) REFERENCES `styles` (`style_id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=15 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,'MFL00001',1,1,1,1,1,10,19,0,250.00,210.00,5.00,1,'2025-07-17 06:22:37','2025-10-27 03:26:02',NULL),(2,'MFL00002',1,1,1,1,2,10,1,0,250.00,200.00,5.00,1,'2025-07-17 07:24:26','2025-10-27 03:26:27',NULL),(3,'MFL00003',3,7,1,1,1,2,10,0,300.00,250.00,12.00,1,'2025-07-18 05:36:23','2025-09-08 03:47:55','2025-09-08 03:47:55'),(4,'MFL00004',2,14,2,2,2,2,0,0,350.00,300.00,12.00,1,'2025-07-22 00:48:44','2025-09-08 03:38:21','2025-09-08 03:38:21'),(5,'MFL00005',2,14,2,2,2,2,0,0,500.00,450.00,5.00,1,'2025-07-22 00:52:37','2025-09-08 03:47:55','2025-09-08 03:47:55'),(6,'25JUL00006',1,6,1,2,2,2,37,0,600.00,550.00,12.00,1,'2025-07-22 00:57:34','2025-09-15 05:58:49',NULL),(7,'25JUL00007',1,14,1,2,1,2,0,0,600.00,550.00,5.00,1,'2025-07-22 02:24:36','2025-07-22 02:24:36',NULL),(8,'25JUL00008',1,14,1,1,1,2,0,0,600.00,550.00,5.00,1,'2025-07-22 02:29:03','2025-07-22 02:29:03',NULL),(9,'25JUL00009',1,14,1,2,1,2,49,0,600.00,550.00,12.00,1,'2025-07-22 02:34:21','2025-07-23 00:12:51',NULL),(10,'25JUL00010',1,14,2,2,2,2,0,0,200.00,200.00,12.00,1,'2025-07-23 00:30:40','2025-07-23 00:30:40',NULL),(11,'25JUL00011',1,1,1,2,2,6,4,0,200.00,200.00,5.00,1,'2025-07-23 04:07:17','2025-07-23 04:09:04',NULL),(12,'250800012',1,4,2,2,2,2,0,0,250.00,250.00,5.00,1,'2025-08-30 05:01:44','2025-08-30 05:01:44',NULL),(13,'250900013',1,14,2,2,1,2,0,0,199.00,199.00,12.00,1,'2025-09-08 03:52:00','2025-09-08 04:01:58',NULL),(14,'250900014',1,1,1,1,2,2,0,0,250.00,250.00,5.00,1,'2025-09-15 06:31:03','2025-09-15 06:31:03',NULL); /*!40000 ALTER TABLE `products` 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) COLLATE utf8mb4_unicode_ci NOT NULL, `active_status` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; INSERT INTO `roles` VALUES (1,'Admin',1,NULL,NULL); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sizes` -- DROP TABLE IF EXISTS `sizes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sizes` ( `size_id` int unsigned NOT NULL AUTO_INCREMENT, `size_name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `active_status` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`size_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sizes` -- LOCK TABLES `sizes` WRITE; /*!40000 ALTER TABLE `sizes` DISABLE KEYS */; INSERT INTO `sizes` VALUES (1,'44',1,'2025-07-17 04:49:51','2025-07-17 04:50:11'),(2,'24',1,'2025-07-22 00:48:13','2025-07-22 00:48:13'); /*!40000 ALTER TABLE `sizes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `styles` -- DROP TABLE IF EXISTS `styles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `styles` ( `style_id` int unsigned NOT NULL AUTO_INCREMENT, `style_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `active_status` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`style_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `styles` -- LOCK TABLES `styles` WRITE; /*!40000 ALTER TABLE `styles` DISABLE KEYS */; INSERT INTO `styles` VALUES (1,'Cap sleeves Cap sleeves Cap sleeves',1,'2025-07-17 04:31:11','2025-08-19 00:34:36'),(2,'Tesy',1,'2025-07-17 06:41:29','2025-07-17 06:41:29'); /*!40000 ALTER TABLE `styles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_type_id` int DEFAULT NULL, `role_id` bigint unsigned DEFAULT NULL, `user_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_email` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `active_status` tinyint(1) NOT NULL DEFAULT '1', `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_user_email_unique` (`user_email`), KEY `users_role_id_foreign` (`role_id`), CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE SET NULL ) 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,NULL,1,'admin','admin@yopmail.com','$2y$12$9pp7hySc/0GxfteVSeCDQOtIScscyCKlf.3QVspyr3yqEBEQwiSXa',1,NULL,'2025-07-17 02:17:19','2025-07-17 02:17:19'); /*!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 2025-10-27 15:02:05