/*
MySQL Data Transfer
Source Host: localhost
Source Database: conquer
Target Host: localhost
Target Database: conquer
Date: 2008-7-26 14:30:36
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account
-- ----------------------------
CREATE TABLE `account` (  `AccountID` varchar(60) character set utf8 NOT NULL,  `Password` varchar(64) character set utf8 default NULL,  `LastLogon` time default NULL,  `LogonCount` int(11) NOT NULL default '0',  `LogonAction` int(11) NOT NULL default '2',  `Flags` int(11) default '0',  `IPAddress` varchar(128) character set utf8 default NULL,  `NID` varchar(500) character set gbk NOT NULL default '0',  PRIMARY KEY  (`AccountID`)) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for characters
-- ----------------------------
CREATE TABLE `characters` (  `CharacterID` int(11) NOT NULL auto_increment,  `Account` varchar(60) character set utf8 NOT NULL,  `Name` varchar(60) character set gbk NOT NULL,  `Level` smallint(11) NOT NULL default '1',  `Experience` int(11) NOT NULL default '0',  `Class` int(11) NOT NULL,  `Model` int(11) NOT NULL,  `Strength` int(11) NOT NULL default '0',  `Agility` int(11) NOT NULL default '0',  `Spirit` int(11) NOT NULL default '0',  `Vitality` int(11) NOT NULL default '0',  `Flags` int(11) NOT NULL default '0',  `HP` int(11) NOT NULL default '1',  `MP` int(11) NOT NULL default '0',  `PKPoints` int(11) NOT NULL default '0',  `LocationX` int(11) NOT NULL default '438',  `LocationY` int(11) NOT NULL default '377',  `Map` int(11) NOT NULL default '1002',  `Money` bigint(20) NOT NULL default '2000',  `StatPoints` smallint(11) NOT NULL default '0',  `Spouse` int(11) NOT NULL default '0',  `Equipment` varchar(2000) NOT NULL,  `Inventory` varchar(2000) NOT NULL,  `Skills` varchar(2000) NOT NULL default '0',  `Quests` varchar(2000) NOT NULL default '0',  `UserBank` varchar(2000) default '0',  `Bankmoney` int(11) NOT NULL default '0',  `ItemSkill` varchar(2000) NOT NULL default '0',  `Friends` varchar(2000) character set gbk NOT NULL default '0',  `Enemy` varchar(6000) character set gbk NOT NULL default '0',  `Cp` bigint(20) NOT NULL default '0',  `face` int(11) NOT NULL default '0',  `APIVar` varchar(4000) character set gbk NOT NULL default '0',  `Guild` int(11) NOT NULL default '0',  `Guidpost` int(11) NOT NULL default '50',  `GuidGX` int(11) NOT NULL default '0',  PRIMARY KEY  (`CharacterID`,`Name`),  KEY `Fk_k` (`Account`),  CONSTRAINT `Fk_k` FOREIGN KEY (`Account`) REFERENCES `account` (`AccountID`)) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for defaultstats
-- ----------------------------
CREATE TABLE `defaultstats` (  `Class` int(11) NOT NULL,  `Strength` int(11) NOT NULL,  `Agility` int(11) NOT NULL,  `Vitality` int(11) NOT NULL,  `Spirit` int(11) NOT NULL,  `Level` int(11) NOT NULL,  PRIMARY KEY  (`Class`,`Level`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for guildlist
-- ----------------------------
CREATE TABLE `guildlist` (  `GuildID` int(11) NOT NULL,  `GuildName` varchar(60) NOT NULL,  `MasterID` int(11) NOT NULL,  `MasterName` varchar(60) NOT NULL,  `Monery` int(11) NOT NULL default '0',  `league` varchar(2000) NOT NULL COMMENT '0',  `foe` varchar(2000) NOT NULL COMMENT '0',  `Text` varchar(1000) NOT NULL,  PRIMARY KEY  (`GuildID`,`GuildName`)) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Table structure for guildmap
-- ----------------------------
CREATE TABLE `guildmap` (  `GuildID` int(11) NOT NULL,  `Money` int(11) NOT NULL default '0',  `Cp` int(11) NOT NULL default '0',  `StartTime` datetime default NULL,  `GoGuril` varchar(1000) NOT NULL default '0',  `GoStart` datetime default NULL,  PRIMARY KEY  (`GuildID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for hdd_spawns
-- ----------------------------
CREATE TABLE `hdd_spawns` (  `ID` int(11) NOT NULL,  `MaxHp` int(11) NOT NULL,  `Hp` int(11) NOT NULL,  `x` int(11) NOT NULL,  `y` int(11) NOT NULL,  `type` int(11) NOT NULL,  `dir` int(11) NOT NULL,  `flag` int(11) NOT NULL,  `name` varchar(60) default NULL,  `MapID` int(11) NOT NULL,  PRIMARY KEY  (`ID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for maps
-- ----------------------------
CREATE TABLE `maps` (  `Map_Number` int(11) NOT NULL,  `PK` int(11) NOT NULL,  `NewbieProtected` int(11) NOT NULL,