Repository: incubator-trafficcontrol Updated Branches: refs/heads/master 8461b11bc -> d8d66502d
add use_reval_pending to global profile Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/51275270 Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/51275270 Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/51275270 Branch: refs/heads/master Commit: 51275270f6c25daf7473ddc696884417fbb65574 Parents: dfe6642 Author: Derek Gelinas <derek_geli...@cable.comcast.com> Authored: Wed Feb 22 14:06:56 2017 -0500 Committer: Jeremy Mitchell <mitchell...@gmail.com> Committed: Thu Mar 16 15:08:23 2017 -0600 ---------------------------------------------------------------------- traffic_ops/app/db/migrations/20170221190747_add_reval_pending.sql | 2 ++ 1 file changed, 2 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/51275270/traffic_ops/app/db/migrations/20170221190747_add_reval_pending.sql ---------------------------------------------------------------------- diff --git a/traffic_ops/app/db/migrations/20170221190747_add_reval_pending.sql b/traffic_ops/app/db/migrations/20170221190747_add_reval_pending.sql index 85ee402..74864d5 100644 --- a/traffic_ops/app/db/migrations/20170221190747_add_reval_pending.sql +++ b/traffic_ops/app/db/migrations/20170221190747_add_reval_pending.sql @@ -17,8 +17,10 @@ -- SQL in section 'Up' is executed when this migration is applied ALTER TABLE server ADD COLUMN reval_pending boolean NOT NULL DEFAULT false; INSERT INTO parameter (name, config_file, value, secure) VALUES ('use_reval_pending', 'global', '0', False); +insert into profile_parameter (profile, parameter) values ((select id from profile where name = 'GLOBAL'), (select id from parameter where name = 'use_reval_pending')); -- +goose Down -- SQL section 'Down' is executed when this migration is rolled back ALTER TABLE server DROP COLUMN reval_pending; +delete from profile_parameter where parameter = (select id from parameter where name = 'use_reval_pending'); delete from parameter where name = 'use_reval_pending'; \ No newline at end of file
