/
NLObP
/
AAEmu
Обзор
Документация
Войти
/
NLObP
/
AAEmu
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
develop
SQL/examples/example-ics-default-en.sql
776 строк
40 KB
ZeromusXYZ
[Game] In-Game cash shop rewrite (#826)
26 фев 2024, 14:15
Не верифицирован
26 фев 2024, 14:15
040611d
Код
Авторство
О чём код?
-- -------------------------------------------------------- -- Host: 127.0.0.1 -- Server version: 8.0.12 - MySQL Community Server - GPL -- Server OS: Linux -- HeidiSQL Version: 12.6.0.6765 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- Dumping structure for table aaemu_game.ics_menu DROP TABLE IF EXISTS `ics_menu`; CREATE TABLE IF NOT EXISTS `ics_menu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `main_tab` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'Which main tab to display on', `sub_tab` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'Which sub tab to display on', `tab_pos` int(11) NOT NULL DEFAULT '0' COMMENT 'Used to change display order', `shop_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Id of the item group for sale (shop item)', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=757 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Contains what item will be displayed on which tab'; -- Dumping data for table aaemu_game.ics_menu: ~342 rows (approximately) REPLACE INTO `ics_menu` (`id`, `main_tab`, `sub_tab`, `tab_pos`, `shop_id`) VALUES (2, 1, 2, 1, 2000003), (3, 1, 2, 2, 2000000), (4, 1, 2, 3, 2000001), (16, 5, 3, 1, 2000004), (17, 5, 3, 3, 2000005), (18, 5, 3, 2, 2000006), (19, 5, 3, 4, 2000007), (20, 5, 3, 5, 2000008), (21, 5, 3, 6, 2000009), (22, 5, 3, 7, 2000010), (23, 5, 3, 9, 2000011), (24, 5, 3, 8, 2000012), (26, 5, 3, 10, 2000014), (27, 5, 3, 11, 2000015), (28, 5, 3, 12, 2000016), (29, 5, 3, 13, 2000017), (30, 5, 3, 14, 2000018), (31, 5, 3, 15, 2000019), (32, 5, 3, 16, 2000020), (33, 5, 3, 17, 2000021), (34, 5, 3, 18, 2000026), (35, 5, 3, 19, 2000022), (36, 5, 3, 20, 2000023), (37, 5, 3, 21, 2000024), (38, 5, 3, 22, 2000025), (39, 5, 3, 23, 2000013), (40, 5, 3, 24, 2000027), (41, 5, 3, 25, 2000028), (42, 5, 3, 26, 2000029), (43, 5, 3, 27, 2000030), (44, 5, 3, 28, 2000031), (45, 5, 3, 29, 2000032), (46, 5, 3, 30, 2000033), (47, 5, 3, 31, 2000034), (48, 5, 3, 32, 2000035), (49, 5, 3, 33, 2000036), (50, 5, 3, 34, 2000037), (51, 5, 3, 35, 2000038), (52, 5, 3, 36, 2000039), (53, 5, 3, 37, 2000040), (54, 5, 3, 38, 2000041), (55, 5, 3, 39, 2000042), (57, 5, 3, 40, 2000045), (58, 5, 3, 41, 2000046), (59, 5, 3, 42, 2000047), (60, 5, 3, 43, 2000048), (61, 5, 3, 44, 2000049), (62, 5, 3, 45, 2000050), (63, 5, 3, 46, 2000051), (64, 5, 3, 47, 2000052), (65, 5, 3, 0, 2000053), (66, 5, 3, 48, 2000054), (67, 5, 3, 49, 2000055), (68, 5, 3, 50, 2000056), (70, 5, 3, 51, 2000058), (71, 5, 3, 52, 2000059), (131, 5, 2, 0, 2000060), (247, 3, 4, 0, 2000061), (248, 3, 4, 1, 2000062), (249, 2, 3, 6, 2000063), (250, 2, 3, 7, 2000064), (251, 2, 3, 8, 2000065), (252, 2, 3, 9, 2000066), (253, 2, 3, 10, 2000067), (254, 2, 3, 11, 2000068), (255, 2, 3, 12, 2000069), (256, 2, 3, 13, 2000070), (257, 2, 3, 14, 2000071), (258, 2, 3, 15, 2000072), (259, 2, 3, 16, 2000073), (260, 2, 3, 17, 2000074), (261, 2, 3, 18, 2000075), (262, 2, 3, 19, 2000076), (263, 2, 3, 20, 2000077), (264, 2, 3, 21, 2000078), (265, 2, 3, 22, 2000079), (266, 2, 3, 23, 2000080), (267, 2, 3, 24, 2000081), (268, 2, 3, 25, 2000082), (269, 2, 2, 0, 2000083), (270, 2, 4, 0, 2000002), (271, 2, 2, 1, 2000084), (272, 2, 3, 0, 2000000), (273, 2, 3, 1, 2000001), (274, 2, 2, 2, 2000061), (275, 2, 2, 3, 2000062), (279, 2, 3, 2, 2000085), (280, 2, 3, 3, 2000086), (281, 2, 3, 4, 2000087), (282, 2, 3, 5, 2000088), (283, 3, 3, 1, 2000089), (318, 3, 3, 0, 2000090), (319, 2, 4, 1, 2000093), (320, 2, 4, 2, 2000091), (321, 2, 4, 3, 2000092), (322, 2, 4, 4, 2000094), (323, 4, 3, 2, 2000095), (324, 4, 3, 3, 2000096), (325, 4, 3, 4, 2000097), (326, 4, 3, 5, 2000098), (327, 4, 3, 6, 2000099), (328, 4, 3, 7, 2000100), (329, 4, 3, 8, 2000101), (330, 4, 3, 9, 2000102), (331, 4, 3, 10, 2000103), (332, 4, 3, 11, 2000104), (333, 4, 3, 12, 2000105), (334, 4, 3, 13, 2000106), (335, 4, 3, 14, 2000107), (336, 4, 3, 16, 2000108), (337, 4, 3, 17, 2000109), (338, 4, 3, 15, 2000110), (339, 4, 3, 18, 2000111), (340, 4, 3, 19, 2000112), (341, 4, 3, 20, 2000113), (342, 4, 3, 21, 2000114), (343, 4, 3, 22, 2000115), (344, 4, 3, 23, 2000116), (345, 4, 3, 24, 2000117), (346, 4, 3, 25, 2000118), (347, 4, 3, 26, 2000119), (348, 4, 3, 0, 2000120), (349, 4, 3, 1, 2000121), (350, 1, 2, 4, 2000122), (351, 4, 2, 0, 2000123), (352, 4, 2, 1, 2000124), (353, 4, 2, 2, 2000125), (354, 6, 7, 0, 2000126), (355, 6, 7, 1, 2000127), (356, 6, 7, 2, 2000128), (488, 3, 3, 2, 2000130), (489, 3, 3, 3, 2000131), (490, 3, 3, 4, 2000132), (491, 3, 3, 5, 2000129), (492, 5, 2, 1, 2000133), (493, 5, 2, 2, 2000134), (494, 5, 2, 3, 2000135), (495, 5, 2, 4, 2000136), (496, 5, 2, 5, 2000137), (497, 5, 2, 6, 2000138), (498, 5, 2, 7, 2000139), (499, 5, 2, 8, 2000140), (500, 5, 2, 9, 2000141), (501, 5, 2, 10, 2000142), (502, 5, 2, 11, 2000143), (503, 5, 2, 12, 2000144), (504, 5, 2, 13, 2000145), (505, 5, 2, 14, 2000146), (506, 5, 2, 15, 2000147), (507, 5, 2, 16, 2000148), (508, 5, 2, 17, 2000149), (509, 5, 2, 18, 2000150), (510, 5, 2, 19, 2000151), (511, 5, 2, 20, 2000152), (512, 5, 4, 0, 2000153), (513, 5, 4, 1, 2000154), (514, 5, 4, 6, 2000155), (515, 5, 4, 7, 2000156), (516, 5, 4, 8, 2000157), (517, 5, 4, 2, 2000158), (518, 5, 4, 3, 2000159), (519, 5, 4, 4, 2000160), (520, 5, 4, 5, 2000161), (521, 6, 3, 0, 2000162), (522, 6, 2, 0, 2000163), (528, 6, 5, 0, 2000166), (529, 6, 2, 1, 2000164), (530, 6, 2, 2, 2000165), (531, 6, 1, 0, 2000163), (532, 6, 1, 1, 2000164), (533, 6, 1, 2, 2000165), (534, 6, 1, 3, 2000162), (535, 6, 1, 4, 2000166), (536, 6, 1, 5, 2000126), (537, 6, 1, 6, 2000127), (538, 6, 1, 7, 2000128), (539, 5, 1, 0, 2000060), (540, 5, 1, 1, 2000133), (541, 5, 1, 2, 2000134), (542, 5, 1, 3, 2000135), (543, 5, 1, 4, 2000136), (544, 5, 1, 5, 2000137), (545, 5, 1, 6, 2000138), (546, 5, 1, 7, 2000139), (547, 5, 1, 8, 2000140), (548, 5, 1, 9, 2000141), (549, 5, 1, 10, 2000142), (550, 5, 1, 11, 2000143), (551, 5, 1, 12, 2000144), (552, 5, 1, 13, 2000145), (553, 5, 1, 14, 2000146), (554, 5, 1, 15, 2000147), (555, 5, 1, 16, 2000148), (556, 5, 1, 17, 2000149), (557, 5, 1, 18, 2000150), (558, 5, 1, 19, 2000151), (559, 5, 1, 20, 2000152), (560, 5, 1, 21, 2000053), (561, 5, 1, 22, 2000004), (562, 5, 1, 23, 2000006), (563, 5, 1, 24, 2000005), (564, 5, 1, 25, 2000007), (565, 5, 1, 26, 2000008), (566, 5, 1, 27, 2000009), (567, 5, 1, 28, 2000010), (568, 5, 1, 29, 2000012), (569, 5, 1, 30, 2000011), (570, 5, 1, 31, 2000014), (571, 5, 1, 32, 2000015), (572, 5, 1, 33, 2000016), (573, 5, 1, 34, 2000017), (574, 5, 1, 35, 2000018), (575, 5, 1, 36, 2000019), (576, 5, 1, 37, 2000020), (577, 5, 1, 38, 2000021), (578, 5, 1, 39, 2000026), (579, 5, 1, 40, 2000022), (580, 5, 1, 41, 2000023), (581, 5, 1, 42, 2000024), (582, 5, 1, 43, 2000025), (583, 5, 1, 44, 2000013), (584, 5, 1, 45, 2000027), (585, 5, 1, 46, 2000028), (586, 5, 1, 47, 2000029), (587, 5, 1, 48, 2000030), (588, 5, 1, 49, 2000031), (589, 5, 1, 50, 2000032), (590, 5, 1, 51, 2000033), (591, 5, 1, 52, 2000034), (592, 5, 1, 53, 2000035), (593, 5, 1, 54, 2000036), (594, 5, 1, 55, 2000037), (595, 5, 1, 56, 2000038), (596, 5, 1, 57, 2000039), (597, 5, 1, 58, 2000040), (598, 5, 1, 59, 2000041), (599, 5, 1, 60, 2000042), (600, 5, 1, 61, 2000045), (601, 5, 1, 62, 2000046), (602, 5, 1, 63, 2000047), (603, 5, 1, 64, 2000048), (604, 5, 1, 65, 2000049), (605, 5, 1, 66, 2000050), (606, 5, 1, 67, 2000051), (607, 5, 1, 68, 2000052), (608, 5, 1, 69, 2000054), (609, 5, 1, 70, 2000055), (610, 5, 1, 71, 2000056), (611, 5, 1, 72, 2000058), (612, 5, 1, 73, 2000059), (613, 5, 1, 74, 2000153), (614, 5, 1, 75, 2000154), (615, 5, 1, 76, 2000158), (616, 5, 1, 77, 2000159), (617, 5, 1, 78, 2000160), (618, 5, 1, 79, 2000161), (619, 5, 1, 80, 2000155), (620, 5, 1, 81, 2000156), (621, 5, 1, 82, 2000157), (622, 4, 1, 0, 2000123), (623, 4, 1, 1, 2000124), (624, 4, 1, 2, 2000125), (625, 4, 1, 3, 2000120), (626, 4, 1, 4, 2000121), (627, 4, 1, 5, 2000095), (628, 4, 1, 6, 2000096), (629, 4, 1, 7, 2000097), (630, 4, 1, 8, 2000098), (631, 4, 1, 9, 2000099), (632, 4, 1, 10, 2000100), (633, 4, 1, 11, 2000101), (634, 4, 1, 12, 2000102), (635, 4, 1, 13, 2000103), (636, 4, 1, 14, 2000104), (637, 4, 1, 15, 2000105), (638, 4, 1, 16, 2000106), (639, 4, 1, 17, 2000107), (640, 4, 1, 18, 2000110), (641, 4, 1, 19, 2000108), (642, 4, 1, 20, 2000109), (643, 4, 1, 21, 2000111), (644, 4, 1, 22, 2000112), (645, 4, 1, 23, 2000113), (646, 4, 1, 24, 2000114), (647, 4, 1, 25, 2000115), (648, 4, 1, 26, 2000116), (649, 4, 1, 27, 2000117), (650, 4, 1, 28, 2000118), (651, 4, 1, 29, 2000119), (652, 3, 1, 0, 2000090), (653, 3, 1, 1, 2000089), (654, 3, 1, 2, 2000130), (655, 3, 1, 3, 2000131), (656, 3, 1, 4, 2000132), (657, 3, 1, 5, 2000129), (658, 3, 1, 6, 2000061), (659, 3, 1, 7, 2000062), (701, 1, 2, 0, 2000002), (710, 2, 1, 0, 2000083), (711, 2, 1, 1, 2000084), (712, 2, 1, 2, 2000061), (713, 2, 1, 3, 2000062), (714, 2, 1, 4, 2000000), (715, 2, 1, 5, 2000001), (716, 2, 1, 6, 2000085), (717, 2, 1, 7, 2000086), (718, 2, 1, 8, 2000087), (719, 2, 1, 9, 2000088), (720, 2, 1, 10, 2000063), (721, 2, 1, 11, 2000064), (722, 2, 1, 12, 2000065), (723, 2, 1, 13, 2000066), (724, 2, 1, 14, 2000067), (725, 2, 1, 15, 2000068), (726, 2, 1, 16, 2000069), (727, 2, 1, 17, 2000070), (728, 2, 1, 18, 2000071), (729, 2, 1, 19, 2000072), (730, 2, 1, 20, 2000073), (731, 2, 1, 21, 2000074), (732, 2, 1, 22, 2000075), (733, 2, 1, 23, 2000076), (734, 2, 1, 24, 2000077), (735, 2, 1, 25, 2000078), (736, 2, 1, 26, 2000079), (737, 2, 1, 27, 2000080), (738, 2, 1, 28, 2000081), (739, 2, 1, 29, 2000082), (740, 2, 1, 30, 2000002), (741, 2, 1, 31, 2000093), (742, 2, 1, 32, 2000091), (743, 2, 1, 33, 2000092), (744, 2, 1, 34, 2000094), (748, 1, 3, 0, 2000003), (749, 1, 3, 1, 2000129), (750, 1, 4, 0, 2000002), (751, 1, 4, 1, 2000003), (752, 1, 4, 2, 2000000), (753, 1, 4, 3, 2000001), (754, 1, 4, 4, 2000122), (755, 1, 4, 5, 2000003), (756, 1, 4, 6, 2000129); -- Dumping structure for table aaemu_game.ics_shop_items DROP TABLE IF EXISTS `ics_shop_items`; CREATE TABLE IF NOT EXISTS `ics_shop_items` ( `shop_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'SKU item id', `display_item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Item who''s icon to use for displaying in the shop, leave 0 for first item in the group', `name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT 'Can be used to override the name in the shop', `limited_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Enables limited stock mode if non-zero, Account(1), Chracter(2)', `limited_stock_max` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Number of items left in stock for this SKU if limited stock is enabled', `level_min` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Minimum level to buy the item (does not show on UI)', `level_max` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Maximum level to buy the item (does not show on UI)', `buy_restrict_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Buy restriction rule, none (0), level (1) or quest(2)', `buy_restrict_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Level or QuestId for restrict rule', `is_sale` tinyint(3) unsigned NOT NULL DEFAULT '0', `is_hidden` tinyint(3) unsigned NOT NULL DEFAULT '0', `sale_start` datetime DEFAULT NULL COMMENT 'Limited sale start time', `sale_end` datetime DEFAULT NULL COMMENT 'Limited sale end time', `shop_buttons` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'All (0), NoCart (1), NoGift (2), OnlyBuy (3)', `remaining` int(11) NOT NULL DEFAULT '-1' COMMENT 'Number of items remaining, only for tab 1-1 (limited)', PRIMARY KEY (`shop_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2000167 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Possible Item listings that are for sale'; -- Dumping data for table aaemu_game.ics_shop_items: ~165 rows (approximately) REPLACE INTO `ics_shop_items` (`shop_id`, `display_item_id`, `name`, `limited_type`, `limited_stock_max`, `level_min`, `level_max`, `buy_restrict_type`, `buy_restrict_id`, `is_sale`, `is_hidden`, `sale_start`, `sale_end`, `shop_buttons`, `remaining`) VALUES (2000000, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000001, 0, NULL, 0, 100, 0, 0, 1, 10, 0, 0, NULL, NULL, 0, -1), (2000002, 0, '', 0, 14, 0, 0, 1, 15, 0, 0, NULL, NULL, 0, -1), (2000003, 0, 'P2W 10g (sell to vendor)', 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 2, -1), (2000004, 0, '', 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000005, 0, '', 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000006, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000007, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000008, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000009, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000010, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000011, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000012, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000013, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000014, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000015, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000016, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000017, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000018, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000019, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000020, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000021, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000022, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000023, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000024, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000025, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000026, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000027, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000028, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000029, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000030, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000031, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000032, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000033, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000034, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000035, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000036, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000037, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000038, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000039, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000040, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000041, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000042, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000043, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000045, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000046, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000047, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000048, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000049, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000050, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000051, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000052, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000053, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000054, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000055, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000056, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000058, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000059, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000060, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000061, 30812, '', 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000062, 30813, '', 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000063, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000064, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000065, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000066, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000067, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000068, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000069, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000070, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000071, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000072, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000073, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000074, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000075, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000076, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000077, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000078, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000079, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000080, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000081, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000082, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000083, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000084, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000085, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000086, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000087, 0, '', 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 3, -1), (2000088, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000089, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000090, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000091, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000092, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000093, 0, 'Fresh Start Bundle', 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 3, -1), (2000094, 0, '', 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 3, -1), (2000095, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000096, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000097, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000098, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000099, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000100, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000101, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000102, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000103, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000104, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000105, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000106, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000107, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000108, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000109, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000110, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000111, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000112, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000113, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000114, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000115, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000116, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000117, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000118, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000119, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000120, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000121, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000122, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000123, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000124, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000125, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000126, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000127, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000128, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000129, 0, '', 0, 100, 0, 0, 1, 10, 0, 0, NULL, NULL, 3, -1), (2000130, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000131, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000132, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000133, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000134, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000135, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000136, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000137, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000138, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000139, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000140, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000141, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000142, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000143, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000144, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000145, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000146, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000147, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000148, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000149, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000150, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000151, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000152, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000153, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000154, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000155, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000156, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000157, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000158, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000159, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000160, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000161, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000162, 0, '', 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 2, -1), (2000163, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000164, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000165, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1), (2000166, 0, NULL, 0, 100, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, -1); -- Dumping structure for table aaemu_game.ics_skus DROP TABLE IF EXISTS `ics_skus`; CREATE TABLE IF NOT EXISTS `ics_skus` ( `sku` int(10) unsigned NOT NULL AUTO_INCREMENT, `shop_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Reference to the shop item', `position` int(10) NOT NULL DEFAULT '0' COMMENT 'Used for display order inside the item details', `item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Item that is for sale', `item_count` int(10) unsigned NOT NULL DEFAULT '1' COMMENT 'Number of items for this detail', `select_type` tinyint(3) unsigned NOT NULL DEFAULT '0', `is_default` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Is this the default selection?', `event_type` tinyint(3) unsigned NOT NULL DEFAULT '0', `event_end_date` datetime DEFAULT NULL, `currency` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Credits(0), AAPoints(1), Loyalty(2), Coins(3)', `price` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Price of the item', `discount_price` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Discounted price (this is used if set)', `bonus_item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Bonus item included for this purchase', `bonus_item_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Amount of bonus items included', PRIMARY KEY (`sku`) ) ENGINE=InnoDB AUTO_INCREMENT=1000189 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Has the actual sales items for the details'; -- Dumping data for table aaemu_game.ics_skus: ~187 rows (approximately) REPLACE INTO `ics_skus` (`sku`, `shop_id`, `position`, `item_id`, `item_count`, `select_type`, `is_default`, `event_type`, `event_end_date`, `currency`, `price`, `discount_price`, `bonus_item_id`, `bonus_item_count`) VALUES (1000000, 2000000, 0, 31145, 1, 1, 1, 0, NULL, 0, 1000, 0, 0, 0), (1000001, 2000000, 1, 31145, 3, 1, 0, 0, NULL, 0, 3000, 2750, 0, 0), (1000002, 2000000, 2, 31145, 5, 1, 0, 0, '0001-01-01 00:00:00', 0, 5000, 4000, 0, 0), (1000003, 2000001, 0, 11123, 1, 0, 1, 0, NULL, 0, 200, 0, 0, 0), (1000004, 2000001, 1, 11123, 5, 0, 0, 0, NULL, 0, 1000, 900, 0, 0), (1000005, 2000001, 2, 11123, 10, 0, 0, 0, NULL, 0, 2000, 1750, 0, 0), (1000006, 2000001, 3, 11123, 25, 0, 0, 0, NULL, 0, 5000, 4000, 0, 0), (1000007, 2000002, 0, 8000025, 1, 0, 0, 2, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000008, 2000002, 0, 8000025, 3, 0, 0, 0, '0001-01-01 00:00:00', 0, 6000, 5500, 0, 0), (1000009, 2000002, 0, 8000025, 7, 0, 0, 2, '0001-01-01 00:00:00', 0, 14000, 10000, 0, 0), (1000010, 2000003, 0, 500, 100000, 0, 0, 4, '0001-01-01 00:00:00', 0, 1000, 0, 0, 0), (1000011, 2000000, 3, 31145, 10, 1, 0, 0, '0001-01-01 00:00:00', 0, 10000, 7000, 0, 0), (1000012, 2000004, 0, 26683, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000013, 2000005, 0, 26684, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000014, 2000006, 0, 26685, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000015, 2000007, 0, 26871, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000016, 2000008, 0, 27475, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000017, 2000009, 0, 27563, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000018, 2000010, 0, 27700, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000019, 2000011, 0, 28000, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000020, 2000012, 0, 28347, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000021, 2000013, 0, 29876, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000022, 2000014, 0, 28963, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000023, 2000015, 0, 28964, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000024, 2000016, 0, 28965, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000025, 2000017, 0, 29021, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000026, 2000018, 0, 29022, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000027, 2000019, 0, 29023, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000028, 2000020, 0, 29034, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000029, 2000021, 0, 29035, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000030, 2000022, 0, 29181, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000031, 2000023, 0, 29182, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000032, 2000024, 0, 29184, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 750, 0, 0, 0), (1000033, 2000025, 0, 29185, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 750, 0, 0, 0), (1000034, 2000026, 0, 29200, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000035, 2000027, 0, 29877, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000036, 2000028, 0, 29878, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000037, 2000029, 0, 29844, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000038, 2000030, 0, 29845, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000039, 2000031, 0, 29846, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000040, 2000032, 0, 29847, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000041, 2000033, 0, 29907, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000042, 2000034, 0, 29908, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000043, 2000035, 0, 30210, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000044, 2000036, 0, 30211, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000045, 2000037, 0, 30212, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000046, 2000038, 0, 30545, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2500, 0, 0, 0), (1000047, 2000039, 0, 30729, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000048, 2000040, 0, 30730, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000049, 2000041, 0, 30731, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000050, 2000042, 0, 30732, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000051, 2000043, 0, 31585, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000053, 2000045, 0, 31888, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2500, 0, 0, 0), (1000054, 2000046, 0, 31889, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2500, 0, 0, 0), (1000055, 2000047, 0, 33162, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 3000, 0, 0, 0), (1000056, 2000048, 0, 33163, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 3000, 0, 0, 0), (1000057, 2000049, 0, 33164, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 3000, 0, 0, 0), (1000058, 2000050, 0, 33239, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000059, 2000051, 0, 33387, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000060, 2000052, 0, 33388, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000061, 2000053, 0, 34091, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000062, 2000054, 0, 34276, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2500, 0, 0, 0), (1000063, 2000055, 0, 34277, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2500, 0, 0, 0), (1000064, 2000056, 0, 34291, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000066, 2000058, 0, 34308, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000067, 2000059, 0, 34800, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000068, 2000060, 0, 29880, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 100, 0, 0, 0), (1000069, 2000060, 0, 29880, 3, 0, 0, 0, '0001-01-01 00:00:00', 0, 300, 275, 0, 0), (1000070, 2000060, 0, 29880, 5, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 450, 0, 0), (1000071, 2000060, 0, 29880, 10, 0, 0, 0, '0001-01-01 00:00:00', 0, 1000, 800, 0, 0), (1000072, 2000061, 0, 34823, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 750, 0, 0, 0), (1000073, 2000062, 0, 34824, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000074, 2000063, 0, 34031, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000075, 2000064, 0, 34032, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000076, 2000065, 0, 34033, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000077, 2000066, 0, 34034, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000078, 2000067, 0, 34035, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000079, 2000068, 0, 34036, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000080, 2000069, 0, 34037, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000081, 2000070, 0, 34038, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000082, 2000071, 0, 34039, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000083, 2000072, 0, 34040, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000084, 2000073, 0, 34041, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000085, 2000074, 0, 34042, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000086, 2000075, 0, 34043, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000087, 2000076, 0, 34044, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000088, 2000077, 0, 34045, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000089, 2000078, 0, 34046, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000090, 2000079, 0, 34047, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000091, 2000080, 0, 34048, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000092, 2000081, 0, 34152, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 250, 0, 0, 0), (1000093, 2000082, 0, 34355, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 250, 0, 0, 0), (1000094, 2000083, 0, 8000018, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 100, 0, 0, 0), (1000095, 2000084, 0, 28359, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 50, 0, 0, 0), (1000096, 2000085, 0, 33965, 1, 3, 0, 0, '0001-01-01 00:00:00', 0, 50, 0, 0, 0), (1000097, 2000085, 0, 34024, 1, 3, 0, 0, '0001-01-01 00:00:00', 0, 100, 0, 0, 0), (1000098, 2000085, 0, 34026, 1, 3, 0, 0, '0001-01-01 00:00:00', 0, 200, 0, 0, 0), (1000099, 2000086, 0, 18456, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 100, 0, 0, 0), (1000100, 2000087, 0, 34018, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000101, 2000088, 0, 32568, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 350, 0, 0, 0), (1000102, 2000089, 0, 29767, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 1000, 0, 0, 0), (1000103, 2000090, 0, 28449, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 1000, 0, 0, 0), (1000104, 2000091, 0, 30810, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000105, 2000092, 0, 30811, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 750, 0, 0, 0), (1000106, 2000093, 0, 30811, 1, 0, 0, 3, '0001-01-01 00:00:00', 0, 2000, 0, 30810, 1), (1000107, 2000094, 0, 8000002, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 5000, 0, 0, 0), (1000108, 2000095, 0, 27438, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000109, 2000096, 0, 27439, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000110, 2000097, 0, 27440, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000111, 2000098, 0, 27441, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000112, 2000099, 0, 27442, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 650, 0, 0, 0), (1000113, 2000100, 0, 27443, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000114, 2000101, 0, 27444, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000115, 2000102, 0, 27445, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000116, 2000103, 0, 27446, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000117, 2000104, 0, 27447, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000118, 2000105, 0, 27448, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000119, 2000106, 0, 27449, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000120, 2000107, 0, 27450, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000121, 2000108, 0, 27451, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000122, 2000109, 0, 27452, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 650, 0, 0, 0), (1000123, 2000110, 0, 27453, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 650, 0, 0, 0), (1000124, 2000111, 0, 27454, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 650, 0, 0, 0), (1000125, 2000112, 0, 27455, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 650, 0, 0, 0), (1000126, 2000113, 0, 27456, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 650, 0, 0, 0), (1000127, 2000114, 0, 28344, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000128, 2000114, 0, 28344, 3, 0, 0, 0, '0001-01-01 00:00:00', 0, 1500, 1000, 0, 0), (1000129, 2000115, 0, 28561, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 650, 0, 0, 0), (1000130, 2000116, 0, 28562, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 650, 0, 0, 0), (1000131, 2000117, 0, 28563, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 650, 0, 0, 0), (1000132, 2000118, 0, 28564, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 650, 0, 0, 0), (1000133, 2000119, 0, 33794, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 250, 0, 0, 0), (1000134, 2000120, 0, 19090, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 250, 0, 0, 0), (1000135, 2000121, 0, 29235, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000136, 2000122, 0, 8000055, 1, 0, 0, 1, '0001-01-01 00:00:00', 0, 1500, 0, 0, 0), (1000137, 2000123, 0, 31892, 10, 0, 1, 0, '0001-01-01 00:00:00', 0, 1000, 0, 0, 0), (1000138, 2000123, 0, 31892, 25, 0, 0, 0, '0001-01-01 00:00:00', 0, 2500, 2000, 0, 0), (1000139, 2000123, 0, 31892, 50, 0, 0, 0, '0001-01-01 00:00:00', 0, 5000, 3500, 0, 0), (1000140, 2000124, 0, 34765, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000141, 2000124, 0, 34765, 3, 0, 1, 0, '0001-01-01 00:00:00', 0, 1500, 1200, 0, 0), (1000142, 2000125, 0, 28085, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000143, 2000125, 0, 28085, 5, 0, 0, 0, '0001-01-01 00:00:00', 0, 2500, 2000, 0, 0), (1000144, 2000125, 0, 28085, 10, 0, 0, 0, '0001-01-01 00:00:00', 0, 5000, 3500, 0, 0), (1000145, 2000126, 0, 30013, 1, 0, 0, 0, '0001-01-01 00:00:00', 2, 150, 0, 0, 0), (1000146, 2000127, 0, 30014, 1, 0, 0, 0, '0001-01-01 00:00:00', 2, 150, 0, 0, 0), (1000147, 2000128, 0, 30015, 1, 0, 0, 0, '0001-01-01 00:00:00', 2, 150, 0, 0, 0), (1000148, 2000129, 0, 27160, 1, 0, 0, 4, '0001-01-01 00:00:00', 0, 500, 0, 0, 0), (1000149, 2000130, 0, 29488, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000150, 2000131, 0, 29491, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000151, 2000132, 0, 29494, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 2000, 0, 0, 0), (1000152, 2000133, 0, 11127, 1, 0, 1, 0, '0001-01-01 00:00:00', 0, 300, 0, 0, 0), (1000153, 2000133, 0, 11127, 3, 0, 0, 0, '0001-01-01 00:00:00', 0, 900, 800, 0, 0), (1000154, 2000133, 0, 11127, 5, 0, 0, 0, '0001-01-01 00:00:00', 0, 1500, 1300, 0, 0), (1000155, 2000134, 0, 23705, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 100, 0, 0, 0), (1000156, 2000135, 0, 8000035, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 150, 0, 0, 0), (1000157, 2000136, 0, 3363, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 150, 0, 0, 0), (1000158, 2000137, 0, 3364, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 150, 0, 0, 0), (1000159, 2000138, 0, 3365, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 150, 0, 0, 0), (1000160, 2000139, 0, 3366, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 150, 0, 0, 0), (1000161, 2000140, 0, 3367, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 150, 0, 0, 0), (1000162, 2000141, 0, 3369, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 150, 0, 0, 0), (1000163, 2000142, 0, 3370, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 150, 0, 0, 0), (1000164, 2000143, 0, 3371, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 150, 0, 0, 0), (1000165, 2000144, 0, 3372, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 150, 0, 0, 0), (1000166, 2000145, 0, 3373, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 150, 0, 0, 0), (1000167, 2000146, 0, 8000032, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 200, 0, 0, 0), (1000168, 2000147, 0, 8000033, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 200, 0, 0, 0), (1000169, 2000148, 0, 8000034, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 200, 0, 0, 0), (1000170, 2000149, 0, 8000036, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 200, 0, 0, 0), (1000171, 2000150, 0, 8000037, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 200, 0, 0, 0), (1000172, 2000151, 0, 8000038, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 200, 0, 0, 0), (1000173, 2000152, 0, 8000039, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 200, 0, 0, 0), (1000174, 2000153, 0, 27969, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 450, 0, 0, 0), (1000175, 2000154, 0, 28393, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 450, 0, 0, 0), (1000176, 2000155, 0, 27705, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 250, 0, 0, 0), (1000177, 2000156, 0, 27708, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 250, 0, 0, 0), (1000178, 2000157, 0, 27968, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 250, 0, 0, 0), (1000179, 2000158, 0, 25246, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 350, 0, 0, 0), (1000180, 2000159, 0, 25248, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 350, 0, 0, 0), (1000181, 2000160, 0, 24469, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 250, 0, 0, 0), (1000182, 2000161, 0, 25247, 1, 0, 0, 0, '0001-01-01 00:00:00', 0, 250, 0, 0, 0), (1000183, 2000162, 0, 31145, 1, 1, 0, 0, '0001-01-01 00:00:00', 2, 25, 0, 0, 0), (1000184, 2000163, 0, 31892, 25, 0, 0, 0, '0001-01-01 00:00:00', 2, 15, 0, 0, 0), (1000185, 2000164, 0, 28300, 1, 0, 0, 0, '0001-01-01 00:00:00', 2, 100, 0, 0, 0), (1000186, 2000165, 0, 28308, 1, 0, 0, 0, '0001-01-01 00:00:00', 2, 60, 0, 0, 0), (1000187, 2000166, 0, 29040, 1, 0, 1, 0, '0001-01-01 00:00:00', 2, 15, 0, 0, 0), (1000188, 2000166, 0, 29040, 5, 0, 0, 0, '0001-01-01 00:00:00', 2, 75, 65, 0, 0); /*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;