diff options
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 |