dewrich closed pull request #2286: removed the job_result reference from the rest of the migrations URL: https://github.com/apache/incubator-trafficcontrol/pull/2286
This is a PR merged from a forked repository. As GitHub hides the original diff on merge, it is displayed below for the sake of provenance: As this is a foreign pull request (from a fork), the diff is supplied below (as it won't show otherwise due to GitHub magic): diff --git a/traffic_ops/app/db/migrations/20170623144818_lastupdated.sql b/traffic_ops/app/db/migrations/20170623144818_lastupdated.sql index fd1048096..9dfb9a9e4 100644 --- a/traffic_ops/app/db/migrations/20170623144818_lastupdated.sql +++ b/traffic_ops/app/db/migrations/20170623144818_lastupdated.sql @@ -64,9 +64,6 @@ CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON job FOR EACH ROW EXE 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(); diff --git a/traffic_ops/app/db/migrations/20180406000000_last_updated_not_null.sql b/traffic_ops/app/db/migrations/20180406000000_last_updated_not_null.sql index d5882f975..3a9a7f60b 100644 --- a/traffic_ops/app/db/migrations/20180406000000_last_updated_not_null.sql +++ b/traffic_ops/app/db/migrations/20180406000000_last_updated_not_null.sql @@ -70,9 +70,6 @@ ALTER TABLE job ALTER COLUMN last_updated SET NOT NULL; UPDATE job_agent SET last_updated = now() WHERE last_updated IS NULL; ALTER TABLE job_agent ALTER COLUMN last_updated SET NOT NULL; -UPDATE job_result SET last_updated = now() WHERE last_updated IS NULL; -ALTER TABLE job_result ALTER COLUMN last_updated SET NOT NULL; - UPDATE job_status SET last_updated = now() WHERE last_updated IS NULL; ALTER TABLE job_status ALTER COLUMN last_updated SET NOT NULL; @@ -155,7 +152,6 @@ ALTER TABLE federation_tmuser ALTER COLUMN last_updated DROP NOT NULL; ALTER TABLE hwinfo ALTER COLUMN last_updated DROP NOT NULL; ALTER TABLE job ALTER COLUMN last_updated DROP NOT NULL; ALTER TABLE job_agent ALTER COLUMN last_updated DROP NOT NULL; -ALTER TABLE job_result ALTER COLUMN last_updated DROP NOT NULL; ALTER TABLE job_status ALTER COLUMN last_updated DROP NOT NULL; ALTER TABLE log ALTER COLUMN last_updated DROP NOT NULL; ALTER TABLE parameter ALTER COLUMN last_updated DROP NOT NULL; ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services