TABLE `teams` (
  `id_team` int(11) NOT NULL auto_increment,
  `idver_team` int(11) NOT NULL,
  `klasse_team` int(11) NOT NULL default '0',
  `naam_team` varchar(50) NOT NULL,
  `shirt1_team` int(11) default NULL,         //color
  `shirt2_team` int(11) default NULL,         //color
  `shirt3_team` int(11) default NULL,         //color
  `broek1_team` int(11) default NULL,         //color
  `broek2_team` int(11) default NULL,         //color
  `broek3_team` int(11) default NULL,         //color
  `kous1_team` int(11) default NULL,          //color
  `kous2_team` int(11) default NULL,          //color
  `kous3_team` int(11) default NULL,          //color
  PRIMARY KEY  (`id_team`)

TABLE `kleuren` (
  `id_kleur` int(11) NOT NULL auto_increment,
  `naam_kleur` varchar(15) NOT NULL,
  `code_kleur` varchar(7) NOT NULL,
  PRIMARY KEY  (`id_kleur`)