X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=README.1.4.0pre4567-8;h=e567120a9c788f37be069943c38e5e04f0b96bca;hb=99e136cfed6e793e7f85b0916239416bf96acaf7;hp=2e2138b3791164a90664ffe954a877b71371bb1d;hpb=cf16b23820da69e3c8d0156ae27e21c635bf1ec5;p=freeside.git

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