Changeset 705

Timestamp:

11/09/08 14:29:28 (5 years ago)

Author:

MDMAN

Message:

racing-league modified

Files:

• racing.league/install.sql (modified) (7 diffs)

racing.league/install.sql

@@ -20 +20 @@
 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`)
+PRIMARY KEY(`raceID`),
+INDEX (`raceID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
@@ -29 +29 @@
 teamID int(10) unsigned NOT NULL auto_increment COMMENT 'TeamID-Nummer',
 teamName varchar(255) NOT NULL COMMENT 'Teamname',
-PRIMARY KEY(`saisonID`, `teamID`),
-INDEX ( `teamID`)
+PRIMARY KEY(`teamID`),
+INDEX (`teamID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
@@ -39 +39 @@
 teamID int(10) unsigned NOT NULL COMMENT 'TeamID-Nummer',
 userID int(10) unsigned NOT NULL COMMENT 'userID-Nummer',
-PRIMARY KEY(`saisonID`, `usertoteamID`),
-INDEX ( `usertoteamID`)
+PRIMARY KEY(`userToTeamID`),
+INDEX (`userToTeamID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
@@ -51 +51 @@
 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`)
+PRIMARY KEY(`resultID`),
+INDEX (`resultID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
@@ -64 +64 @@
 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`)
+PRIMARY KEY(`resultTeamID`),
+INDEX (`resultTeamID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
@@ -74 +74 @@
 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`)
+PRIMARY KEY(`pointsID`),
+INDEX (`pointsID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
@@ -86 +86 @@
 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`)
+PRIMARY KEY(`punishID`),
+INDEX (`punishID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;