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";
54 SET SESSION AUTHORIZATION 'rich';
57 -- TOC entry 31 (OID 536004)
58 -- Name: pages_id_seq; Type: ACL; Schema: public; Owner: rich
61 REVOKE ALL ON TABLE pages_id_seq FROM PUBLIC;
62 GRANT ALL ON TABLE pages_id_seq TO "www-data";
65 SET SESSION AUTHORIZATION 'rich';
68 -- TOC entry 7 (OID 536021)
69 -- Name: contents; Type: TABLE; Schema: public; Owner: rich
72 CREATE TABLE contents (
74 pageid integer NOT NULL,
75 ordering integer NOT NULL,
77 content text NOT NULL,
83 -- TOC entry 8 (OID 536021)
84 -- Name: contents; Type: ACL; Schema: public; Owner: rich
87 REVOKE ALL ON TABLE contents FROM PUBLIC;
88 GRANT ALL ON TABLE contents TO "www-data";
91 SET SESSION AUTHORIZATION 'rich';
94 -- TOC entry 32 (OID 536021)
95 -- Name: contents_id_seq; Type: ACL; Schema: public; Owner: rich
98 REVOKE ALL ON TABLE contents_id_seq FROM PUBLIC;
99 GRANT ALL ON TABLE contents_id_seq TO "www-data";
102 SET SESSION AUTHORIZATION 'rich';
105 -- TOC entry 9 (OID 536371)
106 -- Name: hosts; Type: TABLE; Schema: public; Owner: rich
111 canonical_hostname text NOT NULL,
113 edit_anon boolean DEFAULT true NOT NULL,
114 create_account_anon boolean DEFAULT true NOT NULL,
121 -- TOC entry 10 (OID 536371)
122 -- Name: hosts; Type: ACL; Schema: public; Owner: rich
125 REVOKE ALL ON TABLE hosts FROM PUBLIC;
126 GRANT ALL ON TABLE hosts TO "www-data";
129 SET SESSION AUTHORIZATION 'rich';
132 -- TOC entry 33 (OID 536371)
133 -- Name: hosts_id_seq; Type: ACL; Schema: public; Owner: rich
136 REVOKE ALL ON TABLE hosts_id_seq FROM PUBLIC;
137 GRANT ALL ON TABLE hosts_id_seq TO "www-data";
140 SET SESSION AUTHORIZATION 'rich';
143 -- TOC entry 11 (OID 536379)
144 -- Name: hostnames; Type: TABLE; Schema: public; Owner: rich
147 CREATE TABLE hostnames (
148 hostid integer NOT NULL,
154 -- TOC entry 12 (OID 536379)
155 -- Name: hostnames; Type: ACL; Schema: public; Owner: rich
158 REVOKE ALL ON TABLE hostnames FROM PUBLIC;
159 GRANT ALL ON TABLE hostnames TO "www-data";
162 SET SESSION AUTHORIZATION 'rich';
165 -- TOC entry 13 (OID 536915)
166 -- Name: email_notify; Type: TABLE; Schema: public; Owner: rich
169 CREATE TABLE email_notify (
170 hostid integer NOT NULL,
177 -- TOC entry 14 (OID 536915)
178 -- Name: email_notify; Type: ACL; Schema: public; Owner: rich
181 REVOKE ALL ON TABLE email_notify FROM PUBLIC;
182 GRANT ALL ON TABLE email_notify TO "www-data";
185 SET SESSION AUTHORIZATION 'rich';
188 -- TOC entry 15 (OID 537151)
189 -- Name: images; Type: TABLE; Schema: public; Owner: rich
192 CREATE TABLE images (
194 hostid integer NOT NULL,
197 image bytea NOT NULL,
198 width integer NOT NULL,
199 height integer NOT NULL,
204 mime_type text NOT NULL,
209 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
214 -- TOC entry 16 (OID 537151)
215 -- Name: images; Type: ACL; Schema: public; Owner: rich
218 REVOKE ALL ON TABLE images FROM PUBLIC;
219 GRANT ALL ON TABLE images TO "www-data";
222 SET SESSION AUTHORIZATION 'rich';
225 -- TOC entry 34 (OID 537151)
226 -- Name: images_id_seq; Type: ACL; Schema: public; Owner: rich
229 REVOKE ALL ON TABLE images_id_seq FROM PUBLIC;
230 GRANT ALL ON TABLE images_id_seq TO "www-data";
233 SET SESSION AUTHORIZATION 'rich';
236 -- TOC entry 17 (OID 537166)
237 -- Name: files; Type: TABLE; Schema: public; Owner: rich
242 hostid integer NOT NULL,
245 content bytea NOT NULL,
247 mime_type text NOT NULL,
248 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
253 -- TOC entry 18 (OID 537166)
254 -- Name: files; Type: ACL; Schema: public; Owner: rich
257 REVOKE ALL ON TABLE files FROM PUBLIC;
258 GRANT ALL ON TABLE files TO "www-data";
261 SET SESSION AUTHORIZATION 'rich';
264 -- TOC entry 35 (OID 537166)
265 -- Name: files_id_seq; Type: ACL; Schema: public; Owner: rich
268 REVOKE ALL ON TABLE files_id_seq FROM PUBLIC;
269 GRANT ALL ON TABLE files_id_seq TO "www-data";
272 SET SESSION AUTHORIZATION 'rich';
275 -- TOC entry 19 (OID 540816)
276 -- Name: users; Type: TABLE; Schema: public; Owner: rich
281 hostid integer NOT NULL,
283 "password" text NOT NULL,
285 registration_date date DEFAULT ('now'::text)::date NOT NULL,
286 can_edit boolean DEFAULT true NOT NULL,
287 can_manage_users boolean DEFAULT false NOT NULL,
288 can_manage_contacts boolean DEFAULT false NOT NULL,
289 can_manage_site boolean DEFAULT false NOT NULL,
290 can_edit_global_css boolean DEFAULT false NOT NULL
295 -- TOC entry 20 (OID 540816)
296 -- Name: users; Type: ACL; Schema: public; Owner: rich
299 REVOKE ALL ON TABLE users FROM PUBLIC;
300 GRANT ALL ON TABLE users TO "www-data";
303 SET SESSION AUTHORIZATION 'rich';
306 -- TOC entry 36 (OID 540816)
307 -- Name: users_id_seq; Type: ACL; Schema: public; Owner: rich
310 REVOKE ALL ON TABLE users_id_seq FROM PUBLIC;
311 GRANT ALL ON TABLE users_id_seq TO "www-data";
314 SET SESSION AUTHORIZATION 'rich';
317 -- TOC entry 21 (OID 540832)
318 -- Name: usercookies; Type: TABLE; Schema: public; Owner: rich
321 CREATE TABLE usercookies (
322 userid integer NOT NULL,
328 -- TOC entry 22 (OID 540832)
329 -- Name: usercookies; Type: ACL; Schema: public; Owner: rich
332 REVOKE ALL ON TABLE usercookies FROM PUBLIC;
333 GRANT ALL ON TABLE usercookies TO "www-data";
336 SET SESSION AUTHORIZATION 'rich';
339 -- TOC entry 23 (OID 540961)
340 -- Name: sitemenu; Type: TABLE; Schema: public; Owner: rich
343 CREATE TABLE sitemenu (
344 hostid integer NOT NULL,
347 ordering integer NOT NULL
352 -- TOC entry 24 (OID 540961)
353 -- Name: sitemenu; Type: ACL; Schema: public; Owner: rich
356 REVOKE ALL ON TABLE sitemenu FROM PUBLIC;
357 GRANT ALL ON TABLE sitemenu TO "www-data";
360 SET SESSION AUTHORIZATION 'rich';
363 -- TOC entry 25 (OID 542605)
364 -- Name: contacts; Type: TABLE; Schema: public; Owner: rich
367 CREATE TABLE contacts (
369 hostid integer NOT NULL,
371 subject text NOT NULL
376 -- TOC entry 26 (OID 542605)
377 -- Name: contacts; Type: ACL; Schema: public; Owner: rich
380 REVOKE ALL ON TABLE contacts FROM PUBLIC;
381 GRANT ALL ON TABLE contacts TO "www-data";
384 SET SESSION AUTHORIZATION 'rich';
387 -- TOC entry 37 (OID 542605)
388 -- Name: contacts_id_seq; Type: ACL; Schema: public; Owner: rich
391 REVOKE ALL ON TABLE contacts_id_seq FROM PUBLIC;
392 GRANT ALL ON TABLE contacts_id_seq TO "www-data";
395 SET SESSION AUTHORIZATION 'rich';
398 -- TOC entry 27 (OID 542617)
399 -- Name: contact_emails; Type: TABLE; Schema: public; Owner: rich
402 CREATE TABLE contact_emails (
403 contactid integer NOT NULL,
409 -- TOC entry 28 (OID 542617)
410 -- Name: contact_emails; Type: ACL; Schema: public; Owner: rich
413 REVOKE ALL ON TABLE contact_emails FROM PUBLIC;
414 GRANT ALL ON TABLE contact_emails TO "www-data";
417 SET SESSION AUTHORIZATION 'rich';
420 -- TOC entry 29 (OID 543499)
421 -- Name: themes; Type: TABLE; Schema: public; Owner: rich
424 CREATE TABLE themes (
425 theme_css text NOT NULL,
427 description text NOT NULL
432 -- TOC entry 30 (OID 543499)
433 -- Name: themes; Type: ACL; Schema: public; Owner: rich
436 REVOKE ALL ON TABLE themes FROM PUBLIC;
437 GRANT SELECT ON TABLE themes TO "www-data";
440 SET SESSION AUTHORIZATION 'rich';
443 -- TOC entry 42 (OID 536388)
444 -- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich
447 CREATE UNIQUE INDEX hostnames_hostid_name_uq ON hostnames USING btree (hostid, name);
451 -- TOC entry 43 (OID 536389)
452 -- Name: hostnams_name_uq; Type: INDEX; Schema: public; Owner: rich
455 CREATE UNIQUE INDEX hostnams_name_uq ON hostnames USING btree (name);
459 -- TOC entry 39 (OID 536419)
460 -- Name: pages_url_uq; Type: INDEX; Schema: public; Owner: rich
463 CREATE UNIQUE INDEX pages_url_uq ON pages USING btree (hostid, url);
467 -- TOC entry 44 (OID 536924)
468 -- Name: email_notify_email_uq; Type: INDEX; Schema: public; Owner: rich
471 CREATE UNIQUE INDEX email_notify_email_uq ON email_notify USING btree (hostid, email);
475 -- TOC entry 45 (OID 540251)
476 -- Name: images_name_uq; Type: INDEX; Schema: public; Owner: rich
479 CREATE UNIQUE INDEX images_name_uq ON images USING btree (hostid, name);
483 -- TOC entry 47 (OID 540252)
484 -- Name: files_name_uq; Type: INDEX; Schema: public; Owner: rich
487 CREATE UNIQUE INDEX files_name_uq ON files USING btree (hostid, name);
491 -- TOC entry 50 (OID 540831)
492 -- Name: users_name_uq; Type: INDEX; Schema: public; Owner: rich
495 CREATE UNIQUE INDEX users_name_uq ON users USING btree (hostid, name);
499 -- TOC entry 49 (OID 540946)
500 -- Name: users_id_uq; Type: INDEX; Schema: public; Owner: rich
503 CREATE UNIQUE INDEX users_id_uq ON users USING btree (hostid, id);
507 -- TOC entry 52 (OID 540970)
508 -- Name: sitemenu_ordering_uq; Type: INDEX; Schema: public; Owner: rich
511 CREATE UNIQUE INDEX sitemenu_ordering_uq ON sitemenu USING btree (hostid, ordering);
515 -- TOC entry 53 (OID 540971)
516 -- Name: sitemenu_url_uq; Type: INDEX; Schema: public; Owner: rich
519 CREATE UNIQUE INDEX sitemenu_url_uq ON sitemenu USING btree (hostid, url);
523 -- TOC entry 55 (OID 542626)
524 -- Name: contact_emails_uq; Type: INDEX; Schema: public; Owner: rich
527 CREATE UNIQUE INDEX contact_emails_uq ON contact_emails USING btree (contactid, email);
531 -- TOC entry 56 (OID 543505)
532 -- Name: themes_theme_css_uq; Type: INDEX; Schema: public; Owner: rich
535 CREATE UNIQUE INDEX themes_theme_css_uq ON themes USING btree (theme_css);
539 -- TOC entry 38 (OID 536012)
540 -- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
543 ALTER TABLE ONLY pages
544 ADD CONSTRAINT pages_pkey PRIMARY KEY (id);
548 -- TOC entry 40 (OID 536027)
549 -- Name: contents_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
552 ALTER TABLE ONLY contents
553 ADD CONSTRAINT contents_pkey PRIMARY KEY (id);
557 -- TOC entry 41 (OID 536377)
558 -- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
561 ALTER TABLE ONLY hosts
562 ADD CONSTRAINT hosts_pkey PRIMARY KEY (id);
566 -- TOC entry 46 (OID 537158)
567 -- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
570 ALTER TABLE ONLY images
571 ADD CONSTRAINT images_pkey PRIMARY KEY (id);
575 -- TOC entry 48 (OID 537173)
576 -- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
579 ALTER TABLE ONLY files
580 ADD CONSTRAINT files_pkey PRIMARY KEY (id);
584 -- TOC entry 51 (OID 540825)
585 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
588 ALTER TABLE ONLY users
589 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
593 -- TOC entry 54 (OID 542611)
594 -- Name: contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
597 ALTER TABLE ONLY contacts
598 ADD CONSTRAINT contacts_pkey PRIMARY KEY (id);
602 -- TOC entry 61 (OID 536029)
603 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
606 ALTER TABLE ONLY contents
607 ADD CONSTRAINT "$1" FOREIGN KEY (pageid) REFERENCES pages(id);
611 -- TOC entry 64 (OID 536384)
612 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
615 ALTER TABLE ONLY hostnames
616 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
620 -- TOC entry 62 (OID 536394)
621 -- Name: hosts_hostname_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
624 ALTER TABLE ONLY hosts
625 ADD CONSTRAINT hosts_hostname_cn FOREIGN KEY (id, canonical_hostname) REFERENCES hostnames(hostid, name) DEFERRABLE;
629 -- TOC entry 57 (OID 536404)
630 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
633 ALTER TABLE ONLY pages
634 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
638 -- TOC entry 65 (OID 536920)
639 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
642 ALTER TABLE ONLY email_notify
643 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
647 -- TOC entry 66 (OID 537160)
648 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
651 ALTER TABLE ONLY images
652 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
656 -- TOC entry 67 (OID 537175)
657 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
660 ALTER TABLE ONLY files
661 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
665 -- TOC entry 58 (OID 539155)
666 -- Name: pages_redirect_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
669 ALTER TABLE ONLY pages
670 ADD CONSTRAINT pages_redirect_cn FOREIGN KEY (hostid, redirect) REFERENCES pages(hostid, url) DEFERRABLE;
674 -- TOC entry 68 (OID 540827)
675 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
678 ALTER TABLE ONLY users
679 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
683 -- TOC entry 69 (OID 540837)
684 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
687 ALTER TABLE ONLY usercookies
688 ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
692 -- TOC entry 59 (OID 540942)
693 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
696 ALTER TABLE ONLY pages
697 ADD CONSTRAINT "$2" FOREIGN KEY (logged_user) REFERENCES users(id);
701 -- TOC entry 60 (OID 540947)
702 -- Name: pages_user_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
705 ALTER TABLE ONLY pages
706 ADD CONSTRAINT pages_user_cn FOREIGN KEY (hostid, logged_user) REFERENCES users(hostid, id);
710 -- TOC entry 70 (OID 540966)
711 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
714 ALTER TABLE ONLY sitemenu
715 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
719 -- TOC entry 71 (OID 540972)
720 -- Name: sitemenu_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
723 ALTER TABLE ONLY sitemenu
724 ADD CONSTRAINT sitemenu_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
728 -- TOC entry 72 (OID 542613)
729 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
732 ALTER TABLE ONLY contacts
733 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
737 -- TOC entry 73 (OID 542622)
738 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
741 ALTER TABLE ONLY contact_emails
742 ADD CONSTRAINT "$1" FOREIGN KEY (contactid) REFERENCES contacts(id);
746 -- TOC entry 63 (OID 543506)
747 -- Name: hosts_theme_css_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
750 ALTER TABLE ONLY hosts
751 ADD CONSTRAINT hosts_theme_css_cn FOREIGN KEY (theme_css) REFERENCES themes(theme_css);
754 SET SESSION AUTHORIZATION 'postgres';
757 -- TOC entry 3 (OID 2200)
758 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
761 COMMENT ON SCHEMA public IS 'Standard public namespace';