You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafficcontrol.apache.org by mi...@apache.org on 2017/06/26 15:36:25 UTC
[1/3] incubator-trafficcontrol git commit: add copyright header
Repository: incubator-trafficcontrol
Updated Branches:
refs/heads/master c00049d42 -> e81631b6d
add copyright header
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/f7bcfe16
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/f7bcfe16
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/f7bcfe16
Branch: refs/heads/master
Commit: f7bcfe160d9618a8652cbef8d4159d00e5e16ede
Parents: a9681f2
Author: Dan Kirkwood <da...@gmail.com>
Authored: Fri Jun 23 21:52:10 2017 +0000
Committer: Jeremy Mitchell <mi...@gmail.com>
Committed: Mon Jun 26 09:35:52 2017 -0600
----------------------------------------------------------------------
.../app/db/migrations/20170623144818_lastupdated.sql | 14 ++++++++++++++
1 file changed, 14 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/f7bcfe16/traffic_ops/app/db/migrations/20170623144818_lastupdated.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20170623144818_lastupdated.sql b/traffic_ops/app/db/migrations/20170623144818_lastupdated.sql
index ce46819..fd10480 100644
--- a/traffic_ops/app/db/migrations/20170623144818_lastupdated.sql
+++ b/traffic_ops/app/db/migrations/20170623144818_lastupdated.sql
@@ -1,3 +1,17 @@
+/*
+
+ 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
[3/3] incubator-trafficcontrol git commit: This closes #697
Posted by mi...@apache.org.
This closes #697
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/e81631b6
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/e81631b6
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/e81631b6
Branch: refs/heads/master
Commit: e81631b6db9c0e0b8b3b3f48b91a1bac9bc283ed
Parents: f7bcfe1
Author: Jeremy Mitchell <mi...@gmail.com>
Authored: Mon Jun 26 09:36:18 2017 -0600
Committer: Jeremy Mitchell <mi...@gmail.com>
Committed: Mon Jun 26 09:36:18 2017 -0600
----------------------------------------------------------------------
----------------------------------------------------------------------
[2/3] incubator-trafficcontrol git commit: fix missing triggers --
lost in mysql to psql transition
Posted by mi...@apache.org.
fix missing triggers -- lost in mysql to psql transition
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/a9681f20
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/a9681f20
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/a9681f20
Branch: refs/heads/master
Commit: a9681f20fd84b8753fdba585250667a548679777
Parents: c00049d
Author: Dan Kirkwood <da...@gmail.com>
Authored: Fri Jun 23 16:14:15 2017 +0000
Committer: Jeremy Mitchell <mi...@gmail.com>
Committed: Mon Jun 26 09:35:52 2017 -0600
----------------------------------------------------------------------
.../migrations/20170623144818_lastupdated.sql | 102 +++++++++++++++++++
1 file changed, 102 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/a9681f20/traffic_ops/app/db/migrations/20170623144818_lastupdated.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20170623144818_lastupdated.sql b/traffic_ops/app/db/migrations/20170623144818_lastupdated.sql
new file mode 100644
index 0000000..ce46819
--- /dev/null
+++ b/traffic_ops/app/db/migrations/20170623144818_lastupdated.sql
@@ -0,0 +1,102 @@
+
+-- +goose Up
+-- SQL in section 'Up' is executed when this migration is applied
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON asn;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON asn FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON cachegroup;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON cachegroup FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON cachegroup_parameter;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON cachegroup_parameter FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON cdn;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON cdn FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON deliveryservice;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON deliveryservice FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON deliveryservice_server;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON deliveryservice_server FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON deliveryservice_tmuser;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON deliveryservice_tmuser FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON division;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON division FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON federation;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON federation FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON federation_deliveryservice;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON federation_deliveryservice FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON federation_federation_resolver;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON federation_federation_resolver FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON federation_resolver;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON federation_resolver FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON federation_tmuser;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON federation_tmuser FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON hwinfo;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON hwinfo FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON job;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON job FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON job_agent;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON job_agent FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON job_result;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON job_result FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON job_status;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON job_status FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON log;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON log FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON parameter;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON parameter FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON phys_location;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON phys_location FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON profile;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON profile FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON profile_parameter;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON profile_parameter FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON regex;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON regex FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON region;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON region FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON server;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON server FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON servercheck;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON servercheck FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON staticdnsentry;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON staticdnsentry FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON status;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON status FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON steering_target;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON steering_target FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON tm_user;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON tm_user FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+DROP TRIGGER IF EXISTS on_update_current_timestamp ON type;
+CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON type FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_last_updated();
+
+-- +goose Down
+-- SQL section 'Down' is executed when this migration is rolled back