[trafficcontrol] 10/12: added migration to require cachegroup column in staticdnsentry table

[mi...@apache.org]

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

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

commit ef5b29a7ee4b6313bd3caa9e3c802588a0d451a5
Author: Jesse Rivas <je...@comcast.com>
AuthorDate: Wed Aug 8 11:51:42 2018 -0600

    added migration to require cachegroup column in staticdnsentry table
---
 .../20180808000000_alter_sde_cg_not_null.sql       | 23 ++++++++++++++++++++++
 1 file changed, 23 insertions(+)

diff --git a/traffic_ops/app/db/migrations/20180808000000_alter_sde_cg_not_null.sql b/traffic_ops/app/db/migrations/20180808000000_alter_sde_cg_not_null.sql
new file mode 100644
index 0000000..7c406fc
--- /dev/null
+++ b/traffic_ops/app/db/migrations/20180808000000_alter_sde_cg_not_null.sql
@@ -0,0 +1,23 @@
+/*
+
+    Licensed under the Apache License, Version 2.0 (the "License");
+    you may not use this file except in compliance with the License.
+    You may obtain a copy of the License at
+
+        http://www.apache.org/licenses/LICENSE-2.0
+
+    Unless required by applicable law or agreed to in writing, software
+    distributed under the License is distributed on an "AS IS" BASIS,
+    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+    See the License for the specific language governing permissions and
+    limitations under the License.
+*/
+
+-- +goose Up
+-- SQL in section 'Up' is executed when this migration is applied
+ALTER TABLE STATICDNSENTRY ALTER COLUMN CACHEGROUP SET NOT NULL;
+
+-- +goose Down
+-- SQL section 'Down' is executed when this migration is rolled back
+ALTER TABLE STATICDNSENTRY ALTER COLUMN CACHEGROUP DROP NOT NULL;
+