`GetPk` int(11) NOT NULL,  `GetBlueName` int(11) NOT NULL,  PRIMARY KEY  (`Map_Number`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for monster
-- ----------------------------
CREATE TABLE `monster` (  `id` int(11) NOT NULL,  `name` varchar(200) default NULL,  `mech` int(11) default NULL,  `level` int(11) default NULL,  `hp` bigint(20) default NULL,  `wander` int(11) default NULL,  `hunter` int(11) default NULL,  `guard` int(11) default NULL,  `agressive` int(11) default NULL,  `atkmin` bigint(20) default NULL,  `atkmax` bigint(20) default NULL,  `mdef` int(11) default NULL,  `pdef` int(11) default NULL,  `arange` int(11) default NULL,  `viewdistance` int(11) default NULL,  `canrun` int(11) default NULL,  `dropminlevel` int(11) default NULL,  `dropmaxlevel` int(11) default NULL,  `maxmoney` int(11) default NULL,  `avgmoney` int(11) default NULL,  `dchance` int(11) default NULL,  `speed` int(11) default NULL,  `jrange` int(11) default NULL,  `sizeadd` int(11) default NULL,  `dex` int(11) default NULL,  `dodge` int(11) default NULL,  `lvlb` int(11) default NULL,  `atype` int(11) default NULL,  `Spwtime` bigint(20) NOT NULL default '10000',  PRIMARY KEY  (`id`)) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for monsterspawns
-- ----------------------------
CREATE TABLE `monsterspawns` (  `ID` int(11) NOT NULL,  `xstart` int(11) default NULL,  `ystart` int(11) default NULL,  `UniID` bigint(20) NOT NULL auto_increment,  `Map` varchar(60) character set gb2312 default NULL,  `xstop` int(11) default NULL,  `ystop` int(11) default NULL,  `NumberToSpawn` int(11) default NULL,  PRIMARY KEY  (`UniID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for npc_spawns
-- ----------------------------
CREATE TABLE `npc_spawns` (  `ID_1` int(11) NOT NULL,  `ID` int(11) default NULL,  `X_Pos` int(11) default NULL,  `Y_Pos` int(11) default NULL,  `Type` int(11) default NULL,  `Direction` int(11) default NULL,  `Flag` int(11) default NULL,  `Map_ID` int(11) default NULL,  PRIMARY KEY  (`ID_1`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for portals
-- ----------------------------
CREATE TABLE `portals` (  `Name` varchar(60) character set gb2312 NOT NULL,  `FromMap` int(11) NOT NULL default '0',  `FromX` int(11) NOT NULL default '0',  `FromY` int(11) NOT NULL default '0',  `ToMap` int(11) NOT NULL default '0',  `ToX` int(11) NOT NULL default '0',  `ToY` int(11) NOT NULL default '0',  PRIMARY KEY  (`Name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for servers
-- ----------------------------
CREATE TABLE `servers` (  `ServersName` varchar(60) character set gb2312 NOT NULL,  `IPAddress` varchar(60) character set gb2312 NOT NULL,  PRIMARY KEY  (`ServersName`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for settings
-- ----------------------------
CREATE TABLE `settings` (  `Name` varchar(255) character set gb2312 NOT NULL,  `Value` varchar(255) character set gb2312 NOT NULL,  PRIMARY KEY  (`Name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tempsavedb
-- ----------------------------
CREATE TABLE `tempsavedb` (  `id` int(11) NOT NULL auto_increment,  `CharID` int(11) NOT NULL,  `Name` varchar(1000) NOT NULL,  `Cp` int(11) NOT NULL,  `Str` varchar(1000) NOT NULL,  PRIMARY KEY  (`id`)) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `defaultstats` VALUES ('1', '5', '2', '3', '0', '1');
INSERT INTO `defaultstats` VALUES ('1', '7', '2', '4', '0', '2');
INSERT INTO `defaultstats` VALUES ('2', '5', '2', '3', '0', '1');
INSERT INTO `defaultstats` VALUES ('4', '2', '7', '1', '0', '1');
INSERT INTO `defaultstats` VALUES ('10', '0', '2', '3', '5', '1');
INSERT INTO `guildmap` VALUES ('999999', '0', '0', '0001-01-01 00:00:00', '0', '0001-01-01 00:00:00');
INSERT INTO `hdd_spawns` VALUES ('100002', '10000000', '4504818', '223', '177', '270', '26', '21', '', '1038');
INSERT INTO `hdd_spawns` VALUES ('100003', '50000000', '10266387', '84', '99', '1137', '10', '11', '貴總的傳說', '1038');
INSERT INTO `hdd_spawns` VALUES ('100004', '10000000', '1731125', '162', '209', '250', '26', '21', '', '1038');
INSERT INTO `hdd_spawns` VALUES ('100010', '1000000', '702899', '51', '49', '410', '26', '21', '雪人', '1511');
INSERT INTO `hdd_spawns` VALUES ('100012', '100000', '100000', '34', '35', '8200', '2', '0', '0,1', '1511');
INSERT INTO `hdd_spawns` VALUES ('100013', '100000', '100000', '41', '35', '8200', '2', '0', '2,3', '1511');
INSERT INTO `hdd_spawns` VALUES ('100014', '100000', '100000', '49', '35', '8200', '2', '0', '4,5', '1511');
INSERT INTO `hdd_spawns` VALUES ('100015', '100000', '100000', '57', '35', '8200', '2', '0', '6,7', '1511');
INSERT INTO `hdd_spawns` VALUES ('100016', '100000', '100000', '65', '35', '8200', '2', '0', '8,9', '1511');
INSERT INTO `hdd_spawns` VALUES ('100017', '100000', '100000', '34', '33', '8200', '2', '0', '0', '1511');
INSERT INTO `hdd_spawns` VALUES ('100018', '100000', '100000', '34', '37', '8200', '2', '0', '1', '1511');