11 lines
336 B
SQL
Executable File
11 lines
336 B
SQL
Executable File
CREATE TABLE Articlemaster (
|
|
article varchar(20) NOT NULL default '',
|
|
caption varchar(50) NOT NULL default '',
|
|
gtin varchar(14) NOT NULL default '',
|
|
normammount INTEGER NULL default '',
|
|
minammount INTEGER NULL default '',
|
|
zone INTEGER NOT NULL default '1',
|
|
dest INTEGER NOT NILL default '0',
|
|
PRIMARY KEY (article)
|
|
);
|