/*!40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET [USER=1333464006]old[/USER]_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET [USER=1333464006]old[/USER]_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET [USER=1333464006]old[/USER]_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET [USER=1333464006]old[/USER]_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
CREATE DATABASE IF NOT EXISTS ascension;
USE ascension;
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(13) NOT NULL DEFAULT '',
`password` varchar(128) NOT NULL DEFAULT '',
`salt` varchar(32) DEFAULT NULL,
`2ndpassword` varchar(134) DEFAULT NULL,
`salt2` varchar(32) DEFAULT NULL,
`loggedin` tinyint(1) unsigned NOT NULL DEFAULT '0',
`lastlogin` timestamp NULL DEFAULT NULL,
`createdat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`birthday` date NOT NULL DEFAULT '0000-00-00',
`banned` tinyint(1) NOT NULL DEFAULT '0',
`banreason` text,
`gm` tinyint(1) NOT NULL DEFAULT '0',
`email` tinytext,
`macs` tinytext,
`tempban` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`greason` tinyint(4) unsigned DEFAULT NULL,
`ACash` int(11) NOT NULL DEFAULT '0',
`mPoints` int(11) NOT NULL DEFAULT '0',
`gender` tinyint(1) unsigned NOT NULL DEFAULT '0',
`SessionIP` varchar(64) DEFAULT NULL,
`points` int(11) NOT NULL DEFAULT '0',
`vpoints` int(11) NOT NULL DEFAULT '0',
`monthvotes` int(11) NOT NULL DEFAULT '0',
`totalvotes` int(11) NOT NULL DEFAULT '0',
`lastvote` int(11) NOT NULL DEFAULT '0',
`lastvote2` int(11) NOT NULL DEFAULT '0',
`lastlogon` timestamp NULL DEFAULT NULL,
`lastvoteip` varchar(64) DEFAULT NULL,
`webadmin` int(1) DEFAULT '0',
`rebirths` int(11) NOT NULL DEFAULT '0',
`ip` text,
`mainchar` int(6) NOT NULL DEFAULT '0',
`nxcredit` int(11) unsigned NOT NULL DEFAULT '0',
`nxprepaid` int(11) unsigned NOT NULL DEFAULT '0',
`redeemhn` int(11) unsigned NOT NULL DEFAULT '0',
`tos` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `ranking1` (`id`,`banned`,`gm`),
KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `achievements`;
CREATE TABLE `achievements` (
`achievementid` int(9) NOT NULL DEFAULT '0',
`charid` int(9) NOT NULL DEFAULT '0',
`accountid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`achievementid`,`charid`),
KEY `achievementid` (`achievementid`),
KEY `accountid` (`accountid`),
KEY `charid` (`charid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `alliances`;
CREATE TABLE `alliances` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(13) NOT NULL,
`leaderid` int(11) NOT NULL,
`guild1` int(11) NOT NULL,
`guild2` int(11) NOT NULL,
`guild3` int(11) NOT NULL DEFAULT '0',
`guild4` int(11) NOT NULL DEFAULT '0',
`guild5` int(11) NOT NULL DEFAULT '0',
`rank1` varchar(13) NOT NULL DEFAULT 'Master',
`rank2` varchar(13) NOT NULL DEFAULT 'Jr.Master',
`rank3` varchar(13) NOT NULL DEFAULT 'Member',
`rank4` varchar(13) NOT NULL DEFAULT 'Member',
`rank5` varchar(13) NOT NULL DEFAULT 'Member',
`capacity` int(11) NOT NULL DEFAULT '2',
`notice` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `id` (`id`),
KEY `leaderid` (`leaderid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `androids`;
CREATE TABLE `androids` (
`uniqueid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(13) NOT NULL DEFAULT 'Android',
`hair` int(11) NOT NULL DEFAULT '0',
`face` int(11) NOT NULL DEFAULT '0',
`skin` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`uniqueid`),
KEY `uniqueid` (`uniqueid`)
) ENGINE=InnoDB AUTO_INCREMENT=511 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `asc_news`;
CREATE TABLE `asc_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`msg` varchar(100) NOT NULL,
`date` varchar(8) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `auth_server_channel_ip`;
CREATE TABLE `auth_server_channel_ip` (
`channelconfigid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`channelid` int(10) unsigned NOT NULL DEFAULT '0',
`name` tinytext NOT NULL,
`value` tinytext NOT NULL,
PRIMARY KEY (`channelconfigid`),
KEY `channelid` (`channelid`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `battlelog`;
CREATE TABLE `battlelog` (
`battlelogid` int(11) NOT NULL AUTO_INCREMENT,
`accid` int(11) NOT NULL DEFAULT '0',
`accid_to` int(11) NOT NULL DEFAULT '0',
`when` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`battlelogid`),
KEY `accid` (`accid`),
CONSTRAINT `battlelog_ibfk_1` FOREIGN KEY (`accid`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `bbs_replies`;
CREATE TABLE `bbs_replies` (
`replyid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`threadid` int(10) unsigned NOT NULL,
`postercid` int(10) unsigned NOT NULL,
`timestamp` bigint(20) unsigned NOT NULL,
`content` varchar(26) NOT NULL DEFAULT '',
`guildid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`replyid`)
) ENGINE=InnoDB AUTO_INCREMENT=1335 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `bbs_threads`;
CREATE TABLE `bbs_threads` (
`threadid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`postercid` int(10) unsigned NOT NULL,
`name` varchar(26) NOT NULL DEFAULT '',
`timestamp` bigint(20) unsigned NOT NULL,
`icon` smallint(5) unsigned NOT NULL,
`startpost` text NOT NULL,
`guildid` int(10) unsigned NOT NULL,
`localthreadid` int(10) unsigned NOT NULL,
PRIMARY KEY (`threadid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `buddies`;
CREATE TABLE `buddies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL,
`buddyid` int(11) NOT NULL,
`pending` tinyint(4) NOT NULL DEFAULT '0',
`groupname` varchar(16) NOT NULL DEFAULT 'ETC',
PRIMARY KEY (`id`),
KEY `buddies_ibfk_1` (`characterid`),
KEY `buddyid` (`buddyid`),
KEY `id` (`id`),
CONSTRAINT `buddies_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5780 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `cashshop_limit_sell`;
CREATE TABLE `cashshop_limit_sell` (
`serial` int(11) NOT NULL,
`amount` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`serial`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `cashshop_modified_items`;
CREATE TABLE `cashshop_modified_items` (
`serial` int(11) NOT NULL,
`discount_price` int(11) NOT NULL DEFAULT '-1',
`mark` tinyint(1) NOT NULL DEFAULT '-1',
`showup` tinyint(1) NOT NULL DEFAULT '0',
`itemid` int(11) NOT NULL DEFAULT '0',
`priority` tinyint(3) NOT NULL DEFAULT '0',
`package` tinyint(1) NOT NULL DEFAULT '0',
`period` tinyint(3) NOT NULL DEFAULT '0',
`gender` tinyint(1) NOT NULL DEFAULT '0',
`count` tinyint(3) NOT NULL DEFAULT '0',
`meso` int(11) NOT NULL DEFAULT '0',
`unk_1` tinyint(1) NOT NULL DEFAULT '0',
`unk_2` tinyint(1) NOT NULL DEFAULT '0',
`unk_3` tinyint(1) NOT NULL DEFAULT '0',
`extra_flags` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`serial`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `character_cards`;
CREATE TABLE `character_cards` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`accid` int(11) NOT NULL,
`worldid` int(11) NOT NULL,
`characterid` int(11) NOT NULL,
`position` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `character_slots`;
CREATE TABLE `character_slots` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`accid` int(11) NOT NULL DEFAULT '0',
`worldid` int(11) NOT NULL DEFAULT '0',
`charslots` int(11) NOT NULL DEFAULT '6',
PRIMARY KEY (`id`),
KEY `accid` (`accid`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `characters`;
CREATE TABLE `characters` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`accountid` int(11) NOT NULL DEFAULT '0',
`world` tinyint(1) NOT NULL DEFAULT '0',
`name` varchar(18) NOT NULL,
`level` int(3) unsigned NOT NULL DEFAULT '0',
`exp` int(11) NOT NULL DEFAULT '0',
`str` int(5) NOT NULL DEFAULT '0',
`dex` int(5) NOT NULL DEFAULT '0',
`luk` int(5) NOT NULL DEFAULT '0',
`int` int(5) NOT NULL DEFAULT '0',
`hp` int(5) NOT NULL DEFAULT '0',
`mp` int(5) NOT NULL DEFAULT '0',
`maxhp` int(5) NOT NULL DEFAULT '0',
`maxmp` int(5) NOT NULL DEFAULT '0',
`meso` int(11) NOT NULL DEFAULT '0',
`hpApUsed` int(5) NOT NULL DEFAULT '0',
`job` int(5) NOT NULL DEFAULT '0',
`skincolor` tinyint(1) NOT NULL DEFAULT '0',
`gender` tinyint(1) NOT NULL DEFAULT '0',
`fame` int(5) NOT NULL DEFAULT '0',
`hair` int(11) NOT NULL DEFAULT '0',
`face` int(11) unsigned NOT NULL DEFAULT '0',
`demonMarking` int(11) NOT NULL DEFAULT '0',
`ap` int(11) NOT NULL DEFAULT '0',
`map` int(11) NOT NULL DEFAULT '0',
`spawnpoint` int(3) NOT NULL DEFAULT '0',
`gm` int(3) NOT NULL DEFAULT '0',
`party` int(11) NOT NULL DEFAULT '0',
`buddyCapacity` int(11) NOT NULL DEFAULT '25',
`createdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`guildid` int(10) unsigned NOT NULL DEFAULT '0',
`guildrank` tinyint(1) unsigned NOT NULL DEFAULT '5',
`allianceRank` tinyint(1) unsigned NOT NULL DEFAULT '5',
`guildContribution` int(11) NOT NULL DEFAULT '0',
`pets` varchar(13) NOT NULL DEFAULT '-1,-1,-1',
`sp` varchar(255) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0',
`subcategory` int(11) NOT NULL DEFAULT '0',
`rank` int(11) NOT NULL DEFAULT '1',
`rankMove` int(11) NOT NULL DEFAULT '0',
`jobRank` int(11) NOT NULL DEFAULT '1',
`jobRankMove` int(11) NOT NULL DEFAULT '0',
`marriageId` int(11) NOT NULL DEFAULT '0',
`familyid` int(11) NOT NULL DEFAULT '0',
`seniorid` int(11) NOT NULL DEFAULT '0',
`junior1` int(11) NOT NULL DEFAULT '0',
`junior2` int(11) NOT NULL DEFAULT '0',
`currentrep` int(11) NOT NULL DEFAULT '0',
`totalrep` int(11) NOT NULL DEFAULT '0',
`gachexp` int(11) NOT NULL DEFAULT '0',
`fatigue` tinyint(4) NOT NULL DEFAULT '0',
`charm` mediumint(7) NOT NULL DEFAULT '0',
`craft` mediumint(7) NOT NULL DEFAULT '0',
`charisma` mediumint(7) NOT NULL DEFAULT '0',
`will` mediumint(7) NOT NULL DEFAULT '0',
`sense` mediumint(7) NOT NULL DEFAULT '0',
`insight` mediumint(7) NOT NULL DEFAULT '0',
`honourExp` int(10) unsigned NOT NULL DEFAULT '0',
`honourLevel` int(10) unsigned NOT NULL DEFAULT '1',
`damage` int(11) NOT NULL DEFAULT '0',
`showdamage` int(11) DEFAULT '1',
`totalWins` int(11) NOT NULL DEFAULT '0',
`totalLosses` int(11) NOT NULL DEFAULT '0',
`pvpExp` int(11) NOT NULL DEFAULT '0',
`pvpPoints` int(11) NOT NULL DEFAULT '0',
`rebirths` int(11) NOT NULL DEFAULT '0',
`prefix` varchar(45) DEFAULT NULL,
`reborns` int(11) NOT NULL DEFAULT '0',
`apstorage` int(11) NOT NULL DEFAULT '0',
`donatorPoints` int(11) NOT NULL DEFAULT '0',
`gmtext` int(11) NOT NULL DEFAULT '0',
`occupationId` int(11) unsigned NOT NULL DEFAULT '1',
`occupationExp` int(11) unsigned NOT NULL DEFAULT '0',
`occupationLevel` int(11) unsigned NOT NULL DEFAULT '1',
`charToggle` int(11) unsigned NOT NULL DEFAULT '0',
`jqlevel` int(11) unsigned NOT NULL DEFAULT '1',
`jqexp` int(11) unsigned NOT NULL DEFAULT '0',
`pvpKills` int(11) unsigned NOT NULL DEFAULT '1',
`pvpDeaths` int(11) unsigned NOT NULL DEFAULT '1',
`fametoggle` int(11) unsigned NOT NULL DEFAULT '0',
`dps` bigint(20) unsigned NOT NULL DEFAULT '0',
`msipoints` int(11) unsigned NOT NULL DEFAULT '0',
`muted` tinyint(1) unsigned NOT NULL DEFAULT '0',
`unmutetime` bigint(20) unsigned NOT NULL DEFAULT '0',
`dgm` int(11) unsigned NOT NULL DEFAULT '0',
`gml` int(11) unsigned NOT NULL DEFAULT '0',
`noacc` int(11) unsigned NOT NULL DEFAULT '0',
`location` int(11) unsigned NOT NULL DEFAULT '0',
`birthday` int(11) unsigned NOT NULL DEFAULT '0',
`found` int(11) unsigned NOT NULL DEFAULT '0',
`todo` int(11) unsigned NOT NULL DEFAULT '0',
`autobuff` int(11) unsigned NOT NULL DEFAULT '0',
`autoap` int(11) unsigned NOT NULL DEFAULT '0',
`autotoken` int(11) unsigned NOT NULL DEFAULT '0',
`elf` int(11) unsigned NOT NULL DEFAULT '0',
`clanid` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `accountid` (`accountid`),
KEY `id` (`id`),
KEY `guildid` (`guildid`),
KEY `familyid` (`familyid`),
KEY `marriageId` (`marriageId`),
KEY `seniorid` (`seniorid`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `cheatlog`;
CREATE TABLE `cheatlog` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(11) unsigned NOT NULL DEFAULT '0',
`offense` tinytext NOT NULL,
`count` int(11) unsigned NOT NULL DEFAULT '0',
`lastoffensetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`param` tinytext NOT NULL,
PRIMARY KEY (`id`),
KEY `cid` (`characterid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `chrimg`;
CREATE TABLE `chrimg` (
`id` int(11) NOT NULL,
`hash` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `clans`;
CREATE TABLE `clans` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(12) NOT NULL,
`level` int(11) NOT NULL,
`members` int(11) NOT NULL,
`wins` int(11) NOT NULL,
`message` varchar(40) NOT NULL,
`clantag` varchar(8) NOT NULL,
`leaderid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `compensationlog_confirmed`;
CREATE TABLE `compensationlog_confirmed` (
`chrname` varchar(25) NOT NULL DEFAULT '',
`donor` tinyint(1) NOT NULL DEFAULT '0',
`value` int(11) NOT NULL DEFAULT '0',
`taken` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`chrname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `csequipment`;
CREATE TABLE `csequipment` (
`inventoryequipmentid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`inventoryitemid` bigint(20) unsigned NOT NULL DEFAULT '0',
`upgradeslots` int(11) NOT NULL DEFAULT '0',
`level` int(11) NOT NULL DEFAULT '0',
`str` int(11) NOT NULL DEFAULT '0',
`dex` int(11) NOT NULL DEFAULT '0',
`int` int(11) NOT NULL DEFAULT '0',
`luk` int(11) NOT NULL DEFAULT '0',
`hp` int(11) NOT NULL DEFAULT '0',
`mp` int(11) NOT NULL DEFAULT '0',
`watk` int(11) NOT NULL DEFAULT '0',
`matk` int(11) NOT NULL DEFAULT '0',
`wdef` int(11) NOT NULL DEFAULT '0',
`mdef` int(11) NOT NULL DEFAULT '0',
`acc` int(11) NOT NULL DEFAULT '0',
`avoid` int(11) NOT NULL DEFAULT '0',
`hands` int(11) NOT NULL DEFAULT '0',
`speed` int(11) NOT NULL DEFAULT '0',
`jump` int(11) NOT NULL DEFAULT '0',
`ViciousHammer` tinyint(2) NOT NULL DEFAULT '0',
`itemEXP` int(11) NOT NULL DEFAULT '0',
`durability` int(11) NOT NULL DEFAULT '-1',
`enhance` tinyint(3) NOT NULL DEFAULT '0',
`potential1` int(5) NOT NULL DEFAULT '0',
`potential2` int(5) NOT NULL DEFAULT '0',
`potential3` int(5) NOT NULL DEFAULT '0',
`potential4` int(5) NOT NULL DEFAULT '0',
`potential5` int(5) NOT NULL DEFAULT '0',
`socket1` int(5) NOT NULL DEFAULT '-1',
`socket2` int(5) NOT NULL DEFAULT '-1',
`socket3` int(5) NOT NULL DEFAULT '-1',
`incSkill` int(11) NOT NULL DEFAULT '-1',
`charmEXP` smallint(6) NOT NULL DEFAULT '-1',
`pvpDamage` smallint(6) NOT NULL DEFAULT '0',
`equipLevel` int(11) unsigned NOT NULL DEFAULT '1',
`equipExp` int(11) unsigned NOT NULL DEFAULT '0',
`equipMSIUpgrades` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`inventoryequipmentid`),
KEY `inventoryitemid` (`inventoryitemid`),
CONSTRAINT `csequipment_ibfk_1` FOREIGN KEY (`inventoryitemid`) REFERENCES `csitems` (`inventoryitemid`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4500 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `csitems`;
CREATE TABLE `csitems` (
`inventoryitemid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(11) DEFAULT NULL,
`accountid` int(10) DEFAULT NULL,
`packageid` int(11) DEFAULT NULL,
`itemid` int(11) NOT NULL DEFAULT '0',
`inventorytype` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
`quantity` int(11) NOT NULL DEFAULT '0',
`owner` tinytext,
`GM_Log` tinytext,
`uniqueid` int(11) NOT NULL DEFAULT '-1',
`flag` int(2) NOT NULL DEFAULT '0',
`expiredate` bigint(20) NOT NULL DEFAULT '-1',
`type` tinyint(1) NOT NULL DEFAULT '0',
`sender` varchar(13) NOT NULL DEFAULT '',
PRIMARY KEY (`inventoryitemid`),
KEY `inventoryitems_ibfk_1` (`characterid`),
KEY `characterid` (`characterid`),
KEY `inventorytype` (`inventorytype`),
KEY `accountid` (`accountid`),
KEY `packageid` (`packageid`),
KEY `characterid_2` (`characterid`,`inventorytype`)
) ENGINE=InnoDB AUTO_INCREMENT=8379 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `dojo_ranks`;
CREATE TABLE `dojo_ranks` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(13) NOT NULL DEFAULT '',
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `donation`;
CREATE TABLE `donation` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`ip` varchar(255) NOT NULL DEFAULT '127.0.0.1',
`username` varchar(13) NOT NULL,
`quantity` smallint(5) DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `donorlog`;
CREATE TABLE `donorlog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`accname` varchar(25) NOT NULL DEFAULT '',
`accId` int(11) NOT NULL DEFAULT '0',
`chrname` varchar(25) NOT NULL DEFAULT '',
`chrId` int(11) NOT NULL DEFAULT '0',
`log` varchar(4096) NOT NULL DEFAULT '',
`time` varchar(25) NOT NULL DEFAULT '',
`previousPoints` int(11) NOT NULL DEFAULT '0',
`currentPoints` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `drop_data`;
CREATE TABLE `drop_data` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`dropperid` int(11) NOT NULL,
`itemid` int(11) NOT NULL DEFAULT '0',
`minimum_quantity` int(11) NOT NULL DEFAULT '1',
`maximum_quantity` int(11) NOT NULL DEFAULT '1',
`questid` int(11) NOT NULL DEFAULT '0',
`chance` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `mobid` (`dropperid`)
) ENGINE=MyISAM AUTO_INCREMENT=45195 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `drop_data_global`;
CREATE TABLE `drop_data_global` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`continent` int(11) NOT NULL,
`dropType` tinyint(1) NOT NULL DEFAULT '0',
`itemid` int(11) NOT NULL DEFAULT '0',
`minimum_quantity` int(11) NOT NULL DEFAULT '1',
`maximum_quantity` int(11) NOT NULL DEFAULT '1',
`questid` int(11) NOT NULL DEFAULT '0',
`chance` int(11) NOT NULL DEFAULT '0',
`comments` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `mobid` (`continent`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `dueyequipment`;
CREATE TABLE `dueyequipment` (
`inventoryequipmentid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`inventoryitemid` bigint(20) unsigned NOT NULL DEFAULT '0',
`upgradeslots` int(11) NOT NULL DEFAULT '0',
`level` int(11) NOT NULL DEFAULT '0',
`str` int(11) NOT NULL DEFAULT '0',
`dex` int(11) NOT NULL DEFAULT '0',
`int` int(11) NOT NULL DEFAULT '0',
`luk` int(11) NOT NULL DEFAULT '0',
`hp` int(11) NOT NULL DEFAULT '0',
`mp` int(11) NOT NULL DEFAULT '0',
`watk` int(11) NOT NULL DEFAULT '0',
`matk` int(11) NOT NULL DEFAULT '0',
`wdef` int(11) NOT NULL DEFAULT '0',
`mdef` int(11) NOT NULL DEFAULT '0',
`acc` int(11) NOT NULL DEFAULT '0',
`avoid` int(11) NOT NULL DEFAULT '0',
`hands` int(11) NOT NULL DEFAULT '0',
`speed` int(11) NOT NULL DEFAULT '0',
`jump` int(11) NOT NULL DEFAULT '0',
`ViciousHammer` tinyint(2) NOT NULL DEFAULT '0',
`itemEXP` int(11) NOT NULL DEFAULT '0',
`durability` int(11) NOT NULL DEFAULT '-1',
`enhance` tinyint(3) NOT NULL DEFAULT '0',
`potential1` int(5) NOT NULL DEFAULT '0',
`potential2` int(5) NOT NULL DEFAULT '0',
`potential3` int(5) NOT NULL DEFAULT '0',
`potential4` int(5) NOT NULL DEFAULT '0',
`potential5` int(5) NOT NULL DEFAULT '0',
`socket1` int(5) NOT NULL DEFAULT '-1',
`socket2` int(5) NOT NULL DEFAULT '-1',
`socket3` int(5) NOT NULL DEFAULT '-1',
`incSkill` int(11) NOT NULL DEFAULT '-1',
`charmEXP` smallint(6) NOT NULL DEFAULT '-1',
`pvpDamage` smallint(6) NOT NULL DEFAULT '0',
`equipLevel` int(11) unsigned NOT NULL DEFAULT '1',
`equipExp` int(11) unsigned NOT NULL DEFAULT '0',
`equipMSIUpgrades` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`inventoryequipmentid`),
KEY `inventoryitemid` (`inventoryitemid`),
CONSTRAINT `dueyequipment_ibfk_1` FOREIGN KEY (`inventoryitemid`) REFERENCES `dueyitems` (`inventoryitemid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `dueyitems`;
CREATE TABLE `dueyitems` (
`inventoryitemid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(11) DEFAULT NULL,
`accountid` int(10) DEFAULT NULL,
`packageid` int(11) DEFAULT NULL,
`itemid` int(11) NOT NULL DEFAULT '0',
`inventorytype` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
`quantity` int(11) NOT NULL DEFAULT '0',
`owner` tinytext,
`GM_Log` tinytext,
`uniqueid` int(11) NOT NULL DEFAULT '-1',
`flag` int(2) NOT NULL DEFAULT '0',
`expiredate` bigint(20) NOT NULL DEFAULT '-1',
`type` tinyint(1) NOT NULL DEFAULT '0',
`sender` varchar(13) NOT NULL DEFAULT '',
PRIMARY KEY (`inventoryitemid`),
KEY `inventoryitems_ibfk_1` (`characterid`),
KEY `characterid` (`characterid`),
KEY `inventorytype` (`inventorytype`),
KEY `accountid` (`accountid`),
KEY `packageid` (`packageid`),
KEY `characterid_2` (`characterid`,`inventorytype`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `dueypackages`;
CREATE TABLE `dueypackages` (
`PackageId` int(10) unsigned NOT NULL AUTO_INCREMENT,
`RecieverId` int(10) NOT NULL,
`SenderName` varchar(13) NOT NULL,
`Mesos` int(10) unsigned DEFAULT '0',
`TimeStamp` bigint(20) unsigned DEFAULT NULL,
`Checked` tinyint(1) unsigned DEFAULT '1',
`Type` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`PackageId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `extendedslots`;
CREATE TABLE `extendedslots` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL DEFAULT '0',
`itemId` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `famelog`;
CREATE TABLE `famelog` (
`famelogid` int(11) NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL DEFAULT '0',
`characterid_to` int(11) NOT NULL DEFAULT '0',
`when` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`famelogid`),
KEY `characterid` (`characterid`),
CONSTRAINT `famelog_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `familiars`;
CREATE TABLE `familiars` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL DEFAULT '0',
`familiar` int(11) NOT NULL DEFAULT '0',
`name` varchar(40) NOT NULL DEFAULT '',
`fatigue` int(11) NOT NULL DEFAULT '0',
`expiry` bigint(20) NOT NULL DEFAULT '0',
`vitality` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3044 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `families`;
CREATE TABLE `families` (
`familyid` int(11) NOT NULL AUTO_INCREMENT,
`leaderid` int(11) NOT NULL DEFAULT '0',
`notice` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`familyid`),
KEY `familyid` (`familyid`),
KEY `leaderid` (`leaderid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `gifts`;
CREATE TABLE `gifts` (
`giftid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`recipient` int(11) NOT NULL DEFAULT '0',
`from` varchar(13) NOT NULL DEFAULT '',
`message` varchar(255) NOT NULL DEFAULT '',
`sn` int(11) NOT NULL DEFAULT '0',
`uniqueid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`giftid`),
KEY `recipient` (`recipient`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `gmlog`;
CREATE TABLE `gmlog` (
`gmlogid` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`command` text NOT NULL,
`mapid` int(11) NOT NULL DEFAULT '0',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`gmlogid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `guilds`;
CREATE TABLE `guilds` (
`guildid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`leader` int(10) unsigned NOT NULL DEFAULT '0',
`GP` int(11) NOT NULL DEFAULT '0',
`logo` int(10) unsigned DEFAULT NULL,
`logoColor` smallint(5) unsigned NOT NULL DEFAULT '0',
`name` varchar(45) NOT NULL,
`rank1title` varchar(45) NOT NULL DEFAULT 'Master',
`rank2title` varchar(45) NOT NULL DEFAULT 'Jr. Master',
`rank3title` varchar(45) NOT NULL DEFAULT 'Member',
`rank4title` varchar(45) NOT NULL DEFAULT 'Member',
`rank5title` varchar(45) NOT NULL DEFAULT 'Member',
`capacity` int(10) unsigned NOT NULL DEFAULT '10',
`logoBG` int(10) unsigned DEFAULT NULL,
`logoBGColor` smallint(5) unsigned NOT NULL DEFAULT '0',
`notice` varchar(101) DEFAULT NULL,
`signature` int(11) NOT NULL DEFAULT '0',
`alliance` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`guildid`),
UNIQUE KEY `name` (`name`),
KEY `guildid` (`guildid`),
KEY `leader` (`leader`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `guildskills`;
CREATE TABLE `guildskills` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`guildid` int(11) NOT NULL DEFAULT '0',
`skillid` int(11) NOT NULL DEFAULT '0',
`level` smallint(3) NOT NULL DEFAULT '1',
`timestamp` bigint(20) NOT NULL DEFAULT '0',
`purchaser` varchar(13) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `hidelog`;
CREATE TABLE `hidelog` (
`logid` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`text` text NOT NULL,
`mapid` int(11) NOT NULL DEFAULT '0',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`logid`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `hiredmerch`;
CREATE TABLE `hiredmerch` (
`PackageId` int(10) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(10) unsigned DEFAULT '0',
`accountid` int(10) unsigned DEFAULT NULL,
`Mesos` int(10) unsigned DEFAULT '0',
`time` bigint(20) unsigned DEFAULT NULL,
PRIMARY KEY (`PackageId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `hiredmerchequipment`;
CREATE TABLE `hiredmerchequipment` (
`inventoryequipmentid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`inventoryitemid` bigint(20) unsigned NOT NULL DEFAULT '0',
`upgradeslots` int(11) NOT NULL DEFAULT '0',
`level` int(11) NOT NULL DEFAULT '0',
`str` int(11) NOT NULL DEFAULT '0',
`dex` int(11) NOT NULL DEFAULT '0',
`int` int(11) NOT NULL DEFAULT '0',
`luk` int(11) NOT NULL DEFAULT '0',
`hp` int(11) NOT NULL DEFAULT '0',
`mp` int(11) NOT NULL DEFAULT '0',
`watk` int(11) NOT NULL DEFAULT '0',
`matk` int(11) NOT NULL DEFAULT '0',
`wdef` int(11) NOT NULL DEFAULT '0',
`mdef` int(11) NOT NULL DEFAULT '0',
`acc` int(11) NOT NULL DEFAULT '0',
`avoid` int(11) NOT NULL DEFAULT '0',
`hands` int(11) NOT NULL DEFAULT '0',
`speed` int(11) NOT NULL DEFAULT '0',
`jump` int(11) NOT NULL DEFAULT '0',
`ViciousHammer` tinyint(2) NOT NULL DEFAULT '0',
`itemEXP` int(11) NOT NULL DEFAULT '0',
`durability` int(11) NOT NULL DEFAULT '-1',
`enhance` tinyint(3) NOT NULL DEFAULT '0',
`potential1` int(5) NOT NULL DEFAULT '0',
`potential2` int(5) NOT NULL DEFAULT '0',
`potential3` int(5) NOT NULL DEFAULT '0',
`potential4` int(5) NOT NULL DEFAULT '0',
`potential5` int(5) NOT NULL DEFAULT '0',
`socket1` int(5) NOT NULL DEFAULT '-1',
`socket2` int(5) NOT NULL DEFAULT '-1',
`socket3` int(5) NOT NULL DEFAULT '-1',
`incSkill` int(11) NOT NULL DEFAULT '-1',
`charmEXP` smallint(6) NOT NULL DEFAULT '-1',
`pvpDamage` smallint(6) NOT NULL DEFAULT '0',
`equipLevel` int(11) unsigned NOT NULL DEFAULT '1',
`equipExp` int(11) unsigned NOT NULL DEFAULT '0',
`equipMSIUpgrades` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`inventoryequipmentid`),
KEY `inventoryitemid` (`inventoryitemid`),
CONSTRAINT `hiredmerchequipment_ibfk_1` FOREIGN KEY (`inventoryitemid`) REFERENCES `hiredmerchitems` (`inventoryitemid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `hiredmerchitems`;
CREATE TABLE `hiredmerchitems` (
`inventoryitemid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(11) DEFAULT NULL,
`accountid` int(10) DEFAULT NULL,
`packageid` int(11) DEFAULT NULL,
`itemid` int(11) NOT NULL DEFAULT '0',
`inventorytype` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
`quantity` int(11) NOT NULL DEFAULT '0',
`owner` tinytext,
`GM_Log` tinytext,
`uniqueid` int(11) NOT NULL DEFAULT '-1',
`flag` int(2) NOT NULL DEFAULT '0',
`expiredate` bigint(20) NOT NULL DEFAULT '-1',
`type` tinyint(1) NOT NULL DEFAULT '0',
`sender` varchar(13) NOT NULL DEFAULT '',
PRIMARY KEY (`inventoryitemid`),
KEY `inventoryitems_ibfk_1` (`characterid`),
KEY `characterid` (`characterid`),
KEY `inventorytype` (`inventorytype`),
KEY `accountid` (`accountid`),
KEY `packageid` (`packageid`),
KEY `characterid_2` (`characterid`,`inventorytype`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `hyperrocklocations`;
CREATE TABLE `hyperrocklocations` (
`trockid` int(11) NOT NULL AUTO_INCREMENT,
`characterid` int(11) DEFAULT NULL,
`mapid` int(11) DEFAULT NULL,
PRIMARY KEY (`trockid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `imps`;
CREATE TABLE `imps` (
`impid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL DEFAULT '0',
`itemid` int(11) NOT NULL DEFAULT '0',
`level` tinyint(3) unsigned NOT NULL DEFAULT '1',
`state` tinyint(3) unsigned NOT NULL DEFAULT '1',
`closeness` mediumint(6) unsigned NOT NULL DEFAULT '0',
`fullness` mediumint(6) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`impid`),
KEY `impid` (`impid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `inner_ability_skills`;
CREATE TABLE `inner_ability_skills` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`player_id` int(11) NOT NULL DEFAULT '0',
`skill_id` int(11) NOT NULL DEFAULT '0',
`skill_level` int(11) NOT NULL DEFAULT '0',
`max_level` int(11) NOT NULL DEFAULT '0',
`rank` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4284 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `internlog`;
CREATE TABLE `internlog` (
`gmlogid` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`command` tinytext NOT NULL,
`mapid` int(11) NOT NULL DEFAULT '0',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`gmlogid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `inventoryequipment`;
CREATE TABLE `inventoryequipment` (
`inventoryequipmentid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`inventoryitemid` bigint(20) unsigned NOT NULL DEFAULT '0',
`upgradeslots` tinyint(3) unsigned NOT NULL DEFAULT '0',
`level` tinyint(3) unsigned NOT NULL DEFAULT '0',
`str` int(6) NOT NULL DEFAULT '0',
`dex` int(6) NOT NULL DEFAULT '0',
`int` int(6) NOT NULL DEFAULT '0',
`luk` int(6) NOT NULL DEFAULT '0',
`hp` int(6) NOT NULL DEFAULT '0',
`mp` int(6) NOT NULL DEFAULT '0',
`watk` int(6) NOT NULL DEFAULT '0',
`matk` int(6) NOT NULL DEFAULT '0',
`wdef` int(6) NOT NULL DEFAULT '0',
`mdef` int(6) NOT NULL DEFAULT '0',
`acc` int(6) NOT NULL DEFAULT '0',
`avoid` int(6) NOT NULL DEFAULT '0',
`hands` int(6) NOT NULL DEFAULT '0',
`speed` int(6) NOT NULL DEFAULT '0',
`jump` int(6) NOT NULL DEFAULT '0',
`ViciousHammer` tinyint(2) NOT NULL DEFAULT '0',
`itemEXP` int(11) NOT NULL DEFAULT '0',
`durability` mediumint(9) NOT NULL DEFAULT '-1',
`enhance` tinyint(3) NOT NULL DEFAULT '0',
`potential1` int(5) NOT NULL DEFAULT '0',
`potential2` int(5) NOT NULL DEFAULT '0',
`potential3` int(5) NOT NULL DEFAULT '0',
`potential4` int(5) NOT NULL DEFAULT '0',
`potential5` int(5) NOT NULL DEFAULT '0',
`socket1` int(5) NOT NULL DEFAULT '-1',
`socket2` int(5) NOT NULL DEFAULT '-1',
`socket3` int(5) NOT NULL DEFAULT '-1',
`incSkill` int(11) NOT NULL DEFAULT '-1',
`charmEXP` int(6) NOT NULL DEFAULT '-1',
`pvpDamage` int(6) NOT NULL DEFAULT '0',
`equipLevel` int(11) unsigned NOT NULL DEFAULT '1',
`equipExp` int(11) unsigned NOT NULL DEFAULT '0',
`equipMSIUpgrades` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`inventoryequipmentid`),
KEY `inventoryitemid` (`inventoryitemid`),
CONSTRAINT `inventoryequipment_ibfk_1` FOREIGN KEY (`inventoryitemid`) REFERENCES `inventoryitems` (`inventoryitemid`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2281606 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `inventoryitems`;
CREATE TABLE `inventoryitems` (
`inventoryitemid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(11) DEFAULT NULL,
`accountid` int(10) DEFAULT NULL,
`packageid` int(11) DEFAULT NULL,
`itemid` int(11) NOT NULL DEFAULT '0',
`inventorytype` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
`quantity` int(11) NOT NULL DEFAULT '0',
`owner` tinytext,
`GM_Log` tinytext,
`uniqueid` int(11) NOT NULL DEFAULT '-1',
`flag` int(2) NOT NULL DEFAULT '0',
`expiredate` bigint(20) NOT NULL DEFAULT '-1',
`type` tinyint(1) NOT NULL DEFAULT '0',
`sender` varchar(13) NOT NULL DEFAULT '',
PRIMARY KEY (`inventoryitemid`),
KEY `inventorytype` (`inventorytype`),
KEY `accountid` (`accountid`),
KEY `packageid` (`packageid`),
KEY `characterid_2` (`characterid`,`inventorytype`)
) ENGINE=InnoDB AUTO_INCREMENT=127104082 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `inventorylog`;
CREATE TABLE `inventorylog` (
`inventorylogid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`inventoryitemid` int(10) unsigned NOT NULL DEFAULT '0',
`msg` tinytext NOT NULL,
PRIMARY KEY (`inventorylogid`),
KEY `inventoryitemid` (`inventoryitemid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `inventoryslot`;
CREATE TABLE `inventoryslot` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(10) unsigned DEFAULT NULL,
`equip` tinyint(3) unsigned DEFAULT NULL,
`use` tinyint(3) unsigned DEFAULT NULL,
`setup` tinyint(3) unsigned DEFAULT NULL,
`etc` tinyint(3) unsigned DEFAULT NULL,
`cash` tinyint(3) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `characterid` (`characterid`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `ipbans`;
CREATE TABLE `ipbans` (
`ipbanid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ip` varchar(40) NOT NULL DEFAULT '',
PRIMARY KEY (`ipbanid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `iplog`;
CREATE TABLE `iplog` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`accid` int(11) NOT NULL,
`accname` varchar(45) NOT NULL,
`ip` varchar(45) NOT NULL,
`time` varchar(45) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `ipvotelog`;
CREATE TABLE `ipvotelog` (
`vid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`accid` int(11) NOT NULL DEFAULT '0',
`ipaddress` varchar(255) NOT NULL DEFAULT '127.0.0.1',
`votetime` bigint(20) NOT NULL DEFAULT '0',
`votetype` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`vid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `ipvotes`;
CREATE TABLE `ipvotes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(30) NOT NULL,
`accid` int(11) NOT NULL,
`lastvote` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `keymap`;
CREATE TABLE `keymap` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL DEFAULT '0',
`key` tinyint(3) unsigned NOT NULL DEFAULT '0',
`type` tinyint(3) unsigned NOT NULL DEFAULT '0',
`action` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `keymap_ibfk_1` (`characterid`),
CONSTRAINT `keymap_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=184038 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `macbans`;
CREATE TABLE `macbans` (
`macbanid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`mac` varchar(30) NOT NULL,
PRIMARY KEY (`macbanid`),
UNIQUE KEY `mac_2` (`mac`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `macfilters`;
CREATE TABLE `macfilters` (
`macfilterid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`filter` varchar(30) NOT NULL,
PRIMARY KEY (`macfilterid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `monsterbook`;
CREATE TABLE `monsterbook` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`charid` int(10) unsigned NOT NULL DEFAULT '0',
`cardid` int(10) unsigned NOT NULL DEFAULT '0',
`level` tinyint(2) unsigned DEFAULT '1',
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `charid` (`charid`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `mountdata`;
CREATE TABLE `mountdata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(10) unsigned DEFAULT NULL,
`Level` int(3) unsigned NOT NULL DEFAULT '0',
`Exp` int(10) unsigned NOT NULL DEFAULT '0',
`Fatigue` int(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `characterid` (`characterid`),
KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `mrush`;
CREATE TABLE `mrush` (
`mesos` bigint(8) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`mesos`)
) ENGINE=InnoDB AUTO_INCREMENT=9223372036854775808 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `mts_cart`;
CREATE TABLE `mts_cart` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL DEFAULT '0',
`itemid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `characterid` (`characterid`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `mts_items`;
CREATE TABLE `mts_items` (
`id` int(11) NOT NULL,
`tab` tinyint(1) NOT NULL DEFAULT '1',
`price` int(11) NOT NULL DEFAULT '0',
`characterid` int(11) NOT NULL DEFAULT '0',
`seller` varchar(13) NOT NULL DEFAULT '',
`expiration` bigint(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `mtsequipment`;
CREATE TABLE `mtsequipment` (
`inventoryequipmentid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`inventoryitemid` bigint(20) unsigned NOT NULL DEFAULT '0',
`upgradeslots` int(11) NOT NULL DEFAULT '0',
`level` int(11) NOT NULL DEFAULT '0',
`str` int(11) NOT NULL DEFAULT '0',
`dex` int(11) NOT NULL DEFAULT '0',
`int` int(11) NOT NULL DEFAULT '0',
`luk` int(11) NOT NULL DEFAULT '0',
`hp` int(11) NOT NULL DEFAULT '0',
`mp` int(11) NOT NULL DEFAULT '0',
`watk` int(11) NOT NULL DEFAULT '0',
`matk` int(11) NOT NULL DEFAULT '0',
`wdef` int(11) NOT NULL DEFAULT '0',
`mdef` int(11) NOT NULL DEFAULT '0',
`acc` int(11) NOT NULL DEFAULT '0',
`avoid` int(11) NOT NULL DEFAULT '0',
`hands` int(11) NOT NULL DEFAULT '0',
`speed` int(11) NOT NULL DEFAULT '0',
`jump` int(11) NOT NULL DEFAULT '0',
`ViciousHammer` tinyint(2) NOT NULL DEFAULT '0',
`itemEXP` int(11) NOT NULL DEFAULT '0',
`durability` int(11) NOT NULL DEFAULT '-1',
`enhance` tinyint(3) NOT NULL DEFAULT '0',
`potential1` int(5) NOT NULL DEFAULT '0',
`potential2` int(5) NOT NULL DEFAULT '0',
`potential3` int(5) NOT NULL DEFAULT '0',
`potential4` int(5) NOT NULL DEFAULT '0',
`potential5` int(5) NOT NULL DEFAULT '0',
`socket1` int(5) NOT NULL DEFAULT '-1',
`socket2` int(5) NOT NULL DEFAULT '-1',
`socket3` int(5) NOT NULL DEFAULT '-1',
`incSkill` int(11) NOT NULL DEFAULT '-1',
`charmEXP` smallint(6) NOT NULL DEFAULT '-1',
`pvpDamage` smallint(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`inventoryequipmentid`),
KEY `inventoryitemid` (`inventoryitemid`),
CONSTRAINT `mtsequipment_ibfk_1` FOREIGN KEY (`inventoryitemid`) REFERENCES `mtsitems` (`inventoryitemid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `mtsitems`;
CREATE TABLE `mtsitems` (
`inventoryitemid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(11) DEFAULT NULL,
`accountid` int(10) DEFAULT NULL,
`packageId` int(11) DEFAULT NULL,
`itemid` int(11) NOT NULL DEFAULT '0',
`inventorytype` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
`quantity` int(11) NOT NULL DEFAULT '0',
`owner` tinytext,
`GM_Log` tinytext,
`uniqueid` int(11) NOT NULL DEFAULT '-1',
`flag` int(2) NOT NULL DEFAULT '0',
`expiredate` bigint(20) NOT NULL DEFAULT '-1',
`type` tinyint(1) NOT NULL DEFAULT '0',
`sender` varchar(13) NOT NULL DEFAULT '',
PRIMARY KEY (`inventoryitemid`),
KEY `inventoryitems_ibfk_1` (`characterid`),
KEY `characterid` (`characterid`),
KEY `inventorytype` (`inventorytype`),
KEY `accountid` (`accountid`),
KEY `characterid_2` (`characterid`,`inventorytype`),
KEY `packageid` (`packageId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `mtstransfer`;
CREATE TABLE `mtstransfer` (
`inventoryitemid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(11) DEFAULT NULL,
`accountid` int(10) DEFAULT NULL,
`packageid` int(11) DEFAULT NULL,
`itemid` int(11) NOT NULL DEFAULT '0',
`inventorytype` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
`quantity` int(11) NOT NULL DEFAULT '0',
`owner` tinytext,
`GM_Log` tinytext,
`uniqueid` int(11) NOT NULL DEFAULT '-1',
`flag` int(2) NOT NULL DEFAULT '0',
`expiredate` bigint(20) NOT NULL DEFAULT '-1',
`type` tinyint(1) NOT NULL DEFAULT '0',
`sender` varchar(13) NOT NULL DEFAULT '',
PRIMARY KEY (`inventoryitemid`),
KEY `inventoryitems_ibfk_1` (`characterid`),
KEY `characterid` (`characterid`),
KEY `inventorytype` (`inventorytype`),
KEY `accountid` (`accountid`),
KEY `packageid` (`packageid`),
KEY `characterid_2` (`characterid`,`inventorytype`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `mtstransferequipment`;
CREATE TABLE `mtstransferequipment` (
`inventoryequipmentid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`inventoryitemid` bigint(20) unsigned NOT NULL DEFAULT '0',
`upgradeslots` int(11) NOT NULL DEFAULT '0',
`level` int(11) NOT NULL DEFAULT '0',
`str` int(11) NOT NULL DEFAULT '0',
`dex` int(11) NOT NULL DEFAULT '0',
`int` int(11) NOT NULL DEFAULT '0',
`luk` int(11) NOT NULL DEFAULT '0',
`hp` int(11) NOT NULL DEFAULT '0',
`mp` int(11) NOT NULL DEFAULT '0',
`watk` int(11) NOT NULL DEFAULT '0',
`matk` int(11) NOT NULL DEFAULT '0',
`wdef` int(11) NOT NULL DEFAULT '0',
`mdef` int(11) NOT NULL DEFAULT '0',
`acc` int(11) NOT NULL DEFAULT '0',
`avoid` int(11) NOT NULL DEFAULT '0',
`hands` int(11) NOT NULL DEFAULT '0',
`speed` int(11) NOT NULL DEFAULT '0',
`jump` int(11) NOT NULL DEFAULT '0',
`ViciousHammer` tinyint(2) NOT NULL DEFAULT '0',
`itemEXP` int(11) NOT NULL DEFAULT '0',
`durability` int(11) NOT NULL DEFAULT '-1',
`enhance` tinyint(3) NOT NULL DEFAULT '0',
`potential1` int(5) NOT NULL DEFAULT '0',
`potential2` int(5) NOT NULL DEFAULT '0',
`potential3` int(5) NOT NULL DEFAULT '0',
`potential4` int(5) NOT NULL DEFAULT '0',
`potential5` int(5) NOT NULL DEFAULT '0',
`socket1` int(5) NOT NULL DEFAULT '-1',
`socket2` int(5) NOT NULL DEFAULT '-1',
`socket3` int(5) NOT NULL DEFAULT '-1',
`incSkill` int(11) NOT NULL DEFAULT '-1',
`charmEXP` smallint(6) NOT NULL DEFAULT '-1',
`pvpDamage` smallint(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`inventoryequipmentid`),
KEY `inventoryitemid` (`inventoryitemid`),
CONSTRAINT `mtstransferequipment_ibfk_1` FOREIGN KEY (`inventoryitemid`) REFERENCES `mtstransfer` (`inventoryitemid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `myinfo`;
CREATE TABLE `myinfo` (
`infoid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL,
`location` int(11) NOT NULL,
`todo` int(11) unsigned NOT NULL,
`birthday` int(11) unsigned NOT NULL,
`found` int(11) unsigned NOT NULL,
PRIMARY KEY (`infoid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(25) NOT NULL,
`type` int(11) unsigned NOT NULL DEFAULT '0',
`date` varchar(45) NOT NULL,
`url` varchar(45) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `notes`;
CREATE TABLE `notes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`to` varchar(13) NOT NULL DEFAULT '',
`from` varchar(13) NOT NULL DEFAULT '',
`message` text NOT NULL,
`timestamp` bigint(20) unsigned NOT NULL,
`gift` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `to` (`to`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `nxcode`;
CREATE TABLE `nxcode` (
`code` varchar(15) NOT NULL,
`valid` int(11) NOT NULL DEFAULT '1',
`user` varchar(13) DEFAULT NULL,
`type` int(11) NOT NULL DEFAULT '0',
`item` int(11) NOT NULL DEFAULT '10000',
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `pets`;
CREATE TABLE `pets` (
`petid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(13) DEFAULT NULL,
`level` int(3) unsigned NOT NULL,
`closeness` int(6) unsigned NOT NULL,
`fullness` int(3) unsigned NOT NULL,
`seconds` int(11) NOT NULL DEFAULT '0',
`flags` smallint(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`petid`),
KEY `petid` (`petid`)
) ENGINE=InnoDB AUTO_INCREMENT=637 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `playernpcs`;
CREATE TABLE `playernpcs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(13) NOT NULL,
`hair` int(11) NOT NULL,
`face` int(11) NOT NULL,
`skin` int(11) NOT NULL,
`x` int(11) NOT NULL DEFAULT '0',
`y` int(11) NOT NULL DEFAULT '0',
`map` int(11) NOT NULL,
`charid` int(11) NOT NULL,
`scriptid` int(11) NOT NULL,
`foothold` int(11) NOT NULL,
`dir` tinyint(1) NOT NULL DEFAULT '0',
`gender` tinyint(1) NOT NULL DEFAULT '0',
`pets` varchar(25) DEFAULT '0,0,0',
PRIMARY KEY (`id`),
KEY `scriptid` (`scriptid`),
KEY `playernpcs_ibfk_1` (`charid`),
CONSTRAINT `playernpcs_ibfk_1` FOREIGN KEY (`charid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3739 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `playernpcs_equip`;
CREATE TABLE `playernpcs_equip` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`npcid` int(11) NOT NULL,
`equipid` int(11) NOT NULL,
`equippos` int(11) NOT NULL,
`charid` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `playernpcs_equip_ibfk_1` (`charid`),
KEY `playernpcs_equip_ibfk_2` (`npcid`),
CONSTRAINT `playernpcs_equip_ibfk_1` FOREIGN KEY (`charid`) REFERENCES `characters` (`id`) ON DELETE CASCADE,
CONSTRAINT `playernpcs_equip_ibfk_2` FOREIGN KEY (`npcid`) REFERENCES `playernpcs` (`scriptid`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=63169 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `pokemon`;
CREATE TABLE `pokemon` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`monsterid` int(11) NOT NULL DEFAULT '0',
`characterid` int(11) NOT NULL DEFAULT '0',
`level` smallint(3) NOT NULL DEFAULT '1',
`exp` int(11) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`nature` tinyint(3) NOT NULL DEFAULT '0',
`active` tinyint(1) NOT NULL DEFAULT '0',
`accountid` int(11) NOT NULL DEFAULT '0',
`itemid` int(11) NOT NULL DEFAULT '0',
`gender` tinyint(2) NOT NULL DEFAULT '-1',
`hpiv` tinyint(3) NOT NULL DEFAULT '-1',
`atkiv` tinyint(3) NOT NULL DEFAULT '-1',
`defiv` tinyint(3) NOT NULL DEFAULT '-1',
`spatkiv` tinyint(3) NOT NULL DEFAULT '-1',
`spdefiv` tinyint(3) NOT NULL DEFAULT '-1',
`speediv` tinyint(3) NOT NULL DEFAULT '-1',
`evaiv` tinyint(3) NOT NULL DEFAULT '-1',
`acciv` tinyint(3) NOT NULL DEFAULT '-1',
`ability` tinyint(2) NOT NULL DEFAULT '-1',
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `characterid` (`characterid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `proxyip`;
CREATE TABLE `proxyip` (
`proxyid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`proxyip` varchar(40) NOT NULL,
PRIMARY KEY (`proxyid`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `pwreset`;
CREATE TABLE `pwreset` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(14) NOT NULL,
`email` varchar(100) NOT NULL,
`confirmkey` varchar(100) NOT NULL,
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`timestamp` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `questinfo`;
CREATE TABLE `questinfo` (
`questinfoid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL DEFAULT '0',
`quest` int(6) NOT NULL DEFAULT '0',
`customData` varchar(555) DEFAULT NULL,
PRIMARY KEY (`questinfoid`),
KEY `characterid` (`characterid`),
CONSTRAINT `questsinfo_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=45109 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `queststatus`;
CREATE TABLE `queststatus` (
`queststatusid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL DEFAULT '0',
`quest` int(6) NOT NULL DEFAULT '0',
`status` tinyint(4) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`forfeited` int(11) NOT NULL DEFAULT '0',
`customData` varchar(255) DEFAULT NULL,
PRIMARY KEY (`queststatusid`),
KEY `characterid` (`characterid`),
KEY `queststatusid` (`queststatusid`),
CONSTRAINT `queststatus_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23251946 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `queststatusmobs`;
CREATE TABLE `queststatusmobs` (
`queststatusmobid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`queststatusid` int(10) unsigned NOT NULL DEFAULT '0',
`mob` int(11) NOT NULL DEFAULT '0',
`count` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`queststatusmobid`),
KEY `queststatusid` (`queststatusid`),
CONSTRAINT `queststatusmobs_ibfk_1` FOREIGN KEY (`queststatusid`) REFERENCES `queststatus` (`queststatusid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `reactordrops`;
CREATE TABLE `reactordrops` (
`reactordropid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`reactorid` int(11) NOT NULL,
`itemid` int(11) NOT NULL,
`chance` int(11) NOT NULL,
`questid` int(5) NOT NULL DEFAULT '-1',
PRIMARY KEY (`reactordropid`),
KEY `reactorid` (`reactorid`)
) ENGINE=InnoDB AUTO_INCREMENT=841 DEFAULT CHARSET=latin1 PACK_KEYS=1;
DROP TABLE IF EXISTS `regrocklocations`;
CREATE TABLE `regrocklocations` (
`trockid` int(11) NOT NULL AUTO_INCREMENT,
`characterid` int(11) DEFAULT NULL,
`mapid` int(11) DEFAULT NULL,
PRIMARY KEY (`trockid`),
KEY `characterid` (`characterid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `reports`;
CREATE TABLE `reports` (
`reportid` int(9) NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL DEFAULT '0',
`type` tinyint(2) NOT NULL DEFAULT '0',
`count` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`reportid`,`characterid`),
KEY `characterid` (`characterid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `rings`;
CREATE TABLE `rings` (
`ringid` int(11) NOT NULL AUTO_INCREMENT,
`partnerRingId` int(11) NOT NULL DEFAULT '0',
`partnerChrId` int(11) NOT NULL DEFAULT '0',
`itemid` int(11) NOT NULL DEFAULT '0',
`partnername` varchar(255) NOT NULL,
PRIMARY KEY (`ringid`),
KEY `ringid` (`ringid`),
KEY `partnerChrId` (`partnerChrId`),
KEY `partnerRingId` (`partnerRingId`)
) ENGINE=InnoDB AUTO_INCREMENT=617 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `savedlocations`;
CREATE TABLE `savedlocations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL,
`locationtype` int(11) NOT NULL DEFAULT '0',
`map` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `savedlocations_ibfk_1` (`characterid`),
CONSTRAINT `savedlocations_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=541 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `scroll_log`;
CREATE TABLE `scroll_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`accId` int(11) NOT NULL DEFAULT '0',
`chrId` int(11) NOT NULL DEFAULT '0',
`scrollId` int(11) NOT NULL DEFAULT '0',
`itemId` int(11) NOT NULL DEFAULT '0',
`oldSlots` tinyint(4) NOT NULL DEFAULT '0',
`newSlots` tinyint(4) NOT NULL DEFAULT '0',
`hammer` tinyint(4) NOT NULL DEFAULT '0',
`result` varchar(13) NOT NULL DEFAULT '',
`whiteScroll` tinyint(1) NOT NULL DEFAULT '0',
`legendarySpirit` tinyint(1) NOT NULL DEFAULT '0',
`vegaId` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `shopitems`;
CREATE TABLE `shopitems` (
`shopitemid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`shopid` int(10) unsigned NOT NULL DEFAULT '0',
`itemid` int(11) NOT NULL DEFAULT '0',
`price` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
`reqitem` int(11) NOT NULL DEFAULT '0',
`reqitemq` int(11) NOT NULL DEFAULT '0',
`rank` tinyint(3) NOT NULL DEFAULT '0',
`category` tinyint(3) NOT NULL DEFAULT '0',
`minLevel` int(11) NOT NULL DEFAULT '0',
`expiration` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`shopitemid`),
KEY `shopid` (`shopid`)
) ENGINE=InnoDB AUTO_INCREMENT=5005082 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `shopranks`;
CREATE TABLE `shopranks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`shopid` int(11) NOT NULL DEFAULT '0',
`rank` int(11) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`itemid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `shops`;
CREATE TABLE `shops` (
`shopid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`npcid` int(11) DEFAULT '0',
PRIMARY KEY (`shopid`)
) ENGINE=InnoDB AUTO_INCREMENT=170001 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `sidekicks`;
CREATE TABLE `sidekicks` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`firstid` int(11) NOT NULL DEFAULT '0',
`secondid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `skillmacros`;
CREATE TABLE `skillmacros` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL DEFAULT '0',
`position` tinyint(1) NOT NULL DEFAULT '0',
`skill1` int(11) NOT NULL DEFAULT '0',
`skill2` int(11) NOT NULL DEFAULT '0',
`skill3` int(11) NOT NULL DEFAULT '0',
`name` varchar(30) DEFAULT NULL,
`shout` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `characterid` (`characterid`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `skills`;
CREATE TABLE `skills` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`skillid` int(11) NOT NULL DEFAULT '0',
`characterid` int(11) NOT NULL DEFAULT '0',
`skilllevel` int(11) NOT NULL DEFAULT '0',
`masterlevel` tinyint(4) NOT NULL DEFAULT '0',
`expiration` bigint(20) NOT NULL DEFAULT '-1',
`slot` int(11) NOT NULL DEFAULT '-1',
`equipped` int(11) NOT NULL DEFAULT '-1',
PRIMARY KEY (`id`),
KEY `FK_skills_1` (`characterid`),
CONSTRAINT `FK_skills_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=144034 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `skills_cooldowns`;
CREATE TABLE `skills_cooldowns` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`charid` int(11) NOT NULL,
`SkillID` int(11) NOT NULL,
`length` bigint(20) NOT NULL,
`StartTime` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `charid` (`charid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `speedruns`;
CREATE TABLE `speedruns` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(13) NOT NULL,
`leader` varchar(13) NOT NULL,
`timestring` varchar(1024) NOT NULL,
`time` bigint(20) NOT NULL DEFAULT '0',
`members` varchar(1024) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `stolen`;
CREATE TABLE `stolen` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`characterid` varchar(45) NOT NULL,
`skillid` varchar(45) NOT NULL,
`chosen` varchar(45) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `storages`;
CREATE TABLE `storages` (
`storageid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`accountid` int(11) NOT NULL DEFAULT '0',
`slots` int(11) NOT NULL DEFAULT '0',
`meso` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`storageid`),
KEY `accountid` (`accountid`),
CONSTRAINT `storages_ibfk_1` FOREIGN KEY (`accountid`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `tournamentlog`;
CREATE TABLE `tournamentlog` (
`logid` int(11) NOT NULL AUTO_INCREMENT,
`winnerid` int(11) NOT NULL DEFAULT '0',
`numContestants` int(11) NOT NULL DEFAULT '0',
`when` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`logid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `trocklocations`;
CREATE TABLE `trocklocations` (
`trockid` int(11) NOT NULL AUTO_INCREMENT,
`characterid` int(11) DEFAULT NULL,
`mapid` int(11) DEFAULT NULL,
PRIMARY KEY (`trockid`),
KEY `characterid` (`characterid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `trolled`;
CREATE TABLE `trolled` (
`trolledid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`trolledid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `vote_log`;
CREATE TABLE `vote_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`account` varchar(45) NOT NULL,
`ip` varchar(45) NOT NULL,
`date` int(10) unsigned NOT NULL,
`times` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `votecontrol`;
CREATE TABLE `votecontrol` (
`name` varchar(45) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `votecontrolgtop`;
CREATE TABLE `votecontrolgtop` (
`name` varchar(45) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `voteipcontrol`;
CREATE TABLE `voteipcontrol` (
`ip` varchar(45) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `voteipcontrolgtop`;
CREATE TABLE `voteipcontrolgtop` (
`ip` varchar(45) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `voterewards`;
CREATE TABLE `voterewards` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(45) NOT NULL,
`claimed` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `voterewardsgtop`;
CREATE TABLE `voterewardsgtop` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(45) NOT NULL,
`claimed` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `votingrecords`;
CREATE TABLE `votingrecords` (
`account` varchar(13) NOT NULL DEFAULT '0',
`ip` varchar(30) NOT NULL DEFAULT '0',
`date` int(11) NOT NULL DEFAULT '0',
`times` bigint(20) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`account`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `web_logs`;
CREATE TABLE `web_logs` (
`idweb_logs` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`idweb_logs`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `wishlist`;
CREATE TABLE `wishlist` (
`characterid` int(11) NOT NULL,
`sn` int(11) NOT NULL,
KEY `characterid` (`characterid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `wz_clearedlife`;
CREATE TABLE `wz_clearedlife` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`mapid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `wz_customlife`;
CREATE TABLE `wz_customlife` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`idd` int(11) NOT NULL,
`f` int(11) NOT NULL,
`fh` int(11) NOT NULL,
`type` varchar(1) NOT NULL,
`cy` int(11) NOT NULL,
`rx0` int(11) NOT NULL,
`rx1` int(11) NOT NULL,
`x` int(11) NOT NULL,
`y` int(11) NOT NULL,
`mobtime` int(11) DEFAULT '1000',
`mid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `wz_itemadddata`;
CREATE TABLE `wz_itemadddata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`itemid` int(11) NOT NULL,
`key` varchar(30) NOT NULL,
`value1` int(11) NOT NULL DEFAULT '0',
`value2` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=767 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
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_itemequipdata`;
CREATE TABLE `wz_itemequipdata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`itemid` int(11) NOT NULL,
`itemLevel` int(11) NOT NULL DEFAULT '-1',
`key` varchar(30) NOT NULL,
`value` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=280499 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `wz_itemrewarddata`;
CREATE TABLE `wz_itemrewarddata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`itemid` int(11) NOT NULL,
`item` int(11) NOT NULL,
`prob` int(11) NOT NULL DEFAULT '0',
`quantity` smallint(5) NOT NULL DEFAULT '0',
`period` int(11) NOT NULL DEFAULT '-1',
`worldMsg` varchar(255) NOT NULL DEFAULT '',
`effect` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16529 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_questactdata`;
CREATE TABLE `wz_questactdata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`questid` int(11) NOT NULL DEFAULT '0',
`name` varchar(127) NOT NULL DEFAULT '',
`type` tinyint(1) NOT NULL DEFAULT '0',
`intStore` int(11) NOT NULL DEFAULT '0',
`applicableJobs` varchar(1024) NOT NULL DEFAULT '',
`uniqueid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `quests_ibfk_2` (`questid`)
) ENGINE=InnoDB AUTO_INCREMENT=7454 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `wz_questactitemdata`;
CREATE TABLE `wz_questactitemdata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`itemid` int(11) NOT NULL DEFAULT '0',
`count` smallint(5) NOT NULL DEFAULT '0',
`period` int(11) NOT NULL DEFAULT '0',
`gender` tinyint(1) NOT NULL DEFAULT '2',
`job` int(11) NOT NULL DEFAULT '-1',
`jobEx` int(11) NOT NULL DEFAULT '-1',
`prop` int(11) NOT NULL DEFAULT '-1',
`uniqueid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8960 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `wz_questactquestdata`;
CREATE TABLE `wz_questactquestdata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`quest` int(11) NOT NULL DEFAULT '0',
`state` tinyint(1) NOT NULL DEFAULT '2',
`uniqueid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
DROP TABLE IF EXISTS `wz_questactskilldata`;
CREATE TABLE `wz_questactskilldata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`skillid` int(11) NOT NULL DEFAULT '0',
`skillLevel` int(11) NOT NULL DEFAULT '-1',
`masterLevel` int(11) NOT NULL DEFAULT '-1',
`uniqueid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
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;
DROP TABLE IF EXISTS `wz_questpartydata`;
CREATE TABLE `wz_questpartydata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`questid` int(11) NOT NULL DEFAULT '0',
`rank` varchar(1) NOT NULL DEFAULT '',
`mode` varchar(13) NOT NULL DEFAULT '',
`property` varchar(255) NOT NULL DEFAULT '',
`value` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `quests_ibfk_7` (`questid`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `wz_questreqdata`;
CREATE TABLE `wz_questreqdata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`questid` int(11) NOT NULL DEFAULT '0',
`name` varchar(127) NOT NULL DEFAULT '',
`type` tinyint(1) NOT NULL DEFAULT '0',
`stringStore` varchar(1024) NOT NULL DEFAULT '',
`intStoresFirst` varchar(1024) NOT NULL DEFAULT '',
`intStoresSecond` varchar(1024) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `quests_ibfk_1` (`questid`)
) ENGINE=InnoDB AUTO_INCREMENT=33615 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP VIEW IF EXISTS `readable_cheatlog`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `readable_cheatlog` AS select `a`.`name` AS `accountname`,`a`.`id` AS `accountid`,`c`.`name` AS `name`,`c`.`id` AS `characterid`,`cl`.`offense` AS `offense`,`cl`.`count` AS `count`,`cl`.`lastoffensetime` AS `lastoffensetime`,`cl`.`param` AS `param` from ((`cheatlog` `cl` join `characters` `c`) join `accounts` `a`) where ((`cl`.`id` = `c`.`id`) and (`a`.`id` = `c`.`accountid`) and (`a`.`banned` = 0));
DROP VIEW IF EXISTS `readable_last_hour_cheatlog`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `readable_last_hour_cheatlog` AS select `a`.`name` AS `accountname`,`a`.`id` AS `accountid`,`c`.`name` AS `name`,`c`.`id` AS `characterid`,sum(`cl`.`count`) AS `numrepos` from ((`cheatlog` `cl` join `characters` `c`) join `accounts` `a`) where ((`cl`.`id` = `c`.`id`) and (`a`.`id` = `c`.`accountid`) and (timestampdiff(HOUR,`cl`.`lastoffensetime`,now()) < 1) and (`a`.`banned` = 0)) group by `cl`.`id` order by sum(`cl`.`count`) desc;