diff options
Diffstat (limited to 'README.1.7.0')
| -rw-r--r-- | README.1.7.0 | 40 |
1 files changed, 0 insertions, 40 deletions
diff --git a/README.1.7.0 b/README.1.7.0 deleted file mode 100644 index a6e18d05d..000000000 --- a/README.1.7.0 +++ /dev/null @@ -1,40 +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 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) - -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) - |