diff options
author | Ted Trask <ttrask01@yahoo.com> | 2017-03-01 00:02:39 +0000 |
---|---|---|
committer | Ted Trask <ttrask01@yahoo.com> | 2017-03-01 00:02:39 +0000 |
commit | ca09a060531dfb1de2d4f36fa90b07c82ad0d9ec (patch) | |
tree | b2a4a074a6206d5750ca53449b3c958a79063767 | |
parent | 155ebf06883a902ddd58863b5373c6c8504b6d50 (diff) | |
download | acf-provisioning-ca09a060531dfb1de2d4f36fa90b07c82ad0d9ec.tar.bz2 acf-provisioning-ca09a060531dfb1de2d4f36fa90b07c82ad0d9ec.tar.xz |
Update upgrade script to put firmware update changes into databaseversion 13
-rwxr-xr-x | upgradeprovisioning | 39 |
1 files changed, 24 insertions, 15 deletions
diff --git a/upgradeprovisioning b/upgradeprovisioning index b06018f..b5da882 100755 --- a/upgradeprovisioning +++ b/upgradeprovisioning @@ -742,23 +742,8 @@ fi if [ "$version" -lt "12" ]; then echo "Upgrading to database version 12" - psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='displaylang'), 'French (Canada)', 'French_Canada', '8')" provisioning - psql -U postgres -c "UPDATE provisioning_options SET label='French (France)' WHERE param_id=(SELECT param_id FROM provisioning_params WHERE name='displaylang') AND value='French_France'" provisioning psql -U postgres -c "INSERT INTO provisioning_params VALUES(default, 'clockenable', 'boolean', 'Clock Enable', '', 'true', '14', '', null)" provisioning psql -U postgres -c "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='clockenable'), null, false)" provisioning - psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 101', '7')" provisioning - psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 101'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Polycom)'))" provisioning - psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 101'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))" provisioning - psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 201', '8')" provisioning - psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 201'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Polycom)'))" provisioning - psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 201'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Polycom)'))" provisioning - psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 201'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))" provisioning - psql -U postgres -c "UPDATE provisioning_classes SET (label,seq)=('Polycom VVX 300/301/310/311', '9') WHERE label='Polycom VVX 300/310'" provisioning - psql -U postgres -c "UPDATE provisioning_classes SET (label,seq)=('Polycom VVX 400/401/410/411', '10') WHERE label='Polycom VVX 400/410'" provisioning - psql -U postgres -c "UPDATE provisioning_classes SET (label,seq)=('Polycom VVX 500/501', '11') WHERE label='Polycom VVX 500'" provisioning - psql -U postgres -c "UPDATE provisioning_classes SET (label,seq)=('Polycom VVX 600/601', '12') WHERE label='Polycom VVX 600'" provisioning - psql -U postgres -c "INSERT INTO provisioning_params VALUES(default, 'dectenable', 'boolean', 'VVX D60 Enable', '', 'false', '46', '', null)" provisioning - psql -U postgres -c "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='dectenable'), null, false)" provisioning psql -U postgres -c "UPDATE provisioning_params SET(label)=('Placed Call History Enable') WHERE name='callhistoryenable'" provisioning psql -U postgres -c "INSERT INTO provisioning_params VALUES(default, 'missedcallhistoryenable', 'boolean', 'Missed Call History Enable', '', 'true', '204', '', null)" provisioning @@ -776,4 +761,28 @@ if [ "$version" -lt "12" ]; then psql -U postgres -c "UPDATE provisioning_params SET value='12' WHERE name='databaseversion'" provisioning fi +if [ "$version" -lt "13" ]; then + echo "Upgrading to database version 13" + + psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='displaylang'), 'French (Canada)', 'French_Canada', '8')" provisioning + psql -U postgres -c "UPDATE provisioning_options SET label='French (France)' WHERE param_id=(SELECT param_id FROM provisioning_params WHERE name='displaylang') AND value='French_France'" provisioning + + psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 101', '7')" provisioning + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 101'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Polycom)'))" provisioning + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 101'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))" provisioning + psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 201', '8')" provisioning + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 201'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Polycom)'))" provisioning + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 201'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Polycom)'))" provisioning + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 201'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))" provisioning + psql -U postgres -c "UPDATE provisioning_classes SET (label,seq)=('Polycom VVX 300/301/310/311', '9') WHERE label='Polycom VVX 300/310'" provisioning + psql -U postgres -c "UPDATE provisioning_classes SET (label,seq)=('Polycom VVX 400/401/410/411', '10') WHERE label='Polycom VVX 400/410'" provisioning + psql -U postgres -c "UPDATE provisioning_classes SET (label,seq)=('Polycom VVX 500/501', '11') WHERE label='Polycom VVX 500'" provisioning + psql -U postgres -c "UPDATE provisioning_classes SET (label,seq)=('Polycom VVX 600/601', '12') WHERE label='Polycom VVX 600'" provisioning + psql -U postgres -c "INSERT INTO provisioning_params VALUES(default, 'dectenable', 'boolean', 'VVX D60 Enable', '', 'false', '46', '', null)" provisioning + psql -U postgres -c "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='dectenable'), null, false)" provisioning + + # database + psql -U postgres -c "UPDATE provisioning_params SET value='13' WHERE name='databaseversion'" provisioning +fi + exit 0 |