diff options
Diffstat (limited to 'README.1.4.0pre4567-8')
| -rw-r--r-- | README.1.4.0pre4567-8 | 31 |
1 files changed, 29 insertions, 2 deletions
diff --git a/README.1.4.0pre4567-8 b/README.1.4.0pre4567-8 index e567120a9..57474fed0 100644 --- a/README.1.4.0pre4567-8 +++ b/README.1.4.0pre4567-8 @@ -1,11 +1,19 @@ the following is necessary to upgrade from 1.4.0pre (4 thru 7) to 1.4.0pre8 +if you're upgrading from 1.3.1 follow the instructions in +httemplate/docs/upgrade8.html instead + +if you're upgradeing from before 1.4.0pre4, see +http://cleanwhisker.420.am/cgi-bin/cvsweb/freeside/Attic/ + +----- + install the perl modules and httemplate as per install.html or upgrade8.html ALTER TABLE part_pkg ADD disabled char(1) NULL; ALTER TABLE part_svc ADD disabled char(1) NULL; -CREATE TABLE cust_bill_events ( +CREATE TABLE cust_bill_event ( eventnum int primary key, invnum int not null, eventpart int not null, @@ -14,7 +22,7 @@ CREATE TABLE cust_bill_events ( CREATE UNIQUE INDEX cust_bill_events1 ON cust_bill_events ( eventpart, invnum ); CREATE INDEX cust_bill_events2 ON cust_bill_events ( invnum ); -CREATE TABLE part_bill_events ( +CREATE TABLE part_bill_event ( eventpart int primary key, payby char(4) not null, event varchar(80) not null, @@ -24,6 +32,25 @@ CREATE TABLE part_bill_events ( ); CREATE INDEX part_bill_events1 ON part_bill_events ( payby ); +CREATE TABLE part_export ( + exportnum int primary key, + svcpart int not null, + machine varchar(80) not null, + exporttype varchar(80) not null, + nodomain char(1) NULL +); +CREATE INDEX part_export1 ON part_export ( machine ); +CREATE INDEX part_export2 ON part_export ( exporttype ); + +CREATE INDEX part_export_option ( + optionnum int primary key, + exportnum int not null, + option varchar(80) not null, + optionvalue text NULL +); +CREATE INDEX part_export_option1 ON part_export ( exportnum ); +CREATE INDEX part_export_option2 ON part_export ( option ); + Run bin/dbdef-create Restart Apache and freeside-queued |