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 | |
| 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')
| -rw-r--r-- | httemplate/docs/schema.html | 7 | ||||
| -rw-r--r-- | httemplate/docs/upgrade8.html | 10 |
2 files changed, 15 insertions, 2 deletions
diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index a7c21c7c9..6ed96d229 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -256,10 +256,15 @@ <li>svcpart - <a href="#part_svc">Service definition</a> <li>quantity - quantity of this service that this package includes </ul> + <li><a name="export_svc" href="man/FS/export_svc.html">export_svc</a> + <ul> + <li>exportsvcnum - primary key + <li>svcpart - <a href="#part_svc">Service definition</a> + <li>exportnum - <a href="#exportnum">Export</a> + </ul> <li><a name="part_export" href="man/FS/part_export.html">part_export</a> - Export to external provisioning <ul> <li>exportnum - primary key - <li>svcpart - <a href="#part_svc">Service definition</a> <li>machine - Machine name <li>exporttype - Export type <li>nodomain - blank or Y: usernames are exported to this service with no domain 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 |