summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorVinícius de Jesus <viniciusdjesus@hotmail.com>2016-07-05 10:56:58 -0300
committerTed Trask <ttrask01@yahoo.com>2016-07-06 15:57:19 +0000
commitc1c41b75bcee250d50130a3665bb57ae6536bdc7 (patch)
tree9d113fa000c70b9139c9b79e5b6c39b79fd7bbab
parent8d84399705a808d4d22ad3df7f07a68ef3d7fb6c (diff)
downloadacf-provisioning-c1c41b75bcee250d50130a3665bb57ae6536bdc7.tar.bz2
acf-provisioning-c1c41b75bcee250d50130a3665bb57ae6536bdc7.tar.xz
New device for acf-provisioning: Cyberdata Paging Zone Controller
Signed-off-by: Ted Trask <ttrask01@yahoo.com>
-rw-r--r--config/templates/cyberdata-template.lua48
-rw-r--r--provisioning-scripts.lua152
-rwxr-xr-xupgradeprovisioning108
3 files changed, 280 insertions, 28 deletions
diff --git a/config/templates/cyberdata-template.lua b/config/templates/cyberdata-template.lua
index 607ccfc..f144af6 100644
--- a/config/templates/cyberdata-template.lua
+++ b/config/templates/cyberdata-template.lua
@@ -51,7 +51,7 @@ local function yesno(xmlobj, name, value)
elseif (value == true) then
value = "Yes"
end
- setValue(xmlobj, ''..name..'', ''..value..'')
+ setValue(xmlobj, name, value)
end
end
@@ -81,6 +81,14 @@ cfg = mergeXML(cfg, init_cfg)
-- <IPSettings>
+-- <ClockSettings>
+
+if values.device then
+ local clocksettings = findOrAppendSection(cfg, "ClockSettings")
+ setValue(clocksettings, "NTPServer", values.device.sntpserver)
+ setValue(clocksettings, "NTPTimezone", values.device.timezone)
+end
+
-- <SIPSettings>
if values.reg1 then
@@ -91,6 +99,7 @@ if values.reg1 then
setValue(sipsettings, "SIPUserID", values.reg1.extension)
setValue(sipsettings, "SIPAuthID", values.reg1.extension)
setValue(sipsettings, "SIPAuthPassword", values.reg1.password)
+ -- These parameters are used by CyberData Intercom
setValue(sipsettings, "DialoutExtension0", values.reg1.hotlinedestination)
setValue(sipsettings, "DialoutID0", values.reg1.callerid)
end
@@ -99,8 +108,10 @@ end
if values.device then
local DeviceSettings = findOrAppendSection(cfg, "DeviceSettings")
- setValue(DeviceSettings, "SpeakerVolume", values.device.cyberspeakervolume)
+ -- These parameters are used by CyberData Intercom and CyberData Paging Zone Controller
setValue(DeviceSettings, "AdminPassword", values.device.adminpassword)
+ -- These parameters are used by CyberData Intercom
+ setValue(DeviceSettings, "SpeakerVolume", values.device.cyberspeakervolume)
setValue(DeviceSettings, "RingVolume", values.device.cyberringvolume)
setValue(DeviceSettings, "MicGain", values.device.cybermicgain)
yesno (DeviceSettings, "ActivateRelayWithDTMF", values.device.activaterelaywithdtmf)
@@ -108,21 +119,40 @@ if values.device then
setValue(DeviceSettings, "DTMFActivationDuration", values.device.dtmfactivationduration)
yesno (DeviceSettings, "ActivateRelayDuringRing", values.device.activaterelayduringring)
yesno (DeviceSettings, "ActivateRelayDuringCall", values.device.activaterelayduringcall)
+ yesno (DeviceSettings, "AutoAnswerIncomingCalls", values.device.autoanswerincomingcalls)
+ -- These parameters are used by CyberData Paging Zone Controller
+ yesno (DeviceSettings, "BypassDTMF", values.device.bypassdtmf)
+ yesno (DeviceSettings, "BeepOnInitialization", values.device.beeponinitialization)
+ yesno (DeviceSettings, "BeepBeforePage", values.device.beepbeforepage)
end
--- <ButtonSettings>
+-- <ZoneSettings>
+-- These parameters are used by CyberData Paging Zone Controller
if values.device then
- local ButtonSettings = findOrAppendSection(cfg, "ButtonSettings")
- yesno (ButtonSettings, "PlayToneWhileRelayActive", values.device.playtonewhilerelayactive)
+ local ZoneSettings = findOrAppendSection(cfg, "ZoneSettings")
+ yesno(ZoneSettings, "BypassDTMF", values.device.bypassdtmf)
end
--- <ClockSettings>
+-- Loop through Parameter Groups looking for 'zone' params
+for pg, pg_t in pairs(values) do
+ -- Is it of the form zoneXX ?
+ local num = string.match(pg, 'zone(%d%d)')
+ if num then
+ local ZoneSettings = findOrAppendSection(cfg, "ZoneSettings")
+ yesno(ZoneSettings, 'Zone'..num..'Port1', pg_t.pagingport1)
+ yesno(ZoneSettings, 'Zone'..num..'Port2', pg_t.pagingport2)
+ yesno(ZoneSettings, 'Zone'..num..'Port3', pg_t.pagingport3)
+ yesno(ZoneSettings, 'Zone'..num..'Port4', pg_t.pagingport4)
+ end
+end
+
+-- <ButtonSettings>
+-- These parameters are used by CyberData Intercom
if values.device then
- local clocksettings = findOrAppendSection(cfg, "ClockSettings")
- setValue(clocksettings, "NTPServer", values.device.sntpserver)
- setValue(clocksettings, "NTPTimezone", values.device.timezone)
+ local ButtonSettings = findOrAppendSection(cfg, "ButtonSettings")
+ yesno (ButtonSettings, "PlayToneWhileRelayActive", values.device.playtonewhilerelayactive)
end
-- cfg:save("TEST-cyberdata.xml")
diff --git a/provisioning-scripts.lua b/provisioning-scripts.lua
index 998a8e7..680e8b6 100644
--- a/provisioning-scripts.lua
+++ b/provisioning-scripts.lua
@@ -60,6 +60,7 @@ mymodule.provisioning_classes = {
"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Grandstream HT702', '453')",
"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Grandstream HT704', '454')",
"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'), 'CyberData Paging Zone Controller', '501')",
"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Algo 8180 SIP Audio Alerter', '600')",
"INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Unsupported Phone', '999')",
-- services
@@ -314,7 +315,7 @@ mymodule.classes_to_param_groups = {
"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='CyberData Intercom'), (SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom 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'))",
@@ -329,6 +330,23 @@ mymodule.classes_to_param_groups = {
"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Grandstream HT704'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 4 (Grandstream)'))",
"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Grandstream HT704'), (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)'))",
+ "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData Paging Zone Controller)'))",
+ "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'))",
+ "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'))",
+ "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'))",
+ "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'))",
+ "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'))",
+ "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'))",
+ "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'))",
+ "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'))",
+ "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'))",
+ "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'))",
+ "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'))",
+ "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'))",
+ "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'))",
+ "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'))",
+ "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'))",
+ "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'))",
-- 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'))",
"INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Residential Phone'), (SELECT group_id FROM provisioning_groups WHERE label='Residential Phone'))",
@@ -345,8 +363,9 @@ mymodule.provisioning_groups = {
"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', 'CyberData Intercom Device', '1')",
"INSERT INTO provisioning_groups VALUES(default, 'device', 'Grandstream Device', '1')",
+ "INSERT INTO provisioning_groups VALUES(default, 'device', 'CyberData Paging Zone Controller 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')",
@@ -354,6 +373,7 @@ mymodule.provisioning_groups = {
"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 (CyberData Paging Zone Controller)', '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')",
@@ -409,6 +429,21 @@ mymodule.provisioning_groups = {
"INSERT INTO provisioning_groups VALUES(default, 'reg32', 'Registration 32 (Polycom)', '13')",
"INSERT INTO provisioning_groups VALUES(default, 'reg33', 'Registration 33 (Polycom)', '13')",
"INSERT INTO provisioning_groups VALUES(default, 'reg34', 'Registration 34 (Polycom)', '13')",
+ "INSERT INTO provisioning_groups VALUES(default, 'zone00', 'Zone 00 (CyberData Paging Zone Controller)', '14')",
+ "INSERT INTO provisioning_groups VALUES(default, 'zone01', 'Zone 01 (CyberData Paging Zone Controller)', '14')",
+ "INSERT INTO provisioning_groups VALUES(default, 'zone02', 'Zone 02 (CyberData Paging Zone Controller)', '14')",
+ "INSERT INTO provisioning_groups VALUES(default, 'zone03', 'Zone 03 (CyberData Paging Zone Controller)', '14')",
+ "INSERT INTO provisioning_groups VALUES(default, 'zone04', 'Zone 04 (CyberData Paging Zone Controller)', '14')",
+ "INSERT INTO provisioning_groups VALUES(default, 'zone05', 'Zone 05 (CyberData Paging Zone Controller)', '14')",
+ "INSERT INTO provisioning_groups VALUES(default, 'zone06', 'Zone 06 (CyberData Paging Zone Controller)', '14')",
+ "INSERT INTO provisioning_groups VALUES(default, 'zone07', 'Zone 07 (CyberData Paging Zone Controller)', '14')",
+ "INSERT INTO provisioning_groups VALUES(default, 'zone08', 'Zone 08 (CyberData Paging Zone Controller)', '14')",
+ "INSERT INTO provisioning_groups VALUES(default, 'zone09', 'Zone 09 (CyberData Paging Zone Controller)', '14')",
+ "INSERT INTO provisioning_groups VALUES(default, 'zone10', 'Zone 10 (CyberData Paging Zone Controller)', '14')",
+ "INSERT INTO provisioning_groups VALUES(default, 'zone11', 'Zone 11 (CyberData Paging Zone Controller)', '14')",
+ "INSERT INTO provisioning_groups VALUES(default, 'zone12', 'Zone 12 (CyberData Paging Zone Controller)', '14')",
+ "INSERT INTO provisioning_groups VALUES(default, 'zone13', 'Zone 13 (CyberData Paging Zone Controller)', '14')",
+ "INSERT INTO provisioning_groups VALUES(default, 'zone14', 'Zone 14 (CyberData Paging Zone Controller)', '14')",
-- services
"INSERT INTO provisioning_groups VALUES(default, 'services', 'Office Phone', '21')",
"INSERT INTO provisioning_groups VALUES(default, 'services', 'Residential Phone', '31')",
@@ -479,27 +514,37 @@ mymodule.param_groups_to_params = {
"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='algoringvol'), 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='algopagevol'), 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='algospkmode'), 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='template'), '/etc/provisioning/templates/cyberdata-template.lua', 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='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='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='cyberspeakervolume'), 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='adminpassword'), 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='cyberringvolume'), 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='cybermicgain'), 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='activaterelaywithdtmf'), 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='dtmfactivationcode'), 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='dtmfactivationduration'), 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='playtonewhilerelayactive'), 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='activaterelayduringring'), 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='activaterelayduringcall'), null, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='template'), '/etc/provisioning/templates/cyberdata-template.lua', false)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom 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 Intercom 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 Intercom 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 Intercom 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='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='cyberspeakervolume'), null, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='adminpassword'), null, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='cyberringvolume'), null, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='cybermicgain'), null, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='activaterelaywithdtmf'), null, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='dtmfactivationcode'), null, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='dtmfactivationduration'), null, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='playtonewhilerelayactive'), null, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='activaterelayduringring'), null, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='activaterelayduringcall'), null, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='autoanswerincomingcalls'), 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='template'), '/etc/provisioning/templates/grandstream-template.lua', 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='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)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller 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 Paging Zone Controller 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 Paging Zone Controller 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='CyberData Paging Zone Controller 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 Paging Zone Controller 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 Paging Zone Controller 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 Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='bypassdtmf'), null, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='beeponinitialization'), null, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='beepbeforepage'), null, true)",
-- 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)",
@@ -544,6 +589,9 @@ mymodule.param_groups_to_params = {
"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 (CyberData Paging Zone Controller)'), (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 Paging Zone Controller)'), (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 Paging Zone Controller)'), (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='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)",
@@ -1092,6 +1140,66 @@ mymodule.param_groups_to_params = {
"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Hotline'), (SELECT param_id FROM provisioning_params WHERE name='softkey8'), 'false', false)",
"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Hotline'), (SELECT param_id FROM provisioning_params WHERE name='softkey9'), 'false', false)",
"INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Hotline'), (SELECT param_id FROM provisioning_params WHERE name='softkey10'), 'false', false)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)",
+ "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)",
}
-- List of each parameter used in any way for any device - mostly for how to display
@@ -1125,6 +1233,14 @@ mymodule.provisioning_params = {
"INSERT INTO provisioning_params values(default, 'playtonewhilerelayactive', 'boolean', 'Relay Activation Tone Enable', '', 'true', '25', '', null)",
"INSERT INTO provisioning_params values(default, 'activaterelayduringring', 'boolean', 'Activate Relay During Ring Enable', '', 'false', '26', '', null)",
"INSERT INTO provisioning_params values(default, 'activaterelayduringcall', 'boolean', 'Activate Relay While Call Active Enable', '', 'false', '27', '', null)",
+ "INSERT INTO provisioning_params values(default, 'bypassdtmf', 'boolean', 'Bypass SIP DTMF Entry', 'Bypassing DTMF will result in all SIP calls being played to Zone 0', 'false', '28', '', null)",
+ "INSERT INTO provisioning_params values(default, 'beeponinitialization', 'boolean', 'Beep On Initialization', '', 'true', '29', '', null)",
+ "INSERT INTO provisioning_params values(default, 'beepbeforepage', 'boolean', 'Beep on page', '', 'true', '30', '', null)",
+ "INSERT INTO provisioning_params values(default, 'pagingport1', 'boolean', 'Paging Port 1 Enable', '', 'true', '31', '', null)",
+ "INSERT INTO provisioning_params values(default, 'pagingport2', 'boolean', 'Paging Port 2 Enable', '', 'true', '32', '', null)",
+ "INSERT INTO provisioning_params values(default, 'pagingport3', 'boolean', 'Paging Port 3 Enable', '', 'true', '33', '', null)",
+ "INSERT INTO provisioning_params values(default, 'pagingport4', 'boolean', 'Paging Port 4 Enable', '', 'true', '34', '', null)",
+ "INSERT INTO provisioning_params values(default, 'autoanswerincomingcalls', 'boolean', 'Auto Answer Incoming Calls Enable', '', 'true', '35', '', null)",
"INSERT INTO provisioning_params VALUES(default, 'extension', 'text', 'Extension', '', '', '101', '^%d*$', null)",
"INSERT INTO provisioning_params VALUES(default, 'password', 'text', 'Password', '', '', '102', '', null)",
"INSERT INTO provisioning_params VALUES(default, 'forwardnoanswerenable', 'boolean', 'Forward on No-answer Enable', '', 'false', '103', '', null)",
@@ -1157,7 +1273,7 @@ mymodule.provisioning_params = {
"INSERT INTO provisioning_params VALUES(default, 'softkey8', 'boolean', 'Soft Key 8 Enable', '', 'false', '308', '', null)",
"INSERT INTO provisioning_params VALUES(default, 'softkey9', 'boolean', 'Soft Key 9 Enable', '', 'false', '309', '', null)",
"INSERT INTO provisioning_params VALUES(default, 'softkey10', 'boolean', 'Soft Key 10 Enable', '', 'false', '310', '', null)",
- "INSERT INTO provisioning_params VALUES(default, 'databaseversion', 'text', 'Provisioning Database Version', 'Do not edit or delete!', '9', '999', '', null)",
+ "INSERT INTO provisioning_params VALUES(default, 'databaseversion', 'text', 'Provisioning Database Version', 'Do not edit or delete!', '10', '999', '', null)",
}
-- All of the (non-default) parameter values for all devices are stored here
diff --git a/upgradeprovisioning b/upgradeprovisioning
index 84fb954..3d41489 100755
--- a/upgradeprovisioning
+++ b/upgradeprovisioning
@@ -481,7 +481,7 @@ if [ "$version" -lt "5" ]; then
psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Algo 8180 Device'), (SELECT param_id FROM provisioning_params WHERE name='sntpserver'), null, false)" provisioning
psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Algo 8180 Device'), (SELECT param_id FROM provisioning_params WHERE name='adminpassword'), null, false)" provisioning
psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='template'), 'Algo 8180', '/etc/provisioning/templates/algo8180-template.lua', '5')" provisioning
-
+
# database
psql -U postgres -c "UPDATE provisioning_params SET value='5' WHERE name='databaseversion'" provisioning
fi
@@ -604,4 +604,110 @@ if [ "$version" -lt "9" ]; then
# database
psql -U postgres -c "UPDATE provisioning_params SET value='9' WHERE name='databaseversion'" provisioning
fi
+
+if [ "$version" -lt "10" ]; then
+ echo "Upgrading to database version 10"
+
+ psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'CyberData Paging Zone Controller', '501')" provisioning
+ psql -U postgres -c "INSERT INTO provisioning_groups VALUES(default, 'device', 'CyberData Paging Zone Controller Device', '1')" provisioning
+ psql -U postgres -c "INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (CyberData Paging Zone Controller)', '10')" provisioning
+ psql -U postgres -c "UPDATE provisioning_groups SET label = 'CyberData Intercom Device' where label = 'CyberData Device'" provisioning
+ psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData Paging Zone Controller)'))" provisioning
+ psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'))" provisioning
+ psql -U postgres -c "INSERT INTO provisioning_params values(default, 'bypassdtmf', 'boolean', 'Bypass SIP DTMF Entry', 'Bypassing DTMF will result in all SIP calls being played to Zone 0', 'false', '28', '', null)" provisioning
+ psql -U postgres -c "INSERT INTO provisioning_params values(default, 'beeponinitialization', 'boolean', 'Beep On Initialization', '', 'true', '29', '', null)" provisioning
+ psql -U postgres -c "INSERT INTO provisioning_params values(default, 'beepbeforepage', 'boolean', 'Beep on page', '', 'true', '30', '', null)" provisioning
+ psql -U postgres -c "INSERT INTO provisioning_params values(default, 'autoanswerincomingcalls', 'boolean', 'Auto Answer Incoming Calls Enable', '', 'true', '35', '', null)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='registrar'), null, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='sntpserver'), null, false)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='timezone'), null, false)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='mac'), null, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='adminpassword'), null, false)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='template'), '/etc/provisioning/templates/cyberdata-template.lua', 'f')" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='bypassdtmf'), null, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='beeponinitialization'), null, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='beepbeforepage'), null, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='callerid'), null, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='autoanswerincomingcalls'), null, true)" provisioning
+
+ for a in $(seq 1 4); do
+ psql -U postgres -c "INSERT INTO provisioning_params values(default, 'pagingport$a', 'boolean', 'Paging Port $a Enable', '', 'true', '3$a', '', null)" provisioning
+ done
+
+ for a in $(seq 0 9); do
+ psql -U postgres -c "INSERT INTO provisioning_groups VALUES(default, 'zone0$a', 'Zone 0$a (CyberData Paging Zone Controller)', '14')" provisioning
+ psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 0$a (CyberData Paging Zone Controller)'))" provisioning
+ done
+
+ for a in $(seq 0 4); do
+ psql -U postgres -c "INSERT INTO provisioning_groups VALUES(default, 'zone1$a', 'Zone 1$a (CyberData Paging Zone Controller)', '14')" provisioning
+ psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 1$a (CyberData Paging Zone Controller)'))" provisioning
+ done
+
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)" provisioning
+ psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)" provisioning
+
+ # database
+ psql -U postgres -c "UPDATE provisioning_params SET value='10' WHERE name='databaseversion'" provisioning
+fi
exit 0