DPcVp9pk

1SET FOREIGN_KEY_CHECKS=0;
2
3DROP TABLE IF EXISTS `GameTime`;
4CREATE TABLE `GameTime` (
5  `UserID` varchar(16) NOT NULL DEFAULT '',
6  `paymenttype` tinyint(2) NOT NULL DEFAULT '1',
7  `LimitTime` int(11) unsigned DEFAULT '0',
8  `LimitDt` datetime DEFAULT '1990-01-01 00:00:00',
9  `Scores` int(11) DEFAULT '0',
10  PRIMARY KEY (`UserID`)
11) ENGINE=MyISAM DEFAULT CHARSET=latin1;
12
13DROP TABLE IF EXISTS `GameTimeIP`;
14CREATE TABLE `GameTimeIP` (
15  `ipid` int(11) NOT NULL AUTO_INCREMENT,
16  `name` varchar(128) DEFAULT NULL,
17  `ip` varchar(15) NOT NULL DEFAULT '000.000.000.000',
18  `startIP` int(11) NOT NULL DEFAULT '0',
19  `endIP` int(11) NOT NULL DEFAULT '255',
20  `paymenttype` tinyint(2) NOT NULL DEFAULT '1',
21  `LimitTime` int(11) NOT NULL DEFAULT '0',
22  `LimitDt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
23  `readme` varchar(128) DEFAULT NULL,
24  PRIMARY KEY (`ipid`),
25  UNIQUE KEY `ip_uniq` (`ip`,`startIP`,`endIP`),
26  KEY `ip_idx` (`ip`)
27) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
28
29DROP TABLE IF EXISTS `GameTimeLog`;
30CREATE TABLE `GameTimeLog` (
31  `login` varchar(16) DEFAULT NULL,
32  `type` enum('IP_FREE','FREE','IP_TIME','IP_DAY','TIME','DAY') DEFAULT NULL,
33  `logon_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
34  `logout_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
35  `use_time` int(11) unsigned DEFAULT NULL,
36  `ip` varchar(15) NOT NULL DEFAULT '000.000.000.000',
37  `server` varchar(56) NOT NULL DEFAULT '',
38  KEY `login_key` (`login`)
39) ENGINE=MyISAM DEFAULT CHARSET=latin1;