diff options
| author | Vinicius de Jesus <viniciusdjesus@hotmail.com> | 2015-12-24 08:34:45 -0200 |
|---|---|---|
| committer | Ted Trask <ttrask01@yahoo.com> | 2015-12-24 19:05:52 +0000 |
| commit | fb5fccc38bf11e7abd71a55b49b2f2f0c9a8ecc9 (patch) | |
| tree | 43bb6edd0e846f732d5d3fada145b6a95812d3e0 /upgradeprovisioning | |
| parent | 1bb9e4416a705db1093ee1d43c83ce49005a17a2 (diff) | |
| download | acf-provisioning-fb5fccc38bf11e7abd71a55b49b2f2f0c9a8ecc9.tar.bz2 acf-provisioning-fb5fccc38bf11e7abd71a55b49b2f2f0c9a8ecc9.tar.xz | |
Add Algo parameter related with Speaker mode
Signed-off-by: Ted Trask <ttrask01@yahoo.com>
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 |