summaryrefslogtreecommitdiff
path: root/README.1.4.0pre4567-8
diff options
context:
space:
mode:
Diffstat (limited to 'README.1.4.0pre4567-8')
-rw-r--r--README.1.4.0pre4567-819
1 files changed, 19 insertions, 0 deletions
diff --git a/README.1.4.0pre4567-8 b/README.1.4.0pre4567-8
index 2e2138b37..e567120a9 100644
--- a/README.1.4.0pre4567-8
+++ b/README.1.4.0pre4567-8
@@ -5,6 +5,25 @@ 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 (
+ eventnum int primary key,
+ invnum int not null,
+ eventpart 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 TABLE part_bill_events (
+ eventpart int primary key,
+ payby char(4) not null,
+ event varchar(80) not null,
+ eventcode text null,
+ seconds int null,
+ disabled char(1) null,
+);
+CREATE INDEX part_bill_events1 ON part_bill_events ( payby );
+
Run bin/dbdef-create
Restart Apache and freeside-queued