INSERT INTO `tbl_products` (`id`, `manage_stock`, `is_catalog`, `is_varient`, `parent_id`, `seller_id`, `product_owner_id`, `product_copy_id`, `is_varient_title`, `filter_varient_id`, `overwrite_data`, `attr_name`, `product_type`, `sale_type`, `attribute_unit`, `no_of_pieces`, `quantity`, `rating_num`, `rating_total`, `rating_user`, `title`, `color_code`, `hsn`, `slug`, `added_by`, `main_category`, `category`, `short_description`, `description`, `meta_keywords`, `meta_discription`, `Istamplate`, `sub_category`, `num_of_imgs`, `mrp`, `sale_price`, `purchase_price`, `add_timestamp`, `featured`, `tag`, `grade`, `status`, `front_image`, `brand`, `current_stock`, `product_code`, `unit`, `sku_code`, `sku_org_code`, `additional_fields`, `number_of_view`, `background`, `discount`, `discount_type`, `tax`, `tax_type`, `color`, `options`, `low_image`, `high_image`, `main_image`, `image`, `download`, `download_name`, `deal`, `num_of_downloads`, `update_time`, `requirements`, `logo`, `video`, `minimum_stock`, `maximum_stock`, `last_viewed`, `is_active`, `is_active_web`, `company_id`, `outlet_id`, `user_id`, `admin_id`, `attributes`, `IsDeleted`, `opening_stock_value`, `opening_stock_weight`, `shipping_cost`, `shipping_height`, `shipping_width`, `shipping_weight`, `shipping_dimensions`, `shipping_by`, `exipry_days`, `serves`, `promotion`) VALUES
(136, 0, 0, 3, 0, 0, 0, 135, 0, 0, 0, NULL, '168', 1, NULL, '0', 1.00, 0, 0, NULL, 'Men Slim Mid Rise Black Jeans', '', '', 'men-slim-mid-rise-black-jeans', NULL, '90', '3', '<div class=\"row\" style=\"margin: 0px; padding: 0px; flex-direction: row; width: 667.512px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"col col-3-12 _2H87wv\" style=\"margin: 0px; padding: 0px 0px 24px; width: 166.873px; display: inline-block; vertical-align: top; color: rgb(135, 135, 135);\">Style Code&nbsp; &nbsp; &nbsp;&nbsp;<span style=\"color: rgb(33, 33, 33);\">Black-Cargo-X01-</span></div></div><div class=\"row\" style=\"margin: 0px; padding: 0px; flex-direction: row; width: 667.512px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"col col-3-12 _2H87wv\" style=\"margin: 0px; padding: 0px 0px 24px; width: 166.873px; display: inline-block; vertical-align: top; color: rgb(135, 135, 135);\">Ideal For&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<span style=\"color: rgb(33, 33, 33);\">Men</span></div></div><div class=\"row\" style=\"margin: 0px; padding: 0px; flex-direction: row; width: 667.512px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"col col-3-12 _2H87wv\" style=\"margin: 0px; padding: 0px 0px 24px; width: 166.873px; display: inline-block; vertical-align: top; color: rgb(135, 135, 135);\">Suitable For&nbsp; &nbsp; &nbsp;<span style=\"color: rgb(33, 33, 33);\">Western Wear</span></div></div><div class=\"row\" style=\"margin: 0px; padding: 0px; flex-direction: row; width: 667.512px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"col col-3-12 _2H87wv\" style=\"margin: 0px; padding: 0px 0px 24px; width: 166.873px; display: inline-block; vertical-align: top; color: rgb(135, 135, 135);\">Pack Of&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<span style=\"color: rgb(33, 33, 33);\">1</span></div></div><div class=\"row\" style=\"margin: 0px; padding: 0px; flex-direction: row; width: 667.512px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"col col-3-12 _2H87wv\" style=\"margin: 0px; padding: 0px 0px 24px; width: 166.873px; display: inline-block; vertical-align: top; color: rgb(135, 135, 135);\">Pocket Type&nbsp; &nbsp; &nbsp;&nbsp;<span style=\"color: rgb(33, 33, 33);\">Curved Pocket</span></div></div><div class=\"row\" style=\"margin: 0px; padding: 0px; flex-direction: row; width: 667.512px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"col col-3-12 _2H87wv\" style=\"margin: 0px; padding: 0px 0px 24px; width: 166.873px; display: inline-block; vertical-align: top; color: rgb(135, 135, 135);\">Pattern&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<span style=\"color: rgb(33, 33, 33);\">Solid</span></div></div><div class=\"row\" style=\"margin: 0px; padding: 0px; flex-direction: row; width: 667.512px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"col col-3-12 _2H87wv\" style=\"margin: 0px; padding: 0px 0px 24px; width: 166.873px; display: inline-block; vertical-align: top; color: rgb(135, 135, 135);\">Reversible&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: rgb(33, 33, 33);\">No</span></div></div><div class=\"row\" style=\"margin: 0px; padding: 0px; flex-direction: row; width: 667.512px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"col col-3-12 _2H87wv\" style=\"margin: 0px; padding: 0px 0px 24px; width: 166.873px; display: inline-block; vertical-align: top; color: rgb(135, 135, 135);\">Sales Package&nbsp;&nbsp;<span style=\"color: rgb(33, 33, 33);\">1</span></div></div>', '<div class=\"row\" style=\"margin: 0px; padding: 0px; flex-direction: row; width: 667.512px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"col col-3-12 _2H87wv\" style=\"margin: 0px; padding: 0px 0px 24px; width: 166.873px; display: inline-block; vertical-align: top; color: rgb(135, 135, 135);\"><div class=\"row\" style=\"flex-direction: row; margin: 0px; padding: 0px; width: 667.512px; color: rgb(33, 33, 33);\"><div class=\"col col-3-12 _2H87wv\" style=\"width: 166.873px; padding: 0px 0px 24px; margin: 0px; display: inline-block; vertical-align: top; color: rgb(135, 135, 135);\">Style Code&nbsp; &nbsp; &nbsp;&nbsp;<span style=\"color: rgb(33, 33, 33);\">Black-Cargo-X01-</span></div></div><div class=\"row\" style=\"flex-direction: row; margin: 0px; padding: 0px; width: 667.512px; color: rgb(33, 33, 33);\"><div class=\"col col-3-12 _2H87wv\" style=\"width: 166.873px; padding: 0px 0px 24px; margin: 0px; display: inline-block; vertical-align: top; color: rgb(135, 135, 135);\">Ideal For&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<span style=\"color: rgb(33, 33, 33);\">Men</span></div></div><div class=\"row\" style=\"flex-direction: row; margin: 0px; padding: 0px; width: 667.512px; color: rgb(33, 33, 33);\"><div class=\"col col-3-12 _2H87wv\" style=\"width: 166.873px; padding: 0px 0px 24px; margin: 0px; display: inline-block; vertical-align: top; color: rgb(135, 135, 135);\">Suitable For&nbsp; &nbsp; &nbsp;<span style=\"color: rgb(33, 33, 33);\">Western Wear</span></div></div><div class=\"row\" style=\"flex-direction: row; margin: 0px; padding: 0px; width: 667.512px; color: rgb(33, 33, 33);\"><div class=\"col col-3-12 _2H87wv\" style=\"width: 166.873px; padding: 0px 0px 24px; margin: 0px; display: inline-block; vertical-align: top; color: rgb(135, 135, 135);\">Pack Of&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<span style=\"color: rgb(33, 33, 33);\">1</span></div></div><div class=\"row\" style=\"flex-direction: row; margin: 0px; padding: 0px; width: 667.512px; color: rgb(33, 33, 33);\"><div class=\"col col-3-12 _2H87wv\" style=\"width: 166.873px; padding: 0px 0px 24px; margin: 0px; display: inline-block; vertical-align: top; color: rgb(135, 135, 135);\">Pocket Type&nbsp; &nbsp; &nbsp;&nbsp;<span style=\"color: rgb(33, 33, 33);\">Curved Pocket</span></div></div><div class=\"row\" style=\"flex-direction: row; margin: 0px; padding: 0px; width: 667.512px; color: rgb(33, 33, 33);\"><div class=\"col col-3-12 _2H87wv\" style=\"width: 166.873px; padding: 0px 0px 24px; margin: 0px; display: inline-block; vertical-align: top; color: rgb(135, 135, 135);\">Pattern&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<span style=\"color: rgb(33, 33, 33);\">Solid</span></div></div><div class=\"row\" style=\"flex-direction: row; margin: 0px; padding: 0px; width: 667.512px; color: rgb(33, 33, 33);\"><div class=\"col col-3-12 _2H87wv\" style=\"width: 166.873px; padding: 0px 0px 24px; margin: 0px; display: inline-block; vertical-align: top; color: rgb(135, 135, 135);\">Reversible&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: rgb(33, 33, 33);\">No</span></div></div><div class=\"row\" style=\"flex-direction: row; margin: 0px; padding: 0px; width: 667.512px; color: rgb(33, 33, 33);\"><div class=\"col col-3-12 _2H87wv\" style=\"width: 166.873px; padding: 0px 0px 24px; margin: 0px; display: inline-block; vertical-align: top; color: rgb(135, 135, 135);\">Sales Package&nbsp;&nbsp;<span style=\"color: rgb(33, 33, 33);\">1</span></div></div></div></div>', '', '', 0, '155', NULL, 4000, 3000.00, 0.00, '05-01-2024 18:34:06', NULL, NULL, NULL, NULL, NULL, NULL, 0, '', NULL, '4', NULL, NULL, 0, NULL, '25', '1', '18', '1', NULL, NULL, 'pro100_1003429ff2e87c9f70cb2f7238a8167e736.webp', 'pro1000_10009fa2b4fe9f7add792a3a695149630ab1.webp', '0', 'pro300_300ee29bd9b83fc6d429f1335ec7eb8a5e9.webp', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, 0, NULL, 1, 1, 3, 6, 3, 1, 'Men Fashion', 0, '0', 0.00, 0, 0, 0, 0, 0, 1, '0', NULL, NULL),
(184, 0, 0, 1, 180, 1, 0, 173, 0, 0, 0, NULL, '304', 1, NULL, '', 1.00, 0, 0, NULL, 'Sport shoe 06012024 black', '#030202', NULL, 'sport-shoe-06012024-black', NULL, '90', '1', '<div class=\"_3Z0lU8\" style=\"margin: 16px 0px 0px; padding: 0px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"rd9nIL\" style=\"margin: 0px; padding: 0px; font-size: 16px;\">Short Description</div></div><div class=\"_3TT44I\" style=\"margin: 0px; padding: 0px; line-height: 1.43; color: rgb(33, 33, 33); font-size: 14px; position: relative; font-family: Roboto, Arial, sans-serif;\"><div class=\"WT_FyS\" style=\"margin: 0px; padding: 0px;\"><div class=\"XUp0WS\" style=\"margin: 0px; padding: 0px;\"><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on Bank of Baroda Credit Card EMI Txns, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on IDFC FIRST Bank Credit Card EMI Transactions, up to ₹1,750 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">8% off on Yes Bank Credit Card EMI Transactions, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span></div></div></div>', '<div class=\"_3Z0lU8\" style=\"margin: 16px 0px 0px; padding: 0px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"rd9nIL\" style=\"margin: 0px; padding: 0px; font-size: 16px;\">Description</div></div><div class=\"_3TT44I\" style=\"margin: 0px; padding: 0px; line-height: 1.43; color: rgb(33, 33, 33); font-size: 14px; position: relative; font-family: Roboto, Arial, sans-serif;\"><div class=\"WT_FyS\" style=\"margin: 0px; padding: 0px;\"><div class=\"XUp0WS\" style=\"margin: 0px; padding: 0px;\"><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on Bank of Baroda Credit Card EMI Txns, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on IDFC FIRST Bank Credit Card EMI Transactions, up to ₹1,750 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">8% off on Yes Bank Credit Card EMI Transactions, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span></div></div></div>', NULL, NULL, 0, '303', NULL, 1800, 650.00, 300.00, '06-01-2024 13:32:11', NULL, NULL, NULL, NULL, NULL, NULL, 0, 'DFLKDSJ', NULL, '4', NULL, NULL, 0, NULL, '63.89', '1', '0.00', '', NULL, NULL, 'product_1704527363_ee28c67ad0f1e03f1f73.webp', 'product_1704527363_ee28c67ad0f1e03f1f73.webp', '0', 'product_1704527363_ee28c67ad0f1e03f1f73.webp', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 3, 6, 3, 1, '', 0, NULL, 0.00, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL),
(185, 0, 0, 1, 180, 1, 0, 174, 0, 0, 0, NULL, '304', 1, NULL, '', 1.00, 0, 0, NULL, 'Sport shoe 06012024 black', '#030202', NULL, 'sport-shoe-06012024-black', NULL, '90', '1', '<div class=\"_3Z0lU8\" style=\"margin: 16px 0px 0px; padding: 0px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"rd9nIL\" style=\"margin: 0px; padding: 0px; font-size: 16px;\">Short Description</div></div><div class=\"_3TT44I\" style=\"margin: 0px; padding: 0px; line-height: 1.43; color: rgb(33, 33, 33); font-size: 14px; position: relative; font-family: Roboto, Arial, sans-serif;\"><div class=\"WT_FyS\" style=\"margin: 0px; padding: 0px;\"><div class=\"XUp0WS\" style=\"margin: 0px; padding: 0px;\"><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on Bank of Baroda Credit Card EMI Txns, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on IDFC FIRST Bank Credit Card EMI Transactions, up to ₹1,750 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">8% off on Yes Bank Credit Card EMI Transactions, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span></div></div></div>', '<div class=\"_3Z0lU8\" style=\"margin: 16px 0px 0px; padding: 0px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"rd9nIL\" style=\"margin: 0px; padding: 0px; font-size: 16px;\">Description</div></div><div class=\"_3TT44I\" style=\"margin: 0px; padding: 0px; line-height: 1.43; color: rgb(33, 33, 33); font-size: 14px; position: relative; font-family: Roboto, Arial, sans-serif;\"><div class=\"WT_FyS\" style=\"margin: 0px; padding: 0px;\"><div class=\"XUp0WS\" style=\"margin: 0px; padding: 0px;\"><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on Bank of Baroda Credit Card EMI Txns, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on IDFC FIRST Bank Credit Card EMI Transactions, up to ₹1,750 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">8% off on Yes Bank Credit Card EMI Transactions, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span></div></div></div>', NULL, NULL, 0, '303', NULL, 1800, 650.00, 300.00, '06-01-2024 13:32:11', NULL, NULL, NULL, NULL, NULL, NULL, 0, 'DFLKDSJ', NULL, '4', NULL, NULL, 0, NULL, '63.89', '1', '0.00', '', NULL, NULL, 'product_1704527363_ee28c67ad0f1e03f1f73.webp', 'product_1704527363_ee28c67ad0f1e03f1f73.webp', '0', 'product_1704527363_ee28c67ad0f1e03f1f73.webp', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 3, 6, 3, 1, '', 0, NULL, 0.00, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL),
(186, 0, 0, 1, 180, 1, 0, 175, 0, 0, 0, NULL, '304', 1, NULL, '', 1.00, 0, 0, NULL, 'Sport shoe 06012024 black', '#030202', NULL, 'sport-shoe-06012024-black', NULL, '90', '1', '<div class=\"_3Z0lU8\" style=\"margin: 16px 0px 0px; padding: 0px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"rd9nIL\" style=\"margin: 0px; padding: 0px; font-size: 16px;\">Short Description</div></div><div class=\"_3TT44I\" style=\"margin: 0px; padding: 0px; line-height: 1.43; color: rgb(33, 33, 33); font-size: 14px; position: relative; font-family: Roboto, Arial, sans-serif;\"><div class=\"WT_FyS\" style=\"margin: 0px; padding: 0px;\"><div class=\"XUp0WS\" style=\"margin: 0px; padding: 0px;\"><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on Bank of Baroda Credit Card EMI Txns, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on IDFC FIRST Bank Credit Card EMI Transactions, up to ₹1,750 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">8% off on Yes Bank Credit Card EMI Transactions, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span></div></div></div>', '<div class=\"_3Z0lU8\" style=\"margin: 16px 0px 0px; padding: 0px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"rd9nIL\" style=\"margin: 0px; padding: 0px; font-size: 16px;\">Description</div></div><div class=\"_3TT44I\" style=\"margin: 0px; padding: 0px; line-height: 1.43; color: rgb(33, 33, 33); font-size: 14px; position: relative; font-family: Roboto, Arial, sans-serif;\"><div class=\"WT_FyS\" style=\"margin: 0px; padding: 0px;\"><div class=\"XUp0WS\" style=\"margin: 0px; padding: 0px;\"><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on Bank of Baroda Credit Card EMI Txns, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on IDFC FIRST Bank Credit Card EMI Transactions, up to ₹1,750 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">8% off on Yes Bank Credit Card EMI Transactions, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span></div></div></div>', NULL, NULL, 0, '303', NULL, 1800, 650.00, 300.00, '06-01-2024 13:32:12', NULL, NULL, NULL, NULL, NULL, NULL, 0, 'DFLKDSJ', NULL, '4', NULL, NULL, 0, NULL, '63.89', '1', '0.00', '', NULL, NULL, 'product_1704527363_ee28c67ad0f1e03f1f73.webp', 'product_1704527363_ee28c67ad0f1e03f1f73.webp', '0', 'product_1704527363_ee28c67ad0f1e03f1f73.webp', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 3, 6, 3, 1, '', 0, NULL, 0.00, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL),
(187, 0, 0, 1, 180, 1, 0, 176, 0, 0, 0, NULL, '304', 1, NULL, '', 1.00, 0, 0, NULL, 'Sport shoe 06012024 white', '#eeeded', NULL, 'sport-shoe-06012024-white', NULL, '90', '1', '<div class=\"_3Z0lU8\" style=\"margin: 16px 0px 0px; padding: 0px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"rd9nIL\" style=\"margin: 0px; padding: 0px; font-size: 16px;\">Short Description</div></div><div class=\"_3TT44I\" style=\"margin: 0px; padding: 0px; line-height: 1.43; color: rgb(33, 33, 33); font-size: 14px; position: relative; font-family: Roboto, Arial, sans-serif;\"><div class=\"WT_FyS\" style=\"margin: 0px; padding: 0px;\"><div class=\"XUp0WS\" style=\"margin: 0px; padding: 0px;\"><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on Bank of Baroda Credit Card EMI Txns, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on IDFC FIRST Bank Credit Card EMI Transactions, up to ₹1,750 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">8% off on Yes Bank Credit Card EMI Transactions, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span></div></div></div>', '<div class=\"_3Z0lU8\" style=\"margin: 16px 0px 0px; padding: 0px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"rd9nIL\" style=\"margin: 0px; padding: 0px; font-size: 16px;\">Description</div></div><div class=\"_3TT44I\" style=\"margin: 0px; padding: 0px; line-height: 1.43; color: rgb(33, 33, 33); font-size: 14px; position: relative; font-family: Roboto, Arial, sans-serif;\"><div class=\"WT_FyS\" style=\"margin: 0px; padding: 0px;\"><div class=\"XUp0WS\" style=\"margin: 0px; padding: 0px;\"><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on Bank of Baroda Credit Card EMI Txns, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on IDFC FIRST Bank Credit Card EMI Transactions, up to ₹1,750 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">8% off on Yes Bank Credit Card EMI Transactions, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span></div></div></div>', NULL, NULL, 0, '303', NULL, 2200, 700.00, 400.00, '06-01-2024 13:32:12', NULL, NULL, NULL, NULL, NULL, NULL, 0, 'LDSFLKD', NULL, '4', NULL, NULL, 0, NULL, '68.18', '1', '0.00', '', NULL, NULL, 'product_1704527511_2694d0caf4d6b150f907.webp', 'product_1704527511_2694d0caf4d6b150f907.webp', '0', 'product_1704527511_2694d0caf4d6b150f907.webp', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 3, 6, 3, 1, '', 0, NULL, 0.00, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL);
INSERT INTO `tbl_products` (`id`, `manage_stock`, `is_catalog`, `is_varient`, `parent_id`, `seller_id`, `product_owner_id`, `product_copy_id`, `is_varient_title`, `filter_varient_id`, `overwrite_data`, `attr_name`, `product_type`, `sale_type`, `attribute_unit`, `no_of_pieces`, `quantity`, `rating_num`, `rating_total`, `rating_user`, `title`, `color_code`, `hsn`, `slug`, `added_by`, `main_category`, `category`, `short_description`, `description`, `meta_keywords`, `meta_discription`, `Istamplate`, `sub_category`, `num_of_imgs`, `mrp`, `sale_price`, `purchase_price`, `add_timestamp`, `featured`, `tag`, `grade`, `status`, `front_image`, `brand`, `current_stock`, `product_code`, `unit`, `sku_code`, `sku_org_code`, `additional_fields`, `number_of_view`, `background`, `discount`, `discount_type`, `tax`, `tax_type`, `color`, `options`, `low_image`, `high_image`, `main_image`, `image`, `download`, `download_name`, `deal`, `num_of_downloads`, `update_time`, `requirements`, `logo`, `video`, `minimum_stock`, `maximum_stock`, `last_viewed`, `is_active`, `is_active_web`, `company_id`, `outlet_id`, `user_id`, `admin_id`, `attributes`, `IsDeleted`, `opening_stock_value`, `opening_stock_weight`, `shipping_cost`, `shipping_height`, `shipping_width`, `shipping_weight`, `shipping_dimensions`, `shipping_by`, `exipry_days`, `serves`, `promotion`) VALUES
(188, 0, 0, 1, 180, 1, 0, 177, 0, 0, 0, NULL, '304', 1, NULL, '', 1.00, 0, 0, NULL, 'Sport shoe 06012024 white', '#eeeded', NULL, 'sport-shoe-06012024-white', NULL, '90', '1', '<div class=\"_3Z0lU8\" style=\"margin: 16px 0px 0px; padding: 0px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"rd9nIL\" style=\"margin: 0px; padding: 0px; font-size: 16px;\">Short Description</div></div><div class=\"_3TT44I\" style=\"margin: 0px; padding: 0px; line-height: 1.43; color: rgb(33, 33, 33); font-size: 14px; position: relative; font-family: Roboto, Arial, sans-serif;\"><div class=\"WT_FyS\" style=\"margin: 0px; padding: 0px;\"><div class=\"XUp0WS\" style=\"margin: 0px; padding: 0px;\"><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on Bank of Baroda Credit Card EMI Txns, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on IDFC FIRST Bank Credit Card EMI Transactions, up to ₹1,750 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">8% off on Yes Bank Credit Card EMI Transactions, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span></div></div></div>', '<div class=\"_3Z0lU8\" style=\"margin: 16px 0px 0px; padding: 0px; color: rgb(33, 33, 33); font-family: Roboto, Arial, sans-serif; font-size: 14px;\"><div class=\"rd9nIL\" style=\"margin: 0px; padding: 0px; font-size: 16px;\">Description</div></div><div class=\"_3TT44I\" style=\"margin: 0px; padding: 0px; line-height: 1.43; color: rgb(33, 33, 33); font-size: 14px; position: relative; font-family: Roboto, Arial, sans-serif;\"><div class=\"WT_FyS\" style=\"margin: 0px; padding: 0px;\"><div class=\"XUp0WS\" style=\"margin: 0px; padding: 0px;\"><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on Bank of Baroda Credit Card EMI Txns, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">10% off on IDFC FIRST Bank Credit Card EMI Transactions, up to ₹1,750 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span><span class=\"_3j4Zjq row\" style=\"margin: 12px 0px 0px; padding: 0px; flex-direction: row; width: 787.203px;\"><img src=\"https://rukminim2.flixcart.com/www/36/36/promos/06/09/2016/c22c9fc4-0555-4460-8401-bf5c28d7ba29.png?q=90\" width=\"18\" height=\"18\" class=\"_3HLfAg\" style=\"margin: 0px 10px 0px 0px; padding: 0px; color: inherit; border-width: initial; border-color: initial; border-image: initial; outline: none;\"><li class=\"_16eBzU col\" style=\"margin: -2px 0px 0px; padding: 0px; list-style: none; width: 739.969px; display: inline-block; vertical-align: top;\"><span class=\"u8dYXW\" style=\"margin: 0px; padding: 0px 4px 0px 0px;\">Bank Offer</span><span style=\"margin: 0px; padding: 0px;\">8% off on Yes Bank Credit Card EMI Transactions, up to ₹2,000 on orders of ₹10,000 and above</span><div class=\"Bv11UC _1qNw3R\" style=\"margin: 0px; padding: 0px; display: inline-block; position: relative;\"><span class=\"fGhUR2\" style=\"margin: 0px 0px 0px 5px; padding: 0px; color: rgb(40, 116, 240); display: inline-block; cursor: pointer;\">T&amp;C</span></div></li></span></div></div></div>', NULL, NULL, 0, '303', NULL, 2200, 700.00, 400.00, '06-01-2024 13:32:12', NULL, NULL, NULL, NULL, NULL, NULL, 0, 'LDSFLKD', NULL, '4', NULL, NULL, 0, NULL, '68.18', '1', '0.00', '', NULL, NULL, 'product_1704527511_2694d0caf4d6b150f907.webp', 'product_1704527511_2694d0caf4d6b150f907.webp', '0', 'product_1704527511_2694d0caf4d6b150f907.webp', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 3, 6, 3, 1, '', 0, NULL, 0.00, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_products_05_dec_22`
--

CREATE TABLE `tbl_products_05_dec_22` (
  `id` int(11) NOT NULL,
  `manage_stock` int(11) NOT NULL DEFAULT '0' COMMENT '0=product wise,1=attribute wise',
  `attr_name` varchar(50) DEFAULT NULL,
  `product_type` varchar(255) NOT NULL COMMENT '1:normal,2:attribute',
  `sale_type` int(1) NOT NULL DEFAULT '1' COMMENT '1:quantity;2:weight;',
  `attribute_unit` text,
  `no_of_pieces` varchar(10) NOT NULL,
  `quantity` decimal(11,2) NOT NULL,
  `rating_num` int(11) NOT NULL DEFAULT '0',
  `rating_total` int(11) NOT NULL DEFAULT '0',
  `rating_user` longtext,
  `title` longtext NOT NULL,
  `hsn` varchar(50) DEFAULT NULL,
  `slug` varchar(300) DEFAULT NULL,
  `added_by` varchar(30) DEFAULT NULL,
  `category` text NOT NULL,
  `short_description` text,
  `description` longtext NOT NULL,
  `meta_keywords` text,
  `meta_discription` text,
  `Istamplate` int(11) NOT NULL DEFAULT '0',
  `sub_category` text,
  `num_of_imgs` varchar(100) DEFAULT NULL,
  `sale_price` decimal(20,2) NOT NULL DEFAULT '0.00',
  `purchase_price` decimal(20,2) NOT NULL DEFAULT '0.00',
  `shipping_cost` varchar(20) NOT NULL DEFAULT '0.00',
  `add_timestamp` longtext,
  `featured` longtext,
  `tag` longtext,
  `grade` text,
  `status` longtext,
  `front_image` longtext,
  `brand` int(11) DEFAULT NULL,
  `current_stock` int(11) DEFAULT '0',
  `product_code` varchar(255) DEFAULT NULL,
  `unit` longtext,
  `sku_code` varchar(50) DEFAULT NULL,
  `additional_fields` longtext,
  `number_of_view` int(11) NOT NULL DEFAULT '0',
  `background` longtext,
  `discount` varchar(20) NOT NULL DEFAULT '0.00',
  `discount_type` longtext NOT NULL,
  `tax` varchar(20) NOT NULL DEFAULT '0.00',
  `tax_type` longtext NOT NULL,
  `color` longtext,
  `options` longtext,
  `main_image` varchar(100) NOT NULL DEFAULT '0',
  `image` varchar(300) DEFAULT NULL,
  `download` varchar(200) DEFAULT NULL,
  `download_name` varchar(200) DEFAULT NULL,
  `deal` varchar(10) DEFAULT NULL,
  `num_of_downloads` int(11) NOT NULL DEFAULT '0',
  `update_time` longtext,
  `requirements` longtext,
  `logo` longtext,
  `video` longtext,
  `minimum_stock` int(11) DEFAULT NULL,
  `maximum_stock` int(11) DEFAULT NULL,
  `last_viewed` int(200) DEFAULT NULL,
  `is_active` int(11) NOT NULL DEFAULT '1',
  `company_id` int(5) DEFAULT '5',
  `outlet_id` int(6) NOT NULL DEFAULT '6',
  `user_id` int(1) NOT NULL DEFAULT '1',
  `attributes` text NOT NULL,
  `IsDeleted` int(11) NOT NULL DEFAULT '0',
  `opening_stock_value` varchar(255) DEFAULT NULL,
  `opening_stock_weight` decimal(11,2) NOT NULL,
  `exipry_days` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_products_05_dec_22`
--

INSERT INTO `tbl_products_05_dec_22` (`id`, `manage_stock`, `attr_name`, `product_type`, `sale_type`, `attribute_unit`, `no_of_pieces`, `quantity`, `rating_num`, `rating_total`, `rating_user`, `title`, `hsn`, `slug`, `added_by`, `category`, `short_description`, `description`, `meta_keywords`, `meta_discription`, `Istamplate`, `sub_category`, `num_of_imgs`, `sale_price`, `purchase_price`, `shipping_cost`, `add_timestamp`, `featured`, `tag`, `grade`, `status`, `front_image`, `brand`, `current_stock`, `product_code`, `unit`, `sku_code`, `additional_fields`, `number_of_view`, `background`, `discount`, `discount_type`, `tax`, `tax_type`, `color`, `options`, `main_image`, `image`, `download`, `download_name`, `deal`, `num_of_downloads`, `update_time`, `requirements`, `logo`, `video`, `minimum_stock`, `maximum_stock`, `last_viewed`, `is_active`, `company_id`, `outlet_id`, `user_id`, `attributes`, `IsDeleted`, `opening_stock_value`, `opening_stock_weight`, `exipry_days`) VALUES
(1, 0, NULL, '35', 1, NULL, '10', 50.00, 0, 0, NULL, 'test product 1', '1234', 'test', NULL, '1', 'sort description for test', 'test description', 'a,b,c', 'a,b', 0, NULL, NULL, 50.00, 300.00, '10', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, '2345', NULL, '3', NULL, 0, NULL, '0.00', '', '0.00', 'normal', NULL, NULL, '0', 'product_1670233779_940c3af147fe9747bc05.jpg', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 20, 100, NULL, 1, 5, 6, 1, '', 0, '2500', 0.00, '15');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_states`
--

CREATE TABLE `tbl_states` (
  `id` int(10) NOT NULL,
  `state` varchar(50) NOT NULL,
  `code` int(11) DEFAULT NULL,
  `is_active` varchar(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_states`
--

INSERT INTO `tbl_states` (`id`, `state`, `code`, `is_active`) VALUES
(1, 'JAMMU AND KASHMIR', 1, '1'),
(2, 'HIMACHAL PRADESH', 2, '1'),
(3, 'PUNJAB', 3, '1'),
(4, 'CHANDIGARH', 4, '1'),
(5, 'UTTARAKHAND', 5, '1'),
(6, 'HARYANA', 6, '1'),
(7, 'DELHI', 7, '1'),
(8, 'RAJASTHAN', 8, '1'),
(9, 'UTTAR PRADESH', 9, '1'),
(10, 'BIHAR', 10, '1'),
(11, 'SIKKIM', 11, '1'),
(12, 'ARUNACHAL PRADESH', 12, '1'),
(13, 'NAGALAND', 13, '1'),
(14, 'MANIPUR', 14, '1'),
(15, 'MIZORAM', 15, '1'),
(16, 'TRIPURA', 16, '1'),
(17, 'MEGHLAYA', 17, '1'),
(18, 'ASSAM', 18, '1'),
(19, 'WEST BENGAL', 19, '1'),
(20, 'JHARKHAND', 20, '1'),
(21, 'ODISHA', 21, '1'),
(22, 'CHATTISGARH', 22, '1'),
(23, 'MADHYA PRADESH', 23, '1'),
(24, 'GUJARAT', 24, '1'),
(25, 'DADRA AND NAGAR HAVELI AND DAMAN AND DIU (NEWLY ME', 26, '1'),
(26, 'MAHARASHTRA', 27, '1'),
(27, 'ANDHRA PRADESH(BEFORE DIVISION)', 28, '1'),
(28, 'KARNATAKA', 29, '1'),
(29, 'GOA', 30, '1'),
(30, 'LAKSHWADEEP', 31, '1'),
(31, 'KERALA', 32, '1'),
(32, 'TAMIL NADU', 33, '1'),
(33, 'PUDUCHERRY', 34, '1'),
(34, 'ANDAMAN AND NICOBAR ISLANDS', 35, '1'),
(35, 'TELANGANA', 36, '1');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_stock_units`
--

CREATE TABLE `tbl_stock_units` (
  `id` int(11) NOT NULL,
  `unit_type` varchar(50) NOT NULL,
  `unit_name` varchar(255) NOT NULL,
  `unit_abbreviation` varchar(100) NOT NULL COMMENT 'unit short name',
  `unit_convert` varchar(50) NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_stock_units`
--

INSERT INTO `tbl_stock_units` (`id`, `unit_type`, `unit_name`, `unit_abbreviation`, `unit_convert`, `is_active`, `created_at`, `updated_at`, `created_by`) VALUES
(2, '', 'gm', '', '', 1, '2022-09-23 12:18:31', '2022-09-23 12:18:31', NULL),
(3, '', 'Kg', '', '', 1, '2022-10-03 11:18:20', '2022-10-03 11:18:20', NULL),
(4, '', 'piece', '', '', 1, '2022-10-03 11:18:30', '2022-10-03 11:18:30', NULL),
(5, '', 'Plate', '', '', 1, '2022-10-03 11:18:38', '2022-10-03 11:18:38', NULL),
(6, '', 'tsp', '', '', 1, '2022-10-03 16:49:56', '2022-10-03 16:49:56', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_transactions`
--

CREATE TABLE `tbl_transactions` (
  `id` int(11) UNSIGNED NOT NULL,
  `batch_id` varchar(30) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `invoice_type` varchar(100) DEFAULT NULL COMMENT '1:"Credit";2:"Cash";3:"Online";',
  `voucher_type` varchar(100) DEFAULT NULL COMMENT '1:"Sale";9:"Purchase"',
  `transation_type` int(1) NOT NULL DEFAULT '0' COMMENT '0:"OTHER";1:"CASH";2."CARD";3:"UPI"',
  `voucher_id` int(11) DEFAULT NULL COMMENT 'voucher type id',
  `sub_ledger` varchar(255) DEFAULT NULL,
  `voucher_no` varchar(100) DEFAULT NULL COMMENT 'auto increment no of voucher',
  `return_voucher` varchar(20) DEFAULT NULL,
  `voucher_date_15jun23` varchar(100) DEFAULT NULL COMMENT 'custome date of voucher',
  `voucher_date` date DEFAULT NULL,
  `ledger_id` int(11) NOT NULL COMMENT 'party/ledger id',
  `ac_group_id` int(11) DEFAULT NULL,
  `ac_sub_group_id` int(1) NOT NULL DEFAULT '0' COMMENT 'this ledger is payement/receipt main ledger',
  `cr` decimal(11,2) NOT NULL COMMENT '"Receipt"',
  `dr` decimal(11,2) NOT NULL COMMENT '"Payment"',
  `balance` decimal(11,2) DEFAULT NULL,
  `narration` text,
  `status` int(1) NOT NULL DEFAULT '1',
  `is_active` int(1) NOT NULL DEFAULT '1',
  `company_id` int(11) DEFAULT '5',
  `outlet_id` int(11) DEFAULT '6',
  `user_id` int(11) DEFAULT '1',
  `created_at` varchar(255) NOT NULL,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `temp_pincode_store`
--

CREATE TABLE `temp_pincode_store` (
  `temp_id` int(11) NOT NULL,
  `user_id` varchar(50) DEFAULT NULL,
  `distric_id` varchar(50) DEFAULT NULL,
  `block_name` varchar(50) DEFAULT NULL,
  `pincode` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `unit`
--

CREATE TABLE `unit` (
  `id` int(11) NOT NULL,
  `name` varchar(55) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(5) UNSIGNED NOT NULL,
  `role` int(10) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `otp` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `state_code` int(11) NOT NULL DEFAULT '23',
  `user_id` int(11) NOT NULL DEFAULT '1',
  `admin_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `StateId` varchar(20) DEFAULT NULL,
  `district_id` int(11) DEFAULT NULL,
  `BlockId` varchar(50) DEFAULT NULL,
  `PinCode` varchar(6) DEFAULT NULL,
  `gst_no` text,
  `password` varchar(100) DEFAULT NULL,
  `active_year` int(11) DEFAULT '9',
  `status` int(5) DEFAULT '1' COMMENT '1:admin_user;2:customers;0:deactive',
  `latitude` varchar(100) DEFAULT NULL,
  `longitude` varchar(100) DEFAULT NULL,
  `fcm_id` varchar(255) DEFAULT NULL,
  `autosearch_address` text NOT NULL,
  `start_time` varchar(11) DEFAULT NULL,
  `end_time` varchar(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `role`, `name`, `email`, `phone`, `otp`, `address`, `state_code`, `user_id`, `admin_id`, `company_id`, `outlet_id`, `StateId`, `district_id`, `BlockId`, `PinCode`, `gst_no`, `password`, `active_year`, `status`, `latitude`, `longitude`, `fcm_id`, `autosearch_address`, `start_time`, `end_time`, `updated_at`, `created_at`) VALUES
(1, 1, 'superadmin', 'superadmin111@gmail.com', '0000000000', '', 'Shop No. 1, HN 9/39, Main Road,', 23, 1, 1, 1, 1, '23', 326, NULL, NULL, NULL, '7c4a8d09ca3762af61e59520943dc26494f8941b', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-12-11 08:21:10'),
(2, 8, 'Mahesh Billore', 'maheshbillore1992@gmail.com', '8435671990', '', '', 23, 1, NULL, NULL, NULL, '23', NULL, NULL, NULL, '11AAAAA1111Z1A1', '7c4a8d09ca3762af61e59520943dc26494f8941b', 9, 2, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-12-11 08:24:45'),
(3, 9, 'Raj Sellar bhopal', 'rajsellarbhopal@gmail.com', '9630258741', '', 'bhopal', 23, 1, 1, 1, 1, '23', 77, NULL, NULL, NULL, '7c4a8d09ca3762af61e59520943dc26494f8941b', 9, 1, NULL, NULL, NULL, '', 'NaN:NaN', 'NaN:NaN', NULL, '2023-12-13 09:11:42'),
(4, 8, 'test user', 'testuser@gmail.com', '9879879875', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '7c4a8d09ca3762af61e59520943dc26494f8941b', 8, 2, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-12-16 05:29:11'),
(5, 8, 'ram krishna', 'ramkrishna@gmail.com', '7987169800', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '356a192b7913b04c54574d18c28d46e6395428ab', 8, 2, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-12-19 07:43:47'),
(6, 8, 'Arsalan', 'abc@abc.in', '9897969594', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'a9993e364706816aba3e25717850c26c9cd0d89d', 8, 2, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-12-22 00:18:49'),
(7, 8, 'ram', 'ram@gmail.com', '7987169837', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '88ea39439e74fa27c09a4fc0bc8ebe6d00978392', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-12-26 02:29:20'),
(8, 8, 'Arsalan Khan', 'abcd@abc.in', '1212121212', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fe66e3e864fcf12557cf3330ba85cbe2732d31e8', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-12-26 02:32:15'),
(9, 8, 'Arsalan Khan', 'abcde@abc.in', '1212121212', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fe66e3e864fcf12557cf3330ba85cbe2732d31e8', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-12-26 02:32:21'),
(10, 8, 'test user', 'testuser1@gmail.com', '1111111111', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '301ece87bd38567d27ed49da627082b602461d3c', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-12-26 02:34:29'),
(11, 8, 'Arsalan Khan', 'abc1@abc1.in', '9876543210', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fe66e3e864fcf12557cf3330ba85cbe2732d31e8', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-12-29 00:31:39'),
(12, 8, 'Arsalan Khan', 'arsalan@abc.in', '9876543210', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fe66e3e864fcf12557cf3330ba85cbe2732d31e8', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-12-29 00:31:57'),
(13, 8, 'Priya Nema', 'priyanema9827@gmail.com', '9827955827', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', 8, 2, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-12-30 05:15:05'),
(14, 8, 'Sharad Patel', 'sharadpatel84@gmail.com', '9203867065', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 'fe66e3e864fcf12557cf3330ba85cbe2732d31e8', 8, 2, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-12-30 06:59:52'),
(15, 8, 'Ahad Khalid', 'ahadkhalid117@gmail.com', '7974857585', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '7c4a8d09ca3762af61e59520943dc26494f8941b', 8, 2, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-02 00:24:16'),
(16, 8, 'maheshbillore', 'maheshbillore19921@gmail.com', '8435671991', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 'f7c3bc1d808e04732adf679965ccc34ca7ae3441', 8, 2, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-02 00:32:57'),
(17, 8, 'MAHENDRA YADAV', 'mahi.yadav@gmail.com', '9755472257', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'dbfcc2bb7cb3712608cc26331028b6b1ca2b0c39', 9, 2, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-03 09:17:26'),
(18, 8, 'testdevloper', 'testdevloper@gmail.com', '9638527419', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '7c4a8d09ca3762af61e59520943dc26494f8941b', 9, 2, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-04 07:47:06'),
(19, 8, 'Arsalan Khan', 'xyz@xyz.in', '9876543210', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '37aae3613882d63955566a5b1d5e544e18a10598', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-05 00:43:29'),
(20, 8, 'Arsalan', 'zxc@zxc.in', '9876543211', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7017f35a639ec0d6302fcb0795745d8e8f597b35', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-05 00:43:55'),
(21, 8, 'ram krishna', 'rkcreation7987@gmail.com', '7987169837', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7c4a8d09ca3762af61e59520943dc26494f8941b', 9, 2, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-05 02:50:18'),
(22, 8, 'KAPIL DHARSE', 'kapil.dharse@gmail.com', '8787878787', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '01b307acba4f54f55aafc33bb06bbbf6ca803e9a', 9, 2, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-05 08:59:08'),
(23, 8, 'devtest', 'devtest@gmail.com', '9638527418', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '7c4a8d09ca3762af61e59520943dc26494f8941b', 9, 2, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-06 01:44:36'),
(24, 8, 'XYZ', 'xyz@sapient.com', '8787121212', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '01b307acba4f54f55aafc33bb06bbbf6ca803e9a', 9, 2, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-06 03:37:37'),
(25, 9, 'Ahad', 'ahad@gmail.com', '9806734272', '', 'bhopal', 23, 1, NULL, NULL, NULL, '23', 77, '67719', '462016', '', '40bd001563085fc35165329ea1ff5c5ecbdbbeef', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-10 03:09:57'),
(26, 8, 'A', 'a@a.a', '1111111111', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fe66e3e864fcf12557cf3330ba85cbe2732d31e8', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 04:51:13'),
(27, 8, 'A', 'a@a.in', '1111111111', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fe66e3e864fcf12557cf3330ba85cbe2732d31e8', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 04:51:20'),
(28, 8, 'Arsalan Khan', 'aa@aa.in', '1211212121', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '19928717fd69248767953f490369f212e3fba025', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 05:01:02'),
(29, 8, 'Arsalan Khan', 'aa@aa.com', '1211212121', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '19928717fd69248767953f490369f212e3fba025', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 05:01:10'),
(30, 8, 'Arsalan Khan', 'aa@abc.abc', '1211212121', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '19928717fd69248767953f490369f212e3fba025', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 05:01:19'),
(31, 8, 'Arsalan Khan', 'aa@abc.abcaaaaaaaaaaa', '1211212121', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '19928717fd69248767953f490369f212e3fba025', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 05:01:22'),
(32, 8, 'Arsalan Khan', 'aa@abc.abcaaaaaaaaaaaaa', '1211212121', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '19928717fd69248767953f490369f212e3fba025', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 05:01:36'),
(33, 8, 'Arsalan', 'mmt@mmt.in', '1111111111', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'c632067167fdd285fd316e9a7a07c27535002b3e', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 05:04:30'),
(34, 8, 'Arsalan', 'abc@abc.innnnnnnnnnnn', '1212121212', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fe66e3e864fcf12557cf3330ba85cbe2732d31e8', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 05:05:02'),
(35, 8, 'aa', 'aaaaaaaaa@aaaaaaaaaaa.aaaaaaaaaa', '1111111111', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fe66e3e864fcf12557cf3330ba85cbe2732d31e8', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 05:05:23'),
(36, 8, 'name', 'name@email.com', '1111111111', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fe66e3e864fcf12557cf3330ba85cbe2732d31e8', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 05:07:04'),
(37, 8, 'Arsalan', 'abc123@abc12345.in', '1111111111', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fe66e3e864fcf12557cf3330ba85cbe2732d31e8', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 05:11:05'),
(38, 8, 'Arsalan', 'abc123@abc12345.innn', '1111111111', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fe66e3e864fcf12557cf3330ba85cbe2732d31e8', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 05:12:25'),
(39, 8, 'Checking', 'checkmate@check.in', '1111111111', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'b80036ab387aff0d016d328557c6995a677f5b53', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 05:17:59'),
(40, 8, 'Arsalan khan', 'abc@abcaacss.in', '7777777777', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fe66e3e864fcf12557cf3330ba85cbe2732d31e8', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 05:43:46'),
(41, 8, 'Arsalan', 'abc@abc.inasdsa', '1111111111', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fe66e3e864fcf12557cf3330ba85cbe2732d31e8', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 05:44:55'),
(42, 8, 'aaa', 'abcabc123@abc.in', '2222222222', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fe66e3e864fcf12557cf3330ba85cbe2732d31e8', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 05:46:55'),
(43, 8, 'Checking', 'checkmaate@check.in', '1111111111', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'b80036ab387aff0d016d328557c6995a677f5b53', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 07:29:23');

-- --------------------------------------------------------

--
-- Table structure for table `users_18122023-1`
--

CREATE TABLE `users_18122023-1` (
  `id` int(5) UNSIGNED NOT NULL,
  `role` int(10) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `otp` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `state_code` int(11) NOT NULL DEFAULT '23',
  `user_id` int(11) NOT NULL DEFAULT '1',
  `admin_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `StateId` varchar(20) DEFAULT NULL,
  `district_id` int(11) DEFAULT NULL,
  `BlockId` varchar(20) DEFAULT NULL,
  `PinCode` varchar(6) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `active_year` int(11) DEFAULT '8',
  `status` int(5) DEFAULT '1' COMMENT '1:admin_user;2:customers;0:deactive',
  `latitude` varchar(100) DEFAULT NULL,
  `longitude` varchar(100) DEFAULT NULL,
  `fcm_id` varchar(255) DEFAULT NULL,
  `autosearch_address` text NOT NULL,
  `start_time` varchar(11) DEFAULT NULL,
  `end_time` varchar(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_18122023-1`
--

INSERT INTO `users_18122023-1` (`id`, `role`, `name`, `email`, `phone`, `otp`, `address`, `state_code`, `user_id`, `admin_id`, `company_id`, `outlet_id`, `StateId`, `district_id`, `BlockId`, `PinCode`, `password`, `active_year`, `status`, `latitude`, `longitude`, `fcm_id`, `autosearch_address`, `start_time`, `end_time`, `updated_at`, `created_at`) VALUES
(441, 1, 'superadmin', 'superadmin111@gmail.com', '0000000000', '', 'Shop No. 1, HN 9/39, Main Road,', 23, 1, 1, NULL, 441, NULL, 326, NULL, NULL, '7c4a8d09ca3762af61e59520943dc26494f8941b', 9, 1, '', '', NULL, '', '', '', NULL, '2022-09-19 17:38:50'),
(529, 9, 'rajseller', 'rajseller@gmail.com', '8745963215', '', 'for test', 23, 1, 1, NULL, 441, NULL, 335, NULL, NULL, '7c4a8d09ca3762af61e59520943dc26494f8941b', 8, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-10-10 15:24:28'),
(530, 9, 'superseller', 'superseller@gmail.com', '8435671990', '', 'test address', 23, 1, 1, NULL, 441, NULL, 334, NULL, NULL, '7c4a8d09ca3762af61e59520943dc26494f8941b', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-10-10 15:34:03'),
(531, 9, 'newseller', 'newseller@gmail.com', '8435698574', '', 'for test', 23, 1, 1, NULL, 441, NULL, 326, NULL, NULL, '7c4a8d09ca3762af61e59520943dc26494f8941b', 8, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-10-11 18:48:01'),
(532, 9, 'newuser1210', 'newuser1210@gmail.com', '9874596325', '', 'bhopal', 23, 1, 1, NULL, 441, NULL, 326, NULL, NULL, '7c4a8d09ca3762af61e59520943dc26494f8941b', 8, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-10-12 19:43:43'),
(533, 9, 'testusermahesh', 'testusermahesh@gmail.com', '8435671585', '', 'bhopal', 23, 1, 1, NULL, 441, NULL, 326, NULL, NULL, '7c4a8d09ca3762af61e59520943dc26494f8941b', 8, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-10-12 19:45:59'),
(534, 9, 'testuser1310', 'testuser1310@gmail.com', '8435671990', '', 'for test ', 23, 1, 1, NULL, 441, NULL, 326, NULL, NULL, '7c4a8d09ca3762af61e59520943dc26494f8941b', 8, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-10-13 12:23:24'),
(535, 8, 'maheshbillore', 'maheshbillore@gmail.com', '8435671990', '', '', 23, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7c4a8d09ca3762af61e59520943dc26494f8941b', 8, 2, NULL, NULL, NULL, '', NULL, NULL, NULL, '2023-10-16 12:14:31'),
(538, 9, 'Rajesh Kumar Ghodki', 'ghodki367@gmail.com', '9907345980', '', 'LIG - 10/102 Gauri Shankar Awashiya Parishar BDA Colony Barrai Katara Hills', 23, 1, 1, NULL, 441, '23', 325, '16842', '475115', '601f1889667efaebb33b8c12572835da3f027f78', 8, 1, NULL, NULL, NULL, '', '16:25', '16:25', NULL, '2023-12-15 16:26:48');

-- --------------------------------------------------------

--
-- Table structure for table `users_address`
--

CREATE TABLE `users_address` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `fullname` varchar(150) DEFAULT NULL,
  `mobile_no` varchar(20) DEFAULT NULL,
  `pincode` varchar(10) DEFAULT NULL,
  `firstaddress` varchar(255) DEFAULT NULL COMMENT 'House number',
  `secondaddress` varchar(255) DEFAULT NULL,
  `landmark` varchar(255) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `block` varchar(100) DEFAULT NULL,
  `latitude` varchar(100) DEFAULT NULL,
  `longitude` varchar(100) DEFAULT NULL,
  `autofill_address` text,
  `address` text,
  `status` int(1) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `flag` int(11) DEFAULT NULL COMMENT '0 means Home , 1 means office',
  `is_default` int(11) DEFAULT '0',
  `delete_status` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `users_address`
--

INSERT INTO `users_address` (`id`, `user_id`, `fullname`, `mobile_no`, `pincode`, `firstaddress`, `secondaddress`, `landmark`, `state`, `city`, `block`, `latitude`, `longitude`, `autofill_address`, `address`, `status`, `created_at`, `flag`, `is_default`, `delete_status`) VALUES
(1, 2, 'Mahesh', '8435671990', '461331', '554', 'Harda, Madhya Pradesh, India', 'vikas nagar harda', ' 23', '338', ' 16369', '22.3466702', '77.0889583', 'Harda, Madhya Pradesh, India', 'Harda, Madhya Pradesh, India', 1, NULL, 0, 1, 0),
(2, 2, 'maheshtest test', '7897897897', '461331', '445', 'Harda, Madhya Pradesh, India', 'vikash nagar', ' 23', '338', ' 16369', '22.3466702', '77.0889583', 'Harda, Madhya Pradesh, India', 'Harda, Madhya Pradesh, India', 1, NULL, 23, 0, 0),
(3, 2, 'ahad', '9806734272', '462001', 'mandakini colony', 'Bharat', 'bhopal', ' 23', '696', ' 16124', '20.593684', '78.96288', 'Bharat', 'Bharat', 1, NULL, 23, 0, 0),
(4, 2, 'abcd', '7000680535', '462001', 'mandakini colony', 'Bharat', 'alok press', ' 23', '696', ' 16124', '20.593684', '78.96288', 'Bharat', 'Bharat', 1, NULL, 0, 0, 1),
(5, 4, 'test user', '9879879875', '461331', '54', 'Vikash Kirana, Harda, Madhya Pradesh, India', 'vikash', ' 23', '338', ' 16369', '22.1491325', '77.062629', 'Vikash Kirana, Harda, Madhya Pradesh, India', 'Vikash Kirana, Harda, Madhya Pradesh, India', 1, NULL, 0, 1, 0),
(6, 6, 'AK', '7272123409', '462001', 'H No. 123', NULL, 'Kolar', 'MH', 'Mumbai', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(7, 6, 'Arsalan Khan', '3333333333', '466001', 'H No. 123', NULL, 'Kolar Rd', 'Madhya Pradesh', 'sehore', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(8, 6, 'Arsalan Khan', '3333333333', '466001', 'H No. 123', NULL, 'Kolar Rd', 'Madhya Pradesh', 'sehore', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(9, 6, 'Check', '1314151515', '400088', 'abc 123', NULL, '123 abc', 'Madhya Pradesh', 'sehore', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(10, 6, 'asdsa', '1232131232', '466001', 'assdsaas', NULL, 'dsasafsa', 'Madhya Pradesh', 'sehore', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(11, 6, 'asdsa aa www', '1232131232', '466001', 'assdsaas', NULL, 'dsasafsa', 'Madhya Pradesh', 'sehore', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(12, 6, 'ars abc', '4444444444', '466001', 'asdas', NULL, 'abc asdaf', 'Madhya Pradesh', 'sehore', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(13, 6, 'mnana', '7777771111', '462001', 'mnanan', NULL, 'nmaman', 'MADHYA PRADESH', 'Bhopal', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(14, 6, 'Test Name', '9087654321', '462001', 'Test House', NULL, 'Test Area', 'MADHYA PRADESH', 'Bhopal', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(15, 6, 'Test Name', '9087654321', '400088', 'Test House', NULL, 'Test Area', 'MAHARASHTRA', 'Mumbai', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(16, 6, 'abc', '8989899898', '462001', 'asds', NULL, 'asdsa', 'MADHYA PRADESH', 'Bhopal', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(17, 6, 'aaaaaaaaaaaaaa', '1111111111', '400088', 'aaaaaaaaaaaaaaaa', NULL, 'aaaaaaaaaaaaaaaaaaaa', 'MAHARASHTRA', 'Mumbai', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(18, 6, 'aaaaaaaaaa', '1111111111', '462001', 'aaaaaaaaa', NULL, 'aaaaaaaaaa', '23', '77', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(19, 6, 'Arsalan Khan', '1212121212', '466001', 'abc', NULL, 'acb', '23', '511', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(20, 6, 'XYZ', '8787878787', '400088', 'xyz house', NULL, 'area xyz', '26', '389', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(21, 6, 'abc', '1212112112', '466001', 'abc', NULL, 'def', '23', '511', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(22, 6, 'Tester', '3333333333', '400088', 'www', NULL, 'aaa', '26', '389', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(23, 6, 'bio check', '1211212112', '400088', 'asdsad', NULL, 'asdsa', '26', '389', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(24, 6, 'Abc', '8732848734', '400088', 'abcasdks', NULL, 'asdksa', '26', '389', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(25, 6, 'Abc', '8732848734', '400088', 'abcasdks', NULL, 'asdksa', '26', '389', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(26, 6, 'abcdef', '1212121212', '462001', 'abc test', NULL, 'abc def', '23', '77', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(27, 6, 'Arsalan', '4343434343', '462001', '43 jum', NULL, '43 jum', '23', '77', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(28, 6, 'check ', '1212121211', '462001', 'abca', NULL, 'wasjd', '23', '77', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(29, 6, '111111111', '1111111111', '462002', 'aa', NULL, 'aa', '23', '77', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(30, 6, 'abc', '1212121212', '462001', 'abc', NULL, 'aaa', '23', '77', '67634', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(31, 6, 'abc', '1212121212', '466001', 'abc', NULL, 'aaa', '23', '511', '74738', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(32, 6, 'Arsalan', '9876543210', '400088', 'House 123, Antilla', NULL, 'Behind Hotel Taj Palace', '26', '389', '81503', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 0),
(33, 6, 'Arsalan Khan', '2121212112', '462001', 'aa', NULL, 'aaaa', '23', '77', '67612', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(34, 6, 'Arsalan Khan', '6565656656', '462001', 'asda', NULL, 'sdsad', '23', '77', '67634', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(35, 6, 'Arsalan Khan', '1212121221', '462001', 'aaa', NULL, 'aaa', '23', '77', '67694', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(36, 6, 'Abc', '1211211122', '462001', 'asdsad', NULL, 'asdasd', '23', '77', '67639', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(37, 6, 'Testing Name', '1211212112', '713301', 'House Test', NULL, 'Area Test', '19', '52', '150811', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(38, 6, 'check', '1212121212', '466001', 'asdasdsad', NULL, 'asdsa', '23', '511', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(39, 6, 'check', '1212121212', '466001', 'asdasdsad', NULL, 'asdsa', '23', '511', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(40, 6, 'check', '1212121212', '466001', 'asdasdsad', NULL, 'asdsa', '23', '511', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(41, 6, 'Test Name', '5656565656', '462001', 'abc', NULL, 'abc', '23', '77', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(42, 6, 'Test Name', '5656565656', '462001', 'abc', NULL, 'abc', '23', '77', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(43, 6, 'Check Testing Name', '9087654321', '462001', 'House New Opp Road', NULL, 'JK Hospital', '23', '77', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(44, 6, 'Testing Name 2', '7675747372', '400088', 'Testing House', NULL, 'Testing Area', '26', '389', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(45, 6, 'Testing Name 3', '6564636261', '462001', 'Abcd', NULL, 'ABdcd', '23', '77', '67622', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(46, 6, 'Testing Name 1', '8787878787', '462001', 'House 1', NULL, 'Area 1', '23', '77', '67627', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(47, 6, 'Testing Name 2', '1234556788', '400088', 'House 2', NULL, 'Area 3', '26', '389', '81503', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(48, 6, 'Testing Name 3', '4545544554', '462002', 'House 3', NULL, 'Area 3', '23', '77', '67719', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(49, 6, 'Testing Name 1', '1234567890', '462001', 'Testing House 1', NULL, 'Testing Area 1', '23', '77', '67699', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(50, 6, 'Arsalan Khan', '1212121212', '400099', 'Aiport House', NULL, 'Airport Area', '26', '389', '81432', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(51, 6, 'Testing Name 1', '1211212121', '462003', 'Testing House 1', NULL, 'Testing Area 1', '23', '77', '67688', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(52, 6, 'Testing Name 2', '9876543210', '462042', 'Testing House 2', NULL, 'Testing Area 2', '23', '77', '67648', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(53, 6, 'Arsalan Khan', '1212112112', '462042', 'abc', NULL, 'dubai', '23', '77', '67585', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(54, 6, 'ABc', '2322323232', '462042', 'abc', NULL, 'Chinar Incube Mall, Chinar Fortune City, Bhopal, Madhya Pradesh', '23', '77', '67576', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(55, 6, 'aa', '6565656656', '462042', 'aaaa', NULL, 'my area', '23', '77', '67585', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(56, 6, 'Checking Address', '8787878787', '462001', 'Abcd', NULL, 'DB City Mall, Zone-I, Maharana Pratap Nagar, Bhopal, Madhya Pradesh', '23', '77', '67634', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(57, 6, 'Address Name', '1211212121', '462002', 'abc', NULL, 'Dubai Hills Mall KETCH UP - Al Khail Road - Dubai - United Arab Emirates', '23', '77', '67719', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(58, 6, 'Arsalan Khan', '9876543210', '462002', 'Behind Burj Khalifa', NULL, 'Burj Khalifa - Sheikh Mohammed bin Rashid Boulevard - Dubai - United Arab Emirates', '23', '77', '67719', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 0),
(59, 13, 'priya nema', '9827955827', '462001', '36', 'Sarvadharam C Sector, Shirdipuram, Kolar Rd, Gehun Kheda, Bhopal, Madhya Pradesh, India', 'jk hospital ', ' 23', '77', '67699', '23.1787913', '77.41932369999999', 'Sarvadharam C Sector, Shirdipuram, Kolar Rd, Gehun Kheda, Bhopal, Madhya Pradesh, India', 'Sarvadharam C Sector, Shirdipuram, Kolar Rd, Gehun Kheda, Bhopal, Madhya Pradesh, India', 1, NULL, 23, 1, 0),
(60, 14, 'Sharad Patel', '9203867065', '462022', 'D 18', 'Amrawad Khurd Village, Bhopal, Madhya Pradesh, India', 'Galaxy City PH 2', ' 23', '77', '67602', '23.2085996', '77.49170649999999', 'Amrawad Khurd Village, Bhopal, Madhya Pradesh, India', 'Amrawad Khurd Village, Bhopal, Madhya Pradesh, India', 1, NULL, 0, 0, 0),
(61, 14, 'Sharad Patel', '9203867065', '462022', 'D18', 'Amarawad Khurd', 'Galaxy City Phase 2 BDA Road', ' 23', '77', '67593', '', '', 'Amarawad Khurd', 'Amarawad Khurd', 1, NULL, 0, 1, 0),
(62, 15, 'Ahad', '7974857585', '462001', 'bhopal', 'Bhopal, Madhya Pradesh, India', 'bhopal', ' 23', '77', '67605', '23.2599333', '77.412615', 'Bhopal, Madhya Pradesh, India', 'Bhopal, Madhya Pradesh, India', 1, NULL, 0, 0, 0),
(63, 16, 'mahesh', '9876549876', '461331', '55 test', 'Harda, Madhya Pradesh, India', 'test area', ' 23', '230', '68933', '22.3466702', '77.0889583', 'Harda, Madhya Pradesh, India', 'Harda, Madhya Pradesh, India', 1, NULL, 0, 1, 0),
(64, 6, 'Arsalan Khan', '9796959493', '462001', 'abc', NULL, 'Hamidia Hospital, Sultania Road, Royal Market, Bhopal, Madhya Pradesh', '23', '77', '67627', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 0),
(65, 6, 'ABC', '4545454545', '462001', 'Abc House', NULL, 'Chhola Road, JP Nagar, Bhopal, Madhya Pradesh', '23', '77', '67611', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(66, 15, 'ahad', '7777777777', '462001', '888', 'Bhopal, Madhya Pradesh, India', '', '23', '696', NULL, '23.2599333', '77.412615', 'Bhopal, Madhya Pradesh, India', 'bhopal, madhya pradesh, india', 1, NULL, NULL, 1, 0),
(67, 18, 'test customer', '9638527419', '462022', '55', 'MP Nagar, Bhopal, Madhya Pradesh, India', 'test area', ' 23', '77', '67577', '23.2313434', '77.4326473', 'MP Nagar, Bhopal, Madhya Pradesh, India', 'MP Nagar, Bhopal, Madhya Pradesh, India', 1, NULL, 0, 0, 0),
(68, 18, 'test', '9638527419', '461331', '55', 'Harda, Madhya Pradesh, India', 'test ', ' 23', '230', '68933', '22.3466702', '77.0889583', 'Harda, Madhya Pradesh, India', 'Harda, Madhya Pradesh, India', 1, NULL, 0, 0, 0),
(69, 20, 'Arsalan Khan', '9876543211', '462001', 'House No. 2', NULL, 'Chowk Bazaar Road, Sarafa chowk, Azad Market, Peer Gate Area, Bhopal, Madhya Pradesh', '23', '77', '67612', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 0),
(70, 23, 'test dev', '9638527411', '461331', '55', 'Harda, Madhya Pradesh, India', 'haweli garden', ' 23', '230', '68930', '22.3466702', '77.0889583', 'Harda, Madhya Pradesh, India', 'Harda, Madhya Pradesh, India', 1, NULL, 0, 1, 0),
(71, 18, 'MAHENDRA YADAV', '34532323', '462008', '32', 'wedwex, Manama, Bahrain', 'fd', ' 23', '77', '67635', '26.2143788', '50.5935765', 'wedwex, Manama, Bahrain', 'wedwex, Manama, Bahrain', 1, NULL, 0, 1, 0),
(72, 6, 'Testing Default', '9876543210', '462001', 'Testing', NULL, 'Aashima Mall, Narmadapuram Road, Danish Nagar, Bawaria Kalan, Bhopal, Madhya Pradesh', '23', '77', '67678', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(73, 6, 'Testing', '1212121212112', '462001', 'Testing Default', NULL, 'Testing', 'Madhya Pradesh', 'Bhopal', 'Sehore', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1),
(74, 6, 'Testing Address', '9898989899', '462001', 'Testing House', NULL, 'Chota Talaab, Lower Lake, Jahangirabad, Bhopal, Madhya Pradesh', '23', '77', '67612', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `users_pending`
--

CREATE TABLE `users_pending` (
  `id` int(5) UNSIGNED NOT NULL,
  `role` int(10) DEFAULT NULL,
  `name` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `phone` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `otp` varchar(255) CHARACTER SET utf8 NOT NULL,
  `address` text CHARACTER SET utf8 NOT NULL,
  `state_code` int(11) NOT NULL DEFAULT '23',
  `user_id` int(11) NOT NULL DEFAULT '1',
  `admin_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `StateId` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `district_id` int(11) DEFAULT NULL,
  `BlockId` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `PinCode` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `gst_no` text CHARACTER SET utf8,
  `password` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `active_year` int(11) DEFAULT '9',
  `status` int(5) DEFAULT '1' COMMENT '1:admin_user;2:customers;0:deactive',
  `latitude` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `longitude` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `fcm_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `autosearch_address` text CHARACTER SET utf8 NOT NULL,
  `start_time` varchar(11) CHARACTER SET utf8 DEFAULT NULL,
  `end_time` varchar(11) CHARACTER SET utf8 DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `accept_reject` int(11) DEFAULT '1' COMMENT '1 means pending , 0 menas accept , 2 means reject',
  `reject_message` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `users_pending`
--

INSERT INTO `users_pending` (`id`, `role`, `name`, `email`, `phone`, `otp`, `address`, `state_code`, `user_id`, `admin_id`, `company_id`, `outlet_id`, `StateId`, `district_id`, `BlockId`, `PinCode`, `gst_no`, `password`, `active_year`, `status`, `latitude`, `longitude`, `fcm_id`, `autosearch_address`, `start_time`, `end_time`, `updated_at`, `created_at`, `accept_reject`, `reject_message`) VALUES
(13, 9, 'test by devloper', 'testbydevloper@gmail.com', '9874563214', '', 'test', 23, 1, NULL, NULL, NULL, '34', 423, '148993', '744209', '11AAAAA1111Z1A2', '7c4a8d09ca3762af61e59520943dc26494f8941b', 9, 1, NULL, NULL, NULL, '', NULL, NULL, NULL, '2024-01-11 06:05:30', 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `user_carts`
--

CREATE TABLE `user_carts` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` varchar(50) NOT NULL,
  `updated_at` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_carts`
--

INSERT INTO `user_carts` (`id`, `user_id`, `product_id`, `quantity`, `status`, `created_at`, `updated_at`) VALUES
(422, 15, 102, 1, 1, '10-01-2024 13:43:20 PM', '10-01-2024 13:43:20 PM'),
(423, 15, 28, 1, 1, '10-01-2024 13:43:20 PM', '10-01-2024 13:43:20 PM');

-- --------------------------------------------------------

--
-- Table structure for table `vouchertypes`
--

CREATE TABLE `vouchertypes` (
  `id` int(11) UNSIGNED NOT NULL,
  `voucher_type` varchar(255) NOT NULL,
  `is_active` int(1) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vouchertypes`
--

INSERT INTO `vouchertypes` (`id`, `voucher_type`, `is_active`, `created_at`, `updated_at`, `created_by`) VALUES
(1, 'SALE', 0, '2022-03-22 17:42:22', '2022-03-22 17:42:22', NULL),
(8, 'SALE-RETURN', 0, '2022-03-22 17:44:11', '2022-03-22 17:44:11', NULL),
(9, 'PURCHASE', 0, '2022-03-23 11:16:13', '2022-03-23 11:16:13', NULL),
(10, 'PURCHASE-RETURN', 0, '2022-03-23 11:16:13', '2022-03-23 11:16:13', NULL),
(11, 'CREDIT-NOTE', 0, '2022-03-23 11:16:36', '2022-03-23 11:16:36', NULL),
(12, 'DEBIT -NOTE', 0, '2022-03-23 11:16:36', '2022-03-23 11:16:36', NULL),
(13, 'Receipt', 0, '2022-09-08 13:30:57', '2022-09-08 13:30:57', NULL),
(14, 'Payment', 0, '2022-09-08 17:05:07', '2022-09-08 17:05:07', NULL),
(15, 'Contra', 0, '2022-09-08 17:05:33', '2022-09-08 17:05:33', NULL),
(16, 'Journal', 0, '2022-09-08 17:05:51', '2022-09-08 17:05:51', NULL),
(17, 'complimet', 0, '2022-09-08 17:05:51', '2022-09-08 17:05:51', NULL),
(18, 'Order', 1, '2022-09-08 17:05:51', '2022-09-08 17:05:51', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `vouchertypes_22092023`
--

CREATE TABLE `vouchertypes_22092023` (
  `id` int(11) UNSIGNED NOT NULL,
  `voucher_type` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vouchertypes_22092023`
--

INSERT INTO `vouchertypes_22092023` (`id`, `voucher_type`, `created_at`, `updated_at`, `created_by`) VALUES
(1, 'SALE', '2022-03-22 17:42:22', '2022-03-22 17:42:22', NULL),
(2, 'OUT-STOCK', '2022-03-22 17:42:22', '2022-03-22 17:42:22', NULL),
(3, 'STOCK TO PRODUCTION', '2022-03-22 17:42:50', '2022-03-22 17:42:50', NULL),
(4, 'IN-PRODUCTION-PROCESS', '2022-03-22 17:42:50', '2022-03-22 17:42:50', NULL),
(5, 'IN-PRODUCTION-DONE', '2022-03-22 17:43:53', '2022-03-22 17:43:53', NULL),
(6, 'IN-STORE', '2022-03-22 17:43:53', '2022-03-22 17:43:53', NULL),
(7, 'SALE', '2022-03-22 17:44:11', '2022-03-22 17:44:11', NULL),
(8, 'SALE-RETURN', '2022-03-22 17:44:11', '2022-03-22 17:44:11', NULL),
(9, 'PURCHASE', '2022-03-23 11:16:13', '2022-03-23 11:16:13', NULL),
(10, 'PURCHASE-RETURN', '2022-03-23 11:16:13', '2022-03-23 11:16:13', NULL),
(11, 'CREDIT-NOTE', '2022-03-23 11:16:36', '2022-03-23 11:16:36', NULL),
(12, 'DEBIT -NOTE', '2022-03-23 11:16:36', '2022-03-23 11:16:36', NULL),
(13, 'Receipt', '2022-09-08 13:30:57', '2022-09-08 13:30:57', NULL),
(14, 'Paymant', '2022-09-08 17:05:07', '2022-09-08 17:05:07', NULL),
(15, 'Contra', '2022-09-08 17:05:33', '2022-09-08 17:05:33', NULL),
(16, 'Journal', '2022-09-08 17:05:51', '2022-09-08 17:05:51', NULL),
(17, 'complimet', '2022-09-08 17:05:51', '2022-09-08 17:05:51', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin_send_notification`
--
ALTER TABLE `admin_send_notification`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `aff_coupons`
--
ALTER TABLE `aff_coupons`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `banner_promotion`
--
ALTER TABLE `banner_promotion`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blog_details`
--
ALTER TABLE `blog_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `brands`
--
ALTER TABLE `brands`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `business_details`
--
ALTER TABLE `business_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `carts`
--
ALTER TABLE `carts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `check_pincode`
--
ALTER TABLE `check_pincode`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `coupon`
--
ALTER TABLE `coupon`
  ADD PRIMARY KEY (`coupon_id`);

--
-- Indexes for table `deliveryboys`
--
ALTER TABLE `deliveryboys`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `deliveryboy_messages_status`
--
ALTER TABLE `deliveryboy_messages_status`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `delivery_charge`
--
ALTER TABLE `delivery_charge`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `discover_promotion`
--
ALTER TABLE `discover_promotion`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `districts`
--
ALTER TABLE `districts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `districts_old`
--
ALTER TABLE `districts_old`
  ADD PRIMARY KEY (`id`),
  ADD KEY `state_id` (`state_id`);

--
-- Indexes for table `district_block`
--
ALTER TABLE `district_block`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `district_block_old`
--
ALTER TABLE `district_block_old`
  ADD PRIMARY KEY (`id`),
  ADD KEY `state` (`state`),
  ADD KEY `district` (`district`);

--
-- Indexes for table `district_block_old2`
--
ALTER TABLE `district_block_old2`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fraction_therapy`
--
ALTER TABLE `fraction_therapy`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `gallery_image`
--
ALTER TABLE `gallery_image`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `gallery_tittle`
--
ALTER TABLE `gallery_tittle`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `groups`
--
ALTER TABLE `groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ingredients_for_product`
--
ALTER TABLE `ingredients_for_product`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `main_group`
--
ALTER TABLE `main_group`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mobile_notification`
--
ALTER TABLE `mobile_notification`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mobile_sliders`
--
ALTER TABLE `mobile_sliders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `offer_detail`
--
ALTER TABLE `offer_detail`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `offer_product_detail`
--
ALTER TABLE `offer_product_detail`
  ADD PRIMARY KEY (`id`),
  ADD KEY `offer_details_id` (`offer_detail_id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_status`
--
ALTER TABLE `order_status`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_status_name`
--
ALTER TABLE `order_status_name`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_tables`
--
ALTER TABLE `order_tables`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `outlate_opening_stock`
--
ALTER TABLE `outlate_opening_stock`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `outlet_product_stock`
--
ALTER TABLE `outlet_product_stock`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `outlet_series`
--
ALTER TABLE `outlet_series`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payment_descriptions`
--
ALTER TABLE `payment_descriptions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions_17_dec_22`
--
ALTER TABLE `permissions_17_dec_22`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions_23-12-2022`
--
ALTER TABLE `permissions_23-12-2022`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `printer_setting`
--
ALTER TABLE `printer_setting`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_categories`
--
ALTER TABLE `product_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_categories_23-12-2022`
--
ALTER TABLE `product_categories_23-12-2022`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_filter`
--
ALTER TABLE `product_filter`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_images`
--
ALTER TABLE `product_images`
  ADD PRIMARY KEY (`image_id`) USING BTREE;

--
-- Indexes for table `product_types`
--
ALTER TABLE `product_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_types_23-12-22`
--
ALTER TABLE `product_types_23-12-22`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `promotion`
--
ALTER TABLE `promotion`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ratings`
--
ALTER TABLE `ratings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `reviews_testimonials`
--
ALTER TABLE `reviews_testimonials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `role_has_permissions17dec22`
--
ALTER TABLE `role_has_permissions17dec22`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `series`
--
ALTER TABLE `series`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `seriestitle`
--
ALTER TABLE `seriestitle`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `series_20092023`
--
ALTER TABLE `series_20092023`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sliders`
--
ALTER TABLE `sliders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `state_list`
--
ALTER TABLE `state_list`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `stock_transaction`
--
ALTER TABLE `stock_transaction`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `table_booking_details`
--
ALTER TABLE `table_booking_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_account_sub_groups`
--
ALTER TABLE `tbl_account_sub_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_account_sub_groups03fab2023`
--
ALTER TABLE `tbl_account_sub_groups03fab2023`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_cities`
--
ALTER TABLE `tbl_cities`
  ADD PRIMARY KEY (`city_id`);

--
-- Indexes for table `tbl_financial_years`
--
ALTER TABLE `tbl_financial_years`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_godowns`
--
ALTER TABLE `tbl_godowns`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_invoice`
--
ALTER TABLE `tbl_invoice`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_ledgers`
--
ALTER TABLE `tbl_ledgers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_products`
--
ALTER TABLE `tbl_products`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_products_05_dec_22`
--
ALTER TABLE `tbl_products_05_dec_22`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_states`
--
ALTER TABLE `tbl_states`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_stock_units`
--
ALTER TABLE `tbl_stock_units`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_transactions`
--
ALTER TABLE `tbl_transactions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `temp_pincode_store`
--
ALTER TABLE `temp_pincode_store`
  ADD PRIMARY KEY (`temp_id`);

--
-- Indexes for table `unit`
--
ALTER TABLE `unit`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users_18122023-1`
--
ALTER TABLE `users_18122023-1`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users_address`
--
ALTER TABLE `users_address`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users_pending`
--
ALTER TABLE `users_pending`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_carts`
--
ALTER TABLE `user_carts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `vouchertypes`
--
ALTER TABLE `vouchertypes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `vouchertypes_22092023`
--
ALTER TABLE `vouchertypes_22092023`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin_send_notification`
--
ALTER TABLE `admin_send_notification`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `aff_coupons`
--
ALTER TABLE `aff_coupons`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `banner_promotion`
--
ALTER TABLE `banner_promotion`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `blog_details`
--
ALTER TABLE `blog_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `business_details`
--
ALTER TABLE `business_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `carts`
--
ALTER TABLE `carts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `check_pincode`
--
ALTER TABLE `check_pincode`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `coupon`
--
ALTER TABLE `coupon`
  MODIFY `coupon_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deliveryboys`
--
ALTER TABLE `deliveryboys`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `deliveryboy_messages_status`
--
ALTER TABLE `deliveryboy_messages_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `delivery_charge`
--
ALTER TABLE `delivery_charge`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `discover_promotion`
--
ALTER TABLE `discover_promotion`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `districts`
--
ALTER TABLE `districts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=632;

--
-- AUTO_INCREMENT for table `districts_old`
--
ALTER TABLE `districts_old`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=742;

--
-- AUTO_INCREMENT for table `district_block`
--
ALTER TABLE `district_block`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=154750;

--
-- AUTO_INCREMENT for table `district_block_old`
--
ALTER TABLE `district_block_old`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32212;

--
-- AUTO_INCREMENT for table `district_block_old2`
--
ALTER TABLE `district_block_old2`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7876;

--
-- AUTO_INCREMENT for table `fraction_therapy`
--
ALTER TABLE `fraction_therapy`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `gallery_image`
--
ALTER TABLE `gallery_image`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `gallery_tittle`
--
ALTER TABLE `gallery_tittle`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `groups`
--
ALTER TABLE `groups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `ingredients_for_product`
--
ALTER TABLE `ingredients_for_product`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;

--
-- AUTO_INCREMENT for table `main_group`
--
ALTER TABLE `main_group`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mobile_notification`
--
ALTER TABLE `mobile_notification`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=968;

--
-- AUTO_INCREMENT for table `mobile_sliders`
--
ALTER TABLE `mobile_sliders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `offer_detail`
--
ALTER TABLE `offer_detail`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=345;

--
-- AUTO_INCREMENT for table `offer_product_detail`
--
ALTER TABLE `offer_product_detail`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=285;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `order_status`
--
ALTER TABLE `order_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `order_status_name`
--
ALTER TABLE `order_status_name`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `order_tables`
--
ALTER TABLE `order_tables`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `outlate_opening_stock`
--
ALTER TABLE `outlate_opening_stock`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `outlet_product_stock`
--
ALTER TABLE `outlet_product_stock`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `outlet_series`
--
ALTER TABLE `outlet_series`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=549;

--
-- AUTO_INCREMENT for table `payment_descriptions`
--
ALTER TABLE `payment_descriptions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=219;

--
-- AUTO_INCREMENT for table `permissions_17_dec_22`
--
ALTER TABLE `permissions_17_dec_22`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=121;

--
-- AUTO_INCREMENT for table `permissions_23-12-2022`
--
ALTER TABLE `permissions_23-12-2022`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=187;

--
-- AUTO_INCREMENT for table `printer_setting`
--
ALTER TABLE `printer_setting`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT for table `product_categories`
--
ALTER TABLE `product_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `product_categories_23-12-2022`
--
ALTER TABLE `product_categories_23-12-2022`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `product_filter`
--
ALTER TABLE `product_filter`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=980;

--
-- AUTO_INCREMENT for table `product_images`
--
ALTER TABLE `product_images`
  MODIFY `image_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=239;

--
-- AUTO_INCREMENT for table `product_types`
--
ALTER TABLE `product_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=390;

--
-- AUTO_INCREMENT for table `product_types_23-12-22`
--
ALTER TABLE `product_types_23-12-22`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;

--
-- AUTO_INCREMENT for table `promotion`
--
ALTER TABLE `promotion`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `ratings`
--
ALTER TABLE `ratings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `reviews_testimonials`
--
ALTER TABLE `reviews_testimonials`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7117;

--
-- AUTO_INCREMENT for table `role_has_permissions17dec22`
--
ALTER TABLE `role_has_permissions17dec22`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4457;

--
-- AUTO_INCREMENT for table `series`
--
ALTER TABLE `series`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `seriestitle`
--
ALTER TABLE `seriestitle`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `stock_transaction`
--
ALTER TABLE `stock_transaction`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=88;

--
-- AUTO_INCREMENT for table `tbl_invoice`
--
ALTER TABLE `tbl_invoice`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=84;

--
-- AUTO_INCREMENT for table `tbl_ledgers`
--
ALTER TABLE `tbl_ledgers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=590;

--
-- AUTO_INCREMENT for table `tbl_products`
--
ALTER TABLE `tbl_products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=189;

--
-- AUTO_INCREMENT for table `tbl_states`
--
ALTER TABLE `tbl_states`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `tbl_transactions`
--
ALTER TABLE `tbl_transactions`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `temp_pincode_store`
--
ALTER TABLE `temp_pincode_store`
  MODIFY `temp_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `users_18122023-1`
--
ALTER TABLE `users_18122023-1`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=539;

--
-- AUTO_INCREMENT for table `users_address`
--
ALTER TABLE `users_address`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75;

--
-- AUTO_INCREMENT for table `users_pending`
--
ALTER TABLE `users_pending`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `user_carts`
--
ALTER TABLE `user_carts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=424;
COMMIT;

