diff options
| author | ivan <ivan> | 2004-02-13 10:57:55 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2004-02-13 10:57:55 +0000 |
| commit | 1e2a5c920840e046e4e28ca35681cb0912322666 (patch) | |
| tree | 6b8d7901a8fd4cd3c1ba786b0d30921a86a35589 | |
| parent | 07930a9141f823787a7e9c1e88fef453eb850fc7 (diff) | |
continue adding svc_forward.src: make svc_forward.srcsvc nullable
| -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 |