5 install DBIx::DBSchema 0.27 (or later)
6 (if you are running Pg version 7.2.x or earlier, install at least
8 install HTML::Widgets:SelectLayers 0.05 (or later)
9 install Business::CreditCard 0.28 (or later)
11 ALTER TABLE cust_pay_batch ADD COLUMN batchnum int;
12 ALTER TABLE cust_pay_batch ALTER COLUMN batchnum SET NOT NULL;
13 ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512);
14 UPDATE cust_pay_batch SET payinfo = cardnum;
15 ALTER TABLE cust_pay_batch DROP COLUMN cardnum;
16 ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512);
17 UPDATE h_cust_pay_batch SET payinfo = cardnum;
18 ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;
20 make install-perl-modules
21 run "freeside-upgrade username" to uprade your database schema
23 (if freeside-upgrade hangs, try stopping Apache, all Freeside processes, and
24 anything else connected to your database, especially on older Pg versions)
27 CREATE INDEX cust_pkg2 ON cust_pkg ( pkgpart );
29 CREATE INDEX cust_bill_pkg2 ON cust_bill_pkg ( pkgnum );
30 CREATE INDEX cust_main9 ON cust_main ( county );
31 CREATE INDEX cust_main10 ON cust_main ( state );
32 CREATE INDEX cust_main11 ON cust_main ( country );
33 CREATE INDEX cust_main_county1 ON cust_main_county ( county );
34 CREATE INDEX cust_main_county2 ON cust_main_county ( state );
35 CREATE INDEX cust_main_county3 ON cust_main_county ( country );
37 Optional for better VoIP performance:
38 CREATE INDEX rate_detail2 ON rate_detail ( ratenum, dest_regionnum );
42 Installs w/integrated RT:
43 Install Module::Versions::Report
45 chmod a+r /opt/rt3/etc/RT*Config.pm
49 /opt/rt3/sbin/rt-setup-database --action schema --datadir etc/upgrade/3.3.0
50 /opt/rt3/sbin/rt-setup-database --action acl --datadir etc/upgrade/3.3.0
51 /opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.3.0
53 /opt/rt3/sbin/rt-setup-database --action schema --datadir etc/upgrade/3.3.11
54 /opt/rt3/sbin/rt-setup-database --action acl --datadir etc/upgrade/3.3.11
55 /opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.3.11
57 run "dbdef-create username"
64 (or "make deploy" if you've got everything setup in the Makefile)
66 (errors? try "make clean" then "make install-perl-modules", then
67 "make install-docs" or "make deploy" again)