-- 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
