Skip to content
Snippets Groups Projects
database.sql 348 KiB
Newer Older
--
-- 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
);


ALTER TABLE public.acctype OWNER TO dez;

--
-- 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: chckens; Tablespace: 
--

CREATE TABLE awards (
    id serial 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 SET; Schema: public; Owner: chckens
SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('awards', 'id'), 12, true);
-- Name: books; Type: TABLE; Schema: public; Owner: chckens; 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
);


ALTER TABLE public.books OWNER TO chckens;

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

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

ALTER TABLE public.books_id_seq OWNER TO chckens;
Denis Walker's avatar
Denis Walker committed
--
-- Name: books_id_seq; Type: SEQUENCE SET; Schema: public; Owner: chckens
SELECT pg_catalog.setval('books_id_seq', 148, true);
-- Name: games; Type: TABLE; Schema: public; Owner: chckens; Tablespace: 
--

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


ALTER TABLE public.games OWNER TO chckens;
-- Name: games_id_seq; Type: SEQUENCE SET; Schema: public; Owner: chckens
SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('games', 'id'), 5, true);
--
-- Name: menu; Type: TABLE; Schema: public; Owner: dez; Tablespace: 
--

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


ALTER TABLE public.menu OWNER TO dez;

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

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('menu', 'id'), 34, true);
-- Name: news; Type: TABLE; Schema: public; Owner: chckens; Tablespace: 
--

CREATE TABLE news (
    id serial NOT NULL,
    title text,
    body text,
    date timestamp(0) without time zone,
    category character varying(15),
    sticky boolean,
    author character varying(20)
ALTER TABLE public.news OWNER TO chckens;

-- Name: news_id_seq; Type: SEQUENCE SET; Schema: public; Owner: chckens
SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('news', 'id'), 5, true);
-- Name: pagemap; Type: TABLE; Schema: public; Owner: arthur; Tablespace: 
--

CREATE TABLE pagemap (
    id serial NOT NULL,
    path text,
    depth integer,
    component text
);


ALTER TABLE public.pagemap OWNER TO arthur;

-- Name: pagemap_id_seq; Type: SEQUENCE SET; Schema: public; Owner: arthur
SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('pagemap', 'id'), 19, true);


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

CREATE TABLE pastebin (
Loading
Loading full blame...