X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=README.1.5.8;fp=README.1.5.8;h=cf414545e51720b022b04987af05a716f03f9da8;hp=73a85a2374ad1c0089060aa79d7249e287351ce8;hb=58c036fab9ec7f116c5c3f60f20116b433b1930a;hpb=75e7d0189cb306f8ea01c4961f1e3cd02cd92675 diff --git a/README.1.5.8 b/README.1.5.8 index 73a85a237..cf414545e 100644 --- a/README.1.5.8 +++ b/README.1.5.8 @@ -17,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 );