Database

CREATE TABLE IF NOT EXISTS `cyrus_players` (
  `id` int(11) unsigned NOT NULL,
  `steam` varchar(30) NOT NULL,
  `playerName` varchar(150) NOT NULL,
  `last_connection` datetime NOT NULL,
  `connections` int(10) unsigned NOT NULL,
  `stats_kills` bigint(10) NOT NULL,
  `stats_deaths` bigint(10) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

ALTER TABLE `cyrus_players` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `steam` (`steam`), ADD KEY `last_seen` (`last_connection`);

ALTER TABLE `cyrus_players` MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;