From 04175bb893448a31153bdca1539c44db6db0c003 Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 5 Jan 2006 09:34:28 +0000 Subject: [PATCH] my last 1.4 -> 1.5 upgrade... --- httemplate/docs/upgrade10.html | 22 ++++++++++++++-------- 1 file changed, 14 insertions(+), 8 deletions(-) diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html index dd1b9ae13..ac2c6238d 100644 --- a/httemplate/docs/upgrade10.html +++ b/httemplate/docs/upgrade10.html @@ -9,13 +9,13 @@ If migrating from 1.5.7, see README.1.5.8 instead If migrating from 1.5.0pre6, see README.1.5.7 instead -install JSON install DBD::Pg 1.32, 1.41 or later (not 1.40) (or, if you're using a Perl version before 5.6, you could try installing DBD::Pg 1.22 with this patch and commenting out the "use DBD::Pg 1.32" at the top of DBIx/DBSchema/DBD/Pg.pm) install DBIx::DBSchema 0.27 (or later) (if you are running Pg version 7.2.x or earlier, install at least DBIx::DBSchema 0.29) install Net::SSH 0.08 install HTML::Widgets::SelectLayers 0.05 +install Business::CreditCard 0.28 - If using Apache::ASP, add PerlSetVar RequestBinaryRead Off and PerlSetVar IncludesDir /your/freeside/document/root/ to your Apache configuration and make sure you are using Apache::ASP minimum version 2.55. - In httpd.conf, change <Files ~ \.cgi> to <Files ~ (\.cgi|\.html)> @@ -38,7 +38,7 @@ ALTER TABLE cust_main ALTER COLUMN payinfo varchar(512) NULL; ALTER TABLE h_cust_main ALTER COLUMN payinfo varchar(512) NULL; Or on older Pg versions that don't support altering columns directly: -(write me) +(dump database, edit & reload) On recent Pg versions: @@ -71,12 +71,18 @@ run "freeside-upgrade username" to create the remaining new tables and columns optionally: -CREATE INDEX cust_main6 ON cust_main ( daytime ); -CREATE INDEX cust_main7 ON cust_main ( night ); -CREATE INDEX cust_main8 ON cust_main ( fax ); -CREATE INDEX cust_main9 ON cust_main ( ship_daytime ); -CREATE INDEX cust_main10 ON cust_main ( ship_night ); -CREATE INDEX cust_main11 ON cust_main ( ship_fax ); +CREATE INDEX cust_main4 ON cust_main ( daytime ); +CREATE INDEX cust_main5 ON cust_main ( night ); +CREATE INDEX cust_main6 ON cust_main ( fax ); +CREATE INDEX cust_main7 ON cust_main ( refnum ); +CREATE INDEX cust_main8 ON cust_main ( county ); +CREATE INDEX cust_main9 ON cust_main ( state ); +CREATE INDEX cust_main10 ON cust_main ( country ); +CREATE INDEX cust_main11 ON cust_main ( ship_last ); +CREATE INDEX cust_main12 ON cust_main ( ship_company ); +CREATE INDEX cust_main13 ON cust_main ( ship_daytime ); +CREATE INDEX cust_main14 ON cust_main ( ship_night ); +CREATE INDEX cust_main15 ON cust_main ( ship_fax ); CREATE INDEX agent2 ON agent ( disabled ); CREATE INDEX part_bill_event2 ON part_bill_event ( disabled ); CREATE INDEX cust_pay4 ON cust_pay (_date); -- 2.11.0