[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