| 3 |
lars |
1 |
|
|
|
2 |
CREATE TABLE `Bestellung` (
|
|
|
3 |
`ID` int(4) NOT NULL auto_increment,
|
|
|
4 |
`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',
|
|
|
5 |
`shops_ID` int(4) NOT NULL default '1',
|
|
|
6 |
`Login` int(4) default NULL,
|
|
|
7 |
`liefer_Firma` varchar(255) NOT NULL default '',
|
|
|
8 |
`liefer_Name` varchar(255) NOT NULL default '',
|
|
|
9 |
`liefer_Strasse` varchar(255) NOT NULL default '',
|
|
|
10 |
`liefer_Str_Nr` varchar(10) NOT NULL default '',
|
|
|
11 |
`liefer_PLZ` varchar(10) NOT NULL default '',
|
|
|
12 |
`liefer_Ort` varchar(255) NOT NULL default '',
|
|
|
13 |
`liefer_Land` varchar(255) NOT NULL default '',
|
|
|
14 |
`status` enum('offen','freigegeben','versand') NOT NULL default 'offen',
|
|
|
15 |
`gesamtsumme_buffer` decimal(20,2) NOT NULL default '0.00',
|
|
|
16 |
`artikelstatus_buffer` text NOT NULL,
|
|
|
17 |
`rechnungsstatus_buffer` text NOT NULL,
|
|
|
18 |
`erstellt_am` datetime default NULL,
|
|
|
19 |
`erstellt_von` varchar(255) default NULL,
|
|
|
20 |
`letzte_Aenderung_am` timestamp(14) NOT NULL,
|
|
|
21 |
`letzte_Aenderung_von` varchar(255) default NULL,
|
|
|
22 |
`Bemerkung` text,
|
|
|
23 |
PRIMARY KEY (`ID`,`Language`)
|
|
|
24 |
) TYPE=MyISAM AUTO_INCREMENT=0 ;
|