Jump to content
xt:Commerce Community Forum

Tables in DB eingliedern


tonkelz

Recommended Posts

Hallo!

möchte folgendes eingliedern in TABLE PRODUCTS

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:
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?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
  • Create New...