From fb5fccc38bf11e7abd71a55b49b2f2f0c9a8ecc9 Mon Sep 17 00:00:00 2001 From: Vinicius de Jesus Date: Thu, 24 Dec 2015 08:34:45 -0200 Subject: Add Algo parameter related with Speaker mode Signed-off-by: Ted Trask --- upgradeprovisioning | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'upgradeprovisioning') 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 -- cgit v1.2.3