 -- PostgreSQL database dump
 --
 
--- Dumped from database version 9.5.10
--- Dumped by pg_dump version 9.5.10
+-- Dumped from database version 10.15 (Ubuntu 10.15-0ubuntu0.18.04.1)
+-- Dumped by pg_dump version 10.15 (Ubuntu 10.15-0ubuntu0.18.04.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;
 

-- Name: author; Type: TABLE; Schema: public; Owner: ben
--

CREATE TABLE author (
    id integer,
    type character varying(20),
    value text
);


ALTER TABLE author OWNER TO ben;

--
-- Name: author_id_seq; Type: SEQUENCE; Schema: public; Owner: ben
--

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


ALTER TABLE author_id_seq OWNER TO ben;

--
-- Name: comment; Type: TABLE; Schema: public; Owner: ben
--

CREATE TABLE comment (
    opinion integer NOT NULL,
    comment character varying
);


ALTER TABLE comment OWNER TO ben;

--
-- Name: comment_opinion_seq; Type: SEQUENCE; Schema: public; Owner: ben
--

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


ALTER TABLE comment_opinion_seq OWNER TO ben;

--
-- Name: comment_opinion_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ben
--

ALTER SEQUENCE comment_opinion_seq OWNED BY comment.opinion;


--
-- Name: excerpt; Type: TABLE; Schema: public; Owner: ben
--

CREATE TABLE excerpt (
    opinion integer,
    type character varying(20),
    value character varying
);


ALTER TABLE excerpt OWNER TO ben;

--
-- Name: looks; Type: TABLE; Schema: public; Owner: ben
--

CREATE TABLE looks (
    firstlook timestamp without time zone NOT NULL,
    wf_user text NOT NULL,
    rootid integer NOT NULL,

    target text NOT NULL,
    datestamp timestamp without time zone NOT NULL,
    url text NOT NULL,
    rooturl integer NOT NULL,
    iid character varying(59)
);


ALTER TABLE public.opinion OWNER TO ben;

--
-- Name: opinion_id_seq; Type: SEQUENCE; Schema: public; Owner: ben
--

CREATE SEQUENCE public.opinion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.opinion_id_seq OWNER TO ben;

--
-- Name: opinion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ben
--

ALTER SEQUENCE public.opinion_id_seq OWNED BY public.opinion.id;


--
-- Name: reference; Type: TABLE; Schema: public; Owner: ben
--

CREATE TABLE public.reference (
    opinion integer NOT NULL,
    reference text
);


ALTER TABLE public.reference OWNER TO ben;

--
-- Name: reference_opinion_seq; Type: SEQUENCE; Schema: public; Owner: ben
--

CREATE SEQUENCE public.reference_opinion_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.reference_opinion_seq OWNER TO ben;

--
-- Name: reference_opinion_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ben
--

ALTER SEQUENCE public.reference_opinion_seq OWNED BY public.reference.opinion;


--
-- Name: rooturl; Type: TABLE; Schema: public; Owner: ben
--

CREATE TABLE public.rooturl (
    id integer NOT NULL,
    rooturl text,
    rooturl_real boolean NOT NULL
);


ALTER TABLE public.rooturl OWNER TO ben;

--
-- Name: rooturl_id_seq; Type: SEQUENCE; Schema: public; Owner: ben
--

CREATE SEQUENCE public.rooturl_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.rooturl_id_seq OWNER TO ben;

--
-- Name: rooturl_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ben
--

ALTER SEQUENCE public.rooturl_id_seq OWNED BY public.rooturl.id;


--
-- Name: comment opinion; Type: DEFAULT; Schema: public; Owner: ben
--

ALTER TABLE ONLY public.comment ALTER COLUMN opinion SET DEFAULT nextval('public.comment_opinion_seq'::regclass);


--
-- Name: opinion id; Type: DEFAULT; Schema: public; Owner: ben
--

ALTER TABLE ONLY public.opinion ALTER COLUMN id SET DEFAULT nextval('public.opinion_id_seq'::regclass);


--
-- Name: reference opinion; Type: DEFAULT; Schema: public; Owner: ben
--

ALTER TABLE ONLY public.reference ALTER COLUMN opinion SET DEFAULT nextval('public.reference_opinion_seq'::regclass);


--
-- Name: rooturl id; Type: DEFAULT; Schema: public; Owner: ben
--

ALTER TABLE ONLY public.rooturl ALTER COLUMN id SET DEFAULT nextval('public.rooturl_id_seq'::regclass);


--
-- Name: comment comment_pkey; Type: CONSTRAINT; Schema: public; Owner: ben
--

ALTER TABLE ONLY public.comment
    ADD CONSTRAINT comment_pkey PRIMARY KEY (opinion);


--
-- Name: opinion opinion_pkey; Type: CONSTRAINT; Schema: public; Owner: ben
--

ALTER TABLE ONLY public.opinion
    ADD CONSTRAINT opinion_pkey PRIMARY KEY (id);


--
-- Name: reference reference_pkey; Type: CONSTRAINT; Schema: public; Owner: ben
--

ALTER TABLE ONLY public.reference
    ADD CONSTRAINT reference_pkey PRIMARY KEY (opinion);


--
-- Name: rooturl rooturl_pkey; Type: CONSTRAINT; Schema: public; Owner: ben
--

ALTER TABLE ONLY public.rooturl
    ADD CONSTRAINT rooturl_pkey PRIMARY KEY (id);


--
-- PostgreSQL database dump complete
--

