diff options
author | ivan <ivan> | 2006-08-22 12:20:26 +0000 |
---|---|---|
committer | ivan <ivan> | 2006-08-22 12:20:26 +0000 |
commit | cbdd748a5f97567b350a820ec651455ac389f486 (patch) | |
tree | 944276e5d5783ff8df5076e7149ffa346b3e444d | |
parent | 86cb6d3882df9bcf8076558d597383da30ae0786 (diff) |
wiki!
-rw-r--r-- | README.1.7.0 | 50 |
1 files changed, 0 insertions, 50 deletions
diff --git a/README.1.7.0 b/README.1.7.0 deleted file mode 100644 index 24b89c9..0000000 --- a/README.1.7.0 +++ /dev/null @@ -1,50 +0,0 @@ - -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 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 - -(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 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; - ------- - -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) - |