diff options
author | ivan <ivan> | 2003-12-23 01:49:32 +0000 |
---|---|---|
committer | ivan <ivan> | 2003-12-23 01:49:32 +0000 |
commit | d20581bcbf2809d5c2969d773b16a0c8714a6dec (patch) | |
tree | fa1668a8be9091b9dc3ae418c6def6de28e3bb75 /httemplate/docs/upgrade10.html | |
parent | 869a43742a9bcba4d2dd117b76e759ff6c81d371 (diff) |
add svc_external
Diffstat (limited to 'httemplate/docs/upgrade10.html')
-rw-r--r-- | httemplate/docs/upgrade10.html | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html index 3c6519a61..275b821a3 100644 --- a/httemplate/docs/upgrade10.html +++ b/httemplate/docs/upgrade10.html @@ -73,6 +73,13 @@ CREATE TABLE acct_snarf ( ); CREATE INDEX acct_snarf1 ON acct_snarf ( svcnum ); +CREATE TABLE svc_external ( + svcnum int NOT NULL, + id int NOT NULL, + title varchar(80), + PRIMARY KEY (svcnum) +); + CREATE TABLE part_pkg_temp ( pkgpart serial NOT NULL, pkg varchar(80) NOT NULL, @@ -175,7 +182,7 @@ optionally: mandatory again: dbdef-create username -create-history-tables username cust_bill_pkg_detail router part_svc_router addr_block svc_broadband acct_snarf +create-history-tables username cust_bill_pkg_detail router part_svc_router addr_block svc_broadband acct_snarf svc_external dbdef-create username apache - fix <Files> sections to include .html also |