2 install DBIx::DBSchema 0.31 (or later)
6 ALTER TABLE cust_pay_batch ADD COLUMN batchnum int;
7 ALTER TABLE cust_pay_batch ALTER COLUMN batchnum SET NOT NULL;
8 ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512);
9 UPDATE cust_pay_batch SET payinfo = cardnum;
10 ALTER TABLE cust_pay_batch DROP COLUMN cardnum;
11 ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512);
12 UPDATE h_cust_pay_batch SET payinfo = cardnum;
13 ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;
15 make install-perl-modules
16 run "freeside-upgrade username" to uprade your database schema
18 (if freeside-upgrade hangs, try stopping Apache, all Freeside processes, and
19 anything else connected to your database, especially on older Pg versions)
22 - cd /usr/local/etc/freeside; chown freeside mapsecrets htpasswd
23 - Run "bin/mapsecrets2access_user username" as the freeside user
24 - You can then add more restrictive groups and move your users into them
26 If you have any records in the cust_tax_exempt table, you *MUST* migrate them
27 to the new cust_tax_exempt_pkg table. An example script to get you started is
28 in bin/fs-migrate-cust_tax_exempt - it may need to be customized for your
31 Optional for better zip code report performance:
32 CREATE INDEX cust_main16 on cust_main ( zip );
33 CREATE INDEX cust_main17 on cust_main ( ship_zip );
35 Optional to eliminate harmless but noisy warnings:
36 UPDATE cust_main_county SET exempt_amount = 0 WHERE exempt_amount IS NULL;
41 (or "make deploy" if you've got everything setup in the Makefile)
43 (errors? try "make clean" then "make install-perl-modules", then
44 "make install-docs" or "make deploy" again)