adding support to VVX 300/310/400/410/500/600

Signed-off-by: Ted Trask <ttrask01@yahoo.com>

2 files changed, 59 insertions, 5 deletions

diff --git a/provisioning-scripts.lua b/provisioning-scripts.lua
index 2cc82e2..2048e15 100644
--- a/provisioning-scripts.lua
+++ b/provisioning-scripts.lua
@@ -46,10 +46,11 @@ mymodule.provisioning_classes = {
 	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom SoundPoint IP 650/670 SIP', '4')",
 	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom SoundStation IP 5000/6000/7000 SIP', '5')",
 	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 1500', '6')",
-	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Linksys Internet Phone Adapter PAP2T', '7')",
-	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Cisco 2 Port Phone Adapter SPA112', '8')",
-	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Snom 300', '10')",
-	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Snom 320/360/370', '11')",
+	"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')",
+	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Linksys Internet Phone Adapter PAP2T', '100')",
+	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Cisco 2 Port Phone Adapter SPA112', '200')",
+	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Snom 300', '300')",
+	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Snom 320/360/370', '301')",
 	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Unsupported Phone', '999')",
 	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='services'), 'Standard Phone', '1')",
 	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='services'), 'Public Phone', '2')",
@@ -123,6 +124,41 @@ mymodule.classes_to_param_groups = {
 	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom SoundPoint IP 650/670 SIP'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))",
 	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom SoundStation IP 5000/6000/7000 SIP'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Polycom)'))",
 	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom SoundStation IP 5000/6000/7000 SIP'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))",
+	"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 1 (Polycom)'))",
+	"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 2 (Polycom)'))",
+	"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 3 (Polycom)'))",
+	"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 4 (Polycom)'))",
+	"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 5 (Polycom)'))",
+	"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 6 (Polycom)'))",
+	"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 7 (Polycom)'))",
+	"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 8 (Polycom)'))",
+	"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 9 (Polycom)'))",
+	"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 10 (Polycom)'))",
+	"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 11 (Polycom)'))",
+	"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 12 (Polycom)'))",
+	"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 13 (Polycom)'))",
+	"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 14 (Polycom)'))",
+	"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 15 (Polycom)'))",
+	"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 16 (Polycom)'))",
+	"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 17 (Polycom)'))",
+	"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 18 (Polycom)'))",
+	"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 19 (Polycom)'))",
+	"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 20 (Polycom)'))",
+	"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 21 (Polycom)'))",
+	"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 22 (Polycom)'))",
+	"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 23 (Polycom)'))",
+	"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 24 (Polycom)'))",
+	"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 25 (Polycom)'))",
+	"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 26 (Polycom)'))",
+	"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 27 (Polycom)'))",
+	"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 28 (Polycom)'))",
+	"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 29 (Polycom)'))",
+	"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 30 (Polycom)'))",
+	"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 31 (Polycom)'))",
+	"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 32 (Polycom)'))",
+	"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 33 (Polycom)'))",
+	"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 34 (Polycom)'))",
+	"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'))",
 	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 1500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Polycom)'))",
 	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 1500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Polycom)'))",
 	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 1500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 3 (Polycom)'))",
@@ -748,7 +784,7 @@ mymodule.provisioning_params = {
 	"INSERT INTO provisioning_params VALUES(default, 'speeddialenable', 'boolean', 'Speed Dial Enable', '', 'true', '206', '', null)",
 	"INSERT INTO provisioning_params VALUES(default, 'mailbox', 'text', 'Voice Mailbox', 'Mailbox extension or URL', '', '207', '', null)",
 	"INSERT INTO provisioning_params VALUES(default, 'mailcallback', 'text', 'Voice Mailbox Callback', 'Extension or URL for mailbox message retrieval', '', '208', '', null)",
-	"INSERT INTO provisioning_params VALUES(default, 'databaseversion', 'text', 'Provisioning Database Version', 'Do not edit or delete!', '2', '999', '', null)"
+	"INSERT INTO provisioning_params VALUES(default, 'databaseversion', 'text', 'Provisioning Database Version', 'Do not edit or delete!', '3', '999', '', null)"
 }
 
 -- All of the (non-default) parameter values for all devices are stored here
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