CREATE TABLE IF NOT EXISTS `alg_team` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;

CREATE TABLE IF NOT EXISTS `alg_result` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`homekey` int(5) NOT NULL,
`awaykey` int(5) NOT NULL,
`gamedate` date NOT NULL,
`homescore` smallint(6) NOT NULL,
`homescore1` smallint(6) NOT NULL,
`awayscore` smallint(6) NOT NULL,
`awayscore1` int(11) NOT NULL,
`homeshoot` int(5) NOT NULL,
`homeshootintarget` int(5) NOT NULL,
`awayshoot` int(5) NOT NULL,
`awayshootintarget` int(5) NOT NULL,
`yellowcardhome` int(5) NOT NULL,
`redcardhome` int(5) NOT NULL,
`yellowcardaway` int(5) NOT NULL,
`redcardaway` int(5) NOT NULL,
PRIMARY KEY (`id`,`homekey`,`awaykey`,`gamedate`),
KEY `fk_result_homekey` (`homekey`),
KEY `fk_result_awaykey` (`awaykey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=334 ;