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:26 UTC
[2/3] incubator-trafficcontrol git commit: fix missing triggers --
lost in mysql to psql transition
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