summaryrefslogtreecommitdiff
path: root/README.1.7.0
diff options
context:
space:
mode:
authorjeff <jeff>2006-08-09 06:43:02 +0000
committerjeff <jeff>2006-08-09 06:43:02 +0000
commit6c375156081be5d2023001ed8eaac9b6db568e95 (patch)
tree2fc0676f8f6facd38773035e4a22ba23fd7d85ed /README.1.7.0
parentb58e61ac7df612f606c3e68371265e790e0be585 (diff)
batch refactor
Diffstat (limited to 'README.1.7.0')
-rw-r--r--README.1.7.02
1 files changed, 2 insertions, 0 deletions
diff --git a/README.1.7.0 b/README.1.7.0
index 69b395a34..c82c8ada9 100644
--- a/README.1.7.0
+++ b/README.1.7.0
@@ -8,9 +8,11 @@ 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