All pastes #931076 Raw Edit

Anonymous

public sql v1 · immutable
·published 2008-03-06 23:04 UTC
rendered paste body
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`)