/*
 Navicat Premium Data Transfer

 Source Server         : db
 Source Server Type    : MariaDB
 Source Server Version : 100213
 Source Host           : localhost:3306
 Source Schema         : comet2019

 Target Server Type    : MariaDB
 Target Server Version : 100213
 File Encoding         : 65001

 Date: 18/11/2019 09:53:05
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for achievements
-- ----------------------------
DROP TABLE IF EXISTS `achievements`;
CREATE TABLE `achievements`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `group_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'ACH_',
  `category` enum('identity','explore','music','social','games','room_builder','pets') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'identity',
  `level` int(11) NOT NULL DEFAULT 1,
  `reward_activity_points` int(11) NOT NULL DEFAULT 100,
  `reward_achievement_points` int(11) DEFAULT 10,
  `progress_requirement` int(11) NOT NULL DEFAULT 1,
  `enabled` enum('1','0') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 325 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for badge_shop
-- ----------------------------
DROP TABLE IF EXISTS `badge_shop`;
CREATE TABLE `badge_shop`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `badge_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `cost` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for bans
-- ----------------------------
DROP TABLE IF EXISTS `bans`;
CREATE TABLE `bans`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `type` enum('ip','machine','user') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `expire` int(20) DEFAULT 0 COMMENT '0 = perminent',
  `data` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `reason` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `added_by` int(11) DEFAULT 0,
  `ip` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `bantype` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `value` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 80 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for bots
-- ----------------------------
DROP TABLE IF EXISTS `bots`;
CREATE TABLE `bots`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner_id` int(11) DEFAULT 0,
  `owner` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `room_id` int(11) DEFAULT 0,
  `name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'Placeholder',
  `figure` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `gender` enum('m','f') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'm',
  `motto` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `x` int(11) DEFAULT 0,
  `y` int(11) DEFAULT 0,
  `z` double DEFAULT 0,
  `messages` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `automatic_chat` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
  `chat_delay` int(11) DEFAULT 7,
  `mode` enum('default','relaxed') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'default',
  `type` enum('generic','waiter','spy','test') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'generic',
  `data` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `Column 18` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for catalog_clothing
-- ----------------------------
DROP TABLE IF EXISTS `catalog_clothing`;
CREATE TABLE `catalog_clothing`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `clothing_items` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `item_name`(`item_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for catalog_featured_pages
-- ----------------------------
DROP TABLE IF EXISTS `catalog_featured_pages`;
CREATE TABLE `catalog_featured_pages`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `caption` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `image` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `page_link` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `page_id` int(11) NOT NULL DEFAULT -1,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for catalog_gift_wrapping
-- ----------------------------
DROP TABLE IF EXISTS `catalog_gift_wrapping`;
CREATE TABLE `catalog_gift_wrapping`  (
  `type` enum('new','old') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'new',
  `sprite_id` int(11) DEFAULT 0
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for catalog_items
-- ----------------------------
DROP TABLE IF EXISTS `catalog_items`;
CREATE TABLE `catalog_items`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `page_id` int(11) NOT NULL,
  `item_ids` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `catalog_name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `cost_credits` int(11) NOT NULL DEFAULT 0,
  `cost_pixels` int(11) NOT NULL DEFAULT 0,
  `cost_diamonds` int(11) NOT NULL DEFAULT 0,
  `cost_seasonal` int(11) NOT NULL DEFAULT 0,
  `amount` int(11) NOT NULL DEFAULT 1,
  `vip` enum('0','1','2') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `achievement` int(4) UNSIGNED NOT NULL DEFAULT 0,
  `song_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `limited_sells` int(11) NOT NULL DEFAULT 0,
  `limited_stack` int(11) NOT NULL DEFAULT 0,
  `offer_active` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `extradata` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `badge_id` varchar(5) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `flat_id` int(11) NOT NULL DEFAULT -1,
  `cost_snow` int(11) NOT NULL DEFAULT 0,
  `predesigned_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `item_id`(`item_ids`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 99910896 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for catalog_pages
-- ----------------------------
DROP TABLE IF EXISTS `catalog_pages`;
CREATE TABLE `catalog_pages`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT -1,
  `type` enum('RECENT_PURCHASES','DEFAULT','BUNDLE') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'DEFAULT',
  `caption` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `icon_image` int(11) NOT NULL DEFAULT 1,
  `visible` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `enabled` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `min_rank` int(11) UNSIGNED NOT NULL DEFAULT 1,
  `club_only` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `order_num` int(11) NOT NULL,
  `page_layout` varchar(35) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'default_3x3',
  `page_images` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `page_texts` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `min_sub` int(11) NOT NULL DEFAULT 0,
  `vip_only` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `link` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `extra_data` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE,
  INDEX `order_num`(`order_num`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 423423573 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cms_alerts
-- ----------------------------
DROP TABLE IF EXISTS `cms_alerts`;
CREATE TABLE `cms_alerts`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `alert` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for cms_news
-- ----------------------------
DROP TABLE IF EXISTS `cms_news`;
CREATE TABLE `cms_news`  (
  `n_id` smallint(32) UNSIGNED NOT NULL AUTO_INCREMENT,
  `n_title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `n_short` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `n_text` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `n_u_id` int(11) UNSIGNED NOT NULL,
  `n_time` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `n_topstory` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'default-top-story.png',
  `n_comments` smallint(8) UNSIGNED NOT NULL DEFAULT 0,
  `n_locked` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`n_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 462 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cms_news_comments
-- ----------------------------
DROP TABLE IF EXISTS `cms_news_comments`;
CREATE TABLE `cms_news_comments`  (
  `nc_id` int(11) NOT NULL AUTO_INCREMENT,
  `n_id` smallint(32) UNSIGNED NOT NULL,
  `nc_u_id` int(11) UNSIGNED NOT NULL,
  `nc_time` int(10) UNSIGNED NOT NULL,
  `nc_text` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `nc_deleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`nc_id`) USING BTREE,
  INDEX `n_id`(`n_id`, `nc_deleted`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4978 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cms_news_like
-- ----------------------------
DROP TABLE IF EXISTS `cms_news_like`;
CREATE TABLE `cms_news_like`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(255) DEFAULT NULL,
  `newsid` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cms_news_message
-- ----------------------------
DROP TABLE IF EXISTS `cms_news_message`;
CREATE TABLE `cms_news_message`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` int(11) NOT NULL DEFAULT 0,
  `buggid` int(11) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `message` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `hash` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cms_rarevalues
-- ----------------------------
DROP TABLE IF EXISTS `cms_rarevalues`;
CREATE TABLE `cms_rarevalues`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_name` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `item_image` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `item_cost` int(11) DEFAULT 0,
  `item_status` enum('up','down','same') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cms_wordfilter
-- ----------------------------
DROP TABLE IF EXISTS `cms_wordfilter`;
CREATE TABLE `cms_wordfilter`  (
  `word` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `mode` tinyint(2) NOT NULL DEFAULT 1,
  PRIMARY KEY (`word`, `mode`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for command_notifications
-- ----------------------------
DROP TABLE IF EXISTS `command_notifications`;
CREATE TABLE `command_notifications`  (
  `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)',
  `text` varchar(512) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'The notification that will be displayed to the user.',
  `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.',
  `min_rank` int(11) NOT NULL DEFAULT 1 COMMENT 'The minimum rank that the user must be to execute this command.',
  `cooldown` int(11) DEFAULT 10 COMMENT 'The length of time until the player can execute this command again.',
  PRIMARY KEY (`name`) USING BTREE,
  INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for contact
-- ----------------------------
DROP TABLE IF EXISTS `contact`;
CREATE TABLE `contact`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gebruikersnaam` int(10) NOT NULL DEFAULT 0,
  `email` varchar(999) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `onderwerp` varchar(999) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `bericht` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fastfood_user_data
-- ----------------------------
DROP TABLE IF EXISTS `fastfood_user_data`;
CREATE TABLE `fastfood_user_data`  (
  `player_id` int(11) NOT NULL,
  `parachutes` int(11) NOT NULL DEFAULT 10,
  `missiles` int(11) NOT NULL DEFAULT 10,
  `shields` int(11) NOT NULL DEFAULT 10,
  PRIMARY KEY (`player_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for furniture
-- ----------------------------
DROP TABLE IF EXISTS `furniture`;
CREATE TABLE `furniture`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `item_name` varchar(70) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `public_name` varchar(56) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `type` enum('s','i','e','h','v','r','b','p') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 's',
  `width` int(11) NOT NULL DEFAULT 1,
  `length` int(11) NOT NULL DEFAULT 1,
  `stack_height` double NOT NULL DEFAULT 1,
  `can_stack` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `can_sit` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `is_walkable` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `sprite_id` int(11) NOT NULL DEFAULT 0,
  `allow_recycle` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `allow_trade` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `allow_marketplace_sell` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `allow_gift` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `allow_inventory_stack` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `interaction_type` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'default',
  `interaction_modes_count` int(11) NOT NULL DEFAULT 2,
  `vending_ids` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `variable_heights` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `effect_id` int(3) NOT NULL DEFAULT 0,
  `wired_id` int(11) NOT NULL DEFAULT 0,
  `is_rare` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `clothing_id` int(11) NOT NULL DEFAULT 0,
  `extra_rot` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `behaviour_data` int(11) NOT NULL DEFAULT 0,
  `song_id` int(11) NOT NULL DEFAULT 0,
  `is_arrow` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `foot_figure` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `stack_multiplier` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `subscriber` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `flat_id` int(11) NOT NULL DEFAULT -1,
  `revision` int(11) NOT NULL DEFAULT 49500,
  `description` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `specialtype` int(11) NOT NULL DEFAULT 1,
  `canlayon` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `requires_rights` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE,
  INDEX `sprite_id`(`sprite_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1346781675 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for furniture_music
-- ----------------------------
DROP TABLE IF EXISTS `furniture_music`;
CREATE TABLE `furniture_music`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `artist` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `song_data` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `length` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for group_forum_messages
-- ----------------------------
DROP TABLE IF EXISTS `group_forum_messages`;
CREATE TABLE `group_forum_messages`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` enum('THREAD','REPLY') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'THREAD',
  `thread_id` int(11) DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  `title` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `message` varchar(4000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `author_id` int(11) NOT NULL,
  `author_timestamp` int(11) NOT NULL,
  `state` int(11) NOT NULL DEFAULT 1,
  `locked` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `pinned` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `moderator_id` int(11) NOT NULL DEFAULT 0,
  `moderator_username` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `group_id`(`group_id`) USING BTREE,
  INDEX `thread_id`(`thread_id`) USING BTREE,
  INDEX `author_id`(`author_id`) USING BTREE,
  INDEX `type_group_id`(`type`, `group_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for group_forum_settings
-- ----------------------------
DROP TABLE IF EXISTS `group_forum_settings`;
CREATE TABLE `group_forum_settings`  (
  `group_id` int(11) NOT NULL DEFAULT 0,
  `read_permission` enum('EVERYBODY','MEMBERS','ADMINISTRATORS') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'EVERYBODY',
  `post_permission` enum('EVERYBODY','MEMBERS','ADMINISTRATORS','OWNER') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'EVERYBODY',
  `thread_permission` enum('EVERYBODY','MEMBERS','ADMINISTRATORS','OWNER') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'EVERYBODY',
  `moderate_permission` enum('ADMINISTRATORS','OWNER') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'ADMINISTRATORS',
  PRIMARY KEY (`group_id`) USING BTREE,
  INDEX `group_id`(`group_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for group_items
-- ----------------------------
DROP TABLE IF EXISTS `group_items`;
CREATE TABLE `group_items`  (
  `id` int(11) NOT NULL,
  `firstvalue` varchar(300) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `secondvalue` varchar(300) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `type` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `enabled` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1'
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for group_memberships
-- ----------------------------
DROP TABLE IF EXISTS `group_memberships`;
CREATE TABLE `group_memberships`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `group_id` int(11) UNSIGNED NOT NULL,
  `player_id` int(11) UNSIGNED NOT NULL,
  `access_level` enum('owner','admin','member') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'member',
  `date_joined` int(11) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `groupid`(`group_id`) USING BTREE,
  INDEX `userid`(`player_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 119 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for group_requests
-- ----------------------------
DROP TABLE IF EXISTS `group_requests`;
CREATE TABLE `group_requests`  (
  `group_id` int(11) UNSIGNED NOT NULL,
  `player_id` int(11) UNSIGNED NOT NULL,
  INDEX `groupid`(`group_id`) USING BTREE,
  INDEX `userid`(`player_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for groups
-- ----------------------------
DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `description` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `badge` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `owner_id` int(11) UNSIGNED NOT NULL,
  `room_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `created` int(50) NOT NULL,
  `type` enum('regular','exclusive','private') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'regular',
  `colour1` int(11) NOT NULL DEFAULT 242424,
  `colour2` int(11) NOT NULL DEFAULT 242424,
  `members_deco` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `has_forum` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `notification` int(11) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for hilloversie
-- ----------------------------
DROP TABLE IF EXISTS `hilloversie`;
CREATE TABLE `hilloversie`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `versie` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for hk_fuses
-- ----------------------------
DROP TABLE IF EXISTS `hk_fuses`;
CREATE TABLE `hk_fuses`  (
  `fuse` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `minrank` int(11) NOT NULL DEFAULT 1
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for hp_logboek
-- ----------------------------
DROP TABLE IF EXISTS `hp_logboek`;
CREATE TABLE `hp_logboek`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `browser` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for items
-- ----------------------------
DROP TABLE IF EXISTS `items`;
CREATE TABLE `items`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `room_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `base_item` int(10) UNSIGNED NOT NULL,
  `extra_data` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `x` int(11) NOT NULL DEFAULT 0,
  `y` int(11) NOT NULL DEFAULT 0,
  `z` double NOT NULL DEFAULT 0,
  `rot` int(11) NOT NULL DEFAULT 0,
  `wall_pos` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `limited_number` int(11) DEFAULT 0,
  `limited_stack` int(11) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE,
  INDEX `userid`(`user_id`) USING BTREE,
  INDEX `roomid`(`room_id`) USING BTREE,
  INDEX `base_item`(`base_item`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1439738 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for items_crackable_rewards
-- ----------------------------
DROP TABLE IF EXISTS `items_crackable_rewards`;
CREATE TABLE `items_crackable_rewards`  (
  `item_id` int(11) NOT NULL,
  `hit_requirement` int(11) NOT NULL,
  `crackable_type` enum('PRIVATE','PUBLIC') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'PRIVATE',
  `reward_type` enum('BADGE','ITEM','COINS','VIP_POINTS','ACTIVITY_POINTS','EFFECT') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'BADGE',
  `reward_data` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `reward_data_int` int(11) NOT NULL DEFAULT 11,
  PRIMARY KEY (`item_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for items_limited_edition
-- ----------------------------
DROP TABLE IF EXISTS `items_limited_edition`;
CREATE TABLE `items_limited_edition`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT 0,
  `limited_id` int(11) NOT NULL DEFAULT 0,
  `limited_total` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `item_id`(`item_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for items_moodlight
-- ----------------------------
DROP TABLE IF EXISTS `items_moodlight`;
CREATE TABLE `items_moodlight`  (
  `item_id` int(10) NOT NULL,
  `enabled` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `active_preset` enum('1','2','3') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `preset_1` tinytext CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `preset_2` tinytext CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `preset_3` tinytext CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`item_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for items_teles
-- ----------------------------
DROP TABLE IF EXISTS `items_teles`;
CREATE TABLE `items_teles`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_one` bigint(20) DEFAULT NULL,
  `id_two` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 433 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for items_wired_rewards
-- ----------------------------
DROP TABLE IF EXISTS `items_wired_rewards`;
CREATE TABLE `items_wired_rewards`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` int(11) NOT NULL,
  `item_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `item_id`(`item_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for login_sessions
-- ----------------------------
DROP TABLE IF EXISTS `login_sessions`;
CREATE TABLE `login_sessions`  (
  `ses_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ses_u_id` int(11) UNSIGNED NOT NULL,
  `ses_hash` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ses_expire_type` tinyint(1) NOT NULL,
  `ses_expire_time` int(10) UNSIGNED NOT NULL,
  `ses_created_time` int(10) UNSIGNED NOT NULL,
  `ses_ip_list` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ses_browsers` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ses_phpsessid` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ses_last_ip` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ses_last_time` int(10) UNSIGNED NOT NULL,
  `ses_active` tinyint(1) NOT NULL DEFAULT 1,
  `ses_logout_time` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `ses_mod_auth` int(10) NOT NULL,
  PRIMARY KEY (`ses_id`) USING BTREE,
  INDEX `id_user_active`(`ses_id`, `ses_u_id`, `ses_active`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 220687 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for logs
-- ----------------------------
DROP TABLE IF EXISTS `logs`;
CREATE TABLE `logs`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` enum('ROOM_VISIT','FURNI_PURCHASE','ROOM_CHATLOG','MESSENGER_CHATLOG','COMMAND') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'ROOM_CHATLOG',
  `room_id` int(11) DEFAULT -1,
  `user_id` int(11) DEFAULT -1,
  `data` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `timestamp` int(11) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 441984 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for messenger_friendships
-- ----------------------------
DROP TABLE IF EXISTS `messenger_friendships`;
CREATE TABLE `messenger_friendships`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_one_id` int(10) UNSIGNED NOT NULL,
  `user_two_id` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `user_one_id`(`user_one_id`) USING BTREE,
  INDEX `user_two_id`(`user_two_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13891 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for messenger_requests
-- ----------------------------
DROP TABLE IF EXISTS `messenger_requests`;
CREATE TABLE `messenger_requests`  (
  `from_id` int(10) UNSIGNED NOT NULL,
  `to_id` int(10) UNSIGNED NOT NULL,
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `from_id`(`from_id`) USING BTREE,
  INDEX `to_id`(`to_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4148 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for moderation_action_categories
-- ----------------------------
DROP TABLE IF EXISTS `moderation_action_categories`;
CREATE TABLE `moderation_action_categories`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for moderation_actions
-- ----------------------------
DROP TABLE IF EXISTS `moderation_actions`;
CREATE TABLE `moderation_actions`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
  `message` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ban_hours` int(11) DEFAULT NULL,
  `avatar_ban_hours` int(11) DEFAULT NULL,
  `mute_hours` int(11) DEFAULT NULL,
  `trade_lock_hours` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for moderation_help_tickets
-- ----------------------------
DROP TABLE IF EXISTS `moderation_help_tickets`;
CREATE TABLE `moderation_help_tickets`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `state` enum('CLOSED','IN_PROGRESS','OPEN','INVALID','ABUSIVE') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'OPEN',
  `submitter_id` int(11) NOT NULL DEFAULT 0,
  `reported_id` int(11) NOT NULL DEFAULT 0,
  `moderator_id` int(11) NOT NULL DEFAULT 0,
  `category_id` int(11) NOT NULL DEFAULT 0,
  `message` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `chat_messages` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `room_id` int(11) NOT NULL DEFAULT 0,
  `timestamp_opened` int(11) NOT NULL DEFAULT 0,
  `timestamp_closed` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for moderation_presets
-- ----------------------------
DROP TABLE IF EXISTS `moderation_presets`;
CREATE TABLE `moderation_presets`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `type` enum('user','room') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'user',
  `message` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for navigator_categories
-- ----------------------------
DROP TABLE IF EXISTS `navigator_categories`;
CREATE TABLE `navigator_categories`  (
  `id` int(11) NOT NULL,
  `category` enum('official_view','hotel_view','myworld_view','roomads_view','query') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'hotel_view',
  `category_identifier` varchar(35) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `public_name` varchar(35) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `view_mode` enum('REGULAR','THUMBNAIL') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'REGULAR',
  `required_rank` int(11) NOT NULL DEFAULT 1,
  `category_type` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'category',
  `search_allowance` enum('NOTHING','SHOW_MORE') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'SHOW_MORE',
  `enabled` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `visible` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `order_id` int(11) NOT NULL DEFAULT 0,
  `room_count` int(11) NOT NULL DEFAULT 15,
  `room_count_expanded` int(11) NOT NULL DEFAULT 50,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for navigator_publics
-- ----------------------------
DROP TABLE IF EXISTS `navigator_publics`;
CREATE TABLE `navigator_publics`  (
  `room_id` int(11) NOT NULL AUTO_INCREMENT,
  `caption` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `description` varchar(150) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `image_url` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `order_num` int(11) NOT NULL DEFAULT 1,
  `enabled` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  PRIMARY KEY (`room_id`) USING BTREE,
  INDEX `ordernum`(`order_num`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 162 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for navigator_staff_picks
-- ----------------------------
DROP TABLE IF EXISTS `navigator_staff_picks`;
CREATE TABLE `navigator_staff_picks`  (
  `room_id` int(11) NOT NULL DEFAULT 0,
  `featured_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`room_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for news_likes
-- ----------------------------
DROP TABLE IF EXISTS `news_likes`;
CREATE TABLE `news_likes`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `news_id` int(11) NOT NULL,
  `username` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `like` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for permission_chat_bubbles
-- ----------------------------
DROP TABLE IF EXISTS `permission_chat_bubbles`;
CREATE TABLE `permission_chat_bubbles`  (
  `bubble_id` int(11) NOT NULL,
  `minimum_rank` int(11) NOT NULL,
  `description` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'N/A',
  PRIMARY KEY (`bubble_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for permission_command_overrides
-- ----------------------------
DROP TABLE IF EXISTS `permission_command_overrides`;
CREATE TABLE `permission_command_overrides`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `player_id` int(11) DEFAULT NULL,
  `enabled` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `player_id`(`player_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for permission_commands
-- ----------------------------
DROP TABLE IF EXISTS `permission_commands`;
CREATE TABLE `permission_commands`  (
  `command_id` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'AboutCommand',
  `minimum_rank` int(11) DEFAULT 1,
  `vip_only` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `rights_only` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `rights_override` enum('NONE','RIGHTS','OWNER') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'NONE'
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for permission_effects
-- ----------------------------
DROP TABLE IF EXISTS `permission_effects`;
CREATE TABLE `permission_effects`  (
  `effect_id` int(11) NOT NULL,
  `minimum_rank` int(11) DEFAULT 7,
  PRIMARY KEY (`effect_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for permission_perks
-- ----------------------------
DROP TABLE IF EXISTS `permission_perks`;
CREATE TABLE `permission_perks`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(75) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'FULL_CHAT',
  `data` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `override_rank` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `override_default` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `min_rank` int(11) DEFAULT 1,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for permission_ranks
-- ----------------------------
DROP TABLE IF EXISTS `permission_ranks`;
CREATE TABLE `permission_ranks`  (
  `fuse` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `min_rank` int(11) DEFAULT 1,
  `note` text CHARACTER SET latin1 COLLATE latin1_swedish_ci
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for pet_breeds
-- ----------------------------
DROP TABLE IF EXISTS `pet_breeds`;
CREATE TABLE `pet_breeds`  (
  `pet_type` int(11) NOT NULL DEFAULT 1,
  `pallet_id` int(11) NOT NULL DEFAULT 0,
  `level` enum('EPIC','RARE','UNCOMMON','COMMON') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'COMMON',
  PRIMARY KEY (`pet_type`, `pallet_id`) USING BTREE,
  INDEX `pet_type`(`pet_type`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for pet_data
-- ----------------------------
DROP TABLE IF EXISTS `pet_data`;
CREATE TABLE `pet_data`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner_id` int(11) NOT NULL DEFAULT 0,
  `room_id` int(11) DEFAULT 0,
  `pet_name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `race_id` int(11) DEFAULT 11,
  `type` int(11) DEFAULT NULL,
  `colour` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `scratches` int(11) NOT NULL DEFAULT 0,
  `level` int(11) NOT NULL DEFAULT 0,
  `happiness` int(11) NOT NULL DEFAULT 0,
  `experience` int(11) NOT NULL DEFAULT 0,
  `energy` int(11) NOT NULL DEFAULT 0,
  `hunger` int(11) NOT NULL DEFAULT 0,
  `x` int(11) DEFAULT 0,
  `y` int(11) DEFAULT 0,
  `saddled` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'false',
  `any_rider` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'false',
  `hair_style` int(11) DEFAULT -1,
  `hair_colour` int(11) DEFAULT 0,
  `birthday` int(11) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `owner_id`(`owner_id`) USING BTREE,
  INDEX `room_id`(`room_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 94 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for pet_messages
-- ----------------------------
DROP TABLE IF EXISTS `pet_messages`;
CREATE TABLE `pet_messages`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pet_type` int(11) NOT NULL DEFAULT 0,
  `message_type` enum('GENERIC','SCRATCHED','WELCOME_HOME','HUNGRY','TIRED','SLEEPING') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'GENERIC',
  `message_string` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Hiya %username%!!!',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for pet_races
-- ----------------------------
DROP TABLE IF EXISTS `pet_races`;
CREATE TABLE `pet_races`  (
  `race_id` int(255) DEFAULT NULL,
  `colour1` int(255) DEFAULT NULL,
  `colour2` int(255) DEFAULT NULL,
  `has1colour` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `has2colour` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for pet_transformable
-- ----------------------------
DROP TABLE IF EXISTS `pet_transformable`;
CREATE TABLE `pet_transformable`  (
  `name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `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.',
  PRIMARY KEY (`name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for player_access
-- ----------------------------
DROP TABLE IF EXISTS `player_access`;
CREATE TABLE `player_access`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` int(11) NOT NULL DEFAULT 0,
  `hardware_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `ip_address` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `timestamp` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `player_id_hardware_id_ip_address`(`player_id`, `hardware_id`, `ip_address`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6193 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for player_achievements
-- ----------------------------
DROP TABLE IF EXISTS `player_achievements`;
CREATE TABLE `player_achievements`  (
  `player_id` int(11) NOT NULL DEFAULT 0,
  `group` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `level` tinyint(4) NOT NULL DEFAULT 1,
  `progress` int(11) NOT NULL DEFAULT 0,
  UNIQUE INDEX `player_id_group`(`player_id`, `group`) USING BTREE,
  INDEX `player_id`(`player_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for player_badges
-- ----------------------------
DROP TABLE IF EXISTS `player_badges`;
CREATE TABLE `player_badges`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `player_id` int(11) UNSIGNED DEFAULT NULL,
  `badge_code` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `slot` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `user_id`(`player_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18756 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for player_clothing
-- ----------------------------
DROP TABLE IF EXISTS `player_clothing`;
CREATE TABLE `player_clothing`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` int(11) DEFAULT NULL,
  `item_name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `player_id`(`player_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for player_effects
-- ----------------------------
DROP TABLE IF EXISTS `player_effects`;
CREATE TABLE `player_effects`  (
  `player_id` int(11) NOT NULL,
  `effect_id` int(11) NOT NULL,
  PRIMARY KEY (`player_id`, `effect_id`) USING BTREE,
  INDEX `player_id`(`player_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for player_favourite_rooms
-- ----------------------------
DROP TABLE IF EXISTS `player_favourite_rooms`;
CREATE TABLE `player_favourite_rooms`  (
  `player_id` int(11) NOT NULL,
  `room_id` int(11) NOT NULL,
  PRIMARY KEY (`player_id`, `room_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for player_navigator_view_modes
-- ----------------------------
DROP TABLE IF EXISTS `player_navigator_view_modes`;
CREATE TABLE `player_navigator_view_modes`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` int(11) DEFAULT NULL,
  `category` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `view_mode` int(11) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `player_id_category`(`player_id`, `category`) USING BTREE,
  INDEX `player_id`(`player_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for player_photos
-- ----------------------------
DROP TABLE IF EXISTS `player_photos`;
CREATE TABLE `player_photos`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` int(11) DEFAULT NULL,
  `room_id` int(11) DEFAULT NULL,
  `photo` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `timestamp` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `photo`(`photo`) USING BTREE,
  INDEX `player_id`(`player_id`) USING BTREE,
  INDEX `room_id`(`room_id`) USING BTREE,
  INDEX `player_id_room_id`(`player_id`, `room_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for player_quest_progression
-- ----------------------------
DROP TABLE IF EXISTS `player_quest_progression`;
CREATE TABLE `player_quest_progression`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` int(11) DEFAULT 0,
  `quest_id` int(11) DEFAULT 0,
  `progress` int(11) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `player_id`(`player_id`) USING BTREE,
  INDEX `quest_id`(`quest_id`) USING BTREE,
  INDEX `playerId_questId`(`player_id`, `quest_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for player_recent_purchases
-- ----------------------------
DROP TABLE IF EXISTS `player_recent_purchases`;
CREATE TABLE `player_recent_purchases`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` int(11) NOT NULL DEFAULT 0,
  `catalog_item` int(11) NOT NULL DEFAULT 0,
  `amount` int(11) NOT NULL DEFAULT 0,
  `data` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `purchase_date` timestamp(0) NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `player_id`(`player_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22877 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for player_relationships
-- ----------------------------
DROP TABLE IF EXISTS `player_relationships`;
CREATE TABLE `player_relationships`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` int(11) DEFAULT NULL,
  `level` enum('bobba','smile','heart') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'smile',
  `partner` int(11) DEFAULT NULL,
  `accepted` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 466 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for player_room_visits
-- ----------------------------
DROP TABLE IF EXISTS `player_room_visits`;
CREATE TABLE `player_room_visits`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` int(11) NOT NULL DEFAULT 0,
  `room_id` int(11) NOT NULL DEFAULT 0,
  `time_enter` int(11) NOT NULL DEFAULT 0,
  `time_exit` int(11) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `player_id`(`player_id`) USING BTREE,
  INDEX `room_id`(`room_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31878 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for player_saved_searches
-- ----------------------------
DROP TABLE IF EXISTS `player_saved_searches`;
CREATE TABLE `player_saved_searches`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` int(11) DEFAULT 0,
  `view` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'myworld_view',
  `search_query` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `player_id`(`player_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for player_settings
-- ----------------------------
DROP TABLE IF EXISTS `player_settings`;
CREATE TABLE `player_settings`  (
  `player_id` int(10) NOT NULL DEFAULT 0,
  `allow_follow` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `volume` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `hide_online` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `hide_inroom` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `allow_friend_requests` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
  `allow_trade` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
  `home_room` int(11) DEFAULT 161,
  `wardrobe` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `playlist` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `chat_oldstyle` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `follow_friend_mode` enum('EVERYBODY','FRIENDS','NOBODY') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'EVERYBODY',
  `ignore_invites` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `allow_mimic` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
  `navigator_x` int(11) DEFAULT 68,
  `navigator_y` int(11) DEFAULT 42,
  `navigator_width` int(11) DEFAULT 425,
  `navigator_height` int(11) DEFAULT 592,
  `navigator_show_searches` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `ignore_events` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `disable_whisper` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `send_login_notif` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `mention_type` enum('ALL','FRIENDS','NONE') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'FRIENDS',
  `personalstaff` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  INDEX `avatar_setting`(`player_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for player_stats
-- ----------------------------
DROP TABLE IF EXISTS `player_stats`;
CREATE TABLE `player_stats`  (
  `player_id` int(10) NOT NULL DEFAULT 0,
  `achievement_score` int(10) DEFAULT 0,
  `total_respect_points` int(11) DEFAULT 0,
  `daily_respects` int(3) DEFAULT 3,
  `daily_scratches` int(3) DEFAULT 3,
  `help_tickets` int(11) DEFAULT 0,
  `cautions` int(11) DEFAULT 0,
  `help_tickets_abusive` int(11) DEFAULT 0,
  `bans` int(11) DEFAULT 0,
  `last_daily_update` int(11) DEFAULT 0,
  PRIMARY KEY (`player_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for player_subscriptions
-- ----------------------------
DROP TABLE IF EXISTS `player_subscriptions`;
CREATE TABLE `player_subscriptions`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'habbo_vip',
  `start` int(255) DEFAULT 0,
  `expire` int(255) DEFAULT 0,
  `user_id` int(11) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for players
-- ----------------------------
DROP TABLE IF EXISTS `players`;
CREATE TABLE `players`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_created` int(11) NOT NULL,
  `username` varchar(75) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'Avatar',
  `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',
  `motto` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'Sjovt',
  `credits` int(11) DEFAULT 50000,
  `vip_points` int(11) DEFAULT 0,
  `activity_points` int(11) NOT NULL DEFAULT 10,
  `seasonal_points` int(11) NOT NULL DEFAULT 0,
  `rank` int(3) DEFAULT 1,
  `auth_ticket` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `gender` enum('M','F') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'M',
  `reg_timestamp` int(11) NOT NULL DEFAULT 0,
  `reg_date` varchar(12) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '10/06/2019',
  `last_online` int(11) DEFAULT 0,
  `online` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `last_ip` varchar(72) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT '',
  `vip` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `achievement_points` int(11) DEFAULT 0,
  `favourite_group` int(11) DEFAULT 0,
  `chat_ticket` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `quest_id` int(11) DEFAULT 0,
  `time_muted` int(11) DEFAULT 0,
  `name_colour` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '000000',
  `cms_staffocult` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `cms_role` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `user_fondo` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '/app/assets/img/personal/bg_fondo.png',
  `user_referrals` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `cms_pin` enum('0','1','2') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `cms_stories` int(50) NOT NULL DEFAULT 0,
  `code_forgot` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `cms_forgot_time` int(11) NOT NULL DEFAULT 0,
  `public_stories` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `time_pass` int(11) NOT NULL DEFAULT 0,
  `pin_intentos` int(5) NOT NULL DEFAULT 3,
  `pin_time` int(11) NOT NULL DEFAULT 0,
  `pin_client` int(11) NOT NULL DEFAULT 0,
  `cuenta_suspendida` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `karma` int(11) DEFAULT 0,
  `prestige` int(11) DEFAULT 0,
  `ip_register` varchar(72) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `ip_current` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `tarea` varchar(300) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Sin tarea',
  `country` varchar(1000) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL DEFAULT '',
  `alfarango` enum('3','2','1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `mail` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `rank_2` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `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',
  `let_it_snow` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `profile_ads` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `chest_points` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `support_tickets_alert` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `fbid` int(11) DEFAULT NULL,
  `ip_last` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `respect` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `ip_reg` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `date_of_birth` datetime(0) DEFAULT NULL,
  `block_newfriends` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `block_trade` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `block_gift_alerts` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `block_push` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4586 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for playersettings
-- ----------------------------
DROP TABLE IF EXISTS `playersettings`;
CREATE TABLE `playersettings`  (
  `player_id` int(10) NOT NULL DEFAULT 0,
  `allow_follow` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `volume` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `hide_online` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `hide_inroom` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `allow_friend_requests` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
  `allow_trade` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
  `home_room` int(11) DEFAULT 63,
  `wardrobe` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `playlist` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `chat_oldstyle` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `follow_friend_mode` enum('EVERYBODY','FRIENDS','NOBODY') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'EVERYBODY',
  `ignore_invites` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `allow_mimic` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '1',
  `navigator_x` int(11) DEFAULT 68,
  `navigator_y` int(11) DEFAULT 42,
  `navigator_width` int(11) DEFAULT 425,
  `navigator_height` int(11) DEFAULT 592,
  `navigator_show_searches` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `ignore_events` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `disable_whisper` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `send_login_notif` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `mention_type` enum('ALL','FRIENDS','NONE') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'FRIENDS',
  `personalstaff` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  INDEX `avatar_setting`(`player_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for polls
-- ----------------------------
DROP TABLE IF EXISTS `polls`;
CREATE TABLE `polls`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Untitled Poll',
  `thanks_message` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Thanks!',
  `reward_badge` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'US8',
  `reward_credits` int(11) NOT NULL DEFAULT 0,
  `reward_vip_points` int(11) NOT NULL DEFAULT 0,
  `reward_activity_points` int(11) NOT NULL DEFAULT 0,
  `reward_achievement_points` int(11) NOT NULL DEFAULT 0,
  `room_id` int(11) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `room_id`(`room_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for polls_answers
-- ----------------------------
DROP TABLE IF EXISTS `polls_answers`;
CREATE TABLE `polls_answers`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `poll_id` int(11) DEFAULT 0,
  `question_id` int(11) DEFAULT 0,
  `player_id` int(11) DEFAULT 0,
  `answer` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `poll_id_question_id_player_id`(`poll_id`, `question_id`, `player_id`) USING BTREE,
  INDEX `player_id`(`player_id`) USING BTREE,
  INDEX `poll_id`(`poll_id`) USING BTREE,
  INDEX `poll_id_question_id`(`poll_id`, `question_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for polls_questions
-- ----------------------------
DROP TABLE IF EXISTS `polls_questions`;
CREATE TABLE `polls_questions`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `poll_id` int(11) NOT NULL,
  `question_type` enum('WORDED','MULTIPLE_CHOICE','SINGLE_CHOICE') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'WORDED',
  `question` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'What do you think of Comet Server?',
  `options` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `poll_id`(`poll_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for profile_wall
-- ----------------------------
DROP TABLE IF EXISTS `profile_wall`;
CREATE TABLE `profile_wall`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `titel` tinytext CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `message` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 4 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for quests
-- ----------------------------
DROP TABLE IF EXISTS `quests`;
CREATE TABLE `quests`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `category` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `series_number` int(11) NOT NULL DEFAULT 0,
  `goal_type` int(10) NOT NULL DEFAULT 0,
  `goal_data` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `reward` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '10',
  `badge_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `reward_type` enum('ACHIEVEMENT_POINTS','VIP_POINTS','ACTIVITY_POINTS','CREDITS','BADGE') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'ACTIVITY_POINTS',
  `data_bit` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `enabled` enum('1','0') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '1',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `nameUnique`(`name`) USING BTREE,
  INDEX `nameKey`(`name`) USING BTREE,
  INDEX `categoryKey`(`category`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ranks
-- ----------------------------
DROP TABLE IF EXISTS `ranks`;
CREATE TABLE `ranks`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `badgeid` varchar(5) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `title` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `tab_colour` enum('red','green','pixeldarkblue','orange','blue','settings','pixellightblue') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for referrer
-- ----------------------------
DROP TABLE IF EXISTS `referrer`;
CREATE TABLE `referrer`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` decimal(10, 0) DEFAULT NULL,
  `refid` decimal(10, 0) DEFAULT NULL,
  `diamonds` decimal(10, 0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for referrerbank
-- ----------------------------
DROP TABLE IF EXISTS `referrerbank`;
CREATE TABLE `referrerbank`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `diamonds` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for resetpassword
-- ----------------------------
DROP TABLE IF EXISTS `resetpassword`;
CREATE TABLE `resetpassword`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL,
  `resetkey` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `enable` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for room_bans
-- ----------------------------
DROP TABLE IF EXISTS `room_bans`;
CREATE TABLE `room_bans`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `room_id` int(11) NOT NULL DEFAULT 0,
  `player_id` int(11) NOT NULL DEFAULT 0,
  `expire_timestamp` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 103 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'latin1_swedish_ci' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for room_bundles
-- ----------------------------
DROP TABLE IF EXISTS `room_bundles`;
CREATE TABLE `room_bundles`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `enabled` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `alias` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'roombundle',
  `room_id` int(11) DEFAULT NULL,
  `model_data` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `bundle_data` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `cost_credits` int(11) DEFAULT 20,
  `cost_seasonal` int(11) DEFAULT 0,
  `cost_vip` int(11) DEFAULT 0,
  `room_config` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `cost_activity_points` int(11) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `alias`(`alias`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for room_models
-- ----------------------------
DROP TABLE IF EXISTS `room_models`;
CREATE TABLE `room_models`  (
  `id` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `door_x` int(11) NOT NULL,
  `door_y` int(11) NOT NULL,
  `door_z` double NOT NULL DEFAULT 0,
  `door_dir` int(4) NOT NULL DEFAULT 2,
  `heightmap` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `public_items` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `club_only` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `poolmap` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for room_rights
-- ----------------------------
DROP TABLE IF EXISTS `room_rights`;
CREATE TABLE `room_rights`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `player_id` int(10) DEFAULT 0,
  `room_id` int(10) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 269 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for room_word_filter
-- ----------------------------
DROP TABLE IF EXISTS `room_word_filter`;
CREATE TABLE `room_word_filter`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `room_id` int(11) NOT NULL DEFAULT 0,
  `word` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'bobba',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `room_id_word`(`room_id`, `word`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for rooms
-- ----------------------------
DROP TABLE IF EXISTS `rooms`;
CREATE TABLE `rooms`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` enum('PUBLIC','PRIVATE') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'PRIVATE',
  `owner_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL DEFAULT 0,
  `owner` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'John',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `tags` varchar(65) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `access_type` enum('password','doorbell','open','invisible') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'open',
  `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `category` int(10) NOT NULL DEFAULT 15,
  `max_users` int(11) NOT NULL DEFAULT 25,
  `score` int(11) NOT NULL DEFAULT 0,
  `model` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'model_a',
  `allow_pets` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
  `allow_pets_eating` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `allow_walkthrough` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
  `hide_walls` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `thickness_wall` int(11) NOT NULL DEFAULT 1,
  `thickness_floor` int(11) NOT NULL DEFAULT 1,
  `decorations` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'landscape=0.0',
  `heightmap` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `trade_state` enum('OWNER_ONLY','ENABLED','DISABLED') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'ENABLED',
  `mute_state` enum('NONE','RIGHTS') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'NONE',
  `kick_state` enum('NONE','RIGHTS','EVERYONE') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'RIGHTS',
  `ban_state` enum('NONE','RIGHTS') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'NONE',
  `bubble_mode` tinyint(3) NOT NULL DEFAULT 0,
  `bubble_type` tinyint(3) DEFAULT 0,
  `bubble_scroll` tinyint(3) NOT NULL DEFAULT 0,
  `chat_distance` tinyint(3) NOT NULL DEFAULT 0,
  `flood_level` tinyint(3) NOT NULL DEFAULT 0,
  `disabled_commands` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
  `required_badge` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `thumbnail` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'navigator-thumbnail/default.png',
  `users_now` int(11) DEFAULT 0,
  `hide_wired` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0',
  `allow_recount` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `owner_id`(`id`, `owner_id`) USING BTREE,
  INDEX `name`(`name`) USING BTREE,
  INDEX `tags`(`tags`) USING BTREE,
  INDEX `score`(`score`) USING BTREE,
  INDEX `category`(`category`) USING BTREE,
  INDEX `type`(`type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1723 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for rooms_promoted
-- ----------------------------
DROP TABLE IF EXISTS `rooms_promoted`;
CREATE TABLE `rooms_promoted`  (
  `room_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `description` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `time_start` int(11) DEFAULT NULL,
  `time_expire` int(11) DEFAULT NULL,
  PRIMARY KEY (`room_id`) USING BTREE,
  INDEX `expire`(`time_expire`) USING BTREE,
  INDEX `room_id`(`room_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for server_articles
-- ----------------------------
DROP TABLE IF EXISTS `server_articles`;
CREATE TABLE `server_articles`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `message` varchar(512) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `button_text` varchar(35) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `button_link` varchar(512) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `image_path` varchar(35) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `visible` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for server_config
-- ----------------------------
DROP TABLE IF EXISTS `server_config`;
CREATE TABLE `server_config`  (
  `key` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `value` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  PRIMARY KEY (`key`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for server_configuration
-- ----------------------------
DROP TABLE IF EXISTS `server_configuration`;
CREATE TABLE `server_configuration`  (
  `motd_enabled` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'true',
  `motd_message` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Welcome to Comet!',
  `hotel_name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Comet',
  `hotel_url` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `group_cost` int(11) NOT NULL DEFAULT 100,
  `online_reward_enabled` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'true',
  `online_reward_interval` int(11) NOT NULL DEFAULT 15,
  `online_reward_credits` int(11) NOT NULL DEFAULT 150,
  `online_reward_duckets` int(11) NOT NULL DEFAULT 150,
  `about_image` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `about_show_players_online` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
  `about_show_rooms_active` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
  `about_show_uptime` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
  `floor_editor_max_x` int(11) NOT NULL DEFAULT 0,
  `floor_editor_max_y` int(11) NOT NULL DEFAULT 0,
  `floor_editor_max_total` int(11) NOT NULL DEFAULT 0,
  `room_max_players` int(11) NOT NULL DEFAULT 150,
  `room_encrypt_passwords` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
  `room_can_place_item_on_entity` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
  `room_max_bots` int(11) NOT NULL DEFAULT 15,
  `room_max_pets` int(11) NOT NULL DEFAULT 15,
  `room_wired_reward_minimum_rank` int(11) NOT NULL DEFAULT 7,
  `room_wired_max_effects` int(11) NOT NULL DEFAULT 10,
  `room_wired_max_triggers` int(11) NOT NULL DEFAULT 10,
  `room_wired_max_execute_stacks` int(11) NOT NULL DEFAULT 5,
  `room_idle_minutes` int(11) NOT NULL DEFAULT 15,
  `word_filter_mode` enum('default','smart','strict') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'default',
  `word_filter_strict_chars` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `use_database_ip` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
  `save_logins` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
  `player_infinite_balance` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
  `player_gift_cooldown` int(11) NOT NULL DEFAULT 30,
  `player_change_figure_cooldown` int(11) NOT NULL DEFAULT 5,
  `player_figure_validation` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
  `messenger_max_friends` int(11) NOT NULL DEFAULT 1500,
  `messenger_log_messages` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'true',
  `storage_item_queue_enabled` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'true',
  `storage_player_queue_enabled` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'true',
  `camera_photo_upload_url` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'http://localhost/photos/photos/%photoId%.png',
  `camera_photo_itemid` int(11) NOT NULL DEFAULT 50001,
  `camera_photo_url` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'http://localhost/photos/photos/%photoId%.png',
  `max_connections_per_ip` int(11) NOT NULL DEFAULT 5,
  `max_connections_block_suspicious` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'true',
  `log_catalog_purchases` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'true',
  `group_chat_enabled` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
  `hall_of_fame_enabled` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'true',
  `hall_of_fame_currency` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'vip_points',
  `hall_of_fame_refresh_minutes` int(10) NOT NULL DEFAULT 10,
  `hall_of_fame_texts_key` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'halloffame',
  `aaaa` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'halloffame',
  `online_reward_diamonds_interval` int(11) NOT NULL DEFAULT 15,
  `online_reward_diamonds` int(11) NOT NULL DEFAULT 5,
  `online_reward_double_days` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT ''
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for server_locale
-- ----------------------------
DROP TABLE IF EXISTS `server_locale`;
CREATE TABLE `server_locale`  (
  `key` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `value` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  PRIMARY KEY (`key`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for server_permissions_ranks
-- ----------------------------
DROP TABLE IF EXISTS `server_permissions_ranks`;
CREATE TABLE `server_permissions_ranks`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `flood_bypass` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `flood_time` int(11) NOT NULL DEFAULT 30,
  `disconnectable` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `mod_tool` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `bannable` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `room_kickable` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `room_full_control` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `room_mute_bypass` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `room_filter_bypass` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `room_ignorable` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `room_enter_full` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `room_enter_locked` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `room_staff_pick` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `room_see_whispers` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `messenger_staff_chat` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `messenger_max_friends` int(11) NOT NULL DEFAULT 1100,
  `about_detailed` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `about_stats` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `messenger_log_chat` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `login_notif` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for server_ranks
-- ----------------------------
DROP TABLE IF EXISTS `server_ranks`;
CREATE TABLE `server_ranks`  (
  `rank_id` int(11) NOT NULL DEFAULT 1,
  `title` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Player',
  `badge_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'Player',
  `permission_mod_tool` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `permission_room_full_control` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `permission_bypass_filter` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `permission_room_unkickable` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `permission_unignorable` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `permission_room_staff_pick` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `messenger_log_chat` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `flood_length` int(11) DEFAULT 30,
  PRIMARY KEY (`rank_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for server_status
-- ----------------------------
DROP TABLE IF EXISTS `server_status`;
CREATE TABLE `server_status`  (
  `active_players` int(11) DEFAULT 0,
  `player_record` int(11) DEFAULT 0,
  `active_rooms` int(11) DEFAULT 0,
  `server_version` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `player_record_timestamp` int(11) DEFAULT 0
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for site_hotcampaigns
-- ----------------------------
DROP TABLE IF EXISTS `site_hotcampaigns`;
CREATE TABLE `site_hotcampaigns`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL DEFAULT 1,
  `enabled` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  `image_url` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `caption` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `descr` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `url` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for site_news
-- ----------------------------
DROP TABLE IF EXISTS `site_news`;
CREATE TABLE `site_news`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `seo_link` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'news-article',
  `title` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `category_id` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `topstory_image` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `body` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `snippet` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `datestr` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `timestamp` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `datestr`(`datestr`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sollicitaties
-- ----------------------------
DROP TABLE IF EXISTS `sollicitaties`;
CREATE TABLE `sollicitaties`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `naam` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `email` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `skype` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `leeftijd` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `rank` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `reden` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `ervaring` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for songs
-- ----------------------------
DROP TABLE IF EXISTS `songs`;
CREATE TABLE `songs`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `song_data` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `artist` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `creator_id` int(11) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for staff_logs
-- ----------------------------
DROP TABLE IF EXISTS `staff_logs`;
CREATE TABLE `staff_logs`  (
  `player_id` int(11) NOT NULL DEFAULT 0,
  `type` enum('ALERT','BAN','DISCONNECT','CHECK','NONE') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'NONE',
  `target` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `value` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `time` int(11) NOT NULL DEFAULT 0,
  INDEX `player_id`(`player_id`) USING BTREE,
  INDEX `target`(`target`) USING BTREE,
  INDEX `type`(`type`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for staffapplication
-- ----------------------------
DROP TABLE IF EXISTS `staffapplication`;
CREATE TABLE `staffapplication`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `realname` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `skype` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `age` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `functie` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `onlinetime` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `experience` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `quarrel` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `serious` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `improve` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `microphone` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `ip` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `date` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sterrenkopen
-- ----------------------------
DROP TABLE IF EXISTS `sterrenkopen`;
CREATE TABLE `sterrenkopen`  (
  `naam` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `datum` datetime(0) NOT NULL,
  `aantal` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `betaald` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'ja'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for support_ticket_replies
-- ----------------------------
DROP TABLE IF EXISTS `support_ticket_replies`;
CREATE TABLE `support_ticket_replies`  (
  `id` int(32) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ticket_id` mediumint(32) UNSIGNED NOT NULL,
  `text` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `u_id` int(11) UNSIGNED NOT NULL,
  `time` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7017 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for support_tickets
-- ----------------------------
DROP TABLE IF EXISTS `support_tickets`;
CREATE TABLE `support_tickets`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `state` int(11) NOT NULL DEFAULT 0,
  `type` int(2) NOT NULL DEFAULT 1,
  `timestamp` int(11) NOT NULL DEFAULT 0,
  `score` int(11) NOT NULL DEFAULT 0,
  `sender_id` int(11) NOT NULL DEFAULT 0,
  `reported_id` int(11) NOT NULL DEFAULT 0,
  `room_id` int(11) NOT NULL DEFAULT 0,
  `mod_id` int(11) NOT NULL DEFAULT 0,
  `issue` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `category` int(3) NOT NULL DEFAULT 0,
  `group_id` int(11) NOT NULL,
  `thread_id` int(11) NOT NULL,
  `comment_id` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1650 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for support_ticketscenter
-- ----------------------------
DROP TABLE IF EXISTS `support_ticketscenter`;
CREATE TABLE `support_ticketscenter`  (
  `id` mediumint(32) UNSIGNED NOT NULL AUTO_INCREMENT,
  `category` tinyint(2) UNSIGNED NOT NULL,
  `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `text` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `u_id` int(11) UNSIGNED NOT NULL,
  `replies` smallint(10) UNSIGNED NOT NULL DEFAULT 0,
  `time` int(10) UNSIGNED NOT NULL,
  `closed` tinyint(1) NOT NULL DEFAULT 0,
  `min_rank` tinyint(1) NOT NULL DEFAULT 7,
  `extra_id` int(11) NOT NULL DEFAULT 0,
  `report_type` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2780 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for teamapplication
-- ----------------------------
DROP TABLE IF EXISTS `teamapplication`;
CREATE TABLE `teamapplication`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `realname` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `skype` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `age` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `functie` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `onlinetime` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `experience` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `quarrel` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `serious` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `improve` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `microphone` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `ip` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `date` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for teams
-- ----------------------------
DROP TABLE IF EXISTS `teams`;
CREATE TABLE `teams`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `badgeid` varchar(5) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for uotw
-- ----------------------------
DROP TABLE IF EXISTS `uotw`;
CREATE TABLE `uotw`  (
  `userid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `userid2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `userid3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for user_profile
-- ----------------------------
DROP TABLE IF EXISTS `user_profile`;
CREATE TABLE `user_profile`  (
  `u_id` int(11) UNSIGNED NOT NULL,
  `link_style` tinyint(1) NOT NULL DEFAULT 1,
  `avatar_img` varchar(140) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `cover_img` varchar(140) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `about_text` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `page_views` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `youtube_id` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `gb_posts` mediumint(10) UNSIGNED NOT NULL DEFAULT 0,
  `gb_limit` mediumint(10) UNSIGNED NOT NULL DEFAULT 999999,
  `profile_city` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `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\";}',
  PRIMARY KEY (`u_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for user_profile_gb
-- ----------------------------
DROP TABLE IF EXISTS `user_profile_gb`;
CREATE TABLE `user_profile_gb`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `u_id` int(11) UNSIGNED NOT NULL,
  `author` int(11) UNSIGNED NOT NULL,
  `text` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `time` int(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `u_id`(`u_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3875 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for user_session_log
-- ----------------------------
DROP TABLE IF EXISTS `user_session_log`;
CREATE TABLE `user_session_log`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `browser` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for users_like
-- ----------------------------
DROP TABLE IF EXISTS `users_like`;
CREATE TABLE `users_like`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `likefrom` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for vouchers
-- ----------------------------
DROP TABLE IF EXISTS `vouchers`;
CREATE TABLE `vouchers`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` enum('COINS','DUCKETS','VIP_POINTS','ROOM_BUNDLE') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'COINS',
  `data` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` int(11) NOT NULL DEFAULT 0,
  `claimed_by` int(11) NOT NULL DEFAULT 0,
  `claimed_at` int(11) NOT NULL DEFAULT 0,
  `status` enum('UNCLAIMED','CLAIMED') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'UNCLAIMED',
  `code` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'voucher-00001',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `code`(`code`) USING BTREE,
  INDEX `created_by`(`created_by`) USING BTREE,
  INDEX `claimed_by`(`claimed_by`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for website_articles
-- ----------------------------
DROP TABLE IF EXISTS `website_articles`;
CREATE TABLE `website_articles`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `article_slug` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `article_title` varchar(96) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `article_description` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `article_body` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `article_author` int(11) NOT NULL DEFAULT 0,
  `article_promo_image` varchar(96) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `article_allow_comments` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'false',
  `article_time_created` int(11) NOT NULL DEFAULT 0,
  `article_hidden` enum('true','false') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'false',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `article_slug`(`article_slug`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for website_config
-- ----------------------------
DROP TABLE IF EXISTS `website_config`;
CREATE TABLE `website_config`  (
  `hotel_name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'Comet',
  `hotel_slogan` varchar(96) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'Comet',
  `hotel_description` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `twitter_username` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'habbo',
  `facebook_username` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'habbo',
  `twitter_widget_id` int(11) DEFAULT 0,
  `player_default_credits` int(11) DEFAULT 0,
  `player_default_activity_points` int(11) DEFAULT 0,
  `player_default_vip_points` int(11) DEFAULT 0,
  `player_default_figure` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `player_default_motto` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `player_default_homeroom` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `game_host` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `game_port` int(5) DEFAULT NULL,
  `game_client_swf` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `game_client_variables` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `game_client_texts` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `game_client_productdata` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `game_client_furnidata` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `game_client_base` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `game_client_banner` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT ''
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for website_gamedata_texts
-- ----------------------------
DROP TABLE IF EXISTS `website_gamedata_texts`;
CREATE TABLE `website_gamedata_texts`  (
  `key` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `value` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`key`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for website_gamedata_variables
-- ----------------------------
DROP TABLE IF EXISTS `website_gamedata_variables`;
CREATE TABLE `website_gamedata_variables`  (
  `key` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `value` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  PRIMARY KEY (`key`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for website_news
-- ----------------------------
DROP TABLE IF EXISTS `website_news`;
CREATE TABLE `website_news`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `title` varchar(96) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `description` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  `body` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `images` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `author` int(11) NOT NULL DEFAULT 0,
  `header` varchar(96) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `timestamp` int(11) NOT NULL DEFAULT 0,
  `hidden` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for wordfilter
-- ----------------------------
DROP TABLE IF EXISTS `wordfilter`;
CREATE TABLE `wordfilter`  (
  `word` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `replacement` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'blacklist'
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for wordfilter_characters
-- ----------------------------
DROP TABLE IF EXISTS `wordfilter_characters`;
CREATE TABLE `wordfilter_characters`  (
  `character` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `replacement` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT ''
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;