diff options
| author | Ted Trask <ttrask01@yahoo.com> | 2017-01-01 03:27:22 +0000 |
|---|---|---|
| committer | Ted Trask <ttrask01@yahoo.com> | 2017-01-01 03:51:37 +0000 |
| commit | 53adfb04ee62022952c2b36e725e8a75216058b2 (patch) | |
| tree | ee33542ef37033d5ae4f6d06c829d4ca8e908f5c | |
| parent | 6e2cf4da8bee8dbc180c6011ecf98b70a215bf71 (diff) | |
| download | acf-provisioning-53adfb04ee62022952c2b36e725e8a75216058b2.tar.bz2 acf-provisioning-53adfb04ee62022952c2b36e725e8a75216058b2.tar.xz | |
Add support for Polycom VVX 101,201,301,311,401,411,501,601
Added in Polycom UC Software 5.4.0
| -rw-r--r-- | provisioning-scripts.lua | 295 | ||||
| -rwxr-xr-x | upgradeprovisioning | 11 |
2 files changed, 162 insertions, 144 deletions
diff --git a/provisioning-scripts.lua b/provisioning-scripts.lua index 169cca1..87ca88f 100644 --- a/provisioning-scripts.lua +++ b/provisioning-scripts.lua @@ -46,10 +46,12 @@ 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'), 'Polycom VVX 300/310', '7')", - "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 400/410', '8')", - "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 500', '9')", - "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 600', '10')", + "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 101', '7')", + "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 201', '8')", + "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 300/301/310/311', '9')", + "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 400/401/410/411', '10')", + "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 500/501', '11')", + "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 600/601', '12')", "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')", @@ -137,146 +139,151 @@ 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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 400/410'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 500'), (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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 101'), (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 101'), (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 201'), (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 201'), (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 201'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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/301/310/311'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 400/401/410/411'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 500/501'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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 600/601'), (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)'))", diff --git a/upgradeprovisioning b/upgradeprovisioning index 79c7d15..2aee3ce 100755 --- a/upgradeprovisioning +++ b/upgradeprovisioning @@ -746,6 +746,17 @@ if [ "$version" -lt "12" ]; then psql -U postgres -c "UPDATE provisioning_options SET label='French (France)' WHERE param_id=(SELECT param_id FROM provisioning_params WHERE name='displaylang') AND value='French_France'" provisioning psql -U postgres -c "INSERT INTO provisioning_params VALUES(default, 'clockenable', 'boolean', 'Clock Enable', '', 'true', '14', '', null)" provisioning psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'), (SELECT param_id FROM provisioning_params WHERE name='clockenable'), null, false)" provisioning + psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 101', '7')" provisioning + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 101'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Polycom)'))" provisioning + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 101'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))" provisioning + psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 201', '8')" provisioning + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 201'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Polycom)'))" provisioning + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 201'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Polycom)'))" provisioning + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 201'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))" provisioning + psql -U postgres -c "UPDATE provisioning_classes SET (label,seq)=('Polycom VVX 300/301/310/311', '9') WHERE label='Polycom VVX 300/310'" provisioning + psql -U postgres -c "UPDATE provisioning_classes SET (label,seq)=('Polycom VVX 400/401/410/411', '10') WHERE label='Polycom VVX 400/410'" provisioning + psql -U postgres -c "UPDATE provisioning_classes SET (label,seq)=('Polycom VVX 500/501', '11') WHERE label='Polycom VVX 500'" provisioning + psql -U postgres -c "UPDATE provisioning_classes SET (label,seq)=('Polycom VVX 600/601', '12') WHERE label='Polycom VVX 600'" provisioning # database psql -U postgres -c "UPDATE provisioning_params SET value='12' WHERE name='databaseversion'" provisioning |