 -- 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;
 

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

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

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


ALTER TABLE public.author OWNER TO ben;

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

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


ALTER TABLE public.author_id_seq OWNER TO ben;

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

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


ALTER TABLE public.comment OWNER TO ben;

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

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


ALTER TABLE public.comment_opinion_seq OWNER TO ben;

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

ALTER SEQUENCE public.comment_opinion_seq OWNED BY public.comment.opinion;


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

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


ALTER TABLE public.excerpt OWNER TO ben;

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

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