diff options
Diffstat (limited to 'upgradeprovisioning')
| -rwxr-xr-x | upgradeprovisioning | 108 |
1 files changed, 107 insertions, 1 deletions
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 |