conquer.sql

架设关键部分开始了。点击开始——程序

/*
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,