Rename the delivery_service_tenancy migration file, waiting for the pull
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/1e361b73 Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/1e361b73 Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/1e361b73 Branch: refs/heads/master Commit: 1e361b736678b182ed153483d65e133444277b90 Parents: 6d67f5f Author: nir-sopher <n...@qwilt.com> Authored: Wed Jun 21 00:15:33 2017 +0300 Committer: Jeremy Mitchell <mitchell...@gmail.com> Committed: Mon Jul 10 14:41:42 2017 -0600 ---------------------------------------------------------------------- .../20170602000000_delivery_service_tenancy.sql | 30 -------------------- .../20170621000000_delivery_service_tenancy.sql | 30 ++++++++++++++++++++ 2 files changed, 30 insertions(+), 30 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/1e361b73/traffic_ops/app/db/migrations/20170602000000_delivery_service_tenancy.sql ---------------------------------------------------------------------- diff --git a/traffic_ops/app/db/migrations/20170602000000_delivery_service_tenancy.sql b/traffic_ops/app/db/migrations/20170602000000_delivery_service_tenancy.sql deleted file mode 100644 index a737d0c..0000000 --- a/traffic_ops/app/db/migrations/20170602000000_delivery_service_tenancy.sql +++ /dev/null @@ -1,30 +0,0 @@ -/* - - 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 deliveryservice - ADD tenant_id BIGINT, - ADD CONSTRAINT fk_tenantid FOREIGN KEY (tenant_id) REFERENCES tenant (id) MATCH FULL, - ALTER COLUMN tenant_id SET DEFAULT NULL; -CREATE INDEX idx_k_deliveryservice_tenant_idx ON deliveryservice USING btree (tenant_id); - --- +goose Down --- SQL section 'Down' is executed when this migration is rolled back - -ALTER TABLE deliveryservice -DROP COLUMN tenant_id; - http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/1e361b73/traffic_ops/app/db/migrations/20170621000000_delivery_service_tenancy.sql ---------------------------------------------------------------------- diff --git a/traffic_ops/app/db/migrations/20170621000000_delivery_service_tenancy.sql b/traffic_ops/app/db/migrations/20170621000000_delivery_service_tenancy.sql new file mode 100644 index 0000000..a737d0c --- /dev/null +++ b/traffic_ops/app/db/migrations/20170621000000_delivery_service_tenancy.sql @@ -0,0 +1,30 @@ +/* + + 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 deliveryservice + ADD tenant_id BIGINT, + ADD CONSTRAINT fk_tenantid FOREIGN KEY (tenant_id) REFERENCES tenant (id) MATCH FULL, + ALTER COLUMN tenant_id SET DEFAULT NULL; +CREATE INDEX idx_k_deliveryservice_tenant_idx ON deliveryservice USING btree (tenant_id); + +-- +goose Down +-- SQL section 'Down' is executed when this migration is rolled back + +ALTER TABLE deliveryservice +DROP COLUMN tenant_id; +
