-- ----------------------------------
-- warsow racenet databse structure
-- this is not exactly the racenet db
-- just what is needed by game
-- ----------------------------------

CREATE TABLE `map` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `name` varchar(40) character set utf8 NOT NULL default '',
  `file` varchar(64) character set utf8 NOT NULL,
  `freestyle` enum('true','false') character set utf8 NOT NULL default 'false',
  `status` enum('enabled','disabled') character set utf8 NOT NULL default 'enabled',
  `playtime` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;


CREATE TABLE `player` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `name` varchar(64) character set utf8 NOT NULL default '',
  `simplified` varchar(64) character set utf8 NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;


CREATE TABLE `player_map` (
  `player_id` mediumint(8) unsigned NOT NULL,
  `map_id` mediumint(8) unsigned NOT NULL,
  `playtime` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`player_id`,`map_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE `race` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `map_id` mediumint(8) unsigned NOT NULL default '0',
  `player_id` mediumint(8) unsigned NOT NULL default '0',
  `time` mediumint(8) unsigned NOT NULL default '0',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `map_id` (`map_id`,`player_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;