Subversion-Projekte lars-tiefland.php_share

CREATE TABLE `Aktionen` (
  `ID` int(4) NOT NULL auto_increment,
  `shops_ID` int(2) NOT NULL default '1',
  `templates_ID` int(4) NOT NULL default '0',
  `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',
  `headline` varchar(255) default NULL,
  `bild_1_url` varchar(255) default NULL,
  `bild_pos1` varchar(255) default NULL,
  `bildunterschrift1` varchar(255) default NULL,
  `html_seite` text NOT NULL,
  `html_seite_schalter` enum('0','1') NOT NULL default '0',
  `text` text,
  `von` date default NULL,
  `bis` date default NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=0 ;


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');