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
anything else connected to your database, especially on older Pg versions)
ACL bootstrapping:
- - Run "bin/mapsecrets2access_user username"
+ - 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
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;