--
-- PostgreSQL database dump
--

-- Dumped from database version 10.1
-- Dumped by pg_dump version 10.1

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

SET search_path = log_task, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: duplicate; Type: TABLE; Schema: log_task; Owner: postgres
--

CREATE TABLE duplicate (
    id bigint NOT NULL,
    dummy_field text
);


ALTER TABLE duplicate OWNER TO postgres;

--
-- Name: log_table; Type: TABLE; Schema: log_task; Owner: postgres
--

CREATE TABLE log_table (
    id bigint DEFAULT nextval('log_id_seq'::regclass) NOT NULL,
    schema_name text NOT NULL,
    tbl_name text NOT NULL,
    username text NOT NULL,
    row_id bigint NOT NULL,
    old_data text,
    new_data text,
    query text NOT NULL,
    action_date timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    action_type text NOT NULL,
    success boolean DEFAULT false,
    CONSTRAINT log_table_action_type_check CHECK ((action_type = ANY (ARRAY['INSERT'::text, 'UPDATE'::text, 'DELETE'::text])))
);


ALTER TABLE log_table OWNER TO postgres;

--
-- Name: origin; Type: TABLE; Schema: log_task; Owner: postgres
--

CREATE TABLE origin (
    id bigint NOT NULL,
    dummy_field text
);


ALTER TABLE origin OWNER TO postgres;

--
-- Name: origin_id_seq; Type: SEQUENCE; Schema: log_task; Owner: postgres
--

CREATE SEQUENCE origin_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE origin_id_seq OWNER TO postgres;

--
-- Name: origin_id_seq; Type: SEQUENCE OWNED BY; Schema: log_task; Owner: postgres
--

ALTER SEQUENCE origin_id_seq OWNED BY origin.id;


--
-- Name: origin id; Type: DEFAULT; Schema: log_task; Owner: postgres
--

ALTER TABLE ONLY origin ALTER COLUMN id SET DEFAULT nextval('origin_id_seq'::regclass);


--
-- Data for Name: duplicate; Type: TABLE DATA; Schema: log_task; Owner: postgres
--

COPY duplicate (id, dummy_field) FROM stdin;
3   New value 3 updated
4   New value 4
\.


--
-- Data for Name: log_table; Type: TABLE DATA; Schema: log_task; Owner: postgres
--

COPY log_table (id, schema_name, tbl_name, username, row_id, old_data, new_data, query, action_date, action_type, success) FROM stdin;
10  log_task    origin  postgres    1   \N  (1,"New value") INSERT INTO "log_task"."origin" ("id", "dummy_field") VALUES (DEFAULT, $1)  2017-12-09 08:04:50.706233+00   INSERT  t
11  log_task    origin  postgres    2   \N  (2,"New value 2")   INSERT INTO "log_task"."origin" ("id", "dummy_field") VALUES (DEFAULT, $1)  2017-12-09 08:04:50.706233+00   INSERT  t
12  log_task    origin  postgres    2   (2,"New value 2")   (2,"New value 2 (updated)") UPDATE "log_task"."origin" SET "dummy_field" = $1 WHERE "id" = $2   2017-12-09 08:05:10.585635+00   UPDATE  t
13  log_task    origin  postgres    1   (1,"New value") \N  DELETE FROM "log_task"."origin" WHERE "id" = $1 2017-12-09 08:05:14.286799+00   DELETE  t
14  log_task    origin  postgres    3   \N  (3,"New value 3")   INSERT INTO "log_task"."origin" ("id", "dummy_field") VALUES (DEFAULT, $1)  2017-12-09 08:08:47.925788+00   INSERT  t
15  log_task    origin  postgres    2   (2,"New value 2 (updated)") \N  DELETE FROM "log_task"."origin" WHERE "id" = $1 2017-12-09 08:09:52.179821+00   DELETE  t
16  log_task    origin  postgres    3   (3,"New value 3")   (3,"New value 3 (updated)") UPDATE "log_task"."origin" SET "dummy_field" = $1 WHERE "id" = $2   2017-12-09 08:09:52.179821+00   UPDATE  t
17  log_task    origin  postgres    4   \N  (4,"New value 4")   INSERT INTO "log_task"."origin" ("id", "dummy_field") VALUES (DEFAULT, $1)  2017-12-09 08:09:52.179821+00   INSERT  t
\.


--
-- Data for Name: origin; Type: TABLE DATA; Schema: log_task; Owner: postgres
--

COPY origin (id, dummy_field) FROM stdin;
3   New value 3 (updated)
4   New value 4
\.


--
-- Name: origin_id_seq; Type: SEQUENCE SET; Schema: log_task; Owner: postgres
--

SELECT pg_catalog.setval('origin_id_seq', 4, true);


--
-- Name: duplicate duplicate_pkey; Type: CONSTRAINT; Schema: log_task; Owner: postgres
--

ALTER TABLE ONLY duplicate
    ADD CONSTRAINT duplicate_pkey PRIMARY KEY (id);


--
-- Name: log_table log_table_pkey; Type: CONSTRAINT; Schema: log_task; Owner: postgres
--

ALTER TABLE ONLY log_table
    ADD CONSTRAINT log_table_pkey PRIMARY KEY (id);


--
-- Name: origin origin_pkey; Type: CONSTRAINT; Schema: log_task; Owner: postgres
--

ALTER TABLE ONLY origin
    ADD CONSTRAINT origin_pkey PRIMARY KEY (id);


--
-- Name: origin log_origin_trigger; Type: TRIGGER; Schema: log_task; Owner: postgres
--

CREATE TRIGGER log_origin_trigger AFTER INSERT OR DELETE OR UPDATE ON origin FOR EACH ROW EXECUTE PROCEDURE log_origin();


--
-- PostgreSQL database dump complete
--