database.sql

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

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


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: acctype; Type: TABLE; Schema: public; Owner: dez; Tablespace: 
--

CREATE TABLE acctype (
    id integer NOT NULL,
    description text
);


ALTER TABLE public.acctype OWNER TO dez;

--
-- Name: acctype_id_seq; Type: SEQUENCE; Schema: public; Owner: dez
--

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


ALTER TABLE public.acctype_id_seq OWNER TO dez;

--
-- Name: acctype_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dez
--

ALTER SEQUENCE acctype_id_seq OWNED BY acctype.id;


--
-- Name: awards; Type: TABLE; Schema: public; Owner: chckens; Tablespace: 
--

CREATE TABLE awards (
    id integer NOT NULL,
    username text,
    score integer,
    whn timestamp(0) without time zone,
    who text,
    why text
);


ALTER TABLE public.awards OWNER TO chckens;

--
-- Name: awards_id_seq; Type: SEQUENCE; Schema: public; Owner: chckens
--

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


ALTER TABLE public.awards_id_seq OWNER TO chckens;

--
-- Name: awards_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: chckens
--

ALTER SEQUENCE awards_id_seq OWNED BY awards.id;


--
-- Name: bookcategories; Type: TABLE; Schema: public; Owner: chckens; Tablespace: 
--

CREATE TABLE bookcategories (
    id integer NOT NULL,
    name text
);


ALTER TABLE public.bookcategories OWNER TO chckens;

--
-- Name: bookcategories_id_seq; Type: SEQUENCE; Schema: public; Owner: chckens
--

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


ALTER TABLE public.bookcategories_id_seq OWNER TO chckens;

--
-- Name: bookcategories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: chckens
--

ALTER SEQUENCE bookcategories_id_seq OWNED BY bookcategories.id;


--
-- Name: books; Type: TABLE; Schema: public; Owner: arthur; Tablespace: 
--

CREATE TABLE books (
    id integer DEFAULT nextval(('"books_id_seq"'::text)::regclass) NOT NULL,
    title text,
    author text,
    keywords text DEFAULT ''::text,
    comments text,
    onloan boolean,
    loandate timestamp with time zone,
    publisher text,
    loanwho text,
    got boolean,
    isbn text,
    amazon_data text,
    image_url text
);


ALTER TABLE public.books OWNER TO arthur;

--
-- Name: books_id_seq; Type: SEQUENCE; Schema: public; Owner: arthur
--

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


ALTER TABLE public.books_id_seq OWNER TO arthur;

--
-- Name: booktags; Type: TABLE; Schema: public; Owner: chckens; Tablespace: 
--

CREATE TABLE booktags (
    bookid integer,
    tag integer
);


ALTER TABLE public.booktags OWNER TO chckens;

--
-- Name: election_candidates; Type: TABLE; Schema: public; Owner: dez; Tablespace: 
--

CREATE TABLE election_candidates (
    username text,
    post text,
    manifesto_link text
);


ALTER TABLE public.election_candidates OWNER TO dez;

--
-- Name: election_votes; Type: TABLE; Schema: public; Owner: dez; Tablespace: 
--

CREATE TABLE election_votes (