征途的数据库表zt部分展示
CREATE TABLE `RECOMMEND` (
CREATE TABLE `RECOMMEND` (
`ID` int(10) unsigned NOT NULL DEFAULT '0',
`NAME` varchar(33) NOT NULL DEFAULT '',
`TOTAL` int(10) unsigned NOT NULL DEFAULT '0',
`BALANCE` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*数据表 `RECOMMEND` 的数据*/
/*数据表 `RECOMMENDSUB` 的表结构*/
DROP TABLE IF EXISTS `RECOMMENDSUB`;
CREATE TABLE `RECOMMENDSUB` (
`ID` int(10) unsigned NOT NULL DEFAULT '0',
`NAME` varchar(33) NOT NULL DEFAULT '',
`LASTLEVEL` int(10) unsigned NOT NULL DEFAULT '0',
`TOTAL` int(10) unsigned NOT NULL DEFAULT '0',
`LASTTIME` int(10) unsigned NOT NULL DEFAULT '0',
`RECOMMENDID` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*数据表 `RECOMMENDSUB` 的数据*/
/*数据表 `RESTORECARD` 的表结构*/
DROP TABLE IF EXISTS `RESTORECARD`;
CREATE TABLE `RESTORECARD` (
`ACCID` int(10) unsigned NOT NULL DEFAULT '0',
`SUBAT` int(10) unsigned NOT NULL DEFAULT '0',
`BALANCE` int(10) unsigned NOT NULL DEFAULT '0',
`TID` char(100) NOT NULL DEFAULT '',
PRIMARY KEY (`ACCID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*数据表 `RESTORECARD` 的数据*/
/*数据表 `RESTOREGOLD` 的表结构*/
DROP TABLE IF EXISTS `RESTOREGOLD`;
CREATE TABLE `RESTOREGOLD` (
`ACCID` int(10) unsigned NOT NULL DEFAULT '0',
`RESTOREGOLD` int(10) unsigned NOT NULL DEFAULT '0',
`BALANCE` int(10) unsigned NOT NULL DEFAULT '0',
`TID` char(100) NOT NULL DEFAULT '',
PRIMARY KEY (`ACCID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*数据表 `RESTOREGOLD` 的数据*/
/*数据表 `SAMPLERELATION` 的表结构*/
DROP TABLE IF EXISTS `SAMPLERELATION`;


CREATE TABLE `SAMPLERELATION` (
`CHARID` int(10) unsigned NOT NULL DEFAULT '0',
`RELATIONID` int(10) unsigned NOT NULL DEFAULT '0',
`RELATIONNAME` varchar(33) NOT NULL DEFAULT '',
`TYPE` tinyint(3) unsigned NOT NULL DEFAULT '0',
`LASTTIME` int(10) unsigned NOT NULL DEFAULT '0',
`OCCUPATION` smallint(5) unsigned NOT NULL DEFAULT '0',
`DEGREE` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`CHARID`,`RELATIONID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*数据表 `SAMPLERELATION` 的数据*/
/*数据表 `SCHOOL` 的表结构*/
DROP TABLE IF EXISTS `SCHOOL`;
CREATE TABLE `SCHOOL` (
`SCHOOLID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`NAME` varchar(33) NOT NULL DEFAULT '',
`MASTERSERIAL` int(10) unsigned NOT NULL DEFAULT '0',
`BULLETIN` blob NOT NULL,
PRIMARY KEY (`SCHOOLID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*数据表 `SCHOOL` 的数据*/
/*数据表 `SCHOOLMEMBER` 的表结构*/
DROP TABLE IF EXISTS `SCHOOLMEMBER`;
CREATE TABLE `SCHOOLMEMBER` (
`SERIALID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`MASTERID` int(10) unsigned NOT NULL DEFAULT '0',
`PRESERIALID` int(10) unsigned NOT NULL DEFAULT '0',
`CHARID` int(10) unsigned NOT NULL DEFAULT '0',
`NAME` varchar(33) NOT NULL DEFAULT '',
`LEVEL` smallint(5) unsigned NOT NULL DEFAULT '0',
`JOINTIME` int(10) unsigned NOT NULL DEFAULT '0',
`DEGREE` smallint(5) unsigned NOT NULL DEFAULT '0',
`LASTTIME` int(10) unsigned NOT NULL DEFAULT '0',
`SCHOOLID` int(10) unsigned NOT NULL DEFAULT '0',
`OCCUPATION` smallint(5) unsigned NOT NULL DEFAULT '0',
`TAG` tinyint(3) unsigned NOT NULL DEFAULT '0',
`MASTERBALANCE` int(10) unsigned NOT NULL DEFAULT '0',
`PRENTICETOTAL` int(10) unsigned NOT NULL DEFAULT '0',
`PRENTICELASTLVL` int(10) unsigned NOT NULL DEFAULT '0',
`MASTERTOTAL` bigint(20) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`SERIALID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*数据表 `SCHOOLMEMBER` 的数据*/
/*数据表 `SEPT` 的表结构*/
DROP TABLE IF EXISTS `SEPT`;
CREATE TABLE `SEPT` (
`SEPTID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`NAME` varchar(33) NOT NULL DEFAULT '',
`CHARID` int(10) unsigned NOT NULL DEFAULT '0',
`MASTER` varchar(33) NOT NULL DEFAULT '',
`VOTE` tinyint(3) unsigned NOT NULL DEFAULT '0',
`CREATETIME` int(10) unsigned NOT NULL DEFAULT '0',
`COUNTRYID` int(10) unsigned NOT NULL DEFAULT '0',
`REPUTE` int(10) unsigned NOT NULL DEFAULT '0',
`UNIONID` int(10) unsigned NOT NULL DEFAULT '0',
`LEVEL` int(10) unsigned NOT NULL DEFAULT '0',
`NOTE` varchar(255) NOT NULL DEFAULT '',
`SPENDGOLD` int(10) unsigned NOT NULL DEFAULT '0',
`ISEXP` int(10) unsigned NOT NULL DEFAULT '0',
`NORMALEXPTIME` int(10) unsigned NOT NULL DEFAULT '0',
`CALLTIMES` int(10) unsigned NOT NULL DEFAULT '0',
`CALLDAYTIME` int(10) unsigned NOT NULL DEFAULT '0',
`LEAVETIME` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`SEPTID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*数据表 `SEPT` 的数据*/
/*数据表 `SEPTMEMBER` 的表结构*/
DROP TABLE IF EXISTS `SEPTMEMBER`;
CREATE TABLE `SEPTMEMBER` (
`SEPTID` int(10) unsigned NOT NULL DEFAULT '0',
`CHARID` int(10) unsigned NOT NULL DEFAULT '0',
`ALIASNAME` varchar(33) NOT NULL DEFAULT '',
`NAME` varchar(33) NOT NULL DEFAULT '',
`OCCUPATION` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`CHARID`,`SEPTID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*数据表 `SEPTMEMBER` 的数据*/
/*数据表 `SERVERLIST` 的表结构*/
DROP TABLE IF EXISTS `SERVERLIST`;
CREATE TABLE `SERVERLIST` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`TYPE` int(10) unsigned NOT NULL DEFAULT '0',
`NAME` varchar(32) NOT NULL DEFAULT '',
`IP` varchar(16) NOT NULL DEFAULT '127.0.0.1',
`PORT` int(10) unsigned NOT NULL DEFAULT '0',
`EXTIP` varchar(16) NOT NULL DEFAULT '127.0.0.1',
`EXTPORT` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;
/*数据表 `SERVERLIST` 的数据*/
insert into `SERVERLIST` values
(1,1,'服务器管理器','192.168.202.128',10000,'192.168.202.128',10000),
(20,20,'Session服务器','192.168.202.128',6000,'192.168.202.128',6000),
(21,21,'场景服务器','192.168.202.128',6010,'192.168.202.128',6010),
(22,22,'网关服务器','192.168.202.128',6020,'192.168.202.128',6020),
(11,11,'档案服务器','192.168.202.128',7010,'192.168.202.128',7010),
(12,12,'计费服务器','192.168.202.128',7020,'192.168.202.128',7020),
(23,23,'Mini服务器','192.168.202.128',6030,'192.168.202.128',6030),
(110,10,'登陆服务器','192.168.202.128',7000,'192.168.202.128',7000);
/*数据表 `SN` 的表结构*/
DROP TABLE IF EXISTS `SN`;
CREATE TABLE `SN` (
`SN` varchar(16) NOT NULL DEFAULT '',
`LEVEL` smallint(5) unsigned NOT NULL DEFAULT '0',
`DAY` tinyint(3) unsigned NOT NULL DEFAULT '0',
`USER` varchar(33) NOT NULL DEFAULT '',
PRIMARY KEY (`SN`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*数据表 `SN` 的数据*/
/*数据表 `SORTLIST` 的表结构*/
DROP TABLE IF EXISTS `SORTLIST`;
CREATE TABLE `SORTLIST` (
`CHARID` int(10) unsigned NOT NULL DEFAULT '0',
`LEVEL` smallint(5) unsigned NOT NULL DEFAULT '0',
`EXP` bigint(20) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`CHARID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*数据表 `SORTLIST` 的数据*/
/*数据表 `TECH` 的表结构*/
DROP TABLE IF EXISTS `TECH`;
CREATE TABLE `TECH` (
`UID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`COUNTRYID` int(10) unsigned NOT NULL DEFAULT '0',
`TYPE` int(10) unsigned NOT NULL DEFAULT '0',
`NAME` varchar(33) NOT NULL DEFAULT '',
`PROGRESS` int(10) unsigned NOT NULL DEFAULT '0',
`RESEARCHID` int(10) unsigned DEFAULT '0',
`RESEARCHNAME` varchar(33) DEFAULT '',
`LEVEL` int(10) unsigned NOT NULL DEFAULT '1',
`STATUS` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`UID`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=latin1;
/*数据表 `TECH` 的数据*/
insert into `TECH` values
(1,2,1,'布料类服装',0,0,'',1,0),
(2,2,2,'皮甲类服装',0,0,'',1,0),
(3,2,3,'铠甲类服装',0,0,'',1,0),
(4,2,4,'刀盾类',0,0,'',1,0),
(5,2,5,'弓类',0,0,'',1,0),
(6,2,6,'棍类',0,0,'',1,0),
(7,2,7,'杖类',0,0,'',1,0),
(8,2,8,'扇类',0,0,'',1,0),
(9,2,9,'项链类',0,0,'',1,0),
(10,2,10,'戒指类',0,0,'',1,0),
(11,2,11,'护腕类',0,0,'',1,0),
(12,2,12,'腰带类',0,0,'',1,0),
(13,2,13,'鞋子类',0,0,'',1,0),
(14,2,14,'头盔类',0,0,'',1,0),
(15,3,1,'布料类服装',0,0,'',1,0),
(16,3,2,'皮甲类服装',0,0,'',1,0),
(17,3,3,'铠甲类服装',0,0,'',1,0),
(18,3,4,'刀盾类',0,0,'',1,0),
(19,3,5,'弓类',0,0,'',1,0),
(20,3,6,'棍类',0,0,'',1,0),
(21,3,7,'杖类',0,0,'',1,0),
(22,3,8,'扇类',0,0,'',1,0),
(23,3,9,'项链类',0,0,'',1,0),
(24,3,10,'戒指类',0,0,'',1,0),
(25,3,11,'护腕类',0,0,'',1,0),
(26,3,12,'腰带类',0,0,'',1,0),
(27,3,13,'鞋子类',0,0,'',1,0),
(28,3,14,'头盔类',0,0,'',1,0),
(29,4,1,'布料类服装',0,0,'',1,0),
(30,4,2,'皮甲类服装',0,0,'',1,0),
(31,4,3,'铠甲类服装',0,0,'',1,0),
(32,4,4,'刀盾类',0,0,'',1,0),
(33,4,5,'弓类',0,0,'',1,0),
(34,4,6,'棍类',0,0,'',1,0),
(35,4,7,'杖类',0,0,'',1,0),
(36,4,8,'扇类',0,0,'',1,0),
(37,4,9,'项链类',0,0,'',1,0),
(38,4,10,'戒指类',0,0,'',1,0),
(39,4,11,'护腕类',0,0,'',1,0),
(40,4,12,'腰带类',0,0,'',1,0),
(41,4,13,'鞋子类',0,0,'',1,0),
(42,4,14,'头盔类',0,0,'',1,0);
/*数据表 `UNION` 的表结构*/
DROP TABLE IF EXISTS `UNION`;
CREATE TABLE `UNION` (
`UNIONID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`NAME` varchar(33) NOT NULL DEFAULT '',
`CHARID` int(10) unsigned NOT NULL DEFAULT '0',
`LEVEL` smallint(5) NOT NULL DEFAULT '0',
`MASTER` varchar(33) NOT NULL DEFAULT '',
`EXP` bigint(20) NOT NULL DEFAULT '0',
`VOTE` tinyint(3) unsigned NOT NULL DEFAULT '0',
`CREATETIME` int(10) unsigned NOT NULL DEFAULT '0',
`COUNTRYID` int(10) unsigned NOT NULL DEFAULT '0',
`MANA` int(10) unsigned NOT NULL DEFAULT '0',
`ACTIONPOINT` int(10) unsigned NOT NULL DEFAULT '0',
`MONEY` int(10) unsigned NOT NULL DEFAULT '0',
`NOTE` varchar(255) NOT NULL DEFAULT '',
`CALLTIMES` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`UNIONID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*数据表 `UNION` 的数据*/
/*数据表 `UNIONMEMBER` 的表结构*/
DROP TABLE IF EXISTS `UNIONMEMBER`;
CREATE TABLE `UNIONMEMBER` (
`UNIONID` int(10) unsigned NOT NULL DEFAULT '0',
`CHARID` int(10) unsigned NOT NULL DEFAULT '0',
`ALIASNAME` varchar(33) NOT NULL DEFAULT '',
`NAME` varchar(33) NOT NULL DEFAULT '',
`OCCUPATION` smallint(5) unsigned NOT NULL DEFAULT '0',
`POWER` int(10) unsigned NOT NULL DEFAULT '0',
`SEPTID` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`UNIONID`,`CHARID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*数据表 `UNIONMEMBER` 的数据*/
/*数据表 `VOTE` 的表结构*/
DROP TABLE IF EXISTS `VOTE`;
CREATE TABLE `VOTE` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`COUNTRYID` int(10) unsigned NOT NULL DEFAULT '0',
`STATUS` int(10) unsigned NOT NULL DEFAULT '0',
`TYPE` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*数据表 `VOTE` 的数据*/
/*数据表 `VOTEDPLAYER` 的表结构*/
DROP TABLE IF EXISTS `VOTEDPLAYER`;
CREATE TABLE `VOTEDPLAYER` (
`VOTEID` int(10) unsigned NOT NULL DEFAULT '0',
`CHARID` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`VOTEID`,`CHARID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*数据表 `VOTEDPLAYER` 的数据*/
/*数据表 `VOTEITEM` 的表结构*/
DROP TABLE IF EXISTS `VOTEITEM`;
CREATE TABLE `VOTEITEM` (
`VOTEID` int(10) unsigned NOT NULL DEFAULT '0',
`OPTIONID` int(11) NOT NULL DEFAULT '0',
`OPTIONDESC` varchar(100) NOT NULL DEFAULT '',
`BALLOT` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`VOTEID`,`OPTIONID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*数据表 `VOTEITEM` 的数据*/
版权声明:本文发布于征途私服-最大征途sf发布网 内容均来源于互联网 如有侵权联系删除
快来评论,快来抢沙发吧~