PmvcUK5z

1CREATE TABLE IF NOT EXISTS `connections` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `name` varchar(21) NOT NULL,
4  `ip` varchar(16) NOT NULL,
5  `serial` varchar(128) NOT NULL,
6  `time` varchar(24) NOT NULL,
7  PRIMARY KEY (`id`)
8) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
9
10CREATE TABLE IF NOT EXISTS `namechanges` (
11  `id` smallint(5) NOT NULL AUTO_INCREMENT,
12  `reg_id` mediumint(8) NOT NULL,
13  `oldname` varchar(21) NOT NULL,
14  `newname` varchar(21) NOT NULL,
15  `time` varchar(24) NOT NULL,
16  PRIMARY KEY (`id`),
17  KEY `reg_id` (`reg_id`)
18) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
19
20CREATE TABLE IF NOT EXISTS `namechanges_p` (
21  `id` smallint(5) NOT NULL AUTO_INCREMENT,
22  `reg_id` mediumint(8) NOT NULL,
23  `name` varchar(24) NOT NULL,
24  `oldpass` varchar(21) NOT NULL,
25  `newpass` varchar(21) NOT NULL,
26  `time` varchar(24) NOT NULL,
27  PRIMARY KEY (`id`),
28  KEY `reg_id` (`reg_id`)
29) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
30
31CREATE TABLE IF NOT EXISTS `players` (
32  `reg_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
33  `name` varchar(24) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
34  `ip` varchar(20) NOT NULL,
35  `pass` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
36  `reg_date` varchar(24) NOT NULL,
37  `laston` varchar(24) NOT NULL,
38  `money` int(11) NOT NULL DEFAULT '0',
39  `score` int(11) NOT NULL DEFAULT '0',
40  `kills` mediumint(11) unsigned NOT NULL DEFAULT '0',
41  `deaths` mediumint(11) unsigned NOT NULL DEFAULT '0',
42  `fightingstyle` enum('4','5','6','7','15','16') NOT NULL DEFAULT '4',
43  PRIMARY KEY (`reg_id`),
44  KEY `name` (`name`)
45) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;