diff options
author | ivan <ivan> | 2002-01-28 05:15:29 +0000 |
---|---|---|
committer | ivan <ivan> | 2002-01-28 05:15:29 +0000 |
commit | b03df92e48df653460cb8b6034a06dd1de6f4095 (patch) | |
tree | 68b9877ab8d872feecc6cdaff8ac35fc8b2d32e6 /httemplate/docs/upgrade8.html | |
parent | a820cfffc9f5413be79409c915565689563dede3 (diff) |
part_export schema changes
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 904694879..144242b6a 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -143,6 +143,25 @@ CREATE TABLE part_bill_event ( ); CREATE INDEX part_bill_event1 ON part_bill_event ( payby ); +CREATE TABLE part_export ( + exportnum int primary key, + svcpart int not null, + machine varchar(80) not null, + exporttype varchar(80) not null, + nodomain char(1) NULL +); +CREATE INDEX part_export1 ON part_export ( machine ); +CREATE INDEX part_export2 ON part_export ( exporttype ); + +CREATE INDEX part_export_option ( + optionnum int primary key, + exportnum int not null, + option varchar(80) not null, + optionvalue text NULL +); +CREATE INDEX part_export_option1 ON part_export ( exportnum ); +CREATE INDEX part_export_option2 ON part_export ( option ); + 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; |