X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=README.1.5.8;h=cf414545e51720b022b04987af05a716f03f9da8;hb=b782294eb91805f708a7776fe67f1c0863f4096b;hp=73a85a2374ad1c0089060aa79d7249e287351ce8;hpb=c355bfa4646acb9c23a7cfcb53a5fe157f7c5965;p=freeside.git

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 );