-- DryClean360 database backup -- Generated at 2026-07-17 12:17:30 -- Database: dryclean360_db SET FOREIGN_KEY_CHECKS=0; -- Table structure for table `accounts_staffprofile` DROP TABLE IF EXISTS `accounts_staffprofile`; CREATE TABLE `accounts_staffprofile` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `role` varchar(20) NOT NULL, `phone_number` varchar(15) NOT NULL, `active` tinyint(1) NOT NULL, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, `user_id` bigint(20) 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` (`id`, `role`, `phone_number`, `active`, `created_at`, `updated_at`, `user_id`) VALUES ('1', 'admin', '+919876543210', '1', '2026-06-20 13:30:05.056000', '2026-06-20 13:30:05.056000', '1'); INSERT INTO `accounts_staffprofile` (`id`, `role`, `phone_number`, `active`, `created_at`, `updated_at`, `user_id`) VALUES ('2', 'counter_staff', '+919876543211', '1', '2026-06-20 13:30:05.066000', '2026-06-20 13:30:05.066000', '2'); INSERT INTO `accounts_staffprofile` (`id`, `role`, `phone_number`, `active`, `created_at`, `updated_at`, `user_id`) VALUES ('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` DROP TABLE IF EXISTS `accounts_user`; CREATE TABLE `accounts_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `password` varchar(128) NOT NULL, `last_login` datetime(6) DEFAULT NULL, `is_superuser` tinyint(1) NOT NULL, `username` varchar(150) NOT NULL, `first_name` varchar(150) NOT NULL, `last_name` varchar(150) NOT NULL, `email` varchar(254) NOT NULL, `is_staff` tinyint(1) NOT NULL, `is_active` tinyint(1) NOT NULL, `date_joined` datetime(6) NOT NULL, `role` varchar(20) NOT NULL, `phone` varchar(15) NOT NULL, `is_active_staff` tinyint(1) NOT NULL, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), KEY `accounts_user_role_57e97df0` (`role`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `accounts_user` INSERT INTO `accounts_user` (`id`, `password`, `last_login`, `is_superuser`, `username`, `first_name`, `last_name`, `email`, `is_staff`, `is_active`, `date_joined`, `role`, `phone`, `is_active_staff`, `created_at`, `updated_at`) VALUES ('1', 'pbkdf2_sha256$1000000$BW4ZVcT4uw9MzV5ppTPEBk$GuRU7wsZCefa5zFIpQjNwLqMYwPvnc6BxlBeI0KBSdI=', '2026-07-14 02:37:46.000000', '1', 'admin', 'Riyaz', 'Admin', 'admin@nationaldrycleaners.in', '1', '1', '2026-06-20 13:08:37.465000', 'admin', '+919876543210', '1', '2026-06-20 13:08:37.466000', '2026-07-02 14:46:09.691214'); INSERT INTO `accounts_user` (`id`, `password`, `last_login`, `is_superuser`, `username`, `first_name`, `last_name`, `email`, `is_staff`, `is_active`, `date_joined`, `role`, `phone`, `is_active_staff`, `created_at`, `updated_at`) VALUES ('2', 'pbkdf2_sha256$1000000$gp4InVqYaEPKBB2OwYUbWu$lcbLdw66c85SNSfqnRIRQnIj4mp2+Hi+NlMZMWZmrgo=', NULL, '0', 'counter1', 'Priya', 'Sharma', 'counter@nationaldrycleaners.in', '1', '1', '2026-06-20 13:08:38.099000', 'counter_staff', '+919876543211', '1', '2026-06-20 13:08:38.099000', '2026-07-02 14:46:10.119968'); INSERT INTO `accounts_user` (`id`, `password`, `last_login`, `is_superuser`, `username`, `first_name`, `last_name`, `email`, `is_staff`, `is_active`, `date_joined`, `role`, `phone`, `is_active_staff`, `created_at`, `updated_at`) VALUES ('3', 'pbkdf2_sha256$1000000$kbw5ugJoMM8TSXEBrZBEK4$TIZIhWv9+fXbjjPOvKQl8nxynJOBwTVyZBH3l9vxoXg=', NULL, '0', 'delivery1', 'Amit', 'Kumar', 'delivery@nationaldrycleaners.in', '1', '1', '2026-06-20 13:08:38.696000', 'delivery_staff', '+919876543212', '1', '2026-06-20 13:08:38.696000', '2026-07-02 14:46:10.673783'); -- Table structure for table `accounts_user_groups` DROP TABLE IF EXISTS `accounts_user_groups`; CREATE TABLE `accounts_user_groups` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL, `group_id` int(11) 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; -- Table structure for table `accounts_user_user_permissions` DROP TABLE IF EXISTS `accounts_user_user_permissions`; CREATE TABLE `accounts_user_user_permissions` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL, `permission_id` int(11) 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; -- Table structure for table `activity_logs_activitylog` DROP TABLE IF EXISTS `activity_logs_activitylog`; CREATE TABLE `activity_logs_activitylog` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `action` varchar(50) NOT NULL, `description` longtext NOT NULL, `ip_address` char(39) DEFAULT NULL, `user_agent` varchar(500) NOT NULL, `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`metadata`)), `created_at` datetime(6) NOT NULL, `user_id` bigint(20) DEFAULT NULL, `module_name` varchar(50) 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=202 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `activity_logs_activitylog` INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) 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', ''); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('78', 'payment_updated', 'Payment updated on DC-2026-000002', NULL, '', '{\"order_id\": 2}', '2026-06-21 19:54:09.416000', '1', 'orders'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('92', 'payment_updated', 'Payment updated on DC-2026-000004', NULL, '', '{\"order_id\": 4}', '2026-07-02 16:58:12.549734', '1', 'orders'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('106', 'payment_updated', 'Payment updated on DC-2026-000003', NULL, '', '{\"order_id\": 3}', '2026-07-02 17:02:24.239413', '1', 'orders'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('111', 'payment_updated', 'Payment updated on DC-2026-000004', NULL, '', '{\"order_id\": 4}', '2026-07-02 17:02:37.564456', '1', 'orders'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('124', 'payment_updated', 'Payment updated on DC-2026-000002', NULL, '', '{\"order_id\": 2}', '2026-07-03 04:14:28.000582', '1', 'orders'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('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'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('136', '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-07 00:35:02.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('137', '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-07 00:35:10.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('138', '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-07 00:52:28.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('139', '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-07 00:58:40.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('140', '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-07 01:02:20.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('141', '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-07 01:04:33.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('142', '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-07 01:13:25.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('143', '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-07 01:24:03.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('144', '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-07 01:24:48.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('145', '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-07 01:24:50.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('146', '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-07 01:25:05.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('147', '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-07 01:31:03.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('148', '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-07 01:36:03.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('149', '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-07 01:37:16.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('150', '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-07 01:42:32.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('151', '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-07 01:42:57.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('152', '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-07 01:55:02.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('153', '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-07 01:57:05.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('154', '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-07 08:01:50.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('155', '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-07 08:01:53.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('156', '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-07 08:03:27.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('157', '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-07 08:13:43.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('158', '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-07 08:14:41.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('159', '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-07 08:16:09.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('160', '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-07 08:22:00.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('161', '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-07 09:53:11.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('162', '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-07 09:53:26.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('163', '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-07 10:45:51.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('164', '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-07 10:46:03.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('165', '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-07 11:11:56.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('166', '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-07 11:12:07.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('167', '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-07 11:25:32.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('168', '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-07 20:55:38.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('169', '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-07 22:45:34.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('170', '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-07 22:46:49.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('171', '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-07 23:42:16.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('172', 'login', 'admin logged in successfully.', '115.42.33.105', '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-08 10:25:02.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('173', 'logout', 'admin logged out.', '115.42.33.105', '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-08 10:26:18.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('174', 'login', 'admin logged in successfully.', '115.42.33.105', '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-09 02:55:58.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('175', 'logout', 'admin logged out.', '115.42.33.105', '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-09 03:01:01.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('176', 'login', 'admin logged in successfully.', '124.123.174.25', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-09 09:37:15.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('177', 'login', 'admin logged in successfully.', '115.42.33.105', '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-09 10:47:47.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('178', 'logout', 'admin logged out.', '115.42.33.105', '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-09 10:48:07.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('179', 'login', 'admin logged in successfully.', '124.123.174.25', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-09 22:32:58.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('180', 'logout', 'admin logged out.', '124.123.174.25', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-09 23:08:01.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('181', 'login', 'admin logged in successfully.', '124.123.174.25', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-09 23:25:14.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('182', 'logout', 'admin logged out.', '124.123.174.25', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-09 23:25:35.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('183', 'login', 'admin logged in successfully.', '124.123.174.25', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-11 07:36:09.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('184', 'logout', 'admin logged out.', '124.123.174.25', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-11 07:37:11.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('185', 'login', 'admin logged in successfully.', '122.177.243.180', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Mobile Safari/537.36', '[]', '2026-07-11 10:52:51.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('186', 'login', 'admin logged in successfully.', '124.123.174.25', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-12 22:31:25.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('187', 'logout', 'admin logged out.', '124.123.174.25', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-12 22:31:35.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('188', 'login', 'admin logged in successfully.', '115.98.144.228', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-13 03:16:17.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('189', 'logout', 'admin logged out.', '115.98.144.228', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-13 03:46:31.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('190', 'login', 'admin logged in successfully.', '115.98.144.228', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-13 11:59:25.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('191', 'logout', 'admin logged out.', '115.98.144.228', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-13 12:26:05.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('192', 'login', 'admin logged in successfully.', '115.98.144.228', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-13 12:27:06.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('193', 'logout', 'admin logged out.', '115.98.144.228', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-13 12:27:10.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('194', 'login', 'admin logged in successfully.', '115.98.144.228', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-13 12:27:37.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('195', 'logout', 'admin logged out.', '115.98.144.228', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-13 12:27:45.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('196', 'login', 'admin logged in successfully.', '115.98.144.228', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-13 12:31:21.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('197', 'logout', 'admin logged out.', '115.98.144.228', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-13 12:31:34.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('198', 'login', 'admin logged in successfully.', '115.42.33.201', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-14 02:36:57.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('199', 'logout', 'admin logged out.', '115.42.33.201', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-14 02:37:08.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('200', 'login', 'admin logged in successfully.', '115.42.33.201', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-14 02:37:46.000000', '1', 'accounts'); INSERT INTO `activity_logs_activitylog` (`id`, `action`, `description`, `ip_address`, `user_agent`, `metadata`, `created_at`, `user_id`, `module_name`) VALUES ('201', 'logout', 'admin logged out.', '115.42.33.201', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '[]', '2026-07-14 02:39:08.000000', '1', 'accounts'); -- Table structure for table `auth_group` DROP TABLE IF EXISTS `auth_group`; CREATE TABLE `auth_group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Table structure for table `auth_group_permissions` DROP TABLE IF EXISTS `auth_group_permissions`; CREATE TABLE `auth_group_permissions` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `group_id` int(11) NOT NULL, `permission_id` int(11) 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; -- Table structure for table `auth_permission` DROP TABLE IF EXISTS `auth_permission`; CREATE TABLE `auth_permission` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `content_type_id` int(11) NOT NULL, `codename` varchar(100) 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` (`id`, `name`, `content_type_id`, `codename`) VALUES ('1', 'Can add log entry', '1', 'add_logentry'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('2', 'Can change log entry', '1', 'change_logentry'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('3', 'Can delete log entry', '1', 'delete_logentry'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('4', 'Can view log entry', '1', 'view_logentry'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('5', 'Can add permission', '2', 'add_permission'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('6', 'Can change permission', '2', 'change_permission'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('7', 'Can delete permission', '2', 'delete_permission'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('8', 'Can view permission', '2', 'view_permission'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('9', 'Can add group', '3', 'add_group'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('10', 'Can change group', '3', 'change_group'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('11', 'Can delete group', '3', 'delete_group'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('12', 'Can view group', '3', 'view_group'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('13', 'Can add content type', '4', 'add_contenttype'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('14', 'Can change content type', '4', 'change_contenttype'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('15', 'Can delete content type', '4', 'delete_contenttype'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('16', 'Can view content type', '4', 'view_contenttype'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('17', 'Can add session', '5', 'add_session'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('18', 'Can change session', '5', 'change_session'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('19', 'Can delete session', '5', 'delete_session'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('20', 'Can view session', '5', 'view_session'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('21', 'Can add Staff User', '6', 'add_user'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('22', 'Can change Staff User', '6', 'change_user'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('23', 'Can delete Staff User', '6', 'delete_user'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('24', 'Can view Staff User', '6', 'view_user'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('25', 'Can add Staff Profile', '7', 'add_staffprofile'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('26', 'Can change Staff Profile', '7', 'change_staffprofile'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('27', 'Can delete Staff Profile', '7', 'delete_staffprofile'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('28', 'Can view Staff Profile', '7', 'view_staffprofile'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('29', 'Can add Customer', '8', 'add_customer'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('30', 'Can change Customer', '8', 'change_customer'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('31', 'Can delete Customer', '8', 'delete_customer'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('32', 'Can view Customer', '8', 'view_customer'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('33', 'Can add Category', '9', 'add_category'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('34', 'Can change Category', '9', 'change_category'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('35', 'Can delete Category', '9', 'delete_category'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('36', 'Can view Category', '9', 'view_category'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('37', 'Can add Item', '10', 'add_item'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('38', 'Can change Item', '10', 'change_item'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('39', 'Can delete Item', '10', 'delete_item'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('40', 'Can view Item', '10', 'view_item'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('41', 'Can add Order', '11', 'add_order'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('42', 'Can change Order', '11', 'change_order'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('43', 'Can delete Order', '11', 'delete_order'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('44', 'Can view Order', '11', 'view_order'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('45', 'Can add Order Item', '12', 'add_orderitem'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('46', 'Can change Order Item', '12', 'change_orderitem'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('47', 'Can delete Order Item', '12', 'delete_orderitem'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('48', 'Can view Order Item', '12', 'view_orderitem'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('49', 'Can add Order Photo', '13', 'add_orderphoto'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('50', 'Can change Order Photo', '13', 'change_orderphoto'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('51', 'Can delete Order Photo', '13', 'delete_orderphoto'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('52', 'Can view Order Photo', '13', 'view_orderphoto'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('53', 'Can add Payment', '14', 'add_payment'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('54', 'Can change Payment', '14', 'change_payment'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('55', 'Can delete Payment', '14', 'delete_payment'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('56', 'Can view Payment', '14', 'view_payment'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('57', 'Can add Bill / Invoice', '15', 'add_bill'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('58', 'Can change Bill / Invoice', '15', 'change_bill'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('59', 'Can delete Bill / Invoice', '15', 'delete_bill'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('60', 'Can view Bill / Invoice', '15', 'view_bill'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('61', 'Can add AI Damage Report', '16', 'add_aidamagereport'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('62', 'Can change AI Damage Report', '16', 'change_aidamagereport'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('63', 'Can delete AI Damage Report', '16', 'delete_aidamagereport'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('64', 'Can view AI Damage Report', '16', 'view_aidamagereport'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('65', 'Can add Activity Log', '17', 'add_activitylog'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('66', 'Can change Activity Log', '17', 'change_activitylog'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('67', 'Can delete Activity Log', '17', 'delete_activitylog'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('68', 'Can view Activity Log', '17', 'view_activitylog'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('69', 'Can add Shop Profile', '18', 'add_shopprofile'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('70', 'Can change Shop Profile', '18', 'change_shopprofile'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('71', 'Can delete Shop Profile', '18', 'delete_shopprofile'); INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES ('72', 'Can view Shop Profile', '18', 'view_shopprofile'); -- Table structure for table `billing_bill` DROP TABLE IF EXISTS `billing_bill`; CREATE TABLE `billing_bill` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `bill_number` varchar(20) NOT NULL, `invoice_pdf` varchar(100) 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(20) DEFAULT NULL, `order_id` bigint(20) 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=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `billing_bill` INSERT INTO `billing_bill` (`id`, `bill_number`, `invoice_pdf`, `generated_at`, `sent_on_whatsapp`, `whatsapp_sent_at`, `active`, `generated_by_id`, `order_id`) VALUES ('1', 'BILL-2026-000001', 'invoices/DC-2026-000004/BILL-2026-000001.pdf', '2026-07-07 01:36:21.000000', '0', NULL, '1', '1', '4'); INSERT INTO `billing_bill` (`id`, `bill_number`, `invoice_pdf`, `generated_at`, `sent_on_whatsapp`, `whatsapp_sent_at`, `active`, `generated_by_id`, `order_id`) VALUES ('2', 'BILL-2026-000002', 'invoices/DC-2026-000003/BILL-2026-000002.pdf', '2026-07-07 01:13:34.000000', '0', NULL, '1', '1', '3'); INSERT INTO `billing_bill` (`id`, `bill_number`, `invoice_pdf`, `generated_at`, `sent_on_whatsapp`, `whatsapp_sent_at`, `active`, `generated_by_id`, `order_id`) VALUES ('3', 'BILL-2026-000003', 'invoices/DC-2026-000002/BILL-2026-000003.pdf', '2026-07-07 01:25:19.000000', '0', NULL, '1', '1', '2'); INSERT INTO `billing_bill` (`id`, `bill_number`, `invoice_pdf`, `generated_at`, `sent_on_whatsapp`, `whatsapp_sent_at`, `active`, `generated_by_id`, `order_id`) VALUES ('4', 'BILL-2026-000004', 'invoices/DC-2026-000005/BILL-2026-000004.pdf', '2026-07-07 10:46:16.000000', '0', NULL, '1', '1', '5'); INSERT INTO `billing_bill` (`id`, `bill_number`, `invoice_pdf`, `generated_at`, `sent_on_whatsapp`, `whatsapp_sent_at`, `active`, `generated_by_id`, `order_id`) VALUES ('5', 'BILL-2026-000005', 'invoices/DC-2026-000001/BILL-2026-000005.pdf', '2026-07-07 10:30:10.000000', '0', NULL, '1', '1', '1'); INSERT INTO `billing_bill` (`id`, `bill_number`, `invoice_pdf`, `generated_at`, `sent_on_whatsapp`, `whatsapp_sent_at`, `active`, `generated_by_id`, `order_id`) VALUES ('6', 'BILL-2026-000006', 'invoices/DC-2026-000009/BILL-2026-000006.pdf', '2026-07-09 23:02:25.000000', '0', NULL, '1', '1', '9'); INSERT INTO `billing_bill` (`id`, `bill_number`, `invoice_pdf`, `generated_at`, `sent_on_whatsapp`, `whatsapp_sent_at`, `active`, `generated_by_id`, `order_id`) VALUES ('7', 'BILL-2026-000007', 'invoices/DC-2026-000008/BILL-2026-000007.pdf', '2026-07-13 03:22:58.000000', '0', NULL, '1', '1', '8'); INSERT INTO `billing_bill` (`id`, `bill_number`, `invoice_pdf`, `generated_at`, `sent_on_whatsapp`, `whatsapp_sent_at`, `active`, `generated_by_id`, `order_id`) VALUES ('8', 'BILL-2026-000008', 'invoices/DC-2026-000010/BILL-2026-000008.pdf', '2026-07-13 03:27:04.000000', '0', NULL, '1', '1', '10'); INSERT INTO `billing_bill` (`id`, `bill_number`, `invoice_pdf`, `generated_at`, `sent_on_whatsapp`, `whatsapp_sent_at`, `active`, `generated_by_id`, `order_id`) VALUES ('9', 'BILL-2026-000009', 'invoices/DC-2026-000011/BILL-2026-000009.pdf', '2026-07-13 12:11:41.000000', '0', NULL, '1', '1', '11'); INSERT INTO `billing_bill` (`id`, `bill_number`, `invoice_pdf`, `generated_at`, `sent_on_whatsapp`, `whatsapp_sent_at`, `active`, `generated_by_id`, `order_id`) VALUES ('10', 'BILL-2026-000010', 'invoices/DC-2026-000012/BILL-2026-000010.pdf', '2026-07-13 12:21:19.000000', '0', NULL, '1', '1', '12'); -- Table structure for table `categories_category` DROP TABLE IF EXISTS `categories_category`; CREATE TABLE `categories_category` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, `description` longtext NOT NULL, `active` tinyint(1) NOT NULL, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, `created_by_id` bigint(20) 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=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `categories_category` INSERT INTO `categories_category` (`id`, `name`, `description`, `active`, `created_at`, `updated_at`, `created_by_id`) 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); INSERT INTO `categories_category` (`id`, `name`, `description`, `active`, `created_at`, `updated_at`, `created_by_id`) VALUES ('2', 'Rolling', 'Rolling and pressing services', '1', '2026-06-20 13:30:06.853000', '2026-06-20 13:30:06.853000', NULL); INSERT INTO `categories_category` (`id`, `name`, `description`, `active`, `created_at`, `updated_at`, `created_by_id`) VALUES ('3', 'Polish', 'Polish and finishing services', '1', '2026-06-20 13:30:06.863000', '2026-06-20 13:30:06.863000', NULL); INSERT INTO `categories_category` (`id`, `name`, `description`, `active`, `created_at`, `updated_at`, `created_by_id`) VALUES ('4', 'Suit Cleaning', 'Professional suit dry cleaning', '1', '2026-06-20 13:30:06.872000', '2026-06-20 13:30:06.872000', NULL); INSERT INTO `categories_category` (`id`, `name`, `description`, `active`, `created_at`, `updated_at`, `created_by_id`) VALUES ('5', 'Blanket Cleaning', 'Blanket and heavy linen cleaning', '1', '2026-06-20 13:30:06.881000', '2026-06-20 13:30:06.881000', NULL); INSERT INTO `categories_category` (`id`, `name`, `description`, `active`, `created_at`, `updated_at`, `created_by_id`) VALUES ('6', 'Curtain Cleaning', 'Curtain and drape cleaning', '1', '2026-06-20 13:30:06.889000', '2026-06-20 13:30:06.889000', NULL); INSERT INTO `categories_category` (`id`, `name`, `description`, `active`, `created_at`, `updated_at`, `created_by_id`) VALUES ('7', 'Blazer Cleaning', 'Blazer and jacket cleaning', '1', '2026-06-20 13:30:06.899000', '2026-06-20 13:30:06.899000', NULL); INSERT INTO `categories_category` (`id`, `name`, `description`, `active`, `created_at`, `updated_at`, `created_by_id`) VALUES ('8', 'Regular Clothes', 'Everyday garment cleaning', '1', '2026-06-20 13:30:06.908000', '2026-06-20 13:30:06.908000', NULL); INSERT INTO `categories_category` (`id`, `name`, `description`, `active`, `created_at`, `updated_at`, `created_by_id`) VALUES ('9', 'Premium Garments', 'Premium and delicate garment care', '1', '2026-06-20 13:30:06.916000', '2026-06-20 13:30:06.916000', NULL); INSERT INTO `categories_category` (`id`, `name`, `description`, `active`, `created_at`, `updated_at`, `created_by_id`) VALUES ('10', 'Toys', 'Small and big toys', '1', '2026-06-21 05:22:47.456000', '2026-06-21 05:22:47.457000', '1'); INSERT INTO `categories_category` (`id`, `name`, `description`, `active`, `created_at`, `updated_at`, `created_by_id`) VALUES ('11', 'Carpet Cleaning', 'Deep clean carpet cleaning', '1', '2026-06-21 05:23:54.849000', '2026-06-21 05:23:54.849000', '1'); INSERT INTO `categories_category` (`id`, `name`, `description`, `active`, `created_at`, `updated_at`, `created_by_id`) VALUES ('12', 'Darning Items', 'Darning Items', '1', '2026-07-13 03:41:17.000000', '2026-07-13 03:41:17.000000', '1'); -- Table structure for table `customers_customer` DROP TABLE IF EXISTS `customers_customer`; CREATE TABLE `customers_customer` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(200) NOT NULL, `mobile_number` varchar(15) NOT NULL, `whatsapp_number` varchar(15) NOT NULL, `address` longtext NOT NULL, `notes` longtext NOT NULL, `active` tinyint(1) NOT NULL, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, `created_by_id` bigint(20) DEFAULT NULL, `alternate_number` varchar(15) 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=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `customers_customer` INSERT INTO `customers_customer` (`id`, `name`, `mobile_number`, `whatsapp_number`, `address`, `notes`, `active`, `created_at`, `updated_at`, `created_by_id`, `alternate_number`) 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'); INSERT INTO `customers_customer` (`id`, `name`, `mobile_number`, `whatsapp_number`, `address`, `notes`, `active`, `created_at`, `updated_at`, `created_by_id`, `alternate_number`) VALUES ('2', 'Susmitha Laxmi', '7780313748', '7780313748', 'hyd', '', '1', '2026-06-21 16:50:55.760000', '2026-06-21 17:29:38.706000', '1', '9849555010'); INSERT INTO `customers_customer` (`id`, `name`, `mobile_number`, `whatsapp_number`, `address`, `notes`, `active`, `created_at`, `updated_at`, `created_by_id`, `alternate_number`) VALUES ('3', 'test 123', '1234567891', '1234567890', 'home', '', '1', '2026-06-21 18:30:21.713000', '2026-06-21 19:22:38.235000', '1', '2223334445'); INSERT INTO `customers_customer` (`id`, `name`, `mobile_number`, `whatsapp_number`, `address`, `notes`, `active`, `created_at`, `updated_at`, `created_by_id`, `alternate_number`) VALUES ('4', 'test2', '1122334455', '1122334455', 'home1', '', '0', '2026-06-21 18:33:48.416000', '2026-07-07 09:35:20.000000', '1', '0987654321'); INSERT INTO `customers_customer` (`id`, `name`, `mobile_number`, `whatsapp_number`, `address`, `notes`, `active`, `created_at`, `updated_at`, `created_by_id`, `alternate_number`) VALUES ('5', 'test3', '1236789076', '1236789078', '', '', '1', '2026-06-21 19:33:55.292000', '2026-06-21 19:33:55.292000', '1', '2222222222'); INSERT INTO `customers_customer` (`id`, `name`, `mobile_number`, `whatsapp_number`, `address`, `notes`, `active`, `created_at`, `updated_at`, `created_by_id`, `alternate_number`) VALUES ('6', 'test4', '9876543217', '9876543217', 'test', '', '1', '2026-07-02 14:51:24.011743', '2026-07-02 14:51:24.011796', '1', '5656565656'); INSERT INTO `customers_customer` (`id`, `name`, `mobile_number`, `whatsapp_number`, `address`, `notes`, `active`, `created_at`, `updated_at`, `created_by_id`, `alternate_number`) VALUES ('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'); INSERT INTO `customers_customer` (`id`, `name`, `mobile_number`, `whatsapp_number`, `address`, `notes`, `active`, `created_at`, `updated_at`, `created_by_id`, `alternate_number`) VALUES ('8', 'Soumya Ranjan Das11', '9439149611', '9439149611', 'MBM Silver, Plot L3/60, 3rd Floor, AcharyaVihar', '', '1', '2026-07-08 10:25:37.000000', '2026-07-08 10:25:37.000000', '1', ''); INSERT INTO `customers_customer` (`id`, `name`, `mobile_number`, `whatsapp_number`, `address`, `notes`, `active`, `created_at`, `updated_at`, `created_by_id`, `alternate_number`) VALUES ('9', 'Soumya Ranjan Das33', '9439149633', '9439149633', 'MBM Silver, Plot L3/60, 3rd Floor, AcharyaVihar', '', '1', '2026-07-09 02:57:05.000000', '2026-07-09 02:57:05.000000', '1', ''); INSERT INTO `customers_customer` (`id`, `name`, `mobile_number`, `whatsapp_number`, `address`, `notes`, `active`, `created_at`, `updated_at`, `created_by_id`, `alternate_number`) VALUES ('10', 'Soumya Ranjan Das22', '9439149622', '9439149622', 'MBM Silver, Plot L3/60, 3rd Floor, AcharyaVihar', '', '1', '2026-07-09 03:00:17.000000', '2026-07-09 03:00:17.000000', '1', ''); INSERT INTO `customers_customer` (`id`, `name`, `mobile_number`, `whatsapp_number`, `address`, `notes`, `active`, `created_at`, `updated_at`, `created_by_id`, `alternate_number`) VALUES ('11', 'test rahul', '9988776633', '9988776633', 'test rahul', '', '1', '2026-07-09 22:33:36.000000', '2026-07-09 22:33:36.000000', '1', '5457686922'); INSERT INTO `customers_customer` (`id`, `name`, `mobile_number`, `whatsapp_number`, `address`, `notes`, `active`, `created_at`, `updated_at`, `created_by_id`, `alternate_number`) VALUES ('12', 'test 13072026', '9867050394', '9867050394', 'testing', '', '1', '2026-07-13 03:24:51.000000', '2026-07-13 03:24:51.000000', '1', '3445632266'); INSERT INTO `customers_customer` (`id`, `name`, `mobile_number`, `whatsapp_number`, `address`, `notes`, `active`, `created_at`, `updated_at`, `created_by_id`, `alternate_number`) VALUES ('13', 'syed sufiyan ali', '8008669806', '8008669806', 'national dry cleaners', 'good', '1', '2026-07-13 12:08:15.000000', '2026-07-13 12:08:15.000000', '1', '8919363619'); INSERT INTO `customers_customer` (`id`, `name`, `mobile_number`, `whatsapp_number`, `address`, `notes`, `active`, `created_at`, `updated_at`, `created_by_id`, `alternate_number`) VALUES ('14', 'faizan', '9700409840', '9700409840', '', 'avarage', '1', '2026-07-13 12:16:53.000000', '2026-07-13 12:16:53.000000', '1', '9700423676'); -- Table structure for table `damage_detection_aidamagereport` DROP TABLE IF EXISTS `damage_detection_aidamagereport`; CREATE TABLE `damage_detection_aidamagereport` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `similarity_score` decimal(5,2) DEFAULT NULL, `confidence_score` decimal(5,2) DEFAULT NULL, `status` varchar(30) NOT NULL, `ai_observations` longtext NOT NULL, `difference_image` varchar(100) DEFAULT NULL, `created_at` datetime(6) NOT NULL, `after_photo_id` bigint(20) DEFAULT NULL, `before_photo_id` bigint(20) DEFAULT NULL, `created_by_id` bigint(20) DEFAULT NULL, `order_id` bigint(20) 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 AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `damage_detection_aidamagereport` INSERT INTO `damage_detection_aidamagereport` (`id`, `similarity_score`, `confidence_score`, `status`, `ai_observations`, `difference_image`, `created_at`, `after_photo_id`, `before_photo_id`, `created_by_id`, `order_id`) VALUES ('1', '25.57', '74.43', 'possible_damage', 'Significant visual difference detected. Manual verification recommended. Possible visible difference — stain, tear, color change, or texture change may be present.\n\nManual verification recommended. AI assisted comparison cannot confirm exact damage type. Please inspect the garment physically before informing the customer.', 'orders/ai_reports/DC-2026-000009_front_4c7781dc.jpg', '2026-07-09 22:46:06.000000', '19', '17', '1', '9'); INSERT INTO `damage_detection_aidamagereport` (`id`, `similarity_score`, `confidence_score`, `status`, `ai_observations`, `difference_image`, `created_at`, `after_photo_id`, `before_photo_id`, `created_by_id`, `order_id`) VALUES ('2', '3.09', '96.91', 'possible_damage', 'Significant visual difference detected. Manual verification recommended. Possible visible difference — stain, tear, color change, or texture change may be present.\n\nManual verification recommended. AI assisted comparison cannot confirm exact damage type. Please inspect the garment physically before informing the customer.', 'orders/ai_reports/DC-2026-000009_back_62212fb2.jpg', '2026-07-09 22:46:06.000000', '20', '18', '1', '9'); INSERT INTO `damage_detection_aidamagereport` (`id`, `similarity_score`, `confidence_score`, `status`, `ai_observations`, `difference_image`, `created_at`, `after_photo_id`, `before_photo_id`, `created_by_id`, `order_id`) VALUES ('3', '18.17', '81.83', 'possible_damage', 'Significant visual difference detected. Manual verification recommended. Possible visible difference — stain, tear, color change, or texture change may be present.\n\nManual verification recommended. AI assisted comparison cannot confirm exact damage type. Please inspect the garment physically before informing the customer.', 'orders/ai_reports/DC-2026-000010_front_194a4635.jpg', '2026-07-13 03:31:46.000000', '22', '21', '1', '10'); -- Table structure for table `django_admin_log` DROP TABLE IF EXISTS `django_admin_log`; CREATE TABLE `django_admin_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `action_time` datetime(6) NOT NULL, `object_id` longtext DEFAULT NULL, `object_repr` varchar(200) NOT NULL, `action_flag` smallint(5) unsigned NOT NULL, `change_message` longtext NOT NULL, `content_type_id` int(11) DEFAULT NULL, `user_id` bigint(20) 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; -- Table structure for table `django_content_type` DROP TABLE IF EXISTS `django_content_type`; CREATE TABLE `django_content_type` ( `id` int(11) NOT NULL AUTO_INCREMENT, `app_label` varchar(100) NOT NULL, `model` varchar(100) 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` (`id`, `app_label`, `model`) VALUES ('7', 'accounts', 'staffprofile'); INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES ('6', 'accounts', 'user'); INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES ('17', 'activity_logs', 'activitylog'); INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES ('1', 'admin', 'logentry'); INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES ('3', 'auth', 'group'); INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES ('2', 'auth', 'permission'); INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES ('15', 'billing', 'bill'); INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES ('9', 'categories', 'category'); INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES ('4', 'contenttypes', 'contenttype'); INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES ('8', 'customers', 'customer'); INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES ('16', 'damage_detection', 'aidamagereport'); INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES ('10', 'inventory', 'item'); INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES ('11', 'orders', 'order'); INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES ('12', 'orders', 'orderitem'); INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES ('13', 'orders', 'orderphoto'); INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES ('14', 'payments', 'payment'); INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES ('5', 'sessions', 'session'); INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES ('18', 'shop_settings', 'shopprofile'); -- Table structure for table `django_migrations` DROP TABLE IF EXISTS `django_migrations`; CREATE TABLE `django_migrations` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `app` varchar(255) NOT NULL, `name` varchar(255) 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` (`id`, `app`, `name`, `applied`) VALUES ('1', 'contenttypes', '0001_initial', '2026-07-02 14:44:01.596461'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('2', 'contenttypes', '0002_remove_content_type_name', '2026-07-02 14:44:01.736686'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('3', 'auth', '0001_initial', '2026-07-02 14:44:02.252012'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('4', 'auth', '0002_alter_permission_name_max_length', '2026-07-02 14:44:02.352289'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('5', 'auth', '0003_alter_user_email_max_length', '2026-07-02 14:44:02.361229'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('6', 'auth', '0004_alter_user_username_opts', '2026-07-02 14:44:02.369450'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('7', 'auth', '0005_alter_user_last_login_null', '2026-07-02 14:44:02.378180'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('8', 'auth', '0006_require_contenttypes_0002', '2026-07-02 14:44:02.383789'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('9', 'auth', '0007_alter_validators_add_error_messages', '2026-07-02 14:44:02.394144'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('10', 'auth', '0008_alter_user_username_max_length', '2026-07-02 14:44:02.402667'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('11', 'auth', '0009_alter_user_last_name_max_length', '2026-07-02 14:44:02.412260'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('12', 'auth', '0010_alter_group_name_max_length', '2026-07-02 14:44:02.435078'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('13', 'auth', '0011_update_proxy_permissions', '2026-07-02 14:44:02.444906'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('14', 'auth', '0012_alter_user_first_name_max_length', '2026-07-02 14:44:02.452935'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('15', 'accounts', '0001_initial', '2026-07-02 14:44:03.235165'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('16', 'accounts', '0002_staffprofile', '2026-07-02 14:44:03.410587'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('17', 'activity_logs', '0001_initial', '2026-07-02 14:44:03.583780'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('18', 'activity_logs', '0002_activitylog_module_name_alter_activitylog_action', '2026-07-02 14:44:03.786908'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('19', 'activity_logs', '0003_alter_activitylog_action', '2026-07-02 14:44:03.796336'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('20', 'activity_logs', '0004_add_book_order_clicked', '2026-07-02 14:44:03.806278'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('21', 'activity_logs', '0005_alter_activitylog_action', '2026-07-02 14:44:03.818634'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('22', 'activity_logs', '0006_add_ai_damage_actions', '2026-07-02 14:44:03.828851'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('23', 'admin', '0001_initial', '2026-07-02 14:44:04.049898'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('24', 'admin', '0002_logentry_remove_auto_add', '2026-07-02 14:44:04.061369'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('25', 'admin', '0003_logentry_add_action_flag_choices', '2026-07-02 14:44:04.071661'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('26', 'categories', '0001_initial', '2026-07-02 14:44:04.236128'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('27', 'inventory', '0001_initial', '2026-07-02 14:44:04.487236'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('28', 'inventory', '0002_item_price_range', '2026-07-02 14:44:04.792058'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('29', 'customers', '0001_initial', '2026-07-02 14:44:04.974853'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('30', 'customers', '0002_customer_alternate_number', '2026-07-02 14:44:05.081472'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('31', 'orders', '0001_initial', '2026-07-02 14:44:05.819253'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('32', 'orders', '0002_add_order_date', '2026-07-02 14:44:06.008650'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('33', 'orders', '0003_order_payment_status_order_total_paid', '2026-07-02 14:44:06.269851'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('34', 'billing', '0001_initial', '2026-07-02 14:44:06.522368'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('35', 'damage_detection', '0001_initial', '2026-07-02 14:44:06.554535'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('36', 'damage_detection', '0002_initial', '2026-07-02 14:44:06.990863'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('37', 'payments', '0001_initial', '2026-07-02 14:44:07.332878'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('38', 'sessions', '0001_initial', '2026-07-02 14:44:07.390304'); INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES ('39', 'shop_settings', '0001_initial', '2026-07-03 02:54:08.255450'); -- Table structure for table `django_session` DROP TABLE IF EXISTS `django_session`; CREATE TABLE `django_session` ( `session_key` varchar(40) NOT NULL, `session_data` longtext NOT NULL, `expire_date` datetime(6) NOT NULL, PRIMARY KEY (`session_key`), KEY `django_session_expire_date_a5c62663` (`expire_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `django_session` INSERT INTO `django_session` (`session_key`, `session_data`, `expire_date`) VALUES ('5aawqiszqbu6p65j9acox09hu1rn8ptf', '.eJxVjEEOgjAQRe_StWlaGGjHpXvPQGY6g6CmTSisjHdXEha6_e-9_zIDbes0bFWXYRZzNt6cfjem9NC8A7lTvhWbSl6Xme2u2INWey2iz8vh_h1MVKdv3YRRQaPEEJG0SehVGLsWXIIesEPECK5R7oPjIG1Qj9R2BDxG5xnM-wPY2Ddi:1wavqd:LWuQ__9I_dOsPRvRW4NtgnGJHnAdvnUoeIcHZNphr-4', '2026-07-04 13:34:59.321000'); INSERT INTO `django_session` (`session_key`, `session_data`, `expire_date`) VALUES ('re4uovy53kj556ovp28844i9tw59har3', '.eJxVjEEOgjAQRe_StWlaGGjHpXvPQGY6g6CmTSisjHdXEha6_e-9_zIDbes0bFWXYRZzNt6cfjem9NC8A7lTvhWbSl6Xme2u2INWey2iz8vh_h1MVKdv3YRRQaPEEJG0SehVGLsWXIIesEPECK5R7oPjIG1Qj9R2BDxG5xnM-wPY2Ddi:1wbAFE:jTZQtxbKGNOc1MRGmLINmEvlXH0L-1QU0iBLZawzupY', '2026-07-05 04:57:20.396000'); INSERT INTO `django_session` (`session_key`, `session_data`, `expire_date`) VALUES ('yk37ukf4vpuvq2o7yzdigmtgyiayrjbi', '.eJxVjEEOgjAQRe_StWlaGGjHpXvPQGY6g6CmTSisjHdXEha6_e-9_zIDbes0bFWXYRZzNt6cfjem9NC8A7lTvhWbSl6Xme2u2INWey2iz8vh_h1MVKdv3YRRQaPEEJG0SehVGLsWXIIesEPECK5R7oPjIG1Qj9R2BDxG5xnM-wPY2Ddi:1wbHg5:JjAJxjgEVRSoB2U7ZxVdZv257nDoh_3bwlIiMeiQXAs', '2026-07-05 12:53:33.196000'); INSERT INTO `django_session` (`session_key`, `session_data`, `expire_date`) VALUES ('yktkagbns0ucz7kfnitjdnihg2x1uewf', '.eJxVjEEOgjAQRe_StWlaGGjHpXvPQGY6g6CmTSisjHdXEha6_e-9_zIDbes0bFWXYRZzNt6cfjem9NC8A7lTvhWbSl6Xme2u2INWey2iz8vh_h1MVKdv3YRRQaPEEJG0SehVGLsWXIIesEPECK5R7oPjIG1Qj9R2BDxG5xnM-wPY2Ddi:1wbZ5V:VvQyeABqueMbNyMkrn5Kbft3LzwMwBLxsKA77-C3tso', '2026-07-06 07:28:57.757000'); -- Table structure for table `inventory_item` DROP TABLE IF EXISTS `inventory_item`; CREATE TABLE `inventory_item` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `item_name` varchar(150) NOT NULL, `service_type` varchar(30) NOT NULL, `active` tinyint(1) NOT NULL, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, `category_id` bigint(20) NOT NULL, `created_by_id` bigint(20) 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=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `inventory_item` INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) 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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('21', 'Toys', 'washing', '1', '2026-06-21 10:18:55.073000', '2026-06-21 10:18:55.073000', '10', '1', '100.00', '1000.00'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('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'); INSERT INTO `inventory_item` (`id`, `item_name`, `service_type`, `active`, `created_at`, `updated_at`, `category_id`, `created_by_id`, `min_price`, `max_price`) VALUES ('23', 'Darning', 'other', '1', '2026-07-13 03:42:02.000000', '2026-07-13 03:42:02.000000', '12', '1', '100.00', '1200.00'); -- Table structure for table `orders_order` DROP TABLE IF EXISTS `orders_order`; CREATE TABLE `orders_order` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `order_number` varchar(20) NOT NULL, `status` varchar(20) 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) NOT NULL, `remarks` longtext NOT NULL, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, `created_by_id` bigint(20) DEFAULT NULL, `customer_id` bigint(20) NOT NULL, `order_date` date NOT NULL, `payment_status` varchar(20) 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=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `orders_order` INSERT INTO `orders_order` (`id`, `order_number`, `status`, `expected_delivery_date`, `subtotal`, `discount_amount`, `grand_total`, `advance_paid`, `balance_amount`, `payment_mode`, `remarks`, `created_at`, `updated_at`, `created_by_id`, `customer_id`, `order_date`, `payment_status`, `total_paid`) VALUES ('1', 'DC-2026-000001', 'delivered', '2026-06-27', '340.00', '25.00', '315.00', '315.00', '0.00', 'cash', '', '2026-06-21 17:31:11.609000', '2026-07-07 10:30:03.000000', '1', '2', '2026-06-21', 'paid', '315.00'); INSERT INTO `orders_order` (`id`, `order_number`, `status`, `expected_delivery_date`, `subtotal`, `discount_amount`, `grand_total`, `advance_paid`, `balance_amount`, `payment_mode`, `remarks`, `created_at`, `updated_at`, `created_by_id`, `customer_id`, `order_date`, `payment_status`, `total_paid`) VALUES ('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'); INSERT INTO `orders_order` (`id`, `order_number`, `status`, `expected_delivery_date`, `subtotal`, `discount_amount`, `grand_total`, `advance_paid`, `balance_amount`, `payment_mode`, `remarks`, `created_at`, `updated_at`, `created_by_id`, `customer_id`, `order_date`, `payment_status`, `total_paid`) VALUES ('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'); INSERT INTO `orders_order` (`id`, `order_number`, `status`, `expected_delivery_date`, `subtotal`, `discount_amount`, `grand_total`, `advance_paid`, `balance_amount`, `payment_mode`, `remarks`, `created_at`, `updated_at`, `created_by_id`, `customer_id`, `order_date`, `payment_status`, `total_paid`) VALUES ('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'); INSERT INTO `orders_order` (`id`, `order_number`, `status`, `expected_delivery_date`, `subtotal`, `discount_amount`, `grand_total`, `advance_paid`, `balance_amount`, `payment_mode`, `remarks`, `created_at`, `updated_at`, `created_by_id`, `customer_id`, `order_date`, `payment_status`, `total_paid`) VALUES ('5', 'DC-2026-000005', 'delivered', '2026-07-08', '850.00', '50.00', '800.00', '650.00', '150.00', 'cash', '', '2026-07-03 21:11:30.000000', '2026-07-13 03:43:00.000000', '1', '7', '2026-07-03', 'partially_paid', '650.00'); INSERT INTO `orders_order` (`id`, `order_number`, `status`, `expected_delivery_date`, `subtotal`, `discount_amount`, `grand_total`, `advance_paid`, `balance_amount`, `payment_mode`, `remarks`, `created_at`, `updated_at`, `created_by_id`, `customer_id`, `order_date`, `payment_status`, `total_paid`) VALUES ('6', 'DC-2026-000006', 'delivered', '2026-07-08', '205.00', '0.00', '205.00', '50.00', '155.00', 'cash', '', '2026-07-07 09:55:26.000000', '2026-07-09 09:39:54.000000', '1', '7', '2026-07-07', 'partially_paid', '50.00'); INSERT INTO `orders_order` (`id`, `order_number`, `status`, `expected_delivery_date`, `subtotal`, `discount_amount`, `grand_total`, `advance_paid`, `balance_amount`, `payment_mode`, `remarks`, `created_at`, `updated_at`, `created_by_id`, `customer_id`, `order_date`, `payment_status`, `total_paid`) VALUES ('7', 'DC-2026-000007', 'delivered', '2026-07-07', '855.00', '0.00', '855.00', '0.00', '855.00', 'pending', '', '2026-07-07 22:35:43.000000', '2026-07-07 22:36:51.000000', '1', '3', '2026-07-07', 'pending', '0.00'); INSERT INTO `orders_order` (`id`, `order_number`, `status`, `expected_delivery_date`, `subtotal`, `discount_amount`, `grand_total`, `advance_paid`, `balance_amount`, `payment_mode`, `remarks`, `created_at`, `updated_at`, `created_by_id`, `customer_id`, `order_date`, `payment_status`, `total_paid`) VALUES ('8', 'DC-2026-000008', 'delivered', '2026-07-07', '325.00', '0.00', '325.00', '0.00', '325.00', 'pending', '', '2026-07-07 22:57:37.000000', '2026-07-13 03:24:00.000000', '1', '3', '2026-07-07', 'pending', '0.00'); INSERT INTO `orders_order` (`id`, `order_number`, `status`, `expected_delivery_date`, `subtotal`, `discount_amount`, `grand_total`, `advance_paid`, `balance_amount`, `payment_mode`, `remarks`, `created_at`, `updated_at`, `created_by_id`, `customer_id`, `order_date`, `payment_status`, `total_paid`) VALUES ('9', 'DC-2026-000009', 'delivered', '2026-07-10', '2530.00', '0.00', '2530.00', '2530.00', '0.00', 'cash', '', '2026-07-09 22:39:50.000000', '2026-07-09 23:01:28.000000', '1', '11', '2026-07-10', 'paid', '2530.00'); INSERT INTO `orders_order` (`id`, `order_number`, `status`, `expected_delivery_date`, `subtotal`, `discount_amount`, `grand_total`, `advance_paid`, `balance_amount`, `payment_mode`, `remarks`, `created_at`, `updated_at`, `created_by_id`, `customer_id`, `order_date`, `payment_status`, `total_paid`) VALUES ('10', 'DC-2026-000010', 'ready_for_pickup', '2026-07-13', '450.00', '0.00', '450.00', '100.00', '350.00', 'cash', '', '2026-07-13 03:26:25.000000', '2026-07-13 03:27:42.000000', '1', '12', '2026-07-13', 'partially_paid', '100.00'); INSERT INTO `orders_order` (`id`, `order_number`, `status`, `expected_delivery_date`, `subtotal`, `discount_amount`, `grand_total`, `advance_paid`, `balance_amount`, `payment_mode`, `remarks`, `created_at`, `updated_at`, `created_by_id`, `customer_id`, `order_date`, `payment_status`, `total_paid`) VALUES ('11', 'DC-2026-000011', 'ready_for_pickup', '2026-07-13', '400.00', '0.00', '400.00', '170.00', '230.00', 'upi', '', '2026-07-13 12:09:42.000000', '2026-07-13 12:13:25.000000', '1', '13', '2026-07-13', 'partially_paid', '170.00'); INSERT INTO `orders_order` (`id`, `order_number`, `status`, `expected_delivery_date`, `subtotal`, `discount_amount`, `grand_total`, `advance_paid`, `balance_amount`, `payment_mode`, `remarks`, `created_at`, `updated_at`, `created_by_id`, `customer_id`, `order_date`, `payment_status`, `total_paid`) VALUES ('12', 'DC-2026-000012', 'in_process', '2026-07-13', '3150.00', '360.00', '2790.00', '2560.00', '230.00', 'pending', '', '2026-07-13 12:18:36.000000', '2026-07-13 12:20:22.000000', '1', '14', '2026-07-13', 'partially_paid', '2560.00'); -- Table structure for table `orders_orderitem` DROP TABLE IF EXISTS `orders_orderitem`; CREATE TABLE `orders_orderitem` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `quantity` int(10) 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(20) NOT NULL, `order_id` bigint(20) 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=88 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `orders_orderitem` INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('11', '1', '900.00', '900.00', '1', '4', '3'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('12', '1', '450.00', '450.00', '1', '18', '3'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('13', '1', '175.00', '175.00', '1', '14', '4'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('14', '2', '85.00', '170.00', '1', '3', '2'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('15', '2', '200.00', '400.00', '1', '14', '2'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('25', '2', '95.00', '190.00', '1', '1', '1'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('26', '1', '150.00', '150.00', '1', '19', '1'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('35', '1', '100.00', '100.00', '1', '16', '7'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('36', '1', '75.00', '75.00', '1', '3', '7'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('37', '1', '200.00', '200.00', '1', '2', '7'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('38', '4', '120.00', '480.00', '1', '1', '7'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('53', '1', '115.00', '115.00', '1', '1', '6'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('54', '1', '90.00', '90.00', '1', '8', '6'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('65', '1', '550.00', '550.00', '1', '6', '9'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('66', '1', '500.00', '500.00', '1', '18', '9'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('67', '4', '100.00', '400.00', '1', '16', '9'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('68', '4', '120.00', '480.00', '1', '1', '9'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('69', '3', '200.00', '600.00', '1', '19', '9'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('73', '1', '75.00', '75.00', '1', '5', '8'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('74', '1', '175.00', '175.00', '1', '19', '8'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('75', '1', '75.00', '75.00', '1', '3', '8'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('77', '1', '450.00', '450.00', '1', '14', '10'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('78', '1', '500.00', '500.00', '1', '6', '5'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('79', '1', '200.00', '200.00', '1', '19', '5'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('80', '1', '150.00', '150.00', '1', '23', '5'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('83', '1', '230.00', '230.00', '1', '23', '11'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('84', '1', '170.00', '170.00', '1', '23', '11'); INSERT INTO `orders_orderitem` (`id`, `quantity`, `manual_price`, `line_total`, `price_override_confirmed`, `item_id`, `order_id`) VALUES ('87', '7', '450.00', '3150.00', '1', '6', '12'); -- Table structure for table `orders_orderphoto` DROP TABLE IF EXISTS `orders_orderphoto`; CREATE TABLE `orders_orderphoto` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `photo` varchar(100) NOT NULL, `photo_type` varchar(20) NOT NULL, `stage` varchar(20) NOT NULL, `notes` longtext NOT NULL, `uploaded_at` datetime(6) NOT NULL, `order_id` bigint(20) NOT NULL, `uploaded_by_id` bigint(20) 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 AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `orders_orderphoto` INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('1', 'orders/DC-2026-000006/after/20260707_213800.jpg', 'front', 'after_cleaning', '', '2026-07-07 21:53:35.000000', '6', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('2', 'orders/DC-2026-000006/after/20260707_214516.jpg', 'back', 'after_cleaning', '', '2026-07-07 21:53:35.000000', '6', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('3', 'orders/DC-2026-000007/before/20260707_213800.jpg', 'front', 'before_cleaning', '', '2026-07-07 22:36:24.000000', '7', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('4', 'orders/DC-2026-000007/before/20260707_214516.jpg', 'back', 'before_cleaning', '', '2026-07-07 22:36:24.000000', '7', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('5', 'orders/DC-2026-000007/after/20260707_223741.jpg', 'front', 'after_cleaning', '', '2026-07-07 22:39:58.000000', '7', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('6', 'orders/DC-2026-000007/after/20260707_223807.jpg', 'back', 'after_cleaning', '', '2026-07-07 22:39:58.000000', '7', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('7', 'orders/DC-2026-000006/before/20260707_213800_f0eadbc8.jpg', 'front', 'before_cleaning', '', '2026-07-07 22:56:28.000000', '6', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('8', 'orders/DC-2026-000006/before/20260707_214516_b30ebeae.jpg', 'stain', 'before_cleaning', '', '2026-07-07 22:56:28.000000', '6', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('9', 'orders/DC-2026-000008/before/20260707_213800_5034c773.jpg', 'front', 'before_cleaning', '', '2026-07-07 22:57:37.000000', '8', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('10', 'orders/DC-2026-000008/before/20260707_214516_bca10bef.jpg', 'stain', 'before_cleaning', '', '2026-07-07 22:57:37.000000', '8', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('11', 'orders/DC-2026-000008/after/20260707_223741_ff58ff79.jpg', 'front', 'after_cleaning', '', '2026-07-07 22:58:29.000000', '8', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('12', 'orders/DC-2026-000008/after/20260707_223807_5ae2b69f.jpg', 'stain', 'after_cleaning', '', '2026-07-07 22:58:29.000000', '8', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('13', 'orders/DC-2026-000006/before/20260707_213800_3c88321a.jpg', 'front', 'before_cleaning', '', '2026-07-09 09:39:00.000000', '6', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('14', 'orders/DC-2026-000006/before/20260707_214516_9adb696e.jpg', 'back', 'before_cleaning', '', '2026-07-09 09:39:00.000000', '6', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('15', 'orders/DC-2026-000006/after/20260707_223807_8ce6bb2f.jpg', 'back', 'after_cleaning', 'done', '2026-07-09 09:40:38.000000', '6', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('16', 'orders/DC-2026-000006/after/20260707_223741_025a9f46.jpg', 'front', 'after_cleaning', 'done', '2026-07-09 09:40:38.000000', '6', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('17', 'orders/DC-2026-000009/before/20260710_080649_f3e2067b.jpg', 'front', 'before_cleaning', '', '2026-07-09 22:39:50.000000', '9', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('18', 'orders/DC-2026-000009/before/20260710_080642_54334462.jpg', 'back', 'before_cleaning', '', '2026-07-09 22:39:50.000000', '9', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('19', 'orders/DC-2026-000009/after/20260710_081307_cabfd77d.jpg', 'front', 'after_cleaning', '', '2026-07-09 22:45:18.000000', '9', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('20', 'orders/DC-2026-000009/after/20260710_081313_3d901548.jpg', 'back', 'after_cleaning', '', '2026-07-09 22:45:18.000000', '9', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('21', 'orders/DC-2026-000010/before/20260713_124754_b4012b46.jpg', 'front', 'before_cleaning', '', '2026-07-13 03:26:25.000000', '10', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('22', 'orders/DC-2026-000010/after/20260713_124943_223daedc.jpg', 'front', 'after_cleaning', '', '2026-07-13 03:28:14.000000', '10', '1'); INSERT INTO `orders_orderphoto` (`id`, `photo`, `photo_type`, `stage`, `notes`, `uploaded_at`, `order_id`, `uploaded_by_id`) VALUES ('23', 'orders/DC-2026-000012/before/20260710_080649_ead2146b.jpg', 'front', 'before_cleaning', '', '2026-07-13 12:19:58.000000', '12', '1'); -- Table structure for table `payments_payment` DROP TABLE IF EXISTS `payments_payment`; CREATE TABLE `payments_payment` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `payment_number` varchar(20) NOT NULL, `amount_paid` decimal(12,2) NOT NULL, `payment_mode` varchar(20) NOT NULL, `payment_status` varchar(20) NOT NULL, `transaction_reference` varchar(100) NOT NULL, `payment_date` date NOT NULL, `notes` longtext 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(20) NOT NULL, `received_by_id` bigint(20) 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=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `payments_payment` INSERT INTO `payments_payment` (`id`, `payment_number`, `amount_paid`, `payment_mode`, `payment_status`, `transaction_reference`, `payment_date`, `notes`, `overpayment_confirmed`, `active`, `created_at`, `updated_at`, `order_id`, `received_by_id`) 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'); INSERT INTO `payments_payment` (`id`, `payment_number`, `amount_paid`, `payment_mode`, `payment_status`, `transaction_reference`, `payment_date`, `notes`, `overpayment_confirmed`, `active`, `created_at`, `updated_at`, `order_id`, `received_by_id`) VALUES ('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'); INSERT INTO `payments_payment` (`id`, `payment_number`, `amount_paid`, `payment_mode`, `payment_status`, `transaction_reference`, `payment_date`, `notes`, `overpayment_confirmed`, `active`, `created_at`, `updated_at`, `order_id`, `received_by_id`) VALUES ('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'); INSERT INTO `payments_payment` (`id`, `payment_number`, `amount_paid`, `payment_mode`, `payment_status`, `transaction_reference`, `payment_date`, `notes`, `overpayment_confirmed`, `active`, `created_at`, `updated_at`, `order_id`, `received_by_id`) VALUES ('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'); INSERT INTO `payments_payment` (`id`, `payment_number`, `amount_paid`, `payment_mode`, `payment_status`, `transaction_reference`, `payment_date`, `notes`, `overpayment_confirmed`, `active`, `created_at`, `updated_at`, `order_id`, `received_by_id`) VALUES ('5', 'PAY-2026-000005', '50.00', 'cash', 'paid', '', '2026-07-07', '', '0', '1', '2026-07-07 09:55:41.000000', '2026-07-07 09:55:41.000000', '6', '1'); INSERT INTO `payments_payment` (`id`, `payment_number`, `amount_paid`, `payment_mode`, `payment_status`, `transaction_reference`, `payment_date`, `notes`, `overpayment_confirmed`, `active`, `created_at`, `updated_at`, `order_id`, `received_by_id`) VALUES ('6', 'PAY-2026-000006', '315.00', 'cash', 'paid', 'rthty765', '2026-07-07', '', '0', '1', '2026-07-07 10:30:03.000000', '2026-07-07 10:30:03.000000', '1', '1'); INSERT INTO `payments_payment` (`id`, `payment_number`, `amount_paid`, `payment_mode`, `payment_status`, `transaction_reference`, `payment_date`, `notes`, `overpayment_confirmed`, `active`, `created_at`, `updated_at`, `order_id`, `received_by_id`) VALUES ('7', 'PAY-2026-000007', '1000.00', 'pending', 'paid', '', '2026-07-10', 'Advance at order creation', '0', '1', '2026-07-09 22:39:50.000000', '2026-07-09 22:39:50.000000', '9', '1'); INSERT INTO `payments_payment` (`id`, `payment_number`, `amount_paid`, `payment_mode`, `payment_status`, `transaction_reference`, `payment_date`, `notes`, `overpayment_confirmed`, `active`, `created_at`, `updated_at`, `order_id`, `received_by_id`) VALUES ('8', 'PAY-2026-000008', '1530.00', 'cash', 'paid', '5465jh', '2026-07-10', 'Dnoe', '0', '1', '2026-07-09 23:01:28.000000', '2026-07-09 23:01:28.000000', '9', '1'); INSERT INTO `payments_payment` (`id`, `payment_number`, `amount_paid`, `payment_mode`, `payment_status`, `transaction_reference`, `payment_date`, `notes`, `overpayment_confirmed`, `active`, `created_at`, `updated_at`, `order_id`, `received_by_id`) VALUES ('9', 'PAY-2026-000009', '100.00', 'cash', 'paid', '', '2026-07-13', 'Advance at order creation', '0', '1', '2026-07-13 03:26:25.000000', '2026-07-13 03:26:25.000000', '10', '1'); INSERT INTO `payments_payment` (`id`, `payment_number`, `amount_paid`, `payment_mode`, `payment_status`, `transaction_reference`, `payment_date`, `notes`, `overpayment_confirmed`, `active`, `created_at`, `updated_at`, `order_id`, `received_by_id`) VALUES ('10', 'PAY-2026-000010', '170.00', 'upi', 'paid', '', '2026-07-13', '', '0', '1', '2026-07-13 12:10:30.000000', '2026-07-13 12:11:07.000000', '11', '1'); INSERT INTO `payments_payment` (`id`, `payment_number`, `amount_paid`, `payment_mode`, `payment_status`, `transaction_reference`, `payment_date`, `notes`, `overpayment_confirmed`, `active`, `created_at`, `updated_at`, `order_id`, `received_by_id`) VALUES ('11', 'PAY-2026-000011', '2560.00', 'pending', 'paid', '', '2026-07-13', 'Advance at order creation', '0', '1', '2026-07-13 12:18:36.000000', '2026-07-13 12:18:36.000000', '12', '1'); -- Table structure for table `shop_settings_shopprofile` DROP TABLE IF EXISTS `shop_settings_shopprofile`; CREATE TABLE `shop_settings_shopprofile` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `shop_name` varchar(200) NOT NULL, `owner_name` varchar(200) NOT NULL, `phone` varchar(20) NOT NULL, `alternate_phone` varchar(20) NOT NULL, `email` varchar(254) NOT NULL, `address` longtext NOT NULL, `city` varchar(100) NOT NULL, `gst_number` varchar(20) NOT NULL, `invoice_terms` longtext NOT NULL, `client_logo` varchar(255) NOT NULL DEFAULT '', `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` (`id`, `shop_name`, `owner_name`, `phone`, `alternate_phone`, `email`, `address`, `city`, `gst_number`, `invoice_terms`, `client_logo`, `updated_at`) 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', '', 'Terms & Conditions\r\nCustomer Responsibility: Please ensure that all pockets are emptied before handing over garments. We are not responsible for any money, jewellery, documents, keys, electronic devices, or other valuables left inside garments.\r\nCondition of Garments: Please inform us of any existing damage such as tears, holes, loose stitching, missing buttons, embellishments, or weak fabric at the time of submission. Garments that are old, worn, delicate, or already damaged may be more susceptible to further wear during the cleaning process. We will exercise reasonable care but cannot guarantee against deterioration resulting from the garment\'s pre-existing condition.\r\nStain Removal & Chemical Treatment: Stain removal is performed on a best-effort basis and cannot be guaranteed. Chemical cleaning or special stain treatment will be carried out only with the customer\'s consent. We are not responsible for unavoidable colour fading, fabric shrinkage, texture changes, or damage resulting from the inherent condition or characteristics of the fabric during such treatment.\r\nDelivery Schedule: While every effort is made to complete orders by the expected delivery date, delays may occur due to machine breakdowns, labour issues, power failures, supplier delays, or other circumstances beyond our reasonable control.\r\nCollection of Garments: Customers are requested to produce the invoice or provide their registered mobile number while collecting garments. Orders not collected within 40 days from the date they are marked Ready for Delivery shall be kept at the customer\'s risk. No claims for loss or damage will be entertained after this period.\r\nLoss or Damage: In the unlikely event of loss or damage caused solely due to our negligence, our liability shall be limited to one-third (1/3) of the current value of the garment, subject to the customer submitting:\r\nA written claim,\r\nProof of ownership or purchase (where available), and\r\nSupporting proof of the garment\'s value.\r\nInvoice: This invoice serves as the official receipt for the order. Please preserve it until your garments have been collected.\r\nPhoto Documentation: Garments may be photographed at the time of acceptance for condition recording and quality verification. These photographs are used solely for service documentation and dispute resolution.', 'images/client_logo.png', '2026-07-07 10:45:44.000000'); SET FOREIGN_KEY_CHECKS=1;