diff options
Diffstat (limited to 'provisioning-scripts.lua')
-rw-r--r-- | provisioning-scripts.lua | 57 |
1 files changed, 56 insertions, 1 deletions
diff --git a/provisioning-scripts.lua b/provisioning-scripts.lua index e6fd982..1126615 100644 --- a/provisioning-scripts.lua +++ b/provisioning-scripts.lua @@ -476,6 +476,8 @@ 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='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='Algo 8180 Device'), (SELECT param_id FROM provisioning_params WHERE name='algoringvol'), '5', 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'), '5', 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', '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)", @@ -525,6 +527,7 @@ 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='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='Ring Extension 1 (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 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)", @@ -568,6 +571,7 @@ 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='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='Ring Extension 2 (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 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)", @@ -588,6 +592,7 @@ 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='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='Ring Extension 3 (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 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 3 (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 3 (Grandstream)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, true)", @@ -608,6 +613,7 @@ 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='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='Ring Extension 4 (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='algoringtone'), null, true)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 4 (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 4 (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 4 (Grandstream)'), (SELECT param_id FROM provisioning_params WHERE name='callerid'), null, true)", @@ -628,6 +634,7 @@ 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='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='Ring Extension 5 (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 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)", @@ -645,6 +652,7 @@ 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='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='Page Extension (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 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)", @@ -1125,7 +1133,11 @@ 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!', '5', '999', '', null)" + "INSERT INTO provisioning_params VALUES(default, 'algoringtone', 'select', 'Ring Tone (Algo)', '', 'warble2-med.wav', '110', '', null)", + "INSERT INTO provisioning_params VALUES(default, 'algopagetone', 'select', 'Page Tone (Algo)', '', 'warble2-med.wav', '110', '', null)", + "INSERT INTO provisioning_params VALUES(default, 'algoringvol', 'select', 'Ring Volume (Algo)', '', '5', '16', '', null)", + "INSERT INTO provisioning_params VALUES(default, 'algopagevol', 'select', 'Page Volume (Algo)', '', '5', '17', '', null)", + "INSERT INTO provisioning_params VALUES(default, 'databaseversion', 'text', 'Provisioning Database Version', 'Do not edit or delete!', '6', '999', '', null)" } -- All of the (non-default) parameter values for all devices are stored here @@ -1222,6 +1234,49 @@ mymodule.provisioning_options = { "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='displaylang'), 'Spanish', 'Spanish_Spain', '18')", "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='displaylang'), 'Swedish', 'Swedish_Sweden', '19')", "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='displaylang'), 'Internal (US English)', '', '20')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Bell NA', 'bell-na.wav', '1')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Bell UK', 'bell-uk.wav', '2')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Buzzer', 'buzzer.wav', '3')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Chime', 'chime.wav', '4')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Dogs', 'dogs.wav', '5')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Gong', 'gong.wav', '6')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Page Notify', 'page-notif.wav', '7')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Warble Low', 'warble1-low.wav', '8')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Warble Med', 'warble2-med.wav', '9')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Warble High', 'warble3-high.wav', '10')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Warble Trill', 'warble4-trill.wav', '11')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'None', 'None', '1')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Bell NA', 'bell-na.wav', '2')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Bell UK', 'bell-uk.wav', '3')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Buzzer', 'buzzer.wav', '4')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Chime', 'chime.wav', '5')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Dogs', 'dogs.wav', '6')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Gong', 'gong.wav', '7')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Page Notify', 'page-notif.wav', '8')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Warble Low', 'warble1-low.wav', '9')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Warble Med', 'warble2-med.wav', '10')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Warble High', 'warble3-high.wav', '11')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Warble Trill', 'warble4-trill.wav', '12')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringvol'), '1', '1', '1')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringvol'), '2', '2', '2')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringvol'), '3', '3', '3')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringvol'), '4', '4', '4')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringvol'), '5', '5', '5')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringvol'), '6', '6', '6')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringvol'), '7', '7', '7')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringvol'), '8', '8', '8')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringvol'), '9', '9', '9')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringvol'), '10', '10', '10')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagevol'), '1', '1', '1')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagevol'), '2', '2', '2')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagevol'), '3', '3', '3')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagevol'), '4', '4', '4')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagevol'), '5', '5', '5')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagevol'), '6', '6', '6')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagevol'), '7', '7', '7')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagevol'), '8', '8', '8')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagevol'), '9', '9', '9')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagevol'), '10', '10', '10')", } -- List of getfile requests |