s/Post/Enter/;

[freeside.git] / README.1.7.0

diff --git a/README.1.7.0 b/README.1.7.0
index a6e18d0..24b89c9 100644 (file)
--- a/README.1.7.0
+++ b/README.1.7.0
@@ -8,9 +8,11 @@ ALTER TABLE cust_pay_batch ALTER COLUMN batchnum SET NOT NULL;
 ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512);
 UPDATE cust_pay_batch SET payinfo = cardnum;
 ALTER TABLE cust_pay_batch DROP COLUMN cardnum;
+ALTER TABLE cust_pay_batch ALTER COLUMN exp DROP NOT NULL;
 ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512);
 UPDATE h_cust_pay_batch SET payinfo = cardnum;
 ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;
+ALTER TABLE h_cust_pay_batch ALTER COLUMN exp DROP NOT NULL;
 
 make install-perl-modules
 run "freeside-upgrade username" to uprade your database schema
@@ -18,6 +20,11 @@ run "freeside-upgrade username" to uprade your database schema
 (if freeside-upgrade hangs, try stopping Apache, all Freeside processes, and
  anything else connected to your database, especially on older Pg versions)
 
+ACL bootstrapping:
+  - cd /usr/local/etc/freeside; chown freeside mapsecrets htpasswd
+  - Run "bin/mapsecrets2access_user username" as the freeside user
+  - You can then add more restrictive groups and move your users into them
+
 If you have any records in the cust_tax_exempt table, you *MUST* migrate them
 to the new cust_tax_exempt_pkg table.  An example script to get you started is
 in bin/fs-migrate-cust_tax_exempt - it may need to be customized for your
@@ -27,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;