<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 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);
-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),
+ title varchar(80) NOT NULL,
PRIMARY KEY (titlenum)
);
+-->CREATE TABLE cust_main_invoice (
+ destnum int NOT NULL,
+ custnum int NOT NULL,
+ dest varchar(80) NOT NULL,
+ PRIMARY KEY (destnum),
+ INDEX ( custnum )
+);
</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>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.
<li>Copy or symlink htdocs and site_perl to the new copies.
</body>