2 <title>Upgrading to 1.3.0</title>
5 <h1>Upgrading to 1.2.3 from 1.2.2</h1>
7 <li>If migrating from 1.0.0, see these <a href="upgrade.html">instructions</a> first.
8 <li>If migrating from less than 1.1.4, see these <a href="upgrade2.html">instructions</a> first.
9 <li>If migrating from less than 1.2.0, see these <a href="upgrade3.html">instructions</a> first.
10 <li>If migrating from less than 1.2.2, see these <a href="upgrade4.html">instructions</a> first.
11 <li>Back up your data and current Freeside installation.
12 <li>Apply the following changes to your database:
14 ALTER TABLE svc_acct_pop ADD loc CHAR(4);
15 CREATE TABLE prepay_credit (
16 prepaynum int NOT NULL,
17 identifier varchar(80) NOT NULL,
18 amount decimal(10,2) NOT NULL,
19 PRIMARY KEY (prepaynum),
22 CREATE TABLE domain_record (
25 reczone varchar(80) NOT NULL,
26 recaf char(2) NOT NULL,
27 rectype char(5) NOT NULL,
28 recdata varchar(80) NOT NULL,
31 CREATE TABLE svc_www (
37 ALTER TABLE part_svc ADD svc_www__svcnum varchar(80) NULL;
38 ALTER TABLE part_svc ADD svc_www__svcnum_flag char(1) NULL;
39 ALTER TABLE part_svc ADD svc_www__recnum varchar(80) NULL;
40 ALTER TABLE part_svc ADD svc_www__recnum_flag char(1) NULL;
41 ALTER TABLE part_svc ADD svc_www__usersvc varchar(80) NULL;
42 ALTER TABLE part_svc ADD svc_www__uesrsvc_flag char(1) NULL;
45 <li>Copy or symlink htdocs to the new copy.
46 <li>Remove the symlink or directory <i>(your_site_perl_directory)</i>/FS.
47 <li>Change to the FS directory in the new tarball, and build and install the
55 <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.