From 1e2a5c920840e046e4e28ca35681cb0912322666 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Fri, 13 Feb 2004 10:57:55 +0000
Subject: [PATCH] continue adding svc_forward.src: make svc_forward.srcsvc
 nullable

---
 FS/bin/freeside-setup          | 6 +++---
 httemplate/docs/upgrade10.html | 6 ++++++
 2 files changed, 9 insertions(+), 3 deletions(-)

diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup
index feebcf9f7..7512cc18c 100755
--- a/FS/bin/freeside-setup
+++ b/FS/bin/freeside-setup
@@ -842,10 +842,10 @@ sub tables_hash_hack {
 
     'svc_forward' => {
       'columns' => [
-        'svcnum',   'int',    '',  '',
-        'srcsvc',   'int',    '',  '',
+        'svcnum',   'int',            '',   '',
+        'srcsvc',   'int',        'NULL',   '',
         'src',      'varchar',    'NULL',  255,
-        'dstsvc',   'int',    '',  '',
+        'dstsvc',   'int',        'NULL',   '',
         'dst',      'varchar',    'NULL',  255,
       ],
       'primary_key' => 'svcnum',
diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html
index a878495d4..c3f23b371 100644
--- a/httemplate/docs/upgrade10.html
+++ b/httemplate/docs/upgrade10.html
@@ -158,6 +158,12 @@ ALTER TABLE pkg_svc ADD primary_svc char(1) NULL;
 ALTER TABLE h_pkg_svc ADD primary_svc char(1) NULL;
 ALTER TABLE svc_forward ADD src varchar(255) NULL;
 ALTER TABLE h_svc_forward ADD src varchar(255) NULL;
+ALTER TABLE svc_forward ALTER COLUMN srcsvc DROP NOT NULL;
+ALTER TABLE h_svc_forward ALTER COLUMN srcsvc DROP NOT NULL;
+ALTER TABLE svc_forward ALTER COLUMN dstsvc DROP NOT NULL;
+ALTER TABLE h_svc_forward ALTER COLUMN dstsvc DROP NOT NULL;
+
+
 
 dump database, edit:
 - cust_main: increase otaker from 8 to 32
-- 
2.11.0