<img src="overview.png">
<ul>
<li><a href="install.html">New Installation</a>
- <li><a href="upgrade.html">Upgrading from 1.0.x to 1.1.x</a>
- <li><a href="upgrade2.html">Upgrading from 1.1.x to 1.1.4</a>
- <li><a href="upgrade3.html">Upgrading from 1.1.x to 1.2.x</a>
<li><a href="upgrade4.html">Upgrading from 1.2.x to 1.2.2</a>
<li><a href="upgrade5.html">Upgrading from 1.2.2 to 1.2.3</a>
<li><a href="upgrade6.html">Upgrading from 1.2.3 to 1.3.0</a>
+++ /dev/null
-<head>
- <title>Upgrading to 1.1.x</title>
-</head>
-<body>
-<h1>Upgrading to 1.1.x</h1>
-<ul>
- <li>Back up your data and current Freeside installation.
- <li>Unpack a copy of the 1.0.0 distribution in a separate location.
- <li>Diff your current installation against the 1.0.0 distribution.
- <li>Apply all the diffs you found above, if applicable.
- <li>Apply (at least) the following changes to your database:
-<pre>
-ALTER TABLE cust_main CHANGE ss ss char(11) NULL;
-ALTER TABLE cust_main CHANGE day daytime varchar(20) NULL;
-ALTER TABLE svc_acct CHANGE password _password varchar(25) NOT NULL;
-ALTER TABLE part_svc CHANGE svc_acct__password svc_acct___password varchar(25) NULL;
-ALTER TABLE part_svc CHANGE svc_acct__password_flag svc_acct___password_flag char(1) NULL;
-ALTER TABLE agent_type CHANGE type atype varchar(80) NOT NULL;
-</pre>
- <li>Optionally change the field lengths and types to match a 1.1.x install; see `bin/fs-setup'.
- <li>Create the necessary <a href="config.html">configuration files</a>,
- <li>Copy or symlink htdocs and site_perl to the new 1.1.x copies.
- <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.
-</body>
+++ /dev/null
-<head>
- <title>Upgrading to 1.1.4</title>
-</head>
-<body>
-<h1>Upgrading to 1.1.4 from 1.1.x</h1>
-<ul>
- <li>If migrating from 1.0.0, see these <a href="upgrade.html">instructions</a> first.
- <li>Back up your data and current Freeside installation.
- <li>If applicable, create the new <a href="config.html">configuration files</a>: lpr, cybercash2, cybercash3.2
- <li>Copy or symlink htdocs and site_perl to the new copies.
-</body>
+++ /dev/null
-<head>
- <title>Upgrading to 1.2.x</title>
-</head>
-<body>
-<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.
- <li>Back up your data and current Freeside installation.
- <li>Install the Perl module <a href="http://www.perl.com/CPAN/modules/by-module/String/">String-Approx</a>
- <li><a href="config.html">Configuration file</a> location has changed!
- <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);
-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)
-);
--->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 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>