Quote:
Originally Posted by rodneyw
Using phpMyAdmin you will need to modify your CUSTOMER table in the database.
Insert new field AFTER b_address with the name b_address2
Insert new field AFTER s_address with the name s_address2
Using phpMyAdmin you will need to modify your ORDERS table in the database.
Insert new field AFTER b_address with the name b_address2
Insert new field AFTER s_address with the name s_address2
|
Instead of doing this steps, in case you don't have phpmyadmin, you can use this SQL query in patch/upgrades in your X-Cart admin to achieve the same:
Code:
ALTER TABLE `xcart_customers` ADD `b_address2` VARCHAR( 64 ) NOT NULL AFTER `b_address` ;
ALTER TABLE `xcart_customers` ADD `s_address2` VARCHAR( 64 ) NOT NULL AFTER `s_address` ;
Great documentation btw