2 -- PostgreSQL database dump
5 SET client_encoding = 'UNICODE';
6 SET check_function_bodies = false;
8 SET SESSION AUTHORIZATION 'postgres';
11 -- TOC entry 4 (OID 2200)
12 -- Name: public; Type: ACL; Schema: -; Owner: postgres
15 REVOKE ALL ON SCHEMA public FROM PUBLIC;
16 REVOKE ALL ON SCHEMA public FROM postgres;
17 GRANT ALL ON SCHEMA public TO PUBLIC;
20 SET SESSION AUTHORIZATION 'rich';
22 SET search_path = public, pg_catalog;
25 -- TOC entry 5 (OID 536004)
26 -- Name: pages; Type: TABLE; Schema: public; Owner: rich
34 description text NOT NULL,
35 creation_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL,
36 last_modified_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL,
37 hostid integer NOT NULL,
46 -- TOC entry 6 (OID 536004)
47 -- Name: pages; Type: ACL; Schema: public; Owner: rich
50 REVOKE ALL ON TABLE pages FROM PUBLIC;
51 GRANT ALL ON TABLE pages TO "www-data";
55 -- TOC entry 25 (OID 536004)
56 -- Name: pages_id_seq; Type: ACL; Schema: public; Owner: rich
59 REVOKE ALL ON TABLE pages_id_seq FROM PUBLIC;
60 GRANT ALL ON TABLE pages_id_seq TO "www-data";
64 -- TOC entry 7 (OID 536021)
65 -- Name: contents; Type: TABLE; Schema: public; Owner: rich
68 CREATE TABLE contents (
70 pageid integer NOT NULL,
71 ordering integer NOT NULL,
72 sectionname text NOT NULL,
73 content text NOT NULL,
79 -- TOC entry 8 (OID 536021)
80 -- Name: contents; Type: ACL; Schema: public; Owner: rich
83 REVOKE ALL ON TABLE contents FROM PUBLIC;
84 GRANT ALL ON TABLE contents TO "www-data";
88 -- TOC entry 26 (OID 536021)
89 -- Name: contents_id_seq; Type: ACL; Schema: public; Owner: rich
92 REVOKE ALL ON TABLE contents_id_seq FROM PUBLIC;
93 GRANT ALL ON TABLE contents_id_seq TO "www-data";
97 -- TOC entry 9 (OID 536371)
98 -- Name: hosts; Type: TABLE; Schema: public; Owner: rich
103 canonical_hostname text NOT NULL,
105 edit_anon boolean DEFAULT true NOT NULL,
106 create_account_anon boolean DEFAULT true NOT NULL,
112 -- TOC entry 10 (OID 536371)
113 -- Name: hosts; Type: ACL; Schema: public; Owner: rich
116 REVOKE ALL ON TABLE hosts FROM PUBLIC;
117 GRANT ALL ON TABLE hosts TO "www-data";
121 -- TOC entry 27 (OID 536371)
122 -- Name: hosts_id_seq; Type: ACL; Schema: public; Owner: rich
125 REVOKE ALL ON TABLE hosts_id_seq FROM PUBLIC;
126 GRANT ALL ON TABLE hosts_id_seq TO "www-data";
130 -- TOC entry 11 (OID 536379)
131 -- Name: hostnames; Type: TABLE; Schema: public; Owner: rich
134 CREATE TABLE hostnames (
135 hostid integer NOT NULL,
141 -- TOC entry 12 (OID 536379)
142 -- Name: hostnames; Type: ACL; Schema: public; Owner: rich
145 REVOKE ALL ON TABLE hostnames FROM PUBLIC;
146 GRANT ALL ON TABLE hostnames TO "www-data";
150 -- TOC entry 13 (OID 536915)
151 -- Name: email_notify; Type: TABLE; Schema: public; Owner: rich
154 CREATE TABLE email_notify (
155 hostid integer NOT NULL,
162 -- TOC entry 14 (OID 536915)
163 -- Name: email_notify; Type: ACL; Schema: public; Owner: rich
166 REVOKE ALL ON TABLE email_notify FROM PUBLIC;
167 GRANT ALL ON TABLE email_notify TO "www-data";
171 -- TOC entry 15 (OID 537151)
172 -- Name: images; Type: TABLE; Schema: public; Owner: rich
175 CREATE TABLE images (
177 hostid integer NOT NULL,
180 image bytea NOT NULL,
181 width integer NOT NULL,
182 height integer NOT NULL,
187 mime_type text NOT NULL,
192 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
197 -- TOC entry 16 (OID 537151)
198 -- Name: images; Type: ACL; Schema: public; Owner: rich
201 REVOKE ALL ON TABLE images FROM PUBLIC;
202 GRANT ALL ON TABLE images TO "www-data";
206 -- TOC entry 28 (OID 537151)
207 -- Name: images_id_seq; Type: ACL; Schema: public; Owner: rich
210 REVOKE ALL ON TABLE images_id_seq FROM PUBLIC;
211 GRANT ALL ON TABLE images_id_seq TO "www-data";
215 -- TOC entry 17 (OID 537166)
216 -- Name: files; Type: TABLE; Schema: public; Owner: rich
221 hostid integer NOT NULL,
224 content bytea NOT NULL,
226 mime_type text NOT NULL,
227 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
232 -- TOC entry 18 (OID 537166)
233 -- Name: files; Type: ACL; Schema: public; Owner: rich
236 REVOKE ALL ON TABLE files FROM PUBLIC;
237 GRANT ALL ON TABLE files TO "www-data";
241 -- TOC entry 29 (OID 537166)
242 -- Name: files_id_seq; Type: ACL; Schema: public; Owner: rich
245 REVOKE ALL ON TABLE files_id_seq FROM PUBLIC;
246 GRANT ALL ON TABLE files_id_seq TO "www-data";
250 -- TOC entry 19 (OID 540816)
251 -- Name: users; Type: TABLE; Schema: public; Owner: rich
256 hostid integer NOT NULL,
258 "password" text NOT NULL,
260 registration_date date DEFAULT ('now'::text)::date NOT NULL,
261 can_edit boolean DEFAULT true NOT NULL,
262 can_manage_users boolean DEFAULT false NOT NULL
267 -- TOC entry 20 (OID 540816)
268 -- Name: users; Type: ACL; Schema: public; Owner: rich
271 REVOKE ALL ON TABLE users FROM PUBLIC;
272 GRANT ALL ON TABLE users TO "www-data";
276 -- TOC entry 30 (OID 540816)
277 -- Name: users_id_seq; Type: ACL; Schema: public; Owner: rich
280 REVOKE ALL ON TABLE users_id_seq FROM PUBLIC;
281 GRANT ALL ON TABLE users_id_seq TO "www-data";
285 -- TOC entry 21 (OID 540832)
286 -- Name: usercookies; Type: TABLE; Schema: public; Owner: rich
289 CREATE TABLE usercookies (
290 userid integer NOT NULL,
296 -- TOC entry 22 (OID 540832)
297 -- Name: usercookies; Type: ACL; Schema: public; Owner: rich
300 REVOKE ALL ON TABLE usercookies FROM PUBLIC;
301 GRANT ALL ON TABLE usercookies TO "www-data";
305 -- TOC entry 23 (OID 540961)
306 -- Name: sitemenu; Type: TABLE; Schema: public; Owner: rich
309 CREATE TABLE sitemenu (
310 hostid integer NOT NULL,
313 ordering integer NOT NULL
318 -- TOC entry 24 (OID 540961)
319 -- Name: sitemenu; Type: ACL; Schema: public; Owner: rich
322 REVOKE ALL ON TABLE sitemenu FROM PUBLIC;
323 GRANT ALL ON TABLE sitemenu TO "www-data";
327 -- TOC entry 35 (OID 536388)
328 -- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich
331 CREATE UNIQUE INDEX hostnames_hostid_name_uq ON hostnames USING btree (hostid, name);
335 -- TOC entry 36 (OID 536389)
336 -- Name: hostnams_name_uq; Type: INDEX; Schema: public; Owner: rich
339 CREATE UNIQUE INDEX hostnams_name_uq ON hostnames USING btree (name);
343 -- TOC entry 32 (OID 536419)
344 -- Name: pages_url_uq; Type: INDEX; Schema: public; Owner: rich
347 CREATE UNIQUE INDEX pages_url_uq ON pages USING btree (hostid, url);
351 -- TOC entry 37 (OID 536924)
352 -- Name: email_notify_email_uq; Type: INDEX; Schema: public; Owner: rich
355 CREATE UNIQUE INDEX email_notify_email_uq ON email_notify USING btree (hostid, email);
359 -- TOC entry 38 (OID 540251)
360 -- Name: images_name_uq; Type: INDEX; Schema: public; Owner: rich
363 CREATE UNIQUE INDEX images_name_uq ON images USING btree (hostid, name);
367 -- TOC entry 40 (OID 540252)
368 -- Name: files_name_uq; Type: INDEX; Schema: public; Owner: rich
371 CREATE UNIQUE INDEX files_name_uq ON files USING btree (hostid, name);
375 -- TOC entry 43 (OID 540831)
376 -- Name: users_name_uq; Type: INDEX; Schema: public; Owner: rich
379 CREATE UNIQUE INDEX users_name_uq ON users USING btree (hostid, name);
383 -- TOC entry 42 (OID 540946)
384 -- Name: users_id_uq; Type: INDEX; Schema: public; Owner: rich
387 CREATE UNIQUE INDEX users_id_uq ON users USING btree (hostid, id);
391 -- TOC entry 45 (OID 540970)
392 -- Name: sitemenu_ordering_uq; Type: INDEX; Schema: public; Owner: rich
395 CREATE UNIQUE INDEX sitemenu_ordering_uq ON sitemenu USING btree (hostid, ordering);
399 -- TOC entry 46 (OID 540971)
400 -- Name: sitemenu_url_uq; Type: INDEX; Schema: public; Owner: rich
403 CREATE UNIQUE INDEX sitemenu_url_uq ON sitemenu USING btree (hostid, url);
407 -- TOC entry 31 (OID 536012)
408 -- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
411 ALTER TABLE ONLY pages
412 ADD CONSTRAINT pages_pkey PRIMARY KEY (id);
416 -- TOC entry 33 (OID 536027)
417 -- Name: contents_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
420 ALTER TABLE ONLY contents
421 ADD CONSTRAINT contents_pkey PRIMARY KEY (id);
425 -- TOC entry 34 (OID 536377)
426 -- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
429 ALTER TABLE ONLY hosts
430 ADD CONSTRAINT hosts_pkey PRIMARY KEY (id);
434 -- TOC entry 39 (OID 537158)
435 -- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
438 ALTER TABLE ONLY images
439 ADD CONSTRAINT images_pkey PRIMARY KEY (id);
443 -- TOC entry 41 (OID 537173)
444 -- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
447 ALTER TABLE ONLY files
448 ADD CONSTRAINT files_pkey PRIMARY KEY (id);
452 -- TOC entry 44 (OID 540825)
453 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
456 ALTER TABLE ONLY users
457 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
461 -- TOC entry 51 (OID 536029)
462 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
465 ALTER TABLE ONLY contents
466 ADD CONSTRAINT "$1" FOREIGN KEY (pageid) REFERENCES pages(id);
470 -- TOC entry 53 (OID 536384)
471 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
474 ALTER TABLE ONLY hostnames
475 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
479 -- TOC entry 52 (OID 536394)
480 -- Name: hosts_hostname_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
483 ALTER TABLE ONLY hosts
484 ADD CONSTRAINT hosts_hostname_cn FOREIGN KEY (id, canonical_hostname) REFERENCES hostnames(hostid, name) DEFERRABLE;
488 -- TOC entry 47 (OID 536404)
489 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
492 ALTER TABLE ONLY pages
493 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
497 -- TOC entry 54 (OID 536920)
498 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
501 ALTER TABLE ONLY email_notify
502 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
506 -- TOC entry 55 (OID 537160)
507 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
510 ALTER TABLE ONLY images
511 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
515 -- TOC entry 56 (OID 537175)
516 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
519 ALTER TABLE ONLY files
520 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
524 -- TOC entry 48 (OID 539155)
525 -- Name: pages_redirect_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
528 ALTER TABLE ONLY pages
529 ADD CONSTRAINT pages_redirect_cn FOREIGN KEY (hostid, redirect) REFERENCES pages(hostid, url) DEFERRABLE;
533 -- TOC entry 57 (OID 540827)
534 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
537 ALTER TABLE ONLY users
538 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
542 -- TOC entry 58 (OID 540837)
543 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
546 ALTER TABLE ONLY usercookies
547 ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
551 -- TOC entry 49 (OID 540942)
552 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
555 ALTER TABLE ONLY pages
556 ADD CONSTRAINT "$2" FOREIGN KEY (logged_user) REFERENCES users(id);
560 -- TOC entry 50 (OID 540947)
561 -- Name: pages_user_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
564 ALTER TABLE ONLY pages
565 ADD CONSTRAINT pages_user_cn FOREIGN KEY (hostid, logged_user) REFERENCES users(hostid, id);
569 -- TOC entry 59 (OID 540966)
570 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
573 ALTER TABLE ONLY sitemenu
574 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
578 -- TOC entry 60 (OID 540972)
579 -- Name: sitemenu_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
582 ALTER TABLE ONLY sitemenu
583 ADD CONSTRAINT sitemenu_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
586 SET SESSION AUTHORIZATION 'postgres';
589 -- TOC entry 3 (OID 2200)
590 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
593 COMMENT ON SCHEMA public IS 'Standard public namespace';