[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEY_BLOCK_SIZE=16;
DROP TABLE IF EXISTS `house_object_cooldowns`;
CREATE TAB' at line 7
[Err] -- ----------------------------
-- Table structure for `blocks`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `blocks` (
`player` int(11) NOT NULL,
`blocked_player` int(11) NOT NULL,
`reason` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`player`,`blocked_player`),
FOREIGN KEY (`player`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (`blocked_player`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `player_settings`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `player_settings` (
`player_id` int(11) NOT NULL,
`settings_type` tinyint(1) NOT NULL,
`settings` BLOB NOT NULL,
PRIMARY KEY (`player_id`, `settings_type`),
CONSTRAINT `ps_pl_fk` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `player_skills`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `player_skills` (
`player_id` int(11) NOT NULL,
`skill_id` int(11) NOT NULL,
`skill_level` int(3) NOT NULL default '1',
PRIMARY KEY (`player_id`,`skill_id`),
FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `inventory`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `inventory` (
`item_unique_id` int(11) NOT NULL,
`item_id` int(11) NOT NULL,
`item_count` bigint(20) NOT NULL DEFAULT '0',
`item_color` int(11) NOT NULL DEFAULT '0',
`color_expires` int(11) NOT NULL DEFAULT '0',
`item_creator` varchar(50),
`expire_time` int(11) NOT NULL DEFAULT '0',
`activation_count` int(11) NOT NULL DEFAULT '0',
`item_owner` int(11) NOT NULL,
`is_equiped` TINYINT(1) NOT NULL DEFAULT '0',
`is_soul_bound` TINYINT(1) NOT NULL DEFAULT '0',
`slot` bigint(20) NOT NULL DEFAULT '0',
`item_location` TINYINT(1) DEFAULT '0',
`enchant` TINYINT(1) DEFAULT '0',
`item_skin` int(11) NOT NULL DEFAULT 0,
`fusioned_item` INT(11) NOT NULL DEFAULT '0',
`optional_socket` INT(1) NOT NULL DEFAULT '0',
`optional_fusion_socket` INT(1) NOT NULL DEFAULT '0',
`charge` MEDIUMINT NOT NULL DEFAULT '0',
`rnd_bonus` smallint(6) DEFAULT NULL,
`rnd_count` smallint(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`item_unique_id`),
INDEX `item_location` USING HASH (`item_location`),
INDEX `index3` (`item_owner`, `item_location`, `is_equiped`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `item_stones`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `item_stones` (
`item_unique_id` int(11) NOT NULL,
`item_id` int(11) NOT NULL,
`slot` int(2) NOT NULL,
`category` int(2) NOT NULL default 0,
`polishNumber` int(11) NOT NULL,
`polishCharge` int(11) NOT NULL,
PRIMARY KEY (`item_unique_id`, `slot`, `category`),
FOREIGN KEY (`item_unique_id`) references inventory (`item_unique_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `player_quests`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `player_quests` (
`player_id` int(11) NOT NULL,
`quest_id` int(10) unsigned NOT NULL default '0',
`status` varchar(10) NOT NULL default 'NONE',
`quest_vars` int(10) unsigned NOT NULL default '0',
`complete_count` int(3) unsigned NOT NULL default '0',
`next_repeat_time` timestamp NULL default NULL,
`reward` smallint(3) NULL,
`complete_time` TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (`player_id`,`quest_id`),
FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `player_npc_factions`
-- ----------------------------
CREATE TABLE IF
[Msg] Finished - Unsuccessfully
--------------------------------------------------
