Olorin Posted February 18, 2004 Posted February 18, 2004 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; Quote
Recommended Posts
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.