diff options
| author | Ted Trask <ttrask01@yahoo.com> | 2016-01-28 14:28:38 +0000 |
|---|---|---|
| committer | Ted Trask <ttrask01@yahoo.com> | 2016-02-24 21:15:35 +0000 |
| commit | e7e24ddbecea030a5af8342ba153b8bcfba457c1 (patch) | |
| tree | d4dde798f5e7046a3a581cdff817314b40386b51 /upgradeprovisioning | |
| parent | 168435d418b85cb776295e12fcae540a2ec1afa8 (diff) | |
| download | acf-provisioning-e7e24ddbecea030a5af8342ba153b8bcfba457c1.tar.bz2 acf-provisioning-e7e24ddbecea030a5af8342ba153b8bcfba457c1.tar.xz | |
Further clean up group defaults and editable
Editable group params should have null default so don't show up as overridden (mailbox, mailcallback)
Removed editable from provpollingtime and dndenable as these should not be editable per device
(cherry picked from commit 3862d4fd40c96b6237d334801d9a1d5523aebf92)
Diffstat (limited to 'upgradeprovisioning')
| -rwxr-xr-x | upgradeprovisioning | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/upgradeprovisioning b/upgradeprovisioning index ffaa99a..ecca00e 100755 --- a/upgradeprovisioning +++ b/upgradeprovisioning @@ -556,4 +556,16 @@ if [ "$version" -lt "7" ]; then psql -U postgres -c "UPDATE provisioning_params SET value='7' WHERE name='databaseversion'" provisioning fi +if [ "$version" -lt "8" ]; then + echo "Upgrading to database version 8" + + psql -U postgres -c "UPDATE param_groups_to_params SET value=null WHERE param_id=(SELECT param_id FROM provisioning_params WHERE name='mailbox')" provisioning + psql -U postgres -c "UPDATE param_groups_to_params SET value=null WHERE param_id=(SELECT param_id FROM provisioning_params WHERE name='mailcallback')" provisioning + psql -U postgres -c "UPDATE param_groups_to_params SET editable=false WHERE param_id=(SELECT param_id FROM provisioning_params WHERE name='provpollingtime')" provisioning + psql -U postgres -c "UPDATE param_groups_to_params SET editable=false WHERE param_id=(SELECT param_id FROM provisioning_params WHERE name='dndenable')" provisioning + + # database + psql -U postgres -c "UPDATE provisioning_params SET value='8' WHERE name='databaseversion'" provisioning +fi + exit 0 |