Newer
Older
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
9 1
120 1
121 1
117 1
107 1
114 1
113 1
147 3
130 4
112 1
129 2
146 1
144 1
141 2
19 1
56 1
57 1
31 1
39 1
94 6
76 6
91 6
108 6
110 6
110 1
9 6
124 1
124 1
79 6
86 7
85 7
119 7
126 7
117 7
113 7
114 7
105 5
84 5
39 5
58 5
34 5
64 1
65 1
92 3
42 1
99 1
103 6
103 6
103 6
103 6
\.
--
-- Data for Name: events; Type: TABLE DATA; Schema: public; Owner: chckens
--
COPY events (id, name, "location", whn) FROM stdin;
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
\.
--
-- Data for Name: games; Type: TABLE DATA; Schema: public; Owner: chckens
--
COPY games (id, name, connect) FROM stdin;
1 Counter-Strike Source games.sucs.org:27015
3 Unreal Tournament 2004 games.sucs.org:7777
4 Unreal Tournament games.sucs.org:17777
5 Armagetron Advanced games.sucs.org:4534
2 Half-Life 2: Deathmatch games.sucs.org:27016
\.
--
-- 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
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;
7 A test for the MOTD script This is a test. How fun.<br /> 2007-02-14 14:53:37 \N f dez \N
5 Jabber server /back up <p>SUCS' Jabber server is back up (for the technically minded, we're now using Ejabberd).</p><p>There are a few changes you need to be aware of:</p><ul><li>You now need to log in using<strong> TLS</strong>, <strong>plain text auth</strong>, and <strong>your SUCS username and password</strong>.</li><li>All members can connect now - there's no need to register.</li><li>Account registration is disabled. Hence, only members can log in now.</li></ul>Happy chatting!<br /> 2006-09-25 19:55:43 \N f pwb \N
11 Scary news title #1 test 2007-11-04 19:32:46 \N f chckens 2007-12-04 19:32:46
12 Scary news title #1 test 2007-11-04 19:33:56 \N f chckens 2007-12-04 19:33:56
4 Welcome to the new SUCS website <p>As existing members will have noticed, we have created a new visual identity to go with the new SUCS logo. At the same time, we've taken the opportunity to reorganise the structure of the site and introduce some new features.<br /></p><p>You can now log onto the site using your SUCS username and password. It will always submit your details securely using HTTPS even if you enter your details on a page that wasn't loaded securely. Some tools (e.g. WebMail) still require you to log into them separately, but our long term aim is to allow you to log in once to access all the web-based tools SUCS offers. </p> 2006-09-18 15:50:56 \N t dez \N
8 Test #2 <p>This is a test of the news component's handling of hashes in the title.</p> 2007-05-14 12:10:21 \N f pwb \N
9 Chicken is tasty <p>Have you eaten chicken today?</p> 2007-05-17 00:55:27 \N f chckens 2007-05-17 01:30:56
10 Test news post <p>Posting news is fun!<br /></p> 2007-05-18 00:58:54 \N f chckens 2007-06-18 00:58:54
13 chicken / breakfast test 2007-11-04 21:47:51 \N f chckens 2007-12-04 21:47:51
6 Freshers 2006 <p>The Computer Society welcomes all Swansea freshers (and returning students)!</p> <p>SUCS is one of the university's longest-running and largest societies. In addition to providing members with a range of <a href="../About">IT services</a>, we hold regular events and socials throughout the year.</p> <p>We have our own <a href="../About/Room">computer room</a> on campus with 24 hour swipe-card access. There are usually members present through the week so feel free to stop by.</p> <p>As usual, we'll be at the freshers' fayre this year to answer any questions you may have.</p> <p>If we miss you at the fayre, then please come meet us at a social. We're usually in the quiet side of JC's from about 1pm on Fridays :-)</p> <p>Have a great year!</p> 2006-08-15 11:53:42 \N t talyn256 \N
\.
--
-- 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
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;
16 2007-04-05 13:41:33 aeternus import java.util.*;\r\n\r\nclass test {\r\n public static void main ( String args[] ) {\r\n ArrayList<String> x = new ArrayList<String>();\r\n x.add(new String("cheese"));\r\n Iterator<String> i = x.iterator();\r\n while (i.hasNext()) {\r\n String y = i.next();\r\n System.out.println(y);\r\n }\r\n\r\n }\r\n} \N JAVA \N
18 2007-04-05 13:42:39 aeternus import java.util.*;\r\n\r\nclass test {\r\n public static void main ( String args[] ) {\r\n ArrayList<String> x = new ArrayList<String>();\r\n x.add(new String("cheese"));\r\n Iterator<String> i = x.iterator();\r\n while (i.hasNext()) {\r\n String y = i.next();\r\n System.out.println(y);\r\n }\r\n\r\n }\r\n} \N JAVA \N
\.
--
-- Data for Name: pastebin_comment; Type: TABLE DATA; Schema: public; Owner: arthur
--
COPY pastebin_comment (id, line, username, created, "comment") FROM stdin;
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
\.
--
-- 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;
cfb3c5e35780d3f7735cf58c8dc0ec39 \N 2007-11-26 13:51:36 s:0:""; 86.30.243.149
5f9f77724ca91c969f3edeb45c4f16b3 \N 2007-11-26 14:14:15 s:0:""; 82.45.119.106
97ccf74d1121934106f28047f2fe9158 \N 2007-11-26 15:01:53 s:0:""; 137.44.1.200
5bc504ad9c7cd7b57b28764587a68251 tobeon 2007-11-26 15:02:09 s:0:""; 137.44.1.200
d407a2a8422feb8ce50c09472b345aad \N 2007-11-26 15:08:24 s:0:""; 65.55.165.102
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
\.
--
-- Data for Name: shorturi; Type: TABLE DATA; Schema: public; Owner: dez
--
COPY shorturi (id, url, creator, created) FROM stdin;
1 http://www.google.co.uk/ dez 2006-09-18 19:59:57.218819
2 http://www.uwshiking.org.uk rollercow 2006-09-18 20:28:32.658491
3 http://sucs.org/gihh dez 2006-09-18 20:30:35.181219
4 http://www.thebearsarecoming.co.uk/ frosty 2006-09-18 20:30:48.951419
5 http://www.dabs.com/ProductView.aspx?Quicklinx=3ZW5&CategorySelectedId=11195&NavigationKey=11195,50468&InMerch=1 psycodom 2006-09-18 21:00:04.341336
6 http://sucs.org/blogs/rollercow rollercow 2006-09-18 21:00:29.629866
7 http://www.theregister.co.uk/ dez 2006-09-18 21:01:56.56057
8 http://www.theregister.co.uk dez 2006-09-18 21:03:05.989633
9 http://groups.msn.com/_Secure/0VADnAsQaiJpu08V0CltQSGTxAyVC8OfIurT*V8SR7evS65vSl9FMCO*cGfpCGTZf1EUrj!sg8jTi4EGdJsgePyh!w5En4frihSxN9c6hlYxiJYbAI3TjO50jRHZ09rXV/getwellsoonHAMMOND.jpg chckens 2006-09-21 15:51:08.958125
10 http://www.google.com jonhurlock 2006-09-22 20:37:17.57498
11 http://www.bbc.co.uk/ dez 2006-09-23 15:15:32.760333
12 http://www.tobeon.co.uk tobeon 2006-09-23 15:41:23.36563
13 http://www.awsome.com/therasd/asdsad.php tobeon 2006-09-23 15:41:39.430555
14 https://beta.sucs.org/Tools/ShortURI davea 2006-09-24 12:22:12.485381
15 http://beta.sucs.org/pb/5 aeternus 2006-09-24 15:31:10.108538
16 http://www.shopzilla.com/mkt.xpml?mkt_id=35090400&OVRAW=asshat&OVKEY=asshat&OVMTC=standard dez 2007-02-14 00:39:13.990153
\.
--
-- Data for Name: static; Type: TABLE DATA; Schema: public; Owner: dez
--
COPY static (id, path, summary, editor, pageorder) FROM stdin;
1 /Knowledge/Help/SUCS Services/Printing in the SUCS room Printing from your own computer in the SUCS room dez \N
2 /Knowledge/Help/SUCS Services/Logging in remotely/Using Authorisation Keys to log in Log in using a key (removes need for password, using highly secure RSA algorithm) dez \N
3 /Knowledge/Help/SUCS Services/Logging in remotely/Configuring PuTTY How to login to SUCS remotely using PuTTY dez \N
4 /Knowledge/Help/SUCS Services/Logging in remotely How to login from your own computer dez \N
5 /Knowledge/Help/SUCS Services/Administering a mailing list How to administer a mailing list (for societies) dez \N
6 /Knowledge/Help/SUCS Services/Accessing your email Generic mail settings dez \N
7 /Knowledge/Help/SUCS Services/Accessing your email/Configuring OS X Mail How to get your SUCS mail in OS X Mail dez \N
8 /Knowledge/Help/SUCS Services/Accessing your email/Configuring Thunderbird How to get your SUCS mail in Thunderbird dez \N
9 /Knowledge/Help/SUCS Services/Accessing your email/Using shell-based mail clients How to get your SUCS mail via a shell dez \N
10 /Knowledge/Help/SUCS Services/Connecting to GuestNet Using your own computer in the SUCS room dez \N
11 /Knowledge/Help/SUCS Services/Jabber Server HOWTO A guide to registering on and using the SUCS Jabber server. dez \N
12 /Knowledge/Help/SUCS Services/Jabber Server HOWTO/Jabber with Gaim How to set up Jabber using Gaim dez \N
13 /Knowledge/Help/SUCS Services/Using Desktop on Demand Accessing the SUCS <em>Desktop on Demand</em> system dez \N
14 /Knowledge/Help/SUCS Services/Using Milliways How to use Milliways (The SUCS BBS) dez \N
15 /Knowledge/Help/SUCS Services/Using Milliways/Correcting your character encoding in Milliways How to be able to see all those weird / foreign characters, and the pounds sign, that get posted to Milliways occasionally dez \N
16 /Knowledge/Help/SUCS Services/Using Milliways/Setting up Milliways Scripts How to set up some basic Milliways scripts for colour coding, etc. dez \N
17 /Knowledge/Help/SUCS Services/Using SVN How to set up a personal Subversion repository at SUCS dez \N
18 /Knowledge/Help/SUCS Services/Using Samba Assigning your SUCS disk space to a logical drive letter dez \N
19 /Knowledge/Help/SUCS Services/Using WebDAV Accessing your SUCS disk space using WebDAV dez \N
20 /Knowledge/Help/SUCS Services/Using mailing lists How to subscribe to mailing lists and use them dez \N
22 /About/Room chckens \N
23 /About/Room-secondary chckens \N
44 /fragments/Front dez \N
50 /Knowledge/FAQ frosty \N
25 /Knowledge/Help/SUCS Services Help on Services dez \N
26 /fragments/Games/Counter-Strike Source chckens \N
27 /fragments/Games/Unreal Tournament frosty \N
29 /fragments/Half-Life 2 Team Deathmatch frosty \N
30 /fragments/Games/Half-Life 2 Team Deathmatch frosty \N
31 /fragments/Games/Unreal Tournament 2004 frosty \N
32 /fragments/Games/Armagetron Advanced frosty \N
33 /Games-secondary frosty \N
34 /fragments/Join dez \N
36 /Games/Half-Life 2 Team Deathmatch chckens \N
39 /Games/Armagetron Advanced chckens \N
40 /fragments/Milliways chckens \N
41 /Knowledge/Help/Program Advisory/Reading an arbitrarily long line in C wedge \N
42 /Knowledge/Help/Program Advisory wedge \N
43 /Knowledge/Help/Admin Tools/GuestNET Registration wedge \N
45 /Community/Members dez \N
47 /Tools/Desktop on Demand dez \N
48 /Tools saya \N
49 /Knowledge saya \N
24 /Community dez \N
21 /About/Staff pwb \N
35 /Games/Counter-Strike Source frosty \N
37 /Games/Unreal Tournament 2004 frosty \N
38 /Games/Unreal Tournament frosty \N
52 /Games/Half-Life 2: Deathmatch frosty \N
\.
--
-- Name: acctype_pkey; Type: CONSTRAINT; Schema: public; Owner: dez; Tablespace:
--
ALTER TABLE ONLY acctype
ADD CONSTRAINT acctype_pkey PRIMARY KEY (id);
1323
1324
1325
1326
1327
1328
1329
1330
1331
1332
1333
1334
1335
1336
1337
1338
1339
1340
1341
1342
1343
1344
1345
1346
--
-- 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);
1377
1378
1379
1380
1381
1382
1383
1384
1385
1386
1387
1388
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
--
-- 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;
REVOKE ALL ON TABLE acctype FROM dez;
GRANT ALL ON TABLE acctype TO dez;
GRANT ALL ON TABLE acctype TO apache;
1406
1407
1408
1409
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
--
-- 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: chckens
--
REVOKE ALL ON TABLE awards FROM PUBLIC;
REVOKE ALL ON TABLE awards FROM chckens;
GRANT ALL ON TABLE awards TO chckens;
GRANT ALL ON TABLE awards TO apache;
GRANT ALL ON TABLE awards TO dez;
--
-- Name: awards_id_seq; Type: ACL; Schema: public; Owner: chckens
--
REVOKE ALL ON TABLE awards_id_seq FROM PUBLIC;
REVOKE ALL ON TABLE awards_id_seq FROM chckens;
GRANT ALL ON TABLE awards_id_seq TO chckens;
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: chckens
--
REVOKE ALL ON TABLE bookcategories FROM PUBLIC;
REVOKE ALL ON TABLE bookcategories FROM chckens;
GRANT ALL ON TABLE bookcategories TO chckens;
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;
REVOKE ALL ON TABLE books FROM arthur;
GRANT ALL ON TABLE books TO arthur;
GRANT ALL ON TABLE books TO apache;
GRANT SELECT ON TABLE books TO crystal;
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;
REVOKE ALL ON TABLE books_id_seq FROM arthur;
GRANT ALL ON TABLE books_id_seq TO arthur;
GRANT ALL ON TABLE books_id_seq TO apache;
--
-- Name: booktags; Type: ACL; Schema: public; Owner: chckens
--
REVOKE ALL ON TABLE booktags FROM PUBLIC;
REVOKE ALL ON TABLE booktags FROM chckens;
GRANT ALL ON TABLE booktags TO chckens;
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;
REVOKE ALL ON TABLE games FROM chckens;
GRANT ALL ON TABLE games TO chckens;
GRANT ALL ON TABLE games TO apache;
GRANT ALL ON TABLE games TO dez;
1495
1496
1497
1498
1499
1500
1501
1502
1503
1504
1505
1506
1507
1508
1509
1510
1511
1512
1513
1514
1515
--
-- Name: games_id_seq; Type: ACL; Schema: public; Owner: chckens
--
REVOKE ALL ON TABLE games_id_seq FROM PUBLIC;
REVOKE ALL ON TABLE games_id_seq FROM chckens;
GRANT ALL ON TABLE games_id_seq TO chckens;
GRANT ALL ON TABLE games_id_seq TO apache;
GRANT ALL ON TABLE games_id_seq TO dez;
--
-- 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;
1517
1518
1519
1520
1521
1522
1523
1524
1525
1526
1527
1528
1529
1530
1531
1532
1533
1534
1535
1536
1537
--
-- 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: chckens
--
REVOKE ALL ON TABLE news FROM PUBLIC;
REVOKE ALL ON TABLE news FROM chckens;
GRANT ALL ON TABLE news TO chckens;
GRANT ALL ON TABLE news TO dez;
GRANT ALL ON TABLE news TO apache;
1539
1540
1541
1542
1543
1544
1545
1546
1547
1548
1549
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
--
-- Name: news_id_seq; Type: ACL; Schema: public; Owner: chckens
--
REVOKE ALL ON TABLE news_id_seq FROM PUBLIC;
REVOKE ALL ON TABLE news_id_seq FROM chckens;
GRANT ALL ON TABLE news_id_seq TO chckens;
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: arthur
--
REVOKE ALL ON TABLE pagemap FROM PUBLIC;
REVOKE ALL ON TABLE pagemap FROM arthur;
GRANT ALL ON TABLE pagemap TO arthur;
GRANT ALL ON TABLE pagemap TO apache;
GRANT ALL ON TABLE pagemap TO dez;
1562
1563
1564
1565
1566
1567
1568
1569
1570
1571
1572
1573
1574
1575
1576
1577
1578
1579
1580
1581
1582
--
-- Name: pagemap_id_seq; Type: ACL; Schema: public; Owner: arthur
--
REVOKE ALL ON TABLE pagemap_id_seq FROM PUBLIC;
REVOKE ALL ON TABLE pagemap_id_seq FROM arthur;
GRANT ALL ON TABLE pagemap_id_seq TO arthur;
GRANT ALL ON TABLE pagemap_id_seq TO apache;
GRANT ALL ON TABLE pagemap_id_seq TO dez;
--
-- 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;
GRANT SELECT ON TABLE pastebin TO aeternus;
GRANT SELECT ON TABLE pastebin TO PUBLIC;
--
-- Name: pastebin_comment; Type: ACL; Schema: public; Owner: arthur
--
REVOKE ALL ON TABLE pastebin_comment FROM PUBLIC;
REVOKE ALL ON TABLE pastebin_comment FROM arthur;
GRANT ALL ON TABLE pastebin_comment TO arthur;
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;
1616
1617
1618
1619
1620
1621
1622
1623
1624
1625
1626
1627
1628
1629
1630
1631
1632
1633
1634
1635
1636
--
-- 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: arthur
--
REVOKE ALL ON TABLE "session" FROM PUBLIC;
REVOKE ALL ON TABLE "session" FROM arthur;
GRANT ALL ON TABLE "session" TO arthur;
GRANT ALL ON TABLE "session" TO apache;
GRANT ALL ON TABLE "session" TO dez;
--
-- 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;
--
-- 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;
--
-- 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;
GRANT ALL ON TABLE static_id_seq TO apache;
--
-- PostgreSQL database dump complete
--