--
-- PostgreSQL database dump
--

SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;

SET SESSION AUTHORIZATION 'postgres';

--
-- TOC entry 4 (OID 2200)
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;


SET SESSION AUTHORIZATION 'root';

SET search_path = public, pg_catalog;

--
-- TOC entry 5 (OID 19284)
-- Name: entry_id_seq; Type: SEQUENCE; Schema: public; Owner: root
--

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


--
-- TOC entry 6 (OID 19284)
-- Name: entry_id_seq; Type: ACL; Schema: public; Owner: root
--

REVOKE ALL ON TABLE entry_id_seq FROM PUBLIC;
GRANT ALL ON TABLE entry_id_seq TO apache;


SET SESSION AUTHORIZATION 'root';

--
-- TOC entry 7 (OID 19286)
-- Name: entry_es_id_seq; Type: SEQUENCE; Schema: public; Owner: root
--

CREATE SEQUENCE entry_es_id_seq
    INCREMENT BY 1
    MAXVALUE 2147483647
    NO MINVALUE
    CACHE 1;


--
-- TOC entry 8 (OID 19286)
-- Name: entry_es_id_seq; Type: ACL; Schema: public; Owner: root
--

REVOKE ALL ON TABLE entry_es_id_seq FROM PUBLIC;
GRANT ALL ON TABLE entry_es_id_seq TO apache;


SET SESSION AUTHORIZATION 'root';

--
-- TOC entry 13 (OID 19288)
-- Name: entries; Type: TABLE; Schema: public; Owner: root
--

CREATE TABLE entries (
    entry_id integer DEFAULT nextval('entry_id_seq'::text) NOT NULL,
    date date,
    headline character varying(255),
    para01 text,
    image character varying(255),
    caption character varying(255),
    "type" smallint,
    link character varying(255),
    link_description character varying(255),
    document character varying(255),
    document_description character varying(255),
    hide boolean,
    icon character varying(255),
    url character varying(255)
);


--
-- TOC entry 14 (OID 19288)
-- Name: entries; Type: ACL; Schema: public; Owner: root
--

REVOKE ALL ON TABLE entries FROM PUBLIC;
GRANT ALL ON TABLE entries TO PUBLIC;
GRANT ALL ON TABLE entries TO apache;


SET SESSION AUTHORIZATION 'root';

--
-- TOC entry 15 (OID 19294)
-- Name: entries_es; Type: TABLE; Schema: public; Owner: root
--

CREATE TABLE entries_es (
    entry_id integer DEFAULT nextval('entry_es_id_seq'::text) NOT NULL,
    date date,
    headline character varying(255),
    para01 text,
    image character varying(255),
    caption character varying(255),
    "type" smallint,
    link character varying(255),
    link_description character varying(255),
    document character varying(255),
    document_description character varying(255),
    hide boolean,
    icon character varying(255),
    url character varying(255)
);


--
-- TOC entry 16 (OID 19294)
-- Name: entries_es; Type: ACL; Schema: public; Owner: root
--

REVOKE ALL ON TABLE entries_es FROM PUBLIC;
GRANT ALL ON TABLE entries_es TO apache;


SET SESSION AUTHORIZATION 'root';

--
-- TOC entry 9 (OID 19300)
-- Name: thread_id_seq; Type: SEQUENCE; Schema: public; Owner: root
--

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


--
-- TOC entry 10 (OID 19300)
-- Name: thread_id_seq; Type: ACL; Schema: public; Owner: root
--

REVOKE ALL ON TABLE thread_id_seq FROM PUBLIC;
GRANT ALL ON TABLE thread_id_seq TO PUBLIC;


SET SESSION AUTHORIZATION 'root';

--
-- TOC entry 11 (OID 19302)
-- Name: thread_es_id_seq; Type: SEQUENCE; Schema: public; Owner: root
--

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


--
-- TOC entry 12 (OID 19302)
-- Name: thread_es_id_seq; Type: ACL; Schema: public; Owner: root
--

REVOKE ALL ON TABLE thread_es_id_seq FROM PUBLIC;
GRANT ALL ON TABLE thread_es_id_seq TO PUBLIC;


SET SESSION AUTHORIZATION 'root';

--
-- TOC entry 17 (OID 19304)
-- Name: threads; Type: TABLE; Schema: public; Owner: root
--

CREATE TABLE threads (
    thread_id integer DEFAULT nextval('thread_id_seq'::text) NOT NULL,
    entry_id integer NOT NULL,
    date date,
    headline character varying(255),
    para01 text,
    image character varying(255),
    caption character varying(255),
    "type" smallint,
    link character varying(255),
    link_description text,
    document character varying(255),
    document_description text,
    icon character varying(255),
    url character varying(255)
);


--
-- TOC entry 18 (OID 19304)
-- Name: threads; Type: ACL; Schema: public; Owner: root
--

REVOKE ALL ON TABLE threads FROM PUBLIC;
GRANT ALL ON TABLE threads TO PUBLIC;


SET SESSION AUTHORIZATION 'root';

--
-- TOC entry 19 (OID 19310)
-- Name: threads_es; Type: TABLE; Schema: public; Owner: root
--

CREATE TABLE threads_es (
    thread_id integer DEFAULT nextval('thread_es_id_seq'::text) NOT NULL,
    entry_id integer NOT NULL,
    date date,
    headline character varying(255),
    para01 text,
    image character varying(255),
    caption character varying(255),
    "type" smallint,
    link character varying(255),
    link_description text,
    document character varying(255),
    document_description text,
    icon character varying(255),
    url character varying(255)
);


--
-- TOC entry 20 (OID 19310)
-- Name: threads_es; Type: ACL; Schema: public; Owner: root
--

REVOKE ALL ON TABLE threads_es FROM PUBLIC;
GRANT ALL ON TABLE threads_es TO PUBLIC;


SET SESSION AUTHORIZATION 'root';

--
-- TOC entry 21 (OID 19316)
-- Name: entries_pkey; Type: CONSTRAINT; Schema: public; Owner: root
--

ALTER TABLE ONLY entries
    ADD CONSTRAINT entries_pkey PRIMARY KEY (entry_id);


--
-- TOC entry 22 (OID 19318)
-- Name: entries_es_pkey; Type: CONSTRAINT; Schema: public; Owner: root
--

ALTER TABLE ONLY entries_es
    ADD CONSTRAINT entries_es_pkey PRIMARY KEY (entry_id);


--
-- TOC entry 23 (OID 19320)
-- Name: threads_pkey; Type: CONSTRAINT; Schema: public; Owner: root
--

ALTER TABLE ONLY threads
    ADD CONSTRAINT threads_pkey PRIMARY KEY (thread_id);


--
-- TOC entry 24 (OID 19322)
-- Name: threads_es_pkey; Type: CONSTRAINT; Schema: public; Owner: root
--

ALTER TABLE ONLY threads_es
    ADD CONSTRAINT threads_es_pkey PRIMARY KEY (thread_id);


SET SESSION AUTHORIZATION 'postgres';

--
-- TOC entry 3 (OID 2200)
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';