· 8 years ago · Jan 21, 2018, 11:00 AM
1CREATE TABLE IF NOT EXISTS `blocks` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `image` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '1',
4 `block_id` varchar(11) COLLATE utf8_bin NOT NULL,
5 `amount` int(11) NOT NULL DEFAULT '0',
6 `price` int(11) NOT NULL DEFAULT '0',
7 `server` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '1',
8 `name` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '1',
9 `sale` tinyint(1) NOT NULL DEFAULT '0',
10 `time_sale` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '0',
11 `buys` int(255) NOT NULL DEFAULT '0',
12 PRIMARY KEY (`id`)
13) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=822 ;
14
15
16
17
18CREATE TABLE IF NOT EXISTS `donate_logs` (
19 `id` int(11) NOT NULL AUTO_INCREMENT,
20 `name` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '1',
21 `money` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '0',
22 `dic` varchar(512) CHARACTER SET utf8 NOT NULL DEFAULT '0',
23 `date` varchar(55) COLLATE utf8_bin NOT NULL DEFAULT '0',
24 `unixtime` int(255) NOT NULL DEFAULT '0',
25 PRIMARY KEY (`id`)
26) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=842 ;
27
28
29
30
31CREATE TABLE IF NOT EXISTS `getitem_s1` (
32 `id` int(11) NOT NULL AUTO_INCREMENT,
33 `type` varchar(255) DEFAULT 'item',
34 `nickname` varchar(255) DEFAULT NULL,
35 `item_id` varchar(255) DEFAULT NULL,
36 `extra` text,
37 `item_amount` int(11) NOT NULL DEFAULT '1',
38 PRIMARY KEY (`id`),
39 KEY `nickname` (`nickname`)
40) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4978 ;
41
42
43CREATE TABLE IF NOT EXISTS `getitem_s1_log` (
44 `id` int(24) NOT NULL AUTO_INCREMENT,
45 `name` varchar(255) DEFAULT NULL,
46 `history` varchar(255) DEFAULT NULL,
47 `time` varchar(255) DEFAULT NULL,
48 PRIMARY KEY (`id`)
49) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2218 ;
50
51
52
53CREATE TABLE IF NOT EXISTS `getitem_s2` (
54 `id` int(11) NOT NULL AUTO_INCREMENT,
55 `type` varchar(255) DEFAULT 'item',
56 `nickname` varchar(255) DEFAULT NULL,
57 `item_id` varchar(255) DEFAULT NULL,
58 `extra` text,
59 `item_amount` int(11) NOT NULL DEFAULT '1',
60 PRIMARY KEY (`id`),
61 KEY `nickname` (`nickname`)
62) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2084 ;
63
64
65
66CREATE TABLE IF NOT EXISTS `getitem_s2_log` (
67 `id` int(24) NOT NULL AUTO_INCREMENT,
68 `name` varchar(255) DEFAULT NULL,
69 `history` varchar(255) DEFAULT NULL,
70 `time` varchar(255) DEFAULT NULL,
71 PRIMARY KEY (`id`)
72) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1259 ;
73
74
75
76CREATE TABLE IF NOT EXISTS `getitem_s3` (
77 `id` int(11) NOT NULL AUTO_INCREMENT,
78 `type` varchar(255) DEFAULT 'item',
79 `nickname` varchar(255) DEFAULT NULL,
80 `item_id` varchar(255) DEFAULT NULL,
81 `extra` text,
82 `item_amount` int(11) NOT NULL DEFAULT '1',
83 PRIMARY KEY (`id`),
84 KEY `nickname` (`nickname`)
85) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1579 ;
86
87
88CREATE TABLE IF NOT EXISTS `getitem_s3_log` (
89 `id` int(24) NOT NULL AUTO_INCREMENT,
90 `name` varchar(255) DEFAULT NULL,
91 `history` varchar(255) DEFAULT NULL,
92 `time` varchar(255) DEFAULT NULL,
93 PRIMARY KEY (`id`)
94) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=859 ;
95
96
97
98CREATE TABLE IF NOT EXISTS `getitem_s4` (
99 `id` int(11) NOT NULL AUTO_INCREMENT,
100 `type` varchar(255) DEFAULT 'item',
101 `nickname` varchar(255) DEFAULT NULL,
102 `item_id` varchar(255) DEFAULT NULL,
103 `extra` text,
104 `item_amount` int(11) NOT NULL DEFAULT '1',
105 PRIMARY KEY (`id`),
106 KEY `nickname` (`nickname`)
107) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1597 ;
108
109
110
111CREATE TABLE IF NOT EXISTS `getitem_s4_log` (
112 `id` int(24) NOT NULL AUTO_INCREMENT,
113 `name` varchar(255) DEFAULT NULL,
114 `history` varchar(255) DEFAULT NULL,
115 `time` varchar(255) DEFAULT NULL,
116 PRIMARY KEY (`id`)
117) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=204 ;
118
119
120
121
122CREATE TABLE IF NOT EXISTS `getitem_s5` (
123 `id` int(11) NOT NULL AUTO_INCREMENT,
124 `type` varchar(255) DEFAULT 'item',
125 `nickname` varchar(255) DEFAULT NULL,
126 `item_id` varchar(255) DEFAULT NULL,
127 `extra` text,
128 `item_amount` int(11) NOT NULL DEFAULT '1',
129 PRIMARY KEY (`id`),
130 KEY `nickname` (`nickname`)
131) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1876 ;
132
133
134
135CREATE TABLE IF NOT EXISTS `getitem_s5_log` (
136 `id` int(24) NOT NULL AUTO_INCREMENT,
137 `name` varchar(255) DEFAULT NULL,
138 `history` varchar(255) DEFAULT NULL,
139 `time` varchar(255) DEFAULT NULL,
140 PRIMARY KEY (`id`)
141) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=446 ;
142
143
144CREATE TABLE IF NOT EXISTS `permissions_entity_s1` (
145 `id` int(11) NOT NULL AUTO_INCREMENT,
146 `name` varchar(50) NOT NULL,
147 `type` tinyint(1) NOT NULL,
148 `prefix` varchar(255) NOT NULL,
149 `suffix` varchar(255) NOT NULL,
150 `default` tinyint(1) NOT NULL DEFAULT '0',
151 PRIMARY KEY (`id`),
152 UNIQUE KEY `name` (`name`),
153 KEY `default` (`default`)
154) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3868 ;
155
156
157CREATE TABLE IF NOT EXISTS `permissions_entity_s2` (
158 `id` int(11) NOT NULL AUTO_INCREMENT,
159 `name` varchar(50) NOT NULL,
160 `type` tinyint(1) NOT NULL,
161 `prefix` varchar(255) NOT NULL,
162 `suffix` varchar(255) NOT NULL,
163 `default` tinyint(1) NOT NULL DEFAULT '0',
164 PRIMARY KEY (`id`),
165 UNIQUE KEY `name` (`name`),
166 KEY `default` (`default`)
167) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3471 ;
168
169
170CREATE TABLE IF NOT EXISTS `permissions_entity_s3` (
171 `id` int(11) NOT NULL AUTO_INCREMENT,
172 `name` varchar(50) NOT NULL,
173 `type` tinyint(1) NOT NULL,
174 `prefix` varchar(255) NOT NULL,
175 `suffix` varchar(255) NOT NULL,
176 `default` tinyint(1) NOT NULL DEFAULT '0',
177 PRIMARY KEY (`id`),
178 UNIQUE KEY `name` (`name`),
179 KEY `default` (`default`)
180) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2984 ;
181
182
183
184CREATE TABLE IF NOT EXISTS `permissions_entity_s4` (
185 `id` int(11) NOT NULL AUTO_INCREMENT,
186 `name` varchar(50) NOT NULL,
187 `type` tinyint(1) NOT NULL,
188 `prefix` varchar(255) NOT NULL,
189 `suffix` varchar(255) NOT NULL,
190 `default` tinyint(1) NOT NULL DEFAULT '0',
191 PRIMARY KEY (`id`),
192 UNIQUE KEY `name` (`name`),
193 KEY `default` (`default`)
194) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2910 ;
195
196
197
198CREATE TABLE IF NOT EXISTS `permissions_entity_s5` (
199 `id` int(11) NOT NULL AUTO_INCREMENT,
200 `name` varchar(50) NOT NULL,
201 `type` tinyint(1) NOT NULL,
202 `prefix` varchar(255) NOT NULL,
203 `suffix` varchar(255) NOT NULL,
204 `default` tinyint(1) NOT NULL DEFAULT '0',
205 PRIMARY KEY (`id`),
206 UNIQUE KEY `name` (`name`),
207 KEY `default` (`default`)
208) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3179 ;
209
210
211
212CREATE TABLE IF NOT EXISTS `permissions_inheritance_s1` (
213 `id` int(11) NOT NULL AUTO_INCREMENT,
214 `child` varchar(50) NOT NULL,
215 `parent` varchar(50) NOT NULL,
216 `type` tinyint(1) NOT NULL,
217 `world` varchar(50) DEFAULT NULL,
218 PRIMARY KEY (`id`),
219 UNIQUE KEY `child` (`child`,`parent`,`type`,`world`),
220 KEY `child_2` (`child`,`type`),
221 KEY `parent` (`parent`,`type`)
222) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2831 ;
223
224
225
226CREATE TABLE IF NOT EXISTS `permissions_inheritance_s2` (
227 `id` int(11) NOT NULL AUTO_INCREMENT,
228 `child` varchar(50) NOT NULL,
229 `parent` varchar(50) NOT NULL,
230 `type` tinyint(1) NOT NULL,
231 `world` varchar(50) DEFAULT NULL,
232 PRIMARY KEY (`id`),
233 UNIQUE KEY `child` (`child`,`parent`,`type`,`world`),
234 KEY `child_2` (`child`,`type`),
235 KEY `parent` (`parent`,`type`)
236) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=273 ;
237
238
239
240CREATE TABLE IF NOT EXISTS `permissions_inheritance_s3` (
241 `id` int(11) NOT NULL AUTO_INCREMENT,
242 `child` varchar(50) NOT NULL,
243 `parent` varchar(50) NOT NULL,
244 `type` tinyint(1) NOT NULL,
245 `world` varchar(50) DEFAULT NULL,
246 PRIMARY KEY (`id`),
247 UNIQUE KEY `child` (`child`,`parent`,`type`,`world`),
248 KEY `child_2` (`child`,`type`),
249 KEY `parent` (`parent`,`type`)
250) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2745 ;
251
252
253
254
255CREATE TABLE IF NOT EXISTS `permissions_inheritance_s4` (
256 `id` int(11) NOT NULL AUTO_INCREMENT,
257 `child` varchar(50) NOT NULL,
258 `parent` varchar(50) NOT NULL,
259 `type` tinyint(1) NOT NULL,
260 `world` varchar(50) DEFAULT NULL,
261 PRIMARY KEY (`id`),
262 UNIQUE KEY `child` (`child`,`parent`,`type`,`world`),
263 KEY `child_2` (`child`,`type`),
264 KEY `parent` (`parent`,`type`)
265) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2599 ;
266
267
268
269CREATE TABLE IF NOT EXISTS `permissions_inheritance_s5` (
270 `id` int(11) NOT NULL AUTO_INCREMENT,
271 `child` varchar(50) NOT NULL,
272 `parent` varchar(50) NOT NULL,
273 `type` tinyint(1) NOT NULL,
274 `world` varchar(50) DEFAULT NULL,
275 PRIMARY KEY (`id`),
276 UNIQUE KEY `child` (`child`,`parent`,`type`,`world`),
277 KEY `child_2` (`child`,`type`),
278 KEY `parent` (`parent`,`type`)
279) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2633 ;
280
281
282
283
284CREATE TABLE IF NOT EXISTS `permissions_s1` (
285 `id` int(11) NOT NULL AUTO_INCREMENT,
286 `name` varchar(50) NOT NULL,
287 `type` tinyint(1) NOT NULL,
288 `permission` varchar(200) NOT NULL,
289 `world` varchar(50) NOT NULL,
290 `value` text NOT NULL,
291 PRIMARY KEY (`id`),
292 UNIQUE KEY `unique` (`name`,`permission`,`world`,`type`),
293 KEY `user` (`name`,`type`),
294 KEY `world` (`world`,`name`,`type`)
295) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3045668 ;
296
297
298CREATE TABLE IF NOT EXISTS `permissions_s2` (
299 `id` int(11) NOT NULL AUTO_INCREMENT,
300 `name` varchar(50) NOT NULL,
301 `type` tinyint(1) NOT NULL,
302 `permission` varchar(200) NOT NULL,
303 `world` varchar(50) NOT NULL,
304 `value` text NOT NULL,
305 PRIMARY KEY (`id`),
306 UNIQUE KEY `unique` (`name`,`permission`,`world`,`type`),
307 KEY `user` (`name`,`type`),
308 KEY `world` (`world`,`name`,`type`)
309) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1269972 ;
310
311
312
313CREATE TABLE IF NOT EXISTS `permissions_s3` (
314 `id` int(11) NOT NULL AUTO_INCREMENT,
315 `name` varchar(50) NOT NULL,
316 `type` tinyint(1) NOT NULL,
317 `permission` varchar(200) NOT NULL,
318 `world` varchar(50) NOT NULL,
319 `value` text NOT NULL,
320 PRIMARY KEY (`id`),
321 UNIQUE KEY `unique` (`name`,`permission`,`world`,`type`),
322 KEY `user` (`name`,`type`),
323 KEY `world` (`world`,`name`,`type`)
324) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=824027 ;
325
326
327
328
329CREATE TABLE IF NOT EXISTS `permissions_s4` (
330 `id` int(11) NOT NULL AUTO_INCREMENT,
331 `name` varchar(50) NOT NULL,
332 `type` tinyint(1) NOT NULL,
333 `permission` varchar(200) NOT NULL,
334 `world` varchar(50) NOT NULL,
335 `value` text NOT NULL,
336 PRIMARY KEY (`id`),
337 UNIQUE KEY `unique` (`name`,`permission`,`world`,`type`),
338 KEY `user` (`name`,`type`),
339 KEY `world` (`world`,`name`,`type`)
340) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16949 ;
341
342
343
344CREATE TABLE IF NOT EXISTS `permissions_s5` (
345 `id` int(11) NOT NULL AUTO_INCREMENT,
346 `name` varchar(50) NOT NULL,
347 `type` tinyint(1) NOT NULL,
348 `permission` varchar(200) NOT NULL,
349 `world` varchar(50) NOT NULL,
350 `value` text NOT NULL,
351 PRIMARY KEY (`id`),
352 UNIQUE KEY `unique` (`name`,`permission`,`world`,`type`),
353 KEY `user` (`name`,`type`),
354 KEY `world` (`world`,`name`,`type`)
355) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8637 ;
356
357
358
359CREATE TABLE IF NOT EXISTS `robokassa_pays` (
360 `id` int(11) NOT NULL AUTO_INCREMENT,
361 `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '1',
362 `money` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '0',
363 `dic` varchar(512) CHARACTER SET utf8 NOT NULL DEFAULT '0',
364 `date` varchar(55) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '0',
365 `pay` varchar(55) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '0',
366 `unixtime` int(100) NOT NULL DEFAULT '0',
367 PRIMARY KEY (`id`)
368) ENGINE=InnoDB DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2569 ;
369
370
371CREATE TABLE IF NOT EXISTS `stats_buy` (
372 `id` int(11) NOT NULL AUTO_INCREMENT,
373 `lk` int(11) NOT NULL DEFAULT '0',
374 `shop` int(11) NOT NULL DEFAULT '0',
375 `enchant` int(11) NOT NULL DEFAULT '0',
376 `sales` int(11) NOT NULL DEFAULT '0',
377 `s1` int(255) NOT NULL DEFAULT '0',
378 PRIMARY KEY (`id`)
379) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;
380
381
382CREATE TABLE IF NOT EXISTS `stats_lk` (
383 `id` int(11) NOT NULL AUTO_INCREMENT,
384 `nick` int(11) NOT NULL DEFAULT '0',
385 `group` int(11) NOT NULL DEFAULT '0',
386 `skin` int(11) NOT NULL DEFAULT '0',
387 `cloak` int(11) NOT NULL DEFAULT '0',
388 PRIMARY KEY (`id`)
389) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;