X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=README.1.5.8;h=cf414545e51720b022b04987af05a716f03f9da8;hb=37220994fec0ec4f8913be99f66aa082c78897a4;hp=211b5d9b2596c76f9929a2f2fa0c741e3715bdb0;hpb=e6cda8b39691e166266b306728a5271b6c81110d;p=freeside.git diff --git a/README.1.5.8 b/README.1.5.8 index 211b5d9b2..cf414545e 100644 --- a/README.1.5.8 +++ b/README.1.5.8 @@ -1,5 +1,6 @@ install JSON +install Term::ReadKey install DBIx::DBSchema 0.27 (or later) (if you are running Pg version 7.2.x or earlier, install at least @@ -16,6 +17,14 @@ run "freeside-upgrade username" to uprade your database schema Optional: CREATE INDEX cust_pkg2 ON cust_pkg ( pkgpart ); +CREATE INDEX cust_bill_pkg2 ON cust_bill_pkg ( pkgnum ); +CREATE INDEX cust_main9 ON cust_main ( county ); +CREATE INDEX cust_main10 ON cust_main ( state ); +CREATE INDEX cust_main11 ON cust_main ( country ); +CREATE INDEX cust_main_county1 ON cust_main_county ( county ); +CREATE INDEX cust_main_county2 ON cust_main_county ( state ); +CREATE INDEX cust_main_county3 ON cust_main_county ( country ); + Optional for better VoIP performance: CREATE INDEX rate_detail2 ON rate_detail ( ratenum, dest_regionnum );