| 3 |
lars |
1 |
|
|
|
2 |
CREATE TABLE `Feature_options` (
|
|
|
3 |
`ID` int(4) NOT NULL auto_increment,
|
|
|
4 |
`Feature` int(4) default NULL,
|
|
|
5 |
`Value` varchar(255) default NULL,
|
|
|
6 |
`bit` tinyint(1) default NULL,
|
|
|
7 |
PRIMARY KEY (`ID`)
|
|
|
8 |
) TYPE=MyISAM AUTO_INCREMENT=15 ;
|
|
|
9 |
|
|
|
10 |
INSERT INTO `Feature_options` VALUES (1, 1, 'Buche hell', 0);
|
|
|
11 |
INSERT INTO `Feature_options` VALUES (2, 1, 'Esche hell', 1);
|
|
|
12 |
INSERT INTO `Feature_options` VALUES (3, 1, 'Eiche rustikal', 2);
|
|
|
13 |
INSERT INTO `Feature_options` VALUES (7, 2, 'Buche mit Rand', 1);
|
|
|
14 |
INSERT INTO `Feature_options` VALUES (6, 2, 'Buche mit Leiste', 0);
|
|
|
15 |
INSERT INTO `Feature_options` VALUES (8, 2, 'Ahorn mit Rand', 2);
|
|
|
16 |
INSERT INTO `Feature_options` VALUES (9, 2, 'Weiß mit Rand', 3);
|
|
|
17 |
INSERT INTO `Feature_options` VALUES (10, 3, 'Weiß', 0);
|
|
|
18 |
INSERT INTO `Feature_options` VALUES (11, 3, 'Elfenbein', 1);
|
|
|
19 |
INSERT INTO `Feature_options` VALUES (12, 3, 'Blau', 2);
|
|
|
20 |
INSERT INTO `Feature_options` VALUES (13, 3, 'Rot', 3);
|
|
|
21 |
INSERT INTO `Feature_options` VALUES (14, 3, 'Braun', 4);
|