Skip to content
Snippets Groups Projects
database.sql 21.8 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
);


--
-- 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
Denis Walker's avatar
Denis Walker committed
SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('awards', 'id'), 25, true);


--
-- Name: bookcategories; Type: TABLE; Schema: public; Owner: dez; Tablespace: 
Denis Walker's avatar
Denis Walker committed
--

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


--
-- Name: bookcategories_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dez
Denis Walker's avatar
Denis Walker committed
--

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


Denis Walker's avatar
Denis Walker committed
--
-- Name: booktags; Type: TABLE; Schema: public; Owner: dez; Tablespace: 
Denis Walker's avatar
Denis Walker committed
--

CREATE TABLE booktags (
    bookid integer,
    tag integer
);


--
-- Name: events; Type: TABLE; Schema: public; Owner: dez; Tablespace: 
Denis Walker's avatar
Denis Walker committed
--

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
Denis Walker's avatar
Denis Walker committed
--

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,
Denis Walker's avatar
Denis Walker committed
    parent integer,
    menuorder integer,
    target text,
    title_cy text,
    permission text
);


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

Denis Walker's avatar
Denis Walker committed
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,
    title text,
    body text,
    date timestamp(0) without time zone,
    category character varying(15),
    sticky boolean,
Denis Walker's avatar
Denis Walker committed
    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: dez
Denis Walker's avatar
Denis Walker committed
SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('news', 'id'), 13, true);
-- Name: pagemap; Type: TABLE; Schema: public; Owner: dez; Tablespace: 
--

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


--
-- Name: pagemap_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dez
Denis Walker's avatar
Denis Walker committed
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,
Denis Walker's avatar
Denis Walker committed
    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
);


Denis Walker's avatar
Denis Walker committed
--
-- Name: pastebin_comment; Type: TABLE; Schema: public; Owner: dez; Tablespace: 
Denis Walker's avatar
Denis Walker committed
--

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

Denis Walker's avatar
Denis Walker committed
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: dez; 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
--

Denis Walker's avatar
Denis Walker committed
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
--

Denis Walker's avatar
Denis Walker committed
SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('static', 'id'), 55, true);
--
-- Name: usergroup; Type: TABLE; Schema: public; Owner: dez; Tablespace: 
--

CREATE TABLE usergroup (
    username character varying(20),
    groupname character varying(20)
);


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

CREATE TABLE users (
    username character varying(20) NOT NULL,
    realname text,
    "password" text
);


--
-- 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: dez
--

COPY awards (id, username, score, whn, who, why) FROM stdin;
-- Data for Name: bookcategories; Type: TABLE DATA; Schema: public; Owner: dez
Denis Walker's avatar
Denis Walker committed
--

COPY bookcategories (id, name) FROM stdin;
-- Data for Name: books; Type: TABLE DATA; Schema: public; Owner: dez
--

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: dez
Denis Walker's avatar
Denis Walker committed
--

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


--
-- Data for Name: events; Type: TABLE DATA; Schema: public; Owner: dez
Denis Walker's avatar
Denis Walker committed
--

COPY events (id, name, "location", whn) FROM stdin;
-- Data for Name: games; Type: TABLE DATA; Schema: public; Owner: dez
--

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


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

COPY groups (groupname, description) FROM stdin;
admin	Administrator
editor	Content Editor
\.


--
-- 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
Denis Walker's avatar
Denis Walker committed
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
Denis Walker's avatar
Denis Walker committed
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: dez
Denis Walker's avatar
Denis Walker committed
COPY news (id, title, body, date, category, sticky, author, expiry) FROM stdin;
-- Data for Name: pagemap; Type: TABLE DATA; Schema: public; Owner: dez
--

COPY pagemap (id, path, depth, component) FROM stdin;
Denis Walker's avatar
Denis Walker committed
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
Denis Walker's avatar
Denis Walker committed
30	/Knowledge/Library/Admin	6	libraryadmin
4	/*	1	static
1	/	0	front
Denis Walker's avatar
Denis Walker committed
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
Denis Walker's avatar
Denis Walker committed
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: dez
Denis Walker's avatar
Denis Walker committed
--

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
Denis Walker's avatar
Denis Walker committed
12	/forum	/Community/Forum
13	/punbb	/Community/Forum
-- Data for Name: session; Type: TABLE DATA; Schema: public; Owner: dez
--

COPY "session" (hash, username, "time", data, ip) FROM stdin;
f0c1ec724757a75c5b4b8c90e78d0eca	dez	2007-11-27 18:17:02	s:0:"";	192.168.1.20
\.


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


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

COPY usergroup (username, groupname) FROM stdin;
dez	admin
\.


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

COPY users (username, realname, "password") FROM stdin;
dez	Denis Walker	$1$nfV.LL7A$fIgekLFUJzxMqvXEcsgpb.
--
-- Name: acctype_pkey; Type: CONSTRAINT; Schema: public; Owner: dez; Tablespace: 
--

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


Denis Walker's avatar
Denis Walker committed
--
-- Name: awards_pkey; Type: CONSTRAINT; Schema: public; Owner: dez; Tablespace: 
Denis Walker's avatar
Denis Walker committed
--

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


--
-- Name: bookcategories_pkey; Type: CONSTRAINT; Schema: public; Owner: dez; Tablespace: 
Denis Walker's avatar
Denis Walker committed
--

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


--
-- Name: books_pkey; Type: CONSTRAINT; Schema: public; Owner: dez; Tablespace: 
Denis Walker's avatar
Denis Walker committed
--

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


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

ALTER TABLE ONLY groups
    ADD CONSTRAINT groups_pkey PRIMARY KEY (groupname);


--
-- 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: users_pkey; Type: CONSTRAINT; Schema: public; Owner: dez; Tablespace: 
--

ALTER TABLE ONLY users
    ADD CONSTRAINT users_pkey PRIMARY KEY (username);


--
-- Name: booktags_bookid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dez
Denis Walker's avatar
Denis Walker committed
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: dez
Denis Walker's avatar
Denis Walker committed
--

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: usergroup_groupname_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dez
--

ALTER TABLE ONLY usergroup
    ADD CONSTRAINT usergroup_groupname_fkey FOREIGN KEY (groupname) REFERENCES groups(groupname);


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

ALTER TABLE ONLY usergroup
    ADD CONSTRAINT usergroup_username_fkey FOREIGN KEY (username) REFERENCES users(username);


--
-- 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;
REVOKE ALL ON TABLE acctype FROM dez;
GRANT ALL ON TABLE acctype TO dez;
GRANT ALL ON TABLE acctype TO apache;
Denis Walker's avatar
Denis Walker committed
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;
REVOKE ALL ON TABLE acctype_id_seq FROM dez;
GRANT ALL ON TABLE acctype_id_seq TO dez;
GRANT ALL ON TABLE acctype_id_seq TO apache;


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

REVOKE ALL ON TABLE awards FROM PUBLIC;
REVOKE ALL ON TABLE awards FROM dez;
GRANT ALL ON TABLE awards TO dez;
GRANT ALL ON TABLE awards TO apache;
Denis Walker's avatar
Denis Walker committed
GRANT SELECT ON TABLE awards TO PUBLIC;
-- Name: awards_id_seq; Type: ACL; Schema: public; Owner: dez
--

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


--
-- Name: bookcategories; Type: ACL; Schema: public; Owner: dez
Denis Walker's avatar
Denis Walker committed
--

REVOKE ALL ON TABLE bookcategories FROM PUBLIC;
REVOKE ALL ON TABLE bookcategories FROM dez;
GRANT ALL ON TABLE bookcategories TO dez;
Denis Walker's avatar
Denis Walker committed
GRANT ALL ON TABLE bookcategories TO apache;
GRANT SELECT ON TABLE bookcategories TO PUBLIC;


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

REVOKE ALL ON TABLE books FROM PUBLIC;
REVOKE ALL ON TABLE books FROM dez;
GRANT ALL ON TABLE books TO dez;
GRANT ALL ON TABLE books TO apache;
Denis Walker's avatar
Denis Walker committed
GRANT SELECT ON TABLE books TO PUBLIC;
-- Name: books_id_seq; Type: ACL; Schema: public; Owner: dez
--

REVOKE ALL ON TABLE books_id_seq FROM PUBLIC;
REVOKE ALL ON TABLE books_id_seq FROM dez;
GRANT ALL ON TABLE books_id_seq TO dez;
GRANT ALL ON TABLE books_id_seq TO apache;
-- Name: booktags; Type: ACL; Schema: public; Owner: dez
Denis Walker's avatar
Denis Walker committed
--

REVOKE ALL ON TABLE booktags FROM PUBLIC;
REVOKE ALL ON TABLE booktags FROM dez;
GRANT ALL ON TABLE booktags TO dez;
Denis Walker's avatar
Denis Walker committed
GRANT ALL ON TABLE booktags TO apache;
GRANT SELECT ON TABLE booktags TO PUBLIC;
-- Name: games; Type: ACL; Schema: public; Owner: dez
--

REVOKE ALL ON TABLE games FROM PUBLIC;
REVOKE ALL ON TABLE games FROM dez;
GRANT ALL ON TABLE games TO dez;
GRANT ALL ON TABLE games TO apache;
Denis Walker's avatar
Denis Walker committed
GRANT SELECT ON TABLE games TO PUBLIC;
-- Name: games_id_seq; Type: ACL; Schema: public; Owner: dez
--

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


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

REVOKE ALL ON TABLE groups FROM PUBLIC;
REVOKE ALL ON TABLE groups FROM dez;
GRANT ALL ON TABLE groups TO dez;
GRANT ALL ON TABLE groups TO apache;


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

REVOKE ALL ON TABLE menu FROM PUBLIC;
REVOKE ALL ON TABLE menu FROM dez;
GRANT ALL ON TABLE menu TO dez;
GRANT ALL ON TABLE menu TO apache;
Denis Walker's avatar
Denis Walker committed
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;
REVOKE ALL ON TABLE menu_id_seq FROM dez;
GRANT ALL ON TABLE menu_id_seq TO dez;
GRANT ALL ON TABLE menu_id_seq TO apache;


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

REVOKE ALL ON TABLE news FROM PUBLIC;
REVOKE ALL ON TABLE news FROM dez;
GRANT ALL ON TABLE news TO dez;
GRANT ALL ON TABLE news TO apache;
Denis Walker's avatar
Denis Walker committed
GRANT SELECT ON TABLE news TO PUBLIC;
-- Name: news_id_seq; Type: ACL; Schema: public; Owner: dez
--

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


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

REVOKE ALL ON TABLE pagemap FROM PUBLIC;
REVOKE ALL ON TABLE pagemap FROM dez;
GRANT ALL ON TABLE pagemap TO dez;
GRANT ALL ON TABLE pagemap TO apache;
Denis Walker's avatar
Denis Walker committed
GRANT SELECT ON TABLE pagemap TO PUBLIC;
-- Name: pagemap_id_seq; Type: ACL; Schema: public; Owner: dez
--

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


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

REVOKE ALL ON TABLE pastebin FROM PUBLIC;
REVOKE ALL ON TABLE pastebin FROM dez;
GRANT ALL ON TABLE pastebin TO dez;
GRANT ALL ON TABLE pastebin TO apache;
Denis Walker's avatar
Denis Walker committed
GRANT SELECT ON TABLE pastebin TO PUBLIC;


--
-- Name: pastebin_comment; Type: ACL; Schema: public; Owner: dez
Denis Walker's avatar
Denis Walker committed
--

REVOKE ALL ON TABLE pastebin_comment FROM PUBLIC;
REVOKE ALL ON TABLE pastebin_comment FROM dez;
GRANT ALL ON TABLE pastebin_comment TO dez;
Denis Walker's avatar
Denis Walker committed
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;
REVOKE ALL ON TABLE pastebin_id_seq FROM dez;
GRANT ALL ON TABLE pastebin_id_seq TO dez;
GRANT ALL ON TABLE pastebin_id_seq TO apache;


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

REVOKE ALL ON TABLE redirect FROM PUBLIC;
REVOKE ALL ON TABLE redirect FROM dez;
GRANT ALL ON TABLE redirect TO dez;
GRANT ALL ON TABLE redirect TO apache;
Denis Walker's avatar
Denis Walker committed
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;
REVOKE ALL ON TABLE redirect_id_seq FROM dez;
GRANT ALL ON TABLE redirect_id_seq TO dez;
GRANT ALL ON TABLE redirect_id_seq TO apache;


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

REVOKE ALL ON TABLE "session" FROM PUBLIC;
REVOKE ALL ON TABLE "session" FROM dez;
GRANT ALL ON TABLE "session" TO dez;
GRANT ALL ON TABLE "session" TO apache;
Denis Walker's avatar
Denis Walker committed
GRANT INSERT ON TABLE "session" TO PUBLIC;


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

REVOKE ALL ON TABLE shorturi FROM PUBLIC;
REVOKE ALL ON TABLE shorturi FROM dez;
GRANT ALL ON TABLE shorturi TO dez;
GRANT ALL ON TABLE shorturi TO apache;
Denis Walker's avatar
Denis Walker committed
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;
REVOKE ALL ON TABLE shorturi_id_seq FROM dez;
GRANT ALL ON TABLE shorturi_id_seq TO dez;
GRANT ALL ON TABLE shorturi_id_seq TO apache;


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

REVOKE ALL ON TABLE static FROM PUBLIC;
REVOKE ALL ON TABLE static FROM dez;
GRANT ALL ON TABLE static TO dez;
GRANT ALL ON TABLE static TO apache;
Denis Walker's avatar
Denis Walker committed
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;
REVOKE ALL ON TABLE static_id_seq FROM dez;
GRANT ALL ON TABLE static_id_seq TO dez;