| 3 |
lars |
1 |
CREATE TABLE `Aktionen` (
|
|
|
2 |
`ID` int(4) NOT NULL auto_increment,
|
|
|
3 |
`shops_ID` int(2) NOT NULL default '1',
|
|
|
4 |
`templates_ID` int(4) NOT NULL default '0',
|
|
|
5 |
`Language` enum('DE','UK','ES','FR','RU','TR','NL','BE','PL','DK','IT','PT','CZ','SK','BG','CN','FI','GR','HU','NO','SE') NOT NULL default 'DE',
|
|
|
6 |
`headline` varchar(255) default NULL,
|
|
|
7 |
`bild_1_url` varchar(255) default NULL,
|
|
|
8 |
`bild_pos1` varchar(255) default NULL,
|
|
|
9 |
`bildunterschrift1` varchar(255) default NULL,
|
|
|
10 |
`html_seite` text NOT NULL,
|
|
|
11 |
`html_seite_schalter` enum('0','1') NOT NULL default '0',
|
|
|
12 |
`text` text,
|
|
|
13 |
`von` date default NULL,
|
|
|
14 |
`bis` date default NULL,
|
|
|
15 |
PRIMARY KEY (`ID`)
|
|
|
16 |
) TYPE=MyISAM AUTO_INCREMENT=0 ;
|
|
|
17 |
|
|
|
18 |
|
|
|
19 |
INSERT INTO `Aktionen` (`ID`, `shops_ID`, `templates_ID`, `Language`, `headline`, `bild_1_url`, `bild_pos1`, `bildunterschrift1`, `html_seite`, `html_seite_schalter`, `text`, `von`, `bis`) VALUES (6, 1, 0, 'DE', 'Top Angebote', NULL, NULL, NULL, '', '0', NULL, '2007-02-01', '2008-02-28');
|