CREATE TABLE IF NOT EXISTS `game` ( `id` int(9) NOT NULL AUTO_INCREMENT, `day` date NOT NULL, `team1` int(3) NOT NULL, `team2` int(3) NOT NULL, `result` varchar(5) DEFAULT NULL, `info` int(1) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1127 ;