--
-- PostgreSQL database dump
--

-- Dumped from database version 9.6.23
-- Dumped by pg_dump version 9.6.23

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_with_oids = false;

--
-- Name: jiveuser; Type: TABLE; Schema: public; Owner: core
--

CREATE TABLE public.jiveuser (
    userid bigint NOT NULL,
    username character varying(254) NOT NULL,
    passwordhash text NOT NULL,
    name character varying(100),
    firstname character varying(100),
    lastname character varying(100),
    namevisible integer NOT NULL,
    email character varying(254) NOT NULL,
    emailvisible integer NOT NULL,
    userenabled integer NOT NULL,
    creationdate bigint NOT NULL,
    modificationdate bigint NOT NULL,
    lastloggedin bigint DEFAULT 0 NOT NULL,
    lastprofileupdate bigint DEFAULT 0 NOT NULL,
    usertype integer DEFAULT 0 NOT NULL,
    federated integer DEFAULT 0 NOT NULL,
    visible integer DEFAULT 1 NOT NULL,
    status integer DEFAULT 6 NOT NULL,
    initiallogindate bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.jiveuser OWNER TO core;

--
-- Data for Name: jiveuser; Type: TABLE DATA; Schema: public; Owner: core
--

COPY public.jiveuser (userid, username, passwordhash, name, firstname, lastname, namevisible, email, emailvisible, userenabled, creationdate, modificationdate, lastloggedin, lastprofileupdate, usertype, federated, visible, status, initiallogindate) FROM stdin;
3	docverse_SHRJKZCNU53	INVALID		\N	\N	0	no@mail.com	0	1	0	0	0	0	0	0	0	6	0
2001	jivewebhooksystemuser	INVALID	\N	\N	\N	0	jivewebhooksystemuser@jive_id	0	1	1632864266612	1632864266612	0	1632864266612	0	0	0	6	0
2002	doranchak@cox.net	4d30395d0f7f2f3d7b5b44e293b1d0fba346b2735806cb0023322a4a0cc829d33eaf99d92cd7170bc8d031ac	\N	Dave	O	1	doranchak@cox.net	1	1	1632928306835	1632928406593	1632928406593	1632928309777	0	0	1	6	1632928306827
1	admin	4d30395d915ccfff01ab6d2c7e03817bd51e22523a9ed2d33a7fdab149ca3cf333ad69ec9f3cd8e4b89d0eb8	Administrator	\N	\N	1	doranchak@gmail.com	1	1	1632858086650	1632944410233	1632944410233	1632858086650	0	0	1	6	1632858086646
\.


--
-- Name: jiveuser jiveuser_pk; Type: CONSTRAINT; Schema: public; Owner: core
--

ALTER TABLE ONLY public.jiveuser
    ADD CONSTRAINT jiveuser_pk PRIMARY KEY (userid);


--
-- Name: jiveuser jiveuser_username_key; Type: CONSTRAINT; Schema: public; Owner: core
--

ALTER TABLE ONLY public.jiveuser
    ADD CONSTRAINT jiveuser_username_key UNIQUE (username);


--
-- Name: jiveuser_cdate_idx; Type: INDEX; Schema: public; Owner: core
--

CREATE INDEX jiveuser_cdate_idx ON public.jiveuser USING btree (creationdate);


--
-- Name: jiveuser_eex_idx; Type: INDEX; Schema: public; Owner: core
--

CREATE INDEX jiveuser_eex_idx ON public.jiveuser USING btree (visible, userenabled, usertype);


--
-- Name: jiveuser_em_idx; Type: INDEX; Schema: public; Owner: core
--

CREATE INDEX jiveuser_em_idx ON public.jiveuser USING btree (email);


--
-- Name: jiveuser_lcun; Type: INDEX; Schema: public; Owner: core
--

CREATE INDEX jiveuser_lcun ON public.jiveuser USING btree (lower((username)::text));


--
-- Name: jvusr_mdfctndt_idx; Type: INDEX; Schema: public; Owner: core
--

CREATE INDEX jvusr_mdfctndt_idx ON public.jiveuser USING btree (modificationdate);


--
-- PostgreSQL database dump complete
--