have fs-setup create the necessary "default" billing events

[freeside.git] / README.1.4.0pre4567-8

diff --git a/README.1.4.0pre4567-8 b/README.1.4.0pre4567-8
index e567120..11fc9c1 100644 (file)
--- a/README.1.4.0pre4567-8
+++ b/README.1.4.0pre4567-8
@@ -1,29 +1,66 @@
 the following is necessary to upgrade from 1.4.0pre (4 thru 7) to 1.4.0pre8
 
 the following is necessary to upgrade from 1.4.0pre (4 thru 7) to 1.4.0pre8
 

-install the perl modules and httemplate as per install.html or upgrade8.html
+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 Time::Duration and Tie::IxHash
+
+install the FS 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;
 
 
 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,
   eventnum int primary key,
   invnum int not null,
   eventpart int not null,

-  _date int not null,
+  _date int not null

 );
 CREATE UNIQUE INDEX cust_bill_events1 ON cust_bill_events ( eventpart, invnum );
 CREATE INDEX cust_bill_events2 ON cust_bill_events ( invnum );
 
 );
 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,
   eventcode text null,
   seconds int null,
   eventpart int primary key,
   payby char(4) not null,
   event varchar(80) not null,
   eventcode text null,
   seconds int null,

-  disabled char(1) null,
+  weight int not null,
+  plan varchar(80) null,
+  plandata text null,
+  disabled char(1) null

 );
 CREATE INDEX part_bill_events1 ON part_bill_events ( payby );
 
 );
 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 );
+
+ALTER TABLE cust_bill ADD closed char(1) NULL;
+ALTER TABLE cust_pay ADD closed char(1) NULL;
+ALTER TABLE cust_credit ADD closed char(1) NULL;
+ALTER TABLE cust_refund ADD closed char(1) NULL;
+

 Run bin/dbdef-create
 
 Restart Apache and freeside-queued
 Run bin/dbdef-create
 
 Restart Apache and freeside-queued