add cust_main.agent_custid (at least to schema and customer view, no manual editing yet)

1 files changed, 3 insertions, 0 deletions

diff --git a/README.1.7.0 b/README.1.7.0
index c82c8ada9..24b89c90d 100644
--- a/README.1.7.0
+++ b/README.1.7.0
@@ -34,6 +34,9 @@ Optional for better zip code report performance:
 CREATE INDEX cust_main16 on cust_main ( zip );
 CREATE INDEX cust_main17 on cust_main ( ship_zip );
 
+Optional if you're using the new agent cust ref#s:
+CREATE UNIQUE INDEX cust_main18 ON cust_main ( agentnum, agent_custid );
+
 Optional to eliminate harmless but noisy warnings:
 UPDATE cust_main_county SET exempt_amount = 0 WHERE exempt_amount IS NULL;