diff options
author | Ted Trask <ttrask01@yahoo.com> | 2015-12-28 04:30:01 +0000 |
---|---|---|
committer | Ted Trask <ttrask01@yahoo.com> | 2015-12-28 04:30:01 +0000 |
commit | 3ef565ea82a711a5e42d90a23f7b8bec8a1d3d94 (patch) | |
tree | 6d98d4916caed2c686ba98dbe5c12a2749498a3e /upgradeprovisioning | |
parent | da77aa6295d0e36a3af4142c96f496641b459df6 (diff) | |
download | acf-provisioning-3ef565ea82a711a5e42d90a23f7b8bec8a1d3d94.tar.bz2 acf-provisioning-3ef565ea82a711a5e42d90a23f7b8bec8a1d3d94.tar.xz |
Clean up group defaults so you can specify whether or not to override the parameter default
In general, device and reg groups do not override anything and service groups override all parameters
Diffstat (limited to 'upgradeprovisioning')
-rwxr-xr-x | upgradeprovisioning | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/upgradeprovisioning b/upgradeprovisioning index da1dd66..ffaa99a 100755 --- a/upgradeprovisioning +++ b/upgradeprovisioning @@ -548,6 +548,10 @@ if [ "$version" -lt "7" ]; then psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algospkmode'), 'Internal', '2', '2')" provisioning psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='algospkmode'), 'Disabled', '3', '3')" provisioning + # device and reg param groups should not override defaults with same value, other group types should + psql -U postgres -c "UPDATE param_groups_to_params SET value=null WHERE (group_id, param_id) IN (SELECT group_id, param_id FROM (provisioning_groups g JOIN param_groups_to_params g2p USING(group_id) JOIN provisioning_params p USING(param_id)) WHERE (g.name LIKE 'reg%' OR g.name LIKE 'device%') AND g2p.value=p.value)" provisioning + psql -U postgres -c "UPDATE param_groups_to_params o SET value=(SELECT value FROM provisioning_params WHERE param_id=o.param_id) WHERE (group_id, param_id) IN (SELECT group_id, param_id FROM (provisioning_groups g JOIN param_groups_to_params g2p USING(group_id) JOIN provisioning_params p USING(param_id)) WHERE g.name NOT LIKE 'reg%' AND g.name NOT LIKE 'device%' AND g2p.value IS NULL)" provisioning + # database psql -U postgres -c "UPDATE provisioning_params SET value='7' WHERE name='databaseversion'" provisioning fi |