diff options
Diffstat (limited to 'upgradeprovisioning')
| -rwxr-xr-x | upgradeprovisioning | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/upgradeprovisioning b/upgradeprovisioning index e338ba9..da1dd66 100755 --- a/upgradeprovisioning +++ b/upgradeprovisioning @@ -536,4 +536,20 @@ if [ "$version" -lt "6" ]; then psql -U postgres -c "UPDATE provisioning_params SET value='6' WHERE name='databaseversion'" provisioning fi +if [ "$version" -lt "7" ]; then + echo "Upgrading to database version 7" + + psql -U postgres -c "INSERT INTO provisioning_params values(default, 'algospkmode', 'select', 'Speaker Mode (Algo)', '', '0', '18', '', null)" provisioning + + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Algo 8180 Device'), (SELECT param_id FROM provisioning_params WHERE name='algospkmode'), null, true)" provisioning + + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algospkmode'), 'Auto', '0', '0')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algospkmode'), 'External', '1', '1')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algospkmode'), 'Internal', '2', '2')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algospkmode'), 'Disabled', '3', '3')" provisioning + + # database + psql -U postgres -c "UPDATE provisioning_params SET value='7' WHERE name='databaseversion'" provisioning +fi + exit 0 |