projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
documentation oops
[freeside.git]
/
htdocs
/
docs
/
upgrade3.html
diff --git
a/htdocs/docs/upgrade3.html
b/htdocs/docs/upgrade3.html
index
d2795bd
..
0837e02
100644
(file)
--- a/
htdocs/docs/upgrade3.html
+++ b/
htdocs/docs/upgrade3.html
@@
-2,7
+2,7
@@
<title>Upgrading to 1.2.x</title>
</head>
<body>
<title>Upgrading to 1.2.x</title>
</head>
<body>
-<h1>Upgrading to 1.
1.x from 1.2
.x</h1>
+<h1>Upgrading to 1.
2.x from 1.1
.x</h1>
<ul>
<li>If migrating from 1.0.0, see these <a href="upgrade.html">instructions</a> first.
<li>If migrating from less than 1.1.4, see these <a href="upgrade2.html">instructions</a> first.
<ul>
<li>If migrating from 1.0.0, see these <a href="upgrade.html">instructions</a> first.
<li>If migrating from less than 1.1.4, see these <a href="upgrade2.html">instructions</a> first.
@@
-14,18
+14,20
@@
<li>Move /var/spool/freeside/export to /usr/local/etc/freeside/export.<i>datasrc</i>.
<li>Apply the following changes to your database:
<pre>
<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 middle varchar(80) NULL;
ALTER TABLE cust_main ADD titlenum int NULL;
ALTER TABLE cust_main ADD titlenum int NULL;
-ALTER TABLE cust_main CHANGE state state 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);
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 part_title (
titlenum int NOT NULL,
title varchar(80) NOT NULL,
PRIMARY KEY (titlenum)
);
titlenum int NOT NULL,
title varchar(80) NOT NULL,
PRIMARY KEY (titlenum)
);
-CREATE TABLE cust_main_invoice (
+
-->
CREATE TABLE cust_main_invoice (
destnum int NOT NULL,
custnum int NOT NULL,
dest varchar(80) NOT NULL,
destnum int NOT NULL,
custnum int NOT NULL,
dest varchar(80) NOT NULL,