SkHdgdcx

1/*
2 Navicat Premium Data Transfer
3
4 Source Server         : db
5 Source Server Type    : MariaDB
6 Source Server Version : 100213
7 Source Host           : localhost:3306
8 Source Schema         : comet2019
9
10 Target Server Type    : MariaDB
11 Target Server Version : 100213
12 File Encoding         : 65001
13
14 Date: 18/11/2019 09:53: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) UNSIGNED NOT NULL AUTO_INCREMENT,
26  `group_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') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'identity',
28  `level` int(11) NOT NULL DEFAULT 1,
29  `reward_activity_points` int(11) NOT NULL DEFAULT 100,
30  `reward_achievement_points` int(11) DEFAULT 10,
31  `progress_requirement` int(11) NOT NULL DEFAULT 1,
32  `enabled` enum('1','0') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
33  PRIMARY KEY (`id`) USING BTREE
34) ENGINE = InnoDB AUTO_INCREMENT = 325 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
35
36-- ----------------------------
37-- Table structure for badge_shop
38-- ----------------------------
39DROP TABLE IF EXISTS `badge_shop`;
40CREATE TABLE `badge_shop`  (
41  `id` int(11) NOT NULL AUTO_INCREMENT,
42  `badge_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
43  `title` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
44  `description` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
45  `cost` int(11) DEFAULT NULL,
46  PRIMARY KEY (`id`) USING BTREE
47) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
48
49-- ----------------------------
50-- Table structure for bans
51-- ----------------------------
52DROP TABLE IF EXISTS `bans`;
53CREATE TABLE `bans`  (
54  `id` int(10) NOT NULL AUTO_INCREMENT,
55  `type` enum('ip','machine','user') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
56  `expire` int(20) DEFAULT 0 COMMENT '0 = perminent',
57  `data` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
58  `reason` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
59  `added_by` int(11) DEFAULT 0,
60  `ip` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
61  `bantype` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
62  `value` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
63  PRIMARY KEY (`id`) USING BTREE
64) ENGINE = InnoDB AUTO_INCREMENT = 80 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
65
66-- ----------------------------
67-- Table structure for bots
68-- ----------------------------
69DROP TABLE IF EXISTS `bots`;
70CREATE TABLE `bots`  (
71  `id` int(11) NOT NULL AUTO_INCREMENT,
72  `owner_id` int(11) DEFAULT 0,
73  `owner` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
74  `room_id` int(11) DEFAULT 0,
75  `name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'Placeholder',
76  `figure` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
77  `gender` enum('m','f') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'm',
78  `motto` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
79  `x` int(11) DEFAULT 0,
80  `y` int(11) DEFAULT 0,
81  `z` double DEFAULT 0,
82  `messages` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
83  `automatic_chat` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
84  `chat_delay` int(11) DEFAULT 7,
85  `mode` enum('default','relaxed') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'default',
86  `type` enum('generic','waiter','spy','test') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'generic',
87  `data` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
88  `Column 18` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
89  PRIMARY KEY (`id`) USING BTREE
90) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
91
92-- ----------------------------
93-- Table structure for catalog_clothing
94-- ----------------------------
95DROP TABLE IF EXISTS `catalog_clothing`;
96CREATE TABLE `catalog_clothing`  (
97  `id` int(11) NOT NULL AUTO_INCREMENT,
98  `item_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
99  `clothing_items` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
100  PRIMARY KEY (`id`) USING BTREE,
101  UNIQUE INDEX `item_name`(`item_name`) USING BTREE
102) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
103
104-- ----------------------------
105-- Table structure for catalog_featured_pages
106-- ----------------------------
107DROP TABLE IF EXISTS `catalog_featured_pages`;
108CREATE TABLE `catalog_featured_pages`  (
109  `id` int(11) NOT NULL AUTO_INCREMENT,
110  `caption` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
111  `image` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
112  `page_link` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
113  `page_id` int(11) NOT NULL DEFAULT -1,
114  PRIMARY KEY (`id`) USING BTREE
115) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
116
117-- ----------------------------
118-- Table structure for catalog_gift_wrapping
119-- ----------------------------
120DROP TABLE IF EXISTS `catalog_gift_wrapping`;
121CREATE TABLE `catalog_gift_wrapping`  (
122  `type` enum('new','old') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'new',
123  `sprite_id` int(11) DEFAULT 0
124) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
125
126-- ----------------------------
127-- Table structure for catalog_items
128-- ----------------------------
129DROP TABLE IF EXISTS `catalog_items`;
130CREATE TABLE `catalog_items`  (
131  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
132  `page_id` int(11) NOT NULL,
133  `item_ids` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
134  `catalog_name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
135  `cost_credits` int(11) NOT NULL DEFAULT 0,
136  `cost_pixels` int(11) NOT NULL DEFAULT 0,
137  `cost_diamonds` int(11) NOT NULL DEFAULT 0,
138  `cost_seasonal` int(11) NOT NULL DEFAULT 0,
139  `amount` int(11) NOT NULL DEFAULT 1,
140  `vip` enum('0','1','2') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
141  `achievement` int(4) UNSIGNED NOT NULL DEFAULT 0,
142  `song_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
143  `limited_sells` int(11) NOT NULL DEFAULT 0,
144  `limited_stack` int(11) NOT NULL DEFAULT 0,
145  `offer_active` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
146  `extradata` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
147  `badge_id` varchar(5) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
148  `flat_id` int(11) NOT NULL DEFAULT -1,
149  `cost_snow` int(11) NOT NULL DEFAULT 0,
150  `predesigned_id` int(11) NOT NULL DEFAULT 0,
151  PRIMARY KEY (`id`) USING BTREE,
152  INDEX `item_id`(`item_ids`) USING BTREE
153) ENGINE = InnoDB AUTO_INCREMENT = 99910896 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
154
155-- ----------------------------
156-- Table structure for catalog_pages
157-- ----------------------------
158DROP TABLE IF EXISTS `catalog_pages`;
159CREATE TABLE `catalog_pages`  (
160  `id` int(11) NOT NULL AUTO_INCREMENT,
161  `parent_id` int(11) NOT NULL DEFAULT -1,
162  `type` enum('RECENT_PURCHASES','DEFAULT','BUNDLE') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'DEFAULT',
163  `caption` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
164  `icon_image` int(11) NOT NULL DEFAULT 1,
165  `visible` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
166  `enabled` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
167  `min_rank` int(11) UNSIGNED NOT NULL DEFAULT 1,
168  `club_only` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
169  `order_num` int(11) NOT NULL,
170  `page_layout` varchar(35) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'default_3x3',
171  `page_images` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
172  `page_texts` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
173  `min_sub` int(11) NOT NULL DEFAULT 0,
174  `vip_only` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
175  `link` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
176  `extra_data` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
177  PRIMARY KEY (`id`) USING BTREE,
178  UNIQUE INDEX `id`(`id`) USING BTREE,
179  INDEX `order_num`(`order_num`) USING BTREE
180) ENGINE = InnoDB AUTO_INCREMENT = 423423573 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
181
182-- ----------------------------
183-- Table structure for cms_alerts
184-- ----------------------------
185DROP TABLE IF EXISTS `cms_alerts`;
186CREATE TABLE `cms_alerts`  (
187  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
188  `alert` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
189  PRIMARY KEY (`id`) USING BTREE
190) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
191
192-- ----------------------------
193-- Table structure for cms_news
194-- ----------------------------
195DROP TABLE IF EXISTS `cms_news`;
196CREATE TABLE `cms_news`  (
197  `n_id` smallint(32) UNSIGNED NOT NULL AUTO_INCREMENT,
198  `n_title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
199  `n_short` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
200  `n_text` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
201  `n_u_id` int(11) UNSIGNED NOT NULL,
202  `n_time` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
203  `n_topstory` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'default-top-story.png',
204  `n_comments` smallint(8) UNSIGNED NOT NULL DEFAULT 0,
205  `n_locked` tinyint(1) NOT NULL DEFAULT 0,
206  PRIMARY KEY (`n_id`) USING BTREE
207) ENGINE = InnoDB AUTO_INCREMENT = 462 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
208
209-- ----------------------------
210-- Table structure for cms_news_comments
211-- ----------------------------
212DROP TABLE IF EXISTS `cms_news_comments`;
213CREATE TABLE `cms_news_comments`  (
214  `nc_id` int(11) NOT NULL AUTO_INCREMENT,
215  `n_id` smallint(32) UNSIGNED NOT NULL,
216  `nc_u_id` int(11) UNSIGNED NOT NULL,
217  `nc_time` int(10) UNSIGNED NOT NULL,
218  `nc_text` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
219  `nc_deleted` tinyint(1) NOT NULL DEFAULT 0,
220  PRIMARY KEY (`nc_id`) USING BTREE,
221  INDEX `n_id`(`n_id`, `nc_deleted`) USING BTREE
222) ENGINE = InnoDB AUTO_INCREMENT = 4978 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
223
224-- ----------------------------
225-- Table structure for cms_news_like
226-- ----------------------------
227DROP TABLE IF EXISTS `cms_news_like`;
228CREATE TABLE `cms_news_like`  (
229  `id` int(11) NOT NULL AUTO_INCREMENT,
230  `userid` int(255) DEFAULT NULL,
231  `newsid` int(255) DEFAULT NULL,
232  PRIMARY KEY (`id`) USING BTREE
233) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
234
235-- ----------------------------
236-- Table structure for cms_news_message
237-- ----------------------------
238DROP TABLE IF EXISTS `cms_news_message`;
239CREATE TABLE `cms_news_message`  (
240  `id` int(11) NOT NULL AUTO_INCREMENT,
241  `date` int(11) NOT NULL DEFAULT 0,
242  `buggid` int(11) DEFAULT NULL,
243  `userid` int(11) DEFAULT NULL,
244  `message` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
245  `hash` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
246  PRIMARY KEY (`id`) USING BTREE
247) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
248
249-- ----------------------------
250-- Table structure for cms_rarevalues
251-- ----------------------------
252DROP TABLE IF EXISTS `cms_rarevalues`;
253CREATE TABLE `cms_rarevalues`  (
254  `id` int(11) NOT NULL AUTO_INCREMENT,
255  `item_name` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
256  `item_image` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
257  `item_cost` int(11) DEFAULT 0,
258  `item_status` enum('up','down','same') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
259  PRIMARY KEY (`id`) USING BTREE
260) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
261
262-- ----------------------------
263-- Table structure for cms_wordfilter
264-- ----------------------------
265DROP TABLE IF EXISTS `cms_wordfilter`;
266CREATE TABLE `cms_wordfilter`  (
267  `word` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
268  `mode` tinyint(2) NOT NULL DEFAULT 1,
269  PRIMARY KEY (`word`, `mode`) USING BTREE
270) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
271
272-- ----------------------------
273-- Table structure for command_notifications
274-- ----------------------------
275DROP TABLE IF EXISTS `command_notifications`;
276CREATE TABLE `command_notifications`  (
277  `name` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'The command for the player to type in (it does not override normal system commands)',
278  `text` varchar(512) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'The notification that will be displayed to the user.',
279  `type` enum('global','local','room') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'local' COMMENT 'The type of notification this will show, global = to all players, local = to the single player, room = to the room the executor is in.',
280  `min_rank` int(11) NOT NULL DEFAULT 1 COMMENT 'The minimum rank that the user must be to execute this command.',
281  `cooldown` int(11) DEFAULT 10 COMMENT 'The length of time until the player can execute this command again.',
282  PRIMARY KEY (`name`) USING BTREE,
283  INDEX `name`(`name`) USING BTREE
284) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
285
286-- ----------------------------
287-- Table structure for contact
288-- ----------------------------
289DROP TABLE IF EXISTS `contact`;
290CREATE TABLE `contact`  (
291  `id` int(11) NOT NULL AUTO_INCREMENT,
292  `gebruikersnaam` int(10) NOT NULL DEFAULT 0,
293  `email` varchar(999) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
294  `onderwerp` varchar(999) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
295  `bericht` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
296  PRIMARY KEY (`id`) USING BTREE
297) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
298
299-- ----------------------------
300-- Table structure for fastfood_user_data
301-- ----------------------------
302DROP TABLE IF EXISTS `fastfood_user_data`;
303CREATE TABLE `fastfood_user_data`  (
304  `player_id` int(11) NOT NULL,
305  `parachutes` int(11) NOT NULL DEFAULT 10,
306  `missiles` int(11) NOT NULL DEFAULT 10,
307  `shields` int(11) NOT NULL DEFAULT 10,
308  PRIMARY KEY (`player_id`) USING BTREE
309) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
310
311-- ----------------------------
312-- Table structure for furniture
313-- ----------------------------
314DROP TABLE IF EXISTS `furniture`;
315CREATE TABLE `furniture`  (
316  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
317  `item_name` varchar(70) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
318  `public_name` varchar(56) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
319  `type` enum('s','i','e','h','v','r','b','p') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 's',
320  `width` int(11) NOT NULL DEFAULT 1,
321  `length` int(11) NOT NULL DEFAULT 1,
322  `stack_height` double NOT NULL DEFAULT 1,
323  `can_stack` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
324  `can_sit` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
325  `is_walkable` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
326  `sprite_id` int(11) NOT NULL DEFAULT 0,
327  `allow_recycle` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
328  `allow_trade` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
329  `allow_marketplace_sell` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
330  `allow_gift` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
331  `allow_inventory_stack` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
332  `interaction_type` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'default',
333  `interaction_modes_count` int(11) NOT NULL DEFAULT 2,
334  `vending_ids` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
335  `variable_heights` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
336  `effect_id` int(3) NOT NULL DEFAULT 0,
337  `wired_id` int(11) NOT NULL DEFAULT 0,
338  `is_rare` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
339  `clothing_id` int(11) NOT NULL DEFAULT 0,
340  `extra_rot` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
341  `behaviour_data` int(11) NOT NULL DEFAULT 0,
342  `song_id` int(11) NOT NULL DEFAULT 0,
343  `is_arrow` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
344  `foot_figure` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
345  `stack_multiplier` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
346  `subscriber` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
347  `flat_id` int(11) NOT NULL DEFAULT -1,
348  `revision` int(11) NOT NULL DEFAULT 49500,
349  `description` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
350  `specialtype` int(11) NOT NULL DEFAULT 1,
351  `canlayon` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
352  `requires_rights` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
353  PRIMARY KEY (`id`) USING BTREE,
354  UNIQUE INDEX `id`(`id`) USING BTREE,
355  INDEX `sprite_id`(`sprite_id`) USING BTREE
356) ENGINE = InnoDB AUTO_INCREMENT = 1346781675 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
357
358-- ----------------------------
359-- Table structure for furniture_music
360-- ----------------------------
361DROP TABLE IF EXISTS `furniture_music`;
362CREATE TABLE `furniture_music`  (
363  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
364  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
365  `title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
366  `artist` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
367  `song_data` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
368  `length` int(11) NOT NULL,
369  PRIMARY KEY (`id`) USING BTREE
370) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
371
372-- ----------------------------
373-- Table structure for group_forum_messages
374-- ----------------------------
375DROP TABLE IF EXISTS `group_forum_messages`;
376CREATE TABLE `group_forum_messages`  (
377  `id` int(11) NOT NULL AUTO_INCREMENT,
378  `type` enum('THREAD','REPLY') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'THREAD',
379  `thread_id` int(11) DEFAULT NULL,
380  `group_id` int(11) DEFAULT NULL,
381  `title` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
382  `message` varchar(4000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
383  `author_id` int(11) NOT NULL,
384  `author_timestamp` int(11) NOT NULL,
385  `state` int(11) NOT NULL DEFAULT 1,
386  `locked` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
387  `pinned` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
388  `moderator_id` int(11) NOT NULL DEFAULT 0,
389  `moderator_username` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
390  PRIMARY KEY (`id`) USING BTREE,
391  INDEX `group_id`(`group_id`) USING BTREE,
392  INDEX `thread_id`(`thread_id`) USING BTREE,
393  INDEX `author_id`(`author_id`) USING BTREE,
394  INDEX `type_group_id`(`type`, `group_id`) USING BTREE
395) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
396
397-- ----------------------------
398-- Table structure for group_forum_settings
399-- ----------------------------
400DROP TABLE IF EXISTS `group_forum_settings`;
401CREATE TABLE `group_forum_settings`  (
402  `group_id` int(11) NOT NULL DEFAULT 0,
403  `read_permission` enum('EVERYBODY','MEMBERS','ADMINISTRATORS') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'EVERYBODY',
404  `post_permission` enum('EVERYBODY','MEMBERS','ADMINISTRATORS','OWNER') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'EVERYBODY',
405  `thread_permission` enum('EVERYBODY','MEMBERS','ADMINISTRATORS','OWNER') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'EVERYBODY',
406  `moderate_permission` enum('ADMINISTRATORS','OWNER') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'ADMINISTRATORS',
407  PRIMARY KEY (`group_id`) USING BTREE,
408  INDEX `group_id`(`group_id`) USING BTREE
409) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
410
411-- ----------------------------
412-- Table structure for group_items
413-- ----------------------------
414DROP TABLE IF EXISTS `group_items`;
415CREATE TABLE `group_items`  (
416  `id` int(11) NOT NULL,
417  `firstvalue` varchar(300) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
418  `secondvalue` varchar(300) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
419  `type` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
420  `enabled` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1'
421) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
422
423-- ----------------------------
424-- Table structure for group_memberships
425-- ----------------------------
426DROP TABLE IF EXISTS `group_memberships`;
427CREATE TABLE `group_memberships`  (
428  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
429  `group_id` int(11) UNSIGNED NOT NULL,
430  `player_id` int(11) UNSIGNED NOT NULL,
431  `access_level` enum('owner','admin','member') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'member',
432  `date_joined` int(11) UNSIGNED NOT NULL DEFAULT 0,
433  PRIMARY KEY (`id`) USING BTREE,
434  INDEX `groupid`(`group_id`) USING BTREE,
435  INDEX `userid`(`player_id`) USING BTREE
436) ENGINE = InnoDB AUTO_INCREMENT = 119 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
437
438-- ----------------------------
439-- Table structure for group_requests
440-- ----------------------------
441DROP TABLE IF EXISTS `group_requests`;
442CREATE TABLE `group_requests`  (
443  `group_id` int(11) UNSIGNED NOT NULL,
444  `player_id` int(11) UNSIGNED NOT NULL,
445  INDEX `groupid`(`group_id`) USING BTREE,
446  INDEX `userid`(`player_id`) USING BTREE
447) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
448
449-- ----------------------------
450-- Table structure for groups
451-- ----------------------------
452DROP TABLE IF EXISTS `groups`;
453CREATE TABLE `groups`  (
454  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
455  `name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
456  `description` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
457  `badge` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
458  `owner_id` int(11) UNSIGNED NOT NULL,
459  `room_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
460  `created` int(50) NOT NULL,
461  `type` enum('regular','exclusive','private') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'regular',
462  `colour1` int(11) NOT NULL DEFAULT 242424,
463  `colour2` int(11) NOT NULL DEFAULT 242424,
464  `members_deco` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
465  `has_forum` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
466  `notification` int(11) DEFAULT 0,
467  PRIMARY KEY (`id`) USING BTREE,
468  INDEX `id`(`id`) USING BTREE
469) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
470
471-- ----------------------------
472-- Table structure for hilloversie
473-- ----------------------------
474DROP TABLE IF EXISTS `hilloversie`;
475CREATE TABLE `hilloversie`  (
476  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
477  `versie` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
478  PRIMARY KEY (`id`) USING BTREE
479) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
480
481-- ----------------------------
482-- Table structure for hk_fuses
483-- ----------------------------
484DROP TABLE IF EXISTS `hk_fuses`;
485CREATE TABLE `hk_fuses`  (
486  `fuse` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
487  `minrank` int(11) NOT NULL DEFAULT 1
488) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
489
490-- ----------------------------
491-- Table structure for hp_logboek
492-- ----------------------------
493DROP TABLE IF EXISTS `hp_logboek`;
494CREATE TABLE `hp_logboek`  (
495  `id` int(11) NOT NULL AUTO_INCREMENT,
496  `userid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
497  `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
498  `date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
499  `browser` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
500  PRIMARY KEY (`id`) USING BTREE
501) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
502
503-- ----------------------------
504-- Table structure for items
505-- ----------------------------
506DROP TABLE IF EXISTS `items`;
507CREATE TABLE `items`  (
508  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
509  `user_id` int(10) NOT NULL,
510  `room_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
511  `base_item` int(10) UNSIGNED NOT NULL,
512  `extra_data` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
513  `x` int(11) NOT NULL DEFAULT 0,
514  `y` int(11) NOT NULL DEFAULT 0,
515  `z` double NOT NULL DEFAULT 0,
516  `rot` int(11) NOT NULL DEFAULT 0,
517  `wall_pos` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
518  `limited_number` int(11) DEFAULT 0,
519  `limited_stack` int(11) DEFAULT 0,
520  PRIMARY KEY (`id`) USING BTREE,
521  UNIQUE INDEX `id`(`id`) USING BTREE,
522  INDEX `userid`(`user_id`) USING BTREE,
523  INDEX `roomid`(`room_id`) USING BTREE,
524  INDEX `base_item`(`base_item`) USING BTREE
525) ENGINE = InnoDB AUTO_INCREMENT = 1439738 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
526
527-- ----------------------------
528-- Table structure for items_crackable_rewards
529-- ----------------------------
530DROP TABLE IF EXISTS `items_crackable_rewards`;
531CREATE TABLE `items_crackable_rewards`  (
532  `item_id` int(11) NOT NULL,
533  `hit_requirement` int(11) NOT NULL,
534  `crackable_type` enum('PRIVATE','PUBLIC') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'PRIVATE',
535  `reward_type` enum('BADGE','ITEM','COINS','VIP_POINTS','ACTIVITY_POINTS','EFFECT') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'BADGE',
536  `reward_data` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
537  `reward_data_int` int(11) NOT NULL DEFAULT 11,
538  PRIMARY KEY (`item_id`) USING BTREE
539) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
540
541-- ----------------------------
542-- Table structure for items_limited_edition
543-- ----------------------------
544DROP TABLE IF EXISTS `items_limited_edition`;
545CREATE TABLE `items_limited_edition`  (
546  `id` int(11) NOT NULL AUTO_INCREMENT,
547  `item_id` int(11) NOT NULL DEFAULT 0,
548  `limited_id` int(11) NOT NULL DEFAULT 0,
549  `limited_total` int(11) NOT NULL DEFAULT 0,
550  PRIMARY KEY (`id`) USING BTREE,
551  INDEX `item_id`(`item_id`) USING BTREE
552) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
553
554-- ----------------------------
555-- Table structure for items_moodlight
556-- ----------------------------
557DROP TABLE IF EXISTS `items_moodlight`;
558CREATE TABLE `items_moodlight`  (
559  `item_id` int(10) NOT NULL,
560  `enabled` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
561  `active_preset` enum('1','2','3') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
562  `preset_1` tinytext CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
563  `preset_2` tinytext CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
564  `preset_3` tinytext CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
565  PRIMARY KEY (`item_id`) USING BTREE
566) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
567
568-- ----------------------------
569-- Table structure for items_teles
570-- ----------------------------
571DROP TABLE IF EXISTS `items_teles`;
572CREATE TABLE `items_teles`  (
573  `id` int(11) NOT NULL AUTO_INCREMENT,
574  `id_one` bigint(20) DEFAULT NULL,
575  `id_two` bigint(20) DEFAULT NULL,
576  PRIMARY KEY (`id`) USING BTREE
577) ENGINE = InnoDB AUTO_INCREMENT = 433 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
578
579-- ----------------------------
580-- Table structure for items_wired_rewards
581-- ----------------------------
582DROP TABLE IF EXISTS `items_wired_rewards`;
583CREATE TABLE `items_wired_rewards`  (
584  `id` int(11) NOT NULL AUTO_INCREMENT,
585  `player_id` int(11) NOT NULL,
586  `item_id` bigint(20) NOT NULL,
587  PRIMARY KEY (`id`) USING BTREE,
588  INDEX `item_id`(`item_id`) USING BTREE
589) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
590
591-- ----------------------------
592-- Table structure for login_sessions
593-- ----------------------------
594DROP TABLE IF EXISTS `login_sessions`;
595CREATE TABLE `login_sessions`  (
596  `ses_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
597  `ses_u_id` int(11) UNSIGNED NOT NULL,
598  `ses_hash` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
599  `ses_expire_type` tinyint(1) NOT NULL,
600  `ses_expire_time` int(10) UNSIGNED NOT NULL,
601  `ses_created_time` int(10) UNSIGNED NOT NULL,
602  `ses_ip_list` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
603  `ses_browsers` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
604  `ses_phpsessid` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
605  `ses_last_ip` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
606  `ses_last_time` int(10) UNSIGNED NOT NULL,
607  `ses_active` tinyint(1) NOT NULL DEFAULT 1,
608  `ses_logout_time` int(10) UNSIGNED NOT NULL DEFAULT 0,
609  `ses_mod_auth` int(10) NOT NULL,
610  PRIMARY KEY (`ses_id`) USING BTREE,
611  INDEX `id_user_active`(`ses_id`, `ses_u_id`, `ses_active`) USING BTREE
612) ENGINE = InnoDB AUTO_INCREMENT = 220687 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
613
614-- ----------------------------
615-- Table structure for logs
616-- ----------------------------
617DROP TABLE IF EXISTS `logs`;
618CREATE TABLE `logs`  (
619  `id` int(11) NOT NULL AUTO_INCREMENT,
620  `type` enum('ROOM_VISIT','FURNI_PURCHASE','ROOM_CHATLOG','MESSENGER_CHATLOG','COMMAND') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'ROOM_CHATLOG',
621  `room_id` int(11) DEFAULT -1,
622  `user_id` int(11) DEFAULT -1,
623  `data` text CHARACTER SET utf8 COLLATE utf8_general_ci,
624  `timestamp` int(11) DEFAULT 0,
625  PRIMARY KEY (`id`) USING BTREE
626) ENGINE = InnoDB AUTO_INCREMENT = 441984 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
627
628-- ----------------------------
629-- Table structure for messenger_friendships
630-- ----------------------------
631DROP TABLE IF EXISTS `messenger_friendships`;
632CREATE TABLE `messenger_friendships`  (
633  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
634  `user_one_id` int(10) UNSIGNED NOT NULL,
635  `user_two_id` int(10) UNSIGNED NOT NULL,
636  PRIMARY KEY (`id`) USING BTREE,
637  INDEX `user_one_id`(`user_one_id`) USING BTREE,
638  INDEX `user_two_id`(`user_two_id`) USING BTREE
639) ENGINE = InnoDB AUTO_INCREMENT = 13891 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
640
641-- ----------------------------
642-- Table structure for messenger_requests
643-- ----------------------------
644DROP TABLE IF EXISTS `messenger_requests`;
645CREATE TABLE `messenger_requests`  (
646  `from_id` int(10) UNSIGNED NOT NULL,
647  `to_id` int(10) UNSIGNED NOT NULL,
648  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
649  PRIMARY KEY (`id`) USING BTREE,
650  INDEX `from_id`(`from_id`) USING BTREE,
651  INDEX `to_id`(`to_id`) USING BTREE
652) ENGINE = InnoDB AUTO_INCREMENT = 4148 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
653
654-- ----------------------------
655-- Table structure for moderation_action_categories
656-- ----------------------------
657DROP TABLE IF EXISTS `moderation_action_categories`;
658CREATE TABLE `moderation_action_categories`  (
659  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
660  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
661  PRIMARY KEY (`id`) USING BTREE
662) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
663
664-- ----------------------------
665-- Table structure for moderation_actions
666-- ----------------------------
667DROP TABLE IF EXISTS `moderation_actions`;
668CREATE TABLE `moderation_actions`  (
669  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
670  `category_id` int(11) DEFAULT NULL,
671  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
672  `message` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
673  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
674  `ban_hours` int(11) DEFAULT NULL,
675  `avatar_ban_hours` int(11) DEFAULT NULL,
676  `mute_hours` int(11) DEFAULT NULL,
677  `trade_lock_hours` int(11) DEFAULT NULL,
678  PRIMARY KEY (`id`) USING BTREE
679) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
680
681-- ----------------------------
682-- Table structure for moderation_help_tickets
683-- ----------------------------
684DROP TABLE IF EXISTS `moderation_help_tickets`;
685CREATE TABLE `moderation_help_tickets`  (
686  `id` int(11) NOT NULL AUTO_INCREMENT,
687  `state` enum('CLOSED','IN_PROGRESS','OPEN','INVALID','ABUSIVE') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'OPEN',
688  `submitter_id` int(11) NOT NULL DEFAULT 0,
689  `reported_id` int(11) NOT NULL DEFAULT 0,
690  `moderator_id` int(11) NOT NULL DEFAULT 0,
691  `category_id` int(11) NOT NULL DEFAULT 0,
692  `message` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
693  `chat_messages` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
694  `room_id` int(11) NOT NULL DEFAULT 0,
695  `timestamp_opened` int(11) NOT NULL DEFAULT 0,
696  `timestamp_closed` int(11) NOT NULL DEFAULT 0,
697  PRIMARY KEY (`id`) USING BTREE
698) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
699
700-- ----------------------------
701-- Table structure for moderation_presets
702-- ----------------------------
703DROP TABLE IF EXISTS `moderation_presets`;
704CREATE TABLE `moderation_presets`  (
705  `id` int(10) NOT NULL AUTO_INCREMENT,
706  `type` enum('user','room') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'user',
707  `message` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
708  PRIMARY KEY (`id`) USING BTREE
709) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
710
711-- ----------------------------
712-- Table structure for navigator_categories
713-- ----------------------------
714DROP TABLE IF EXISTS `navigator_categories`;
715CREATE TABLE `navigator_categories`  (
716  `id` int(11) NOT NULL,
717  `category` enum('official_view','hotel_view','myworld_view','roomads_view','query') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'hotel_view',
718  `category_identifier` varchar(35) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
719  `public_name` varchar(35) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
720  `view_mode` enum('REGULAR','THUMBNAIL') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'REGULAR',
721  `required_rank` int(11) NOT NULL DEFAULT 1,
722  `category_type` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'category',
723  `search_allowance` enum('NOTHING','SHOW_MORE') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'SHOW_MORE',
724  `enabled` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
725  `visible` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
726  `order_id` int(11) NOT NULL DEFAULT 0,
727  `room_count` int(11) NOT NULL DEFAULT 15,
728  `room_count_expanded` int(11) NOT NULL DEFAULT 50,
729  PRIMARY KEY (`id`) USING BTREE
730) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
731
732-- ----------------------------
733-- Table structure for navigator_publics
734-- ----------------------------
735DROP TABLE IF EXISTS `navigator_publics`;
736CREATE TABLE `navigator_publics`  (
737  `room_id` int(11) NOT NULL AUTO_INCREMENT,
738  `caption` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
739  `description` varchar(150) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
740  `image_url` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
741  `order_num` int(11) NOT NULL DEFAULT 1,
742  `enabled` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
743  PRIMARY KEY (`room_id`) USING BTREE,
744  INDEX `ordernum`(`order_num`) USING BTREE
745) ENGINE = InnoDB AUTO_INCREMENT = 162 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
746
747-- ----------------------------
748-- Table structure for navigator_staff_picks
749-- ----------------------------
750DROP TABLE IF EXISTS `navigator_staff_picks`;
751CREATE TABLE `navigator_staff_picks`  (
752  `room_id` int(11) NOT NULL DEFAULT 0,
753  `featured_by` int(11) DEFAULT NULL,
754  PRIMARY KEY (`room_id`) USING BTREE
755) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
756
757-- ----------------------------
758-- Table structure for news_likes
759-- ----------------------------
760DROP TABLE IF EXISTS `news_likes`;
761CREATE TABLE `news_likes`  (
762  `id` int(11) NOT NULL AUTO_INCREMENT,
763  `news_id` int(11) NOT NULL,
764  `username` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
765  `like` int(11) NOT NULL,
766  PRIMARY KEY (`id`) USING BTREE
767) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
768
769-- ----------------------------
770-- Table structure for permission_chat_bubbles
771-- ----------------------------
772DROP TABLE IF EXISTS `permission_chat_bubbles`;
773CREATE TABLE `permission_chat_bubbles`  (
774  `bubble_id` int(11) NOT NULL,
775  `minimum_rank` int(11) NOT NULL,
776  `description` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'N/A',
777  PRIMARY KEY (`bubble_id`) USING BTREE
778) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
779
780-- ----------------------------
781-- Table structure for permission_command_overrides
782-- ----------------------------
783DROP TABLE IF EXISTS `permission_command_overrides`;
784CREATE TABLE `permission_command_overrides`  (
785  `id` int(11) NOT NULL AUTO_INCREMENT,
786  `command_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
787  `player_id` int(11) DEFAULT NULL,
788  `enabled` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
789  PRIMARY KEY (`id`) USING BTREE,
790  INDEX `player_id`(`player_id`) USING BTREE
791) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
792
793-- ----------------------------
794-- Table structure for permission_commands
795-- ----------------------------
796DROP TABLE IF EXISTS `permission_commands`;
797CREATE TABLE `permission_commands`  (
798  `command_id` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'AboutCommand',
799  `minimum_rank` int(11) DEFAULT 1,
800  `vip_only` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
801  `rights_only` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
802  `rights_override` enum('NONE','RIGHTS','OWNER') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'NONE'
803) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
804
805-- ----------------------------
806-- Table structure for permission_effects
807-- ----------------------------
808DROP TABLE IF EXISTS `permission_effects`;
809CREATE TABLE `permission_effects`  (
810  `effect_id` int(11) NOT NULL,
811  `minimum_rank` int(11) DEFAULT 7,
812  PRIMARY KEY (`effect_id`) USING BTREE
813) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
814
815-- ----------------------------
816-- Table structure for permission_perks
817-- ----------------------------
818DROP TABLE IF EXISTS `permission_perks`;
819CREATE TABLE `permission_perks`  (
820  `id` int(10) NOT NULL AUTO_INCREMENT,
821  `title` varchar(75) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'FULL_CHAT',
822  `data` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
823  `override_rank` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
824  `override_default` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
825  `min_rank` int(11) DEFAULT 1,
826  PRIMARY KEY (`id`) USING BTREE
827) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
828
829-- ----------------------------
830-- Table structure for permission_ranks
831-- ----------------------------
832DROP TABLE IF EXISTS `permission_ranks`;
833CREATE TABLE `permission_ranks`  (
834  `fuse` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
835  `min_rank` int(11) DEFAULT 1,
836  `note` text CHARACTER SET latin1 COLLATE latin1_swedish_ci
837) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
838
839-- ----------------------------
840-- Table structure for pet_breeds
841-- ----------------------------
842DROP TABLE IF EXISTS `pet_breeds`;
843CREATE TABLE `pet_breeds`  (
844  `pet_type` int(11) NOT NULL DEFAULT 1,
845  `pallet_id` int(11) NOT NULL DEFAULT 0,
846  `level` enum('EPIC','RARE','UNCOMMON','COMMON') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'COMMON',
847  PRIMARY KEY (`pet_type`, `pallet_id`) USING BTREE,
848  INDEX `pet_type`(`pet_type`) USING BTREE
849) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
850
851-- ----------------------------
852-- Table structure for pet_data
853-- ----------------------------
854DROP TABLE IF EXISTS `pet_data`;
855CREATE TABLE `pet_data`  (
856  `id` int(11) NOT NULL AUTO_INCREMENT,
857  `owner_id` int(11) NOT NULL DEFAULT 0,
858  `room_id` int(11) DEFAULT 0,
859  `pet_name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
860  `race_id` int(11) DEFAULT 11,
861  `type` int(11) DEFAULT NULL,
862  `colour` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
863  `scratches` int(11) NOT NULL DEFAULT 0,
864  `level` int(11) NOT NULL DEFAULT 0,
865  `happiness` int(11) NOT NULL DEFAULT 0,
866  `experience` int(11) NOT NULL DEFAULT 0,
867  `energy` int(11) NOT NULL DEFAULT 0,
868  `hunger` int(11) NOT NULL DEFAULT 0,
869  `x` int(11) DEFAULT 0,
870  `y` int(11) DEFAULT 0,
871  `saddled` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'false',
872  `any_rider` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'false',
873  `hair_style` int(11) DEFAULT -1,
874  `hair_colour` int(11) DEFAULT 0,
875  `birthday` int(11) DEFAULT 0,
876  PRIMARY KEY (`id`) USING BTREE,
877  INDEX `owner_id`(`owner_id`) USING BTREE,
878  INDEX `room_id`(`room_id`) USING BTREE
879) ENGINE = InnoDB AUTO_INCREMENT = 94 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
880
881-- ----------------------------
882-- Table structure for pet_messages
883-- ----------------------------
884DROP TABLE IF EXISTS `pet_messages`;
885CREATE TABLE `pet_messages`  (
886  `id` int(11) NOT NULL AUTO_INCREMENT,
887  `pet_type` int(11) NOT NULL DEFAULT 0,
888  `message_type` enum('GENERIC','SCRATCHED','WELCOME_HOME','HUNGRY','TIRED','SLEEPING') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'GENERIC',
889  `message_string` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Hiya %username%!!!',
890  PRIMARY KEY (`id`) USING BTREE
891) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
892
893-- ----------------------------
894-- Table structure for pet_races
895-- ----------------------------
896DROP TABLE IF EXISTS `pet_races`;
897CREATE TABLE `pet_races`  (
898  `race_id` int(255) DEFAULT NULL,
899  `colour1` int(255) DEFAULT NULL,
900  `colour2` int(255) DEFAULT NULL,
901  `has1colour` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
902  `has2colour` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL
903) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
904
905-- ----------------------------
906-- Table structure for pet_transformable
907-- ----------------------------
908DROP TABLE IF EXISTS `pet_transformable`;
909CREATE TABLE `pet_transformable`  (
910  `name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
911  `data` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'The first number is the pet ID, the rest is what determine the colours, hair etc.',
912  PRIMARY KEY (`name`) USING BTREE
913) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
914
915-- ----------------------------
916-- Table structure for player_access
917-- ----------------------------
918DROP TABLE IF EXISTS `player_access`;
919CREATE TABLE `player_access`  (
920  `id` int(11) NOT NULL AUTO_INCREMENT,
921  `player_id` int(11) NOT NULL DEFAULT 0,
922  `hardware_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
923  `ip_address` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
924  `timestamp` int(11) NOT NULL DEFAULT 0,
925  PRIMARY KEY (`id`) USING BTREE,
926  INDEX `player_id_hardware_id_ip_address`(`player_id`, `hardware_id`, `ip_address`) USING BTREE
927) ENGINE = InnoDB AUTO_INCREMENT = 6193 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
928
929-- ----------------------------
930-- Table structure for player_achievements
931-- ----------------------------
932DROP TABLE IF EXISTS `player_achievements`;
933CREATE TABLE `player_achievements`  (
934  `player_id` int(11) NOT NULL DEFAULT 0,
935  `group` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
936  `level` tinyint(4) NOT NULL DEFAULT 1,
937  `progress` int(11) NOT NULL DEFAULT 0,
938  UNIQUE INDEX `player_id_group`(`player_id`, `group`) USING BTREE,
939  INDEX `player_id`(`player_id`) USING BTREE
940) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
941
942-- ----------------------------
943-- Table structure for player_badges
944-- ----------------------------
945DROP TABLE IF EXISTS `player_badges`;
946CREATE TABLE `player_badges`  (
947  `id` int(10) NOT NULL AUTO_INCREMENT,
948  `player_id` int(11) UNSIGNED DEFAULT NULL,
949  `badge_code` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
950  `slot` int(11) NOT NULL DEFAULT 0,
951  PRIMARY KEY (`id`) USING BTREE,
952  INDEX `user_id`(`player_id`) USING BTREE
953) ENGINE = InnoDB AUTO_INCREMENT = 18756 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
954
955-- ----------------------------
956-- Table structure for player_clothing
957-- ----------------------------
958DROP TABLE IF EXISTS `player_clothing`;
959CREATE TABLE `player_clothing`  (
960  `id` int(11) NOT NULL AUTO_INCREMENT,
961  `player_id` int(11) DEFAULT NULL,
962  `item_name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
963  PRIMARY KEY (`id`) USING BTREE,
964  INDEX `player_id`(`player_id`) USING BTREE
965) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
966
967-- ----------------------------
968-- Table structure for player_effects
969-- ----------------------------
970DROP TABLE IF EXISTS `player_effects`;
971CREATE TABLE `player_effects`  (
972  `player_id` int(11) NOT NULL,
973  `effect_id` int(11) NOT NULL,
974  PRIMARY KEY (`player_id`, `effect_id`) USING BTREE,
975  INDEX `player_id`(`player_id`) USING BTREE
976) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
977
978-- ----------------------------
979-- Table structure for player_favourite_rooms
980-- ----------------------------
981DROP TABLE IF EXISTS `player_favourite_rooms`;
982CREATE TABLE `player_favourite_rooms`  (
983  `player_id` int(11) NOT NULL,
984  `room_id` int(11) NOT NULL,
985  PRIMARY KEY (`player_id`, `room_id`) USING BTREE
986) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
987
988-- ----------------------------
989-- Table structure for player_navigator_view_modes
990-- ----------------------------
991DROP TABLE IF EXISTS `player_navigator_view_modes`;
992CREATE TABLE `player_navigator_view_modes`  (
993  `id` int(11) NOT NULL AUTO_INCREMENT,
994  `player_id` int(11) DEFAULT NULL,
995  `category` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
996  `view_mode` int(11) DEFAULT 0,
997  PRIMARY KEY (`id`) USING BTREE,
998  UNIQUE INDEX `player_id_category`(`player_id`, `category`) USING BTREE,
999  INDEX `player_id`(`player_id`) USING BTREE
1000) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1001
1002-- ----------------------------
1003-- Table structure for player_photos
1004-- ----------------------------
1005DROP TABLE IF EXISTS `player_photos`;
1006CREATE TABLE `player_photos`  (
1007  `id` int(11) NOT NULL AUTO_INCREMENT,
1008  `player_id` int(11) DEFAULT NULL,
1009  `room_id` int(11) DEFAULT NULL,
1010  `photo` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1011  `timestamp` int(11) DEFAULT NULL,
1012  PRIMARY KEY (`id`) USING BTREE,
1013  UNIQUE INDEX `photo`(`photo`) USING BTREE,
1014  INDEX `player_id`(`player_id`) USING BTREE,
1015  INDEX `room_id`(`room_id`) USING BTREE,
1016  INDEX `player_id_room_id`(`player_id`, `room_id`) USING BTREE
1017) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1018
1019-- ----------------------------
1020-- Table structure for player_quest_progression
1021-- ----------------------------
1022DROP TABLE IF EXISTS `player_quest_progression`;
1023CREATE TABLE `player_quest_progression`  (
1024  `id` int(11) NOT NULL AUTO_INCREMENT,
1025  `player_id` int(11) DEFAULT 0,
1026  `quest_id` int(11) DEFAULT 0,
1027  `progress` int(11) DEFAULT 0,
1028  PRIMARY KEY (`id`) USING BTREE,
1029  INDEX `player_id`(`player_id`) USING BTREE,
1030  INDEX `quest_id`(`quest_id`) USING BTREE,
1031  INDEX `playerId_questId`(`player_id`, `quest_id`) USING BTREE
1032) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1033
1034-- ----------------------------
1035-- Table structure for player_recent_purchases
1036-- ----------------------------
1037DROP TABLE IF EXISTS `player_recent_purchases`;
1038CREATE TABLE `player_recent_purchases`  (
1039  `id` int(11) NOT NULL AUTO_INCREMENT,
1040  `player_id` int(11) NOT NULL DEFAULT 0,
1041  `catalog_item` int(11) NOT NULL DEFAULT 0,
1042  `amount` int(11) NOT NULL DEFAULT 0,
1043  `data` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
1044  `purchase_date` timestamp(0) NOT NULL DEFAULT current_timestamp(),
1045  PRIMARY KEY (`id`) USING BTREE,
1046  INDEX `player_id`(`player_id`) USING BTREE
1047) ENGINE = InnoDB AUTO_INCREMENT = 22877 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1048
1049-- ----------------------------
1050-- Table structure for player_relationships
1051-- ----------------------------
1052DROP TABLE IF EXISTS `player_relationships`;
1053CREATE TABLE `player_relationships`  (
1054  `id` int(11) NOT NULL AUTO_INCREMENT,
1055  `player_id` int(11) DEFAULT NULL,
1056  `level` enum('bobba','smile','heart') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'smile',
1057  `partner` int(11) DEFAULT NULL,
1058  `accepted` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1059  PRIMARY KEY (`id`) USING BTREE
1060) ENGINE = InnoDB AUTO_INCREMENT = 466 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1061
1062-- ----------------------------
1063-- Table structure for player_room_visits
1064-- ----------------------------
1065DROP TABLE IF EXISTS `player_room_visits`;
1066CREATE TABLE `player_room_visits`  (
1067  `id` int(11) NOT NULL AUTO_INCREMENT,
1068  `player_id` int(11) NOT NULL DEFAULT 0,
1069  `room_id` int(11) NOT NULL DEFAULT 0,
1070  `time_enter` int(11) NOT NULL DEFAULT 0,
1071  `time_exit` int(11) DEFAULT 0,
1072  PRIMARY KEY (`id`) USING BTREE,
1073  INDEX `player_id`(`player_id`) USING BTREE,
1074  INDEX `room_id`(`room_id`) USING BTREE
1075) ENGINE = InnoDB AUTO_INCREMENT = 31878 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1076
1077-- ----------------------------
1078-- Table structure for player_saved_searches
1079-- ----------------------------
1080DROP TABLE IF EXISTS `player_saved_searches`;
1081CREATE TABLE `player_saved_searches`  (
1082  `id` int(11) NOT NULL AUTO_INCREMENT,
1083  `player_id` int(11) DEFAULT 0,
1084  `view` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'myworld_view',
1085  `search_query` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
1086  PRIMARY KEY (`id`) USING BTREE,
1087  INDEX `player_id`(`player_id`) USING BTREE
1088) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1089
1090-- ----------------------------
1091-- Table structure for player_settings
1092-- ----------------------------
1093DROP TABLE IF EXISTS `player_settings`;
1094CREATE TABLE `player_settings`  (
1095  `player_id` int(10) NOT NULL DEFAULT 0,
1096  `allow_follow` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
1097  `volume` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
1098  `hide_online` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1099  `hide_inroom` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1100  `allow_friend_requests` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
1101  `allow_trade` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
1102  `home_room` int(11) DEFAULT 161,
1103  `wardrobe` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
1104  `playlist` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
1105  `chat_oldstyle` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1106  `follow_friend_mode` enum('EVERYBODY','FRIENDS','NOBODY') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'EVERYBODY',
1107  `ignore_invites` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1108  `allow_mimic` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
1109  `navigator_x` int(11) DEFAULT 68,
1110  `navigator_y` int(11) DEFAULT 42,
1111  `navigator_width` int(11) DEFAULT 425,
1112  `navigator_height` int(11) DEFAULT 592,
1113  `navigator_show_searches` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1114  `ignore_events` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1115  `disable_whisper` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1116  `send_login_notif` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1117  `mention_type` enum('ALL','FRIENDS','NONE') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'FRIENDS',
1118  `personalstaff` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1119  INDEX `avatar_setting`(`player_id`) USING BTREE
1120) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1121
1122-- ----------------------------
1123-- Table structure for player_stats
1124-- ----------------------------
1125DROP TABLE IF EXISTS `player_stats`;
1126CREATE TABLE `player_stats`  (
1127  `player_id` int(10) NOT NULL DEFAULT 0,
1128  `achievement_score` int(10) DEFAULT 0,
1129  `total_respect_points` int(11) DEFAULT 0,
1130  `daily_respects` int(3) DEFAULT 3,
1131  `daily_scratches` int(3) DEFAULT 3,
1132  `help_tickets` int(11) DEFAULT 0,
1133  `cautions` int(11) DEFAULT 0,
1134  `help_tickets_abusive` int(11) DEFAULT 0,
1135  `bans` int(11) DEFAULT 0,
1136  `last_daily_update` int(11) DEFAULT 0,
1137  PRIMARY KEY (`player_id`) USING BTREE
1138) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1139
1140-- ----------------------------
1141-- Table structure for player_subscriptions
1142-- ----------------------------
1143DROP TABLE IF EXISTS `player_subscriptions`;
1144CREATE TABLE `player_subscriptions`  (
1145  `id` int(10) NOT NULL AUTO_INCREMENT,
1146  `type` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'habbo_vip',
1147  `start` int(255) DEFAULT 0,
1148  `expire` int(255) DEFAULT 0,
1149  `user_id` int(11) DEFAULT 0,
1150  PRIMARY KEY (`id`) USING BTREE
1151) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1152
1153-- ----------------------------
1154-- Table structure for players
1155-- ----------------------------
1156DROP TABLE IF EXISTS `players`;
1157CREATE TABLE `players`  (
1158  `id` int(11) NOT NULL AUTO_INCREMENT,
1159  `account_created` int(11) NOT NULL,
1160  `username` varchar(75) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'Avatar',
1161  `figure` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'lg-275-82.sh-290-92.ch-5579038-92-62.ha-1015-62.hr-155-45.hd-180-10',
1162  `motto` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'Sjovt',
1163  `credits` int(11) DEFAULT 50000,
1164  `vip_points` int(11) DEFAULT 0,
1165  `activity_points` int(11) NOT NULL DEFAULT 10,
1166  `seasonal_points` int(11) NOT NULL DEFAULT 0,
1167  `rank` int(3) DEFAULT 1,
1168  `auth_ticket` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1169  `gender` enum('M','F') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'M',
1170  `reg_timestamp` int(11) NOT NULL DEFAULT 0,
1171  `reg_date` varchar(12) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '10/06/2019',
1172  `last_online` int(11) DEFAULT 0,
1173  `online` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1174  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
1175  `email` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
1176  `last_ip` varchar(72) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT '',
1177  `vip` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1178  `achievement_points` int(11) DEFAULT 0,
1179  `favourite_group` int(11) DEFAULT 0,
1180  `chat_ticket` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
1181  `quest_id` int(11) DEFAULT 0,
1182  `time_muted` int(11) DEFAULT 0,
1183  `name_colour` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '000000',
1184  `cms_staffocult` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1185  `cms_role` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
1186  `user_fondo` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '/app/assets/img/personal/bg_fondo.png',
1187  `user_referrals` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1188  `cms_pin` enum('0','1','2') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1189  `cms_stories` int(50) NOT NULL DEFAULT 0,
1190  `code_forgot` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
1191  `cms_forgot_time` int(11) NOT NULL DEFAULT 0,
1192  `public_stories` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1193  `time_pass` int(11) NOT NULL DEFAULT 0,
1194  `pin_intentos` int(5) NOT NULL DEFAULT 3,
1195  `pin_time` int(11) NOT NULL DEFAULT 0,
1196  `pin_client` int(11) NOT NULL DEFAULT 0,
1197  `cuenta_suspendida` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1198  `karma` int(11) DEFAULT 0,
1199  `prestige` int(11) DEFAULT 0,
1200  `ip_register` varchar(72) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
1201  `ip_current` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1202  `tarea` varchar(300) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Sin tarea',
1203  `country` varchar(1000) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL DEFAULT '',
1204  `alfarango` enum('3','2','1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1205  `mail` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1206  `rank_2` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1207  `look` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'lg-275-82.sh-290-92.ch-5579038-92-62.ha-1015-62.hr-155-45.hd-180-10',
1208  `let_it_snow` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1209  `profile_ads` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1210  `chest_points` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1211  `support_tickets_alert` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1212  `fbid` int(11) DEFAULT NULL,
1213  `ip_last` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1214  `respect` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1215  `ip_reg` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1216  `date_of_birth` datetime(0) DEFAULT NULL,
1217  `block_newfriends` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1218  `block_trade` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1219  `block_gift_alerts` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1220  `block_push` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1221  PRIMARY KEY (`id`) USING BTREE
1222) ENGINE = InnoDB AUTO_INCREMENT = 4586 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
1223
1224-- ----------------------------
1225-- Table structure for playersettings
1226-- ----------------------------
1227DROP TABLE IF EXISTS `playersettings`;
1228CREATE TABLE `playersettings`  (
1229  `player_id` int(10) NOT NULL DEFAULT 0,
1230  `allow_follow` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
1231  `volume` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
1232  `hide_online` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1233  `hide_inroom` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1234  `allow_friend_requests` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
1235  `allow_trade` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
1236  `home_room` int(11) DEFAULT 63,
1237  `wardrobe` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
1238  `playlist` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
1239  `chat_oldstyle` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1240  `follow_friend_mode` enum('EVERYBODY','FRIENDS','NOBODY') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'EVERYBODY',
1241  `ignore_invites` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1242  `allow_mimic` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
1243  `navigator_x` int(11) DEFAULT 68,
1244  `navigator_y` int(11) DEFAULT 42,
1245  `navigator_width` int(11) DEFAULT 425,
1246  `navigator_height` int(11) DEFAULT 592,
1247  `navigator_show_searches` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1248  `ignore_events` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1249  `disable_whisper` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1250  `send_login_notif` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1251  `mention_type` enum('ALL','FRIENDS','NONE') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'FRIENDS',
1252  `personalstaff` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1253  INDEX `avatar_setting`(`player_id`) USING BTREE
1254) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1255
1256-- ----------------------------
1257-- Table structure for polls
1258-- ----------------------------
1259DROP TABLE IF EXISTS `polls`;
1260CREATE TABLE `polls`  (
1261  `id` int(11) NOT NULL AUTO_INCREMENT,
1262  `title` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Untitled Poll',
1263  `thanks_message` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Thanks!',
1264  `reward_badge` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'US8',
1265  `reward_credits` int(11) NOT NULL DEFAULT 0,
1266  `reward_vip_points` int(11) NOT NULL DEFAULT 0,
1267  `reward_activity_points` int(11) NOT NULL DEFAULT 0,
1268  `reward_achievement_points` int(11) NOT NULL DEFAULT 0,
1269  `room_id` int(11) DEFAULT 0,
1270  PRIMARY KEY (`id`) USING BTREE,
1271  INDEX `room_id`(`room_id`) USING BTREE
1272) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1273
1274-- ----------------------------
1275-- Table structure for polls_answers
1276-- ----------------------------
1277DROP TABLE IF EXISTS `polls_answers`;
1278CREATE TABLE `polls_answers`  (
1279  `id` int(11) NOT NULL AUTO_INCREMENT,
1280  `poll_id` int(11) DEFAULT 0,
1281  `question_id` int(11) DEFAULT 0,
1282  `player_id` int(11) DEFAULT 0,
1283  `answer` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
1284  PRIMARY KEY (`id`) USING BTREE,
1285  INDEX `poll_id_question_id_player_id`(`poll_id`, `question_id`, `player_id`) USING BTREE,
1286  INDEX `player_id`(`player_id`) USING BTREE,
1287  INDEX `poll_id`(`poll_id`) USING BTREE,
1288  INDEX `poll_id_question_id`(`poll_id`, `question_id`) USING BTREE
1289) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1290
1291-- ----------------------------
1292-- Table structure for polls_questions
1293-- ----------------------------
1294DROP TABLE IF EXISTS `polls_questions`;
1295CREATE TABLE `polls_questions`  (
1296  `id` int(11) NOT NULL AUTO_INCREMENT,
1297  `poll_id` int(11) NOT NULL,
1298  `question_type` enum('WORDED','MULTIPLE_CHOICE','SINGLE_CHOICE') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'WORDED',
1299  `question` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'What do you think of Comet Server?',
1300  `options` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
1301  PRIMARY KEY (`id`) USING BTREE,
1302  INDEX `poll_id`(`poll_id`) USING BTREE
1303) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1304
1305-- ----------------------------
1306-- Table structure for profile_wall
1307-- ----------------------------
1308DROP TABLE IF EXISTS `profile_wall`;
1309CREATE TABLE `profile_wall`  (
1310  `id` int(11) NOT NULL AUTO_INCREMENT,
1311  `username` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1312  `titel` tinytext CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1313  `message` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1314  PRIMARY KEY (`id`) USING BTREE
1315) ENGINE = MyISAM AUTO_INCREMENT = 4 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1316
1317-- ----------------------------
1318-- Table structure for quests
1319-- ----------------------------
1320DROP TABLE IF EXISTS `quests`;
1321CREATE TABLE `quests`  (
1322  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1323  `category` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1324  `series_number` int(11) NOT NULL DEFAULT 0,
1325  `goal_type` int(10) NOT NULL DEFAULT 0,
1326  `goal_data` int(10) UNSIGNED NOT NULL DEFAULT 0,
1327  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1328  `reward` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '10',
1329  `badge_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1330  `reward_type` enum('ACHIEVEMENT_POINTS','VIP_POINTS','ACTIVITY_POINTS','CREDITS','BADGE') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'ACTIVITY_POINTS',
1331  `data_bit` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1332  `enabled` enum('1','0') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '1',
1333  PRIMARY KEY (`id`) USING BTREE,
1334  UNIQUE INDEX `nameUnique`(`name`) USING BTREE,
1335  INDEX `nameKey`(`name`) USING BTREE,
1336  INDEX `categoryKey`(`category`) USING BTREE
1337) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1338
1339-- ----------------------------
1340-- Table structure for ranks
1341-- ----------------------------
1342DROP TABLE IF EXISTS `ranks`;
1343CREATE TABLE `ranks`  (
1344  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
1345  `name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1346  `badgeid` varchar(5) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1347  `title` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1348  `tab_colour` enum('red','green','pixeldarkblue','orange','blue','settings','pixellightblue') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1349  PRIMARY KEY (`id`) USING BTREE,
1350  UNIQUE INDEX `id`(`id`) USING BTREE
1351) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1352
1353-- ----------------------------
1354-- Table structure for referrer
1355-- ----------------------------
1356DROP TABLE IF EXISTS `referrer`;
1357CREATE TABLE `referrer`  (
1358  `id` int(11) NOT NULL AUTO_INCREMENT,
1359  `userid` decimal(10, 0) DEFAULT NULL,
1360  `refid` decimal(10, 0) DEFAULT NULL,
1361  `diamonds` decimal(10, 0) DEFAULT NULL,
1362  PRIMARY KEY (`id`) USING BTREE
1363) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1364
1365-- ----------------------------
1366-- Table structure for referrerbank
1367-- ----------------------------
1368DROP TABLE IF EXISTS `referrerbank`;
1369CREATE TABLE `referrerbank`  (
1370  `id` int(11) NOT NULL AUTO_INCREMENT,
1371  `userid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
1372  `diamonds` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
1373  PRIMARY KEY (`id`) USING BTREE
1374) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1375
1376-- ----------------------------
1377-- Table structure for resetpassword
1378-- ----------------------------
1379DROP TABLE IF EXISTS `resetpassword`;
1380CREATE TABLE `resetpassword`  (
1381  `id` int(11) NOT NULL AUTO_INCREMENT,
1382  `userid` int(11) DEFAULT NULL,
1383  `resetkey` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
1384  `enable` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0',
1385  PRIMARY KEY (`id`) USING BTREE
1386) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1387
1388-- ----------------------------
1389-- Table structure for room_bans
1390-- ----------------------------
1391DROP TABLE IF EXISTS `room_bans`;
1392CREATE TABLE `room_bans`  (
1393  `id` int(11) NOT NULL AUTO_INCREMENT,
1394  `room_id` int(11) NOT NULL DEFAULT 0,
1395  `player_id` int(11) NOT NULL DEFAULT 0,
1396  `expire_timestamp` int(11) NOT NULL DEFAULT 0,
1397  PRIMARY KEY (`id`) USING BTREE
1398) ENGINE = InnoDB AUTO_INCREMENT = 103 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'latin1_swedish_ci' ROW_FORMAT = Dynamic;
1399
1400-- ----------------------------
1401-- Table structure for room_bundles
1402-- ----------------------------
1403DROP TABLE IF EXISTS `room_bundles`;
1404CREATE TABLE `room_bundles`  (
1405  `id` int(11) NOT NULL AUTO_INCREMENT,
1406  `enabled` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
1407  `alias` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'roombundle',
1408  `room_id` int(11) DEFAULT NULL,
1409  `model_data` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
1410  `bundle_data` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
1411  `cost_credits` int(11) DEFAULT 20,
1412  `cost_seasonal` int(11) DEFAULT 0,
1413  `cost_vip` int(11) DEFAULT 0,
1414  `room_config` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
1415  `cost_activity_points` int(11) DEFAULT 0,
1416  PRIMARY KEY (`id`) USING BTREE,
1417  UNIQUE INDEX `alias`(`alias`) USING BTREE
1418) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1419
1420-- ----------------------------
1421-- Table structure for room_models
1422-- ----------------------------
1423DROP TABLE IF EXISTS `room_models`;
1424CREATE TABLE `room_models`  (
1425  `id` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1426  `door_x` int(11) NOT NULL,
1427  `door_y` int(11) NOT NULL,
1428  `door_z` double NOT NULL DEFAULT 0,
1429  `door_dir` int(4) NOT NULL DEFAULT 2,
1430  `heightmap` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1431  `public_items` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1432  `club_only` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1433  `poolmap` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL
1434) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
1435
1436-- ----------------------------
1437-- Table structure for room_rights
1438-- ----------------------------
1439DROP TABLE IF EXISTS `room_rights`;
1440CREATE TABLE `room_rights`  (
1441  `id` int(10) NOT NULL AUTO_INCREMENT,
1442  `player_id` int(10) DEFAULT 0,
1443  `room_id` int(10) DEFAULT 0,
1444  PRIMARY KEY (`id`) USING BTREE
1445) ENGINE = InnoDB AUTO_INCREMENT = 269 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1446
1447-- ----------------------------
1448-- Table structure for room_word_filter
1449-- ----------------------------
1450DROP TABLE IF EXISTS `room_word_filter`;
1451CREATE TABLE `room_word_filter`  (
1452  `id` int(11) NOT NULL AUTO_INCREMENT,
1453  `room_id` int(11) NOT NULL DEFAULT 0,
1454  `word` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'bobba',
1455  PRIMARY KEY (`id`) USING BTREE,
1456  INDEX `room_id_word`(`room_id`, `word`) USING BTREE
1457) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1458
1459-- ----------------------------
1460-- Table structure for rooms
1461-- ----------------------------
1462DROP TABLE IF EXISTS `rooms`;
1463CREATE TABLE `rooms`  (
1464  `id` int(11) NOT NULL AUTO_INCREMENT,
1465  `type` enum('PUBLIC','PRIVATE') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'PRIVATE',
1466  `owner_id` int(11) NOT NULL,
1467  `group_id` int(11) NOT NULL DEFAULT 0,
1468  `owner` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'John',
1469  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1470  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1471  `tags` varchar(65) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1472  `access_type` enum('password','doorbell','open','invisible') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'open',
1473  `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1474  `category` int(10) NOT NULL DEFAULT 15,
1475  `max_users` int(11) NOT NULL DEFAULT 25,
1476  `score` int(11) NOT NULL DEFAULT 0,
1477  `model` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'model_a',
1478  `allow_pets` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1479  `allow_pets_eating` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1480  `allow_walkthrough` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
1481  `hide_walls` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1482  `thickness_wall` int(11) NOT NULL DEFAULT 1,
1483  `thickness_floor` int(11) NOT NULL DEFAULT 1,
1484  `decorations` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'landscape=0.0',
1485  `heightmap` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1486  `trade_state` enum('OWNER_ONLY','ENABLED','DISABLED') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'ENABLED',
1487  `mute_state` enum('NONE','RIGHTS') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'NONE',
1488  `kick_state` enum('NONE','RIGHTS','EVERYONE') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'RIGHTS',
1489  `ban_state` enum('NONE','RIGHTS') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'NONE',
1490  `bubble_mode` tinyint(3) NOT NULL DEFAULT 0,
1491  `bubble_type` tinyint(3) DEFAULT 0,
1492  `bubble_scroll` tinyint(3) NOT NULL DEFAULT 0,
1493  `chat_distance` tinyint(3) NOT NULL DEFAULT 0,
1494  `flood_level` tinyint(3) NOT NULL DEFAULT 0,
1495  `disabled_commands` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
1496  `required_badge` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
1497  `thumbnail` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'navigator-thumbnail/default.png',
1498  `users_now` int(11) DEFAULT 0,
1499  `hide_wired` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0',
1500  `allow_recount` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
1501  PRIMARY KEY (`id`) USING BTREE,
1502  INDEX `owner_id`(`id`, `owner_id`) USING BTREE,
1503  INDEX `name`(`name`) USING BTREE,
1504  INDEX `tags`(`tags`) USING BTREE,
1505  INDEX `score`(`score`) USING BTREE,
1506  INDEX `category`(`category`) USING BTREE,
1507  INDEX `type`(`type`) USING BTREE
1508) ENGINE = InnoDB AUTO_INCREMENT = 1723 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
1509
1510-- ----------------------------
1511-- Table structure for rooms_promoted
1512-- ----------------------------
1513DROP TABLE IF EXISTS `rooms_promoted`;
1514CREATE TABLE `rooms_promoted`  (
1515  `room_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
1516  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
1517  `description` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
1518  `time_start` int(11) DEFAULT NULL,
1519  `time_expire` int(11) DEFAULT NULL,
1520  PRIMARY KEY (`room_id`) USING BTREE,
1521  INDEX `expire`(`time_expire`) USING BTREE,
1522  INDEX `room_id`(`room_id`) USING BTREE
1523) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1524
1525-- ----------------------------
1526-- Table structure for server_articles
1527-- ----------------------------
1528DROP TABLE IF EXISTS `server_articles`;
1529CREATE TABLE `server_articles`  (
1530  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
1531  `title` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1532  `message` varchar(512) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1533  `button_text` varchar(35) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1534  `button_link` varchar(512) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
1535  `image_path` varchar(35) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1536  `visible` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1537  PRIMARY KEY (`id`) USING BTREE
1538) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1539
1540-- ----------------------------
1541-- Table structure for server_config
1542-- ----------------------------
1543DROP TABLE IF EXISTS `server_config`;
1544CREATE TABLE `server_config`  (
1545  `key` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1546  `value` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
1547  PRIMARY KEY (`key`) USING BTREE
1548) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1549
1550-- ----------------------------
1551-- Table structure for server_configuration
1552-- ----------------------------
1553DROP TABLE IF EXISTS `server_configuration`;
1554CREATE TABLE `server_configuration`  (
1555  `motd_enabled` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'true',
1556  `motd_message` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Welcome to Comet!',
1557  `hotel_name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Comet',
1558  `hotel_url` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
1559  `group_cost` int(11) NOT NULL DEFAULT 100,
1560  `online_reward_enabled` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'true',
1561  `online_reward_interval` int(11) NOT NULL DEFAULT 15,
1562  `online_reward_credits` int(11) NOT NULL DEFAULT 150,
1563  `online_reward_duckets` int(11) NOT NULL DEFAULT 150,
1564  `about_image` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
1565  `about_show_players_online` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
1566  `about_show_rooms_active` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
1567  `about_show_uptime` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
1568  `floor_editor_max_x` int(11) NOT NULL DEFAULT 0,
1569  `floor_editor_max_y` int(11) NOT NULL DEFAULT 0,
1570  `floor_editor_max_total` int(11) NOT NULL DEFAULT 0,
1571  `room_max_players` int(11) NOT NULL DEFAULT 150,
1572  `room_encrypt_passwords` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
1573  `room_can_place_item_on_entity` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
1574  `room_max_bots` int(11) NOT NULL DEFAULT 15,
1575  `room_max_pets` int(11) NOT NULL DEFAULT 15,
1576  `room_wired_reward_minimum_rank` int(11) NOT NULL DEFAULT 7,
1577  `room_wired_max_effects` int(11) NOT NULL DEFAULT 10,
1578  `room_wired_max_triggers` int(11) NOT NULL DEFAULT 10,
1579  `room_wired_max_execute_stacks` int(11) NOT NULL DEFAULT 5,
1580  `room_idle_minutes` int(11) NOT NULL DEFAULT 15,
1581  `word_filter_mode` enum('default','smart','strict') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'default',
1582  `word_filter_strict_chars` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
1583  `use_database_ip` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
1584  `save_logins` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
1585  `player_infinite_balance` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
1586  `player_gift_cooldown` int(11) NOT NULL DEFAULT 30,
1587  `player_change_figure_cooldown` int(11) NOT NULL DEFAULT 5,
1588  `player_figure_validation` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
1589  `messenger_max_friends` int(11) NOT NULL DEFAULT 1500,
1590  `messenger_log_messages` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'true',
1591  `storage_item_queue_enabled` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'true',
1592  `storage_player_queue_enabled` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'true',
1593  `camera_photo_upload_url` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'http://localhost/photos/photos/%photoId%.png',
1594  `camera_photo_itemid` int(11) NOT NULL DEFAULT 50001,
1595  `camera_photo_url` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'http://localhost/photos/photos/%photoId%.png',
1596  `max_connections_per_ip` int(11) NOT NULL DEFAULT 5,
1597  `max_connections_block_suspicious` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'true',
1598  `log_catalog_purchases` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'true',
1599  `group_chat_enabled` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
1600  `hall_of_fame_enabled` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'true',
1601  `hall_of_fame_currency` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'vip_points',
1602  `hall_of_fame_refresh_minutes` int(10) NOT NULL DEFAULT 10,
1603  `hall_of_fame_texts_key` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'halloffame',
1604  `aaaa` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'halloffame',
1605  `online_reward_diamonds_interval` int(11) NOT NULL DEFAULT 15,
1606  `online_reward_diamonds` int(11) NOT NULL DEFAULT 5,
1607  `online_reward_double_days` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT ''
1608) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1609
1610-- ----------------------------
1611-- Table structure for server_locale
1612-- ----------------------------
1613DROP TABLE IF EXISTS `server_locale`;
1614CREATE TABLE `server_locale`  (
1615  `key` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1616  `value` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
1617  PRIMARY KEY (`key`) USING BTREE
1618) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1619
1620-- ----------------------------
1621-- Table structure for server_permissions_ranks
1622-- ----------------------------
1623DROP TABLE IF EXISTS `server_permissions_ranks`;
1624CREATE TABLE `server_permissions_ranks`  (
1625  `id` int(11) NOT NULL AUTO_INCREMENT,
1626  `name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1627  `flood_bypass` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1628  `flood_time` int(11) NOT NULL DEFAULT 30,
1629  `disconnectable` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
1630  `mod_tool` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1631  `bannable` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1632  `room_kickable` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
1633  `room_full_control` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
1634  `room_mute_bypass` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
1635  `room_filter_bypass` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1636  `room_ignorable` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
1637  `room_enter_full` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
1638  `room_enter_locked` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
1639  `room_staff_pick` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
1640  `room_see_whispers` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
1641  `messenger_staff_chat` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1642  `messenger_max_friends` int(11) NOT NULL DEFAULT 1100,
1643  `about_detailed` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1644  `about_stats` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1645  `messenger_log_chat` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
1646  `login_notif` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1647  PRIMARY KEY (`id`) USING BTREE
1648) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1649
1650-- ----------------------------
1651-- Table structure for server_ranks
1652-- ----------------------------
1653DROP TABLE IF EXISTS `server_ranks`;
1654CREATE TABLE `server_ranks`  (
1655  `rank_id` int(11) NOT NULL DEFAULT 1,
1656  `title` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Player',
1657  `badge_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'Player',
1658  `permission_mod_tool` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1659  `permission_room_full_control` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1660  `permission_bypass_filter` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1661  `permission_room_unkickable` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1662  `permission_unignorable` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1663  `permission_room_staff_pick` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1664  `messenger_log_chat` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1665  `flood_length` int(11) DEFAULT 30,
1666  PRIMARY KEY (`rank_id`) USING BTREE
1667) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1668
1669-- ----------------------------
1670-- Table structure for server_status
1671-- ----------------------------
1672DROP TABLE IF EXISTS `server_status`;
1673CREATE TABLE `server_status`  (
1674  `active_players` int(11) DEFAULT 0,
1675  `player_record` int(11) DEFAULT 0,
1676  `active_rooms` int(11) DEFAULT 0,
1677  `server_version` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
1678  `player_record_timestamp` int(11) DEFAULT 0
1679) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1680
1681-- ----------------------------
1682-- Table structure for site_hotcampaigns
1683-- ----------------------------
1684DROP TABLE IF EXISTS `site_hotcampaigns`;
1685CREATE TABLE `site_hotcampaigns`  (
1686  `id` int(11) NOT NULL AUTO_INCREMENT,
1687  `order_id` int(11) NOT NULL DEFAULT 1,
1688  `enabled` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
1689  `image_url` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1690  `caption` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1691  `descr` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1692  `url` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1693  PRIMARY KEY (`id`) USING BTREE
1694) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1695
1696-- ----------------------------
1697-- Table structure for site_news
1698-- ----------------------------
1699DROP TABLE IF EXISTS `site_news`;
1700CREATE TABLE `site_news`  (
1701  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1702  `seo_link` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'news-article',
1703  `title` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1704  `category_id` int(10) UNSIGNED NOT NULL DEFAULT 1,
1705  `topstory_image` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1706  `body` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1707  `snippet` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1708  `datestr` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1709  `timestamp` int(11) NOT NULL,
1710  PRIMARY KEY (`id`) USING BTREE,
1711  INDEX `datestr`(`datestr`) USING BTREE
1712) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1713
1714-- ----------------------------
1715-- Table structure for sollicitaties
1716-- ----------------------------
1717DROP TABLE IF EXISTS `sollicitaties`;
1718CREATE TABLE `sollicitaties`  (
1719  `id` int(11) NOT NULL AUTO_INCREMENT,
1720  `naam` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1721  `email` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1722  `skype` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1723  `leeftijd` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1724  `rank` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1725  `reden` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1726  `ervaring` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1727  PRIMARY KEY (`id`) USING BTREE
1728) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1729
1730-- ----------------------------
1731-- Table structure for songs
1732-- ----------------------------
1733DROP TABLE IF EXISTS `songs`;
1734CREATE TABLE `songs`  (
1735  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1736  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1737  `song_data` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1738  `artist` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1739  `creator_id` int(11) DEFAULT 0,
1740  PRIMARY KEY (`id`) USING BTREE
1741) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1742
1743-- ----------------------------
1744-- Table structure for staff_logs
1745-- ----------------------------
1746DROP TABLE IF EXISTS `staff_logs`;
1747CREATE TABLE `staff_logs`  (
1748  `player_id` int(11) NOT NULL DEFAULT 0,
1749  `type` enum('ALERT','BAN','DISCONNECT','CHECK','NONE') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'NONE',
1750  `target` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
1751  `value` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
1752  `time` int(11) NOT NULL DEFAULT 0,
1753  INDEX `player_id`(`player_id`) USING BTREE,
1754  INDEX `target`(`target`) USING BTREE,
1755  INDEX `type`(`type`) USING BTREE
1756) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1757
1758-- ----------------------------
1759-- Table structure for staffapplication
1760-- ----------------------------
1761DROP TABLE IF EXISTS `staffapplication`;
1762CREATE TABLE `staffapplication`  (
1763  `id` int(11) NOT NULL AUTO_INCREMENT,
1764  `username` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1765  `realname` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1766  `skype` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1767  `age` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1768  `functie` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1769  `onlinetime` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1770  `experience` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1771  `quarrel` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1772  `serious` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1773  `improve` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1774  `microphone` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1775  `ip` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1776  `date` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1777  PRIMARY KEY (`id`) USING BTREE
1778) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1779
1780-- ----------------------------
1781-- Table structure for sterrenkopen
1782-- ----------------------------
1783DROP TABLE IF EXISTS `sterrenkopen`;
1784CREATE TABLE `sterrenkopen`  (
1785  `naam` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1786  `datum` datetime(0) NOT NULL,
1787  `aantal` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1788  `betaald` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'ja'
1789) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1790
1791-- ----------------------------
1792-- Table structure for support_ticket_replies
1793-- ----------------------------
1794DROP TABLE IF EXISTS `support_ticket_replies`;
1795CREATE TABLE `support_ticket_replies`  (
1796  `id` int(32) UNSIGNED NOT NULL AUTO_INCREMENT,
1797  `ticket_id` mediumint(32) UNSIGNED NOT NULL,
1798  `text` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1799  `u_id` int(11) UNSIGNED NOT NULL,
1800  `time` int(10) UNSIGNED NOT NULL,
1801  PRIMARY KEY (`id`) USING BTREE
1802) ENGINE = InnoDB AUTO_INCREMENT = 7017 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1803
1804-- ----------------------------
1805-- Table structure for support_tickets
1806-- ----------------------------
1807DROP TABLE IF EXISTS `support_tickets`;
1808CREATE TABLE `support_tickets`  (
1809  `id` int(11) NOT NULL AUTO_INCREMENT,
1810  `state` int(11) NOT NULL DEFAULT 0,
1811  `type` int(2) NOT NULL DEFAULT 1,
1812  `timestamp` int(11) NOT NULL DEFAULT 0,
1813  `score` int(11) NOT NULL DEFAULT 0,
1814  `sender_id` int(11) NOT NULL DEFAULT 0,
1815  `reported_id` int(11) NOT NULL DEFAULT 0,
1816  `room_id` int(11) NOT NULL DEFAULT 0,
1817  `mod_id` int(11) NOT NULL DEFAULT 0,
1818  `issue` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1819  `category` int(3) NOT NULL DEFAULT 0,
1820  `group_id` int(11) NOT NULL,
1821  `thread_id` int(11) NOT NULL,
1822  `comment_id` int(11) NOT NULL,
1823  PRIMARY KEY (`id`) USING BTREE
1824) ENGINE = InnoDB AUTO_INCREMENT = 1650 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1825
1826-- ----------------------------
1827-- Table structure for support_ticketscenter
1828-- ----------------------------
1829DROP TABLE IF EXISTS `support_ticketscenter`;
1830CREATE TABLE `support_ticketscenter`  (
1831  `id` mediumint(32) UNSIGNED NOT NULL AUTO_INCREMENT,
1832  `category` tinyint(2) UNSIGNED NOT NULL,
1833  `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1834  `text` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1835  `u_id` int(11) UNSIGNED NOT NULL,
1836  `replies` smallint(10) UNSIGNED NOT NULL DEFAULT 0,
1837  `time` int(10) UNSIGNED NOT NULL,
1838  `closed` tinyint(1) NOT NULL DEFAULT 0,
1839  `min_rank` tinyint(1) NOT NULL DEFAULT 7,
1840  `extra_id` int(11) NOT NULL DEFAULT 0,
1841  `report_type` int(11) NOT NULL DEFAULT 1,
1842  PRIMARY KEY (`id`) USING BTREE
1843) ENGINE = InnoDB AUTO_INCREMENT = 2780 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1844
1845-- ----------------------------
1846-- Table structure for teamapplication
1847-- ----------------------------
1848DROP TABLE IF EXISTS `teamapplication`;
1849CREATE TABLE `teamapplication`  (
1850  `id` int(11) NOT NULL AUTO_INCREMENT,
1851  `username` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1852  `realname` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1853  `skype` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1854  `age` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1855  `functie` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1856  `onlinetime` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1857  `experience` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1858  `quarrel` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1859  `serious` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1860  `improve` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1861  `microphone` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1862  `ip` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1863  `date` text CHARACTER SET utf8 COLLATE utf8_general_ci,
1864  PRIMARY KEY (`id`) USING BTREE
1865) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1866
1867-- ----------------------------
1868-- Table structure for teams
1869-- ----------------------------
1870DROP TABLE IF EXISTS `teams`;
1871CREATE TABLE `teams`  (
1872  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
1873  `name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1874  `badgeid` varchar(5) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1875  PRIMARY KEY (`id`) USING BTREE,
1876  UNIQUE INDEX `id`(`id`) USING BTREE
1877) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1878
1879-- ----------------------------
1880-- Table structure for uotw
1881-- ----------------------------
1882DROP TABLE IF EXISTS `uotw`;
1883CREATE TABLE `uotw`  (
1884  `userid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
1885  `userid2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
1886  `userid3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL
1887) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
1888
1889-- ----------------------------
1890-- Table structure for user_profile
1891-- ----------------------------
1892DROP TABLE IF EXISTS `user_profile`;
1893CREATE TABLE `user_profile`  (
1894  `u_id` int(11) UNSIGNED NOT NULL,
1895  `link_style` tinyint(1) NOT NULL DEFAULT 1,
1896  `avatar_img` varchar(140) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1897  `cover_img` varchar(140) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1898  `about_text` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1899  `page_views` int(10) UNSIGNED NOT NULL DEFAULT 0,
1900  `youtube_id` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1901  `gb_posts` mediumint(10) UNSIGNED NOT NULL DEFAULT 0,
1902  `gb_limit` mediumint(10) UNSIGNED NOT NULL DEFAULT 999999,
1903  `profile_city` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
1904  `exts` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'a:8:{i:0;s:7:\"YouTube\";i:1;s:5:\"NoAds\";i:2;s:5:\"Stats\";i:3;s:9:\"FancyName\";i:4;s:6:\"Avatar\";i:5;s:7:\"CoverBg\";i:6;s:8:\"FancyBio\";i:7;s:9:\"GuestBook\";}',
1905  PRIMARY KEY (`u_id`) USING BTREE
1906) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1907
1908-- ----------------------------
1909-- Table structure for user_profile_gb
1910-- ----------------------------
1911DROP TABLE IF EXISTS `user_profile_gb`;
1912CREATE TABLE `user_profile_gb`  (
1913  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
1914  `u_id` int(11) UNSIGNED NOT NULL,
1915  `author` int(11) UNSIGNED NOT NULL,
1916  `text` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1917  `time` int(10) UNSIGNED NOT NULL DEFAULT 0,
1918  PRIMARY KEY (`id`) USING BTREE,
1919  INDEX `u_id`(`u_id`) USING BTREE
1920) ENGINE = InnoDB AUTO_INCREMENT = 3875 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1921
1922-- ----------------------------
1923-- Table structure for user_session_log
1924-- ----------------------------
1925DROP TABLE IF EXISTS `user_session_log`;
1926CREATE TABLE `user_session_log`  (
1927  `id` int(11) NOT NULL AUTO_INCREMENT,
1928  `userid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
1929  `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
1930  `date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
1931  `browser` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
1932  PRIMARY KEY (`id`) USING BTREE
1933) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1934
1935-- ----------------------------
1936-- Table structure for users_like
1937-- ----------------------------
1938DROP TABLE IF EXISTS `users_like`;
1939CREATE TABLE `users_like`  (
1940  `id` int(11) NOT NULL AUTO_INCREMENT,
1941  `userid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
1942  `likefrom` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
1943  PRIMARY KEY (`id`) USING BTREE
1944) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1945
1946-- ----------------------------
1947-- Table structure for vouchers
1948-- ----------------------------
1949DROP TABLE IF EXISTS `vouchers`;
1950CREATE TABLE `vouchers`  (
1951  `id` int(11) NOT NULL AUTO_INCREMENT,
1952  `type` enum('COINS','DUCKETS','VIP_POINTS','ROOM_BUNDLE') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'COINS',
1953  `data` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1954  `created_by` int(11) NOT NULL DEFAULT 0,
1955  `created_at` int(11) NOT NULL DEFAULT 0,
1956  `claimed_by` int(11) NOT NULL DEFAULT 0,
1957  `claimed_at` int(11) NOT NULL DEFAULT 0,
1958  `status` enum('UNCLAIMED','CLAIMED') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'UNCLAIMED',
1959  `code` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'voucher-00001',
1960  PRIMARY KEY (`id`) USING BTREE,
1961  UNIQUE INDEX `code`(`code`) USING BTREE,
1962  INDEX `created_by`(`created_by`) USING BTREE,
1963  INDEX `claimed_by`(`claimed_by`) USING BTREE
1964) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1965
1966-- ----------------------------
1967-- Table structure for website_articles
1968-- ----------------------------
1969DROP TABLE IF EXISTS `website_articles`;
1970CREATE TABLE `website_articles`  (
1971  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1972  `article_slug` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1973  `article_title` varchar(96) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1974  `article_description` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
1975  `article_body` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
1976  `article_author` int(11) NOT NULL DEFAULT 0,
1977  `article_promo_image` varchar(96) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
1978  `article_allow_comments` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
1979  `article_time_created` int(11) NOT NULL DEFAULT 0,
1980  `article_hidden` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'false',
1981  PRIMARY KEY (`id`) USING BTREE,
1982  UNIQUE INDEX `article_slug`(`article_slug`) USING BTREE
1983) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
1984
1985-- ----------------------------
1986-- Table structure for website_config
1987-- ----------------------------
1988DROP TABLE IF EXISTS `website_config`;
1989CREATE TABLE `website_config`  (
1990  `hotel_name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'Comet',
1991  `hotel_slogan` varchar(96) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'Comet',
1992  `hotel_description` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
1993  `twitter_username` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'habbo',
1994  `facebook_username` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'habbo',
1995  `twitter_widget_id` int(11) DEFAULT 0,
1996  `player_default_credits` int(11) DEFAULT 0,
1997  `player_default_activity_points` int(11) DEFAULT 0,
1998  `player_default_vip_points` int(11) DEFAULT 0,
1999  `player_default_figure` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
2000  `player_default_motto` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
2001  `player_default_homeroom` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
2002  `game_host` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
2003  `game_port` int(5) DEFAULT NULL,
2004  `game_client_swf` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
2005  `game_client_variables` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
2006  `game_client_texts` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
2007  `game_client_productdata` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
2008  `game_client_furnidata` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
2009  `game_client_base` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
2010  `game_client_banner` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT ''
2011) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
2012
2013-- ----------------------------
2014-- Table structure for website_gamedata_texts
2015-- ----------------------------
2016DROP TABLE IF EXISTS `website_gamedata_texts`;
2017CREATE TABLE `website_gamedata_texts`  (
2018  `key` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
2019  `value` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
2020  PRIMARY KEY (`key`) USING BTREE
2021) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
2022
2023-- ----------------------------
2024-- Table structure for website_gamedata_variables
2025-- ----------------------------
2026DROP TABLE IF EXISTS `website_gamedata_variables`;
2027CREATE TABLE `website_gamedata_variables`  (
2028  `key` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
2029  `value` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
2030  PRIMARY KEY (`key`) USING BTREE
2031) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
2032
2033-- ----------------------------
2034-- Table structure for website_news
2035-- ----------------------------
2036DROP TABLE IF EXISTS `website_news`;
2037CREATE TABLE `website_news`  (
2038  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
2039  `slug` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
2040  `title` varchar(96) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
2041  `description` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
2042  `body` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
2043  `images` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
2044  `author` int(11) NOT NULL DEFAULT 0,
2045  `header` varchar(96) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
2046  `timestamp` int(11) NOT NULL DEFAULT 0,
2047  `hidden` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
2048  PRIMARY KEY (`id`) USING BTREE
2049) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
2050
2051-- ----------------------------
2052-- Table structure for wordfilter
2053-- ----------------------------
2054DROP TABLE IF EXISTS `wordfilter`;
2055CREATE TABLE `wordfilter`  (
2056  `word` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
2057  `replacement` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'blacklist'
2058) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
2059
2060-- ----------------------------
2061-- Table structure for wordfilter_characters
2062-- ----------------------------
2063DROP TABLE IF EXISTS `wordfilter_characters`;
2064CREATE TABLE `wordfilter_characters`  (
2065  `character` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
2066  `replacement` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT ''
2067) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
2068
2069SET FOREIGN_KEY_CHECKS = 1;