INSERT INTO `products` (`id`, `branch_id`, `product_code`, `name`, `description`, `category_id`, `sub_category_id`, `unit_id`, `brand_id`, `purchase_price`, `purchase_discount_type_id`, `purchase_tax_id`, `sale_price`, `sale_discount_type_id`, `sale_tax_id`, `product_alice`, `imei_suport`, `product_sku`, `alert_qty`, `expire_in`, `expire_date`, `rack`, `row`, `possition`, `weight`, `dimensions`, `opening_stock`, `opening_by`, `opening_date`, `image`, `status`, `warranty`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(796, NULL, '4210268926943', 'velit officiis ea', 'Doloremque excepturi adipisci aut aliquam omnis itaque veniam.', 5, NULL, NULL, 6, 95.02, NULL, NULL, 480.91, NULL, NULL, 'veniam', 0, '38220197', 42, NULL, NULL, 'fugiat', '6', '7', '6kg', '17x5cm', 248.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(797, NULL, '5818599698943', 'nostrum ab rerum', 'Nulla quibusdam sed et recusandae molestiae fugit aut ut perferendis animi totam tenetur odio.', 3, NULL, NULL, 5, 353.11, NULL, NULL, 832.48, NULL, NULL, 'temporibus', 0, '44353438', 36, NULL, '1972-01-12', 'et', '9', '9', '7kg', '32x40cm', 217.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(798, NULL, '2733549021455', 'necessitatibus voluptatem dolorum', 'Temporibus aut fuga corporis tempora nulla et magni repellendus eos debitis eum ducimus aut.', 8, NULL, NULL, 5, 110.15, NULL, NULL, 695.64, NULL, NULL, 'dicta', 0, '46167255', 35, 169, '2018-09-26', 'sint', '9', '6', '10kg', '18x7cm', 307.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(799, NULL, '0028926694950', 'aut repellendus incidunt', 'Odit est recusandae cum perferendis voluptas suscipit iure est.', 5, NULL, NULL, 4, 224.88, NULL, NULL, 248.74, NULL, NULL, 'et', 0, '89262917', 4, NULL, NULL, 'corporis', '6', '9', '6kg', '39x46cm', 265.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(800, NULL, '6183570782034', 'suscipit est quae', 'Sed molestias voluptatem molestiae maiores illum aut neque omnis quaerat.', 6, NULL, NULL, 4, 213.71, NULL, NULL, 503, NULL, NULL, 'at', 0, '62037129', 31, NULL, '1986-04-19', 'aut', '3', '8', '2kg', '49x13cm', 428.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(801, NULL, '0552484463883', 'impedit totam dolore', 'Sint voluptates officiis ea tempora tenetur ipsum soluta.', 4, NULL, NULL, 4, 156.9, NULL, NULL, 584.89, NULL, NULL, 'voluptatem', 0, '93649940', 13, NULL, '1978-09-16', 'perferendis', '8', '9', '9kg', '25x18cm', 235.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(802, NULL, '3122526616736', 'necessitatibus exercitationem illo', 'Velit animi ipsam animi quae eligendi officia vel.', 10, NULL, NULL, 1, 199.08, NULL, NULL, 733.14, NULL, NULL, 'sapiente', 0, '98009589', 2, NULL, NULL, 'sit', '6', '6', '5kg', '29x26cm', 493.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(803, NULL, '2369275502038', 'possimus aut dignissimos', 'Assumenda et rem ut illum et saepe vero ut voluptas.', 9, NULL, NULL, 4, 249.61, NULL, NULL, 253.03, NULL, NULL, 'quia', 0, '11152965', 16, 209, NULL, 'iure', '9', '1', '5kg', '10x36cm', 8.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(804, NULL, '8206904343089', 'id sequi dolor', 'Possimus sint rem molestias quibusdam cumque quisquam adipisci.', 1, NULL, NULL, 3, 338.11, NULL, NULL, 455.26, NULL, NULL, 'veritatis', 0, '78155640', 20, 70, NULL, 'fugiat', '7', '1', '1kg', '44x44cm', 334.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(805, NULL, '3470940366158', 'aspernatur itaque aut', 'Harum inventore qui et harum est incidunt cum qui facilis temporibus repudiandae perferendis adipisci.', 8, NULL, NULL, 4, 232.43, NULL, NULL, 32.15, NULL, NULL, 'eveniet', 0, '69824098', 34, 186, NULL, 'fugiat', '5', '9', '5kg', '11x47cm', 465.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(806, NULL, '5833008269095', 'necessitatibus aut architecto', 'Minus voluptatem assumenda eius et ut aliquid sit enim totam in non et occaecati.', 2, NULL, NULL, 4, 96.6, NULL, NULL, 525.93, NULL, NULL, 'commodi', 0, '31181327', 6, NULL, NULL, 'cumque', '1', '7', '3kg', '14x16cm', 435.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(807, NULL, '3216770220587', 'nostrum minima aliquam', 'Eveniet qui atque blanditiis eos qui aut saepe similique.', 1, NULL, NULL, 5, 120.42, NULL, NULL, 223.87, NULL, NULL, 'consectetur', 0, '24177641', 10, 148, '1983-10-12', 'debitis', '4', '8', '2kg', '44x33cm', 209.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(808, NULL, '1422493674855', 'provident maiores deserunt', 'Odio est harum et quo quaerat qui laudantium cupiditate exercitationem ea mollitia.', 2, NULL, NULL, 5, 294.87, NULL, NULL, 990.56, NULL, NULL, 'enim', 0, '81491834', 18, 68, NULL, 'laborum', '6', '4', '3kg', '15x25cm', 204.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(809, NULL, '9067691103640', 'animi quod eaque', 'Autem dolor est consequatur dolor ab dolor alias quia autem quas sint ut.', 7, NULL, NULL, 6, 147.39, NULL, NULL, 526.48, NULL, NULL, 'rerum', 0, '68682439', 29, NULL, '1973-11-14', 'quas', '5', '2', '10kg', '37x31cm', 194.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(810, NULL, '3851480284681', 'a dolores quas', 'Enim sed doloribus beatae natus cumque sed quia et aut vel necessitatibus.', 8, NULL, NULL, 2, 91.7, NULL, NULL, 218.72, NULL, NULL, 'qui', 0, '74718207', 31, 80, '2023-02-17', 'non', '2', '3', '3kg', '25x14cm', 74.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(811, NULL, '9373868727565', 'sapiente rerum nemo', 'Ut excepturi delectus ipsam assumenda qui quaerat voluptatum velit tempore dolor ad doloribus et.', 9, NULL, NULL, 2, 321.33, NULL, NULL, 992.2, NULL, NULL, 'ad', 0, '05440573', 23, NULL, '1993-08-07', 'nam', '8', '1', '4kg', '10x7cm', 373.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(812, NULL, '8510758062110', 'rerum debitis error', 'Aut ut voluptatem harum molestias architecto laboriosam est tempora fugiat provident iusto et nemo.', 4, NULL, NULL, 5, 97.13, NULL, NULL, 475.3, NULL, NULL, 'pariatur', 0, '74960842', 30, 104, '2003-07-17', 'necessitatibus', '8', '3', '1kg', '31x18cm', 361.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(813, NULL, '1024807665575', 'omnis sed quia', 'Facilis sint expedita et harum nihil facere libero quas veritatis temporibus.', 7, NULL, NULL, 3, 311.75, NULL, NULL, 789.23, NULL, NULL, 'ut', 0, '04100041', 37, 341, '2006-04-19', 'assumenda', '3', '5', '9kg', '16x42cm', 321.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(814, NULL, '4011297069287', 'dicta quia nisi', 'Dolorem non minima sint sed doloribus aspernatur qui.', 7, NULL, NULL, 4, 94.57, NULL, NULL, 908.82, NULL, NULL, 'corporis', 0, '22151513', 22, 337, NULL, 'accusantium', '3', '4', '2kg', '8x15cm', 297.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(815, NULL, '2233023165199', 'ipsa maxime quia', 'Est similique dolor recusandae deserunt accusantium non culpa reiciendis deleniti quasi.', 9, NULL, NULL, 5, 236.02, NULL, NULL, 393.73, NULL, NULL, 'ducimus', 0, '17520874', 22, 364, '1989-02-14', 'enim', '6', '3', '7kg', '29x10cm', 398.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(816, NULL, '4853680485171', 'rerum ea sed', 'Earum sit dolorem repellendus voluptas consequuntur excepturi nobis est ab iure modi.', 3, NULL, NULL, 3, 183.21, NULL, NULL, 415.83, NULL, NULL, 'sed', 0, '24938624', 4, NULL, '2016-10-06', 'dignissimos', '2', '1', '7kg', '20x15cm', 289.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(817, NULL, '3796393784647', 'debitis dolorem laborum', 'Reprehenderit velit placeat odit ut pariatur temporibus in.', 3, NULL, NULL, 2, 183.68, NULL, NULL, 516.17, NULL, NULL, 'amet', 0, '38763687', 6, NULL, '1972-01-28', 'quod', '2', '3', '7kg', '19x28cm', 112.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(818, NULL, '7923300961921', 'est accusamus molestiae', 'Non quaerat id dignissimos sed qui occaecati a sequi harum voluptatum et.', 10, NULL, NULL, 6, 204.95, NULL, NULL, 403.55, NULL, NULL, 'in', 0, '44768058', 45, 236, '1980-09-15', 'nesciunt', '6', '9', '6kg', '43x29cm', 226.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(819, NULL, '6213467070538', 'minima et rerum', 'Quo molestiae eius in quo aut sed saepe excepturi.', 5, NULL, NULL, 4, 77.84, NULL, NULL, 499.57, NULL, NULL, 'ut', 0, '69585357', 31, NULL, '2017-07-18', 'qui', '6', '8', '4kg', '41x16cm', 79.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(820, NULL, '5831452080532', 'rerum ea perferendis', 'Modi dolorum unde quisquam quia placeat et quaerat est esse inventore inventore porro eos.', 7, NULL, NULL, 1, 63.45, NULL, NULL, 247.76, NULL, NULL, 'a', 0, '83552380', 44, NULL, '2019-04-20', 'nihil', '9', '2', '6kg', '45x23cm', 378.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(821, NULL, '6946895988778', 'et et laborum', 'Corporis animi qui distinctio quia ratione vitae harum dolorem vitae.', 2, NULL, NULL, 5, 285.11, NULL, NULL, 317.58, NULL, NULL, 'quae', 0, '17850193', 12, NULL, NULL, 'esse', '7', '3', '1kg', '22x17cm', 322.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(822, NULL, '7265894853689', 'ad consequatur molestiae', 'Sint eveniet nisi dolores porro omnis veritatis aut facilis tenetur impedit eos.', 6, NULL, NULL, 2, 469.94, NULL, NULL, 810.34, NULL, NULL, 'voluptatum', 0, '83388606', 45, NULL, '1988-04-19', 'non', '2', '2', '1kg', '19x31cm', 125.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(823, NULL, '3216004136561', 'vel accusantium voluptatem', 'Qui atque id quo nihil consequatur est molestiae aut non ipsam molestiae doloribus labore.', 1, NULL, NULL, 6, 162.24, NULL, NULL, 911.54, NULL, NULL, 'rerum', 0, '90182488', 32, 150, NULL, 'adipisci', '4', '6', '3kg', '31x39cm', 100.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(824, NULL, '8997913404006', 'minima repellendus est', 'Repudiandae ducimus autem est ut magnam aut nesciunt nobis nulla maiores veniam quis.', 5, NULL, NULL, 6, 108.31, NULL, NULL, 94.67, NULL, NULL, 'velit', 0, '17846981', 21, NULL, '1989-10-24', 'voluptatem', '4', '8', '1kg', '35x11cm', 37.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(825, NULL, '7101165570384', 'atque autem voluptas', 'Est esse voluptatum a ut sit fuga et assumenda saepe enim aut.', 8, NULL, NULL, 4, 466.69, NULL, NULL, 171.45, NULL, NULL, 'ex', 0, '46849595', 4, NULL, '2016-12-31', 'aut', '5', '1', '6kg', '33x22cm', 415.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(826, NULL, '2868325707718', 'debitis nihil vel', 'Porro vero enim itaque est quia quis et fuga quia quia praesentium.', 4, NULL, NULL, 5, 269.12, NULL, NULL, 959.06, NULL, NULL, 'est', 0, '48935494', 27, 157, NULL, 'consequuntur', '1', '4', '1kg', '24x37cm', 272.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(827, NULL, '1365535596268', 'asperiores rerum quaerat', 'Et dolor sed voluptas et soluta id possimus et ea officia repellat.', 10, NULL, NULL, 4, 274.35, NULL, NULL, 662.2, NULL, NULL, 'nobis', 0, '11058182', 25, NULL, NULL, 'possimus', '5', '6', '4kg', '43x30cm', 198.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(828, NULL, '8150552527509', 'eaque aut non', 'Aut ratione facilis qui molestias quo quo expedita ducimus inventore sint quod.', 4, NULL, NULL, 6, 274.31, NULL, NULL, 463.1, NULL, NULL, 'perspiciatis', 0, '16525405', 41, 56, '1996-05-27', 'itaque', '8', '1', '4kg', '26x28cm', 137.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(829, NULL, '3465337151745', 'expedita autem natus', 'Dolorem eos numquam fugit molestias suscipit qui accusantium tempora laboriosam sit.', 5, NULL, NULL, 5, 315.15, NULL, NULL, 637.49, NULL, NULL, 'et', 0, '88031675', 26, 354, '2016-05-29', 'voluptas', '2', '9', '4kg', '19x44cm', 500.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(830, NULL, '2938838665178', 'rem iusto odit', 'Facere non hic quia vero dolor fuga esse non debitis facilis minima.', 1, NULL, NULL, 3, 339.26, NULL, NULL, 269.38, NULL, NULL, 'ut', 0, '15476258', 42, NULL, '2008-09-21', 'praesentium', '4', '2', '7kg', '39x15cm', 337.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(831, NULL, '4991689644004', 'explicabo a aliquid', 'Nisi est voluptatem enim illum laboriosam amet ipsum a et qui.', 4, NULL, NULL, 5, 471.11, NULL, NULL, 169.51, NULL, NULL, 'autem', 0, '95842271', 35, 171, '2007-03-01', 'quas', '3', '9', '5kg', '20x25cm', 16.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(832, NULL, '0771105276880', 'quaerat odio qui', 'Consequatur dicta voluptatum optio voluptas quaerat nihil odit ipsam dolorum.', 6, NULL, NULL, 2, 27.22, NULL, NULL, 543.12, NULL, NULL, 'accusamus', 0, '44594831', 33, 88, NULL, 'dolorum', '3', '3', '5kg', '35x43cm', 334.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(833, NULL, '7734538382811', 'omnis accusantium dolorum', 'Qui totam omnis aliquid nobis dignissimos et.', 8, NULL, NULL, 2, 369.17, NULL, NULL, 703.33, NULL, NULL, 'rem', 0, '71574356', 19, NULL, NULL, 'culpa', '5', '9', '3kg', '6x15cm', 227.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(834, NULL, '6774496727140', 'exercitationem dolores accusamus', 'Nihil labore aut deserunt dignissimos qui et consequuntur dolor unde quaerat quis amet.', 3, NULL, NULL, 4, 80, NULL, NULL, 117.33, NULL, NULL, 'consequatur', 0, '17415750', 6, NULL, '1995-03-08', 'aperiam', '6', '2', '2kg', '21x45cm', 467.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(835, NULL, '4161953579701', 'ipsam occaecati consequatur', 'Doloribus est saepe sunt minima aut et fuga consequatur.', 6, NULL, NULL, 1, 10.07, NULL, NULL, 43.92, NULL, NULL, 'aperiam', 0, '34011447', 25, 70, '1975-12-11', 'sed', '8', '6', '7kg', '49x48cm', 302.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(836, NULL, '2954730195506', 'incidunt et et', 'Eos id voluptate accusantium ab ut repellendus nihil beatae.', 1, NULL, NULL, 4, 23.86, NULL, NULL, 132.8, NULL, NULL, 'autem', 0, '71525228', 50, NULL, NULL, 'et', '8', '8', '4kg', '41x9cm', 485.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(837, NULL, '7502094718555', 'dignissimos earum placeat', 'Inventore mollitia ea porro laborum aliquam consequatur et ducimus maiores unde aut quibusdam.', 10, NULL, NULL, 5, 86.36, NULL, NULL, 410.73, NULL, NULL, 'est', 0, '43147557', 21, 347, NULL, 'quibusdam', '2', '3', '8kg', '34x32cm', 202.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(838, NULL, '7478540002489', 'eum iste voluptas', 'Voluptatum sit eveniet nihil occaecati omnis ut.', 3, NULL, NULL, 5, 65.79, NULL, NULL, 324.26, NULL, NULL, 'voluptas', 0, '88821498', 30, NULL, '1975-08-06', 'maiores', '2', '7', '9kg', '25x6cm', 302.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(839, NULL, '3104271719993', 'reiciendis provident sunt', 'Iusto maxime possimus ut doloribus voluptate sit aut.', 5, NULL, NULL, 3, 21.76, NULL, NULL, 818.16, NULL, NULL, 'possimus', 0, '72938683', 2, 155, NULL, 'ut', '4', '6', '5kg', '25x6cm', 216.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(840, NULL, '3391185123101', 'aliquid quis est', 'Rerum non laboriosam pariatur ut quia sunt officiis sed dolores dolores veritatis eius.', 1, NULL, NULL, 6, 430.63, NULL, NULL, 105.21, NULL, NULL, 'ratione', 0, '38064494', 45, 215, NULL, 'ea', '4', '9', '2kg', '49x50cm', 52.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(841, NULL, '0743440808156', 'voluptas qui vitae', 'Non sunt eos illo vitae dolore in sunt et est sint rerum est quae.', 1, NULL, NULL, 5, 31.13, NULL, NULL, 197.96, NULL, NULL, 'deserunt', 0, '74088584', 50, 193, '2006-07-16', 'doloremque', '4', '6', '10kg', '46x36cm', 171.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(842, NULL, '4620950829382', 'eligendi perspiciatis nihil', 'Quos voluptatem soluta at quibusdam nam eveniet impedit et rerum et.', 8, NULL, NULL, 6, 56.26, NULL, NULL, 82.17, NULL, NULL, 'officiis', 0, '77720900', 38, 359, '1982-02-04', 'velit', '5', '6', '4kg', '50x21cm', 376.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(843, NULL, '8178812117864', 'excepturi et aut', 'Asperiores maiores nemo unde consequatur mollitia dolorem est nisi.', 10, NULL, NULL, 2, 303.91, NULL, NULL, 26.99, NULL, NULL, 'minima', 0, '06662707', 16, NULL, NULL, 'est', '1', '9', '9kg', '7x12cm', 389.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(844, NULL, '2829926555658', 'et aut non', 'Ipsum cum necessitatibus omnis dolorem ullam consequuntur.', 7, NULL, NULL, 6, 470.34, NULL, NULL, 156.14, NULL, NULL, 'nostrum', 0, '16519046', 21, 154, '2021-03-14', 'dolor', '6', '6', '4kg', '36x10cm', 358.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(845, NULL, '6807410088239', 'excepturi voluptatem eum', 'Accusamus cumque ut distinctio est voluptatibus impedit eius adipisci sapiente velit.', 6, NULL, NULL, 4, 51.83, NULL, NULL, 823.58, NULL, NULL, 'dolores', 0, '96285640', 43, NULL, NULL, 'eveniet', '8', '9', '6kg', '48x20cm', 324.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(846, NULL, '1372317748111', 'consectetur minima explicabo', 'Voluptas culpa ad iusto laudantium beatae et ut quaerat qui porro veniam consectetur.', 1, NULL, NULL, 5, 380.1, NULL, NULL, 999.06, NULL, NULL, 'atque', 0, '30028548', 33, NULL, NULL, 'commodi', '1', '3', '6kg', '46x49cm', 201.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(847, NULL, '0142043391735', 'porro sit minima', 'Odit doloremque odio eos laboriosam ex quo possimus.', 3, NULL, NULL, 5, 344.54, NULL, NULL, 728.83, NULL, NULL, 'quo', 0, '70510287', 47, 108, NULL, 'et', '4', '8', '7kg', '12x23cm', 70.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(848, NULL, '6518648310503', 'ad ab quam', 'Suscipit reprehenderit ipsum autem maxime velit necessitatibus aut suscipit ad.', 6, NULL, NULL, 4, 410.9, NULL, NULL, 683.44, NULL, NULL, 'a', 0, '62818759', 15, 156, '1992-09-12', 'distinctio', '5', '7', '1kg', '22x5cm', 251.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(849, NULL, '2168726420378', 'atque enim dolore', 'Aut et fugit qui sunt repellat vel officiis id nihil consequatur nulla.', 6, NULL, NULL, 5, 39.58, NULL, NULL, 453.07, NULL, NULL, 'voluptatibus', 0, '60542298', 19, 135, NULL, 'odit', '9', '5', '8kg', '6x13cm', 40.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(850, NULL, '0815295973119', 'amet vitae eum', 'Excepturi illum cupiditate blanditiis itaque adipisci harum sed distinctio eaque eligendi iusto.', 8, NULL, NULL, 6, 162.53, NULL, NULL, 841.77, NULL, NULL, 'nihil', 0, '53698643', 28, 185, NULL, 'id', '3', '2', '1kg', '30x49cm', 154.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(851, NULL, '2086850327205', 'qui dolore voluptate', 'Est beatae consequatur vero labore eos quo.', 7, NULL, NULL, 1, 12.09, NULL, NULL, 40.3, NULL, NULL, 'rerum', 0, '32554434', 44, 41, NULL, 'quaerat', '7', '6', '8kg', '34x46cm', 334.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(852, NULL, '6400652347326', 'qui distinctio et', 'Non qui eligendi earum numquam neque voluptates possimus quo alias delectus.', 2, NULL, NULL, 1, 164.78, NULL, NULL, 713.77, NULL, NULL, 'eum', 0, '99252861', 39, NULL, NULL, 'architecto', '5', '8', '6kg', '50x23cm', 86.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(853, NULL, '5053615800270', 'repellat ut debitis', 'Possimus saepe consequatur hic provident deleniti voluptas minus doloribus aut veniam modi.', 2, NULL, NULL, 2, 123.83, NULL, NULL, 742.7, NULL, NULL, 'sequi', 0, '21260551', 26, 139, '1980-03-19', 'ut', '3', '3', '9kg', '19x33cm', 129.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(854, NULL, '8026438419032', 'accusamus ad officia', 'Sed reprehenderit est id consequatur provident voluptate quos maiores temporibus voluptatum.', 5, NULL, NULL, 4, 143.75, NULL, NULL, 830.28, NULL, NULL, 'quibusdam', 0, '78796713', 8, 115, '1976-07-17', 'eum', '4', '8', '9kg', '43x36cm', 82.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(855, NULL, '7646594515839', 'commodi aut qui', 'Molestiae sapiente commodi accusantium quia minus beatae quo unde laborum nesciunt.', 10, NULL, NULL, 2, 433.78, NULL, NULL, 68.53, NULL, NULL, 'voluptates', 0, '16077881', 39, NULL, '2024-06-22', 'nostrum', '5', '4', '8kg', '14x41cm', 200.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(856, NULL, '4240829724664', 'dolorem possimus vel', 'Eos eaque non eos sunt amet id quos vero.', 8, NULL, NULL, 6, 113.6, NULL, NULL, 786.83, NULL, NULL, 'reprehenderit', 0, '93561150', 12, NULL, NULL, 'doloribus', '4', '7', '10kg', '26x21cm', 292.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(857, NULL, '0354542852000', 'est consequatur ipsum', 'Hic dolores animi dolor molestiae exercitationem earum.', 4, NULL, NULL, 3, 108.28, NULL, NULL, 898.77, NULL, NULL, 'non', 0, '00968782', 38, 325, NULL, 'molestias', '2', '6', '8kg', '16x5cm', 373.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(858, NULL, '3533403824197', 'nihil ullam repellat', 'Est modi optio vel laboriosam aspernatur quae aut id maiores.', 3, NULL, NULL, 4, 411.9, NULL, NULL, 268.26, NULL, NULL, 'aut', 0, '08980168', 26, 203, '2007-10-30', 'sint', '3', '5', '10kg', '48x34cm', 196.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(859, NULL, '2837166011186', 'consequatur ex incidunt', 'Voluptatem et velit tenetur et et et animi dolorum nam.', 4, NULL, NULL, 1, 56.36, NULL, NULL, 159.03, NULL, NULL, 'molestias', 0, '63335040', 17, NULL, NULL, 'corporis', '5', '1', '3kg', '39x19cm', 323.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(860, NULL, '8937938601851', 'delectus sapiente nesciunt', 'Eos provident consequatur id sint error dicta maxime nostrum dignissimos sapiente consequatur explicabo.', 4, NULL, NULL, 1, 21.55, NULL, NULL, 592.95, NULL, NULL, 'placeat', 0, '86156691', 31, NULL, NULL, 'vel', '1', '4', '5kg', '24x33cm', 352.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(861, NULL, '6706585755482', 'doloremque autem sequi', 'Quam hic quidem voluptate aut quis ut dolor qui libero.', 7, NULL, NULL, 5, 440.08, NULL, NULL, 473.53, NULL, NULL, 'veritatis', 0, '54616592', 13, NULL, NULL, 'et', '2', '5', '5kg', '47x14cm', 51.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(862, NULL, '8054602515266', 'et sunt ut', 'Accusantium cupiditate alias tenetur ut occaecati expedita dolore nulla aut repudiandae laudantium illum.', 9, NULL, NULL, 1, 73.21, NULL, NULL, 297.56, NULL, NULL, 'optio', 0, '57355245', 47, 234, '2014-07-08', 'culpa', '9', '3', '2kg', '23x32cm', 92.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(863, NULL, '1935816543283', 'maxime aut animi', 'Reiciendis rem quaerat modi non libero impedit unde repudiandae itaque.', 7, NULL, NULL, 3, 122.63, NULL, NULL, 147.09, NULL, NULL, 'voluptates', 0, '63318418', 2, NULL, NULL, 'qui', '5', '8', '5kg', '26x10cm', 14.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(864, NULL, '4396931257719', 'a perferendis molestiae', 'Quos ipsa aliquid excepturi est ea qui similique dicta consectetur fugit.', 2, NULL, NULL, 3, 135.03, NULL, NULL, 929.88, NULL, NULL, 'temporibus', 0, '55752169', 9, 89, NULL, 'eos', '6', '5', '4kg', '8x28cm', 308.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(865, NULL, '1698630468292', 'temporibus et quia', 'Rerum beatae eaque libero voluptatibus corrupti cupiditate consectetur aut.', 4, NULL, NULL, 1, 455.94, NULL, NULL, 67.45, NULL, NULL, 'molestiae', 0, '36483532', 19, NULL, '1997-10-21', 'voluptas', '8', '9', '7kg', '37x43cm', 350.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(866, NULL, '5435159109239', 'delectus ipsum sit', 'Dolores nihil amet et et inventore quas.', 8, NULL, NULL, 2, 239.86, NULL, NULL, 942.27, NULL, NULL, 'consectetur', 0, '10761519', 25, NULL, NULL, 'dolor', '3', '7', '6kg', '9x25cm', 198.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(867, NULL, '1856391255678', 'consequatur dolorem explicabo', 'Recusandae aut dignissimos doloribus nostrum quis ab voluptatum deleniti eos nihil.', 6, NULL, NULL, 1, 209.04, NULL, NULL, 496.76, NULL, NULL, 'beatae', 0, '50615117', 35, NULL, '2018-01-04', 'ratione', '2', '8', '6kg', '29x11cm', 12.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(868, NULL, '6839720293034', 'assumenda quis repellat', 'Aliquam soluta eaque voluptas qui quidem odio est rerum facilis harum in doloremque a.', 3, NULL, NULL, 4, 21.67, NULL, NULL, 384.34, NULL, NULL, 'vel', 0, '06039899', 44, 344, NULL, 'quisquam', '9', '6', '5kg', '39x41cm', 200.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(869, NULL, '3296148776021', 'voluptas deleniti voluptates', 'Fuga aspernatur sed natus ut natus non doloremque recusandae.', 8, NULL, NULL, 1, 376.51, NULL, NULL, 59.78, NULL, NULL, 'et', 0, '39411471', 43, 47, NULL, 'praesentium', '3', '1', '10kg', '36x10cm', 32.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(870, NULL, '9359235686697', 'accusamus iste adipisci', 'Voluptatem quia voluptatem voluptas earum et voluptatem eveniet vitae numquam vero nulla vero et.', 5, NULL, NULL, 6, 203.17, NULL, NULL, 564.83, NULL, NULL, 'dolore', 0, '41234563', 8, NULL, NULL, 'maiores', '5', '8', '3kg', '19x21cm', 472.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(871, NULL, '4854782097149', 'pariatur beatae autem', 'Consequatur quo at quo rerum fuga doloribus velit.', 7, NULL, NULL, 5, 436.27, NULL, NULL, 801.29, NULL, NULL, 'nihil', 0, '96167465', 9, 198, NULL, 'magni', '9', '3', '3kg', '16x42cm', 92.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(872, NULL, '0956340438518', 'quae quas magnam', 'Excepturi aliquid molestiae dolorem dignissimos aut ut est deleniti sunt corporis quaerat autem sed.', 8, NULL, NULL, 3, 430.26, NULL, NULL, 961.78, NULL, NULL, 'ducimus', 0, '28814252', 25, 311, NULL, 'alias', '6', '6', '7kg', '11x36cm', 268.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(873, NULL, '7390699193842', 'alias consequuntur ratione', 'Ducimus tenetur excepturi soluta consequatur molestias et est veritatis voluptatum enim ullam nisi.', 4, NULL, NULL, 5, 370.62, NULL, NULL, 267.47, NULL, NULL, 'temporibus', 0, '62745321', 43, NULL, '2025-05-02', 'voluptatum', '6', '6', '7kg', '25x41cm', 308.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(874, NULL, '4465316015678', 'enim aut illo', 'Fuga voluptatem sed voluptas architecto ducimus ut repellendus dolores necessitatibus labore saepe.', 10, NULL, NULL, 3, 480.73, NULL, NULL, 905.88, NULL, NULL, 'et', 0, '20986131', 2, 300, NULL, 'fugiat', '8', '3', '1kg', '26x41cm', 129.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(875, NULL, '9774498647511', 'et ut dolorem', 'Quia iste in adipisci aperiam recusandae non vero ex harum quae aliquam earum iusto.', 3, NULL, NULL, 1, 125.29, NULL, NULL, 983.99, NULL, NULL, 'quidem', 0, '70378030', 25, 117, '2002-09-27', 'asperiores', '4', '1', '8kg', '22x35cm', 147.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(876, NULL, '7070646735140', 'veritatis deleniti quo', 'Distinctio libero optio aut molestiae reprehenderit eligendi nulla.', 2, NULL, NULL, 2, 382.39, NULL, NULL, 695.46, NULL, NULL, 'rerum', 0, '41461822', 41, NULL, NULL, 'reprehenderit', '2', '3', '4kg', '20x27cm', 359.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(877, NULL, '9273074968939', 'in nemo soluta', 'Sed dolorem et magnam adipisci quis nesciunt.', 2, NULL, NULL, 6, 63.9, NULL, NULL, 106.53, NULL, NULL, 'eum', 0, '17103503', 15, 196, NULL, 'consectetur', '9', '1', '3kg', '36x25cm', 250.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(878, NULL, '4591466850927', 'molestiae sunt saepe', 'Excepturi praesentium libero ab et rerum error at.', 2, NULL, NULL, 2, 418.05, NULL, NULL, 470.08, NULL, NULL, 'qui', 0, '28032953', 37, 124, NULL, 'consectetur', '3', '1', '10kg', '44x13cm', 224.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(879, NULL, '9238171710409', 'dignissimos reprehenderit eius', 'Cumque est eius qui iure voluptatem autem aut sequi distinctio voluptatem dolores itaque.', 9, NULL, NULL, 5, 105.16, NULL, NULL, 400.59, NULL, NULL, 'ea', 0, '02956213', 38, NULL, NULL, 'assumenda', '6', '5', '8kg', '29x41cm', 307.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(880, NULL, '5908132413642', 'quae dolorem rerum', 'Expedita doloremque blanditiis aut laudantium esse quibusdam commodi qui dolorem et voluptate.', 5, NULL, NULL, 1, 266.92, NULL, NULL, 848.79, NULL, NULL, 'enim', 0, '48754996', 32, 108, NULL, 'ad', '5', '1', '6kg', '50x47cm', 283.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(881, NULL, '4445911500960', 'quo sequi ipsum', 'Itaque in voluptas nam totam perspiciatis doloribus rerum provident.', 9, NULL, NULL, 1, 353.25, NULL, NULL, 107.36, NULL, NULL, 'optio', 0, '27353950', 42, NULL, '1973-06-03', 'laborum', '9', '8', '10kg', '19x43cm', 379.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(882, NULL, '8473814746921', 'amet illo blanditiis', 'Assumenda pariatur maiores maxime aut quo quos blanditiis quia.', 2, NULL, NULL, 3, 76.98, NULL, NULL, 163.89, NULL, NULL, 'eaque', 0, '66490401', 45, 287, '2017-12-20', 'aut', '7', '3', '5kg', '44x45cm', 264.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(883, NULL, '7189743589539', 'aut sint cumque', 'Voluptatibus quidem culpa distinctio architecto maxime quibusdam assumenda consequatur reprehenderit unde et harum.', 4, NULL, NULL, 4, 50.87, NULL, NULL, 233.06, NULL, NULL, 'et', 0, '53752321', 47, NULL, NULL, 'debitis', '7', '2', '2kg', '24x28cm', 371.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(884, NULL, '4262821610387', 'tenetur fugiat vel', 'Maxime dolor et exercitationem quia iure ipsam quisquam non repellat cupiditate.', 7, NULL, NULL, 5, 416.83, NULL, NULL, 479.01, NULL, NULL, 'excepturi', 0, '72552469', 25, NULL, '1996-03-28', 'voluptatem', '5', '5', '5kg', '14x47cm', 212.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(885, NULL, '6102504682059', 'tenetur ut enim', 'Omnis eos aut qui et cupiditate quo et est vel quis est accusamus.', 3, NULL, NULL, 2, 350.13, NULL, NULL, 396.5, NULL, NULL, 'sunt', 0, '13237073', 46, NULL, '2004-09-10', 'repudiandae', '4', '9', '3kg', '17x15cm', 85.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(886, NULL, '9123084988017', 'id facilis cumque', 'Labore eius quisquam et voluptas est dolore qui.', 9, NULL, NULL, 3, 158.69, NULL, NULL, 991.98, NULL, NULL, 'et', 0, '61247222', 12, NULL, NULL, 'voluptate', '9', '8', '5kg', '49x9cm', 208.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(887, NULL, '4741945348012', 'sed dolor fugiat', 'Est nostrum praesentium accusantium error nobis voluptatum tempora ratione perspiciatis.', 2, NULL, NULL, 3, 106.15, NULL, NULL, 546.68, NULL, NULL, 'commodi', 0, '26151229', 22, NULL, '1979-02-15', 'commodi', '2', '2', '7kg', '14x7cm', 197.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(888, NULL, '8455870779648', 'magni unde velit', 'Dolore qui numquam ab quis omnis sit consectetur repellat ad.', 8, NULL, NULL, 3, 273.04, NULL, NULL, 437.03, NULL, NULL, 'neque', 0, '97793335', 4, 172, NULL, 'vero', '7', '2', '7kg', '15x21cm', 65.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(889, NULL, '9940592174332', 'qui culpa quia', 'Dolorem repellat est accusamus delectus est molestiae nobis eligendi.', 2, NULL, NULL, 1, 303, NULL, NULL, 782.66, NULL, NULL, 'sapiente', 0, '78624627', 42, 308, NULL, 'expedita', '7', '4', '3kg', '16x36cm', 321.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(890, NULL, '4184780527073', 'natus quas atque', 'Perferendis esse et non mollitia culpa omnis possimus est sed et.', 5, NULL, NULL, 2, 283.13, NULL, NULL, 530.75, NULL, NULL, 'et', 0, '67355945', 41, 194, '1987-12-07', 'culpa', '6', '8', '2kg', '8x11cm', 483.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(891, NULL, '5435311122755', 'omnis necessitatibus qui', 'Ab delectus ipsum ullam minima rerum cum ut fuga ipsum qui provident sit distinctio.', 5, NULL, NULL, 2, 142.68, NULL, NULL, 972.32, NULL, NULL, 'eligendi', 0, '28573807', 50, NULL, NULL, 'magnam', '1', '6', '6kg', '41x8cm', 41.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(892, NULL, '7432266877141', 'qui non quia', 'Quisquam est ut ducimus sunt aliquid excepturi libero nostrum nobis pariatur sit.', 6, NULL, NULL, 1, 127.43, NULL, NULL, 783.53, NULL, NULL, 'quisquam', 0, '36705634', 3, 132, '2019-08-24', 'corporis', '7', '2', '5kg', '43x45cm', 61.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(893, NULL, '0161821770197', 'velit repellendus vel', 'Molestiae omnis est quae et sed aut aut ut.', 1, NULL, NULL, 1, 200.88, NULL, NULL, 552.73, NULL, NULL, 'minima', 0, '34490792', 34, 81, '1996-06-28', 'aut', '3', '1', '3kg', '10x15cm', 208.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(894, NULL, '4330193948138', 'est quas inventore', 'Deserunt nam ipsam perspiciatis aliquid voluptas quisquam aut rerum voluptas quos.', 4, NULL, NULL, 6, 249.7, NULL, NULL, 682.65, NULL, NULL, 'quam', 0, '50088195', 28, NULL, NULL, 'soluta', '7', '2', '7kg', '24x14cm', 220.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(895, NULL, '4691187297282', 'sint omnis nobis', 'Consequuntur doloribus reprehenderit enim dolorum odit placeat repellendus quo et nihil pariatur et.', 5, NULL, NULL, 6, 280.11, NULL, NULL, 493.15, NULL, NULL, 'nihil', 0, '51361211', 2, 34, NULL, 'est', '5', '7', '5kg', '46x26cm', 475.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(896, NULL, '0665768581620', 'optio ullam aliquam', 'Vel et nostrum esse et sequi illo et est.', 8, NULL, NULL, 5, 232.6, NULL, NULL, 30.48, NULL, NULL, 'omnis', 0, '07979163', 44, NULL, NULL, 'ut', '2', '2', '5kg', '46x29cm', 376.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(897, NULL, '5793859166953', 'laborum labore tenetur', 'Quod quo et id distinctio nihil optio doloremque.', 2, NULL, NULL, 6, 408.52, NULL, NULL, 994.28, NULL, NULL, 'minus', 0, '55007559', 29, 33, NULL, 'culpa', '1', '9', '7kg', '45x50cm', 15.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(898, NULL, '9808895478451', 'ab vel cupiditate', 'Nemo maiores officia quia ea et in libero dolores.', 4, NULL, NULL, 6, 423.09, NULL, NULL, 506.26, NULL, NULL, 'voluptatem', 0, '75873530', 6, 165, '1996-08-09', 'earum', '1', '1', '1kg', '50x43cm', 215.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(899, NULL, '3659021977944', 'voluptatem delectus quia', 'Blanditiis rerum qui facere voluptatem quasi quidem nam eaque.', 3, NULL, NULL, 5, 321.23, NULL, NULL, 828.11, NULL, NULL, 'totam', 0, '13235697', 32, 35, '2002-02-13', 'et', '5', '3', '3kg', '20x22cm', 468.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(900, NULL, '7361326413060', 'cupiditate modi eaque', 'Quos aut eum pariatur a nostrum similique id eius laboriosam blanditiis enim.', 1, NULL, NULL, 3, 336.02, NULL, NULL, 385.46, NULL, NULL, 'facere', 0, '95783291', 50, NULL, '2003-01-28', 'sit', '8', '6', '7kg', '38x23cm', 307.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(901, NULL, '7414329052481', 'quis aut quidem', 'Et est facilis et voluptas ea aspernatur excepturi sapiente iste vitae.', 8, NULL, NULL, 1, 391.6, NULL, NULL, 433.46, NULL, NULL, 'et', 0, '88571805', 21, NULL, '1976-09-22', 'tempora', '6', '1', '7kg', '14x5cm', 280.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(902, NULL, '5679945347119', 'sapiente harum ducimus', 'Ipsum sit reprehenderit earum eius nulla reprehenderit omnis aspernatur voluptas voluptatem fugit est ex.', 3, NULL, NULL, 1, 389.13, NULL, NULL, 823.2, NULL, NULL, 'vitae', 0, '56892437', 43, NULL, NULL, 'aliquam', '2', '8', '10kg', '28x44cm', 390.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(903, NULL, '8742546817583', 'occaecati quis minima', 'Dolore omnis reprehenderit ut odio porro beatae est dolorum iste commodi animi et nam.', 8, NULL, NULL, 2, 207.17, NULL, NULL, 829.73, NULL, NULL, 'minima', 0, '12403905', 11, 181, '1997-02-15', 'quod', '6', '5', '10kg', '19x50cm', 404.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(904, NULL, '6064626715209', 'minus et modi', 'Fugit dignissimos voluptatem quod assumenda porro nisi id similique illo et.', 5, NULL, NULL, 4, 94.2, NULL, NULL, 373.27, NULL, NULL, 'aut', 0, '24964319', 9, NULL, NULL, 'aliquam', '6', '4', '4kg', '15x24cm', 293.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(905, NULL, '7236586083318', 'consequatur eaque nesciunt', 'Quis sequi porro repudiandae dolorem enim labore.', 6, NULL, NULL, 6, 32.32, NULL, NULL, 110.2, NULL, NULL, 'nihil', 0, '85152564', 49, NULL, NULL, 'est', '6', '7', '10kg', '44x36cm', 224.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(906, NULL, '6841244218936', 'nisi incidunt unde', 'Est tempora excepturi mollitia dolores et mollitia.', 5, NULL, NULL, 2, 477.75, NULL, NULL, 838.73, NULL, NULL, 'est', 0, '33819471', 38, 292, '1980-09-30', 'optio', '8', '6', '3kg', '12x6cm', 268.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(907, NULL, '9086046358931', 'temporibus rerum fuga', 'Adipisci nesciunt nulla non totam officiis dolorem et tempora nihil.', 1, NULL, NULL, 2, 235.95, NULL, NULL, 516.63, NULL, NULL, 'et', 0, '94589399', 44, NULL, NULL, 'molestias', '1', '5', '9kg', '12x37cm', 456.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(908, NULL, '2355191656863', 'omnis laboriosam ut', 'Nemo delectus molestias eos repellendus quas maiores nihil corporis.', 2, NULL, NULL, 1, 373.69, NULL, NULL, 620.9, NULL, NULL, 'omnis', 0, '88272917', 35, 76, NULL, 'reprehenderit', '1', '5', '7kg', '45x13cm', 406.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(909, NULL, '1882793926182', 'sed eos porro', 'Velit provident odio distinctio in corrupti quasi illum et quia.', 6, NULL, NULL, 5, 433.47, NULL, NULL, 114.79, NULL, NULL, 'enim', 0, '63397017', 44, NULL, NULL, 'sit', '4', '2', '5kg', '10x36cm', 334.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(910, NULL, '3230439618157', 'placeat ut est', 'Voluptate suscipit omnis temporibus mollitia aut perspiciatis.', 10, NULL, NULL, 2, 473.28, NULL, NULL, 791.38, NULL, NULL, 'quasi', 0, '05161881', 4, 235, NULL, 'nobis', '7', '3', '9kg', '18x25cm', 176.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(911, NULL, '6568014879943', 'perferendis et molestiae', 'Saepe atque sunt officia quo quos et impedit neque reiciendis quia assumenda.', 7, NULL, NULL, 6, 126.72, NULL, NULL, 538.98, NULL, NULL, 'eaque', 0, '41970843', 2, NULL, NULL, 'sit', '2', '1', '3kg', '21x35cm', 205.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(912, NULL, '7143890740656', 'rem praesentium fuga', 'Molestiae saepe temporibus suscipit porro magni quis.', 9, NULL, NULL, 5, 425.06, NULL, NULL, 901.23, NULL, NULL, 'quisquam', 0, '16823778', 43, 118, '1981-02-17', 'dolores', '2', '5', '10kg', '9x23cm', 206.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(913, NULL, '2136342935507', 'animi doloremque vel', 'Consequuntur aut neque cum delectus est laboriosam doloribus.', 5, NULL, NULL, 1, 155.4, NULL, NULL, 521.24, NULL, NULL, 'deserunt', 0, '75146269', 8, NULL, '1993-11-03', 'quae', '9', '6', '8kg', '46x21cm', 83.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(914, NULL, '7455375042064', 'nihil quo voluptas', 'Aliquam harum voluptas velit tenetur quo dignissimos officia sunt qui explicabo hic dignissimos quae.', 6, NULL, NULL, 1, 412.77, NULL, NULL, 940.41, NULL, NULL, 'amet', 0, '20827168', 40, NULL, NULL, 'sit', '6', '1', '10kg', '49x26cm', 204.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(915, NULL, '3133277783622', 'laborum nam necessitatibus', 'Ad veritatis quo deleniti dolorem nisi nisi et dignissimos perspiciatis sunt est culpa et.', 1, NULL, NULL, 4, 364.17, NULL, NULL, 574.09, NULL, NULL, 'nisi', 0, '05168552', 24, 165, '1990-06-08', 'et', '5', '2', '5kg', '26x11cm', 68.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(916, NULL, '1259818506924', 'in quasi distinctio', 'Blanditiis qui esse sint reprehenderit sed pariatur aspernatur in.', 4, NULL, NULL, 1, 385.96, NULL, NULL, 528.68, NULL, NULL, 'eaque', 0, '12104796', 10, NULL, '2016-03-28', 'repellat', '4', '4', '6kg', '5x50cm', 183.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(917, NULL, '4847252685847', 'et quisquam sed', 'Voluptas dolores eligendi impedit maiores quia voluptas enim voluptatum qui ut animi quia porro.', 8, NULL, NULL, 3, 150.71, NULL, NULL, 72.32, NULL, NULL, 'ab', 0, '12322411', 19, 151, '2025-05-12', 'quae', '6', '9', '6kg', '47x12cm', 412.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(918, NULL, '5164962754786', 'voluptatem harum est', 'Reprehenderit soluta mollitia doloremque qui ipsum ipsum.', 2, NULL, NULL, 3, 431.24, NULL, NULL, 110.17, NULL, NULL, 'excepturi', 0, '49199468', 21, 364, '1990-07-22', 'consectetur', '6', '5', '2kg', '13x50cm', 163.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(919, NULL, '3396465073879', 'quidem eveniet voluptatem', 'Impedit odio facilis error harum vel sit ut ratione sit laboriosam deleniti voluptatem.', 5, NULL, NULL, 2, 38.1, NULL, NULL, 679.62, NULL, NULL, 'quis', 0, '17260985', 23, NULL, '2025-01-29', 'iusto', '8', '1', '1kg', '12x30cm', 495.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(920, NULL, '7074334028675', 'recusandae ipsam dolor', 'Cupiditate nam qui dolorem et suscipit laborum.', 4, NULL, NULL, 3, 376.35, NULL, NULL, 985.48, NULL, NULL, 'eligendi', 0, '61629974', 30, 270, '2016-11-28', 'non', '6', '3', '6kg', '9x44cm', 148.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(921, NULL, '4643123916276', 'assumenda quam soluta', 'Vel asperiores autem aut consequatur quibusdam aspernatur.', 9, NULL, NULL, 5, 150, NULL, NULL, 105.9, NULL, NULL, 'impedit', 0, '28575481', 21, 313, NULL, 'ullam', '9', '7', '1kg', '22x36cm', 127.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(922, NULL, '3007514715168', 'ipsam vitae sed', 'Est et repellat itaque odit fugiat aut earum aut eum aperiam quo harum.', 2, NULL, NULL, 2, 307.49, NULL, NULL, 305.28, NULL, NULL, 'repudiandae', 0, '70518719', 16, NULL, NULL, 'ipsam', '5', '1', '6kg', '7x44cm', 407.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(923, NULL, '5145772451621', 'tempore et consequatur', 'Sint libero beatae ullam maxime est sapiente ullam nam impedit.', 5, NULL, NULL, 2, 48.91, NULL, NULL, 788.46, NULL, NULL, 'explicabo', 0, '64658216', 11, NULL, NULL, 'repellat', '8', '7', '9kg', '21x23cm', 145.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(924, NULL, '2283374350690', 'iste dolorum veniam', 'Vero et necessitatibus occaecati aut dolorum maiores.', 6, NULL, NULL, 1, 59.22, NULL, NULL, 207.34, NULL, NULL, 'sed', 0, '55398169', 41, 364, '1985-08-06', 'eum', '6', '2', '7kg', '6x13cm', 421.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(925, NULL, '9119210730254', 'qui voluptate quaerat', 'Ab facere laudantium esse voluptas labore laborum odio sed libero occaecati placeat facere.', 8, NULL, NULL, 3, 156.69, NULL, NULL, 221.32, NULL, NULL, 'autem', 0, '18792225', 5, NULL, '1974-09-28', 'non', '1', '5', '10kg', '33x32cm', 215.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(926, NULL, '2754088586106', 'ipsam quia rerum', 'Molestiae aut id quis sit quidem distinctio perspiciatis.', 3, NULL, NULL, 6, 131.1, NULL, NULL, 567.92, NULL, NULL, 'ut', 0, '62374170', 23, NULL, NULL, 'dolores', '9', '9', '2kg', '28x43cm', 102.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(927, NULL, '8271911280078', 'asperiores velit voluptas', 'Voluptatibus quasi dolorem exercitationem aliquam ducimus facere quisquam aut aspernatur.', 4, NULL, NULL, 1, 480.48, NULL, NULL, 277.53, NULL, NULL, 'omnis', 0, '99985301', 30, NULL, '1987-05-25', 'harum', '3', '2', '5kg', '31x36cm', 483.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03');
INSERT INTO `products` (`id`, `branch_id`, `product_code`, `name`, `description`, `category_id`, `sub_category_id`, `unit_id`, `brand_id`, `purchase_price`, `purchase_discount_type_id`, `purchase_tax_id`, `sale_price`, `sale_discount_type_id`, `sale_tax_id`, `product_alice`, `imei_suport`, `product_sku`, `alert_qty`, `expire_in`, `expire_date`, `rack`, `row`, `possition`, `weight`, `dimensions`, `opening_stock`, `opening_by`, `opening_date`, `image`, `status`, `warranty`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(928, NULL, '0865137581279', 'itaque et odio', 'Nemo sunt ex quia nobis ab iusto.', 3, NULL, NULL, 1, 39.99, NULL, NULL, 82.2, NULL, NULL, 'rerum', 0, '65553671', 24, 314, '1973-08-09', 'repudiandae', '5', '4', '4kg', '45x8cm', 26.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(929, NULL, '1355757816213', 'consequatur veritatis ut', 'Aut fugiat enim aut quidem quidem veniam earum quas iusto error voluptatem voluptas maiores distinctio.', 1, NULL, NULL, 1, 181.71, NULL, NULL, 304.18, NULL, NULL, 'consequuntur', 0, '91900579', 34, 207, '1983-06-02', 'qui', '6', '1', '8kg', '14x24cm', 206.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(930, NULL, '0936245656507', 'consequuntur quis libero', 'Aut consequatur corrupti quidem nihil saepe iusto necessitatibus sint ut eveniet similique distinctio.', 3, NULL, NULL, 1, 308.78, NULL, NULL, 514.81, NULL, NULL, 'neque', 0, '85593091', 22, NULL, NULL, 'totam', '5', '8', '4kg', '9x27cm', 210.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(931, NULL, '7539458301313', 'tempore debitis sunt', 'Aut nisi odit vel ut nostrum vitae rerum ipsa deserunt tempora commodi quae.', 5, NULL, NULL, 2, 64.89, NULL, NULL, 840.07, NULL, NULL, 'quisquam', 0, '40555591', 2, 151, NULL, 'autem', '3', '8', '9kg', '7x14cm', 255.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(932, NULL, '8307297970149', 'dicta aut corporis', 'Rem eos voluptates expedita officiis illum quas odio velit nostrum doloribus autem.', 5, NULL, NULL, 1, 457.71, NULL, NULL, 116.4, NULL, NULL, 'est', 0, '50593903', 50, 200, '1998-07-16', 'earum', '1', '1', '3kg', '23x13cm', 261.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(933, NULL, '6248022912688', 'facilis ut nesciunt', 'Sint repudiandae aut quo et velit vel sapiente debitis laboriosam.', 7, NULL, NULL, 6, 180.99, NULL, NULL, 462.91, NULL, NULL, 'eius', 0, '02482224', 3, NULL, NULL, 'doloremque', '8', '3', '8kg', '29x24cm', 73.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(934, NULL, '2036180576583', 'consequuntur error accusantium', 'Quibusdam et qui quibusdam et et eaque autem porro quod velit accusantium error.', 4, NULL, NULL, 5, 41.75, NULL, NULL, 630.01, NULL, NULL, 'repudiandae', 0, '38990106', 25, NULL, '1981-03-24', 'est', '3', '1', '9kg', '14x36cm', 202.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(935, NULL, '1469094086892', 'laborum qui molestias', 'Nihil non et enim et et provident.', 6, NULL, NULL, 6, 332.35, NULL, NULL, 874.33, NULL, NULL, 'deserunt', 0, '15286055', 18, 31, '2013-07-03', 'ab', '5', '3', '10kg', '11x7cm', 188.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(936, NULL, '5047066953937', 'deleniti natus animi', 'Reprehenderit sunt neque dolor ratione excepturi et asperiores.', 1, NULL, NULL, 4, 222.1, NULL, NULL, 537.09, NULL, NULL, 'est', 0, '33476513', 40, NULL, NULL, 'et', '6', '5', '5kg', '6x15cm', 464.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(937, NULL, '8381100529519', 'non voluptate ipsam', 'Ut qui minima minus optio quo illo ea enim corrupti eveniet facere.', 5, NULL, NULL, 3, 252.36, NULL, NULL, 664.56, NULL, NULL, 'vel', 0, '80776437', 9, 143, '1998-10-29', 'vero', '3', '7', '2kg', '33x42cm', 99.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(938, NULL, '0171166990112', 'quia quo aut', 'Et atque facere corporis maiores nesciunt ab facere molestiae ratione.', 4, NULL, NULL, 4, 323.94, NULL, NULL, 74.78, NULL, NULL, 'quod', 0, '28061991', 48, 151, NULL, 'repellendus', '4', '2', '3kg', '17x18cm', 313.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(939, NULL, '7170164169783', 'qui temporibus corporis', 'Ea quos vitae optio et sed aperiam.', 2, NULL, NULL, 3, 374.99, NULL, NULL, 994.07, NULL, NULL, 'sunt', 0, '33338835', 12, 84, '2008-04-15', 'vel', '9', '8', '6kg', '47x9cm', 18.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(940, NULL, '9962444599582', 'voluptatem fugiat voluptas', 'Omnis velit corporis quam nemo repellendus ut.', 2, NULL, NULL, 1, 313.82, NULL, NULL, 898.75, NULL, NULL, 'totam', 0, '69940965', 30, 77, NULL, 'voluptas', '5', '2', '6kg', '20x46cm', 62.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(941, NULL, '1768525293565', 'earum repellat enim', 'Atque vero in officia temporibus repudiandae nesciunt et dolorum vel et autem laudantium ipsum.', 10, NULL, NULL, 6, 202.96, NULL, NULL, 529.36, NULL, NULL, 'eius', 0, '58490822', 32, 160, NULL, 'omnis', '9', '3', '1kg', '42x20cm', 156.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(942, NULL, '8157021058960', 'inventore ad in', 'Minus alias blanditiis nam autem et repellendus voluptatem voluptatem minus ab nostrum tempora.', 5, NULL, NULL, 3, 427.82, NULL, NULL, 779.57, NULL, NULL, 'iusto', 0, '25352610', 5, NULL, '1984-01-17', 'deleniti', '3', '2', '6kg', '12x13cm', 216.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(943, NULL, '9336478762159', 'earum similique repellendus', 'Neque numquam quia quas quod dolores velit aut.', 6, NULL, NULL, 3, 221.73, NULL, NULL, 95.81, NULL, NULL, 'reprehenderit', 0, '83276316', 36, 114, NULL, 'beatae', '4', '3', '1kg', '21x23cm', 70.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(944, NULL, '2886657432504', 'fugiat et dignissimos', 'Eum et in corrupti quas voluptates explicabo.', 3, NULL, NULL, 3, 228.71, NULL, NULL, 232.03, NULL, NULL, 'enim', 0, '14710094', 19, 200, NULL, 'optio', '8', '6', '2kg', '16x16cm', 84.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(945, NULL, '7453317256517', 'totam ex alias', 'Vero labore et cumque alias suscipit non ullam consectetur.', 2, NULL, NULL, 4, 12.04, NULL, NULL, 932.94, NULL, NULL, 'deleniti', 0, '00904209', 21, 151, '1996-09-23', 'dignissimos', '4', '3', '8kg', '27x21cm', 340.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(946, NULL, '6137066863257', 'repellat exercitationem ut', 'Et impedit libero non itaque fugiat unde minima eum et eius.', 6, NULL, NULL, 3, 497.17, NULL, NULL, 466.19, NULL, NULL, 'autem', 0, '31900911', 23, 76, NULL, 'consequuntur', '9', '3', '5kg', '8x43cm', 426.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(947, NULL, '0813173084360', 'repellat voluptas reprehenderit', 'Alias ex tenetur autem et ab ratione suscipit ut.', 7, NULL, NULL, 3, 267.37, NULL, NULL, 881.88, NULL, NULL, 'consequatur', 0, '03654842', 32, NULL, NULL, 'illo', '6', '5', '7kg', '5x40cm', 284.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(948, NULL, '1232887098811', 'error laudantium qui', 'Error dolorem soluta debitis ipsam quas odit reprehenderit dolor.', 5, NULL, NULL, 1, 449.2, NULL, NULL, 286.95, NULL, NULL, 'repudiandae', 0, '87987645', 34, NULL, '2024-01-09', 'ullam', '9', '7', '1kg', '40x19cm', 384.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(949, NULL, '8157024647833', 'id quas animi', 'Ut voluptas at quia ipsam debitis beatae sint sit tempore.', 10, NULL, NULL, 2, 113.04, NULL, NULL, 591.64, NULL, NULL, 'eligendi', 0, '15422927', 5, 123, '2011-07-13', 'architecto', '9', '1', '2kg', '29x41cm', 427.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(950, NULL, '0093867029277', 'odio hic veniam', 'Nihil sunt in nesciunt excepturi qui dolorum ea.', 4, NULL, NULL, 1, 264.79, NULL, NULL, 287.44, NULL, NULL, 'iste', 0, '41220542', 20, NULL, NULL, 'laudantium', '6', '4', '9kg', '24x15cm', 190.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(951, NULL, '4851743653789', 'sed fugiat recusandae', 'Omnis optio commodi doloribus id recusandae esse placeat aut earum nihil.', 5, NULL, NULL, 5, 364.77, NULL, NULL, 197.91, NULL, NULL, 'tempore', 0, '38985799', 4, 291, NULL, 'alias', '7', '5', '10kg', '43x36cm', 494.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(952, NULL, '8156912628695', 'ut delectus mollitia', 'Error laboriosam dolorem ea reiciendis ratione consequatur repudiandae laboriosam est aperiam qui eum quam.', 9, NULL, NULL, 2, 221.33, NULL, NULL, 47.8, NULL, NULL, 'sint', 0, '09491229', 43, 68, '1970-08-31', 'voluptate', '1', '8', '3kg', '22x22cm', 24.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(953, NULL, '7447743449230', 'ipsa rerum unde', 'Veritatis maiores quaerat nobis nemo vel dicta corporis deleniti.', 9, NULL, NULL, 2, 457.45, NULL, NULL, 441.38, NULL, NULL, 'officiis', 0, '74296859', 19, 308, NULL, 'vero', '1', '2', '10kg', '6x49cm', 71.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(954, NULL, '0331843575135', 'nisi culpa nemo', 'Nesciunt est voluptas alias rerum est sit reprehenderit sequi ut cupiditate recusandae quia eos.', 10, NULL, NULL, 6, 407.6, NULL, NULL, 833.97, NULL, NULL, 'dolor', 0, '63793956', 37, NULL, '1973-06-20', 'amet', '7', '4', '4kg', '5x45cm', 37.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(955, NULL, '7409053543534', 'voluptas ratione nobis', 'Rerum nostrum rerum officia iure excepturi quod ipsum ad quia voluptas quisquam.', 1, NULL, NULL, 2, 252.38, NULL, NULL, 691.97, NULL, NULL, 'quis', 0, '72011881', 27, NULL, NULL, 'officiis', '4', '7', '9kg', '10x32cm', 91.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(956, NULL, '6375513316615', 'nulla earum adipisci', 'Possimus unde odio et quia aut quasi ut consequatur quidem unde ab aspernatur.', 8, NULL, NULL, 2, 150.48, NULL, NULL, 630.38, NULL, NULL, 'eum', 0, '91321237', 37, 127, '1972-06-11', 'corporis', '9', '8', '5kg', '43x25cm', 263.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(957, NULL, '3051541623026', 'temporibus voluptatum et', 'Et dolor nostrum esse quasi enim atque beatae laudantium suscipit quaerat est voluptatem.', 3, NULL, NULL, 6, 184.6, NULL, NULL, 699.89, NULL, NULL, 'fuga', 0, '46378705', 31, 214, '2014-07-28', 'accusamus', '8', '5', '6kg', '50x16cm', 186.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(958, NULL, '6747174762948', 'voluptates quibusdam exercitationem', 'Architecto sint laborum vero ducimus numquam non.', 6, NULL, NULL, 1, 466.84, NULL, NULL, 359.79, NULL, NULL, 'eaque', 0, '33564357', 10, NULL, '2009-06-10', 'non', '6', '4', '4kg', '34x23cm', 365.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(959, NULL, '0493627281707', 'soluta voluptatem sunt', 'Facere sint sit nisi consequatur laudantium labore maiores veniam quod.', 8, NULL, NULL, 3, 148.54, NULL, NULL, 847.41, NULL, NULL, 'ut', 0, '06821937', 32, NULL, '2006-12-03', 'enim', '7', '8', '4kg', '8x8cm', 198.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(960, NULL, '6480481000241', 'doloremque impedit voluptatem', 'Suscipit tenetur odit possimus qui consequatur velit sunt iusto iste temporibus voluptas odit.', 1, NULL, NULL, 5, 419.91, NULL, NULL, 429.94, NULL, NULL, 'quo', 0, '25932904', 20, NULL, NULL, 'qui', '4', '4', '10kg', '31x25cm', 481.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(961, NULL, '8948775486556', 'autem sit modi', 'Qui maxime et iusto et in non.', 7, NULL, NULL, 3, 434.07, NULL, NULL, 220.57, NULL, NULL, 'inventore', 0, '59404095', 37, 280, NULL, 'voluptate', '7', '9', '6kg', '42x47cm', 243.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(962, NULL, '0709784378588', 'aspernatur inventore quos', 'Cumque repellat vitae voluptatem et mollitia officiis et.', 5, NULL, NULL, 6, 86.33, NULL, NULL, 844.09, NULL, NULL, 'et', 0, '84018243', 22, NULL, NULL, 'consequuntur', '4', '8', '7kg', '13x44cm', 31.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(963, NULL, '5593511684883', 'assumenda voluptatem quia', 'Quis officiis et et praesentium corrupti aut quam perspiciatis dolor qui non.', 9, NULL, NULL, 3, 191.3, NULL, NULL, 961.63, NULL, NULL, 'et', 0, '21128776', 2, 98, NULL, 'ab', '5', '9', '3kg', '36x34cm', 80.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(964, NULL, '6573530071160', 'quia voluptate rem', 'Ipsa ducimus porro dolores dolor sapiente commodi quisquam adipisci sed molestiae fugiat.', 2, NULL, NULL, 6, 79.28, NULL, NULL, 26.72, NULL, NULL, 'quis', 0, '81603053', 47, NULL, NULL, 'voluptatem', '9', '8', '9kg', '37x21cm', 476.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(965, NULL, '2341373831777', 'libero architecto fugit', 'Nulla enim sit et dolor quas sint non odit nobis repudiandae ut ut eius.', 4, NULL, NULL, 4, 475.35, NULL, NULL, 141.24, NULL, NULL, 'ad', 0, '25954982', 9, NULL, '2001-08-28', 'provident', '6', '4', '8kg', '16x29cm', 215.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(966, NULL, '6090580743217', 'impedit atque nulla', 'Dolor voluptatem sit facilis voluptas ab sit quaerat aut hic deleniti veritatis.', 6, NULL, NULL, 3, 92.99, NULL, NULL, 375.55, NULL, NULL, 'et', 0, '48136198', 33, NULL, '1983-02-25', 'esse', '1', '1', '2kg', '48x43cm', 6.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(967, NULL, '3436508018808', 'provident iure saepe', 'Ut est est amet maxime debitis quia qui quia.', 6, NULL, NULL, 1, 175.12, NULL, NULL, 861.68, NULL, NULL, 'saepe', 0, '39494252', 14, NULL, NULL, 'voluptate', '6', '7', '10kg', '11x28cm', 234.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(968, NULL, '1333040559436', 'vero distinctio enim', 'Praesentium aut et aut esse illo possimus sapiente quo dolorum accusantium omnis quas quis.', 10, NULL, NULL, 3, 233.89, NULL, NULL, 286.5, NULL, NULL, 'corrupti', 0, '17360968', 2, NULL, NULL, 'atque', '6', '1', '9kg', '23x14cm', 188.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(969, NULL, '3395818165995', 'dolores eum accusantium', 'Blanditiis iusto sit commodi aperiam autem distinctio.', 4, NULL, NULL, 1, 232.35, NULL, NULL, 105.42, NULL, NULL, 'incidunt', 0, '88209289', 47, NULL, '2022-09-22', 'fugiat', '8', '3', '3kg', '37x46cm', 129.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(970, NULL, '2575432356936', 'voluptatem voluptatem nihil', 'Nam et provident ex sequi iure aut accusamus illo officiis.', 4, NULL, NULL, 4, 64.37, NULL, NULL, 198.09, NULL, NULL, 'molestias', 0, '26886909', 25, NULL, '2001-11-27', 'perferendis', '4', '8', '1kg', '23x29cm', 175.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(971, NULL, '8433213697422', 'et dignissimos ut', 'Eum voluptatem dolores a aut voluptatem aut harum ut quo rerum neque possimus.', 2, NULL, NULL, 1, 85.48, NULL, NULL, 891.41, NULL, NULL, 'rerum', 0, '20872885', 14, NULL, NULL, 'rem', '1', '2', '6kg', '15x27cm', 119.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(972, NULL, '0840819684615', 'aut ratione pariatur', 'Facilis cumque magni unde qui cupiditate repudiandae animi vel ut optio odit.', 5, NULL, NULL, 3, 81.29, NULL, NULL, 758.45, NULL, NULL, 'nulla', 0, '03985854', 31, NULL, '2004-04-05', 'fugit', '3', '9', '6kg', '10x29cm', 374.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(973, NULL, '6313100124717', 'est eos vitae', 'Dolor sapiente aliquid eos asperiores id alias possimus magnam reprehenderit ab ab aut laboriosam.', 8, NULL, NULL, 4, 171.09, NULL, NULL, 454.93, NULL, NULL, 'inventore', 0, '62279758', 4, NULL, '2014-12-03', 'qui', '8', '4', '9kg', '29x32cm', 424.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(974, NULL, '8285820482287', 'sapiente non deserunt', 'Officia consectetur maxime magni id omnis reiciendis.', 9, NULL, NULL, 6, 376.37, NULL, NULL, 887.39, NULL, NULL, 'cum', 0, '62693394', 14, 330, NULL, 'harum', '9', '3', '4kg', '9x15cm', 164.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(975, NULL, '4530245719932', 'corrupti consequuntur sunt', 'Doloribus voluptas eius aliquid dolores sit laborum repudiandae soluta est minus occaecati.', 3, NULL, NULL, 5, 309.6, NULL, NULL, 712.95, NULL, NULL, 'officiis', 0, '15632272', 9, 325, '1970-03-26', 'voluptatem', '9', '3', '2kg', '21x10cm', 253.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(976, NULL, '9380136414225', 'magni nobis odit', 'Eligendi quidem voluptatem corporis unde fuga in sed quis similique accusamus at.', 5, NULL, NULL, 5, 257.13, NULL, NULL, 562.98, NULL, NULL, 'qui', 0, '37230326', 4, NULL, NULL, 'molestias', '1', '7', '10kg', '19x17cm', 168.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(977, NULL, '7244186044295', 'quo deserunt veritatis', 'Voluptatem vitae dicta voluptatum consectetur suscipit molestias voluptas asperiores in facere.', 2, NULL, NULL, 6, 141.23, NULL, NULL, 392.21, NULL, NULL, 'quisquam', 0, '86140645', 31, NULL, NULL, 'quod', '8', '9', '6kg', '17x31cm', 196.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(978, NULL, '0548605874072', 'accusamus dolorem provident', 'Dignissimos illo natus unde tenetur ullam dolorum et architecto alias atque atque.', 3, NULL, NULL, 5, 196.16, NULL, NULL, 62.52, NULL, NULL, 'eaque', 0, '70288407', 6, NULL, NULL, 'itaque', '2', '3', '1kg', '8x40cm', 180.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(979, NULL, '0786115627973', 'dolor laboriosam quia', 'Vitae qui accusamus et qui incidunt excepturi quas quasi molestiae repudiandae.', 5, NULL, NULL, 4, 225.59, NULL, NULL, 994.62, NULL, NULL, 'dolorem', 0, '81120161', 41, NULL, '1974-04-11', 'iste', '2', '4', '6kg', '39x22cm', 219.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(980, NULL, '2737222889660', 'dolorem eos deleniti', 'Corporis suscipit velit repellendus voluptatem voluptatem dolorum.', 7, NULL, NULL, 5, 87.99, NULL, NULL, 373.88, NULL, NULL, 'cum', 0, '15687258', 28, NULL, NULL, 'occaecati', '8', '1', '6kg', '32x43cm', 140.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(981, NULL, '2271905815923', 'voluptate animi dolores', 'Totam quo ad fugit quia laborum ut totam ut modi natus modi in.', 7, NULL, NULL, 2, 117.44, NULL, NULL, 941.35, NULL, NULL, 'vel', 0, '62664653', 49, 199, '2022-07-19', 'aliquam', '3', '6', '7kg', '19x32cm', 1.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(982, NULL, '2288370236405', 'possimus minima atque', 'Tempore quia deserunt dolorem laborum ad at ut nihil quas porro minima aspernatur.', 4, NULL, NULL, 5, 365.48, NULL, NULL, 808.5, NULL, NULL, 'nisi', 0, '83384844', 37, 149, NULL, 'quod', '9', '1', '6kg', '18x22cm', 472.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(983, NULL, '6963608699509', 'maiores adipisci dolorum', 'Eos quia quasi et et reprehenderit ex omnis ipsum velit vel qui aut.', 8, NULL, NULL, 2, 302.75, NULL, NULL, 120.74, NULL, NULL, 'est', 0, '93281614', 33, NULL, NULL, 'quisquam', '4', '2', '7kg', '18x27cm', 50.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(984, NULL, '7007143593829', 'velit quibusdam delectus', 'Reprehenderit est qui est eos libero molestiae deleniti laborum est.', 2, NULL, NULL, 1, 61.68, NULL, NULL, 858.16, NULL, NULL, 'est', 0, '23297586', 43, 333, NULL, 'omnis', '5', '3', '5kg', '6x38cm', 374.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(985, NULL, '5257927796652', 'consequatur quis itaque', 'Soluta omnis eius sed officiis nemo nam qui.', 3, NULL, NULL, 4, 131.68, NULL, NULL, 808.09, NULL, NULL, 'quaerat', 0, '73185963', 11, 326, NULL, 'magni', '4', '1', '5kg', '5x33cm', 402.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(986, NULL, '9341617567373', 'similique incidunt provident', 'Non ut provident deleniti quidem sit sequi atque repudiandae deserunt.', 4, NULL, NULL, 5, 56.8, NULL, NULL, 705.33, NULL, NULL, 'sequi', 0, '25901542', 10, 183, '2006-12-21', 'non', '4', '9', '1kg', '23x24cm', 294.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(987, NULL, '1132352453391', 'assumenda quas doloremque', 'Est nobis consequatur earum aliquid architecto qui eum aliquid ullam placeat aspernatur.', 10, NULL, NULL, 3, 294.47, NULL, NULL, 450.12, NULL, NULL, 'laborum', 0, '70052299', 1, 68, NULL, 'in', '6', '2', '2kg', '32x32cm', 343.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(988, NULL, '5868184902054', 'eos sed ut', 'Et ut odit molestias corporis fugit accusantium earum perferendis.', 2, NULL, NULL, 5, 64.62, NULL, NULL, 619.91, NULL, NULL, 'praesentium', 0, '22303943', 35, 112, '1979-01-21', 'voluptates', '5', '6', '8kg', '46x31cm', 155.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(989, NULL, '0391543200270', 'minus et facilis', 'Quis culpa pariatur quis excepturi quas placeat labore inventore voluptas fuga.', 8, NULL, NULL, 6, 260.19, NULL, NULL, 492.32, NULL, NULL, 'quia', 0, '48623964', 26, NULL, '2013-09-22', 'itaque', '6', '5', '10kg', '28x12cm', 223.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(990, NULL, '8421099908015', 'commodi est ut', 'Sapiente temporibus cum rerum corporis ut explicabo commodi rerum quaerat omnis minima reprehenderit.', 3, NULL, NULL, 1, 348.21, NULL, NULL, 197.64, NULL, NULL, 'magni', 0, '48231923', 25, 110, NULL, 'aut', '9', '9', '6kg', '48x19cm', 225.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(991, NULL, '4744550827002', 'fuga voluptas quia', 'Consequatur ut neque magni ut nobis soluta temporibus magni.', 2, NULL, NULL, 5, 241.66, NULL, NULL, 64.02, NULL, NULL, 'minus', 0, '84134554', 3, 152, NULL, 'nemo', '9', '3', '7kg', '34x36cm', 103.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(992, NULL, '9671013998564', 'perspiciatis amet sint', 'Expedita ducimus animi nihil consequatur velit molestiae ab veniam et itaque in ab.', 8, NULL, NULL, 1, 35.47, NULL, NULL, 479.12, NULL, NULL, 'qui', 0, '97908722', 21, 345, NULL, 'amet', '1', '3', '10kg', '34x22cm', 295.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(993, NULL, '8019893827597', 'quasi voluptatem alias', 'Et sunt harum rerum et veniam rem doloremque doloribus magni.', 7, NULL, NULL, 1, 103.95, NULL, NULL, 531.04, NULL, NULL, 'nihil', 0, '96449905', 13, 120, '1989-03-23', 'iusto', '4', '2', '7kg', '47x40cm', 413.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(994, NULL, '6978778858359', 'ullam nesciunt non', 'Assumenda qui dolor adipisci qui voluptas provident alias nisi autem eius.', 8, NULL, NULL, 2, 176.49, NULL, NULL, 741.55, NULL, NULL, 'id', 0, '15246684', 45, NULL, '2012-02-03', 'quaerat', '5', '3', '3kg', '41x9cm', 138.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(995, NULL, '1993992563860', 'dolor aperiam qui', 'Assumenda illum pariatur suscipit non esse a ad natus sit eius officiis ea.', 4, NULL, NULL, 6, 160.56, NULL, NULL, 202.17, NULL, NULL, 'est', 0, '45685651', 36, 246, '1993-06-01', 'minus', '1', '6', '1kg', '26x25cm', 465.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(996, NULL, '3047953402755', 'rerum et laborum', 'Debitis enim rerum tempore ut impedit recusandae quia libero quaerat.', 6, NULL, NULL, 1, 63.45, NULL, NULL, 898.27, NULL, NULL, 'reprehenderit', 0, '97597247', 36, NULL, '2004-05-14', 'beatae', '4', '7', '6kg', '23x16cm', 233.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(997, NULL, '3207231767093', 'quis qui porro', 'Porro libero exercitationem illum eveniet tempore saepe totam cumque dolorum aut sequi ipsum sit.', 2, NULL, NULL, 3, 383.2, NULL, NULL, 708.44, NULL, NULL, 'distinctio', 0, '43752355', 45, NULL, '1989-02-24', 'nobis', '7', '5', '8kg', '11x18cm', 237.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(998, NULL, '4219384776579', 'doloremque velit eveniet', 'Nulla sed qui soluta impedit doloremque repellendus in blanditiis.', 7, NULL, NULL, 4, 109.94, NULL, NULL, 947.83, NULL, NULL, 'asperiores', 0, '65877197', 37, 317, NULL, 'non', '3', '1', '7kg', '16x45cm', 85.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(999, NULL, '1262838515906', 'quidem aut quam', 'Aut vel totam voluptatem ullam dolores quas.', 9, NULL, NULL, 3, 253.27, NULL, NULL, 45.69, NULL, NULL, 'saepe', 0, '34820254', 26, 115, '1983-05-04', 'ipsum', '5', '2', '7kg', '30x36cm', 315.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03'),
(1000, NULL, '1855811347894', 'placeat et quam', 'Quibusdam tenetur fugiat vel optio harum pariatur exercitationem.', 4, NULL, NULL, 3, 394.33, NULL, NULL, 142.62, NULL, NULL, 'veritatis', 0, '57796987', 27, 332, '1982-11-25', 'odio', '8', '3', '9kg', '36x14cm', 104.00, NULL, '2025-10-13', NULL, 'active', NULL, NULL, NULL, '2025-10-12 21:10:03', '2025-10-12 21:10:03');

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

--
-- Table structure for table `product_customfields`
--

CREATE TABLE `product_customfields` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_customfields`
--

INSERT INTO `product_customfields` (`id`, `name`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'Form', 'active', 1, NULL, '2025-10-19 00:51:56', '2025-10-19 00:51:56');

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

--
-- Table structure for table `product_custom_information`
--

CREATE TABLE `product_custom_information` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `custom_field_id` bigint(20) UNSIGNED NOT NULL,
  `custom_information` varchar(255) DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_discounts`
--

CREATE TABLE `product_discounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `discount_code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `dicount_type` enum('normal','offer','buy_to_get') NOT NULL DEFAULT 'normal',
  `amount_type` enum('parcantage','normal') NOT NULL DEFAULT 'normal',
  `operation_type` enum('purchase','sale') NOT NULL DEFAULT 'sale',
  `start_date` timestamp NULL DEFAULT NULL,
  `end_date` timestamp NULL DEFAULT NULL,
  `value` double DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_specifications`
--

CREATE TABLE `product_specifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `details_id` int(10) UNSIGNED DEFAULT NULL,
  `type` enum('purchase','purchase return','sale','sale return','stock transfer','adjustment','hold','quatation') NOT NULL DEFAULT 'purchase',
  `emi_number` text DEFAULT NULL,
  `serial_number` text DEFAULT NULL,
  `sale` tinyint(1) NOT NULL DEFAULT 0,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_variations`
--

CREATE TABLE `product_variations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `variation_id` bigint(20) UNSIGNED NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchasepayments`
--

CREATE TABLE `purchasepayments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_no` varchar(255) DEFAULT NULL,
  `payment_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `company_branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `purchase_id` bigint(20) UNSIGNED DEFAULT NULL,
  `supplier_id` bigint(20) UNSIGNED DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `transection_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `type` enum('purchase','return') NOT NULL DEFAULT 'purchase',
  `amount` double NOT NULL DEFAULT 0,
  `note` varchar(255) DEFAULT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT 0,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchases`
--

CREATE TABLE `purchases` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_no` varchar(255) DEFAULT NULL,
  `order_no` varchar(255) DEFAULT NULL,
  `reference_no` varchar(255) DEFAULT NULL,
  `supplier_id` bigint(20) UNSIGNED DEFAULT NULL,
  `company_branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `warehouse_id` bigint(20) UNSIGNED DEFAULT NULL,
  `store_id` bigint(20) UNSIGNED DEFAULT NULL,
  `purchase_date` timestamp NULL DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `discount_parcentage` double NOT NULL DEFAULT 0,
  `total_discount` double NOT NULL DEFAULT 0,
  `tax_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vat_parcantage` double NOT NULL DEFAULT 0,
  `total_vat` double NOT NULL DEFAULT 0,
  `shiping_charge` double NOT NULL DEFAULT 0,
  `total_amount` double NOT NULL DEFAULT 0,
  `gross_discount_type` enum('normal','parcantage') DEFAULT NULL,
  `gross_discount_value` double DEFAULT NULL,
  `gross_discount_amount` double DEFAULT NULL,
  `nettotal` double DEFAULT NULL,
  `paid_amount` double DEFAULT NULL,
  `due_amount` double DEFAULT NULL,
  `change_amount` double DEFAULT NULL,
  `payment_status` enum('paid','due','partial') NOT NULL DEFAULT 'due',
  `purchase_status` enum('draft','ordered','recieved') NOT NULL DEFAULT 'draft',
  `recieved_date` date DEFAULT NULL,
  `customer_note` varchar(255) DEFAULT NULL,
  `private_note` varchar(255) DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `return_amount` double NOT NULL DEFAULT 0,
  `custom_note` varchar(255) DEFAULT NULL,
  `delivery_date` timestamp NULL DEFAULT NULL,
  `delivery_note` varchar(255) DEFAULT NULL,
  `delivery_status` enum('recieved','pending') DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchase_details`
--

CREATE TABLE `purchase_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `purchase_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `unit_price` double NOT NULL DEFAULT 0,
  `qty` double NOT NULL DEFAULT 0,
  `return_qty` double NOT NULL DEFAULT 0,
  `amount` double NOT NULL DEFAULT 0,
  `vat_percent` double DEFAULT 0,
  `vat_amount` double NOT NULL DEFAULT 0,
  `discount` double DEFAULT 0,
  `discount_percent` double DEFAULT 0,
  `discount_amount` double NOT NULL DEFAULT 0,
  `nettotal` double NOT NULL DEFAULT 0,
  `product_note` text DEFAULT NULL,
  `purchase_status` enum('draft','ordered','recieved') NOT NULL DEFAULT 'draft',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchase_returns`
--

CREATE TABLE `purchase_returns` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_no` varchar(255) DEFAULT NULL,
  `purchase_id` bigint(20) UNSIGNED DEFAULT NULL,
  `order_no` varchar(255) DEFAULT NULL,
  `reference_no` varchar(255) DEFAULT NULL,
  `supplier_id` bigint(20) UNSIGNED DEFAULT NULL,
  `company_branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `warehouse_id` bigint(20) UNSIGNED DEFAULT NULL,
  `store_id` bigint(20) UNSIGNED DEFAULT NULL,
  `return_date` timestamp NULL DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `discount_parcentage` double NOT NULL DEFAULT 0,
  `total_discount` double NOT NULL DEFAULT 0,
  `tax_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vat_parcantage` double NOT NULL DEFAULT 0,
  `total_vat` double NOT NULL DEFAULT 0,
  `shiping_charge` double NOT NULL DEFAULT 0,
  `total_amount` double NOT NULL DEFAULT 0,
  `gross_discount_type` enum('normal','parcantage') DEFAULT NULL,
  `gross_discount_value` double DEFAULT NULL,
  `gross_discount_amount` double DEFAULT NULL,
  `nettotal` double DEFAULT NULL,
  `paid_amount` double DEFAULT NULL,
  `due_amount` double DEFAULT NULL,
  `change_amount` double DEFAULT NULL,
  `payment_status` enum('paid','due','partial') NOT NULL DEFAULT 'due',
  `purchase_status` enum('draft','return') NOT NULL DEFAULT 'draft',
  `recieved_date` date DEFAULT NULL,
  `customer_note` varchar(255) DEFAULT NULL,
  `private_note` varchar(255) DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `custom_note` varchar(255) DEFAULT NULL,
  `delivery_date` timestamp NULL DEFAULT NULL,
  `delivery_note` varchar(255) DEFAULT NULL,
  `delivery_status` enum('recieved','pending') DEFAULT NULL,
  `return_type` enum('just return','invoice return') NOT NULL DEFAULT 'just return',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchase_return_details`
--

CREATE TABLE `purchase_return_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `purchase_return_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `unit_price` double NOT NULL DEFAULT 0,
  `qty` double NOT NULL DEFAULT 0,
  `amount` double NOT NULL DEFAULT 0,
  `vat_percent` double DEFAULT 0,
  `vat_amount` double NOT NULL DEFAULT 0,
  `discount` double DEFAULT 0,
  `discount_percent` double DEFAULT 0,
  `discount_amount` double NOT NULL DEFAULT 0,
  `nettotal` double NOT NULL DEFAULT 0,
  `product_note` text DEFAULT NULL,
  `purchase_status` enum('draft','return') NOT NULL DEFAULT 'draft',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `quantity_transactions`
--

CREATE TABLE `quantity_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(20) NOT NULL,
  `qty_change` decimal(15,4) NOT NULL,
  `old_qty` decimal(15,4) NOT NULL,
  `new_qty` decimal(15,4) NOT NULL,
  `purchase_price` decimal(15,4) DEFAULT NULL,
  `sale_price` decimal(15,4) DEFAULT NULL,
  `txn_date` date NOT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `quatations`
--

CREATE TABLE `quatations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_no` varchar(255) NOT NULL,
  `company_branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `quotation_date` date DEFAULT NULL,
  `delivery_date` date DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `customer_phone` varchar(255) DEFAULT NULL,
  `customer_email` varchar(255) DEFAULT NULL,
  `customer_address` varchar(255) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `total_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `status` varchar(255) NOT NULL DEFAULT 'Pending',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `quatation_details`
--

CREATE TABLE `quatation_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `quatation_id` bigint(20) UNSIGNED NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `product_note` varchar(255) DEFAULT NULL,
  `qty` int(11) NOT NULL,
  `unit_price` decimal(10,2) NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `unit_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `quatation_sales`
--

CREATE TABLE `quatation_sales` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_no` varchar(255) DEFAULT NULL,
  `reference_no` varchar(255) DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `warehouse_id` bigint(20) UNSIGNED DEFAULT NULL,
  `company_branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `sale_date` timestamp NULL DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `discount_parcentage` double NOT NULL DEFAULT 0,
  `total_discount` double NOT NULL DEFAULT 0,
  `tax_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vat_parcantage` double NOT NULL DEFAULT 0,
  `total_vat` double NOT NULL DEFAULT 0,
  `shiping_charge` double NOT NULL DEFAULT 0,
  `total_amount` double NOT NULL DEFAULT 0,
  `gross_discount_type` enum('normal','parcantage') DEFAULT NULL,
  `gross_discount_value` double DEFAULT NULL,
  `gross_discount_amount` double DEFAULT NULL,
  `nettotal` double DEFAULT NULL,
  `customer_note` varchar(255) DEFAULT NULL,
  `private_note` varchar(255) DEFAULT NULL,
  `custom_note` varchar(255) DEFAULT NULL,
  `delivery_date` timestamp NULL DEFAULT NULL,
  `delivery_note` varchar(255) DEFAULT NULL,
  `delivery_status` enum('recieved','pending') DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `quatation_sale_details`
--

CREATE TABLE `quatation_sale_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `quatation_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `tp_price` double NOT NULL DEFAULT 0,
  `unit_price` double NOT NULL DEFAULT 0,
  `qty` double NOT NULL DEFAULT 0,
  `amount` double NOT NULL DEFAULT 0,
  `vat_percent` double NOT NULL DEFAULT 0,
  `vat_amount` double NOT NULL DEFAULT 0,
  `discount` double DEFAULT 0,
  `discount_percent` double NOT NULL DEFAULT 0,
  `discount_amount` double NOT NULL DEFAULT 0,
  `nettotal` double NOT NULL DEFAULT 0,
  `product_note` text DEFAULT NULL,
  `return_qty` double NOT NULL DEFAULT 0,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `reciepts`
--

CREATE TABLE `reciepts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reciept_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `bank_account_id` bigint(20) UNSIGNED NOT NULL,
  `date` date DEFAULT NULL,
  `month` varchar(255) DEFAULT NULL,
  `year` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `amount` decimal(50,2) DEFAULT NULL,
  `type` enum('opening','running') NOT NULL DEFAULT 'running',
  `journal_status` enum('active','inactive') NOT NULL DEFAULT 'inactive',
  `company_branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `journal_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `reciepttypes`
--

CREATE TABLE `reciepttypes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `company_branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `opening_amount` decimal(50,2) DEFAULT 0.00,
  `note_type` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `report_configs`
--

CREATE TABLE `report_configs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'web', '2025-10-12 21:09:47', '2025-10-12 21:09:47');

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

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(29, 1),
(30, 1),
(31, 1),
(32, 1),
(33, 1),
(34, 1),
(35, 1),
(36, 1),
(37, 1),
(38, 1),
(39, 1),
(40, 1),
(41, 1),
(42, 1),
(43, 1),
(44, 1),
(45, 1),
(46, 1),
(47, 1),
(48, 1),
(49, 1),
(50, 1),
(51, 1),
(52, 1),
(53, 1),
(54, 1),
(55, 1),
(56, 1),
(57, 1),
(58, 1),
(59, 1),
(60, 1),
(61, 1),
(62, 1),
(63, 1),
(64, 1),
(65, 1),
(66, 1),
(67, 1),
(68, 1),
(69, 1),
(70, 1),
(71, 1),
(72, 1),
(73, 1),
(74, 1),
(75, 1),
(76, 1),
(77, 1),
(78, 1),
(79, 1),
(80, 1);

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

--
-- Table structure for table `salary_increament_histories`
--

CREATE TABLE `salary_increament_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `employee_id` bigint(20) UNSIGNED DEFAULT NULL,
  `designation_id` bigint(20) UNSIGNED DEFAULT NULL,
  `increament_date` date NOT NULL,
  `month` varchar(255) NOT NULL,
  `salary` decimal(10,2) NOT NULL,
  `remark` enum('Starting Salary','Increament') NOT NULL DEFAULT 'Starting Salary',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `salary_payments`
--

CREATE TABLE `salary_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date DEFAULT NULL,
  `month` varchar(255) NOT NULL,
  `year` int(11) NOT NULL,
  `employee_id` bigint(20) UNSIGNED NOT NULL,
  `payroll_id` bigint(20) UNSIGNED NOT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `payment` decimal(10,2) NOT NULL,
  `due` decimal(10,2) NOT NULL,
  `type` enum('paid','advance') NOT NULL DEFAULT 'paid',
  `transection_no` varchar(255) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `salary_sheets`
--

CREATE TABLE `salary_sheets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date DEFAULT NULL,
  `financial_year` varchar(255) DEFAULT NULL,
  `month` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `total_salary` decimal(10,2) DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `salary_types`
--

CREATE TABLE `salary_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `designation_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employee_type` enum('local','expat','other') NOT NULL DEFAULT 'local',
  `gross_amount` decimal(10,2) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `salary_types`
--

INSERT INTO `salary_types` (`id`, `name`, `designation_id`, `employee_type`, `gross_amount`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'Manager', NULL, 'local', 100000.00, 1, 1, NULL, '2025-10-13 05:33:37', '2025-10-13 05:33:37'),
(2, 'Project Manager', NULL, 'local', 12000.00, 1, 1, NULL, '2025-10-14 11:58:13', '2025-10-14 11:58:13');

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

--
-- Table structure for table `salary_type_details`
--

CREATE TABLE `salary_type_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `salary_type_id` bigint(20) UNSIGNED NOT NULL,
  `head_name` varchar(255) NOT NULL,
  `head_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `parcentage` decimal(10,2) NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `salary_type_details`
--

INSERT INTO `salary_type_details` (`id`, `salary_type_id`, `head_name`, `head_id`, `amount`, `parcentage`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 1, 'Basic Salary', 1, 80000.00, 80.00, 1, NULL, '2025-10-13 05:33:37', '2025-10-13 05:33:37'),
(2, 1, 'House Rent Allowance', 2, 10000.00, 10.00, 1, NULL, '2025-10-13 05:33:37', '2025-10-13 05:33:37'),
(3, 1, 'Medical Allowance', 3, 10000.00, 10.00, 1, NULL, '2025-10-13 05:33:37', '2025-10-13 05:33:37'),
(4, 2, 'Basic Salary', 1, 9600.00, 80.00, 1, NULL, '2025-10-14 11:58:13', '2025-10-14 11:58:13'),
(5, 2, 'House Rent Allowance', 2, 1200.00, 10.00, 1, NULL, '2025-10-14 11:58:13', '2025-10-14 11:58:13'),
(6, 2, 'Medical Allowance', 3, 1200.00, 10.00, 1, NULL, '2025-10-14 11:58:13', '2025-10-14 11:58:13');

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

--
-- Table structure for table `saledetails`
--

CREATE TABLE `saledetails` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sale_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `tp_price` double NOT NULL DEFAULT 0,
  `unit_price` double NOT NULL DEFAULT 0,
  `qty` double NOT NULL DEFAULT 0,
  `amount` double NOT NULL DEFAULT 0,
  `vat_percent` double NOT NULL DEFAULT 0,
  `vat_amount` double NOT NULL DEFAULT 0,
  `discount` double DEFAULT 0,
  `discount_percent` double NOT NULL DEFAULT 0,
  `discount_amount` double NOT NULL DEFAULT 0,
  `nettotal` double NOT NULL DEFAULT 0,
  `product_note` text DEFAULT NULL,
  `sale_status` enum('draft','ordered','complete') NOT NULL DEFAULT 'draft',
  `return_qty` double NOT NULL DEFAULT 0,
  `warranty_start_date` date DEFAULT NULL,
  `warranty_end_date` date DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `salereturns`
--

CREATE TABLE `salereturns` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_no` varchar(255) DEFAULT NULL,
  `order_no` varchar(255) DEFAULT NULL,
  `reference_no` varchar(255) DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `sale_id` bigint(20) UNSIGNED DEFAULT NULL,
  `company_branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `warehouse_id` bigint(20) UNSIGNED DEFAULT NULL,
  `store_id` bigint(20) UNSIGNED DEFAULT NULL,
  `return_date` timestamp NULL DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `discount_parcentage` double NOT NULL DEFAULT 0,
  `total_discount` double NOT NULL DEFAULT 0,
  `tax_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vat_parcantage` double NOT NULL DEFAULT 0,
  `total_vat` double NOT NULL DEFAULT 0,
  `shiping_charge` double NOT NULL DEFAULT 0,
  `total_amount` double NOT NULL DEFAULT 0,
  `gross_discount_type` enum('normal','parcantage') DEFAULT NULL,
  `gross_discount_value` double DEFAULT NULL,
  `gross_discount_amount` double DEFAULT NULL,
  `nettotal` double DEFAULT NULL,
  `paid_amount` double DEFAULT NULL,
  `due_amount` double DEFAULT NULL,
  `change_amount` double DEFAULT NULL,
  `payment_status` enum('paid','due','partial') NOT NULL DEFAULT 'due',
  `return_status` enum('draft','return') NOT NULL DEFAULT 'draft',
  `recieved_date` date DEFAULT NULL,
  `customer_note` varchar(255) DEFAULT NULL,
  `private_note` varchar(255) DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `custom_note` varchar(255) DEFAULT NULL,
  `delivery_date` timestamp NULL DEFAULT NULL,
  `delivery_note` varchar(255) DEFAULT NULL,
  `delivery_status` enum('recieved','pending') DEFAULT NULL,
  `return_type` enum('just return','invoice return') NOT NULL DEFAULT 'just return',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `salereturn_details`
--

CREATE TABLE `salereturn_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sale_return_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `unit_price` double NOT NULL DEFAULT 0,
  `qty` double NOT NULL DEFAULT 0,
  `amount` double NOT NULL DEFAULT 0,
  `vat_percent` double DEFAULT 0,
  `vat_amount` double NOT NULL DEFAULT 0,
  `discount` double DEFAULT 0,
  `discount_percent` double DEFAULT 0,
  `discount_amount` double NOT NULL DEFAULT 0,
  `nettotal` double NOT NULL DEFAULT 0,
  `product_note` text DEFAULT NULL,
  `return_status` enum('draft','return') NOT NULL DEFAULT 'draft',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sales`
--

CREATE TABLE `sales` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_no` varchar(255) DEFAULT NULL,
  `order_no` varchar(255) DEFAULT NULL,
  `reference_no` varchar(255) DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `warehouse_id` bigint(20) UNSIGNED DEFAULT NULL,
  `company_branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `sale_date` timestamp NULL DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `discount_parcentage` double NOT NULL DEFAULT 0,
  `total_discount` double NOT NULL DEFAULT 0,
  `tax_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vat_parcantage` double NOT NULL DEFAULT 0,
  `total_vat` double NOT NULL DEFAULT 0,
  `shiping_charge` double NOT NULL DEFAULT 0,
  `total_amount` double NOT NULL DEFAULT 0,
  `gross_discount_type` enum('normal','parcantage') DEFAULT NULL,
  `gross_discount_value` double DEFAULT NULL,
  `gross_discount_amount` double DEFAULT NULL,
  `nettotal` double DEFAULT NULL,
  `paid_amount` double DEFAULT NULL,
  `due_amount` double DEFAULT NULL,
  `change_amount` double DEFAULT NULL,
  `payment_status` enum('paid','due','partial') NOT NULL DEFAULT 'due',
  `sale_status` enum('draft','ordered','complete') NOT NULL DEFAULT 'draft',
  `customer_note` varchar(255) DEFAULT NULL,
  `private_note` varchar(255) DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `return_amount` double NOT NULL DEFAULT 0,
  `custom_note` varchar(255) DEFAULT NULL,
  `delivery_date` timestamp NULL DEFAULT NULL,
  `delivery_note` varchar(255) DEFAULT NULL,
  `delivery_status` enum('recieved','pending') DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `cash_register_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sell_pyments`
--

CREATE TABLE `sell_pyments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_no` varchar(255) DEFAULT NULL,
  `payment_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `company_branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `sale_id` bigint(20) UNSIGNED DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `transection_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `type` enum('sale','return') NOT NULL DEFAULT 'sale',
  `amount` double NOT NULL DEFAULT 0,
  `note` varchar(255) DEFAULT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT 0,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `country_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `stock_adjustmentdeatsils`
--

CREATE TABLE `stock_adjustmentdeatsils` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `stock_adjustment_id` bigint(20) UNSIGNED DEFAULT NULL,
  `company_branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `unit_price` double NOT NULL DEFAULT 0,
  `qty` double NOT NULL DEFAULT 0,
  `amount` double NOT NULL DEFAULT 0,
  `vat_percent` double DEFAULT 0,
  `vat_amount` double NOT NULL DEFAULT 0,
  `nettotal` double NOT NULL DEFAULT 0,
  `product_note` text DEFAULT NULL,
  `adjustment_type` enum('damage','wastage','normal') NOT NULL DEFAULT 'damage',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `stock_adjustments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_no` varchar(255) DEFAULT NULL,
  `company_branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `date` timestamp NULL DEFAULT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `total_vat` double DEFAULT NULL,
  `total_amount` double DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `adjustment_type` enum('damage','wastage','normal') NOT NULL DEFAULT 'damage',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `stock_transfers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_no` varchar(255) DEFAULT NULL,
  `reference_no` varchar(255) DEFAULT NULL,
  `from_branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `to_branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `date` timestamp NULL DEFAULT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `discount_parcentage` double NOT NULL DEFAULT 0,
  `total_discount` double NOT NULL DEFAULT 0,
  `tax_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vat_parcantage` double NOT NULL DEFAULT 0,
  `total_vat` double NOT NULL DEFAULT 0,
  `shiping_charge` double NOT NULL DEFAULT 0,
  `total_amount` double NOT NULL DEFAULT 0,
  `gross_discount_type` enum('normal','parcantage') DEFAULT NULL,
  `gross_discount_value` double DEFAULT NULL,
  `gross_discount_amount` double DEFAULT NULL,
  `nettotal` double DEFAULT NULL,
  `custom_note` varchar(255) DEFAULT NULL,
  `delivery_status` enum('draft','sending','recieved') NOT NULL DEFAULT 'draft',
  `delivery_date` timestamp NULL DEFAULT NULL,
  `delivery_note` varchar(255) DEFAULT NULL,
  `recieved_date` date DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `stock_transfer_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `stcok_transfer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `from_branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `to_branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `unit_price` double NOT NULL DEFAULT 0,
  `qty` double NOT NULL DEFAULT 0,
  `amount` double NOT NULL DEFAULT 0,
  `vat_percent` double DEFAULT 0,
  `vat_amount` double NOT NULL DEFAULT 0,
  `discount` double DEFAULT 0,
  `discount_percent` double DEFAULT 0,
  `discount_amount` double NOT NULL DEFAULT 0,
  `nettotal` double NOT NULL DEFAULT 0,
  `product_note` text DEFAULT NULL,
  `delivery_status` enum('draft','sending','recieved') NOT NULL DEFAULT 'draft',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `supply_infos`
--

CREATE TABLE `supply_infos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `supplier_code` varchar(255) DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `gst_number` varchar(255) DEFAULT NULL,
  `igt_number` varchar(255) DEFAULT NULL,
  `vat_Number` varchar(255) DEFAULT NULL,
  `license_number` varchar(255) DEFAULT NULL,
  `tax_No` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `alternative_mobile` varchar(255) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `country_id` bigint(20) UNSIGNED DEFAULT NULL,
  `state_id` bigint(20) UNSIGNED DEFAULT NULL,
  `city_id` bigint(20) UNSIGNED DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `opening_balance` decimal(8,2) NOT NULL DEFAULT 0.00,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `company_logo` varchar(255) DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `task_managers`
--

CREATE TABLE `task_managers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `operation_type` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `status` enum('pending','complete') NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tax_infos`
--

CREATE TABLE `tax_infos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `vat_parcentage` double NOT NULL DEFAULT 0,
  `type` enum('input','output') NOT NULL DEFAULT 'input',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `timezones`
--

CREATE TABLE `timezones` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `supplier_id` bigint(20) UNSIGNED DEFAULT NULL,
  `operation_id` bigint(20) UNSIGNED DEFAULT NULL,
  `voucher_no` varchar(255) DEFAULT NULL,
  `trn_no` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `account_operation` enum('recieved','payment') NOT NULL DEFAULT 'recieved',
  `type` enum('puchase','purchase return','sale','sale return','expense','refund','transfer','salary','salary advance') NOT NULL DEFAULT 'puchase',
  `account_type` enum('credit','debit') NOT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `remark` varchar(255) DEFAULT NULL,
  `recieved_by` varchar(255) DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `btanch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `untis`
--

CREATE TABLE `untis` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `short_name` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `variation_types`
--

CREATE TABLE `variation_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `variation_values`
--

CREATE TABLE `variation_values` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `variation_type_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `warehouses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `company_branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `warehouse_code` varchar(255) NOT NULL,
  `warehouse_name` varchar(255) NOT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `alternative_mobile` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `country_id` bigint(20) UNSIGNED DEFAULT NULL,
  `state_id` bigint(20) UNSIGNED DEFAULT NULL,
  `city_id` bigint(20) UNSIGNED DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `warenty_types`
--

CREATE TABLE `warenty_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_days` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `warranty_claims`
--

CREATE TABLE `warranty_claims` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `claim_no` varchar(255) NOT NULL,
  `sale_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `emi_number` bigint(20) UNSIGNED DEFAULT NULL,
  `details_id` bigint(20) UNSIGNED DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `customer_mobile` varchar(255) DEFAULT NULL,
  `claim_date` date NOT NULL DEFAULT '2025-10-13',
  `issue_description` text DEFAULT NULL,
  `resolution_date` date DEFAULT NULL,
  `status` enum('pending') NOT NULL DEFAULT 'pending',
  `charge` double DEFAULT NULL,
  `vat` double DEFAULT NULL,
  `total` double DEFAULT NULL,
  `tax` double DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `company_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `warranty_companies`
--

CREATE TABLE `warranty_companies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `work_schedule_types`
--

CREATE TABLE `work_schedule_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `schedule_name` varchar(255) DEFAULT NULL,
  `start_time` time NOT NULL,
  `ending_time` time NOT NULL,
  `late_time` time NOT NULL,
  `total_work_hour` int(11) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `employee_heads`
--
ALTER TABLE `employee_heads`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `employee_heads_pay_code_unique` (`pay_code`);

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

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `financial_years`
--
ALTER TABLE `financial_years`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `financial_years_start_year_unique` (`start_year`),
  ADD UNIQUE KEY `financial_years_end_year_unique` (`end_year`),
  ADD UNIQUE KEY `financial_years_financial_year_unique` (`financial_year`);

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

--
-- Indexes for table `held_sales`
--
ALTER TABLE `held_sales`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `held_sales_hold_number_unique` (`hold_number`);

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

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

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

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

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

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

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

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

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

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

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

--
-- Indexes for table `payrolls`
--
ALTER TABLE `payrolls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payrolls_employee_id_financial_year_index` (`employee_id`,`financial_year`),
  ADD KEY `payrolls_employee_id_head_id_index` (`employee_id`,`head_id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

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

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

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

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `products_product_code_unique` (`product_code`);
ALTER TABLE `products` ADD FULLTEXT KEY `ft_products` (`name`,`product_code`,`product_sku`,`description`);

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `quantity_transactions`
--
ALTER TABLE `quantity_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `quantity_transactions_user_id_foreign` (`user_id`),
  ADD KEY `quantity_transactions_product_id_txn_date_index` (`product_id`,`txn_date`),
  ADD KEY `quantity_transactions_branch_id_txn_date_index` (`branch_id`,`txn_date`),
  ADD KEY `quantity_transactions_type_index` (`type`),
  ADD KEY `quantity_transactions_txn_date_index` (`txn_date`);

--
-- Indexes for table `quatations`
--
ALTER TABLE `quatations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `quatations_invoice_no_unique` (`invoice_no`);

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

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

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

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

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

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

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

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

--
-- Indexes for table `salary_payments`
--
ALTER TABLE `salary_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `salary_payments_account_id_foreign` (`account_id`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `warenty_types`
--
ALTER TABLE `warenty_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `warenty_types_name_unique` (`name`);

--
-- Indexes for table `warranty_claims`
--
ALTER TABLE `warranty_claims`
  ADD PRIMARY KEY (`id`),
  ADD KEY `warranty_claims_claim_no_index` (`claim_no`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `quantity_transactions`
--
ALTER TABLE `quantity_transactions`
  ADD CONSTRAINT `quantity_transactions_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `company_branches` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `quantity_transactions_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `quantity_transactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `salary_payments`
--
ALTER TABLE `salary_payments`
  ADD CONSTRAINT `salary_payments_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`);
COMMIT;

