--
-- PostgreSQL database dump
--

-- Dumped from database version 12.1
-- Dumped by pg_dump version 12.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;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: processinstancelog; Type: TABLE; Schema: public; Owner: bpm
--

CREATE TABLE public.processinstancelog (
    id bigint NOT NULL,
    correlationkey character varying(255),
    duration bigint,
    end_date timestamp without time zone,
    externalid character varying(255),
    user_identity character varying(255),
    outcome character varying(255),
    parentprocessinstanceid bigint,
    processid character varying(255),
    processinstancedescription character varying(255),
    processinstanceid bigint NOT NULL,
    processname character varying(255),
    processtype integer,
    processversion character varying(255),
    slacompliance integer,
    sla_due_date timestamp without time zone,
    start_date timestamp without time zone,
    status integer
);


ALTER TABLE public.processinstancelog OWNER TO bpm;

--
-- Data for Name: processinstancelog; Type: TABLE DATA; Schema: public; Owner: bpm
--

COPY public.processinstancelog (id, correlationkey, duration, end_date, externalid, user_identity, outcome, parentprocessinstanceid, processid, processinstancedescription, processinstanceid, processname, processtype, processversion, slacompliance, sla_due_date, start_date, status) FROM stdin;
1686	1686	\N	\N	rhpam_1.1.2-SNAPSHOT	mlazar	\N	-1	build-ms	build-ms	1686	build-ms	1	1.0	0	\N	2021-05-18 11:10:40.295	1
1687	1686:org.jbpm.process.longrest.executerest:d3d49de2-7c2c-46b7-8972-99d698a035b5	30273	2021-05-18 11:11:10.692	rhpam_1.1.2-SNAPSHOT	mlazar	\N	1686	org.jbpm.process.longrest.executerest	executerest	1687	executerest	1	1.0	0	\N	2021-05-18 11:10:40.419	2
1688	1686:org.jbpm.process.longrest.executerest:384ffd4f-47da-4399-bf81-61c00936ecf9	94	2021-05-18 11:11:10.885	rhpam_1.1.2-SNAPSHOT	mlazar	\N	1686	org.jbpm.process.longrest.executerest	executerest	1688	executerest	1	1.0	0	\N	2021-05-18 11:11:10.791	2
1689	1686:org.jbpm.process.longrest.executerest:410ded7d-78e7-43ee-9dcc-2d56c2dfec1e	11896	2021-05-18 11:11:22.811	rhpam_1.1.2-SNAPSHOT	mlazar	\N	1686	org.jbpm.process.longrest.executerest	executerest	1689	executerest	1	1.0	0	\N	2021-05-18 11:11:10.915	2
1690	1686:org.jbpm.process.longrest.executerest:4fc1126b-87ff-4186-b755-cc451d16f316	3014	2021-05-18 11:11:25.915	rhpam_1.1.2-SNAPSHOT	mlazar	operationFailed	1686	org.jbpm.process.longrest.executerest	executerest	1690	executerest	1	1.0	0	\N	2021-05-18 11:11:22.901	3
1691	1686:org.jbpm.process.longrest.executerest:d1a8821c-33f6-4c8d-9abe-4dc2b6817b5c	90	2021-05-18 11:11:26.103	rhpam_1.1.2-SNAPSHOT	mlazar	\N	1686	org.jbpm.process.longrest.executerest	executerest	1691	executerest	1	1.0	0	\N	2021-05-18 11:11:26.013	2
1692	1686:org.jbpm.process.longrest.executerest:dcab79c3-8e02-4699-86ca-81996bd6bedb	\N	\N	rhpam_1.1.2-SNAPSHOT	mlazar	\N	1686	org.jbpm.process.longrest.executerest	executerest	1692	executerest	1	1.0	0	\N	2021-05-18 11:11:26.199	1
\.


--
-- Name: processinstancelog processinstancelog_pkey; Type: CONSTRAINT; Schema: public; Owner: bpm
--

ALTER TABLE ONLY public.processinstancelog
    ADD CONSTRAINT processinstancelog_pkey PRIMARY KEY (id);


--
-- Name: idx_pinstlog_correlation; Type: INDEX; Schema: public; Owner: bpm
--

CREATE INDEX idx_pinstlog_correlation ON public.processinstancelog USING btree (correlationkey);


--
-- Name: idx_pinstlog_duration; Type: INDEX; Schema: public; Owner: bpm
--

CREATE INDEX idx_pinstlog_duration ON public.processinstancelog USING btree (duration);


--
-- Name: idx_pinstlog_end_date; Type: INDEX; Schema: public; Owner: bpm
--

CREATE INDEX idx_pinstlog_end_date ON public.processinstancelog USING btree (end_date);


--
-- Name: idx_pinstlog_extid; Type: INDEX; Schema: public; Owner: bpm
--

CREATE INDEX idx_pinstlog_extid ON public.processinstancelog USING btree (externalid);


--
-- Name: idx_pinstlog_outcome; Type: INDEX; Schema: public; Owner: bpm
--

CREATE INDEX idx_pinstlog_outcome ON public.processinstancelog USING btree (outcome);


--
-- Name: idx_pinstlog_parentpinstid; Type: INDEX; Schema: public; Owner: bpm
--

CREATE INDEX idx_pinstlog_parentpinstid ON public.processinstancelog USING btree (parentprocessinstanceid);


--
-- Name: idx_pinstlog_pid; Type: INDEX; Schema: public; Owner: bpm
--

CREATE INDEX idx_pinstlog_pid ON public.processinstancelog USING btree (processid);


--
-- Name: idx_pinstlog_pinstedescr; Type: INDEX; Schema: public; Owner: bpm
--

CREATE INDEX idx_pinstlog_pinstedescr ON public.processinstancelog USING btree (processinstancedescription);


--
-- Name: idx_pinstlog_pinstid; Type: INDEX; Schema: public; Owner: bpm
--

CREATE INDEX idx_pinstlog_pinstid ON public.processinstancelog USING btree (processinstanceid);


--
-- Name: idx_pinstlog_pname; Type: INDEX; Schema: public; Owner: bpm
--

CREATE INDEX idx_pinstlog_pname ON public.processinstancelog USING btree (processname);


--
-- Name: idx_pinstlog_pversion; Type: INDEX; Schema: public; Owner: bpm
--

CREATE INDEX idx_pinstlog_pversion ON public.processinstancelog USING btree (processversion);


--
-- Name: idx_pinstlog_start_date; Type: INDEX; Schema: public; Owner: bpm
--

CREATE INDEX idx_pinstlog_start_date ON public.processinstancelog USING btree (start_date);


--
-- Name: idx_pinstlog_status; Type: INDEX; Schema: public; Owner: bpm
--

CREATE INDEX idx_pinstlog_status ON public.processinstancelog USING btree (status);


--
-- Name: idx_pinstlog_user_identity; Type: INDEX; Schema: public; Owner: bpm
--

CREATE INDEX idx_pinstlog_user_identity ON public.processinstancelog USING btree (user_identity);


--
-- PostgreSQL database dump complete
--

