X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=README.1.7.0;fp=README.1.7.0;h=0000000000000000000000000000000000000000;hb=cbdd748a5f97567b350a820ec651455ac389f486;hp=24b89c90d0487213358ab071df34edb8206eae69;hpb=86cb6d3882df9bcf8076558d597383da30ae0786;p=freeside.git diff --git a/README.1.7.0 b/README.1.7.0 deleted file mode 100644 index 24b89c90d..000000000 --- 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) -