INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('npcu3e153q08ql77ckhos340crg4h08r', '103.14.130.185', 1716643508, 0x[encoded data, 20228 characters]),
('lb1q78snv1es0irom2rcdh8vfjgqmcb0', '103.14.130.185', 1716645171, 0x[encoded data, 20228 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('r9sq98ae6fijc9i85f49682rjkllf5lr', '103.14.130.185', 1716645595, 0x[encoded data, 20228 characters]),
('9g0q7gnp6h5qkopr5dso2g52bk5nhonq', '103.14.130.185', 1716646366, 0x[encoded data, 20228 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('mp78kq4tuek64j3h5k9arm4fu8u0ob5i', '103.14.130.185', 1716646605, 0x[encoded data, 20228 characters]);

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

--
-- Table structure for table `tbl_set_opening_stocks`
--

CREATE TABLE `tbl_set_opening_stocks` (
  `id` bigint(255) NOT NULL,
  `item_id` int(11) DEFAULT NULL,
  `item_type` varchar(55) DEFAULT NULL,
  `item_description` varchar(255) DEFAULT NULL,
  `stock_quantity` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `del_status` varchar(10) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_set_opening_stocks`
--

INSERT INTO `tbl_set_opening_stocks` (`id`, `item_id`, `item_type`, `item_description`, `stock_quantity`, `outlet_id`, `user_id`, `company_id`, `del_status`) VALUES
(1, 2, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(2, 2, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(3, 3, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(4, 3, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(5, 4, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(6, 4, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(7, 5, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(8, 5, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(9, 7, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(10, 7, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(11, 8, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(12, 8, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(13, 9, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(14, 9, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(15, 10, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(16, 10, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(17, 12, 'Variation_Product', NULL, 250, 4, 1, 1, 'Live'),
(18, 12, 'Variation_Product', NULL, 250, 5, 1, 1, 'Live'),
(19, 13, 'Variation_Product', NULL, 250, 4, 1, 1, 'Live'),
(20, 13, 'Variation_Product', NULL, 250, 5, 1, 1, 'Live'),
(21, 14, 'Variation_Product', NULL, 250, 4, 1, 1, 'Live'),
(22, 14, 'Variation_Product', NULL, 250, 5, 1, 1, 'Live'),
(23, 15, 'Variation_Product', NULL, 250, 4, 1, 1, 'Live'),
(24, 15, 'Variation_Product', NULL, 250, 5, 1, 1, 'Live'),
(25, 17, 'Variation_Product', NULL, 170, 4, 1, 1, 'Live'),
(26, 17, 'Variation_Product', NULL, 170, 5, 1, 1, 'Live'),
(27, 18, 'Variation_Product', NULL, 170, 4, 1, 1, 'Live'),
(28, 18, 'Variation_Product', NULL, 170, 5, 1, 1, 'Live'),
(29, 19, 'Variation_Product', NULL, 170, 4, 1, 1, 'Live'),
(30, 19, 'Variation_Product', NULL, 170, 5, 1, 1, 'Live'),
(31, 20, 'Variation_Product', NULL, 170, 4, 1, 1, 'Live'),
(32, 20, 'Variation_Product', NULL, 170, 5, 1, 1, 'Live'),
(33, 22, 'Variation_Product', NULL, 300, 4, 1, 1, 'Live'),
(34, 22, 'Variation_Product', NULL, 300, 5, 1, 1, 'Live'),
(35, 23, 'Variation_Product', NULL, 300, 4, 1, 1, 'Live'),
(36, 23, 'Variation_Product', NULL, 300, 5, 1, 1, 'Live'),
(37, 24, 'Variation_Product', NULL, 300, 4, 1, 1, 'Live'),
(38, 24, 'Variation_Product', NULL, 300, 5, 1, 1, 'Live'),
(39, 25, 'Variation_Product', NULL, 300, 4, 1, 1, 'Live'),
(40, 25, 'Variation_Product', NULL, 300, 5, 1, 1, 'Live'),
(41, 27, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(42, 27, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(43, 28, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(44, 28, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(45, 29, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(46, 29, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(47, 30, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(48, 30, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(49, 32, 'Variation_Product', NULL, 140, 4, 1, 1, 'Live'),
(50, 32, 'Variation_Product', NULL, 140, 5, 1, 1, 'Live'),
(51, 33, 'Variation_Product', NULL, 140, 4, 1, 1, 'Live'),
(52, 33, 'Variation_Product', NULL, 140, 5, 1, 1, 'Live'),
(53, 34, 'Variation_Product', NULL, 140, 4, 1, 1, 'Live'),
(54, 34, 'Variation_Product', NULL, 140, 5, 1, 1, 'Live'),
(55, 35, 'Variation_Product', NULL, 140, 4, 1, 1, 'Live'),
(56, 35, 'Variation_Product', NULL, 140, 5, 1, 1, 'Live'),
(57, 37, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(58, 37, 'Variation_Product', NULL, 160, 5, 1, 1, 'Live'),
(59, 38, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(60, 38, 'Variation_Product', NULL, 160, 5, 1, 1, 'Live'),
(61, 39, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(62, 39, 'Variation_Product', NULL, 160, 5, 1, 1, 'Live'),
(63, 40, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(64, 40, 'Variation_Product', NULL, 160, 5, 1, 1, 'Live'),
(65, 42, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(66, 42, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(67, 43, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(68, 43, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(69, 44, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(70, 44, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(71, 45, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(72, 45, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(73, 47, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(74, 47, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(75, 48, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(76, 48, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(77, 49, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(78, 49, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(79, 50, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(80, 50, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(81, 52, 'Variation_Product', NULL, 160, 4, 1, 1, 'Live'),
(82, 52, 'Variation_Product', NULL, 160, 5, 1, 1, 'Live'),
(83, 53, 'Variation_Product', NULL, 160, 4, 1, 1, 'Live'),
(84, 53, 'Variation_Product', NULL, 160, 5, 1, 1, 'Live'),
(85, 54, 'Variation_Product', NULL, 160, 4, 1, 1, 'Live'),
(86, 54, 'Variation_Product', NULL, 160, 5, 1, 1, 'Live'),
(87, 55, 'Variation_Product', NULL, 160, 4, 1, 1, 'Live'),
(88, 55, 'Variation_Product', NULL, 160, 5, 1, 1, 'Live'),
(89, 57, 'Variation_Product', NULL, 110, 4, 1, 1, 'Live'),
(90, 57, 'Variation_Product', NULL, 110, 5, 1, 1, 'Live'),
(91, 58, 'Variation_Product', NULL, 110, 4, 1, 1, 'Live'),
(92, 58, 'Variation_Product', NULL, 110, 5, 1, 1, 'Live'),
(93, 59, 'Variation_Product', NULL, 110, 4, 1, 1, 'Live'),
(94, 59, 'Variation_Product', NULL, 110, 5, 1, 1, 'Live'),
(95, 62, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(96, 62, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(97, 63, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(98, 63, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(99, 64, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(100, 64, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(101, 65, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(102, 65, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(103, 67, 'Variation_Product', NULL, 120, 4, 1, 1, 'Live'),
(104, 67, 'Variation_Product', NULL, 120, 5, 1, 1, 'Live'),
(105, 68, 'Variation_Product', NULL, 120, 4, 1, 1, 'Live'),
(106, 68, 'Variation_Product', NULL, 120, 5, 1, 1, 'Live'),
(107, 69, 'Variation_Product', NULL, 120, 4, 1, 1, 'Live'),
(108, 69, 'Variation_Product', NULL, 120, 5, 1, 1, 'Live'),
(109, 70, 'Variation_Product', NULL, 120, 4, 1, 1, 'Live'),
(110, 70, 'Variation_Product', NULL, 120, 5, 1, 1, 'Live'),
(111, 72, 'Variation_Product', NULL, 130, 4, 1, 1, 'Live'),
(112, 72, 'Variation_Product', NULL, 130, 5, 1, 1, 'Live'),
(113, 73, 'Variation_Product', NULL, 130, 4, 1, 1, 'Live'),
(114, 73, 'Variation_Product', NULL, 130, 5, 1, 1, 'Live'),
(115, 74, 'Variation_Product', NULL, 130, 4, 1, 1, 'Live'),
(116, 74, 'Variation_Product', NULL, 130, 5, 1, 1, 'Live'),
(117, 75, 'Variation_Product', NULL, 130, 4, 1, 1, 'Live'),
(118, 75, 'Variation_Product', NULL, 130, 5, 1, 1, 'Live'),
(119, 77, 'Variation_Product', NULL, 110, 4, 1, 1, 'Live'),
(120, 77, 'Variation_Product', NULL, 120, 5, 1, 1, 'Live'),
(121, 78, 'Variation_Product', NULL, 110, 4, 1, 1, 'Live'),
(122, 78, 'Variation_Product', NULL, 120, 5, 1, 1, 'Live'),
(123, 79, 'Variation_Product', NULL, 110, 4, 1, 1, 'Live'),
(124, 79, 'Variation_Product', NULL, 120, 5, 1, 1, 'Live'),
(125, 80, 'Variation_Product', NULL, 110, 4, 1, 1, 'Live'),
(126, 80, 'Variation_Product', NULL, 120, 5, 1, 1, 'Live'),
(127, 82, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(128, 82, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(129, 83, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(130, 83, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(131, 84, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(132, 84, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(133, 85, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(134, 85, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(135, 87, 'Variation_Product', NULL, 190, 4, 1, 1, 'Live'),
(136, 87, 'Variation_Product', NULL, 190, 5, 1, 1, 'Live'),
(137, 88, 'Variation_Product', NULL, 190, 4, 1, 1, 'Live'),
(138, 88, 'Variation_Product', NULL, 190, 5, 1, 1, 'Live'),
(139, 89, 'Variation_Product', NULL, 190, 4, 1, 1, 'Live'),
(140, 89, 'Variation_Product', NULL, 190, 5, 1, 1, 'Live'),
(141, 90, 'Variation_Product', NULL, 190, 4, 1, 1, 'Live'),
(142, 90, 'Variation_Product', NULL, 190, 5, 1, 1, 'Live'),
(143, 92, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(144, 92, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(145, 93, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(146, 93, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(147, 94, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(148, 94, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(149, 95, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(150, 95, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(151, 97, 'Variation_Product', NULL, 250, 4, 1, 1, 'Live'),
(152, 97, 'Variation_Product', NULL, 250, 5, 1, 1, 'Live'),
(153, 98, 'Variation_Product', NULL, 250, 4, 1, 1, 'Live'),
(154, 98, 'Variation_Product', NULL, 250, 5, 1, 1, 'Live'),
(155, 99, 'Variation_Product', NULL, 250, 4, 1, 1, 'Live'),
(156, 99, 'Variation_Product', NULL, 250, 5, 1, 1, 'Live'),
(157, 100, 'Variation_Product', NULL, 250, 4, 1, 1, 'Live'),
(158, 100, 'Variation_Product', NULL, 250, 5, 1, 1, 'Live'),
(159, 102, 'Variation_Product', NULL, 700, 4, 1, 1, 'Live'),
(160, 102, 'Variation_Product', NULL, 700, 5, 1, 1, 'Live'),
(161, 103, 'Variation_Product', NULL, 700, 4, 1, 1, 'Live'),
(162, 103, 'Variation_Product', NULL, 700, 5, 1, 1, 'Live'),
(163, 104, 'Variation_Product', NULL, 700, 4, 1, 1, 'Live'),
(164, 104, 'Variation_Product', NULL, 700, 5, 1, 1, 'Live'),
(165, 105, 'Variation_Product', NULL, 700, 4, 1, 1, 'Live'),
(166, 105, 'Variation_Product', NULL, 700, 5, 1, 1, 'Live'),
(167, 107, 'Variation_Product', NULL, 555, 4, 1, 1, 'Live'),
(168, 107, 'Variation_Product', NULL, 555, 5, 1, 1, 'Live'),
(169, 108, 'Variation_Product', NULL, 555, 4, 1, 1, 'Live'),
(170, 108, 'Variation_Product', NULL, 555, 5, 1, 1, 'Live'),
(171, 109, 'Variation_Product', NULL, 555, 4, 1, 1, 'Live'),
(172, 109, 'Variation_Product', NULL, 555, 5, 1, 1, 'Live'),
(173, 110, 'Variation_Product', NULL, 555, 4, 1, 1, 'Live'),
(174, 110, 'Variation_Product', NULL, 555, 5, 1, 1, 'Live'),
(175, 112, 'Variation_Product', NULL, 400, 4, 1, 1, 'Live'),
(176, 112, 'Variation_Product', NULL, 400, 5, 1, 1, 'Live'),
(177, 113, 'Variation_Product', NULL, 400, 4, 1, 1, 'Live'),
(178, 113, 'Variation_Product', NULL, 400, 5, 1, 1, 'Live'),
(179, 114, 'Variation_Product', NULL, 400, 4, 1, 1, 'Live'),
(180, 114, 'Variation_Product', NULL, 400, 5, 1, 1, 'Live'),
(181, 115, 'Variation_Product', NULL, 400, 4, 1, 1, 'Live'),
(182, 115, 'Variation_Product', NULL, 400, 5, 1, 1, 'Live'),
(183, 117, 'Variation_Product', NULL, 456, 4, 1, 1, 'Live'),
(184, 117, 'Variation_Product', NULL, 456, 5, 1, 1, 'Live'),
(185, 118, 'Variation_Product', NULL, 456, 4, 1, 1, 'Live'),
(186, 118, 'Variation_Product', NULL, 456, 5, 1, 1, 'Live'),
(187, 119, 'Variation_Product', NULL, 456, 4, 1, 1, 'Live'),
(188, 119, 'Variation_Product', NULL, 456, 5, 1, 1, 'Live'),
(189, 120, 'Variation_Product', NULL, 456, 4, 1, 1, 'Live'),
(190, 120, 'Variation_Product', NULL, 456, 5, 1, 1, 'Live'),
(191, 122, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(192, 122, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(193, 123, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(194, 123, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(195, 124, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(196, 124, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(197, 125, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(198, 125, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(199, 127, 'Variation_Product', NULL, 110, 4, 1, 1, 'Live'),
(200, 127, 'Variation_Product', NULL, 110, 5, 1, 1, 'Live'),
(201, 128, 'Variation_Product', NULL, 110, 4, 1, 1, 'Live'),
(202, 128, 'Variation_Product', NULL, 110, 5, 1, 1, 'Live'),
(203, 129, 'Variation_Product', NULL, 110, 4, 1, 1, 'Live'),
(204, 129, 'Variation_Product', NULL, 110, 5, 1, 1, 'Live'),
(205, 130, 'Variation_Product', NULL, 110, 4, 1, 1, 'Live'),
(206, 130, 'Variation_Product', NULL, 110, 5, 1, 1, 'Live'),
(207, 132, 'Variation_Product', NULL, 555, 4, 1, 1, 'Live'),
(208, 132, 'Variation_Product', NULL, 555, 5, 1, 1, 'Live'),
(209, 133, 'Variation_Product', NULL, 555, 4, 1, 1, 'Live'),
(210, 133, 'Variation_Product', NULL, 555, 5, 1, 1, 'Live'),
(211, 134, 'Variation_Product', NULL, 555, 4, 1, 1, 'Live'),
(212, 134, 'Variation_Product', NULL, 555, 5, 1, 1, 'Live'),
(213, 135, 'Variation_Product', NULL, 555, 4, 1, 1, 'Live'),
(214, 135, 'Variation_Product', NULL, 555, 5, 1, 1, 'Live'),
(215, 137, 'Variation_Product', NULL, 666, 4, 1, 1, 'Live'),
(216, 137, 'Variation_Product', NULL, 666, 5, 1, 1, 'Live'),
(217, 138, 'Variation_Product', NULL, 666, 4, 1, 1, 'Live'),
(218, 138, 'Variation_Product', NULL, 666, 5, 1, 1, 'Live'),
(219, 139, 'Variation_Product', NULL, 666, 4, 1, 1, 'Live'),
(220, 139, 'Variation_Product', NULL, 666, 5, 1, 1, 'Live'),
(221, 140, 'Variation_Product', NULL, 666, 4, 1, 1, 'Live'),
(222, 140, 'Variation_Product', NULL, 666, 5, 1, 1, 'Live'),
(223, 142, 'Variation_Product', NULL, 444, 4, 1, 1, 'Live'),
(224, 142, 'Variation_Product', NULL, 444, 5, 1, 1, 'Live'),
(225, 143, 'Variation_Product', NULL, 444, 4, 1, 1, 'Live'),
(226, 143, 'Variation_Product', NULL, 444, 5, 1, 1, 'Live'),
(227, 144, 'Variation_Product', NULL, 444, 4, 1, 1, 'Live'),
(228, 144, 'Variation_Product', NULL, 444, 5, 1, 1, 'Live'),
(229, 145, 'Variation_Product', NULL, 444, 4, 1, 1, 'Live'),
(230, 145, 'Variation_Product', NULL, 444, 5, 1, 1, 'Live'),
(231, 147, 'Variation_Product', NULL, 555, 4, 1, 1, 'Live'),
(232, 147, 'Variation_Product', NULL, 555, 5, 1, 1, 'Live'),
(233, 148, 'Variation_Product', NULL, 555, 4, 1, 1, 'Live'),
(234, 148, 'Variation_Product', NULL, 555, 5, 1, 1, 'Live'),
(235, 149, 'Variation_Product', NULL, 555, 4, 1, 1, 'Live'),
(236, 149, 'Variation_Product', NULL, 555, 5, 1, 1, 'Live'),
(237, 150, 'Variation_Product', NULL, 555, 4, 1, 1, 'Live'),
(238, 150, 'Variation_Product', NULL, 555, 5, 1, 1, 'Live'),
(239, 152, 'Variation_Product', NULL, 400, 4, 1, 1, 'Live'),
(240, 152, 'Variation_Product', NULL, 400, 5, 1, 1, 'Live'),
(241, 153, 'Variation_Product', NULL, 400, 4, 1, 1, 'Live'),
(242, 153, 'Variation_Product', NULL, 400, 5, 1, 1, 'Live'),
(243, 154, 'Variation_Product', NULL, 400, 4, 1, 1, 'Live'),
(244, 154, 'Variation_Product', NULL, 400, 5, 1, 1, 'Live'),
(245, 156, 'Variation_Product', NULL, 777, 4, 1, 1, 'Live'),
(246, 156, 'Variation_Product', NULL, 777, 5, 1, 1, 'Live'),
(247, 157, 'Variation_Product', NULL, 777, 4, 1, 1, 'Live'),
(248, 157, 'Variation_Product', NULL, 777, 5, 1, 1, 'Live'),
(249, 158, 'Variation_Product', NULL, 777, 4, 1, 1, 'Live'),
(250, 158, 'Variation_Product', NULL, 777, 5, 1, 1, 'Live'),
(251, 160, 'Variation_Product', NULL, 100, 4, 1, 1, 'Live'),
(252, 160, 'Variation_Product', NULL, 100, 5, 1, 1, 'Live'),
(253, 161, 'Variation_Product', NULL, 100, 4, 1, 1, 'Live'),
(254, 161, 'Variation_Product', NULL, 100, 5, 1, 1, 'Live'),
(255, 162, 'Variation_Product', NULL, 100, 4, 1, 1, 'Live'),
(256, 162, 'Variation_Product', NULL, 100, 5, 1, 1, 'Live'),
(257, 163, 'Variation_Product', NULL, 100, 4, 1, 1, 'Live'),
(258, 163, 'Variation_Product', NULL, 100, 5, 1, 1, 'Live'),
(259, 165, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(260, 165, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(261, 166, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(262, 166, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(263, 167, 'Variation_Product', NULL, 200, 4, 1, 1, 'Live'),
(264, 167, 'Variation_Product', NULL, 200, 5, 1, 1, 'Live'),
(265, 169, 'Variation_Product', NULL, 500, 4, 1, 1, 'Live'),
(266, 169, 'Variation_Product', NULL, 500, 5, 1, 1, 'Live'),
(267, 170, 'Variation_Product', NULL, 500, 4, 1, 1, 'Live'),
(268, 170, 'Variation_Product', NULL, 500, 5, 1, 1, 'Live'),
(269, 171, 'Variation_Product', NULL, 500, 4, 1, 1, 'Live'),
(270, 171, 'Variation_Product', NULL, 500, 5, 1, 1, 'Live'),
(271, 172, 'Variation_Product', NULL, 500, 4, 1, 1, 'Live'),
(272, 172, 'Variation_Product', NULL, 500, 5, 1, 1, 'Live'),
(273, 174, 'Variation_Product', NULL, 555, 4, 1, 1, 'Live'),
(274, 174, 'Variation_Product', NULL, 555, 5, 1, 1, 'Live'),
(275, 175, 'Variation_Product', NULL, 555, 4, 1, 1, 'Live'),
(276, 175, 'Variation_Product', NULL, 555, 5, 1, 1, 'Live'),
(277, 176, 'Variation_Product', NULL, 555, 4, 1, 1, 'Live'),
(278, 176, 'Variation_Product', NULL, 555, 5, 1, 1, 'Live'),
(279, 177, 'Variation_Product', NULL, 555, 4, 1, 1, 'Live'),
(280, 177, 'Variation_Product', NULL, 555, 5, 1, 1, 'Live'),
(281, 179, 'Variation_Product', NULL, 100, 4, 1, 1, 'Live'),
(282, 179, 'Variation_Product', NULL, 100, 5, 1, 1, 'Live'),
(283, 180, 'Variation_Product', NULL, 100, 4, 1, 1, 'Live'),
(284, 180, 'Variation_Product', NULL, 100, 5, 1, 1, 'Live'),
(285, 181, 'Variation_Product', NULL, 100, 4, 1, 1, 'Live'),
(286, 181, 'Variation_Product', NULL, 100, 5, 1, 1, 'Live'),
(287, 182, 'Variation_Product', NULL, 100, 4, 1, 1, 'Live'),
(288, 182, 'Variation_Product', NULL, 100, 5, 1, 1, 'Live'),
(289, 184, 'Variation_Product', NULL, 100, 4, 1, 1, 'Live'),
(290, 184, 'Variation_Product', NULL, 120, 5, 1, 1, 'Live'),
(291, 185, 'Variation_Product', NULL, 100, 4, 1, 1, 'Live'),
(292, 185, 'Variation_Product', NULL, 120, 5, 1, 1, 'Live'),
(293, 186, 'Variation_Product', NULL, 100, 4, 1, 1, 'Live'),
(294, 186, 'Variation_Product', NULL, 120, 5, 1, 1, 'Live'),
(295, 187, 'Variation_Product', NULL, 100, 4, 1, 1, 'Live'),
(296, 187, 'Variation_Product', NULL, 120, 5, 1, 1, 'Live'),
(297, 189, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(298, 189, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(299, 190, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(300, 190, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(301, 191, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(302, 191, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(303, 192, 'Variation_Product', NULL, 150, 4, 1, 1, 'Live'),
(304, 192, 'Variation_Product', NULL, 150, 5, 1, 1, 'Live'),
(305, 194, 'Variation_Product', NULL, 120, 4, 1, 1, 'Live'),
(306, 194, 'Variation_Product', NULL, 140, 5, 1, 1, 'Live'),
(307, 195, 'Variation_Product', NULL, 120, 4, 1, 1, 'Live'),
(308, 195, 'Variation_Product', NULL, 140, 5, 1, 1, 'Live'),
(309, 196, 'Variation_Product', NULL, 120, 4, 1, 1, 'Live'),
(310, 196, 'Variation_Product', NULL, 140, 5, 1, 1, 'Live'),
(311, 197, 'Variation_Product', NULL, 120, 4, 1, 1, 'Live'),
(312, 197, 'Variation_Product', NULL, 140, 5, 1, 1, 'Live'),
(327, 208, 'Variation_Product', NULL, 100, 4, 1, 1, 'Live'),
(328, 208, 'Variation_Product', NULL, 100, 5, 1, 1, 'Live'),
(329, 209, 'Variation_Product', NULL, 110, 4, 1, 1, 'Live'),
(330, 209, 'Variation_Product', NULL, 110, 5, 1, 1, 'Live'),
(331, 210, 'Variation_Product', NULL, 120, 4, 1, 1, 'Live'),
(332, 210, 'Variation_Product', NULL, 120, 5, 1, 1, 'Live'),
(333, 211, 'Variation_Product', NULL, 80, 4, 1, 1, 'Live'),
(334, 211, 'Variation_Product', NULL, 80, 5, 1, 1, 'Live'),
(335, 212, 'IMEI_Product', '514393207756410', 1, 5, 1, 1, 'Live'),
(336, 212, 'IMEI_Product', '534129070198041', 1, 5, 1, 1, 'Live'),
(337, 212, 'IMEI_Product', '526329230522722', 1, 5, 1, 1, 'Live'),
(338, 212, 'IMEI_Product', '540188684939358', 1, 5, 1, 1, 'Live'),
(339, 212, 'IMEI_Product', '915004095688731', 1, 4, 1, 1, 'Live'),
(340, 212, 'IMEI_Product', '999884385304597', 1, 4, 1, 1, 'Live'),
(341, 212, 'IMEI_Product', '861416984985198', 1, 4, 1, 1, 'Live'),
(342, 212, 'IMEI_Product', '518606802454602', 1, 4, 1, 1, 'Live'),
(343, 213, 'IMEI_Product', '503144110208913', 1, 5, 1, 1, 'Live'),
(344, 213, 'IMEI_Product', '332536766024071', 1, 5, 1, 1, 'Live'),
(345, 213, 'IMEI_Product', '992218174897205', 1, 5, 1, 1, 'Live'),
(346, 213, 'IMEI_Product', '107531976251575', 1, 5, 1, 1, 'Live'),
(347, 213, 'IMEI_Product', '499078877672893', 1, 4, 1, 1, 'Live'),
(348, 213, 'IMEI_Product', '535097567483433', 1, 4, 1, 1, 'Live'),
(349, 213, 'IMEI_Product', '338277193662928', 1, 4, 1, 1, 'Live'),
(350, 213, 'IMEI_Product', '988976945973300', 1, 4, 1, 1, 'Live'),
(351, 214, 'IMEI_Product', '104988827727117', 1, 5, 1, 1, 'Live'),
(352, 214, 'IMEI_Product', '989421912548719', 1, 5, 1, 1, 'Live'),
(353, 214, 'IMEI_Product', '446889817402710', 1, 5, 1, 1, 'Live'),
(354, 214, 'IMEI_Product', '499676362739612', 1, 5, 1, 1, 'Live'),
(355, 214, 'IMEI_Product', '539606866685641', 1, 4, 1, 1, 'Live'),
(356, 214, 'IMEI_Product', '105269824232149', 1, 4, 1, 1, 'Live'),
(357, 214, 'IMEI_Product', '353315901967872', 1, 4, 1, 1, 'Live'),
(358, 214, 'IMEI_Product', '520481010048521', 1, 4, 1, 1, 'Live'),
(359, 215, 'IMEI_Product', '535731547030217', 1, 5, 1, 1, 'Live'),
(360, 215, 'IMEI_Product', '103939624082983', 1, 5, 1, 1, 'Live'),
(361, 215, 'IMEI_Product', '992312233333268', 1, 5, 1, 1, 'Live'),
(362, 215, 'IMEI_Product', '452306234600041', 1, 5, 1, 1, 'Live'),
(363, 215, 'IMEI_Product', '499126170838156', 1, 4, 1, 1, 'Live'),
(364, 215, 'IMEI_Product', '519828699492441', 1, 4, 1, 1, 'Live'),
(365, 215, 'IMEI_Product', '916251490218924', 1, 4, 1, 1, 'Live'),
(366, 215, 'IMEI_Product', '355292493034916', 1, 4, 1, 1, 'Live'),
(367, 216, 'IMEI_Product', '530705161959898', 1, 5, 1, 1, 'Live'),
(368, 216, 'IMEI_Product', '983426162221848', 1, 5, 1, 1, 'Live'),
(369, 216, 'IMEI_Product', '545845828450726', 1, 5, 1, 1, 'Live'),
(370, 216, 'IMEI_Product', '306173753830302', 1, 5, 1, 1, 'Live'),
(371, 216, 'IMEI_Product', '540151243728837', 1, 4, 1, 1, 'Live'),
(372, 216, 'IMEI_Product', '300549698241372', 1, 4, 1, 1, 'Live'),
(373, 216, 'IMEI_Product', '492843234964920', 1, 4, 1, 1, 'Live'),
(374, 216, 'IMEI_Product', '528115168756129', 1, 4, 1, 1, 'Live'),
(375, 217, 'IMEI_Product', '353029128448208', 1, 5, 1, 1, 'Live'),
(376, 217, 'IMEI_Product', '017070958117289', 1, 5, 1, 1, 'Live'),
(377, 217, 'IMEI_Product', '506474818885242', 1, 5, 1, 1, 'Live'),
(378, 217, 'IMEI_Product', '107484906802887', 1, 5, 1, 1, 'Live'),
(379, 217, 'IMEI_Product', '540296661934985', 1, 4, 1, 1, 'Live'),
(380, 217, 'IMEI_Product', '442323928209941', 1, 4, 1, 1, 'Live'),
(381, 217, 'IMEI_Product', '356520985836622', 1, 4, 1, 1, 'Live'),
(382, 217, 'IMEI_Product', '356520985836623', 1, 4, 1, 1, 'Live'),
(383, 218, 'IMEI_Product', '544886549146426', 1, 5, 1, 1, 'Live'),
(384, 218, 'IMEI_Product', '456741446026658', 1, 5, 1, 1, 'Live'),
(385, 218, 'IMEI_Product', '510150604679080', 1, 5, 1, 1, 'Live'),
(386, 218, 'IMEI_Product', '309490931774518', 1, 5, 1, 1, 'Live'),
(387, 218, 'IMEI_Product', '441411948078817', 1, 4, 1, 1, 'Live'),
(388, 218, 'IMEI_Product', '515119033362316', 1, 4, 1, 1, 'Live'),
(389, 218, 'IMEI_Product', '545513019693203', 1, 4, 1, 1, 'Live'),
(390, 218, 'IMEI_Product', '497409644389531', 1, 4, 1, 1, 'Live'),
(391, 219, 'IMEI_Product', '015299794533324', 1, 5, 1, 1, 'Live'),
(392, 219, 'IMEI_Product', '354447951123723', 1, 5, 1, 1, 'Live'),
(393, 219, 'IMEI_Product', '522100916447797', 1, 5, 1, 1, 'Live'),
(394, 219, 'IMEI_Product', '540976422778595', 1, 5, 1, 1, 'Live'),
(395, 219, 'IMEI_Product', '103322873692424', 1, 4, 1, 1, 'Live'),
(396, 219, 'IMEI_Product', '524218224957014', 1, 4, 1, 1, 'Live'),
(397, 219, 'IMEI_Product', '919144277872533', 1, 4, 1, 1, 'Live'),
(398, 219, 'IMEI_Product', '459248137042785', 1, 4, 1, 1, 'Live'),
(399, 220, 'IMEI_Product', '356728091234574', 1, 5, 1, 1, 'Live'),
(400, 220, 'IMEI_Product', '356728091234573', 1, 5, 1, 1, 'Live'),
(401, 220, 'IMEI_Product', '356728091234572', 1, 5, 1, 1, 'Live'),
(402, 220, 'IMEI_Product', '356728091234571', 1, 5, 1, 1, 'Live'),
(403, 220, 'IMEI_Product', '356728091234570', 1, 4, 1, 1, 'Live'),
(404, 220, 'IMEI_Product', '356728091234569', 1, 4, 1, 1, 'Live'),
(405, 220, 'IMEI_Product', '356728091234568', 1, 4, 1, 1, 'Live'),
(406, 220, 'IMEI_Product', '356728091234567', 1, 4, 1, 1, 'Live'),
(407, 221, 'IMEI_Product', '356729092345685', 1, 5, 1, 1, 'Live'),
(408, 221, 'IMEI_Product', '356729092345684', 1, 5, 1, 1, 'Live'),
(409, 221, 'IMEI_Product', '356729092345683', 1, 5, 1, 1, 'Live'),
(410, 221, 'IMEI_Product', '356729092345682', 1, 5, 1, 1, 'Live'),
(411, 221, 'IMEI_Product', '356729092345681', 1, 4, 1, 1, 'Live'),
(412, 221, 'IMEI_Product', '356729092345680', 1, 4, 1, 1, 'Live'),
(413, 221, 'IMEI_Product', '356729092345679', 1, 4, 1, 1, 'Live'),
(414, 221, 'IMEI_Product', '356729092345678', 1, 4, 1, 1, 'Live'),
(415, 222, 'IMEI_Product', '356730093456713', 1, 5, 1, 1, 'Live'),
(416, 222, 'IMEI_Product', '356730093456712', 1, 5, 1, 1, 'Live'),
(417, 222, 'IMEI_Product', '356730093456711', 1, 5, 1, 1, 'Live'),
(418, 222, 'IMEI_Product', '356730093456710', 1, 5, 1, 1, 'Live'),
(419, 222, 'IMEI_Product', '356730093456798', 1, 4, 1, 1, 'Live'),
(420, 222, 'IMEI_Product', '356730093456797', 1, 4, 1, 1, 'Live'),
(421, 222, 'IMEI_Product', '356730093456796', 1, 4, 1, 1, 'Live'),
(422, 222, 'IMEI_Product', '356730093456795', 1, 4, 1, 1, 'Live'),
(423, 223, 'IMEI_Product', '356731094567814', 1, 5, 1, 1, 'Live'),
(424, 223, 'IMEI_Product', '356731094567813', 1, 5, 1, 1, 'Live'),
(425, 223, 'IMEI_Product', '356731094567812', 1, 5, 1, 1, 'Live'),
(426, 223, 'IMEI_Product', '356731094567811', 1, 5, 1, 1, 'Live'),
(427, 223, 'IMEI_Product', '356731094567818', 1, 4, 1, 1, 'Live'),
(428, 223, 'IMEI_Product', '356731094567817', 1, 4, 1, 1, 'Live'),
(429, 223, 'IMEI_Product', '356731094567816', 1, 4, 1, 1, 'Live'),
(430, 223, 'IMEI_Product', '356731094567815', 1, 4, 1, 1, 'Live'),
(431, 224, 'IMEI_Product', '356734097890110', 1, 5, 1, 1, 'Live'),
(432, 224, 'IMEI_Product', '356734097890129', 1, 5, 1, 1, 'Live'),
(433, 224, 'IMEI_Product', '356734097890128', 1, 5, 1, 1, 'Live'),
(434, 224, 'IMEI_Product', '356734097890127', 1, 5, 1, 1, 'Live'),
(435, 224, 'IMEI_Product', '356734097890126', 1, 4, 1, 1, 'Live'),
(436, 224, 'IMEI_Product', '356734097890125', 1, 4, 1, 1, 'Live'),
(437, 224, 'IMEI_Product', '356734097890124', 1, 4, 1, 1, 'Live'),
(438, 224, 'IMEI_Product', '356734097890123', 1, 4, 1, 1, 'Live'),
(439, 225, 'IMEI_Product', '356735098901262', 1, 5, 1, 1, 'Live'),
(440, 225, 'IMEI_Product', '356735098901261', 1, 5, 1, 1, 'Live'),
(441, 225, 'IMEI_Product', '356735098901260', 1, 5, 1, 1, 'Live'),
(442, 225, 'IMEI_Product', '356735098901259', 1, 5, 1, 1, 'Live'),
(443, 225, 'IMEI_Product', '356735098901258', 1, 4, 1, 1, 'Live'),
(444, 225, 'IMEI_Product', '356735098901257', 1, 4, 1, 1, 'Live'),
(445, 225, 'IMEI_Product', '356735098901256', 1, 4, 1, 1, 'Live'),
(446, 225, 'IMEI_Product', '356735098901255', 1, 4, 1, 1, 'Live'),
(447, 226, 'IMEI_Product', '356732095678908', 1, 5, 1, 1, 'Live'),
(448, 226, 'IMEI_Product', '356732095678907', 1, 5, 1, 1, 'Live'),
(449, 226, 'IMEI_Product', '356732095678906', 1, 5, 1, 1, 'Live'),
(450, 226, 'IMEI_Product', '356732095678905', 1, 5, 1, 1, 'Live'),
(451, 226, 'IMEI_Product', '356732095678904', 1, 4, 1, 1, 'Live'),
(452, 226, 'IMEI_Product', '356732095678903', 1, 4, 1, 1, 'Live'),
(453, 226, 'IMEI_Product', '356732095678902', 1, 4, 1, 1, 'Live'),
(454, 226, 'IMEI_Product', '356732095678901', 1, 4, 1, 1, 'Live'),
(455, 227, 'IMEI_Product', '356733096789028', 1, 5, 1, 1, 'Live'),
(456, 227, 'IMEI_Product', '356733096789027', 1, 5, 1, 1, 'Live'),
(457, 227, 'IMEI_Product', '356733096789026', 1, 5, 1, 1, 'Live'),
(458, 227, 'IMEI_Product', '356733096789025', 1, 5, 1, 1, 'Live'),
(459, 227, 'IMEI_Product', '356733096789024', 1, 4, 1, 1, 'Live'),
(460, 227, 'IMEI_Product', '356733096789023', 1, 4, 1, 1, 'Live'),
(461, 227, 'IMEI_Product', '356733096789022', 1, 4, 1, 1, 'Live'),
(462, 227, 'IMEI_Product', '356733096789021', 1, 4, 1, 1, 'Live'),
(463, 228, 'IMEI_Product', '356728091234593', 1, 5, 1, 1, 'Live'),
(464, 228, 'IMEI_Product', '356728091234592', 1, 5, 1, 1, 'Live'),
(465, 228, 'IMEI_Product', '356728091234591', 1, 5, 1, 1, 'Live'),
(466, 228, 'IMEI_Product', '356728091234590', 1, 5, 1, 1, 'Live'),
(467, 228, 'IMEI_Product', '356728091234597', 1, 4, 1, 1, 'Live'),
(468, 228, 'IMEI_Product', '356728091234596', 1, 4, 1, 1, 'Live'),
(469, 228, 'IMEI_Product', '356728091234595', 1, 4, 1, 1, 'Live'),
(470, 228, 'IMEI_Product', '356728091234594', 1, 4, 1, 1, 'Live'),
(471, 229, 'IMEI_Product', '356729092345896', 1, 5, 1, 1, 'Live'),
(472, 229, 'IMEI_Product', '356729092345895', 1, 5, 1, 1, 'Live'),
(473, 229, 'IMEI_Product', '356729092345894', 1, 5, 1, 1, 'Live'),
(474, 229, 'IMEI_Product', '356729092345893', 1, 5, 1, 1, 'Live'),
(475, 229, 'IMEI_Product', '356729092345892', 1, 4, 1, 1, 'Live'),
(476, 229, 'IMEI_Product', '356729092345891', 1, 4, 1, 1, 'Live'),
(477, 229, 'IMEI_Product', '356729092345890', 1, 4, 1, 1, 'Live'),
(478, 229, 'IMEI_Product', '356729092345889', 1, 4, 1, 1, 'Live'),
(479, 230, 'IMEI_Product', '356730083456783', 1, 5, 1, 1, 'Live'),
(480, 230, 'IMEI_Product', '356730083456782', 1, 5, 1, 1, 'Live'),
(481, 230, 'IMEI_Product', '356730083456781', 1, 5, 1, 1, 'Live'),
(482, 230, 'IMEI_Product', '356730083456780', 1, 5, 1, 1, 'Live'),
(483, 230, 'IMEI_Product', '356730083456788', 1, 4, 1, 1, 'Live'),
(484, 230, 'IMEI_Product', '356730083456787', 1, 4, 1, 1, 'Live'),
(485, 230, 'IMEI_Product', '356730083456786', 1, 4, 1, 1, 'Live'),
(486, 230, 'IMEI_Product', '356730083456784', 1, 4, 1, 1, 'Live'),
(487, 231, 'IMEI_Product', '356732094567897', 1, 5, 1, 1, 'Live'),
(488, 231, 'IMEI_Product', '356732094567896', 1, 5, 1, 1, 'Live'),
(489, 231, 'IMEI_Product', '356732094567895', 1, 5, 1, 1, 'Live'),
(490, 231, 'IMEI_Product', '356732094567894', 1, 5, 1, 1, 'Live'),
(491, 231, 'IMEI_Product', '356732094567893', 1, 4, 1, 1, 'Live'),
(492, 231, 'IMEI_Product', '356732094567892', 1, 4, 1, 1, 'Live'),
(493, 231, 'IMEI_Product', '356732094567891', 1, 4, 1, 1, 'Live'),
(494, 231, 'IMEI_Product', '356732094567890', 1, 4, 1, 1, 'Live'),
(495, 232, 'IMEI_Product', '356732195678908', 1, 5, 1, 1, 'Live'),
(496, 232, 'IMEI_Product', '356732195678907', 1, 5, 1, 1, 'Live'),
(497, 232, 'IMEI_Product', '356732195678906', 1, 5, 1, 1, 'Live'),
(498, 232, 'IMEI_Product', '356732195678905', 1, 5, 1, 1, 'Live'),
(499, 232, 'IMEI_Product', '356732195678904', 1, 4, 1, 1, 'Live'),
(500, 232, 'IMEI_Product', '356732195678903', 1, 4, 1, 1, 'Live'),
(501, 232, 'IMEI_Product', '356732195678902', 1, 4, 1, 1, 'Live'),
(502, 232, 'IMEI_Product', '356732195678901', 1, 4, 1, 1, 'Live'),
(503, 233, 'IMEI_Product', '356733096789019', 1, 5, 1, 1, 'Live'),
(504, 233, 'IMEI_Product', '356733096789018', 1, 5, 1, 1, 'Live'),
(505, 233, 'IMEI_Product', '356733096789017', 1, 5, 1, 1, 'Live'),
(506, 233, 'IMEI_Product', '356733096789016', 1, 5, 1, 1, 'Live'),
(507, 233, 'IMEI_Product', '356733096789015', 1, 4, 1, 1, 'Live'),
(508, 233, 'IMEI_Product', '356733096789014', 1, 4, 1, 1, 'Live'),
(509, 233, 'IMEI_Product', '356733096789013', 1, 4, 1, 1, 'Live'),
(510, 233, 'IMEI_Product', '356733096789012', 1, 4, 1, 1, 'Live'),
(511, 234, 'IMEI_Product', '356734197890110', 1, 5, 1, 1, 'Live'),
(512, 234, 'IMEI_Product', '356734197890129', 1, 5, 1, 1, 'Live'),
(513, 234, 'IMEI_Product', '356734197890128', 1, 5, 1, 1, 'Live'),
(514, 234, 'IMEI_Product', '356734197890127', 1, 5, 1, 1, 'Live'),
(515, 234, 'IMEI_Product', '356734197890126', 1, 4, 1, 1, 'Live'),
(516, 234, 'IMEI_Product', '356734197890125', 1, 4, 1, 1, 'Live'),
(517, 234, 'IMEI_Product', '356734197890124', 1, 4, 1, 1, 'Live'),
(518, 234, 'IMEI_Product', '356734197890123', 1, 4, 1, 1, 'Live'),
(519, 235, 'IMEI_Product', '356735098901238', 1, 5, 1, 1, 'Live'),
(520, 235, 'IMEI_Product', '356735098901233', 1, 5, 1, 1, 'Live'),
(521, 235, 'IMEI_Product', '356735098901232', 1, 5, 1, 1, 'Live'),
(522, 235, 'IMEI_Product', '356735098901231', 1, 5, 1, 1, 'Live'),
(523, 235, 'IMEI_Product', '356735098901237', 1, 4, 1, 1, 'Live'),
(524, 235, 'IMEI_Product', '356735098901236', 1, 4, 1, 1, 'Live'),
(525, 235, 'IMEI_Product', '356735098901235', 1, 4, 1, 1, 'Live'),
(526, 235, 'IMEI_Product', '356735098901234', 1, 4, 1, 1, 'Live'),
(527, 236, 'IMEI_Product', '357728091234674', 1, 5, 1, 1, 'Live'),
(528, 236, 'IMEI_Product', '357728091234673', 1, 5, 1, 1, 'Live'),
(529, 236, 'IMEI_Product', '357728091234672', 1, 5, 1, 1, 'Live'),
(530, 236, 'IMEI_Product', '357728091234671', 1, 5, 1, 1, 'Live'),
(531, 236, 'IMEI_Product', '357728091234670', 1, 4, 1, 1, 'Live'),
(532, 236, 'IMEI_Product', '357728091234669', 1, 4, 1, 1, 'Live'),
(533, 236, 'IMEI_Product', '357728091234668', 1, 4, 1, 1, 'Live'),
(534, 236, 'IMEI_Product', '357728091234667', 1, 4, 1, 1, 'Live'),
(535, 237, 'IMEI_Product', '357728091234578', 1, 5, 1, 1, 'Live'),
(536, 237, 'IMEI_Product', '357728091234577', 1, 5, 1, 1, 'Live'),
(537, 237, 'IMEI_Product', '357728091234576', 1, 5, 1, 1, 'Live'),
(538, 237, 'IMEI_Product', '357728091234575', 1, 5, 1, 1, 'Live'),
(539, 237, 'IMEI_Product', '357728091234574', 1, 4, 1, 1, 'Live'),
(540, 237, 'IMEI_Product', '357728091234573', 1, 4, 1, 1, 'Live'),
(541, 237, 'IMEI_Product', '357728091234572', 1, 4, 1, 1, 'Live'),
(542, 237, 'IMEI_Product', '357728091234571', 1, 4, 1, 1, 'Live'),
(543, 238, 'IMEI_Product', '358728091234574', 1, 5, 1, 1, 'Live'),
(544, 238, 'IMEI_Product', '358728091234573', 1, 5, 1, 1, 'Live'),
(545, 238, 'IMEI_Product', '358728091234572', 1, 5, 1, 1, 'Live'),
(546, 238, 'IMEI_Product', '358728091234571', 1, 5, 1, 1, 'Live'),
(547, 238, 'IMEI_Product', '358728091234570', 1, 4, 1, 1, 'Live'),
(548, 238, 'IMEI_Product', '358728091234569', 1, 4, 1, 1, 'Live'),
(549, 238, 'IMEI_Product', '358728091234568', 1, 4, 1, 1, 'Live'),
(550, 238, 'IMEI_Product', '358728091234567', 1, 4, 1, 1, 'Live'),
(551, 239, 'IMEI_Product', '358728091234588', 1, 5, 1, 1, 'Live'),
(552, 239, 'IMEI_Product', '358728091234587', 1, 5, 1, 1, 'Live'),
(553, 239, 'IMEI_Product', '358728091234586', 1, 5, 1, 1, 'Live'),
(554, 239, 'IMEI_Product', '3587280912345815', 1, 5, 1, 1, 'Live'),
(555, 239, 'IMEI_Product', '358728091234584', 1, 4, 1, 1, 'Live'),
(556, 239, 'IMEI_Product', '358728091234583', 1, 4, 1, 1, 'Live'),
(557, 239, 'IMEI_Product', '358728091234582', 1, 4, 1, 1, 'Live'),
(558, 239, 'IMEI_Product', '358728091234581', 1, 4, 1, 1, 'Live'),
(559, 240, 'IMEI_Product', '359728091234570', 1, 5, 1, 1, 'Live'),
(560, 240, 'IMEI_Product', '359728091234569', 1, 5, 1, 1, 'Live'),
(561, 240, 'IMEI_Product', '359728091234568', 1, 5, 1, 1, 'Live'),
(562, 240, 'IMEI_Product', '359728091234567', 1, 5, 1, 1, 'Live'),
(563, 240, 'IMEI_Product', '359728091234574', 1, 4, 1, 1, 'Live'),
(564, 240, 'IMEI_Product', '359728091234573', 1, 4, 1, 1, 'Live'),
(565, 240, 'IMEI_Product', '359728091234572', 1, 4, 1, 1, 'Live'),
(566, 240, 'IMEI_Product', '359728091234571', 1, 4, 1, 1, 'Live'),
(567, 241, 'IMEI_Product', '359728091234588', 1, 5, 1, 1, 'Live'),
(568, 241, 'IMEI_Product', '359728091234587', 1, 5, 1, 1, 'Live'),
(569, 241, 'IMEI_Product', '359728091234586', 1, 5, 1, 1, 'Live'),
(570, 241, 'IMEI_Product', '359728091234585', 1, 5, 1, 1, 'Live'),
(571, 241, 'IMEI_Product', '359728091234584', 1, 4, 1, 1, 'Live'),
(572, 241, 'IMEI_Product', '359728091234583', 1, 4, 1, 1, 'Live'),
(573, 241, 'IMEI_Product', '359728091234582', 1, 4, 1, 1, 'Live'),
(574, 241, 'IMEI_Product', '359728091234581', 1, 4, 1, 1, 'Live'),
(575, 242, 'IMEI_Product', '360728091234574', 1, 5, 1, 1, 'Live'),
(576, 242, 'IMEI_Product', '360728091234573', 1, 5, 1, 1, 'Live'),
(577, 242, 'IMEI_Product', '360728091234572', 1, 5, 1, 1, 'Live'),
(578, 242, 'IMEI_Product', '360728091234571', 1, 5, 1, 1, 'Live'),
(579, 242, 'IMEI_Product', '360728091234570', 1, 4, 1, 1, 'Live'),
(580, 242, 'IMEI_Product', '360728091234569', 1, 4, 1, 1, 'Live'),
(581, 242, 'IMEI_Product', '360728091234568', 1, 4, 1, 1, 'Live'),
(582, 242, 'IMEI_Product', '360728091234567', 1, 4, 1, 1, 'Live'),
(583, 243, 'IMEI_Product', '360728091235578', 1, 5, 1, 1, 'Live'),
(584, 243, 'IMEI_Product', '360728091235577', 1, 5, 1, 1, 'Live'),
(585, 243, 'IMEI_Product', '360728091235576', 1, 5, 1, 1, 'Live'),
(586, 243, 'IMEI_Product', '360728091235575', 1, 5, 1, 1, 'Live'),
(587, 243, 'IMEI_Product', '360728091235574', 1, 4, 1, 1, 'Live'),
(588, 243, 'IMEI_Product', '360728091235573', 1, 4, 1, 1, 'Live'),
(589, 243, 'IMEI_Product', '360728091235572', 1, 4, 1, 1, 'Live'),
(590, 243, 'IMEI_Product', '360728091235571', 1, 4, 1, 1, 'Live'),
(591, 244, 'IMEI_Product', '359472092847537', 1, 5, 1, 1, 'Live'),
(592, 244, 'IMEI_Product', '359472092847536', 1, 5, 1, 1, 'Live'),
(593, 244, 'IMEI_Product', '359472092847535', 1, 5, 1, 1, 'Live'),
(594, 244, 'IMEI_Product', '359472092847534', 1, 5, 1, 1, 'Live'),
(595, 244, 'IMEI_Product', '359472092847533', 1, 4, 1, 1, 'Live'),
(596, 244, 'IMEI_Product', '359472092847532', 1, 4, 1, 1, 'Live'),
(597, 244, 'IMEI_Product', '359472092847531', 1, 4, 1, 1, 'Live'),
(598, 244, 'IMEI_Product', '359472092847530', 1, 4, 1, 1, 'Live'),
(599, 245, 'IMEI_Product', '352968097654328', 1, 5, 1, 1, 'Live'),
(600, 245, 'IMEI_Product', '352968097654327', 1, 5, 1, 1, 'Live'),
(601, 245, 'IMEI_Product', '352968097654326', 1, 5, 1, 1, 'Live'),
(602, 245, 'IMEI_Product', '352968097654325', 1, 5, 1, 1, 'Live'),
(603, 245, 'IMEI_Product', '352968097654324', 1, 4, 1, 1, 'Live'),
(604, 245, 'IMEI_Product', '352968097654323', 1, 4, 1, 1, 'Live'),
(605, 245, 'IMEI_Product', '352968097654322', 1, 4, 1, 1, 'Live'),
(606, 245, 'IMEI_Product', '352968097654321', 1, 4, 1, 1, 'Live'),
(607, 246, 'IMEI_Product', '354896073456796', 1, 5, 1, 1, 'Live'),
(608, 246, 'IMEI_Product', '354896073456795', 1, 5, 1, 1, 'Live'),
(609, 246, 'IMEI_Product', '354896073456794', 1, 5, 1, 1, 'Live'),
(610, 246, 'IMEI_Product', '354896073456793', 1, 5, 1, 1, 'Live'),
(611, 246, 'IMEI_Product', '354896073456792', 1, 4, 1, 1, 'Live'),
(612, 246, 'IMEI_Product', '354896073456791', 1, 4, 1, 1, 'Live'),
(613, 246, 'IMEI_Product', '354896073456790', 1, 4, 1, 1, 'Live'),
(614, 246, 'IMEI_Product', '354896073456789', 1, 4, 1, 1, 'Live'),
(615, 247, 'IMEI_Product', '357592091234574', 1, 5, 1, 1, 'Live'),
(616, 247, 'IMEI_Product', '357592091234573', 1, 5, 1, 1, 'Live'),
(617, 247, 'IMEI_Product', '357592091234572', 1, 5, 1, 1, 'Live'),
(618, 247, 'IMEI_Product', '357592091234571', 1, 5, 1, 1, 'Live'),
(619, 247, 'IMEI_Product', '357592091234570', 1, 4, 1, 1, 'Live'),
(620, 247, 'IMEI_Product', '357592091234569', 1, 4, 1, 1, 'Live'),
(621, 247, 'IMEI_Product', '357592091234568', 1, 4, 1, 1, 'Live'),
(622, 247, 'IMEI_Product', '357592091234567', 1, 4, 1, 1, 'Live'),
(623, 248, 'IMEI_Product', '358762095678130', 1, 5, 1, 1, 'Live'),
(624, 248, 'IMEI_Product', '358762095678129', 1, 5, 1, 1, 'Live'),
(625, 248, 'IMEI_Product', '358762095678128', 1, 5, 1, 1, 'Live'),
(626, 248, 'IMEI_Product', '358762095678127', 1, 5, 1, 1, 'Live'),
(627, 248, 'IMEI_Product', '358762095678126', 1, 4, 1, 1, 'Live'),
(628, 248, 'IMEI_Product', '358762095678125', 1, 4, 1, 1, 'Live'),
(629, 248, 'IMEI_Product', '358762095678124', 1, 4, 1, 1, 'Live'),
(630, 248, 'IMEI_Product', '358762095678123', 1, 4, 1, 1, 'Live'),
(631, 249, 'IMEI_Product', '356897092345687', 1, 5, 1, 1, 'Live'),
(632, 249, 'IMEI_Product', '356897092345686', 1, 5, 1, 1, 'Live'),
(633, 249, 'IMEI_Product', '356897092345685', 1, 5, 1, 1, 'Live'),
(634, 249, 'IMEI_Product', '356897092345684', 1, 5, 1, 1, 'Live'),
(635, 249, 'IMEI_Product', '356897092345683', 1, 4, 1, 1, 'Live'),
(636, 249, 'IMEI_Product', '356897092345682', 1, 4, 1, 1, 'Live'),
(637, 249, 'IMEI_Product', '356897092345681', 1, 4, 1, 1, 'Live'),
(638, 249, 'IMEI_Product', '356897092345680', 1, 4, 1, 1, 'Live'),
(639, 250, 'IMEI_Product', '354896071234897', 1, 5, 1, 1, 'Live'),
(640, 250, 'IMEI_Product', '354896071234896', 1, 5, 1, 1, 'Live'),
(641, 250, 'IMEI_Product', '354896071234895', 1, 5, 1, 1, 'Live'),
(642, 250, 'IMEI_Product', '354896071234894', 1, 5, 1, 1, 'Live'),
(643, 250, 'IMEI_Product', '354896071234893', 1, 4, 1, 1, 'Live'),
(644, 250, 'IMEI_Product', '354896071234892', 1, 4, 1, 1, 'Live'),
(645, 250, 'IMEI_Product', '354896071234891', 1, 4, 1, 1, 'Live'),
(646, 250, 'IMEI_Product', '354896071234890', 1, 4, 1, 1, 'Live'),
(647, 251, 'IMEI_Product', '358964082345687', 1, 5, 1, 1, 'Live'),
(648, 251, 'IMEI_Product', '358964082345686', 1, 5, 1, 1, 'Live'),
(649, 251, 'IMEI_Product', '358964082345685', 1, 5, 1, 1, 'Live'),
(650, 251, 'IMEI_Product', '358964082345684', 1, 5, 1, 1, 'Live'),
(651, 251, 'IMEI_Product', '358964082345683', 1, 4, 1, 1, 'Live'),
(652, 251, 'IMEI_Product', '358964082345682', 1, 4, 1, 1, 'Live'),
(653, 251, 'IMEI_Product', '358964082345681', 1, 4, 1, 1, 'Live'),
(654, 251, 'IMEI_Product', '358964082345680', 1, 4, 1, 1, 'Live'),
(663, 252, 'IMEI_Product', '458607044466034', 1, 5, 1, 1, 'Live'),
(664, 252, 'IMEI_Product', '014311904286684', 1, 5, 1, 1, 'Live'),
(665, 252, 'IMEI_Product', '539414213530804', 1, 5, 1, 1, 'Live'),
(666, 252, 'IMEI_Product', '458432680306232', 1, 5, 1, 1, 'Live'),
(667, 252, 'IMEI_Product', '994921311155092', 1, 4, 1, 1, 'Live'),
(668, 252, 'IMEI_Product', '509031228264801', 1, 4, 1, 1, 'Live'),
(669, 252, 'IMEI_Product', '547376564542490', 1, 4, 1, 1, 'Live'),
(670, 252, 'IMEI_Product', '517549273684300', 1, 4, 1, 1, 'Live'),
(679, 253, 'Serial_Product', 'XDR12345685', 1, 5, 1, 1, 'Live'),
(680, 253, 'Serial_Product', 'XDR12345684', 1, 5, 1, 1, 'Live'),
(681, 253, 'Serial_Product', 'XDR12345683', 1, 5, 1, 1, 'Live'),
(682, 253, 'Serial_Product', 'XDR12345682', 1, 5, 1, 1, 'Live'),
(683, 253, 'Serial_Product', 'XDR12345681', 1, 4, 1, 1, 'Live'),
(684, 253, 'Serial_Product', 'XDR12345680', 1, 4, 1, 1, 'Live'),
(685, 253, 'Serial_Product', 'XDR12345679', 1, 4, 1, 1, 'Live'),
(686, 253, 'Serial_Product', 'XDR12345678', 1, 4, 1, 1, 'Live'),
(687, 254, 'Serial_Product', 'TBD87654328', 1, 5, 1, 1, 'Live'),
(688, 254, 'Serial_Product', 'TBD87654327', 1, 5, 1, 1, 'Live'),
(689, 254, 'Serial_Product', 'TBD87654326', 1, 5, 1, 1, 'Live'),
(690, 254, 'Serial_Product', 'TBD87654325', 1, 5, 1, 1, 'Live'),
(691, 254, 'Serial_Product', 'TBD87654324', 1, 4, 1, 1, 'Live'),
(692, 254, 'Serial_Product', 'TBD87654323', 1, 4, 1, 1, 'Live'),
(693, 254, 'Serial_Product', 'TBD87654322', 1, 4, 1, 1, 'Live'),
(694, 254, 'Serial_Product', 'TBD87654321', 1, 4, 1, 1, 'Live'),
(695, 255, 'Serial_Product', 'HPZ274K1243', 1, 5, 1, 1, 'Live'),
(696, 255, 'Serial_Product', 'HPZ274K1242', 1, 5, 1, 1, 'Live'),
(697, 255, 'Serial_Product', 'HPZ274K1241', 1, 5, 1, 1, 'Live'),
(698, 255, 'Serial_Product', 'HPZ274K1240', 1, 5, 1, 1, 'Live'),
(699, 255, 'Serial_Product', 'HPZ274K1237', 1, 4, 1, 1, 'Live'),
(700, 255, 'Serial_Product', 'HPZ274K1236', 1, 4, 1, 1, 'Live'),
(701, 255, 'Serial_Product', 'HPZ274K1235', 1, 4, 1, 1, 'Live'),
(702, 255, 'Serial_Product', 'HPZ274K1234', 1, 4, 1, 1, 'Live'),
(703, 256, 'Serial_Product', 'HPE2435685', 1, 5, 1, 1, 'Live'),
(704, 256, 'Serial_Product', 'HPE2435684', 1, 5, 1, 1, 'Live'),
(705, 256, 'Serial_Product', 'HPE2435683', 1, 5, 1, 1, 'Live'),
(706, 256, 'Serial_Product', 'HPE2435682', 1, 5, 1, 1, 'Live'),
(707, 256, 'Serial_Product', 'HPE2435681', 1, 4, 1, 1, 'Live'),
(708, 256, 'Serial_Product', 'HPE2435680', 1, 4, 1, 1, 'Live'),
(709, 256, 'Serial_Product', 'HPE2435679', 1, 4, 1, 1, 'Live'),
(710, 256, 'Serial_Product', 'HPE2435678', 1, 4, 1, 1, 'Live'),
(711, 257, 'Serial_Product', 'U2720Q9106', 1, 5, 1, 1, 'Live'),
(712, 257, 'Serial_Product', 'U2720Q9105', 1, 5, 1, 1, 'Live'),
(713, 257, 'Serial_Product', 'U2720Q9104', 1, 5, 1, 1, 'Live'),
(714, 257, 'Serial_Product', 'U2720Q9103', 1, 5, 1, 1, 'Live'),
(715, 257, 'Serial_Product', 'U2720Q9102', 1, 4, 1, 1, 'Live'),
(716, 257, 'Serial_Product', 'U2720Q9101', 1, 4, 1, 1, 'Live'),
(717, 257, 'Serial_Product', 'U2720Q9100', 1, 4, 1, 1, 'Live'),
(718, 257, 'Serial_Product', 'U2720Q9999', 1, 4, 1, 1, 'Live'),
(719, 258, 'Serial_Product', 'P2419H5562', 1, 5, 1, 1, 'Live'),
(720, 258, 'Serial_Product', 'P2419H5561', 1, 5, 1, 1, 'Live'),
(721, 258, 'Serial_Product', 'P2419H5560', 1, 5, 1, 1, 'Live'),
(722, 258, 'Serial_Product', 'P2419H5559', 1, 5, 1, 1, 'Live'),
(723, 258, 'Serial_Product', 'P2419H5558', 1, 4, 1, 1, 'Live'),
(724, 258, 'Serial_Product', 'P2419H5557', 1, 4, 1, 1, 'Live'),
(725, 258, 'Serial_Product', 'P2419H5556', 1, 4, 1, 1, 'Live'),
(726, 258, 'Serial_Product', 'P2419H5555', 1, 4, 1, 1, 'Live'),
(727, 259, 'Serial_Product', 'UF5K135797', 1, 5, 1, 1, 'Live'),
(728, 259, 'Serial_Product', 'UF5K135796', 1, 5, 1, 1, 'Live'),
(729, 259, 'Serial_Product', 'UF5K135795', 1, 5, 1, 1, 'Live'),
(730, 259, 'Serial_Product', 'UF5K135794', 1, 5, 1, 1, 'Live'),
(731, 259, 'Serial_Product', 'UF5K135793', 1, 4, 1, 1, 'Live'),
(732, 259, 'Serial_Product', 'UF5K135792', 1, 4, 1, 1, 'Live'),
(733, 259, 'Serial_Product', 'UF5K135791', 1, 4, 1, 1, 'Live'),
(734, 259, 'Serial_Product', 'UF5K135790', 1, 4, 1, 1, 'Live'),
(735, 260, 'Serial_Product', '27UK8504689', 1, 5, 1, 1, 'Live'),
(736, 260, 'Serial_Product', '27UK8504688', 1, 5, 1, 1, 'Live'),
(737, 260, 'Serial_Product', '27UK8504687', 1, 5, 1, 1, 'Live'),
(738, 260, 'Serial_Product', '27UK8504686', 1, 5, 1, 1, 'Live'),
(739, 260, 'Serial_Product', '27UK8504685', 1, 4, 1, 1, 'Live'),
(740, 260, 'Serial_Product', '27UK8504684', 1, 4, 1, 1, 'Live'),
(741, 260, 'Serial_Product', '27UK8504683', 1, 4, 1, 1, 'Live'),
(742, 260, 'Serial_Product', '27UK8504682', 1, 4, 1, 1, 'Live'),
(767, 263, 'Serial_Product', 'C1OLED124585', 1, 5, 1, 1, 'Live'),
(768, 263, 'Serial_Product', 'C1OLED124584', 1, 5, 1, 1, 'Live'),
(769, 263, 'Serial_Product', 'C1OLED124583', 1, 5, 1, 1, 'Live'),
(770, 263, 'Serial_Product', 'C1OLED124582', 1, 5, 1, 1, 'Live'),
(771, 263, 'Serial_Product', 'C1OLED124581', 1, 4, 1, 1, 'Live'),
(772, 263, 'Serial_Product', 'C1OLED124580', 1, 4, 1, 1, 'Live'),
(773, 263, 'Serial_Product', 'C1OLED124579', 1, 4, 1, 1, 'Live'),
(774, 263, 'Serial_Product', 'C1OLED124578', 1, 4, 1, 1, 'Live'),
(775, 262, 'Serial_Product', 'TU800098772', 1, 5, 1, 1, 'Live'),
(776, 262, 'Serial_Product', 'TU800098771', 1, 5, 1, 1, 'Live'),
(777, 262, 'Serial_Product', 'TU800098770', 1, 5, 1, 1, 'Live'),
(778, 262, 'Serial_Product', 'TU800098769', 1, 5, 1, 1, 'Live'),
(779, 262, 'Serial_Product', 'TU800098768', 1, 4, 1, 1, 'Live'),
(780, 262, 'Serial_Product', 'TU800098767', 1, 4, 1, 1, 'Live'),
(781, 262, 'Serial_Product', 'TU800098766', 1, 4, 1, 1, 'Live'),
(782, 262, 'Serial_Product', 'TU800098765', 1, 4, 1, 1, 'Live'),
(783, 261, 'Serial_Product', 'QN90A202352', 1, 5, 1, 1, 'Live'),
(784, 261, 'Serial_Product', 'QN90A202351', 1, 5, 1, 1, 'Live'),
(785, 261, 'Serial_Product', 'QN90A202350', 1, 5, 1, 1, 'Live'),
(786, 261, 'Serial_Product', 'QN90A202349', 1, 5, 1, 1, 'Live'),
(787, 261, 'Serial_Product', 'QN90A202348', 1, 4, 1, 1, 'Live'),
(788, 261, 'Serial_Product', 'QN90A202347', 1, 4, 1, 1, 'Live'),
(789, 261, 'Serial_Product', 'QN90A202346', 1, 4, 1, 1, 'Live'),
(790, 261, 'Serial_Product', 'QN90A202345', 1, 4, 1, 1, 'Live'),
(791, 264, 'Serial_Product', 'NC904568130', 1, 5, 1, 1, 'Live'),
(792, 264, 'Serial_Product', 'NC904568129', 1, 5, 1, 1, 'Live'),
(793, 264, 'Serial_Product', 'NC904568128', 1, 5, 1, 1, 'Live'),
(794, 264, 'Serial_Product', 'NC904568127', 1, 5, 1, 1, 'Live'),
(795, 264, 'Serial_Product', 'NC904568126', 1, 4, 1, 1, 'Live'),
(796, 264, 'Serial_Product', 'NC904568125', 1, 4, 1, 1, 'Live'),
(797, 264, 'Serial_Product', 'NC904568124', 1, 4, 1, 1, 'Live'),
(798, 264, 'Serial_Product', 'NC904568123', 1, 4, 1, 1, 'Live'),
(799, 265, 'Serial_Product', 'A90J34561241', 1, 5, 1, 1, 'Live'),
(800, 265, 'Serial_Product', 'A90J34561240', 1, 5, 1, 1, 'Live'),
(801, 265, 'Serial_Product', 'A90J34561239', 1, 5, 1, 1, 'Live'),
(802, 265, 'Serial_Product', 'A90J34561238', 1, 5, 1, 1, 'Live'),
(803, 265, 'Serial_Product', 'A90J34561237', 1, 4, 1, 1, 'Live'),
(804, 265, 'Serial_Product', 'A90J34561236', 1, 4, 1, 1, 'Live'),
(805, 265, 'Serial_Product', 'A90J34561235', 1, 4, 1, 1, 'Live'),
(806, 265, 'Serial_Product', 'A90J34561234', 1, 4, 1, 1, 'Live'),
(807, 266, 'Serial_Product', 'X90J78906550', 1, 5, 1, 1, 'Live'),
(808, 266, 'Serial_Product', 'X90J78906549', 1, 5, 1, 1, 'Live'),
(809, 266, 'Serial_Product', 'X90J78906548', 1, 5, 1, 1, 'Live'),
(810, 266, 'Serial_Product', 'X90J78906547', 1, 5, 1, 1, 'Live'),
(811, 266, 'Serial_Product', 'X90J78906546', 1, 4, 1, 1, 'Live'),
(812, 266, 'Serial_Product', 'X90J78906545', 1, 4, 1, 1, 'Live'),
(813, 266, 'Serial_Product', 'X90J78906544', 1, 4, 1, 1, 'Live'),
(814, 266, 'Serial_Product', 'X90J78906543', 1, 4, 1, 1, 'Live'),
(815, 267, 'Serial_Product', 'HZ2000567819', 1, 5, 1, 1, 'Live'),
(816, 267, 'Serial_Product', 'HZ2000567818', 1, 5, 1, 1, 'Live'),
(817, 267, 'Serial_Product', 'HZ2000567817', 1, 5, 1, 1, 'Live'),
(818, 267, 'Serial_Product', 'HZ2000567816', 1, 5, 1, 1, 'Live'),
(819, 267, 'Serial_Product', 'HZ2000567815', 1, 4, 1, 1, 'Live'),
(820, 267, 'Serial_Product', 'HZ2000567814', 1, 4, 1, 1, 'Live'),
(821, 267, 'Serial_Product', 'HZ2000567813', 1, 4, 1, 1, 'Live'),
(822, 267, 'Serial_Product', 'HZ2000567812', 1, 4, 1, 1, 'Live'),
(823, 268, 'Serial_Product', 'GX8000123105', 1, 5, 1, 1, 'Live'),
(824, 268, 'Serial_Product', 'GX8000123104', 1, 5, 1, 1, 'Live'),
(825, 268, 'Serial_Product', 'GX8000123103', 1, 5, 1, 1, 'Live'),
(826, 268, 'Serial_Product', 'GX8000123102', 1, 5, 1, 1, 'Live'),
(827, 268, 'Serial_Product', 'GX8000123101', 1, 4, 1, 1, 'Live'),
(828, 268, 'Serial_Product', 'GX8000123100', 1, 4, 1, 1, 'Live'),
(829, 268, 'Serial_Product', 'GX8000123499', 1, 4, 1, 1, 'Live'),
(830, 268, 'Serial_Product', 'GX8000123498', 1, 4, 1, 1, 'Live'),
(831, 269, 'Serial_Product', 'MBP16A2023463', 1, 5, 1, 1, 'Live'),
(832, 269, 'Serial_Product', 'MBP16A2023462', 1, 5, 1, 1, 'Live'),
(833, 269, 'Serial_Product', 'MBP16A2023461', 1, 5, 1, 1, 'Live'),
(834, 269, 'Serial_Product', 'MBP16A2023460', 1, 5, 1, 1, 'Live'),
(835, 269, 'Serial_Product', 'MBP16A2023459', 1, 4, 1, 1, 'Live'),
(836, 269, 'Serial_Product', 'MBP16A2023458', 1, 4, 1, 1, 'Live'),
(837, 269, 'Serial_Product', 'MBP16A2023457', 1, 4, 1, 1, 'Live'),
(838, 269, 'Serial_Product', 'MBP16A2023456', 1, 4, 1, 1, 'Live'),
(839, 270, 'Serial_Product', 'MBA13B7896549', 1, 5, 1, 1, 'Live'),
(840, 270, 'Serial_Product', 'MBA13B7896548', 1, 5, 1, 1, 'Live'),
(841, 270, 'Serial_Product', 'MBA13B7896547', 1, 5, 1, 1, 'Live'),
(842, 270, 'Serial_Product', 'MBA13B7896546', 1, 5, 1, 1, 'Live'),
(843, 270, 'Serial_Product', 'MBA13B7896545', 1, 4, 1, 1, 'Live'),
(844, 270, 'Serial_Product', 'MBA13B7896544', 1, 4, 1, 1, 'Live'),
(845, 270, 'Serial_Product', 'MBA13B7896543', 1, 4, 1, 1, 'Live'),
(846, 270, 'Serial_Product', 'MBA13B7896542', 1, 4, 1, 1, 'Live'),
(847, 271, 'Serial_Product', 'SPECTREX36014C567898', 1, 5, 1, 1, 'Live'),
(848, 271, 'Serial_Product', 'SPECTREX36014C567897', 1, 5, 1, 1, 'Live'),
(849, 271, 'Serial_Product', 'SPECTREX36014C567896', 1, 5, 1, 1, 'Live'),
(850, 271, 'Serial_Product', 'SPECTREX36014C567895', 1, 5, 1, 1, 'Live'),
(851, 271, 'Serial_Product', 'SPECTREX36014C567893', 1, 4, 1, 1, 'Live'),
(852, 271, 'Serial_Product', 'SPECTREX36014C567892', 1, 4, 1, 1, 'Live'),
(853, 271, 'Serial_Product', 'SPECTREX36014C567891', 1, 4, 1, 1, 'Live'),
(854, 271, 'Serial_Product', 'SPECTREX36014C567890', 1, 4, 1, 1, 'Live'),
(855, 272, 'Serial_Product', 'ENVY13D2345685', 1, 5, 1, 1, 'Live'),
(856, 272, 'Serial_Product', 'ENVY13D2345684', 1, 5, 1, 1, 'Live'),
(857, 272, 'Serial_Product', 'ENVY13D2345683', 1, 5, 1, 1, 'Live');
INSERT INTO `tbl_set_opening_stocks` (`id`, `item_id`, `item_type`, `item_description`, `stock_quantity`, `outlet_id`, `user_id`, `company_id`, `del_status`) VALUES
(858, 272, 'Serial_Product', 'ENVY13D2345682', 1, 5, 1, 1, 'Live'),
(859, 272, 'Serial_Product', 'ENVY13D2345681', 1, 4, 1, 1, 'Live'),
(860, 272, 'Serial_Product', 'ENVY13D2345680', 1, 4, 1, 1, 'Live'),
(861, 272, 'Serial_Product', 'ENVY13D2345679', 1, 4, 1, 1, 'Live'),
(862, 272, 'Serial_Product', 'ENVY13D2345678', 1, 4, 1, 1, 'Live'),
(863, 273, 'Serial_Product', 'XPS15E8765439', 1, 5, 1, 1, 'Live'),
(864, 273, 'Serial_Product', 'XPS15E8765438', 1, 5, 1, 1, 'Live'),
(865, 273, 'Serial_Product', 'XPS15E8765437', 1, 5, 1, 1, 'Live'),
(866, 273, 'Serial_Product', 'XPS15E8765436', 1, 5, 1, 1, 'Live'),
(867, 273, 'Serial_Product', 'XPS15E8765435', 1, 4, 1, 1, 'Live'),
(868, 273, 'Serial_Product', 'XPS15E8765434', 1, 4, 1, 1, 'Live'),
(869, 273, 'Serial_Product', 'XPS15E8765433', 1, 4, 1, 1, 'Live'),
(870, 273, 'Serial_Product', 'XPS15E8765432', 1, 4, 1, 1, 'Live'),
(871, 274, 'Serial_Product', 'INSP1445F345685', 1, 5, 1, 1, 'Live'),
(872, 274, 'Serial_Product', 'INSP1445F345684', 1, 5, 1, 1, 'Live'),
(873, 274, 'Serial_Product', 'INSP1445F345683', 1, 5, 1, 1, 'Live'),
(874, 274, 'Serial_Product', 'INSP1445F345682', 1, 5, 1, 1, 'Live'),
(875, 274, 'Serial_Product', 'INSP1445F345681', 1, 4, 1, 1, 'Live'),
(876, 274, 'Serial_Product', 'INSP1445F345680', 1, 4, 1, 1, 'Live'),
(877, 274, 'Serial_Product', 'INSP1445F345679', 1, 4, 1, 1, 'Live'),
(878, 274, 'Serial_Product', 'INSP1445F345678', 1, 4, 1, 1, 'Live'),
(879, 275, 'Serial_Product', 'GBOOKPRO360G123463', 1, 5, 1, 1, 'Live'),
(880, 275, 'Serial_Product', 'GBOOKPRO360G123462', 1, 5, 1, 1, 'Live'),
(881, 275, 'Serial_Product', 'GBOOKPRO360G123461', 1, 5, 1, 1, 'Live'),
(882, 275, 'Serial_Product', 'GBOOKPRO360G123460', 1, 5, 1, 1, 'Live'),
(883, 275, 'Serial_Product', 'GBOOKPRO360G123459', 1, 4, 1, 1, 'Live'),
(884, 275, 'Serial_Product', 'GBOOKPRO360G123458', 1, 4, 1, 1, 'Live'),
(885, 275, 'Serial_Product', 'GBOOKPRO360G123457', 1, 4, 1, 1, 'Live'),
(886, 275, 'Serial_Product', 'GBOOKPRO360G123456', 1, 4, 1, 1, 'Live'),
(887, 276, 'Serial_Product', 'NBK9PROH987661', 1, 5, 1, 1, 'Live'),
(888, 276, 'Serial_Product', 'NBK9PROH987660', 1, 5, 1, 1, 'Live'),
(889, 276, 'Serial_Product', 'NBK9PROH987659', 1, 5, 1, 1, 'Live'),
(890, 276, 'Serial_Product', 'NBK9PROH987658', 1, 5, 1, 1, 'Live'),
(891, 276, 'Serial_Product', 'NBK9PROH987657', 1, 4, 1, 1, 'Live'),
(892, 276, 'Serial_Product', 'NBK9PROH987656', 1, 4, 1, 1, 'Live'),
(893, 276, 'Serial_Product', 'NBK9PROH987655', 1, 4, 1, 1, 'Live'),
(894, 276, 'Serial_Product', 'NBK9PROH987654', 1, 4, 1, 1, 'Live'),
(895, 277, 'Serial_Product', 'APPM1CPU12345685', 1, 5, 1, 1, 'Live'),
(896, 277, 'Serial_Product', 'APPM1CPU12345684', 1, 5, 1, 1, 'Live'),
(897, 277, 'Serial_Product', 'APPM1CPU12345683', 1, 5, 1, 1, 'Live'),
(898, 277, 'Serial_Product', 'APPM1CPU12345682', 1, 5, 1, 1, 'Live'),
(899, 277, 'Serial_Product', 'APPM1CPU12345681', 1, 4, 1, 1, 'Live'),
(900, 277, 'Serial_Product', 'APPM1CPU12345680', 1, 4, 1, 1, 'Live'),
(901, 277, 'Serial_Product', 'APPM1CPU12345679', 1, 4, 1, 1, 'Live'),
(902, 277, 'Serial_Product', 'APPM1CPU12345678', 1, 4, 1, 1, 'Live'),
(903, 278, 'Serial_Product', 'APPM1PRO87654328', 1, 5, 1, 1, 'Live'),
(904, 278, 'Serial_Product', 'APPM1PRO87654327', 1, 5, 1, 1, 'Live'),
(905, 278, 'Serial_Product', 'APPM1PRO87654326', 1, 5, 1, 1, 'Live'),
(906, 278, 'Serial_Product', 'APPM1PRO87654325', 1, 5, 1, 1, 'Live'),
(907, 278, 'Serial_Product', 'APPM1PRO87654324', 1, 4, 1, 1, 'Live'),
(908, 278, 'Serial_Product', 'APPM1PRO87654323', 1, 4, 1, 1, 'Live'),
(909, 278, 'Serial_Product', 'APPM1PRO87654322', 1, 4, 1, 1, 'Live'),
(910, 278, 'Serial_Product', 'APPM1PRO87654321', 1, 4, 1, 1, 'Live'),
(911, 279, 'Serial_Product', 'HPR54600H12345678', 1, 5, 1, 1, 'Live'),
(912, 279, 'Serial_Product', 'HPR54600H12345677', 1, 5, 1, 1, 'Live'),
(913, 279, 'Serial_Product', 'HPR54600H12345676', 1, 5, 1, 1, 'Live'),
(914, 279, 'Serial_Product', 'HPR54600H12345675', 1, 5, 1, 1, 'Live'),
(915, 279, 'Serial_Product', 'HPR54600H12345674', 1, 4, 1, 1, 'Live'),
(916, 279, 'Serial_Product', 'HPR54600H12345673', 1, 4, 1, 1, 'Live'),
(917, 279, 'Serial_Product', 'HPR54600H12345672', 1, 4, 1, 1, 'Live'),
(918, 279, 'Serial_Product', 'HPR54600H12345671', 1, 4, 1, 1, 'Live'),
(919, 280, 'Serial_Product', 'HPCI710750H87654328', 1, 5, 1, 1, 'Live'),
(920, 280, 'Serial_Product', 'HPCI710750H87654327', 1, 5, 1, 1, 'Live'),
(921, 280, 'Serial_Product', 'HPCI710750H87654326', 1, 5, 1, 1, 'Live'),
(922, 280, 'Serial_Product', 'HPCI710750H87654325', 1, 5, 1, 1, 'Live'),
(923, 280, 'Serial_Product', 'HPCI710750H87654324', 1, 4, 1, 1, 'Live'),
(924, 280, 'Serial_Product', 'HPCI710750H87654323', 1, 4, 1, 1, 'Live'),
(925, 280, 'Serial_Product', 'HPCI710750H87654322', 1, 4, 1, 1, 'Live'),
(926, 280, 'Serial_Product', 'HPCI710750H87654321', 1, 4, 1, 1, 'Live'),
(927, 281, 'Serial_Product', 'DELLCI51040012345678', 1, 5, 1, 1, 'Live'),
(928, 281, 'Serial_Product', 'DELLCI51040012345677', 1, 5, 1, 1, 'Live'),
(929, 281, 'Serial_Product', 'DELLCI51040012345676', 1, 5, 1, 1, 'Live'),
(930, 281, 'Serial_Product', 'DELLCI51040012345675', 1, 5, 1, 1, 'Live'),
(931, 281, 'Serial_Product', 'DELLCI51040012345674', 1, 4, 1, 1, 'Live'),
(932, 281, 'Serial_Product', 'DELLCI51040012345673', 1, 4, 1, 1, 'Live'),
(933, 281, 'Serial_Product', 'DELLCI51040012345672', 1, 4, 1, 1, 'Live'),
(934, 281, 'Serial_Product', 'DELLCI51040012345671', 1, 4, 1, 1, 'Live'),
(935, 282, 'Serial_Product', 'DELLCI910900K87654328', 1, 5, 1, 1, 'Live'),
(936, 282, 'Serial_Product', 'DELLCI910900K87654327', 1, 5, 1, 1, 'Live'),
(937, 282, 'Serial_Product', 'DELLCI910900K87654326', 1, 5, 1, 1, 'Live'),
(938, 282, 'Serial_Product', 'DELLCI910900K87654325', 1, 5, 1, 1, 'Live'),
(939, 282, 'Serial_Product', 'DELLCI910900K87654324', 1, 4, 1, 1, 'Live'),
(940, 282, 'Serial_Product', 'DELLCI910900K87654323', 1, 4, 1, 1, 'Live'),
(941, 282, 'Serial_Product', 'DELLCI910900K87654322', 1, 4, 1, 1, 'Live'),
(942, 282, 'Serial_Product', 'DELLCI910900K87654321', 1, 4, 1, 1, 'Live'),
(943, 283, 'Serial_Product', 'SAMEX210012345678', 1, 5, 1, 1, 'Live'),
(944, 283, 'Serial_Product', 'SAMEX210012345677', 1, 5, 1, 1, 'Live'),
(945, 283, 'Serial_Product', 'SAMEX210012345676', 1, 5, 1, 1, 'Live'),
(946, 283, 'Serial_Product', 'SAMEX210012345675', 1, 5, 1, 1, 'Live'),
(947, 283, 'Serial_Product', 'SAMEX210012345674', 1, 4, 1, 1, 'Live'),
(948, 283, 'Serial_Product', 'SAMEX210012345673', 1, 4, 1, 1, 'Live'),
(949, 283, 'Serial_Product', 'SAMEX210012345672', 1, 4, 1, 1, 'Live'),
(950, 283, 'Serial_Product', 'SAMEX210012345671', 1, 4, 1, 1, 'Live'),
(951, 284, 'Serial_Product', 'SAMEX99087654328', 1, 5, 1, 1, 'Live'),
(952, 284, 'Serial_Product', 'SAMEX99087654327', 1, 5, 1, 1, 'Live'),
(953, 284, 'Serial_Product', 'SAMEX99087654326', 1, 5, 1, 1, 'Live'),
(954, 284, 'Serial_Product', 'SAMEX99087654325', 1, 5, 1, 1, 'Live'),
(955, 284, 'Serial_Product', 'SAMEX99087654324', 1, 4, 1, 1, 'Live'),
(956, 284, 'Serial_Product', 'SAMEX99087654323', 1, 4, 1, 1, 'Live'),
(957, 284, 'Serial_Product', 'SAMEX99087654322', 1, 4, 1, 1, 'Live'),
(958, 284, 'Serial_Product', 'SAMEX99087654321', 1, 4, 1, 1, 'Live'),
(959, 285, 'Serial_Product', 'APPRAM8GB26661241', 1, 5, 1, 1, 'Live'),
(960, 285, 'Serial_Product', 'APPRAM8GB26661240', 1, 5, 1, 1, 'Live'),
(961, 285, 'Serial_Product', 'APPRAM8GB26661239', 1, 5, 1, 1, 'Live'),
(962, 285, 'Serial_Product', 'APPRAM8GB26661238', 1, 5, 1, 1, 'Live'),
(963, 285, 'Serial_Product', 'APPRAM8GB26661237', 1, 4, 1, 1, 'Live'),
(964, 285, 'Serial_Product', 'APPRAM8GB26661236', 1, 4, 1, 1, 'Live'),
(965, 285, 'Serial_Product', 'APPRAM8GB26661235', 1, 4, 1, 1, 'Live'),
(966, 285, 'Serial_Product', 'APPRAM8GB26661234', 1, 4, 1, 1, 'Live'),
(967, 286, 'Serial_Product', 'APPRAM16GB32008768', 1, 5, 1, 1, 'Live'),
(968, 286, 'Serial_Product', 'APPRAM16GB32008767', 1, 5, 1, 1, 'Live'),
(969, 286, 'Serial_Product', 'APPRAM16GB32008766', 1, 5, 1, 1, 'Live'),
(970, 286, 'Serial_Product', 'APPRAM16GB32008765', 1, 5, 1, 1, 'Live'),
(971, 286, 'Serial_Product', 'APPRAM16GB32008764', 1, 4, 1, 1, 'Live'),
(972, 286, 'Serial_Product', 'APPRAM16GB32008763', 1, 4, 1, 1, 'Live'),
(973, 286, 'Serial_Product', 'APPRAM16GB32008762', 1, 4, 1, 1, 'Live'),
(974, 286, 'Serial_Product', 'APPRAM16GB32008761', 1, 4, 1, 1, 'Live'),
(975, 287, 'Serial_Product', 'HPRAM8GB24005678', 1, 5, 1, 1, 'Live'),
(976, 287, 'Serial_Product', 'HPRAM8GB24005677', 1, 5, 1, 1, 'Live'),
(977, 287, 'Serial_Product', 'HPRAM8GB24005676', 1, 5, 1, 1, 'Live'),
(978, 287, 'Serial_Product', 'HPRAM8GB24005675', 1, 5, 1, 1, 'Live'),
(979, 287, 'Serial_Product', 'HPRAM8GB24005674', 1, 4, 1, 1, 'Live'),
(980, 287, 'Serial_Product', 'HPRAM8GB24005673', 1, 4, 1, 1, 'Live'),
(981, 287, 'Serial_Product', 'HPRAM8GB24005672', 1, 4, 1, 1, 'Live'),
(982, 287, 'Serial_Product', 'HPRAM8GB24005671', 1, 4, 1, 1, 'Live'),
(983, 288, 'Serial_Product', 'HPRAM16GB266643218', 1, 5, 1, 1, 'Live'),
(984, 288, 'Serial_Product', 'HPRAM16GB26664327', 1, 5, 1, 1, 'Live'),
(985, 288, 'Serial_Product', 'HPRAM16GB26664326', 1, 5, 1, 1, 'Live'),
(986, 288, 'Serial_Product', 'HPRAM16GB26664325', 1, 5, 1, 1, 'Live'),
(987, 288, 'Serial_Product', 'HPRAM16GB26664324', 1, 4, 1, 1, 'Live'),
(988, 288, 'Serial_Product', 'HPRAM16GB26664323', 1, 4, 1, 1, 'Live'),
(989, 288, 'Serial_Product', 'HPRAM16GB26664322', 1, 4, 1, 1, 'Live'),
(990, 288, 'Serial_Product', 'HPRAM16GB26664321', 1, 4, 1, 1, 'Live'),
(991, 289, 'Serial_Product', 'DELLRAM8GB21337897', 1, 5, 1, 1, 'Live'),
(992, 289, 'Serial_Product', 'DELLRAM8GB21337896', 1, 5, 1, 1, 'Live'),
(993, 289, 'Serial_Product', 'DELLRAM8GB21337895', 1, 5, 1, 1, 'Live'),
(994, 289, 'Serial_Product', 'DELLRAM8GB21337894', 1, 5, 1, 1, 'Live'),
(995, 289, 'Serial_Product', 'DELLRAM8GB2133783', 1, 4, 1, 1, 'Live'),
(996, 289, 'Serial_Product', 'DELLRAM8GB21337892', 1, 4, 1, 1, 'Live'),
(997, 289, 'Serial_Product', 'DELLRAM8GB21337891', 1, 4, 1, 1, 'Live'),
(998, 289, 'Serial_Product', 'DELLRAM8GB21337890', 1, 4, 1, 1, 'Live'),
(999, 290, 'Serial_Product', 'DELLRAM16GB24009878', 1, 5, 1, 1, 'Live'),
(1000, 290, 'Serial_Product', 'DELLRAM16GB24009877', 1, 5, 1, 1, 'Live'),
(1001, 290, 'Serial_Product', 'DELLRAM16GB24009876', 1, 5, 1, 1, 'Live'),
(1002, 290, 'Serial_Product', 'DELLRAM16GB24009875', 1, 5, 1, 1, 'Live'),
(1003, 290, 'Serial_Product', 'DELLRAM16GB24009874', 1, 4, 1, 1, 'Live'),
(1004, 290, 'Serial_Product', 'DELLRAM16GB24009873', 1, 4, 1, 1, 'Live'),
(1005, 290, 'Serial_Product', 'DELLRAM16GB24009872', 1, 4, 1, 1, 'Live'),
(1006, 290, 'Serial_Product', 'DELLRAM16GB24009871', 1, 4, 1, 1, 'Live'),
(1007, 291, 'Serial_Product', 'SAMRAM8GB32005438', 1, 5, 1, 1, 'Live'),
(1008, 291, 'Serial_Product', 'SAMRAM8GB32005437', 1, 5, 1, 1, 'Live'),
(1009, 291, 'Serial_Product', 'SAMRAM8GB32005436', 1, 5, 1, 1, 'Live'),
(1010, 291, 'Serial_Product', 'SAMRAM8GB32005439', 1, 5, 1, 1, 'Live'),
(1011, 291, 'Serial_Product', 'SAMRAM8GB32005435', 1, 4, 1, 1, 'Live'),
(1012, 291, 'Serial_Product', 'SAMRAM8GB32005434', 1, 4, 1, 1, 'Live'),
(1013, 291, 'Serial_Product', 'SAMRAM8GB32005433', 1, 4, 1, 1, 'Live'),
(1014, 291, 'Serial_Product', 'SAMRAM8GB32005432', 1, 4, 1, 1, 'Live'),
(1015, 292, 'Serial_Product', 'SAMRAM16GB36001241', 1, 5, 1, 1, 'Live'),
(1016, 292, 'Serial_Product', 'SAMRAM16GB36001240', 1, 5, 1, 1, 'Live'),
(1017, 292, 'Serial_Product', 'SAMRAM16GB36001239', 1, 5, 1, 1, 'Live'),
(1018, 292, 'Serial_Product', 'SAMRAM16GB36001238', 1, 5, 1, 1, 'Live'),
(1019, 292, 'Serial_Product', 'SAMRAM16GB36001237', 1, 4, 1, 1, 'Live'),
(1020, 292, 'Serial_Product', 'SAMRAM16GB36001236', 1, 4, 1, 1, 'Live'),
(1021, 292, 'Serial_Product', 'SAMRAM16GB36001235', 1, 4, 1, 1, 'Live'),
(1022, 292, 'Serial_Product', 'SAMRAM16GB36001234', 1, 4, 1, 1, 'Live'),
(1023, 293, 'Serial_Product', 'INM89065453146', 1, 5, 1, 1, 'Live'),
(1024, 293, 'Serial_Product', 'INM89065453145', 1, 5, 1, 1, 'Live'),
(1025, 293, 'Serial_Product', 'INM89065453144', 1, 4, 1, 1, 'Live'),
(1026, 293, 'Serial_Product', 'INM89065453143', 1, 4, 1, 1, 'Live'),
(1027, 294, 'Serial_Product', 'DELLU2422HE123463', 1, 5, 1, 1, 'Live'),
(1028, 294, 'Serial_Product', 'DELLU2422HE123462', 1, 5, 1, 1, 'Live'),
(1029, 294, 'Serial_Product', 'DELLU2422HE123461', 1, 5, 1, 1, 'Live'),
(1030, 294, 'Serial_Product', 'DELLU2422HE123460', 1, 5, 1, 1, 'Live'),
(1031, 294, 'Serial_Product', 'DELLU2422HE123459', 1, 4, 1, 1, 'Live'),
(1032, 294, 'Serial_Product', 'DELLU2422HE123458', 1, 4, 1, 1, 'Live'),
(1033, 294, 'Serial_Product', 'DELLU2422HE123457', 1, 4, 1, 1, 'Live'),
(1034, 294, 'Serial_Product', 'DELLU2422HE123456', 1, 4, 1, 1, 'Live');

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

--
-- Stand-in structure for view `tbl_stock_detail`
-- (See below for the actual view)
--
CREATE TABLE `tbl_stock_detail` (
`item_id` int(11)
,`item_type` varchar(55)
,`expiry_imei_serial` varchar(255)
,`stock_quantity` varchar(23)
,`outlet_id` int(11)
,`type` int(1)
,`description` varchar(18)
);

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

--
-- Stand-in structure for view `tbl_stock_detail2`
-- (See below for the actual view)
--
CREATE TABLE `tbl_stock_detail2` (
`item_id` int(11)
,`item_type` varchar(55)
,`expiry_imei_serial` varchar(255)
,`stock_quantity` varchar(34)
,`outlet_id` int(11)
,`type` int(1)
,`description` varchar(18)
);

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

--
-- Table structure for table `tbl_suppliers`
--

CREATE TABLE `tbl_suppliers` (
  `id` int(11) NOT NULL,
  `name` varchar(55) DEFAULT NULL,
  `contact_person` varchar(55) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `email` varchar(55) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `opening_balance` int(11) DEFAULT 0,
  `opening_balance_type` varchar(11) DEFAULT 'Credit',
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_suppliers`
--

INSERT INTO `tbl_suppliers` (`id`, `name`, `contact_person`, `phone`, `email`, `address`, `description`, `opening_balance`, `opening_balance_type`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(3, 'Easy', 'Mr.Alex', '9233343471', '', '', '', 0, 'Debit', '2024-05-21 14:38:05', 1, 1, 'Delete'),
(4, 'Gentle Park', 'Mr.Gousif', '0987654743', '', '', '', 0, 'Debit', '2024-05-21 15:04:02', 1, 1, 'Delete'),
(5, 'Le Reve', 'Mr.Lumen', '0978368365', '', '', '', 0, 'Debit', '2024-05-21 15:21:09', 1, 1, 'Delete'),
(6, 'Arong', 'Mr.Adam', '89364234698', '', '', '', 0, 'Debit', '2024-05-21 15:41:44', 1, 1, 'Delete'),
(7, 'Apple', 'Mr.Antoni', '0945847597494', '', '', '', 0, 'Debit', '2024-05-23 12:53:21', 1, 1, 'Live'),
(8, 'Samsung', 'Mr.Simon', '8473496553459', '', '', '', 0, 'Debit', '2024-05-23 13:08:49', 1, 1, 'Live'),
(9, 'Huawei', 'Mr.Henry', '3456745634452', '', '', '', 0, 'Debit', '2024-05-23 13:16:53', 1, 1, 'Delete'),
(10, 'LG', 'Mr.Leo', '87386387383', '', '', '', 0, 'Debit', '2024-05-23 13:28:11', 1, 1, 'Live'),
(11, 'Sony', 'Mr.Simon', '3242356568756', '', '', '', 0, 'Debit', '2024-05-23 14:20:53', 1, 1, 'Live'),
(12, 'TP Link', 'Mr.Tom', '0987657987', '', '', '', 0, 'Debit', '2024-05-23 16:07:59', 1, 1, 'Delete'),
(13, 'D Link', 'Mr.Donald', '9787557886545', '', '', '', 0, 'Debit', '2024-05-23 16:15:53', 1, 1, 'Delete'),
(14, 'Tenda', 'Mr.Thomas', '098374834783', '', '', '', 0, 'Debit', '2024-05-23 16:21:43', 1, 1, 'Delete'),
(15, 'Asus', 'Mr.Antony', '456423785674', '', '', '', 0, 'Debit', '2024-05-23 16:30:18', 1, 1, 'Delete'),
(16, 'Mircosoft', 'Mr.Moon', '09757856734', '', '', '', 0, 'Debit', '2024-05-23 16:50:55', 1, 1, 'Delete'),
(17, 'HP', 'Mr.Head', '9878654467', '', '', '', 0, 'Debit', '2024-05-23 17:03:02', 1, 1, 'Live'),
(18, 'Lenovo', 'Mr.Latham', '0983736483', '', '', '', 0, 'Debit', '2024-05-23 17:13:31', 1, 1, 'Delete'),
(19, 'Dell', 'Mr.Dheman', '09878765467', '', '', '', 0, 'Debit', '2024-05-23 17:22:18', 1, 1, 'Live'),
(20, 'Penasonic', 'Mr.Petter', '098767577565', '', '', '', 0, 'Debit', '2024-05-25 14:20:28', 1, 1, 'Live');

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

--
-- Table structure for table `tbl_supplier_payments`
--

CREATE TABLE `tbl_supplier_payments` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(55) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `payment_method_id` int(11) NOT NULL DEFAULT 1,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `tbl_time_zone`
--

CREATE TABLE `tbl_time_zone` (
  `id` int(11) NOT NULL,
  `country_code` varchar(25) CHARACTER SET utf32 COLLATE utf32_general_ci DEFAULT NULL,
  `zone_name` varchar(55) CHARACTER SET utf32 COLLATE utf32_general_ci DEFAULT NULL,
  `del_status` varchar(11) CHARACTER SET utf32 COLLATE utf32_general_ci DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_time_zone`
--

INSERT INTO `tbl_time_zone` (`id`, `country_code`, `zone_name`, `del_status`) VALUES
(1, 'AD', 'Europe/Andorra', 'Live'),
(2, 'AE', 'Asia/Dubai', 'Live'),
(3, 'AF', 'Asia/Kabul', 'Live'),
(4, 'AG', 'America/Antigua', 'Live'),
(5, 'AI', 'America/Anguilla', 'Live'),
(6, 'AL', 'Europe/Tirane', 'Live'),
(7, 'AM', 'Asia/Yerevan', 'Live'),
(8, 'AO', 'Africa/Luanda', 'Live'),
(9, 'AQ', 'Antarctica/McMurdo', 'Live'),
(10, 'AQ', 'Antarctica/Casey', 'Live'),
(11, 'AQ', 'Antarctica/Davis', 'Live'),
(12, 'AQ', 'Antarctica/DumontDUrville', 'Live'),
(13, 'AQ', 'Antarctica/Mawson', 'Live'),
(14, 'AQ', 'Antarctica/Palmer', 'Live'),
(15, 'AQ', 'Antarctica/Rothera', 'Live'),
(16, 'AQ', 'Antarctica/Syowa', 'Live'),
(17, 'AQ', 'Antarctica/Troll', 'Live'),
(18, 'AQ', 'Antarctica/Vostok', 'Live'),
(19, 'AR', 'America/Argentina/Buenos_Aires', 'Live'),
(20, 'AR', 'America/Argentina/Cordoba', 'Live'),
(21, 'AR', 'America/Argentina/Salta', 'Live'),
(22, 'AR', 'America/Argentina/Jujuy', 'Live'),
(23, 'AR', 'America/Argentina/Tucuman', 'Live'),
(24, 'AR', 'America/Argentina/Catamarca', 'Live'),
(25, 'AR', 'America/Argentina/La_Rioja', 'Live'),
(26, 'AR', 'America/Argentina/San_Juan', 'Live'),
(27, 'AR', 'America/Argentina/Mendoza', 'Live'),
(28, 'AR', 'America/Argentina/San_Luis', 'Live'),
(29, 'AR', 'America/Argentina/Rio_Gallegos', 'Live'),
(30, 'AR', 'America/Argentina/Ushuaia', 'Live'),
(31, 'AS', 'Pacific/Pago_Pago', 'Live'),
(32, 'AT', 'Europe/Vienna', 'Live'),
(33, 'AU', 'Australia/Lord_Howe', 'Live'),
(34, 'AU', 'Antarctica/Macquarie', 'Live'),
(35, 'AU', 'Australia/Hobart', 'Live'),
(36, 'AU', 'Australia/Currie', 'Live'),
(37, 'AU', 'Australia/Melbourne', 'Live'),
(38, 'AU', 'Australia/Sydney', 'Live'),
(39, 'AU', 'Australia/Broken_Hill', 'Live'),
(40, 'AU', 'Australia/Brisbane', 'Live'),
(41, 'AU', 'Australia/Lindeman', 'Live'),
(42, 'AU', 'Australia/Adelaide', 'Live'),
(43, 'AU', 'Australia/Darwin', 'Live'),
(44, 'AU', 'Australia/Perth', 'Live'),
(45, 'AU', 'Australia/Eucla', 'Live'),
(46, 'AW', 'America/Aruba', 'Live'),
(47, 'AX', 'Europe/Mariehamn', 'Live'),
(48, 'AZ', 'Asia/Baku', 'Live'),
(49, 'BA', 'Europe/Sarajevo', 'Live'),
(50, 'BB', 'America/Barbados', 'Live'),
(51, 'BD', 'Asia/Dhaka', 'Live'),
(52, 'BE', 'Europe/Brussels', 'Live'),
(53, 'BF', 'Africa/Ouagadougou', 'Live'),
(54, 'BG', 'Europe/Sofia', 'Live'),
(55, 'BH', 'Asia/Bahrain', 'Live'),
(56, 'BI', 'Africa/Bujumbura', 'Live'),
(57, 'BJ', 'Africa/Porto-Novo', 'Live'),
(58, 'BL', 'America/St_Barthelemy', 'Live'),
(59, 'BM', 'Atlantic/Bermuda', 'Live'),
(60, 'BN', 'Asia/Brunei', 'Live'),
(61, 'BO', 'America/La_Paz', 'Live'),
(62, 'BQ', 'America/Kralendijk', 'Live'),
(63, 'BR', 'America/Noronha', 'Live'),
(64, 'BR', 'America/Belem', 'Live'),
(65, 'BR', 'America/Fortaleza', 'Live'),
(66, 'BR', 'America/Recife', 'Live'),
(67, 'BR', 'America/Araguaina', 'Live'),
(68, 'BR', 'America/Maceio', 'Live'),
(69, 'BR', 'America/Bahia', 'Live'),
(70, 'BR', 'America/Sao_Paulo', 'Live'),
(71, 'BR', 'America/Campo_Grande', 'Live'),
(72, 'BR', 'America/Cuiaba', 'Live'),
(73, 'BR', 'America/Santarem', 'Live'),
(74, 'BR', 'America/Porto_Velho', 'Live'),
(75, 'BR', 'America/Boa_Vista', 'Live'),
(76, 'BR', 'America/Manaus', 'Live'),
(77, 'BR', 'America/Eirunepe', 'Live'),
(78, 'BR', 'America/Rio_Branco', 'Live'),
(79, 'BS', 'America/Nassau', 'Live'),
(80, 'BT', 'Asia/Thimphu', 'Live'),
(81, 'BW', 'Africa/Gaborone', 'Live'),
(82, 'BY', 'Europe/Minsk', 'Live'),
(83, 'BZ', 'America/Belize', 'Live'),
(84, 'CA', 'America/St_Johns', 'Live'),
(85, 'CA', 'America/Halifax', 'Live'),
(86, 'CA', 'America/Glace_Bay', 'Live'),
(87, 'CA', 'America/Moncton', 'Live'),
(88, 'CA', 'America/Goose_Bay', 'Live'),
(89, 'CA', 'America/Blanc-Sablon', 'Live'),
(90, 'CA', 'America/Toronto', 'Live'),
(91, 'CA', 'America/Nipigon', 'Live'),
(92, 'CA', 'America/Thunder_Bay', 'Live'),
(93, 'CA', 'America/Iqaluit', 'Live'),
(94, 'CA', 'America/Pangnirtung', 'Live'),
(95, 'CA', 'America/Atikokan', 'Live'),
(96, 'CA', 'America/Winnipeg', 'Live'),
(97, 'CA', 'America/Rainy_River', 'Live'),
(98, 'CA', 'America/Resolute', 'Live'),
(99, 'CA', 'America/Rankin_Inlet', 'Live'),
(100, 'CA', 'America/Regina', 'Live'),
(101, 'CA', 'America/Swift_Current', 'Live'),
(102, 'CA', 'America/Edmonton', 'Live'),
(103, 'CA', 'America/Cambridge_Bay', 'Live'),
(104, 'CA', 'America/Yellowknife', 'Live'),
(105, 'CA', 'America/Inuvik', 'Live'),
(106, 'CA', 'America/Creston', 'Live'),
(107, 'CA', 'America/Dawson_Creek', 'Live'),
(108, 'CA', 'America/Fort_Nelson', 'Live'),
(109, 'CA', 'America/Vancouver', 'Live'),
(110, 'CA', 'America/Whitehorse', 'Live'),
(111, 'CA', 'America/Dawson', 'Live'),
(112, 'CC', 'Indian/Cocos', 'Live'),
(113, 'CD', 'Africa/Kinshasa', 'Live'),
(114, 'CD', 'Africa/Lubumbashi', 'Live'),
(115, 'CF', 'Africa/Bangui', 'Live'),
(116, 'CG', 'Africa/Brazzaville', 'Live'),
(117, 'CH', 'Europe/Zurich', 'Live'),
(118, 'CI', 'Africa/Abidjan', 'Live'),
(119, 'CK', 'Pacific/Rarotonga', 'Live'),
(120, 'CL', 'America/Santiago', 'Live'),
(121, 'CL', 'America/Punta_Arenas', 'Live'),
(122, 'CL', 'Pacific/Easter', 'Live'),
(123, 'CM', 'Africa/Douala', 'Live'),
(124, 'CN', 'Asia/Shanghai', 'Live'),
(125, 'CN', 'Asia/Urumqi', 'Live'),
(126, 'CO', 'America/Bogota', 'Live'),
(127, 'CR', 'America/Costa_Rica', 'Live'),
(128, 'CU', 'America/Havana', 'Live'),
(129, 'CV', 'Atlantic/Cape_Verde', 'Live'),
(130, 'CW', 'America/Curacao', 'Live'),
(131, 'CX', 'Indian/Christmas', 'Live'),
(132, 'CY', 'Asia/Nicosia', 'Live'),
(133, 'CY', 'Asia/Famagusta', 'Live'),
(134, 'CZ', 'Europe/Prague', 'Live'),
(135, 'DE', 'Europe/Berlin', 'Live'),
(136, 'DE', 'Europe/Busingen', 'Live'),
(137, 'DJ', 'Africa/Djibouti', 'Live'),
(138, 'DK', 'Europe/Copenhagen', 'Live'),
(139, 'DM', 'America/Dominica', 'Live'),
(140, 'DO', 'America/Santo_Domingo', 'Live'),
(141, 'DZ', 'Africa/Algiers', 'Live'),
(142, 'EC', 'America/Guayaquil', 'Live'),
(143, 'EC', 'Pacific/Galapagos', 'Live'),
(144, 'EE', 'Europe/Tallinn', 'Live'),
(145, 'EG', 'Africa/Cairo', 'Live'),
(146, 'EH', 'Africa/El_Aaiun', 'Live'),
(147, 'ER', 'Africa/Asmara', 'Live'),
(148, 'ES', 'Europe/Madrid', 'Live'),
(149, 'ES', 'Africa/Ceuta', 'Live'),
(150, 'ES', 'Atlantic/Canary', 'Live'),
(151, 'ET', 'Africa/Addis_Ababa', 'Live'),
(152, 'FI', 'Europe/Helsinki', 'Live'),
(153, 'FJ', 'Pacific/Fiji', 'Live'),
(154, 'FK', 'Atlantic/Stanley', 'Live'),
(155, 'FM', 'Pacific/Chuuk', 'Live'),
(156, 'FM', 'Pacific/Pohnpei', 'Live'),
(157, 'FM', 'Pacific/Kosrae', 'Live'),
(158, 'FO', 'Atlantic/Faroe', 'Live'),
(159, 'FR', 'Europe/Paris', 'Live'),
(160, 'GA', 'Africa/Libreville', 'Live'),
(161, 'GB', 'Europe/London', 'Live'),
(162, 'GD', 'America/Grenada', 'Live'),
(163, 'GE', 'Asia/Tbilisi', 'Live'),
(164, 'GF', 'America/Cayenne', 'Live'),
(165, 'GG', 'Europe/Guernsey', 'Live'),
(166, 'GH', 'Africa/Accra', 'Live'),
(167, 'GI', 'Europe/Gibraltar', 'Live'),
(168, 'GL', 'America/Godthab', 'Live'),
(169, 'GL', 'America/Danmarkshavn', 'Live'),
(170, 'GL', 'America/Scoresbysund', 'Live'),
(171, 'GL', 'America/Thule', 'Live'),
(172, 'GM', 'Africa/Banjul', 'Live'),
(173, 'GN', 'Africa/Conakry', 'Live'),
(174, 'GP', 'America/Guadeloupe', 'Live'),
(175, 'GQ', 'Africa/Malabo', 'Live'),
(176, 'GR', 'Europe/Athens', 'Live'),
(177, 'GS', 'Atlantic/South_Georgia', 'Live'),
(178, 'GT', 'America/Guatemala', 'Live'),
(179, 'GU', 'Pacific/Guam', 'Live'),
(180, 'GW', 'Africa/Bissau', 'Live'),
(181, 'GY', 'America/Guyana', 'Live'),
(182, 'HK', 'Asia/Hong_Kong', 'Live'),
(183, 'HN', 'America/Tegucigalpa', 'Live'),
(184, 'HR', 'Europe/Zagreb', 'Live'),
(185, 'HT', 'America/Port-au-Prince', 'Live'),
(186, 'HU', 'Europe/Budapest', 'Live'),
(187, 'ID', 'Asia/Jakarta', 'Live'),
(188, 'ID', 'Asia/Pontianak', 'Live'),
(189, 'ID', 'Asia/Makassar', 'Live'),
(190, 'ID', 'Asia/Jayapura', 'Live'),
(191, 'IE', 'Europe/Dublin', 'Live'),
(192, 'IL', 'Asia/Jerusalem', 'Live'),
(193, 'IM', 'Europe/Isle_of_Man', 'Live'),
(194, 'IN', 'Asia/Kolkata', 'Live'),
(195, 'IO', 'Indian/Chagos', 'Live'),
(196, 'IQ', 'Asia/Baghdad', 'Live'),
(197, 'IR', 'Asia/Tehran', 'Live'),
(198, 'IS', 'Atlantic/Reykjavik', 'Live'),
(199, 'IT', 'Europe/Rome', 'Live'),
(200, 'JE', 'Europe/Jersey', 'Live'),
(201, 'JM', 'America/Jamaica', 'Live'),
(202, 'JO', 'Asia/Amman', 'Live'),
(203, 'JP', 'Asia/Tokyo', 'Live'),
(204, 'KE', 'Africa/Nairobi', 'Live'),
(205, 'KG', 'Asia/Bishkek', 'Live'),
(206, 'KH', 'Asia/Phnom_Penh', 'Live'),
(207, 'KI', 'Pacific/Tarawa', 'Live'),
(208, 'KI', 'Pacific/Enderbury', 'Live'),
(209, 'KI', 'Pacific/Kiritimati', 'Live'),
(210, 'KM', 'Indian/Comoro', 'Live'),
(211, 'KN', 'America/St_Kitts', 'Live'),
(212, 'KP', 'Asia/Pyongyang', 'Live'),
(213, 'KR', 'Asia/Seoul', 'Live'),
(214, 'KW', 'Asia/Kuwait', 'Live'),
(215, 'KY', 'America/Cayman', 'Live'),
(216, 'KZ', 'Asia/Almaty', 'Live'),
(217, 'KZ', 'Asia/Qyzylorda', 'Live'),
(218, 'KZ', 'Asia/Aqtobe', 'Live'),
(219, 'KZ', 'Asia/Aqtau', 'Live'),
(220, 'KZ', 'Asia/Atyrau', 'Live'),
(221, 'KZ', 'Asia/Oral', 'Live'),
(222, 'LA', 'Asia/Vientiane', 'Live'),
(223, 'LB', 'Asia/Beirut', 'Live'),
(224, 'LC', 'America/St_Lucia', 'Live'),
(225, 'LI', 'Europe/Vaduz', 'Live'),
(226, 'LK', 'Asia/Colombo', 'Live'),
(227, 'LR', 'Africa/Monrovia', 'Live'),
(228, 'LS', 'Africa/Maseru', 'Live'),
(229, 'LT', 'Europe/Vilnius', 'Live'),
(230, 'LU', 'Europe/Luxembourg', 'Live'),
(231, 'LV', 'Europe/Riga', 'Live'),
(232, 'LY', 'Africa/Tripoli', 'Live'),
(233, 'MA', 'Africa/Casablanca', 'Live'),
(234, 'MC', 'Europe/Monaco', 'Live'),
(235, 'MD', 'Europe/Chisinau', 'Live'),
(236, 'ME', 'Europe/Podgorica', 'Live'),
(237, 'MF', 'America/Marigot', 'Live'),
(238, 'MG', 'Indian/Antananarivo', 'Live'),
(239, 'MH', 'Pacific/Majuro', 'Live'),
(240, 'MH', 'Pacific/Kwajalein', 'Live'),
(241, 'MK', 'Europe/Skopje', 'Live'),
(242, 'ML', 'Africa/Bamako', 'Live'),
(243, 'MM', 'Asia/Yangon', 'Live'),
(244, 'MN', 'Asia/Ulaanbaatar', 'Live'),
(245, 'MN', 'Asia/Hovd', 'Live'),
(246, 'MN', 'Asia/Choibalsan', 'Live'),
(247, 'MO', 'Asia/Macau', 'Live'),
(248, 'MP', 'Pacific/Saipan', 'Live'),
(249, 'MQ', 'America/Martinique', 'Live'),
(250, 'MR', 'Africa/Nouakchott', 'Live'),
(251, 'MS', 'America/Montserrat', 'Live'),
(252, 'MT', 'Europe/Malta', 'Live'),
(253, 'MU', 'Indian/Mauritius', 'Live'),
(254, 'MV', 'Indian/Maldives', 'Live'),
(255, 'MW', 'Africa/Blantyre', 'Live'),
(256, 'MX', 'America/Mexico_City', 'Live'),
(257, 'MX', 'America/Cancun', 'Live'),
(258, 'MX', 'America/Merida', 'Live'),
(259, 'MX', 'America/Monterrey', 'Live'),
(260, 'MX', 'America/Matamoros', 'Live'),
(261, 'MX', 'America/Mazatlan', 'Live'),
(262, 'MX', 'America/Chihuahua', 'Live'),
(263, 'MX', 'America/Ojinaga', 'Live'),
(264, 'MX', 'America/Hermosillo', 'Live'),
(265, 'MX', 'America/Tijuana', 'Live'),
(266, 'MX', 'America/Bahia_Banderas', 'Live'),
(267, 'MY', 'Asia/Kuala_Lumpur', 'Live'),
(268, 'MY', 'Asia/Kuching', 'Live'),
(269, 'MZ', 'Africa/Maputo', 'Live'),
(270, 'NA', 'Africa/Windhoek', 'Live'),
(271, 'NC', 'Pacific/Noumea', 'Live'),
(272, 'NE', 'Africa/Niamey', 'Live'),
(273, 'NF', 'Pacific/Norfolk', 'Live'),
(274, 'NG', 'Africa/Lagos', 'Live'),
(275, 'NI', 'America/Managua', 'Live'),
(276, 'NL', 'Europe/Amsterdam', 'Live'),
(277, 'NO', 'Europe/Oslo', 'Live'),
(278, 'NP', 'Asia/Kathmandu', 'Live'),
(279, 'NR', 'Pacific/Nauru', 'Live'),
(280, 'NU', 'Pacific/Niue', 'Live'),
(281, 'NZ', 'Pacific/Auckland', 'Live'),
(282, 'NZ', 'Pacific/Chatham', 'Live'),
(283, 'OM', 'Asia/Muscat', 'Live'),
(284, 'PA', 'America/Panama', 'Live'),
(285, 'PE', 'America/Lima', 'Live'),
(286, 'PF', 'Pacific/Tahiti', 'Live'),
(287, 'PF', 'Pacific/Marquesas', 'Live'),
(288, 'PF', 'Pacific/Gambier', 'Live'),
(289, 'PG', 'Pacific/Port_Moresby', 'Live'),
(290, 'PG', 'Pacific/Bougainville', 'Live'),
(291, 'PH', 'Asia/Manila', 'Live'),
(292, 'PK', 'Asia/Karachi', 'Live'),
(293, 'PL', 'Europe/Warsaw', 'Live'),
(294, 'PM', 'America/Miquelon', 'Live'),
(295, 'PN', 'Pacific/Pitcairn', 'Live'),
(296, 'PR', 'America/Puerto_Rico', 'Live'),
(297, 'PS', 'Asia/Gaza', 'Live'),
(298, 'PS', 'Asia/Hebron', 'Live'),
(299, 'PT', 'Europe/Lisbon', 'Live'),
(300, 'PT', 'Atlantic/Madeira', 'Live'),
(301, 'PT', 'Atlantic/Azores', 'Live'),
(302, 'PW', 'Pacific/Palau', 'Live'),
(303, 'PY', 'America/Asuncion', 'Live'),
(304, 'QA', 'Asia/Qatar', 'Live'),
(305, 'RE', 'Indian/Reunion', 'Live'),
(306, 'RO', 'Europe/Bucharest', 'Live'),
(307, 'RS', 'Europe/Belgrade', 'Live'),
(308, 'RU', 'Europe/Kaliningrad', 'Live'),
(309, 'RU', 'Europe/Moscow', 'Live'),
(310, 'RU', 'Europe/Simferopol', 'Live'),
(311, 'RU', 'Europe/Volgograd', 'Live'),
(312, 'RU', 'Europe/Kirov', 'Live'),
(313, 'RU', 'Europe/Astrakhan', 'Live'),
(314, 'RU', 'Europe/Saratov', 'Live'),
(315, 'RU', 'Europe/Ulyanovsk', 'Live'),
(316, 'RU', 'Europe/Samara', 'Live'),
(317, 'RU', 'Asia/Yekaterinburg', 'Live'),
(318, 'RU', 'Asia/Omsk', 'Live'),
(319, 'RU', 'Asia/Novosibirsk', 'Live'),
(320, 'RU', 'Asia/Barnaul', 'Live'),
(321, 'RU', 'Asia/Tomsk', 'Live'),
(322, 'RU', 'Asia/Novokuznetsk', 'Live'),
(323, 'RU', 'Asia/Krasnoyarsk', 'Live'),
(324, 'RU', 'Asia/Irkutsk', 'Live'),
(325, 'RU', 'Asia/Chita', 'Live'),
(326, 'RU', 'Asia/Yakutsk', 'Live'),
(327, 'RU', 'Asia/Khandyga', 'Live'),
(328, 'RU', 'Asia/Vladivostok', 'Live'),
(329, 'RU', 'Asia/Ust-Nera', 'Live'),
(330, 'RU', 'Asia/Magadan', 'Live'),
(331, 'RU', 'Asia/Sakhalin', 'Live'),
(332, 'RU', 'Asia/Srednekolymsk', 'Live'),
(333, 'RU', 'Asia/Kamchatka', 'Live'),
(334, 'RU', 'Asia/Anadyr', 'Live'),
(335, 'RW', 'Africa/Kigali', 'Live'),
(336, 'SA', 'Asia/Riyadh', 'Live'),
(337, 'SB', 'Pacific/Guadalcanal', 'Live'),
(338, 'SC', 'Indian/Mahe', 'Live'),
(339, 'SD', 'Africa/Khartoum', 'Live'),
(340, 'SE', 'Europe/Stockholm', 'Live'),
(341, 'SG', 'Asia/Singapore', 'Live'),
(342, 'SH', 'Atlantic/St_Helena', 'Live'),
(343, 'SI', 'Europe/Ljubljana', 'Live'),
(344, 'SJ', 'Arctic/Longyearbyen', 'Live'),
(345, 'SK', 'Europe/Bratislava', 'Live'),
(346, 'SL', 'Africa/Freetown', 'Live'),
(347, 'SM', 'Europe/San_Marino', 'Live'),
(348, 'SN', 'Africa/Dakar', 'Live'),
(349, 'SO', 'Africa/Mogadishu', 'Live'),
(350, 'SR', 'America/Paramaribo', 'Live'),
(351, 'SS', 'Africa/Juba', 'Live'),
(352, 'ST', 'Africa/Sao_Tome', 'Live'),
(353, 'SV', 'America/El_Salvador', 'Live'),
(354, 'SX', 'America/Lower_Princes', 'Live'),
(355, 'SY', 'Asia/Damascus', 'Live'),
(356, 'SZ', 'Africa/Mbabane', 'Live'),
(357, 'TC', 'America/Grand_Turk', 'Live'),
(358, 'TD', 'Africa/Ndjamena', 'Live'),
(359, 'TF', 'Indian/Kerguelen', 'Live'),
(360, 'TG', 'Africa/Lome', 'Live'),
(361, 'TH', 'Asia/Bangkok', 'Live'),
(362, 'TJ', 'Asia/Dushanbe', 'Live'),
(363, 'TK', 'Pacific/Fakaofo', 'Live'),
(364, 'TL', 'Asia/Dili', 'Live'),
(365, 'TM', 'Asia/Ashgabat', 'Live'),
(366, 'TN', 'Africa/Tunis', 'Live'),
(367, 'TO', 'Pacific/Tongatapu', 'Live'),
(368, 'TR', 'Europe/Istanbul', 'Live'),
(369, 'TT', 'America/Port_of_Spain', 'Live'),
(370, 'TV', 'Pacific/Funafuti', 'Live'),
(371, 'TW', 'Asia/Taipei', 'Live'),
(372, 'TZ', 'Africa/Dar_es_Salaam', 'Live'),
(373, 'UA', 'Europe/Kiev', 'Live'),
(374, 'UA', 'Europe/Uzhgorod', 'Live'),
(375, 'UA', 'Europe/Zaporozhye', 'Live'),
(376, 'UG', 'Africa/Kampala', 'Live'),
(377, 'UM', 'Pacific/Midway', 'Live'),
(378, 'UM', 'Pacific/Wake', 'Live'),
(379, 'US', 'America/New_York', 'Live'),
(380, 'US', 'America/Detroit', 'Live'),
(381, 'US', 'America/Kentucky/Louisville', 'Live'),
(382, 'US', 'America/Kentucky/Monticello', 'Live'),
(383, 'US', 'America/Indiana/Indianapolis', 'Live'),
(384, 'US', 'America/Indiana/Vincennes', 'Live'),
(385, 'US', 'America/Indiana/Winamac', 'Live'),
(386, 'US', 'America/Indiana/Marengo', 'Live'),
(387, 'US', 'America/Indiana/Petersburg', 'Live'),
(388, 'US', 'America/Indiana/Vevay', 'Live'),
(389, 'US', 'America/Chicago', 'Live'),
(390, 'US', 'America/Indiana/Tell_City', 'Live'),
(391, 'US', 'America/Indiana/Knox', 'Live'),
(392, 'US', 'America/Menominee', 'Live'),
(393, 'US', 'America/North_Dakota/Center', 'Live'),
(394, 'US', 'America/North_Dakota/New_Salem', 'Live'),
(395, 'US', 'America/North_Dakota/Beulah', 'Live'),
(396, 'US', 'America/Denver', 'Live'),
(397, 'US', 'America/Boise', 'Live'),
(398, 'US', 'America/Phoenix', 'Live'),
(399, 'US', 'America/Los_Angeles', 'Live'),
(400, 'US', 'America/Anchorage', 'Live'),
(401, 'US', 'America/Juneau', 'Live'),
(402, 'US', 'America/Sitka', 'Live'),
(403, 'US', 'America/Metlakatla', 'Live'),
(404, 'US', 'America/Yakutat', 'Live'),
(405, 'US', 'America/Nome', 'Live'),
(406, 'US', 'America/Adak', 'Live'),
(407, 'US', 'Pacific/Honolulu', 'Live'),
(408, 'UY', 'America/Montevideo', 'Live'),
(409, 'UZ', 'Asia/Samarkand', 'Live'),
(410, 'UZ', 'Asia/Tashkent', 'Live'),
(411, 'VA', 'Europe/Vatican', 'Live'),
(412, 'VC', 'America/St_Vincent', 'Live'),
(413, 'VE', 'America/Caracas', 'Live'),
(414, 'VG', 'America/Tortola', 'Live'),
(415, 'VI', 'America/St_Thomas', 'Live'),
(416, 'VN', 'Asia/Ho_Chi_Minh', 'Live'),
(417, 'VU', 'Pacific/Efate', 'Live'),
(418, 'WF', 'Pacific/Wallis', 'Live'),
(419, 'WS', 'Pacific/Apia', 'Live'),
(420, 'YE', 'Asia/Aden', 'Live'),
(421, 'YT', 'Indian/Mayotte', 'Live'),
(422, 'ZA', 'Africa/Johannesburg', 'Live'),
(423, 'ZM', 'Africa/Lusaka', 'Live'),
(424, 'ZW', 'Africa/Harare', 'Live');

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

--
-- Table structure for table `tbl_transfer`
--

CREATE TABLE `tbl_transfer` (
  `id` int(11) NOT NULL,
  `transfer_type` int(11) NOT NULL DEFAULT 1,
  `reference_no` varchar(55) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `received_date` varchar(30) DEFAULT NULL,
  `note_for_sender` varchar(300) DEFAULT NULL,
  `note_for_receiver` varchar(300) DEFAULT NULL,
  `from_outlet_id` int(11) DEFAULT NULL,
  `to_outlet_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `tbl_transfer_items`
--

CREATE TABLE `tbl_transfer_items` (
  `id` int(11) NOT NULL,
  `status` int(11) DEFAULT NULL,
  `ingredient_id` int(11) DEFAULT NULL,
  `quantity_amount` float DEFAULT NULL,
  `transfer_id` int(11) DEFAULT NULL,
  `item_type` varchar(55) NOT NULL,
  `expiry_imei_serial` varchar(255) DEFAULT NULL,
  `from_outlet_id` int(11) DEFAULT NULL,
  `to_outlet_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `tbl_units`
--

CREATE TABLE `tbl_units` (
  `id` int(11) NOT NULL,
  `unit_name` varchar(55) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `tbl_units`
--

INSERT INTO `tbl_units` (`id`, `unit_name`, `description`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'PCS', '', '2024-05-21 14:34:40', 1, 1, 'Live'),
(2, 'Bundle', '', '2024-05-21 14:34:47', 1, 1, 'Live');

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

--
-- Table structure for table `tbl_variations`
--

CREATE TABLE `tbl_variations` (
  `id` int(11) NOT NULL,
  `variation_name` varchar(55) DEFAULT NULL,
  `variation_value` varchar(300) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_variations`
--

INSERT INTO `tbl_variations` (`id`, `variation_name`, `variation_value`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'Size', '[\"M\",\"L\",\"XL\",\"XXL\"]', '2024-05-21 14:36:14', 1, 1, 'Live'),
(2, 'Color', '[\"Red\",\"Blue\",\"Sky Blue\",\"Yellow\",\"Navy Blue\",\"Lightblue\",\"White \",\"Black\",\"Gray\",\"Green\",\"Light Green\"]', '2024-05-21 14:36:48', 1, 1, 'Live'),
(3, 'Hips Size', '[\"28\",\"30\",\"32\",\"34\",\"36\",\"38\",\"40\"]', '2024-05-21 18:59:11', 1, 1, 'Live'),
(4, 'Shoes Size', '[\"38\",\"40\",\"42\",\"44\"]', '2024-05-21 20:37:44', 1, 1, 'Live');

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

--
-- Table structure for table `tbl_warranties`
--

CREATE TABLE `tbl_warranties` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `customer_name` varchar(55) DEFAULT NULL,
  `customer_mobile` varchar(30) DEFAULT NULL,
  `product_name` varchar(55) DEFAULT NULL,
  `product_serial_no` varchar(100) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `receiving_date` varchar(30) DEFAULT NULL,
  `delivery_date` varchar(30) DEFAULT NULL,
  `current_status` varchar(25) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) UNSIGNED DEFAULT NULL,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_warranties`
--

INSERT INTO `tbl_warranties` (`id`, `customer_id`, `customer_name`, `customer_mobile`, `product_name`, `product_serial_no`, `description`, `receiving_date`, `delivery_date`, `current_status`, `added_date`, `user_id`, `outlet_id`, `company_id`, `del_status`) VALUES
(1, 84, 'Mr.John', '01987434455', 'Dell Ultra Sharp', 'DELLU2422HE123459', 'Display problem', '2024-05-25', '2024-06-01', 'R_F_C', '2024-05-25 19:55:18', 1, 4, 1, 'Live');

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

--
-- Structure for view `tbl_stock_detail`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`dsbeta`@`localhost` SQL SECURITY DEFINER VIEW `tbl_stock_detail`  AS   (select `op`.`item_id` AS `item_id`,`op`.`item_type` AS `item_type`,`op`.`item_description` AS `expiry_imei_serial`,`op`.`stock_quantity` AS `stock_quantity`,`op`.`outlet_id` AS `outlet_id`,1 AS `type`,'Opening' AS `description` from `tbl_set_opening_stocks` `op` where `op`.`del_status` = 'Live') union (select `pu`.`item_id` AS `item_id`,`pu`.`item_type` AS `item_type`,`pu`.`expiry_imei_serial` AS `expiry_imei_serial`,`pu`.`quantity_amount` * `i`.`conversion_rate` AS `stock_quantity`,`pu`.`outlet_id` AS `outlet_id`,1 AS `type`,'Purchase' AS `description` from (`tbl_purchase_details` `pu` join `tbl_items` `i`) where `pu`.`del_status` = 'Live' and `pu`.`item_id` = `i`.`id`) union (select `pr`.`item_id` AS `item_id`,`pr`.`item_type` AS `item_type`,`pr`.`expiry_imei_serial` AS `expiry_imei_serial`,`pr`.`return_quantity_amount` AS `stock_quantity`,`pr`.`outlet_id` AS `outlet_id`,2 AS `type`,'Purchase Return' AS `description` from `tbl_purchase_return_details` `pr` where `pr`.`del_status` = 'Live') union (select `pri`.`item_id` AS `item_id`,`pri`.`item_type` AS `item_type`,`pri`.`expiry_imei_serial_in` AS `expiry_imei_serial`,`pri`.`return_quantity_amount` AS `stock_quantity`,`pri`.`outlet_id` AS `outlet_id`,1 AS `type`,'Purchase Return In' AS `description` from `tbl_purchase_return_details` `pri` where `pri`.`return_status` = 'taken_by_sup_pro_returned' and `pri`.`del_status` = 'Live') union (select `i_s`.`item_id` AS `item_id`,`i_s`.`item_type` AS `item_type`,`i_s`.`expiry_imei_serial` AS `expiry_imei_serial`,`i_s`.`quantity` AS `stock_quantity`,`i_s`.`outlet_id` AS `outlet_id`,2 AS `type`,'Installment Sale' AS `description` from `tbl_installments` `i_s` where `i_s`.`del_status` = 'Live') union (select `s`.`food_menu_id` AS `item_id`,`s`.`item_type` AS `item_type`,'' AS `expiry_imei_serial`,`s`.`qty` AS `stock_quantity`,`s`.`outlet_id` AS `outlet_id`,2 AS `type`,'Sale' AS `description` from `tbl_sales_details` `s` where (`s`.`delivery_status` = 'Sent' or `s`.`delivery_status` = 'Cash Received') and `s`.`del_status` = 'Live') union (select `s2`.`food_menu_id` AS `item_id`,`s2`.`item_type` AS `item_type`,`s2`.`expiry_imei_serial` AS `expiry_imei_serial`,0 AS `stock_quantity`,`s2`.`outlet_id` AS `outlet_id`,2 AS `type`,'Sale IMEI' AS `description` from `tbl_sales_details` `s2` where !(`s2`.`expiry_imei_serial` in (select `sr2`.`expiry_imei_serial` from `tbl_sale_return_details` `sr2` where `sr2`.`item_id` = `s2`.`food_menu_id` and `s2`.`outlet_id` = `sr2`.`outlet_id`)) and `s2`.`del_status` = 'Live') union (select `sr`.`item_id` AS `item_id`,`sr`.`item_type` AS `item_type`,'' AS `expiry_imei_serial`,`sr`.`return_quantity_amount` AS `stock_quantity`,`sr`.`outlet_id` AS `outlet_id`,1 AS `type`,'Sale Return' AS `description` from `tbl_sale_return_details` `sr` where `sr`.`del_status` = 'Live') union (select `d`.`item_id` AS `item_id`,`d`.`item_type` AS `item_type`,`d`.`expiry_imei_serial` AS `expiry_imei_serial`,`d`.`damage_quantity` AS `stock_quantity`,`d`.`outlet_id` AS `outlet_id`,2 AS `type`,'Damage' AS `description` from `tbl_damage_details` `d` where `d`.`del_status` = 'Live') union (select `tou`.`ingredient_id` AS `item_id`,`tou`.`item_type` AS `item_type`,`tou`.`expiry_imei_serial` AS `expiry_imei_serial`,`tou`.`quantity_amount` AS `stock_quantity`,`tou`.`outlet_id` AS `outlet_id`,2 AS `type`,'Transfer Out' AS `description` from `tbl_transfer_items` `tou` where `tou`.`from_outlet_id` = `tou`.`outlet_id` and `tou`.`del_status` = 'Live') union (select `ti`.`ingredient_id` AS `item_id`,`ti`.`item_type` AS `item_type`,`ti`.`expiry_imei_serial` AS `expiry_imei_serial`,`ti`.`quantity_amount` AS `stock_quantity`,`ti`.`to_outlet_id` AS `outlet_id`,1 AS `type`,'Transfer In' AS `description` from `tbl_transfer_items` `ti` where `ti`.`to_outlet_id` <> `ti`.`outlet_id` and `ti`.`del_status` = 'Live')  ;

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

--
-- Structure for view `tbl_stock_detail2`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`dsbeta`@`localhost` SQL SECURITY DEFINER VIEW `tbl_stock_detail2`  AS   (select `op`.`item_id` AS `item_id`,`op`.`item_type` AS `item_type`,`op`.`item_description` AS `expiry_imei_serial`,`op`.`stock_quantity` AS `stock_quantity`,`op`.`outlet_id` AS `outlet_id`,1 AS `type`,'Opening' AS `description` from `tbl_set_opening_stocks` `op` where `op`.`del_status` = 'Live') union (select `pu`.`item_id` AS `item_id`,`pu`.`item_type` AS `item_type`,`pu`.`expiry_imei_serial` AS `expiry_imei_serial`,`pu`.`quantity_amount` * `i`.`conversion_rate` AS `stock_quantity`,`pu`.`outlet_id` AS `outlet_id`,1 AS `type`,'Purchase' AS `description` from (`tbl_purchase_details` `pu` join `tbl_items` `i`) where `pu`.`del_status` = 'Live' and `pu`.`item_id` = `i`.`id`) union (select `pr`.`item_id` AS `item_id`,`pr`.`item_type` AS `item_type`,`pr`.`expiry_imei_serial` AS `expiry_imei_serial`,-`pr`.`return_quantity_amount` AS `stock_quantity`,`pr`.`outlet_id` AS `outlet_id`,2 AS `type`,'Purchase Return' AS `description` from `tbl_purchase_return_details` `pr` where `pr`.`del_status` = 'Live') union (select `pri`.`item_id` AS `item_id`,`pri`.`item_type` AS `item_type`,`pri`.`expiry_imei_serial_in` AS `expiry_imei_serial`,`pri`.`return_quantity_amount` AS `stock_quantity`,`pri`.`outlet_id` AS `outlet_id`,1 AS `type`,'Purchase Return In' AS `description` from `tbl_purchase_return_details` `pri` where `pri`.`return_status` = 'taken_by_sup_pro_returned' and `pri`.`del_status` = 'Live') union (select `s`.`food_menu_id` AS `item_id`,`s`.`item_type` AS `item_type`,`s`.`expiry_imei_serial` AS `expiry_imei_serial`,-`s`.`qty` AS `stock_quantity`,`s`.`outlet_id` AS `outlet_id`,2 AS `type`,'Sale' AS `description` from `tbl_sales_details` `s` where (`s`.`delivery_status` = 'Sent' or `s`.`delivery_status` = 'Cash Received') and `s`.`del_status` = 'Live') union (select `sr`.`item_id` AS `item_id`,`sr`.`item_type` AS `item_type`,`sr`.`expiry_imei_serial` AS `expiry_imei_serial`,`sr`.`return_quantity_amount` AS `stock_quantity`,`sr`.`outlet_id` AS `outlet_id`,1 AS `type`,'Sale Return' AS `description` from `tbl_sale_return_details` `sr` where `sr`.`del_status` = 'Live') union (select `d`.`item_id` AS `item_id`,`d`.`item_type` AS `item_type`,`d`.`expiry_imei_serial` AS `expiry_imei_serial`,-`d`.`damage_quantity` AS `stock_quantity`,`d`.`outlet_id` AS `outlet_id`,2 AS `type`,'Damage' AS `description` from `tbl_damage_details` `d` where `d`.`del_status` = 'Live') union (select `tou`.`ingredient_id` AS `item_id`,`tou`.`item_type` AS `item_type`,`tou`.`expiry_imei_serial` AS `expiry_imei_serial`,-`tou`.`quantity_amount` AS `stock_quantity`,`tou`.`outlet_id` AS `outlet_id`,2 AS `type`,'Transfer Out' AS `description` from `tbl_transfer_items` `tou` where `tou`.`from_outlet_id` = `tou`.`outlet_id` and `tou`.`del_status` = 'Live') union (select `ti`.`ingredient_id` AS `item_id`,`ti`.`item_type` AS `item_type`,`ti`.`expiry_imei_serial` AS `expiry_imei_serial`,`ti`.`quantity_amount` AS `stock_quantity`,`ti`.`to_outlet_id` AS `outlet_id`,1 AS `type`,'Transfer In' AS `description` from `tbl_transfer_items` `ti` where `ti`.`to_outlet_id` <> `ti`.`outlet_id` and `ti`.`del_status` = 'Live')  ;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- Indexes for table `tbl_customer_due_receives`
--
ALTER TABLE `tbl_customer_due_receives`
  ADD PRIMARY KEY (`id`),
  ADD KEY `outlet_id_slow` (`id`);

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

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

--
-- Indexes for table `tbl_damage_details`
--
ALTER TABLE `tbl_damage_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slow` (`item_id`,`outlet_id`,`del_status`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `tbl_installments`
--
ALTER TABLE `tbl_installments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slow` (`item_id`,`outlet_id`,`del_status`);

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

--
-- Indexes for table `tbl_items`
--
ALTER TABLE `tbl_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `brand_id_slow` (`brand_id`);

--
-- Indexes for table `tbl_item_categories`
--
ALTER TABLE `tbl_item_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slow` (`del_status`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `tbl_purchase_details`
--
ALTER TABLE `tbl_purchase_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slow` (`item_id`,`outlet_id`,`del_status`),
  ADD KEY `purchase_id_slow` (`purchase_id`);

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

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

--
-- Indexes for table `tbl_purchase_return_details`
--
ALTER TABLE `tbl_purchase_return_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slow` (`item_id`,`outlet_id`,`del_status`);

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

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

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

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

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

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

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

--
-- Indexes for table `tbl_sales`
--
ALTER TABLE `tbl_sales`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sale_slow` (`customer_id`,`user_id`,`outlet_id`);

--
-- Indexes for table `tbl_sales_details`
--
ALTER TABLE `tbl_sales_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slow` (`food_menu_id`,`outlet_id`,`del_status`),
  ADD KEY `slow1` (`sales_id`),
  ADD KEY `user_id_slow` (`user_id`),
  ADD KEY `previous_id_slow` (`sales_id`);

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

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

--
-- Indexes for table `tbl_sale_return_details`
--
ALTER TABLE `tbl_sale_return_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slow` (`item_id`,`outlet_id`,`del_status`);

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

--
-- Indexes for table `tbl_sessions`
--
ALTER TABLE `tbl_sessions`
  ADD KEY `ci_sessions_timestamp` (`timestamp`);

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

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

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

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

--
-- Indexes for table `tbl_transfer`
--
ALTER TABLE `tbl_transfer`
  ADD PRIMARY KEY (`id`) USING BTREE;

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

--
-- Indexes for table `tbl_units`
--
ALTER TABLE `tbl_units`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slow` (`del_status`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `tbl_sales`
--
ALTER TABLE `tbl_sales`
  MODIFY `id` bigint(55) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_sales_details`
--
ALTER TABLE `tbl_sales_details`
  MODIFY `id` bigint(55) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

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

--
-- AUTO_INCREMENT for table `tbl_set_opening_stocks`
--
ALTER TABLE `tbl_set_opening_stocks`
  MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1035;

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

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

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

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

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

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

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

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

