All pastes #931088 Raw Edit

Anonymous

public sql v1 · immutable
·published 2008-03-06 23:13 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`)