--
-- Host: 127.0.0.1    Database: dryclean360_db
-- ------------------------------------------------------


--
-- Table structure for table `accounts_staffprofile`
--

CREATE TABLE `accounts_staffprofile` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `role` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  `user_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`),
  KEY `accounts_staffprofile_role_d13773b4` (`role`),
  CONSTRAINT `accounts_staffprofile_user_id_1ed1af60_fk_accounts_user_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accounts_staffprofile`
--

INSERT INTO `accounts_staffprofile` VALUES (1,'admin','+919876543210',1,'2026-06-20 13:30:05.056000','2026-06-20 13:30:05.056000',1),(2,'counter_staff','+919876543211',1,'2026-06-20 13:30:05.066000','2026-06-20 13:30:05.066000',2),(3,'delivery_staff','+919876543212',1,'2026-06-20 13:30:05.073000','2026-06-20 13:30:05.073000',3);

--
-- Table structure for table `accounts_user_groups`
--

CREATE TABLE `accounts_user_groups` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `group_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `accounts_user_groups_user_id_group_id_59c0b32f_uniq` (`user_id`,`group_id`),
  KEY `accounts_user_groups_group_id_bd11a704_fk_auth_group_id` (`group_id`),
  CONSTRAINT `accounts_user_groups_group_id_bd11a704_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `accounts_user_groups_user_id_52b62117_fk_accounts_user_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accounts_user_groups`
--


--
-- Table structure for table `accounts_user_user_permissions`
--

CREATE TABLE `accounts_user_user_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `accounts_user_user_permi_user_id_permission_id_2ab516c2_uniq` (`user_id`,`permission_id`),
  KEY `accounts_user_user_p_permission_id_113bb443_fk_auth_perm` (`permission_id`),
  CONSTRAINT `accounts_user_user_p_permission_id_113bb443_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `accounts_user_user_p_user_id_e4f0a161_fk_accounts_` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accounts_user_user_permissions`
--


--
-- Table structure for table `activity_logs_activitylog`
--

CREATE TABLE `activity_logs_activitylog` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `action` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip_address` char(39) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `metadata` json NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `user_id` bigint DEFAULT NULL,
  `module_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_logs_activitylog_user_id_9ba15f3d_fk_accounts_user_id` (`user_id`),
  KEY `activity_logs_activitylog_action_4796e53b` (`action`),
  KEY `activity_logs_activitylog_created_at_fec1fcbd` (`created_at`),
  KEY `activity_logs_activitylog_module_name_4d46dafe` (`module_name`),
  CONSTRAINT `activity_logs_activitylog_user_id_9ba15f3d_fk_accounts_user_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_logs_activitylog`
--

INSERT INTO `activity_logs_activitylog` VALUES (1,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-20 13:19:06.394000',1,''),(2,'logout','admin logged out.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-20 13:34:50.722000',1,'accounts'),(3,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-20 13:34:59.307000',1,'accounts'),(4,'created','Created customer: Surya Brahma (09849555010)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-20 13:49:00.896000',1,'customers'),(5,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 04:57:20.378000',1,'accounts'),(6,'created','Created category: Toys','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 05:22:47.470000',1,'categories'),(7,'created','Created category: Carpet Cleaning','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 05:23:54.865000',1,'categories'),(8,'updated','Updated price range for Blanket: ₹300 - ₹1000','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:07:55.697000',1,'items'),(9,'updated','Updated price range for Blazer: ₹350 - ₹600','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:08:35.442000',1,'items'),(10,'updated','Updated price range for Curtain: ₹200 - ₹2000','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:08:56.700000',1,'items'),(11,'updated','Updated price range for Saree (R): ₹60 - ₹100','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:10:15.656000',1,'items'),(12,'updated','Updated price range for Saree (DW): ₹150 - ₹350','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:10:40.039000',1,'items'),(13,'created','Created item: Saree (P) (Saree Dry Cleaning)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:11:08.829000',1,'items'),(14,'updated','Updated price range for Blouse: ₹60 - ₹100','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:12:13.013000',1,'items'),(15,'updated','Updated price range for Shirt: ₹80 - ₹150','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:12:46.822000',1,'items'),(16,'created','Created item: Dress (Regular Clothes)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:13:27.269000',1,'items'),(17,'created','Created item: Top (Regular Clothes)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:13:56.125000',1,'items'),(18,'created','Created item: Bottom (Regular Clothes)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:14:14.609000',1,'items'),(19,'created','Created item: Chunnies (Regular Clothes)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:14:40.706000',1,'items'),(20,'created','Created item: Waitcoat (Regular Clothes)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:15:05.066000',1,'items'),(21,'updated','Updated item: Waistcoat (Regular Clothes)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:15:13.859000',1,'items'),(22,'created','Created item: Lehengas (Premium Garments)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:15:50.202000',1,'items'),(23,'created','Created item: Frock (Regular Clothes)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:16:07.032000',1,'items'),(24,'created','Created item: Pant (Regular Clothes)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:16:44.516000',1,'items'),(25,'created','Created item: Shervani (Premium Garments)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:17:10.707000',1,'items'),(26,'created','Created item: Jerkin (Regular Clothes)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:17:45.802000',1,'items'),(27,'created','Created item: Pancha (Regular Clothes)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:18:12.716000',1,'items'),(28,'created','Created item: Kanduva (Regular Clothes)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:18:33.667000',1,'items'),(29,'created','Created item: Toys (Toys)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:18:55.085000',1,'items'),(30,'created','Created item: Carpet (Carpet Cleaning)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 10:19:47.111000',1,'items'),(31,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 12:53:33.185000',1,'accounts'),(32,'updated','Updated customer: Surya Brahma (09849555010)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 12:54:00.531000',1,'customers'),(33,'updated','Updated customer: Surya Brahma (09849555010)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 12:54:30.098000',1,'customers'),(34,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 15:05:35.572000',1,'accounts'),(35,'updated','Customer updated: Surya Brahma (09849555010)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 1}','2026-06-21 15:05:45.132000',1,'customers'),(36,'book_order_clicked','Book order started for Surya Brahma (09849555010)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 1}','2026-06-21 15:05:50.571000',1,'orders'),(37,'book_order_clicked','Book order started for Surya Brahma (09849555010)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 1}','2026-06-21 16:48:12.157000',1,'orders'),(38,'logout','admin logged out.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 16:48:15.122000',1,'accounts'),(39,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 16:48:59.313000',1,'accounts'),(40,'created','Customer created: Susmitha Laxmi (7780313748)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 2}','2026-06-21 16:50:55.775000',1,'customers'),(41,'book_order_clicked','Book order started for Susmitha Laxmi (7780313748)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 2}','2026-06-21 16:50:57.434000',1,'orders'),(42,'updated','Customer updated: Susmitha Laxmi (7780313748)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 2}','2026-06-21 17:29:38.728000',1,'customers'),(43,'book_order_clicked','Book order started for Susmitha Laxmi (7780313748)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 2}','2026-06-21 17:29:40.749000',1,'orders'),(44,'order_item_added','Added Shirt x2 @ ₹95 to DC-2026-000001','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 17:31:11.624000',1,'orders'),(45,'order_item_added','Added Pancha x1 @ ₹150 to DC-2026-000001','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 17:31:11.629000',1,'orders'),(46,'order_created','Created order DC-2026-000001 for Susmitha Laxmi (7780313748)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 1, \"customer_id\": 2}','2026-06-21 17:31:11.638000',1,'orders'),(47,'discount_updated','Discount ₹25 on DC-2026-000001','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 17:31:11.640000',1,'orders'),(48,'logout','admin logged out.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 17:31:35.380000',1,'accounts'),(49,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 17:31:49.740000',1,'accounts'),(50,'created','Customer created: test 123 (1234567890)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 3}','2026-06-21 18:30:21.731000',1,'customers'),(51,'book_order_clicked','Book order started for test 123 (1234567890)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 3}','2026-06-21 18:30:24.967000',1,'orders'),(52,'order_item_added','Added Saree (R) x2 @ ₹85 to DC-2026-000002','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 18:31:08.663000',1,'orders'),(53,'order_item_added','Added Lehengas x2 @ ₹200 to DC-2026-000002','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 18:31:08.667000',1,'orders'),(54,'order_created','Created order DC-2026-000002 for test 123 (1234567890)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 2, \"customer_id\": 3}','2026-06-21 18:31:08.674000',1,'orders'),(55,'created','Customer created: test2 (1122334455)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 4}','2026-06-21 18:33:48.425000',1,'customers'),(56,'book_order_clicked','Book order started for test2 (1122334455)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 4}','2026-06-21 18:33:50.313000',1,'orders'),(57,'order_item_added','Added Blanket x1 @ ₹900 to DC-2026-000003','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 18:34:32.074000',1,'orders'),(58,'order_item_added','Added Jerkin x1 @ ₹450 to DC-2026-000003','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 18:34:32.076000',1,'orders'),(59,'order_created','Created order DC-2026-000003 for test2 (1122334455)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 3, \"customer_id\": 4}','2026-06-21 18:34:32.079000',1,'orders'),(60,'discount_updated','Discount ₹50 on DC-2026-000003','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 18:34:32.080000',1,'orders'),(61,'logout','admin logged out.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 19:21:41.754000',1,'accounts'),(62,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 19:21:59.759000',1,'accounts'),(63,'updated','Customer updated: test 123 (1234567891)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 3}','2026-06-21 19:22:38.263000',1,'customers'),(64,'logout','admin logged out.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 19:32:51.248000',1,'accounts'),(65,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 19:33:02.268000',1,'accounts'),(66,'created','Customer created: test3 (1236789076)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 5}','2026-06-21 19:33:55.312000',1,'customers'),(67,'updated','Customer updated: test2 (1122334455)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 4}','2026-06-21 19:34:19.814000',1,'customers'),(68,'updated','Customer updated: test2 (1122334455)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 4}','2026-06-21 19:34:34.509000',1,'customers'),(69,'logout','admin logged out.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 19:46:02.806000',1,'accounts'),(70,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 19:46:14.600000',1,'accounts'),(71,'logout','admin logged out.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 19:48:05.479000',1,'accounts'),(72,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 19:52:04.828000',1,'accounts'),(73,'order_item_removed','Removed 2 item(s) from order DC-2026-000002','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 19:54:09.403000',1,'orders'),(74,'order_item_added','Added Saree (R) x2 @ ₹85.00 to DC-2026-000002','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 19:54:09.407000',1,'orders'),(75,'order_item_added','Added Lehengas x2 @ ₹200.00 to DC-2026-000002','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 19:54:09.409000',1,'orders'),(76,'order_updated','Updated order DC-2026-000002','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 2}','2026-06-21 19:54:09.414000',1,'orders'),(77,'discount_updated','Discount updated to ₹30 on DC-2026-000002','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-21 19:54:09.415000',1,'orders'),(78,'payment_updated','Payment updated on DC-2026-000002',NULL,'','{\"order_id\": 2}','2026-06-21 19:54:09.416000',1,'orders'),(79,'book_order_clicked','Book order started for test3 (1236789076)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 5}','2026-06-22 06:34:16.817000',1,'orders'),(80,'logout','admin logged out.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-22 06:42:06.800000',1,'accounts'),(81,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-22 07:28:57.747000',1,'accounts'),(82,'report_viewed','Viewed Orders report','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-06-22 07:29:28.274000',1,'reports'),(83,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-02 14:50:56.061119',1,'accounts'),(84,'created','Customer created: test4 (9876543217)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 6}','2026-07-02 14:51:24.023333',1,'customers'),(85,'book_order_clicked','Book order started for test4 (9876543217)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"customer_id\": 6}','2026-07-02 14:53:01.416138',1,'orders'),(86,'order_item_added','Added Lehengas x1 @ ₹175 to DC-2026-000004','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-02 16:57:31.321651',1,'orders'),(87,'order_created','Created order DC-2026-000004 for test4 (9876543217)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 4, \"customer_id\": 6}','2026-07-02 16:57:31.340906',1,'orders'),(88,'order_item_removed','Removed 1 item(s) from order DC-2026-000004','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-02 16:58:12.533393',1,'orders'),(89,'order_item_added','Added Lehengas x1 @ ₹175.00 to DC-2026-000004','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-02 16:58:12.537805',1,'orders'),(90,'order_updated','Updated order DC-2026-000004','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 4}','2026-07-02 16:58:12.545734',1,'orders'),(91,'discount_updated','Discount updated to ₹50 on DC-2026-000004','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-02 16:58:12.547704',1,'orders'),(92,'payment_updated','Payment updated on DC-2026-000004',NULL,'','{\"order_id\": 4}','2026-07-02 16:58:12.549734',1,'orders'),(93,'payment_created','Payment PAY-2026-000001 ₹125 for order DC-2026-000004','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 4, \"payment_id\": 1}','2026-07-02 17:00:27.072543',1,'payments'),(94,'payment_updated','Order DC-2026-000004 payment updated','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 4}','2026-07-02 17:00:27.077351',1,'orders'),(95,'bill_generated','Generated invoice BILL-2026-000001 for DC-2026-000004 (reportlab)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"bill_id\": 1, \"order_id\": 4}','2026-07-02 17:00:33.529395',1,'billing'),(96,'invoice_previewed','Previewed invoice BILL-2026-000001','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-02 17:00:41.414438',1,'billing'),(97,'invoice_downloaded','Downloaded invoice BILL-2026-000001','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-02 17:00:53.277961',1,'billing'),(98,'report_viewed','Viewed Orders report','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-02 17:01:04.475394',1,'reports'),(99,'report_viewed','Viewed Orders report','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-02 17:01:23.835051',1,'reports'),(100,'report_viewed','Viewed Orders report','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-02 17:01:27.445629',1,'reports'),(101,'order_item_removed','Removed 2 item(s) from order DC-2026-000003','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-02 17:02:24.193007',1,'orders'),(102,'order_item_added','Added Blanket x1 @ ₹900.00 to DC-2026-000003','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-02 17:02:24.205652',1,'orders'),(103,'order_item_added','Added Jerkin x1 @ ₹450.00 to DC-2026-000003','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-02 17:02:24.209593',1,'orders'),(104,'order_updated','Updated order DC-2026-000003','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 3}','2026-07-02 17:02:24.229276',1,'orders'),(105,'status_changed','Order DC-2026-000003 status: received → delivered','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 3}','2026-07-02 17:02:24.236758',1,'orders'),(106,'payment_updated','Payment updated on DC-2026-000003',NULL,'','{\"order_id\": 3}','2026-07-02 17:02:24.239413',1,'orders'),(107,'order_item_removed','Removed 1 item(s) from order DC-2026-000004','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-02 17:02:37.552984',1,'orders'),(108,'order_item_added','Added Lehengas x1 @ ₹175.00 to DC-2026-000004','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-02 17:02:37.555398',1,'orders'),(109,'order_updated','Updated order DC-2026-000004','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 4}','2026-07-02 17:02:37.561592',1,'orders'),(110,'status_changed','Order DC-2026-000004 status: received → delivered','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 4}','2026-07-02 17:02:37.563067',1,'orders'),(111,'payment_updated','Payment updated on DC-2026-000004',NULL,'','{\"order_id\": 4}','2026-07-02 17:02:37.564456',1,'orders'),(112,'payment_created','Payment PAY-2026-000002 ₹1300 for order DC-2026-000003','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 3, \"payment_id\": 2}','2026-07-02 17:03:21.711457',1,'payments'),(113,'payment_updated','Order DC-2026-000003 payment updated','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 3}','2026-07-02 17:03:21.717094',1,'orders'),(114,'bill_generated','Generated invoice BILL-2026-000002 for DC-2026-000003 (reportlab)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"bill_id\": 2, \"order_id\": 3}','2026-07-02 17:03:26.586499',1,'billing'),(115,'logout','admin logged out.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-03 03:03:10.378244',1,'accounts'),(116,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-03 03:03:18.641016',1,'accounts'),(117,'updated','Updated shop profile for invoices and branding.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-03 04:13:43.999930',1,'shop_settings'),(118,'invoice_previewed','Previewed invoice BILL-2026-000001','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-03 04:13:52.686840',1,'billing'),(119,'order_item_removed','Removed 2 item(s) from order DC-2026-000002','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-03 04:14:27.979221',1,'orders'),(120,'order_item_added','Added Saree (R) x2 @ ₹85.00 to DC-2026-000002','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-03 04:14:27.983731',1,'orders'),(121,'order_item_added','Added Lehengas x2 @ ₹200.00 to DC-2026-000002','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-03 04:14:27.987710',1,'orders'),(122,'order_updated','Updated order DC-2026-000002','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 2}','2026-07-03 04:14:27.995791',1,'orders'),(123,'status_changed','Order DC-2026-000002 status: received → delivered','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 2}','2026-07-03 04:14:27.998505',1,'orders'),(124,'payment_updated','Payment updated on DC-2026-000002',NULL,'','{\"order_id\": 2}','2026-07-03 04:14:28.000582',1,'orders'),(125,'payment_created','Payment PAY-2026-000003 ₹540 for order DC-2026-000002','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 2, \"payment_id\": 3}','2026-07-03 04:14:46.874675',1,'payments'),(126,'payment_updated','Order DC-2026-000002 payment updated','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"order_id\": 2}','2026-07-03 04:14:46.884242',1,'orders'),(127,'bill_generated','Generated invoice BILL-2026-000003 for DC-2026-000002 (reportlab)','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{\"bill_id\": 3, \"order_id\": 2}','2026-07-03 04:14:53.737929',1,'billing'),(128,'invoice_downloaded','Downloaded invoice BILL-2026-000003','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-03 04:15:00.246387',1,'billing'),(129,'invoice_previewed','Previewed invoice BILL-2026-000003','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-03 04:15:01.946879',1,'billing'),(130,'logout','admin logged out.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','{}','2026-07-03 04:15:18.342314',1,'accounts'),(131,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','[]','2026-07-03 21:08:12.000000',1,'accounts'),(132,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','[]','2026-07-03 21:27:00.000000',1,'accounts'),(133,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','[]','2026-07-04 07:19:06.000000',1,'accounts'),(134,'login','admin logged in successfully.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','[]','2026-07-04 11:06:57.000000',1,'accounts'),(135,'logout','admin logged out.','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','[]','2026-07-04 11:24:10.000000',1,'accounts');

--
-- Table structure for table `auth_group`
--

CREATE TABLE `auth_group` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `auth_group`
--


--
-- Table structure for table `auth_group_permissions`
--

CREATE TABLE `auth_group_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` int NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `auth_group_permissions`
--


--
-- Table structure for table `auth_permission`
--

CREATE TABLE `auth_permission` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_type_id` int NOT NULL,
  `codename` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
  CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `auth_permission`
--

INSERT INTO `auth_permission` VALUES (1,'Can add log entry',1,'add_logentry'),(2,'Can change log entry',1,'change_logentry'),(3,'Can delete log entry',1,'delete_logentry'),(4,'Can view log entry',1,'view_logentry'),(5,'Can add permission',2,'add_permission'),(6,'Can change permission',2,'change_permission'),(7,'Can delete permission',2,'delete_permission'),(8,'Can view permission',2,'view_permission'),(9,'Can add group',3,'add_group'),(10,'Can change group',3,'change_group'),(11,'Can delete group',3,'delete_group'),(12,'Can view group',3,'view_group'),(13,'Can add content type',4,'add_contenttype'),(14,'Can change content type',4,'change_contenttype'),(15,'Can delete content type',4,'delete_contenttype'),(16,'Can view content type',4,'view_contenttype'),(17,'Can add session',5,'add_session'),(18,'Can change session',5,'change_session'),(19,'Can delete session',5,'delete_session'),(20,'Can view session',5,'view_session'),(21,'Can add Staff User',6,'add_user'),(22,'Can change Staff User',6,'change_user'),(23,'Can delete Staff User',6,'delete_user'),(24,'Can view Staff User',6,'view_user'),(25,'Can add Staff Profile',7,'add_staffprofile'),(26,'Can change Staff Profile',7,'change_staffprofile'),(27,'Can delete Staff Profile',7,'delete_staffprofile'),(28,'Can view Staff Profile',7,'view_staffprofile'),(29,'Can add Customer',8,'add_customer'),(30,'Can change Customer',8,'change_customer'),(31,'Can delete Customer',8,'delete_customer'),(32,'Can view Customer',8,'view_customer'),(33,'Can add Category',9,'add_category'),(34,'Can change Category',9,'change_category'),(35,'Can delete Category',9,'delete_category'),(36,'Can view Category',9,'view_category'),(37,'Can add Item',10,'add_item'),(38,'Can change Item',10,'change_item'),(39,'Can delete Item',10,'delete_item'),(40,'Can view Item',10,'view_item'),(41,'Can add Order',11,'add_order'),(42,'Can change Order',11,'change_order'),(43,'Can delete Order',11,'delete_order'),(44,'Can view Order',11,'view_order'),(45,'Can add Order Item',12,'add_orderitem'),(46,'Can change Order Item',12,'change_orderitem'),(47,'Can delete Order Item',12,'delete_orderitem'),(48,'Can view Order Item',12,'view_orderitem'),(49,'Can add Order Photo',13,'add_orderphoto'),(50,'Can change Order Photo',13,'change_orderphoto'),(51,'Can delete Order Photo',13,'delete_orderphoto'),(52,'Can view Order Photo',13,'view_orderphoto'),(53,'Can add Payment',14,'add_payment'),(54,'Can change Payment',14,'change_payment'),(55,'Can delete Payment',14,'delete_payment'),(56,'Can view Payment',14,'view_payment'),(57,'Can add Bill / Invoice',15,'add_bill'),(58,'Can change Bill / Invoice',15,'change_bill'),(59,'Can delete Bill / Invoice',15,'delete_bill'),(60,'Can view Bill / Invoice',15,'view_bill'),(61,'Can add AI Damage Report',16,'add_aidamagereport'),(62,'Can change AI Damage Report',16,'change_aidamagereport'),(63,'Can delete AI Damage Report',16,'delete_aidamagereport'),(64,'Can view AI Damage Report',16,'view_aidamagereport'),(65,'Can add Activity Log',17,'add_activitylog'),(66,'Can change Activity Log',17,'change_activitylog'),(67,'Can delete Activity Log',17,'delete_activitylog'),(68,'Can view Activity Log',17,'view_activitylog'),(69,'Can add Shop Profile',18,'add_shopprofile'),(70,'Can change Shop Profile',18,'change_shopprofile'),(71,'Can delete Shop Profile',18,'delete_shopprofile'),(72,'Can view Shop Profile',18,'view_shopprofile');

--
-- Table structure for table `billing_bill`
--

CREATE TABLE `billing_bill` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `bill_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `invoice_pdf` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `generated_at` datetime(6) NOT NULL,
  `sent_on_whatsapp` tinyint(1) NOT NULL,
  `whatsapp_sent_at` datetime(6) DEFAULT NULL,
  `active` tinyint(1) NOT NULL,
  `generated_by_id` bigint DEFAULT NULL,
  `order_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `bill_number` (`bill_number`),
  KEY `billing_bill_generated_by_id_4a9a3358_fk_accounts_user_id` (`generated_by_id`),
  KEY `billing_bill_order_id_46555792_fk_orders_order_id` (`order_id`),
  KEY `billing_bill_active_8f6aed15` (`active`),
  CONSTRAINT `billing_bill_generated_by_id_4a9a3358_fk_accounts_user_id` FOREIGN KEY (`generated_by_id`) REFERENCES `accounts_user` (`id`),
  CONSTRAINT `billing_bill_order_id_46555792_fk_orders_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders_order` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `billing_bill`
--

INSERT INTO `billing_bill` VALUES (1,'BILL-2026-000001','invoices/DC-2026-000004/BILL-2026-000001.pdf','2026-07-02 17:00:33.520979',0,NULL,1,1,4),(2,'BILL-2026-000002','invoices/DC-2026-000003/BILL-2026-000002.pdf','2026-07-02 17:03:26.575933',0,NULL,1,1,3),(3,'BILL-2026-000003','invoices/DC-2026-000002/BILL-2026-000003.pdf','2026-07-03 04:14:53.729077',0,NULL,1,1,2),(4,'BILL-2026-000004','invoices/DC-2026-000005/BILL-2026-000004.pdf','2026-07-04 07:20:04.000000',0,NULL,1,1,5);

--
-- Table structure for table `categories_category`
--

CREATE TABLE `categories_category` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  `created_by_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `categories_category_created_by_id_e073107e_fk_accounts_user_id` (`created_by_id`),
  KEY `categories_category_active_2955e477` (`active`),
  CONSTRAINT `categories_category_created_by_id_e073107e_fk_accounts_user_id` FOREIGN KEY (`created_by_id`) REFERENCES `accounts_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories_category`
--

INSERT INTO `categories_category` VALUES (1,'Saree Dry Cleaning','Dry cleaning services for sarees',1,'2026-06-20 13:30:06.842000','2026-06-20 13:30:06.842000',NULL),(2,'Rolling','Rolling and pressing services',1,'2026-06-20 13:30:06.853000','2026-06-20 13:30:06.853000',NULL),(3,'Polish','Polish and finishing services',1,'2026-06-20 13:30:06.863000','2026-06-20 13:30:06.863000',NULL),(4,'Suit Cleaning','Professional suit dry cleaning',1,'2026-06-20 13:30:06.872000','2026-06-20 13:30:06.872000',NULL),(5,'Blanket Cleaning','Blanket and heavy linen cleaning',1,'2026-06-20 13:30:06.881000','2026-06-20 13:30:06.881000',NULL),(6,'Curtain Cleaning','Curtain and drape cleaning',1,'2026-06-20 13:30:06.889000','2026-06-20 13:30:06.889000',NULL),(7,'Blazer Cleaning','Blazer and jacket cleaning',1,'2026-06-20 13:30:06.899000','2026-06-20 13:30:06.899000',NULL),(8,'Regular Clothes','Everyday garment cleaning',1,'2026-06-20 13:30:06.908000','2026-06-20 13:30:06.908000',NULL),(9,'Premium Garments','Premium and delicate garment care',1,'2026-06-20 13:30:06.916000','2026-06-20 13:30:06.916000',NULL),(10,'Toys','Small and big toys',1,'2026-06-21 05:22:47.456000','2026-06-21 05:22:47.457000',1),(11,'Carpet Cleaning','Deep clean carpet cleaning',1,'2026-06-21 05:23:54.849000','2026-06-21 05:23:54.849000',1);

--
-- Table structure for table `customers_customer`
--

CREATE TABLE `customers_customer` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `whatsapp_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `alternate_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mobile_number` (`mobile_number`),
  KEY `customers_customer_created_by_id_e3e9e010_fk_accounts_user_id` (`created_by_id`),
  KEY `customers_customer_active_f846960a` (`active`),
  CONSTRAINT `customers_customer_created_by_id_e3e9e010_fk_accounts_user_id` FOREIGN KEY (`created_by_id`) REFERENCES `accounts_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customers_customer`
--

INSERT INTO `customers_customer` VALUES (1,'Surya Brahma','09849555010','09849555010','S R NIVAS MIG II, 843, Kphb Colony 3rd Phase\r\nGA','Good customer kphb',1,'2026-06-20 13:49:00.883000','2026-06-21 15:05:45.095000',1,'7780313748'),(2,'Susmitha Laxmi','7780313748','7780313748','hyd','',1,'2026-06-21 16:50:55.760000','2026-06-21 17:29:38.706000',1,'9849555010'),(3,'test 123','1234567891','1234567890','home','',1,'2026-06-21 18:30:21.713000','2026-06-21 19:22:38.235000',1,'2223334445'),(4,'test2','1122334455','1122334455','home1','',1,'2026-06-21 18:33:48.416000','2026-06-21 19:34:34.482000',1,'0987654321'),(5,'test3','1236789076','1236789078','','',1,'2026-06-21 19:33:55.292000','2026-06-21 19:33:55.292000',1,'2222222222'),(6,'test4','9876543217','9876543217','test','',1,'2026-07-02 14:51:24.011743','2026-07-02 14:51:24.011796',1,'5656565656'),(7,'testing 5 hi','3456789086','3456789086','test address','',1,'2026-07-03 21:10:30.000000','2026-07-03 21:10:30.000000',1,'2349598600');

--
-- Table structure for table `damage_detection_aidamagereport`
--

CREATE TABLE `damage_detection_aidamagereport` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `similarity_score` decimal(5,2) DEFAULT NULL,
  `confidence_score` decimal(5,2) DEFAULT NULL,
  `status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ai_observations` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `difference_image` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime(6) NOT NULL,
  `after_photo_id` bigint DEFAULT NULL,
  `before_photo_id` bigint DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `order_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `damage_detection_aid_after_photo_id_2b2e662d_fk_orders_or` (`after_photo_id`),
  KEY `damage_detection_aid_before_photo_id_e40264f9_fk_orders_or` (`before_photo_id`),
  KEY `damage_detection_aid_created_by_id_9f86fa2d_fk_accounts_` (`created_by_id`),
  KEY `damage_detection_aid_order_id_0eb5be40_fk_orders_or` (`order_id`),
  CONSTRAINT `damage_detection_aid_after_photo_id_2b2e662d_fk_orders_or` FOREIGN KEY (`after_photo_id`) REFERENCES `orders_orderphoto` (`id`),
  CONSTRAINT `damage_detection_aid_before_photo_id_e40264f9_fk_orders_or` FOREIGN KEY (`before_photo_id`) REFERENCES `orders_orderphoto` (`id`),
  CONSTRAINT `damage_detection_aid_created_by_id_9f86fa2d_fk_accounts_` FOREIGN KEY (`created_by_id`) REFERENCES `accounts_user` (`id`),
  CONSTRAINT `damage_detection_aid_order_id_0eb5be40_fk_orders_or` FOREIGN KEY (`order_id`) REFERENCES `orders_order` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `damage_detection_aidamagereport`
--


--
-- Table structure for table `django_admin_log`
--

CREATE TABLE `django_admin_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext COLLATE utf8mb4_unicode_ci,
  `object_repr` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action_flag` smallint unsigned NOT NULL,
  `change_message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_type_id` int DEFAULT NULL,
  `user_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
  KEY `django_admin_log_user_id_c564eba6_fk_accounts_user_id` (`user_id`),
  CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
  CONSTRAINT `django_admin_log_user_id_c564eba6_fk_accounts_user_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`),
  CONSTRAINT `django_admin_log_chk_1` CHECK ((`action_flag` >= 0))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `django_admin_log`
--


--
-- Table structure for table `django_content_type`
--

CREATE TABLE `django_content_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `django_content_type`
--

INSERT INTO `django_content_type` VALUES (7,'accounts','staffprofile'),(6,'accounts','user'),(17,'activity_logs','activitylog'),(1,'admin','logentry'),(3,'auth','group'),(2,'auth','permission'),(15,'billing','bill'),(9,'categories','category'),(4,'contenttypes','contenttype'),(8,'customers','customer'),(16,'damage_detection','aidamagereport'),(10,'inventory','item'),(11,'orders','order'),(12,'orders','orderitem'),(13,'orders','orderphoto'),(14,'payments','payment'),(5,'sessions','session'),(18,'shop_settings','shopprofile');

--
-- Table structure for table `django_migrations`
--

CREATE TABLE `django_migrations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `app` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `django_migrations`
--

INSERT INTO `django_migrations` VALUES (1,'contenttypes','0001_initial','2026-07-02 14:44:01.596461'),(2,'contenttypes','0002_remove_content_type_name','2026-07-02 14:44:01.736686'),(3,'auth','0001_initial','2026-07-02 14:44:02.252012'),(4,'auth','0002_alter_permission_name_max_length','2026-07-02 14:44:02.352289'),(5,'auth','0003_alter_user_email_max_length','2026-07-02 14:44:02.361229'),(6,'auth','0004_alter_user_username_opts','2026-07-02 14:44:02.369450'),(7,'auth','0005_alter_user_last_login_null','2026-07-02 14:44:02.378180'),(8,'auth','0006_require_contenttypes_0002','2026-07-02 14:44:02.383789'),(9,'auth','0007_alter_validators_add_error_messages','2026-07-02 14:44:02.394144'),(10,'auth','0008_alter_user_username_max_length','2026-07-02 14:44:02.402667'),(11,'auth','0009_alter_user_last_name_max_length','2026-07-02 14:44:02.412260'),(12,'auth','0010_alter_group_name_max_length','2026-07-02 14:44:02.435078'),(13,'auth','0011_update_proxy_permissions','2026-07-02 14:44:02.444906'),(14,'auth','0012_alter_user_first_name_max_length','2026-07-02 14:44:02.452935'),(15,'accounts','0001_initial','2026-07-02 14:44:03.235165'),(16,'accounts','0002_staffprofile','2026-07-02 14:44:03.410587'),(17,'activity_logs','0001_initial','2026-07-02 14:44:03.583780'),(18,'activity_logs','0002_activitylog_module_name_alter_activitylog_action','2026-07-02 14:44:03.786908'),(19,'activity_logs','0003_alter_activitylog_action','2026-07-02 14:44:03.796336'),(20,'activity_logs','0004_add_book_order_clicked','2026-07-02 14:44:03.806278'),(21,'activity_logs','0005_alter_activitylog_action','2026-07-02 14:44:03.818634'),(22,'activity_logs','0006_add_ai_damage_actions','2026-07-02 14:44:03.828851'),(23,'admin','0001_initial','2026-07-02 14:44:04.049898'),(24,'admin','0002_logentry_remove_auto_add','2026-07-02 14:44:04.061369'),(25,'admin','0003_logentry_add_action_flag_choices','2026-07-02 14:44:04.071661'),(26,'categories','0001_initial','2026-07-02 14:44:04.236128'),(27,'inventory','0001_initial','2026-07-02 14:44:04.487236'),(28,'inventory','0002_item_price_range','2026-07-02 14:44:04.792058'),(29,'customers','0001_initial','2026-07-02 14:44:04.974853'),(30,'customers','0002_customer_alternate_number','2026-07-02 14:44:05.081472'),(31,'orders','0001_initial','2026-07-02 14:44:05.819253'),(32,'orders','0002_add_order_date','2026-07-02 14:44:06.008650'),(33,'orders','0003_order_payment_status_order_total_paid','2026-07-02 14:44:06.269851'),(34,'billing','0001_initial','2026-07-02 14:44:06.522368'),(35,'damage_detection','0001_initial','2026-07-02 14:44:06.554535'),(36,'damage_detection','0002_initial','2026-07-02 14:44:06.990863'),(37,'payments','0001_initial','2026-07-02 14:44:07.332878'),(38,'sessions','0001_initial','2026-07-02 14:44:07.390304'),(39,'shop_settings','0001_initial','2026-07-03 02:54:08.255450');

--
-- Table structure for table `inventory_item`
--

CREATE TABLE `inventory_item` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `item_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `service_type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  `category_id` bigint NOT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `min_price` decimal(10,2) NOT NULL,
  `max_price` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_item_category_service` (`item_name`,`category_id`,`service_type`),
  KEY `inventory_item_category_id_44f2108d_fk_categories_category_id` (`category_id`),
  KEY `inventory_item_created_by_id_e23f29c1_fk_accounts_user_id` (`created_by_id`),
  KEY `inventory_item_active_105b3414` (`active`),
  CONSTRAINT `inventory_item_category_id_44f2108d_fk_categories_category_id` FOREIGN KEY (`category_id`) REFERENCES `categories_category` (`id`),
  CONSTRAINT `inventory_item_created_by_id_e23f29c1_fk_accounts_user_id` FOREIGN KEY (`created_by_id`) REFERENCES `accounts_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inventory_item`
--

INSERT INTO `inventory_item` VALUES (1,'Shirt','dry_cleaning',1,'2026-06-20 13:30:08.722000','2026-06-21 10:12:46.808000',8,NULL,80.00,150.00),(2,'Saree (DW)','dry_cleaning',1,'2026-06-20 13:30:08.734000','2026-06-21 10:10:40.024000',1,NULL,150.00,350.00),(3,'Saree (R)','rolling',1,'2026-06-20 13:30:08.742000','2026-06-21 10:10:15.635000',2,NULL,60.00,100.00),(4,'Blanket','dry_cleaning',1,'2026-06-20 13:30:08.751000','2026-06-21 10:07:55.682000',5,NULL,300.00,1000.00),(5,'Blouse','dry_cleaning',1,'2026-06-20 13:30:08.760000','2026-06-21 10:12:12.994000',1,NULL,60.00,100.00),(6,'Blazer','dry_cleaning',1,'2026-06-20 13:30:08.769000','2026-06-21 10:08:35.427000',7,NULL,350.00,600.00),(7,'Curtain','dry_cleaning',1,'2026-06-20 13:30:08.779000','2026-06-21 10:08:56.686000',6,NULL,200.00,2000.00),(8,'Saree (P)','dry_cleaning',1,'2026-06-21 10:11:08.814000','2026-06-21 10:11:08.814000',1,1,80.00,100.00),(9,'Dress','dry_cleaning',1,'2026-06-21 10:13:27.257000','2026-06-21 10:13:27.257000',8,1,350.00,500.00),(10,'Top','dry_cleaning',1,'2026-06-21 10:13:56.114000','2026-06-21 10:13:56.114000',8,1,150.00,350.00),(11,'Bottom','dry_cleaning',1,'2026-06-21 10:14:14.594000','2026-06-21 10:14:14.594000',8,1,90.00,150.00),(12,'Chunnies','dry_cleaning',1,'2026-06-21 10:14:40.691000','2026-06-21 10:14:40.691000',8,1,80.00,150.00),(13,'Waistcoat','dry_cleaning',1,'2026-06-21 10:15:05.052000','2026-06-21 10:15:13.840000',8,1,120.00,200.00),(14,'Lehengas','dry_cleaning',1,'2026-06-21 10:15:50.186000','2026-06-21 10:15:50.186000',9,1,150.00,500.00),(15,'Frock','dry_cleaning',1,'2026-06-21 10:16:07.021000','2026-06-21 10:16:07.021000',8,1,150.00,500.00),(16,'Pant','dry_cleaning',1,'2026-06-21 10:16:44.503000','2026-06-21 10:16:44.503000',8,1,80.00,150.00),(17,'Shervani','dry_cleaning',1,'2026-06-21 10:17:10.695000','2026-06-21 10:17:10.695000',9,1,400.00,1000.00),(18,'Jerkin','dry_cleaning',1,'2026-06-21 10:17:45.787000','2026-06-21 10:17:45.787000',8,1,150.00,500.00),(19,'Pancha','dry_cleaning',1,'2026-06-21 10:18:12.702000','2026-06-21 10:18:12.702000',8,1,100.00,200.00),(20,'Kanduva','dry_cleaning',1,'2026-06-21 10:18:33.655000','2026-06-21 10:18:33.655000',8,1,80.00,150.00),(21,'Toys','washing',1,'2026-06-21 10:18:55.073000','2026-06-21 10:18:55.073000',10,1,100.00,1000.00),(22,'Carpet','dry_cleaning',1,'2026-06-21 10:19:47.097000','2026-06-21 10:19:47.097000',11,1,400.00,2000.00);

--
-- Table structure for table `orders_order`
--

CREATE TABLE `orders_order` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `order_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expected_delivery_date` date NOT NULL,
  `subtotal` decimal(12,2) NOT NULL,
  `discount_amount` decimal(12,2) NOT NULL,
  `grand_total` decimal(12,2) NOT NULL,
  `advance_paid` decimal(12,2) NOT NULL,
  `balance_amount` decimal(12,2) NOT NULL,
  `payment_mode` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remarks` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `customer_id` bigint NOT NULL,
  `order_date` date NOT NULL,
  `payment_status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_paid` decimal(12,2) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_number` (`order_number`),
  KEY `orders_order_created_by_id_d5f5e69c_fk_accounts_user_id` (`created_by_id`),
  KEY `orders_order_customer_id_0b76f6a4_fk_customers_customer_id` (`customer_id`),
  KEY `orders_order_status_445594e5` (`status`),
  KEY `orders_order_order_date_0416df95` (`order_date`),
  KEY `orders_order_payment_status_d9b0ddfc` (`payment_status`),
  CONSTRAINT `orders_order_created_by_id_d5f5e69c_fk_accounts_user_id` FOREIGN KEY (`created_by_id`) REFERENCES `accounts_user` (`id`),
  CONSTRAINT `orders_order_customer_id_0b76f6a4_fk_customers_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers_customer` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders_order`
--

INSERT INTO `orders_order` VALUES (1,'DC-2026-000001','received','2026-06-27',340.00,25.00,315.00,0.00,315.00,'pending','','2026-06-21 17:31:11.609000','2026-06-21 17:31:11.635000',1,2,'2026-06-21','pending',0.00),(2,'DC-2026-000002','delivered','2026-07-03',570.00,30.00,540.00,540.00,0.00,'upi','','2026-06-21 18:31:08.653000','2026-07-03 04:14:46.865562',1,3,'2026-06-22','paid',540.00),(3,'DC-2026-000003','delivered','2026-07-01',1350.00,50.00,1300.00,1300.00,0.00,'upi','','2026-06-21 18:34:32.066000','2026-07-02 17:03:21.704220',1,4,'2026-06-22','paid',1300.00),(4,'DC-2026-000004','delivered','2026-07-10',175.00,50.00,125.00,125.00,0.00,'cash','','2026-07-02 16:57:31.317555','2026-07-02 17:02:37.559371',1,6,'2026-07-02','paid',125.00),(5,'DC-2026-000005','delivered','2026-07-08',700.00,50.00,650.00,650.00,0.00,'cash','','2026-07-03 21:11:30.000000','2026-07-03 21:14:00.000000',1,7,'2026-07-03','paid',650.00);

--
-- Table structure for table `orders_orderitem`
--

CREATE TABLE `orders_orderitem` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `quantity` int unsigned NOT NULL,
  `manual_price` decimal(10,2) NOT NULL,
  `line_total` decimal(12,2) NOT NULL,
  `price_override_confirmed` tinyint(1) NOT NULL,
  `item_id` bigint NOT NULL,
  `order_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `orders_orderitem_item_id_0f65da43_fk_inventory_item_id` (`item_id`),
  KEY `orders_orderitem_order_id_fe61a34d_fk_orders_order_id` (`order_id`),
  CONSTRAINT `orders_orderitem_item_id_0f65da43_fk_inventory_item_id` FOREIGN KEY (`item_id`) REFERENCES `inventory_item` (`id`),
  CONSTRAINT `orders_orderitem_order_id_fe61a34d_fk_orders_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders_order` (`id`),
  CONSTRAINT `orders_orderitem_chk_1` CHECK ((`quantity` >= 0))
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders_orderitem`
--

INSERT INTO `orders_orderitem` VALUES (1,2,95.00,190.00,1,1,1),(2,1,150.00,150.00,1,19,1),(11,1,900.00,900.00,1,4,3),(12,1,450.00,450.00,1,18,3),(13,1,175.00,175.00,1,14,4),(14,2,85.00,170.00,1,3,2),(15,2,200.00,400.00,1,14,2),(20,1,500.00,500.00,1,6,5),(21,1,200.00,200.00,1,19,5);

--
-- Table structure for table `orders_orderphoto`
--

CREATE TABLE `orders_orderphoto` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `photo` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `stage` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `uploaded_at` datetime(6) NOT NULL,
  `order_id` bigint NOT NULL,
  `uploaded_by_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `orders_orderphoto_order_id_3540390e_fk_orders_order_id` (`order_id`),
  KEY `orders_orderphoto_uploaded_by_id_42362bd2_fk_accounts_user_id` (`uploaded_by_id`),
  CONSTRAINT `orders_orderphoto_order_id_3540390e_fk_orders_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders_order` (`id`),
  CONSTRAINT `orders_orderphoto_uploaded_by_id_42362bd2_fk_accounts_user_id` FOREIGN KEY (`uploaded_by_id`) REFERENCES `accounts_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders_orderphoto`
--


--
-- Table structure for table `payments_payment`
--

CREATE TABLE `payments_payment` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `payment_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount_paid` decimal(12,2) NOT NULL,
  `payment_mode` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_reference` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_date` date NOT NULL,
  `notes` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `overpayment_confirmed` tinyint(1) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  `order_id` bigint NOT NULL,
  `received_by_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payment_number` (`payment_number`),
  KEY `payments_payment_order_id_22c479b7_fk_orders_order_id` (`order_id`),
  KEY `payments_payment_received_by_id_39c5a844_fk_accounts_user_id` (`received_by_id`),
  KEY `payments_payment_payment_date_9d82b355` (`payment_date`),
  KEY `payments_payment_active_26ac8949` (`active`),
  CONSTRAINT `payments_payment_order_id_22c479b7_fk_orders_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders_order` (`id`),
  CONSTRAINT `payments_payment_received_by_id_39c5a844_fk_accounts_user_id` FOREIGN KEY (`received_by_id`) REFERENCES `accounts_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payments_payment`
--

INSERT INTO `payments_payment` VALUES (1,'PAY-2026-000001',125.00,'cash','paid','1242374687','2026-07-02','',1,1,'2026-07-02 17:00:27.055985','2026-07-02 17:00:27.056018',4,1),(2,'PAY-2026-000002',1300.00,'upi','paid','5476548675','2026-07-02','done',1,1,'2026-07-02 17:03:21.684616','2026-07-02 17:03:21.684647',3,1),(3,'PAY-2026-000003',540.00,'upi','paid','7856535434','2026-07-03','',0,1,'2026-07-03 04:14:46.846797','2026-07-03 04:14:46.846850',2,1),(4,'PAY-2026-000004',650.00,'cash','paid','4575645gf4','2026-07-03','Advance at order creation',0,1,'2026-07-03 21:11:30.000000','2026-07-03 21:13:23.000000',5,1);

--
-- Table structure for table `shop_settings_shopprofile`
--

CREATE TABLE `shop_settings_shopprofile` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `shop_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alternate_phone` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gst_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `invoice_terms` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shop_settings_shopprofile`
--

INSERT INTO `shop_settings_shopprofile` VALUES (1,'National Dry Cleaners','Mr. Riyaz','+91-9391119840','+91-9391119840','brahmasurya.v@gmail.com','S No 925, Opp Venkateshwara Temple Bus Stop, KPHB Colony, Kukatapally, Hyderabad, 500072','Hyderabad','','','2026-07-04 11:07:12.000000');

--
-- Dumping events for database 'dryclean360_db'
--

--
-- Dumping routines for database 'dryclean360_db'
--


