database.sql

--
-- PostgreSQL database dump
--

SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';


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 serial NOT NULL,
    description text
);


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

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('acctype', 'id'), 5, true);


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

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


--
-- Name: awards_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dez
--

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('awards', 'id'), 25, true);


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

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


--
-- Name: bookcategories_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dez
--

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('bookcategories', 'id'), 7, true);


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

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


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

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


--
-- Name: books_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dez
--

SELECT pg_catalog.setval('books_id_seq', 148, true);


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

CREATE TABLE booktags (
    bookid integer,
    tag integer
);


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

CREATE TABLE events (
    id serial NOT NULL,
    name text,
    "location" text,
    whn timestamp(0) without time zone
);


--
-- Name: events_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dez
--

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('events', 'id'), 1, false);


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

CREATE TABLE games (
    id serial NOT NULL,
    name text,
    connect text
);


--
-- Name: games_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dez
--

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('games', 'id'), 5, true);


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

CREATE TABLE groups (
    groupname character varying(20) NOT NULL,
    description text
);


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

CREATE TABLE menu (
    id serial NOT NULL,
    title text NOT NULL,
    parent integer,
    menuorder integer,
    target text,
    title_cy text,
    permission text
);


--
-- Name: menu_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dez
--

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('menu', 'id'), 37, true);


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

CREATE TABLE news (
    id serial NOT NULL,