· 8 years ago · May 31, 2018, 04:44 PM
1-- --------------------------------------------------------
2-- Host: 158.69.202.49
3-- Server version: 10.0.29-MariaDB-0ubuntu0.16.04.1 - Ubuntu 16.04
4-- Server OS: debian-linux-gnu
5-- HeidiSQL Version: 9.4.0.5173
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Dumping structure for table monolith_development.market_orders
15CREATE TABLE IF NOT EXISTS `market_orders` (
16 `id` int(11) NOT NULL AUTO_INCREMENT,
17 `itemId` text NOT NULL,
18 `steamId` text NOT NULL,
19 `price` int(11) NOT NULL,
20 `quantity` int(11) NOT NULL,
21 `quantity_remaining` int(11) NOT NULL,
22 `quantity_unclaimed` int(11) NOT NULL,
23 `balance` int(11) NOT NULL,
24 `order_type` text NOT NULL,
25 `order_status` text NOT NULL,
26 `created_at` bigint(20) NOT NULL DEFAULT '1496081142',
27 PRIMARY KEY (`id`)
28) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8mb4;
29
30-- Dumping data for table monolith_development.market_orders: ~157 rows (approximately)
31/*!40000 ALTER TABLE `market_orders` DISABLE KEYS */;
32INSERT INTO `market_orders` (`id`, `itemId`, `steamId`, `price`, `quantity`, `quantity_remaining`, `quantity_unclaimed`, `balance`, `order_type`, `order_status`, `created_at`) VALUES
33 (1, 'mat_metal', '12345', 55, 6, 0, 6, 90, 'BUY', 'COMPLETE', 1496081143),
34 (3, 'mat_metal', '12345', 35, 4, 0, 0, 140, 'SELL', 'COMPLETE', 1496081743),
35 (4, 'mat_metal', '12345', 56, 4, 0, 0, 224, 'SELL', 'COMPLETE', 1496081863),
36 (5, 'mat_metal', '12345', 50, 4, 0, 0, 200, 'SELL', 'COMPLETE', 1496081902),
37 (6, 'mat_metal', '12345', 100, 4, 0, 4, 176, 'BUY', 'COMPLETE', 1496082000),
38 (7, 'mat_gold', '12345', 220, 50, 9, 0, 0, 'BUY', 'PENDING', 1496086741),
39 (8, 'mat_gold', '12345', 200, 10, 0, 0, 2000, 'SELL', 'COMPLETE', 1496086761),
40 (9, 'mat_gold', '12345', 200, 10, 0, 0, 2000, 'SELL', 'COMPLETE', 1496684026),
41 (10, 'mat_gold', '12345', 200, 10, 0, 0, 0, 'SELL', 'COMPLETE', 1496684417),
42 (11, 'mat_metal', '12345', 200, 10, 4, 0, 0, 'SELL', 'PENDING', 1496691613),
43 (16, 'mat_metal', '76561198041348844', 240, 6, 0, 0, 0, 'BUY', 'COMPLETE', 1496693897),
44 (17, 'food_bottle', '76561197973858781', 123, 1, 0, 0, 0, 'SELL', 'COMPLETE', 1496778662),
45 (18, 'food_bottle', '76561197973858781', 123, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496780286),
46 (19, 'attachment_aimpoint', '76561197973858781', 5000, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496783385),
47 (20, 'ent_lsd_paper', '76561197973858781', 30, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496783583),
48 (21, 'weapon_cw_ak74', '76561197973858781', 25000, 4, 4, 0, 0, 'BUY', 'CANCELLED', 1496784028),
49 (22, 'weapon_cw_l85a2', '76561197973858781', 17864, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496789226),
50 (23, 'food_bottle', '76561197973858781', 10, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496789333),
51 (24, 'weapon_cw_ak74', '76561197973858781', 25000, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496789526),
52 (25, 'weapon_cw_ak74', '76561197973858781', 25000, 1, 0, 0, 0, 'SELL', 'COMPLETE', 1496789534),
53 (26, 'weapon_cw_mac11', '76561197973858781', 2000000, 1, 0, 0, 0, 'SELL', 'COMPLETE', 1496789607),
54 (27, 'weapon_cw_mac11', '76561197973858781', 25000, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496789623),
55 (28, 'weapon_cw_mac11', '76561197973858781', 2000000, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496789654),
56 (29, 'weapon_cw_mac11', '76561197973858781', 593683, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496789721),
57 (30, 'weapon_cw_mac11', '76561197973858781', 593683, 1, 0, 0, 0, 'SELL', 'COMPLETE', 1496789758),
58 (31, 'weapon_cw_mac11', '76561197973858781', 25000, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496790004),
59 (32, 'weapon_9x19mm', '76561197973858781', 2000, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496790013),
60 (33, 'weapon_cw_l115', '76561197973858781', 250000, 1, 0, 0, 0, 'SELL', 'COMPLETE', 1496790270),
61 (34, 'weapon_cw_l115', '76561197973858781', 250000, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496790278),
62 (35, 'ammo_cw_rifle', '76561197973858781', 870, 4, 1, 0, 0, 'SELL', 'CANCELLED', 1496790305),
63 (36, 'ammo_rifle', '76561197973858781', 870, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496790311),
64 (37, 'ammo_cw_rifle', '76561197973858781', 870, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496790320),
65 (38, 'ammo_cw_rifle', '76561197973858781', 870, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496790508),
66 (39, 'ammo_cw_rifle', '76561197973858781', 870, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496790835),
67 (40, 'weapon_cw_mp5', '76561197973858781', 25000, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496792339),
68 (41, 'weapon_cw_mp5', '76561197973858781', 25000, 1, 0, 0, 0, 'SELL', 'COMPLETE', 1496792344),
69 (42, 'weapon_cw_mp5', '76561197973858781', 25000, 1, 0, 0, 0, 'SELL', 'COMPLETE', 1496792804),
70 (43, 'weapon_cw_mp5', '76561197973858781', 25000, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496792834),
71 (44, 'weapon_cw_ak74', '76561197973858781', 25000, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496794111),
72 (45, 'weapon_cw_mp5', '76561197973858781', 25000, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496795390),
73 (46, 'food_chicken', '76561197973858781', 45, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496797124),
74 (47, 'furniture_breendesk', '76561197973858781', 5000, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496797811),
75 (48, 'furniture_table9', '76561197973858781', 14272, 10, 10, 0, 0, 'BUY', 'CANCELLED', 1496798306),
76 (49, 'food_raw_apple', '76561197973858781', 325, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496798981),
77 (50, 'ammo_cw_rifle', '76561197973858781', 870, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496798992),
78 (51, 'ammo_cw_rifle', '76561197973858781', 870, 10, 8, 0, 0, 'BUY', 'CANCELLED', 1496799013),
79 (52, 'ammo_cw_rifle', '76561197973858781', 870, 2, 0, 0, 0, 'SELL', 'COMPLETE', 1496799020),
80 (53, 'ammo_cw_rifle', '76561197973858781', 870, 2, 1, 0, 0, 'SELL', 'CANCELLED', 1496799341),
81 (54, 'ammo_cw_rifle', '76561197973858781', 870, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496799347),
82 (55, 'ammo_cw_rifle', '76561197973858781', 870, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496799768),
83 (56, 'ammo_cw_rifle', '76561197973858781', 870, 2, 1, 0, 0, 'SELL', 'CANCELLED', 1496799813),
84 (57, 'ammo_cw_rifle', '76561197973858781', 870, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496799825),
85 (58, 'weapon_cw_m14', '76561197973858781', 25000, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496799913),
86 (59, 'weapon_cw_m14', '76561197973858781', 24999, 1, 0, 0, 0, 'SELL', 'COMPLETE', 1496799920),
87 (60, 'attachment_acog', '76561197973858781', 1, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496800893),
88 (61, 'weapon_cw_p99', '76561197973858781', 1000, 1, 0, 0, 0, 'SELL', 'COMPLETE', 1496802947),
89 (62, 'weapon_cw_p99', '76561197999982690', 1000, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496803116),
90 (63, 'ent_weedseed_1', '76561197973858781', 25, 4, 4, 0, 0, 'SELL', 'CANCELLED', 1496803256),
91 (64, 'ent_weedseed_1', '76561197973858781', 25, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496803264),
92 (65, 'ent_weedseed_1', '76561197973858781', 25, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496803264),
93 (66, 'ent_weedseed_1', '76561197973858781', 25, 4, 4, 0, 0, 'SELL', 'CANCELLED', 1496803272),
94 (67, 'weapon_cw_ak74', '76561197973858781', 25000, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496803419),
95 (68, 'drug_anti_drug', '76561197999982690', 1340, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496815334),
96 (69, 'weapon_cw_fiveseven', '76561197973858781', 5000, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496836310),
97 (70, 'weapon_fiveseven', '76561197973858781', 11690, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496836342),
98 (71, 'weapon_fiveseven', '76561197973858781', 5000, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496836368),
99 (72, 'weapon_cw_fiveseven', '76561197973858781', 5000, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496836377),
100 (73, 'weapon_cw_fiveseven', '76561197973858781', 5000, 1, 0, 0, 0, 'SELL', 'COMPLETE', 1496836418),
101 (74, 'weapon_cw_fiveseven', '76561197973858781', 5000, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496836423),
102 (75, 'attachment_acog', '76561197973858781', 5000, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496836452),
103 (76, 'ent_lsd_paper', '76561197973858781', 30, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496836692),
104 (77, 'ammo_cw_rifle', '76561197973858781', 870, 2, 2, 0, 0, 'SELL', 'CANCELLED', 1496836786),
105 (78, 'weapon_cw_makarov', '76561197973858781', 5000, 1, 0, 0, 0, 'SELL', 'COMPLETE', 1496842779),
106 (79, 'weapon_cw_makarov', '76561198058718007', 5000, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496842795),
107 (80, 'attachment_rpkmag', '76561198058718007', 2500, 2, 2, 0, 0, 'BUY', 'PENDING', 1496842884),
108 (81, 'drug_weed_bag', '76561198058718007', 100, 5, 0, 0, 0, 'BUY', 'COMPLETE', 1496842942),
109 (82, 'ent_weedseed_1', '76561197973858781', 100, 2, 2, 0, 0, 'SELL', 'CANCELLED', 1496842960),
110 (83, 'ent_weedseed_1', '76561197973858781', 50, 2, 2, 0, 0, 'SELL', 'CANCELLED', 1496842984),
111 (84, 'drug_weed_bag', '76561197973858781', 100, 50, 0, 0, 0, 'SELL', 'COMPLETE', 1496843025),
112 (85, 'drug_weed_bag', '76561198005515404', 197, 15, 15, 0, 0, 'SELL', 'PENDING', 1496851494),
113 (86, 'food_bottle', '76561198055526536', 46, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496857094),
114 (87, 'mat_stone', '76561197999982690', 23, 42, 42, 0, 0, 'SELL', 'CANCELLED', 1496868310),
115 (88, 'attachment_acog', '76561198012467855', 5000, 1, 1, 0, 0, 'BUY', 'PENDING', 1496876464),
116 (89, 'mat_copper', '76561198133001780', 50, 2, 0, 0, 100, 'SELL', 'COMPLETE', 1496876634),
117 (90, 'food_watermelon', '76561198133001780', 120, 1, 1, 0, 0, 'SELL', 'PENDING', 1496876647),
118 (91, 'mat_wood', '76561198133001780', 90, 13, 11, 0, 180, 'SELL', 'PENDING', 1496876747),
119 (92, 'ent_woodworkingtbl', '76561198133001780', 2790, 1, 1, 0, 0, 'SELL', 'PENDING', 1496876836),
120 (93, 'mat_stone', '76561198062150766', 10, 81, 79, 0, 20, 'SELL', 'PENDING', 1496885774),
121 (94, 'drug_weed_bag', '76561198300419257', 100, 20, 20, 0, 0, 'BUY', 'CANCELLED', 1496922601),
122 (95, 'drug_weed_bag', '76561198300419257', 100, 20, 20, 0, 0, 'BUY', 'CANCELLED', 1496922602),
123 (96, 'drug_weed_bag', '76561198300419257', 100, 20, 20, 0, 0, 'BUY', 'CANCELLED', 1496922602),
124 (97, 'drug_weed_bag', '76561198300419257', 100, 15, 15, 0, 0, 'BUY', 'CANCELLED', 1496922630),
125 (98, 'weapon_cw_ak74', '76561197973858781', 25000, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496931822),
126 (99, 'attachment_anpeq', '76561197973858781', 5000, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496931840),
127 (100, 'food_mountaindew', '76561198115815665', 33, 30, 20, 0, 0, 'SELL', 'CANCELLED', 1496935750),
128 (101, 'food_mountaindew', '76561197973858781', 23, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496935795),
129 (102, 'food_mountaindew', '76561197973858781', 33, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496935803),
130 (103, 'food_mountaindew', '76561197973858781', 33, 9, 0, 0, 0, 'BUY', 'COMPLETE', 1496935823),
131 (104, 'food_pie', '76561197973858781', 398, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496935873),
132 (105, 'food_pie', '76561197973858781', 398, 6, 5, 0, 0, 'SELL', 'CANCELLED', 1496935886),
133 (106, 'food_pie', '76561198115815665', 351, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496935945),
134 (107, 'food_pie', '76561198115815665', 435, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496935985),
135 (108, 'food_mountaindew', '76561198115815665', 32, 10, 9, 0, 0, 'SELL', 'PENDING', 1496936020),
136 (109, 'food_mountaindew', '76561197973858781', 32, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496936033),
137 (110, 'mat_wood', '76561198062150766', 90, 41, 41, 0, 0, 'SELL', 'PENDING', 1496942995),
138 (111, 'ammo_cw_shotgun', '76561198116108156', 290, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496953356),
139 (112, 'drug_anti_drug', '76561198116108156', 1340, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496953463),
140 (113, 'ent_lsd_paper', '76561197973858781', 30, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496953468),
141 (114, 'drug_anti_drug', '76561197973858781', 1340, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496953480),
142 (115, 'food_bottle', '76561198116012771', 100, 1, 0, 0, 0, 'SELL', 'COMPLETE', 1496953553),
143 (116, 'food_bottle', '76561198116012771', 10, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496953612),
144 (117, 'food_bottle', '76561198116108156', 10, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496953614),
145 (118, 'food_raw_apple', '76561198116108156', 325, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496953654),
146 (119, 'food_bottle', '76561198116108156', 10, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496953712),
147 (120, 'food_bottle', '76561198116108156', 99, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496953792),
148 (121, 'food_bottle', '76561198116108156', 99, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496953804),
149 (122, 'ammo_cw_shotgun', '76561198242630254', 290, 1, 1, 0, 0, 'BUY', 'PENDING', 1496953828),
150 (123, 'ammo_cw_shotgun', '76561198242630254', 290, 1, 1, 0, 0, 'BUY', 'PENDING', 1496953828),
151 (124, 'food_bottle', '76561198116108156', 100, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496953835),
152 (125, 'weapon_cw_ak74', '76561198242630254', 25000, 1, 1, 0, 0, 'BUY', 'PENDING', 1496953842),
153 (126, 'weapon_cw_deagle', '76561198116012771', 5000, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496955638),
154 (127, 'food_bottle', '76561198116012771', 100, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496956153),
155 (128, 'mat_circuit', '76561197999982690', 30, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496961794),
156 (129, 'food_watermelon', '76561198036754873', 150, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496969587),
157 (130, 'food_damsel', '76561198036754873', 12, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496969678),
158 (131, 'food_watermelon', '76561198036754873', 500, 1, 1, 0, 0, 'SELL', 'PENDING', 1496969725),
159 (132, 'ammo_cw_shotgun', '76561198011844757', 290, 1, 1, 0, 0, 'BUY', 'PENDING', 1496969745),
160 (133, 'food_bottle', '76561197999982690', 10, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496971732),
161 (134, 'food_bottle', '76561197999982690', 10, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496971738),
162 (135, 'mat_wood', '76561197999982690', 90, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496971739),
163 (136, 'mat_pine', '76561197999982690', 120, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496971741),
164 (137, 'mat_circuit', '76561197999982690', 30, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496971742),
165 (138, 'misc_flashlight', '76561197999982690', 300, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496971743),
166 (139, 'mat_coal', '76561197999982690', 125, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496971745),
167 (140, 'misc_handheldradio', '76561197999982690', 5000, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496971746),
168 (141, 'weapon_hoe', '76561197999982690', 380, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496971751),
169 (142, 'ent_lsd_paper', '76561197999982690', 30, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496974036),
170 (143, 'food_bottle', '76561197973858781', 25, 10, 10, 0, 0, 'SELL', 'CANCELLED', 1496974093),
171 (144, 'tool_vapevip', '76561197999982690', 7500, 1, 1, 0, 0, 'SELL', 'CANCELLED', 1496974959),
172 (145, 'tool_vape', '76561197973858781', 10000, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496975018),
173 (146, 'tool_vape', '76561197973858781', 4000000, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496975091),
174 (147, 'tool_vape', '76561197973858781', 7500, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496975124),
175 (148, 'food_raw_catfish', '76561197999982690', 70, 1, 0, 0, 0, 'SELL', 'COMPLETE', 1496975199),
176 (149, 'food_raw_catfish', '76561197973858781', 70, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496975230),
177 (150, 'mat_stone', '76561197999982690', 25, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496975617),
178 (151, 'mat_metal', '76561198041348844', 671, 6, 6, 0, 0, 'SELL', 'PENDING', 1496975792),
179 (152, 'food_bacon', '76561198041348844', 50, 2, 2, 0, 0, 'SELL', 'PENDING', 1496975827),
180 (153, 'mat_stone', '76561197973858781', 25, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496975846),
181 (154, 'mat_wood', '76561197973858781', 90, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496975927),
182 (155, 'mat_wood', '76561197973858781', 90, 1, 0, 0, 0, 'BUY', 'COMPLETE', 1496976532),
183 (156, 'drug_lsd', '76561198312183445', 100, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496984953),
184 (157, 'misc_flashlight', '76561198173836415', 300, 1, 1, 0, 0, 'BUY', 'CANCELLED', 1496985030),
185 (158, 'food_bottle', '76561198119657683', 9, 3, 3, 0, 0, 'BUY', 'PENDING', 1496999198),
186 (159, 'food_bottle', '76561197973858781', 9, 5, 5, 0, 0, 'BUY', 'CANCELLED', 1497011721),
187 (160, 'mat_copper', '76561197973858781', 50, 5, 3, 0, 0, 'BUY', 'CANCELLED', 1497012007),
188 (161, 'mat_copper', '76561197973858781', 25, 2, 2, 0, 0, 'SELL', 'CANCELLED', 1497012398),
189 (162, 'food_doritos', '76561198173836415', 88, 2, 2, 0, 0, 'SELL', 'CANCELLED', 1497023892);
190/*!40000 ALTER TABLE `market_orders` ENABLE KEYS */;
191
192-- Dumping structure for table monolith_development.market_transactions
193CREATE TABLE IF NOT EXISTS `market_transactions` (
194 `id` int(11) NOT NULL AUTO_INCREMENT,
195 `buyer_steamId` text NOT NULL,
196 `seller_steamId` text NOT NULL,
197 `buyer_orderId` int(11) NOT NULL,
198 `seller_orderId` int(11) NOT NULL,
199 `itemId` text NOT NULL,
200 `quantity_sold` int(11) NOT NULL,
201 `price_per_item` int(11) NOT NULL,
202 `timestamp` mediumtext,
203 PRIMARY KEY (`id`),
204 KEY `buyer_order` (`buyer_orderId`),
205 KEY `seller_order` (`seller_orderId`),
206 CONSTRAINT `buyer_order` FOREIGN KEY (`buyer_orderId`) REFERENCES `market_orders` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
207 CONSTRAINT `seller_order` FOREIGN KEY (`seller_orderId`) REFERENCES `market_orders` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
208) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
209
210-- Dumping data for table monolith_development.market_transactions: ~1 rows (approximately)
211/*!40000 ALTER TABLE `market_transactions` DISABLE KEYS */;
212INSERT INTO `market_transactions` (`id`, `buyer_steamId`, `seller_steamId`, `buyer_orderId`, `seller_orderId`, `itemId`, `quantity_sold`, `price_per_item`, `timestamp`) VALUES
213/*!40000 ALTER TABLE `market_transactions` ENABLE KEYS */;
214
215-- Dumping structure for table monolith_development.mrp_arrests
216CREATE TABLE IF NOT EXISTS `mrp_arrests` (
217 `id` int(11) NOT NULL AUTO_INCREMENT,
218 `timestamp` int(11) NOT NULL,
219 `steamid` varchar(45) NOT NULL,
220 `name` varchar(45) NOT NULL,
221 `arrester_steamid` varchar(45) NOT NULL,
222 `arrester_name` varchar(45) NOT NULL,
223 `length` smallint(6) NOT NULL,
224 `reason` text NOT NULL,
225 PRIMARY KEY (`id`)
226) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
227
228-- Dumping data for table monolith_development.mrp_arrests: ~10 rows (approximately)
229/*!40000 ALTER TABLE `mrp_arrests` DISABLE KEYS */;
230INSERT INTO `mrp_arrests` (`id`, `timestamp`, `steamid`, `name`, `arrester_steamid`, `arrester_name`, `length`, `reason`) VALUES
231/*!40000 ALTER TABLE `mrp_arrests` ENABLE KEYS */;
232
233-- Dumping structure for table monolith_development.mrp_factions
234CREATE TABLE IF NOT EXISTS `mrp_factions` (
235 `idkey` varchar(64) NOT NULL,
236 `data` varchar(512) NOT NULL,
237 PRIMARY KEY (`idkey`)
238) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
239
240-- Dumping data for table monolith_development.mrp_factions: ~2 rows (approximately)
241/*!40000 ALTER TABLE `mrp_factions` DISABLE KEYS */;
242INSERT INTO `mrp_factions` (`idkey`, `data`) VALUES
243/*!40000 ALTER TABLE `mrp_factions` ENABLE KEYS */;
244
245-- Dumping structure for table monolith_development.mrp_organizations
246CREATE TABLE IF NOT EXISTS `mrp_organizations` (
247 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
248 `name` varchar(60) NOT NULL,
249 `description` varchar(300) NOT NULL DEFAULT '',
250 `color` varchar(45) NOT NULL,
251 `master_id` varchar(45) NOT NULL,
252 `master_rank` varchar(60) NOT NULL DEFAULT '',
253 `points` int(11) NOT NULL DEFAULT '0',
254 PRIMARY KEY (`id`),
255 UNIQUE KEY `id_UNIQUE` (`id`),
256 UNIQUE KEY `name_UNIQUE` (`name`)
257) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8mb4;
258
259-- Dumping data for table monolith_development.mrp_organizations: ~119 rows (approximately)
260/*!40000 ALTER TABLE `mrp_organizations` DISABLE KEYS */;
261INSERT INTO `mrp_organizations` (`id`, `name`, `description`, `color`, `master_id`, `master_rank`, `points`) VALUES
262/*!40000 ALTER TABLE `mrp_organizations` ENABLE KEYS */;
263
264-- Dumping structure for table monolith_development.mrp_organizations_members
265CREATE TABLE IF NOT EXISTS `mrp_organizations_members` (
266 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
267 `organization_id` int(10) unsigned NOT NULL,
268 `steamid` varchar(45) NOT NULL,
269 `role` varchar(10) NOT NULL DEFAULT 'member',
270 `custom_rank` varchar(45) NOT NULL DEFAULT '',
271 PRIMARY KEY (`id`),
272 UNIQUE KEY `id_UNIQUE` (`id`),
273 KEY `orgID_idx` (`organization_id`),
274 CONSTRAINT `orgID` FOREIGN KEY (`organization_id`) REFERENCES `mrp_organizations` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
275) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8mb4;
276
277-- Dumping data for table monolith_development.mrp_organizations_members: ~60 rows (approximately)
278/*!40000 ALTER TABLE `mrp_organizations_members` DISABLE KEYS */;
279INSERT INTO `mrp_organizations_members` (`id`, `organization_id`, `steamid`, `role`, `custom_rank`) VALUES
280/*!40000 ALTER TABLE `mrp_organizations_members` ENABLE KEYS */;
281
282-- Dumping structure for table monolith_development.mrp_pdata
283CREATE TABLE IF NOT EXISTS `mrp_pdata` (
284 `steamid` varchar(45) NOT NULL,
285 `money` int(11) NOT NULL,
286 `name` varchar(64) NOT NULL,
287 `experience` int(11) NOT NULL,
288 `inventory` longtext NOT NULL,
289 `bank` text NOT NULL,
290 `jobxp` longtext NOT NULL,
291 `skillxp` text,
292 `faction` int(11) NOT NULL,
293 `model` varchar(64) NOT NULL,
294 `cloth` text NOT NULL,
295 `cosmetics` text NOT NULL,
296 `cars` longtext NOT NULL,
297 `premium` tinyint(4) DEFAULT '0',
298 `playtime` int(11) DEFAULT '0'
299) ENGINE=InnoDB DEFAULT CHARSET=latin1;
300
301-- Dumping data for table monolith_development.mrp_pdata: ~995 rows (approximately)
302/*!40000 ALTER TABLE `mrp_pdata` DISABLE KEYS */;
303INSERT INTO `mrp_pdata` (`steamid`, `money`, `name`, `experience`, `inventory`, `bank`, `jobxp`, `skillxp`, `faction`, `model`, `cloth`, `cosmetics`, `cars`, `premium`, `playtime`) VALUES
304/*!40000 ALTER TABLE `mrp_pdata` ENABLE KEYS */;
305
306-- Dumping structure for table monolith_development.serverguard_analytics
307CREATE TABLE IF NOT EXISTS `serverguard_analytics` (
308 `id` int(11) NOT NULL AUTO_INCREMENT,
309 `date` varchar(10) NOT NULL,
310 `data` text NOT NULL,
311 PRIMARY KEY (`id`)
312) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4;
313
314-- Dumping data for table monolith_development.serverguard_analytics: ~18 rows (approximately)
315/*!40000 ALTER TABLE `serverguard_analytics` DISABLE KEYS */;
316INSERT INTO `serverguard_analytics` (`id`, `date`, `data`) VALUES
317 (1, '12-3-2017', '[8,["STEAM_0:1:20315119","STEAM_0:1:19210903"]]'),
318 (2, '13-3-2017', '[17,["STEAM_0:1:25789514","STEAM_0:1:49226139","STEAM_0:1:20315119","STEAM_0:0:23322796","STEAM_0:1:32122155","STEAM_0:0:49040104"]]'),
319 (3, '14-3-2017', '[50,["STEAM_0:1:25789514","STEAM_0:1:32122155","STEAM_0:0:49040104","STEAM_0:0:18667447","STEAM_0:1:20315119","STEAM_0:0:23322796","STEAM_0:1:19210903"]]'),
320 (4, '15-3-2017', '[30,["STEAM_0:1:25789514","STEAM_0:0:13347490","STEAM_0:0:33227351","STEAM_0:0:49040104","STEAM_0:0:29876712","STEAM_0:1:20315119","STEAM_0:0:53919241"]]'),
321 (5, '16-3-2017', '[31,["STEAM_0:0:19484174","STEAM_0:0:49040104","STEAM_0:0:33227351","STEAM_0:1:49226139","STEAM_0:0:189757235","STEAM_0:0:29876712","STEAM_0:1:20315119","STEAM_0:0:166150202","STEAM_0:0:134484118","STEAM_0:0:59444492","STEAM_0:1:19210903"]]'),
322 (6, '17-3-2017', '[14,["STEAM_0:0:102283517","STEAM_0:1:25789514","STEAM_0:0:49040104","STEAM_0:0:189757235","STEAM_0:1:20315119","STEAM_0:0:33227351","STEAM_0:0:55095240","STEAM_0:0:59444492"]]'),
323 (7, '18-3-2017', '[12,["STEAM_0:1:32122155","STEAM_0:1:20315119","STEAM_0:0:49040104","STEAM_0:0:18667447","STEAM_0:0:29876712","STEAM_0:0:42337250","STEAM_0:1:37646802"]]'),
324 (8, '19-3-2017', '[32,["STEAM_0:0:49040104","STEAM_0:0:29876712","STEAM_0:0:40541558","STEAM_0:1:29983059","STEAM_0:0:48484493","STEAM_0:1:79642051","STEAM_0:0:83473595","STEAM_0:0:33227351","STEAM_0:0:42337250","STEAM_0:1:37646802"]]'),
325 (9, '20-3-2017', '[13,["STEAM_0:1:25789514","STEAM_0:1:32122155","STEAM_0:0:40541558","STEAM_0:0:49040104","STEAM_0:1:49226139","STEAM_0:0:29876712"]]'),
326 (10, '12-3-2017', '[8,["STEAM_0:1:20315119","STEAM_0:1:19210903"]]'),
327 (11, '13-3-2017', '[17,["STEAM_0:1:25789514","STEAM_0:1:49226139","STEAM_0:1:20315119","STEAM_0:0:23322796","STEAM_0:1:32122155","STEAM_0:0:49040104"]]'),
328 (12, '14-3-2017', '[50,["STEAM_0:1:25789514","STEAM_0:1:32122155","STEAM_0:0:49040104","STEAM_0:0:18667447","STEAM_0:1:20315119","STEAM_0:0:23322796","STEAM_0:1:19210903"]]'),
329 (13, '15-3-2017', '[30,["STEAM_0:1:25789514","STEAM_0:0:13347490","STEAM_0:0:33227351","STEAM_0:0:49040104","STEAM_0:0:29876712","STEAM_0:1:20315119","STEAM_0:0:53919241"]]'),
330 (14, '16-3-2017', '[31,["STEAM_0:0:19484174","STEAM_0:0:49040104","STEAM_0:0:33227351","STEAM_0:1:49226139","STEAM_0:0:189757235","STEAM_0:0:29876712","STEAM_0:1:20315119","STEAM_0:0:166150202","STEAM_0:0:134484118","STEAM_0:0:59444492","STEAM_0:1:19210903"]]'),
331 (15, '17-3-2017', '[14,["STEAM_0:0:102283517","STEAM_0:1:25789514","STEAM_0:0:49040104","STEAM_0:0:189757235","STEAM_0:1:20315119","STEAM_0:0:33227351","STEAM_0:0:55095240","STEAM_0:0:59444492"]]'),
332 (16, '18-3-2017', '[12,["STEAM_0:1:32122155","STEAM_0:1:20315119","STEAM_0:0:49040104","STEAM_0:0:18667447","STEAM_0:0:29876712","STEAM_0:0:42337250","STEAM_0:1:37646802"]]'),
333 (17, '19-3-2017', '[32,["STEAM_0:0:49040104","STEAM_0:0:29876712","STEAM_0:0:40541558","STEAM_0:1:29983059","STEAM_0:0:48484493","STEAM_0:1:79642051","STEAM_0:0:83473595","STEAM_0:0:33227351","STEAM_0:0:42337250","STEAM_0:1:37646802"]]'),
334 (18, '20-3-2017', '[13,["STEAM_0:1:25789514","STEAM_0:1:32122155","STEAM_0:0:40541558","STEAM_0:0:49040104","STEAM_0:1:49226139","STEAM_0:0:29876712"]]');
335/*!40000 ALTER TABLE `serverguard_analytics` ENABLE KEYS */;
336
337-- Dumping structure for table monolith_development.serverguard_bans
338CREATE TABLE IF NOT EXISTS `serverguard_bans` (
339 `id` int(11) NOT NULL AUTO_INCREMENT,
340 `steam_id` varchar(25) NOT NULL,
341 `community_id` text NOT NULL,
342 `player` varchar(255) NOT NULL,
343 `reason` text NOT NULL,
344 `start_time` int(11) NOT NULL,
345 `end_time` int(11) NOT NULL,
346 `admin` varchar(255) NOT NULL,
347 `ip_address` varchar(15) NOT NULL,
348 PRIMARY KEY (`id`)
349) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
350
351-- Dumping data for table monolith_development.serverguard_bans: ~0 rows (approximately)
352/*!40000 ALTER TABLE `serverguard_bans` DISABLE KEYS */;
353/*!40000 ALTER TABLE `serverguard_bans` ENABLE KEYS */;
354
355-- Dumping structure for table monolith_development.serverguard_pms
356CREATE TABLE IF NOT EXISTS `serverguard_pms` (
357 `id` int(11) NOT NULL AUTO_INCREMENT,
358 `sender` varchar(255) NOT NULL,
359 `sender_steamid` varchar(255) NOT NULL,
360 `receiver` varchar(255) NOT NULL,
361 `receiver_steamid` varchar(255) NOT NULL,
362 `message` varchar(255) NOT NULL,
363 PRIMARY KEY (`id`)
364) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
365
366-- Dumping data for table monolith_development.serverguard_pms: ~0 rows (approximately)
367/*!40000 ALTER TABLE `serverguard_pms` DISABLE KEYS */;
368/*!40000 ALTER TABLE `serverguard_pms` ENABLE KEYS */;
369
370-- Dumping structure for table monolith_development.serverguard_ranks
371CREATE TABLE IF NOT EXISTS `serverguard_ranks` (
372 `id` int(11) NOT NULL AUTO_INCREMENT,
373 `unique_id` varchar(255) NOT NULL,
374 `name` varchar(255) NOT NULL,
375 `color` varchar(40) NOT NULL,
376 `immunity` int(11) NOT NULL,
377 `texture` varchar(255) NOT NULL,
378 `data` text,
379 `targetable` int(11) NOT NULL DEFAULT '0',
380 PRIMARY KEY (`id`)
381) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
382
383-- Dumping data for table monolith_development.serverguard_ranks: ~4 rows (approximately)
384/*!40000 ALTER TABLE `serverguard_ranks` DISABLE KEYS */;
385INSERT INTO `serverguard_ranks` (`id`, `unique_id`, `name`, `color`, `immunity`, `texture`, `data`, `targetable`) VALUES
386 (1, 'user', 'Guest', '{"r":100,"b":245,"a":255,"g":150}', 0, 'icon16/user.png', '{"phys_color":{"r":77,"b":255,"a":255,"g":255},"Restrictions":{"Vehicles":2,"Hoverballs":6,"Emitters":3,"Props":128,"Wheels":10,"Sents":4,"Dynamite":3,"Effects":10,"Ragdolls":1,"Lamps":2,"Thrusters":10,"Buttons":6,"Lights":2,"Balloons":4,"Tools":[],"Npcs":1}}', 0),
387 (2, 'founder', 'Founder', '{"r":240,"b":0,"a":255,"g":0}', 99, 'icon16/award_star_gold_1.png', '[]', 99),
388 (3, 'superadmin', 'Super Administrator', '{"r":0,"b":0,"a":255,"g":150}', 25, 'icon16/award_star_silver_1.png', '{"phys_color":{"r":77,"b":255,"a":255,"g":255},"Permissions":{"Sandbox settings":true,"Manage Prop-Protection":true,"Bypass Prop Deletion":true,"Manage Players":true,"Extinguish":true,"Invisible":true,"Slay":true,"Unban":true,"Set Health":true,"Manage Plugins":false,"Respond to Help Requests":true,"Noclip":true,"Set Armor":true,"Manage Advertisements":true,"Freeze":true,"Strip Weapons":true,"Manage MOTD":true,"Freeze Props":true,"Map Restart":true,"Clear Decals":true,"Send":true,"Give Ammo":true,"Manage Prop Blacklist":true,"Ragdoll":true,"Goto":true,"Permaban":true,"Quick Menu":true,"Kick":true,"Bypass Prop Blacklist":true,"Spectate":true,"Screencap":true,"Ignite":true,"Bypass Prop-Protection":true,"Admin":true,"Return":true,"Rcon":false,"Physgun Player":true,"Manage Reports":true,"Server Logs":true,"Set Rank":false,"Edit Ranks":false,"Announce":true,"Slap":true,"Superadmin":true,"Manage Restrictions":false,"God mode":true,"Play Song":true,"Analytics":true,"NPC Target":true,"Give Weapon":true,"Mute":true,"Map":true,"Respawn":true,"Ban":true,"Bring":true},"Restrictions":{"Vehicles":8,"Hoverballs":20,"Emitters":12,"Props":512,"Wheels":50,"Sents":12,"Dynamite":12,"Effects":50,"Ragdolls":6,"Lamps":12,"Thrusters":50,"Buttons":30,"Lights":12,"Balloons":12,"Tools":[],"Npcs":4}}', 25),
389 (4, 'admin', 'Administrator', '{"r":117,"b":211,"a":255,"g":0}', 20, 'icon16/award_star_bronze_1.png', '{"phys_color":{"r":77,"b":255,"a":255,"g":255},"Permissions":{"Sandbox settings":false,"Manage Prop-Protection":false,"Bypass Prop Deletion":true,"Manage Players":true,"Extinguish":true,"Invisible":true,"Slay":true,"Unban":true,"Set Health":true,"Manage Plugins":false,"Respond to Help Requests":true,"Noclip":true,"Set Armor":true,"Strip Weapons":true,"Manage Advertisements":false,"Freeze":true,"Map Restart":true,"Clear Decals":true,"Send":true,"Give Ammo":true,"Manage MOTD":false,"Ragdoll":true,"Goto":true,"Freeze Props":false,"Quick Menu":true,"Kick":true,"Permaban":false,"Spectate":true,"Screencap":false,"Ignite":true,"Bypass Prop-Protection":true,"Superadmin":false,"Return":true,"Rcon":false,"Physgun Player":true,"Manage Reports":true,"Server Logs":true,"Set Rank":false,"Edit Ranks":false,"Announce":true,"Slap":true,"Admin":true,"Manage Restrictions":false,"God mode":true,"Play Song":false,"Analytics":false,"NPC Target":true,"Give Weapon":true,"Mute":true,"Map":true,"Respawn":true,"Ban":true,"Bring":true},"Restrictions":{"Vehicles":4,"Hoverballs":10,"Emitters":6,"Props":256,"Wheels":25,"Sents":8,"Dynamite":6,"Effects":25,"Ragdolls":4,"Lamps":6,"Thrusters":25,"Buttons":15,"Lights":6,"Balloons":6,"Tools":[],"Npcs":2}}', 20);
390/*!40000 ALTER TABLE `serverguard_ranks` ENABLE KEYS */;
391
392-- Dumping structure for table monolith_development.serverguard_reports
393CREATE TABLE IF NOT EXISTS `serverguard_reports` (
394 `id` int(11) NOT NULL AUTO_INCREMENT,
395 `name` varchar(255) NOT NULL,
396 `steamID` varchar(255) NOT NULL DEFAULT 'Unknown',
397 `text` text NOT NULL,
398 `time` int(11) NOT NULL,
399 PRIMARY KEY (`id`)
400) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
401
402-- Dumping data for table monolith_development.serverguard_reports: ~0 rows (approximately)
403/*!40000 ALTER TABLE `serverguard_reports` DISABLE KEYS */;
404/*!40000 ALTER TABLE `serverguard_reports` ENABLE KEYS */;
405
406-- Dumping structure for table monolith_development.serverguard_schema
407CREATE TABLE IF NOT EXISTS `serverguard_schema` (
408 `id` varchar(31) NOT NULL,
409 `version` int(11) NOT NULL DEFAULT '0',
410 PRIMARY KEY (`id`)
411) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
412
413-- Dumping data for table monolith_development.serverguard_schema: ~0 rows (approximately)
414/*!40000 ALTER TABLE `serverguard_schema` DISABLE KEYS */;
415INSERT INTO `serverguard_schema` (`id`, `version`) VALUES
416 ('serverguard_ranks', 1);
417/*!40000 ALTER TABLE `serverguard_schema` ENABLE KEYS */;
418
419-- Dumping structure for table monolith_development.serverguard_users
420CREATE TABLE IF NOT EXISTS `serverguard_users` (
421 `id` int(11) NOT NULL AUTO_INCREMENT,
422 `steam_id` varchar(25) NOT NULL,
423 `rank` varchar(255) NOT NULL DEFAULT '',
424 `name` varchar(255) NOT NULL,
425 `last_played` int(11) NOT NULL,
426 `data` text,
427 PRIMARY KEY (`id`)
428) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4;
429
430-- Dumping data for table monolith_development.serverguard_users: ~26 rows (approximately)
431/*!40000 ALTER TABLE `serverguard_users` DISABLE KEYS */;
432INSERT INTO `serverguard_users` (`id`, `steam_id`, `rank`, `name`, `last_played`, `data`) VALUES
433 (1, 'STEAM_0:0:209753673', 'founder', 'Snake', 1489855875, '~\'groupExpire":b0'),
434 (2, 'STEAMIDHERE', 'superadmin', 'namegoeshere', 1489720292, '~\'groupExpire":b0'),
435 (3, 'STEAMIDHERE', 'admin', 'namegoeshere', 1490042816, '~\'groupExpire":b0'),
436
437/*!40000 ALTER TABLE `serverguard_users` ENABLE KEYS */;
438
439-- Dumping structure for table monolith_development.serverguard_watchlist
440CREATE TABLE IF NOT EXISTS `serverguard_watchlist` (
441 `steam_id` varchar(64) NOT NULL,
442 `note` varchar(255) NOT NULL,
443 PRIMARY KEY (`steam_id`)
444) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
445
446-- Dumping data for table monolith_development.serverguard_watchlist: ~0 rows (approximately)
447/*!40000 ALTER TABLE `serverguard_watchlist` DISABLE KEYS */;
448/*!40000 ALTER TABLE `serverguard_watchlist` ENABLE KEYS */;
449
450/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
451/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
452/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;