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/12/16 21:16:47 UTC

[50/50] incubator-trafficcontrol git commit: adds goose down for snapshot trigger and table creation

adds goose down for snapshot trigger and table creation


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/0b99575d
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/0b99575d
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/0b99575d

Branch: refs/heads/postgres
Commit: 0b99575df7926161161dd564fa0e913bf15050da
Parents: 3a75935
Author: Jeremy Mitchell <mi...@gmail.com>
Authored: Mon Dec 12 14:30:02 2016 -0700
Committer: Dan Kirkwood <da...@gmail.com>
Committed: Fri Dec 16 14:10:49 2016 -0700

----------------------------------------------------------------------
 traffic_ops/app/db/migrations/20161208000001_create_snapshots.sql | 3 +++
 1 file changed, 3 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/0b99575d/traffic_ops/app/db/migrations/20161208000001_create_snapshots.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20161208000001_create_snapshots.sql b/traffic_ops/app/db/migrations/20161208000001_create_snapshots.sql
index 240a0c5..d5c2d9a 100644
--- a/traffic_ops/app/db/migrations/20161208000001_create_snapshots.sql
+++ b/traffic_ops/app/db/migrations/20161208000001_create_snapshots.sql
@@ -27,3 +27,6 @@ CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON snapshot FOR EACH RO
 
 -- +goose Down
 -- SQL section 'Down' is executed when this migration is rolled back
+DROP TRIGGER on_update_current_timestamp ON snapshot;
+
+DROP TABLE snapshot;