[incubator-trafficcontrol] branch master updated: removed the job_result reference from the rest of the migrations for fresh installs

[da...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

dangogh pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-trafficcontrol.git


The following commit(s) were added to refs/heads/master by this push:
     new 09ae825  removed the job_result reference from the rest of the migrations for fresh installs
09ae825 is described below

commit 09ae825f56760a5c859d6d888c009cdc01f29ac7
Author: Dewayne Richardson <de...@apache.org>
AuthorDate: Thu May 17 11:18:22 2018 -0600

    removed the job_result reference from the rest of the migrations for fresh installs
---
 traffic_ops/app/db/create_tables.sql | 35 +++++++++++++++++++++++++++++++++++
 1 file changed, 35 insertions(+)

diff --git a/traffic_ops/app/db/create_tables.sql b/traffic_ops/app/db/create_tables.sql
index 2c18b7f..4a9df85 100644
--- a/traffic_ops/app/db/create_tables.sql
+++ b/traffic_ops/app/db/create_tables.sql
@@ -567,6 +567,41 @@ ALTER TABLE job_id_seq OWNER TO traffic_ops;
 
 ALTER SEQUENCE job_id_seq OWNED BY job.id;
 
+--
+-- Name: job_result; Type: TABLE; Schema: public; Owner: traffic_ops
+--
+
+CREATE TABLE job_result (
+    id bigint NOT NULL,
+    job bigint NOT NULL,
+    agent bigint NOT NULL,
+    result text NOT NULL,
+    description text,
+    last_updated timestamp with time zone DEFAULT now()
+);
+
+
+ALTER TABLE job_result OWNER TO traffic_ops;
+
+--
+-- Name: job_result_id_seq; Type: SEQUENCE; Schema: public; Owner: traffic_ops
+--
+
+CREATE SEQUENCE job_result_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE job_result_id_seq OWNER TO traffic_ops;
+
+--
+-- Name: job_result_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: traffic_ops
+--
+
+ALTER SEQUENCE job_result_id_seq OWNED BY job_result.id;
 
 --
 -- Name: job_status; Type: TABLE; Schema: public; Owner: traffic_ops

-- 
To stop receiving notification emails like this one, please contact
dangogh@apache.org.