diff options
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 |