-- MySQL dump 10.19  Distrib 10.3.28-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: f2p
-- ------------------------------------------------------
-- Server version	10.3.28-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `acc_reg_num_db`
--

DROP TABLE IF EXISTS `acc_reg_num_db`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `acc_reg_num_db` (
  `account_id` int(10) unsigned NOT NULL DEFAULT 0,
  `key` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `index` int(10) 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 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `acc_reg_str_db`
--

DROP TABLE IF EXISTS `acc_reg_str_db`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `acc_reg_str_db` (
  `account_id` int(10) unsigned NOT NULL DEFAULT 0,
  `key` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `index` int(10) unsigned NOT NULL DEFAULT 0,
  `value` varchar(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`account_id`,`key`,`index`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `account_data`
--

DROP TABLE IF EXISTS `account_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `account_data` (
  `account_id` int(10) unsigned NOT NULL DEFAULT 0,
  `bank_vault` int(10) unsigned NOT NULL DEFAULT 0,
  `base_exp` smallint(5) unsigned NOT NULL DEFAULT 100,
  `base_drop` smallint(5) unsigned NOT NULL DEFAULT 100,
  `base_death` smallint(5) unsigned NOT NULL DEFAULT 100,
  `attendance_count` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `attendance_timer` bigint(20) DEFAULT 0,
  PRIMARY KEY (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `auction`
--

DROP TABLE IF EXISTS `auction`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auction` (
  `auction_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) unsigned NOT NULL DEFAULT 0,
  `seller_name` varchar(30) NOT NULL DEFAULT '',
  `buyer_id` int(10) unsigned NOT NULL DEFAULT 0,
  `buyer_name` varchar(30) NOT NULL DEFAULT '',
  `price` int(10) unsigned NOT NULL DEFAULT 0,
  `buynow` int(10) unsigned NOT NULL DEFAULT 0,
  `hours` smallint(6) NOT NULL DEFAULT 0,
  `timestamp` int(10) unsigned NOT NULL DEFAULT 0,
  `nameid` int(10) 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,
  `grade` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `attribute` tinyint(3) 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(6) NOT NULL DEFAULT 0,
  `opt_idx1` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val1` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx2` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val2` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx3` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val3` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx4` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val4` smallint(6) NOT NULL DEFAULT 0,
  `unique_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`auction_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `autotrade_data`
--

DROP TABLE IF EXISTS `autotrade_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `autotrade_merchants`
--

DROP TABLE IF EXISTS `autotrade_merchants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `autotrade_merchants` (
  `account_id` int(11) NOT NULL DEFAULT 0,
  `char_id` int(11) NOT NULL DEFAULT 0,
  `sex` tinyint(4) NOT NULL DEFAULT 0,
  `title` varchar(80) NOT NULL DEFAULT 'Buy From Me!',
  PRIMARY KEY (`account_id`,`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `bank`
--

DROP TABLE IF EXISTS `bank`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bank` (
  `account_id` int(11) NOT NULL DEFAULT 0,
  `money` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cart_inventory`
--

DROP TABLE IF EXISTS `cart_inventory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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(10) unsigned NOT NULL DEFAULT 0,
  `identify` smallint(6) NOT NULL DEFAULT 0,
  `refine` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `grade` 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(6) NOT NULL DEFAULT 0,
  `opt_idx1` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val1` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx2` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val2` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx3` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val3` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx4` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val4` smallint(6) NOT NULL DEFAULT 0,
  `expire_time` int(10) unsigned NOT NULL DEFAULT 0,
  `bound` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `unique_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `char_id` (`char_id`)
) ENGINE=MyISAM AUTO_INCREMENT=781 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cashlog`
--

DROP TABLE IF EXISTS `cashlog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cashlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` datetime DEFAULT NULL,
  `account_id` int(11) NOT NULL DEFAULT 0,
  `char_id` int(11) unsigned NOT NULL DEFAULT 0,
  `points` int(11) unsigned NOT NULL DEFAULT 0,
  `amount` int(11) NOT NULL DEFAULT 0,
  `npc` varchar(20) DEFAULT NULL,
  `map` varchar(11) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `channel_ban`
--

DROP TABLE IF EXISTS `channel_ban`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `channel_ban` (
  `account_id` int(11) unsigned NOT NULL,
  `char_id` int(11) unsigned NOT NULL,
  `channel_id` tinyint(1) unsigned NOT NULL,
  `date` datetime NOT NULL,
  `gm_name` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `char`
--

DROP TABLE IF EXISTS `char`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `char` (
  `char_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL DEFAULT 0,
  `char_num` tinyint(4) NOT NULL DEFAULT 0,
  `name` varchar(30) NOT NULL DEFAULT '',
  `class` smallint(5) unsigned NOT NULL DEFAULT 0,
  `base_level` smallint(5) unsigned NOT NULL DEFAULT 1,
  `job_level` smallint(5) 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(10) unsigned NOT NULL DEFAULT 0,
  `str` smallint(5) unsigned NOT NULL DEFAULT 0,
  `agi` smallint(5) unsigned NOT NULL DEFAULT 0,
  `vit` smallint(5) unsigned NOT NULL DEFAULT 0,
  `int` smallint(5) unsigned NOT NULL DEFAULT 0,
  `dex` smallint(5) unsigned NOT NULL DEFAULT 0,
  `luk` smallint(5) unsigned NOT NULL DEFAULT 0,
  `max_hp` int(10) unsigned NOT NULL DEFAULT 0,
  `hp` int(10) unsigned NOT NULL DEFAULT 0,
  `max_sp` int(10) unsigned NOT NULL DEFAULT 0,
  `sp` int(10) unsigned NOT NULL DEFAULT 0,
  `status_point` int(10) unsigned NOT NULL DEFAULT 0,
  `skill_point` int(10) unsigned NOT NULL DEFAULT 0,
  `option` int(11) NOT NULL DEFAULT 0,
  `karma` tinyint(4) NOT NULL DEFAULT 0,
  `manner` smallint(6) NOT NULL DEFAULT 0,
  `party_id` int(10) unsigned NOT NULL DEFAULT 0,
  `guild_id` int(10) unsigned NOT NULL DEFAULT 0,
  `clan_id` int(10) unsigned NOT NULL DEFAULT 0,
  `pet_id` int(10) unsigned NOT NULL DEFAULT 0,
  `homun_id` int(10) unsigned NOT NULL DEFAULT 0,
  `elemental_id` int(10) unsigned NOT NULL DEFAULT 0,
  `hair` tinyint(3) 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(5) unsigned NOT NULL DEFAULT 0,
  `shield` smallint(5) unsigned NOT NULL DEFAULT 0,
  `head_top` smallint(5) unsigned NOT NULL DEFAULT 0,
  `head_mid` smallint(5) unsigned NOT NULL DEFAULT 0,
  `head_bottom` smallint(5) unsigned NOT NULL DEFAULT 0,
  `robe` smallint(5) unsigned NOT NULL DEFAULT 0,
  `last_login` bigint(20) DEFAULT 0,
  `last_map` varchar(11) NOT NULL DEFAULT '',
  `last_x` smallint(5) unsigned NOT NULL DEFAULT 53,
  `last_y` smallint(5) unsigned NOT NULL DEFAULT 111,
  `save_map` varchar(11) NOT NULL DEFAULT '',
  `save_x` smallint(5) unsigned NOT NULL DEFAULT 53,
  `save_y` smallint(5) unsigned NOT NULL DEFAULT 111,
  `partner_id` int(10) unsigned NOT NULL DEFAULT 0,
  `online` tinyint(4) NOT NULL DEFAULT 0,
  `father` int(10) unsigned NOT NULL DEFAULT 0,
  `mother` int(10) unsigned NOT NULL DEFAULT 0,
  `child` int(10) unsigned NOT NULL DEFAULT 0,
  `fame` int(10) unsigned NOT NULL DEFAULT 0,
  `rename` smallint(5) unsigned NOT NULL DEFAULT 0,
  `delete_date` int(10) unsigned NOT NULL DEFAULT 0,
  `slotchange` smallint(5) unsigned NOT NULL DEFAULT 0,
  `char_opt` int(10) unsigned NOT NULL DEFAULT 0,
  `font` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `unban_time` int(10) 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,
  `title_id` int(10) unsigned NOT NULL DEFAULT 0,
  `inventory_size` int(10) 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=150881 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `char_achievements`
--

DROP TABLE IF EXISTS `char_achievements`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `char_achievements` (
  `char_id` int(10) unsigned NOT NULL,
  `ach_id` int(10) 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 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `char_reg_num_db`
--

DROP TABLE IF EXISTS `char_reg_num_db`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `char_reg_num_db` (
  `char_id` int(10) unsigned NOT NULL DEFAULT 0,
  `key` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `index` int(10) 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 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `char_reg_str_db`
--

DROP TABLE IF EXISTS `char_reg_str_db`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `char_reg_str_db` (
  `char_id` int(10) unsigned NOT NULL DEFAULT 0,
  `key` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `index` int(10) unsigned NOT NULL DEFAULT 0,
  `value` varchar(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`char_id`,`key`,`index`),
  KEY `char_id` (`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `charlog`
--

DROP TABLE IF EXISTS `charlog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `charlog` (
  `time` datetime DEFAULT NULL,
  `char_msg` varchar(255) NOT NULL DEFAULT 'char select',
  `account_id` int(11) NOT NULL DEFAULT 0,
  `char_id` int(10) 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(10) unsigned NOT NULL DEFAULT 0,
  `agi` int(10) unsigned NOT NULL DEFAULT 0,
  `vit` int(10) unsigned NOT NULL DEFAULT 0,
  `int` int(10) unsigned NOT NULL DEFAULT 0,
  `dex` int(10) unsigned NOT NULL DEFAULT 0,
  `luk` int(10) unsigned NOT NULL DEFAULT 0,
  `hair` tinyint(4) NOT NULL DEFAULT 0,
  `hair_color` int(11) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `claim_codes`
--

DROP TABLE IF EXISTS `claim_codes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `claim_codes` (
  `serial` int(11) unsigned NOT NULL DEFAULT 0,
  `code` varchar(32) NOT NULL DEFAULT '',
  `nameid` int(11) unsigned NOT NULL DEFAULT 0,
  `item_name` varchar(45) NOT NULL DEFAULT '',
  `amount` int(11) unsigned NOT NULL DEFAULT 0,
  `time_created` int(11) NOT NULL DEFAULT 0,
  `redeem_time` int(11) NOT NULL DEFAULT 0,
  `account_id` int(11) unsigned NOT NULL DEFAULT 0,
  `name` varchar(30) NOT NULL DEFAULT '0',
  `claimed` int(1) unsigned NOT NULL DEFAULT 0,
  `reclaim` tinyint(1) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cp_banlog`
--

DROP TABLE IF EXISTS `cp_banlog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_banlog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(11) unsigned NOT NULL,
  `banned_by` int(11) unsigned DEFAULT NULL,
  `ban_type` tinyint(1) NOT NULL,
  `ban_until` datetime NOT NULL,
  `ban_date` datetime NOT NULL,
  `ban_reason` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `account_id` (`account_id`,`banned_by`)
) ENGINE=MyISAM AUTO_INCREMENT=1566 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cp_changelogs`
--

DROP TABLE IF EXISTS `cp_changelogs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_changelogs` (
  `cl_id` int(11) NOT NULL AUTO_INCREMENT,
  `gmname` text NOT NULL,
  `category` int(1) NOT NULL,
  `subject` text DEFAULT NULL,
  `text` text DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `link` text DEFAULT NULL,
  PRIMARY KEY (`cl_id`)
) ENGINE=MyISAM AUTO_INCREMENT=567 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cp_charprefs`
--

DROP TABLE IF EXISTS `cp_charprefs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_charprefs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(11) unsigned NOT NULL,
  `char_id` int(11) unsigned NOT NULL,
  `name` varchar(80) NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `account_id` (`account_id`,`char_id`),
  KEY `char_id` (`char_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COMMENT='Character preferences.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cp_createlog`
--

DROP TABLE IF EXISTS `cp_createlog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_createlog` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(11) unsigned NOT NULL,
  `userid` varchar(23) NOT NULL,
  `user_pass` varchar(32) NOT NULL,
  `sex` enum('M','F','S') NOT NULL DEFAULT 'M',
  `email` varchar(39) NOT NULL,
  `reg_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `reg_ip` varchar(100) NOT NULL,
  `delete_date` datetime DEFAULT NULL,
  `confirmed` tinyint(1) NOT NULL DEFAULT 1,
  `confirm_code` varchar(32) DEFAULT NULL,
  `confirm_expire` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`userid`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1050 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cp_credits`
--

DROP TABLE IF EXISTS `cp_credits`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_credits` (
  `account_id` int(11) unsigned NOT NULL,
  `balance` int(11) unsigned NOT NULL DEFAULT 0,
  `last_donation_date` datetime DEFAULT NULL,
  `last_donation_amount` float unsigned DEFAULT NULL,
  PRIMARY KEY (`account_id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Donation credits balance for a given account.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cp_emailchange`
--

DROP TABLE IF EXISTS `cp_emailchange`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_emailchange` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(32) NOT NULL,
  `account_id` int(10) NOT NULL,
  `old_email` varchar(39) NOT NULL,
  `new_email` varchar(39) NOT NULL,
  `request_date` datetime NOT NULL,
  `request_ip` varchar(15) NOT NULL,
  `change_date` datetime DEFAULT NULL,
  `change_ip` varchar(15) DEFAULT NULL,
  `change_done` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cp_ipbanlog`
--

DROP TABLE IF EXISTS `cp_ipbanlog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_ipbanlog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(15) NOT NULL,
  `banned_by` int(11) unsigned DEFAULT NULL,
  `ban_type` tinyint(1) NOT NULL,
  `ban_until` datetime NOT NULL,
  `ban_date` datetime NOT NULL,
  `ban_reason` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ip_address` (`ip_address`),
  KEY `banned_by` (`banned_by`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cp_itemdesc`
--

DROP TABLE IF EXISTS `cp_itemdesc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_itemdesc` (
  `itemid` smallint(5) unsigned NOT NULL DEFAULT 0,
  `itemdesc` text DEFAULT NULL,
  PRIMARY KEY (`itemid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cp_itemshop`
--

DROP TABLE IF EXISTS `cp_itemshop`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_itemshop` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nameid` int(11) unsigned NOT NULL DEFAULT 0,
  `category` int(11) DEFAULT NULL,
  `quantity` int(11) unsigned NOT NULL DEFAULT 0,
  `cost` int(11) unsigned NOT NULL,
  `info` text DEFAULT NULL,
  `use_existing` tinyint(4) NOT NULL DEFAULT 0,
  `create_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `nameid` (`nameid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Item shop';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cp_loginlog`
--

DROP TABLE IF EXISTS `cp_loginlog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_loginlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(10) DEFAULT NULL,
  `username` varchar(23) NOT NULL,
  `password` varchar(32) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `login_date` datetime NOT NULL,
  `error_code` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM AUTO_INCREMENT=548 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cp_loginprefs`
--

DROP TABLE IF EXISTS `cp_loginprefs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_loginprefs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(11) unsigned NOT NULL,
  `name` varchar(80) NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Account preferences';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cp_pwchange`
--

DROP TABLE IF EXISTS `cp_pwchange`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_pwchange` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(10) NOT NULL,
  `old_password` varchar(32) NOT NULL,
  `new_password` varchar(32) DEFAULT NULL,
  `change_date` datetime NOT NULL,
  `change_ip` varchar(15) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cp_redeemlog`
--

DROP TABLE IF EXISTS `cp_redeemlog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_redeemlog` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nameid` int(11) unsigned NOT NULL DEFAULT 0,
  `quantity` int(11) unsigned NOT NULL DEFAULT 0,
  `cost` int(11) unsigned NOT NULL,
  `account_id` int(11) unsigned NOT NULL,
  `char_id` int(11) unsigned DEFAULT NULL,
  `redeemed` tinyint(1) unsigned NOT NULL,
  `redemption_date` datetime DEFAULT NULL,
  `purchase_date` datetime NOT NULL,
  `credits_before` int(10) NOT NULL,
  `credits_after` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `nameid` (`nameid`,`account_id`,`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Log of redeemed donation items.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cp_resetpass`
--

DROP TABLE IF EXISTS `cp_resetpass`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_resetpass` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(32) NOT NULL,
  `account_id` int(10) NOT NULL,
  `old_password` varchar(32) NOT NULL,
  `new_password` varchar(32) DEFAULT NULL,
  `request_date` datetime NOT NULL,
  `request_ip` varchar(15) NOT NULL,
  `reset_date` datetime DEFAULT NULL,
  `reset_ip` varchar(15) DEFAULT NULL,
  `reset_done` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cp_trusted`
--

DROP TABLE IF EXISTS `cp_trusted`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_trusted` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(11) unsigned NOT NULL,
  `email` varchar(255) NOT NULL,
  `create_date` datetime NOT NULL,
  `delete_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cp_txnlog`
--

DROP TABLE IF EXISTS `cp_txnlog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_txnlog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(11) unsigned DEFAULT 0,
  `server_name` varchar(255) DEFAULT NULL,
  `credits` int(11) DEFAULT 0,
  `receiver_email` varchar(60) DEFAULT NULL,
  `item_name` varchar(100) DEFAULT NULL,
  `item_number` varchar(10) DEFAULT NULL,
  `quantity` varchar(6) DEFAULT NULL,
  `payment_status` varchar(20) DEFAULT NULL,
  `pending_reason` varchar(20) DEFAULT NULL,
  `payment_date` varchar(40) DEFAULT NULL,
  `mc_gross` varchar(20) DEFAULT NULL,
  `mc_fee` varchar(20) DEFAULT NULL,
  `tax` varchar(20) DEFAULT NULL,
  `mc_currency` varchar(3) DEFAULT NULL,
  `parent_txn_id` varchar(20) DEFAULT NULL,
  `txn_id` varchar(20) DEFAULT NULL,
  `txn_type` varchar(20) DEFAULT NULL,
  `first_name` varchar(30) DEFAULT NULL,
  `last_name` varchar(40) DEFAULT NULL,
  `address_street` varchar(50) DEFAULT NULL,
  `address_city` varchar(30) DEFAULT NULL,
  `address_state` varchar(30) DEFAULT NULL,
  `address_zip` varchar(20) DEFAULT NULL,
  `address_country` varchar(30) DEFAULT NULL,
  `address_status` varchar(30) DEFAULT NULL,
  `payer_email` varchar(60) DEFAULT NULL,
  `payer_status` varchar(10) DEFAULT NULL,
  `payment_type` varchar(10) DEFAULT NULL,
  `notify_version` varchar(10) DEFAULT NULL,
  `verify_sign` varchar(255) DEFAULT NULL,
  `referrer_id` varchar(30) DEFAULT NULL,
  `process_date` datetime DEFAULT NULL,
  `hold_until` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `account_id` (`account_id`),
  KEY `parent_txn_id` (`parent_txn_id`),
  KEY `txn_id` (`txn_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='All PayPal transactions that go through the IPN handler.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cp_xferlog`
--

DROP TABLE IF EXISTS `cp_xferlog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_xferlog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `from_account_id` int(10) unsigned NOT NULL,
  `target_account_id` int(10) unsigned NOT NULL,
  `target_char_id` int(11) unsigned NOT NULL,
  `amount` int(10) unsigned NOT NULL,
  `for_free` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `transfer_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `from_account_id` (`from_account_id`,`target_account_id`,`target_char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Credit transfer log.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `elemental`
--

DROP TABLE IF EXISTS `elemental`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `elemental` (
  `ele_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `char_id` int(11) NOT NULL,
  `class` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `mode` int(10) unsigned NOT NULL DEFAULT 1,
  `hp` int(11) NOT NULL DEFAULT 1,
  `sp` int(11) NOT NULL DEFAULT 1,
  `max_hp` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `max_sp` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `atk1` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `atk2` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `matk` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `aspd` smallint(5) unsigned NOT NULL DEFAULT 0,
  `def` smallint(5) unsigned NOT NULL DEFAULT 0,
  `mdef` smallint(5) unsigned NOT NULL DEFAULT 0,
  `flee` smallint(5) unsigned NOT NULL DEFAULT 0,
  `hit` smallint(5) unsigned NOT NULL DEFAULT 0,
  `life_time` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`ele_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `friends`
--

DROP TABLE IF EXISTS `friends`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `gepard_block`
--

DROP TABLE IF EXISTS `gepard_block`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gepard_block` (
  `unique_id` int(11) unsigned NOT NULL DEFAULT 0,
  `unban_time` datetime NOT NULL,
  `reason` varchar(50) NOT NULL,
  UNIQUE KEY `unique_id` (`unique_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `gepard_block_log`
--

DROP TABLE IF EXISTS `gepard_block_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gepard_block_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `unique_id` int(11) unsigned NOT NULL DEFAULT 0,
  `block_time` datetime NOT NULL,
  `unban_time` datetime NOT NULL,
  `violator_name` varchar(24) NOT NULL,
  `violator_account_id` int(11) NOT NULL,
  `initiator_name` varchar(24) NOT NULL,
  `initiator_account_id` int(11) NOT NULL,
  `reason` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `gepard_min_allowed_license_version`
--

DROP TABLE IF EXISTS `gepard_min_allowed_license_version`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gepard_min_allowed_license_version` (
  `version` int(11) unsigned NOT NULL DEFAULT 2018033001
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `global_acc_reg_num_db`
--

DROP TABLE IF EXISTS `global_acc_reg_num_db`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `global_acc_reg_num_db` (
  `account_id` int(10) unsigned NOT NULL DEFAULT 0,
  `key` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `index` int(10) 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 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `global_acc_reg_str_db`
--

DROP TABLE IF EXISTS `global_acc_reg_str_db`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `global_acc_reg_str_db` (
  `account_id` int(10) unsigned NOT NULL DEFAULT 0,
  `key` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `index` int(10) unsigned NOT NULL DEFAULT 0,
  `value` varchar(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`account_id`,`key`,`index`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `gm_reward`
--

DROP TABLE IF EXISTS `gm_reward`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gm_reward` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gm_aid` int(11) NOT NULL DEFAULT 0,
  `gm_name` varchar(30) NOT NULL DEFAULT '',
  `nameid` int(11) NOT NULL DEFAULT 0,
  `amount` int(11) unsigned NOT NULL DEFAULT 0,
  `refine` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `card1` smallint(4) unsigned NOT NULL DEFAULT 0,
  `card2` smallint(4) unsigned NOT NULL DEFAULT 0,
  `card3` smallint(4) unsigned NOT NULL DEFAULT 0,
  `card4` smallint(4) unsigned NOT NULL DEFAULT 0,
  `format_name` varchar(30) NOT NULL DEFAULT 'null',
  `reward_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `claim_aid` int(11) NOT NULL DEFAULT 0,
  `claim_name` varchar(30) NOT NULL DEFAULT '',
  `claim_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `note` varchar(255) NOT NULL DEFAULT 'none',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `guild`
--

DROP TABLE IF EXISTS `guild`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `guild` (
  `guild_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(24) NOT NULL DEFAULT '',
  `char_id` int(10) unsigned NOT NULL DEFAULT 0,
  `master` varchar(24) NOT NULL DEFAULT '',
  `guild_lv` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `connect_member` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `max_member` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `max_storage` smallint(5) unsigned NOT NULL DEFAULT 0,
  `average_lv` smallint(5) unsigned NOT NULL DEFAULT 1,
  `exp` bigint(20) unsigned NOT NULL DEFAULT 0,
  `next_exp` int(10) unsigned NOT NULL DEFAULT 0,
  `skill_point` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `mes1` varchar(60) NOT NULL DEFAULT '',
  `mes2` varchar(120) NOT NULL DEFAULT '',
  `emblem_len` int(10) unsigned NOT NULL DEFAULT 0,
  `emblem_id` int(10) unsigned NOT NULL DEFAULT 0,
  `emblem_data` blob DEFAULT NULL,
  PRIMARY KEY (`guild_id`,`char_id`),
  UNIQUE KEY `guild_id` (`guild_id`),
  KEY `char_id` (`char_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `guild_alliance`
--

DROP TABLE IF EXISTS `guild_alliance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `guild_alliance` (
  `guild_id` int(10) unsigned NOT NULL DEFAULT 0,
  `opposition` int(10) unsigned NOT NULL DEFAULT 0,
  `alliance_id` int(10) unsigned NOT NULL DEFAULT 0,
  `name` varchar(24) NOT NULL DEFAULT '',
  PRIMARY KEY (`guild_id`,`alliance_id`),
  KEY `alliance_id` (`alliance_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `guild_castle`
--

DROP TABLE IF EXISTS `guild_castle`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `guild_castle` (
  `castle_id` int(10) unsigned NOT NULL DEFAULT 0,
  `guild_id` int(10) unsigned NOT NULL DEFAULT 0,
  `economy` int(10) unsigned NOT NULL DEFAULT 0,
  `defense` int(10) unsigned NOT NULL DEFAULT 0,
  `triggerE` int(10) unsigned NOT NULL DEFAULT 0,
  `triggerD` int(10) unsigned NOT NULL DEFAULT 0,
  `nextTime` int(10) unsigned NOT NULL DEFAULT 0,
  `payTime` int(10) unsigned NOT NULL DEFAULT 0,
  `createTime` int(10) unsigned NOT NULL DEFAULT 0,
  `visibleC` int(10) unsigned NOT NULL DEFAULT 0,
  `visibleG0` int(10) unsigned NOT NULL DEFAULT 0,
  `visibleG1` int(10) unsigned NOT NULL DEFAULT 0,
  `visibleG2` int(10) unsigned NOT NULL DEFAULT 0,
  `visibleG3` int(10) unsigned NOT NULL DEFAULT 0,
  `visibleG4` int(10) unsigned NOT NULL DEFAULT 0,
  `visibleG5` int(10) unsigned NOT NULL DEFAULT 0,
  `visibleG6` int(10) unsigned NOT NULL DEFAULT 0,
  `visibleG7` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`castle_id`),
  KEY `guild_id` (`guild_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `guild_expulsion`
--

DROP TABLE IF EXISTS `guild_expulsion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `guild_expulsion` (
  `guild_id` int(10) unsigned NOT NULL DEFAULT 0,
  `account_id` int(10) unsigned NOT NULL DEFAULT 0,
  `char_id` int(10) unsigned NOT NULL DEFAULT 0,
  `name` varchar(24) NOT NULL DEFAULT '',
  `mes` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`guild_id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `guild_member`
--

DROP TABLE IF EXISTS `guild_member`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `guild_member` (
  `guild_id` int(10) unsigned NOT NULL DEFAULT 0,
  `account_id` int(10) unsigned NOT NULL DEFAULT 0,
  `char_id` int(10) unsigned NOT NULL DEFAULT 0,
  `hair` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `hair_color` smallint(5) unsigned NOT NULL DEFAULT 0,
  `gender` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `class` smallint(5) unsigned NOT NULL DEFAULT 0,
  `lv` smallint(5) unsigned NOT NULL DEFAULT 0,
  `exp` bigint(20) unsigned NOT NULL DEFAULT 0,
  `exp_payper` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `online` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `position` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `name` varchar(24) NOT NULL DEFAULT '',
  PRIMARY KEY (`guild_id`,`char_id`),
  KEY `char_id` (`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `guild_position`
--

DROP TABLE IF EXISTS `guild_position`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `guild_position` (
  `guild_id` int(10) unsigned NOT NULL DEFAULT 0,
  `position` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `name` varchar(24) NOT NULL DEFAULT '',
  `mode` smallint(5) unsigned NOT NULL DEFAULT 0,
  `exp_mode` tinyint(3) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`guild_id`,`position`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `guild_skill`
--

DROP TABLE IF EXISTS `guild_skill`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `guild_skill` (
  `guild_id` int(10) unsigned NOT NULL DEFAULT 0,
  `id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `lv` tinyint(3) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`guild_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `guild_storage`
--

DROP TABLE IF EXISTS `guild_storage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `guild_storage` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `guild_id` int(10) unsigned NOT NULL DEFAULT 0,
  `nameid` int(10) unsigned NOT NULL DEFAULT 0,
  `amount` int(10) unsigned NOT NULL DEFAULT 0,
  `equip` int(10) unsigned NOT NULL DEFAULT 0,
  `identify` smallint(5) unsigned NOT NULL DEFAULT 0,
  `refine` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `grade` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `attribute` tinyint(3) 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(6) NOT NULL DEFAULT 0,
  `opt_idx1` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val1` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx2` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val2` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx3` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val3` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx4` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val4` smallint(6) NOT NULL DEFAULT 0,
  `expire_time` int(10) unsigned NOT NULL DEFAULT 0,
  `bound` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `unique_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `guild_id` (`guild_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `homunculus`
--

DROP TABLE IF EXISTS `homunculus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `homunculus` (
  `homun_id` int(11) NOT NULL AUTO_INCREMENT,
  `char_id` int(11) NOT NULL,
  `class` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `prev_class` mediumint(9) NOT NULL DEFAULT 0,
  `name` varchar(24) NOT NULL DEFAULT '',
  `level` smallint(6) NOT NULL DEFAULT 0,
  `exp` bigint(20) NOT NULL DEFAULT 0,
  `intimacy` int(11) NOT NULL DEFAULT 0,
  `hunger` smallint(6) NOT NULL DEFAULT 0,
  `str` smallint(5) unsigned NOT NULL DEFAULT 0,
  `agi` smallint(5) unsigned NOT NULL DEFAULT 0,
  `vit` smallint(5) unsigned NOT NULL DEFAULT 0,
  `INT` smallint(5) unsigned NOT NULL DEFAULT 0,
  `dex` smallint(5) unsigned NOT NULL DEFAULT 0,
  `luk` smallint(5) unsigned NOT NULL DEFAULT 0,
  `hp` int(11) NOT NULL DEFAULT 1,
  `max_hp` int(11) NOT NULL DEFAULT 1,
  `sp` int(11) NOT NULL DEFAULT 1,
  `max_sp` int(11) NOT NULL DEFAULT 1,
  `skill_point` smallint(5) unsigned NOT NULL DEFAULT 0,
  `alive` tinyint(4) NOT NULL DEFAULT 1,
  `rename_flag` tinyint(4) NOT NULL DEFAULT 0,
  `vaporize` tinyint(4) NOT NULL DEFAULT 0,
  `autofeed` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`homun_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hotkey`
--

DROP TABLE IF EXISTS `hotkey`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hotkey` (
  `char_id` int(11) NOT NULL,
  `hotkey` tinyint(3) unsigned NOT NULL,
  `type` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `itemskill_id` int(10) unsigned NOT NULL DEFAULT 0,
  `skill_lvl` tinyint(3) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`char_id`,`hotkey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `interlog`
--

DROP TABLE IF EXISTS `interlog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `interlog` (
  `time` datetime DEFAULT NULL,
  `log` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `inventory`
--

DROP TABLE IF EXISTS `inventory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inventory` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `char_id` int(10) unsigned NOT NULL DEFAULT 0,
  `nameid` int(10) unsigned NOT NULL DEFAULT 0,
  `amount` int(10) unsigned NOT NULL DEFAULT 0,
  `equip` int(10) unsigned NOT NULL DEFAULT 0,
  `identify` smallint(6) NOT NULL DEFAULT 0,
  `refine` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `grade` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `attribute` tinyint(3) 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(6) NOT NULL DEFAULT 0,
  `opt_idx1` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val1` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx2` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val2` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx3` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val3` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx4` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val4` smallint(6) NOT NULL DEFAULT 0,
  `expire_time` int(10) unsigned NOT NULL DEFAULT 0,
  `favorite` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `bound` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `unique_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `char_id` (`char_id`)
) ENGINE=MyISAM AUTO_INCREMENT=75021 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ipbanlist`
--

DROP TABLE IF EXISTS `ipbanlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipbanlist` (
  `list` varchar(39) NOT NULL DEFAULT '',
  `btime` datetime DEFAULT NULL,
  `rtime` datetime DEFAULT NULL,
  `reason` varchar(255) NOT NULL DEFAULT '',
  KEY `list` (`list`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `item_db`
--

DROP TABLE IF EXISTS `item_db`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `item_db` (
  `id` int(10) unsigned NOT NULL DEFAULT 0,
  `name_english` varchar(50) NOT NULL DEFAULT '',
  `name_japanese` varchar(50) NOT NULL DEFAULT '',
  `type` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `subtype` tinyint(3) unsigned DEFAULT NULL,
  `price_buy` mediumint(9) DEFAULT NULL,
  `price_sell` mediumint(9) DEFAULT NULL,
  `weight` smallint(5) unsigned DEFAULT NULL,
  `atk` smallint(5) unsigned DEFAULT NULL,
  `matk` smallint(5) unsigned DEFAULT NULL,
  `defence` smallint(5) unsigned DEFAULT NULL,
  `range` tinyint(3) unsigned DEFAULT NULL,
  `slots` tinyint(3) unsigned DEFAULT NULL,
  `equip_jobs` bigint(20) unsigned DEFAULT NULL,
  `equip_upper` tinyint(3) unsigned DEFAULT NULL,
  `equip_genders` tinyint(3) unsigned DEFAULT NULL,
  `equip_locations` mediumint(8) unsigned DEFAULT NULL,
  `weapon_level` tinyint(3) unsigned DEFAULT NULL,
  `equip_level_min` smallint(5) unsigned DEFAULT NULL,
  `equip_level_max` smallint(5) unsigned DEFAULT NULL,
  `refineable` tinyint(3) unsigned DEFAULT NULL,
  `gradeable` tinyint(3) unsigned DEFAULT NULL,
  `disable_options` tinyint(3) unsigned DEFAULT NULL,
  `view_sprite` smallint(5) unsigned DEFAULT NULL,
  `bindonequip` tinyint(3) unsigned DEFAULT NULL,
  `forceserial` tinyint(3) unsigned DEFAULT NULL,
  `buyingstore` tinyint(3) unsigned DEFAULT NULL,
  `delay` mediumint(8) unsigned DEFAULT NULL,
  `keepafteruse` tinyint(3) unsigned DEFAULT NULL,
  `dropannounce` tinyint(3) unsigned DEFAULT NULL,
  `showdropeffect` tinyint(3) unsigned DEFAULT NULL,
  `dropeffectmode` tinyint(3) unsigned DEFAULT NULL,
  `ignorediscount` tinyint(3) unsigned DEFAULT NULL,
  `ignoreovercharge` tinyint(3) unsigned DEFAULT NULL,
  `trade_flag` smallint(5) unsigned DEFAULT NULL,
  `trade_group` smallint(5) unsigned DEFAULT NULL,
  `nouse_flag` smallint(5) unsigned DEFAULT NULL,
  `nouse_group` smallint(5) unsigned DEFAULT NULL,
  `stack_amount` mediumint(8) unsigned DEFAULT NULL,
  `stack_flag` tinyint(3) unsigned DEFAULT NULL,
  `sprite` mediumint(8) unsigned DEFAULT NULL,
  `script` text DEFAULT NULL,
  `equip_script` text DEFAULT NULL,
  `unequip_script` text DEFAULT NULL,
  `rental_start_script` text DEFAULT NULL,
  `rental_end_script` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `item_db2`
--

DROP TABLE IF EXISTS `item_db2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `item_db2` (
  `id` int(10) unsigned NOT NULL DEFAULT 0,
  `name_english` varchar(50) NOT NULL DEFAULT '',
  `name_japanese` varchar(50) NOT NULL DEFAULT '',
  `type` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `subtype` tinyint(3) unsigned DEFAULT NULL,
  `price_buy` mediumint(9) DEFAULT NULL,
  `price_sell` mediumint(9) DEFAULT NULL,
  `weight` smallint(5) unsigned DEFAULT NULL,
  `atk` smallint(5) unsigned DEFAULT NULL,
  `matk` smallint(5) unsigned DEFAULT NULL,
  `defence` smallint(5) unsigned DEFAULT NULL,
  `range` tinyint(3) unsigned DEFAULT NULL,
  `slots` tinyint(3) unsigned DEFAULT NULL,
  `equip_jobs` bigint(20) unsigned DEFAULT NULL,
  `equip_upper` tinyint(3) unsigned DEFAULT NULL,
  `equip_genders` tinyint(3) unsigned DEFAULT NULL,
  `equip_locations` mediumint(8) unsigned DEFAULT NULL,
  `weapon_level` tinyint(3) unsigned DEFAULT NULL,
  `equip_level_min` smallint(5) unsigned DEFAULT NULL,
  `equip_level_max` smallint(5) unsigned DEFAULT NULL,
  `refineable` tinyint(3) unsigned DEFAULT NULL,
  `gradeable` tinyint(3) unsigned DEFAULT NULL,
  `disable_options` tinyint(3) unsigned DEFAULT NULL,
  `view_sprite` smallint(5) unsigned DEFAULT NULL,
  `bindonequip` tinyint(3) unsigned DEFAULT NULL,
  `forceserial` tinyint(3) unsigned DEFAULT NULL,
  `buyingstore` tinyint(3) unsigned DEFAULT NULL,
  `delay` mediumint(8) unsigned DEFAULT NULL,
  `keepafteruse` tinyint(3) unsigned DEFAULT NULL,
  `dropannounce` tinyint(3) unsigned DEFAULT NULL,
  `showdropeffect` tinyint(3) unsigned DEFAULT NULL,
  `dropeffectmode` tinyint(3) unsigned DEFAULT NULL,
  `ignorediscount` tinyint(3) unsigned DEFAULT NULL,
  `ignoreovercharge` tinyint(3) unsigned DEFAULT NULL,
  `trade_flag` smallint(5) unsigned DEFAULT NULL,
  `trade_group` smallint(5) unsigned DEFAULT NULL,
  `nouse_flag` smallint(5) unsigned DEFAULT NULL,
  `nouse_group` smallint(5) unsigned DEFAULT NULL,
  `stack_amount` mediumint(8) unsigned DEFAULT NULL,
  `stack_flag` tinyint(3) unsigned DEFAULT NULL,
  `sprite` mediumint(8) unsigned DEFAULT NULL,
  `script` text DEFAULT NULL,
  `equip_script` text DEFAULT NULL,
  `unequip_script` text DEFAULT NULL,
  `rental_start_script` text DEFAULT NULL,
  `rental_end_script` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `item_reward`
--

DROP TABLE IF EXISTS `item_reward`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `item_reward` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nameid` int(11) NOT NULL DEFAULT 0,
  `qty` smallint(6) DEFAULT 1,
  `refine` smallint(2) DEFAULT 0,
  `card1` smallint(4) DEFAULT 0,
  `card2` smallint(4) DEFAULT 0,
  `card3` smallint(4) DEFAULT 0,
  `card4` smallint(4) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `login`
--

DROP TABLE IF EXISTS `login`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `login` (
  `account_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` varchar(23) NOT NULL,
  `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(4) NOT NULL DEFAULT 0,
  `state` int(10) unsigned NOT NULL DEFAULT 0,
  `unban_time` int(10) unsigned NOT NULL DEFAULT 0,
  `expiration_time` int(10) unsigned NOT NULL DEFAULT 0,
  `logincount` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `lastlogin` datetime DEFAULT NULL,
  `last_ip` varchar(100) NOT NULL DEFAULT '',
  `birthdate` date DEFAULT NULL,
  `character_slots` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `pincode` varchar(4) NOT NULL DEFAULT '',
  `pincode_change` int(10) unsigned NOT NULL DEFAULT 0,
  `last_unique_id` int(11) unsigned NOT NULL DEFAULT 0,
  `blocked_unique_id` int(11) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`account_id`),
  UNIQUE KEY `name` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=2001050 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mail`
--

DROP TABLE IF EXISTS `mail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mail` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `send_name` varchar(30) NOT NULL DEFAULT '',
  `send_id` int(10) unsigned NOT NULL DEFAULT 0,
  `dest_name` varchar(30) NOT NULL DEFAULT '',
  `dest_id` int(10) unsigned NOT NULL DEFAULT 0,
  `title` varchar(45) NOT NULL DEFAULT '',
  `message` varchar(255) NOT NULL DEFAULT '',
  `time` int(10) unsigned NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `zeny` int(10) unsigned NOT NULL DEFAULT 0,
  `nameid` int(10) unsigned NOT NULL DEFAULT 0,
  `amount` int(10) unsigned NOT NULL DEFAULT 0,
  `refine` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `grade` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `attribute` tinyint(3) 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(6) NOT NULL DEFAULT 0,
  `opt_idx1` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val1` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx2` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val2` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx3` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val3` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx4` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val4` smallint(6) NOT NULL DEFAULT 0,
  `unique_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `maintenance`
--

DROP TABLE IF EXISTS `maintenance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maintenance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) DEFAULT NULL,
  `name` varchar(23) DEFAULT NULL,
  `reason` varchar(99) DEFAULT NULL,
  `minlv2connect` tinyint(4) DEFAULT NULL,
  `order_time` datetime DEFAULT NULL,
  `start_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `map_reg_num_db`
--

DROP TABLE IF EXISTS `map_reg_num_db`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `map_reg_num_db` (
  `key` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `index` int(10) unsigned NOT NULL DEFAULT 0,
  `value` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`key`,`index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `map_reg_str_db`
--

DROP TABLE IF EXISTS `map_reg_str_db`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `map_reg_str_db` (
  `key` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `index` int(10) unsigned NOT NULL DEFAULT 0,
  `value` varchar(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`key`,`index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `memo`
--

DROP TABLE IF EXISTS `memo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `memo` (
  `memo_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `char_id` int(10) unsigned NOT NULL DEFAULT 0,
  `map` varchar(11) NOT NULL DEFAULT '',
  `x` smallint(5) unsigned NOT NULL DEFAULT 0,
  `y` smallint(5) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`memo_id`),
  KEY `char_id` (`char_id`)
) ENGINE=MyISAM AUTO_INCREMENT=350 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mercenary`
--

DROP TABLE IF EXISTS `mercenary`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mercenary` (
  `mer_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `char_id` int(11) NOT NULL,
  `class` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `hp` int(11) NOT NULL DEFAULT 1,
  `sp` int(11) NOT NULL DEFAULT 1,
  `kill_counter` int(11) NOT NULL,
  `life_time` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`mer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mercenary_owner`
--

DROP TABLE IF EXISTS `mercenary_owner`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mob_db`
--

DROP TABLE IF EXISTS `mob_db`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mob_db` (
  `ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `Sprite` text NOT NULL,
  `kName` text NOT NULL,
  `iName` text NOT NULL,
  `LV` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `HP` int(10) unsigned NOT NULL DEFAULT 0,
  `SP` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `EXP` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `JEXP` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `Range1` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `ATK1` smallint(5) unsigned NOT NULL DEFAULT 0,
  `ATK2` smallint(5) unsigned NOT NULL DEFAULT 0,
  `DEF` smallint(5) unsigned NOT NULL DEFAULT 0,
  `MDEF` smallint(5) unsigned NOT NULL DEFAULT 0,
  `STR` smallint(5) unsigned NOT NULL DEFAULT 0,
  `AGI` smallint(5) unsigned NOT NULL DEFAULT 0,
  `VIT` smallint(5) unsigned NOT NULL DEFAULT 0,
  `INT` smallint(5) unsigned NOT NULL DEFAULT 0,
  `DEX` smallint(5) unsigned NOT NULL DEFAULT 0,
  `LUK` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Range2` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `Range3` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `Scale` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `Race` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `Element` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `Mode` int(10) unsigned NOT NULL DEFAULT 0,
  `Speed` smallint(5) unsigned NOT NULL DEFAULT 0,
  `aDelay` smallint(5) unsigned NOT NULL DEFAULT 0,
  `aMotion` smallint(5) unsigned NOT NULL DEFAULT 0,
  `dMotion` smallint(5) unsigned NOT NULL DEFAULT 0,
  `MEXP` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `MVP1id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `MVP1per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `MVP2id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `MVP2per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `MVP3id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `MVP3per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop1id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop1per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop2id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop2per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop3id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop3per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop4id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop4per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop5id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop5per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop6id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop6per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop7id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop7per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop8id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop8per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop9id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop9per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `DropCardid` smallint(5) unsigned NOT NULL DEFAULT 0,
  `DropCardper` smallint(5) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mob_db2`
--

DROP TABLE IF EXISTS `mob_db2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mob_db2` (
  `ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `Sprite` text NOT NULL,
  `kName` text NOT NULL,
  `iName` text NOT NULL,
  `LV` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `HP` int(10) unsigned NOT NULL DEFAULT 0,
  `SP` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `EXP` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `JEXP` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `Range1` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `ATK1` smallint(5) unsigned NOT NULL DEFAULT 0,
  `ATK2` smallint(5) unsigned NOT NULL DEFAULT 0,
  `DEF` smallint(5) unsigned NOT NULL DEFAULT 0,
  `MDEF` smallint(5) unsigned NOT NULL DEFAULT 0,
  `STR` smallint(5) unsigned NOT NULL DEFAULT 0,
  `AGI` smallint(5) unsigned NOT NULL DEFAULT 0,
  `VIT` smallint(5) unsigned NOT NULL DEFAULT 0,
  `INT` smallint(5) unsigned NOT NULL DEFAULT 0,
  `DEX` smallint(5) unsigned NOT NULL DEFAULT 0,
  `LUK` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Range2` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `Range3` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `Scale` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `Race` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `Element` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `Mode` int(10) unsigned NOT NULL DEFAULT 0,
  `Speed` smallint(5) unsigned NOT NULL DEFAULT 0,
  `aDelay` smallint(5) unsigned NOT NULL DEFAULT 0,
  `aMotion` smallint(5) unsigned NOT NULL DEFAULT 0,
  `dMotion` smallint(5) unsigned NOT NULL DEFAULT 0,
  `MEXP` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `MVP1id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `MVP1per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `MVP2id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `MVP2per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `MVP3id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `MVP3per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop1id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop1per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop2id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop2per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop3id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop3per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop4id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop4per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop5id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop5per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop6id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop6per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop7id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop7per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop8id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop8per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop9id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `Drop9per` smallint(5) unsigned NOT NULL DEFAULT 0,
  `DropCardid` smallint(5) unsigned NOT NULL DEFAULT 0,
  `DropCardper` smallint(5) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mob_skill_db`
--

DROP TABLE IF EXISTS `mob_skill_db`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mob_skill_db` (
  `MOB_ID` smallint(6) NOT NULL,
  `INFO` text NOT NULL,
  `STATE` text NOT NULL,
  `SKILL_ID` smallint(6) NOT NULL,
  `SKILL_LV` tinyint(4) NOT NULL,
  `RATE` smallint(6) NOT NULL,
  `CASTTIME` mediumint(9) NOT NULL,
  `DELAY` int(11) NOT NULL,
  `CANCELABLE` text NOT NULL,
  `TARGET` text NOT NULL,
  `CONDITION` text NOT NULL,
  `CONDITION_VALUE` text DEFAULT NULL,
  `VAL1` int(11) DEFAULT NULL,
  `VAL2` int(11) DEFAULT NULL,
  `VAL3` int(11) DEFAULT NULL,
  `VAL4` int(11) DEFAULT NULL,
  `VAL5` int(11) DEFAULT NULL,
  `EMOTION` text DEFAULT NULL,
  `CHAT` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mob_skill_db2`
--

DROP TABLE IF EXISTS `mob_skill_db2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mob_skill_db2` (
  `MOB_ID` smallint(6) NOT NULL,
  `INFO` text NOT NULL,
  `STATE` text NOT NULL,
  `SKILL_ID` smallint(6) NOT NULL,
  `SKILL_LV` tinyint(4) NOT NULL,
  `RATE` smallint(6) NOT NULL,
  `CASTTIME` mediumint(9) NOT NULL,
  `DELAY` int(11) NOT NULL,
  `CANCELABLE` text NOT NULL,
  `TARGET` text NOT NULL,
  `CONDITION` text NOT NULL,
  `CONDITION_VALUE` text DEFAULT NULL,
  `VAL1` int(11) DEFAULT NULL,
  `VAL2` int(11) DEFAULT NULL,
  `VAL3` int(11) DEFAULT NULL,
  `VAL4` int(11) DEFAULT NULL,
  `VAL5` int(11) DEFAULT NULL,
  `EMOTION` text DEFAULT NULL,
  `CHAT` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mob_spawns`
--

DROP TABLE IF EXISTS `mob_spawns`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mob_spawns` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `map` varchar(20) NOT NULL,
  `name` varchar(40) NOT NULL,
  `mob_id` smallint(5) NOT NULL,
  `count` smallint(4) NOT NULL,
  `time_to` int(11) NOT NULL,
  `time_from` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `map` (`map`),
  KEY `mob_id` (`mob_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `npc_barter_data`
--

DROP TABLE IF EXISTS `npc_barter_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `npc_barter_data` (
  `name` varchar(24) NOT NULL DEFAULT '',
  `itemId` int(10) unsigned NOT NULL DEFAULT 0,
  `amount` int(10) unsigned NOT NULL DEFAULT 0,
  `priceId` int(10) unsigned NOT NULL DEFAULT 0,
  `priceAmount` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`name`,`itemId`,`priceId`,`priceAmount`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `npc_expanded_barter_data`
--

DROP TABLE IF EXISTS `npc_expanded_barter_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `npc_expanded_barter_data` (
  `name` varchar(24) NOT NULL DEFAULT '',
  `itemId` int(10) unsigned NOT NULL DEFAULT 0,
  `amount` int(10) unsigned NOT NULL DEFAULT 0,
  `zeny` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyId1` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyAmount1` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyRefine1` int(11) NOT NULL DEFAULT 0,
  `currencyId2` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyAmount2` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyRefine2` int(11) NOT NULL DEFAULT 0,
  `currencyId3` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyAmount3` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyRefine3` int(11) NOT NULL DEFAULT 0,
  `currencyId4` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyAmount4` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyRefine4` int(11) NOT NULL DEFAULT 0,
  `currencyId5` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyAmount5` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyRefine5` int(11) NOT NULL DEFAULT 0,
  `currencyId6` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyAmount6` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyRefine6` int(11) NOT NULL DEFAULT 0,
  `currencyId7` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyAmount7` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyRefine7` int(11) NOT NULL DEFAULT 0,
  `currencyId8` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyAmount8` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyRefine8` int(11) NOT NULL DEFAULT 0,
  `currencyId9` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyAmount9` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyRefine9` int(11) NOT NULL DEFAULT 0,
  `currencyId10` int(10) unsigned NOT NULL DEFAULT 0,
  `currencyAmount10` int(10) 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 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `npc_market_data`
--

DROP TABLE IF EXISTS `npc_market_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `npc_market_data` (
  `name` varchar(24) NOT NULL DEFAULT '',
  `itemid` int(10) unsigned NOT NULL DEFAULT 0,
  `amount` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`name`,`itemid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `party`
--

DROP TABLE IF EXISTS `party`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `party` (
  `party_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(24) NOT NULL DEFAULT '',
  `exp` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `item` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `leader_id` int(10) unsigned NOT NULL DEFAULT 0,
  `leader_char` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`party_id`)
) ENGINE=MyISAM AUTO_INCREMENT=257 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pet`
--

DROP TABLE IF EXISTS `pet`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pet` (
  `pet_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `class` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `name` varchar(24) NOT NULL DEFAULT '',
  `account_id` int(10) unsigned NOT NULL DEFAULT 0,
  `char_id` int(10) unsigned NOT NULL DEFAULT 0,
  `level` smallint(5) unsigned NOT NULL DEFAULT 0,
  `egg_id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `equip` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `intimate` smallint(5) unsigned NOT NULL DEFAULT 0,
  `hungry` smallint(5) unsigned NOT NULL DEFAULT 0,
  `rename_flag` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `incubate` int(10) unsigned NOT NULL DEFAULT 0,
  `autofeed` tinyint(3) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`pet_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pre_reg`
--

DROP TABLE IF EXISTS `pre_reg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pre_reg` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL DEFAULT '',
  `redeem_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `account_id` int(11) unsigned NOT NULL DEFAULT 0,
  `char_id` int(11) unsigned NOT NULL DEFAULT 0,
  `unique_id` int(11) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=128 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pvp_rank`
--

DROP TABLE IF EXISTS `pvp_rank`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pvp_rank` (
  `char_id` int(11) NOT NULL,
  `account_id` int(11) NOT NULL,
  `char` varchar(30) NOT NULL,
  `kill` int(11) NOT NULL,
  `death` int(11) NOT NULL,
  `kdr` varchar(30) NOT NULL,
  `killingstreak` int(11) NOT NULL,
  `multikill` int(11) NOT NULL,
  `killingspree` int(11) NOT NULL,
  `dominating` int(11) NOT NULL,
  `megakill` int(11) NOT NULL,
  `unstoppable` int(11) NOT NULL,
  `wickedsick` int(11) NOT NULL,
  `monsterkill` int(11) NOT NULL,
  `godlike` int(11) NOT NULL,
  `beyondgodlike` int(11) NOT NULL,
  `doublekill` int(11) NOT NULL,
  `triplekill` int(11) NOT NULL,
  `ultrakill` int(11) NOT NULL,
  `rampage` int(11) NOT NULL,
  `ownage` int(11) NOT NULL,
  `nemesiskill` int(11) NOT NULL,
  `feedcount` int(11) NOT NULL,
  PRIMARY KEY (`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `quest`
--

DROP TABLE IF EXISTS `quest`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quest` (
  `char_id` int(10) unsigned NOT NULL DEFAULT 0,
  `quest_id` int(10) unsigned NOT NULL,
  `state` enum('0','1','2') NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL DEFAULT 0,
  `count1` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `count2` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `count3` mediumint(8) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`char_id`,`quest_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ragsrvinfo`
--

DROP TABLE IF EXISTS `ragsrvinfo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ragsrvinfo` (
  `index` int(11) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `exp` int(10) unsigned NOT NULL DEFAULT 0,
  `jexp` int(10) unsigned NOT NULL DEFAULT 0,
  `drop` int(10) unsigned NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rodex_items`
--

DROP TABLE IF EXISTS `rodex_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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(10) unsigned NOT NULL DEFAULT 0,
  `identify` smallint(6) NOT NULL DEFAULT 0,
  `refine` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `grade` 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(6) NOT NULL DEFAULT 0,
  `opt_idx1` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val1` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx2` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val2` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx3` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val3` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx4` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val4` smallint(6) NOT NULL DEFAULT 0,
  `expire_time` int(10) unsigned NOT NULL DEFAULT 0,
  `bound` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `unique_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mail_id` (`mail_id`)
) ENGINE=InnoDB AUTO_INCREMENT=712 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rodex_mail`
--

DROP TABLE IF EXISTS `rodex_mail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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(3) unsigned NOT NULL,
  `is_read` tinyint(4) NOT NULL,
  `sender_read` tinyint(4) 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 AUTO_INCREMENT=749 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `sc_data`
--

DROP TABLE IF EXISTS `sc_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sc_data` (
  `account_id` int(10) unsigned NOT NULL,
  `char_id` int(10) unsigned NOT NULL,
  `type` smallint(5) unsigned NOT NULL,
  `tick` int(11) NOT NULL,
  `total_tick` int(11) 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,
  PRIMARY KEY (`account_id`,`char_id`,`type`),
  KEY `account_id` (`account_id`),
  KEY `char_id` (`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `skill`
--

DROP TABLE IF EXISTS `skill`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `skill` (
  `char_id` int(10) unsigned NOT NULL DEFAULT 0,
  `id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `lv` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `flag` tinyint(3) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`char_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `skill_homunculus`
--

DROP TABLE IF EXISTS `skill_homunculus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `sql_updates`
--

DROP TABLE IF EXISTS `sql_updates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sql_updates` (
  `timestamp` int(10) unsigned NOT NULL,
  `ignored` enum('Yes','No') NOT NULL DEFAULT 'No',
  PRIMARY KEY (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `storage`
--

DROP TABLE IF EXISTS `storage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storage` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL DEFAULT 0,
  `nameid` int(10) unsigned NOT NULL DEFAULT 0,
  `amount` smallint(5) unsigned NOT NULL DEFAULT 0,
  `equip` int(10) unsigned NOT NULL DEFAULT 0,
  `identify` smallint(5) unsigned NOT NULL DEFAULT 0,
  `refine` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `grade` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `attribute` tinyint(3) 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(6) NOT NULL DEFAULT 0,
  `opt_idx1` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val1` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx2` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val2` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx3` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val3` smallint(6) NOT NULL DEFAULT 0,
  `opt_idx4` smallint(5) unsigned NOT NULL DEFAULT 0,
  `opt_val4` smallint(6) NOT NULL DEFAULT 0,
  `expire_time` int(10) unsigned NOT NULL DEFAULT 0,
  `bound` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `unique_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10919 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `top3_event`
--

DROP TABLE IF EXISTS `top3_event`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `top3_event` (
  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `account_id` int(11) NOT NULL DEFAULT 0,
  `char_id` int(11) unsigned NOT NULL DEFAULT 0,
  `name` varchar(23) NOT NULL DEFAULT '',
  `class` smallint(6) unsigned NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AVG_ROW_LENGTH=45;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tournament`
--

DROP TABLE IF EXISTS `tournament`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tournament` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `party_id` int(10) NOT NULL DEFAULT 0,
  `guild_id` int(10) NOT NULL DEFAULT 0,
  `account_id` int(11) NOT NULL DEFAULT 0,
  `char_id` int(10) NOT NULL DEFAULT 0,
  `name` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tournament_saveset`
--

DROP TABLE IF EXISTS `tournament_saveset`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tournament_saveset` (
  `char_id` int(10) unsigned NOT NULL,
  `slot` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `top` smallint(5) unsigned NOT NULL DEFAULT 0,
  `top_refine` tinyint(2) unsigned NOT NULL DEFAULT 0,
  `top_card` smallint(5) unsigned NOT NULL DEFAULT 0,
  `mid` smallint(5) unsigned NOT NULL DEFAULT 0,
  `low` smallint(5) unsigned NOT NULL DEFAULT 0,
  `c_top` smallint(5) unsigned NOT NULL DEFAULT 0,
  `c_mid` smallint(5) unsigned NOT NULL DEFAULT 0,
  `c_low` smallint(5) unsigned NOT NULL DEFAULT 0,
  `weapon_1` smallint(5) unsigned NOT NULL DEFAULT 0,
  `weapon_1_refine` tinyint(2) NOT NULL DEFAULT 0,
  `weapon_1_card1` smallint(5) unsigned NOT NULL DEFAULT 0,
  `weapon_1_card2` smallint(5) unsigned NOT NULL DEFAULT 0,
  `weapon_1_card3` smallint(5) unsigned NOT NULL DEFAULT 0,
  `weapon_1_card4` smallint(5) unsigned NOT NULL DEFAULT 0,
  `weapon_2` smallint(5) unsigned NOT NULL DEFAULT 0,
  `weapon_2_refine` tinyint(2) unsigned NOT NULL DEFAULT 0,
  `weapon_2_card1` smallint(5) unsigned NOT NULL DEFAULT 0,
  `weapon_2_card2` smallint(5) unsigned NOT NULL DEFAULT 0,
  `weapon_2_card3` smallint(5) unsigned NOT NULL DEFAULT 0,
  `weapon_2_card4` smallint(5) unsigned NOT NULL DEFAULT 0,
  `armor` smallint(5) unsigned NOT NULL DEFAULT 0,
  `armor_refine` tinyint(2) unsigned NOT NULL DEFAULT 0,
  `armor_card` smallint(5) unsigned NOT NULL DEFAULT 0,
  `garment` smallint(5) unsigned NOT NULL DEFAULT 0,
  `garment_refine` tinyint(2) unsigned NOT NULL DEFAULT 0,
  `garment_card` smallint(5) unsigned NOT NULL DEFAULT 0,
  `shoes` smallint(5) unsigned NOT NULL DEFAULT 0,
  `shoes_refine` tinyint(2) unsigned NOT NULL DEFAULT 0,
  `shoes_card` smallint(5) unsigned NOT NULL DEFAULT 0,
  `acc_1` smallint(5) unsigned NOT NULL DEFAULT 0,
  `acc_1_card` smallint(5) unsigned NOT NULL DEFAULT 0,
  `acc_2` smallint(5) unsigned NOT NULL DEFAULT 0,
  `acc_2_card` smallint(5) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`char_id`),
  UNIQUE KEY `char_id` (`char_id`),
  KEY `slot` (`slot`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `vip_system`
--

DROP TABLE IF EXISTS `vip_system`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vip_system` (
  `char_id` int(11) unsigned NOT NULL,
  `start_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  PRIMARY KEY (`char_id`),
  UNIQUE KEY `char_id` (`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-10-11 10:12:04
