diff options
| author | ivan <ivan> | 2002-04-11 22:05:31 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2002-04-11 22:05:31 +0000 |
| commit | a7c1b602f88c177db34477ed4cdc1f72603f8995 (patch) | |
| tree | 116d090127ee48b041eeb9ff21a0d62c0c768250 /httemplate/docs/upgrade8.html | |
| parent | 52a07a405e197fda1654fc61eefa538450f269e8 (diff) | |
(almost) everything for bug#375 - create export_svc table - part_svc to
part_export is now properly many-to-many, not one-to-many
still need to finish service editing (choosing exports) in
httemplate/edit/part_svc.cgi and httemplate/edti/process/part_svc.cgi
and do somethinga about that manual $svcdb = 'svc_acct' in
httemplate/edit/part_export.cgi (do part_export records need a svcdb?
probably not... should be able to just pass an svcdb on creation of new
exports, move the big %exports hash into part_export.pm and allow
httemplate/edit/part_svc.cgi to query it for exports that can apply to a given
svcdb....
Diffstat (limited to 'httemplate/docs/upgrade8.html')
| -rw-r--r-- | httemplate/docs/upgrade8.html | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index d1b13fe9c..841a053ed 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -152,9 +152,17 @@ CREATE TABLE part_bill_event ( ); CREATE INDEX part_bill_event1 ON part_bill_event ( payby ); +CREATE TABLE export_svc ( + exportsvcnum int primary key, + exportnum int not null, + svcpart int not null +); +CREATE UNIQUE INDEX export_svc1 ON export_svc ( exportnum, svcpart ); +CREATE INDEX export_svc2 ON export_svc ( exportnum ); +CREATE INDEX export_svc3 ON export_svc ( svcpart ); + 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 |