Stuff

CREATE TABLE MATCH (mid INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT ,home_tid INTEGER NOT NULL REFERENCES team( tid ) ,away_tid INTEGER NOT NULL REFERENCES team( tid ) ,week INTEGER NOT NULL ,UNIQUE (home_tid,away_tid,week));