diff options
| author | Ted Trask <ttrask01@yahoo.com> | 2016-01-28 14:28:38 +0000 |
|---|---|---|
| committer | Ted Trask <ttrask01@yahoo.com> | 2016-01-28 14:28:38 +0000 |
| commit | 3862d4fd40c96b6237d334801d9a1d5523aebf92 (patch) | |
| tree | 8955e68f2a285b72394bb45c8fb56141a2d20196 /upgradeprovisioning | |
| parent | a4a0c4c48d70b90eb7791d808ebc0a5d8620314f (diff) | |
| download | acf-provisioning-3862d4fd40c96b6237d334801d9a1d5523aebf92.tar.bz2 acf-provisioning-3862d4fd40c96b6237d334801d9a1d5523aebf92.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
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 |