SQL - Eine Tabelle erstellen

[sniper_w]

SQL-Code:

CREATE TABLE `TableName` (`ID` INT (3) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, `ArtNr` VARCHAR (30) DEFAULT '0' NOT NULL, `ProduktEn` VARCHAR (250) DEFAULT '0' NOT NULL, `ProduktDe` VARCHAR (250) DEFAULT '0' NOT NULL, `ProduktBa` VARCHAR (250) DEFAULT '0' NOT NULL, `Preis` DOUBLE (3) DEFAULT '0' NOT NULL, PRIMARY KEY(`ID`), UNIQUE(`ID`))  TYPE = MyISAM
Error: 1064 - You have an error in your SQL syntax near ') DEFAULT '0' NOT NULL, PRIMARY KEY(`ID`), UNIQUE(`ID`))  TYPE = MyISAM' at line 1
CREATE TABLE `SkpNahrung` (`ID` INT (3) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, `ArtNr` VARCHAR (30) DEFAULT '0' NOT NULL, `ProduktEn` VARCHAR (250) DEFAULT '0', `ProduktDe` VARCHAR (250) DEFAULT '0', `ProduktBa` VARCHAR (250) DEFAULT '0', `Preis` DOUBLE (3) DEFAULT '0' NOT NULL, PRIMARY KEY(`ID`), UNIQUE(`ID`))  TYPE = MyISAM
Error: 1064 - You have an error in your SQL syntax near ') DEFAULT '0' NOT NULL, PRIMARY KEY(`ID`), UNIQUE(`ID`))  TYPE = MyISAM' at line 1
CREATE TABLE `SkpNahrung` (`ID` INT (3) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, `ArtNr` VARCHAR (30) DEFAULT '0' NOT NULL, `ProduktEn` VARCHAR (250) DEFAULT '0', `ProduktDe` VARCHAR (250) DEFAULT '0', `ProduktBa` VARCHAR (250) DEFAULT '0', `Preis` DOUBLE (3) DEFAULT '0' NOT NULL, PRIMARY KEY(`ID`), UNIQUE(`ID`)) 
Error: 1064 - You have an error in your SQL syntax near ') DEFAULT '0' NOT NULL, PRIMARY KEY(`ID`), UNIQUE(`ID`)) ' at line 1

Was stimmt hier nicht ?