root/racing.league/install.sql @ 699

DROP TABLE IF EXISTS wcf1_racing_settings;
CREATE TABLE wcf1_racing_settings (
saisonID int(10) unsigned NOT NULL  auto_increment COMMENT 'ID der Saison',
saisonName varchar(255) NOT NULL COMMENT 'Name der Saison',
PRIMARY KEY(`saisonID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS wcf1_racing_group;
CREATE TABLE wcf1_racing_group (
saisonID int(10) unsigned NOT NULL COMMENT 'ID der Saison',
groupID int(10) unsigned NOT NULL COMMENT 'ID der Benutzergruppe der Fahrer',
PRIMARY KEY(`saisonID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS wcf1_racing_races;
CREATE TABLE wcf1_racing_races (
saisonID int(10) unsigned NOT NULL COMMENT 'ID der Saison',
raceID  int(10) unsigned NOT NULL  auto_increment COMMENT 'ID des Rennens',
raceNo int(10) unsigned NOT NULL COMMENT 'Rennennummer',
raceName varchar(255) NOT NULL COMMENT 'Rennname/Rennort',
drived  int(10) unsigned NULL DEFAULT '0' COMMENT 'Rennen wurde schon gefahren',
PRIMARY KEY(`saisonID`, `raceID`),
INDEX ( `raceID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS wcf1_racing_teams;
CREATE TABLE wcf1_racing_teams (
saisonID int(10) unsigned NOT NULL COMMENT 'ID der Saison',
teamID int(10) unsigned NOT NULL auto_increment COMMENT 'TeamID-Nummer',
teamName varchar(255) NOT NULL COMMENT 'Teamname',
PRIMARY KEY(`saisonID`, `teamID`),
INDEX ( `teamID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS wcf1_racing_user_to_team;
CREATE TABLE wcf1_racing_user_to_team (
saisonID int(10) unsigned NOT NULL COMMENT 'ID der Saison',
userToTeamID int(10) unsigned NOT NULL auto_increment COMMENT 'User zu Team ID-Nummer',
teamID int(10) unsigned NOT NULL COMMENT 'TeamID-Nummer',
userID int(10) unsigned NOT NULL COMMENT 'userID-Nummer',
PRIMARY KEY(`saisonID`, `usertoteamID`),
INDEX ( `usertoteamID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS wcf1_racing_results;
CREATE TABLE wcf1_racing_results (
saisonID int(10) unsigned NOT NULL COMMENT 'ID der Saison',
resultID  int(10) unsigned NOT NULL  auto_increment COMMENT 'ID des Ergebnisses',
raceID int(10) unsigned NOT NULL COMMENT 'ID des Rennens',
userID int(10) unsigned NOT NULL COMMENT 'userID des Fahrers',
place int(10) unsigned NOT NULL COMMENT 'erfahrener Platz des Fahrers',
points int(10) unsigned NOT NULL COMMENT 'Punkte für den Fahrer',
PRIMARY KEY(`saisonID`, `resultID`),
INDEX ( `resultID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS wcf1_racing_results_team;
CREATE TABLE wcf1_racing_results_team (
saisonID int(10) unsigned NOT NULL COMMENT 'ID der Saison',
resultTeamID  int(10) unsigned NOT NULL  auto_increment COMMENT 'ID des Team-Ergebnisses',
resultID int(10) unsigned NOT NULL COMMENT 'ID des Ergebnisses',
raceID int(10) unsigned NOT NULL COMMENT 'ID des Rennens',
userID int(10) unsigned NOT NULL COMMENT 'userID des Fahrers',
teamID int(10) unsigned NOT NULL COMMENT 'ID des Teams',
points int(10) unsigned NOT NULL COMMENT 'Punkte für das Team',
PRIMARY KEY(`saisonID`, `resultTeamID`),
INDEX ( `resultTeamID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS wcf1_racing_points;
CREATE TABLE wcf1_racing_points (
saisonID int(10) unsigned NOT NULL COMMENT 'ID der Saison',
pointsID  int(10) unsigned NOT NULL  auto_increment COMMENT 'ID der Regel',
place int(10) unsigned NOT NULL COMMENT 'Platzierung',
points int(10) unsigned NOT NULL COMMENT 'Punkte für Platz',
PRIMARY KEY(`saisonID`, `pointsID`),
INDEX ( `pointsID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS wcf1_racing_punish;
CREATE TABLE wcf1_racing_punish (
saisonID int(10) unsigned NOT NULL COMMENT 'ID der Saison',
punishID  int(10) unsigned NOT NULL  auto_increment COMMENT 'ID der Strafe',
raceID int(10) unsigned NOT NULL COMMENT 'ID des Rennens',
userID int(10) unsigned NOT NULL COMMENT 'UserID',
minusPoints int(10) unsigned NOT NULL COMMENT 'Punkte die abgezogen werden sollen',
punishReason varchar(255) NOT NULL COMMENT 'Grund für die Strafe',
PRIMARY KEY(`saisonID`, `punishID`),
INDEX ( `punishID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;