diff options
| author | ivan <ivan> | 2001-09-02 03:20:45 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2001-09-02 03:20:45 +0000 |
| commit | 02b16ae5152826a2dfc3ec9a2e173198e2d013d3 (patch) | |
| tree | b76405111301913485ee7deab5b3da5fea5bafc6 | |
| parent | d938dd5cd86b7fd2d9041f929a371a5faf3b18ac (diff) | |
upgrade
| -rw-r--r-- | httemplate/docs/upgrade8.html | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 573db3683..cd537119e 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -177,5 +177,19 @@ ALTER TABLE cust_main ADD COLUMN comments varchar NULL; <li>create a service based on svc_forward <li>Run bin/fs-migrate-svc_acct_sm <li>Run bin/fs-migrate-payref + <li><b>After running bin/fs-migrate-payref</b>, apply the following changes to your database: + <table border><tr><th>PostgreSQL</th><th>MySQL, others</th></tr> +<tr><td> +<font size=-1><pre> +ALTER TABLE cust_pay RENAME COLUMN invnum TO depreciated; +ALTER TABLE cust_refund RENAME COLUMN crednum TO depreciated; +</pre></font> +</td><td> +<font size=-1><pre> +ALTER TABLE cust_pay DROP COLUMN invnum; +ALTER TABLE cust_refund DROP COLUMN crednum; +</pre></font> +</td></tr></table> + <li><b>IMPORTANT: After applying the second set of database changes</b>, run bin/dbdef-create again. <li>create the conf.dbsrc/user_policy as appropriate for your site </body> |