diff options
| -rwxr-xr-x | FS/bin/freeside-setup | 6 | ||||
| -rw-r--r-- | 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 |