diff options
author | Alan Lacerda <alacerda@alpinelinux.org> | 2015-05-12 20:49:28 +0000 |
---|---|---|
committer | Ted Trask <ttrask01@yahoo.com> | 2015-05-13 08:16:26 -0400 |
commit | acb5bc002de09dff8cf7490671c18f2a707d01e2 (patch) | |
tree | 1b1289afaaf8a35df10adeef321cd58948dad19b /upgradeprovisioning | |
parent | 7504992fb58832b07d453be2003224f1033d547b (diff) | |
download | acf-provisioning-acb5bc002de09dff8cf7490671c18f2a707d01e2.tar.bz2 acf-provisioning-acb5bc002de09dff8cf7490671c18f2a707d01e2.tar.xz |
split polycom vvx models
Signed-off-by: Ted Trask <ttrask01@yahoo.com>
Diffstat (limited to 'upgradeprovisioning')
-rwxr-xr-x | upgradeprovisioning | 15 |
1 files changed, 10 insertions, 5 deletions
diff --git a/upgradeprovisioning b/upgradeprovisioning index df1e2cf..d498c51 100755 --- a/upgradeprovisioning +++ b/upgradeprovisioning @@ -279,11 +279,16 @@ fi if [ "$version" -lt "3" ]; then echo "Upgrading to database version 3" - psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 300/310/400/410/500/600', '7')" provisioning - psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))" provisioning - - for a in $(seq 1 34); do - psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration $a (Polycom)'))" provisioning + psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 300/310', '7')" provisioning + psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 400/410', '8')" provisioning + psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 500', '9')" provisioning + psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 600', '10')" provisioning + + for polycom_model in "300/310" "400/410" "500" "600"; do + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX $polycom_model'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))" provisioning + for a in $(seq 1 34); do + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX $polycom_model'), (SELECT group_id FROM provisioning_groups WHERE label='Registration $a (Polycom)'))" provisioning + done done psql -U postgres -c "UPDATE provisioning_classes SET seq='100' WHERE label='Linksys Internet Phone Adapter PAP2T'" provisioning |