· 4 years ago · Aug 02, 2021, 03:46 PM
1/*
2 Navicat MySQL Data Transfer
3
4 Source Server : localhost
5 Source Server Type : MySQL
6 Source Server Version : 50731
7 Source Host : localhost:3306
8 Source Schema : buble
9
10 Target Server Type : MySQL
11 Target Server Version : 50731
12 File Encoding : 65001
13
14 Date: 02/08/2021 16:38:05
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for achievements
22-- ----------------------------
23DROP TABLE IF EXISTS `achievements`;
24CREATE TABLE `achievements` (
25 `id` int(10) NOT NULL AUTO_INCREMENT,
26 `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'ACH_',
27 `category` enum('identity','explore','music','social','games','room_builder','pets','tools','events') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'identity',
28 `level` int(11) NOT NULL DEFAULT 1,
29 `reward_amount` int(11) NOT NULL DEFAULT 100,
30 `reward_type` int(2) NOT NULL DEFAULT 0,
31 `points` int(11) NULL DEFAULT 10,
32 `progress_needed` int(11) NOT NULL DEFAULT 1,
33 PRIMARY KEY (`name`, `level`) USING BTREE,
34 UNIQUE INDEX `id`(`id`) USING BTREE
35) ENGINE = MyISAM AUTO_INCREMENT = 2758 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
36
37-- ----------------------------
38-- Table structure for achievements_talents
39-- ----------------------------
40DROP TABLE IF EXISTS `achievements_talents`;
41CREATE TABLE `achievements_talents` (
42 `id` int(11) NOT NULL AUTO_INCREMENT,
43 `type` enum('citizenship','helper') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'citizenship',
44 `level` int(11) NOT NULL DEFAULT 0,
45 `achievement_ids` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
46 `achievement_levels` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
47 `reward_furni` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
48 `reward_perks` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
49 `reward_badges` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
50 PRIMARY KEY (`id`) USING BTREE
51) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
52
53-- ----------------------------
54-- Table structure for bans
55-- ----------------------------
56DROP TABLE IF EXISTS `bans`;
57CREATE TABLE `bans` (
58 `id` int(11) NOT NULL AUTO_INCREMENT,
59 `user_id` int(11) NOT NULL,
60 `ip` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
61 `machine_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
62 `user_staff_id` int(11) NOT NULL,
63 `timestamp` int(11) NOT NULL,
64 `ban_expire` int(32) NOT NULL DEFAULT 0,
65 `ban_reason` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
66 `type` enum('account','ip','machine','super') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'account' COMMENT 'Account is the entry in the users table banned.\nIP is any client that connects with that IP.\nMachine is the computer that logged in.\nSuper is all of the above.',
67 `cfh_topic` int(4) NOT NULL DEFAULT -1,
68 PRIMARY KEY (`id`) USING BTREE,
69 INDEX `user_data`(`user_id`, `ip`, `machine_id`, `ban_expire`, `timestamp`, `ban_reason`) USING BTREE,
70 INDEX `general`(`id`, `type`) USING BTREE
71) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
72
73-- ----------------------------
74-- Table structure for bot_serves
75-- ----------------------------
76DROP TABLE IF EXISTS `bot_serves`;
77CREATE TABLE `bot_serves` (
78 `keys` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
79 `item` int(11) NOT NULL
80) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
81
82-- ----------------------------
83-- Table structure for bots
84-- ----------------------------
85DROP TABLE IF EXISTS `bots`;
86CREATE TABLE `bots` (
87 `id` int(11) NOT NULL AUTO_INCREMENT,
88 `user_id` int(11) NOT NULL DEFAULT 0,
89 `room_id` int(11) NOT NULL DEFAULT 0,
90 `name` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
91 `motto` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
92 `figure` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
93 `gender` enum('M','F') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'M',
94 `x` int(11) NOT NULL DEFAULT 0,
95 `y` int(11) NOT NULL DEFAULT 0,
96 `z` double(11, 1) NOT NULL DEFAULT 0.0,
97 `rot` int(11) NOT NULL DEFAULT 0,
98 `chat_lines` varchar(5112) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
99 `chat_auto` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
100 `chat_random` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
101 `chat_delay` int(11) NOT NULL DEFAULT 5,
102 `dance` int(11) NOT NULL DEFAULT 0,
103 `freeroam` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
104 `type` enum('generic','visitor_log','bartender','weapons_dealer') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'generic',
105 `effect` int(3) NOT NULL DEFAULT 0,
106 `bubble_id` int(3) NULL DEFAULT 31,
107 PRIMARY KEY (`id`) USING BTREE,
108 INDEX `general_data`(`id`, `user_id`, `room_id`, `name`, `motto`, `gender`) USING BTREE
109) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
110
111-- ----------------------------
112-- Table structure for calendar_rewards
113-- ----------------------------
114DROP TABLE IF EXISTS `calendar_rewards`;
115CREATE TABLE `calendar_rewards` (
116 `id` int(11) NOT NULL AUTO_INCREMENT,
117 `custom_image` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
118 `credits` int(11) NOT NULL DEFAULT 0,
119 `points` int(11) NOT NULL DEFAULT 0,
120 `points_type` int(3) NOT NULL DEFAULT 0,
121 `badge` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
122 `item_id` int(11) NOT NULL DEFAULT 0,
123 PRIMARY KEY (`id`) USING BTREE
124) ENGINE = MyISAM AUTO_INCREMENT = 32 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
125
126-- ----------------------------
127-- Table structure for calendar_rewards_claimed
128-- ----------------------------
129DROP TABLE IF EXISTS `calendar_rewards_claimed`;
130CREATE TABLE `calendar_rewards_claimed` (
131 `user_id` int(11) NOT NULL,
132 `reward_id` int(11) NOT NULL,
133 `timestamp` int(11) NOT NULL
134) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
135
136-- ----------------------------
137-- Table structure for camera_web
138-- ----------------------------
139DROP TABLE IF EXISTS `camera_web`;
140CREATE TABLE `camera_web` (
141 `id` int(11) NOT NULL AUTO_INCREMENT,
142 `user_id` int(11) NOT NULL,
143 `room_id` int(11) NOT NULL DEFAULT 0,
144 `timestamp` int(11) NOT NULL,
145 `url` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
146 PRIMARY KEY (`id`) USING BTREE,
147 UNIQUE INDEX `id`(`id`) USING BTREE,
148 INDEX `user_id`(`user_id`) USING BTREE
149) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
150
151-- ----------------------------
152-- Table structure for catalog_clothing
153-- ----------------------------
154DROP TABLE IF EXISTS `catalog_clothing`;
155CREATE TABLE `catalog_clothing` (
156 `id` int(11) NOT NULL AUTO_INCREMENT,
157 `name` varchar(75) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
158 `setid` varchar(75) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
159 PRIMARY KEY (`id`) USING BTREE
160) ENGINE = MyISAM AUTO_INCREMENT = 845 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
161
162-- ----------------------------
163-- Table structure for catalog_club_offers
164-- ----------------------------
165DROP TABLE IF EXISTS `catalog_club_offers`;
166CREATE TABLE `catalog_club_offers` (
167 `id` int(11) NOT NULL,
168 `enabled` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
169 `name` varchar(35) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
170 `days` int(7) NOT NULL,
171 `credits` int(5) NOT NULL DEFAULT 10,
172 `points` int(5) NOT NULL DEFAULT 0,
173 `points_type` int(3) NOT NULL DEFAULT 0,
174 `type` enum('HC','VIP') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'HC',
175 `deal` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
176 `giftable` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
177 PRIMARY KEY (`id`) USING BTREE
178) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
179
180-- ----------------------------
181-- Table structure for catalog_featured_pages
182-- ----------------------------
183DROP TABLE IF EXISTS `catalog_featured_pages`;
184CREATE TABLE `catalog_featured_pages` (
185 `slot_id` int(11) NOT NULL,
186 `image` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
187 `caption` varchar(130) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
188 `type` enum('page_name','page_id','product_name') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'page_name',
189 `expire_timestamp` int(11) NOT NULL DEFAULT -1,
190 `page_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
191 `page_id` int(11) NOT NULL DEFAULT 0,
192 `product_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
193 PRIMARY KEY (`slot_id`) USING BTREE
194) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
195
196-- ----------------------------
197-- Table structure for catalog_items
198-- ----------------------------
199DROP TABLE IF EXISTS `catalog_items`;
200CREATE TABLE `catalog_items` (
201 `id` int(16) NOT NULL AUTO_INCREMENT,
202 `item_ids` varchar(666) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
203 `page_id` int(11) NOT NULL,
204 `catalog_name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
205 `cost_credits` int(11) NOT NULL DEFAULT 3,
206 `cost_points` int(11) NOT NULL DEFAULT 0,
207 `points_type` int(3) NOT NULL DEFAULT 0 COMMENT '0 for duckets; 5 for diamonds; and any seasonal/GOTW currencies you have in your emu_settings table.',
208 `amount` int(11) NOT NULL DEFAULT 1,
209 `limited_stack` int(11) NOT NULL DEFAULT 0 COMMENT 'Change this number to make the item limited.',
210 `limited_sells` int(11) NOT NULL DEFAULT 0 COMMENT 'This automatically logs from the emu; do not change it.',
211 `order_number` int(11) NOT NULL DEFAULT 1,
212 `offer_id` int(11) NOT NULL DEFAULT -1,
213 `song_id` int(3) UNSIGNED NOT NULL DEFAULT 0,
214 `extradata` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
215 `have_offer` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
216 `club_only` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
217 PRIMARY KEY (`id`) USING BTREE,
218 INDEX `page_id`(`page_id`) USING BTREE,
219 INDEX `catalog_name`(`catalog_name`) USING BTREE,
220 INDEX `costs`(`cost_credits`, `cost_points`, `points_type`) USING BTREE,
221 INDEX `id`(`id`) USING BTREE
222) ENGINE = InnoDB AUTO_INCREMENT = 20501 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
223
224-- ----------------------------
225-- Table structure for catalog_items_bc
226-- ----------------------------
227DROP TABLE IF EXISTS `catalog_items_bc`;
228CREATE TABLE `catalog_items_bc` (
229 `id` int(16) NOT NULL AUTO_INCREMENT,
230 `item_ids` varchar(666) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
231 `page_id` int(11) NOT NULL,
232 `catalog_name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
233 `order_number` int(11) NOT NULL DEFAULT 1,
234 `extradata` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
235 PRIMARY KEY (`id`) USING BTREE
236) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
237
238-- ----------------------------
239-- Table structure for catalog_items_limited
240-- ----------------------------
241DROP TABLE IF EXISTS `catalog_items_limited`;
242CREATE TABLE `catalog_items_limited` (
243 `catalog_item_id` int(11) NOT NULL,
244 `number` int(11) NOT NULL,
245 `user_id` int(11) NOT NULL DEFAULT 0,
246 `timestamp` int(11) NOT NULL DEFAULT 0,
247 `item_id` int(11) NOT NULL DEFAULT 0,
248 UNIQUE INDEX `catalog_item_id`(`catalog_item_id`, `number`) USING BTREE,
249 INDEX `user_timestamp_index`(`user_id`, `timestamp`) USING BTREE
250) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
251
252-- ----------------------------
253-- Table structure for catalog_pages
254-- ----------------------------
255DROP TABLE IF EXISTS `catalog_pages`;
256CREATE TABLE `catalog_pages` (
257 `id` int(11) NOT NULL AUTO_INCREMENT,
258 `parent_id` int(11) NOT NULL DEFAULT -1,
259 `caption_save` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
260 `caption` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
261 `page_layout` enum('default_3x3','club_buy','club_gift','frontpage','spaces','recycler','recycler_info','recycler_prizes','trophies','plasto','marketplace','marketplace_own_items','spaces_new','soundmachine','guilds','guild_furni','info_duckets','info_rentables','info_pets','roomads','single_bundle','sold_ltd_items','badge_display','bots','pets','pets2','pets3','productpage1','room_bundle','recent_purchases','default_3x3_color_grouping','guild_forum','vip_buy','info_loyalty','loyalty_vip_buy','collectibles','petcustomization','frontpage_featured') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'default_3x3',
262 `icon_color` int(5) NOT NULL DEFAULT 1,
263 `icon_image` int(5) NOT NULL DEFAULT 1,
264 `min_rank` int(5) NOT NULL DEFAULT 1,
265 `order_num` int(5) NOT NULL DEFAULT 1,
266 `visible` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
267 `enabled` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
268 `club_only` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
269 `vip_only` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
270 `page_headline` varchar(1024) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
271 `page_teaser` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
272 `page_special` varchar(2048) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '' COMMENT 'Gold Bubble: catalog_special_txtbg1 // Speech Bubble: catalog_special_txtbg2 // Place normal text in page_text_teaser',
273 `page_text1` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
274 `page_text2` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
275 `page_text_details` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
276 `page_text_teaser` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
277 `room_id` int(5) NULL DEFAULT 0,
278 `includes` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '' COMMENT 'Example usage: 1;2;3\r\n This will include page 1, 2 and 3 in the current page.\r\n Note that permissions are only used for the current entry.',
279 PRIMARY KEY (`id`) USING BTREE,
280 INDEX `id`(`id`) USING BTREE
281) ENGINE = MyISAM AUTO_INCREMENT = 1111 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
282
283-- ----------------------------
284-- Table structure for catalog_pages_bc
285-- ----------------------------
286DROP TABLE IF EXISTS `catalog_pages_bc`;
287CREATE TABLE `catalog_pages_bc` (
288 `id` int(11) NOT NULL AUTO_INCREMENT,
289 `parent_id` int(11) NOT NULL DEFAULT -1,
290 `caption` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
291 `page_layout` enum('default_3x3','club_buy','club_gift','frontpage','spaces','recycler','recycler_info','recycler_prizes','trophies','plasto','marketplace','marketplace_own_items','spaces_new','soundmachine','guilds','guild_furni','info_duckets','info_rentables','info_pets','roomads','single_bundle','sold_ltd_items','badge_display','bots','pets','pets2','pets3','productpage1','room_bundle','recent_purchases','default_3x3_color_grouping','guild_forum','vip_buy','info_loyalty','loyalty_vip_buy','collectibles','petcustomization','frontpage_featured') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'default_3x3',
292 `icon_color` int(5) NOT NULL DEFAULT 1,
293 `icon_image` int(5) NOT NULL DEFAULT 1,
294 `order_num` int(5) NOT NULL DEFAULT 1,
295 `visible` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
296 `enabled` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
297 `page_headline` varchar(1024) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
298 `page_teaser` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
299 `page_special` varchar(2048) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '' COMMENT 'Gold Bubble: catalog_special_txtbg1 // Speech Bubble: catalog_special_txtbg2 // Place normal text in page_text_teaser',
300 `page_text1` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
301 `page_text2` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
302 `page_text_details` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
303 `page_text_teaser` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
304 PRIMARY KEY (`id`) USING BTREE
305) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
306
307-- ----------------------------
308-- Table structure for catalog_target_offers
309-- ----------------------------
310DROP TABLE IF EXISTS `catalog_target_offers`;
311CREATE TABLE `catalog_target_offers` (
312 `id` int(11) NOT NULL AUTO_INCREMENT,
313 `offer_code` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
314 `title` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
315 `description` varchar(2048) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
316 `image` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
317 `icon` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
318 `end_timestamp` int(11) NOT NULL,
319 `credits` int(5) NOT NULL DEFAULT 10,
320 `points` int(5) NOT NULL DEFAULT 10,
321 `points_type` int(3) NOT NULL DEFAULT 5,
322 `purchase_limit` int(2) NOT NULL DEFAULT 5,
323 `catalog_item` int(11) NOT NULL,
324 `vars` varchar(1024) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '' COMMENT 'List of strings seperated by a ;',
325 PRIMARY KEY (`id`) USING BTREE
326) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
327
328-- ----------------------------
329-- Table structure for chatlogs_private
330-- ----------------------------
331DROP TABLE IF EXISTS `chatlogs_private`;
332CREATE TABLE `chatlogs_private` (
333 `id` int(11) NOT NULL AUTO_INCREMENT,
334 `user_from_id` int(11) NOT NULL,
335 `user_to_id` int(11) NOT NULL,
336 `message` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
337 `timestamp` int(11) NOT NULL DEFAULT 0,
338 PRIMARY KEY (`id`) USING BTREE,
339 INDEX `id`(`id`) USING BTREE,
340 INDEX `user_from_id`(`user_from_id`) USING BTREE,
341 INDEX `user_to_id`(`user_to_id`) USING BTREE,
342 INDEX `message`(`message`) USING BTREE
343) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
344
345-- ----------------------------
346-- Table structure for chatlogs_room
347-- ----------------------------
348DROP TABLE IF EXISTS `chatlogs_room`;
349CREATE TABLE `chatlogs_room` (
350 `room_id` int(11) NOT NULL DEFAULT 0,
351 `user_from_id` int(11) NOT NULL,
352 `user_to_id` int(11) NOT NULL DEFAULT 0,
353 `message` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
354 `timestamp` int(32) NOT NULL,
355 INDEX `user_from_id`(`user_from_id`) USING BTREE,
356 INDEX `timestamp`(`timestamp`) USING BTREE,
357 INDEX `user_to_id`(`user_to_id`) USING BTREE,
358 INDEX `message`(`message`) USING BTREE,
359 INDEX `room_id`(`room_id`) USING BTREE
360) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
361
362-- ----------------------------
363-- Table structure for cms_alerts
364-- ----------------------------
365DROP TABLE IF EXISTS `cms_alerts`;
366CREATE TABLE `cms_alerts` (
367 `id` int(11) NOT NULL AUTO_INCREMENT,
368 `message` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
369 `icon` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'ADM',
370 `userid` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
371 PRIMARY KEY (`id`) USING BTREE
372) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
373
374-- ----------------------------
375-- Table structure for cms_badges
376-- ----------------------------
377DROP TABLE IF EXISTS `cms_badges`;
378CREATE TABLE `cms_badges` (
379 `id` int(7) NOT NULL AUTO_INCREMENT,
380 `code` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
381 `title` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
382 `desc` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
383 `news_id` int(77) NOT NULL DEFAULT 0,
384 PRIMARY KEY (`id`) USING BTREE
385) ENGINE = MyISAM AUTO_INCREMENT = 6 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
386
387-- ----------------------------
388-- Table structure for cms_clothing
389-- ----------------------------
390DROP TABLE IF EXISTS `cms_clothing`;
391CREATE TABLE `cms_clothing` (
392 `id` int(7) NOT NULL AUTO_INCREMENT,
393 `title` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
394 `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
395 PRIMARY KEY (`id`) USING BTREE
396) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
397
398-- ----------------------------
399-- Table structure for cms_furniture
400-- ----------------------------
401DROP TABLE IF EXISTS `cms_furniture`;
402CREATE TABLE `cms_furniture` (
403 `id` int(7) NOT NULL AUTO_INCREMENT,
404 `title` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
405 `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
406 PRIMARY KEY (`id`) USING BTREE
407) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
408
409-- ----------------------------
410-- Table structure for cms_fuserights
411-- ----------------------------
412DROP TABLE IF EXISTS `cms_fuserights`;
413CREATE TABLE `cms_fuserights` (
414 `right` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
415 `min_rank` int(25) NOT NULL,
416 `desc` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
417 `type` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
418 PRIMARY KEY (`right`) USING BTREE
419) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
420
421-- ----------------------------
422-- Table structure for cms_hk_logs
423-- ----------------------------
424DROP TABLE IF EXISTS `cms_hk_logs`;
425CREATE TABLE `cms_hk_logs` (
426 `id` int(255) NOT NULL AUTO_INCREMENT,
427 `user_id` int(255) NOT NULL,
428 `ip` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
429 `action` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
430 `timestamp` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
431 PRIMARY KEY (`id`) USING BTREE
432) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
433
434-- ----------------------------
435-- Table structure for cms_homes
436-- ----------------------------
437DROP TABLE IF EXISTS `cms_homes`;
438CREATE TABLE `cms_homes` (
439 `id` int(255) NOT NULL AUTO_INCREMENT,
440 `user_id` int(255) NOT NULL,
441 `type` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
442 `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
443 `z` int(255) NULL DEFAULT NULL,
444 `x` int(255) NULL DEFAULT NULL,
445 `y` int(255) NULL DEFAULT NULL,
446 `skin` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
447 `visible` int(255) NOT NULL DEFAULT 1,
448 `data` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
449 PRIMARY KEY (`id`) USING BTREE
450) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
451
452-- ----------------------------
453-- Table structure for cms_homes_catalogue
454-- ----------------------------
455DROP TABLE IF EXISTS `cms_homes_catalogue`;
456CREATE TABLE `cms_homes_catalogue` (
457 `id` int(11) NOT NULL AUTO_INCREMENT,
458 `type` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 's',
459 `data` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
460 `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
461 `category` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
462 PRIMARY KEY (`id`) USING BTREE
463) ENGINE = InnoDB AUTO_INCREMENT = 81 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
464
465-- ----------------------------
466-- Table structure for cms_homes_catalogue_cats
467-- ----------------------------
468DROP TABLE IF EXISTS `cms_homes_catalogue_cats`;
469CREATE TABLE `cms_homes_catalogue_cats` (
470 `id` int(11) NOT NULL AUTO_INCREMENT,
471 `type` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 's',
472 `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
473 PRIMARY KEY (`id`) USING BTREE
474) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
475
476-- ----------------------------
477-- Table structure for cms_logins
478-- ----------------------------
479DROP TABLE IF EXISTS `cms_logins`;
480CREATE TABLE `cms_logins` (
481 `id` int(255) NOT NULL AUTO_INCREMENT,
482 `user_id` int(255) NOT NULL,
483 `ip` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
484 `timestamp` int(255) NOT NULL,
485 `successful` int(255) NOT NULL,
486 PRIMARY KEY (`id`) USING BTREE
487) ENGINE = InnoDB AUTO_INCREMENT = 55 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
488
489-- ----------------------------
490-- Table structure for cms_menu
491-- ----------------------------
492DROP TABLE IF EXISTS `cms_menu`;
493CREATE TABLE `cms_menu` (
494 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
495 `group` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '',
496 `title` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
497 `url` varchar(230) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
498 `order` int(11) NOT NULL,
499 PRIMARY KEY (`id`) USING BTREE
500) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
501
502-- ----------------------------
503-- Table structure for cms_news
504-- ----------------------------
505DROP TABLE IF EXISTS `cms_news`;
506CREATE TABLE `cms_news` (
507 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
508 `caption` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
509 `desc` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
510 `body` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
511 `image` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
512 `author` int(11) NOT NULL,
513 `date` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
514 `category` int(7) NOT NULL DEFAULT 1,
515 `main` int(11) NOT NULL DEFAULT 0,
516 PRIMARY KEY (`id`) USING BTREE
517) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
518
519-- ----------------------------
520-- Table structure for cms_settings
521-- ----------------------------
522DROP TABLE IF EXISTS `cms_settings`;
523CREATE TABLE `cms_settings` (
524 `id` int(7) NOT NULL AUTO_INCREMENT,
525 `key` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
526 `value` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
527 PRIMARY KEY (`id`) USING BTREE
528) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
529
530-- ----------------------------
531-- Table structure for commandlogs
532-- ----------------------------
533DROP TABLE IF EXISTS `commandlogs`;
534CREATE TABLE `commandlogs` (
535 `user_id` int(11) NOT NULL,
536 `timestamp` int(11) NOT NULL,
537 `command` varchar(256) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
538 `params` varchar(256) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
539 `succes` enum('no','yes') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'yes',
540 INDEX `user_id`(`user_id`) USING BTREE,
541 INDEX `user_data`(`user_id`, `timestamp`) USING BTREE,
542 INDEX `command`(`command`) USING BTREE
543) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
544
545-- ----------------------------
546-- Table structure for crafting_altars_recipes
547-- ----------------------------
548DROP TABLE IF EXISTS `crafting_altars_recipes`;
549CREATE TABLE `crafting_altars_recipes` (
550 `altar_id` int(11) NOT NULL,
551 `recipe_id` int(11) NOT NULL,
552 UNIQUE INDEX `altar_id`(`altar_id`, `recipe_id`) USING BTREE
553) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
554
555-- ----------------------------
556-- Table structure for crafting_recipes
557-- ----------------------------
558DROP TABLE IF EXISTS `crafting_recipes`;
559CREATE TABLE `crafting_recipes` (
560 `id` int(11) NOT NULL,
561 `product_name` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'WARNING! This field must match a entry in your productdata or crafting WILL NOT WORK!',
562 `reward` int(11) NOT NULL,
563 `enabled` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
564 `achievement` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
565 `secret` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
566 `limited` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
567 `remaining` int(11) NOT NULL DEFAULT 0,
568 PRIMARY KEY (`id`) USING BTREE,
569 UNIQUE INDEX `id`(`id`) USING BTREE,
570 UNIQUE INDEX `name`(`product_name`) USING BTREE
571) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
572
573-- ----------------------------
574-- Table structure for crafting_recipes_ingredients
575-- ----------------------------
576DROP TABLE IF EXISTS `crafting_recipes_ingredients`;
577CREATE TABLE `crafting_recipes_ingredients` (
578 `recipe_id` int(11) NOT NULL,
579 `item_id` int(11) NOT NULL,
580 `amount` int(11) NOT NULL DEFAULT 1
581) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
582
583-- ----------------------------
584-- Table structure for emulator_errors
585-- ----------------------------
586DROP TABLE IF EXISTS `emulator_errors`;
587CREATE TABLE `emulator_errors` (
588 `id` int(16) NOT NULL AUTO_INCREMENT,
589 `timestamp` int(32) NOT NULL DEFAULT 0,
590 `version` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
591 `build_hash` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
592 `type` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Exception',
593 `stacktrace` blob NOT NULL,
594 PRIMARY KEY (`id`) USING BTREE
595) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
596
597-- ----------------------------
598-- Table structure for emulator_settings
599-- ----------------------------
600DROP TABLE IF EXISTS `emulator_settings`;
601CREATE TABLE `emulator_settings` (
602 `key` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
603 `value` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
604 PRIMARY KEY (`key`) USING BTREE
605) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
606
607-- ----------------------------
608-- Table structure for emulator_texts
609-- ----------------------------
610DROP TABLE IF EXISTS `emulator_texts`;
611CREATE TABLE `emulator_texts` (
612 `key` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
613 `value` varchar(4096) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
614 PRIMARY KEY (`key`) USING BTREE
615) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
616
617-- ----------------------------
618-- Table structure for gift_wrappers
619-- ----------------------------
620DROP TABLE IF EXISTS `gift_wrappers`;
621CREATE TABLE `gift_wrappers` (
622 `id` int(11) NOT NULL AUTO_INCREMENT,
623 `sprite_id` int(11) NOT NULL,
624 `item_id` int(11) NOT NULL,
625 `type` enum('gift','wrapper') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'wrapper',
626 PRIMARY KEY (`id`) USING BTREE
627) ENGINE = MyISAM AUTO_INCREMENT = 18 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
628
629-- ----------------------------
630-- Table structure for groups_items
631-- ----------------------------
632DROP TABLE IF EXISTS `groups_items`;
633CREATE TABLE `groups_items` (
634 `type` enum('base','symbol','color','color2','color3') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
635 `id` int(255) NOT NULL,
636 `firstvalue` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
637 `secondvalue` varchar(2000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
638 `enabled` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
639 PRIMARY KEY (`id`, `type`) USING BTREE,
640 INDEX `type`(`type`) USING BTREE,
641 INDEX `id`(`id`) USING BTREE
642) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
643
644-- ----------------------------
645-- Table structure for guild_forum_views
646-- ----------------------------
647DROP TABLE IF EXISTS `guild_forum_views`;
648CREATE TABLE `guild_forum_views` (
649 `id` int(11) NOT NULL AUTO_INCREMENT,
650 `user_id` int(11) NOT NULL,
651 `guild_id` int(11) NOT NULL,
652 `timestamp` int(11) NOT NULL,
653 PRIMARY KEY (`id`) USING BTREE
654) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
655
656-- ----------------------------
657-- Table structure for guilds
658-- ----------------------------
659DROP TABLE IF EXISTS `guilds`;
660CREATE TABLE `guilds` (
661 `id` int(11) NOT NULL AUTO_INCREMENT,
662 `user_id` int(11) NOT NULL DEFAULT 0,
663 `name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
664 `description` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
665 `room_id` int(11) NOT NULL DEFAULT 0,
666 `state` int(3) NOT NULL DEFAULT 0,
667 `rights` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
668 `color_one` int(11) NOT NULL DEFAULT 0,
669 `color_two` int(11) NOT NULL DEFAULT 0,
670 `badge` varchar(256) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
671 `date_created` int(11) NOT NULL,
672 `forum` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
673 `read_forum` enum('EVERYONE','MEMBERS','ADMINS') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'EVERYONE',
674 `post_messages` enum('EVERYONE','MEMBERS','ADMINS','OWNER') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'EVERYONE',
675 `post_threads` enum('EVERYONE','MEMBERS','ADMINS','OWNER') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'EVERYONE',
676 `mod_forum` enum('ADMINS','OWNER') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'ADMINS',
677 PRIMARY KEY (`id`) USING BTREE,
678 INDEX `id`(`id`) USING BTREE,
679 INDEX `data`(`room_id`, `user_id`) USING BTREE,
680 INDEX `name`(`name`) USING BTREE,
681 INDEX `description`(`description`) USING BTREE
682) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
683
684-- ----------------------------
685-- Table structure for guilds_elements
686-- ----------------------------
687DROP TABLE IF EXISTS `guilds_elements`;
688CREATE TABLE `guilds_elements` (
689 `id` int(11) NOT NULL,
690 `firstvalue` varchar(300) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
691 `secondvalue` varchar(300) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
692 `type` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
693 `enabled` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
694 UNIQUE INDEX `id`(`id`, `type`) USING BTREE,
695 UNIQUE INDEX `data`(`id`, `type`) USING BTREE
696) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
697
698-- ----------------------------
699-- Table structure for guilds_forums_comments
700-- ----------------------------
701DROP TABLE IF EXISTS `guilds_forums_comments`;
702CREATE TABLE `guilds_forums_comments` (
703 `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
704 `thread_id` int(11) NOT NULL DEFAULT 0,
705 `user_id` int(11) NOT NULL DEFAULT 0,
706 `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
707 `created_at` int(11) NOT NULL DEFAULT 0,
708 `state` int(11) NOT NULL DEFAULT 0,
709 `admin_id` int(11) NOT NULL DEFAULT 0,
710 PRIMARY KEY (`id`) USING BTREE,
711 INDEX `id`(`id`) USING BTREE,
712 INDEX `thread_data`(`thread_id`, `user_id`, `created_at`, `state`) USING BTREE
713) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = COMPACT;
714
715-- ----------------------------
716-- Table structure for guilds_forums_threads
717-- ----------------------------
718DROP TABLE IF EXISTS `guilds_forums_threads`;
719CREATE TABLE `guilds_forums_threads` (
720 `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
721 `guild_id` int(11) NULL DEFAULT 0,
722 `opener_id` int(11) NULL DEFAULT 0,
723 `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '',
724 `posts_count` int(11) NULL DEFAULT 0,
725 `created_at` int(11) NULL DEFAULT 0,
726 `updated_at` int(11) NULL DEFAULT 0,
727 `state` int(11) NULL DEFAULT 0,
728 `pinned` tinyint(4) NULL DEFAULT 0,
729 `locked` tinyint(4) NULL DEFAULT 0,
730 `admin_id` int(11) NULL DEFAULT 0,
731 PRIMARY KEY (`id`) USING BTREE
732) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = COMPACT;
733
734-- ----------------------------
735-- Table structure for guilds_members
736-- ----------------------------
737DROP TABLE IF EXISTS `guilds_members`;
738CREATE TABLE `guilds_members` (
739 `id` int(11) NOT NULL AUTO_INCREMENT,
740 `guild_id` int(11) NOT NULL DEFAULT 0,
741 `user_id` int(11) NOT NULL DEFAULT 0,
742 `level_id` int(3) NOT NULL DEFAULT 0,
743 `member_since` int(11) NOT NULL DEFAULT 0,
744 PRIMARY KEY (`id`) USING BTREE,
745 INDEX `id`(`id`) USING BTREE,
746 INDEX `user_id`(`user_id`) USING BTREE,
747 INDEX `guild_id`(`guild_id`) USING BTREE,
748 INDEX `userdata`(`user_id`, `guild_id`) USING BTREE,
749 INDEX `level_id`(`level_id`) USING BTREE,
750 INDEX `member_since`(`member_since`) USING BTREE
751) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
752
753-- ----------------------------
754-- Table structure for hotelview_news
755-- ----------------------------
756DROP TABLE IF EXISTS `hotelview_news`;
757CREATE TABLE `hotelview_news` (
758 `id` int(11) NOT NULL AUTO_INCREMENT,
759 `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
760 `text` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
761 `button_text` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
762 `button_type` enum('client','web') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'web',
763 `button_link` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
764 `image` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
765 PRIMARY KEY (`id`) USING BTREE
766) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
767
768-- ----------------------------
769-- Table structure for items
770-- ----------------------------
771DROP TABLE IF EXISTS `items`;
772CREATE TABLE `items` (
773 `id` int(11) NOT NULL AUTO_INCREMENT,
774 `user_id` int(11) NOT NULL DEFAULT 0,
775 `room_id` int(11) NOT NULL DEFAULT 0,
776 `item_id` int(11) NULL DEFAULT 0,
777 `wall_pos` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
778 `x` int(11) NOT NULL DEFAULT 0,
779 `y` int(11) NOT NULL DEFAULT 0,
780 `z` double(10, 6) NOT NULL DEFAULT 0.000000,
781 `rot` int(11) NOT NULL DEFAULT 0,
782 `extra_data` varchar(1024) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
783 `wired_data` varchar(10000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
784 `limited_data` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0:0',
785 `guild_id` int(32) NOT NULL DEFAULT 0,
786 PRIMARY KEY (`id`) USING BTREE,
787 INDEX `room_id`(`user_id`, `room_id`) USING BTREE,
788 INDEX `itemsdata`(`room_id`, `item_id`) USING BTREE,
789 INDEX `user_id`(`user_id`) USING BTREE,
790 INDEX `extra_data`(`extra_data`) USING BTREE,
791 INDEX `wired_data`(`wired_data`(3072)) USING BTREE,
792 INDEX `id`(`id`) USING BTREE
793) ENGINE = InnoDB AUTO_INCREMENT = 338 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
794
795-- ----------------------------
796-- Table structure for items_base
797-- ----------------------------
798DROP TABLE IF EXISTS `items_base`;
799CREATE TABLE `items_base` (
800 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
801 `sprite_id` int(11) NOT NULL DEFAULT 0,
802 `public_name` varchar(56) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
803 `item_name` varchar(70) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
804 `type` varchar(3) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 's',
805 `width` int(11) NOT NULL DEFAULT 1,
806 `length` int(11) NOT NULL DEFAULT 1,
807 `stack_height` double(4, 2) NOT NULL DEFAULT 0.00,
808 `allow_stack` tinyint(1) NOT NULL DEFAULT 1,
809 `allow_sit` tinyint(1) NOT NULL DEFAULT 0,
810 `allow_lay` tinyint(1) NOT NULL DEFAULT 0,
811 `allow_walk` tinyint(1) NOT NULL DEFAULT 0,
812 `allow_gift` tinyint(1) NOT NULL DEFAULT 1,
813 `allow_trade` tinyint(1) NOT NULL DEFAULT 1,
814 `allow_recycle` tinyint(1) NOT NULL DEFAULT 0,
815 `allow_marketplace_sell` tinyint(1) NOT NULL DEFAULT 0,
816 `allow_inventory_stack` tinyint(1) NOT NULL DEFAULT 1,
817 `interaction_type` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'default',
818 `interaction_modes_count` int(13) NOT NULL DEFAULT 1,
819 `vending_ids` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
820 `multiheight` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
821 `customparams` varchar(256) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
822 `effect_id_male` int(3) NOT NULL DEFAULT 0,
823 `effect_id_female` int(3) NOT NULL DEFAULT 0,
824 `clothing_on_walk` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
825 PRIMARY KEY (`id`) USING BTREE
826) ENGINE = InnoDB AUTO_INCREMENT = 50513 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
827
828-- ----------------------------
829-- Table structure for items_crackable
830-- ----------------------------
831DROP TABLE IF EXISTS `items_crackable`;
832CREATE TABLE `items_crackable` (
833 `item_id` int(11) NOT NULL,
834 `item_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'Item name for identification',
835 `count` int(11) NOT NULL,
836 `prizes` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '179:1' COMMENT 'Used in the format of item_id:chance;item_id_2:chance. item_id must be id in the items_base table. Default value for chance is 100.',
837 `achievement_tick` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
838 `achievement_cracked` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
839 `required_effect` int(3) NOT NULL DEFAULT 0,
840 `subscription_duration` int(3) NULL DEFAULT NULL,
841 `subscription_type` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT 'hc for Habbo Club, bc for Builders Club',
842 PRIMARY KEY (`item_id`) USING BTREE,
843 UNIQUE INDEX `id`(`item_id`) USING BTREE,
844 INDEX `data`(`count`, `prizes`, `achievement_tick`, `achievement_cracked`) USING BTREE
845) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
846
847-- ----------------------------
848-- Table structure for items_highscore_data
849-- ----------------------------
850DROP TABLE IF EXISTS `items_highscore_data`;
851CREATE TABLE `items_highscore_data` (
852 `id` int(11) NOT NULL AUTO_INCREMENT,
853 `item_id` int(11) NOT NULL,
854 `user_ids` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
855 `score` int(11) NOT NULL,
856 `is_win` tinyint(1) NULL DEFAULT 0,
857 `timestamp` int(11) NOT NULL,
858 PRIMARY KEY (`id`) USING BTREE,
859 INDEX `id`(`id`) USING BTREE,
860 INDEX `data`(`item_id`, `user_ids`) USING BTREE,
861 INDEX `status`(`is_win`, `score`, `timestamp`) USING BTREE
862) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
863
864-- ----------------------------
865-- Table structure for items_hoppers
866-- ----------------------------
867DROP TABLE IF EXISTS `items_hoppers`;
868CREATE TABLE `items_hoppers` (
869 `item_id` int(11) NOT NULL,
870 `base_item` int(11) NOT NULL
871) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
872
873-- ----------------------------
874-- Table structure for items_presents
875-- ----------------------------
876DROP TABLE IF EXISTS `items_presents`;
877CREATE TABLE `items_presents` (
878 `item_id` int(11) NOT NULL,
879 `base_item_reward` int(11) NOT NULL
880) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
881
882-- ----------------------------
883-- Table structure for items_teleports
884-- ----------------------------
885DROP TABLE IF EXISTS `items_teleports`;
886CREATE TABLE `items_teleports` (
887 `teleport_one_id` int(11) NOT NULL,
888 `teleport_two_id` int(11) NOT NULL,
889 INDEX `teleport_one_id`(`teleport_one_id`) USING BTREE,
890 INDEX `teleport_two_id`(`teleport_two_id`) USING BTREE
891) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
892
893-- ----------------------------
894-- Table structure for logs_hc_payday
895-- ----------------------------
896DROP TABLE IF EXISTS `logs_hc_payday`;
897CREATE TABLE `logs_hc_payday` (
898 `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
899 `timestamp` int(10) UNSIGNED NULL DEFAULT NULL,
900 `user_id` int(10) UNSIGNED NULL DEFAULT NULL,
901 `hc_streak` int(10) UNSIGNED NULL DEFAULT NULL,
902 `total_coins_spent` int(10) UNSIGNED NULL DEFAULT NULL,
903 `reward_coins_spent` int(10) UNSIGNED NULL DEFAULT NULL,
904 `reward_streak` int(10) UNSIGNED NULL DEFAULT NULL,
905 `total_payout` int(10) UNSIGNED NULL DEFAULT NULL,
906 `currency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
907 `claimed` tinyint(1) NULL DEFAULT 0,
908 PRIMARY KEY (`id`) USING BTREE,
909 INDEX `timestamp`(`timestamp`) USING BTREE,
910 INDEX `user_id`(`user_id`) USING BTREE
911) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
912
913-- ----------------------------
914-- Table structure for logs_shop_purchases
915-- ----------------------------
916DROP TABLE IF EXISTS `logs_shop_purchases`;
917CREATE TABLE `logs_shop_purchases` (
918 `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
919 `timestamp` int(10) UNSIGNED NULL DEFAULT NULL,
920 `user_id` int(10) UNSIGNED NULL DEFAULT NULL,
921 `catalog_item_id` int(10) UNSIGNED NULL DEFAULT NULL,
922 `item_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
923 `catalog_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
924 `cost_credits` int(10) NULL DEFAULT NULL,
925 `cost_points` int(10) NULL DEFAULT NULL,
926 `points_type` int(10) NULL DEFAULT NULL,
927 `amount` int(10) NULL DEFAULT NULL,
928 PRIMARY KEY (`id`) USING BTREE,
929 INDEX `timestamp`(`timestamp`) USING BTREE,
930 INDEX `user_id`(`user_id`) USING BTREE
931) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
932
933-- ----------------------------
934-- Table structure for marketplace_items
935-- ----------------------------
936DROP TABLE IF EXISTS `marketplace_items`;
937CREATE TABLE `marketplace_items` (
938 `id` int(11) NOT NULL AUTO_INCREMENT,
939 `item_id` int(11) NOT NULL,
940 `user_id` int(11) NOT NULL,
941 `price` int(11) NOT NULL,
942 `timestamp` int(11) NOT NULL,
943 `sold_timestamp` int(11) NOT NULL DEFAULT 0,
944 `state` int(1) NOT NULL DEFAULT 1,
945 PRIMARY KEY (`id`) USING BTREE,
946 INDEX `itemdata`(`item_id`, `user_id`) USING BTREE,
947 INDEX `price`(`price`) USING BTREE,
948 INDEX `time`(`timestamp`, `sold_timestamp`) USING BTREE,
949 INDEX `status`(`state`) USING BTREE
950) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
951
952-- ----------------------------
953-- Table structure for messenger_friendrequests
954-- ----------------------------
955DROP TABLE IF EXISTS `messenger_friendrequests`;
956CREATE TABLE `messenger_friendrequests` (
957 `id` int(11) NOT NULL AUTO_INCREMENT,
958 `user_to_id` int(11) NOT NULL DEFAULT 0,
959 `user_from_id` int(11) NOT NULL DEFAULT 0,
960 PRIMARY KEY (`id`) USING BTREE,
961 UNIQUE INDEX `id`(`id`) USING BTREE,
962 INDEX `users`(`user_to_id`, `user_from_id`) USING BTREE
963) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
964
965-- ----------------------------
966-- Table structure for messenger_friendships
967-- ----------------------------
968DROP TABLE IF EXISTS `messenger_friendships`;
969CREATE TABLE `messenger_friendships` (
970 `id` int(11) NOT NULL AUTO_INCREMENT,
971 `user_one_id` int(11) NOT NULL DEFAULT 0,
972 `user_two_id` int(11) NOT NULL DEFAULT 0,
973 `relation` int(1) NOT NULL DEFAULT 0,
974 `friends_since` int(11) NOT NULL DEFAULT 0,
975 PRIMARY KEY (`id`) USING BTREE,
976 UNIQUE INDEX `id`(`id`) USING BTREE,
977 INDEX `user_one_id`(`user_one_id`) USING BTREE,
978 INDEX `user_two_id`(`user_two_id`) USING BTREE,
979 INDEX `userdata`(`user_one_id`, `user_two_id`) USING BTREE
980) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
981
982-- ----------------------------
983-- Table structure for messenger_offline
984-- ----------------------------
985DROP TABLE IF EXISTS `messenger_offline`;
986CREATE TABLE `messenger_offline` (
987 `id` int(11) NOT NULL AUTO_INCREMENT,
988 `user_id` int(11) NOT NULL DEFAULT 0,
989 `user_from_id` int(11) NOT NULL DEFAULT 0,
990 `message` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
991 `sended_on` int(11) NOT NULL,
992 PRIMARY KEY (`id`) USING BTREE
993) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
994
995-- ----------------------------
996-- Table structure for namechange_log
997-- ----------------------------
998DROP TABLE IF EXISTS `namechange_log`;
999CREATE TABLE `namechange_log` (
1000 `user_id` int(11) NOT NULL,
1001 `old_name` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1002 `new_name` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1003 `timestamp` int(11) NOT NULL
1004) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1005
1006-- ----------------------------
1007-- Table structure for navigator_filter
1008-- ----------------------------
1009DROP TABLE IF EXISTS `navigator_filter`;
1010CREATE TABLE `navigator_filter` (
1011 `key` varchar(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1012 `field` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1013 `compare` enum('equals','equals_ignore_case','contains') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1014 `database_query` varchar(1024) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1015 PRIMARY KEY (`key`) USING BTREE
1016) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1017
1018-- ----------------------------
1019-- Table structure for navigator_flatcats
1020-- ----------------------------
1021DROP TABLE IF EXISTS `navigator_flatcats`;
1022CREATE TABLE `navigator_flatcats` (
1023 `id` int(11) NOT NULL AUTO_INCREMENT,
1024 `min_rank` int(11) NOT NULL DEFAULT 0,
1025 `caption_save` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'caption_save',
1026 `caption` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1027 `can_trade` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1028 `max_user_count` int(11) NOT NULL DEFAULT 100,
1029 `public` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1030 `list_type` int(11) NOT NULL DEFAULT 0 COMMENT 'Display mode in the navigator. 0 for list, 1 for thumbnails.',
1031 `order_num` int(3) NOT NULL DEFAULT 0,
1032 PRIMARY KEY (`id`) USING BTREE
1033) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
1034
1035-- ----------------------------
1036-- Table structure for navigator_publiccats
1037-- ----------------------------
1038DROP TABLE IF EXISTS `navigator_publiccats`;
1039CREATE TABLE `navigator_publiccats` (
1040 `id` int(11) NOT NULL AUTO_INCREMENT,
1041 `name` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Staff Picks',
1042 `image` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1043 `visible` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
1044 `order_num` int(3) NOT NULL DEFAULT 0,
1045 PRIMARY KEY (`id`) USING BTREE
1046) ENGINE = MyISAM AUTO_INCREMENT = 7 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1047
1048-- ----------------------------
1049-- Table structure for navigator_publics
1050-- ----------------------------
1051DROP TABLE IF EXISTS `navigator_publics`;
1052CREATE TABLE `navigator_publics` (
1053 `public_cat_id` int(11) NOT NULL,
1054 `room_id` int(11) NOT NULL,
1055 `visible` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1'
1056) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1057
1058-- ----------------------------
1059-- Table structure for nux_gifts
1060-- ----------------------------
1061DROP TABLE IF EXISTS `nux_gifts`;
1062CREATE TABLE `nux_gifts` (
1063 `id` int(3) NOT NULL AUTO_INCREMENT,
1064 `type` enum('item','room') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'item',
1065 `value` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'If type item then items.item_name. If type room then room id to copy.',
1066 `image` varchar(256) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1067 PRIMARY KEY (`id`) USING BTREE
1068) ENGINE = MyISAM AUTO_INCREMENT = 4 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1069
1070-- ----------------------------
1071-- Table structure for old_guilds_forums
1072-- ----------------------------
1073DROP TABLE IF EXISTS `old_guilds_forums`;
1074CREATE TABLE `old_guilds_forums` (
1075 `id` int(11) NOT NULL AUTO_INCREMENT,
1076 `guild_id` int(11) NOT NULL,
1077 `user_id` int(11) NOT NULL,
1078 `subject` mediumtext CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1079 `message` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1080 `state` enum('OPEN','CLOSED','HIDDEN_BY_ADMIN','HIDDEN_BY_STAFF') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'OPEN',
1081 `admin_id` int(11) NOT NULL DEFAULT 0,
1082 `pinned` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1083 `locked` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1084 `timestamp` int(11) NOT NULL,
1085 PRIMARY KEY (`id`) USING BTREE
1086) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1087
1088-- ----------------------------
1089-- Table structure for old_guilds_forums_comments
1090-- ----------------------------
1091DROP TABLE IF EXISTS `old_guilds_forums_comments`;
1092CREATE TABLE `old_guilds_forums_comments` (
1093 `id` int(11) NOT NULL AUTO_INCREMENT,
1094 `thread_id` int(11) NOT NULL,
1095 `user_id` int(11) NOT NULL,
1096 `timestamp` int(11) NOT NULL,
1097 `message` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1098 `state` enum('OPEN','CLOSED','HIDDEN_BY_ADMIN','HIDDEN_BY_STAFF') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'OPEN',
1099 `admin_id` int(11) NOT NULL DEFAULT 0,
1100 PRIMARY KEY (`id`) USING BTREE
1101) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1102
1103-- ----------------------------
1104-- Table structure for permissions
1105-- ----------------------------
1106DROP TABLE IF EXISTS `permissions`;
1107CREATE TABLE `permissions` (
1108 `id` int(11) NOT NULL AUTO_INCREMENT,
1109 `rank_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1110 `badge` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1111 `level` int(2) NOT NULL DEFAULT 1,
1112 `room_effect` int(11) NOT NULL DEFAULT 0,
1113 `log_commands` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1114 `prefix` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1115 `prefix_color` varchar(7) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1116 `cmd_about` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1117 `cmd_alert` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1118 `cmd_allow_trading` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1119 `cmd_badge` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1120 `cmd_ban` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1121 `cmd_blockalert` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1122 `cmd_bots` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1123 `cmd_bundle` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1124 `cmd_calendar` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1125 `cmd_changename` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1126 `cmd_chatcolor` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1127 `cmd_commands` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1128 `cmd_connect_camera` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1129 `cmd_control` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1130 `cmd_coords` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '2',
1131 `cmd_credits` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1132 `cmd_subscription` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0',
1133 `cmd_danceall` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1134 `cmd_diagonal` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1135 `cmd_disconnect` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1136 `cmd_duckets` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1137 `cmd_ejectall` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '2',
1138 `cmd_empty` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1139 `cmd_empty_bots` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1140 `cmd_empty_pets` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1141 `cmd_enable` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1142 `cmd_event` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1143 `cmd_faceless` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1144 `cmd_fastwalk` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1145 `cmd_filterword` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1146 `cmd_freeze` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1147 `cmd_freeze_bots` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1148 `cmd_gift` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1149 `cmd_give_rank` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1150 `cmd_ha` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1151 `acc_can_stalk` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1152 `cmd_hal` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1153 `cmd_invisible` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1154 `cmd_ip_ban` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1155 `cmd_machine_ban` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1156 `cmd_hand_item` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1157 `cmd_happyhour` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1158 `cmd_hidewired` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '2',
1159 `cmd_kickall` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '2',
1160 `cmd_softkick` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1161 `cmd_massbadge` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1162 `cmd_roombadge` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1163 `cmd_masscredits` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1164 `cmd_massduckets` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1165 `cmd_massgift` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1166 `cmd_masspoints` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1167 `cmd_moonwalk` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1168 `cmd_mimic` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1169 `cmd_multi` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1170 `cmd_mute` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1171 `cmd_pet_info` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '2',
1172 `cmd_pickall` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1173 `cmd_plugins` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1174 `cmd_points` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1175 `cmd_promote_offer` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1176 `cmd_pull` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1177 `cmd_push` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1178 `cmd_redeem` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1179 `cmd_reload_room` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '2',
1180 `cmd_roomalert` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1181 `cmd_roomcredits` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1182 `cmd_roomeffect` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1183 `cmd_roomgift` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1184 `cmd_roomitem` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1185 `cmd_roommute` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1186 `cmd_roompixels` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1187 `cmd_roompoints` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1188 `cmd_say` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1189 `cmd_say_all` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1190 `cmd_setmax` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1191 `cmd_set_poll` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1192 `cmd_setpublic` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1193 `cmd_setspeed` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1194 `cmd_shout` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1195 `cmd_shout_all` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1196 `cmd_shutdown` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1197 `cmd_sitdown` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1198 `cmd_staffalert` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1199 `cmd_staffonline` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1200 `cmd_summon` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1201 `cmd_summonrank` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1202 `cmd_super_ban` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1203 `cmd_stalk` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1204 `cmd_superpull` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1205 `cmd_take_badge` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1206 `cmd_talk` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1207 `cmd_teleport` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1208 `cmd_trash` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1209 `cmd_transform` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1210 `cmd_unban` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1211 `cmd_unload` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1212 `cmd_unmute` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1213 `cmd_update_achievements` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1214 `cmd_update_bots` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1215 `cmd_update_catalogue` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1216 `cmd_update_config` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1217 `cmd_update_guildparts` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1218 `cmd_update_hotel_view` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1219 `cmd_update_items` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1220 `cmd_update_navigator` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1221 `cmd_update_permissions` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1222 `cmd_update_pet_data` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1223 `cmd_update_plugins` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1224 `cmd_update_polls` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1225 `cmd_update_texts` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1226 `cmd_update_wordfilter` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1227 `cmd_userinfo` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1228 `cmd_word_quiz` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1229 `cmd_warp` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1230 `acc_anychatcolor` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1231 `acc_anyroomowner` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1232 `acc_empty_others` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1233 `acc_enable_others` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1234 `acc_see_whispers` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1235 `acc_see_tentchat` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1236 `acc_superwired` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1237 `acc_supporttool` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1238 `acc_unkickable` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1239 `acc_guildgate` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1240 `acc_moverotate` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1241 `acc_placefurni` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1242 `acc_unlimited_bots` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT 'Overrides the bot restriction to the inventory and room.',
1243 `acc_unlimited_pets` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT 'Overrides the pet restriction to the inventory and room.',
1244 `acc_hide_ip` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1245 `acc_hide_mail` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1246 `acc_not_mimiced` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1247 `acc_chat_no_flood` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1248 `acc_staff_chat` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1249 `acc_staff_pick` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1250 `acc_enteranyroom` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1251 `acc_fullrooms` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1252 `acc_infinite_credits` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1253 `acc_infinite_pixels` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1254 `acc_infinite_points` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1255 `acc_ambassador` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1256 `acc_debug` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1257 `acc_chat_no_limit` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT 'People with this permission node are always heard and can see all chat in the room regarding of maximum hearing distance in the room settings (In game)',
1258 `acc_chat_no_filter` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1259 `acc_nomute` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1260 `acc_guild_admin` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1261 `acc_catalog_ids` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1262 `acc_modtool_ticket_q` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1263 `acc_modtool_user_logs` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1264 `acc_modtool_user_alert` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1265 `acc_modtool_user_kick` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1266 `acc_modtool_user_ban` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1267 `acc_modtool_room_info` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1268 `acc_modtool_room_logs` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1269 `acc_trade_anywhere` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1270 `acc_update_notifications` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1271 `acc_helper_use_guide_tool` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1272 `acc_helper_give_guide_tours` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1273 `acc_helper_judge_chat_reviews` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1274 `acc_floorplan_editor` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1275 `acc_camera` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1276 `acc_ads_background` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1277 `cmd_wordquiz` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1278 `acc_room_staff_tags` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1279 `acc_infinite_friends` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1280 `acc_mimic_unredeemed` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1281 `cmd_update_youtube_playlists` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1282 `cmd_add_youtube_playlist` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1283 `auto_credits_amount` int(11) NULL DEFAULT 0,
1284 `auto_pixels_amount` int(11) NULL DEFAULT 0,
1285 `auto_gotw_amount` int(11) NULL DEFAULT 0,
1286 `auto_points_amount` int(11) NULL DEFAULT 0,
1287 `acc_mention` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1288 `cmd_setstate` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1289 `cmd_buildheight` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1290 `cmd_setrotation` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1291 `cmd_sellroom` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1292 `cmd_buyroom` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1293 `cmd_pay` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1294 `cmd_kill` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1295 `cmd_hoverboard` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1296 `cmd_kiss` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1297 `cmd_hug` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1298 `cmd_welcome` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1299 `cmd_disable_effects` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '2',
1300 `cmd_brb` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1301 `cmd_nuke` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1302 `cmd_slime` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1303 `cmd_explain` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1304 `cmd_closedice` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1305 `acc_closedice_room` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '2',
1306 `cmd_set` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1307 `cmd_furnidata` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1308 `kiss_cmd` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1309 PRIMARY KEY (`id`) USING BTREE
1310) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
1311
1312-- ----------------------------
1313-- Table structure for pet_actions
1314-- ----------------------------
1315DROP TABLE IF EXISTS `pet_actions`;
1316CREATE TABLE `pet_actions` (
1317 `pet_type` int(2) NOT NULL AUTO_INCREMENT,
1318 `pet_name` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1319 `offspring_type` int(3) NOT NULL DEFAULT -1,
1320 `happy_actions` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
1321 `tired_actions` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
1322 `random_actions` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
1323 `can_swim` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '0',
1324 PRIMARY KEY (`pet_type`) USING BTREE
1325) ENGINE = MyISAM AUTO_INCREMENT = 40 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1326
1327-- ----------------------------
1328-- Table structure for pet_breeding
1329-- ----------------------------
1330DROP TABLE IF EXISTS `pet_breeding`;
1331CREATE TABLE `pet_breeding` (
1332 `pet_id` int(2) NOT NULL,
1333 `offspring_id` int(2) NOT NULL
1334) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1335
1336-- ----------------------------
1337-- Table structure for pet_breeding_races
1338-- ----------------------------
1339DROP TABLE IF EXISTS `pet_breeding_races`;
1340CREATE TABLE `pet_breeding_races` (
1341 `pet_type` int(2) NOT NULL,
1342 `rarity_level` int(2) NOT NULL,
1343 `breed` int(2) NOT NULL
1344) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1345
1346-- ----------------------------
1347-- Table structure for pet_breeds
1348-- ----------------------------
1349DROP TABLE IF EXISTS `pet_breeds`;
1350CREATE TABLE `pet_breeds` (
1351 `race` int(11) NOT NULL,
1352 `color_one` int(11) NOT NULL,
1353 `color_two` int(11) NOT NULL,
1354 `has_color_one` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1355 `has_color_two` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1356 UNIQUE INDEX `idx_name`(`race`, `color_one`, `color_two`, `has_color_one`, `has_color_two`) USING BTREE
1357) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1358
1359-- ----------------------------
1360-- Table structure for pet_commands
1361-- ----------------------------
1362DROP TABLE IF EXISTS `pet_commands`;
1363CREATE TABLE `pet_commands` (
1364 `pet_id` int(11) NOT NULL,
1365 `command_id` int(11) NOT NULL
1366) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1367
1368-- ----------------------------
1369-- Table structure for pet_commands_data
1370-- ----------------------------
1371DROP TABLE IF EXISTS `pet_commands_data`;
1372CREATE TABLE `pet_commands_data` (
1373 `command_id` int(3) NOT NULL,
1374 `text` varchar(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1375 `required_level` int(2) NOT NULL,
1376 `reward_xp` int(3) NOT NULL DEFAULT 5,
1377 `cost_happyness` int(3) NOT NULL DEFAULT 0,
1378 `cost_energy` int(3) NOT NULL DEFAULT 0,
1379 PRIMARY KEY (`command_id`) USING BTREE
1380) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1381
1382-- ----------------------------
1383-- Table structure for pet_drinks
1384-- ----------------------------
1385DROP TABLE IF EXISTS `pet_drinks`;
1386CREATE TABLE `pet_drinks` (
1387 `pet_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Leave 0 to have it affect all pet types.',
1388 `item_id` int(11) NOT NULL
1389) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1390
1391-- ----------------------------
1392-- Table structure for pet_foods
1393-- ----------------------------
1394DROP TABLE IF EXISTS `pet_foods`;
1395CREATE TABLE `pet_foods` (
1396 `pet_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Leave 0 to have it affect all pet types.',
1397 `item_id` int(11) NOT NULL
1398) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1399
1400-- ----------------------------
1401-- Table structure for pet_items
1402-- ----------------------------
1403DROP TABLE IF EXISTS `pet_items`;
1404CREATE TABLE `pet_items` (
1405 `pet_id` int(11) NOT NULL COMMENT 'Leave 0 to have it affect all pet types.',
1406 `item_id` int(11) NOT NULL COMMENT 'Item id of a item having one of the following interactions: nest, pet_food, pet_drink'
1407) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1408
1409-- ----------------------------
1410-- Table structure for pet_vocals
1411-- ----------------------------
1412DROP TABLE IF EXISTS `pet_vocals`;
1413CREATE TABLE `pet_vocals` (
1414 `pet_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Leave 0 to have it apply to all pet types.',
1415 `type` enum('DISOBEY','DRINKING','EATING','GENERIC_HAPPY','GENERIC_NEUTRAL','GENERIC_SAD','GREET_OWNER','HUNGRY','LEVEL_UP','MUTED','PLAYFUL','SLEEPING','THIRSTY','TIRED','UNKNOWN_COMMAND') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'GENERIC_HAPPY',
1416 `message` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
1417) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1418
1419-- ----------------------------
1420-- Table structure for polls
1421-- ----------------------------
1422DROP TABLE IF EXISTS `polls`;
1423CREATE TABLE `polls` (
1424 `id` int(11) NOT NULL AUTO_INCREMENT,
1425 `title` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Hey! We\'d appreciate it if you could take some time to answer these questions. It will help improve our hotel.',
1426 `thanks_message` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1427 `reward_badge` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
1428 PRIMARY KEY (`id`) USING BTREE
1429) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1430
1431-- ----------------------------
1432-- Table structure for polls_answers
1433-- ----------------------------
1434DROP TABLE IF EXISTS `polls_answers`;
1435CREATE TABLE `polls_answers` (
1436 `poll_id` int(11) NOT NULL,
1437 `user_id` int(11) NOT NULL,
1438 `question_id` int(11) NOT NULL,
1439 `answer` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1440 UNIQUE INDEX `unique_index`(`poll_id`, `user_id`, `question_id`) USING BTREE
1441) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1442
1443-- ----------------------------
1444-- Table structure for polls_questions
1445-- ----------------------------
1446DROP TABLE IF EXISTS `polls_questions`;
1447CREATE TABLE `polls_questions` (
1448 `id` int(11) NOT NULL AUTO_INCREMENT,
1449 `parent_id` int(11) NOT NULL DEFAULT 0,
1450 `poll_id` int(11) NOT NULL,
1451 `order` int(11) NOT NULL,
1452 `question` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1453 `type` int(11) NOT NULL DEFAULT 2,
1454 `min_selections` int(11) NOT NULL DEFAULT 1,
1455 `options` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1456 PRIMARY KEY (`id`) USING BTREE
1457) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1458
1459-- ----------------------------
1460-- Table structure for recycler_prizes
1461-- ----------------------------
1462DROP TABLE IF EXISTS `recycler_prizes`;
1463CREATE TABLE `recycler_prizes` (
1464 `rarity` int(11) NOT NULL,
1465 `item_id` int(11) NOT NULL
1466) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1467
1468-- ----------------------------
1469-- Table structure for room_bans
1470-- ----------------------------
1471DROP TABLE IF EXISTS `room_bans`;
1472CREATE TABLE `room_bans` (
1473 `room_id` int(11) NOT NULL,
1474 `user_id` int(11) NOT NULL,
1475 `ends` int(11) NOT NULL
1476) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1477
1478-- ----------------------------
1479-- Table structure for room_enter_log
1480-- ----------------------------
1481DROP TABLE IF EXISTS `room_enter_log`;
1482CREATE TABLE `room_enter_log` (
1483 `room_id` int(11) NOT NULL,
1484 `user_id` int(11) NOT NULL,
1485 `timestamp` int(11) NOT NULL,
1486 `exit_timestamp` int(11) NOT NULL DEFAULT 0,
1487 INDEX `room_enter_log_room_id`(`room_id`) USING BTREE,
1488 INDEX `room_enter_log_user_entry`(`user_id`, `timestamp`) USING BTREE,
1489 INDEX `room_id`(`room_id`) USING BTREE,
1490 INDEX `exit_timestamp`(`exit_timestamp`) USING BTREE,
1491 INDEX `timestamps`(`timestamp`, `exit_timestamp`) USING BTREE,
1492 INDEX `user_id`(`user_id`) USING BTREE
1493) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1494
1495-- ----------------------------
1496-- Table structure for room_game_scores
1497-- ----------------------------
1498DROP TABLE IF EXISTS `room_game_scores`;
1499CREATE TABLE `room_game_scores` (
1500 `room_id` int(32) NOT NULL,
1501 `game_start_timestamp` int(11) NOT NULL,
1502 `game_name` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
1503 `user_id` int(11) NOT NULL,
1504 `team_id` int(11) NOT NULL,
1505 `score` int(11) NOT NULL,
1506 `team_score` int(11) NOT NULL
1507) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1508
1509-- ----------------------------
1510-- Table structure for room_models
1511-- ----------------------------
1512DROP TABLE IF EXISTS `room_models`;
1513CREATE TABLE `room_models` (
1514 `name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1515 `door_x` int(11) NOT NULL,
1516 `door_y` int(11) NOT NULL,
1517 `door_dir` int(4) NOT NULL DEFAULT 2,
1518 `heightmap` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1519 `public_items` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1520 `club_only` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1521 PRIMARY KEY (`name`) USING BTREE
1522) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1523
1524-- ----------------------------
1525-- Table structure for room_models_custom
1526-- ----------------------------
1527DROP TABLE IF EXISTS `room_models_custom`;
1528CREATE TABLE `room_models_custom` (
1529 `id` int(11) NOT NULL,
1530 `name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1531 `door_x` int(11) NOT NULL,
1532 `door_y` int(11) NOT NULL,
1533 `door_dir` int(11) NOT NULL,
1534 `heightmap` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1535 UNIQUE INDEX `id`(`id`) USING BTREE
1536) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1537
1538-- ----------------------------
1539-- Table structure for room_mutes
1540-- ----------------------------
1541DROP TABLE IF EXISTS `room_mutes`;
1542CREATE TABLE `room_mutes` (
1543 `room_id` int(11) NOT NULL,
1544 `user_id` int(11) NOT NULL,
1545 `ends` int(11) NOT NULL
1546) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1547
1548-- ----------------------------
1549-- Table structure for room_promotions
1550-- ----------------------------
1551DROP TABLE IF EXISTS `room_promotions`;
1552CREATE TABLE `room_promotions` (
1553 `room_id` int(11) NOT NULL,
1554 `title` varchar(127) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1555 `description` varchar(1024) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1556 `end_timestamp` int(11) NOT NULL DEFAULT 0,
1557 `start_timestamp` int(11) NOT NULL DEFAULT -1,
1558 `category` int(11) NOT NULL DEFAULT 0,
1559 UNIQUE INDEX `room_id`(`room_id`) USING BTREE
1560) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1561
1562-- ----------------------------
1563-- Table structure for room_rights
1564-- ----------------------------
1565DROP TABLE IF EXISTS `room_rights`;
1566CREATE TABLE `room_rights` (
1567 `room_id` int(11) NOT NULL,
1568 `user_id` int(11) NOT NULL
1569) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1570
1571-- ----------------------------
1572-- Table structure for room_trade_log
1573-- ----------------------------
1574DROP TABLE IF EXISTS `room_trade_log`;
1575CREATE TABLE `room_trade_log` (
1576 `id` int(11) NOT NULL AUTO_INCREMENT,
1577 `user_one_id` int(11) NOT NULL,
1578 `user_two_id` int(11) NOT NULL,
1579 `user_one_ip` varchar(45) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1580 `user_two_ip` varchar(45) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1581 `timestamp` int(11) NOT NULL,
1582 `user_one_item_count` int(11) NOT NULL,
1583 `user_two_item_count` int(11) NOT NULL,
1584 PRIMARY KEY (`id`) USING BTREE,
1585 INDEX `user_one_id`(`user_one_id`) USING BTREE,
1586 INDEX `user_two_id`(`user_two_id`) USING BTREE
1587) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1588
1589-- ----------------------------
1590-- Table structure for room_trade_log_items
1591-- ----------------------------
1592DROP TABLE IF EXISTS `room_trade_log_items`;
1593CREATE TABLE `room_trade_log_items` (
1594 `id` int(11) NOT NULL,
1595 `item_id` int(11) NOT NULL,
1596 `user_id` int(11) NOT NULL,
1597 UNIQUE INDEX `id`(`id`, `item_id`, `user_id`) USING BTREE,
1598 INDEX `id_2`(`id`) USING BTREE,
1599 INDEX `user_id`(`user_id`) USING BTREE,
1600 INDEX `id_3`(`id`, `user_id`) USING BTREE
1601) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1602
1603-- ----------------------------
1604-- Table structure for room_trax
1605-- ----------------------------
1606DROP TABLE IF EXISTS `room_trax`;
1607CREATE TABLE `room_trax` (
1608 `room_id` int(11) NOT NULL,
1609 `trax_item_id` int(11) NOT NULL
1610) ENGINE = InnoDB CHARACTER SET = armscii8 COLLATE = armscii8_general_ci ROW_FORMAT = COMPACT;
1611
1612-- ----------------------------
1613-- Table structure for room_trax_playlist
1614-- ----------------------------
1615DROP TABLE IF EXISTS `room_trax_playlist`;
1616CREATE TABLE `room_trax_playlist` (
1617 `room_id` int(11) NOT NULL,
1618 `item_id` int(11) NOT NULL,
1619 INDEX `room_id`(`room_id`) USING BTREE
1620) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1621
1622-- ----------------------------
1623-- Table structure for room_votes
1624-- ----------------------------
1625DROP TABLE IF EXISTS `room_votes`;
1626CREATE TABLE `room_votes` (
1627 `user_id` int(11) NOT NULL,
1628 `room_id` int(11) NOT NULL
1629) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1630
1631-- ----------------------------
1632-- Table structure for room_wordfilter
1633-- ----------------------------
1634DROP TABLE IF EXISTS `room_wordfilter`;
1635CREATE TABLE `room_wordfilter` (
1636 `room_id` int(11) NOT NULL,
1637 `word` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1638 UNIQUE INDEX `unique_index`(`room_id`, `word`) USING BTREE
1639) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1640
1641-- ----------------------------
1642-- Table structure for rooms
1643-- ----------------------------
1644DROP TABLE IF EXISTS `rooms`;
1645CREATE TABLE `rooms` (
1646 `id` int(11) NOT NULL AUTO_INCREMENT,
1647 `owner_id` int(11) NOT NULL DEFAULT 0,
1648 `owner_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1649 `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
1650 `description` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1651 `model` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'model_a',
1652 `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1653 `state` enum('open','locked','password','invisible') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'open',
1654 `users` int(11) NOT NULL DEFAULT 0,
1655 `users_max` int(11) NOT NULL DEFAULT 25,
1656 `guild_id` int(11) NOT NULL DEFAULT 0,
1657 `category` int(11) NOT NULL DEFAULT 1,
1658 `score` int(11) NOT NULL DEFAULT 0,
1659 `paper_floor` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0.0',
1660 `paper_wall` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0.0',
1661 `paper_landscape` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0.0',
1662 `thickness_wall` int(1) NOT NULL DEFAULT 0,
1663 `wall_height` int(2) NOT NULL DEFAULT -1,
1664 `thickness_floor` int(1) NOT NULL DEFAULT 0,
1665 `moodlight_data` varchar(254) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '2,1,1,#000000,255;2,3,1,#000000,255;2,3,1,#000000,255;',
1666 `tags` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1667 `is_public` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1668 `is_staff_picked` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1669 `allow_other_pets` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1670 `allow_other_pets_eat` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1671 `allow_walkthrough` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1672 `allow_hidewall` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1673 `chat_mode` int(11) NOT NULL DEFAULT 0,
1674 `chat_weight` int(11) NOT NULL DEFAULT 1,
1675 `chat_speed` int(11) NOT NULL DEFAULT 1,
1676 `chat_hearing_distance` int(11) NOT NULL DEFAULT 50,
1677 `chat_protection` int(11) NOT NULL DEFAULT 2,
1678 `override_model` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1679 `who_can_mute` int(11) NOT NULL DEFAULT 0,
1680 `who_can_kick` int(11) NOT NULL DEFAULT 0,
1681 `who_can_ban` int(11) NOT NULL DEFAULT 0,
1682 `poll_id` int(11) NOT NULL DEFAULT 0,
1683 `roller_speed` int(3) NOT NULL DEFAULT 4,
1684 `promoted` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1685 `trade_mode` int(11) NOT NULL DEFAULT 2,
1686 `move_diagonally` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1687 `jukebox_active` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1688 `hidewired` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1689 `is_forsale` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1690 PRIMARY KEY (`id`) USING BTREE,
1691 INDEX `name`(`name`) USING BTREE,
1692 INDEX `owner_name`(`owner_name`) USING BTREE,
1693 INDEX `owner_id`(`owner_id`) USING BTREE,
1694 INDEX `guild_id`(`guild_id`) USING BTREE,
1695 INDEX `category`(`category`) USING BTREE,
1696 INDEX `public_status`(`is_public`, `is_staff_picked`) USING BTREE,
1697 INDEX `togehter_data`(`name`, `owner_name`, `guild_id`) USING BTREE,
1698 INDEX `tags`(`tags`) USING BTREE,
1699 INDEX `state`(`state`) USING BTREE,
1700 INDEX `description`(`description`) USING BTREE,
1701 INDEX `users`(`users`) USING BTREE
1702) ENGINE = InnoDB AUTO_INCREMENT = 57 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
1703
1704-- ----------------------------
1705-- Table structure for sanction_levels
1706-- ----------------------------
1707DROP TABLE IF EXISTS `sanction_levels`;
1708CREATE TABLE `sanction_levels` (
1709 `level` int(1) NOT NULL,
1710 `type` enum('ALERT','BAN','MUTE') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1711 `hour_length` int(12) NOT NULL,
1712 `probation_days` int(12) NOT NULL,
1713 PRIMARY KEY (`level`) USING BTREE
1714) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1715
1716-- ----------------------------
1717-- Table structure for sanctions
1718-- ----------------------------
1719DROP TABLE IF EXISTS `sanctions`;
1720CREATE TABLE `sanctions` (
1721 `id` int(11) NOT NULL AUTO_INCREMENT,
1722 `habbo_id` int(11) NOT NULL DEFAULT 0,
1723 `sanction_level` int(11) NOT NULL DEFAULT 0,
1724 `probation_timestamp` int(32) NOT NULL DEFAULT 0,
1725 `reason` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
1726 `trade_locked_until` int(32) NOT NULL DEFAULT 0,
1727 `is_muted` tinyint(1) NOT NULL DEFAULT 0,
1728 `mute_duration` int(11) NOT NULL DEFAULT 0,
1729 PRIMARY KEY (`id`) USING BTREE
1730) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1731
1732-- ----------------------------
1733-- Table structure for soundtracks
1734-- ----------------------------
1735DROP TABLE IF EXISTS `soundtracks`;
1736CREATE TABLE `soundtracks` (
1737 `id` int(6) NOT NULL AUTO_INCREMENT,
1738 `code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1739 `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1740 `author` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1741 `track` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1742 `length` int(4) NOT NULL DEFAULT 0,
1743 PRIMARY KEY (`id`) USING BTREE
1744) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
1745
1746-- ----------------------------
1747-- Table structure for special_enables
1748-- ----------------------------
1749DROP TABLE IF EXISTS `special_enables`;
1750CREATE TABLE `special_enables` (
1751 `effect_id` int(5) NOT NULL,
1752 `min_rank` int(2) NOT NULL,
1753 UNIQUE INDEX `effect_id`(`effect_id`) USING BTREE
1754) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1755
1756-- ----------------------------
1757-- Table structure for support_cfh_categories
1758-- ----------------------------
1759DROP TABLE IF EXISTS `support_cfh_categories`;
1760CREATE TABLE `support_cfh_categories` (
1761 `id` int(11) NOT NULL AUTO_INCREMENT,
1762 `name_internal` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
1763 `name_external` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
1764 PRIMARY KEY (`id`) USING BTREE
1765) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1766
1767-- ----------------------------
1768-- Table structure for support_cfh_topics
1769-- ----------------------------
1770DROP TABLE IF EXISTS `support_cfh_topics`;
1771CREATE TABLE `support_cfh_topics` (
1772 `id` int(11) NOT NULL AUTO_INCREMENT,
1773 `category_id` int(11) NULL DEFAULT NULL,
1774 `name_internal` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
1775 `name_external` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
1776 `action` enum('mods','auto_ignore','auto_reply') CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT 'mods',
1777 `ignore_target` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1778 `auto_reply` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
1779 `default_sanction` int(3) NOT NULL DEFAULT 0,
1780 PRIMARY KEY (`id`) USING BTREE
1781) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1782
1783-- ----------------------------
1784-- Table structure for support_issue_categories
1785-- ----------------------------
1786DROP TABLE IF EXISTS `support_issue_categories`;
1787CREATE TABLE `support_issue_categories` (
1788 `id` int(11) NOT NULL AUTO_INCREMENT,
1789 `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'PII',
1790 PRIMARY KEY (`id`) USING BTREE
1791) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1792
1793-- ----------------------------
1794-- Table structure for support_issue_presets
1795-- ----------------------------
1796DROP TABLE IF EXISTS `support_issue_presets`;
1797CREATE TABLE `support_issue_presets` (
1798 `id` int(11) NOT NULL AUTO_INCREMENT,
1799 `category` int(11) NOT NULL DEFAULT 1,
1800 `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1801 `message` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1802 `reminder` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1803 `ban_for` int(11) NOT NULL DEFAULT 0 COMMENT '100000 = perm ban',
1804 `mute_for` int(11) NOT NULL DEFAULT 0,
1805 PRIMARY KEY (`id`) USING BTREE
1806) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
1807
1808-- ----------------------------
1809-- Table structure for support_presets
1810-- ----------------------------
1811DROP TABLE IF EXISTS `support_presets`;
1812CREATE TABLE `support_presets` (
1813 `id` int(11) NOT NULL AUTO_INCREMENT,
1814 `type` enum('user','room') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'user',
1815 `preset` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1816 PRIMARY KEY (`id`) USING BTREE
1817) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
1818
1819-- ----------------------------
1820-- Table structure for support_tickets
1821-- ----------------------------
1822DROP TABLE IF EXISTS `support_tickets`;
1823CREATE TABLE `support_tickets` (
1824 `id` int(11) NOT NULL AUTO_INCREMENT,
1825 `state` int(11) NOT NULL DEFAULT 0,
1826 `type` int(2) NOT NULL DEFAULT 1,
1827 `timestamp` int(11) NOT NULL DEFAULT 0,
1828 `score` int(11) NOT NULL DEFAULT 0,
1829 `sender_id` int(11) NOT NULL DEFAULT 0,
1830 `reported_id` int(11) NOT NULL DEFAULT 0,
1831 `room_id` int(11) NOT NULL DEFAULT 0,
1832 `mod_id` int(11) NOT NULL DEFAULT 0,
1833 `issue` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1834 `category` int(3) NOT NULL DEFAULT 0,
1835 `group_id` int(11) NOT NULL,
1836 `thread_id` int(11) NOT NULL,
1837 `comment_id` int(11) NOT NULL,
1838 `photo_item_id` int(11) NOT NULL DEFAULT -1,
1839 PRIMARY KEY (`id`) USING BTREE,
1840 UNIQUE INDEX `id`(`id`) USING BTREE,
1841 INDEX `state`(`state`) USING BTREE,
1842 INDEX `type`(`type`) USING BTREE,
1843 INDEX `timestamp`(`timestamp`) USING BTREE,
1844 INDEX `user_data`(`sender_id`, `reported_id`) USING BTREE,
1845 INDEX `room_id`(`room_id`) USING BTREE,
1846 INDEX `issue`(`issue`) USING BTREE
1847) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
1848
1849-- ----------------------------
1850-- Table structure for trax_playlist
1851-- ----------------------------
1852DROP TABLE IF EXISTS `trax_playlist`;
1853CREATE TABLE `trax_playlist` (
1854 `trax_item_id` int(11) NOT NULL,
1855 `item_id` int(11) NOT NULL
1856) ENGINE = InnoDB CHARACTER SET = armscii8 COLLATE = armscii8_general_ci ROW_FORMAT = COMPACT;
1857
1858-- ----------------------------
1859-- Table structure for user_window_settings
1860-- ----------------------------
1861DROP TABLE IF EXISTS `user_window_settings`;
1862CREATE TABLE `user_window_settings` (
1863 `user_id` int(11) NOT NULL,
1864 `x` int(16) NOT NULL DEFAULT 100,
1865 `y` int(16) NOT NULL DEFAULT 100,
1866 `width` int(16) NOT NULL DEFAULT 435,
1867 `height` int(16) NOT NULL DEFAULT 535,
1868 `open_searches` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0'
1869) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1870
1871-- ----------------------------
1872-- Table structure for users
1873-- ----------------------------
1874DROP TABLE IF EXISTS `users`;
1875CREATE TABLE `users` (
1876 `id` int(11) NOT NULL AUTO_INCREMENT,
1877 `username` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1878 `real_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'KREWS DEV',
1879 `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1880 `mail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
1881 `mail_verified` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1882 `account_created` int(11) NOT NULL,
1883 `account_day_of_birth` int(11) NOT NULL DEFAULT 0,
1884 `last_login` int(11) NOT NULL DEFAULT 0,
1885 `last_online` int(11) NOT NULL DEFAULT 0,
1886 `motto` varchar(127) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1887 `look` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'hr-115-42.hd-195-19.ch-3030-82.lg-275-1408.fa-1201.ca-1804-64',
1888 `gender` enum('M','F') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'M',
1889 `rank` int(2) NOT NULL DEFAULT 1,
1890 `credits` int(11) NOT NULL DEFAULT 2500,
1891 `pixels` int(11) NOT NULL DEFAULT 500,
1892 `points` int(11) NOT NULL DEFAULT 10,
1893 `online` enum('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1894 `auth_ticket` varchar(256) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
1895 `ip_register` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1896 `ip_current` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'Have your CMS update this IP. If you do not do this IP banning won\'t work!',
1897 `machine_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1898 `home_room` int(32) NOT NULL DEFAULT 0,
1899 `secret_key` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
1900 `pincode` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
1901 `extra_rank` int(2) NULL DEFAULT NULL,
1902 `profile_background` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '06.gif',
1903 `hotelview` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'view_us_wide.png',
1904 PRIMARY KEY (`id`) USING BTREE,
1905 UNIQUE INDEX `username`(`username`) USING BTREE,
1906 UNIQUE INDEX `id`(`id`) USING BTREE,
1907 UNIQUE INDEX `id_2`(`id`) USING BTREE,
1908 UNIQUE INDEX `id_3`(`id`) USING BTREE,
1909 INDEX `account_created`(`account_created`) USING BTREE,
1910 INDEX `last_login`(`last_login`) USING BTREE,
1911 INDEX `last_online`(`last_online`) USING BTREE,
1912 INDEX `figure`(`motto`, `look`, `gender`) USING BTREE,
1913 INDEX `auth_ticket`(`auth_ticket`) USING BTREE
1914) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
1915
1916-- ----------------------------
1917-- Table structure for users_achievements
1918-- ----------------------------
1919DROP TABLE IF EXISTS `users_achievements`;
1920CREATE TABLE `users_achievements` (
1921 `user_id` int(32) NOT NULL,
1922 `achievement_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1923 `progress` int(11) NOT NULL DEFAULT 1,
1924 INDEX `user_id`(`user_id`) USING BTREE,
1925 INDEX `achievement_name`(`achievement_name`) USING BTREE,
1926 INDEX `progress`(`progress`) USING BTREE
1927) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
1928
1929-- ----------------------------
1930-- Table structure for users_achievements_queue
1931-- ----------------------------
1932DROP TABLE IF EXISTS `users_achievements_queue`;
1933CREATE TABLE `users_achievements_queue` (
1934 `user_id` int(11) NOT NULL,
1935 `achievement_id` int(11) NOT NULL,
1936 `amount` int(11) NOT NULL,
1937 UNIQUE INDEX `unique_index`(`user_id`, `achievement_id`) USING BTREE,
1938 UNIQUE INDEX `data`(`user_id`, `achievement_id`) USING BTREE
1939) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1940
1941-- ----------------------------
1942-- Table structure for users_badges
1943-- ----------------------------
1944DROP TABLE IF EXISTS `users_badges`;
1945CREATE TABLE `users_badges` (
1946 `id` int(11) NOT NULL AUTO_INCREMENT,
1947 `user_id` int(11) NOT NULL DEFAULT 0,
1948 `slot_id` int(11) NOT NULL DEFAULT 0,
1949 `badge_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1950 PRIMARY KEY (`id`) USING BTREE
1951) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
1952
1953-- ----------------------------
1954-- Table structure for users_clothing
1955-- ----------------------------
1956DROP TABLE IF EXISTS `users_clothing`;
1957CREATE TABLE `users_clothing` (
1958 `user_id` int(11) NOT NULL,
1959 `clothing_id` int(11) NOT NULL,
1960 UNIQUE INDEX `user_id`(`user_id`, `clothing_id`) USING BTREE
1961) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1962
1963-- ----------------------------
1964-- Table structure for users_currency
1965-- ----------------------------
1966DROP TABLE IF EXISTS `users_currency`;
1967CREATE TABLE `users_currency` (
1968 `user_id` int(32) NOT NULL,
1969 `type` int(3) NOT NULL,
1970 `amount` int(64) NOT NULL DEFAULT 0,
1971 PRIMARY KEY (`user_id`, `type`) USING BTREE,
1972 UNIQUE INDEX `userdata`(`user_id`, `type`) USING BTREE,
1973 INDEX `amount`(`amount`) USING BTREE
1974) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1975
1976-- ----------------------------
1977-- Table structure for users_effects
1978-- ----------------------------
1979DROP TABLE IF EXISTS `users_effects`;
1980CREATE TABLE `users_effects` (
1981 `user_id` int(11) NOT NULL,
1982 `effect` int(5) NOT NULL,
1983 `duration` int(11) NOT NULL DEFAULT 86400,
1984 `activation_timestamp` int(11) NOT NULL DEFAULT -1,
1985 `total` int(2) NOT NULL DEFAULT 1,
1986 UNIQUE INDEX `user_id`(`user_id`, `effect`) USING BTREE
1987) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1988
1989-- ----------------------------
1990-- Table structure for users_favorite_rooms
1991-- ----------------------------
1992DROP TABLE IF EXISTS `users_favorite_rooms`;
1993CREATE TABLE `users_favorite_rooms` (
1994 `user_id` int(11) NOT NULL,
1995 `room_id` int(11) NOT NULL,
1996 UNIQUE INDEX `user_id`(`user_id`, `room_id`) USING BTREE
1997) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
1998
1999-- ----------------------------
2000-- Table structure for users_ignored
2001-- ----------------------------
2002DROP TABLE IF EXISTS `users_ignored`;
2003CREATE TABLE `users_ignored` (
2004 `user_id` int(11) NOT NULL,
2005 `target_id` int(11) NOT NULL,
2006 INDEX `user_id`(`user_id`, `target_id`) USING BTREE
2007) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
2008
2009-- ----------------------------
2010-- Table structure for users_navigator_settings
2011-- ----------------------------
2012DROP TABLE IF EXISTS `users_navigator_settings`;
2013CREATE TABLE `users_navigator_settings` (
2014 `user_id` int(11) NOT NULL,
2015 `caption` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
2016 `list_type` enum('list','thumbnails') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'list',
2017 `display` enum('visible','collapsed') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'visible',
2018 UNIQUE INDEX `userid`(`user_id`) USING BTREE,
2019 INDEX `list_type`(`list_type`) USING BTREE,
2020 INDEX `display`(`display`) USING BTREE
2021) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
2022
2023-- ----------------------------
2024-- Table structure for users_pets
2025-- ----------------------------
2026DROP TABLE IF EXISTS `users_pets`;
2027CREATE TABLE `users_pets` (
2028 `id` int(11) NOT NULL AUTO_INCREMENT,
2029 `user_id` int(11) NOT NULL,
2030 `room_id` int(11) NOT NULL,
2031 `name` varchar(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'User Pet',
2032 `race` int(11) NOT NULL,
2033 `type` int(11) NOT NULL,
2034 `color` varchar(6) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
2035 `happyness` int(11) NOT NULL DEFAULT 100,
2036 `experience` int(11) NOT NULL DEFAULT 0,
2037 `energy` int(11) NOT NULL DEFAULT 100,
2038 `hunger` int(3) NOT NULL DEFAULT 0,
2039 `thirst` int(3) NOT NULL DEFAULT 0,
2040 `respect` int(11) NOT NULL DEFAULT 0,
2041 `created` int(11) NOT NULL,
2042 `x` int(11) NOT NULL DEFAULT 0,
2043 `y` int(11) NOT NULL DEFAULT 0,
2044 `z` double NOT NULL DEFAULT 0,
2045 `rot` int(11) NOT NULL DEFAULT 0,
2046 `hair_style` int(3) NOT NULL DEFAULT -1,
2047 `hair_color` int(3) NOT NULL DEFAULT 0,
2048 `saddle` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
2049 `ride` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
2050 `mp_type` int(3) NOT NULL DEFAULT 0,
2051 `mp_color` int(3) NOT NULL DEFAULT 0,
2052 `mp_nose` int(3) NOT NULL DEFAULT 0,
2053 `mp_nose_color` tinyint(2) NOT NULL DEFAULT 0,
2054 `mp_eyes` int(3) NOT NULL DEFAULT 0,
2055 `mp_eyes_color` tinyint(2) NOT NULL DEFAULT 0,
2056 `mp_mouth` int(3) NOT NULL DEFAULT 0,
2057 `mp_mouth_color` tinyint(2) NOT NULL DEFAULT 0,
2058 `mp_death_timestamp` int(11) NOT NULL DEFAULT 0,
2059 `mp_breedable` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
2060 `mp_allow_breed` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
2061 `gnome_data` varchar(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
2062 `mp_is_dead` tinyint(1) NOT NULL DEFAULT 0,
2063 `saddle_item_id` int(11) NULL DEFAULT NULL,
2064 PRIMARY KEY (`id`) USING BTREE
2065) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
2066
2067-- ----------------------------
2068-- Table structure for users_recipes
2069-- ----------------------------
2070DROP TABLE IF EXISTS `users_recipes`;
2071CREATE TABLE `users_recipes` (
2072 `user_id` int(11) NOT NULL,
2073 `recipe` int(11) NOT NULL,
2074 UNIQUE INDEX `user_id`(`user_id`, `recipe`) USING BTREE
2075) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
2076
2077-- ----------------------------
2078-- Table structure for users_saved_searches
2079-- ----------------------------
2080DROP TABLE IF EXISTS `users_saved_searches`;
2081CREATE TABLE `users_saved_searches` (
2082 `id` int(11) NOT NULL AUTO_INCREMENT,
2083 `search_code` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
2084 `filter` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
2085 `user_id` int(11) NOT NULL,
2086 PRIMARY KEY (`id`) USING BTREE
2087) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
2088
2089-- ----------------------------
2090-- Table structure for users_settings
2091-- ----------------------------
2092DROP TABLE IF EXISTS `users_settings`;
2093CREATE TABLE `users_settings` (
2094 `id` int(32) NOT NULL AUTO_INCREMENT,
2095 `user_id` int(32) NOT NULL DEFAULT 0 COMMENT 'WARNING: DONT HAVE YOUR CMS INSERT ANYTHING IN HERE. THE EMULATOR DOES THIS FOR YOU!',
2096 `credits` int(32) NOT NULL DEFAULT 0,
2097 `achievement_score` int(10) NOT NULL DEFAULT 0,
2098 `daily_respect_points` int(2) NOT NULL DEFAULT 3,
2099 `daily_pet_respect_points` int(2) NOT NULL DEFAULT 3,
2100 `respects_given` int(11) NOT NULL DEFAULT 0,
2101 `respects_received` int(11) NOT NULL DEFAULT 0,
2102 `guild_id` int(16) NOT NULL DEFAULT 0,
2103 `can_change_name` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
2104 `can_trade` enum('0','1') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
2105 `is_citizen` enum('0','1') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
2106 `citizen_level` int(2) NOT NULL DEFAULT 0,
2107 `helper_level` int(2) NOT NULL DEFAULT 0,
2108 `tradelock_amount` int(11) NOT NULL DEFAULT 0,
2109 `cfh_send` int(8) NOT NULL DEFAULT 0 COMMENT 'Amount of CFHs been send. Not include abusive.',
2110 `cfh_abusive` int(8) NOT NULL DEFAULT 0 COMMENT 'Amount of abusive CFHs have been send.',
2111 `cfh_warnings` int(8) NOT NULL DEFAULT 0 COMMENT 'Amount of warnings a user has received.',
2112 `cfh_bans` int(8) NOT NULL DEFAULT 0 COMMENT 'Amount of bans a user has received.',
2113 `block_following` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
2114 `block_friendrequests` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
2115 `block_roominvites` enum('0','1') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
2116 `volume_system` int(3) NOT NULL DEFAULT 100,
2117 `volume_furni` int(3) NOT NULL DEFAULT 100,
2118 `volume_trax` int(3) NOT NULL DEFAULT 100,
2119 `old_chat` enum('0','1') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
2120 `block_camera_follow` enum('0','1') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
2121 `chat_color` int(2) NOT NULL DEFAULT 0,
2122 `home_room` int(32) NOT NULL DEFAULT 0,
2123 `online_time` int(32) NOT NULL DEFAULT 0 COMMENT 'Total online time in seconds.',
2124 `tags` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Arcturus Emulator;',
2125 `club_expire_timestamp` int(11) NOT NULL DEFAULT 0,
2126 `login_streak` int(11) NOT NULL DEFAULT 0,
2127 `rent_space_id` int(32) NOT NULL DEFAULT 0,
2128 `rent_space_endtime` int(11) NOT NULL DEFAULT 0,
2129 `hof_points` int(16) NOT NULL DEFAULT 0,
2130 `block_alerts` enum('0','1') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
2131 `talent_track_citizenship_level` int(2) NOT NULL DEFAULT -1,
2132 `talent_track_helpers_level` int(2) NOT NULL DEFAULT -1,
2133 `ignore_bots` enum('0','1') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
2134 `ignore_pets` enum('0','1') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
2135 `nux` enum('0','1') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
2136 `mute_end_timestamp` int(11) NOT NULL DEFAULT 0,
2137 `allow_name_change` enum('0','1') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
2138 `perk_trade` enum('0','1') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' COMMENT 'Defines if a player has obtained the perk TRADE. When hotel.trading.requires.perk is set to 1, this perk is required in order to trade. Perk is obtained from the talen track.',
2139 `forums_post_count` int(11) NULL DEFAULT 0,
2140 `ui_flags` int(11) NOT NULL DEFAULT 1,
2141 `has_gotten_default_saved_searches` tinyint(1) NOT NULL DEFAULT 0,
2142 `hc_gifts_claimed` int(10) NULL DEFAULT 0,
2143 `last_hc_payday` int(10) NULL DEFAULT 0,
2144 `max_rooms` int(10) NULL DEFAULT 50,
2145 `max_friends` int(10) NULL DEFAULT 300,
2146 PRIMARY KEY (`id`) USING BTREE,
2147 UNIQUE INDEX `user_id`(`user_id`) USING BTREE,
2148 INDEX `achievement_score`(`achievement_score`) USING BTREE,
2149 INDEX `guild_id`(`guild_id`) USING BTREE,
2150 INDEX `can_trade`(`can_trade`) USING BTREE,
2151 INDEX `online_time`(`online_time`) USING BTREE
2152) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = DYNAMIC;
2153
2154-- ----------------------------
2155-- Table structure for users_subscriptions
2156-- ----------------------------
2157DROP TABLE IF EXISTS `users_subscriptions`;
2158CREATE TABLE `users_subscriptions` (
2159 `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
2160 `user_id` int(10) UNSIGNED NULL DEFAULT NULL,
2161 `subscription_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
2162 `timestamp_start` int(10) UNSIGNED NULL DEFAULT NULL,
2163 `duration` int(10) UNSIGNED NULL DEFAULT NULL,
2164 `active` tinyint(1) NULL DEFAULT 1,
2165 PRIMARY KEY (`id`) USING BTREE,
2166 INDEX `user_id`(`user_id`) USING BTREE,
2167 INDEX `subscription_type`(`subscription_type`) USING BTREE,
2168 INDEX `timestamp_start`(`timestamp_start`) USING BTREE,
2169 INDEX `active`(`active`) USING BTREE
2170) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
2171
2172-- ----------------------------
2173-- Table structure for users_target_offer_purchases
2174-- ----------------------------
2175DROP TABLE IF EXISTS `users_target_offer_purchases`;
2176CREATE TABLE `users_target_offer_purchases` (
2177 `user_id` int(11) NOT NULL,
2178 `offer_id` int(11) NOT NULL,
2179 `state` int(11) NOT NULL DEFAULT 0,
2180 `amount` int(11) NOT NULL DEFAULT 0,
2181 `last_purchase` int(11) NOT NULL DEFAULT 0,
2182 UNIQUE INDEX `use_id`(`user_id`, `offer_id`) USING BTREE
2183) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
2184
2185-- ----------------------------
2186-- Table structure for users_wardrobe
2187-- ----------------------------
2188DROP TABLE IF EXISTS `users_wardrobe`;
2189CREATE TABLE `users_wardrobe` (
2190 `id` int(11) NOT NULL AUTO_INCREMENT,
2191 `user_id` int(11) NOT NULL DEFAULT 0,
2192 `slot_id` int(11) NOT NULL DEFAULT 0,
2193 `look` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
2194 `gender` enum('M','F') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'F',
2195 PRIMARY KEY (`id`) USING BTREE
2196) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
2197
2198-- ----------------------------
2199-- Table structure for voucher_history
2200-- ----------------------------
2201DROP TABLE IF EXISTS `voucher_history`;
2202CREATE TABLE `voucher_history` (
2203 `id` int(11) NOT NULL AUTO_INCREMENT,
2204 `voucher_id` int(11) NOT NULL,
2205 `user_id` int(11) NOT NULL,
2206 `timestamp` int(11) NOT NULL,
2207 PRIMARY KEY (`id`) USING BTREE
2208) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
2209
2210-- ----------------------------
2211-- Table structure for vouchers
2212-- ----------------------------
2213DROP TABLE IF EXISTS `vouchers`;
2214CREATE TABLE `vouchers` (
2215 `id` int(11) NOT NULL AUTO_INCREMENT,
2216 `code` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
2217 `credits` int(11) NOT NULL DEFAULT 0,
2218 `points` int(11) NOT NULL DEFAULT 0,
2219 `points_type` int(3) NOT NULL DEFAULT 0,
2220 `catalog_item_id` int(11) NOT NULL DEFAULT 0,
2221 `amount` int(11) NOT NULL DEFAULT 1,
2222 `limit` int(11) NOT NULL DEFAULT -1,
2223 PRIMARY KEY (`id`) USING BTREE
2224) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
2225
2226-- ----------------------------
2227-- Table structure for wired_rewards_given
2228-- ----------------------------
2229DROP TABLE IF EXISTS `wired_rewards_given`;
2230CREATE TABLE `wired_rewards_given` (
2231 `wired_item` int(32) NOT NULL,
2232 `user_id` int(32) NOT NULL,
2233 `reward_id` int(11) NOT NULL,
2234 `timestamp` int(11) NOT NULL
2235) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
2236
2237-- ----------------------------
2238-- Table structure for wordfilter
2239-- ----------------------------
2240DROP TABLE IF EXISTS `wordfilter`;
2241CREATE TABLE `wordfilter` (
2242 `key` varchar(256) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'The word to filter.',
2243 `replacement` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'What the word should be replaced with.',
2244 `hide` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0' COMMENT 'Wether the whole message that contains this word should be hidden from being displayed.',
2245 `report` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0' COMMENT 'Wether the message should be reported as auto-report to the moderators.',
2246 `mute` int(3) NOT NULL DEFAULT 0 COMMENT 'Time user gets muted for mentioning this word.',
2247 UNIQUE INDEX `key`(`key`) USING BTREE
2248) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
2249
2250-- ----------------------------
2251-- Table structure for youtube_playlists
2252-- ----------------------------
2253DROP TABLE IF EXISTS `youtube_playlists`;
2254CREATE TABLE `youtube_playlists` (
2255 `item_id` int(11) NOT NULL,
2256 `playlist_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'YouTube playlist ID',
2257 `order` int(11) NOT NULL,
2258 UNIQUE INDEX `item_id`(`item_id`, `playlist_id`, `order`) USING BTREE
2259) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
2260
2261SET FOREIGN_KEY_CHECKS = 1;
2262