diff options
| author | Alan Lacerda <alacerda@alpinelinux.org> | 2015-05-13 19:01:00 +0000 |
|---|---|---|
| committer | Ted Trask <ttrask01@yahoo.com> | 2015-05-14 10:22:34 -0400 |
| commit | 42d4e0b8a70dfeff4d0b913e7fd46332c797eed6 (patch) | |
| tree | 07de52de7c971ed48aa0a52db6f875e18d53816f /upgradeprovisioning | |
| parent | acb5bc002de09dff8cf7490671c18f2a707d01e2 (diff) | |
| download | acf-provisioning-42d4e0b8a70dfeff4d0b913e7fd46332c797eed6.tar.bz2 acf-provisioning-42d4e0b8a70dfeff4d0b913e7fd46332c797eed6.tar.xz | |
split Standard Phone into Office and Residential Phones
Signed-off-by: Ted Trask <ttrask01@yahoo.com>
Diffstat (limited to 'upgradeprovisioning')
| -rwxr-xr-x | upgradeprovisioning | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/upgradeprovisioning b/upgradeprovisioning index d498c51..656481d 100755 --- a/upgradeprovisioning +++ b/upgradeprovisioning @@ -296,6 +296,31 @@ if [ "$version" -lt "3" ]; then psql -U postgres -c "UPDATE provisioning_classes SET seq='300' WHERE label='Snom 300'" provisioning psql -U postgres -c "UPDATE provisioning_classes SET seq='301' WHERE label='Snom 320/360/370'" provisioning + # provisioning_classes + psql -U postgres -c "UPDATE provisioning_classes SET label='Office Phone' WHERE label='Standard Phone')" provisioning + psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='services'), 'Residential Phone', '11')" provisioning + psql -U postgres -c "UPDATE provisioning_classes SET seq='21' WHERE label='Public Phone'" provisioning + psql -U postgres -c "UPDATE provisioning_classes SET seq='31' WHERE label='Hotline'" provisioning + + # provisioning_groups + psql -U postgres -c "UPDATE provisioning_groups SET label='Office Phone' WHERE label='Standard Phone')" provisioning + psql -U postgres -c "INSERT INTO provisioning_groups VALUES(default, 'services', 'Residential Phone', '31')" provisioning + psql -U postgres -c "UPDATE provisioning_groups SET seq='41' WHERE label='Public Phone')" provisioning + psql -U postgres -c "UPDATE provisioning_groups SET seq='51' WHERE label='Hotline')" provisioning + + # classes_to_param_groups + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Residential Phone'), (SELECT group_id FROM provisioning_groups WHERE label='Residential Phone'))" provisioning + + # param_groups_to_params + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Residential Phone'), (SELECT param_id FROM provisioning_params WHERE name='forwarding'), 'true', false)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Residential Phone'), (SELECT param_id FROM provisioning_params WHERE name='hotlineenable'), 'false', false)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Residential Phone'), (SELECT param_id FROM provisioning_params WHERE name='callhistoryenable'), 'true', false)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Residential Phone'), (SELECT param_id FROM provisioning_params WHERE name='callwaitingenable'), 'true', false)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Residential Phone'), (SELECT param_id FROM provisioning_params WHERE name='speeddialenable'), 'true', false)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Residential Phone'), (SELECT param_id FROM provisioning_params WHERE name='mailbox'), null, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Residential Phone'), (SELECT param_id FROM provisioning_params WHERE name='mailcallback'), null, true)" provisioning + + # database psql -U postgres -c "UPDATE provisioning_params SET value='3' WHERE name='databaseversion'" provisioning fi |