continue adding svc_forward.src: make svc_forward.srcsvc nullable

diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup
index feebcf9..7512cc1 100755 (executable)
--- 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 a878495..c3f23b3 100644 (file)
--- 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