CREATE TABLE test_artikel (
  id int(11) NOT NULL auto_increment,
  artnr char(10) NOT NULL,
  name varchar(80) NOT NULL,
  preis decimal(8,2) NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;