anyone know how to add UPS MS2 sql manually with loosing old

[Guest]

I want to add the UPS tracking module that will allow my customers to on click access from their account to UPS tracking, but I dont want to loose all my order info, in the contribution instructions it says you can manually add it if you know how... here is the problem, I dont know how to do it. Is there anyone that could add this to my sql dump of my catalog for me, or can someone explain what I would need to do so I dont loose the orders that I currently have... Thanks Doug

 

Please message me if you have time to help me modifying mine. Doug

 

 

Here is what I will need to be adding to my current database

DROP TABLE IF EXISTS orders;

CREATE TABLE 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_company 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_company 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',

billing_name varchar(64) NOT NULL default '',

billing_company varchar(64) NOT NULL default '',

billing_street_address varchar(64) NOT NULL default '',

billing_suburb varchar(32) default NULL,

billing_city varchar(32) NOT NULL default '',

billing_postcode varchar(10) NOT NULL default '',

billing_state varchar(32) default NULL,

billing_country varchar(32) NOT NULL default '',

billing_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,

ups_track_num varchar(18) default NULL,

usps_track_num varchar(24) default NULL,

fedex_track_num varchar(20) default NULL,

comments text,

currency char(3) default NULL,

currency_value decimal(14,6) default NULL,

PRIMARY KEY (orders_id)

) TYPE=MyISAM;