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 make install-perl-modules
12 run "freeside-upgrade username" to uprade your database schema
14 (if freeside-upgrade hangs, try stopping Apache, all Freeside processes, and
15 anything else connected to your database, especially on older Pg versions)
18 CREATE INDEX cust_pkg2 ON cust_pkg ( pkgpart );
20 CREATE INDEX cust_bill_pkg2 ON cust_bill_pkg ( pkgnum );
21 CREATE INDEX cust_main9 ON cust_main ( county );
22 CREATE INDEX cust_main10 ON cust_main ( state );
23 CREATE INDEX cust_main11 ON cust_main ( country );
24 CREATE INDEX cust_main_county1 ON cust_main_county ( county );
25 CREATE INDEX cust_main_county2 ON cust_main_county ( state );
26 CREATE INDEX cust_main_county3 ON cust_main_county ( country );
28 Optional for better VoIP performance:
29 CREATE INDEX rate_detail2 ON rate_detail ( ratenum, dest_regionnum );
33 Installs w/integrated RT:
34 Install Module::Versions::Report
36 chmod a+r /opt/rt3/etc/RT*Config.pm
40 /opt/rt3/sbin/rt-setup-database --action schema --datadir etc/upgrade/3.3.0
41 /opt/rt3/sbin/rt-setup-database --action acl --datadir etc/upgrade/3.3.0
42 /opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.3.0
44 /opt/rt3/sbin/rt-setup-database --action schema --datadir etc/upgrade/3.3.11
45 /opt/rt3/sbin/rt-setup-database --action acl --datadir etc/upgrade/3.3.11
46 /opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.3.11
48 run "dbdef-create username"
55 (or "make deploy" if you've got everything setup in the Makefile)