X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fdocs%2Fupgrade10.html;fp=httemplate%2Fdocs%2Fupgrade10.html;h=ac2c6238d8f2714d370a39954b4af4d8b254bbd7;hp=dd1b9ae1345a56c6f8d3fa38282821611538401c;hb=04175bb893448a31153bdca1539c44db6db0c003;hpb=1287d6792f03ba59508ea6338abc7ee3f1f0630e 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);