diff options
Diffstat (limited to 'upgradeprovisioning')
| -rwxr-xr-x | upgradeprovisioning | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/upgradeprovisioning b/upgradeprovisioning index 3d41489..9d69d96 100755 --- a/upgradeprovisioning +++ b/upgradeprovisioning @@ -710,4 +710,32 @@ if [ "$version" -lt "10" ]; then # database psql -U postgres -c "UPDATE provisioning_params SET value='10' WHERE name='databaseversion'" provisioning fi + +if [ "$version" -lt "11" ]; then + echo "Upgrading to database version 11" + + psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensornormallyclosed', 'boolean', 'Door Sensor Normally Closed Enable', '', 'false', '36', '', null)" provisioning + psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensortimeout', 'text', 'Door Sensor Open Timeout', 'Value in seconds', '0', '37', '^%d*\$', E'local value, functions, params = ...\nif value == \'\' then\n return value, \'Empty not accepted\'\nend\nlocal value = tonumber(value)\nif value == nil then\n return value, \'Only numbers are allowed\'\nend\nif value >= 99999 then\n return value, \'Maximum 99999\'\nend\nreturn value')" provisioning + psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensorflashled', 'boolean', 'Door Sensor Flash Button LED Enable', '', 'false', '38', '', null)" provisioning + psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensoractivaterelay', 'boolean', 'Door Sensor Activate Relay Enable', '', 'false', '39', '', null)" provisioning + psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensorplaylocally', 'boolean', 'Door Sensor Play Audio Locally Enable', '', 'false', '40', '', null)" provisioning + psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensorcall', 'boolean', 'Door Sensor Call to Extension Enable', '', 'false', '41', '', null)" provisioning + psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensordialoutextension', 'text', 'Door Sensor Dial Out Extension', '', '', '42', '^[*#0-9]*\$', E'local value, functions, params = ...\nif value ~= \'\' then\nlocal len = string.len(value)\n if len >= 65 then\n return value, \'Maximum 64 digits\'\n end\nend\nreturn value')" provisioning + psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensordialoutid', 'text', 'Door Sensor Dial Out ID', '', '', '43', '', E'local value, functions, params = ...\nif value ~= \'\' then\nlocal len = string.len(value)\n if len >= 65 then\n return value, \'Maximum 64 characters\'\n end\nend\nreturn value')" provisioning + psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensorrepeat', 'text', 'Door Sensor Repeat Message', '', '1', '44', '', E'local value, functions, params = ...\nif value == \'\' then\n return value, \'Empty not accepted\'\nend\nlocal value = tonumber(value)\nif value == nil then\n return value, \'Only numbers are allowed\'\nend\nif value >= 65537 then\n return value, \'Maximum 65536\'\nend\nreturn value')" provisioning + psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensorplayremotely', 'boolean', 'Door Sensor Play Audio Enable', '', 'false', '45', '', null)" 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='sensornormallyclosed'), 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='sensortimeout'), 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='sensorflashled'), 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='sensoractivaterelay'), 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='sensorplaylocally'), 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='sensorcall'), 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='sensordialoutextension'), 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='sensordialoutid'), 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='sensorrepeat'), 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='sensorplayremotely'), null, true)" provisioning + + # database + psql -U postgres -c "UPDATE provisioning_params SET value='11' WHERE name='databaseversion'" provisioning +fi exit 0 |