diff options
| -rw-r--r-- | README.1.7.0 | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/README.1.7.0 b/README.1.7.0 index 992a988c8..a6e18d05d 100644 --- a/README.1.7.0 +++ b/README.1.7.0 @@ -1,6 +1,16 @@ 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 @@ -17,6 +27,9 @@ 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 |