Org Tenancy - DB migration file rename (date)
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/97764b17 Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/97764b17 Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/97764b17 Branch: refs/heads/master Commit: 97764b17547a6025f41eb67583cac6612b7c6ae2 Parents: 85b0557 Author: nir-sopher <nirsop...@gmail.com> Authored: Sat Apr 1 21:43:54 2017 +0300 Committer: Jeremy Mitchell <mitchell...@gmail.com> Committed: Sun Apr 2 16:08:51 2017 -0600 ---------------------------------------------------------------------- .../migrations/20170315000001_user_tenancy.sql | 31 -------------------- .../migrations/20170401000000_user_tenancy.sql | 31 ++++++++++++++++++++ 2 files changed, 31 insertions(+), 31 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/97764b17/traffic_ops/app/db/migrations/20170315000001_user_tenancy.sql ---------------------------------------------------------------------- diff --git a/traffic_ops/app/db/migrations/20170315000001_user_tenancy.sql b/traffic_ops/app/db/migrations/20170315000001_user_tenancy.sql deleted file mode 100644 index 9be1ca3..0000000 --- a/traffic_ops/app/db/migrations/20170315000001_user_tenancy.sql +++ /dev/null @@ -1,31 +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 tm_user - 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_tm_user_tenant_idx ON tm_user USING btree (tenant_id); - --- +goose Down --- SQL section 'Down' is executed when this migration is rolled back - -ALTER TABLE tm_user -DROP COLUMN tenant_id; - http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/97764b17/traffic_ops/app/db/migrations/20170401000000_user_tenancy.sql ---------------------------------------------------------------------- diff --git a/traffic_ops/app/db/migrations/20170401000000_user_tenancy.sql b/traffic_ops/app/db/migrations/20170401000000_user_tenancy.sql new file mode 100644 index 0000000..9be1ca3 --- /dev/null +++ b/traffic_ops/app/db/migrations/20170401000000_user_tenancy.sql @@ -0,0 +1,31 @@ +/* + + 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 tm_user + 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_tm_user_tenant_idx ON tm_user USING btree (tenant_id); + +-- +goose Down +-- SQL section 'Down' is executed when this migration is rolled back + +ALTER TABLE tm_user +DROP COLUMN tenant_id; +
