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 48 (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 49 (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,
109 navigation boolean DEFAULT false NOT NULL
114 -- TOC entry 10 (OID 536371)
115 -- Name: hosts; Type: ACL; Schema: public; Owner: rich
118 REVOKE ALL ON TABLE hosts FROM PUBLIC;
119 GRANT ALL ON TABLE hosts TO "www-data";
123 -- TOC entry 50 (OID 536371)
124 -- Name: hosts_id_seq; Type: ACL; Schema: public; Owner: rich
127 REVOKE ALL ON TABLE hosts_id_seq FROM PUBLIC;
128 GRANT ALL ON TABLE hosts_id_seq TO "www-data";
132 -- TOC entry 11 (OID 536379)
133 -- Name: hostnames; Type: TABLE; Schema: public; Owner: rich
136 CREATE TABLE hostnames (
137 hostid integer NOT NULL,
143 -- TOC entry 12 (OID 536379)
144 -- Name: hostnames; Type: ACL; Schema: public; Owner: rich
147 REVOKE ALL ON TABLE hostnames FROM PUBLIC;
148 GRANT ALL ON TABLE hostnames TO "www-data";
152 -- TOC entry 13 (OID 536915)
153 -- Name: email_notify; Type: TABLE; Schema: public; Owner: rich
156 CREATE TABLE email_notify (
157 hostid integer NOT NULL,
164 -- TOC entry 14 (OID 536915)
165 -- Name: email_notify; Type: ACL; Schema: public; Owner: rich
168 REVOKE ALL ON TABLE email_notify FROM PUBLIC;
169 GRANT ALL ON TABLE email_notify TO "www-data";
173 -- TOC entry 15 (OID 537151)
174 -- Name: images; Type: TABLE; Schema: public; Owner: rich
177 CREATE TABLE images (
179 hostid integer NOT NULL,
182 image bytea NOT NULL,
183 width integer NOT NULL,
184 height integer NOT NULL,
189 mime_type text NOT NULL,
194 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
199 -- TOC entry 16 (OID 537151)
200 -- Name: images; Type: ACL; Schema: public; Owner: rich
203 REVOKE ALL ON TABLE images FROM PUBLIC;
204 GRANT ALL ON TABLE images TO "www-data";
208 -- TOC entry 51 (OID 537151)
209 -- Name: images_id_seq; Type: ACL; Schema: public; Owner: rich
212 REVOKE ALL ON TABLE images_id_seq FROM PUBLIC;
213 GRANT ALL ON TABLE images_id_seq TO "www-data";
217 -- TOC entry 17 (OID 537166)
218 -- Name: files; Type: TABLE; Schema: public; Owner: rich
223 hostid integer NOT NULL,
226 content bytea NOT NULL,
228 mime_type text NOT NULL,
229 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
234 -- TOC entry 18 (OID 537166)
235 -- Name: files; Type: ACL; Schema: public; Owner: rich
238 REVOKE ALL ON TABLE files FROM PUBLIC;
239 GRANT ALL ON TABLE files TO "www-data";
243 -- TOC entry 52 (OID 537166)
244 -- Name: files_id_seq; Type: ACL; Schema: public; Owner: rich
247 REVOKE ALL ON TABLE files_id_seq FROM PUBLIC;
248 GRANT ALL ON TABLE files_id_seq TO "www-data";
252 -- TOC entry 19 (OID 540816)
253 -- Name: users; Type: TABLE; Schema: public; Owner: rich
258 hostid integer NOT NULL,
260 "password" text NOT NULL,
262 registration_date date DEFAULT ('now'::text)::date NOT NULL,
263 can_edit boolean DEFAULT true NOT NULL,
264 can_manage_users boolean DEFAULT false NOT NULL,
265 can_manage_contacts boolean DEFAULT false NOT NULL,
266 can_manage_site boolean DEFAULT false NOT NULL,
267 can_edit_global_css boolean DEFAULT false NOT NULL,
268 force_password_change boolean DEFAULT false NOT NULL
273 -- TOC entry 20 (OID 540816)
274 -- Name: users; Type: ACL; Schema: public; Owner: rich
277 REVOKE ALL ON TABLE users FROM PUBLIC;
278 GRANT ALL ON TABLE users TO "www-data";
282 -- TOC entry 53 (OID 540816)
283 -- Name: users_id_seq; Type: ACL; Schema: public; Owner: rich
286 REVOKE ALL ON TABLE users_id_seq FROM PUBLIC;
287 GRANT ALL ON TABLE users_id_seq TO "www-data";
291 -- TOC entry 21 (OID 540832)
292 -- Name: usercookies; Type: TABLE; Schema: public; Owner: rich
295 CREATE TABLE usercookies (
296 userid integer NOT NULL,
302 -- TOC entry 22 (OID 540832)
303 -- Name: usercookies; Type: ACL; Schema: public; Owner: rich
306 REVOKE ALL ON TABLE usercookies FROM PUBLIC;
307 GRANT ALL ON TABLE usercookies TO "www-data";
311 -- TOC entry 23 (OID 540961)
312 -- Name: sitemenu; Type: TABLE; Schema: public; Owner: rich
315 CREATE TABLE sitemenu (
316 hostid integer NOT NULL,
319 ordering integer NOT NULL
324 -- TOC entry 24 (OID 540961)
325 -- Name: sitemenu; Type: ACL; Schema: public; Owner: rich
328 REVOKE ALL ON TABLE sitemenu FROM PUBLIC;
329 GRANT ALL ON TABLE sitemenu TO "www-data";
333 -- TOC entry 25 (OID 542605)
334 -- Name: contacts; Type: TABLE; Schema: public; Owner: rich
337 CREATE TABLE contacts (
339 hostid integer NOT NULL,
341 subject text NOT NULL
346 -- TOC entry 26 (OID 542605)
347 -- Name: contacts; Type: ACL; Schema: public; Owner: rich
350 REVOKE ALL ON TABLE contacts FROM PUBLIC;
351 GRANT ALL ON TABLE contacts TO "www-data";
355 -- TOC entry 54 (OID 542605)
356 -- Name: contacts_id_seq; Type: ACL; Schema: public; Owner: rich
359 REVOKE ALL ON TABLE contacts_id_seq FROM PUBLIC;
360 GRANT ALL ON TABLE contacts_id_seq TO "www-data";
364 -- TOC entry 27 (OID 542617)
365 -- Name: contact_emails; Type: TABLE; Schema: public; Owner: rich
368 CREATE TABLE contact_emails (
369 contactid integer NOT NULL,
375 -- TOC entry 28 (OID 542617)
376 -- Name: contact_emails; Type: ACL; Schema: public; Owner: rich
379 REVOKE ALL ON TABLE contact_emails FROM PUBLIC;
380 GRANT ALL ON TABLE contact_emails TO "www-data";
384 -- TOC entry 29 (OID 543499)
385 -- Name: themes; Type: TABLE; Schema: public; Owner: rich
388 CREATE TABLE themes (
389 theme_css text NOT NULL,
391 description text NOT NULL
396 -- TOC entry 30 (OID 543499)
397 -- Name: themes; Type: ACL; Schema: public; Owner: rich
400 REVOKE ALL ON TABLE themes FROM PUBLIC;
401 GRANT SELECT ON TABLE themes TO "www-data";
405 -- TOC entry 31 (OID 543592)
406 -- Name: server_settings; Type: TABLE; Schema: public; Owner: rich
409 CREATE TABLE server_settings (
410 "version" integer NOT NULL,
417 -- TOC entry 33 (OID 543592)
418 -- Name: server_settings; Type: ACL; Schema: public; Owner: rich
421 REVOKE ALL ON TABLE server_settings FROM PUBLIC;
422 GRANT SELECT ON TABLE server_settings TO "www-data";
426 -- TOC entry 34 (OID 543754)
427 -- Name: page_emails; Type: TABLE; Schema: public; Owner: rich
430 CREATE TABLE page_emails (
431 hostid integer NOT NULL,
434 entry_date date DEFAULT ('now'::text)::date NOT NULL,
435 last_sent date DEFAULT ('now'::text)::date NOT NULL,
437 opt_out text NOT NULL
442 -- TOC entry 35 (OID 543754)
443 -- Name: page_emails; Type: ACL; Schema: public; Owner: rich
446 REVOKE ALL ON TABLE page_emails FROM PUBLIC;
447 GRANT ALL ON TABLE page_emails TO "www-data";
451 -- TOC entry 36 (OID 543785)
452 -- Name: mailing_lists; Type: TABLE; Schema: public; Owner: rich
455 CREATE TABLE mailing_lists (
456 hostid integer NOT NULL,
458 entry_date date DEFAULT ('now'::text)::date NOT NULL,
460 opt_out text NOT NULL,
466 -- TOC entry 37 (OID 543785)
467 -- Name: mailing_lists; Type: ACL; Schema: public; Owner: rich
470 REVOKE ALL ON TABLE mailing_lists FROM PUBLIC;
471 GRANT ALL ON TABLE mailing_lists TO "www-data";
475 -- TOC entry 38 (OID 544445)
476 -- Name: links; Type: TABLE; Schema: public; Owner: rich
480 hostid integer NOT NULL,
481 from_url text NOT NULL,
482 to_url text NOT NULL,
483 CONSTRAINT links_not_selfref_cn CHECK ((from_url <> to_url))
488 -- TOC entry 39 (OID 544445)
489 -- Name: links; Type: ACL; Schema: public; Owner: rich
492 REVOKE ALL ON TABLE links FROM PUBLIC;
493 GRANT ALL ON TABLE links TO "www-data";
497 -- TOC entry 40 (OID 547939)
498 -- Name: templates; Type: TABLE; Schema: public; Owner: rich
501 CREATE TABLE templates (
503 title_regexp text NOT NULL,
504 url_regexp text NOT NULL,
505 extension text NOT NULL,
506 ordering integer NOT NULL
511 -- TOC entry 41 (OID 547939)
512 -- Name: templates; Type: ACL; Schema: public; Owner: rich
515 REVOKE ALL ON TABLE templates FROM PUBLIC;
516 GRANT SELECT ON TABLE templates TO "www-data";
520 -- TOC entry 55 (OID 547939)
521 -- Name: templates_id_seq; Type: ACL; Schema: public; Owner: rich
524 REVOKE ALL ON TABLE templates_id_seq FROM PUBLIC;
528 -- TOC entry 42 (OID 551123)
529 -- Name: recently_visited; Type: TABLE; Schema: public; Owner: rich
532 CREATE TABLE recently_visited (
533 userid integer NOT NULL,
534 hostid integer NOT NULL,
536 visit_time timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
541 -- TOC entry 43 (OID 551123)
542 -- Name: recently_visited; Type: ACL; Schema: public; Owner: rich
545 REVOKE ALL ON TABLE recently_visited FROM PUBLIC;
546 GRANT ALL ON TABLE recently_visited TO "www-data";
550 -- TOC entry 44 (OID 551675)
551 -- Name: messages; Type: TABLE; Schema: public; Owner: rich
554 CREATE TABLE messages (
556 subject text NOT NULL,
557 inet_message_id text NOT NULL,
558 message_date timestamp with time zone NOT NULL,
559 hostid integer NOT NULL
564 -- TOC entry 45 (OID 551675)
565 -- Name: messages; Type: ACL; Schema: public; Owner: rich
568 REVOKE ALL ON TABLE messages FROM PUBLIC;
569 GRANT ALL ON TABLE messages TO "www-data";
573 -- TOC entry 56 (OID 551675)
574 -- Name: messages_id_seq; Type: ACL; Schema: public; Owner: rich
577 REVOKE ALL ON TABLE messages_id_seq FROM PUBLIC;
578 GRANT ALL ON TABLE messages_id_seq TO "www-data";
582 -- TOC entry 46 (OID 551685)
583 -- Name: msg_references; Type: TABLE; Schema: public; Owner: rich
586 CREATE TABLE msg_references (
587 message_id integer NOT NULL,
588 inet_message_id text NOT NULL
593 -- TOC entry 47 (OID 551685)
594 -- Name: msg_references; Type: ACL; Schema: public; Owner: rich
597 REVOKE ALL ON TABLE msg_references FROM PUBLIC;
598 GRANT ALL ON TABLE msg_references TO "www-data";
602 -- TOC entry 61 (OID 536388)
603 -- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich
606 CREATE UNIQUE INDEX hostnames_hostid_name_uq ON hostnames USING btree (hostid, name);
610 -- TOC entry 62 (OID 536389)
611 -- Name: hostnams_name_uq; Type: INDEX; Schema: public; Owner: rich
614 CREATE UNIQUE INDEX hostnams_name_uq ON hostnames USING btree (name);
618 -- TOC entry 58 (OID 536419)
619 -- Name: pages_url_uq; Type: INDEX; Schema: public; Owner: rich
622 CREATE UNIQUE INDEX pages_url_uq ON pages USING btree (hostid, url);
626 -- TOC entry 63 (OID 536924)
627 -- Name: email_notify_email_uq; Type: INDEX; Schema: public; Owner: rich
630 CREATE UNIQUE INDEX email_notify_email_uq ON email_notify USING btree (hostid, email);
634 -- TOC entry 64 (OID 540251)
635 -- Name: images_name_uq; Type: INDEX; Schema: public; Owner: rich
638 CREATE UNIQUE INDEX images_name_uq ON images USING btree (hostid, name);
642 -- TOC entry 66 (OID 540252)
643 -- Name: files_name_uq; Type: INDEX; Schema: public; Owner: rich
646 CREATE UNIQUE INDEX files_name_uq ON files USING btree (hostid, name);
650 -- TOC entry 69 (OID 540831)
651 -- Name: users_name_uq; Type: INDEX; Schema: public; Owner: rich
654 CREATE UNIQUE INDEX users_name_uq ON users USING btree (hostid, name);
658 -- TOC entry 68 (OID 540946)
659 -- Name: users_id_uq; Type: INDEX; Schema: public; Owner: rich
662 CREATE UNIQUE INDEX users_id_uq ON users USING btree (hostid, id);
666 -- TOC entry 71 (OID 540970)
667 -- Name: sitemenu_ordering_uq; Type: INDEX; Schema: public; Owner: rich
670 CREATE UNIQUE INDEX sitemenu_ordering_uq ON sitemenu USING btree (hostid, ordering);
674 -- TOC entry 72 (OID 540971)
675 -- Name: sitemenu_url_uq; Type: INDEX; Schema: public; Owner: rich
678 CREATE UNIQUE INDEX sitemenu_url_uq ON sitemenu USING btree (hostid, url);
682 -- TOC entry 75 (OID 542626)
683 -- Name: contact_emails_uq; Type: INDEX; Schema: public; Owner: rich
686 CREATE UNIQUE INDEX contact_emails_uq ON contact_emails USING btree (contactid, email);
690 -- TOC entry 76 (OID 543505)
691 -- Name: themes_theme_css_uq; Type: INDEX; Schema: public; Owner: rich
694 CREATE UNIQUE INDEX themes_theme_css_uq ON themes USING btree (theme_css);
698 -- TOC entry 77 (OID 543763)
699 -- Name: page_emails_email_uq; Type: INDEX; Schema: public; Owner: rich
702 CREATE UNIQUE INDEX page_emails_email_uq ON page_emails USING btree (hostid, url, email);
706 -- TOC entry 78 (OID 543795)
707 -- Name: mailing_lists_email_uq; Type: INDEX; Schema: public; Owner: rich
710 CREATE UNIQUE INDEX mailing_lists_email_uq ON mailing_lists USING btree (hostid, email);
714 -- TOC entry 73 (OID 543880)
715 -- Name: contacts_name_uq; Type: INDEX; Schema: public; Owner: rich
718 CREATE UNIQUE INDEX contacts_name_uq ON contacts USING btree (hostid, name);
722 -- TOC entry 79 (OID 544454)
723 -- Name: links_uq; Type: INDEX; Schema: public; Owner: rich
726 CREATE UNIQUE INDEX links_uq ON links USING btree (hostid, from_url, to_url);
730 -- TOC entry 80 (OID 547951)
731 -- Name: templates_ext_ord_uq; Type: INDEX; Schema: public; Owner: rich
734 CREATE UNIQUE INDEX templates_ext_ord_uq ON templates USING btree (extension, ordering);
738 -- TOC entry 82 (OID 547952)
739 -- Name: templates_title_uq; Type: INDEX; Schema: public; Owner: rich
742 CREATE UNIQUE INDEX templates_title_uq ON templates USING btree (title_regexp);
746 -- TOC entry 83 (OID 547953)
747 -- Name: templates_url_uq; Type: INDEX; Schema: public; Owner: rich
750 CREATE UNIQUE INDEX templates_url_uq ON templates USING btree (url_regexp);
754 -- TOC entry 84 (OID 551151)
755 -- Name: recently_visited_uq; Type: INDEX; Schema: public; Owner: rich
758 CREATE UNIQUE INDEX recently_visited_uq ON recently_visited USING btree (userid, hostid, url);
762 -- TOC entry 57 (OID 536012)
763 -- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
766 ALTER TABLE ONLY pages
767 ADD CONSTRAINT pages_pkey PRIMARY KEY (id);
771 -- TOC entry 59 (OID 536027)
772 -- Name: contents_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
775 ALTER TABLE ONLY contents
776 ADD CONSTRAINT contents_pkey PRIMARY KEY (id);
780 -- TOC entry 60 (OID 536377)
781 -- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
784 ALTER TABLE ONLY hosts
785 ADD CONSTRAINT hosts_pkey PRIMARY KEY (id);
789 -- TOC entry 65 (OID 537158)
790 -- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
793 ALTER TABLE ONLY images
794 ADD CONSTRAINT images_pkey PRIMARY KEY (id);
798 -- TOC entry 67 (OID 537173)
799 -- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
802 ALTER TABLE ONLY files
803 ADD CONSTRAINT files_pkey PRIMARY KEY (id);
807 -- TOC entry 70 (OID 540825)
808 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
811 ALTER TABLE ONLY users
812 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
816 -- TOC entry 74 (OID 542611)
817 -- Name: contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
820 ALTER TABLE ONLY contacts
821 ADD CONSTRAINT contacts_pkey PRIMARY KEY (id);
825 -- TOC entry 81 (OID 547945)
826 -- Name: templates_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
829 ALTER TABLE ONLY templates
830 ADD CONSTRAINT templates_pkey PRIMARY KEY (id);
834 -- TOC entry 86 (OID 551681)
835 -- Name: messages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
838 ALTER TABLE ONLY messages
839 ADD CONSTRAINT messages_pkey PRIMARY KEY (id);
843 -- TOC entry 85 (OID 551683)
844 -- Name: messages_inet_message_id_key; Type: CONSTRAINT; Schema: public; Owner: rich
847 ALTER TABLE ONLY messages
848 ADD CONSTRAINT messages_inet_message_id_key UNIQUE (inet_message_id);
852 -- TOC entry 91 (OID 536029)
853 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
856 ALTER TABLE ONLY contents
857 ADD CONSTRAINT "$1" FOREIGN KEY (pageid) REFERENCES pages(id);
861 -- TOC entry 94 (OID 536384)
862 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
865 ALTER TABLE ONLY hostnames
866 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
870 -- TOC entry 92 (OID 536394)
871 -- Name: hosts_hostname_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
874 ALTER TABLE ONLY hosts
875 ADD CONSTRAINT hosts_hostname_cn FOREIGN KEY (id, canonical_hostname) REFERENCES hostnames(hostid, name) DEFERRABLE;
879 -- TOC entry 87 (OID 536404)
880 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
883 ALTER TABLE ONLY pages
884 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
888 -- TOC entry 95 (OID 536920)
889 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
892 ALTER TABLE ONLY email_notify
893 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
897 -- TOC entry 96 (OID 537160)
898 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
901 ALTER TABLE ONLY images
902 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
906 -- TOC entry 97 (OID 537175)
907 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
910 ALTER TABLE ONLY files
911 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
915 -- TOC entry 88 (OID 539155)
916 -- Name: pages_redirect_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
919 ALTER TABLE ONLY pages
920 ADD CONSTRAINT pages_redirect_cn FOREIGN KEY (hostid, redirect) REFERENCES pages(hostid, url) DEFERRABLE;
924 -- TOC entry 98 (OID 540827)
925 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
928 ALTER TABLE ONLY users
929 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
933 -- TOC entry 99 (OID 540837)
934 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
937 ALTER TABLE ONLY usercookies
938 ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
942 -- TOC entry 89 (OID 540942)
943 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
946 ALTER TABLE ONLY pages
947 ADD CONSTRAINT "$2" FOREIGN KEY (logged_user) REFERENCES users(id);
951 -- TOC entry 90 (OID 540947)
952 -- Name: pages_user_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
955 ALTER TABLE ONLY pages
956 ADD CONSTRAINT pages_user_cn FOREIGN KEY (hostid, logged_user) REFERENCES users(hostid, id);
960 -- TOC entry 100 (OID 540966)
961 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
964 ALTER TABLE ONLY sitemenu
965 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
969 -- TOC entry 101 (OID 540972)
970 -- Name: sitemenu_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
973 ALTER TABLE ONLY sitemenu
974 ADD CONSTRAINT sitemenu_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
978 -- TOC entry 102 (OID 542613)
979 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
982 ALTER TABLE ONLY contacts
983 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
987 -- TOC entry 103 (OID 542622)
988 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
991 ALTER TABLE ONLY contact_emails
992 ADD CONSTRAINT "$1" FOREIGN KEY (contactid) REFERENCES contacts(id);
996 -- TOC entry 93 (OID 543506)
997 -- Name: hosts_theme_css_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
1000 ALTER TABLE ONLY hosts
1001 ADD CONSTRAINT hosts_theme_css_cn FOREIGN KEY (theme_css) REFERENCES themes(theme_css);
1005 -- TOC entry 104 (OID 543759)
1006 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
1009 ALTER TABLE ONLY page_emails
1010 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
1014 -- TOC entry 105 (OID 543764)
1015 -- Name: page_emails_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
1018 ALTER TABLE ONLY page_emails
1019 ADD CONSTRAINT page_emails_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
1023 -- TOC entry 106 (OID 543791)
1024 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
1027 ALTER TABLE ONLY mailing_lists
1028 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
1032 -- TOC entry 107 (OID 544450)
1033 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
1036 ALTER TABLE ONLY links
1037 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
1041 -- TOC entry 108 (OID 544455)
1042 -- Name: links_from_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
1045 ALTER TABLE ONLY links
1046 ADD CONSTRAINT links_from_cn FOREIGN KEY (hostid, from_url) REFERENCES pages(hostid, url) DEFERRABLE;
1050 -- TOC entry 109 (OID 551129)
1051 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
1054 ALTER TABLE ONLY recently_visited
1055 ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
1059 -- TOC entry 110 (OID 551133)
1060 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
1063 ALTER TABLE ONLY recently_visited
1064 ADD CONSTRAINT "$2" FOREIGN KEY (hostid) REFERENCES hosts(id);
1068 -- TOC entry 111 (OID 551137)
1069 -- Name: recently_visited_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
1072 ALTER TABLE ONLY recently_visited
1073 ADD CONSTRAINT recently_visited_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
1077 -- TOC entry 112 (OID 551141)
1078 -- Name: recently_visited_userid_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
1081 ALTER TABLE ONLY recently_visited
1082 ADD CONSTRAINT recently_visited_userid_cn FOREIGN KEY (hostid, userid) REFERENCES users(hostid, id);
1086 -- TOC entry 114 (OID 551690)
1087 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
1090 ALTER TABLE ONLY msg_references
1091 ADD CONSTRAINT "$1" FOREIGN KEY (message_id) REFERENCES messages(id);
1095 -- TOC entry 113 (OID 551694)
1096 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
1099 ALTER TABLE ONLY messages
1100 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
1104 -- TOC entry 3 (OID 2200)
1105 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
1108 COMMENT ON SCHEMA public IS 'Standard public namespace';
1112 -- TOC entry 32 (OID 543592)
1113 -- Name: TABLE server_settings; Type: COMMENT; Schema: public; Owner: rich
1116 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.';
1120 -- PostgreSQL database dump
1123 SET client_encoding = 'UNICODE';
1124 SET check_function_bodies = false;
1126 SET search_path = public, pg_catalog;
1129 -- Data for TOC entry 3 (OID 547939)
1130 -- Name: templates; Type: TABLE DATA; Schema: public; Owner: rich
1133 COPY templates (id, title_regexp, url_regexp, extension, ordering) FROM stdin;
1134 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
1135 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
1136 4 ^(199[0-9]|20[0-9][0-9])$ ^(199[0-9]|20[0-9][0-9])$ calendar 30
1141 -- TOC entry 2 (OID 547937)
1142 -- Name: templates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rich
1145 SELECT pg_catalog.setval('templates_id_seq', 4, true);
1149 -- PostgreSQL database dump
1152 SET client_encoding = 'UNICODE';
1153 SET check_function_bodies = false;
1155 SET search_path = public, pg_catalog;
1158 -- Data for TOC entry 2 (OID 543499)
1159 -- Name: themes; Type: TABLE DATA; Schema: public; Owner: rich
1162 COPY themes (theme_css, name, description) FROM stdin;
1163 /_css/easyweb.css Merjis Easy Web Marketing This is the easy web marketing stylesheet developed by Merjis Ltd. Please see http://www.merjis.com/