From 69a0a7504f84aa9bb1f204d1f3522e1520e0885e Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 3 Jan 2002 17:40:26 +0000 Subject: more schema changes: part_bill_event and cust_bill_event tables remove old 1.4.0pre READMEs --- README.1.4.0pre4567-8 | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) (limited to 'README.1.4.0pre4567-8') 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 -- cgit v1.2.1