diff options
| author | Ted Trask <ttrask01@yahoo.com> | 2011-02-28 13:21:03 +0000 |
|---|---|---|
| committer | Ted Trask <ttrask01@yahoo.com> | 2011-02-28 13:21:03 +0000 |
| commit | 10db00827279e3cc3d8a6c2f4c89db325ae62ef4 (patch) | |
| tree | d739222b56c2d42c5a58ae661fa1035f641bfb05 | |
| parent | ec3a8ef069def94b623279885dd9d3b64ef90818 (diff) | |
| download | acf-provisioning-10db00827279e3cc3d8a6c2f4c89db325ae62ef4.tar.bz2 acf-provisioning-10db00827279e3cc3d8a6c2f4c89db325ae62ef4.tar.xz | |
Added MAC address param to devices.
| -rwxr-xr-x | provisioning-scripts.lua | 21 |
1 files changed, 12 insertions, 9 deletions
diff --git a/provisioning-scripts.lua b/provisioning-scripts.lua index 5700b23..6f6f741 100755 --- a/provisioning-scripts.lua +++ b/provisioning-scripts.lua @@ -169,7 +169,9 @@ param_groups_to_params = { "CREATE UNIQUE INDEX g2p_group_param_idx ON param_groups_to_params (group_id, param_id)", -- Device "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Linksys ATA Device'), (SELECT param_id FROM provisioning_params WHERE name='template'), '/etc/provisioning/templates/linksysata-template.lua', false)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Linksys ATA Device'), (SELECT param_id FROM provisioning_params WHERE name='mac'), '', true)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'), (SELECT param_id FROM provisioning_params WHERE name='template'), '/etc/provisioning/templates/polycom-template.lua', false)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'), (SELECT param_id FROM provisioning_params WHERE name='mac'), '', true)", -- Registrations "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1'), (SELECT param_id FROM provisioning_params WHERE name='extension'), '', true)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1'), (SELECT param_id FROM provisioning_params WHERE name='password'), '', false)", @@ -357,15 +359,16 @@ param_groups_to_params = { provisioning_params = { "CREATE TABLE provisioning_params (param_id SERIAL PRIMARY KEY, name VARCHAR(255) UNIQUE, type VARCHAR(255), label VARCHAR(255), descr VARCHAR(255), value VARCHAR(255), seq INTEGER, regexp VARCHAR(255))", "CREATE INDEX params_name_idx ON provisioning_params (name)", - "INSERT INTO provisioning_params VALUES(default, 'template', 'select', 'Template', '', '', '0', '')", - "INSERT INTO provisioning_params VALUES(default, 'extension', 'text', 'Extension', '', '', '1', '^%d*$')", - "INSERT INTO provisioning_params VALUES(default, 'password', 'text', 'Password', '', '', '2', '')", - "INSERT INTO provisioning_params VALUES(default, 'forwardnoanswer', 'text', 'Forward on No-answer Destination', 'Callers will be transferred to this extension when you don''t answer after 20 seconds. Blank disables.', '', '3', '')", - "INSERT INTO provisioning_params VALUES(default, 'forwardbusy', 'text', 'Forward on Busy Destination', 'Callers will be transferred to this extension when the line is busy. Blank disables.', '', '4', '')", - "INSERT INTO provisioning_params VALUES(default, 'forwardall', 'text', 'Forward All Calls Destination', 'All calls will be transferred to this extension. Blank disables.', '', '5', '')", - "INSERT INTO provisioning_params VALUES(default, 'forwarding', 'boolean', 'Forwarding Enable', '', 'true', '11', '')", - "INSERT INTO provisioning_params VALUES(default, 'hotlineenable', 'boolean', 'Hotline Enable', '', 'false', '12', '')", - "INSERT INTO provisioning_params VALUES(default, 'hotlinedestination', 'text', 'Hotline Destination', '', '', '13', '')", + "INSERT INTO provisioning_params VALUES(default, 'mac', 'text', 'MAC Address', 'Capitalized hex digits with no puncuation', '', '1', '^[0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F]$')", + "INSERT INTO provisioning_params VALUES(default, 'template', 'select', 'Template', '', '', '2', '')", + "INSERT INTO provisioning_params VALUES(default, 'extension', 'text', 'Extension', '', '', '11', '^%d*$')", + "INSERT INTO provisioning_params VALUES(default, 'password', 'text', 'Password', '', '', '12', '')", + "INSERT INTO provisioning_params VALUES(default, 'forwardnoanswer', 'text', 'Forward on No-answer Destination', 'Callers will be transferred to this extension when you don''t answer after 20 seconds. Blank disables.', '', '13', '')", + "INSERT INTO provisioning_params VALUES(default, 'forwardbusy', 'text', 'Forward on Busy Destination', 'Callers will be transferred to this extension when the line is busy. Blank disables.', '', '14', '')", + "INSERT INTO provisioning_params VALUES(default, 'forwardall', 'text', 'Forward All Calls Destination', 'All calls will be transferred to this extension. Blank disables.', '', '15', '')", + "INSERT INTO provisioning_params VALUES(default, 'forwarding', 'boolean', 'Forwarding Enable', '', 'true', '21', '')", + "INSERT INTO provisioning_params VALUES(default, 'hotlineenable', 'boolean', 'Hotline Enable', '', 'false', '22', '')", + "INSERT INTO provisioning_params VALUES(default, 'hotlinedestination', 'text', 'Hotline Destination', '', '', '23', '')", } -- All of the (non-default) parameter values for all devices are stored here |