1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

CREATE TABLE `module_cs_gs_servers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `game` varchar(31) NOT NULL,
  `name` varchar(255) NOT NULL,
  `ip_address` varchar(39) DEFAULT NULL,
  `port` smallint(5) unsigned NOT NULL,
  `mode` enum('LAN','LAN&INET') NOT NULL DEFAULT 'LAN',
  `max_players` smallint(5) unsigned NOT NULL DEFAULT '16',
  `autoupdate` enum('yes','no') NOT NULL DEFAULT 'yes',
  `master` enum('yes','no') NOT NULL DEFAULT 'yes',
  `config_id` int(10) unsigned NOT NULL,
  `secure` enum('yes','no') NOT NULL DEFAULT 'yes',
  `rcon_password` varchar(61) NOT NULL,
  `sv_password` varchar(61) NOT NULL,
  `default_map` varchar(61) NOT NULL,
  `total_traffic` bigint(20) unsigned NOT NULL DEFAULT '0',
  `period_traffic` bigint(20) unsigned NOT NULL DEFAULT '0',
  `begin_period_date` date NOT NULL,
  `end_period_date` date NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ip_address` (`ip_address`,`port`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `module_cs_gs_servers` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `game` varchar(31) NOT NULL, `name` varchar(255) NOT NULL, `ip_address` varchar(39) DEFAULT NULL, `port` smallint(5) unsigned NOT NULL, `mode` enum('LAN','LAN&INET') NOT NULL DEFAULT 'LAN', `max_players` smallint(5) unsigned NOT NULL DEFAULT '16', `autoupdate` enum('yes','no') NOT NULL DEFAULT 'yes', `master` enum('yes','no') NOT NULL DEFAULT 'yes', `config_id` int(10) unsigned NOT NULL, `secure` enum('yes','no') NOT NULL DEFAULT 'yes', `rcon_password` varchar(61) NOT NULL, `sv_password` varchar(61) NOT NULL, `default_map` varchar(61) NOT NULL, `total_traffic` bigint(20) unsigned NOT NULL DEFAULT '0', `period_traffic` bigint(20) unsigned NOT NULL DEFAULT '0', `begin_period_date` date NOT NULL, `end_period_date` date NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ip_address` (`ip_address`,`port`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1