-- Table structure for table `product_variants_11`
--

CREATE TABLE IF NOT EXISTS `product_variants_11` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_master_id` bigint UNSIGNED NOT NULL,
  `sku` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `full_name` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uom_id` bigint UNSIGNED DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `stock` int NOT NULL DEFAULT '0',
  `status` enum('ACTIVE','INACTIVE') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVE',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `brand_id` bigint UNSIGNED DEFAULT NULL,
  `hsn_id` bigint UNSIGNED DEFAULT NULL,
  `default_warehouse_id` bigint UNSIGNED DEFAULT NULL,
  `item_tax_template_id` bigint UNSIGNED DEFAULT NULL,
  `is_stock_item` tinyint(1) NOT NULL DEFAULT '1',
  `is_sales_item` tinyint(1) NOT NULL DEFAULT '1',
  `is_purchase_item` tinyint(1) NOT NULL DEFAULT '1',
  `opening_stock` decimal(13,3) NOT NULL DEFAULT '0.000',
  `opening_value` decimal(15,2) NOT NULL DEFAULT '0.00',
  `valuation_method` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'FIFO',
  `default_uom_id` bigint UNSIGNED DEFAULT NULL,
  `reserved_qty` decimal(13,3) NOT NULL DEFAULT '0.000',
  `ordered_qty` decimal(13,3) NOT NULL DEFAULT '0.000',
  `available_qty` decimal(13,3) NOT NULL DEFAULT '0.000',
  `batch_number_series` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `serial_number_series` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `auto_create_serial` tinyint(1) NOT NULL DEFAULT '0',
  `auto_create_batch` tinyint(1) NOT NULL DEFAULT '0',
  `company_id` bigint UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_variants_sku_unique` (`sku`),
  KEY `product_variants_product_master_id_foreign` (`product_master_id`),
  KEY `product_variants_uom_id_index` (`uom_id`),
  KEY `product_variants_brand_id_foreign` (`brand_id`),
  KEY `product_variants_hsn_id_foreign` (`hsn_id`),
  KEY `product_variants_default_warehouse_id_foreign` (`default_warehouse_id`),
  KEY `product_variants_default_uom_id_foreign` (`default_uom_id`),
  KEY `product_variants_company_id_foreign` (`company_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_variant_attributes`
--

CREATE TABLE IF NOT EXISTS `product_variant_attributes` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_variant_id` bigint UNSIGNED NOT NULL,
  `attribute_master_id` bigint UNSIGNED NOT NULL,
  `attribute_value_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `var_attr_unique` (`product_variant_id`,`attribute_master_id`),
  KEY `product_variant_attributes_attribute_master_id_foreign` (`attribute_master_id`),
  KEY `product_variant_attributes_attribute_value_id_foreign` (`attribute_value_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2440 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_variant_attributes`
--

INSERT INTO `product_variant_attributes` (`id`, `product_variant_id`, `attribute_master_id`, `attribute_value_id`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 1, 1, 38, NULL, NULL, 'AJIT HOGADE', NULL),
(2, 1, 4, 70, NULL, NULL, 'AJIT HOGADE', NULL),
(3, 2, 1, 38, NULL, NULL, 'AJIT HOGADE', NULL),
(4, 2, 4, 68, NULL, NULL, 'AJIT HOGADE', NULL),
(5, 3, 1, 38, NULL, NULL, 'AJIT HOGADE', NULL),
(6, 3, 4, 70, NULL, NULL, 'AJIT HOGADE', NULL),
(7, 3, 10, 65, NULL, NULL, 'AJIT HOGADE', NULL),
(8, 4, 1, 38, NULL, NULL, 'AJIT HOGADE', NULL),
(9, 4, 4, 68, NULL, NULL, 'AJIT HOGADE', NULL),
(10, 4, 10, 66, NULL, NULL, 'AJIT HOGADE', NULL),
(11, 5, 1, 38, NULL, NULL, 'AJIT HOGADE', NULL),
(12, 5, 4, 69, NULL, NULL, 'AJIT HOGADE', NULL),
(13, 5, 10, 67, NULL, NULL, 'AJIT HOGADE', NULL),
(14, 6, 2, 74, NULL, NULL, 'AJIT HOGADE', NULL),
(15, 6, 4, 70, NULL, NULL, 'AJIT HOGADE', NULL),
(16, 7, 2, 72, NULL, NULL, 'AJIT HOGADE', NULL),
(17, 7, 4, 70, NULL, NULL, 'AJIT HOGADE', NULL),
(18, 8, 2, 71, NULL, NULL, 'AJIT HOGADE', NULL),
(19, 8, 4, 70, NULL, NULL, 'AJIT HOGADE', NULL),
(20, 9, 5, 58, NULL, NULL, 'AJIT HOGADE', NULL),
(21, 9, 8, 35, NULL, NULL, 'AJIT HOGADE', NULL),
(22, 10, 8, 75, NULL, NULL, 'AJIT HOGADE', NULL),
(23, 11, 5, 76, NULL, NULL, 'AJIT HOGADE', NULL),
(24, 11, 8, 75, NULL, NULL, 'AJIT HOGADE', NULL),
(25, 12, 8, 77, NULL, NULL, 'AJIT HOGADE', NULL),
(26, 13, 8, 78, NULL, NULL, 'AJIT HOGADE', NULL),
(27, 14, 8, 79, NULL, NULL, 'AJIT HOGADE', NULL),
(28, 15, 8, 75, NULL, NULL, 'AJIT HOGADE', NULL),
(29, 16, 8, 75, NULL, NULL, 'AJIT HOGADE', NULL),
(30, 17, 5, 64, NULL, NULL, 'AJIT HOGADE', NULL),
(31, 18, 5, 80, NULL, NULL, 'AJIT HOGADE', NULL),
(32, 19, 6, 81, NULL, NULL, 'AJIT HOGADE', NULL),
(33, 20, 6, 82, NULL, NULL, 'AJIT HOGADE', NULL),
(34, 21, 5, 83, NULL, NULL, 'AJIT HOGADE', NULL),
(35, 22, 5, 84, NULL, NULL, 'AJIT HOGADE', NULL),
(36, 23, 8, 75, NULL, NULL, 'AJIT HOGADE', NULL),
(37, 23, 12, 85, NULL, NULL, 'AJIT HOGADE', NULL),
(38, 24, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(39, 25, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(44, 26, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(45, 26, 4, 91, NULL, NULL, 'AJIT HOGADE', NULL),
(46, 27, 5, 10, NULL, NULL, 'AJIT HOGADE', NULL),
(47, 27, 11, 92, NULL, NULL, 'AJIT HOGADE', NULL),
(48, 28, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(49, 28, 5, 10, NULL, NULL, 'AJIT HOGADE', NULL),
(50, 29, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(51, 29, 5, 10, NULL, NULL, 'AJIT HOGADE', NULL),
(52, 30, 3, 93, NULL, NULL, 'AJIT HOGADE', NULL),
(53, 30, 5, 10, NULL, NULL, 'AJIT HOGADE', NULL),
(54, 31, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(55, 31, 5, 10, NULL, NULL, 'AJIT HOGADE', NULL),
(56, 32, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(57, 32, 5, 10, NULL, NULL, 'AJIT HOGADE', NULL),
(58, 33, 6, 102, NULL, NULL, 'AJIT HOGADE', NULL),
(59, 34, 6, 103, NULL, NULL, 'AJIT HOGADE', NULL),
(60, 35, 6, 101, NULL, NULL, 'AJIT HOGADE', NULL),
(61, 36, 1, 38, NULL, NULL, 'AJIT HOGADE', NULL),
(62, 36, 3, 104, NULL, NULL, 'AJIT HOGADE', NULL),
(63, 36, 13, 94, NULL, NULL, 'AJIT HOGADE', NULL),
(64, 37, 1, 38, NULL, NULL, 'AJIT HOGADE', NULL),
(65, 37, 3, 93, NULL, NULL, 'AJIT HOGADE', NULL),
(66, 37, 13, 94, NULL, NULL, 'AJIT HOGADE', NULL),
(67, 38, 1, 38, NULL, NULL, 'AJIT HOGADE', NULL),
(68, 38, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(69, 38, 13, 94, NULL, NULL, 'AJIT HOGADE', NULL),
(70, 39, 1, 38, NULL, NULL, 'AJIT HOGADE', NULL),
(71, 39, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(72, 39, 13, 94, NULL, NULL, 'AJIT HOGADE', NULL),
(73, 40, 1, 39, NULL, NULL, 'AJIT HOGADE', NULL),
(74, 40, 3, 104, NULL, NULL, 'AJIT HOGADE', NULL),
(75, 40, 13, 94, NULL, NULL, 'AJIT HOGADE', NULL),
(76, 41, 1, 39, NULL, NULL, 'AJIT HOGADE', NULL),
(77, 41, 3, 93, NULL, NULL, 'AJIT HOGADE', NULL),
(78, 41, 13, 94, NULL, NULL, 'AJIT HOGADE', NULL),
(79, 42, 1, 39, NULL, NULL, 'AJIT HOGADE', NULL),
(80, 42, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(81, 42, 13, 94, NULL, NULL, 'AJIT HOGADE', NULL),
(82, 43, 1, 39, NULL, NULL, 'AJIT HOGADE', NULL),
(83, 43, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(84, 43, 13, 94, NULL, NULL, 'AJIT HOGADE', NULL),
(85, 44, 1, 38, NULL, NULL, 'AJIT HOGADE', NULL),
(86, 44, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(87, 45, 1, 38, NULL, NULL, 'AJIT HOGADE', NULL),
(88, 45, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(89, 46, 1, 38, NULL, NULL, 'AJIT HOGADE', NULL),
(90, 46, 3, 93, NULL, NULL, 'AJIT HOGADE', NULL),
(91, 47, 1, 38, NULL, NULL, 'AJIT HOGADE', NULL),
(92, 47, 3, 104, NULL, NULL, 'AJIT HOGADE', NULL),
(93, 48, 1, 39, NULL, NULL, 'AJIT HOGADE', NULL),
(94, 48, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(95, 49, 1, 39, NULL, NULL, 'AJIT HOGADE', NULL),
(96, 49, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(97, 50, 1, 39, NULL, NULL, 'AJIT HOGADE', NULL),
(98, 50, 3, 93, NULL, NULL, 'AJIT HOGADE', NULL),
(99, 51, 1, 39, NULL, NULL, 'AJIT HOGADE', NULL),
(100, 51, 3, 104, NULL, NULL, 'AJIT HOGADE', NULL),
(101, 52, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(102, 53, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(103, 54, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(104, 55, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(105, 56, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(106, 56, 13, 95, NULL, NULL, 'AJIT HOGADE', NULL),
(107, 57, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(108, 57, 13, 96, NULL, NULL, 'AJIT HOGADE', NULL),
(109, 58, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(110, 58, 13, 95, NULL, NULL, 'AJIT HOGADE', NULL),
(111, 59, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(112, 59, 13, 96, NULL, NULL, 'AJIT HOGADE', NULL),
(113, 60, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(114, 60, 12, 85, NULL, NULL, 'AJIT HOGADE', NULL),
(115, 61, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(116, 61, 12, 85, NULL, NULL, 'AJIT HOGADE', NULL),
(117, 62, 12, 86, NULL, NULL, 'AJIT HOGADE', NULL),
(118, 63, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(119, 63, 5, 10, NULL, NULL, 'AJIT HOGADE', NULL),
(120, 64, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(121, 64, 5, 10, NULL, NULL, 'AJIT HOGADE', NULL),
(122, 65, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(123, 65, 5, 10, NULL, NULL, 'AJIT HOGADE', NULL),
(124, 65, 13, 95, NULL, NULL, 'AJIT HOGADE', NULL),
(125, 66, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(126, 66, 5, 10, NULL, NULL, 'AJIT HOGADE', NULL),
(127, 66, 13, 96, NULL, NULL, 'AJIT HOGADE', NULL),
(128, 67, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(129, 67, 5, 10, NULL, NULL, 'AJIT HOGADE', NULL),
(130, 67, 13, 95, NULL, NULL, 'AJIT HOGADE', NULL),
(131, 68, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(132, 68, 5, 10, NULL, NULL, 'AJIT HOGADE', NULL),
(133, 68, 13, 96, NULL, NULL, 'AJIT HOGADE', NULL),
(134, 69, 8, 33, NULL, NULL, 'AJIT HOGADE', NULL),
(135, 70, 3, 106, NULL, NULL, 'AJIT HOGADE', NULL),
(136, 70, 8, 34, NULL, NULL, 'AJIT HOGADE', NULL),
(137, 71, 3, 104, NULL, NULL, 'AJIT HOGADE', NULL),
(138, 71, 8, 34, NULL, NULL, 'AJIT HOGADE', NULL),
(139, 72, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(140, 72, 8, 34, NULL, NULL, 'AJIT HOGADE', NULL),
(141, 73, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(142, 73, 8, 34, NULL, NULL, 'AJIT HOGADE', NULL),
(143, 74, 12, 87, NULL, NULL, 'AJIT HOGADE', NULL),
(144, 75, 12, 88, NULL, NULL, 'AJIT HOGADE', NULL),
(145, 76, 12, 86, NULL, NULL, 'AJIT HOGADE', NULL),
(146, 77, 5, 107, NULL, NULL, 'AJIT HOGADE', NULL),
(147, 77, 8, 34, NULL, NULL, 'AJIT HOGADE', NULL),
(148, 78, 5, 76, NULL, NULL, 'AJIT HOGADE', NULL),
(149, 78, 8, 34, NULL, NULL, 'AJIT HOGADE', NULL),
(150, 79, 5, 80, NULL, NULL, 'AJIT HOGADE', NULL),
(151, 79, 8, 34, NULL, NULL, 'AJIT HOGADE', NULL),
(152, 80, 3, 106, NULL, NULL, 'AJIT HOGADE', NULL),
(153, 80, 4, 109, NULL, NULL, 'AJIT HOGADE', NULL),
(154, 80, 5, 110, NULL, NULL, 'AJIT HOGADE', NULL),
(155, 81, 3, 104, NULL, NULL, 'AJIT HOGADE', NULL),
(156, 81, 4, 109, NULL, NULL, 'AJIT HOGADE', NULL),
(157, 81, 5, 110, NULL, NULL, 'AJIT HOGADE', NULL),
(158, 82, 3, 108, NULL, NULL, 'AJIT HOGADE', NULL),
(159, 82, 4, 109, NULL, NULL, 'AJIT HOGADE', NULL),
(160, 82, 5, 110, NULL, NULL, 'AJIT HOGADE', NULL),
(161, 83, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(162, 83, 4, 105, NULL, NULL, 'AJIT HOGADE', NULL),
(163, 83, 5, 110, NULL, NULL, 'AJIT HOGADE', NULL),
(164, 84, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(165, 84, 4, 109, NULL, NULL, 'AJIT HOGADE', NULL),
(166, 84, 5, 110, NULL, NULL, 'AJIT HOGADE', NULL),
(167, 85, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(168, 85, 4, 105, NULL, NULL, 'AJIT HOGADE', NULL),
(169, 85, 5, 110, NULL, NULL, 'AJIT HOGADE', NULL),
(170, 86, 5, 111, NULL, NULL, 'AJIT HOGADE', NULL),
(171, 87, 4, 105, NULL, NULL, 'AJIT HOGADE', NULL),
(172, 88, 3, 112, NULL, NULL, 'AJIT HOGADE', NULL),
(173, 89, 3, 113, NULL, NULL, 'AJIT HOGADE', NULL),
(174, 90, 3, 106, NULL, NULL, 'AJIT HOGADE', NULL),
(175, 91, 3, 104, NULL, NULL, 'AJIT HOGADE', NULL),
(176, 92, 3, 93, NULL, NULL, 'AJIT HOGADE', NULL),
(177, 93, 3, 114, NULL, NULL, 'AJIT HOGADE', NULL),
(178, 94, 3, 108, NULL, NULL, 'AJIT HOGADE', NULL),
(179, 95, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(180, 96, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(181, 97, 3, 5, NULL, NULL, 'AJIT HOGADE', NULL),
(182, 98, 3, 6, NULL, NULL, 'AJIT HOGADE', NULL),
(183, 99, 3, 93, NULL, NULL, 'AJIT HOGADE', NULL),
(184, 100, 3, 104, NULL, NULL, 'AJIT HOGADE', NULL),
(185, 101, 3, 106, NULL, NULL, 'AJIT HOGADE', NULL),
(186, 102, 3, 108, NULL, NULL, 'AJIT HOGADE', NULL),
(187, 103, 3, 112, NULL, NULL, 'AJIT HOGADE', NULL),
(188, 104, 3, 113, NULL, NULL, 'AJIT HOGADE', NULL),
(189, 105, 3, 114, NULL, NULL, 'AJIT HOGADE', NULL),
(190, 106, 14, 124, NULL, NULL, 'SYSTEM', NULL),
(191, 106, 15, 293, NULL, NULL, 'SYSTEM', NULL),
(192, 106, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(193, 107, 14, 119, NULL, NULL, 'SYSTEM', NULL),
(194, 107, 15, 298, NULL, NULL, 'SYSTEM', NULL),
(195, 107, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(196, 108, 14, 119, NULL, NULL, 'SYSTEM', NULL),
(197, 108, 15, 299, NULL, NULL, 'SYSTEM', NULL),
(198, 108, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(199, 109, 14, 119, NULL, NULL, 'SYSTEM', NULL),
(200, 109, 15, 300, NULL, NULL, 'SYSTEM', NULL),
(201, 109, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(202, 110, 14, 119, NULL, NULL, 'SYSTEM', NULL),
(203, 110, 15, 301, NULL, NULL, 'SYSTEM', NULL),
(204, 110, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(205, 111, 14, 119, NULL, NULL, 'SYSTEM', NULL),
(206, 111, 15, 302, NULL, NULL, 'SYSTEM', NULL),
(207, 111, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(208, 112, 14, 118, NULL, NULL, 'SYSTEM', NULL),
(209, 112, 15, 303, NULL, NULL, 'SYSTEM', NULL),
(210, 112, 11, 238, NULL, NULL, 'SYSTEM', NULL),
(211, 113, 14, 122, NULL, NULL, 'SYSTEM', NULL),
(212, 113, 15, 309, NULL, NULL, 'SYSTEM', NULL),
(213, 113, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(214, 114, 14, 122, NULL, NULL, 'SYSTEM', NULL),
(215, 114, 15, 310, NULL, NULL, 'SYSTEM', NULL),
(216, 114, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(217, 115, 14, 122, NULL, NULL, 'SYSTEM', NULL),
(218, 115, 15, 311, NULL, NULL, 'SYSTEM', NULL),
(219, 115, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(220, 116, 14, 122, NULL, NULL, 'SYSTEM', NULL),
(221, 116, 15, 312, NULL, NULL, 'SYSTEM', NULL),
(222, 116, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(223, 117, 14, 117, NULL, NULL, 'SYSTEM', NULL),
(224, 117, 15, 313, NULL, NULL, 'SYSTEM', NULL),
(225, 117, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(226, 118, 14, 117, NULL, NULL, 'SYSTEM', NULL),
(227, 118, 15, 314, NULL, NULL, 'SYSTEM', NULL),
(228, 118, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(229, 119, 14, 117, NULL, NULL, 'SYSTEM', NULL),
(230, 119, 15, 315, NULL, NULL, 'SYSTEM', NULL),
(231, 119, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(232, 120, 14, 117, NULL, NULL, 'SYSTEM', NULL),
(233, 120, 15, 316, NULL, NULL, 'SYSTEM', NULL),
(234, 120, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(235, 121, 14, 121, NULL, NULL, 'SYSTEM', NULL),
(236, 121, 15, 317, NULL, NULL, 'SYSTEM', NULL),
(237, 121, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(238, 122, 14, 121, NULL, NULL, 'SYSTEM', NULL),
(239, 122, 15, 318, NULL, NULL, 'SYSTEM', NULL),
(240, 122, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(241, 123, 14, 121, NULL, NULL, 'SYSTEM', NULL),
(242, 123, 15, 319, NULL, NULL, 'SYSTEM', NULL),
(243, 123, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(244, 124, 14, 121, NULL, NULL, 'SYSTEM', NULL),
(245, 124, 15, 320, NULL, NULL, 'SYSTEM', NULL),
(246, 124, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(247, 125, 14, 127, NULL, NULL, 'SYSTEM', NULL),
(248, 125, 15, 321, NULL, NULL, 'SYSTEM', NULL),
(249, 125, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(250, 126, 14, 127, NULL, NULL, 'SYSTEM', NULL),
(251, 126, 15, 324, NULL, NULL, 'SYSTEM', NULL),
(252, 126, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(253, 127, 14, 128, NULL, NULL, 'SYSTEM', NULL),
(254, 127, 15, 326, NULL, NULL, 'SYSTEM', NULL),
(255, 127, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(256, 128, 14, 128, NULL, NULL, 'SYSTEM', NULL),
(257, 128, 15, 327, NULL, NULL, 'SYSTEM', NULL),
(258, 128, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(259, 129, 14, 128, NULL, NULL, 'SYSTEM', NULL),
(260, 129, 15, 329, NULL, NULL, 'SYSTEM', NULL),
(261, 129, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(262, 130, 14, 129, NULL, NULL, 'SYSTEM', NULL),
(263, 130, 15, 330, NULL, NULL, 'SYSTEM', NULL),
(264, 130, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(265, 131, 14, 129, NULL, NULL, 'SYSTEM', NULL),
(266, 131, 15, 331, NULL, NULL, 'SYSTEM', NULL),
(267, 131, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(268, 132, 14, 120, NULL, NULL, 'SYSTEM', NULL),
(269, 132, 15, 338, NULL, NULL, 'SYSTEM', NULL),
(270, 132, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(271, 133, 14, 120, NULL, NULL, 'SYSTEM', NULL),
(272, 133, 15, 340, NULL, NULL, 'SYSTEM', NULL),
(273, 133, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(274, 134, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(275, 134, 15, 345, NULL, NULL, 'SYSTEM', NULL),
(276, 134, 11, 239, NULL, NULL, 'SYSTEM', NULL),
(277, 135, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(278, 135, 15, 345, NULL, NULL, 'SYSTEM', NULL),
(279, 135, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(280, 136, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(281, 136, 15, 345, NULL, NULL, 'SYSTEM', NULL),
(282, 136, 11, 238, NULL, NULL, 'SYSTEM', NULL),
(283, 137, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(284, 137, 15, 346, NULL, NULL, 'SYSTEM', NULL),
(285, 137, 11, 239, NULL, NULL, 'SYSTEM', NULL),
(286, 138, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(287, 138, 15, 346, NULL, NULL, 'SYSTEM', NULL),
(288, 138, 11, 238, NULL, NULL, 'SYSTEM', NULL),
(289, 139, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(290, 139, 15, 346, NULL, NULL, 'SYSTEM', NULL),
(291, 139, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(292, 140, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(293, 140, 15, 286, NULL, NULL, 'SYSTEM', NULL),
(294, 140, 11, 239, NULL, NULL, 'SYSTEM', NULL),
(295, 141, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(296, 141, 15, 286, NULL, NULL, 'SYSTEM', NULL),
(297, 141, 11, 238, NULL, NULL, 'SYSTEM', NULL),
(298, 142, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(299, 142, 15, 286, NULL, NULL, 'SYSTEM', NULL),
(300, 142, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(301, 143, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(302, 143, 15, 287, NULL, NULL, 'SYSTEM', NULL),
(303, 143, 11, 239, NULL, NULL, 'SYSTEM', NULL),
(304, 144, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(305, 144, 15, 287, NULL, NULL, 'SYSTEM', NULL),
(306, 144, 11, 238, NULL, NULL, 'SYSTEM', NULL),
(307, 145, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(308, 145, 15, 287, NULL, NULL, 'SYSTEM', NULL),
(309, 145, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(310, 146, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(311, 146, 15, 288, NULL, NULL, 'SYSTEM', NULL),
(312, 146, 11, 239, NULL, NULL, 'SYSTEM', NULL),
(313, 147, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(314, 147, 15, 288, NULL, NULL, 'SYSTEM', NULL),
(315, 147, 11, 238, NULL, NULL, 'SYSTEM', NULL),
(316, 148, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(317, 148, 15, 288, NULL, NULL, 'SYSTEM', NULL),
(318, 148, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(319, 149, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(320, 149, 15, 289, NULL, NULL, 'SYSTEM', NULL),
(321, 149, 11, 239, NULL, NULL, 'SYSTEM', NULL),
(322, 150, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(323, 150, 15, 289, NULL, NULL, 'SYSTEM', NULL),
(324, 150, 11, 238, NULL, NULL, 'SYSTEM', NULL),
(325, 151, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(326, 151, 15, 289, NULL, NULL, 'SYSTEM', NULL),
(327, 151, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(328, 152, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(329, 152, 15, 290, NULL, NULL, 'SYSTEM', NULL),
(330, 152, 11, 239, NULL, NULL, 'SYSTEM', NULL),
(331, 153, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(332, 153, 15, 290, NULL, NULL, 'SYSTEM', NULL),
(333, 153, 11, 238, NULL, NULL, 'SYSTEM', NULL),
(334, 154, 14, 123, NULL, NULL, 'SYSTEM', NULL),
(335, 154, 15, 290, NULL, NULL, 'SYSTEM', NULL),
(336, 154, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(337, 155, 14, 124, NULL, NULL, 'SYSTEM', NULL),
(338, 155, 15, 291, NULL, NULL, 'SYSTEM', NULL),
(339, 155, 11, 239, NULL, NULL, 'SYSTEM', NULL),
(340, 156, 14, 124, NULL, NULL, 'SYSTEM', NULL),
(341, 156, 15, 291, NULL, NULL, 'SYSTEM', NULL),
(342, 156, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(343, 157, 14, 124, NULL, NULL, 'SYSTEM', NULL),
(344, 157, 15, 292, NULL, NULL, 'SYSTEM', NULL),
(345, 157, 11, 239, NULL, NULL, 'SYSTEM', NULL),
(346, 158, 14, 124, NULL, NULL, 'SYSTEM', NULL),
(347, 158, 15, 292, NULL, NULL, 'SYSTEM', NULL),
(348, 158, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(349, 159, 14, 124, NULL, NULL, 'SYSTEM', NULL),
(350, 159, 15, 294, NULL, NULL, 'SYSTEM', NULL),
(351, 159, 11, 239, NULL, NULL, 'SYSTEM', NULL),
(352, 160, 14, 124, NULL, NULL, 'SYSTEM', NULL),
(353, 160, 15, 294, NULL, NULL, 'SYSTEM', NULL),
(354, 160, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(355, 161, 14, 124, NULL, NULL, 'SYSTEM', NULL),
(356, 161, 15, 295, NULL, NULL, 'SYSTEM', NULL),
(357, 161, 11, 238, NULL, NULL, 'SYSTEM', NULL),
(358, 162, 14, 124, NULL, NULL, 'SYSTEM', NULL),
(359, 162, 15, 295, NULL, NULL, 'SYSTEM', NULL),
(360, 162, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(361, 163, 14, 124, NULL, NULL, 'SYSTEM', NULL),
(362, 163, 15, 296, NULL, NULL, 'SYSTEM', NULL),
(363, 163, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(364, 164, 14, 124, NULL, NULL, 'SYSTEM', NULL),
(365, 164, 15, 296, NULL, NULL, 'SYSTEM', NULL),
(366, 164, 11, 238, NULL, NULL, 'SYSTEM', NULL),
(367, 165, 14, 124, NULL, NULL, 'SYSTEM', NULL),
(368, 165, 15, 296, NULL, NULL, 'SYSTEM', NULL),
(369, 165, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(370, 166, 14, 124, NULL, NULL, 'SYSTEM', NULL),
(371, 166, 15, 297, NULL, NULL, 'SYSTEM', NULL),
(372, 166, 11, 238, NULL, NULL, 'SYSTEM', NULL),
(373, 167, 14, 124, NULL, NULL, 'SYSTEM', NULL),
(374, 167, 15, 297, NULL, NULL, 'SYSTEM', NULL),
(375, 167, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(376, 168, 14, 118, NULL, NULL, 'SYSTEM', NULL),
(377, 168, 15, 304, NULL, NULL, 'SYSTEM', NULL),
(378, 168, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(379, 169, 14, 118, NULL, NULL, 'SYSTEM', NULL),
(380, 169, 15, 304, NULL, NULL, 'SYSTEM', NULL),
(381, 169, 11, 238, NULL, NULL, 'SYSTEM', NULL),
(382, 170, 14, 118, NULL, NULL, 'SYSTEM', NULL),
(383, 170, 15, 304, NULL, NULL, 'SYSTEM', NULL),
(384, 170, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(385, 171, 14, 118, NULL, NULL, 'SYSTEM', NULL),
(386, 171, 15, 305, NULL, NULL, 'SYSTEM', NULL),
(387, 171, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(388, 172, 14, 118, NULL, NULL, 'SYSTEM', NULL),
(389, 172, 15, 305, NULL, NULL, 'SYSTEM', NULL),
(390, 172, 11, 238, NULL, NULL, 'SYSTEM', NULL),
(391, 173, 14, 118, NULL, NULL, 'SYSTEM', NULL),
(392, 173, 15, 305, NULL, NULL, 'SYSTEM', NULL),
(393, 173, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(394, 174, 14, 118, NULL, NULL, 'SYSTEM', NULL),
(395, 174, 15, 306, NULL, NULL, 'SYSTEM', NULL),
(396, 174, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(397, 175, 14, 118, NULL, NULL, 'SYSTEM', NULL),
(398, 175, 15, 306, NULL, NULL, 'SYSTEM', NULL),
(399, 175, 11, 238, NULL, NULL, 'SYSTEM', NULL),
(400, 176, 14, 118, NULL, NULL, 'SYSTEM', NULL),
(401, 176, 15, 306, NULL, NULL, 'SYSTEM', NULL),
(402, 176, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(403, 177, 14, 118, NULL, NULL, 'SYSTEM', NULL),
(404, 177, 15, 307, NULL, NULL, 'SYSTEM', NULL),
(405, 177, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(406, 178, 14, 118, NULL, NULL, 'SYSTEM', NULL),
(407, 178, 15, 307, NULL, NULL, 'SYSTEM', NULL),
(408, 178, 11, 238, NULL, NULL, 'SYSTEM', NULL),
(409, 179, 14, 118, NULL, NULL, 'SYSTEM', NULL),
(410, 179, 15, 307, NULL, NULL, 'SYSTEM', NULL),
(411, 179, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(412, 180, 14, 118, NULL, NULL, 'SYSTEM', NULL),
(413, 180, 15, 308, NULL, NULL, 'SYSTEM', NULL),
(414, 180, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(415, 181, 14, 118, NULL, NULL, 'SYSTEM', NULL),
(416, 181, 15, 308, NULL, NULL, 'SYSTEM', NULL),
(417, 181, 11, 238, NULL, NULL, 'SYSTEM', NULL),
(418, 182, 14, 127, NULL, NULL, 'SYSTEM', NULL),
(419, 182, 15, 322, NULL, NULL, 'SYSTEM', NULL),
(420, 182, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(421, 183, 14, 127, NULL, NULL, 'SYSTEM', NULL),
(422, 183, 15, 322, NULL, NULL, 'SYSTEM', NULL),
(423, 183, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(424, 184, 14, 127, NULL, NULL, 'SYSTEM', NULL),
(425, 184, 15, 323, NULL, NULL, 'SYSTEM', NULL),
(426, 184, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(427, 185, 14, 127, NULL, NULL, 'SYSTEM', NULL),
(428, 185, 15, 323, NULL, NULL, 'SYSTEM', NULL),
(429, 185, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(430, 186, 14, 128, NULL, NULL, 'SYSTEM', NULL),
(431, 186, 15, 325, NULL, NULL, 'SYSTEM', NULL),
(432, 186, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(433, 187, 14, 128, NULL, NULL, 'SYSTEM', NULL),
(434, 187, 15, 325, NULL, NULL, 'SYSTEM', NULL),
(435, 187, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(436, 188, 14, 128, NULL, NULL, 'SYSTEM', NULL),
(437, 188, 15, 328, NULL, NULL, 'SYSTEM', NULL),
(438, 188, 11, 241, NULL, NULL, 'SYSTEM', NULL),
(439, 189, 14, 128, NULL, NULL, 'SYSTEM', NULL),
(440, 189, 15, 328, NULL, NULL, 'SYSTEM', NULL),
(441, 189, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(442, 190, 14, 129, NULL, NULL, 'SYSTEM', NULL),
(443, 190, 15, 332, NULL, NULL, 'SYSTEM', NULL),
(444, 190, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(445, 191, 14, 129, NULL, NULL, 'SYSTEM', NULL),
(446, 191, 15, 332, NULL, NULL, 'SYSTEM', NULL),
(447, 191, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(448, 192, 14, 129, NULL, NULL, 'SYSTEM', NULL),
(449, 192, 15, 333, NULL, NULL, 'SYSTEM', NULL),
(450, 192, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(451, 193, 14, 129, NULL, NULL, 'SYSTEM', NULL),
(452, 193, 15, 333, NULL, NULL, 'SYSTEM', NULL),
(453, 193, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(454, 194, 14, 130, NULL, NULL, 'SYSTEM', NULL),
(455, 194, 15, 334, NULL, NULL, 'SYSTEM', NULL),
(456, 194, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(457, 195, 14, 130, NULL, NULL, 'SYSTEM', NULL),
(458, 195, 15, 334, NULL, NULL, 'SYSTEM', NULL),
(459, 195, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(460, 196, 14, 130, NULL, NULL, 'SYSTEM', NULL),
(461, 196, 15, 335, NULL, NULL, 'SYSTEM', NULL),
(462, 196, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(463, 197, 14, 130, NULL, NULL, 'SYSTEM', NULL),
(464, 197, 15, 335, NULL, NULL, 'SYSTEM', NULL),
(465, 197, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(466, 198, 14, 130, NULL, NULL, 'SYSTEM', NULL),
(467, 198, 15, 336, NULL, NULL, 'SYSTEM', NULL),
(468, 198, 11, 243, NULL, NULL, 'SYSTEM', NULL),
(469, 199, 14, 130, NULL, NULL, 'SYSTEM', NULL),
(470, 199, 15, 336, NULL, NULL, 'SYSTEM', NULL),
(471, 199, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(472, 200, 14, 130, NULL, NULL, 'SYSTEM', NULL),
(473, 200, 15, 336, NULL, NULL, 'SYSTEM', NULL),
(474, 200, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(475, 201, 14, 130, NULL, NULL, 'SYSTEM', NULL),
(476, 201, 15, 337, NULL, NULL, 'SYSTEM', NULL),
(477, 201, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(478, 202, 14, 130, NULL, NULL, 'SYSTEM', NULL),
(479, 202, 15, 337, NULL, NULL, 'SYSTEM', NULL),
(480, 202, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(481, 203, 14, 120, NULL, NULL, 'SYSTEM', NULL),
(482, 203, 15, 339, NULL, NULL, 'SYSTEM', NULL),
(483, 203, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(484, 204, 14, 120, NULL, NULL, 'SYSTEM', NULL),
(485, 204, 15, 339, NULL, NULL, 'SYSTEM', NULL),
(486, 204, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(487, 205, 14, 126, NULL, NULL, 'SYSTEM', NULL),
(488, 205, 15, 341, NULL, NULL, 'SYSTEM', NULL),
(489, 205, 11, 240, NULL, NULL, 'SYSTEM', NULL),
(490, 206, 14, 126, NULL, NULL, 'SYSTEM', NULL),
(491, 206, 15, 341, NULL, NULL, 'SYSTEM', NULL),
(492, 206, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(493, 207, 14, 126, NULL, NULL, 'SYSTEM', NULL),
(494, 207, 15, 341, NULL, NULL, 'SYSTEM', NULL),
(495, 207, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(496, 208, 14, 126, NULL, NULL, 'SYSTEM', NULL),
(497, 208, 15, 342, NULL, NULL, 'SYSTEM', NULL),
(498, 208, 11, 241, NULL, NULL, 'SYSTEM', NULL),
(499, 209, 14, 126, NULL, NULL, 'SYSTEM', NULL),
(500, 209, 15, 342, NULL, NULL, 'SYSTEM', NULL),
(501, 209, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(502, 210, 14, 126, NULL, NULL, 'SYSTEM', NULL),
(503, 210, 15, 342, NULL, NULL, 'SYSTEM', NULL),
(504, 210, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(505, 211, 14, 126, NULL, NULL, 'SYSTEM', NULL),
(506, 211, 15, 343, NULL, NULL, 'SYSTEM', NULL),
(507, 211, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(508, 212, 14, 126, NULL, NULL, 'SYSTEM', NULL),
(509, 212, 15, 343, NULL, NULL, 'SYSTEM', NULL),
(510, 212, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(511, 213, 14, 126, NULL, NULL, 'SYSTEM', NULL),
(512, 213, 15, 344, NULL, NULL, 'SYSTEM', NULL),
(513, 213, 11, 242, NULL, NULL, 'SYSTEM', NULL),
(514, 214, 14, 126, NULL, NULL, 'SYSTEM', NULL),
(515, 214, 15, 344, NULL, NULL, 'SYSTEM', NULL),
(516, 214, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(517, 215, 14, 126, NULL, NULL, 'SYSTEM', NULL),
(518, 215, 15, 344, NULL, NULL, 'SYSTEM', NULL),
(519, 215, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(520, 216, 14, 119, NULL, NULL, 'SYSTEM', NULL),
(521, 216, 15, 347, NULL, NULL, 'SYSTEM', NULL),
(522, 216, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(523, 217, 14, 119, NULL, NULL, 'SYSTEM', NULL),
(524, 217, 15, 348, NULL, NULL, 'SYSTEM', NULL),
(525, 217, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(526, 218, 14, 119, NULL, NULL, 'SYSTEM', NULL),
(527, 218, 15, 349, NULL, NULL, 'SYSTEM', NULL),
(528, 218, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(529, 219, 14, 132, NULL, NULL, 'SYSTEM', NULL),
(530, 219, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(531, 219, 11, 245, NULL, NULL, 'SYSTEM', NULL),
(532, 220, 14, 132, NULL, NULL, 'SYSTEM', NULL),
(533, 220, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(534, 220, 11, 245, NULL, NULL, 'SYSTEM', NULL),
(535, 221, 14, 132, NULL, NULL, 'SYSTEM', NULL),
(536, 221, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(537, 221, 11, 245, NULL, NULL, 'SYSTEM', NULL),
(538, 222, 14, 119, NULL, NULL, 'SYSTEM', NULL),
(539, 222, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(540, 222, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(541, 223, 14, 131, NULL, NULL, 'SYSTEM', NULL),
(542, 223, 3, 265, NULL, NULL, 'SYSTEM', NULL),
(543, 223, 11, 245, NULL, NULL, 'SYSTEM', NULL),
(544, 224, 14, 131, NULL, NULL, 'SYSTEM', NULL),
(545, 224, 3, 114, NULL, NULL, 'SYSTEM', NULL),
(546, 224, 11, 245, NULL, NULL, 'SYSTEM', NULL),
(547, 225, 14, 131, NULL, NULL, 'SYSTEM', NULL),
(548, 225, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(549, 225, 11, 245, NULL, NULL, 'SYSTEM', NULL),
(550, 226, 14, 131, NULL, NULL, 'SYSTEM', NULL),
(551, 226, 3, 113, NULL, NULL, 'SYSTEM', NULL),
(552, 226, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(553, 227, 14, 131, NULL, NULL, 'SYSTEM', NULL),
(554, 227, 3, 265, NULL, NULL, 'SYSTEM', NULL),
(555, 227, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(556, 228, 14, 131, NULL, NULL, 'SYSTEM', NULL),
(557, 228, 3, 114, NULL, NULL, 'SYSTEM', NULL),
(558, 228, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(559, 229, 14, 137, NULL, NULL, 'SYSTEM', NULL),
(560, 229, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(561, 230, 14, 138, NULL, NULL, 'SYSTEM', NULL),
(562, 230, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(563, 231, 14, 139, NULL, NULL, 'SYSTEM', NULL),
(564, 231, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(565, 232, 14, 140, NULL, NULL, 'SYSTEM', NULL),
(566, 232, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(567, 233, 14, 141, NULL, NULL, 'SYSTEM', NULL),
(568, 233, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(569, 234, 14, 142, NULL, NULL, 'SYSTEM', NULL),
(570, 234, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(571, 235, 14, 143, NULL, NULL, 'SYSTEM', NULL),
(572, 235, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(573, 236, 14, 144, NULL, NULL, 'SYSTEM', NULL),
(574, 236, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(575, 237, 14, 145, NULL, NULL, 'SYSTEM', NULL),
(576, 237, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(577, 238, 14, 146, NULL, NULL, 'SYSTEM', NULL),
(578, 238, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(579, 239, 14, 147, NULL, NULL, 'SYSTEM', NULL),
(580, 239, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(581, 240, 14, 148, NULL, NULL, 'SYSTEM', NULL),
(582, 240, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(583, 241, 14, 149, NULL, NULL, 'SYSTEM', NULL),
(584, 241, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(585, 242, 14, 150, NULL, NULL, 'SYSTEM', NULL),
(586, 242, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(587, 243, 14, 151, NULL, NULL, 'SYSTEM', NULL),
(588, 243, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(589, 244, 14, 152, NULL, NULL, 'SYSTEM', NULL),
(590, 244, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(591, 245, 14, 153, NULL, NULL, 'SYSTEM', NULL),
(592, 245, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(593, 246, 14, 154, NULL, NULL, 'SYSTEM', NULL),
(594, 246, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(595, 247, 14, 155, NULL, NULL, 'SYSTEM', NULL),
(596, 247, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(597, 248, 14, 156, NULL, NULL, 'SYSTEM', NULL),
(598, 248, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(599, 249, 14, 157, NULL, NULL, 'SYSTEM', NULL),
(600, 249, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(601, 250, 14, 158, NULL, NULL, 'SYSTEM', NULL),
(602, 250, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(603, 251, 14, 159, NULL, NULL, 'SYSTEM', NULL),
(604, 251, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(605, 252, 14, 160, NULL, NULL, 'SYSTEM', NULL),
(606, 252, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(607, 253, 14, 161, NULL, NULL, 'SYSTEM', NULL),
(608, 253, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(609, 254, 14, 162, NULL, NULL, 'SYSTEM', NULL),
(610, 254, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(611, 255, 14, 163, NULL, NULL, 'SYSTEM', NULL),
(612, 255, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(613, 256, 14, 164, NULL, NULL, 'SYSTEM', NULL),
(614, 256, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(615, 257, 14, 165, NULL, NULL, 'SYSTEM', NULL),
(616, 257, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(617, 258, 14, 166, NULL, NULL, 'SYSTEM', NULL),
(618, 258, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(619, 259, 14, 167, NULL, NULL, 'SYSTEM', NULL),
(620, 259, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(621, 260, 14, 168, NULL, NULL, 'SYSTEM', NULL),
(622, 260, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(623, 261, 14, 169, NULL, NULL, 'SYSTEM', NULL),
(624, 261, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(625, 262, 14, 170, NULL, NULL, 'SYSTEM', NULL),
(626, 262, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(627, 263, 14, 171, NULL, NULL, 'SYSTEM', NULL),
(628, 263, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(629, 264, 14, 172, NULL, NULL, 'SYSTEM', NULL),
(630, 264, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(631, 265, 14, 173, NULL, NULL, 'SYSTEM', NULL),
(632, 265, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(633, 266, 14, 174, NULL, NULL, 'SYSTEM', NULL),
(634, 266, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(635, 267, 14, 175, NULL, NULL, 'SYSTEM', NULL),
(636, 267, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(637, 268, 14, 176, NULL, NULL, 'SYSTEM', NULL),
(638, 268, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(639, 269, 14, 177, NULL, NULL, 'SYSTEM', NULL),
(640, 269, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(641, 270, 14, 178, NULL, NULL, 'SYSTEM', NULL),
(642, 270, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(643, 271, 14, 179, NULL, NULL, 'SYSTEM', NULL),
(644, 271, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(645, 272, 14, 180, NULL, NULL, 'SYSTEM', NULL),
(646, 272, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(647, 273, 14, 181, NULL, NULL, 'SYSTEM', NULL),
(648, 273, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(649, 274, 14, 182, NULL, NULL, 'SYSTEM', NULL),
(650, 274, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(651, 275, 14, 183, NULL, NULL, 'SYSTEM', NULL),
(652, 275, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(653, 276, 14, 184, NULL, NULL, 'SYSTEM', NULL),
(654, 276, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(655, 277, 14, 185, NULL, NULL, 'SYSTEM', NULL),
(656, 277, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(657, 278, 14, 186, NULL, NULL, 'SYSTEM', NULL),
(658, 278, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(659, 279, 14, 187, NULL, NULL, 'SYSTEM', NULL),
(660, 279, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(661, 280, 14, 188, NULL, NULL, 'SYSTEM', NULL),
(662, 280, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(663, 281, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(664, 281, 15, 350, NULL, NULL, 'SYSTEM', NULL),
(665, 281, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(666, 282, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(667, 282, 15, 351, NULL, NULL, 'SYSTEM', NULL),
(668, 282, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(669, 283, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(670, 283, 15, 352, NULL, NULL, 'SYSTEM', NULL),
(671, 283, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(672, 284, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(673, 284, 15, 353, NULL, NULL, 'SYSTEM', NULL),
(674, 284, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(675, 285, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(676, 285, 15, 354, NULL, NULL, 'SYSTEM', NULL),
(677, 285, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(678, 286, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(679, 286, 15, 355, NULL, NULL, 'SYSTEM', NULL),
(680, 286, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(681, 287, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(682, 287, 15, 356, NULL, NULL, 'SYSTEM', NULL),
(683, 287, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(684, 288, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(685, 288, 15, 357, NULL, NULL, 'SYSTEM', NULL),
(686, 288, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(687, 289, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(688, 289, 15, 358, NULL, NULL, 'SYSTEM', NULL),
(689, 289, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(690, 290, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(691, 290, 15, 359, NULL, NULL, 'SYSTEM', NULL),
(692, 290, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(693, 291, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(694, 291, 15, 360, NULL, NULL, 'SYSTEM', NULL),
(695, 291, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(696, 292, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(697, 292, 15, 361, NULL, NULL, 'SYSTEM', NULL),
(698, 292, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(699, 293, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(700, 293, 15, 362, NULL, NULL, 'SYSTEM', NULL),
(701, 293, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(702, 294, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(703, 294, 15, 363, NULL, NULL, 'SYSTEM', NULL),
(704, 294, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(705, 295, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(706, 295, 15, 364, NULL, NULL, 'SYSTEM', NULL),
(707, 295, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(708, 296, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(709, 296, 15, 365, NULL, NULL, 'SYSTEM', NULL),
(710, 296, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(711, 297, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(712, 297, 15, 366, NULL, NULL, 'SYSTEM', NULL),
(713, 297, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(714, 298, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(715, 298, 15, 367, NULL, NULL, 'SYSTEM', NULL),
(716, 298, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(717, 299, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(718, 299, 15, 368, NULL, NULL, 'SYSTEM', NULL),
(719, 299, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(720, 300, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(721, 300, 15, 369, NULL, NULL, 'SYSTEM', NULL),
(722, 300, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(723, 301, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(724, 301, 15, 370, NULL, NULL, 'SYSTEM', NULL),
(725, 301, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(726, 302, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(727, 302, 15, 371, NULL, NULL, 'SYSTEM', NULL),
(728, 302, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(729, 303, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(730, 303, 15, 372, NULL, NULL, 'SYSTEM', NULL),
(731, 303, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(732, 304, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(733, 304, 15, 373, NULL, NULL, 'SYSTEM', NULL),
(734, 304, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(735, 305, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(736, 305, 15, 374, NULL, NULL, 'SYSTEM', NULL),
(737, 305, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(738, 306, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(739, 306, 15, 375, NULL, NULL, 'SYSTEM', NULL),
(740, 306, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(741, 307, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(742, 307, 15, 376, NULL, NULL, 'SYSTEM', NULL),
(743, 307, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(744, 308, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(745, 308, 15, 377, NULL, NULL, 'SYSTEM', NULL),
(746, 308, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(747, 309, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(748, 309, 15, 378, NULL, NULL, 'SYSTEM', NULL),
(749, 309, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(750, 310, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(751, 310, 15, 379, NULL, NULL, 'SYSTEM', NULL),
(752, 310, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(753, 311, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(754, 311, 15, 380, NULL, NULL, 'SYSTEM', NULL),
(755, 311, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(756, 312, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(757, 312, 15, 381, NULL, NULL, 'SYSTEM', NULL),
(758, 312, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(759, 313, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(760, 313, 15, 382, NULL, NULL, 'SYSTEM', NULL),
(761, 313, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(762, 314, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(763, 314, 15, 383, NULL, NULL, 'SYSTEM', NULL),
(764, 314, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(765, 315, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(766, 315, 15, 384, NULL, NULL, 'SYSTEM', NULL),
(767, 315, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(768, 316, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(769, 316, 15, 385, NULL, NULL, 'SYSTEM', NULL),
(770, 316, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(771, 317, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(772, 317, 15, 386, NULL, NULL, 'SYSTEM', NULL),
(773, 317, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(774, 318, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(775, 318, 15, 387, NULL, NULL, 'SYSTEM', NULL),
(776, 318, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(777, 319, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(778, 319, 15, 388, NULL, NULL, 'SYSTEM', NULL),
(779, 319, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(780, 320, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(781, 320, 15, 389, NULL, NULL, 'SYSTEM', NULL),
(782, 320, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(783, 321, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(784, 321, 15, 390, NULL, NULL, 'SYSTEM', NULL),
(785, 321, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(786, 322, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(787, 322, 15, 391, NULL, NULL, 'SYSTEM', NULL),
(788, 322, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(789, 323, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(790, 323, 15, 392, NULL, NULL, 'SYSTEM', NULL),
(791, 323, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(792, 324, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(793, 324, 15, 393, NULL, NULL, 'SYSTEM', NULL),
(794, 324, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(795, 325, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(796, 325, 15, 394, NULL, NULL, 'SYSTEM', NULL),
(797, 325, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(798, 326, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(799, 326, 15, 395, NULL, NULL, 'SYSTEM', NULL),
(800, 326, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(801, 327, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(802, 327, 15, 396, NULL, NULL, 'SYSTEM', NULL),
(803, 327, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(804, 328, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(805, 328, 15, 397, NULL, NULL, 'SYSTEM', NULL),
(806, 328, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(807, 329, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(808, 329, 15, 398, NULL, NULL, 'SYSTEM', NULL),
(809, 329, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(810, 330, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(811, 330, 15, 399, NULL, NULL, 'SYSTEM', NULL),
(812, 330, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(813, 331, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(814, 331, 15, 400, NULL, NULL, 'SYSTEM', NULL),
(815, 331, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(816, 332, 14, 189, NULL, NULL, 'SYSTEM', NULL),
(817, 332, 15, 401, NULL, NULL, 'SYSTEM', NULL),
(818, 332, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(819, 333, 14, 115, NULL, NULL, 'SYSTEM', NULL),
(820, 333, 15, 116, NULL, NULL, 'SYSTEM', NULL),
(821, 333, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(822, 334, 14, 115, NULL, NULL, 'SYSTEM', NULL),
(823, 334, 15, 402, NULL, NULL, 'SYSTEM', NULL),
(824, 334, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(825, 335, 14, 115, NULL, NULL, 'SYSTEM', NULL),
(826, 335, 15, 403, NULL, NULL, 'SYSTEM', NULL),
(827, 335, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(828, 336, 14, 115, NULL, NULL, 'SYSTEM', NULL),
(829, 336, 15, 404, NULL, NULL, 'SYSTEM', NULL),
(830, 336, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(831, 337, 14, 115, NULL, NULL, 'SYSTEM', NULL),
(832, 337, 15, 405, NULL, NULL, 'SYSTEM', NULL),
(833, 337, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(834, 338, 14, 115, NULL, NULL, 'SYSTEM', NULL),
(835, 338, 15, 406, NULL, NULL, 'SYSTEM', NULL),
(836, 338, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(837, 339, 14, 190, NULL, NULL, 'SYSTEM', NULL),
(838, 339, 15, 407, NULL, NULL, 'SYSTEM', NULL),
(839, 339, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(840, 340, 14, 190, NULL, NULL, 'SYSTEM', NULL),
(841, 340, 15, 408, NULL, NULL, 'SYSTEM', NULL),
(842, 340, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(843, 341, 14, 190, NULL, NULL, 'SYSTEM', NULL),
(844, 341, 15, 409, NULL, NULL, 'SYSTEM', NULL),
(845, 341, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(846, 342, 14, 190, NULL, NULL, 'SYSTEM', NULL),
(847, 342, 15, 410, NULL, NULL, 'SYSTEM', NULL),
(848, 342, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(849, 343, 14, 190, NULL, NULL, 'SYSTEM', NULL),
(850, 343, 15, 411, NULL, NULL, 'SYSTEM', NULL),
(851, 343, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(852, 344, 14, 190, NULL, NULL, 'SYSTEM', NULL),
(853, 344, 15, 412, NULL, NULL, 'SYSTEM', NULL),
(854, 344, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(855, 345, 14, 191, NULL, NULL, 'SYSTEM', NULL),
(856, 345, 15, 413, NULL, NULL, 'SYSTEM', NULL),
(857, 345, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(858, 346, 14, 191, NULL, NULL, 'SYSTEM', NULL),
(859, 346, 15, 414, NULL, NULL, 'SYSTEM', NULL),
(860, 346, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(861, 347, 14, 191, NULL, NULL, 'SYSTEM', NULL),
(862, 347, 15, 415, NULL, NULL, 'SYSTEM', NULL),
(863, 347, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(864, 348, 14, 191, NULL, NULL, 'SYSTEM', NULL),
(865, 348, 15, 416, NULL, NULL, 'SYSTEM', NULL),
(866, 348, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(867, 349, 14, 191, NULL, NULL, 'SYSTEM', NULL),
(868, 349, 15, 417, NULL, NULL, 'SYSTEM', NULL),
(869, 349, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(870, 350, 14, 192, NULL, NULL, 'SYSTEM', NULL),
(871, 350, 15, 418, NULL, NULL, 'SYSTEM', NULL),
(872, 350, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(873, 351, 14, 192, NULL, NULL, 'SYSTEM', NULL),
(874, 351, 15, 419, NULL, NULL, 'SYSTEM', NULL),
(875, 351, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(876, 352, 14, 192, NULL, NULL, 'SYSTEM', NULL),
(877, 352, 15, 420, NULL, NULL, 'SYSTEM', NULL),
(878, 352, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(879, 353, 14, 192, NULL, NULL, 'SYSTEM', NULL),
(880, 353, 15, 421, NULL, NULL, 'SYSTEM', NULL),
(881, 353, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(882, 354, 14, 192, NULL, NULL, 'SYSTEM', NULL),
(883, 354, 15, 422, NULL, NULL, 'SYSTEM', NULL),
(884, 354, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(885, 355, 14, 192, NULL, NULL, 'SYSTEM', NULL),
(886, 355, 15, 423, NULL, NULL, 'SYSTEM', NULL),
(887, 355, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(888, 356, 14, 193, NULL, NULL, 'SYSTEM', NULL),
(889, 356, 15, 424, NULL, NULL, 'SYSTEM', NULL),
(890, 356, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(891, 357, 14, 193, NULL, NULL, 'SYSTEM', NULL),
(892, 357, 15, 425, NULL, NULL, 'SYSTEM', NULL),
(893, 357, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(894, 358, 14, 193, NULL, NULL, 'SYSTEM', NULL),
(895, 358, 15, 426, NULL, NULL, 'SYSTEM', NULL),
(896, 358, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(897, 359, 14, 193, NULL, NULL, 'SYSTEM', NULL),
(898, 359, 15, 427, NULL, NULL, 'SYSTEM', NULL),
(899, 359, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(900, 360, 14, 193, NULL, NULL, 'SYSTEM', NULL),
(901, 360, 15, 428, NULL, NULL, 'SYSTEM', NULL),
(902, 360, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(903, 361, 14, 193, NULL, NULL, 'SYSTEM', NULL),
(904, 361, 15, 429, NULL, NULL, 'SYSTEM', NULL),
(905, 361, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(906, 362, 14, 193, NULL, NULL, 'SYSTEM', NULL),
(907, 362, 15, 430, NULL, NULL, 'SYSTEM', NULL),
(908, 362, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(909, 363, 14, 193, NULL, NULL, 'SYSTEM', NULL),
(910, 363, 15, 431, NULL, NULL, 'SYSTEM', NULL),
(911, 363, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(912, 364, 14, 193, NULL, NULL, 'SYSTEM', NULL),
(913, 364, 15, 432, NULL, NULL, 'SYSTEM', NULL),
(914, 364, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(915, 365, 14, 194, NULL, NULL, 'SYSTEM', NULL),
(916, 365, 15, 433, NULL, NULL, 'SYSTEM', NULL),
(917, 365, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(918, 366, 14, 194, NULL, NULL, 'SYSTEM', NULL),
(919, 366, 15, 434, NULL, NULL, 'SYSTEM', NULL),
(920, 366, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(921, 367, 14, 194, NULL, NULL, 'SYSTEM', NULL),
(922, 367, 15, 435, NULL, NULL, 'SYSTEM', NULL),
(923, 367, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(924, 368, 14, 194, NULL, NULL, 'SYSTEM', NULL),
(925, 368, 15, 436, NULL, NULL, 'SYSTEM', NULL),
(926, 368, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(927, 369, 14, 195, NULL, NULL, 'SYSTEM', NULL),
(928, 369, 15, 437, NULL, NULL, 'SYSTEM', NULL),
(929, 369, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(930, 370, 14, 195, NULL, NULL, 'SYSTEM', NULL),
(931, 370, 15, 438, NULL, NULL, 'SYSTEM', NULL),
(932, 370, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(933, 371, 14, 195, NULL, NULL, 'SYSTEM', NULL),
(934, 371, 15, 439, NULL, NULL, 'SYSTEM', NULL),
(935, 371, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(936, 372, 14, 195, NULL, NULL, 'SYSTEM', NULL),
(937, 372, 15, 440, NULL, NULL, 'SYSTEM', NULL),
(938, 372, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(939, 373, 14, 196, NULL, NULL, 'SYSTEM', NULL),
(940, 373, 15, 441, NULL, NULL, 'SYSTEM', NULL),
(941, 373, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(942, 374, 14, 196, NULL, NULL, 'SYSTEM', NULL),
(943, 374, 15, 442, NULL, NULL, 'SYSTEM', NULL),
(944, 374, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(945, 375, 14, 196, NULL, NULL, 'SYSTEM', NULL),
(946, 375, 15, 443, NULL, NULL, 'SYSTEM', NULL),
(947, 375, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(948, 376, 14, 196, NULL, NULL, 'SYSTEM', NULL),
(949, 376, 15, 444, NULL, NULL, 'SYSTEM', NULL),
(950, 376, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(951, 377, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(952, 377, 15, 445, NULL, NULL, 'SYSTEM', NULL),
(953, 377, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(954, 378, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(955, 378, 15, 446, NULL, NULL, 'SYSTEM', NULL),
(956, 378, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(957, 379, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(958, 379, 15, 446, NULL, NULL, 'SYSTEM', NULL),
(959, 379, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(960, 380, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(961, 380, 15, 447, NULL, NULL, 'SYSTEM', NULL),
(962, 380, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(963, 381, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(964, 381, 15, 448, NULL, NULL, 'SYSTEM', NULL),
(965, 381, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(966, 382, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(967, 382, 15, 448, NULL, NULL, 'SYSTEM', NULL),
(968, 382, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(969, 383, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(970, 383, 15, 449, NULL, NULL, 'SYSTEM', NULL),
(971, 383, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(972, 384, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(973, 384, 15, 450, NULL, NULL, 'SYSTEM', NULL),
(974, 384, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(975, 385, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(976, 385, 15, 451, NULL, NULL, 'SYSTEM', NULL),
(977, 385, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(978, 386, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(979, 386, 15, 451, NULL, NULL, 'SYSTEM', NULL),
(980, 386, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(981, 387, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(982, 387, 15, 452, NULL, NULL, 'SYSTEM', NULL),
(983, 387, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(984, 388, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(985, 388, 15, 452, NULL, NULL, 'SYSTEM', NULL),
(986, 388, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(987, 389, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(988, 389, 15, 453, NULL, NULL, 'SYSTEM', NULL),
(989, 389, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(990, 390, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(991, 390, 15, 453, NULL, NULL, 'SYSTEM', NULL),
(992, 390, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(993, 391, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(994, 391, 15, 454, NULL, NULL, 'SYSTEM', NULL),
(995, 391, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(996, 392, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(997, 392, 15, 454, NULL, NULL, 'SYSTEM', NULL),
(998, 392, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(999, 393, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1000, 393, 15, 455, NULL, NULL, 'SYSTEM', NULL),
(1001, 393, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1002, 394, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1003, 394, 15, 455, NULL, NULL, 'SYSTEM', NULL),
(1004, 394, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1005, 395, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1006, 395, 15, 456, NULL, NULL, 'SYSTEM', NULL),
(1007, 395, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1008, 396, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1009, 396, 15, 457, NULL, NULL, 'SYSTEM', NULL),
(1010, 396, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1011, 397, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1012, 397, 15, 458, NULL, NULL, 'SYSTEM', NULL),
(1013, 397, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1014, 398, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1015, 398, 15, 459, NULL, NULL, 'SYSTEM', NULL),
(1016, 398, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1017, 399, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1018, 399, 15, 459, NULL, NULL, 'SYSTEM', NULL),
(1019, 399, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1020, 400, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1021, 400, 15, 460, NULL, NULL, 'SYSTEM', NULL),
(1022, 400, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1023, 401, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1024, 401, 15, 460, NULL, NULL, 'SYSTEM', NULL),
(1025, 401, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1026, 402, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1027, 402, 15, 461, NULL, NULL, 'SYSTEM', NULL),
(1028, 402, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1029, 403, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1030, 403, 15, 461, NULL, NULL, 'SYSTEM', NULL),
(1031, 403, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1032, 404, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1033, 404, 15, 462, NULL, NULL, 'SYSTEM', NULL),
(1034, 404, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1035, 405, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1036, 405, 15, 462, NULL, NULL, 'SYSTEM', NULL),
(1037, 405, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1038, 406, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1039, 406, 15, 463, NULL, NULL, 'SYSTEM', NULL),
(1040, 406, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1041, 407, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1042, 407, 15, 463, NULL, NULL, 'SYSTEM', NULL),
(1043, 407, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1044, 408, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1045, 408, 15, 464, NULL, NULL, 'SYSTEM', NULL),
(1046, 408, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1047, 409, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1048, 409, 15, 465, NULL, NULL, 'SYSTEM', NULL),
(1049, 409, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1050, 410, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1051, 410, 15, 465, NULL, NULL, 'SYSTEM', NULL),
(1052, 410, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1053, 411, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1054, 411, 15, 466, NULL, NULL, 'SYSTEM', NULL),
(1055, 411, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1056, 412, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1057, 412, 15, 466, NULL, NULL, 'SYSTEM', NULL);
INSERT INTO `product_variant_attributes` (`id`, `product_variant_id`, `attribute_master_id`, `attribute_value_id`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1058, 412, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1059, 413, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1060, 413, 15, 467, NULL, NULL, 'SYSTEM', NULL),
(1061, 413, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1062, 414, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1063, 414, 15, 468, NULL, NULL, 'SYSTEM', NULL),
(1064, 414, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1065, 415, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1066, 415, 15, 468, NULL, NULL, 'SYSTEM', NULL),
(1067, 415, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1068, 416, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1069, 416, 15, 469, NULL, NULL, 'SYSTEM', NULL),
(1070, 416, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1071, 417, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1072, 417, 15, 469, NULL, NULL, 'SYSTEM', NULL),
(1073, 417, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1074, 418, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1075, 418, 15, 470, NULL, NULL, 'SYSTEM', NULL),
(1076, 418, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1077, 419, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1078, 419, 15, 471, NULL, NULL, 'SYSTEM', NULL),
(1079, 419, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1080, 420, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1081, 420, 15, 471, NULL, NULL, 'SYSTEM', NULL),
(1082, 420, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1083, 421, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1084, 421, 15, 472, NULL, NULL, 'SYSTEM', NULL),
(1085, 421, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1086, 422, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1087, 422, 15, 473, NULL, NULL, 'SYSTEM', NULL),
(1088, 422, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1089, 423, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1090, 423, 15, 474, NULL, NULL, 'SYSTEM', NULL),
(1091, 423, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1092, 424, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1093, 424, 15, 475, NULL, NULL, 'SYSTEM', NULL),
(1094, 424, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1095, 425, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1096, 425, 15, 476, NULL, NULL, 'SYSTEM', NULL),
(1097, 425, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1098, 426, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1099, 426, 15, 476, NULL, NULL, 'SYSTEM', NULL),
(1100, 426, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1101, 427, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1102, 427, 15, 477, NULL, NULL, 'SYSTEM', NULL),
(1103, 427, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1104, 428, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1105, 428, 15, 477, NULL, NULL, 'SYSTEM', NULL),
(1106, 428, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1107, 429, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1108, 429, 15, 478, NULL, NULL, 'SYSTEM', NULL),
(1109, 429, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1110, 430, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1111, 430, 15, 478, NULL, NULL, 'SYSTEM', NULL),
(1112, 430, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1113, 431, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1114, 431, 15, 479, NULL, NULL, 'SYSTEM', NULL),
(1115, 431, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1116, 432, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1117, 432, 15, 479, NULL, NULL, 'SYSTEM', NULL),
(1118, 432, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1119, 433, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1120, 433, 15, 480, NULL, NULL, 'SYSTEM', NULL),
(1121, 433, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1122, 434, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1123, 434, 15, 480, NULL, NULL, 'SYSTEM', NULL),
(1124, 434, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1125, 435, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1126, 435, 15, 481, NULL, NULL, 'SYSTEM', NULL),
(1127, 435, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1128, 436, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1129, 436, 15, 481, NULL, NULL, 'SYSTEM', NULL),
(1130, 436, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1131, 437, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1132, 437, 15, 482, NULL, NULL, 'SYSTEM', NULL),
(1133, 437, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1134, 438, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1135, 438, 15, 482, NULL, NULL, 'SYSTEM', NULL),
(1136, 438, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1137, 439, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1138, 439, 15, 483, NULL, NULL, 'SYSTEM', NULL),
(1139, 439, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1140, 440, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1141, 440, 15, 483, NULL, NULL, 'SYSTEM', NULL),
(1142, 440, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1143, 441, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1144, 441, 15, 484, NULL, NULL, 'SYSTEM', NULL),
(1145, 441, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1146, 442, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1147, 442, 15, 484, NULL, NULL, 'SYSTEM', NULL),
(1148, 442, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1149, 443, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1150, 443, 15, 485, NULL, NULL, 'SYSTEM', NULL),
(1151, 443, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1152, 444, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1153, 444, 15, 485, NULL, NULL, 'SYSTEM', NULL),
(1154, 444, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1155, 445, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1156, 445, 15, 486, NULL, NULL, 'SYSTEM', NULL),
(1157, 445, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1158, 446, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1159, 446, 15, 486, NULL, NULL, 'SYSTEM', NULL),
(1160, 446, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1161, 447, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1162, 447, 15, 487, NULL, NULL, 'SYSTEM', NULL),
(1163, 447, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1164, 448, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1165, 448, 15, 488, NULL, NULL, 'SYSTEM', NULL),
(1166, 448, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1167, 449, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1168, 449, 15, 488, NULL, NULL, 'SYSTEM', NULL),
(1169, 449, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1170, 450, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1171, 450, 15, 489, NULL, NULL, 'SYSTEM', NULL),
(1172, 450, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1173, 451, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1174, 451, 15, 489, NULL, NULL, 'SYSTEM', NULL),
(1175, 451, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1176, 452, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1177, 452, 15, 490, NULL, NULL, 'SYSTEM', NULL),
(1178, 452, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1179, 453, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1180, 453, 15, 490, NULL, NULL, 'SYSTEM', NULL),
(1181, 453, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1182, 454, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1183, 454, 15, 491, NULL, NULL, 'SYSTEM', NULL),
(1184, 454, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1185, 455, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1186, 455, 15, 491, NULL, NULL, 'SYSTEM', NULL),
(1187, 455, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1188, 456, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1189, 456, 15, 492, NULL, NULL, 'SYSTEM', NULL),
(1190, 456, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1191, 457, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1192, 457, 15, 493, NULL, NULL, 'SYSTEM', NULL),
(1193, 457, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1194, 458, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1195, 458, 15, 493, NULL, NULL, 'SYSTEM', NULL),
(1196, 458, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1197, 459, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1198, 459, 15, 494, NULL, NULL, 'SYSTEM', NULL),
(1199, 459, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1200, 460, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1201, 460, 15, 495, NULL, NULL, 'SYSTEM', NULL),
(1202, 460, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1203, 461, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1204, 461, 15, 495, NULL, NULL, 'SYSTEM', NULL),
(1205, 461, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1206, 462, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1207, 462, 15, 496, NULL, NULL, 'SYSTEM', NULL),
(1208, 462, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1209, 463, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1210, 463, 15, 497, NULL, NULL, 'SYSTEM', NULL),
(1211, 463, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1212, 464, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1213, 464, 15, 497, NULL, NULL, 'SYSTEM', NULL),
(1214, 464, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1215, 465, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1216, 465, 15, 498, NULL, NULL, 'SYSTEM', NULL),
(1217, 465, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1218, 466, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1219, 466, 15, 499, NULL, NULL, 'SYSTEM', NULL),
(1220, 466, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1221, 467, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1222, 467, 15, 500, NULL, NULL, 'SYSTEM', NULL),
(1223, 467, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1224, 468, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1225, 468, 15, 501, NULL, NULL, 'SYSTEM', NULL),
(1226, 468, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1227, 469, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1228, 469, 15, 502, NULL, NULL, 'SYSTEM', NULL),
(1229, 469, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1230, 470, 14, 237, NULL, NULL, 'SYSTEM', NULL),
(1231, 470, 15, 503, NULL, NULL, 'SYSTEM', NULL),
(1232, 470, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1233, 471, 15, 504, NULL, NULL, 'SYSTEM', NULL),
(1234, 471, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1235, 472, 15, 505, NULL, NULL, 'SYSTEM', NULL),
(1236, 472, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1237, 473, 15, 505, NULL, NULL, 'SYSTEM', NULL),
(1238, 473, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1239, 474, 15, 506, NULL, NULL, 'SYSTEM', NULL),
(1240, 474, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1241, 475, 15, 507, NULL, NULL, 'SYSTEM', NULL),
(1242, 475, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1243, 476, 15, 508, NULL, NULL, 'SYSTEM', NULL),
(1244, 476, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1245, 477, 15, 509, NULL, NULL, 'SYSTEM', NULL),
(1246, 477, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1247, 478, 15, 510, NULL, NULL, 'SYSTEM', NULL),
(1248, 478, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1249, 479, 15, 511, NULL, NULL, 'SYSTEM', NULL),
(1250, 479, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1251, 480, 15, 511, NULL, NULL, 'SYSTEM', NULL),
(1252, 480, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1253, 481, 15, 512, NULL, NULL, 'SYSTEM', NULL),
(1254, 481, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1255, 482, 15, 513, NULL, NULL, 'SYSTEM', NULL),
(1256, 482, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1257, 483, 15, 514, NULL, NULL, 'SYSTEM', NULL),
(1258, 483, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1259, 484, 15, 515, NULL, NULL, 'SYSTEM', NULL),
(1260, 484, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1261, 485, 15, 516, NULL, NULL, 'SYSTEM', NULL),
(1262, 485, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1263, 486, 15, 517, NULL, NULL, 'SYSTEM', NULL),
(1264, 486, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1265, 487, 15, 518, NULL, NULL, 'SYSTEM', NULL),
(1266, 487, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1267, 488, 15, 519, NULL, NULL, 'SYSTEM', NULL),
(1268, 488, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1269, 489, 15, 520, NULL, NULL, 'SYSTEM', NULL),
(1270, 489, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1271, 490, 15, 521, NULL, NULL, 'SYSTEM', NULL),
(1272, 490, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1273, 491, 15, 522, NULL, NULL, 'SYSTEM', NULL),
(1274, 491, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1275, 492, 15, 523, NULL, NULL, 'SYSTEM', NULL),
(1276, 492, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1277, 493, 15, 524, NULL, NULL, 'SYSTEM', NULL),
(1278, 493, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1279, 494, 15, 525, NULL, NULL, 'SYSTEM', NULL),
(1280, 494, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1281, 495, 15, 526, NULL, NULL, 'SYSTEM', NULL),
(1282, 495, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1283, 496, 15, 527, NULL, NULL, 'SYSTEM', NULL),
(1284, 496, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1285, 497, 15, 528, NULL, NULL, 'SYSTEM', NULL),
(1286, 497, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1287, 498, 15, 529, NULL, NULL, 'SYSTEM', NULL),
(1288, 498, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1289, 499, 15, 530, NULL, NULL, 'SYSTEM', NULL),
(1290, 499, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1291, 500, 15, 531, NULL, NULL, 'SYSTEM', NULL),
(1292, 500, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1293, 501, 15, 532, NULL, NULL, 'SYSTEM', NULL),
(1294, 501, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1295, 502, 15, 533, NULL, NULL, 'SYSTEM', NULL),
(1296, 502, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1297, 503, 15, 534, NULL, NULL, 'SYSTEM', NULL),
(1298, 503, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1299, 504, 15, 535, NULL, NULL, 'SYSTEM', NULL),
(1300, 504, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1301, 505, 15, 536, NULL, NULL, 'SYSTEM', NULL),
(1302, 505, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1303, 506, 15, 537, NULL, NULL, 'SYSTEM', NULL),
(1304, 506, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1305, 507, 15, 538, NULL, NULL, 'SYSTEM', NULL),
(1306, 507, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1307, 508, 15, 539, NULL, NULL, 'SYSTEM', NULL),
(1308, 508, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1309, 509, 15, 540, NULL, NULL, 'SYSTEM', NULL),
(1310, 509, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1311, 510, 15, 540, NULL, NULL, 'SYSTEM', NULL),
(1312, 510, 11, 247, NULL, NULL, 'SYSTEM', NULL),
(1313, 511, 15, 541, NULL, NULL, 'SYSTEM', NULL),
(1314, 511, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1315, 512, 15, 542, NULL, NULL, 'SYSTEM', NULL),
(1316, 512, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1317, 513, 15, 543, NULL, NULL, 'SYSTEM', NULL),
(1318, 513, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1319, 514, 15, 544, NULL, NULL, 'SYSTEM', NULL),
(1320, 514, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1321, 515, 15, 545, NULL, NULL, 'SYSTEM', NULL),
(1322, 515, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1323, 516, 15, 546, NULL, NULL, 'SYSTEM', NULL),
(1324, 516, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1325, 517, 15, 547, NULL, NULL, 'SYSTEM', NULL),
(1326, 517, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1327, 518, 15, 548, NULL, NULL, 'SYSTEM', NULL),
(1328, 518, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1329, 519, 15, 549, NULL, NULL, 'SYSTEM', NULL),
(1330, 519, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1331, 520, 15, 550, NULL, NULL, 'SYSTEM', NULL),
(1332, 520, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1333, 521, 15, 551, NULL, NULL, 'SYSTEM', NULL),
(1334, 521, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1335, 522, 15, 552, NULL, NULL, 'SYSTEM', NULL),
(1336, 522, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1337, 523, 15, 553, NULL, NULL, 'SYSTEM', NULL),
(1338, 523, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1339, 524, 15, 554, NULL, NULL, 'SYSTEM', NULL),
(1340, 524, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1341, 525, 15, 555, NULL, NULL, 'SYSTEM', NULL),
(1342, 525, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1343, 526, 15, 556, NULL, NULL, 'SYSTEM', NULL),
(1344, 526, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1345, 527, 15, 557, NULL, NULL, 'SYSTEM', NULL),
(1346, 527, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1347, 528, 15, 558, NULL, NULL, 'SYSTEM', NULL),
(1348, 528, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1349, 529, 15, 559, NULL, NULL, 'SYSTEM', NULL),
(1350, 529, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1351, 530, 15, 560, NULL, NULL, 'SYSTEM', NULL),
(1352, 530, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1353, 531, 15, 561, NULL, NULL, 'SYSTEM', NULL),
(1354, 531, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1355, 532, 15, 562, NULL, NULL, 'SYSTEM', NULL),
(1356, 532, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1357, 533, 15, 563, NULL, NULL, 'SYSTEM', NULL),
(1358, 533, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1359, 534, 15, 564, NULL, NULL, 'SYSTEM', NULL),
(1360, 534, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1361, 535, 15, 565, NULL, NULL, 'SYSTEM', NULL),
(1362, 535, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1363, 536, 15, 566, NULL, NULL, 'SYSTEM', NULL),
(1364, 536, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1365, 537, 15, 567, NULL, NULL, 'SYSTEM', NULL),
(1366, 537, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1367, 538, 14, 236, NULL, NULL, 'SYSTEM', NULL),
(1368, 538, 15, 568, NULL, NULL, 'SYSTEM', NULL),
(1369, 538, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(1370, 538, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1371, 539, 14, 236, NULL, NULL, 'SYSTEM', NULL),
(1372, 539, 15, 569, NULL, NULL, 'SYSTEM', NULL),
(1373, 539, 3, 275, NULL, NULL, 'SYSTEM', NULL),
(1374, 539, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1375, 540, 14, 236, NULL, NULL, 'SYSTEM', NULL),
(1376, 540, 15, 570, NULL, NULL, 'SYSTEM', NULL),
(1377, 540, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1378, 540, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1379, 541, 14, 236, NULL, NULL, 'SYSTEM', NULL),
(1380, 541, 15, 571, NULL, NULL, 'SYSTEM', NULL),
(1381, 541, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(1382, 541, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1383, 542, 14, 236, NULL, NULL, 'SYSTEM', NULL),
(1384, 542, 15, 572, NULL, NULL, 'SYSTEM', NULL),
(1385, 542, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(1386, 542, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1387, 543, 14, 236, NULL, NULL, 'SYSTEM', NULL),
(1388, 543, 15, 573, NULL, NULL, 'SYSTEM', NULL),
(1389, 543, 3, 258, NULL, NULL, 'SYSTEM', NULL),
(1390, 543, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1391, 544, 14, 236, NULL, NULL, 'SYSTEM', NULL),
(1392, 544, 15, 574, NULL, NULL, 'SYSTEM', NULL),
(1393, 544, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(1394, 544, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1395, 545, 14, 236, NULL, NULL, 'SYSTEM', NULL),
(1396, 545, 15, 575, NULL, NULL, 'SYSTEM', NULL),
(1397, 545, 3, 264, NULL, NULL, 'SYSTEM', NULL),
(1398, 545, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1399, 546, 14, 236, NULL, NULL, 'SYSTEM', NULL),
(1400, 546, 15, 576, NULL, NULL, 'SYSTEM', NULL),
(1401, 546, 3, 255, NULL, NULL, 'SYSTEM', NULL),
(1402, 546, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1403, 547, 14, 236, NULL, NULL, 'SYSTEM', NULL),
(1404, 547, 15, 577, NULL, NULL, 'SYSTEM', NULL),
(1405, 547, 3, 281, NULL, NULL, 'SYSTEM', NULL),
(1406, 547, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1407, 548, 14, 236, NULL, NULL, 'SYSTEM', NULL),
(1408, 548, 15, 578, NULL, NULL, 'SYSTEM', NULL),
(1409, 548, 3, 256, NULL, NULL, 'SYSTEM', NULL),
(1410, 548, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1411, 549, 14, 236, NULL, NULL, 'SYSTEM', NULL),
(1412, 549, 15, 579, NULL, NULL, 'SYSTEM', NULL),
(1413, 549, 3, 113, NULL, NULL, 'SYSTEM', NULL),
(1414, 549, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1415, 550, 14, 235, NULL, NULL, 'SYSTEM', NULL),
(1416, 550, 15, 580, NULL, NULL, 'SYSTEM', NULL),
(1417, 550, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(1418, 550, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1419, 551, 14, 235, NULL, NULL, 'SYSTEM', NULL),
(1420, 551, 15, 581, NULL, NULL, 'SYSTEM', NULL),
(1421, 551, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1422, 551, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1423, 552, 14, 235, NULL, NULL, 'SYSTEM', NULL),
(1424, 552, 15, 582, NULL, NULL, 'SYSTEM', NULL),
(1425, 552, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(1426, 552, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1427, 553, 14, 235, NULL, NULL, 'SYSTEM', NULL),
(1428, 553, 15, 583, NULL, NULL, 'SYSTEM', NULL),
(1429, 553, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(1430, 553, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1431, 554, 14, 235, NULL, NULL, 'SYSTEM', NULL),
(1432, 554, 15, 584, NULL, NULL, 'SYSTEM', NULL),
(1433, 554, 3, 258, NULL, NULL, 'SYSTEM', NULL),
(1434, 554, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1435, 555, 14, 235, NULL, NULL, 'SYSTEM', NULL),
(1436, 555, 15, 585, NULL, NULL, 'SYSTEM', NULL),
(1437, 555, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(1438, 555, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1439, 556, 14, 235, NULL, NULL, 'SYSTEM', NULL),
(1440, 556, 15, 586, NULL, NULL, 'SYSTEM', NULL),
(1441, 556, 3, 264, NULL, NULL, 'SYSTEM', NULL),
(1442, 556, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1443, 557, 14, 235, NULL, NULL, 'SYSTEM', NULL),
(1444, 557, 15, 587, NULL, NULL, 'SYSTEM', NULL),
(1445, 557, 3, 113, NULL, NULL, 'SYSTEM', NULL),
(1446, 557, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1447, 558, 14, 235, NULL, NULL, 'SYSTEM', NULL),
(1448, 558, 15, 588, NULL, NULL, 'SYSTEM', NULL),
(1449, 558, 3, 256, NULL, NULL, 'SYSTEM', NULL),
(1450, 558, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1451, 559, 14, 234, NULL, NULL, 'SYSTEM', NULL),
(1452, 559, 15, 589, NULL, NULL, 'SYSTEM', NULL),
(1453, 559, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(1454, 559, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1455, 560, 14, 234, NULL, NULL, 'SYSTEM', NULL),
(1456, 560, 15, 590, NULL, NULL, 'SYSTEM', NULL),
(1457, 560, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1458, 560, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1459, 561, 14, 234, NULL, NULL, 'SYSTEM', NULL),
(1460, 561, 15, 591, NULL, NULL, 'SYSTEM', NULL),
(1461, 561, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(1462, 561, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1463, 562, 14, 234, NULL, NULL, 'SYSTEM', NULL),
(1464, 562, 15, 592, NULL, NULL, 'SYSTEM', NULL),
(1465, 562, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(1466, 562, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1467, 563, 14, 234, NULL, NULL, 'SYSTEM', NULL),
(1468, 563, 15, 593, NULL, NULL, 'SYSTEM', NULL),
(1469, 563, 3, 258, NULL, NULL, 'SYSTEM', NULL),
(1470, 563, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1471, 564, 14, 234, NULL, NULL, 'SYSTEM', NULL),
(1472, 564, 15, 594, NULL, NULL, 'SYSTEM', NULL),
(1473, 564, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(1474, 564, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1475, 565, 14, 234, NULL, NULL, 'SYSTEM', NULL),
(1476, 565, 15, 595, NULL, NULL, 'SYSTEM', NULL),
(1477, 565, 3, 264, NULL, NULL, 'SYSTEM', NULL),
(1478, 565, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1479, 566, 14, 234, NULL, NULL, 'SYSTEM', NULL),
(1480, 566, 15, 596, NULL, NULL, 'SYSTEM', NULL),
(1481, 566, 3, 113, NULL, NULL, 'SYSTEM', NULL),
(1482, 566, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1483, 567, 14, 234, NULL, NULL, 'SYSTEM', NULL),
(1484, 567, 15, 597, NULL, NULL, 'SYSTEM', NULL),
(1485, 567, 3, 256, NULL, NULL, 'SYSTEM', NULL),
(1486, 567, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1487, 568, 14, 233, NULL, NULL, 'SYSTEM', NULL),
(1488, 568, 15, 598, NULL, NULL, 'SYSTEM', NULL),
(1489, 568, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(1490, 568, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1491, 569, 14, 233, NULL, NULL, 'SYSTEM', NULL),
(1492, 569, 15, 599, NULL, NULL, 'SYSTEM', NULL),
(1493, 569, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1494, 569, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1495, 570, 14, 233, NULL, NULL, 'SYSTEM', NULL),
(1496, 570, 15, 600, NULL, NULL, 'SYSTEM', NULL),
(1497, 570, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(1498, 570, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1499, 571, 14, 233, NULL, NULL, 'SYSTEM', NULL),
(1500, 571, 15, 601, NULL, NULL, 'SYSTEM', NULL),
(1501, 571, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(1502, 571, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1503, 572, 14, 233, NULL, NULL, 'SYSTEM', NULL),
(1504, 572, 15, 602, NULL, NULL, 'SYSTEM', NULL),
(1505, 572, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(1506, 572, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1507, 573, 14, 233, NULL, NULL, 'SYSTEM', NULL),
(1508, 573, 15, 603, NULL, NULL, 'SYSTEM', NULL),
(1509, 573, 3, 269, NULL, NULL, 'SYSTEM', NULL),
(1510, 573, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1511, 574, 14, 232, NULL, NULL, 'SYSTEM', NULL),
(1512, 574, 15, 604, NULL, NULL, 'SYSTEM', NULL),
(1513, 574, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(1514, 574, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1515, 575, 14, 232, NULL, NULL, 'SYSTEM', NULL),
(1516, 575, 15, 605, NULL, NULL, 'SYSTEM', NULL),
(1517, 575, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1518, 575, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1519, 576, 14, 232, NULL, NULL, 'SYSTEM', NULL),
(1520, 576, 15, 606, NULL, NULL, 'SYSTEM', NULL),
(1521, 576, 3, 258, NULL, NULL, 'SYSTEM', NULL),
(1522, 576, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1523, 577, 14, 231, NULL, NULL, 'SYSTEM', NULL),
(1524, 577, 15, 607, NULL, NULL, 'SYSTEM', NULL),
(1525, 577, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(1526, 577, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1527, 578, 14, 231, NULL, NULL, 'SYSTEM', NULL),
(1528, 578, 15, 608, NULL, NULL, 'SYSTEM', NULL),
(1529, 578, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1530, 578, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1531, 579, 14, 231, NULL, NULL, 'SYSTEM', NULL),
(1532, 579, 15, 609, NULL, NULL, 'SYSTEM', NULL),
(1533, 579, 3, 264, NULL, NULL, 'SYSTEM', NULL),
(1534, 579, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1535, 580, 14, 231, NULL, NULL, 'SYSTEM', NULL),
(1536, 580, 15, 610, NULL, NULL, 'SYSTEM', NULL),
(1537, 580, 3, 258, NULL, NULL, 'SYSTEM', NULL),
(1538, 580, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1539, 581, 14, 230, NULL, NULL, 'SYSTEM', NULL),
(1540, 581, 15, 611, NULL, NULL, 'SYSTEM', NULL),
(1541, 581, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(1542, 581, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1543, 582, 14, 230, NULL, NULL, 'SYSTEM', NULL),
(1544, 582, 15, 612, NULL, NULL, 'SYSTEM', NULL),
(1545, 582, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1546, 582, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1547, 583, 14, 230, NULL, NULL, 'SYSTEM', NULL),
(1548, 583, 15, 613, NULL, NULL, 'SYSTEM', NULL),
(1549, 583, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(1550, 583, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1551, 584, 14, 229, NULL, NULL, 'SYSTEM', NULL),
(1552, 584, 15, 614, NULL, NULL, 'SYSTEM', NULL),
(1553, 584, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(1554, 584, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1555, 585, 14, 229, NULL, NULL, 'SYSTEM', NULL),
(1556, 585, 15, 615, NULL, NULL, 'SYSTEM', NULL),
(1557, 585, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1558, 585, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1559, 586, 14, 229, NULL, NULL, 'SYSTEM', NULL),
(1560, 586, 15, 616, NULL, NULL, 'SYSTEM', NULL),
(1561, 586, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(1562, 586, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1563, 587, 14, 228, NULL, NULL, 'SYSTEM', NULL),
(1564, 587, 15, 617, NULL, NULL, 'SYSTEM', NULL),
(1565, 587, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(1566, 587, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1567, 588, 14, 228, NULL, NULL, 'SYSTEM', NULL),
(1568, 588, 15, 618, NULL, NULL, 'SYSTEM', NULL),
(1569, 588, 3, 114, NULL, NULL, 'SYSTEM', NULL),
(1570, 588, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1571, 589, 14, 228, NULL, NULL, 'SYSTEM', NULL),
(1572, 589, 15, 619, NULL, NULL, 'SYSTEM', NULL),
(1573, 589, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1574, 589, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1575, 590, 14, 227, NULL, NULL, 'SYSTEM', NULL),
(1576, 590, 15, 620, NULL, NULL, 'SYSTEM', NULL),
(1577, 590, 3, 277, NULL, NULL, 'SYSTEM', NULL),
(1578, 590, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1579, 591, 14, 227, NULL, NULL, 'SYSTEM', NULL),
(1580, 591, 15, 621, NULL, NULL, 'SYSTEM', NULL),
(1581, 591, 3, 284, NULL, NULL, 'SYSTEM', NULL),
(1582, 591, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1583, 592, 14, 205, NULL, NULL, 'SYSTEM', NULL),
(1584, 592, 15, 622, NULL, NULL, 'SYSTEM', NULL),
(1585, 592, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(1586, 592, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1587, 593, 14, 205, NULL, NULL, 'SYSTEM', NULL),
(1588, 593, 15, 623, NULL, NULL, 'SYSTEM', NULL),
(1589, 593, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1590, 593, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1591, 594, 14, 205, NULL, NULL, 'SYSTEM', NULL),
(1592, 594, 15, 624, NULL, NULL, 'SYSTEM', NULL),
(1593, 594, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(1594, 594, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1595, 595, 14, 205, NULL, NULL, 'SYSTEM', NULL),
(1596, 595, 15, 625, NULL, NULL, 'SYSTEM', NULL),
(1597, 595, 3, 266, NULL, NULL, 'SYSTEM', NULL),
(1598, 595, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1599, 596, 14, 205, NULL, NULL, 'SYSTEM', NULL),
(1600, 596, 15, 626, NULL, NULL, 'SYSTEM', NULL),
(1601, 596, 3, 280, NULL, NULL, 'SYSTEM', NULL),
(1602, 596, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1603, 597, 14, 205, NULL, NULL, 'SYSTEM', NULL),
(1604, 597, 15, 627, NULL, NULL, 'SYSTEM', NULL),
(1605, 597, 3, 256, NULL, NULL, 'SYSTEM', NULL),
(1606, 597, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1607, 598, 14, 226, NULL, NULL, 'SYSTEM', NULL),
(1608, 598, 15, 628, NULL, NULL, 'SYSTEM', NULL),
(1609, 598, 3, 273, NULL, NULL, 'SYSTEM', NULL),
(1610, 598, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1611, 599, 14, 226, NULL, NULL, 'SYSTEM', NULL),
(1612, 599, 15, 629, NULL, NULL, 'SYSTEM', NULL),
(1613, 599, 3, 113, NULL, NULL, 'SYSTEM', NULL),
(1614, 599, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1615, 600, 14, 226, NULL, NULL, 'SYSTEM', NULL),
(1616, 600, 15, 630, NULL, NULL, 'SYSTEM', NULL),
(1617, 600, 3, 255, NULL, NULL, 'SYSTEM', NULL),
(1618, 600, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1619, 601, 14, 225, NULL, NULL, 'SYSTEM', NULL),
(1620, 601, 15, 631, NULL, NULL, 'SYSTEM', NULL),
(1621, 601, 3, 275, NULL, NULL, 'SYSTEM', NULL),
(1622, 601, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1623, 602, 14, 225, NULL, NULL, 'SYSTEM', NULL),
(1624, 602, 15, 632, NULL, NULL, 'SYSTEM', NULL),
(1625, 602, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1626, 602, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1627, 603, 14, 225, NULL, NULL, 'SYSTEM', NULL),
(1628, 603, 15, 633, NULL, NULL, 'SYSTEM', NULL),
(1629, 603, 3, 273, NULL, NULL, 'SYSTEM', NULL),
(1630, 603, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1631, 604, 14, 225, NULL, NULL, 'SYSTEM', NULL),
(1632, 604, 15, 634, NULL, NULL, 'SYSTEM', NULL),
(1633, 604, 3, 270, NULL, NULL, 'SYSTEM', NULL),
(1634, 604, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1635, 605, 14, 225, NULL, NULL, 'SYSTEM', NULL),
(1636, 605, 15, 635, NULL, NULL, 'SYSTEM', NULL),
(1637, 605, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(1638, 605, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1639, 606, 14, 225, NULL, NULL, 'SYSTEM', NULL),
(1640, 606, 15, 636, NULL, NULL, 'SYSTEM', NULL),
(1641, 606, 3, 264, NULL, NULL, 'SYSTEM', NULL),
(1642, 606, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1643, 607, 14, 225, NULL, NULL, 'SYSTEM', NULL),
(1644, 607, 15, 637, NULL, NULL, 'SYSTEM', NULL),
(1645, 607, 3, 276, NULL, NULL, 'SYSTEM', NULL),
(1646, 607, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1647, 608, 14, 225, NULL, NULL, 'SYSTEM', NULL),
(1648, 608, 15, 638, NULL, NULL, 'SYSTEM', NULL),
(1649, 608, 3, 113, NULL, NULL, 'SYSTEM', NULL),
(1650, 608, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1651, 609, 14, 225, NULL, NULL, 'SYSTEM', NULL),
(1652, 609, 15, 639, NULL, NULL, 'SYSTEM', NULL),
(1653, 609, 3, 255, NULL, NULL, 'SYSTEM', NULL),
(1654, 609, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1655, 610, 14, 224, NULL, NULL, 'SYSTEM', NULL),
(1656, 610, 15, 640, NULL, NULL, 'SYSTEM', NULL),
(1657, 610, 3, 275, NULL, NULL, 'SYSTEM', NULL),
(1658, 610, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1659, 611, 14, 224, NULL, NULL, 'SYSTEM', NULL),
(1660, 611, 15, 641, NULL, NULL, 'SYSTEM', NULL),
(1661, 611, 3, 271, NULL, NULL, 'SYSTEM', NULL),
(1662, 611, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1663, 612, 14, 224, NULL, NULL, 'SYSTEM', NULL),
(1664, 612, 15, 642, NULL, NULL, 'SYSTEM', NULL),
(1665, 612, 3, 273, NULL, NULL, 'SYSTEM', NULL),
(1666, 612, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1667, 613, 14, 224, NULL, NULL, 'SYSTEM', NULL),
(1668, 613, 15, 643, NULL, NULL, 'SYSTEM', NULL),
(1669, 613, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(1670, 613, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1671, 614, 14, 224, NULL, NULL, 'SYSTEM', NULL),
(1672, 614, 15, 644, NULL, NULL, 'SYSTEM', NULL),
(1673, 614, 3, 262, NULL, NULL, 'SYSTEM', NULL),
(1674, 614, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1675, 615, 14, 224, NULL, NULL, 'SYSTEM', NULL),
(1676, 615, 15, 645, NULL, NULL, 'SYSTEM', NULL),
(1677, 615, 3, 260, NULL, NULL, 'SYSTEM', NULL),
(1678, 615, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1679, 616, 14, 224, NULL, NULL, 'SYSTEM', NULL),
(1680, 616, 15, 646, NULL, NULL, 'SYSTEM', NULL),
(1681, 616, 3, 263, NULL, NULL, 'SYSTEM', NULL),
(1682, 616, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1683, 617, 14, 224, NULL, NULL, 'SYSTEM', NULL),
(1684, 617, 15, 647, NULL, NULL, 'SYSTEM', NULL),
(1685, 617, 3, 113, NULL, NULL, 'SYSTEM', NULL),
(1686, 617, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1687, 618, 14, 224, NULL, NULL, 'SYSTEM', NULL),
(1688, 618, 15, 648, NULL, NULL, 'SYSTEM', NULL),
(1689, 618, 3, 276, NULL, NULL, 'SYSTEM', NULL),
(1690, 618, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1691, 619, 14, 223, NULL, NULL, 'SYSTEM', NULL),
(1692, 619, 15, 649, NULL, NULL, 'SYSTEM', NULL),
(1693, 619, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(1694, 619, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1695, 620, 14, 223, NULL, NULL, 'SYSTEM', NULL),
(1696, 620, 15, 650, NULL, NULL, 'SYSTEM', NULL),
(1697, 620, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1698, 620, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1699, 621, 14, 223, NULL, NULL, 'SYSTEM', NULL),
(1700, 621, 15, 651, NULL, NULL, 'SYSTEM', NULL),
(1701, 621, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(1702, 621, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1703, 622, 14, 223, NULL, NULL, 'SYSTEM', NULL),
(1704, 622, 15, 652, NULL, NULL, 'SYSTEM', NULL),
(1705, 622, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(1706, 622, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1707, 623, 14, 222, NULL, NULL, 'SYSTEM', NULL),
(1708, 623, 15, 653, NULL, NULL, 'SYSTEM', NULL),
(1709, 623, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1710, 624, 14, 222, NULL, NULL, 'SYSTEM', NULL),
(1711, 624, 15, 654, NULL, NULL, 'SYSTEM', NULL),
(1712, 624, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1713, 625, 14, 222, NULL, NULL, 'SYSTEM', NULL),
(1714, 625, 15, 655, NULL, NULL, 'SYSTEM', NULL),
(1715, 625, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1716, 626, 14, 222, NULL, NULL, 'SYSTEM', NULL),
(1717, 626, 15, 656, NULL, NULL, 'SYSTEM', NULL),
(1718, 626, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1719, 627, 14, 222, NULL, NULL, 'SYSTEM', NULL),
(1720, 627, 15, 657, NULL, NULL, 'SYSTEM', NULL),
(1721, 627, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1722, 628, 14, 222, NULL, NULL, 'SYSTEM', NULL),
(1723, 628, 15, 658, NULL, NULL, 'SYSTEM', NULL),
(1724, 628, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1725, 629, 14, 222, NULL, NULL, 'SYSTEM', NULL),
(1726, 629, 15, 659, NULL, NULL, 'SYSTEM', NULL),
(1727, 629, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1728, 630, 14, 222, NULL, NULL, 'SYSTEM', NULL),
(1729, 630, 15, 660, NULL, NULL, 'SYSTEM', NULL),
(1730, 630, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1731, 631, 14, 222, NULL, NULL, 'SYSTEM', NULL),
(1732, 631, 15, 661, NULL, NULL, 'SYSTEM', NULL),
(1733, 631, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(1734, 632, 14, 222, NULL, NULL, 'SYSTEM', NULL),
(1735, 632, 15, 662, NULL, NULL, 'SYSTEM', NULL),
(1736, 632, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1737, 633, 14, 222, NULL, NULL, 'SYSTEM', NULL),
(1738, 633, 15, 663, NULL, NULL, 'SYSTEM', NULL),
(1739, 633, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1740, 634, 14, 221, NULL, NULL, 'SYSTEM', NULL),
(1741, 634, 15, 664, NULL, NULL, 'SYSTEM', NULL),
(1742, 634, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(1743, 634, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1744, 635, 14, 221, NULL, NULL, 'SYSTEM', NULL),
(1745, 635, 15, 665, NULL, NULL, 'SYSTEM', NULL),
(1746, 635, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(1747, 635, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1748, 636, 14, 221, NULL, NULL, 'SYSTEM', NULL),
(1749, 636, 15, 666, NULL, NULL, 'SYSTEM', NULL),
(1750, 636, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(1751, 636, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1752, 637, 14, 221, NULL, NULL, 'SYSTEM', NULL),
(1753, 637, 15, 667, NULL, NULL, 'SYSTEM', NULL),
(1754, 637, 3, 258, NULL, NULL, 'SYSTEM', NULL),
(1755, 637, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1756, 638, 14, 221, NULL, NULL, 'SYSTEM', NULL),
(1757, 638, 15, 668, NULL, NULL, 'SYSTEM', NULL),
(1758, 638, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(1759, 638, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1760, 639, 14, 221, NULL, NULL, 'SYSTEM', NULL),
(1761, 639, 15, 669, NULL, NULL, 'SYSTEM', NULL),
(1762, 639, 3, 264, NULL, NULL, 'SYSTEM', NULL),
(1763, 639, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1764, 640, 14, 221, NULL, NULL, 'SYSTEM', NULL),
(1765, 640, 15, 670, NULL, NULL, 'SYSTEM', NULL),
(1766, 640, 3, 255, NULL, NULL, 'SYSTEM', NULL),
(1767, 640, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1768, 641, 14, 221, NULL, NULL, 'SYSTEM', NULL),
(1769, 641, 15, 671, NULL, NULL, 'SYSTEM', NULL),
(1770, 641, 3, 256, NULL, NULL, 'SYSTEM', NULL),
(1771, 641, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1772, 642, 14, 221, NULL, NULL, 'SYSTEM', NULL),
(1773, 642, 15, 672, NULL, NULL, 'SYSTEM', NULL),
(1774, 642, 3, 266, NULL, NULL, 'SYSTEM', NULL),
(1775, 642, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1776, 643, 14, 221, NULL, NULL, 'SYSTEM', NULL),
(1777, 643, 15, 673, NULL, NULL, 'SYSTEM', NULL),
(1778, 643, 3, 280, NULL, NULL, 'SYSTEM', NULL),
(1779, 643, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(1780, 644, 14, 197, NULL, NULL, 'SYSTEM', NULL),
(1781, 644, 15, 674, NULL, NULL, 'SYSTEM', NULL),
(1782, 644, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1783, 645, 14, 197, NULL, NULL, 'SYSTEM', NULL),
(1784, 645, 15, 675, NULL, NULL, 'SYSTEM', NULL),
(1785, 645, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1786, 646, 14, 197, NULL, NULL, 'SYSTEM', NULL),
(1787, 646, 15, 676, NULL, NULL, 'SYSTEM', NULL),
(1788, 646, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1789, 647, 14, 197, NULL, NULL, 'SYSTEM', NULL),
(1790, 647, 15, 677, NULL, NULL, 'SYSTEM', NULL),
(1791, 647, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1792, 648, 14, 198, NULL, NULL, 'SYSTEM', NULL),
(1793, 648, 15, 678, NULL, NULL, 'SYSTEM', NULL),
(1794, 648, 3, 275, NULL, NULL, 'SYSTEM', NULL),
(1795, 648, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1796, 649, 14, 198, NULL, NULL, 'SYSTEM', NULL),
(1797, 649, 15, 679, NULL, NULL, 'SYSTEM', NULL),
(1798, 649, 3, 6, NULL, NULL, 'SYSTEM', NULL),
(1799, 649, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1800, 650, 14, 198, NULL, NULL, 'SYSTEM', NULL),
(1801, 650, 15, 680, NULL, NULL, 'SYSTEM', NULL),
(1802, 650, 3, 114, NULL, NULL, 'SYSTEM', NULL),
(1803, 650, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1804, 651, 14, 198, NULL, NULL, 'SYSTEM', NULL),
(1805, 651, 15, 681, NULL, NULL, 'SYSTEM', NULL),
(1806, 651, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(1807, 651, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1808, 652, 14, 198, NULL, NULL, 'SYSTEM', NULL),
(1809, 652, 3, 272, NULL, NULL, 'SYSTEM', NULL),
(1810, 652, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1811, 653, 14, 199, NULL, NULL, 'SYSTEM', NULL),
(1812, 653, 15, 682, NULL, NULL, 'SYSTEM', NULL),
(1813, 653, 3, 114, NULL, NULL, 'SYSTEM', NULL),
(1814, 653, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1815, 654, 14, 199, NULL, NULL, 'SYSTEM', NULL),
(1816, 654, 15, 683, NULL, NULL, 'SYSTEM', NULL),
(1817, 654, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(1818, 654, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1819, 655, 14, 199, NULL, NULL, 'SYSTEM', NULL),
(1820, 655, 15, 684, NULL, NULL, 'SYSTEM', NULL),
(1821, 655, 3, 284, NULL, NULL, 'SYSTEM', NULL),
(1822, 655, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1823, 656, 14, 199, NULL, NULL, 'SYSTEM', NULL),
(1824, 656, 15, 685, NULL, NULL, 'SYSTEM', NULL),
(1825, 656, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1826, 656, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1827, 657, 14, 199, NULL, NULL, 'SYSTEM', NULL),
(1828, 657, 15, 686, NULL, NULL, 'SYSTEM', NULL),
(1829, 657, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(1830, 657, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1831, 658, 14, 200, NULL, NULL, 'SYSTEM', NULL),
(1832, 658, 15, 687, NULL, NULL, 'SYSTEM', NULL),
(1833, 658, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(1834, 658, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1835, 659, 14, 200, NULL, NULL, 'SYSTEM', NULL),
(1836, 659, 15, 688, NULL, NULL, 'SYSTEM', NULL),
(1837, 659, 3, 275, NULL, NULL, 'SYSTEM', NULL),
(1838, 659, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1839, 660, 14, 200, NULL, NULL, 'SYSTEM', NULL),
(1840, 660, 15, 689, NULL, NULL, 'SYSTEM', NULL),
(1841, 660, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1842, 660, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1843, 661, 14, 200, NULL, NULL, 'SYSTEM', NULL),
(1844, 661, 15, 690, NULL, NULL, 'SYSTEM', NULL),
(1845, 661, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(1846, 661, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1847, 662, 14, 200, NULL, NULL, 'SYSTEM', NULL),
(1848, 662, 15, 691, NULL, NULL, 'SYSTEM', NULL),
(1849, 662, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(1850, 662, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1851, 663, 14, 200, NULL, NULL, 'SYSTEM', NULL),
(1852, 663, 15, 692, NULL, NULL, 'SYSTEM', NULL),
(1853, 663, 3, 114, NULL, NULL, 'SYSTEM', NULL),
(1854, 663, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1855, 664, 14, 201, NULL, NULL, 'SYSTEM', NULL),
(1856, 664, 15, 693, NULL, NULL, 'SYSTEM', NULL),
(1857, 664, 3, 275, NULL, NULL, 'SYSTEM', NULL),
(1858, 664, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1859, 665, 14, 201, NULL, NULL, 'SYSTEM', NULL),
(1860, 665, 15, 694, NULL, NULL, 'SYSTEM', NULL),
(1861, 665, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1862, 665, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1863, 666, 14, 201, NULL, NULL, 'SYSTEM', NULL),
(1864, 666, 15, 695, NULL, NULL, 'SYSTEM', NULL),
(1865, 666, 3, 114, NULL, NULL, 'SYSTEM', NULL),
(1866, 666, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1867, 667, 14, 201, NULL, NULL, 'SYSTEM', NULL),
(1868, 667, 15, 696, NULL, NULL, 'SYSTEM', NULL),
(1869, 667, 3, 279, NULL, NULL, 'SYSTEM', NULL),
(1870, 667, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1871, 668, 14, 201, NULL, NULL, 'SYSTEM', NULL),
(1872, 668, 15, 697, NULL, NULL, 'SYSTEM', NULL),
(1873, 668, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(1874, 668, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1875, 669, 14, 132, NULL, NULL, 'SYSTEM', NULL),
(1876, 669, 15, 698, NULL, NULL, 'SYSTEM', NULL),
(1877, 669, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(1878, 669, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1879, 670, 14, 132, NULL, NULL, 'SYSTEM', NULL),
(1880, 670, 15, 698, NULL, NULL, 'SYSTEM', NULL),
(1881, 670, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(1882, 670, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(1883, 671, 14, 132, NULL, NULL, 'SYSTEM', NULL),
(1884, 671, 15, 698, NULL, NULL, 'SYSTEM', NULL),
(1885, 671, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(1886, 671, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(1887, 672, 14, 132, NULL, NULL, 'SYSTEM', NULL),
(1888, 672, 15, 699, NULL, NULL, 'SYSTEM', NULL),
(1889, 672, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(1890, 672, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1891, 673, 14, 132, NULL, NULL, 'SYSTEM', NULL),
(1892, 673, 15, 699, NULL, NULL, 'SYSTEM', NULL),
(1893, 673, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(1894, 673, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(1895, 674, 14, 132, NULL, NULL, 'SYSTEM', NULL),
(1896, 674, 15, 700, NULL, NULL, 'SYSTEM', NULL),
(1897, 674, 3, 278, NULL, NULL, 'SYSTEM', NULL),
(1898, 674, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1899, 675, 14, 132, NULL, NULL, 'SYSTEM', NULL),
(1900, 675, 15, 700, NULL, NULL, 'SYSTEM', NULL),
(1901, 675, 3, 278, NULL, NULL, 'SYSTEM', NULL),
(1902, 675, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(1903, 676, 14, 132, NULL, NULL, 'SYSTEM', NULL),
(1904, 676, 15, 701, NULL, NULL, 'SYSTEM', NULL),
(1905, 676, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(1906, 676, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1907, 677, 14, 132, NULL, NULL, 'SYSTEM', NULL),
(1908, 677, 15, 701, NULL, NULL, 'SYSTEM', NULL),
(1909, 677, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(1910, 677, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(1911, 678, 14, 132, NULL, NULL, 'SYSTEM', NULL),
(1912, 678, 15, 702, NULL, NULL, 'SYSTEM', NULL),
(1913, 678, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(1914, 678, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(1915, 679, 14, 132, NULL, NULL, 'SYSTEM', NULL),
(1916, 679, 15, 702, NULL, NULL, 'SYSTEM', NULL),
(1917, 679, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(1918, 679, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1919, 680, 14, 132, NULL, NULL, 'SYSTEM', NULL),
(1920, 680, 15, 703, NULL, NULL, 'SYSTEM', NULL),
(1921, 680, 3, 283, NULL, NULL, 'SYSTEM', NULL),
(1922, 680, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1923, 681, 14, 132, NULL, NULL, 'SYSTEM', NULL),
(1924, 681, 15, 703, NULL, NULL, 'SYSTEM', NULL),
(1925, 681, 3, 283, NULL, NULL, 'SYSTEM', NULL),
(1926, 681, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(1927, 682, 14, 202, NULL, NULL, 'SYSTEM', NULL),
(1928, 682, 15, 704, NULL, NULL, 'SYSTEM', NULL),
(1929, 682, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(1930, 682, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1931, 683, 14, 202, NULL, NULL, 'SYSTEM', NULL),
(1932, 683, 15, 705, NULL, NULL, 'SYSTEM', NULL),
(1933, 683, 3, 275, NULL, NULL, 'SYSTEM', NULL),
(1934, 683, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(1935, 684, 14, 202, NULL, NULL, 'SYSTEM', NULL),
(1936, 684, 15, 706, NULL, NULL, 'SYSTEM', NULL),
(1937, 684, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(1938, 684, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(1939, 685, 14, 202, NULL, NULL, 'SYSTEM', NULL),
(1940, 685, 15, 707, NULL, NULL, 'SYSTEM', NULL),
(1941, 685, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1942, 685, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(1943, 686, 14, 202, NULL, NULL, 'SYSTEM', NULL),
(1944, 686, 15, 708, NULL, NULL, 'SYSTEM', NULL),
(1945, 686, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(1946, 686, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(1947, 687, 14, 202, NULL, NULL, 'SYSTEM', NULL),
(1948, 687, 15, 709, NULL, NULL, 'SYSTEM', NULL),
(1949, 687, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(1950, 687, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(1951, 688, 14, 202, NULL, NULL, 'SYSTEM', NULL),
(1952, 688, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(1953, 688, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(1954, 689, 14, 202, NULL, NULL, 'SYSTEM', NULL),
(1955, 689, 15, 710, NULL, NULL, 'SYSTEM', NULL),
(1956, 689, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(1957, 689, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(1958, 690, 14, 202, NULL, NULL, 'SYSTEM', NULL),
(1959, 690, 15, 710, NULL, NULL, 'SYSTEM', NULL),
(1960, 690, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(1961, 690, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(1962, 691, 14, 203, NULL, NULL, 'SYSTEM', NULL),
(1963, 691, 15, 711, NULL, NULL, 'SYSTEM', NULL),
(1964, 691, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(1965, 691, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(1966, 692, 14, 203, NULL, NULL, 'SYSTEM', NULL),
(1967, 692, 15, 711, NULL, NULL, 'SYSTEM', NULL),
(1968, 692, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(1969, 692, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1970, 693, 14, 203, NULL, NULL, 'SYSTEM', NULL),
(1971, 693, 15, 711, NULL, NULL, 'SYSTEM', NULL),
(1972, 693, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(1973, 693, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(1974, 694, 14, 203, NULL, NULL, 'SYSTEM', NULL),
(1975, 694, 15, 712, NULL, NULL, 'SYSTEM', NULL),
(1976, 694, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1977, 694, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1978, 695, 14, 203, NULL, NULL, 'SYSTEM', NULL),
(1979, 695, 15, 712, NULL, NULL, 'SYSTEM', NULL),
(1980, 695, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(1981, 695, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(1982, 696, 14, 203, NULL, NULL, 'SYSTEM', NULL),
(1983, 696, 15, 713, NULL, NULL, 'SYSTEM', NULL),
(1984, 696, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(1985, 696, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(1986, 697, 14, 203, NULL, NULL, 'SYSTEM', NULL),
(1987, 697, 15, 713, NULL, NULL, 'SYSTEM', NULL),
(1988, 697, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(1989, 697, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1990, 698, 14, 203, NULL, NULL, 'SYSTEM', NULL),
(1991, 698, 15, 713, NULL, NULL, 'SYSTEM', NULL),
(1992, 698, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(1993, 698, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(1994, 699, 14, 203, NULL, NULL, 'SYSTEM', NULL),
(1995, 699, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(1996, 699, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(1997, 700, 14, 203, NULL, NULL, 'SYSTEM', NULL),
(1998, 700, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(1999, 700, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2000, 701, 14, 204, NULL, NULL, 'SYSTEM', NULL),
(2001, 701, 15, 714, NULL, NULL, 'SYSTEM', NULL),
(2002, 701, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2003, 701, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2004, 702, 14, 204, NULL, NULL, 'SYSTEM', NULL),
(2005, 702, 15, 714, NULL, NULL, 'SYSTEM', NULL),
(2006, 702, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2007, 702, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2008, 703, 14, 204, NULL, NULL, 'SYSTEM', NULL),
(2009, 703, 15, 715, NULL, NULL, 'SYSTEM', NULL),
(2010, 703, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(2011, 703, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2012, 704, 14, 204, NULL, NULL, 'SYSTEM', NULL),
(2013, 704, 15, 715, NULL, NULL, 'SYSTEM', NULL),
(2014, 704, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(2015, 704, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2016, 705, 14, 204, NULL, NULL, 'SYSTEM', NULL),
(2017, 705, 15, 716, NULL, NULL, 'SYSTEM', NULL),
(2018, 705, 3, 280, NULL, NULL, 'SYSTEM', NULL),
(2019, 705, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2020, 706, 14, 204, NULL, NULL, 'SYSTEM', NULL),
(2021, 706, 15, 717, NULL, NULL, 'SYSTEM', NULL),
(2022, 706, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(2023, 706, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2024, 707, 14, 204, NULL, NULL, 'SYSTEM', NULL),
(2025, 707, 15, 717, NULL, NULL, 'SYSTEM', NULL),
(2026, 707, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(2027, 707, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2028, 708, 14, 204, NULL, NULL, 'SYSTEM', NULL),
(2029, 708, 15, 718, NULL, NULL, 'SYSTEM', NULL),
(2030, 708, 3, 265, NULL, NULL, 'SYSTEM', NULL),
(2031, 708, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2032, 709, 14, 204, NULL, NULL, 'SYSTEM', NULL),
(2033, 709, 15, 718, NULL, NULL, 'SYSTEM', NULL),
(2034, 709, 3, 265, NULL, NULL, 'SYSTEM', NULL),
(2035, 709, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2036, 710, 14, 204, NULL, NULL, 'SYSTEM', NULL),
(2037, 710, 15, 719, NULL, NULL, 'SYSTEM', NULL),
(2038, 710, 3, 114, NULL, NULL, 'SYSTEM', NULL),
(2039, 710, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2040, 711, 14, 204, NULL, NULL, 'SYSTEM', NULL),
(2041, 711, 15, 719, NULL, NULL, 'SYSTEM', NULL),
(2042, 711, 3, 114, NULL, NULL, 'SYSTEM', NULL),
(2043, 711, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2044, 712, 14, 205, NULL, NULL, 'SYSTEM', NULL),
(2045, 712, 15, 720, NULL, NULL, 'SYSTEM', NULL),
(2046, 712, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(2047, 712, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2048, 713, 14, 205, NULL, NULL, 'SYSTEM', NULL),
(2049, 713, 15, 721, NULL, NULL, 'SYSTEM', NULL),
(2050, 713, 3, 280, NULL, NULL, 'SYSTEM', NULL),
(2051, 713, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2052, 714, 14, 205, NULL, NULL, 'SYSTEM', NULL),
(2053, 714, 15, 721, NULL, NULL, 'SYSTEM', NULL),
(2054, 714, 3, 280, NULL, NULL, 'SYSTEM', NULL),
(2055, 714, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(2056, 715, 14, 205, NULL, NULL, 'SYSTEM', NULL),
(2057, 715, 15, 721, NULL, NULL, 'SYSTEM', NULL),
(2058, 715, 3, 280, NULL, NULL, 'SYSTEM', NULL),
(2059, 715, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(2060, 716, 14, 205, NULL, NULL, 'SYSTEM', NULL),
(2061, 716, 15, 722, NULL, NULL, 'SYSTEM', NULL),
(2062, 716, 3, 266, NULL, NULL, 'SYSTEM', NULL),
(2063, 716, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(2064, 717, 14, 205, NULL, NULL, 'SYSTEM', NULL),
(2065, 717, 15, 722, NULL, NULL, 'SYSTEM', NULL),
(2066, 717, 3, 266, NULL, NULL, 'SYSTEM', NULL),
(2067, 717, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(2068, 718, 14, 205, NULL, NULL, 'SYSTEM', NULL),
(2069, 718, 15, 723, NULL, NULL, 'SYSTEM', NULL),
(2070, 718, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(2071, 718, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2072, 719, 14, 205, NULL, NULL, 'SYSTEM', NULL),
(2073, 719, 15, 723, NULL, NULL, 'SYSTEM', NULL),
(2074, 719, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(2075, 719, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(2076, 720, 14, 206, NULL, NULL, 'SYSTEM', NULL),
(2077, 720, 3, 6, NULL, NULL, 'SYSTEM', NULL),
(2078, 720, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2079, 721, 14, 206, NULL, NULL, 'SYSTEM', NULL),
(2080, 721, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(2081, 721, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2082, 722, 14, 206, NULL, NULL, 'SYSTEM', NULL),
(2083, 722, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(2084, 722, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2085, 723, 14, 206, NULL, NULL, 'SYSTEM', NULL),
(2086, 723, 3, 257, NULL, NULL, 'SYSTEM', NULL),
(2087, 723, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2088, 724, 14, 206, NULL, NULL, 'SYSTEM', NULL),
(2089, 724, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(2090, 724, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2091, 725, 14, 206, NULL, NULL, 'SYSTEM', NULL),
(2092, 725, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(2093, 725, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2094, 726, 14, 206, NULL, NULL, 'SYSTEM', NULL),
(2095, 726, 3, 275, NULL, NULL, 'SYSTEM', NULL),
(2096, 726, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2097, 727, 14, 207, NULL, NULL, 'SYSTEM', NULL),
(2098, 727, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(2099, 727, 11, 244, NULL, NULL, 'SYSTEM', NULL);
INSERT INTO `product_variant_attributes` (`id`, `product_variant_id`, `attribute_master_id`, `attribute_value_id`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(2100, 728, 14, 207, NULL, NULL, 'SYSTEM', NULL),
(2101, 728, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(2102, 728, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2103, 729, 14, 207, NULL, NULL, 'SYSTEM', NULL),
(2104, 729, 3, 261, NULL, NULL, 'SYSTEM', NULL),
(2105, 729, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2106, 730, 14, 207, NULL, NULL, 'SYSTEM', NULL),
(2107, 730, 3, 259, NULL, NULL, 'SYSTEM', NULL),
(2108, 730, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2109, 731, 14, 207, NULL, NULL, 'SYSTEM', NULL),
(2110, 731, 3, 259, NULL, NULL, 'SYSTEM', NULL),
(2111, 731, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2112, 732, 14, 207, NULL, NULL, 'SYSTEM', NULL),
(2113, 732, 3, 108, NULL, NULL, 'SYSTEM', NULL),
(2114, 732, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2115, 733, 14, 208, NULL, NULL, 'SYSTEM', NULL),
(2116, 733, 15, 725, NULL, NULL, 'SYSTEM', NULL),
(2117, 733, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(2118, 733, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2119, 734, 14, 208, NULL, NULL, 'SYSTEM', NULL),
(2120, 734, 15, 726, NULL, NULL, 'SYSTEM', NULL),
(2121, 734, 3, 114, NULL, NULL, 'SYSTEM', NULL),
(2122, 734, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2123, 735, 14, 208, NULL, NULL, 'SYSTEM', NULL),
(2124, 735, 15, 726, NULL, NULL, 'SYSTEM', NULL),
(2125, 735, 3, 114, NULL, NULL, 'SYSTEM', NULL),
(2126, 735, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(2127, 736, 14, 208, NULL, NULL, 'SYSTEM', NULL),
(2128, 736, 15, 703, NULL, NULL, 'SYSTEM', NULL),
(2129, 736, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2130, 736, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2131, 737, 14, 208, NULL, NULL, 'SYSTEM', NULL),
(2132, 737, 15, 727, NULL, NULL, 'SYSTEM', NULL),
(2133, 737, 3, 265, NULL, NULL, 'SYSTEM', NULL),
(2134, 737, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2135, 738, 14, 208, NULL, NULL, 'SYSTEM', NULL),
(2136, 738, 15, 728, NULL, NULL, 'SYSTEM', NULL),
(2137, 738, 3, 113, NULL, NULL, 'SYSTEM', NULL),
(2138, 738, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2139, 739, 14, 209, NULL, NULL, 'SYSTEM', NULL),
(2140, 739, 15, 729, NULL, NULL, 'SYSTEM', NULL),
(2141, 739, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(2142, 739, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2143, 740, 14, 209, NULL, NULL, 'SYSTEM', NULL),
(2144, 740, 15, 729, NULL, NULL, 'SYSTEM', NULL),
(2145, 740, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(2146, 740, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2147, 741, 14, 209, NULL, NULL, 'SYSTEM', NULL),
(2148, 741, 15, 729, NULL, NULL, 'SYSTEM', NULL),
(2149, 741, 3, 5, NULL, NULL, 'SYSTEM', NULL),
(2150, 741, 11, 248, NULL, NULL, 'SYSTEM', NULL),
(2151, 742, 14, 209, NULL, NULL, 'SYSTEM', NULL),
(2152, 742, 15, 730, NULL, NULL, 'SYSTEM', NULL),
(2153, 742, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(2154, 742, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2155, 743, 14, 209, NULL, NULL, 'SYSTEM', NULL),
(2156, 743, 15, 731, NULL, NULL, 'SYSTEM', NULL),
(2157, 743, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(2158, 743, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2159, 744, 14, 209, NULL, NULL, 'SYSTEM', NULL),
(2160, 744, 15, 731, NULL, NULL, 'SYSTEM', NULL),
(2161, 744, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(2162, 744, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2163, 745, 14, 209, NULL, NULL, 'SYSTEM', NULL),
(2164, 745, 15, 732, NULL, NULL, 'SYSTEM', NULL),
(2165, 745, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(2166, 745, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2167, 746, 14, 209, NULL, NULL, 'SYSTEM', NULL),
(2168, 746, 15, 732, NULL, NULL, 'SYSTEM', NULL),
(2169, 746, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(2170, 746, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2171, 747, 14, 210, NULL, NULL, 'SYSTEM', NULL),
(2172, 747, 15, 733, NULL, NULL, 'SYSTEM', NULL),
(2173, 747, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2174, 747, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2175, 748, 14, 210, NULL, NULL, 'SYSTEM', NULL),
(2176, 748, 15, 733, NULL, NULL, 'SYSTEM', NULL),
(2177, 748, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2178, 748, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2179, 749, 14, 210, NULL, NULL, 'SYSTEM', NULL),
(2180, 749, 15, 734, NULL, NULL, 'SYSTEM', NULL),
(2181, 749, 3, 6, NULL, NULL, 'SYSTEM', NULL),
(2182, 749, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2183, 750, 14, 210, NULL, NULL, 'SYSTEM', NULL),
(2184, 750, 15, 734, NULL, NULL, 'SYSTEM', NULL),
(2185, 750, 3, 6, NULL, NULL, 'SYSTEM', NULL),
(2186, 750, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2187, 751, 14, 210, NULL, NULL, 'SYSTEM', NULL),
(2188, 751, 15, 734, NULL, NULL, 'SYSTEM', NULL),
(2189, 751, 3, 6, NULL, NULL, 'SYSTEM', NULL),
(2190, 751, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(2191, 752, 14, 210, NULL, NULL, 'SYSTEM', NULL),
(2192, 752, 15, 735, NULL, NULL, 'SYSTEM', NULL),
(2193, 752, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(2194, 752, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2195, 753, 14, 210, NULL, NULL, 'SYSTEM', NULL),
(2196, 753, 15, 735, NULL, NULL, 'SYSTEM', NULL),
(2197, 753, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(2198, 753, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2199, 754, 14, 210, NULL, NULL, 'SYSTEM', NULL),
(2200, 754, 15, 736, NULL, NULL, 'SYSTEM', NULL),
(2201, 754, 3, 284, NULL, NULL, 'SYSTEM', NULL),
(2202, 754, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2203, 755, 14, 210, NULL, NULL, 'SYSTEM', NULL),
(2204, 755, 15, 736, NULL, NULL, 'SYSTEM', NULL),
(2205, 755, 3, 284, NULL, NULL, 'SYSTEM', NULL),
(2206, 755, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2207, 756, 14, 210, NULL, NULL, 'SYSTEM', NULL),
(2208, 756, 15, 736, NULL, NULL, 'SYSTEM', NULL),
(2209, 756, 3, 284, NULL, NULL, 'SYSTEM', NULL),
(2210, 756, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(2211, 757, 14, 210, NULL, NULL, 'SYSTEM', NULL),
(2212, 757, 15, 737, NULL, NULL, 'SYSTEM', NULL),
(2213, 757, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(2214, 757, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2215, 758, 14, 210, NULL, NULL, 'SYSTEM', NULL),
(2216, 758, 15, 737, NULL, NULL, 'SYSTEM', NULL),
(2217, 758, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(2218, 758, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2219, 759, 14, 211, NULL, NULL, 'SYSTEM', NULL),
(2220, 759, 15, 738, NULL, NULL, 'SYSTEM', NULL),
(2221, 759, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(2222, 759, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2223, 760, 14, 211, NULL, NULL, 'SYSTEM', NULL),
(2224, 760, 15, 739, NULL, NULL, 'SYSTEM', NULL),
(2225, 760, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(2226, 760, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2227, 761, 14, 211, NULL, NULL, 'SYSTEM', NULL),
(2228, 761, 15, 739, NULL, NULL, 'SYSTEM', NULL),
(2229, 761, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(2230, 761, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2231, 762, 14, 211, NULL, NULL, 'SYSTEM', NULL),
(2232, 762, 15, 740, NULL, NULL, 'SYSTEM', NULL),
(2233, 762, 3, 266, NULL, NULL, 'SYSTEM', NULL),
(2234, 762, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2235, 763, 14, 211, NULL, NULL, 'SYSTEM', NULL),
(2236, 763, 15, 740, NULL, NULL, 'SYSTEM', NULL),
(2237, 763, 3, 266, NULL, NULL, 'SYSTEM', NULL),
(2238, 763, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2239, 764, 14, 211, NULL, NULL, 'SYSTEM', NULL),
(2240, 764, 15, 741, NULL, NULL, 'SYSTEM', NULL),
(2241, 764, 3, 272, NULL, NULL, 'SYSTEM', NULL),
(2242, 764, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2243, 765, 14, 211, NULL, NULL, 'SYSTEM', NULL),
(2244, 765, 15, 741, NULL, NULL, 'SYSTEM', NULL),
(2245, 765, 3, 272, NULL, NULL, 'SYSTEM', NULL),
(2246, 765, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2247, 766, 14, 211, NULL, NULL, 'SYSTEM', NULL),
(2248, 766, 15, 742, NULL, NULL, 'SYSTEM', NULL),
(2249, 766, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2250, 766, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2251, 767, 14, 211, NULL, NULL, 'SYSTEM', NULL),
(2252, 767, 15, 742, NULL, NULL, 'SYSTEM', NULL),
(2253, 767, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2254, 767, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2255, 768, 14, 212, NULL, NULL, 'SYSTEM', NULL),
(2256, 768, 15, 743, NULL, NULL, 'SYSTEM', NULL),
(2257, 768, 3, 280, NULL, NULL, 'SYSTEM', NULL),
(2258, 768, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2259, 769, 14, 212, NULL, NULL, 'SYSTEM', NULL),
(2260, 769, 15, 744, NULL, NULL, 'SYSTEM', NULL),
(2261, 769, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(2262, 769, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2263, 770, 14, 212, NULL, NULL, 'SYSTEM', NULL),
(2264, 770, 15, 745, NULL, NULL, 'SYSTEM', NULL),
(2265, 770, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2266, 770, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2267, 771, 14, 212, NULL, NULL, 'SYSTEM', NULL),
(2268, 771, 15, 746, NULL, NULL, 'SYSTEM', NULL),
(2269, 771, 3, 264, NULL, NULL, 'SYSTEM', NULL),
(2270, 771, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2271, 772, 14, 213, NULL, NULL, 'SYSTEM', NULL),
(2272, 772, 15, 747, NULL, NULL, 'SYSTEM', NULL),
(2273, 772, 3, 275, NULL, NULL, 'SYSTEM', NULL),
(2274, 772, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2275, 773, 14, 213, NULL, NULL, 'SYSTEM', NULL),
(2276, 773, 15, 748, NULL, NULL, 'SYSTEM', NULL),
(2277, 773, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(2278, 773, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2279, 774, 14, 213, NULL, NULL, 'SYSTEM', NULL),
(2280, 774, 15, 749, NULL, NULL, 'SYSTEM', NULL),
(2281, 774, 3, 114, NULL, NULL, 'SYSTEM', NULL),
(2282, 774, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2283, 775, 14, 213, NULL, NULL, 'SYSTEM', NULL),
(2284, 775, 15, 750, NULL, NULL, 'SYSTEM', NULL),
(2285, 775, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(2286, 775, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2287, 776, 14, 214, NULL, NULL, 'SYSTEM', NULL),
(2288, 776, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(2289, 776, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2290, 777, 14, 214, NULL, NULL, 'SYSTEM', NULL),
(2291, 777, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(2292, 777, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(2293, 778, 14, 214, NULL, NULL, 'SYSTEM', NULL),
(2294, 778, 3, 264, NULL, NULL, 'SYSTEM', NULL),
(2295, 778, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2296, 779, 14, 214, NULL, NULL, 'SYSTEM', NULL),
(2297, 779, 3, 282, NULL, NULL, 'SYSTEM', NULL),
(2298, 779, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2299, 780, 14, 214, NULL, NULL, 'SYSTEM', NULL),
(2300, 780, 3, 282, NULL, NULL, 'SYSTEM', NULL),
(2301, 780, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(2302, 781, 14, 214, NULL, NULL, 'SYSTEM', NULL),
(2303, 781, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2304, 781, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2305, 782, 14, 214, NULL, NULL, 'SYSTEM', NULL),
(2306, 782, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2307, 782, 11, 250, NULL, NULL, 'SYSTEM', NULL),
(2308, 783, 14, 215, NULL, NULL, 'SYSTEM', NULL),
(2309, 783, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(2310, 783, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2311, 784, 14, 215, NULL, NULL, 'SYSTEM', NULL),
(2312, 784, 3, 257, NULL, NULL, 'SYSTEM', NULL),
(2313, 784, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2314, 785, 14, 215, NULL, NULL, 'SYSTEM', NULL),
(2315, 785, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(2316, 785, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2317, 786, 14, 215, NULL, NULL, 'SYSTEM', NULL),
(2318, 786, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2319, 786, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2320, 787, 14, 216, NULL, NULL, 'SYSTEM', NULL),
(2321, 787, 3, 257, NULL, NULL, 'SYSTEM', NULL),
(2322, 787, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2323, 788, 14, 216, NULL, NULL, 'SYSTEM', NULL),
(2324, 788, 3, 257, NULL, NULL, 'SYSTEM', NULL),
(2325, 788, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2326, 789, 14, 216, NULL, NULL, 'SYSTEM', NULL),
(2327, 789, 3, 275, NULL, NULL, 'SYSTEM', NULL),
(2328, 789, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2329, 790, 14, 216, NULL, NULL, 'SYSTEM', NULL),
(2330, 790, 3, 275, NULL, NULL, 'SYSTEM', NULL),
(2331, 790, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2332, 791, 14, 216, NULL, NULL, 'SYSTEM', NULL),
(2333, 791, 3, 264, NULL, NULL, 'SYSTEM', NULL),
(2334, 791, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2335, 792, 14, 216, NULL, NULL, 'SYSTEM', NULL),
(2336, 792, 3, 264, NULL, NULL, 'SYSTEM', NULL),
(2337, 792, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2338, 793, 14, 216, NULL, NULL, 'SYSTEM', NULL),
(2339, 793, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(2340, 793, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2341, 794, 14, 216, NULL, NULL, 'SYSTEM', NULL),
(2342, 794, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(2343, 794, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2344, 795, 14, 216, NULL, NULL, 'SYSTEM', NULL),
(2345, 795, 3, 272, NULL, NULL, 'SYSTEM', NULL),
(2346, 795, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2347, 796, 14, 216, NULL, NULL, 'SYSTEM', NULL),
(2348, 796, 3, 272, NULL, NULL, 'SYSTEM', NULL),
(2349, 796, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2350, 797, 14, 216, NULL, NULL, 'SYSTEM', NULL),
(2351, 797, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2352, 797, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2353, 798, 14, 216, NULL, NULL, 'SYSTEM', NULL),
(2354, 798, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2355, 798, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2356, 799, 14, 217, NULL, NULL, 'SYSTEM', NULL),
(2357, 799, 3, 264, NULL, NULL, 'SYSTEM', NULL),
(2358, 799, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2359, 800, 14, 217, NULL, NULL, 'SYSTEM', NULL),
(2360, 800, 3, 264, NULL, NULL, 'SYSTEM', NULL),
(2361, 800, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2362, 801, 14, 217, NULL, NULL, 'SYSTEM', NULL),
(2363, 801, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(2364, 801, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2365, 802, 14, 217, NULL, NULL, 'SYSTEM', NULL),
(2366, 802, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(2367, 802, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2368, 803, 14, 217, NULL, NULL, 'SYSTEM', NULL),
(2369, 803, 3, 274, NULL, NULL, 'SYSTEM', NULL),
(2370, 803, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2371, 804, 14, 217, NULL, NULL, 'SYSTEM', NULL),
(2372, 804, 3, 274, NULL, NULL, 'SYSTEM', NULL),
(2373, 804, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2374, 805, 14, 217, NULL, NULL, 'SYSTEM', NULL),
(2375, 805, 3, 275, NULL, NULL, 'SYSTEM', NULL),
(2376, 805, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2377, 806, 14, 217, NULL, NULL, 'SYSTEM', NULL),
(2378, 806, 3, 275, NULL, NULL, 'SYSTEM', NULL),
(2379, 806, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2380, 807, 14, 217, NULL, NULL, 'SYSTEM', NULL),
(2381, 807, 3, 275, NULL, NULL, 'SYSTEM', NULL),
(2382, 807, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(2383, 808, 14, 217, NULL, NULL, 'SYSTEM', NULL),
(2384, 808, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2385, 808, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2386, 809, 14, 217, NULL, NULL, 'SYSTEM', NULL),
(2387, 809, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2388, 809, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2389, 810, 14, 217, NULL, NULL, 'SYSTEM', NULL),
(2390, 810, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2391, 810, 11, 246, NULL, NULL, 'SYSTEM', NULL),
(2392, 811, 14, 218, NULL, NULL, 'SYSTEM', NULL),
(2393, 811, 3, 112, NULL, NULL, 'SYSTEM', NULL),
(2394, 811, 11, 249, NULL, NULL, 'SYSTEM', NULL),
(2395, 812, 14, 218, NULL, NULL, 'SYSTEM', NULL),
(2396, 812, 3, 256, NULL, NULL, 'SYSTEM', NULL),
(2397, 812, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2398, 813, 14, 218, NULL, NULL, 'SYSTEM', NULL),
(2399, 813, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2400, 813, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2401, 814, 14, 218, NULL, NULL, 'SYSTEM', NULL),
(2402, 814, 3, 284, NULL, NULL, 'SYSTEM', NULL),
(2403, 814, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2404, 815, 14, 219, NULL, NULL, 'SYSTEM', NULL),
(2405, 815, 3, 282, NULL, NULL, 'SYSTEM', NULL),
(2406, 815, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2407, 816, 14, 219, NULL, NULL, 'SYSTEM', NULL),
(2408, 816, 3, 104, NULL, NULL, 'SYSTEM', NULL),
(2409, 816, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2410, 817, 14, 219, NULL, NULL, 'SYSTEM', NULL),
(2411, 817, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(2412, 817, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2413, 818, 14, 219, NULL, NULL, 'SYSTEM', NULL),
(2414, 818, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(2415, 818, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2416, 819, 14, 219, NULL, NULL, 'SYSTEM', NULL),
(2417, 819, 3, 114, NULL, NULL, 'SYSTEM', NULL),
(2418, 819, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2419, 820, 14, 220, NULL, NULL, 'SYSTEM', NULL),
(2420, 820, 3, 275, NULL, NULL, 'SYSTEM', NULL),
(2421, 820, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2422, 821, 14, 220, NULL, NULL, 'SYSTEM', NULL),
(2423, 821, 3, 93, NULL, NULL, 'SYSTEM', NULL),
(2424, 821, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2425, 822, 14, 220, NULL, NULL, 'SYSTEM', NULL),
(2426, 822, 3, 267, NULL, NULL, 'SYSTEM', NULL),
(2427, 822, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2428, 823, 14, 220, NULL, NULL, 'SYSTEM', NULL),
(2429, 823, 3, 272, NULL, NULL, 'SYSTEM', NULL),
(2430, 823, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2431, 824, 14, 220, NULL, NULL, 'SYSTEM', NULL),
(2432, 824, 3, 285, NULL, NULL, 'SYSTEM', NULL),
(2433, 824, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2434, 825, 14, 220, NULL, NULL, 'SYSTEM', NULL),
(2435, 825, 3, 264, NULL, NULL, 'SYSTEM', NULL),
(2436, 825, 11, 244, NULL, NULL, 'SYSTEM', NULL),
(2437, 826, 14, 220, NULL, NULL, 'SYSTEM', NULL),
(2438, 826, 3, 268, NULL, NULL, 'SYSTEM', NULL),
(2439, 826, 11, 244, NULL, NULL, 'SYSTEM', NULL);

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

--
-- Table structure for table `product_variant_purchase_prices`
--

CREATE TABLE IF NOT EXISTS `product_variant_purchase_prices` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `variant_id` bigint UNSIGNED NOT NULL,
  `vendor_id` bigint UNSIGNED DEFAULT NULL,
  `rate` decimal(12,2) NOT NULL,
  `currency` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'INR',
  `valid_from` date DEFAULT NULL,
  `valid_to` date DEFAULT NULL,
  `min_qty` decimal(13,3) NOT NULL DEFAULT '1.000',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `company_id` bigint UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_variant_purchase_prices_vendor_id_foreign` (`vendor_id`),
  KEY `product_variant_purchase_prices_variant_id_vendor_id_index` (`variant_id`,`vendor_id`),
  KEY `product_variant_purchase_prices_valid_from_valid_to_index` (`valid_from`,`valid_to`),
  KEY `product_variant_purchase_prices_is_active_index` (`is_active`),
  KEY `product_variant_purchase_prices_company_id_foreign` (`company_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_variant_sales_prices`
--

CREATE TABLE IF NOT EXISTS `product_variant_sales_prices` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `variant_id` bigint UNSIGNED NOT NULL,
  `customer_id` bigint UNSIGNED DEFAULT NULL,
  `rate` decimal(12,2) NOT NULL,
  `currency` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'INR',
  `valid_from` date DEFAULT NULL,
  `valid_to` date DEFAULT NULL,
  `min_qty` decimal(13,3) NOT NULL DEFAULT '1.000',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `company_id` bigint UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_variant_sales_prices_customer_id_foreign` (`customer_id`),
  KEY `product_variant_sales_prices_variant_id_customer_id_index` (`variant_id`,`customer_id`),
  KEY `product_variant_sales_prices_valid_from_valid_to_index` (`valid_from`,`valid_to`),
  KEY `product_variant_sales_prices_is_active_index` (`is_active`),
  KEY `product_variant_sales_prices_company_id_foreign` (`company_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `company_id` bigint UNSIGNED DEFAULT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `role_guard_unique` (`name`,`guard_name`),
  KEY `roles_team_foreign_key_index` (`company_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `company_id`, `name`, `guard_name`, `description`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Super Admin', 'web', NULL, '2025-08-29 09:55:02', '2025-08-29 09:55:02'),
(2, 1, 'Admin', 'web', NULL, '2025-08-30 06:12:08', '2025-08-30 06:12:08'),
(3, 1, 'Procurement', 'web', NULL, '2025-08-30 06:17:56', '2025-08-30 06:17:56'),
(4, 1, 'Master Data', 'web', 'Ths user will be only taking care of master data', '2025-09-04 05:01:03', '2025-09-04 05:01:03'),
(5, 2, 'Master Data T', 'web', 'Master data management.', '2025-09-08 05:45:58', '2025-09-08 05:45:58');

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

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

CREATE TABLE IF NOT EXISTS `role_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(31, 2),
(31, 4),
(32, 4),
(33, 4),
(34, 4),
(35, 4),
(36, 4),
(235, 4),
(236, 4),
(237, 4),
(239, 4),
(240, 4),
(241, 4),
(242, 4),
(243, 4),
(245, 4),
(246, 4),
(247, 4),
(248, 4),
(249, 4),
(251, 4),
(252, 4),
(253, 4),
(254, 4),
(255, 4),
(257, 4),
(258, 4),
(259, 4),
(260, 4),
(261, 4),
(263, 4),
(264, 4),
(265, 4),
(266, 4),
(267, 4),
(269, 4),
(270, 4),
(271, 4),
(272, 4),
(273, 4),
(275, 4),
(276, 4);

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

--
-- Table structure for table `role_permission_audits`
--

CREATE TABLE IF NOT EXISTS `role_permission_audits` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `company_id` bigint UNSIGNED DEFAULT NULL,
  `role_id` bigint UNSIGNED DEFAULT NULL,
  `action` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `rp_audits_company_role_created_idx` (`company_id`,`role_id`,`created_at`),
  KEY `role_permission_audits_user_id_index` (`user_id`),
  KEY `role_permission_audits_company_id_index` (`company_id`),
  KEY `role_permission_audits_role_id_index` (`role_id`),
  KEY `role_permission_audits_action_index` (`action`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_permission_audits`
--

INSERT INTO `role_permission_audits` (`id`, `user_id`, `company_id`, `role_id`, `action`, `details`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 4, 'role_created', '{\"name\": \"Master Data\", \"guard_name\": \"web\", \"description\": \"Ths user will be only taking care of master data\", \"copied_from_role_id\": null}', '2025-09-04 05:01:03', '2025-09-04 05:01:03'),
(2, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": []}', '2025-09-04 05:09:12', '2025-09-04 05:09:12'),
(3, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": []}', '2025-09-04 05:09:17', '2025-09-04 05:09:17'),
(4, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": []}', '2025-09-04 08:19:53', '2025-09-04 08:19:53'),
(5, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": []}', '2025-09-04 08:29:03', '2025-09-04 08:29:03'),
(6, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": []}', '2025-09-04 08:29:34', '2025-09-04 08:29:34'),
(7, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [1]}', '2025-09-04 08:48:50', '2025-09-04 08:48:50'),
(8, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [996]}', '2025-09-04 09:01:12', '2025-09-04 09:01:12'),
(9, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [1026]}', '2025-09-04 09:02:10', '2025-09-04 09:02:10'),
(10, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [1026]}', '2025-09-04 09:02:26', '2025-09-04 09:02:26'),
(11, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [1026]}', '2025-09-04 09:03:33', '2025-09-04 09:03:33'),
(12, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [996]}', '2025-09-05 01:04:47', '2025-09-05 01:04:47'),
(13, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [259, 260, 261, 262, 263, 264]}', '2025-09-05 04:17:02', '2025-09-05 04:17:02'),
(14, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": []}', '2025-09-05 04:18:50', '2025-09-05 04:18:50'),
(15, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [211]}', '2025-09-05 04:19:34', '2025-09-05 04:19:34'),
(16, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [211, 212, 213, 214, 215, 216]}', '2025-09-05 04:20:09', '2025-09-05 04:20:09'),
(17, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [199]}', '2025-09-08 02:11:22', '2025-09-08 02:11:22'),
(18, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": []}', '2025-09-08 02:12:13', '2025-09-08 02:12:13'),
(19, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [199, 211]}', '2025-09-08 02:30:01', '2025-09-08 02:30:01'),
(20, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [199, 200, 201, 202, 203, 204, 211]}', '2025-09-08 04:51:58', '2025-09-08 04:51:58'),
(21, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [199, 200, 201, 202, 203, 204, 211, 212, 213, 214, 215, 216]}', '2025-09-08 04:52:21', '2025-09-08 04:52:21'),
(22, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [199, 211]}', '2025-09-08 05:15:09', '2025-09-08 05:15:09'),
(23, 1, 2, 5, 'role_created', '{\"name\": \"Master Data T\", \"guard_name\": \"web\", \"description\": \"Master data management.\", \"copied_from_role_id\": null}', '2025-09-08 05:45:58', '2025-09-08 05:45:58'),
(24, 1, 2, 5, 'permissions_updated', '{\"permission_ids\": [199, 211]}', '2025-09-08 05:48:16', '2025-09-08 05:48:16'),
(25, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [199, 211, 213]}', '2025-09-08 06:39:28', '2025-09-08 06:39:28'),
(26, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [199, 201, 211, 213]}', '2025-09-08 09:06:51', '2025-09-08 09:06:51'),
(27, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [199, 211, 213]}', '2025-09-09 03:03:54', '2025-09-09 03:03:54'),
(28, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [199, 201, 211, 213]}', '2025-09-09 03:04:11', '2025-09-09 03:04:11'),
(29, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [199, 211, 213]}', '2025-09-09 03:04:18', '2025-09-09 03:04:18'),
(30, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [199, 200, 211, 213]}', '2025-09-09 08:42:10', '2025-09-09 08:42:10'),
(31, 1, 1, 2, 'permissions_updated', '{\"permission_ids\": [31]}', '2025-09-11 06:41:27', '2025-09-11 06:41:27'),
(32, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": []}', '2025-09-11 06:42:06', '2025-09-11 06:42:06'),
(33, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [31]}', '2025-09-11 06:42:18', '2025-09-11 06:42:18'),
(34, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [31, 32]}', '2025-09-11 06:42:32', '2025-09-11 06:42:32'),
(35, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [199]}', '2025-09-11 06:43:00', '2025-09-11 06:43:00'),
(36, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [31]}', '2025-09-11 06:43:17', '2025-09-11 06:43:17'),
(37, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [37]}', '2025-09-11 06:44:10', '2025-09-11 06:44:10'),
(38, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": []}', '2025-10-06 11:07:36', '2025-10-06 11:07:36'),
(39, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [259, 260, 263, 264, 265, 266, 269, 270, 247, 248, 251, 252, 235, 236, 239, 240, 271, 272, 275, 276, 241, 242, 245, 246, 253, 254, 257, 258]}', '2025-10-06 11:22:32', '2025-10-06 11:22:32'),
(40, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [259, 260, 261, 263, 264, 265, 266, 267, 269, 270, 247, 248, 249, 251, 252, 235, 236, 237, 239, 240, 271, 272, 273, 275, 276, 241, 242, 243, 245, 246, 253, 254, 255, 257, 258]}', '2025-10-06 11:24:14', '2025-10-06 11:24:14'),
(41, 1, 1, 4, 'permissions_updated', '{\"permission_ids\": [31, 32, 33, 34, 35, 36, 259, 260, 261, 263, 264, 265, 266, 267, 269, 270, 247, 248, 249, 251, 252, 235, 236, 237, 239, 240, 271, 272, 273, 275, 276, 241, 242, 243, 245, 246, 253, 254, 255, 257, 258]}', '2025-10-06 11:26:02', '2025-10-06 11:26:02'),
(42, 1, 2, 5, 'permissions_updated', '{\"permission_ids\": [211]}', '2025-10-06 11:27:48', '2025-10-06 11:27:48'),
(43, 1, 2, 5, 'permissions_updated', '{\"permission_ids\": []}', '2025-10-06 11:27:55', '2025-10-06 11:27:55');

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

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

CREATE TABLE IF NOT EXISTS `sessions` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('fqj9jOMFvhDSwDLXhWqWJKYhzSABhrvXilpZvjTX', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoicXk3MlhLa0pUNGFqQW5kUFJOUE5mR3ZCak1WM29iVXBxcTBYUUcwWSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czoxNjoibGFzdF9hY3Rpdml0eV9hdCI7aToxNzU5OTExMDc5O3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjYxOiJodHRwOi8vc29kZXJwLm1lL21hc3RlcnMvcHJvZHVjdC1tYW5hZ2VtZW50L2F0dHJpYnV0ZS1tYXN0ZXJzIjt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTtzOjEwOiJjb21wYW55X2lkIjtpOjE7fQ==', 1759911079);

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

--
-- Table structure for table `shift_work_center`
--

CREATE TABLE IF NOT EXISTS `shift_work_center` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `shift_id` bigint UNSIGNED NOT NULL,
  `work_center_id` bigint UNSIGNED NOT NULL,
  `effective_from` date DEFAULT NULL,
  `effective_to` date DEFAULT NULL,
  `capacity_override` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_shift_work_center` (`shift_id`,`work_center_id`),
  KEY `shift_work_center_work_center_id_foreign` (`work_center_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shift_work_center`
--

INSERT INTO `shift_work_center` (`id`, `shift_id`, `work_center_id`, `effective_from`, `effective_to`, `capacity_override`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '2025-08-14', '2025-09-05', 120, '2025-08-28 09:56:38', '2025-08-28 09:56:38');

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

--
-- Table structure for table `state_master`
--

CREATE TABLE IF NOT EXISTS `state_master` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `state_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_code` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_code` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'IND',
  `zone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `sort_order` int NOT NULL DEFAULT '0',
  `created_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'SYSTEM',
  `updated_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `state_master_state_name_unique` (`state_name`),
  UNIQUE KEY `state_master_state_code_unique` (`state_code`),
  KEY `state_master_state_code_index` (`state_code`),
  KEY `state_master_is_active_index` (`is_active`),
  KEY `state_master_sort_order_index` (`sort_order`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `state_master`
--

INSERT INTO `state_master` (`id`, `state_name`, `state_code`, `short_name`, `country_code`, `zone`, `is_active`, `sort_order`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'Andhra Pradesh', '37', 'AP', 'IND', 'South', 1, 1, 'SYSTEM', NULL, '2025-07-25 09:15:58', '2025-07-25 09:15:58'),
(2, 'Arunachal Pradesh', '12', 'AR', 'IND', 'Northeast', 1, 2, 'SYSTEM', NULL, '2025-07-25 09:15:58', '2025-07-25 09:15:58'),
(3, 'Assam', '18', 'AS', 'IND', 'Northeast', 1, 3, 'SYSTEM', NULL, '2025-07-25 09:15:58', '2025-07-25 09:15:58'),
(4, 'Bihar', '10', 'BR', 'IND', 'East', 1, 4, 'SYSTEM', NULL, '2025-07-25 09:15:58', '2025-07-25 09:15:58'),
(5, 'Chhattisgarh', '22', 'CG', 'IND', 'Central', 1, 5, 'SYSTEM', NULL, '2025-07-25 09:15:58', '2025-07-25 09:15:58'),
(6, 'Goa', '30', 'GA', 'IND', 'West', 1, 6, 'SYSTEM', NULL, '2025-07-25 09:15:58', '2025-07-25 09:15:58'),
(7, 'Gujarat', '24', 'GJ', 'IND', 'West', 1, 7, 'SYSTEM', NULL, '2025-07-25 09:15:58', '2025-07-25 09:15:58'),
(8, 'Haryana', '06', 'HR', 'IND', 'North', 1, 8, 'SYSTEM', NULL, '2025-07-25 09:15:58', '2025-07-25 09:15:58'),
(9, 'Himachal Pradesh', '02', 'HP', 'IND', 'North', 1, 9, 'SYSTEM', NULL, '2025-07-25 09:15:58', '2025-07-25 09:15:58'),
(10, 'Jharkhand', '20', 'JH', 'IND', 'East', 1, 10, 'SYSTEM', NULL, '2025-07-25 09:15:58', '2025-07-25 09:15:58'),
(11, 'Karnataka', '29', 'KA', 'IND', 'South', 1, 11, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(12, 'Kerala', '32', 'KL', 'IND', 'South', 1, 12, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(13, 'Madhya Pradesh', '23', 'MP', 'IND', 'Central', 1, 13, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(14, 'Maharashtra', '27', 'MH', 'IND', 'West', 1, 14, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(15, 'Manipur', '14', 'MN', 'IND', 'Northeast', 1, 15, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(16, 'Meghalaya', '17', 'ML', 'IND', 'Northeast', 1, 16, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(17, 'Mizoram', '15', 'MZ', 'IND', 'Northeast', 1, 17, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(18, 'Nagaland', '13', 'NL', 'IND', 'Northeast', 1, 18, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(19, 'Odisha', '21', 'OD', 'IND', 'East', 1, 19, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(20, 'Punjab', '03', 'PB', 'IND', 'North', 1, 20, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(21, 'Rajasthan', '08', 'RJ', 'IND', 'North', 1, 21, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(22, 'Sikkim', '11', 'SK', 'IND', 'Northeast', 1, 22, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(23, 'Tamil Nadu', '33', 'TN', 'IND', 'South', 1, 23, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(24, 'Telangana', '36', 'TS', 'IND', 'South', 1, 24, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(25, 'Tripura', '16', 'TR', 'IND', 'Northeast', 1, 25, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(26, 'Uttar Pradesh', '09', 'UP', 'IND', 'North', 1, 26, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(27, 'Uttarakhand', '05', 'UK', 'IND', 'North', 1, 27, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(28, 'West Bengal', '19', 'WB', 'IND', 'East', 1, 28, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(29, 'Andaman and Nicobar Islands', '35', 'AN', 'IND', 'Islands', 1, 29, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(30, 'Chandigarh', '04', 'CH', 'IND', 'North', 1, 30, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(31, 'Dadra and Nagar Haveli and Daman and Diu', '26', 'DN', 'IND', 'West', 1, 31, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(32, 'Delhi', '07', 'DL', 'IND', 'North', 1, 32, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(33, 'Jammu and Kashmir', '01', 'JK', 'IND', 'North', 1, 33, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(34, 'Ladakh', '38', 'LA', 'IND', 'North', 1, 34, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(35, 'Lakshadweep', '31', 'LD', 'IND', 'Islands', 1, 35, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59'),
(36, 'Puducherry', '34', 'PY', 'IND', 'South', 1, 36, 'SYSTEM', NULL, '2025-07-25 09:15:59', '2025-07-25 09:15:59');

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

--
-- Table structure for table `stock_balance`
--

CREATE TABLE IF NOT EXISTS `stock_balance` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `company_id` bigint UNSIGNED NOT NULL,
  `product_variant_id` bigint UNSIGNED NOT NULL,
  `warehouse_id` bigint UNSIGNED NOT NULL,
  `warehouse_bin_id` bigint UNSIGNED DEFAULT NULL,
  `actual_qty` decimal(15,3) NOT NULL DEFAULT '0.000',
  `reserved_qty` decimal(15,3) NOT NULL DEFAULT '0.000',
  `ordered_qty` decimal(15,3) NOT NULL DEFAULT '0.000',
  `planned_qty` decimal(15,3) NOT NULL DEFAULT '0.000',
  `available_qty` decimal(15,3) NOT NULL DEFAULT '0.000',
  `stock_uom` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `stock_value` decimal(15,2) NOT NULL DEFAULT '0.00',
  `avg_rate` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `valuation_method` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'FIFO',
  `batch_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `serial_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reorder_level` decimal(15,3) NOT NULL DEFAULT '0.000',
  `reorder_qty` decimal(15,3) NOT NULL DEFAULT '0.000',
  `max_level` decimal(15,3) NOT NULL DEFAULT '0.000',
  `min_level` decimal(15,3) NOT NULL DEFAULT '0.000',
  `safety_stock` decimal(15,3) NOT NULL DEFAULT '0.000',
  `last_transaction_date` date DEFAULT NULL,
  `last_transaction_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_purchase_rate` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `last_sales_rate` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `qty_0_30_days` decimal(15,3) NOT NULL DEFAULT '0.000',
  `qty_31_60_days` decimal(15,3) NOT NULL DEFAULT '0.000',
  `qty_61_90_days` decimal(15,3) NOT NULL DEFAULT '0.000',
  `qty_over_90_days` decimal(15,3) NOT NULL DEFAULT '0.000',
  `good_qty` decimal(15,3) NOT NULL DEFAULT '0.000',
  `damaged_qty` decimal(15,3) NOT NULL DEFAULT '0.000',
  `expired_qty` decimal(15,3) NOT NULL DEFAULT '0.000',
  `obsolete_qty` decimal(15,3) NOT NULL DEFAULT '0.000',
  `quarantine_qty` decimal(15,3) NOT NULL DEFAULT '0.000',
  `total_batches` int NOT NULL DEFAULT '0',
  `earliest_expiry_date` date DEFAULT NULL,
  `batch_summary` json DEFAULT NULL,
  `turnover_ratio` decimal(8,2) NOT NULL DEFAULT '0.00',
  `days_since_last_movement` int NOT NULL DEFAULT '0',
  `is_slow_moving` tinyint(1) NOT NULL DEFAULT '0',
  `is_fast_moving` tinyint(1) NOT NULL DEFAULT '0',
  `is_dead_stock` tinyint(1) NOT NULL DEFAULT '0',
  `below_reorder_level` tinyint(1) NOT NULL DEFAULT '0',
  `near_expiry` tinyint(1) NOT NULL DEFAULT '0',
  `overstock` tinyint(1) NOT NULL DEFAULT '0',
  `active_alerts` json DEFAULT NULL,
  `last_updated_from_ledger` timestamp NULL DEFAULT NULL,
  `requires_rebalancing` tinyint(1) NOT NULL DEFAULT '0',
  `reconciliation_notes` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_stock_balance` (`company_id`,`product_variant_id`,`warehouse_id`),
  KEY `stock_balance_product_variant_id_foreign` (`product_variant_id`),
  KEY `stock_balance_warehouse_id_foreign` (`warehouse_id`),
  KEY `idx_stock_balance_reorder` (`below_reorder_level`,`warehouse_id`),
  KEY `idx_stock_balance_movement` (`is_slow_moving`,`is_dead_stock`),
  KEY `idx_stock_balance_expiry` (`near_expiry`,`earliest_expiry_date`),
  KEY `stock_balance_warehouse_bin_id_foreign` (`warehouse_bin_id`),
  KEY `idx_stock_balance_bin` (`company_id`,`product_variant_id`,`warehouse_id`,`warehouse_bin_id`),
  KEY `idx_stock_balance_batch_serial` (`batch_no`,`serial_no`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `stock_balance_uoms`
--

CREATE TABLE IF NOT EXISTS `stock_balance_uoms` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `company_id` bigint UNSIGNED NOT NULL,
  `product_variant_id` bigint UNSIGNED NOT NULL,
  `warehouse_id` bigint UNSIGNED NOT NULL,
  `uom_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `factor_to_base` decimal(24,12) NOT NULL DEFAULT '1.000000000000',
  `qty_in_uom` decimal(24,12) NOT NULL DEFAULT '0.000000000000',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_balance_uoms` (`company_id`,`product_variant_id`,`warehouse_id`,`uom_code`),
  KEY `stock_balance_uoms_warehouse_id_foreign` (`warehouse_id`),
  KEY `stock_balance_uoms_product_variant_id_warehouse_id_index` (`product_variant_id`,`warehouse_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `stock_ledger`
--

CREATE TABLE IF NOT EXISTS `stock_ledger` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `company_id` bigint UNSIGNED NOT NULL,
  `product_variant_id` bigint UNSIGNED NOT NULL,
  `warehouse_id` bigint UNSIGNED NOT NULL,
  `warehouse_bin_id` bigint UNSIGNED DEFAULT NULL,
  `voucher_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `voucher_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `posting_date` date NOT NULL,
  `posting_time` timestamp NOT NULL,
  `actual_qty` decimal(15,3) NOT NULL DEFAULT '0.000',
  `qty_after_transaction` decimal(15,3) NOT NULL DEFAULT '0.000',
  `stock_uom` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `stock_uom_rate` decimal(10,6) NOT NULL DEFAULT '1.000000',
  `incoming_rate` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `outgoing_rate` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `stock_value` decimal(15,2) NOT NULL DEFAULT '0.00',
  `stock_value_difference` decimal(15,2) NOT NULL DEFAULT '0.00',
  `balance_stock_value` decimal(15,2) NOT NULL DEFAULT '0.00',
  `valuation_method` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'FIFO',
  `batch_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `serial_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `manufacturing_date` date DEFAULT NULL,
  `reference_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_details` json DEFAULT NULL,
  `quality_inspection` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACCEPTED',
  `stock_condition` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'GOOD',
  `project_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cost_center` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `department` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_cancelled` tinyint(1) NOT NULL DEFAULT '0',
  `cancelled_at` timestamp NULL DEFAULT NULL,
  `cancelled_by` bigint UNSIGNED DEFAULT NULL,
  `cancellation_reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `stock_ledger_product_variant_id_foreign` (`product_variant_id`),
  KEY `stock_ledger_warehouse_id_foreign` (`warehouse_id`),
  KEY `idx_stock_ledger_main` (`company_id`,`product_variant_id`,`warehouse_id`,`posting_date`),
  KEY `idx_stock_ledger_voucher` (`voucher_type`,`voucher_number`),
  KEY `idx_stock_ledger_batch_serial` (`batch_no`,`serial_no`),
  KEY `idx_stock_ledger_time` (`posting_date`,`posting_time`),
  KEY `idx_stock_ledger_bin` (`warehouse_bin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `stock_ledger_uoms`
--

CREATE TABLE IF NOT EXISTS `stock_ledger_uoms` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `stock_ledger_id` bigint UNSIGNED NOT NULL,
  `product_variant_id` bigint UNSIGNED NOT NULL,
  `uom_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `qty_entered` decimal(24,12) NOT NULL,
  `factor_to_base` decimal(24,12) NOT NULL,
  `qty_in_base` decimal(24,12) NOT NULL,
  `is_base` tinyint(1) NOT NULL DEFAULT '0',
  `context` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `stock_ledger_uoms_stock_ledger_id_index` (`stock_ledger_id`),
  KEY `stock_ledger_uoms_product_variant_id_index` (`product_variant_id`),
  KEY `stock_ledger_uoms_uom_code_index` (`uom_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `terms_conditions`
--

CREATE TABLE IF NOT EXISTS `terms_conditions` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `company_id` bigint UNSIGNED NOT NULL,
  `template_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `template_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `template_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `document_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `version_number` int NOT NULL DEFAULT '1',
  `terms_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `terms_sections` json DEFAULT NULL,
  `header_text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `footer_text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `custom_fields` json DEFAULT NULL,
  `payment_terms` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_due_days` int NOT NULL DEFAULT '30',
  `early_payment_discount` decimal(5,2) NOT NULL DEFAULT '0.00',
  `early_payment_days` int NOT NULL DEFAULT '0',
  `late_payment_penalty` decimal(5,2) NOT NULL DEFAULT '0.00',
  `preferred_payment_method` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery_terms` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery_lead_time_days` int NOT NULL DEFAULT '0',
  `shipping_method` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `packaging_instructions` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `insurance_required` tinyint(1) NOT NULL DEFAULT '0',
  `risk_transfer_point` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `warranty_period` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `warranty_terms` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `support_level` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `maintenance_terms` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `extended_warranty_available` tinyint(1) NOT NULL DEFAULT '0',
  `governing_law` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jurisdiction` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dispute_resolution` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `limitation_of_liability` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `intellectual_property` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `confidentiality` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `cancellation_policy` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `return_policy` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `refund_policy` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `cancellation_charges` decimal(5,2) NOT NULL DEFAULT '0.00',
  `price_validity_days` int NOT NULL DEFAULT '30',
  `prices_subject_to_change` tinyint(1) NOT NULL DEFAULT '0',
  `quality_standards` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `inspection_terms` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `buyer_inspection_required` tinyint(1) NOT NULL DEFAULT '0',
  `inspection_period_days` int NOT NULL DEFAULT '7',
  `rejection_terms` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `force_majeure_clause` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `risk_mitigation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `insurance_requirements` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `covid_specific_terms` tinyint(1) NOT NULL DEFAULT '0',
  `performance_standards` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `penalty_structure` json DEFAULT NULL,
  `service_level_agreement` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `performance_bond_percentage` decimal(5,2) NOT NULL DEFAULT '0.00',
  `environmental_compliance` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `social_responsibility` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sustainability_requirements` tinyint(1) NOT NULL DEFAULT '0',
  `ethical_standards` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `approval_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DRAFT',
  `approved_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `approved_at` timestamp NULL DEFAULT NULL,
  `legal_review_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `legal_review_at` timestamp NULL DEFAULT NULL,
  `review_notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `usage_count` int NOT NULL DEFAULT '0',
  `last_used_date` timestamp NULL DEFAULT NULL,
  `usage_statistics` json DEFAULT NULL,
  `auto_include_in_documents` tinyint(1) NOT NULL DEFAULT '0',
  `auto_include_conditions` json DEFAULT NULL,
  `requires_customer_acceptance` tinyint(1) NOT NULL DEFAULT '0',
  `digital_signature_required` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_terms_template` (`company_id`,`template_code`),
  KEY `idx_terms_conditions_main` (`template_type`,`document_type`,`is_active`),
  KEY `idx_terms_conditions_approval` (`approval_status`,`is_default`),
  KEY `idx_terms_conditions_version` (`company_id`,`version_number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `uom_conversion`
--

CREATE TABLE IF NOT EXISTS `uom_conversion` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `from_uom_id` bigint UNSIGNED NOT NULL,
  `to_uom_id` bigint UNSIGNED NOT NULL,
  `multiply_factor` decimal(16,6) DEFAULT NULL,
  `conversion_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'factor',
  `rule_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `offset` decimal(16,6) DEFAULT NULL,
  `formula_expr` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `variables_used` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scope` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'global',
  `context` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `valid_from` date DEFAULT NULL,
  `valid_to` date DEFAULT NULL,
  `version` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rounding_override` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `min_increment_override` decimal(10,4) DEFAULT NULL,
  `product_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Optional: restrict conversion to specific product',
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Additional conversion notes',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'system',
  `updated_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_uom_conversion_ids` (`from_uom_id`,`to_uom_id`,`product_id`),
  KEY `uom_conversion_product_id_index` (`product_id`),
  KEY `uom_conversion_is_active_index` (`is_active`),
  KEY `uom_conversion_to_uom_id_foreign` (`to_uom_id`),
  KEY `uom_conversion_from_uom_id_to_uom_id_index` (`from_uom_id`,`to_uom_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `uom_conversion`
--

INSERT INTO `uom_conversion` (`id`, `from_uom_id`, `to_uom_id`, `multiply_factor`, `conversion_type`, `rule_name`, `offset`, `formula_expr`, `variables_used`, `scope`, `context`, `valid_from`, `valid_to`, `version`, `rounding_override`, `min_increment_override`, `product_id`, `notes`, `is_active`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 7, 5, 1.000000, 'formula', NULL, NULL, 'qty * WIDTH', 'WIDTH', 'global', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'admin', NULL, '2025-10-04 15:01:03', '2025-10-04 15:01:03');

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

--
-- Table structure for table `uom_master`
--

CREATE TABLE IF NOT EXISTS `uom_master` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `uom_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `uom_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `uom_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'QUANTITY' COMMENT 'Type: LENGTH, WEIGHT, VOLUME, QUANTITY, AREA, TIME',
  `precision` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `rounding_policy` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'nearest',
  `min_increment` decimal(10,4) NOT NULL DEFAULT '1.0000',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Detailed description of the UOM',
  `symbol` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Symbol like kg, m, pcs',
  `base_unit_factor` decimal(14,4) NOT NULL DEFAULT '1.0000' COMMENT 'Factor to convert to base unit',
  `base_uom_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Reference to base UOM for this type',
  `is_base_unit` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is this the base unit for its type?',
  `uom_category` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `sort_order` int NOT NULL DEFAULT '0',
  `created_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `deleted_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uom_master_uom_code_unique` (`uom_code`),
  KEY `uom_master_is_active_index` (`is_active`),
  KEY `uom_master_uom_type_index` (`uom_type`),
  KEY `uom_master_uom_type_is_active_index` (`uom_type`,`is_active`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `uom_master`
--

INSERT INTO `uom_master` (`id`, `uom_code`, `uom_name`, `uom_type`, `precision`, `rounding_policy`, `min_increment`, `description`, `symbol`, `base_unit_factor`, `base_uom_code`, `is_base_unit`, `uom_category`, `is_active`, `sort_order`, `created_by`, `updated_by`, `is_deleted`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'MTR', 'Meter', 'LENGTH', 0, 'nearest', 1.0000, '', '', 1.0000, NULL, 1, NULL, 1, 0, 'AJIT HOGADE', NULL, 0, '2025-09-25 05:53:14', '2025-09-25 00:23:14', '2025-09-25 00:23:14'),
(2, 'PCS', 'Piece', 'QUANTITY', 0, 'nearest', 1.0000, '', '', 1.0000, NULL, 1, NULL, 1, 0, 'AJIT HOGADE', NULL, 0, '2025-09-25 05:54:22', '2025-09-25 00:24:22', '2025-09-25 00:24:22'),
(3, 'BOX', 'BOX', 'QUANTITY', 0, 'nearest', 1.0000, '', '', 1.0000, NULL, 1, NULL, 1, 0, 'AJIT HOGADE', NULL, 0, '2025-09-26 07:32:37', '2025-09-26 02:02:37', '2025-09-26 02:02:37'),
(4, 'FT', 'FEET', 'LENGTH', 0, 'nearest', 1.0000, '', '', 1.0000, NULL, 1, NULL, 1, 0, 'AJIT HOGADE', NULL, 0, '2025-09-27 10:39:54', '2025-09-27 05:09:54', '2025-09-27 05:09:54'),
(5, 'SQM', 'Square Meter', 'AREA', 0, 'nearest', 1.0000, '', '', 1.0000, NULL, 1, NULL, 1, 0, 'AJIT HOGADE', NULL, 0, '2025-09-27 10:41:44', '2025-09-27 05:11:44', '2025-09-27 05:11:44'),
(6, 'SQF', 'Square Feet', 'AREA', 0, 'nearest', 1.0000, '', '', 1.0000, NULL, 1, NULL, 1, 0, 'AJIT HOGADE', 'AJIT HOGADE', 0, '2025-09-27 10:42:26', '2025-09-27 05:12:26', '2025-09-27 05:12:38'),
(7, 'RM', 'Running Meter', 'LENGTH', 0, 'nearest', 1.0000, '', '', 1.0000, NULL, 1, NULL, 1, 0, 'AJIT HOGADE', NULL, 0, '2025-09-27 10:48:54', '2025-09-27 05:18:54', '2025-09-27 05:18:54');

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

--
-- Table structure for table `uom_rules_map`
--

CREATE TABLE IF NOT EXISTS `uom_rules_map` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_id` bigint UNSIGNED NOT NULL,
  `conversion_id` bigint UNSIGNED NOT NULL,
  `context` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uom_rules_map_unique` (`product_id`,`conversion_id`,`context`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `uom_rules_map`
--

INSERT INTO `uom_rules_map` (`id`, `product_id`, `conversion_id`, `context`, `is_active`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 45, 1, NULL, 1, 'admin', NULL, '2025-10-06 11:05:38', '2025-10-06 11:05:38');

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

--
-- Table structure for table `user_groups`
--

CREATE TABLE IF NOT EXISTS `user_groups` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `company_id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVE',
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_groups_company_id_name_unique` (`company_id`,`name`),
  KEY `user_groups_created_by_foreign` (`created_by`),
  KEY `user_groups_updated_by_foreign` (`updated_by`),
  KEY `user_groups_deleted_by_foreign` (`deleted_by`),
  KEY `user_groups_company_id_status_index` (`company_id`,`status`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_groups`
--

INSERT INTO `user_groups` (`id`, `company_id`, `name`, `status`, `description`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'Temp Group', 'ACTIVE', NULL, 1, 1, NULL, '2025-10-01 08:09:29', '2025-10-01 11:43:47', NULL);

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

--
-- Table structure for table `user_group_role`
--

CREATE TABLE IF NOT EXISTS `user_group_role` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_group_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_group_role_user_group_id_role_id_unique` (`user_group_id`,`role_id`),
  KEY `user_group_role_role_id_index` (`role_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_group_user`
--

CREATE TABLE IF NOT EXISTS `user_group_user` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_group_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_group_user_user_group_id_user_id_unique` (`user_group_id`,`user_id`),
  KEY `user_group_user_user_id_index` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_group_user`
--

INSERT INTO `user_group_user` (`id`, `user_group_id`, `user_id`, `created_at`, `updated_at`) VALUES
(8, 6, 10, '2025-10-01 06:55:02', '2025-10-01 06:55:02'),
(7, 6, 6, '2025-10-01 06:54:45', '2025-10-01 06:54:45'),
(9, 6, 2, '2025-10-01 06:56:06', '2025-10-01 06:56:06'),
(10, 7, 6, '2025-10-01 07:02:38', '2025-10-01 07:02:38'),
(11, 7, 10, '2025-10-01 07:02:38', '2025-10-01 07:02:38'),
(13, 8, 6, '2025-10-01 07:08:30', '2025-10-01 07:08:30'),
(14, 5, 6, '2025-10-01 07:26:47', '2025-10-01 07:26:47'),
(27, 1, 10, '2025-10-01 13:31:44', '2025-10-01 13:31:44'),
(26, 1, 6, '2025-10-01 13:31:44', '2025-10-01 13:31:44'),
(25, 1, 2, '2025-10-01 13:31:44', '2025-10-01 13:31:44');

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

--
-- Table structure for table `vendor_master`
--

CREATE TABLE IF NOT EXISTS `vendor_master` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `vendor_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `vendor_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `vendor_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vendor_category` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_person` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `country` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'India',
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `default_currency` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'INR',
  `payment_terms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `credit_limit` decimal(15,2) NOT NULL DEFAULT '0.00',
  `tds_applicable` tinyint(1) NOT NULL DEFAULT '0',
  `tds_section` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `msme_registered` tinyint(1) NOT NULL DEFAULT '0',
  `msme_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vendor_master_vendor_code_unique` (`vendor_code`),
  KEY `vendor_master_vendor_code_index` (`vendor_code`),
  KEY `vendor_master_vendor_name_index` (`vendor_name`),
  KEY `vendor_master_vendor_type_index` (`vendor_type`),
  KEY `vendor_master_status_index` (`status`),
  KEY `vendor_master_city_index` (`city`),
  KEY `vendor_master_state_index` (`state`),
  KEY `vendor_master_created_by_foreign` (`created_by`),
  KEY `vendor_master_updated_by_foreign` (`updated_by`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vendor_masters`
--

CREATE TABLE IF NOT EXISTS `vendor_masters` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `vendor_code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `vendor_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `vendor_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'REGULAR',
  `vendor_category` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'India',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `default_currency` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'INR',
  `payment_terms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `credit_limit` decimal(18,2) DEFAULT NULL,
  `tds_applicable` tinyint(1) NOT NULL DEFAULT '0',
  `tds_section` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `msme_registered` tinyint(1) NOT NULL DEFAULT '0',
  `msme_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `company_id` bigint UNSIGNED DEFAULT NULL,
  `msme_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `msme_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tds_category` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `credit_days` int NOT NULL DEFAULT '0',
  `price_list_id` bigint UNSIGNED DEFAULT NULL,
  `tax_preference` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'TAXABLE',
  `vendor_rating` decimal(3,1) NOT NULL DEFAULT '0.0',
  `is_sub_contractor` tinyint(1) NOT NULL DEFAULT '0',
  `opening_balance` decimal(15,2) NOT NULL DEFAULT '0.00',
  `opening_balance_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'CR',
  `territory` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `industry_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `internal_notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_frozen` tinyint(1) NOT NULL DEFAULT '0',
  `registration_date` date DEFAULT NULL,
  `custom_fields` json DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vendor_master_vendor_code_unique` (`vendor_code`),
  KEY `vendor_master_vendor_code_index` (`vendor_code`),
  KEY `vendor_master_vendor_type_index` (`vendor_type`),
  KEY `vendor_master_status_index` (`status`),
  KEY `vendor_master_company_id_foreign` (`company_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `warehouse_bins`
--

CREATE TABLE IF NOT EXISTS `warehouse_bins` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `company_id` bigint UNSIGNED DEFAULT NULL,
  `warehouse_id` bigint UNSIGNED NOT NULL,
  `bin_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bin_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `capacity_info` json DEFAULT NULL,
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVE',
  `created_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `warehouse_bins_warehouse_id_bin_code_unique` (`warehouse_id`,`bin_code`),
  KEY `warehouse_bins_company_id_status_index` (`company_id`,`status`),
  KEY `warehouse_bins_warehouse_id_is_default_index` (`warehouse_id`,`is_default`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `warehouse_master`
--

CREATE TABLE IF NOT EXISTS `warehouse_master` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `warehouse_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `warehouse_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `manager_user_id` bigint UNSIGNED DEFAULT NULL,
  `manager_id` bigint UNSIGNED DEFAULT NULL,
  `company_id` bigint UNSIGNED NOT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `capacity_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_main_warehouse` tinyint(1) NOT NULL DEFAULT '0',
  `is_sales_warehouse` tinyint(1) NOT NULL DEFAULT '1',
  `is_purchase_warehouse` tinyint(1) NOT NULL DEFAULT '1',
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVE',
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `plant_id` bigint UNSIGNED DEFAULT NULL,
  `department_id` bigint UNSIGNED DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state_id` bigint UNSIGNED DEFAULT NULL,
  `state_code` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pincode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relationship_type` enum('PLANT_BASED','INDEPENDENT','SHARED','THIRD_PARTY') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PLANT_BASED' COMMENT 'Defines how warehouse relates to organizational structure',
  `warehouse_function` enum('STORAGE','RAW_MATERIAL','WORK_IN_PROGRESS','FINISHED_GOODS','DISTRIBUTION','TRANSIT','QUARANTINE','RETURN_GOODS','GENERAL') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'GENERAL' COMMENT 'Specific function/purpose of the warehouse',
  PRIMARY KEY (`id`),
  UNIQUE KEY `warehouse_master_warehouse_code_unique` (`warehouse_code`),
  KEY `warehouse_master_warehouse_code_index` (`warehouse_code`),
  KEY `warehouse_master_status_index` (`status`),
  KEY `warehouse_master_is_main_warehouse_index` (`is_main_warehouse`),
  KEY `warehouse_master_plant_id_foreign` (`plant_id`),
  KEY `idx_warehouse_company_plant` (`company_id`,`plant_id`),
  KEY `idx_warehouse_type_relation` (`relationship_type`),
  KEY `idx_warehouse_status_function` (`status`,`warehouse_function`),
  KEY `warehouse_master_department_id_foreign` (`department_id`),
  KEY `warehouse_master_state_id_foreign` (`state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `warehouse_master`
--

INSERT INTO `warehouse_master` (`id`, `warehouse_code`, `warehouse_name`, `manager_user_id`, `manager_id`, `company_id`, `phone`, `email`, `capacity_info`, `is_main_warehouse`, `is_sales_warehouse`, `is_purchase_warehouse`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `plant_id`, `department_id`, `address`, `city`, `state_id`, `state_code`, `pincode`, `relationship_type`, `warehouse_function`) VALUES
(1, 'WH001', 'mW1', 1, 1, 1, '9004588982', 'dummy@dot-next.in', '{\"text\":\"Thane\"}', 1, 0, 1, 'ACTIVE', 0, 1, '2025-08-23 07:55:53', '2025-08-24 07:33:28', 2, NULL, 'Nerul', 'Navi Mumbai', 14, '27', '400703', 'PLANT_BASED', 'STORAGE'),
(2, 'WH002', 'Nerul', 1, 1, 1, NULL, NULL, NULL, 1, 1, 0, 'ACTIVE', 0, 1, '2025-08-23 08:35:39', '2025-08-24 07:26:32', 2, NULL, 'Nerul', 'Navi Mumbai', 14, '27', '400703', 'PLANT_BASED', 'STORAGE'),
(3, 'WH003', 'GH', NULL, 1, 1, NULL, NULL, NULL, 0, 1, 1, 'ACTIVE', 0, 0, '2025-08-23 08:57:23', '2025-08-23 08:57:23', 2, NULL, 'Nerul', 'Navi Mumbai', 14, '27', '400703', 'PLANT_BASED', 'GENERAL'),
(4, 'SMKbfcd', 'Smoke WH', NULL, NULL, 1, '9876543210', 'updated@example.com', '1500 sq ft • 6000 kg max', 0, 1, 1, 'ACTIVE', 1, 1, '2025-08-24 07:20:53', '2025-08-24 07:20:53', 2, NULL, NULL, NULL, NULL, NULL, NULL, 'PLANT_BASED', 'GENERAL'),
(5, 'WH003-MUM', 'MC WH', 1, 1, 1, '9004588982', 'ap28@indiataekwondo.com', '100000', 0, 1, 1, 'ACTIVE', 1, 1, '2025-08-24 07:32:53', '2025-08-24 07:33:07', 2, NULL, 'Nerul', 'Navi Mumbai', 14, '27', '400703', 'PLANT_BASED', 'GENERAL');
COMMIT;

