From e1233e3a30a4942f0290e33ff332dac32c3a75d8 Mon Sep 17 00:00:00 2001 From: Joao Arruda Date: Mon, 16 Nov 2015 14:19:18 -0200 Subject: Add Algo parameter related with ring tone and volume Signed-off-by: Ted Trask --- config/templates/algo8180-template.lua | 8 +++++ provisioning-scripts.lua | 57 +++++++++++++++++++++++++++++++++- upgradeprovisioning | 50 +++++++++++++++++++++++++++++ 3 files changed, 114 insertions(+), 1 deletion(-) diff --git a/config/templates/algo8180-template.lua b/config/templates/algo8180-template.lua index a9c811d..1c6a02f 100644 --- a/config/templates/algo8180-template.lua +++ b/config/templates/algo8180-template.lua @@ -38,6 +38,8 @@ end set_elem("admin.pwd", values.device.adminpassword) set_elem("net.time", values.device.sntpserver) set_elem("sip.proxy", values.device.registrar) +set_elem("audio.ring.vol", values.device.algoringvol) +set_elem("audio.page.vol", values.device.algopagevol) for pg, pg_t in pairs(values) do -- Is it of the form regX ? local num = string.match(pg, 'reg(%d+)') @@ -46,12 +48,18 @@ for pg, pg_t in pairs(values) do set_elem("sip.alert"..num..".auth", pg_t.extension) set_elem("sip.alert"..num..".pwd", pg_t.password) set_elem("sip.alert"..num..".user", pg_t.extension) + if tostring(num) == "1" then + set_elem("audio.ring.tone", pg_t.algoringtone) + else + set_elem("audio.ring.tone"..num.."", pg_t.algoringtone) + end end elseif num == "6" then if pg_t.extension ~= "" then set_elem("sip.u1.auth", pg_t.extension) set_elem("sip.u1.pwd", pg_t.password) set_elem("sip.u1.user", pg_t.extension) + set_elem("audio.page.tone", pg_t.algopagetone) end end end 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 diff --git a/upgradeprovisioning b/upgradeprovisioning index e1ea28c..7cd301e 100755 --- a/upgradeprovisioning +++ b/upgradeprovisioning @@ -486,4 +486,54 @@ if [ "$version" -lt "5" ]; then psql -U postgres -c "UPDATE provisioning_params SET value='5' WHERE name='databaseversion'" provisioning fi +if [ "$version" -lt "6" ]; then + echo "Upgrading to database version 6" + + psql -U postgres -c "INSERT INTO provisioning_params VALUES(default, 'algoringtone', 'select', 'Ring Tone (Algo)', '', 'warble2-med.wav', '110', '', null)" provisioning + psql -U postgres -c "INSERT INTO provisioning_params VALUES(default, 'algopagetone', 'select', 'Page Tone (Algo)', '', 'warble2-med.wav', '110', '', null)" provisioning + psql -U postgres -c "INSERT INTO provisioning_params VALUES(default, 'algoringvol', 'select', 'Ring Volume (Algo)', '', '5', '16', '', null)" provisioning + psql -U postgres -c "INSERT INTO provisioning_params VALUES(default, 'algopagevol', 'select', 'Page Volume (Algo)', '', '5', '17', '', null)" 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='algoringvol'), '5', true)" 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='algopagevol'), '5', true)" provisioning + + for a in $(seq 1 5); do + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Ring Extension $a (Algo)'), (SELECT param_id FROM provisioning_params WHERE name='algoringtone'), null, true)" provisioning + done + psql -U postgres -c "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)" provisioning + + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Bell NA', 'bell-na.wav', '1')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Bell UK', 'bell-uk.wav', '2')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Buzzer', 'buzzer.wav', '3')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Chime', 'chime.wav', '4')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Dogs', 'dogs.wav', '5')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Gong', 'gong.wav', '6')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Page Notify', 'page-notif.wav', '7')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Warble Low', 'warble1-low.wav', '8')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Warble Med', 'warble2-med.wav', '9')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Warble High', 'warble3-high.wav', '10')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringtone'), 'Warble Trill', 'warble4-trill.wav', '11')" provisioning + + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'None', 'None', '1')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Bell NA', 'bell-na.wav', '2')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Bell UK', 'bell-uk.wav', '3')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Buzzer', 'buzzer.wav', '4')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Chime', 'chime.wav', '5')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Dogs', 'dogs.wav', '6')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Gong', 'gong.wav', '7')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Page Notify', 'page-notif.wav', '8')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Warble Low', 'warble1-low.wav', '9')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Warble Med', 'warble2-med.wav', '10')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Warble High', 'warble3-high.wav', '11')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagetone'), 'Warble Trill', 'warble4-trill.wav', '12')" provisioning + + for a in $(seq 1 10); do + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algoringvol'), '$a', '$a', '$a')" provisioning + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algopagevol'), '$a', '$a', '$a')" provisioning + done + + # database + psql -U postgres -c "UPDATE provisioning_params SET value='6' WHERE name='databaseversion'" provisioning +fi + exit 0 -- cgit v1.2.3