diff options
author | ivan <ivan> | 2002-01-03 17:40:26 +0000 |
---|---|---|
committer | ivan <ivan> | 2002-01-03 17:40:26 +0000 |
commit | 69a0a7504f84aa9bb1f204d1f3522e1520e0885e (patch) | |
tree | de4cb175a70c7a7da58f84454fd29dfca55bd249 /httemplate/docs/upgrade8.html | |
parent | e3f87d761538a0a21d26fc86b5bce7c9d737d590 (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.html | 19 |
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; |