--
-- Host: 127.0.0.1    Database: wms
-- ------------------------------------------------------


--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `action` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_id` bigint unsigned DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_logs`
--

INSERT INTO `activity_logs` VALUES (1,1,'login','User',1,'','127.0.0.1',1,'2025-06-06 02:31:19','2025-06-06 02:31:19'),(2,1,'Added','Inward',12,'Invoice Id : 5','127.0.0.1',1,'2025-06-06 03:00:20','2025-06-06 03:00:20'),(3,1,'Updated','Inward',12,'Invoice Id : 5','127.0.0.1',1,'2025-06-06 04:04:41','2025-06-06 04:04:41'),(4,1,'Deleted','Inward',12,'Invoice Id : 5','127.0.0.1',1,'2025-06-06 04:07:03','2025-06-06 04:07:03'),(5,1,'login','User',1,'','127.0.0.1',1,'2025-06-06 06:53:49','2025-06-06 06:53:49'),(6,1,'Updated','Role',1,'','127.0.0.1',1,'2025-06-06 06:55:12','2025-06-06 06:55:12'),(7,1,'Updated','Role',1,'','127.0.0.1',1,'2025-06-06 07:17:40','2025-06-06 07:17:40'),(8,1,'login','User',1,'','127.0.0.1',1,'2025-06-06 23:22:53','2025-06-06 23:22:53'),(9,1,'Updated','Role',1,'','127.0.0.1',1,'2025-06-07 00:09:48','2025-06-07 00:09:48'),(10,1,'Updated','Role',1,'','127.0.0.1',1,'2025-06-07 00:18:10','2025-06-07 00:18:10'),(11,1,'Deleted','User',13,'User Name : MS dhoni','127.0.0.1',1,'2025-06-07 02:52:15','2025-06-07 02:52:15'),(12,1,'Deleted','User',14,'User Name : Omkar more','127.0.0.1',1,'2025-06-07 03:54:43','2025-06-07 03:54:43'),(13,1,'Added','User',15,'','127.0.0.1',1,'2025-06-07 03:55:36','2025-06-07 03:55:36'),(14,1,'login','User',1,'','127.0.0.1',1,'2025-06-07 04:16:02','2025-06-07 04:16:02'),(15,1,'login','User',1,'','127.0.0.1',1,'2025-06-07 04:56:19','2025-06-07 04:56:19'),(16,1,'Updated','Role',1,'','127.0.0.1',1,'2025-06-07 04:57:03','2025-06-07 04:57:03'),(17,1,'login','User',1,'','127.0.0.1',1,'2025-06-08 23:14:51','2025-06-08 23:14:51'),(18,1,'Updated','User',12,'User Name : Mayur pawar','127.0.0.1',1,'2025-06-09 00:17:43','2025-06-09 00:17:43'),(19,1,'Updated','User',12,'User Name : Mayur pawar','127.0.0.1',1,'2025-06-09 00:26:00','2025-06-09 00:26:00'),(20,1,'login','User',1,'','127.0.0.1',1,'2025-06-09 02:10:24','2025-06-09 02:10:24'),(21,1,'login','User',1,'','127.0.0.1',1,'2025-06-09 03:56:36','2025-06-09 03:56:36'),(22,1,'Updated','Role',1,'','127.0.0.1',1,'2025-06-09 04:36:55','2025-06-09 04:36:55'),(23,1,'Updated','Role',1,'','127.0.0.1',1,'2025-06-09 06:47:00','2025-06-09 06:47:00'),(24,1,'login','User',1,'','127.0.0.1',1,'2025-06-09 23:57:17','2025-06-09 23:57:17'),(25,1,'login','User',1,'','127.0.0.1',1,'2025-06-09 23:59:31','2025-06-09 23:59:31'),(26,1,'login','User',1,'','127.0.0.1',1,'2025-06-10 00:58:31','2025-06-10 00:58:31'),(27,1,'login','User',1,'','127.0.0.1',1,'2025-06-10 02:41:49','2025-06-10 02:41:49'),(28,1,'login','User',1,'','127.0.0.1',1,'2025-06-10 23:43:34','2025-06-10 23:43:34'),(29,1,'login','User',1,'','127.0.0.1',1,'2025-06-11 00:32:30','2025-06-11 00:32:30'),(30,1,'login','User',1,'','127.0.0.1',1,'2025-06-11 01:08:31','2025-06-11 01:08:31'),(31,1,'login','User',1,'','127.0.0.1',1,'2025-06-11 01:33:45','2025-06-11 01:33:45'),(32,1,'login','User',1,'','127.0.0.1',1,'2025-06-11 02:13:17','2025-06-11 02:13:17'),(33,1,'login','User',1,'','127.0.0.1',1,'2025-06-11 06:38:21','2025-06-11 06:38:21'),(34,1,'Updated','Role',1,'','127.0.0.1',1,'2025-06-11 06:44:00','2025-06-11 06:44:00'),(35,1,'Updated','Role',1,'','127.0.0.1',1,'2025-06-11 06:49:08','2025-06-11 06:49:08'),(36,1,'login','User',1,'','127.0.0.1',1,'2025-06-12 00:15:23','2025-06-12 00:15:23'),(37,1,'Updated','Role',1,'','127.0.0.1',1,'2025-06-12 00:16:44','2025-06-12 00:16:44'),(38,1,'Updated','Role',1,'','127.0.0.1',1,'2025-06-12 00:18:53','2025-06-12 00:18:53'),(39,1,'login','User',1,'','127.0.0.1',1,'2025-06-12 01:18:39','2025-06-12 01:18:39'),(40,1,'login','User',1,'','127.0.0.1',1,'2025-06-12 03:49:01','2025-06-12 03:49:01'),(41,1,'login','User',1,'','127.0.0.1',1,'2025-06-12 05:02:48','2025-06-12 05:02:48'),(42,1,'login','User',1,'','192.168.1.41',1,'2025-06-12 05:11:55','2025-06-12 05:11:55'),(43,1,'login','User',1,'','127.0.0.1',1,'2025-06-12 06:06:56','2025-06-12 06:06:56'),(44,1,'login','User',1,'','127.0.0.1',1,'2025-06-12 06:18:13','2025-06-12 06:18:13'),(45,1,'login','User',1,'','127.0.0.1',1,'2025-06-12 06:37:59','2025-06-12 06:37:59'),(46,1,'Updated','Role',1,'','127.0.0.1',1,'2025-06-12 06:38:47','2025-06-12 06:38:47'),(47,1,'Updated','Role',1,'','127.0.0.1',1,'2025-06-12 06:39:05','2025-06-12 06:39:05'),(48,1,'Updated','Role',1,'','127.0.0.1',1,'2025-06-12 06:39:24','2025-06-12 06:39:24'),(49,1,'Updated','Role',1,'','127.0.0.1',1,'2025-06-12 06:42:23','2025-06-12 06:42:23'),(50,1,'login','User',1,'','127.0.0.1',1,'2025-06-12 06:51:25','2025-06-12 06:51:25'),(51,1,'Updated','User',8,'Customer Name : Akshay Tate','127.0.0.1',1,'2025-06-12 06:56:58','2025-06-12 06:56:58'),(52,1,'Updated','User',9,'Customer Name : Aniket tate','127.0.0.1',1,'2025-06-12 06:57:10','2025-06-12 06:57:10'),(53,1,'login','User',1,'','127.0.0.1',1,'2025-06-12 23:43:39','2025-06-12 23:43:39'),(54,1,'login','User',1,'','127.0.0.1',1,'2025-06-13 05:32:07','2025-06-13 05:32:07'),(55,1,'login','User',1,'','127.0.0.1',1,'2025-06-14 00:04:15','2025-06-14 00:04:15'),(56,1,'login','User',1,'','127.0.0.1',1,'2025-06-14 06:19:31','2025-06-14 06:19:31'),(57,1,'login','User',1,'','127.0.0.1',1,'2025-06-15 23:22:35','2025-06-15 23:22:35'),(58,1,'login','User',1,'','127.0.0.1',1,'2025-06-15 23:55:00','2025-06-15 23:55:00'),(59,1,'login','User',1,'','127.0.0.1',1,'2025-06-16 00:50:05','2025-06-16 00:50:05');

--
-- Table structure for table `banks`
--

CREATE TABLE `banks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `warehouse_id` tinyint NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bank_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `branch` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ifsc_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `createdby` tinyint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banks`
--

INSERT INTO `banks` VALUES (1,6,'Pradip Jadhav','Kotak 811','Satara','123412341234','QWE1231',1,1,'2025-05-10 00:33:07','2025-05-24 04:48:18'),(2,5,'Mayur Vaidya','ICICI','Pune','678967899876','ICICI2323',1,1,'2025-05-10 00:43:57','2025-05-24 04:48:25');

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `createdby` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1,'Dry fruit',1,1,'2025-05-08 04:02:41','2025-05-08 04:03:42'),(3,'Liquid',1,0,'2025-05-09 04:25:36','2025-05-09 04:25:36');

--
-- Table structure for table `customer_in_outs`
--

CREATE TABLE `customer_in_outs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `customer_id` bigint unsigned NOT NULL,
  `warehouse_id` bigint unsigned NOT NULL,
  `rack_id` bigint unsigned NOT NULL DEFAULT '0',
  `partition_id` bigint unsigned NOT NULL DEFAULT '0',
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_sqft` double NOT NULL,
  `parent_id` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_in_outs`
--

INSERT INTO `customer_in_outs` VALUES (15,'2025-06-01',11,6,4,3,'in',500,7,'2025-06-02 04:34:46','2025-06-02 04:34:46'),(16,'2025-06-02',10,6,4,3,'in',250,8,'2025-06-02 04:41:21','2025-06-02 04:41:21'),(17,'2025-06-02',11,6,4,3,'out',100,2,'2025-06-02 04:44:20','2025-06-02 04:44:20'),(18,'2025-06-02',10,6,4,3,'out',50,3,'2025-06-02 04:44:55','2025-06-02 04:44:55'),(19,'2025-06-02',10,5,5,4,'stin',50,8,'2025-06-02 04:46:39','2025-06-02 04:46:39'),(20,'2025-06-02',10,6,4,3,'stout',50,8,'2025-06-02 04:46:39','2025-06-02 04:46:39'),(21,'2025-06-02',11,6,4,3,'adjust',50,3,'2025-06-02 04:47:43','2025-06-02 04:47:43'),(22,'2025-05-31',10,5,5,4,'in',250,9,'2025-06-02 06:06:35','2025-06-02 06:06:35'),(23,'2025-06-06',11,6,4,3,'in',140,11,'2025-06-05 23:36:28','2025-06-05 23:36:28'),(24,'2025-06-06',11,6,4,3,'out',140,4,'2025-06-05 23:45:18','2025-06-05 23:45:18');

--
-- Table structure for table `customer_invoices`
--

CREATE TABLE `customer_invoices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `customer_id` bigint unsigned NOT NULL,
  `warehouse_id` bigint NOT NULL,
  `rate` decimal(10,2) NOT NULL,
  `pdf_path` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `max_sqft` double NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `igst` decimal(10,2) NOT NULL,
  `cgst` decimal(10,2) NOT NULL,
  `sgst` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_invoices`
--

INSERT INTO `customer_invoices` VALUES (1,'2025-05-31',11,6,50.00,'invoices/June_68467f0c471ab.pdf',500,'2025-06-01','2025-06-30',29500.00,4500.00,0.00,0.00,'2025-06-09 00:58:35','2025-06-09 00:58:35'),(2,'2025-05-31',10,6,50.00,'invoices/June_68467f1567bdd.pdf',250,'2025-06-01','2025-06-30',14750.00,0.00,1125.00,1125.00,'2025-06-09 00:58:41','2025-06-09 00:58:41'),(3,'2025-06-16',11,6,50.00,'invoices/June_684fb8ef7b3bf.pdf',500,'2025-06-01','2025-06-30',29500.00,4500.00,0.00,0.00,'2025-06-16 00:55:57','2025-06-16 00:55:57'),(4,'2025-06-16',10,6,50.00,'invoices/June_684fb8f798a11.pdf',250,'2025-06-01','2025-06-30',14750.00,0.00,1125.00,1125.00,'2025-06-16 00:56:01','2025-06-16 00:56:01');

--
-- Table structure for table `customer_payments`
--

CREATE TABLE `customer_payments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint unsigned NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ref` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `screenshot` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `flag` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_payments`
--

INSERT INTO `customer_payments` VALUES (1,11,29500.00,'debit',NULL,NULL,NULL,NULL,0,'2025-06-09 00:58:35','2025-06-09 00:58:35'),(2,10,14750.00,'debit',NULL,NULL,NULL,NULL,0,'2025-06-09 00:58:41','2025-06-09 00:58:41'),(3,11,29500.00,'debit',NULL,NULL,NULL,NULL,0,'2025-06-16 00:55:57','2025-06-16 00:55:57'),(4,10,14750.00,'debit',NULL,NULL,NULL,NULL,0,'2025-06-16 00:56:01','2025-06-16 00:56:01');

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_details` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `gstin` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `createdby` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customers`
--


--
-- Table structure for table `database_backups`
--

CREATE TABLE `database_backups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `file_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `database_backups`
--


--
-- Table structure for table `expense_categories`
--

CREATE TABLE `expense_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expense_categories`
--

INSERT INTO `expense_categories` VALUES (1,'Advertising','2025-05-10 06:11:49','2025-05-10 06:11:49'),(2,'Petrol','2025-05-10 06:36:20','2025-05-10 06:36:20');

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `expense_id` tinyint NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `date` date NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` tinyint NOT NULL DEFAULT '0',
  `createdby` tinyint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `expense_id` (`expense_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expenses`
--

INSERT INTO `expenses` VALUES (2,2,'MH11AB2025',1000.00,'2025-05-09','From mayur',1,1,'2025-05-10 06:36:20','2025-05-10 06:36:20'),(3,2,'Abcdggd',100.00,'2025-05-22','23234234',1,1,'2025-05-22 05:51:50','2025-05-22 05:51:50');

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

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `inward_details`
--

CREATE TABLE `inward_details` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint NOT NULL,
  `sku` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` double NOT NULL,
  `l` double NOT NULL,
  `w` double NOT NULL,
  `h` double NOT NULL DEFAULT '0',
  `gst` double NOT NULL DEFAULT '0',
  `rate` double NOT NULL DEFAULT '0',
  `total_rate` double NOT NULL DEFAULT '0',
  `product_sqft` double NOT NULL DEFAULT '0',
  `parent_id` bigint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_id` (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inward_details`
--

INSERT INTO `inward_details` VALUES (9,1,'0898',10,5,10,1,5,100,1000,500,7,'2025-06-02 04:34:45','2025-06-02 04:34:45'),(10,2,'3528',5,10,5,1,5,100,500,250,8,'2025-06-02 04:41:21','2025-06-02 04:41:21'),(11,2,'3528',5,10,5,1,5,100,500,250,9,'2025-06-02 06:06:35','2025-06-02 06:06:35'),(15,5,'8374',10,1,5,2,0,100,1000,100,11,'2025-06-05 23:36:28','2025-06-05 23:36:28'),(14,7,'9451',10,1,2,2,5,1000,10000,40,11,'2025-06-05 23:36:28','2025-06-05 23:36:28');

--
-- Table structure for table `inwards`
--

CREATE TABLE `inwards` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `invoice_no` bigint NOT NULL,
  `date` date NOT NULL,
  `customer_id` bigint NOT NULL,
  `warehouse_id` bigint NOT NULL,
  `rack_id` bigint NOT NULL,
  `partition_id` bigint NOT NULL,
  `total_sqft` double NOT NULL,
  `custom_fleld1` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_fleld2` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_fleld3` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_fleld4` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `createdby` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `inwards_invoice_no_unique` (`invoice_no`),
  KEY `customer_id` (`customer_id`),
  KEY `warehouse_id` (`warehouse_id`),
  KEY `rack_id` (`rack_id`),
  KEY `partition_id` (`partition_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inwards`
--

INSERT INTO `inwards` VALUES (7,1,'2025-06-01',11,6,4,3,500,'','','','',1,'2025-06-02 04:34:45','2025-06-02 04:34:45'),(8,2,'2025-06-02',10,6,4,3,250,'','','','',1,'2025-06-02 04:41:21','2025-06-02 04:41:21'),(9,3,'2025-05-31',10,5,5,4,250,'','','','',1,'2025-06-02 06:06:35','2025-06-02 06:06:35'),(11,4,'2025-06-06',11,6,4,3,140,NULL,NULL,NULL,NULL,1,'2025-06-05 23:36:28','2025-06-05 23:36:28');

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

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

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

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_reset_tokens_table',1),(3,'2014_10_12_100000_create_password_resets_table',1),(4,'2019_08_19_000000_create_failed_jobs_table',1),(5,'2019_12_14_000001_create_personal_access_tokens_table',1),(6,'2025_05_05_050523_create_roles_table',1),(7,'2025_05_05_055310_create_permissions_table',1),(8,'2025_05_07_080948_create_warehouses_table',2),(9,'2025_05_07_081521_create_racks_table',2),(10,'2025_05_07_082316_create_partitions_table',2),(11,'2025_05_07_082821_create_products_table',2),(12,'2025_05_07_083301_create_customers_table',2),(13,'2025_05_07_083516_create_categories_table',2),(14,'2025_05_07_083658_create_uoms_table',2),(15,'2025_05_10_044554_create_banks_table',3),(16,'2025_05_10_071211_create_expenses_table',4),(17,'2025_05_10_074547_create_expense_categories_table',5),(18,'2025_05_12_051915_create_warranties_table',6),(19,'2025_05_12_065039_create_variations_table',7),(20,'2025_05_14_060847_create_inwards_table',8),(21,'2025_05_14_060908_create_inward_details_table',8),(22,'2025_05_22_122152_create_outwards_table',9),(23,'2025_05_22_123014_create_outward_details_table',9),(24,'2025_05_24_121001_create_database_backups_table',10),(25,'2025_05_27_062220_create_device_tokens_table',11),(26,'2025_05_27_093912_create_stock_transfers_table',12),(27,'2025_05_27_093943_create_stock_transfer_details_table',12),(28,'2025_05_28_110028_create_stock_adjustments_table',13),(29,'2025_05_28_110250_create_stock_adjustment_details_table',13),(30,'2025_06_02_064110_create_customer_in_outs_table',14),(31,'2025_06_02_103332_create_customer_invoices_table',15),(32,'2025_06_03_081537_create_customer_payments_table',16),(33,'2025_06_06_062528_create_activity_logs_table',17),(34,'2025_06_07_104236_create_company_settings_table',18);

--
-- Table structure for table `outward_details`
--

CREATE TABLE `outward_details` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint NOT NULL,
  `sku` bigint NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `l` double NOT NULL DEFAULT '0',
  `w` double NOT NULL DEFAULT '0',
  `h` double NOT NULL DEFAULT '0',
  `gst` double NOT NULL DEFAULT '0',
  `rate` double NOT NULL DEFAULT '0',
  `total_rate` decimal(10,2) NOT NULL,
  `product_sqft` double NOT NULL DEFAULT '0',
  `parent_id` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `outward_details`
--

INSERT INTO `outward_details` VALUES (4,1,898,2,5,10,1,5,100,200.00,100,2,'2025-06-02 04:44:20','2025-06-02 04:44:20'),(5,2,3528,1,10,5,1,5,100,100.00,50,3,'2025-06-02 04:44:54','2025-06-02 04:44:54'),(6,7,9451,10,1,2,2,5,1000,10000.00,40,4,'2025-06-05 23:45:18','2025-06-05 23:45:18'),(7,5,8374,10,1,5,2,0,100,1000.00,100,4,'2025-06-05 23:45:18','2025-06-05 23:45:18');

--
-- Table structure for table `outwards`
--

CREATE TABLE `outwards` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `invoice_no` bigint NOT NULL,
  `date` date NOT NULL,
  `customer_id` bigint NOT NULL,
  `warehouse_id` bigint NOT NULL,
  `rack_id` bigint NOT NULL,
  `partition_id` bigint NOT NULL,
  `total_sqft` double NOT NULL,
  `custom_fleld1` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_fleld2` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_fleld3` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_fleld4` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `createdby` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `outwards_invoice_no_unique` (`invoice_no`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `outwards`
--

INSERT INTO `outwards` VALUES (2,1,'2025-06-02',11,6,4,3,100,'','','','',1,'2025-06-02 04:44:20','2025-06-02 04:44:20'),(3,2,'2025-06-02',10,6,4,3,50,'','','','',1,'2025-06-02 04:44:54','2025-06-02 04:44:54'),(4,3,'2025-06-06',11,6,4,3,140,NULL,NULL,NULL,NULL,1,'2025-06-05 23:45:18','2025-06-05 23:45:18');

--
-- Table structure for table `partitions`
--

CREATE TABLE `partitions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `warehouse_id` bigint unsigned NOT NULL,
  `rack_id` bigint unsigned NOT NULL,
  `partition_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `area_sqft` double NOT NULL DEFAULT '0',
  `rem_sqft` double NOT NULL DEFAULT '0',
  `status` tinyint NOT NULL DEFAULT '1',
  `createdby` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `partitions_warehouse_id_foreign` (`warehouse_id`),
  KEY `partitions_rack_id_foreign` (`rack_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partitions`
--

INSERT INTO `partitions` VALUES (4,5,5,'A1',1000,700,1,1,'2025-05-23 04:08:24','2025-06-02 06:06:35'),(3,6,4,'A1',1000,500,1,1,'2025-05-23 04:07:47','2025-06-06 04:07:03');

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

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `attribute` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `permissions` VALUES (1,'User','{\"read\":\"user_read\",\"create\":\"create_user\",\"edit\":\"edit_user\",\"delete\":\"delete_user\"}','2025-05-05 10:07:37','2025-05-05 10:07:44'),(2,'Role','{\"read\":\"role_read\",\"create\":\"role_create\",\"edit\":\"edit_role\",\"delete\":\"delete_role\"}','2025-05-05 10:07:41','2025-05-05 10:07:47'),(3,'Warehouse','{\"read\":\"warehouse_read\",\"create\":\"create_warehouse\",\"edit\":\"edit_warehouse\",\"delete\":\"delete_warehouse\"}','2025-05-07 10:18:33','2025-05-07 10:18:33'),(4,'Rack','{\"read\":\"rack_read\",\"create\":\"create_rack\",\"edit\":\"edit_rack\",\"delete\":\"delete_rack\"}','2025-05-07 12:28:30','2025-05-07 12:28:30'),(5,'Partition','{\"read\":\"partition_read\",\"create\":\"create_partition\",\"edit\":\"edit_partition\",\"delete\":\"delete_partition\"}','2025-05-08 07:21:13','2025-05-08 07:21:13'),(6,'Product','{\"read\":\"product_read\",\"create\":\"create_product\",\"edit\":\"edit_product\",\"delete\":\"delete_product\",\"import\":\"import_product\"}','2025-05-08 07:22:28','2025-05-08 07:22:28'),(7,'Customer','{\"read\":\"customer_read\",\"create\":\"create_customer\",\"edit\":\"edit_customer\",\"delete\":\"delete_customer\",\"import\":\"import_customer\"}','2025-05-08 07:23:25','2025-05-08 07:23:25'),(8,'Catergory','{\"read\":\"category_read\",\"create\":\"create_category\",\"edit\":\"edit_category\",\"delete\":\"delete_category\"}','2025-05-08 07:24:43','2025-05-08 07:24:43'),(9,'UOM','{\"read\":\"uom_read\",\"create\":\"create_uom\",\"edit\":\"edit_uom\",\"delete\":\"delete_uom\"}','2025-05-08 07:25:55','2025-05-08 07:25:55'),(10,'Bank','{\"read\":\"bank_read\",\"create\":\"create_bank\",\"edit\":\"edit_bank\",\"delete\":\"delete_bank\"}','2025-05-10 05:07:56','2025-05-10 05:07:56'),(11,'Expense','{\"read\":\"expense_read\",\"create\":\"create_expense\",\"edit\":\"edit_expense\",\"delete\":\"delete_expense\"}','2025-05-10 07:43:09','2025-05-10 07:43:09'),(12,'Warranty','{\"read\":\"warranty_read\",\"create\":\"create_warranty\",\"edit\":\"edit_warranty\",\"delete\":\"delete_warranty\"}','2025-05-12 05:54:05','2025-05-12 05:54:05'),(13,'Variations','{\"read\":\"variation_read\",\"create\":\"create_variation\",\"edit\":\"edit_variation\",\"delete\":\"delete_variation\"}','2025-05-12 09:24:15','2025-05-12 09:24:15'),(14,'Inwards','{\"read\":\"inward_read\",\"create\":\"create_inward\",\"edit\":\"edit_inward\",\"delete\":\"delete_inward\",\"import\":\"import_inward\"}','2025-05-15 07:44:05','2025-05-15 07:44:05'),(15,'Outwards','{\"read\":\"outward_read\",\"create\":\"create_outward\",\"edit\":\"edit_outward\",\"delete\":\"delete_outward\",\"import\":\"import_outward\"}','2025-05-22 12:13:38','2025-05-22 12:13:39'),(16,'Stock Transfer','{\"read\":\"stocktransfer_read\",\"create\":\"create_stocktransfer\",\"edit\":\"edit_stocktransfer\",\"delete\":\"delete_stocktransfer\"}','2025-05-24 11:33:27','2025-05-24 11:33:27'),(17,'Stock Adjustment','{\"read\":\"stockadjustment_read\",\"create\":\"create_stockadjustment\",\"edit\":\"edit_stockadjustment\",\"delete\":\"delete_stockadjustment\"}','2025-05-28 10:37:35','2025-05-28 10:37:35'),(18,'Reports','{\"items\":\"items_read\",\"expence\":\"expense_report_read\",\"Sale Payment\":\"sale_payment_read\",\"Inward\":\"inward_report_read\",\"Outward\":\"outward_report_read\",\"Stock Adjustment\":\"stock_adjustment_read\",\"Stock expiry\":\"stock_expiry_read\",\"stock\":\"stock_read\",\"Customer\":\"customer_report_read\",\"Rack Utilization\":\"rack_utilization_read\",\"Rent Collection\":\"rent_collection_read\",\"Space Allocation Summary\":\"space_allocation_read\",\"Transefer History\":\"transfer_read\",\"category wise Stock\":\"category_wise_stock_read\",\"Customer WIse Billing Report\":\"customer_wise_billing_read\",\"Tax Report\":\"tax_read\",\"activity log\":\"activity_log_read\"}','2025-06-06 05:55:41','2025-06-06 05:55:41'),(19,'Push Notification','{\"push notification\":\"pushnotification_read\"}','2025-06-07 05:41:43','2025-06-06 18:30:00'),(20,'Administer Backup','{\"Administer Backup\":\"administerbk_read\"}','2025-06-07 05:43:33','2025-06-07 05:43:33'),(21,'Company Setting','{\"Company Setting\":\"companysetting_read\"}','2025-06-07 10:23:34','2025-06-07 10:23:34');

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint NOT NULL DEFAULT '0',
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sku` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `selling_price_tax_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchase_exc_tx` decimal(10,2) NOT NULL,
  `purchase_inc_tx` decimal(10,2) NOT NULL,
  `sale_exc_tx` decimal(10,2) NOT NULL,
  `sale_inc_tx` decimal(10,2) NOT NULL,
  `gst` decimal(5,2) NOT NULL,
  `l` decimal(10,2) NOT NULL,
  `b` decimal(10,2) NOT NULL,
  `h` decimal(10,2) NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `duration` double DEFAULT NULL,
  `duration_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `variation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unit_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` bigint unsigned NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `createdby` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `products_sku_unique` (`sku`),
  KEY `products_category_id_foreign` (`category_id`),
  KEY `customer_id` (`customer_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` VALUES (1,11,'coconut','0898','inclusive',95.24,100.00,95.24,100.00,5.00,5.00,10.00,1.00,0,1,'Days','','1',1,1,1,'2025-05-13 02:19:26','2025-05-28 00:47:56'),(2,10,'Almond','3528','inclusive',95.24,100.00,95.24,100.00,5.00,10.00,5.00,1.00,0,1,'Days','','1',1,1,1,'2025-05-13 06:16:28','2025-05-28 00:43:54'),(4,10,'Peanut','0108','exclusive',95.00,95.00,95.00,95.00,0.00,10.00,6.00,1.00,0,1,'Days','','1',1,1,1,'2025-05-20 05:04:58','2025-05-28 00:44:19'),(5,11,'Mnagos','8374','inclusive',100.00,100.00,100.00,100.00,0.00,1.00,5.00,2.00,5,10,'Days','hapus','1',1,1,1,'2025-06-04 06:53:05','2025-06-05 04:55:24'),(6,10,'cake','2913','inclusive',95.00,100.00,95.00,100.00,5.00,4.00,3.00,3.00,0,3,'Days','','1',1,1,1,'2025-06-04 23:22:15','2025-06-04 23:22:15'),(7,11,'Orange','9451','inclusive',950.00,1000.00,950.00,1000.00,5.00,1.00,2.00,2.00,0,1,'Months','','1',1,1,1,'2025-06-05 04:54:30','2025-06-05 04:54:30');

--
-- Table structure for table `racks`
--

CREATE TABLE `racks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `warehouse_id` bigint unsigned NOT NULL,
  `rack_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_area_sqft` double NOT NULL DEFAULT '0',
  `rem_sqft` double NOT NULL DEFAULT '0',
  `number_of_partitions` int NOT NULL DEFAULT '0',
  `monthly_rent_rate` decimal(10,2) NOT NULL,
  `per_sqft_rent_rate` decimal(10,2) NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `createdby` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `racks_warehouse_id_foreign` (`warehouse_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `racks`
--

INSERT INTO `racks` VALUES (5,5,'A',10000,9700,0,1000.00,10.00,1,1,'2025-05-23 04:07:12','2025-06-02 06:06:35'),(4,6,'A',10000,9500,0,1000.00,10.00,1,1,'2025-05-23 04:06:42','2025-06-06 04:07:03');

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

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `permissions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` tinyint NOT NULL DEFAULT '1',
  `createdby` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`),
  UNIQUE KEY `roles_slug_unique` (`slug`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` VALUES (1,'Admin','admin','[\"user_read\",\"create_user\",\"edit_user\",\"delete_user\",\"role_read\",\"role_create\",\"edit_role\",\"delete_role\",\"warehouse_read\",\"create_warehouse\",\"edit_warehouse\",\"delete_warehouse\",\"rack_read\",\"create_rack\",\"edit_rack\",\"delete_rack\",\"partition_read\",\"create_partition\",\"edit_partition\",\"delete_partition\",\"product_read\",\"create_product\",\"edit_product\",\"delete_product\",\"import_product\",\"customer_read\",\"create_customer\",\"edit_customer\",\"delete_customer\",\"import_customer\",\"category_read\",\"create_category\",\"edit_category\",\"delete_category\",\"uom_read\",\"create_uom\",\"edit_uom\",\"delete_uom\",\"bank_read\",\"create_bank\",\"edit_bank\",\"delete_bank\",\"expense_read\",\"create_expense\",\"edit_expense\",\"delete_expense\",\"warranty_read\",\"create_warranty\",\"edit_warranty\",\"delete_warranty\",\"variation_read\",\"create_variation\",\"edit_variation\",\"delete_variation\",\"inward_read\",\"create_inward\",\"edit_inward\",\"delete_inward\",\"import_inward\",\"outward_read\",\"create_outward\",\"edit_outward\",\"delete_outward\",\"import_outward\",\"stocktransfer_read\",\"create_stocktransfer\",\"edit_stocktransfer\",\"delete_stocktransfer\",\"stockadjustment_read\",\"create_stockadjustment\",\"edit_stockadjustment\",\"delete_stockadjustment\",\"items_read\",\"expense_report_read\",\"sale_payment_read\",\"inward_report_read\",\"outward_report_read\",\"stock_adjustment_read\",\"stock_expiry_read\",\"stock_read\",\"customer_report_read\",\"transfer_read\",\"customer_wise_billing_read\",\"activity_log_read\",\"pushnotification_read\",\"administerbk_read\",\"companysetting_read\"]',1,0,'2025-05-05 01:18:48','2025-06-12 06:42:23'),(5,'Account','account','[\"user_read\"]',1,0,'2025-05-06 23:36:21','2025-05-06 23:47:44');

--
-- Table structure for table `stock_adjustment_details`
--

CREATE TABLE `stock_adjustment_details` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint NOT NULL,
  `sku` bigint NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `l` double NOT NULL DEFAULT '0',
  `w` double NOT NULL DEFAULT '0',
  `h` double NOT NULL DEFAULT '0',
  `gst` double NOT NULL DEFAULT '0',
  `rate` double NOT NULL DEFAULT '0',
  `total_rate` decimal(10,2) NOT NULL,
  `product_sqft` double NOT NULL DEFAULT '0',
  `parent_id` bigint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stock_adjustment_details`
--

INSERT INTO `stock_adjustment_details` VALUES (5,1,898,1,5,10,1,5,100,100.00,50,3,'2025-06-02 04:47:43','2025-06-02 04:47:43');

--
-- Table structure for table `stock_adjustments`
--

CREATE TABLE `stock_adjustments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `adjustment_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `customer_id` bigint unsigned NOT NULL,
  `warehouse_id` bigint unsigned NOT NULL,
  `rack_id` bigint unsigned NOT NULL,
  `partition_id` bigint unsigned NOT NULL,
  `total_sqft` double NOT NULL,
  `remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `createdby` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `stock_adjustments_adjustment_number_unique` (`adjustment_number`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stock_adjustments`
--

INSERT INTO `stock_adjustments` VALUES (3,'1','2025-06-02',11,6,4,3,50,'Material is waste',1,'2025-06-02 04:47:43','2025-06-02 04:47:43');

--
-- Table structure for table `stock_transfer_details`
--

CREATE TABLE `stock_transfer_details` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint NOT NULL,
  `sku` bigint NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `l` double NOT NULL DEFAULT '0',
  `w` double NOT NULL DEFAULT '0',
  `h` double NOT NULL DEFAULT '0',
  `gst` double NOT NULL DEFAULT '0',
  `rate` double NOT NULL DEFAULT '0',
  `total_rate` decimal(10,2) NOT NULL,
  `product_sqft` double NOT NULL DEFAULT '0',
  `parent_id` bigint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stock_transfer_details`
--

INSERT INTO `stock_transfer_details` VALUES (9,2,3528,1,10,5,1,5,100,100.00,50,8,'2025-06-02 04:46:39','2025-06-02 04:46:39');

--
-- Table structure for table `stock_transfers`
--

CREATE TABLE `stock_transfers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `transfer_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_id` bigint NOT NULL DEFAULT '0',
  `from_warehouse_id` bigint unsigned NOT NULL,
  `to_warehouse_id` bigint unsigned NOT NULL,
  `from_rack_id` bigint unsigned NOT NULL,
  `to_rack_id` bigint unsigned NOT NULL,
  `from_partition_id` bigint unsigned NOT NULL,
  `to_partition_id` bigint unsigned NOT NULL,
  `total_sqft` double NOT NULL,
  `date` date NOT NULL,
  `remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `createdby` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `stock_transfers_transfer_number_unique` (`transfer_number`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stock_transfers`
--

INSERT INTO `stock_transfers` VALUES (8,'1',10,6,5,4,5,3,4,50,'2025-06-02','',1,'2025-06-02 04:46:39','2025-06-02 04:46:39');

--
-- Table structure for table `uoms`
--

CREATE TABLE `uoms` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `uoms`
--

INSERT INTO `uoms` VALUES (1,'kg','kilo gram','2025-05-08 04:41:47','2025-05-08 04:41:47'),(3,'ltr','liter','2025-05-09 04:25:36','2025-06-04 07:28:55');

--
-- Table structure for table `variations`
--

CREATE TABLE `variations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `variations`
--

INSERT INTO `variations` VALUES (2,'test',200,'2025-05-12 03:59:56','2025-05-12 03:59:56');

--
-- Table structure for table `warehouses`
--

CREATE TABLE `warehouses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_sqfts` double NOT NULL,
  `rem_sqft` double NOT NULL DEFAULT '0',
  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_person` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `monthly_rent_rate` decimal(10,2) NOT NULL,
  `per_sqft_rent_rate` decimal(10,2) NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `createdby` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `warehouses`
--

INSERT INTO `warehouses` VALUES (5,'Pune',100000,99700,'Pune','Omkar More','1234567890',1000.00,60.00,1,1,'2025-05-23 04:04:41','2025-06-02 06:06:35'),(6,'Satara',100000,99500,'satara','Mayur Vaidya','8669192829',800.00,50.00,1,1,'2025-05-23 04:05:25','2025-06-06 04:07:03');

--
-- Table structure for table `warranties`
--

CREATE TABLE `warranties` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `duration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `warranties`
--

INSERT INTO `warranties` VALUES (1,'test','test','1','Years','2025-05-12 00:51:32','2025-05-12 00:51:32'),(2,'test2','','2','Months','2025-05-12 00:51:47','2025-05-12 00:51:47');


