diff options
| author | jeff <jeff> | 2006-05-20 20:06:30 +0000 |
|---|---|---|
| committer | jeff <jeff> | 2006-05-20 20:06:30 +0000 |
| commit | 50f25b285b2caf77d267ed66f03e56924ad7229f (patch) | |
| tree | 492bbc92656fbcbdfdc6880d88639388e9226225 /README.1.5.8 | |
| parent | 64dc1bb0f70ccc0b828cc1d758cd82f040e0ec33 (diff) | |
first stab at BoM download
Diffstat (limited to 'README.1.5.8')
| -rw-r--r-- | README.1.5.8 | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/README.1.5.8 b/README.1.5.8 index 6ad19b063..4335a5677 100644 --- a/README.1.5.8 +++ b/README.1.5.8 @@ -8,6 +8,15 @@ install DBIx::DBSchema 0.27 (or later) install HTML::Widgets:SelectLayers 0.05 (or later) install Business::CreditCard 0.28 (or later) +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 |