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

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


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

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


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

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


--
-- 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,
    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: arthur
--

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

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

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


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

CREATE TABLE booktags (
    bookid integer,
    tag integer
);


--
-- Name: events; Type: TABLE; Schema: public; Owner: chckens; 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: chckens
--

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


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

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


--
-- 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,
    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: 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),
    expiry timestamp(0) without time zone DEFAULT (now() + '1 mon'::interval)
);


--
-- Name: news_id_seq; Type: SEQUENCE SET; Schema: public; Owner: chckens
--

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('news', 'id'), 13, true);


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

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


--
-- Name: pagemap_id_seq; Type: SEQUENCE SET; Schema: public; Owner: arthur
--

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('pagemap', 'id'), 34, true);


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

CREATE TABLE pastebin (
    id serial NOT NULL,
    created timestamp(0) without time zone DEFAULT now(),
    username character varying(50),
    code text,
    highlighted_code text,
    "language" character varying(10),
    retain_til timestamp(0) with time zone DEFAULT ('now'::text)::timestamp(0) with time zone
);


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

CREATE TABLE pastebin_comment (
    id integer,
    line integer,
    username character varying(50),
    created timestamp(0) without time zone,
    "comment" text
);


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

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('pastebin', 'id'), 27, true);


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

CREATE TABLE redirect (
    id serial NOT NULL,
    from_uri text,
    to_uri text
);


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

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('redirect', 'id'), 18, true);


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

CREATE TABLE "session" (
    hash text,
    username text,
    "time" timestamp(0) without time zone,
    data text,
    ip text
);


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

CREATE TABLE shorturi (
    id serial NOT NULL,
    url text,
    creator text,
    created timestamp without time zone
);


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

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('shorturi', 'id'), 16, true);


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

CREATE TABLE static (
    id serial NOT NULL,
    path text,
    summary text,
    editor text,
    pageorder integer
);


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

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('static', 'id'), 55, true);


--
-- Data for Name: acctype; Type: TABLE DATA; Schema: public; Owner: dez
--

COPY acctype (id, description) FROM stdin;
1	public
2	non-member
3	member
4	moderator
5	admin
\.


--
-- Data for Name: awards; Type: TABLE DATA; Schema: public; Owner: chckens
--

COPY awards (id, username, score, whn, who, why) FROM stdin;
\.


--
-- Data for Name: bookcategories; Type: TABLE DATA; Schema: public; Owner: chckens
--

COPY bookcategories (id, name) FROM stdin;
1	Programming
2	World Wide Web
3	Unix and Linux
4	Maths
5	Prolog
6	Java
7	Databases
\.


--
-- Data for Name: books; Type: TABLE DATA; Schema: public; Owner: arthur
--

COPY books (id, title, author, keywords, comments, onloan, loandate, publisher, loanwho, got, isbn, amazon_data, image_url) FROM stdin;
\.


--
-- Data for Name: booktags; Type: TABLE DATA; Schema: public; Owner: chckens
--

COPY booktags (bookid, tag) FROM stdin;
\.


--
-- Data for Name: events; Type: TABLE DATA; Schema: public; Owner: chckens
--

COPY events (id, name, "location", whn) FROM stdin;
\.


--
-- Data for Name: games; Type: TABLE DATA; Schema: public; Owner: chckens
--

COPY games (id, name, connect) FROM stdin;
\.


--
-- Data for Name: menu; Type: TABLE DATA; Schema: public; Owner: dez
--

COPY menu (id, title, parent, menuorder, target, title_cy, permission) FROM stdin;
7	Donations	3	\N	/About/Donations	\N	\N
17	History	3	4	/About/History	Hanes	\N
37	Options	8	6	/Tools/Options	\N	users
27	Help	22	2	/Help	\N	\N
28	Articles	22	3	/Knowledge/Articles	\N	\N
9	Library	22	\N	/Knowledge/Library	Llyfrgell	\N
2	News	\N	1	/News/	Newyddion	\N
21	Joining	3	1	/About/Joining	Ymunwch	\N
18	Staff	3	3	/About/Staff	Staff	\N
12	Room	3	2	/About/Room	Ystafell	\N
10	Mailing Lists	8	1	http://sucs.org/mailman/listinfo	Rhestri Ebost	\N
11	Web Mail	8	3	https://sucs.org/webmail/	Ebost Gwe	\N
30	ShortURI	8	2	/Tools/ShortURI	\N	\N
31	PasteBin	8	4	/Tools/PasteBin	\N	\N
13	Milliways	16	3	/Community/Milliways	Milliways	\N
26	Shop	16	5	/Community/Shop	Shop	\N
29	Planet	16	6	/Community/Planet	\N	\N
25	Bananas	16	7	/Community/Bananas	\N	\N
32	Forum	16	4	/Community/Forum/	\N	\N
19	Members	16	1	/Community/Members	Aelodau	\N
20	Societies	16	2	/Community/Societies	Cymdeithasau	\N
33	Desktop on Demand	8	5	/Tools/Desktop on Demand	\N	\N
34	Projects	16	8	/Community/Projects	\N	\N
8	Tools	\N	6	/Tools	Gwasanaethaud	users
15	Games	\N	5	/Games	Gêmau	\N
36	Blogs	\N	4	/Blogs	\N	\N
22	Knowledge	\N	7	/Knowledge	\N	\N
16	Community	\N	3	/Community	Pobl	\N
24	FAQ	22	1	/Knowledge/FAQ	\N	\N
6	Regulations	3	\N	/About/Regulations	\N	\N
3	About	\N	2	/About	Gwybodaeth	\N
\.


--
-- Data for Name: news; Type: TABLE DATA; Schema: public; Owner: chckens
--

COPY news (id, title, body, date, category, sticky, author, expiry) FROM stdin;
\.


--
-- Data for Name: pagemap; Type: TABLE DATA; Schema: public; Owner: arthur
--

COPY pagemap (id, path, depth, component) FROM stdin;
24	/Blogs	2	blogs
25	/Blogs/Admin	4	blogadmin
26	/Blogs/feed	4	blogfeed
27	/Community/Planet	4	planet
33	/Options	2	options
32	/Tools/Options	4	options
3	/News	2	news
30	/Knowledge/Library/Admin	6	libraryadmin
4	/*	1	static
1	/	0	front
29	/About/JoinEmail	4	email
34	/gallery	2	gallery
5	/Community/Milliways	4	milliways
2	/Community/Bananas	4	bananas
10	/Debug	2	debug
8	/Games	2	games
11	/Admin/Pagemap	4	pagemap
12	/Knowledge/Articles	4	contents
6	/Knowledge/Library	4	library
13	/fragments	2	contents
14	/Tools/ShortURI	4	uri
7	/Knowledge/Help	2	contents
9	/Community/Shop	2	shop
15	/Games/*	3	static
17	/Tools/PasteBin	4	pastebin
16	/Community/Forum	4	forum
18	/Community/Projects	2	projects
19	/signup	2	signup
20	/Community/MW	4	mw
21	/Debug/ID	4	id
22	/Community/Members	4	members
23	/Community/Societies	4	societies
\.


--
-- Data for Name: pastebin; Type: TABLE DATA; Schema: public; Owner: dez
--

COPY pastebin (id, created, username, code, highlighted_code, "language", retain_til) FROM stdin;
\.


--
-- Data for Name: pastebin_comment; Type: TABLE DATA; Schema: public; Owner: arthur
--

COPY pastebin_comment (id, line, username, created, "comment") FROM stdin;
\.


--
-- Data for Name: redirect; Type: TABLE DATA; Schema: public; Owner: dez
--

COPY redirect (id, from_uri, to_uri) FROM stdin;
1	/uri	/Tools/ShortURI
2	/help	/Knowledge/Help
3	/Help	/Knowledge/Help
4	/games	/Games
5	/news	/News
6	/about	/About
7	/wiki	/Knowledge/Help
8	/join	/About/Joining
9	/shop	/Community/Shop
10	/Shop	/Community/Shop
11	/pb	/Tools/PasteBin
14	/planet	/Community/Planet
15	/info	/About
16	/services	/Tools
17	/people	/Community
18	/signup.php	/signup
12	/forum	/Community/Forum
13	/punbb	/Community/Forum
\.


--
-- Data for Name: session; Type: TABLE DATA; Schema: public; Owner: arthur
--

COPY "session" (hash, username, "time", data, ip) FROM stdin;
\.


--
-- Data for Name: shorturi; Type: TABLE DATA; Schema: public; Owner: dez
--

COPY shorturi (id, url, creator, created) FROM stdin;
\.


--
-- Data for Name: static; Type: TABLE DATA; Schema: public; Owner: dez
--

COPY static (id, path, summary, editor, pageorder) FROM stdin;
\.


--
-- Name: acctype_pkey; Type: CONSTRAINT; Schema: public; Owner: dez; Tablespace: 
--

ALTER TABLE ONLY acctype
    ADD CONSTRAINT acctype_pkey PRIMARY KEY (id);


--
-- Name: awards_pkey; Type: CONSTRAINT; Schema: public; Owner: chckens; Tablespace: 
--

ALTER TABLE ONLY awards
    ADD CONSTRAINT awards_pkey PRIMARY KEY (id);


--
-- Name: bookcategories_pkey; Type: CONSTRAINT; Schema: public; Owner: chckens; Tablespace: 
--

ALTER TABLE ONLY bookcategories
    ADD CONSTRAINT bookcategories_pkey PRIMARY KEY (id);


--
-- Name: books_pkey; Type: CONSTRAINT; Schema: public; Owner: arthur; Tablespace: 
--

ALTER TABLE ONLY books
    ADD CONSTRAINT books_pkey PRIMARY KEY (id);


--
-- Name: menu_pkey; Type: CONSTRAINT; Schema: public; Owner: dez; Tablespace: 
--

ALTER TABLE ONLY menu
    ADD CONSTRAINT menu_pkey PRIMARY KEY (id);


--
-- Name: pastebin_pkey; Type: CONSTRAINT; Schema: public; Owner: dez; Tablespace: 
--

ALTER TABLE ONLY pastebin
    ADD CONSTRAINT pastebin_pkey PRIMARY KEY (id);


--
-- Name: booktags_bookid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: chckens
--

ALTER TABLE ONLY booktags
    ADD CONSTRAINT booktags_bookid_fkey FOREIGN KEY (bookid) REFERENCES books(id);


--
-- Name: booktags_tag_fkey; Type: FK CONSTRAINT; Schema: public; Owner: chckens
--

ALTER TABLE ONLY booktags
    ADD CONSTRAINT booktags_tag_fkey FOREIGN KEY (tag) REFERENCES bookcategories(id);


--
-- Name: menu_heading_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dez
--

ALTER TABLE ONLY menu
    ADD CONSTRAINT menu_heading_fkey FOREIGN KEY (parent) REFERENCES menu(id);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- Name: acctype; Type: ACL; Schema: public; Owner: dez
--

REVOKE ALL ON TABLE acctype FROM PUBLIC;
GRANT ALL ON TABLE acctype TO apache;
GRANT SELECT ON TABLE acctype TO PUBLIC;


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

REVOKE ALL ON TABLE acctype_id_seq FROM PUBLIC;
GRANT ALL ON TABLE acctype_id_seq TO apache;


--
-- Name: awards; Type: ACL; Schema: public; Owner: chckens
--

REVOKE ALL ON TABLE awards FROM PUBLIC;
GRANT ALL ON TABLE awards TO apache;
GRANT SELECT ON TABLE awards TO PUBLIC;


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

REVOKE ALL ON TABLE awards_id_seq FROM PUBLIC;
GRANT ALL ON TABLE awards_id_seq TO apache;


--
-- Name: bookcategories; Type: ACL; Schema: public; Owner: chckens
--

REVOKE ALL ON TABLE bookcategories FROM PUBLIC;
GRANT ALL ON TABLE bookcategories TO apache;
GRANT SELECT ON TABLE bookcategories TO PUBLIC;


--
-- Name: books; Type: ACL; Schema: public; Owner: arthur
--

REVOKE ALL ON TABLE books FROM PUBLIC;
GRANT ALL ON TABLE books TO apache;
GRANT SELECT ON TABLE books TO PUBLIC;


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

REVOKE ALL ON TABLE books_id_seq FROM PUBLIC;
GRANT ALL ON TABLE books_id_seq TO apache;


--
-- Name: booktags; Type: ACL; Schema: public; Owner: chckens
--

REVOKE ALL ON TABLE booktags FROM PUBLIC;
GRANT ALL ON TABLE booktags TO apache;
GRANT SELECT ON TABLE booktags TO PUBLIC;


--
-- Name: games; Type: ACL; Schema: public; Owner: chckens
--

REVOKE ALL ON TABLE games FROM PUBLIC;
GRANT ALL ON TABLE games TO apache;
GRANT SELECT ON TABLE games TO PUBLIC;


--
-- Name: games_id_seq; Type: ACL; Schema: public; Owner: chckens
--

REVOKE ALL ON TABLE games_id_seq FROM PUBLIC;
GRANT ALL ON TABLE games_id_seq TO apache;


--
-- Name: menu; Type: ACL; Schema: public; Owner: dez
--

REVOKE ALL ON TABLE menu FROM PUBLIC;
GRANT ALL ON TABLE menu TO apache;
GRANT SELECT ON TABLE menu TO PUBLIC;


--
-- Name: menu_id_seq; Type: ACL; Schema: public; Owner: dez
--

REVOKE ALL ON TABLE menu_id_seq FROM PUBLIC;
GRANT ALL ON TABLE menu_id_seq TO apache;


--
-- Name: news; Type: ACL; Schema: public; Owner: chckens
--

REVOKE ALL ON TABLE news FROM PUBLIC;
GRANT ALL ON TABLE news TO apache;
GRANT SELECT ON TABLE news TO PUBLIC;


--
-- Name: news_id_seq; Type: ACL; Schema: public; Owner: chckens
--

REVOKE ALL ON TABLE news_id_seq FROM PUBLIC;
GRANT ALL ON TABLE news_id_seq TO apache;


--
-- Name: pagemap; Type: ACL; Schema: public; Owner: arthur
--

REVOKE ALL ON TABLE pagemap FROM PUBLIC;
GRANT ALL ON TABLE pagemap TO apache;
GRANT SELECT ON TABLE pagemap TO PUBLIC;


--
-- Name: pagemap_id_seq; Type: ACL; Schema: public; Owner: arthur
--

REVOKE ALL ON TABLE pagemap_id_seq FROM PUBLIC;
GRANT ALL ON TABLE pagemap_id_seq TO apache;


--
-- Name: pastebin; Type: ACL; Schema: public; Owner: dez
--

REVOKE ALL ON TABLE pastebin FROM PUBLIC;
GRANT ALL ON TABLE pastebin TO apache;
GRANT SELECT ON TABLE pastebin TO PUBLIC;


--
-- Name: pastebin_comment; Type: ACL; Schema: public; Owner: arthur
--

REVOKE ALL ON TABLE pastebin_comment FROM PUBLIC;
GRANT SELECT ON TABLE pastebin_comment TO PUBLIC;


--
-- Name: pastebin_id_seq; Type: ACL; Schema: public; Owner: dez
--

REVOKE ALL ON TABLE pastebin_id_seq FROM PUBLIC;
GRANT ALL ON TABLE pastebin_id_seq TO apache;


--
-- Name: redirect; Type: ACL; Schema: public; Owner: dez
--

REVOKE ALL ON TABLE redirect FROM PUBLIC;
GRANT ALL ON TABLE redirect TO apache;
GRANT SELECT ON TABLE redirect TO PUBLIC;


--
-- Name: redirect_id_seq; Type: ACL; Schema: public; Owner: dez
--

REVOKE ALL ON TABLE redirect_id_seq FROM PUBLIC;
GRANT ALL ON TABLE redirect_id_seq TO apache;


--
-- Name: session; Type: ACL; Schema: public; Owner: arthur
--

REVOKE ALL ON TABLE "session" FROM PUBLIC;
GRANT ALL ON TABLE "session" TO apache;
GRANT INSERT ON TABLE "session" TO PUBLIC;


--
-- Name: shorturi; Type: ACL; Schema: public; Owner: dez
--

REVOKE ALL ON TABLE shorturi FROM PUBLIC;
GRANT ALL ON TABLE shorturi TO apache;
GRANT SELECT ON TABLE shorturi TO PUBLIC;


--
-- Name: shorturi_id_seq; Type: ACL; Schema: public; Owner: dez
--

REVOKE ALL ON TABLE shorturi_id_seq FROM PUBLIC;
GRANT ALL ON TABLE shorturi_id_seq TO apache;


--
-- Name: static; Type: ACL; Schema: public; Owner: dez
--

REVOKE ALL ON TABLE static FROM PUBLIC;
GRANT ALL ON TABLE static TO apache;
GRANT SELECT ON TABLE static TO PUBLIC;


--
-- Name: static_id_seq; Type: ACL; Schema: public; Owner: dez
--

REVOKE ALL ON TABLE static_id_seq FROM PUBLIC;
GRANT ALL ON TABLE static_id_seq TO apache;


--
-- PostgreSQL database dump complete
--