Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

I tried doing the first step, creating the three tables, and my sql gave me this error

 

MySQL said:

 

 

You have an error in your SQL syntax near '\'0\',

customers_name varchar(64) NOT NULL default \'\',

customers_street_' at line 3

 

 

 

Heres what was in the textfile

 

CREATE TABLE holding_orders (
 orders_id int(11) NOT NULL auto_increment,
 customers_id int(11) NOT NULL default '0',
 customers_name varchar(64) NOT NULL default '',
 customers_street_address varchar(64) NOT NULL default '',
 customers_suburb varchar(32) default NULL,
 customers_city varchar(32) NOT NULL default '',
 customers_postcode varchar(10) NOT NULL default '',
 customers_state varchar(32) default NULL,
 customers_country varchar(32) NOT NULL default '',
 customers_telephone varchar(32) NOT NULL default '',
 customers_email_address varchar(96) NOT NULL default '',
 customers_address_format_id int(5) NOT NULL default '0',
 delivery_name varchar(64) NOT NULL default '',
 delivery_street_address varchar(64) NOT NULL default '',
 delivery_suburb varchar(32) default NULL,
 delivery_city varchar(32) NOT NULL default '',
 delivery_postcode varchar(10) NOT NULL default '',
 delivery_state varchar(32) default NULL,
 delivery_country varchar(32) NOT NULL default '',
 delivery_address_format_id int(5) NOT NULL default '0',
 payment_method varchar(32) NOT NULL default '',
 cc_type varchar(20) default NULL,
 cc_owner varchar(64) default NULL,
 cc_number varchar(32) default NULL,
 cc_expires varchar(4) default NULL,
 last_modified datetime default NULL,
 date_purchased datetime default NULL,
 orders_status int(5) NOT NULL default '0',
 orders_date_finished datetime default NULL,
 comments text,
 currency char(3) default NULL,
 currency_value decimal(14,6) default NULL,
 PRIMARY KEY  (orders_id)
) TYPE=MyISAM;


CREATE TABLE holding_orders_products (
 orders_products_id int(11) NOT NULL auto_increment,
 orders_id int(11) NOT NULL default '0',
 products_id int(11) NOT NULL default '0',
 products_model varchar(12) default NULL,
 products_name varchar(64) NOT NULL default '',
 products_price decimal(15,4) NOT NULL default '0.0000',
 final_price decimal(15,4) NOT NULL default '0.0000',
 products_tax decimal(7,4) NOT NULL default '0.0000',
 products_quantity int(2) NOT NULL default '0',
 PRIMARY KEY  (orders_products_id)
) TYPE=MyISAM;


CREATE TABLE holding_orders_total (
 orders_total_id int(10) unsigned NOT NULL auto_increment,
 orders_id int(11) NOT NULL default '0',
 title varchar(255) NOT NULL default '',
 text varchar(255) NOT NULL default '',
 value decimal(15,4) NOT NULL default '0.0000',
 class varchar(32) NOT NULL default '',
 sort_order int(11) NOT NULL default '0',
 PRIMARY KEY  (orders_total_id),
 KEY idx_orders_total_orders_id (orders_id)
) TYPE=MyISAM;

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...