Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Holding orders contribution


ihg

Recommended Posts

Hi

I have created the table as below, which I think follows the instructions but have an error. Can anyone see the problem please.

Kind regards

Ian

SQL-query:

 

CREATE TABLE `holding_orders` (

 

`orders_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,

`customers_id` INT( 11 ) DEFAULT '0' NOT NULL ,

`customers_name` VARCHAR( 64 ) NOT NULL ,

`customers_street_address` VARCHAR( 64 ) NOT NULL ,

`customers_suburb` VARCHAR( 32 ) NOT NULL ,

`customers_city` VARCHAR( 32 ) NOT NULL ,

`customers_postcode` VARCHAR( 10 ) NOT NULL ,

`customers_state` VARCHAR( 32 ) NOT NULL ,

`customers_country` VARCHAR( 32 ) NOT NULL ,

`customers_telephone` VARCHAR( 32 ) NOT NULL ,

`customers_email_address` VARCHAR( 96 ) NOT NULL ,

`customers_address_format_id` INT( 5 ) DEFAULT '0' NOT NULL

)

MySQL said:

 

#1075 - Incorrect table definition; There can only be one auto column and it must be defined as a key

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...