CREATE TABLE `matchscore` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `team` varchar(20) NOT NULL,
  `matchname` varchar(20) NOT NULL,
  `score` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;