diff options
Diffstat (limited to 'htdocs/docs/upgrade3.html')
| -rw-r--r-- | htdocs/docs/upgrade3.html | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/htdocs/docs/upgrade3.html b/htdocs/docs/upgrade3.html index bfb717cfa..15066423e 100644 --- a/htdocs/docs/upgrade3.html +++ b/htdocs/docs/upgrade3.html @@ -12,5 +12,21 @@ <li>Move /var/spool/freeside/dbdef.<i>datasrc</i> to /usr/local/etc/freeside/dbdef.<i>datasrc</i>. <li>Move /var/spool/freeside/counters to /usr/local/etc/freeside/counters.<i>datasrc</i>. <li>Move /var/spool/freeside/export to /usr/local/etc/freeside/export.<i>datasrc</i>. + <li>Apply the following changes to your database: +<pre> +ALTER TABLE cust_main ADD middle varchar(80) NULL; +ALTER TABLE cust_main ADD titlenum int NULL; +ALTER TABLE cust_main CHANGE state state varchar(80) NULL; +ALTER TABLE cust_main_county CHANGE state state varchar(80) NULL; +ALTER TABLE cust_main_county ADD country char(2); +UPDATE cust_main_county SET country = "US" where country IS NULL; +CREATE TABLE part_title ( + titlenum int NOT NULL, + title varchar(80), + PRIMARY KEY (titlenum) +); +</pre> + <li>Run bin/dbdef-create. This file uses MySQL-specific syntax. If you are r +unning a different database engine you will need to modify it slightly. <li>Copy or symlink htdocs and site_perl to the new copies. </body> |