Hallo!
möchte folgendes eingliedern in TABLE PRODUCTS
Code:
CREATE TABLE IF NOT EXISTS `products` (
`products_ean` VARCHAR( 128 ) DEFAULT NULL ,
`products_shippingtime` INT( 4 ) NOT NULL DEFAULT '0',
`group_permission_0` TINYINT( 1 ) NOT NULL DEFAULT '0',
`group_permission_1` TINYINT( 1 ) NOT NULL DEFAULT '0',
`group_permission_2` TINYINT( 1 ) NOT NULL DEFAULT '0',
`group_permission_3` TINYINT( 1 ) NOT NULL DEFAULT '0',
`products_sort` INT( 4 ) NOT NULL DEFAULT '0',
`products_discount_allowed` DECIMAL( 3, 2 ) NOT NULL DEFAULT '0.00',
`product_template` VARCHAR( 64 ) DEFAULT NULL ,
`options_template` VARCHAR( 64 ) DEFAULT NULL ,
`products_vpe` INT( 11 ) NOT NULL DEFAULT '0',
`products_vpe_status` INT( 1 ) NOT NULL DEFAULT '0',
`products_vpe_value` DECIMAL( 15, 4 ) NOT NULL DEFAULT '0.0000',
`products_startpage` INT( 1 ) NOT NULL DEFAULT '0',
`products_startpage_sort` INT( 4 ) NOT NULL DEFAULT '0',
`products_zustand` VARCHAR( 10 ) NOT NULL DEFAULT 'neu',
)
Jetzt kommt folgender Fehler:
Code:
MySQL meldet:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 27
Ich habe aber doch gar keine line27 oder?
Wie bekomme ich diese tables in meine products?