diff options
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 |