summaryrefslogtreecommitdiff
path: root/httemplate/docs/upgrade10.html
diff options
context:
space:
mode:
authorivan <ivan>2003-12-23 01:49:32 +0000
committerivan <ivan>2003-12-23 01:49:32 +0000
commitd20581bcbf2809d5c2969d773b16a0c8714a6dec (patch)
treefa1668a8be9091b9dc3ae418c6def6de28e3bb75 /httemplate/docs/upgrade10.html
parent869a43742a9bcba4d2dd117b76e759ff6c81d371 (diff)
add svc_external
Diffstat (limited to 'httemplate/docs/upgrade10.html')
-rw-r--r--httemplate/docs/upgrade10.html9
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