Teams

CREATE 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` varchar(15) default NULL,
  `shirt2_team` varchar(15) default NULL,
  `shirt3_team` varchar(15) default NULL,
  `broek1_team` varchar(15) default NULL,
  `broek2_team` varchar(15) default NULL,
  `broek3_team` varchar(15) default NULL,
  `kous1_team` varchar(15) default NULL,
  `kous2_team` varchar(15) default NULL,
  `kous3_team` varchar(15) default NULL,
  PRIMARY KEY  (`id_team`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1009 ;

-- 
-- Sample records
-- 

INSERT INTO `teams` VALUES (34, 1, 0, 'BouwbedrijF Vos ', '#FFFFFF', NULL, NULL, '#FFFFFF', NULL, NULL, '#FFFFFF', NULL, NULL);
INSERT INTO `teams` VALUES (35, 4, 0, 'MarksliFe.Com', '#FF6600', '#FF6600', '#FF6600', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000');
INSERT INTO `teams` VALUES (36, 5, 0, 'Rison ZVV', '#FF0000', '#FF0000', '#FF0000', '#FFFFFF', '#FFFFFF', '#FFFFFF', '#FFFFFF', '#FFFFFF', '#FFFFFF');
INSERT INTO `teams` VALUES (37, 6, 0, 'van Wanrooy', '#FF0000', '#FF0000', '#FF0000', '#000000', '#000000', '#000000', '#FF0000', '#FF0000', '#FF0000');
INSERT INTO `teams` VALUES (38, 7, 0, 'Ron Smit Tapijt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

------------------------------------------------------------
Colors

CREATE 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- 
-- 
-- 

INSERT INTO `kleuren` VALUES (1, 'Zwart', '#000000');
INSERT INTO `kleuren` VALUES (2, 'Wit', '#FFFFFF');
INSERT INTO `kleuren` VALUES (3, 'Rood', '#FF0000');
INSERT INTO `kleuren` VALUES (4, 'Blauw', '#0000FF');
INSERT INTO `kleuren` VALUES (5, 'Groen', '#009900');
INSERT INTO `kleuren` VALUES (6, 'Rose', '#FF66FF');
INSERT INTO `kleuren` VALUES (7, 'Paars', '#FF00FF');
INSERT INTO `kleuren` VALUES (8, 'Licht Blauw', '#00CCFF');
INSERT INTO `kleuren` VALUES (9, 'Licht Groen', '#00CC00');
INSERT INTO `kleuren` VALUES (10, 'Bordeaux', '#CC0000');
INSERT INTO `kleuren` VALUES (11, 'Geel', '#FFFF00');
INSERT INTO `kleuren` VALUES (12, 'Oranje', '#FF6600');
INSERT INTO `kleuren` VALUES (13, '', '');