[TEP-COMMIT] [CVS catalog] add customer ip address fields

Commit in catalog/catalog/install/templates/pages on MAIN

upgrade_3.php +2 1.70 -> 1.71

add customer ip address fields

----------

catalog /catalog /install /templates /pages

upgrade_3.php 1.70 -> 1.71

diff -u -r1.70 -r1.71
--- upgrade_3.php 2004/07/22 20:47:11 1.70
+++ upgrade_3.php 2004/07/22 21:15:55 1.71
@@ -369,6 +369,7 @@

$osC_Database->simpleQuery("alter table customers drop customers_country_id");
$osC_Database->simpleQuery("alter table customers change customers_dob customers_dob datetime not null default '0000-00-00 00:00:00'");
$osC_Database->simpleQuery("alter table customers add customers_newsletter char(1)");

+ $osC_Database->simpleQuery("alter table customers add customers_ip_address varchar(15)");

$osC_Database->simpleQuery("alter table customers_basket change products_id products_id tinytext not null");
$osC_Database->simpleQuery("alter table customers_basket change customers_basket_date_added customers_basket_date_added varchar(8)");

@@ -488,6 +489,7 @@

$osC_Database->simpleQuery("alter table orders add billing_state varchar(32) after billing_postcode");
$osC_Database->simpleQuery("alter table orders add billing_country varchar(32) not null after billing_state");
$osC_Database->simpleQuery("alter table orders add billing_address_format_id int(5) not null after billing_country");

+ $osC_Database->simpleQuery("alter table orders add customers_ip_address varchar(15)");

$osC_Database->simpleQuery("alter table orders change payment_method payment_method varchar(32) not null");
$osC_Database->simpleQuery("alter table orders change date_purchased date_purchased datetime");
$osC_Database->simpleQuery("alter table orders change last_modified last_modified datetime");

CVSspam 0.2.8

-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click