X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=htdocs%2Fdocs%2Fupgrade3.html;h=15066423e657e91500a2f1b2130e8ccbeecb4056;hp=bfb717cfa13b1b453a196d9f1d198ebddf686f46;hb=ef834d58bfd2ce38c8bea73262c8091a5d88388f;hpb=69eff6e55baea5f6d99f8f797fa2eac6f761838b 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 @@
+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) +); ++