X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=htdocs%2Fdocs%2Fupgrade3.html;h=0837e0207cac41e94789c76a13f9be2b0c65a6a4;hb=dcea7c60c75544055ee1add9fcd70d0af6863c47;hp=15066423e657e91500a2f1b2130e8ccbeecb4056;hpb=ef834d58bfd2ce38c8bea73262c8091a5d88388f;p=freeside.git diff --git a/htdocs/docs/upgrade3.html b/htdocs/docs/upgrade3.html index 15066423e..0837e0207 100644 --- a/htdocs/docs/upgrade3.html +++ b/htdocs/docs/upgrade3.html @@ -2,7 +2,7 @@ Upgrading to 1.2.x -

Upgrading to 1.1.x from 1.2.x

Upgrading to 1.2.x from 1.1.x

If migrating from 1.0.0, see these instructions first.
If migrating from less than 1.1.4, see these instructions first. @@ -14,19 +14,27 @@
Move /var/spool/freeside/export to /usr/local/etc/freeside/export.datasrc.

Apply the following changes to your database:

-ALTER TABLE cust_main ADD middle varchar(80) 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 (
+ALTER TABLE cust_main CHANGE paydate paydate varchar(10);
+UPDATE cust_main SET country = "US" where country IS NULL OR country = '';
+UPDATE cust_main_county SET country = "US" where country IS NULL OR country = "";
+CREATE TABLE cust_main_invoice (
+   destnum int NOT NULL,
+   custnum int NOT NULL,
+   dest varchar(80) NOT NULL,
+   PRIMARY KEY (destnum),
+   INDEX ( custnum )
+);

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. +
Run bin/dbdef-create. This file uses MySQL-specific syntax. If you are running a different database engine you will need to modify it slightly.
Copy or symlink htdocs and site_perl to the new copies.