From 90a4aec660be666dda630895d4e96e87a7a04028 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Fri, 21 Jun 2002 09:28:27 +0000
Subject: [PATCH] don't forget part_svc in upgrades

---
 httemplate/docs/upgrade8.html | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html
index 8ba3b5baf..75155407c 100644
--- a/httemplate/docs/upgrade8.html
+++ b/httemplate/docs/upgrade8.html
@@ -69,6 +69,12 @@ CREATE TABLE svc_forward (
   dst varchar(80),
   PRIMARY KEY (svcnum)
 );
+ALTER TABLE part_svc ADD svc_forward__srcsvc varchar(80) NULL;
+ALTER TABLE part_svc ADD svc_forward__srcsvc_flag char(1) NULL;
+ALTER TABLE part_svc ADD svc_forward__dstsvc varchar(80) NULL;
+ALTER TABLE part_svc ADD svc_forward__dstsvc_flag char(1) NULL;
+ALTER TABLE part_svc ADD svc_forward__dst varchar(80) NULL;
+ALTER TABLE part_svc ADD svc_forward__dst_flag char(1) NULL;
 
 CREATE TABLE cust_credit_bill (
   creditbillnum int primary key,
@@ -214,6 +220,8 @@ CREATE TABLE cust_tax_exempt (
 CREATE UNIQUE INDEX cust_tax_exempt1 ON cust_tax_exempt ( taxnum, year, month );
 
 ALTER TABLE svc_acct ADD domsvc integer NULL;
+ALTER TABLE part_svc ADD svc_acct__domsvc varchar(80) NULL;
+ALTER TABLE part_svc ADD svc_acct__domsvc_flag char(1) NULL;
 ALTER TABLE svc_domain ADD catchall integer NULL;
 ALTER TABLE cust_main ADD referral_custnum integer NULL;
 ALTER TABLE cust_main ADD comments text NULL;
@@ -234,6 +242,8 @@ ALTER TABLE cust_refund ADD closed char(1) NULL;
 ALTER TABLE cust_bill_event ADD status varchar(80);
 ALTER TABLE cust_bill_event ADD statustext text NULL;
 ALTER TABLE svc_acct ADD sec_phrase varchar(80) NULL;
+ALTER TABLE part_svc ADD svc_acct__sec_phrase varchar(80) NULL;
+ALTER TABLE part_svc ADD svc_acct__sec_phrase_flag char(1) NULL;
 ALTER TABLE part_pkg ADD taxclass varchar(80) NULL;
 ALTER TABLE cust_main_county ADD taxclass varchar(80) NULL;
 ALTER TABLE cust_main_county ADD exempt_amount decimal(10,2);
-- 
2.11.0