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