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`)