From e7e24ddbecea030a5af8342ba153b8bcfba457c1 Mon Sep 17 00:00:00 2001 From: Ted Trask Date: Thu, 28 Jan 2016 14:28:38 +0000 Subject: 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) --- upgradeprovisioning | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'upgradeprovisioning') 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 -- cgit v1.2.3