new devices for acf-provisioning: algo, cyberdata, grandstream

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

1 files changed, 72 insertions, 0 deletions

diff --git a/provisioning-scripts.lua b/provisioning-scripts.lua
index 2e3807e..89fe9ae 100644
--- a/provisioning-scripts.lua
+++ b/provisioning-scripts.lua
@@ -54,6 +54,10 @@ mymodule.provisioning_classes = {
 	"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'), 'Algo 8180 SIP Audio Alerter', '400')";,
+	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'CyberData Intercom', '500')";,
+	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Grandstream HT-502', '600')";,
+	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Grandstream HT701', '601')";,
 	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Unsupported Phone', '999')",
 	-- services
 	"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='services'), 'Office Phone', '1')",
@@ -299,6 +303,20 @@ mymodule.classes_to_param_groups = {
 	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Snom 320/360/370'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 11 (Snom)'))",
 	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Snom 320/360/370'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 12 (Snom)'))",
 	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Snom 320/360/370'), (SELECT group_id FROM provisioning_groups WHERE label='Snom Device'))",
+	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Algo 8180 SIP Audio Alerter'), (SELECT group_id FROM provisioning_groups WHERE label='Ring Extension 1 (Algo)'))",
+	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Algo 8180 SIP Audio Alerter'), (SELECT group_id FROM provisioning_groups WHERE label='Ring Extension 2 (Algo)'))",
+	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Algo 8180 SIP Audio Alerter'), (SELECT group_id FROM provisioning_groups WHERE label='Ring Extension 3 (Algo)'))",
+	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Algo 8180 SIP Audio Alerter'), (SELECT group_id FROM provisioning_groups WHERE label='Ring Extension 4 (Algo)'))",
+	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Algo 8180 SIP Audio Alerter'), (SELECT group_id FROM provisioning_groups WHERE label='Ring Extension 5 (Algo)'))",
+	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Algo 8180 SIP Audio Alerter'), (SELECT group_id FROM provisioning_groups WHERE label='Page Extension (Algo)'))",
+	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Algo 8180 SIP Audio Alerter'), (SELECT group_id FROM provisioning_groups WHERE label='Algo 8180 Device'))",
+	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Intercom'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData)'))",
+	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Intercom'), (SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'))",
+	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Grandstream HT-502'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Grandstream)'))",
+	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Grandstream HT-502'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Grandstream)'))",
+	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Grandstream HT-502'), (SELECT group_id FROM provisioning_groups WHERE label='Grandstream Device'))",
+	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Grandstream HT701'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Grandstream)'))",
+	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Grandstream HT701'), (SELECT group_id FROM provisioning_groups WHERE label='Grandstream Device'))",
 	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Unsupported Phone'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Unsupported)'))",
 	-- Services
 	"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Office Phone'), (SELECT group_id FROM provisioning_groups WHERE label='Office Phone'))",
@@ -315,23 +333,35 @@ mymodule.provisioning_groups = {
 	"INSERT INTO provisioning_groups VALUES(default, 'device', 'Cisco ATA Device', '1')",
 	"INSERT INTO provisioning_groups VALUES(default, 'device', 'Polycom Device', '1')",
 	"INSERT INTO provisioning_groups VALUES(default, 'device', 'Snom Device', '1')",
+	"INSERT INTO provisioning_groups VALUES(default, 'device', 'Algo 8180 Device', '1')",
+	"INSERT INTO provisioning_groups VALUES(default, 'device', 'CyberData Device', '1')",
+	"INSERT INTO provisioning_groups VALUES(default, 'device', 'Grandstream Device', '1')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (Polycom)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (Linksys)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (Cisco)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (Unsupported)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (Snom)', '10')",
+	"INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Ring Extension 1 (Algo)', '10')",
+	"INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (CyberData)', '10')",
+	"INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (Grandstream)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg2', 'Registration 2 (Polycom)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg2', 'Registration 2 (Linksys)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg2', 'Registration 2 (Cisco)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg2', 'Registration 2 (Snom)', '10')",
+	"INSERT INTO provisioning_groups VALUES(default, 'reg2', 'Ring Extension 2 (Algo)', '10')",
+	"INSERT INTO provisioning_groups VALUES(default, 'reg2', 'Registration 2 (Grandstream)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg3', 'Registration 3 (Polycom)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg3', 'Registration 3 (Snom)', '10')",
+	"INSERT INTO provisioning_groups VALUES(default, 'reg3', 'Ring Extension 3 (Algo)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg4', 'Registration 4 (Polycom)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg4', 'Registration 4 (Snom)', '10')",
+	"INSERT INTO provisioning_groups VALUES(default, 'reg4', 'Ring Extension 4 (Algo)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg5', 'Registration 5 (Polycom)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg5', 'Registration 5 (Snom)', '10')",
+	"INSERT INTO provisioning_groups VALUES(default, 'reg5', 'Ring Extension 5 (Algo)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg6', 'Registration 6 (Polycom)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg6', 'Registration 6 (Snom)', '10')",
+	"INSERT INTO provisioning_groups VALUES(default, 'reg6', 'Page Extension (Algo)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg7', 'Registration 7 (Polycom)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg7', 'Registration 7 (Snom)', '10')",
 	"INSERT INTO provisioning_groups VALUES(default, 'reg8', 'Registration 8 (Polycom)', '10')",
@@ -428,6 +458,22 @@ mymodule.param_groups_to_params = {
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Snom Device'), (SELECT param_id FROM provisioning_params WHERE name='forwardbusyenable'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Snom Device'), (SELECT param_id FROM provisioning_params WHERE name='forwardall'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Snom Device'), (SELECT param_id FROM provisioning_params WHERE name='forwardallenable'), null, true)",
+	"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='template'), '/etc/provisioning/templates/algo8180-template.lua', 'f')"
+	"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='mac'), null, true)"
+	"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='registrar'), null, false)"
+	"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='sntpserver'), null, false)"
+	"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='adminpassword'), null, false)"
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='template'), '/etc/provisioning/templates/cyberdata-template.lua', 'f')"
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='mac'), null, true)"
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='registrar'), null, true)"
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='sntpserver'), null, false)"
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='timezone'), null, false)"
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Grandstream Device'), (SELECT param_id FROM provisioning_params WHERE name='template'), '/etc/provisioning/templates/grandstream-template.lua', 'f')"
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Grandstream Device'), (SELECT param_id FROM provisioning_params WHERE name='mac'), null, true)"
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Grandstream Device'), (SELECT param_id FROM provisioning_params WHERE name='registrar'), null, false)"
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Grandstream Device'), (SELECT param_id FROM provisioning_params WHERE name='sntpserver'), null, false)"
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Grandstream Device'), (SELECT param_id FROM provisioning_params WHERE name='timezone'), null, false)"
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Grandstream Device'), (SELECT param_id FROM provisioning_params WHERE name='adminpassword'), null, false)"
 	-- Registrations
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Unsupported)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Unsupported)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, true)",
@@ -464,6 +510,16 @@ mymodule.param_groups_to_params = {
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='callerid'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Ring Extension 1 (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Ring Extension 1 (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData)'), (SELECT param_id FROM provisioning_params WHERE name='callerid'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData)'), (SELECT param_id FROM provisioning_params WHERE name='hotlineenable'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData)'), (SELECT param_id FROM provisioning_params WHERE name='hotlinedestination'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Grandstream)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Grandstream)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Grandstream)'), (SELECT param_id FROM provisioning_params WHERE name='callerid'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='forwardnoanswer'), null, true)",
@@ -497,6 +553,11 @@ mymodule.param_groups_to_params = {
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='callerid'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Ring Extension 2 (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Ring Extension 2 (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Grandstream)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Grandstream)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Grandstream)'), (SELECT param_id FROM provisioning_params WHERE name='callerid'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 3 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 3 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 3 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='forwardnoanswer'), null, true)",
@@ -512,6 +573,8 @@ mymodule.param_groups_to_params = {
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 3 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 3 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 3 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='callerid'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Ring Extension 3 (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Ring Extension 3 (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 4 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 4 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 4 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='forwardnoanswer'), null, true)",
@@ -527,6 +590,8 @@ mymodule.param_groups_to_params = {
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 4 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 4 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 4 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='callerid'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Ring Extension 4 (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Ring Extension 4 (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 5 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 5 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 5 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='forwardnoanswer'), null, true)",
@@ -542,6 +607,8 @@ mymodule.param_groups_to_params = {
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 5 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 5 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 5 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='callerid'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Ring Extension 5 (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Ring Extension 5 (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 6 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 6 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 6 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='forwardnoanswer'), null, true)",
@@ -557,6 +624,8 @@ mymodule.param_groups_to_params = {
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 6 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 6 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 6 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='callerid'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Page Extension (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
+	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Page Extension (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 7 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 7 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)",
 	"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 7 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='forwardnoanswer'), null, true)",
@@ -1073,6 +1142,9 @@ mymodule.provisioning_options = {
 	"INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='template'), 'Linksys ATA', '/etc/provisioning/templates/linksysata-template.lua', '2')",
 	"INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='template'), 'Snom', '/etc/provisioning/templates/snom-template.lua', '3')",
 	"INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='template'), 'Cisco ATA', '/etc/provisioning/templates/ciscoata-template.lua', '4')",
+	"INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='template'), 'Algo 8180', '/etc/provisioning/templates/algo8180-template.lua', '5')",
+	"INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='template'), 'CyberData', '/etc/provisioning/templates/cyberdata-template.lua', '6')",
+	"INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='template'), 'Grandstream', '/etc/provisioning/templates/grandstream-template.lua', '7')",
 	"INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='polycomringtone'), 'Silent Ring', '1', '1')",
 	"INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='polycomringtone'), 'Low Trill', '2', '2')",
 	"INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='polycomringtone'), 'Low Double Trill', '3', '3')",