DROP TABLE IF EXISTS `wz_itemdata`;
CREATE TABLE `wz_itemdata` (
`itemid` int(11) NOT NULL,
`name` tinytext,
`msg` varchar(4096) DEFAULT NULL,
`desc` varchar(4096) DEFAULT NULL,
`slotMax` smallint(5) NOT NULL DEFAULT '1',
`price` varchar(255) NOT NULL DEFAULT '-1.0',
`wholePrice` int(11) NOT NULL DEFAULT '-1',
`stateChange` int(11) NOT NULL DEFAULT '0',
`flags` smallint(4) NOT NULL DEFAULT '0',
`karma` tinyint(1) NOT NULL DEFAULT '0',
`meso` int(11) NOT NULL DEFAULT '0',
`monsterBook` int(11) NOT NULL DEFAULT '0',
`itemMakeLevel` smallint(6) NOT NULL DEFAULT '0',
`questId` int(11) NOT NULL DEFAULT '0',
`scrollReqs` tinytext,
`consumeItem` tinytext,
`totalprob` int(11) NOT NULL DEFAULT '0',
`incSkill` varchar(255) NOT NULL DEFAULT '',
`replaceid` int(11) NOT NULL DEFAULT '0',
`replacemsg` varchar(255) NOT NULL DEFAULT '',
`create` int(11) NOT NULL DEFAULT '0',
`afterImage` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`itemid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `wz_mobskilldata`;
CREATE TABLE `wz_mobskilldata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`skillid` int(11) NOT NULL,
`level` int(11) NOT NULL,
`hp` int(11) NOT NULL DEFAULT '100',
`mpcon` int(11) NOT NULL DEFAULT '0',
`x` int(11) NOT NULL DEFAULT '1',
`y` int(11) NOT NULL DEFAULT '1',
`time` int(11) NOT NULL DEFAULT '0',
`prop` int(11) NOT NULL DEFAULT '100',
`limit` int(11) NOT NULL DEFAULT '0',
`spawneffect` int(11) NOT NULL DEFAULT '0',
`interval` int(11) NOT NULL DEFAULT '0',
`summons` varchar(1024) NOT NULL DEFAULT '',
`ltx` int(11) NOT NULL DEFAULT '0',
`lty` int(11) NOT NULL DEFAULT '0',
`rbx` int(11) NOT NULL DEFAULT '0',
`rby` int(11) NOT NULL DEFAULT '0',
`once` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=789 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `wz_oxdata`;
CREATE TABLE `wz_oxdata` (
`questionset` smallint(6) NOT NULL DEFAULT '0',
`questionid` smallint(6) NOT NULL DEFAULT '0',
`question` varchar(200) NOT NULL DEFAULT '',
`display` varchar(200) NOT NULL DEFAULT '',
`answer` enum('o','x') NOT NULL,
PRIMARY KEY (`questionset`,`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `wz_questdata`;
CREATE TABLE `wz_questdata` (
`questid` int(11) NOT NULL,
`name` varchar(1024) NOT NULL DEFAULT '',
`autoStart` tinyint(1) NOT NULL DEFAULT '0',
`autoPreComplete` tinyint(1) NOT NULL DEFAULT '0',
`viewMedalItem` int(11) NOT NULL DEFAULT '0',
`selectedSkillID` int(11) NOT NULL DEFAULT '0',
`blocked` tinyint(1) NOT NULL DEFAULT '0',
`autoAccept` tinyint(1) NOT NULL DEFAULT '0',
`autoComplete` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`questid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;