2 -- PostgreSQL database dump
5 SET client_encoding = 'UNICODE';
6 SET check_function_bodies = false;
9 -- TOC entry 4 (OID 2200)
10 -- Name: public; Type: ACL; Schema: -; Owner: postgres
13 REVOKE ALL ON SCHEMA public FROM PUBLIC;
14 REVOKE ALL ON SCHEMA public FROM postgres;
15 GRANT ALL ON SCHEMA public TO PUBLIC;
18 SET search_path = public, pg_catalog;
21 -- TOC entry 5 (OID 536004)
22 -- Name: pages; Type: TABLE; Schema: public; Owner: rich
30 description text NOT NULL,
31 creation_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL,
32 last_modified_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL,
33 hostid integer NOT NULL,
42 -- TOC entry 6 (OID 536004)
43 -- Name: pages; Type: ACL; Schema: public; Owner: rich
46 REVOKE ALL ON TABLE pages FROM PUBLIC;
47 GRANT ALL ON TABLE pages TO "www-data";
51 -- TOC entry 42 (OID 536004)
52 -- Name: pages_id_seq; Type: ACL; Schema: public; Owner: rich
55 REVOKE ALL ON TABLE pages_id_seq FROM PUBLIC;
56 GRANT ALL ON TABLE pages_id_seq TO "www-data";
60 -- TOC entry 7 (OID 536021)
61 -- Name: contents; Type: TABLE; Schema: public; Owner: rich
64 CREATE TABLE contents (
66 pageid integer NOT NULL,
67 ordering integer NOT NULL,
69 content text NOT NULL,
75 -- TOC entry 8 (OID 536021)
76 -- Name: contents; Type: ACL; Schema: public; Owner: rich
79 REVOKE ALL ON TABLE contents FROM PUBLIC;
80 GRANT ALL ON TABLE contents TO "www-data";
84 -- TOC entry 43 (OID 536021)
85 -- Name: contents_id_seq; Type: ACL; Schema: public; Owner: rich
88 REVOKE ALL ON TABLE contents_id_seq FROM PUBLIC;
89 GRANT ALL ON TABLE contents_id_seq TO "www-data";
93 -- TOC entry 9 (OID 536371)
94 -- Name: hosts; Type: TABLE; Schema: public; Owner: rich
99 canonical_hostname text NOT NULL,
101 edit_anon boolean DEFAULT true NOT NULL,
102 create_account_anon boolean DEFAULT true NOT NULL,
105 mailing_list boolean DEFAULT false NOT NULL,
106 is_template boolean DEFAULT false NOT NULL,
107 search_box boolean DEFAULT true NOT NULL,
108 view_anon boolean DEFAULT true NOT NULL
113 -- TOC entry 10 (OID 536371)
114 -- Name: hosts; Type: ACL; Schema: public; Owner: rich
117 REVOKE ALL ON TABLE hosts FROM PUBLIC;
118 GRANT ALL ON TABLE hosts TO "www-data";
122 -- TOC entry 44 (OID 536371)
123 -- Name: hosts_id_seq; Type: ACL; Schema: public; Owner: rich
126 REVOKE ALL ON TABLE hosts_id_seq FROM PUBLIC;
127 GRANT ALL ON TABLE hosts_id_seq TO "www-data";
131 -- TOC entry 11 (OID 536379)
132 -- Name: hostnames; Type: TABLE; Schema: public; Owner: rich
135 CREATE TABLE hostnames (
136 hostid integer NOT NULL,
142 -- TOC entry 12 (OID 536379)
143 -- Name: hostnames; Type: ACL; Schema: public; Owner: rich
146 REVOKE ALL ON TABLE hostnames FROM PUBLIC;
147 GRANT ALL ON TABLE hostnames TO "www-data";
151 -- TOC entry 13 (OID 536915)
152 -- Name: email_notify; Type: TABLE; Schema: public; Owner: rich
155 CREATE TABLE email_notify (
156 hostid integer NOT NULL,
163 -- TOC entry 14 (OID 536915)
164 -- Name: email_notify; Type: ACL; Schema: public; Owner: rich
167 REVOKE ALL ON TABLE email_notify FROM PUBLIC;
168 GRANT ALL ON TABLE email_notify TO "www-data";
172 -- TOC entry 15 (OID 537151)
173 -- Name: images; Type: TABLE; Schema: public; Owner: rich
176 CREATE TABLE images (
178 hostid integer NOT NULL,
181 image bytea NOT NULL,
182 width integer NOT NULL,
183 height integer NOT NULL,
188 mime_type text NOT NULL,
193 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
198 -- TOC entry 16 (OID 537151)
199 -- Name: images; Type: ACL; Schema: public; Owner: rich
202 REVOKE ALL ON TABLE images FROM PUBLIC;
203 GRANT ALL ON TABLE images TO "www-data";
207 -- TOC entry 45 (OID 537151)
208 -- Name: images_id_seq; Type: ACL; Schema: public; Owner: rich
211 REVOKE ALL ON TABLE images_id_seq FROM PUBLIC;
212 GRANT ALL ON TABLE images_id_seq TO "www-data";
216 -- TOC entry 17 (OID 537166)
217 -- Name: files; Type: TABLE; Schema: public; Owner: rich
222 hostid integer NOT NULL,
225 content bytea NOT NULL,
227 mime_type text NOT NULL,
228 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
233 -- TOC entry 18 (OID 537166)
234 -- Name: files; Type: ACL; Schema: public; Owner: rich
237 REVOKE ALL ON TABLE files FROM PUBLIC;
238 GRANT ALL ON TABLE files TO "www-data";
242 -- TOC entry 46 (OID 537166)
243 -- Name: files_id_seq; Type: ACL; Schema: public; Owner: rich
246 REVOKE ALL ON TABLE files_id_seq FROM PUBLIC;
247 GRANT ALL ON TABLE files_id_seq TO "www-data";
251 -- TOC entry 19 (OID 540816)
252 -- Name: users; Type: TABLE; Schema: public; Owner: rich
257 hostid integer NOT NULL,
259 "password" text NOT NULL,
261 registration_date date DEFAULT ('now'::text)::date NOT NULL,
262 can_edit boolean DEFAULT true NOT NULL,
263 can_manage_users boolean DEFAULT false NOT NULL,
264 can_manage_contacts boolean DEFAULT false NOT NULL,
265 can_manage_site boolean DEFAULT false NOT NULL,
266 can_edit_global_css boolean DEFAULT false NOT NULL,
267 force_password_change boolean DEFAULT false NOT NULL
272 -- TOC entry 20 (OID 540816)
273 -- Name: users; Type: ACL; Schema: public; Owner: rich
276 REVOKE ALL ON TABLE users FROM PUBLIC;
277 GRANT ALL ON TABLE users TO "www-data";
281 -- TOC entry 47 (OID 540816)
282 -- Name: users_id_seq; Type: ACL; Schema: public; Owner: rich
285 REVOKE ALL ON TABLE users_id_seq FROM PUBLIC;
286 GRANT ALL ON TABLE users_id_seq TO "www-data";
290 -- TOC entry 21 (OID 540832)
291 -- Name: usercookies; Type: TABLE; Schema: public; Owner: rich
294 CREATE TABLE usercookies (
295 userid integer NOT NULL,
301 -- TOC entry 22 (OID 540832)
302 -- Name: usercookies; Type: ACL; Schema: public; Owner: rich
305 REVOKE ALL ON TABLE usercookies FROM PUBLIC;
306 GRANT ALL ON TABLE usercookies TO "www-data";
310 -- TOC entry 23 (OID 540961)
311 -- Name: sitemenu; Type: TABLE; Schema: public; Owner: rich
314 CREATE TABLE sitemenu (
315 hostid integer NOT NULL,
318 ordering integer NOT NULL
323 -- TOC entry 24 (OID 540961)
324 -- Name: sitemenu; Type: ACL; Schema: public; Owner: rich
327 REVOKE ALL ON TABLE sitemenu FROM PUBLIC;
328 GRANT ALL ON TABLE sitemenu TO "www-data";
332 -- TOC entry 25 (OID 542605)
333 -- Name: contacts; Type: TABLE; Schema: public; Owner: rich
336 CREATE TABLE contacts (
338 hostid integer NOT NULL,
340 subject text NOT NULL
345 -- TOC entry 26 (OID 542605)
346 -- Name: contacts; Type: ACL; Schema: public; Owner: rich
349 REVOKE ALL ON TABLE contacts FROM PUBLIC;
350 GRANT ALL ON TABLE contacts TO "www-data";
354 -- TOC entry 48 (OID 542605)
355 -- Name: contacts_id_seq; Type: ACL; Schema: public; Owner: rich
358 REVOKE ALL ON TABLE contacts_id_seq FROM PUBLIC;
359 GRANT ALL ON TABLE contacts_id_seq TO "www-data";
363 -- TOC entry 27 (OID 542617)
364 -- Name: contact_emails; Type: TABLE; Schema: public; Owner: rich
367 CREATE TABLE contact_emails (
368 contactid integer NOT NULL,
374 -- TOC entry 28 (OID 542617)
375 -- Name: contact_emails; Type: ACL; Schema: public; Owner: rich
378 REVOKE ALL ON TABLE contact_emails FROM PUBLIC;
379 GRANT ALL ON TABLE contact_emails TO "www-data";
383 -- TOC entry 29 (OID 543499)
384 -- Name: themes; Type: TABLE; Schema: public; Owner: rich
387 CREATE TABLE themes (
388 theme_css text NOT NULL,
390 description text NOT NULL
395 -- TOC entry 30 (OID 543499)
396 -- Name: themes; Type: ACL; Schema: public; Owner: rich
399 REVOKE ALL ON TABLE themes FROM PUBLIC;
400 GRANT SELECT ON TABLE themes TO "www-data";
404 -- TOC entry 31 (OID 543592)
405 -- Name: server_settings; Type: TABLE; Schema: public; Owner: rich
408 CREATE TABLE server_settings (
409 "version" integer NOT NULL,
415 -- TOC entry 33 (OID 543592)
416 -- Name: server_settings; Type: ACL; Schema: public; Owner: rich
419 REVOKE ALL ON TABLE server_settings FROM PUBLIC;
420 GRANT SELECT ON TABLE server_settings TO "www-data";
424 -- TOC entry 34 (OID 543754)
425 -- Name: page_emails; Type: TABLE; Schema: public; Owner: rich
428 CREATE TABLE page_emails (
429 hostid integer NOT NULL,
432 entry_date date DEFAULT ('now'::text)::date NOT NULL,
433 last_sent date DEFAULT ('now'::text)::date NOT NULL,
435 opt_out text NOT NULL
440 -- TOC entry 35 (OID 543754)
441 -- Name: page_emails; Type: ACL; Schema: public; Owner: rich
444 REVOKE ALL ON TABLE page_emails FROM PUBLIC;
445 GRANT ALL ON TABLE page_emails TO "www-data";
449 -- TOC entry 36 (OID 543785)
450 -- Name: mailing_lists; Type: TABLE; Schema: public; Owner: rich
453 CREATE TABLE mailing_lists (
454 hostid integer NOT NULL,
456 entry_date date DEFAULT ('now'::text)::date NOT NULL,
458 opt_out text NOT NULL,
464 -- TOC entry 37 (OID 543785)
465 -- Name: mailing_lists; Type: ACL; Schema: public; Owner: rich
468 REVOKE ALL ON TABLE mailing_lists FROM PUBLIC;
469 GRANT ALL ON TABLE mailing_lists TO "www-data";
473 -- TOC entry 38 (OID 544445)
474 -- Name: links; Type: TABLE; Schema: public; Owner: rich
478 hostid integer NOT NULL,
479 from_url text NOT NULL,
480 to_url text NOT NULL,
481 CONSTRAINT links_not_selfref_cn CHECK ((from_url <> to_url))
486 -- TOC entry 39 (OID 544445)
487 -- Name: links; Type: ACL; Schema: public; Owner: rich
490 REVOKE ALL ON TABLE links FROM PUBLIC;
491 GRANT ALL ON TABLE links TO "www-data";
495 -- TOC entry 40 (OID 547939)
496 -- Name: templates; Type: TABLE; Schema: public; Owner: rich
499 CREATE TABLE templates (
501 title_regexp text NOT NULL,
502 url_regexp text NOT NULL,
503 extension text NOT NULL,
504 ordering integer NOT NULL
509 -- TOC entry 41 (OID 547939)
510 -- Name: templates; Type: ACL; Schema: public; Owner: rich
513 REVOKE ALL ON TABLE templates FROM PUBLIC;
514 GRANT SELECT ON TABLE templates TO "www-data";
518 -- TOC entry 49 (OID 547939)
519 -- Name: templates_id_seq; Type: ACL; Schema: public; Owner: rich
522 REVOKE ALL ON TABLE templates_id_seq FROM PUBLIC;
526 -- TOC entry 54 (OID 536388)
527 -- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich
530 CREATE UNIQUE INDEX hostnames_hostid_name_uq ON hostnames USING btree (hostid, name);
534 -- TOC entry 55 (OID 536389)
535 -- Name: hostnams_name_uq; Type: INDEX; Schema: public; Owner: rich
538 CREATE UNIQUE INDEX hostnams_name_uq ON hostnames USING btree (name);
542 -- TOC entry 51 (OID 536419)
543 -- Name: pages_url_uq; Type: INDEX; Schema: public; Owner: rich
546 CREATE UNIQUE INDEX pages_url_uq ON pages USING btree (hostid, url);
550 -- TOC entry 56 (OID 536924)
551 -- Name: email_notify_email_uq; Type: INDEX; Schema: public; Owner: rich
554 CREATE UNIQUE INDEX email_notify_email_uq ON email_notify USING btree (hostid, email);
558 -- TOC entry 57 (OID 540251)
559 -- Name: images_name_uq; Type: INDEX; Schema: public; Owner: rich
562 CREATE UNIQUE INDEX images_name_uq ON images USING btree (hostid, name);
566 -- TOC entry 59 (OID 540252)
567 -- Name: files_name_uq; Type: INDEX; Schema: public; Owner: rich
570 CREATE UNIQUE INDEX files_name_uq ON files USING btree (hostid, name);
574 -- TOC entry 62 (OID 540831)
575 -- Name: users_name_uq; Type: INDEX; Schema: public; Owner: rich
578 CREATE UNIQUE INDEX users_name_uq ON users USING btree (hostid, name);
582 -- TOC entry 61 (OID 540946)
583 -- Name: users_id_uq; Type: INDEX; Schema: public; Owner: rich
586 CREATE UNIQUE INDEX users_id_uq ON users USING btree (hostid, id);
590 -- TOC entry 64 (OID 540970)
591 -- Name: sitemenu_ordering_uq; Type: INDEX; Schema: public; Owner: rich
594 CREATE UNIQUE INDEX sitemenu_ordering_uq ON sitemenu USING btree (hostid, ordering);
598 -- TOC entry 65 (OID 540971)
599 -- Name: sitemenu_url_uq; Type: INDEX; Schema: public; Owner: rich
602 CREATE UNIQUE INDEX sitemenu_url_uq ON sitemenu USING btree (hostid, url);
606 -- TOC entry 68 (OID 542626)
607 -- Name: contact_emails_uq; Type: INDEX; Schema: public; Owner: rich
610 CREATE UNIQUE INDEX contact_emails_uq ON contact_emails USING btree (contactid, email);
614 -- TOC entry 69 (OID 543505)
615 -- Name: themes_theme_css_uq; Type: INDEX; Schema: public; Owner: rich
618 CREATE UNIQUE INDEX themes_theme_css_uq ON themes USING btree (theme_css);
622 -- TOC entry 70 (OID 543763)
623 -- Name: page_emails_email_uq; Type: INDEX; Schema: public; Owner: rich
626 CREATE UNIQUE INDEX page_emails_email_uq ON page_emails USING btree (hostid, url, email);
630 -- TOC entry 71 (OID 543795)
631 -- Name: mailing_lists_email_uq; Type: INDEX; Schema: public; Owner: rich
634 CREATE UNIQUE INDEX mailing_lists_email_uq ON mailing_lists USING btree (hostid, email);
638 -- TOC entry 66 (OID 543880)
639 -- Name: contacts_name_uq; Type: INDEX; Schema: public; Owner: rich
642 CREATE UNIQUE INDEX contacts_name_uq ON contacts USING btree (hostid, name);
646 -- TOC entry 72 (OID 544454)
647 -- Name: links_uq; Type: INDEX; Schema: public; Owner: rich
650 CREATE UNIQUE INDEX links_uq ON links USING btree (hostid, from_url, to_url);
654 -- TOC entry 73 (OID 547951)
655 -- Name: templates_ext_ord_uq; Type: INDEX; Schema: public; Owner: rich
658 CREATE UNIQUE INDEX templates_ext_ord_uq ON templates USING btree (extension, ordering);
662 -- TOC entry 75 (OID 547952)
663 -- Name: templates_title_uq; Type: INDEX; Schema: public; Owner: rich
666 CREATE UNIQUE INDEX templates_title_uq ON templates USING btree (title_regexp);
670 -- TOC entry 76 (OID 547953)
671 -- Name: templates_url_uq; Type: INDEX; Schema: public; Owner: rich
674 CREATE UNIQUE INDEX templates_url_uq ON templates USING btree (url_regexp);
678 -- TOC entry 50 (OID 536012)
679 -- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
682 ALTER TABLE ONLY pages
683 ADD CONSTRAINT pages_pkey PRIMARY KEY (id);
687 -- TOC entry 52 (OID 536027)
688 -- Name: contents_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
691 ALTER TABLE ONLY contents
692 ADD CONSTRAINT contents_pkey PRIMARY KEY (id);
696 -- TOC entry 53 (OID 536377)
697 -- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
700 ALTER TABLE ONLY hosts
701 ADD CONSTRAINT hosts_pkey PRIMARY KEY (id);
705 -- TOC entry 58 (OID 537158)
706 -- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
709 ALTER TABLE ONLY images
710 ADD CONSTRAINT images_pkey PRIMARY KEY (id);
714 -- TOC entry 60 (OID 537173)
715 -- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
718 ALTER TABLE ONLY files
719 ADD CONSTRAINT files_pkey PRIMARY KEY (id);
723 -- TOC entry 63 (OID 540825)
724 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
727 ALTER TABLE ONLY users
728 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
732 -- TOC entry 67 (OID 542611)
733 -- Name: contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
736 ALTER TABLE ONLY contacts
737 ADD CONSTRAINT contacts_pkey PRIMARY KEY (id);
741 -- TOC entry 74 (OID 547945)
742 -- Name: templates_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
745 ALTER TABLE ONLY templates
746 ADD CONSTRAINT templates_pkey PRIMARY KEY (id);
750 -- TOC entry 81 (OID 536029)
751 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
754 ALTER TABLE ONLY contents
755 ADD CONSTRAINT "$1" FOREIGN KEY (pageid) REFERENCES pages(id);
759 -- TOC entry 84 (OID 536384)
760 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
763 ALTER TABLE ONLY hostnames
764 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
768 -- TOC entry 82 (OID 536394)
769 -- Name: hosts_hostname_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
772 ALTER TABLE ONLY hosts
773 ADD CONSTRAINT hosts_hostname_cn FOREIGN KEY (id, canonical_hostname) REFERENCES hostnames(hostid, name) DEFERRABLE;
777 -- TOC entry 77 (OID 536404)
778 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
781 ALTER TABLE ONLY pages
782 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
786 -- TOC entry 85 (OID 536920)
787 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
790 ALTER TABLE ONLY email_notify
791 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
795 -- TOC entry 86 (OID 537160)
796 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
799 ALTER TABLE ONLY images
800 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
804 -- TOC entry 87 (OID 537175)
805 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
808 ALTER TABLE ONLY files
809 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
813 -- TOC entry 78 (OID 539155)
814 -- Name: pages_redirect_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
817 ALTER TABLE ONLY pages
818 ADD CONSTRAINT pages_redirect_cn FOREIGN KEY (hostid, redirect) REFERENCES pages(hostid, url) DEFERRABLE;
822 -- TOC entry 88 (OID 540827)
823 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
826 ALTER TABLE ONLY users
827 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
831 -- TOC entry 89 (OID 540837)
832 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
835 ALTER TABLE ONLY usercookies
836 ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
840 -- TOC entry 79 (OID 540942)
841 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
844 ALTER TABLE ONLY pages
845 ADD CONSTRAINT "$2" FOREIGN KEY (logged_user) REFERENCES users(id);
849 -- TOC entry 80 (OID 540947)
850 -- Name: pages_user_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
853 ALTER TABLE ONLY pages
854 ADD CONSTRAINT pages_user_cn FOREIGN KEY (hostid, logged_user) REFERENCES users(hostid, id);
858 -- TOC entry 90 (OID 540966)
859 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
862 ALTER TABLE ONLY sitemenu
863 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
867 -- TOC entry 91 (OID 540972)
868 -- Name: sitemenu_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
871 ALTER TABLE ONLY sitemenu
872 ADD CONSTRAINT sitemenu_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
876 -- TOC entry 92 (OID 542613)
877 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
880 ALTER TABLE ONLY contacts
881 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
885 -- TOC entry 93 (OID 542622)
886 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
889 ALTER TABLE ONLY contact_emails
890 ADD CONSTRAINT "$1" FOREIGN KEY (contactid) REFERENCES contacts(id);
894 -- TOC entry 83 (OID 543506)
895 -- Name: hosts_theme_css_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
898 ALTER TABLE ONLY hosts
899 ADD CONSTRAINT hosts_theme_css_cn FOREIGN KEY (theme_css) REFERENCES themes(theme_css);
903 -- TOC entry 94 (OID 543759)
904 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
907 ALTER TABLE ONLY page_emails
908 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
912 -- TOC entry 95 (OID 543764)
913 -- Name: page_emails_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
916 ALTER TABLE ONLY page_emails
917 ADD CONSTRAINT page_emails_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
921 -- TOC entry 96 (OID 543791)
922 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
925 ALTER TABLE ONLY mailing_lists
926 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
930 -- TOC entry 97 (OID 544450)
931 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
934 ALTER TABLE ONLY links
935 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
939 -- TOC entry 98 (OID 544455)
940 -- Name: links_from_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
943 ALTER TABLE ONLY links
944 ADD CONSTRAINT links_from_cn FOREIGN KEY (hostid, from_url) REFERENCES pages(hostid, url) DEFERRABLE;
948 -- TOC entry 3 (OID 2200)
949 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
952 COMMENT ON SCHEMA public IS 'Standard public namespace';
956 -- TOC entry 32 (OID 543592)
957 -- Name: TABLE server_settings; Type: COMMENT; Schema: public; Owner: rich
960 COMMENT ON TABLE server_settings IS 'This table contains global settings for the server. There should be only one row in this table. If you modify any setting, you must restart the webserver for the change to take effect. The "version" field is intended to be some sort of database version, but is currently unused.';
964 -- PostgreSQL database dump
967 SET client_encoding = 'UNICODE';
968 SET check_function_bodies = false;
970 SET search_path = public, pg_catalog;
973 -- Data for TOC entry 3 (OID 547939)
974 -- Name: templates; Type: TABLE DATA; Schema: public; Owner: rich
977 COPY templates (id, title_regexp, url_regexp, extension, ordering) FROM stdin;
978 1 (199[0-9]|20[0-9][0-9])/(0[1-9]|1[0-2])/(0[1-9]|1[0-9]|2[0-9]|3[01]) (199[0-9]|20[0-9][0-9])/(0[1-9]|1[0-2])/(0[1-9]|1[0-9]|2[0-9]|3[01]) calendar 10
979 3 (199[0-9]|20[0-9][0-9])/(0[1-9]|1[0-2]) (199[0-9]|20[0-9][0-9])/(0[1-9]|1[0-2]) calendar 20
980 4 (199[0-9]|20[0-9][0-9]) (199[0-9]|20[0-9][0-9]) calendar 30
985 -- TOC entry 2 (OID 547937)
986 -- Name: templates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rich
989 SELECT pg_catalog.setval('templates_id_seq', 4, true);
993 -- PostgreSQL database dump
996 SET client_encoding = 'UNICODE';
997 SET check_function_bodies = false;
999 SET search_path = public, pg_catalog;
1002 -- Data for TOC entry 2 (OID 543499)
1003 -- Name: themes; Type: TABLE DATA; Schema: public; Owner: rich
1006 COPY themes (theme_css, name, description) FROM stdin;
1007 /_css/easyweb.css Merjis Easy Web Marketing This is the easy web marketing stylesheet developed by Merjis Ltd. Please see http://www.merjis.com/