diff options
| author | Ted Trask <ttrask01@yahoo.com> | 2014-08-19 12:40:38 +0000 |
|---|---|---|
| committer | Ted Trask <ttrask01@yahoo.com> | 2014-08-19 12:40:38 +0000 |
| commit | 207a204bb95ceba5017a91c340b53ef12c0811d8 (patch) | |
| tree | e9433c255d806badcec61d4ca5ab08b89789aea9 | |
| parent | afd9299582949522d1344afc5beade4d6348ad47 (diff) | |
| download | acf-provisioning-207a204bb95ceba5017a91c340b53ef12c0811d8.tar.bz2 acf-provisioning-207a204bb95ceba5017a91c340b53ef12c0811d8.tar.xz | |
Fix order of operations in upgradeprovisioning
| -rwxr-xr-x | upgradeprovisioning | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/upgradeprovisioning b/upgradeprovisioning index 4a54720..d37c257 100755 --- a/upgradeprovisioning +++ b/upgradeprovisioning @@ -244,12 +244,12 @@ if [ "$version" -lt "2" ]; then echo "Upgrading to database version 2" psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Cisco 2 Port Phone Adapter SPA112', '8')" provisioning -psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Cisco 2 Port Phone Adapter SPA112'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Cisco)'))" provisioning -psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Cisco 2 Port Phone Adapter SPA112'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Cisco)'))" provisioning -psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Cisco 2 Port Phone Adapter SPA112'), (SELECT group_id FROM provisioning_groups WHERE label='Cisco ATA Device'))" provisioning psql -U postgres -c "INSERT INTO provisioning_groups VALUES(default, 'device', 'Cisco ATA Device', '1')" provisioning psql -U postgres -c "INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (Cisco)', '10')" provisioning psql -U postgres -c "INSERT INTO provisioning_groups VALUES(default, 'reg2', 'Registration 2 (Cisco)', '10')" provisioning +psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Cisco 2 Port Phone Adapter SPA112'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Cisco)'))" provisioning +psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Cisco 2 Port Phone Adapter SPA112'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Cisco)'))" provisioning +psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Cisco 2 Port Phone Adapter SPA112'), (SELECT group_id FROM provisioning_groups WHERE label='Cisco ATA Device'))" provisioning psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Cisco ATA Device'), (SELECT param_id FROM provisioning_params WHERE name='template'), '/etc/provisioning/templates/ciscoata-template.lua', false)" provisioning psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Cisco ATA Device'), (SELECT param_id FROM provisioning_params WHERE name='mac'), null, true)" provisioning psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Cisco ATA Device'), (SELECT param_id FROM provisioning_params WHERE name='registrar'), null, false)" provisioning |