[trafficcontrol] branch master updated: Update the traffic_ops databae to add a GROVE_PROFILE to the profile_type ENUM.

[de...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

dewrich pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/trafficcontrol.git


The following commit(s) were added to refs/heads/master by this push:
     new ee569be  Update the traffic_ops databae to add a GROVE_PROFILE to the profile_type ENUM.
ee569be is described below

commit ee569be166fa812d12f463e75f655fb41e4a65ab
Author: John Rushford <jr...@apache.org>
AuthorDate: Mon Jul 9 17:17:15 2018 +0000

    Update the traffic_ops databae to add a GROVE_PROFILE to the profile_type ENUM.
---
 traffic_ops/app/db/patches.sql | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/traffic_ops/app/db/patches.sql b/traffic_ops/app/db/patches.sql
index 640a515..6fe87d1 100644
--- a/traffic_ops/app/db/patches.sql
+++ b/traffic_ops/app/db/patches.sql
@@ -34,3 +34,8 @@ ALTER TABLE deliveryservice ALTER COLUMN routing_name SET NOT NULL;
 ALTER TABLE deliveryservice ALTER COLUMN routing_name SET DEFAULT 'cdn';
 ALTER TABLE deliveryservice DROP CONSTRAINT IF EXISTS routing_name_not_empty;
 ALTER TABLE deliveryservice ADD CONSTRAINT routing_name_not_empty CHECK (length(routing_name) > 0);
+-- This patch adds a new enum value to profile_type
+-- We need to add the enum directly with sql as postgres will not allow
+-- altering any enum values within a transaction block and by default
+-- goose runs migrations within a transaction.
+ALTER TYPE profile_type ADD VALUE IF NOT EXISTS 'GROVE_PROFILE';