You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafficcontrol.apache.org by da...@apache.org on 2016/11/14 22:35:12 UTC
[1/2] incubator-trafficcontrol git commit: removes applied migrations
Repository: incubator-trafficcontrol
Updated Branches:
refs/heads/psql-rebase dceef530c -> 4895aeb12
removes applied migrations
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/ea10588f
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/ea10588f
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/ea10588f
Branch: refs/heads/psql-rebase
Commit: ea10588f9b4e72c1d5b49b0cc77381e6933389a0
Parents: dceef53
Author: Jeremy Mitchell <mi...@gmail.com>
Authored: Mon Nov 14 15:03:18 2016 -0700
Committer: Dan Kirkwood <da...@gmail.com>
Committed: Mon Nov 14 15:34:20 2016 -0700
----------------------------------------------------------------------
.../20160718000000_drop_ttl_max_hours_param.sql | 23 --------
.../20160718000005_drop_ttl_min_hours_param.sql | 23 --------
.../20160826111234_modify_server_table.sql | 58 --------------------
3 files changed, 104 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/ea10588f/traffic_ops/app/db/migrations/20160718000000_drop_ttl_max_hours_param.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20160718000000_drop_ttl_max_hours_param.sql b/traffic_ops/app/db/migrations/20160718000000_drop_ttl_max_hours_param.sql
deleted file mode 100644
index fc32174..0000000
--- a/traffic_ops/app/db/migrations/20160718000000_drop_ttl_max_hours_param.sql
+++ /dev/null
@@ -1,23 +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
-
-DELETE FROM parameter
-WHERE parameter.name = "ttl_max_hours";
-
--- +goose Down
--- SQL section 'Down' is executed when this migration is rolled back
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/ea10588f/traffic_ops/app/db/migrations/20160718000005_drop_ttl_min_hours_param.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20160718000005_drop_ttl_min_hours_param.sql b/traffic_ops/app/db/migrations/20160718000005_drop_ttl_min_hours_param.sql
deleted file mode 100644
index d08f219..0000000
--- a/traffic_ops/app/db/migrations/20160718000005_drop_ttl_min_hours_param.sql
+++ /dev/null
@@ -1,23 +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
-
-DELETE FROM parameter
-WHERE parameter.name = "ttl_min_hours";
-
--- +goose Down
--- SQL section 'Down' is executed when this migration is rolled back
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/ea10588f/traffic_ops/app/db/migrations/20160826111234_modify_server_table.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20160826111234_modify_server_table.sql b/traffic_ops/app/db/migrations/20160826111234_modify_server_table.sql
deleted file mode 100644
index 7d8ea25..0000000
--- a/traffic_ops/app/db/migrations/20160826111234_modify_server_table.sql
+++ /dev/null
@@ -1,58 +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
-set @exist1 := (select count(*) from information_schema.statistics where table_name = 'server' and index_name = 'cs_ip_address_UNIQUE' and table_schema = database());
-set @sqlstmt1 := if( @exist1 > 0, 'alter table server drop index cs_ip_address_UNIQUE', 'alter table server');
-PREPARE stmt1 FROM @sqlstmt1;
-EXECUTE stmt1;
-
-set @exist2 := (select count(*) from information_schema.statistics where table_name = 'server' and index_name = 'ip6_address' and table_schema = database());
-set @sqlstmt2 := if( @exist2 > 0, 'alter table server drop index ip6_address', 'alter table server');
-PREPARE stmt2 FROM @sqlstmt2;
-EXECUTE stmt2;
-
-set @exist3 := (select count(*) from information_schema.statistics where table_name = 'server' and index_name = 'host_name' and table_schema = database());
-set @sqlstmt3 := if( @exist3 > 0, 'alter table server drop index host_name', 'alter table server');
-PREPARE stmt3 FROM @sqlstmt3;
-EXECUTE stmt3;
-
-alter table server modify host_name varchar(63) not null;
-alter table server modify domain_name varchar(63) not null;
-
-alter table server add unique key `ip_profile` (ip_address, profile);
-alter table server add unique key `ip6_profile` (ip6_address, profile);
-
--- +goose Down
--- SQL section 'Down' is executed when this migration is rolled back
-create unique index cs_ip_address_UNIQUE on server (ip_address);
-create unique index host_name on server (host_name);
-create unique index ip6_address on server (ip6_address);
-alter table server modify host_name varchar(45) not null;
-alter table server modify domain_name varchar(45) not null;
-
-set @exist4 := (select count(*) from information_schema.statistics where table_name = 'server' and index_name = 'ip_profile' and table_schema = database());
-set @sqlstmt4 := if( @exist4 > 0, 'alter table server drop index ip_profile', 'alter table server');
-PREPARE stmt4 FROM @sqlstmt4;
-EXECUTE stmt4;
-
-set @exist5 := (select count(*) from information_schema.statistics where table_name = 'server' and index_name = 'ip6_profile' and table_schema = database());
-set @sqlstmt5 := if( @exist5 > 0, 'alter table server drop index ip6_profile', 'alter table server');
-PREPARE stmt5 FROM @sqlstmt5;
-EXECUTE stmt5;
-
-
-
[2/2] incubator-trafficcontrol git commit: This closes #80
Posted by da...@apache.org.
This closes #80
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/4895aeb1
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/4895aeb1
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/4895aeb1
Branch: refs/heads/psql-rebase
Commit: 4895aeb129b0f603b830bd746c0c24c85977fe7a
Parents: ea10588
Author: Dan Kirkwood <da...@gmail.com>
Authored: Mon Nov 14 15:34:51 2016 -0700
Committer: Dan Kirkwood <da...@gmail.com>
Committed: Mon Nov 14 15:34:51 2016 -0700
----------------------------------------------------------------------
----------------------------------------------------------------------