Newer
Older
3001
3002
3003
3004
3005
3006
3007
3008
3009
3010
3011
3012
3013
3014
3015
3016
3017
3018
3019
3020
3021
3022
3023
3024
3025
3026
3027
3028
3029
3030
3031
3032
3033
3034
3035
3036
3037
3038
3039
3040
3041
3042
3043
3044
3045
3046
3047
3048
3049
3050
3051
3052
3053
3054
3055
3056
3057
3058
3059
504 https://sucs.org/About/Room zephyr 2012-02-20 16:23:25.240019
505 https://docs.google.com/a/swansea-union.co.uk/spreadsheet/viewform?formkey=dHNDSzRGbXFDRktUdXpBZWlpM2FmTmc6MQ#gid=0 tswsl1989 2012-02-28 11:11:27.685411
506 https://forums.virtualbox.org/viewtopic.php?t=9918 tswsl1989 2012-03-05 23:58:40.236944
507 http://bearwindows.boot-land.net/100601.zip tswsl1989 2012-03-06 00:03:32.993124
508 http://git.fedorahosted.org/git/?p=gfs2-utils.git;a=blob;f=gfs2/libgfs2/fs_ops.c;h=a72394fb8fa212e8c8c869a02a930cb826c864ab;hb=HEAD#l405 welshbyte 2012-03-13 16:02:51.83143
509 https://www.google.co.uk/search?q=sqrt%28cos%28x%29%29*cos%28300x%29%2Bsqrt%28abs%28x%29%29-0.7%29*%284-x*x%29^0.01%2C+sqrt%286-x^2%29%2C+-sqrt%286-x^2%29+from+-4.5+to+4.5 welshbyte 2012-03-16 15:35:58.329448
510 http://www.sucs.org/~cmckenna/UEL/year2/Chris_McKenna_book_project.pdf cmckenna 2012-04-19 20:17:34.878219
511 http://swansea-union.co.uk/support/content/827043/student_forums/student_forum_-_08052012/ tswsl1989 2012-06-01 15:19:55.084967
512 http://swansea-union.co.uk/support/content/833413/student_forums/student_forum_-_31052012/ tswsl1989 2012-06-01 15:20:17.521725
513 http://www.google.co.uk/search?hl=en&sa=N&tbs=simg:CAESaxppCxCo1NgEGggIBggICBcIPQwLELCMpwgaPAo6CAESFK8C-QH7AbMCtwLaAr4EnAW9BMkEGiDiqY9MO4RqJeK6WGa2dfmZtTt9CKCjZWXLaev97USYiQwLEI6u_1ggaCgoICAESBLO6EBMM&tbm=isch&ei=vFnfT-yZGaT80QXEmrXhCg&ved=0CDgQsw4&biw=1466&bih=879 dez 2012-06-18 17:40:50.415985
514 https://sucs.org/News/Downtime%25202012-07-08 tswsl1989 2012-06-29 15:48:59.082436
517 http://www.guardian.co.uk/business/2012/jul/11/o2-mobile-network-crash?newsfeed=true ed 2012-07-11 21:46:18.1118
515 https://maps.google.com/maps?hl=en&ll=47.063179,15.475085&spn=0.000571,0.000862&gl=uk&t=k&z=20 edmund 2012-06-29 20:26:33.84682
516 https://maps.google.com/maps?hl=en&ll=47.056518,15.4557&spn=0.000286,0.000431&gl=uk&t=k&z=21 edmund 2012-06-29 20:42:32.856499
518 http://www.ebay.co.uk/itm/4GB-2-x-2GB-Kingston-PC3200-Reg-ECC-KTH-DL385-4G-PC3200R-DDR400-Registered-RAM-/251047238571?pt=UK_Computing_ComputerComponents_MemoryRAM_JN&hash=item3a7394dbab#ht_3544wt_1037 kais58 2012-08-14 17:24:05.96091
519 http://4.bp.blogspot.com/-UywIpePhD3c/UAF6LeeNPVI/AAAAAAAADG8/GpquDp6Em7M/s1600/shut_the_fuck_up_trollcat.jpg tswsl1989 2012-08-21 22:47:12.910642
520 http://www.ebay.co.uk/itm/Hardy-Chusan-Palm-Trachycarpus-fortunei-/110938898235?_trksid=p3284.m263&_trkparms=algo%3DSIC%26its%3DI%26itu%3DUCI%252BIA%252BUA%252BFICS%252BUFI%26otn%3D21%26pmod%3D270946538225%26ps%3D54 cmckenna 2012-08-30 10:53:43.325741
521 https://docs.google.com/spreadsheet/viewform?formkey=dGswR0N2WmZ2eG5LbWJWQ1Jmd1duLVE6MQ zephyr 2012-09-13 14:27:15.643878
522 http://git.kernel.org/?p=linux%2Fkernel%2Fgit%2Ftorvalds%2Flinux.git&a=search&h=HEAD&st=author&s=Andrew+Price welshbyte 2012-10-23 10:33:35.981424
523 http://git.fedorahosted.org/cgit/gfs2-utils.git/log/?qt=author&q=Andrew+Price welshbyte 2012-10-23 10:35:38.367701
524 http://carto.metro.free.fr/cartes/metro-tram-london/index.php?gpslat=51.466912&gpslon=-0.162414&zoom=4 cmckenna 2012-10-24 01:32:04.916691
525 http://lmgtfy.com/?q=use+command+line+arguments+C tswsl1989 2012-11-16 16:01:48.425005
526 https://groups.google.com/forum/?fromgroups=#!topic/vertx/gnpGSxX7PzI welshbyte 2013-01-08 17:41:11.834615
527 http://www.ec.kingston.com/ecom/configurator_new/modelsinfo.asp?SysID=62074&root=us&LinkBack=http%3A%2F%2Fwww.kingston.com&Capacity=8+GB&Speed=Speed&DIMM=3&ErrCheck=3&Rank=3&Chip=Chip rollercow 2013-01-11 11:37:05.796332
528 http://www.rowlandjones.co.uk/searchproperties/description.php?position=302&image_number=1&page=retail&name=30%20Beach%20Street,%20Swansea%20SA1%203JP kais58 2013-01-15 11:37:27.989798
529 http://www.rowlandjones.co.uk/searchproperties/description.php?position=274&page=office&name=Upper%20Floors%20-%20New%20Street,%20Neath%20SA11%201RT&PHPSESSID=c8b0942e0f410fb2b503402ca9ab89fa kais58 2013-01-15 11:41:14.141546
530 http://www.slipperybrick.com/wp-content/uploads/2007/02/80-brick-phone.jpg firefury 2013-02-07 09:00:55.331868
533 http://cache2.allpostersimages.com/p/LRG/7/789/TMEI000Z/posters/train-accident-at-the-gare-montparnasse-paris-1895.jpg cmckenna 2013-09-27 16:45:03.996314
531 http://geoguessr.com/?s=eyJ0b3RhbFBvaW50cyI6NzU5MywidmVyc2lvbiI6MSwicm91bmRzIjpbWyJyb3VuZCIsImxhdCIsImxuZyIsImdMYXQiLCJnTG5nIl0sWzEsLTIwLjA2MzY2MSwyMy40ODQ3MzAwMDAwMDAwMTMsLTIxLjg0MTEwNDc0OTA2NTAzMiwxMzMuNjU5NjY3OTY4NzVdLFsyLC0yOC4xODYzODksLTUzLjA0ODM0MDk5OTk5OTk5LDQzLjgzNDUyNjc4MjIzNjg0LC0xMDguNDEzMDg1OTM3NV0sWzMsNDguNjEwNTg2LDQ0LjM2NzE5MzAwMDAwMDA0LDU0LjkyNzE0MTg2NDU0NjQ1LDMxLjAyNTM5MDYyNV0sWzQsNTQuODczNTQxLDU2LjA5ODM5OTk5OTk5OTk3LDU1LjMyOTE0NDQwODQwNTA3LDM4LjY0OTkwMjM0Mzc1XSxbNSw1MS40MDU0MzcsMzAuMDU4MTUwMDAwMDAwMDcsNDguNDU4MzUxODgyODA4NjYsMzUuMDQ2Mzg2NzE4NzVdXX0%3D cmckenna 2013-06-05 02:51:23.180574
532 https://maps.google.co.uk/maps?q=Grand+Canyon+Village,+AZ,+USA&hl=en&ll=36.101492,-112.089729&spn=0.009033,0.021136&sll=32.634785,-16.934996&sspn=0.018829,0.042272&oq=g&hnear=Grand+Canyon+Village,+Coconino,+Arizona,+United+States&t=m&z=16&layer=c&cbll=36.101444,-112.089622&panoid=Lxj4JNOelFEYnVLhU1omhw&cbp=12,349.58,,0,11.88 cmckenna 2013-06-15 16:34:48.411686
534 http://www.raib.gov.uk/publications/investigation_reports/reports_2009/report122009.cfm cmckenna 2013-10-15 20:46:00.059942
535 https://en.wikipedia.org/wiki/Wikipedia:WikiProject_London/Wiki_takes_the_Tube cmckenna 2013-11-03 01:13:33.964906
536 http://sucs.org/~tswsl1989/Debates/#UKDC2013 tswsl1989 2013-11-11 23:14:35.06126
537 http://www.bbc.co.uk/rd/blog/2013/11/speakerthon-uploading-voice-samples-from-the-radio-4-archive-to-wikipedia cmckenna 2013-11-14 14:49:46.214568
538 http://www.ebuyer.com/451036-startech-usb-802-11n-dual-band-wireless-network-adapter-300-mbps-high-power-usb300wn2x2d?utm_source=google&utm_medium=products&gclid=CLP71YDBt7wCFSgKwwodenMAMQ rjames93 2014-02-06 12:33:05.252519
539 http://google.com/ kn100 2014-02-09 22:30:42.629275
540 https://mega.co.nz/#!4QAmyD6Y!Wgetwt-n_dHl9RsMR1ZKAM7-w4pMg79FrBcqskt1kjc kn100 2014-02-13 12:28:48.946039
541 http://sucs.org/uri/8I kn100 2014-02-13 12:30:22.823001
542 http://zahidraja.co.uk/index.php/expenses-scandal-jog-on-worst-smear-campaign-ever/ tswsl1989 2014-03-17 15:11:11.934763
543 https://sucs.org/~rjames93/Notes/PH-353%20Computational%20Physics/presentation/presentation.pdf rjames93 2014-04-08 10:17:46.454452
544 http://www.openstreetmap.org/?mlat=51.60943&mlon=-3.97790#map=19/51.60943/-3.97791&layers=N tswsl1989 2014-04-11 11:06:46.225128
545 https://imranh.co.uk imranh 2014-04-25 20:53:04.460859
546 http://www.swansea-union.co.uk/mysociety/sucs/ imranh 2014-09-16 15:33:59.397234
547 http://www.berghaus.com/mens-cornice-iii-gore-tex-walking-jacket/421016.html?dwvar_421016_color=BP6&cgid=mens-gore-tex-jackets rjames93 2014-10-22 12:25:24.287194
548 http://open.spotify.com/user/foshjedi2004/playlist/5THNoJYvWbqcMdxxuPiY7X foshjedi2004 2014-10-23 14:22:50.294955
549 https://www.youtube.com/watch?v=gpDbvlAI_A0&t=1m40s tswsl1989 2014-10-30 10:01:22.687668
550 http://sucs.org/stats/cacti/graph_image.php?action=zoom&local_graph_id=108&rra_id=2&view_type=&graph_start=1414504933&graph_end=1415107936&graph_height=120&graph_width=500&title_font_size=10 kais58 2014-11-04 14:02:51.235336
551 http://www.ukofequestria.co.uk ripp_ 2014-11-05 08:29:51.871109
552 https://www.google.co.uk/maps/dir/51.6250603,-3.9414492/51.622345,-4.0121702/@51.6174062,-4.0491802,12z/data=!3m1!4b1!4m2!4m1!3e0 ripp_ 2014-11-05 10:45:59.724377
553 http://i.guim.co.uk/static/w-1920/h--/q-95/sys-images/Guardian/Pix/pictures/2014/1/31/1391186220186/e0e9a3fa-6b6d-4e33-b295-ba76426ad637-1020x574.jpeg arthur 2014-11-06 14:35:54.221159
554 http://i.guim.co.uk/static/w-1920/h--/q-95/sys-images/Guardian/Pix/pictures/2014/1/31/1391186096469/b2d3ce6b-db50-4fad-ac55-460f1cbebddb-1020x574.jpeg arthur 2014-11-06 14:36:12.395925
555 http://www.tsarbomba.org/images/tsar%20bom%20explosion.jpg firefury 2014-11-06 15:21:40.625071
556 https://www.facebook.com/SwanseaUniversityComputerSociety andy 2014-11-07 21:38:05.92888
557 https://www.facebook.com/SwanseaUniversityComputerSociety/ andy 2014-11-07 21:38:27.570925
558 https://www.facebook.com/SwanseaUniversityComputerSociety/Timeline andy 2014-11-07 21:38:36.395898
559 https://www.teepublic.com/show/103195-two-aspies-dont-walk-into-a-bar.-white-text?utm_source=designer%20&utm_medium=social%20&utm_campaign= rjames93 2014-12-01 09:46:35.039269
560 https://sucs.org/News/Room%2520closure%2520%2526%2520Service%2520outage%2520on%2520Wed%252014%2520Jan%25202015 tswsl1989 2015-01-13 14:56:18.581759
561 https://sucs.org/Community/Stream andy 2015-02-27 16:48:29.517427
562 https://www.facebook.com/events/387252841458053/ tswsl1989 2015-03-11 10:58:20.815297
--
-- Name: shorturi_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dez
--
SELECT pg_catalog.setval('shorturi_id_seq', 562, true);
--
-- Data for Name: static; Type: TABLE DATA; Schema: public; Owner: dez
--
COPY static (id, path, summary, editor, pageorder) FROM stdin;
7 /Knowledge/Help/SUCS Services/Accessing your email/Configuring OS X Mail How to get your SUCS mail in OS X Mail elsmorian \N
47 /Tools/Desktop on Demand tswsl1989 \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 chckens \N
5 /Knowledge/Help/SUCS Services/Administering a mailing list How to administer a mailing list (for societies) tswsl1989 \N
94 /fragments/Junk rollercow \N
68 /Knowledge/Articles/Nokia 770 Why you should totally buy a 770 now! dez \N
11 /Knowledge/Help/SUCS Services/Jabber Server HOWTO A guide to registering on and using the SUCS Jabber server. tswsl1989 \N
10 /Knowledge/Help/SUCS Services/Connecting to GuestNet Using your own computer in the SUCS room rollercow \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
82 /Games/Team Fortress 2 chckens \N
107 /Community/Stream/High Embedded player for High quality stream tswsl1989 \N
16 /Knowledge/Help/SUCS Services/Using Milliways/Setting up Milliways Scripts How to set up some basic Milliways scripts for colour coding, etc. cmckenna \N
8 /Knowledge/Help/SUCS Services/Accessing your email/Configuring Thunderbird How to get your SUCS mail in Thunderbird rollercow \N
39 /Games/Armagetron Advanced 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) rollercow \N
1 /Knowledge/Help/SUCS Services/Printing in the SUCS room Printing from your own computer in the SUCS room rollercow \N
13 /Knowledge/Help/SUCS Services/Using Desktop on Demand Accessing the SUCS <em>Desktop on Demand</em> system rollercow \N
25 /Knowledge/Help/SUCS Services Help on Services rollercow \N
20 /Knowledge/Help/SUCS Services/Using mailing lists How to subscribe to mailing lists and use them dez \N
79 /Knowledge/Help/SUCS Services/Using Milliways/Milliways Etiquette How to get along with the crowd pwb \N
23 /About/Room-secondary chckens \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
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
36 /Games/Half-Life 2 Team Deathmatch chckens \N
84 /Community/Talks/20070320jk dez \N
19 /Knowledge/Help/SUCS Services/Using WebDAV Accessing your SUCS disk space using WebDAV arthur \N
75 /Knowledge/Help/Admin Tools/Groups What are "Groups"? dez \N
43 /Knowledge/Help/Admin Tools/GuestNET Registration wedge \N
45 /Community/Members dez \N
17 /Knowledge/Help/SUCS Services/Using SVN How to set up a personal Subversion repository at SUCS rollercow \N
22 /About/Room rjames93 \N
54 /Knowledge/Help/Windows to Linux rollercow \N
65 /Community/AGM-2007-03-13 frosty \N
38 /Games/Unreal Tournament chckens \N
35 /Games/Counter-Strike Source frosty \N
37 /Games/Unreal Tournament 2004 frosty \N
66 /About/AGM-2007-03-13 frosty \N
52 /Games/Half-Life 2: Deathmatch frosty \N
46 /Community/Societies dez \N
3122
3123
3124
3125
3126
3127
3128
3129
3130
3131
3132
3133
3134
3135
3136
3137
3138
3139
3140
3141
3142
3143
3144
3145
3146
3147
3148
3149
3150
3151
3152
3153
3154
3155
3156
3157
3158
3159
3160
3161
3162
3163
3164
3165
3166
3167
3168
3169
3170
3171
3172
3173
3174
3175
3176
3177
3178
3179
3180
3181
3182
3183
3184
3185
3186
3187
3188
3189
3190
3191
3192
3193
3194
3195
3196
3197
3198
3199
3200
3201
3202
3203
3204
3205
3206
3207
3208
3209
56 /Knowledge/Help/Windows to Linux/How Windows login differs rollercow \N
57 /Knowledge/Help/Windows to Linux/Email Setup rollercow \N
106 /About/Donations zephyr \N
18 /Knowledge/Help/SUCS Services/Using Samba Assigning your SUCS disk space to a logical drive letter rollercow \N
67 /fragments/Projects-secondary dez \N
58 /Knowledge/Articles/Lambda Calculus An introduction to lambda calculus for Haskell programmers pwb \N
70 /Knowledge/Help/UNIX Commands and Concepts dez \N
41 /Knowledge/Help/Program Advisory/Reading an arbitrarily long line in C pwb \N
42 /Knowledge/Help/Program Advisory welshbyte \N
59 /Community/Forum chckens \N
85 /Community/Talks/20070320frosty dez \N
49 /Knowledge chckens \N
60 /Knowledge/Help/Program Advisory/make Using make to simplify compiling C programs pwb \N
96 /Community/Talks/2007-11-07/sits dez \N
86 /Community/Talks/20070320jean dez \N
71 /Knowledge/Help/UNIX Commands and Concepts/Text Editors/joe rollercow \N
28 /fragments/Games chckens \N
63 /About/AGM 2007 dez \N
53 /About/Regulations rollercow \N
98 /Knowledge/Help/SUCS Services/Using the SUCS Tools How to install and use the SUCS Tools for Windows and Mac OS X dez \N
87 /Community/Talks/20070320talyn256 dez \N
88 /Community/Talks/20070320sits dez \N
89 /Community/Talks/20070320worldinsideme dez \N
90 /Community/Talks/20070320elsmorian dez \N
73 /Knowledge/Help/UNIX Commands and Concepts/Text Editors/vi rollercow \N
91 /Community/Talks/20070320rollercow dez \N
114 /Community/Shame tswsl1989 \N
14 /Knowledge/Help/SUCS Services/Using Milliways How to use Milliways (The SUCS BBS) firefury \N
101 /Community/Talks/2008-10-16/eclipse eclipse \N
111 /Games/Minecraft tswsl1989 \N
126 /Knowledge/Help/SUCS Services/Using your web space/PHP Using PHP to create dynamic websites arthur \N
44 /fragments/Front dez \N
78 /Getting Started imranh \N
55 /About imranh \N
24 /Community imranh \N
128 /Games/OpenTTD imranh \N
74 /About/Constitution imranh \N
80 /Knowledge/Help/SUCS Services/Using Milliways/Milliways Lexicon Terms and phrases regularly used on Milliways cmckenna \N
76 /Knowledge/Help/SUCS Services/Using your web space How to create your own website and host it on your SUCS account dez \N
95 /Conference chckens \N
34 /fragments/Join dez \N
77 /Knowledge/Help/SUCS Services/Using your web space/Creating a photo gallery Installing Gallery 2 on your website dez \N
81 /Knowledge/Help/SUCS Services/Configuring Proxy Settings chckens \N
102 /Community/Talks/2008-10-16/talyn256 eclipse \N
83 /Community/Talks/20070320welshbyte dez \N
92 /Community/Talks/test dez \N
6 /Knowledge/Help/SUCS Services/Accessing your email Generic mail settings chckens \N
93 /Community/Talks/20071107welshbyte frosty \N
99 /Community/Talks/2008-10-16/worldinsideme eclipse \N
40 /fragments/Milliways dez \N
100 /Games/Wolfenstein Enemy Territory foshjedi2004 \N
62 /Games/LAN Events Turned URLs into links chckens \N
104 /Knowledge/Help/UNIX Commands and Concepts/Text Editors/nano tswsl1989 \N
105 /Knowledge/Help/UNIX Commands and Concepts/Control Keys dez \N
108 /Community/Stream/FAQ tswsl1989 \N
103 /Knowledge/Help/UNIX Commands and Concepts/Mail Clients/alpine dez \N
72 /Knowledge/Help/UNIX Commands and Concepts/Mail Clients/pine dez \N
110 /Community/Stream/Low eclipse \N
113 /Knowledge/Help/SUCS Services/Jabber Server HOWTO/Jabber with Pidgin chckens \N
112 /Knowledge/Help/UNIX Commands and Concepts/The UNIX Filesystem chckens \N
12 /Knowledge/Help/SUCS Services/Jabber Server HOWTO/Jabber with Gaim How to set up Jabber using Pidgin chckens \N
129 /Community/Talks/2012-10-18/hantudemon tswsl1989 \N
127 /Community/Talks/2012-02-16/kais58 kais58 \N
122 /Community/Talks/2011-11-01/itsme dez \N
115 /Community/Talks/2011-11-01/tswsl1989-1 dez \N
116 /Community/Talks/2011-11-01/mistake dez \N
117 /Community/Talks/2011-11-01/eclipse dez \N
118 /Community/Talks/2011-11-01/tswsl1989-2 dez \N
119 /Community/Talks/2011-11-01/rollercow dez \N
120 /Community/Talks/hantudemon tswsl1989 \N
124 /Community/Talks/2011-02-24/mistake2 dez \N
123 /Community/Talks/2011-02-24/mistake dez \N
121 /Community/Talks/2010-10-14/tswsl1989 tswsl1989 \N
125 /Community/Stream/External How to view our video stream in an external player tswsl1989 \N
48 /Tools kais58 \N
131 /Community/Talks/2014-03-20/eclipse imranh \N
133 /Community/Talks/2014-03-20/mistake imranh \N
134 /Community/Talks/2014-03-20/grepwood imranh \N
132 /Community/Talks/2014-03-20/lightwind imranh \N
64 /Community/Talks Test imranh \N
61 /About/History imranh \N
135 /stats Statistics imranh \N
21 /About/Staff imranh \N
69 /About/Joining you can use other revision control systems than Subversion imranh \N
97 /Admin Admin landing page eclipse \N
136 /Vote/No Manifesto imranh \N
50 /Knowledge/FAQ imranh \N
109 /Community/Stream imranh \N
--
-- Name: static_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dez
--
SELECT pg_catalog.setval('static_id_seq', 136, true);
--
-- Name: acctype_pkey; Type: CONSTRAINT; Schema: public; Owner: dez; Tablespace:
--
ALTER TABLE ONLY acctype
ADD CONSTRAINT acctype_pkey PRIMARY KEY (id);
3228
3229
3230
3231
3232
3233
3234
3235
3236
3237
3238
3239
3240
3241
3242
3243
3244
3245
3246
3247
3248
3249
3250
3251
3252
3253
3254
3255
3256
3257
3258
3259
3260
3261
3262
3263
3264
3265
3266
3267
--
-- 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: election_votes_pkey; Type: CONSTRAINT; Schema: public; Owner: dez; Tablespace:
--
ALTER TABLE ONLY election_votes
ADD CONSTRAINT election_votes_pkey PRIMARY KEY (username);
--
-- Name: junk_pkey; Type: CONSTRAINT; Schema: public; Owner: eclipse; Tablespace:
--
ALTER TABLE ONLY inventory
ADD CONSTRAINT junk_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: books_id_key; Type: INDEX; Schema: public; Owner: arthur; Tablespace:
CREATE UNIQUE INDEX books_id_key ON books USING btree (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);
3307
3308
3309
3310
3311
3312
3313
3314
3315
3316
3317
3318
3319
3320
3321
3322
3323
3324
3325
3326
3327
3328
3329
--
-- 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;
--
-- Name: acctype_id_seq; Type: ACL; Schema: public; Owner: dez
--
REVOKE ALL ON SEQUENCE acctype_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE acctype_id_seq FROM dez;
GRANT ALL ON SEQUENCE acctype_id_seq TO dez;
GRANT ALL ON SEQUENCE 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;
GRANT SELECT ON TABLE awards TO rjames93;
-- Name: awards_id_seq; Type: ACL; Schema: public; Owner: chckens
REVOKE ALL ON SEQUENCE awards_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE awards_id_seq FROM chckens;
GRANT ALL ON SEQUENCE awards_id_seq TO chckens;
GRANT ALL ON SEQUENCE awards_id_seq TO dez;
GRANT ALL ON SEQUENCE 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;
-- 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;
3386
3387
3388
3389
3390
3391
3392
3393
3394
3395
3396
3397
3398
3399
3400
3401
3402
3403
3404
3405
3406
3407
3408
3409
3410
3411
3412
3413
3414
3415
3416
3417
GRANT SELECT ON TABLE books TO crystal;
--
-- Name: books_id_seq; Type: ACL; Schema: public; Owner: arthur
--
REVOKE ALL ON SEQUENCE books_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE books_id_seq FROM arthur;
GRANT ALL ON SEQUENCE books_id_seq TO arthur;
GRANT ALL ON SEQUENCE 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;
--
-- Name: election_candidates; Type: ACL; Schema: public; Owner: dez
--
REVOKE ALL ON TABLE election_candidates FROM PUBLIC;
REVOKE ALL ON TABLE election_candidates FROM dez;
GRANT ALL ON TABLE election_candidates TO dez;
GRANT ALL ON TABLE election_candidates TO vote;
GRANT ALL ON TABLE election_candidates TO apache;
-- Name: election_votes; Type: ACL; Schema: public; Owner: dez
REVOKE ALL ON TABLE election_votes FROM PUBLIC;
REVOKE ALL ON TABLE election_votes FROM dez;
GRANT ALL ON TABLE election_votes TO dez;
GRANT ALL ON TABLE election_votes TO apache;
GRANT ALL ON TABLE election_votes TO vote;
-- 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;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE games TO kais58;
-- Name: games_id_seq; Type: ACL; Schema: public; Owner: chckens
3447
3448
3449
3450
3451
3452
3453
3454
3455
3456
3457
3458
3459
3460
3461
3462
3463
3464
3465
3466
3467
3468
3469
3470
3471
3472
REVOKE ALL ON SEQUENCE games_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE games_id_seq FROM chckens;
GRANT ALL ON SEQUENCE games_id_seq TO chckens;
GRANT ALL ON SEQUENCE games_id_seq TO apache;
GRANT ALL ON SEQUENCE games_id_seq TO dez;
GRANT ALL ON SEQUENCE games_id_seq TO kais58;
--
-- Name: inventory; Type: ACL; Schema: public; Owner: eclipse
--
REVOKE ALL ON TABLE inventory FROM PUBLIC;
REVOKE ALL ON TABLE inventory FROM eclipse;
GRANT ALL ON TABLE inventory TO eclipse;
GRANT ALL ON TABLE inventory TO apache;
--
-- Name: inventory_id_seq; Type: ACL; Schema: public; Owner: eclipse
--
REVOKE ALL ON SEQUENCE inventory_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE inventory_id_seq FROM eclipse;
GRANT ALL ON SEQUENCE inventory_id_seq TO eclipse;
GRANT ALL ON SEQUENCE inventory_id_seq 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;
--
-- Name: menu_id_seq; Type: ACL; Schema: public; Owner: dez
--
REVOKE ALL ON SEQUENCE menu_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE menu_id_seq FROM dez;
GRANT ALL ON SEQUENCE menu_id_seq TO dez;
GRANT ALL ON SEQUENCE 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;
--
-- Name: news_id_seq; Type: ACL; Schema: public; Owner: chckens
REVOKE ALL ON SEQUENCE news_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE news_id_seq FROM chckens;
GRANT ALL ON SEQUENCE news_id_seq TO chckens;
GRANT ALL ON SEQUENCE news_id_seq TO dez;
GRANT ALL ON SEQUENCE 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;
-- Name: pagemap_id_seq; Type: ACL; Schema: public; Owner: arthur
REVOKE ALL ON SEQUENCE pagemap_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE pagemap_id_seq FROM arthur;
GRANT ALL ON SEQUENCE pagemap_id_seq TO arthur;
GRANT ALL ON SEQUENCE pagemap_id_seq TO apache;
GRANT ALL ON SEQUENCE 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;
--
-- Name: pastebin_id_seq; Type: ACL; Schema: public; Owner: dez
--
REVOKE ALL ON SEQUENCE pastebin_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE pastebin_id_seq FROM dez;
GRANT ALL ON SEQUENCE pastebin_id_seq TO dez;
GRANT ALL ON SEQUENCE pastebin_id_seq TO apache;
--
-- Name: poems; Type: ACL; Schema: public; Owner: tswsl1989
--
REVOKE ALL ON TABLE poems FROM PUBLIC;
REVOKE ALL ON TABLE poems FROM tswsl1989;
GRANT ALL ON TABLE poems TO tswsl1989;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE poems TO apache;
GRANT SELECT,INSERT,UPDATE ON TABLE poems TO dez;
--
-- 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;
--
-- Name: redirect_id_seq; Type: ACL; Schema: public; Owner: dez
--
REVOKE ALL ON SEQUENCE redirect_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE redirect_id_seq FROM dez;
GRANT ALL ON SEQUENCE redirect_id_seq TO dez;
GRANT ALL ON SEQUENCE 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;
GRANT SELECT ON TABLE session TO mw;
--
-- 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 SEQUENCE shorturi_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE shorturi_id_seq FROM dez;
GRANT ALL ON SEQUENCE shorturi_id_seq TO dez;
GRANT ALL ON SEQUENCE 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 SEQUENCE static_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE static_id_seq FROM dez;
GRANT ALL ON SEQUENCE static_id_seq TO dez;
GRANT ALL ON SEQUENCE static_id_seq TO apache;
--
-- PostgreSQL database dump complete
--