Subversion-Projekte lars-tiefland.php_share

CREATE TABLE `Feature_options` (
  `ID` int(4) NOT NULL auto_increment,
  `Feature` int(4) default NULL,
  `Value` varchar(255) default NULL,
  `bit` tinyint(1) default NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=15 ;

INSERT INTO `Feature_options` VALUES (1, 1, 'Buche hell', 0);
INSERT INTO `Feature_options` VALUES (2, 1, 'Esche hell', 1);
INSERT INTO `Feature_options` VALUES (3, 1, 'Eiche rustikal', 2);
INSERT INTO `Feature_options` VALUES (7, 2, 'Buche mit Rand', 1);
INSERT INTO `Feature_options` VALUES (6, 2, 'Buche mit Leiste', 0);
INSERT INTO `Feature_options` VALUES (8, 2, 'Ahorn mit Rand', 2);
INSERT INTO `Feature_options` VALUES (9, 2, 'Weiß mit Rand', 3);
INSERT INTO `Feature_options` VALUES (10, 3, 'Weiß', 0);
INSERT INTO `Feature_options` VALUES (11, 3, 'Elfenbein', 1);
INSERT INTO `Feature_options` VALUES (12, 3, 'Blau', 2);
INSERT INTO `Feature_options` VALUES (13, 3, 'Rot', 3);
INSERT INTO `Feature_options` VALUES (14, 3, 'Braun', 4);