From 7504992fb58832b07d453be2003224f1033d547b Mon Sep 17 00:00:00 2001 From: Alan Lacerda Date: Tue, 12 May 2015 12:26:56 +0000 Subject: adding support to VVX 300/310/400/410/500/600 Signed-off-by: Ted Trask --- upgradeprovisioning | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) (limited to 'upgradeprovisioning') diff --git a/upgradeprovisioning b/upgradeprovisioning index d37c257..df1e2cf 100755 --- a/upgradeprovisioning +++ b/upgradeprovisioning @@ -276,4 +276,22 @@ psql -U postgres -c "UPDATE provisioning_params SET value='2' WHERE name='databa fi +if [ "$version" -lt "3" ]; then + echo "Upgrading to database version 3" + + psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 300/310/400/410/500/600', '7')" provisioning + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))" provisioning + + for a in $(seq 1 34); do + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration $a (Polycom)'))" provisioning + done + + psql -U postgres -c "UPDATE provisioning_classes SET seq='100' WHERE label='Linksys Internet Phone Adapter PAP2T'" provisioning + psql -U postgres -c "UPDATE provisioning_classes SET seq='200' WHERE label='Cisco 2 Port Phone Adapter SPA112'" provisioning + psql -U postgres -c "UPDATE provisioning_classes SET seq='300' WHERE label='Snom 300'" provisioning + psql -U postgres -c "UPDATE provisioning_classes SET seq='301' WHERE label='Snom 320/360/370'" provisioning + + psql -U postgres -c "UPDATE provisioning_params SET value='3' WHERE name='databaseversion'" provisioning +fi + exit 0 -- cgit v1.2.3