summaryrefslogtreecommitdiff
path: root/httemplate/docs/upgrade8.html
diff options
context:
space:
mode:
authorivan <ivan>2002-01-03 17:40:26 +0000
committerivan <ivan>2002-01-03 17:40:26 +0000
commit69a0a7504f84aa9bb1f204d1f3522e1520e0885e (patch)
treede4cb175a70c7a7da58f84454fd29dfca55bd249 /httemplate/docs/upgrade8.html
parente3f87d761538a0a21d26fc86b5bce7c9d737d590 (diff)
more schema changes: part_bill_event and cust_bill_event tables
remove old 1.4.0pre READMEs
Diffstat (limited to 'httemplate/docs/upgrade8.html')
-rw-r--r--httemplate/docs/upgrade8.html19
1 files changed, 19 insertions, 0 deletions
diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html
index 0855e6dee..13830dc6c 100644
--- a/httemplate/docs/upgrade8.html
+++ b/httemplate/docs/upgrade8.html
@@ -124,6 +124,25 @@ CREATE TABLE part_pop_local (
);
CREATE UNIQUE INDEX part_pop_local1 ON part_pop_local ( npa, nxx );
+CREATE TABLE cust_bill_event (
+ eventnum int primary key,
+ invnum int not null,
+ eventpart int not null,
+ _date int not null,
+);
+CREATE UNIQUE INDEX cust_bill_event1 ON cust_bill_event ( eventpart, invnum );
+CREATE INDEX cust_bill_event2 ON cust_bill_event ( invnum );
+
+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,
+ disabled char(1) null,
+);
+CREATE INDEX part_bill_event1 ON part_bill_event ( payby );
+
ALTER TABLE svc_acct ADD domsvc integer NOT NULL;
ALTER TABLE svc_domain ADD catchall integer NULL;
ALTER TABLE cust_main ADD referral_custnum integer NULL;