-- This file is part of Hercules.
-- http://herc.ws - http://github.com/HerculesWS/Hercules
--
-- Copyright (C) 2012-2016 Hercules Dev Team
-- Copyright (C) Athena Dev Teams
--
-- Hercules is free software: you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation, either version 3 of the License, or
-- (at your option) any later version.
--
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with this program. If not, see <http://www.gnu.org/licenses/>.
--
-- Table structure for table `account_data`
--
CREATE TABLE IF NOT EXISTS `account_data` (
`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`bank_vault` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`base_exp` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '100',
`base_drop` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '100',
`base_death` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '100',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `acc_reg_num_db`
--
CREATE TABLE IF NOT EXISTS `acc_reg_num_db` (
`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
`index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`value` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`account_id`,`key`,`index`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `acc_reg_str_db`
--
CREATE TABLE IF NOT EXISTS `acc_reg_str_db` (
`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
`index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`value` VARCHAR(254) NOT NULL DEFAULT '0',
PRIMARY KEY (`account_id`,`key`,`index`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `auction`
--
-- start_time end_time min_price(step)
CREATE TABLE IF NOT EXISTS `auction` (
`auction_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`seller_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`seller_name` VARCHAR(30) NOT NULL DEFAULT '',
`buyer_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`buyer_name` VARCHAR(30) NOT NULL DEFAULT '',
`price` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`buynow` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`hours` SMALLINT(6) NOT NULL DEFAULT '0',
`timestamp` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`item_name` VARCHAR(50) NOT NULL DEFAULT '',
`type` SMALLINT(6) NOT NULL DEFAULT '0',
`refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
`card0` INT(11) NOT NULL DEFAULT '0',
`card1` INT(11) NOT NULL DEFAULT '0',
`card2` INT(11) NOT NULL DEFAULT '0',
`card3` INT(11) NOT NULL DEFAULT '0',
`opt_idx0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val0` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val1` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val2` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val3` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val4` SMALLINT(5) NOT NULL DEFAULT '0',
`unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`auction_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `autotrade_data`
--
CREATE TABLE IF NOT EXISTS `autotrade_data` (
`char_id` INT(11) NOT NULL DEFAULT '0',
`itemkey` INT(11) NOT NULL DEFAULT '0',
`amount` INT(11) NOT NULL DEFAULT '0',
`price` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`char_id`,`itemkey`)
) ENGINE=MyISAM;
--
-- Table structure for table `autotrade_merchants`
--
CREATE TABLE IF NOT EXISTS `autotrade_merchants` (
`account_id` INT(11) NOT NULL DEFAULT '0',
`char_id` INT(11) NOT NULL DEFAULT '0',
`sex` TINYINT(2) NOT NULL DEFAULT '0',
`title` VARCHAR(80) NOT NULL DEFAULT 'Buy From Me!',
PRIMARY KEY (`account_id`,`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `char_achievements`
--
CREATE TABLE IF NOT EXISTS `char_achievements` (
`char_id` INT(11) UNSIGNED NOT NULL,
`ach_id` INT(11) UNSIGNED NOT NULL,
`completed_at` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`rewarded_at` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`obj_0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`obj_1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`obj_2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`obj_3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`obj_4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`obj_5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`obj_6` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`obj_7` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`obj_8` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`obj_9` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`char_id`, `ach_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `cart_inventory`
--
CREATE TABLE IF NOT EXISTS `cart_inventory` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`char_id` INT(11) NOT NULL DEFAULT '0',
`nameid` INT(11) NOT NULL DEFAULT '0',
`amount` INT(11) NOT NULL DEFAULT '0',
`equip` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`identify` SMALLINT(6) NOT NULL DEFAULT '0',
`refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`attribute` TINYINT(4) NOT NULL DEFAULT '0',
`card0` INT(11) NOT NULL DEFAULT '0',
`card1` INT(11) NOT NULL DEFAULT '0',
`card2` INT(11) NOT NULL DEFAULT '0',
`card3` INT(11) NOT NULL DEFAULT '0',
`opt_idx0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val0` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val1` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val2` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val3` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val4` SMALLINT(5) NOT NULL DEFAULT '0',
`expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `char`
--
CREATE TABLE IF NOT EXISTS `char` (
`char_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`char_num` TINYINT(1) NOT NULL DEFAULT '0',
`name` VARCHAR(30) NOT NULL DEFAULT '',
`class` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`base_level` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '1',
`job_level` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '1',
`base_exp` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`job_exp` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`zeny` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`str` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`agi` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`vit` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`int` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`dex` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`luk` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`max_hp` INT(9) UNSIGNED NOT NULL DEFAULT '0',
`hp` INT(9) UNSIGNED NOT NULL DEFAULT '0',
`max_sp` INT(9) UNSIGNED NOT NULL DEFAULT '0',
`sp` INT(9) UNSIGNED NOT NULL DEFAULT '0',
`status_point` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`skill_point` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`option` INT(11) NOT NULL DEFAULT '0',
`karma` TINYINT(3) NOT NULL DEFAULT '0',
`manner` SMALLINT(6) NOT NULL DEFAULT '0',
`party_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`clan_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`pet_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`homun_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`elemental_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`hair` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
`hair_color` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`clothes_color` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`body` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`weapon` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`shield` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`head_top` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`head_mid` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`head_bottom` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`robe` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`last_login` BIGINT(20) NULL DEFAULT '0',
`last_map` VARCHAR(11) NOT NULL DEFAULT '',
`last_x` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '53',
`last_y` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '111',
`save_map` VARCHAR(11) NOT NULL DEFAULT '',
`save_x` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '53',
`save_y` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '111',
`partner_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`online` TINYINT(2) NOT NULL DEFAULT '0',
`father` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`mother` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`child` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`fame` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`rename` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
`delete_date` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`slotchange` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
`char_opt` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`font` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`unban_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`uniqueitem_counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`sex` ENUM('M','F','U') NOT NULL DEFAULT 'U',
`hotkey_rowshift` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`hotkey_rowshift2` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`attendance_count` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`attendance_timer` BIGINT(20) NULL DEFAULT '0',
`title_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`inventory_size` INT(11) UNSIGNED NOT NULL DEFAULT '100',
PRIMARY KEY (`char_id`),
UNIQUE KEY `name_key` (`name`),
KEY `account_id` (`account_id`),
KEY `party_id` (`party_id`),
KEY `guild_id` (`guild_id`),
KEY `online` (`online`)
) ENGINE=MyISAM AUTO_INCREMENT=150000;
--
-- Table structure for table `char_reg_num_db`
--
CREATE TABLE IF NOT EXISTS `char_reg_num_db` (
`char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
`index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`value` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`char_id`,`key`,`index`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `char_reg_str_db`
--
CREATE TABLE IF NOT EXISTS `char_reg_str_db` (
`char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
`index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`value` VARCHAR(254) NOT NULL DEFAULT '0',
PRIMARY KEY (`char_id`,`key`,`index`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `charlog`
--
CREATE TABLE IF NOT EXISTS `charlog` (
`time` DATETIME NULL,
`char_msg` VARCHAR(255) NOT NULL DEFAULT 'char select',
`account_id` INT(11) NOT NULL DEFAULT '0',
`char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`char_num` TINYINT(4) NOT NULL DEFAULT '0',
`class` MEDIUMINT(9) NOT NULL DEFAULT '0',
`name` VARCHAR(23) NOT NULL DEFAULT '',
`str` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`agi` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`vit` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`int` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`dex` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`luk` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`hair` TINYINT(4) NOT NULL DEFAULT '0',
`hair_color` INT(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM;
--
-- Table structure for table `discord`
--
CREATE TABLE IF NOT EXISTS `discord` (
`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`discord_id` VARCHAR(255) NOT NULL DEFAULT '',
`discord_name` VARCHAR(255) NOT NULL DEFAULT '',
`verified` ENUM('0', '1') NOT NULL DEFAULT '0',
PRIMARY KEY (`discord_name`),
UNIQUE KEY (`account_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `patreon`
--
-- account_id (Game issued)
-- client_id (Patreon issued)
CREATE TABLE IF NOT EXISTS `patreon` (
`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`client_id` VARCHAR(255) NOT NULL DEFAULT '',
`access_token` VARCHAR(255) NOT NULL DEFAULT '',
`currently_entitled_amount_cents` INT(11) DEFAULT '0',
`verified` ENUM('0', '1') NOT NULL DEFAULT '0'
) ENGINE=MyISAM;
--
-- Table structure for table `elemental`
--
CREATE TABLE IF NOT EXISTS `elemental` (
`ele_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`char_id` INT(11) NOT NULL,
`class` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
`mode` INT(11) UNSIGNED NOT NULL DEFAULT '1',
`hp` INT(12) NOT NULL DEFAULT '1',
`sp` INT(12) NOT NULL DEFAULT '1',
`max_hp` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`max_sp` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT '0',
`atk1` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT '0',
`atk2` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT '0',
`matk` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT '0',
`aspd` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`def` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`mdef` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`flee` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`hit` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`life_time` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`ele_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `friends`
--
CREATE TABLE IF NOT EXISTS `friends` (
`char_id` INT(11) NOT NULL DEFAULT '0',
`friend_account` INT(11) NOT NULL DEFAULT '0',
`friend_id` INT(11) NOT NULL DEFAULT '0',
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `hotkey`
--
CREATE TABLE IF NOT EXISTS `hotkey` (
`char_id` INT(11) NOT NULL,
`hotkey` TINYINT(2) UNSIGNED NOT NULL,
`type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`itemskill_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`skill_lvl` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`char_id`,`hotkey`)
) ENGINE=MyISAM;
--
-- Table structure for table `global_acc_reg_num_db`
--
CREATE TABLE IF NOT EXISTS `global_acc_reg_num_db` (
`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
`index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`value` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`account_id`,`key`,`index`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `global_acc_reg_str_db`
--
CREATE TABLE IF NOT EXISTS `global_acc_reg_str_db` (
`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
`index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`value` VARCHAR(254) NOT NULL DEFAULT '0',
PRIMARY KEY (`account_id`,`key`,`index`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `guild`
--
CREATE TABLE IF NOT EXISTS `guild` (
`guild_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(24) NOT NULL DEFAULT '',
`char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`master` VARCHAR(24) NOT NULL DEFAULT '',
`guild_lv` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
`connect_member` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
`max_member` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
`average_lv` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '1',
`exp` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`next_exp` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`skill_point` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0',
`mes1` VARCHAR(60) NOT NULL DEFAULT '',
`mes2` VARCHAR(120) NOT NULL DEFAULT '',
`emblem_len` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`emblem_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`emblem_data` blob,
PRIMARY KEY (`guild_id`,`char_id`),
UNIQUE KEY `guild_id` (`guild_id`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `guild_alliance`
--
CREATE TABLE IF NOT EXISTS `guild_alliance` (
`guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`opposition` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`alliance_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`name` VARCHAR(24) NOT NULL DEFAULT '',
PRIMARY KEY (`guild_id`,`alliance_id`),
KEY `alliance_id` (`alliance_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `guild_castle`
--
CREATE TABLE IF NOT EXISTS `guild_castle` (
`castle_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`economy` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`defense` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`triggerE` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`triggerD` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`nextTime` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`payTime` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`createTime` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`visibleC` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`visibleG0` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`visibleG1` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`visibleG2` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`visibleG3` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`visibleG4` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`visibleG5` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`visibleG6` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`visibleG7` INT(11) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`castle_id`),
KEY `guild_id` (`guild_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `guild_expulsion`
--
CREATE TABLE IF NOT EXISTS `guild_expulsion` (
`guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`name` VARCHAR(24) NOT NULL DEFAULT '',
`mes` VARCHAR(40) NOT NULL DEFAULT '',
PRIMARY KEY (`guild_id`,`name`)
) ENGINE=MyISAM;
--
-- Table structure for table `guild_member`
--
CREATE TABLE IF NOT EXISTS `guild_member` (
`guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`hair` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
`hair_color` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`gender` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
`class` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`lv` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`exp` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`exp_payper` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0',
`online` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
`position` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
`name` VARCHAR(24) NOT NULL DEFAULT '',
PRIMARY KEY (`guild_id`,`char_id`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `guild_position`
--
CREATE TABLE IF NOT EXISTS `guild_position` (
`guild_id` INT(9) UNSIGNED NOT NULL DEFAULT '0',
`position` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
`name` VARCHAR(24) NOT NULL DEFAULT '',
`mode` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0',
`exp_mode` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`guild_id`,`position`)
) ENGINE=MyISAM;
--
-- Table structure for table `guild_skill`
--
CREATE TABLE IF NOT EXISTS `guild_skill` (
`guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
`lv` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`guild_id`,`id`)
) ENGINE=MyISAM;
--
-- Table structure for table `guild_storage`
--
CREATE TABLE IF NOT EXISTS `guild_storage` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`equip` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`identify` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
`card0` INT(11) NOT NULL DEFAULT '0',
`card1` INT(11) NOT NULL DEFAULT '0',
`card2` INT(11) NOT NULL DEFAULT '0',
`card3` INT(11) NOT NULL DEFAULT '0',
`opt_idx0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val0` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val1` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val2` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val3` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val4` SMALLINT(5) NOT NULL DEFAULT '0',
`expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `guild_id` (`guild_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `homunculus`
--
CREATE TABLE IF NOT EXISTS `homunculus` (
`homun_id` INT(11) NOT NULL AUTO_INCREMENT,
`char_id` INT(11) NOT NULL,
`class` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
`prev_class` MEDIUMINT(9) NOT NULL DEFAULT '0',
`name` VARCHAR(24) NOT NULL DEFAULT '',
`level` SMALLINT(4) NOT NULL DEFAULT '0',
`exp` INT(12) NOT NULL DEFAULT '0',
`intimacy` INT(12) NOT NULL DEFAULT '0',
`hunger` SMALLINT(4) NOT NULL DEFAULT '0',
`str` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`agi` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`vit` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`INT` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`dex` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`luk` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`hp` INT(12) NOT NULL DEFAULT '1',
`max_hp` INT(12) NOT NULL DEFAULT '1',
`sp` INT(12) NOT NULL DEFAULT '1',
`max_sp` INT(12) NOT NULL DEFAULT '1',
`skill_point` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`alive` TINYINT(2) NOT NULL DEFAULT '1',
`rename_flag` TINYINT(2) NOT NULL DEFAULT '0',
`vaporize` TINYINT(2) NOT NULL DEFAULT '0',
`autofeed` TINYINT(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`homun_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `interlog`
--
CREATE TABLE IF NOT EXISTS `interlog` (
`time` DATETIME NULL,
`log` VARCHAR(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM;
--
-- Table structure for table `inventory`
--
CREATE TABLE IF NOT EXISTS `inventory` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`equip` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`identify` SMALLINT(6) NOT NULL DEFAULT '0',
`refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
`card0` INT(11) NOT NULL DEFAULT '0',
`card1` INT(11) NOT NULL DEFAULT '0',
`card2` INT(11) NOT NULL DEFAULT '0',
`card3` INT(11) NOT NULL DEFAULT '0',
`opt_idx0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val0` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val1` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val2` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val3` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val4` SMALLINT(5) NOT NULL DEFAULT '0',
`expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`favorite` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `ipbanlist`
--
CREATE TABLE IF NOT EXISTS `ipbanlist` (
`list` VARCHAR(255) NOT NULL DEFAULT '',
`btime` DATETIME NULL,
`rtime` DATETIME NULL,
`reason` VARCHAR(255) NOT NULL DEFAULT '',
KEY (`list`)
) ENGINE=MyISAM;
--
-- Table structure for table `login`
--
CREATE TABLE IF NOT EXISTS `login` (
`account_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`userid` VARCHAR(23) NOT NULL DEFAULT '',
`user_pass` VARCHAR(32) NOT NULL DEFAULT '',
`sex` ENUM('M','F','S') NOT NULL DEFAULT 'M',
`email` VARCHAR(39) NOT NULL DEFAULT '',
`group_id` TINYINT(3) NOT NULL DEFAULT '0',
`state` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`unban_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`expiration_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`logincount` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
`lastlogin` DATETIME NULL,
`last_ip` VARCHAR(100) NOT NULL DEFAULT '',
`birthdate` DATE NULL,
`character_slots` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`pincode` VARCHAR(4) NOT NULL DEFAULT '',
`pincode_change` INT(11) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`account_id`),
KEY `name` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=2000000;
-- added standard accounts for servers, VERY INSECURE!!!
-- inserted into the table called login which is above
INSERT IGNORE INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES ('1', 's1', 'p1', 'S','athena@athena.com');
--
-- Table structure for table `mapreg`
--
CREATE TABLE IF NOT EXISTS `mapreg` (
`varname` VARCHAR(32) BINARY NOT NULL,
`index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`value` VARCHAR(255) NOT NULL,
PRIMARY KEY (`varname`,`index`)
) ENGINE=MyISAM;
--
-- Table structure for table `map_reg_num_db`
--
CREATE TABLE IF NOT EXISTS `map_reg_num_db` (
`key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
`index` INT UNSIGNED NOT NULL DEFAULT '0',
`value` INT NOT NULL DEFAULT '0',
PRIMARY KEY (`key`, `index`)
) ENGINE=MyISAM;
--
-- Table structure for table `map_reg_str_db`
--
CREATE TABLE IF NOT EXISTS `map_reg_str_db` (
`key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
`index` INT UNSIGNED NOT NULL DEFAULT '0',
`value` VARCHAR(255) NOT NULL DEFAULT '0',
PRIMARY KEY (`key`, `index`)
) ENGINE=MyISAM;
--
-- Table structure for table `npc_market_data`
--
CREATE TABLE IF NOT EXISTS `npc_market_data` (
`name` VARCHAR(24) NOT NULL DEFAULT '',
`itemid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`name`,`itemid`)
) ENGINE=MyISAM;
--
-- Table structure for table `sc_data`
--
CREATE TABLE IF NOT EXISTS `sc_data` (
`account_id` INT(11) UNSIGNED NOT NULL,
`char_id` INT(11) UNSIGNED NOT NULL,
`type` SMALLINT(11) UNSIGNED NOT NULL,
`tick` INT(11) NOT NULL,
`total_tick` INT NOT NULL,
`val1` INT(11) NOT NULL DEFAULT '0',
`val2` INT(11) NOT NULL DEFAULT '0',
`val3` INT(11) NOT NULL DEFAULT '0',
`val4` INT(11) NOT NULL DEFAULT '0',
KEY (`account_id`),
KEY (`char_id`),
PRIMARY KEY (`account_id`,`char_id`,`type`)
) ENGINE=MyISAM;
--
-- Table structure for table `mail`
--
CREATE TABLE IF NOT EXISTS `mail` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`send_name` VARCHAR(30) NOT NULL DEFAULT '',
`send_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`dest_name` VARCHAR(30) NOT NULL DEFAULT '',
`dest_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`title` VARCHAR(45) NOT NULL DEFAULT '',
`message` VARCHAR(255) NOT NULL DEFAULT '',
`time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`status` TINYINT(2) NOT NULL DEFAULT '0',
`zeny` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
`identify` SMALLINT(6) NOT NULL DEFAULT '0',
`card0` INT(11) NOT NULL DEFAULT '0',
`card1` INT(11) NOT NULL DEFAULT '0',
`card2` INT(11) NOT NULL DEFAULT '0',
`card3` INT(11) NOT NULL DEFAULT '0',
`opt_idx0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val0` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val1` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val2` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val3` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val4` SMALLINT(5) NOT NULL DEFAULT '0',
`unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
--
-- Table structure for table `memo`
--
CREATE TABLE IF NOT EXISTS `memo` (
`memo_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`map` VARCHAR(11) NOT NULL DEFAULT '',
`x` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`y` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`memo_id`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `mercenary`
--
CREATE TABLE IF NOT EXISTS `mercenary` (
`mer_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`char_id` INT(11) NOT NULL,
`class` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
`hp` INT(12) NOT NULL DEFAULT '1',
`sp` INT(12) NOT NULL DEFAULT '1',
`kill_counter` INT(11) NOT NULL,
`life_time` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`mer_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `mercenary_owner`
--
CREATE TABLE IF NOT EXISTS `mercenary_owner` (
`char_id` INT(11) NOT NULL,
`merc_id` INT(11) NOT NULL DEFAULT '0',
`arch_calls` INT(11) NOT NULL DEFAULT '0',
`arch_faith` INT(11) NOT NULL DEFAULT '0',
`spear_calls` INT(11) NOT NULL DEFAULT '0',
`spear_faith` INT(11) NOT NULL DEFAULT '0',
`sword_calls` INT(11) NOT NULL DEFAULT '0',
`sword_faith` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `party`
--
CREATE TABLE IF NOT EXISTS `party` (
`party_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(24) NOT NULL DEFAULT '',
`exp` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0',
`item` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0',
`leader_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`leader_char` INT(11) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`party_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `pet`
--
CREATE TABLE IF NOT EXISTS `pet` (
`pet_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`class` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
`name` VARCHAR(24) NOT NULL DEFAULT '',
`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`level` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`egg_id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
`equip` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`intimate` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
`hungry` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
`rename_flag` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
`incubate` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`autofeed` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`pet_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `quest`
--
CREATE TABLE IF NOT EXISTS `quest` (
`char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`quest_id` INT(10) UNSIGNED NOT NULL,
`state` ENUM('0','1','2') NOT NULL DEFAULT '0',
`time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`count1` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`count2` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`count3` INT(11) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`char_id`,`quest_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `ragsrvinfo`
--
CREATE TABLE IF NOT EXISTS `ragsrvinfo` (
`index` INT(11) NOT NULL DEFAULT '0',
`name` VARCHAR(255) NOT NULL DEFAULT '',
`exp` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`jexp` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`drop` INT(11) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM;
--
-- Table structure for table `skill`
--
CREATE TABLE IF NOT EXISTS `skill` (
`char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
`lv` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
`flag` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`char_id`,`id`)
) ENGINE=MyISAM;
--
-- Table structure for table `skill_homunculus`
--
CREATE TABLE IF NOT EXISTS `skill_homunculus` (
`homun_id` INT(11) NOT NULL,
`id` INT(11) NOT NULL,
`lv` SMALLINT(6) NOT NULL,
PRIMARY KEY (`homun_id`,`id`)
) ENGINE=MyISAM;
--
-- Table structure for table `sql_updates`
--
CREATE TABLE IF NOT EXISTS `sql_updates` (
`timestamp` INT(11) UNSIGNED NOT NULL,
`ignored` ENUM('Yes','No') NOT NULL DEFAULT 'No',
PRIMARY KEY (`timestamp`)
) ENGINE=MyISAM;
-- Existent updates to enter
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1360858500); -- 2013-02-14--16-15.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1360951560); -- 2013-02-15--18-06.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1362445531); -- 2013-03-05--01-05.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1362528000); -- 2013-03-06--00-00.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1362794218); -- 2013-03-09--01-56.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1364409316); -- 2013-03-27--18-35.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1366075474); -- 2013-04-16--01-24.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1366078541); -- 2013-04-16--02-15.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1381354728); -- 2013-10-09--21-38.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1381423003); -- 2013-10-10--16-36.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1382892428); -- 2013-10-27--16-47.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1383162785); -- 2013-10-30--19-53.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1383167577); -- 2013-10-30--21-12.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1383205740); -- 2013-10-31--07-49.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1383955424); -- 2013-11-09--00-03.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1384473995); -- 2013-11-15--00-06.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1384545461); -- 2013-11-15--19-57.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1384588175); -- 2013-11-16--07-49.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1384763034); -- 2013-11-18--08-23.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1387844126); -- 2013-12-24--00-15.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1388854043); -- 2014-01-04--16-47.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1389028967); -- 2014-01-06--17-22.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1392832626); -- 2014-02-19--17-57.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1395789302); -- 2014-03-25--23-57.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1396893866); -- 2014-04-07--22-04.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1398477600); -- 2014-04-26--10-00.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1400256139); -- 2014-05-17--00-06.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1409590380); -- 2014-09-01--16-53.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1414975503); -- 2014-11-03--00-45.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1435860840); -- 2015-07-02--18-14.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1436360978); -- 2015-07-08--13-08.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1440688342); -- 2015-08-27--20-42.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1450241859); -- 2015-12-16--12-57.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1450367880); -- 2015-12-17--15-58.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1457638175); -- 2016-03-10--22-18.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1467934919); -- 2016-07-08--02-42.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1467935469); -- 2016-07-08--02-51.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1475526420); -- 2016-10-03--20-27.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1477434595); -- 2016-10-26--10-29.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1488454834); -- 2017-03-02--11-40.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1488744559); -- 2017-03-05--08-09.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1489588190); -- 2017-03-15--14-29.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1496588640); -- 2017-06-04--15-04.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1496588700); -- 2017-06-04--15-05.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1509835214); -- 2017-11-04--10-39.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1519671456); -- 2018-02-26--15-57.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1520654809); -- 2018-03-10--04-06.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1527964800); -- 2018-06-03--00-10.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1528026381); -- 2018-06-03--17-16.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1528180320); -- 2018-06-05--12-02.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1532403228); -- 2018-07-24--03-23.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1535865732); -- 2018-09-01--05-22.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1544738447); -- 2018-12-14--01-02.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1546059075); -- 2018-12-29--07-51.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1554760320); -- 2019-04-08--21-52.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1556147483); -- 2019-04-25--02-12.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1557414445); -- 2019-05-09--18-07.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1565293394); -- 2019-08-08--19-43.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1570309293); -- 2019-10-05--19-01.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1570870260); -- 2019-10-21--14-21.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1574463539); -- 2019-11-22--23-58.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1579817630); -- 2020-01-24--01-09.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1584838560); -- 2020-03-22--01-56.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1584842940); -- 2020-03-22--03-09.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1588301040); -- 2020-05-01--04-44.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1589145060); -- 2020-05-10--23-11.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1596240000); -- 2020-08-01--00-00.sql
--
-- Table structure for table `storage`
--
CREATE TABLE IF NOT EXISTS `storage` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`storage_id` INT UNSIGNED NOT NULL DEFAULT '1',
`nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`equip` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`identify` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
`card0` INT(11) NOT NULL DEFAULT '0',
`card1` INT(11) NOT NULL DEFAULT '0',
`card2` INT(11) NOT NULL DEFAULT '0',
`card3` INT(11) NOT NULL DEFAULT '0',
`opt_idx0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val0` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val1` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val2` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val3` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val4` SMALLINT(5) NOT NULL DEFAULT '0',
`expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `rodex_items` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`mail_id` BIGINT(20) NOT NULL DEFAULT '0',
`nameid` INT(11) NOT NULL DEFAULT '0',
`amount` INT(11) NOT NULL DEFAULT '0',
`equip` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`identify` SMALLINT(6) NOT NULL DEFAULT '0',
`refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`attribute` TINYINT(4) NOT NULL DEFAULT '0',
`card0` INT(11) NOT NULL DEFAULT '0',
`card1` INT(11) NOT NULL DEFAULT '0',
`card2` INT(11) NOT NULL DEFAULT '0',
`card3` INT(11) NOT NULL DEFAULT '0',
`opt_idx0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val0` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val1` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val2` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val3` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val4` SMALLINT(5) NOT NULL DEFAULT '0',
`expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `mail_id` (`mail_id`)
) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS `rodex_mail` (
`mail_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
`sender_name` VARCHAR(30) NOT NULL,
`sender_id` INT(11) NOT NULL,
`receiver_name` VARCHAR(30) NOT NULL,
`receiver_id` INT(11) NOT NULL,
`receiver_accountid` INT(11) NOT NULL,
`title` VARCHAR(50) NOT NULL,
`body` VARCHAR(510) NOT NULL,
`zeny` BIGINT(20) NOT NULL,
`type` TINYINT(8) UNSIGNED NOT NULL,
`is_read` TINYINT(8) NOT NULL,
`sender_read` TINYINT(2) NOT NULL,
`send_date` INT(11) NOT NULL,
`expire_date` INT(11) NOT NULL,
`weight` INT(11) NOT NULL,
PRIMARY KEY (`mail_id`),
KEY `sender_id` (`sender_id`),
KEY `receiver_id` (`receiver_id`),
KEY `receiver_accountid` (`receiver_accountid`),
KEY `send_date` (`send_date`),
KEY `expire_date` (`expire_date`)
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `npc_barter_data` (
`name` VARCHAR(24) NOT NULL DEFAULT '',
`itemId` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`priceId` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`priceAmount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`name`, `itemid`, `priceId`, `priceAmount`)
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `npc_expanded_barter_data` (
`name` VARCHAR(24) NOT NULL DEFAULT '',
`itemId` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`zeny` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyId1` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyAmount1` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyRefine1` INT(11) NOT NULL DEFAULT '0',
`currencyId2` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyAmount2` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyRefine2` INT(11) NOT NULL DEFAULT '0',
`currencyId3` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyAmount3` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyRefine3` INT(11) NOT NULL DEFAULT '0',
`currencyId4` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyAmount4` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyRefine4` INT(11) NOT NULL DEFAULT '0',
`currencyId5` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyAmount5` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyRefine5` INT(11) NOT NULL DEFAULT '0',
`currencyId6` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyAmount6` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyRefine6` INT(11) NOT NULL DEFAULT '0',
`currencyId7` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyAmount7` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyRefine7` INT(11) NOT NULL DEFAULT '0',
`currencyId8` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyAmount8` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyRefine8` INT(11) NOT NULL DEFAULT '0',
`currencyId9` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyAmount9` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyRefine9` INT(11) NOT NULL DEFAULT '0',
`currencyId10` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyAmount10` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`currencyRefine10` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`name`, `itemid`, `zeny`,
`currencyId1`, `currencyAmount1`, `currencyRefine1`,
`currencyId2`, `currencyAmount2`, `currencyRefine2`,
`currencyId3`, `currencyAmount3`, `currencyRefine3`,
`currencyId4`, `currencyAmount4`, `currencyRefine4`
)
) ENGINE=MyISAM;
-- Bound items cannot go to ManaMarket anyway
-- PS. id autofilled, accountid/price/expire by MM
-- options by index, all others by getinventorylist()
CREATE TABLE IF NOT EXISTS `manamarket` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`price` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`amount` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
`equip` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`identify` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
`card0` INT(11) NOT NULL DEFAULT '0',
`card1` INT(11) NOT NULL DEFAULT '0',
`card2` INT(11) NOT NULL DEFAULT '0',
`card3` INT(11) NOT NULL DEFAULT '0',
`opt_idx0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val0` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val1` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val2` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val3` SMALLINT(5) NOT NULL DEFAULT '0',
`opt_idx4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`opt_val4` SMALLINT(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
