blob: 69b395a341f4a35f1896044a46eea0b8163f73b3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
install DBIx::DBSchema 0.31 (or later)
install Color::Scheme
install Data::Table
ALTER TABLE cust_pay_batch ADD COLUMN batchnum int;
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 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;
make install-perl-modules
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
specific data.
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 to eliminate harmless but noisy warnings:
UPDATE cust_main_county SET exempt_amount = 0 WHERE exempt_amount IS NULL;
------
make install-docs
(or "make deploy" if you've got everything setup in the Makefile)
(errors? try "make clean" then "make install-perl-modules", then
"make install-docs" or "make deploy" again)
|
