conquer.sql

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

  `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');