Skip to content
Snippets Groups Projects
database.sql 348 KiB
Newer Older
6960b83605f521dd0219eb1f977a0106	\N	2006-09-25 19:33:05	s:0:"";	87.106.3.38
f737e4ec8757f1b4c9af70437b2c34c5	\N	2006-09-25 19:33:06	s:0:"";	66.155.203.138
9327d47f4d4a3224847ded8e561bccb1	\N	2006-09-25 19:33:32	s:0:"";	213.105.224.13
31c4662ae8a72833b5f221e9cad81690	\N	2006-09-25 19:33:33	\N	66.249.65.163
9cbd81e684e90694574c5bc931590352	\N	2006-09-25 19:33:45	s:0:"";	65.214.44.146
d90b985434c09d2795023022a85fc34c	\N	2006-09-25 19:38:38	s:0:"";	81.103.162.49
3a999723ebc5e0a4d6d5a48e28351a03	sara	2006-09-25 19:39:04	s:0:"";	81.103.162.209
3db18cbba2ed461da775fa6c52433a1d	talyn256	2006-09-25 19:39:52	s:0:"";	81.129.88.210
f40cc27d215e66cf5f881ba678cbb863	\N	2006-09-25 19:39:53	s:0:"";	65.54.188.99
1e367beadf46b0ada90a253a6d88d704	\N	2006-09-25 19:41:13	s:0:"";	72.30.129.137
83ae92e37b19a5a6b2cbbd948f0540d3	\N	2006-09-25 19:42:13	s:0:"";	72.14.199.65
b3938e21ccf17297bb9fd72107a74124	\N	2006-09-25 19:42:14	s:0:"";	65.54.188.100
eecbbd75deee2f00052e50265409f643	\N	2006-09-25 19:42:27	s:0:"";	72.30.226.198
e2fefc0f3c41022c54209d8fa30d38d0	\N	2006-09-25 19:42:27	s:0:"";	72.30.226.198
8efd26c485beb30d7167c1ed2968b2cb	\N	2006-09-25 19:45:05	s:0:"";	66.249.65.163
11e235287e75c6354a04a00da02a90df	\N	2006-09-25 19:47:47	s:0:"";	65.214.44.29
e553b4e1bfefe3d0a03d73a8ac438c11	\N	2006-09-25 19:47:47	s:0:"";	65.214.44.29
d6c11d4886fa82d24d502c9fb4f35ebf	\N	2006-09-25 19:47:48	\N	65.214.44.29
d6c11d4886fa82d24d502c9fb4f35ebf	\N	2006-09-25 19:47:48	\N	65.214.44.29
b0413901fb06c37949138c8d4401d69e	\N	2006-09-25 19:50:15	s:0:"";	72.30.252.167
688f11f598b2d456c04425fdabb6f672	\N	2006-09-25 19:50:16	s:0:"";	72.30.107.80
ca14763b855064993a5ea320b3434e7d	\N	2006-09-25 19:50:59	s:0:"";	72.30.129.105
51835695c09a37bd22c8ff71a9a36612	\N	2006-09-25 19:51:43	s:0:"";	207.46.98.87
51835695c09a37bd22c8ff71a9a36612	\N	2006-09-25 19:51:43	s:0:"";	207.46.98.87
547a42374a8d1631273f8be25a21b32e	\N	2006-09-25 19:51:49	s:0:"";	80.192.150.82
2d502eb30dac3fab53f56d8ddc2f7060	\N	2006-09-25 19:55:48	s:0:"";	72.30.133.144
a2295dc70612c4c127e59fd76a7b701f	\N	2006-09-25 19:57:46	s:0:"";	72.30.110.35
adcb60a478a6a2f1206d06accfc92899	\N	2006-09-25 19:57:47	s:0:"";	72.30.110.35
d0296e98ce11253bf95267650ddcd327	\N	2006-09-25 20:00:23	s:0:"";	137.44.10.1
6c6d14fa2d4787f00a9cd6f7af776e38	\N	2006-09-25 20:02:17	s:0:"";	202.160.180.200
1d32f7877fb96c0d0b86966df84e5f61	\N	2006-09-25 20:07:44	s:0:"";	66.249.65.163
faa19f47550c6cce15e8e85a4af780c5	\N	2006-09-25 20:08:39	s:0:"";	72.30.103.150
c0bb2c416ca040b61941fa1b819ef5ad	\N	2006-09-25 20:08:42	s:0:"";	172.142.31.225
3da04b04a3b7fe2e0d8417b58c8f0c08	\N	2006-09-25 20:08:45	s:0:"";	216.195.21.172
a62b22eb86be7b634590ac17584f91d8	\N	2006-09-25 20:11:07	\N	202.108.11.108
4a796729b281f924b48a0c27600a5b19	\N	2006-09-25 20:12:54	s:0:"";	213.105.224.13
e9e70e162e31a57c7ae4e9ad0285f841	\N	2006-09-25 20:13:34	s:0:"";	60.181.244.221
ee211aeb90340f06a4d528e92bfc2e94	\N	2006-09-25 20:14:24	s:0:"";	207.46.98.116
fc8687f59aca7a70499c109866edeca7	\N	2006-09-25 20:16:10	s:0:"";	202.160.178.238
24ae06d4119e86a9f6cfd92ae9c9e4df	\N	2006-09-25 20:17:04	s:0:"";	65.54.188.100
ae7d1ae0cd108963704dec2767ef273e	\N	2006-09-25 20:17:44	s:0:"";	65.214.44.29
e89f67c4f3757b41225931974dc20df7	\N	2006-09-25 20:17:45	\N	65.214.44.29
20eb4e288e32a8d71c0a3c920bb34bf4	\N	2006-09-25 20:18:09	s:0:"";	209.129.150.14
c45a94fe3b8bcbbd6c5926e018e521ca	\N	2006-09-25 20:18:57	s:0:"";	83.104.48.218
7c4bd6c8939d23eca0f22a79e2b8f944	\N	2006-09-25 20:19:23	s:0:"";	83.104.48.218
a31b9b0baec1876df3257f4012488ad6	\N	2006-09-25 20:19:38	s:0:"";	83.104.48.218
e00a29d6f69205426bced8a25dcb2700	\N	2006-09-25 20:23:00	s:0:"";	24.207.252.185
df62878636ea55df7e7972205fec1f35	\N	2006-09-25 20:25:19	s:0:"";	202.108.11.106
7a3392fd50001cc45f62b965b69353eb	\N	2006-09-25 20:25:28	s:0:"";	142.106.218.85
38b7488f77dd1b6f992bd626e0bfdff7	\N	2006-09-25 20:26:40	s:0:"";	202.160.180.45
d968bc0352e1bec4b961a5b5792f16c4	\N	2006-09-25 20:30:15	s:0:"";	137.44.10.1
c1273e6095ff18e2c593b741c095b223	\N	2006-09-25 20:30:48	s:0:"";	65.54.188.100
d6ceb399e3a47db3ede5f14b6bf545cd	\N	2006-09-25 20:31:25	s:0:"";	86.132.33.125
3487e7291688cab94009755f7f1e8be2	\N	2006-09-25 20:31:28	s:0:"";	72.30.128.209
734fdb128c92efe9cd9a5297868c37e9	\N	2006-09-25 20:31:49	s:0:"";	74.6.131.201
37c69319d836604304c303fc57fb109b	\N	2006-09-25 20:32:42	s:0:"";	81.129.88.210
707909a6d2ab738ac8b76b0e00cdc091	pwb	2006-09-25 20:33:07	s:0:"";	137.44.10.31
ebf958825b791c28c744947750c7740f	\N	2006-09-25 20:34:45	s:0:"";	72.14.199.65
f230a9048266330c10e98cdeb72cc7a6	\N	2006-09-25 20:37:51	s:0:"";	202.160.179.6
8bac809fbf3f3567ef39e761b46642a2	\N	2006-09-25 20:43:03	s:0:"";	72.30.226.142
9c2e0202819e69708b5bbeba82da603f	\N	2006-09-25 20:43:57	s:0:"";	199.216.95.253
3aa25d49957809eeab51349d66b462a8	\N	2006-09-25 20:45:10	s:0:"";	65.0.102.238
84dd915adc7efc084c96733cc818a3df	wedge	2006-09-25 20:45:41	s:0:"";	81.96.205.21
6cd5b6fa9830a74662b58cd95ffb90ff	\N	2006-09-25 20:45:42	s:0:"";	213.105.224.13
a9b3d2a3dd36e65d6bdf8d7b5e089902	\N	2006-09-25 20:46:24	s:0:"";	65.54.188.98
0a8791c8640ad57227e6f9ab67002d62	\N	2006-09-25 20:46:31	s:0:"";	65.214.44.29
a6e69678998fd68e757f08a1d2414cd9	\N	2006-09-25 20:46:32	\N	65.214.44.29
fdacb0c09ec1867d7e2dd5af23b21934	\N	2006-09-25 20:46:33	s:0:"";	65.214.44.29
c3281bf44be0394bfd2627a55328fe4f	\N	2006-09-25 20:46:34	\N	65.214.44.29
7990635c9864a5bbddaa6758e5a75373	\N	2006-09-25 20:48:37	s:0:"";	82.0.222.175
599959d76b8578ade7c8e6a4b14eaf86	\N	2006-09-25 20:48:38	s:0:"";	70.48.41.207
bae28c48bea6466ace7ca3a48ca2ed9d	\N	2006-09-25 20:48:38	s:0:"";	70.48.41.207
c51595963fd066564485e14132d723bd	\N	2006-09-25 20:49:16	s:0:"";	213.105.224.13
6480898b6e1e611cbe35b8ce48f98ae4	dez	2006-09-25 20:51:52	s:0:"";	81.174.227.170
0ad77ec9d9b104c1cbcc5e9eaaf81dd9	\N	2006-09-25 20:53:46	s:0:"";	82.17.79.203
ac9b33209b6536bd64dfc3f1f72839a3	\N	2006-09-25 20:54:30	s:0:"";	72.145.43.235
ce791dedbf4480facc6fafe0a9d6f847	\N	2006-09-25 20:54:43	s:0:"";	207.46.98.89
6d9a012d5f2849c26321b228c7a9e955	\N	2006-09-25 20:54:54	s:0:"";	202.165.107.18
14b74cfaaa503acd8bb9a059fece6e36	\N	2006-09-25 20:59:24	s:0:"";	66.249.65.163
29eefa3c6837494e3b6d14d83e07deee	\N	2006-09-25 21:00:10	s:0:"";	137.44.10.1
2daded11bb97e3827896c47251f7d100	\N	2006-09-25 21:00:22	s:0:"";	66.249.65.163
d2399973605914842dc3b99d09f38973	\N	2006-09-25 21:00:32	s:0:"";	195.27.215.89
e7d2dd483df3cef9b9e7e787e4f6c489	\N	2006-09-25 21:01:23	s:0:"";	66.249.65.163
e7cc08c49efef9ecffe59e0e03401ba1	\N	2006-09-25 21:02:22	\N	66.249.65.163
b8e0b2eaefa78ef987d2341fcc35558d	akyan	2006-09-25 21:05:21	s:0:"";	80.4.13.224
b2c116ff768852ca0402543d9461d5bd	\N	2006-09-25 21:06:39	s:0:"";	202.160.178.238
c54a6c5657efd41199b71e753e4799cb	\N	2006-09-25 21:08:10	s:0:"";	72.149.230.106
b8a042a73f146f800230cbf3171816e2	\N	2006-09-25 21:08:11	s:0:"";	72.149.230.106
1f6128d7c7d1b8ae9d730f21f0dc9235	\N	2006-09-25 21:08:12	s:0:"";	72.149.230.106
69dbf641ea18d6004255a7d7e0be7046	\N	2006-09-25 21:08:13	s:0:"";	72.149.230.106
4a9bee8263aca7c3a857e18c8e14bd45	\N	2006-09-25 21:08:14	s:0:"";	72.149.230.106
fc3351cf2a97ed6d22328c9119064e59	\N	2006-09-25 21:08:15	s:0:"";	72.149.230.106
4b5af224a5a8c7ff2bf69738ad4da389	\N	2006-09-25 21:08:16	s:0:"";	72.149.230.106
5aad946196b00bcb89ff5f05ed535cfa	\N	2006-09-25 21:08:17	s:0:"";	72.149.230.106
671212b73d281520ecdcfaf0028fc31e	\N	2006-09-25 21:08:18	s:0:"";	72.149.230.106
4e54c2fdbe1ef1982df88ec4ca887c96	\N	2006-09-25 21:08:19	s:0:"";	72.149.230.106
ca08337ab37754665c10841cc3a1f81b	\N	2006-09-25 21:08:20	s:0:"";	72.149.230.106
e03338cad642f6f022de9744fee2456a	\N	2006-09-25 21:08:21	s:0:"";	72.149.230.106
4cbdd66d80bec1fcbcd201e4315d0b16	\N	2006-09-25 21:08:22	s:0:"";	72.149.230.106
8d4ce934a28c06e804b2745c612d9027	\N	2006-09-25 21:08:23	s:0:"";	72.149.230.106
ce8ae50902beab4c957d36b8e18cbb32	\N	2006-09-25 21:08:24	s:0:"";	72.149.230.106
3e9053010308ca5d3a80e224e73a5182	\N	2006-09-25 21:08:25	s:0:"";	72.149.230.106
6589b60552411550efefa849fcdda340	\N	2006-09-25 21:08:26	s:0:"";	72.149.230.106
ea434992f883cb06a4d3f9a099b21363	\N	2006-09-25 21:08:27	s:0:"";	72.149.230.106
ec97caeaf81f318ba2dfd4eb2cd0ec75	\N	2006-09-25 21:08:28	s:0:"";	72.149.230.106
1419af22cb18cd9154a99b8162c87901	\N	2006-09-25 21:08:29	s:0:"";	72.149.230.106
8125ff109d2ffa729869283ca990afb7	\N	2006-09-25 21:08:29	s:0:"";	65.214.44.184
d4f9b4bb3c61047fb70555c91c9fe323	\N	2006-09-25 21:08:30	s:0:"";	72.149.230.106
366a21452555d47959dccfa8e198494a	\N	2006-09-25 21:08:31	s:0:"";	72.149.230.106
1c0735cb204e7e4564ccc2403e787454	\N	2006-09-25 21:08:32	s:0:"";	72.149.230.106
ab4146564ce9257f5058938bd95ec810	\N	2006-09-25 21:08:33	s:0:"";	72.149.230.106
e65f078564315f6ed94b981f07c12cd4	\N	2006-09-25 21:08:34	s:0:"";	72.149.230.106
fefe1eb23b30964d397e66ce71f88c83	\N	2006-09-25 21:09:02	s:0:"";	72.149.230.106
f7dd764b515d29f982292716a2542005	\N	2006-09-25 21:09:53	s:0:"";	81.96.205.21
d8806f8ccdd0c75a841a2e2fbfc0f7bf	\N	2006-09-25 21:12:19	s:0:"";	66.249.65.163
512c664350b3595ee08f590cfeb89249	\N	2006-09-25 21:13:42	s:0:"";	213.105.224.13
c88c6b6e7da8f758271ed6ed1b447153	\N	2006-09-25 21:13:43	s:0:"";	65.54.188.99
50434f8bbc18b81ec33edc327f2c70a6	\N	2006-09-25 21:15:40	s:0:"";	81.96.205.21
24ed7a6266a2ae77e6b33b39e7832412	\N	2006-09-25 21:15:51	s:0:"";	207.46.98.114
921b8ef5a73cbbad8c406ee8f08da057	\N	2006-09-25 21:16:03	\N	202.108.11.108
9c3875acf568831bd5e1bca424a1fb88	\N	2006-09-25 21:16:15	s:0:"";	74.6.75.41
a5d50268b585a1ebf2709fd3944f17ac	\N	2006-09-25 21:16:47	s:0:"";	202.160.179.92
cfe52d0098b58e4881ad017630942be7	\N	2006-09-25 21:16:54	s:0:"";	65.214.44.29
65eb68f332be0d914babbb812fcd5680	\N	2006-09-25 21:16:54	\N	65.214.44.29
7179b939a6153f144abdd7f134f85185	\N	2006-09-25 21:17:33	s:0:"";	207.46.98.114
db2543f21581d4aa5d3dc86e1131f760	dez	2006-09-25 21:17:39	s:0:"";	81.174.227.170
a0192b7f39bbe68d5a3192df995d9173	\N	2006-09-25 21:19:22	s:0:"";	207.46.98.116
e1b1fe649276fac00daba624575223e9	\N	2006-09-25 21:21:23	s:0:"";	207.46.98.116
3f823df59179b74405991e99fd882718	\N	2006-09-25 21:21:27	s:0:"";	202.160.179.116
b47ccf222ef2fa7cbf3fdf352c5b28f2	\N	2006-09-25 21:22:54	s:0:"";	204.169.236.211
4ca8107a971e1cc302539f83fcca87fe	\N	2006-09-25 21:23:47	s:0:"";	87.106.3.38
2ceabde5f6f8111ae7598f41b24a8b27	\N	2006-09-25 21:23:47	s:0:"";	87.106.3.38
3311521e39c8818bedb2f004b60e259b	\N	2006-09-25 21:24:55	s:0:"";	72.30.177.225
3a44b12faa199c2b6d480803e184c5f1	\N	2006-09-25 21:25:22	s:0:"";	202.108.11.106
16326021ee4e9de66fc74a5b99d1134a	\N	2006-09-25 21:25:24	s:0:"";	74.6.70.159
4d3c6553f715332942811b1f26ff3b49	\N	2006-09-25 21:25:38	s:0:"";	82.0.222.175
e0f856728ce54c1e53559ba4e07a5d54	\N	2006-09-25 21:26:42	s:0:"";	212.227.20.34
0e11d28cb9b031048f67bd2b757ac013	\N	2006-09-25 21:26:42	s:0:"";	72.30.177.243
6c8a122f501b81486ad601ba6bff7300	\N	2006-09-25 21:27:30	s:0:"";	202.160.180.45
ea003dbfdab107401b3feeb59cafdd50	frosty	2006-09-25 21:28:21	s:0:"";	81.103.162.49
\.


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


--
-- 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
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
35	/Games/Counter-Strike Source		chckens	\N
36	/Games/Half-Life 2 Team Deathmatch		chckens	\N
37	/Games/Unreal Tournament 2004		chckens	\N
38	/Games/Unreal Tournament		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
44	/fragments/Front		dez	\N
45	/Community/Members		dez	\N
46	/Community/Societies		dez	\N
47	/Tools/Desktop on Demand		dez	\N
48	/Tools		saya	\N
49	/Knowledge		saya	\N
24	/Community		dez	\N
50	/Knowledge/FAQ		chckens	\N
21	/About/Staff		pwb	\N
28	/fragments/Games		frosty	\N
--
-- Name: acctype_pkey; Type: CONSTRAINT; Schema: public; Owner: dez; Tablespace: 
--

ALTER TABLE ONLY acctype
    ADD CONSTRAINT acctype_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: chckens; Tablespace: 
CREATE UNIQUE INDEX books_id_key ON books USING btree (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;
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 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: books; Type: ACL; Schema: public; Owner: chckens
--

REVOKE ALL ON TABLE books FROM PUBLIC;
REVOKE ALL ON TABLE books FROM chckens;
GRANT ALL ON TABLE books TO chckens;
GRANT ALL ON TABLE books TO apache;
GRANT ALL ON TABLE books TO dez;
-- Name: books_id_seq; Type: ACL; Schema: public; Owner: chckens
--

REVOKE ALL ON TABLE books_id_seq FROM PUBLIC;
REVOKE ALL ON TABLE books_id_seq FROM chckens;
GRANT ALL ON TABLE books_id_seq TO chckens;
GRANT ALL ON TABLE books_id_seq TO apache;
GRANT ALL ON TABLE books_id_seq TO dez;
-- 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;
-- 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;


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


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


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


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