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 12 (OID 26046)
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,
38 title_description_fti tsvector NOT NULL
43 -- TOC entry 13 (OID 26046)
44 -- Name: pages; Type: ACL; Schema: public; Owner: rich
47 REVOKE ALL ON TABLE pages FROM PUBLIC;
48 GRANT ALL ON TABLE pages TO "www-data";
52 -- TOC entry 65 (OID 26046)
53 -- Name: pages_id_seq; Type: ACL; Schema: public; Owner: rich
56 REVOKE ALL ON TABLE pages_id_seq FROM PUBLIC;
57 GRANT ALL ON TABLE pages_id_seq TO "www-data";
61 -- TOC entry 14 (OID 26056)
62 -- Name: contents; Type: TABLE; Schema: public; Owner: rich
65 CREATE TABLE contents (
67 pageid integer NOT NULL,
68 ordering integer NOT NULL,
70 content text NOT NULL,
72 content_fti tsvector NOT NULL
77 -- TOC entry 15 (OID 26056)
78 -- Name: contents; Type: ACL; Schema: public; Owner: rich
81 REVOKE ALL ON TABLE contents FROM PUBLIC;
82 GRANT ALL ON TABLE contents TO "www-data";
86 -- TOC entry 66 (OID 26056)
87 -- Name: contents_id_seq; Type: ACL; Schema: public; Owner: rich
90 REVOKE ALL ON TABLE contents_id_seq FROM PUBLIC;
91 GRANT ALL ON TABLE contents_id_seq TO "www-data";
95 -- TOC entry 16 (OID 26064)
96 -- Name: hosts; Type: TABLE; Schema: public; Owner: rich
101 canonical_hostname text NOT NULL,
103 edit_anon boolean DEFAULT true NOT NULL,
104 create_account_anon boolean DEFAULT true NOT NULL,
107 mailing_list boolean DEFAULT false NOT NULL,
108 is_template boolean DEFAULT false NOT NULL,
109 search_box boolean DEFAULT true NOT NULL,
110 view_anon boolean DEFAULT true NOT NULL,
111 navigation boolean DEFAULT false NOT NULL,
117 -- TOC entry 17 (OID 26064)
118 -- Name: hosts; Type: ACL; Schema: public; Owner: rich
121 REVOKE ALL ON TABLE hosts FROM PUBLIC;
122 GRANT ALL ON TABLE hosts TO "www-data";
126 -- TOC entry 67 (OID 26064)
127 -- Name: hosts_id_seq; Type: ACL; Schema: public; Owner: rich
130 REVOKE ALL ON TABLE hosts_id_seq FROM PUBLIC;
131 GRANT ALL ON TABLE hosts_id_seq TO "www-data";
135 -- TOC entry 18 (OID 26077)
136 -- Name: hostnames; Type: TABLE; Schema: public; Owner: rich
139 CREATE TABLE hostnames (
140 hostid integer NOT NULL,
146 -- TOC entry 19 (OID 26077)
147 -- Name: hostnames; Type: ACL; Schema: public; Owner: rich
150 REVOKE ALL ON TABLE hostnames FROM PUBLIC;
151 GRANT ALL ON TABLE hostnames TO "www-data";
155 -- TOC entry 20 (OID 26084)
156 -- Name: images; Type: TABLE; Schema: public; Owner: rich
159 CREATE TABLE images (
161 hostid integer NOT NULL,
164 image bytea NOT NULL,
165 width integer NOT NULL,
166 height integer NOT NULL,
171 mime_type text NOT NULL,
176 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
181 -- TOC entry 21 (OID 26084)
182 -- Name: images; Type: ACL; Schema: public; Owner: rich
185 REVOKE ALL ON TABLE images FROM PUBLIC;
186 GRANT ALL ON TABLE images TO "www-data";
190 -- TOC entry 68 (OID 26084)
191 -- Name: images_id_seq; Type: ACL; Schema: public; Owner: rich
194 REVOKE ALL ON TABLE images_id_seq FROM PUBLIC;
195 GRANT ALL ON TABLE images_id_seq TO "www-data";
199 -- TOC entry 22 (OID 26093)
200 -- Name: files; Type: TABLE; Schema: public; Owner: rich
205 hostid integer NOT NULL,
208 content bytea NOT NULL,
210 mime_type text NOT NULL,
211 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
216 -- TOC entry 23 (OID 26093)
217 -- Name: files; Type: ACL; Schema: public; Owner: rich
220 REVOKE ALL ON TABLE files FROM PUBLIC;
221 GRANT ALL ON TABLE files TO "www-data";
225 -- TOC entry 69 (OID 26093)
226 -- Name: files_id_seq; Type: ACL; Schema: public; Owner: rich
229 REVOKE ALL ON TABLE files_id_seq FROM PUBLIC;
230 GRANT ALL ON TABLE files_id_seq TO "www-data";
234 -- TOC entry 24 (OID 26102)
235 -- Name: users; Type: TABLE; Schema: public; Owner: rich
240 hostid integer NOT NULL,
242 "password" text NOT NULL,
244 registration_date date DEFAULT ('now'::text)::date NOT NULL,
245 can_edit boolean DEFAULT true NOT NULL,
246 can_manage_users boolean DEFAULT false NOT NULL,
247 can_manage_contacts boolean DEFAULT false NOT NULL,
248 can_manage_site boolean DEFAULT false NOT NULL,
249 can_edit_global_css boolean DEFAULT false NOT NULL,
250 force_password_change boolean DEFAULT false NOT NULL,
251 can_import_mail boolean DEFAULT false NOT NULL,
252 email_notify boolean DEFAULT true NOT NULL,
258 -- TOC entry 25 (OID 26102)
259 -- Name: users; Type: ACL; Schema: public; Owner: rich
262 REVOKE ALL ON TABLE users FROM PUBLIC;
263 GRANT ALL ON TABLE users TO "www-data";
267 -- TOC entry 70 (OID 26102)
268 -- Name: users_id_seq; Type: ACL; Schema: public; Owner: rich
271 REVOKE ALL ON TABLE users_id_seq FROM PUBLIC;
272 GRANT ALL ON TABLE users_id_seq TO "www-data";
276 -- TOC entry 26 (OID 26117)
277 -- Name: usercookies; Type: TABLE; Schema: public; Owner: rich
280 CREATE TABLE usercookies (
281 userid integer NOT NULL,
287 -- TOC entry 27 (OID 26117)
288 -- Name: usercookies; Type: ACL; Schema: public; Owner: rich
291 REVOKE ALL ON TABLE usercookies FROM PUBLIC;
292 GRANT ALL ON TABLE usercookies TO "www-data";
296 -- TOC entry 28 (OID 26122)
297 -- Name: sitemenu; Type: TABLE; Schema: public; Owner: rich
300 CREATE TABLE sitemenu (
301 hostid integer NOT NULL,
304 ordering integer NOT NULL
309 -- TOC entry 29 (OID 26122)
310 -- Name: sitemenu; Type: ACL; Schema: public; Owner: rich
313 REVOKE ALL ON TABLE sitemenu FROM PUBLIC;
314 GRANT ALL ON TABLE sitemenu TO "www-data";
318 -- TOC entry 30 (OID 26129)
319 -- Name: contacts; Type: TABLE; Schema: public; Owner: rich
322 CREATE TABLE contacts (
324 hostid integer NOT NULL,
326 subject text NOT NULL
331 -- TOC entry 31 (OID 26129)
332 -- Name: contacts; Type: ACL; Schema: public; Owner: rich
335 REVOKE ALL ON TABLE contacts FROM PUBLIC;
336 GRANT ALL ON TABLE contacts TO "www-data";
340 -- TOC entry 71 (OID 26129)
341 -- Name: contacts_id_seq; Type: ACL; Schema: public; Owner: rich
344 REVOKE ALL ON TABLE contacts_id_seq FROM PUBLIC;
345 GRANT ALL ON TABLE contacts_id_seq TO "www-data";
349 -- TOC entry 32 (OID 26135)
350 -- Name: contact_emails; Type: TABLE; Schema: public; Owner: rich
353 CREATE TABLE contact_emails (
354 contactid integer NOT NULL,
360 -- TOC entry 33 (OID 26135)
361 -- Name: contact_emails; Type: ACL; Schema: public; Owner: rich
364 REVOKE ALL ON TABLE contact_emails FROM PUBLIC;
365 GRANT ALL ON TABLE contact_emails TO "www-data";
369 -- TOC entry 34 (OID 26140)
370 -- Name: themes; Type: TABLE; Schema: public; Owner: rich
373 CREATE TABLE themes (
374 theme_css text NOT NULL,
376 description text NOT NULL
381 -- TOC entry 35 (OID 26140)
382 -- Name: themes; Type: ACL; Schema: public; Owner: rich
385 REVOKE ALL ON TABLE themes FROM PUBLIC;
386 GRANT SELECT ON TABLE themes TO "www-data";
390 -- TOC entry 36 (OID 26145)
391 -- Name: server_settings; Type: TABLE; Schema: public; Owner: rich
394 CREATE TABLE server_settings (
395 "version" integer NOT NULL,
402 -- TOC entry 38 (OID 26145)
403 -- Name: server_settings; Type: ACL; Schema: public; Owner: rich
406 REVOKE ALL ON TABLE server_settings FROM PUBLIC;
407 GRANT SELECT ON TABLE server_settings TO "www-data";
411 -- TOC entry 39 (OID 26150)
412 -- Name: page_emails; Type: TABLE; Schema: public; Owner: rich
415 CREATE TABLE page_emails (
416 hostid integer NOT NULL,
419 entry_date date DEFAULT ('now'::text)::date NOT NULL,
420 last_sent date DEFAULT ('now'::text)::date NOT NULL,
422 opt_out text NOT NULL
427 -- TOC entry 40 (OID 26150)
428 -- Name: page_emails; Type: ACL; Schema: public; Owner: rich
431 REVOKE ALL ON TABLE page_emails FROM PUBLIC;
432 GRANT ALL ON TABLE page_emails TO "www-data";
436 -- TOC entry 41 (OID 26157)
437 -- Name: mailing_lists; Type: TABLE; Schema: public; Owner: rich
440 CREATE TABLE mailing_lists (
441 hostid integer NOT NULL,
443 entry_date date DEFAULT ('now'::text)::date NOT NULL,
445 opt_out text NOT NULL,
451 -- TOC entry 42 (OID 26157)
452 -- Name: mailing_lists; Type: ACL; Schema: public; Owner: rich
455 REVOKE ALL ON TABLE mailing_lists FROM PUBLIC;
456 GRANT ALL ON TABLE mailing_lists TO "www-data";
460 -- TOC entry 43 (OID 26163)
461 -- Name: links; Type: TABLE; Schema: public; Owner: rich
465 hostid integer NOT NULL,
466 from_url text NOT NULL,
467 to_url text NOT NULL,
468 CONSTRAINT links_not_selfref_cn CHECK ((from_url <> to_url))
473 -- TOC entry 44 (OID 26163)
474 -- Name: links; Type: ACL; Schema: public; Owner: rich
477 REVOKE ALL ON TABLE links FROM PUBLIC;
478 GRANT ALL ON TABLE links TO "www-data";
482 -- TOC entry 45 (OID 26171)
483 -- Name: templates; Type: TABLE; Schema: public; Owner: rich
486 CREATE TABLE templates (
488 title_regexp text NOT NULL,
489 url_regexp text NOT NULL,
490 extension text NOT NULL,
491 ordering integer NOT NULL
496 -- TOC entry 46 (OID 26171)
497 -- Name: templates; Type: ACL; Schema: public; Owner: rich
500 REVOKE ALL ON TABLE templates FROM PUBLIC;
501 GRANT SELECT ON TABLE templates TO "www-data";
505 -- TOC entry 72 (OID 26171)
506 -- Name: templates_id_seq; Type: ACL; Schema: public; Owner: rich
509 REVOKE ALL ON TABLE templates_id_seq FROM PUBLIC;
513 -- TOC entry 47 (OID 26177)
514 -- Name: recently_visited; Type: TABLE; Schema: public; Owner: rich
517 CREATE TABLE recently_visited (
518 userid integer NOT NULL,
519 hostid integer NOT NULL,
521 visit_time timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
526 -- TOC entry 48 (OID 26177)
527 -- Name: recently_visited; Type: ACL; Schema: public; Owner: rich
530 REVOKE ALL ON TABLE recently_visited FROM PUBLIC;
531 GRANT ALL ON TABLE recently_visited TO "www-data";
535 -- TOC entry 49 (OID 26185)
536 -- Name: messages; Type: TABLE; Schema: public; Owner: rich
539 CREATE TABLE messages (
541 subject text NOT NULL,
542 inet_message_id text NOT NULL,
543 message_date timestamp with time zone NOT NULL,
544 hostid integer NOT NULL
549 -- TOC entry 50 (OID 26185)
550 -- Name: messages; Type: ACL; Schema: public; Owner: rich
553 REVOKE ALL ON TABLE messages FROM PUBLIC;
554 GRANT ALL ON TABLE messages TO "www-data";
558 -- TOC entry 73 (OID 26185)
559 -- Name: messages_id_seq; Type: ACL; Schema: public; Owner: rich
562 REVOKE ALL ON TABLE messages_id_seq FROM PUBLIC;
563 GRANT ALL ON TABLE messages_id_seq TO "www-data";
567 -- TOC entry 51 (OID 26191)
568 -- Name: msg_references; Type: TABLE; Schema: public; Owner: rich
571 CREATE TABLE msg_references (
572 message_id integer NOT NULL,
573 inet_message_id text NOT NULL,
574 ordering integer NOT NULL
579 -- TOC entry 52 (OID 26191)
580 -- Name: msg_references; Type: ACL; Schema: public; Owner: rich
583 REVOKE ALL ON TABLE msg_references FROM PUBLIC;
584 GRANT ALL ON TABLE msg_references TO "www-data";
588 -- TOC entry 53 (OID 26198)
589 -- Name: powered_by; Type: TABLE; Schema: public; Owner: rich
592 CREATE TABLE powered_by (
600 -- TOC entry 54 (OID 26198)
601 -- Name: powered_by; Type: ACL; Schema: public; Owner: rich
604 REVOKE ALL ON TABLE powered_by FROM PUBLIC;
605 GRANT SELECT ON TABLE powered_by TO "www-data";
609 -- TOC entry 55 (OID 26204)
610 -- Name: pending_email_changes; Type: TABLE; Schema: public; Owner: rich
613 CREATE TABLE pending_email_changes (
615 change_date date DEFAULT ('now'::text)::date NOT NULL,
616 userid integer NOT NULL,
622 -- TOC entry 56 (OID 26204)
623 -- Name: pending_email_changes; Type: ACL; Schema: public; Owner: rich
626 REVOKE ALL ON TABLE pending_email_changes FROM PUBLIC;
627 GRANT ALL ON TABLE pending_email_changes TO "www-data";
631 -- TOC entry 57 (OID 50792)
632 -- Name: pg_ts_dict; Type: TABLE; Schema: public; Owner: postgres
635 CREATE TABLE pg_ts_dict (
636 dict_name text NOT NULL,
637 dict_init regprocedure,
638 dict_initoption text,
639 dict_lexize regprocedure NOT NULL,
645 -- TOC entry 58 (OID 50792)
646 -- Name: pg_ts_dict; Type: ACL; Schema: public; Owner: postgres
649 REVOKE ALL ON TABLE pg_ts_dict FROM PUBLIC;
650 GRANT SELECT ON TABLE pg_ts_dict TO rich;
651 GRANT SELECT ON TABLE pg_ts_dict TO "www-data";
655 -- TOC entry 113 (OID 50799)
656 -- Name: lexize(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
659 CREATE FUNCTION lexize(oid, text) RETURNS text[]
660 AS '$libdir/tsearch2', 'lexize'
665 -- TOC entry 114 (OID 50800)
666 -- Name: lexize(text, text); Type: FUNCTION; Schema: public; Owner: postgres
669 CREATE FUNCTION lexize(text, text) RETURNS text[]
670 AS '$libdir/tsearch2', 'lexize_byname'
675 -- TOC entry 115 (OID 50801)
676 -- Name: lexize(text); Type: FUNCTION; Schema: public; Owner: postgres
679 CREATE FUNCTION lexize(text) RETURNS text[]
680 AS '$libdir/tsearch2', 'lexize_bycurrent'
685 -- TOC entry 116 (OID 50802)
686 -- Name: set_curdict(integer); Type: FUNCTION; Schema: public; Owner: postgres
689 CREATE FUNCTION set_curdict(integer) RETURNS void
690 AS '$libdir/tsearch2', 'set_curdict'
695 -- TOC entry 117 (OID 50803)
696 -- Name: set_curdict(text); Type: FUNCTION; Schema: public; Owner: postgres
699 CREATE FUNCTION set_curdict(text) RETURNS void
700 AS '$libdir/tsearch2', 'set_curdict_byname'
705 -- TOC entry 118 (OID 50804)
706 -- Name: dex_init(text); Type: FUNCTION; Schema: public; Owner: postgres
709 CREATE FUNCTION dex_init(text) RETURNS internal
710 AS '$libdir/tsearch2', 'dex_init'
715 -- TOC entry 119 (OID 50805)
716 -- Name: dex_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
719 CREATE FUNCTION dex_lexize(internal, internal, integer) RETURNS internal
720 AS '$libdir/tsearch2', 'dex_lexize'
725 -- TOC entry 120 (OID 50807)
726 -- Name: snb_en_init(text); Type: FUNCTION; Schema: public; Owner: postgres
729 CREATE FUNCTION snb_en_init(text) RETURNS internal
730 AS '$libdir/tsearch2', 'snb_en_init'
735 -- TOC entry 121 (OID 50808)
736 -- Name: snb_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
739 CREATE FUNCTION snb_lexize(internal, internal, integer) RETURNS internal
740 AS '$libdir/tsearch2', 'snb_lexize'
745 -- TOC entry 122 (OID 50810)
746 -- Name: snb_ru_init(text); Type: FUNCTION; Schema: public; Owner: postgres
749 CREATE FUNCTION snb_ru_init(text) RETURNS internal
750 AS '$libdir/tsearch2', 'snb_ru_init'
755 -- TOC entry 123 (OID 50812)
756 -- Name: spell_init(text); Type: FUNCTION; Schema: public; Owner: postgres
759 CREATE FUNCTION spell_init(text) RETURNS internal
760 AS '$libdir/tsearch2', 'spell_init'
765 -- TOC entry 124 (OID 50813)
766 -- Name: spell_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
769 CREATE FUNCTION spell_lexize(internal, internal, integer) RETURNS internal
770 AS '$libdir/tsearch2', 'spell_lexize'
775 -- TOC entry 125 (OID 50815)
776 -- Name: syn_init(text); Type: FUNCTION; Schema: public; Owner: postgres
779 CREATE FUNCTION syn_init(text) RETURNS internal
780 AS '$libdir/tsearch2', 'syn_init'
785 -- TOC entry 126 (OID 50816)
786 -- Name: syn_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
789 CREATE FUNCTION syn_lexize(internal, internal, integer) RETURNS internal
790 AS '$libdir/tsearch2', 'syn_lexize'
795 -- TOC entry 59 (OID 50818)
796 -- Name: pg_ts_parser; Type: TABLE; Schema: public; Owner: postgres
799 CREATE TABLE pg_ts_parser (
800 prs_name text NOT NULL,
801 prs_start regprocedure NOT NULL,
802 prs_nexttoken regprocedure NOT NULL,
803 prs_end regprocedure NOT NULL,
804 prs_headline regprocedure NOT NULL,
805 prs_lextype regprocedure NOT NULL,
811 -- TOC entry 60 (OID 50818)
812 -- Name: pg_ts_parser; Type: ACL; Schema: public; Owner: postgres
815 REVOKE ALL ON TABLE pg_ts_parser FROM PUBLIC;
816 GRANT SELECT ON TABLE pg_ts_parser TO rich;
817 GRANT SELECT ON TABLE pg_ts_parser TO "www-data";
821 -- TOC entry 5 (OID 50826)
822 -- Name: tokentype; Type: TYPE; Schema: public; Owner: postgres
825 CREATE TYPE tokentype AS (
833 -- TOC entry 127 (OID 50827)
834 -- Name: token_type(integer); Type: FUNCTION; Schema: public; Owner: postgres
837 CREATE FUNCTION token_type(integer) RETURNS SETOF tokentype
838 AS '$libdir/tsearch2', 'token_type'
843 -- TOC entry 128 (OID 50828)
844 -- Name: token_type(text); Type: FUNCTION; Schema: public; Owner: postgres
847 CREATE FUNCTION token_type(text) RETURNS SETOF tokentype
848 AS '$libdir/tsearch2', 'token_type_byname'
853 -- TOC entry 129 (OID 50829)
854 -- Name: token_type(); Type: FUNCTION; Schema: public; Owner: postgres
857 CREATE FUNCTION token_type() RETURNS SETOF tokentype
858 AS '$libdir/tsearch2', 'token_type_current'
863 -- TOC entry 130 (OID 50830)
864 -- Name: set_curprs(integer); Type: FUNCTION; Schema: public; Owner: postgres
867 CREATE FUNCTION set_curprs(integer) RETURNS void
868 AS '$libdir/tsearch2', 'set_curprs'
873 -- TOC entry 131 (OID 50831)
874 -- Name: set_curprs(text); Type: FUNCTION; Schema: public; Owner: postgres
877 CREATE FUNCTION set_curprs(text) RETURNS void
878 AS '$libdir/tsearch2', 'set_curprs_byname'
883 -- TOC entry 6 (OID 50833)
884 -- Name: tokenout; Type: TYPE; Schema: public; Owner: postgres
887 CREATE TYPE tokenout AS (
894 -- TOC entry 132 (OID 50834)
895 -- Name: parse(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
898 CREATE FUNCTION parse(oid, text) RETURNS SETOF tokenout
899 AS '$libdir/tsearch2', 'parse'
904 -- TOC entry 133 (OID 50835)
905 -- Name: parse(text, text); Type: FUNCTION; Schema: public; Owner: postgres
908 CREATE FUNCTION parse(text, text) RETURNS SETOF tokenout
909 AS '$libdir/tsearch2', 'parse_byname'
914 -- TOC entry 134 (OID 50836)
915 -- Name: parse(text); Type: FUNCTION; Schema: public; Owner: postgres
918 CREATE FUNCTION parse(text) RETURNS SETOF tokenout
919 AS '$libdir/tsearch2', 'parse_current'
924 -- TOC entry 135 (OID 50837)
925 -- Name: prsd_start(internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
928 CREATE FUNCTION prsd_start(internal, integer) RETURNS internal
929 AS '$libdir/tsearch2', 'prsd_start'
934 -- TOC entry 136 (OID 50838)
935 -- Name: prsd_getlexeme(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
938 CREATE FUNCTION prsd_getlexeme(internal, internal, internal) RETURNS integer
939 AS '$libdir/tsearch2', 'prsd_getlexeme'
944 -- TOC entry 137 (OID 50839)
945 -- Name: prsd_end(internal); Type: FUNCTION; Schema: public; Owner: postgres
948 CREATE FUNCTION prsd_end(internal) RETURNS void
949 AS '$libdir/tsearch2', 'prsd_end'
954 -- TOC entry 138 (OID 50840)
955 -- Name: prsd_lextype(internal); Type: FUNCTION; Schema: public; Owner: postgres
958 CREATE FUNCTION prsd_lextype(internal) RETURNS internal
959 AS '$libdir/tsearch2', 'prsd_lextype'
964 -- TOC entry 139 (OID 50841)
965 -- Name: prsd_headline(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
968 CREATE FUNCTION prsd_headline(internal, internal, internal) RETURNS internal
969 AS '$libdir/tsearch2', 'prsd_headline'
974 -- TOC entry 61 (OID 50843)
975 -- Name: pg_ts_cfg; Type: TABLE; Schema: public; Owner: postgres
978 CREATE TABLE pg_ts_cfg (
979 ts_name text NOT NULL,
980 prs_name text NOT NULL,
986 -- TOC entry 62 (OID 50843)
987 -- Name: pg_ts_cfg; Type: ACL; Schema: public; Owner: postgres
990 REVOKE ALL ON TABLE pg_ts_cfg FROM PUBLIC;
991 GRANT SELECT ON TABLE pg_ts_cfg TO rich;
992 GRANT SELECT ON TABLE pg_ts_cfg TO "www-data";
996 -- TOC entry 63 (OID 50850)
997 -- Name: pg_ts_cfgmap; Type: TABLE; Schema: public; Owner: postgres
1000 CREATE TABLE pg_ts_cfgmap (
1001 ts_name text NOT NULL,
1002 tok_alias text NOT NULL,
1008 -- TOC entry 64 (OID 50850)
1009 -- Name: pg_ts_cfgmap; Type: ACL; Schema: public; Owner: postgres
1012 REVOKE ALL ON TABLE pg_ts_cfgmap FROM PUBLIC;
1013 GRANT SELECT ON TABLE pg_ts_cfgmap TO rich;
1014 GRANT SELECT ON TABLE pg_ts_cfgmap TO "www-data";
1018 -- TOC entry 140 (OID 50857)
1019 -- Name: set_curcfg(integer); Type: FUNCTION; Schema: public; Owner: postgres
1022 CREATE FUNCTION set_curcfg(integer) RETURNS void
1023 AS '$libdir/tsearch2', 'set_curcfg'
1028 -- TOC entry 141 (OID 50858)
1029 -- Name: set_curcfg(text); Type: FUNCTION; Schema: public; Owner: postgres
1032 CREATE FUNCTION set_curcfg(text) RETURNS void
1033 AS '$libdir/tsearch2', 'set_curcfg_byname'
1038 -- TOC entry 142 (OID 50859)
1039 -- Name: show_curcfg(); Type: FUNCTION; Schema: public; Owner: postgres
1042 CREATE FUNCTION show_curcfg() RETURNS oid
1043 AS '$libdir/tsearch2', 'show_curcfg'
1048 -- TOC entry 143 (OID 50921)
1049 -- Name: tsvector_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
1052 CREATE FUNCTION tsvector_in(cstring) RETURNS tsvector
1053 AS '$libdir/tsearch2', 'tsvector_in'
1058 -- TOC entry 144 (OID 50922)
1059 -- Name: tsvector_out(tsvector); Type: FUNCTION; Schema: public; Owner: postgres
1062 CREATE FUNCTION tsvector_out(tsvector) RETURNS cstring
1063 AS '$libdir/tsearch2', 'tsvector_out'
1068 -- TOC entry 7 (OID 50920)
1069 -- Name: tsvector; Type: TYPE; Schema: public; Owner: postgres
1072 CREATE TYPE tsvector (
1073 INTERNALLENGTH = variable,
1074 INPUT = tsvector_in,
1075 OUTPUT = tsvector_out,
1082 -- TOC entry 145 (OID 50924)
1083 -- Name: length(tsvector); Type: FUNCTION; Schema: public; Owner: postgres
1086 CREATE FUNCTION length(tsvector) RETURNS integer
1087 AS '$libdir/tsearch2', 'tsvector_length'
1088 LANGUAGE c IMMUTABLE STRICT;
1092 -- TOC entry 146 (OID 50925)
1093 -- Name: to_tsvector(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
1096 CREATE FUNCTION to_tsvector(oid, text) RETURNS tsvector
1097 AS '$libdir/tsearch2', 'to_tsvector'
1098 LANGUAGE c IMMUTABLE STRICT;
1102 -- TOC entry 147 (OID 50926)
1103 -- Name: to_tsvector(text, text); Type: FUNCTION; Schema: public; Owner: postgres
1106 CREATE FUNCTION to_tsvector(text, text) RETURNS tsvector
1107 AS '$libdir/tsearch2', 'to_tsvector_name'
1108 LANGUAGE c IMMUTABLE STRICT;
1112 -- TOC entry 148 (OID 50927)
1113 -- Name: to_tsvector(text); Type: FUNCTION; Schema: public; Owner: postgres
1116 CREATE FUNCTION to_tsvector(text) RETURNS tsvector
1117 AS '$libdir/tsearch2', 'to_tsvector_current'
1118 LANGUAGE c IMMUTABLE STRICT;
1122 -- TOC entry 149 (OID 50928)
1123 -- Name: strip(tsvector); Type: FUNCTION; Schema: public; Owner: postgres
1126 CREATE FUNCTION strip(tsvector) RETURNS tsvector
1127 AS '$libdir/tsearch2', 'strip'
1128 LANGUAGE c IMMUTABLE STRICT;
1132 -- TOC entry 150 (OID 50929)
1133 -- Name: setweight(tsvector, "char"); Type: FUNCTION; Schema: public; Owner: postgres
1136 CREATE FUNCTION setweight(tsvector, "char") RETURNS tsvector
1137 AS '$libdir/tsearch2', 'setweight'
1138 LANGUAGE c IMMUTABLE STRICT;
1142 -- TOC entry 151 (OID 50930)
1143 -- Name: concat(tsvector, tsvector); Type: FUNCTION; Schema: public; Owner: postgres
1146 CREATE FUNCTION concat(tsvector, tsvector) RETURNS tsvector
1147 AS '$libdir/tsearch2', 'concat'
1148 LANGUAGE c IMMUTABLE STRICT;
1152 -- TOC entry 191 (OID 50931)
1153 -- Name: ||; Type: OPERATOR; Schema: public; Owner: postgres
1156 CREATE OPERATOR || (
1164 -- TOC entry 152 (OID 50933)
1165 -- Name: tsquery_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
1168 CREATE FUNCTION tsquery_in(cstring) RETURNS tsquery
1169 AS '$libdir/tsearch2', 'tsquery_in'
1174 -- TOC entry 153 (OID 50934)
1175 -- Name: tsquery_out(tsquery); Type: FUNCTION; Schema: public; Owner: postgres
1178 CREATE FUNCTION tsquery_out(tsquery) RETURNS cstring
1179 AS '$libdir/tsearch2', 'tsquery_out'
1184 -- TOC entry 8 (OID 50932)
1185 -- Name: tsquery; Type: TYPE; Schema: public; Owner: postgres
1188 CREATE TYPE tsquery (
1189 INTERNALLENGTH = variable,
1191 OUTPUT = tsquery_out,
1198 -- TOC entry 154 (OID 50936)
1199 -- Name: querytree(tsquery); Type: FUNCTION; Schema: public; Owner: postgres
1202 CREATE FUNCTION querytree(tsquery) RETURNS text
1203 AS '$libdir/tsearch2', 'tsquerytree'
1208 -- TOC entry 155 (OID 50937)
1209 -- Name: to_tsquery(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
1212 CREATE FUNCTION to_tsquery(oid, text) RETURNS tsquery
1213 AS '$libdir/tsearch2', 'to_tsquery'
1214 LANGUAGE c IMMUTABLE STRICT;
1218 -- TOC entry 156 (OID 50938)
1219 -- Name: to_tsquery(text, text); Type: FUNCTION; Schema: public; Owner: postgres
1222 CREATE FUNCTION to_tsquery(text, text) RETURNS tsquery
1223 AS '$libdir/tsearch2', 'to_tsquery_name'
1224 LANGUAGE c IMMUTABLE STRICT;
1228 -- TOC entry 157 (OID 50939)
1229 -- Name: to_tsquery(text); Type: FUNCTION; Schema: public; Owner: postgres
1232 CREATE FUNCTION to_tsquery(text) RETURNS tsquery
1233 AS '$libdir/tsearch2', 'to_tsquery_current'
1234 LANGUAGE c IMMUTABLE STRICT;
1238 -- TOC entry 158 (OID 50940)
1239 -- Name: exectsq(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
1242 CREATE FUNCTION exectsq(tsvector, tsquery) RETURNS boolean
1243 AS '$libdir/tsearch2', 'exectsq'
1244 LANGUAGE c IMMUTABLE STRICT;
1248 -- TOC entry 160 (OID 50941)
1249 -- Name: rexectsq(tsquery, tsvector); Type: FUNCTION; Schema: public; Owner: postgres
1252 CREATE FUNCTION rexectsq(tsquery, tsvector) RETURNS boolean
1253 AS '$libdir/tsearch2', 'rexectsq'
1254 LANGUAGE c IMMUTABLE STRICT;
1258 -- TOC entry 193 (OID 50942)
1259 -- Name: @@; Type: OPERATOR; Schema: public; Owner: postgres
1262 CREATE OPERATOR @@ (
1263 PROCEDURE = rexectsq,
1265 RIGHTARG = tsvector,
1273 -- TOC entry 192 (OID 50943)
1274 -- Name: @@; Type: OPERATOR; Schema: public; Owner: postgres
1277 CREATE OPERATOR @@ (
1278 PROCEDURE = exectsq,
1288 -- TOC entry 162 (OID 50944)
1289 -- Name: tsearch2(); Type: FUNCTION; Schema: public; Owner: postgres
1292 CREATE FUNCTION tsearch2() RETURNS "trigger"
1293 AS '$libdir/tsearch2', 'tsearch2'
1298 -- TOC entry 163 (OID 50945)
1299 -- Name: rank(real[], tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
1302 CREATE FUNCTION rank(real[], tsvector, tsquery) RETURNS real
1303 AS '$libdir/tsearch2', 'rank'
1304 LANGUAGE c IMMUTABLE STRICT;
1308 -- TOC entry 164 (OID 50946)
1309 -- Name: rank(real[], tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
1312 CREATE FUNCTION rank(real[], tsvector, tsquery, integer) RETURNS real
1313 AS '$libdir/tsearch2', 'rank'
1314 LANGUAGE c IMMUTABLE STRICT;
1318 -- TOC entry 165 (OID 50947)
1319 -- Name: rank(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
1322 CREATE FUNCTION rank(tsvector, tsquery) RETURNS real
1323 AS '$libdir/tsearch2', 'rank_def'
1324 LANGUAGE c IMMUTABLE STRICT;
1328 -- TOC entry 166 (OID 50948)
1329 -- Name: rank(tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
1332 CREATE FUNCTION rank(tsvector, tsquery, integer) RETURNS real
1333 AS '$libdir/tsearch2', 'rank_def'
1334 LANGUAGE c IMMUTABLE STRICT;
1338 -- TOC entry 167 (OID 50949)
1339 -- Name: rank_cd(integer, tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
1342 CREATE FUNCTION rank_cd(integer, tsvector, tsquery) RETURNS real
1343 AS '$libdir/tsearch2', 'rank_cd'
1344 LANGUAGE c IMMUTABLE STRICT;
1348 -- TOC entry 168 (OID 50950)
1349 -- Name: rank_cd(integer, tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
1352 CREATE FUNCTION rank_cd(integer, tsvector, tsquery, integer) RETURNS real
1353 AS '$libdir/tsearch2', 'rank_cd'
1354 LANGUAGE c IMMUTABLE STRICT;
1358 -- TOC entry 169 (OID 50951)
1359 -- Name: rank_cd(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
1362 CREATE FUNCTION rank_cd(tsvector, tsquery) RETURNS real
1363 AS '$libdir/tsearch2', 'rank_cd_def'
1364 LANGUAGE c IMMUTABLE STRICT;
1368 -- TOC entry 170 (OID 50952)
1369 -- Name: rank_cd(tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
1372 CREATE FUNCTION rank_cd(tsvector, tsquery, integer) RETURNS real
1373 AS '$libdir/tsearch2', 'rank_cd_def'
1374 LANGUAGE c IMMUTABLE STRICT;
1378 -- TOC entry 171 (OID 50953)
1379 -- Name: headline(oid, text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
1382 CREATE FUNCTION headline(oid, text, tsquery, text) RETURNS text
1383 AS '$libdir/tsearch2', 'headline'
1384 LANGUAGE c IMMUTABLE STRICT;
1388 -- TOC entry 172 (OID 50954)
1389 -- Name: headline(oid, text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
1392 CREATE FUNCTION headline(oid, text, tsquery) RETURNS text
1393 AS '$libdir/tsearch2', 'headline'
1394 LANGUAGE c IMMUTABLE STRICT;
1398 -- TOC entry 173 (OID 50955)
1399 -- Name: headline(text, text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
1402 CREATE FUNCTION headline(text, text, tsquery, text) RETURNS text
1403 AS '$libdir/tsearch2', 'headline_byname'
1404 LANGUAGE c IMMUTABLE STRICT;
1408 -- TOC entry 174 (OID 50956)
1409 -- Name: headline(text, text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
1412 CREATE FUNCTION headline(text, text, tsquery) RETURNS text
1413 AS '$libdir/tsearch2', 'headline_byname'
1414 LANGUAGE c IMMUTABLE STRICT;
1418 -- TOC entry 175 (OID 50957)
1419 -- Name: headline(text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
1422 CREATE FUNCTION headline(text, tsquery, text) RETURNS text
1423 AS '$libdir/tsearch2', 'headline_current'
1424 LANGUAGE c IMMUTABLE STRICT;
1428 -- TOC entry 176 (OID 50958)
1429 -- Name: headline(text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
1432 CREATE FUNCTION headline(text, tsquery) RETURNS text
1433 AS '$libdir/tsearch2', 'headline_current'
1434 LANGUAGE c IMMUTABLE STRICT;
1438 -- TOC entry 177 (OID 50960)
1439 -- Name: gtsvector_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
1442 CREATE FUNCTION gtsvector_in(cstring) RETURNS gtsvector
1443 AS '$libdir/tsearch2', 'gtsvector_in'
1448 -- TOC entry 178 (OID 50961)
1449 -- Name: gtsvector_out(gtsvector); Type: FUNCTION; Schema: public; Owner: postgres
1452 CREATE FUNCTION gtsvector_out(gtsvector) RETURNS cstring
1453 AS '$libdir/tsearch2', 'gtsvector_out'
1458 -- TOC entry 9 (OID 50959)
1459 -- Name: gtsvector; Type: TYPE; Schema: public; Owner: postgres
1462 CREATE TYPE gtsvector (
1463 INTERNALLENGTH = variable,
1464 INPUT = gtsvector_in,
1465 OUTPUT = gtsvector_out,
1472 -- TOC entry 179 (OID 50963)
1473 -- Name: gtsvector_consistent(gtsvector, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
1476 CREATE FUNCTION gtsvector_consistent(gtsvector, internal, integer) RETURNS boolean
1477 AS '$libdir/tsearch2', 'gtsvector_consistent'
1482 -- TOC entry 180 (OID 50964)
1483 -- Name: gtsvector_compress(internal); Type: FUNCTION; Schema: public; Owner: postgres
1486 CREATE FUNCTION gtsvector_compress(internal) RETURNS internal
1487 AS '$libdir/tsearch2', 'gtsvector_compress'
1492 -- TOC entry 181 (OID 50965)
1493 -- Name: gtsvector_decompress(internal); Type: FUNCTION; Schema: public; Owner: postgres
1496 CREATE FUNCTION gtsvector_decompress(internal) RETURNS internal
1497 AS '$libdir/tsearch2', 'gtsvector_decompress'
1502 -- TOC entry 182 (OID 50966)
1503 -- Name: gtsvector_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
1506 CREATE FUNCTION gtsvector_penalty(internal, internal, internal) RETURNS internal
1507 AS '$libdir/tsearch2', 'gtsvector_penalty'
1512 -- TOC entry 183 (OID 50967)
1513 -- Name: gtsvector_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
1516 CREATE FUNCTION gtsvector_picksplit(internal, internal) RETURNS internal
1517 AS '$libdir/tsearch2', 'gtsvector_picksplit'
1522 -- TOC entry 184 (OID 50968)
1523 -- Name: gtsvector_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: postgres
1526 CREATE FUNCTION gtsvector_union(bytea, internal) RETURNS integer[]
1527 AS '$libdir/tsearch2', 'gtsvector_union'
1532 -- TOC entry 185 (OID 50969)
1533 -- Name: gtsvector_same(gtsvector, gtsvector, internal); Type: FUNCTION; Schema: public; Owner: postgres
1536 CREATE FUNCTION gtsvector_same(gtsvector, gtsvector, internal) RETURNS internal
1537 AS '$libdir/tsearch2', 'gtsvector_same'
1542 -- TOC entry 194 (OID 50970)
1543 -- Name: gist_tsvector_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
1546 CREATE OPERATOR CLASS gist_tsvector_ops
1547 DEFAULT FOR TYPE tsvector USING gist AS
1549 OPERATOR 1 @@(tsvector,tsquery) RECHECK ,
1550 FUNCTION 1 gtsvector_consistent(gtsvector,internal,integer) ,
1551 FUNCTION 2 gtsvector_union(bytea,internal) ,
1552 FUNCTION 3 gtsvector_compress(internal) ,
1553 FUNCTION 4 gtsvector_decompress(internal) ,
1554 FUNCTION 5 gtsvector_penalty(internal,internal,internal) ,
1555 FUNCTION 6 gtsvector_picksplit(internal,internal) ,
1556 FUNCTION 7 gtsvector_same(gtsvector,gtsvector,internal);
1560 -- TOC entry 10 (OID 50972)
1561 -- Name: statinfo; Type: TYPE; Schema: public; Owner: postgres
1564 CREATE TYPE statinfo AS (
1572 -- TOC entry 186 (OID 50973)
1573 -- Name: stat(text); Type: FUNCTION; Schema: public; Owner: postgres
1576 CREATE FUNCTION stat(text) RETURNS SETOF statinfo
1577 AS '$libdir/tsearch2', 'ts_stat'
1582 -- TOC entry 187 (OID 50974)
1583 -- Name: reset_tsearch(); Type: FUNCTION; Schema: public; Owner: postgres
1586 CREATE FUNCTION reset_tsearch() RETURNS void
1587 AS '$libdir/tsearch2', 'reset_tsearch'
1592 -- TOC entry 188 (OID 50975)
1593 -- Name: get_covers(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
1596 CREATE FUNCTION get_covers(tsvector, tsquery) RETURNS text
1597 AS '$libdir/tsearch2', 'get_covers'
1602 -- TOC entry 11 (OID 50977)
1603 -- Name: tsdebug; Type: TYPE; Schema: public; Owner: postgres
1606 CREATE TYPE tsdebug AS (
1617 -- TOC entry 189 (OID 50978)
1618 -- Name: _get_parser_from_curcfg(); Type: FUNCTION; Schema: public; Owner: postgres
1621 CREATE FUNCTION _get_parser_from_curcfg() RETURNS text
1622 AS ' select prs_name from pg_ts_cfg where oid = show_curcfg() '
1623 LANGUAGE sql IMMUTABLE STRICT;
1627 -- TOC entry 190 (OID 50979)
1628 -- Name: ts_debug(text); Type: FUNCTION; Schema: public; Owner: postgres
1631 CREATE FUNCTION ts_debug(text) RETURNS SETOF tsdebug
1635 t.alias as tok_type,
1636 t.descr as description,
1639 strip(to_tsvector(p.token)) as tsvector
1641 parse( _get_parser_from_curcfg(), $1 ) as p,
1647 t.alias = m.tok_alias and
1648 m.ts_name=c.ts_name and
1651 LANGUAGE sql STRICT;
1655 -- TOC entry 82 (OID 50632)
1656 -- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich
1659 CREATE UNIQUE INDEX hostnames_hostid_name_uq ON hostnames USING btree (hostid, name);
1663 -- TOC entry 83 (OID 50633)
1664 -- Name: hostnams_name_uq; Type: INDEX; Schema: public; Owner: rich
1667 CREATE UNIQUE INDEX hostnams_name_uq ON hostnames USING btree (name);
1671 -- TOC entry 78 (OID 50634)
1672 -- Name: pages_url_uq; Type: INDEX; Schema: public; Owner: rich
1675 CREATE UNIQUE INDEX pages_url_uq ON pages USING btree (hostid, url);
1679 -- TOC entry 84 (OID 50635)
1680 -- Name: images_name_uq; Type: INDEX; Schema: public; Owner: rich
1683 CREATE UNIQUE INDEX images_name_uq ON images USING btree (hostid, name);
1687 -- TOC entry 86 (OID 50636)
1688 -- Name: files_name_uq; Type: INDEX; Schema: public; Owner: rich
1691 CREATE UNIQUE INDEX files_name_uq ON files USING btree (hostid, name);
1695 -- TOC entry 89 (OID 50637)
1696 -- Name: users_name_uq; Type: INDEX; Schema: public; Owner: rich
1699 CREATE UNIQUE INDEX users_name_uq ON users USING btree (hostid, name);
1703 -- TOC entry 88 (OID 50638)
1704 -- Name: users_id_uq; Type: INDEX; Schema: public; Owner: rich
1707 CREATE UNIQUE INDEX users_id_uq ON users USING btree (hostid, id);
1711 -- TOC entry 91 (OID 50639)
1712 -- Name: sitemenu_ordering_uq; Type: INDEX; Schema: public; Owner: rich
1715 CREATE UNIQUE INDEX sitemenu_ordering_uq ON sitemenu USING btree (hostid, ordering);
1719 -- TOC entry 92 (OID 50640)
1720 -- Name: sitemenu_url_uq; Type: INDEX; Schema: public; Owner: rich
1723 CREATE UNIQUE INDEX sitemenu_url_uq ON sitemenu USING btree (hostid, url);
1727 -- TOC entry 95 (OID 50641)
1728 -- Name: contact_emails_uq; Type: INDEX; Schema: public; Owner: rich
1731 CREATE UNIQUE INDEX contact_emails_uq ON contact_emails USING btree (contactid, email);
1735 -- TOC entry 96 (OID 50642)
1736 -- Name: themes_theme_css_uq; Type: INDEX; Schema: public; Owner: rich
1739 CREATE UNIQUE INDEX themes_theme_css_uq ON themes USING btree (theme_css);
1743 -- TOC entry 97 (OID 50643)
1744 -- Name: page_emails_email_uq; Type: INDEX; Schema: public; Owner: rich
1747 CREATE UNIQUE INDEX page_emails_email_uq ON page_emails USING btree (hostid, url, email);
1751 -- TOC entry 98 (OID 50644)
1752 -- Name: mailing_lists_email_uq; Type: INDEX; Schema: public; Owner: rich
1755 CREATE UNIQUE INDEX mailing_lists_email_uq ON mailing_lists USING btree (hostid, email);
1759 -- TOC entry 93 (OID 50645)
1760 -- Name: contacts_name_uq; Type: INDEX; Schema: public; Owner: rich
1763 CREATE UNIQUE INDEX contacts_name_uq ON contacts USING btree (hostid, name);
1767 -- TOC entry 99 (OID 50646)
1768 -- Name: links_uq; Type: INDEX; Schema: public; Owner: rich
1771 CREATE UNIQUE INDEX links_uq ON links USING btree (hostid, from_url, to_url);
1775 -- TOC entry 100 (OID 50647)
1776 -- Name: templates_ext_ord_uq; Type: INDEX; Schema: public; Owner: rich
1779 CREATE UNIQUE INDEX templates_ext_ord_uq ON templates USING btree (extension, ordering);
1783 -- TOC entry 102 (OID 50648)
1784 -- Name: templates_title_uq; Type: INDEX; Schema: public; Owner: rich
1787 CREATE UNIQUE INDEX templates_title_uq ON templates USING btree (title_regexp);
1791 -- TOC entry 103 (OID 50649)
1792 -- Name: templates_url_uq; Type: INDEX; Schema: public; Owner: rich
1795 CREATE UNIQUE INDEX templates_url_uq ON templates USING btree (url_regexp);
1799 -- TOC entry 104 (OID 50650)
1800 -- Name: recently_visited_uq; Type: INDEX; Schema: public; Owner: rich
1803 CREATE UNIQUE INDEX recently_visited_uq ON recently_visited USING btree (userid, hostid, url);
1807 -- TOC entry 105 (OID 50651)
1808 -- Name: messages_inet_message_id_uq; Type: INDEX; Schema: public; Owner: rich
1811 CREATE UNIQUE INDEX messages_inet_message_id_uq ON messages USING btree (hostid, inet_message_id);
1815 -- TOC entry 77 (OID 50652)
1816 -- Name: pages_url_ix; Type: INDEX; Schema: public; Owner: rich
1819 CREATE INDEX pages_url_ix ON pages USING btree (url);
1823 -- TOC entry 76 (OID 50653)
1824 -- Name: pages_redirect_ix; Type: INDEX; Schema: public; Owner: rich
1827 CREATE INDEX pages_redirect_ix ON pages USING btree (redirect);
1831 -- TOC entry 74 (OID 50981)
1832 -- Name: pages_fti_idx; Type: INDEX; Schema: public; Owner: rich
1835 CREATE INDEX pages_fti_idx ON pages USING gist (title_description_fti);
1839 -- TOC entry 79 (OID 53128)
1840 -- Name: contents_fti_idx; Type: INDEX; Schema: public; Owner: rich
1843 CREATE INDEX contents_fti_idx ON contents USING gist (content_fti);
1847 -- TOC entry 75 (OID 50654)
1848 -- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
1851 ALTER TABLE ONLY pages
1852 ADD CONSTRAINT pages_pkey PRIMARY KEY (id);
1856 -- TOC entry 80 (OID 50656)
1857 -- Name: contents_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
1860 ALTER TABLE ONLY contents
1861 ADD CONSTRAINT contents_pkey PRIMARY KEY (id);
1865 -- TOC entry 81 (OID 50658)
1866 -- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
1869 ALTER TABLE ONLY hosts
1870 ADD CONSTRAINT hosts_pkey PRIMARY KEY (id);
1874 -- TOC entry 85 (OID 50660)
1875 -- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
1878 ALTER TABLE ONLY images
1879 ADD CONSTRAINT images_pkey PRIMARY KEY (id);
1883 -- TOC entry 87 (OID 50662)
1884 -- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
1887 ALTER TABLE ONLY files
1888 ADD CONSTRAINT files_pkey PRIMARY KEY (id);
1892 -- TOC entry 90 (OID 50664)
1893 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
1896 ALTER TABLE ONLY users
1897 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
1901 -- TOC entry 94 (OID 50666)
1902 -- Name: contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
1905 ALTER TABLE ONLY contacts
1906 ADD CONSTRAINT contacts_pkey PRIMARY KEY (id);
1910 -- TOC entry 101 (OID 50668)
1911 -- Name: templates_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
1914 ALTER TABLE ONLY templates
1915 ADD CONSTRAINT templates_pkey PRIMARY KEY (id);
1919 -- TOC entry 106 (OID 50670)
1920 -- Name: messages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
1923 ALTER TABLE ONLY messages
1924 ADD CONSTRAINT messages_pkey PRIMARY KEY (id);
1928 -- TOC entry 107 (OID 50672)
1929 -- Name: powered_by_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
1932 ALTER TABLE ONLY powered_by
1933 ADD CONSTRAINT powered_by_pkey PRIMARY KEY (id);
1937 -- TOC entry 108 (OID 50674)
1938 -- Name: pending_email_changes_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
1941 ALTER TABLE ONLY pending_email_changes
1942 ADD CONSTRAINT pending_email_changes_pkey PRIMARY KEY ("key");
1946 -- TOC entry 109 (OID 50797)
1947 -- Name: pg_ts_dict_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1950 ALTER TABLE ONLY pg_ts_dict
1951 ADD CONSTRAINT pg_ts_dict_pkey PRIMARY KEY (dict_name);
1955 -- TOC entry 110 (OID 50823)
1956 -- Name: pg_ts_parser_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1959 ALTER TABLE ONLY pg_ts_parser
1960 ADD CONSTRAINT pg_ts_parser_pkey PRIMARY KEY (prs_name);
1964 -- TOC entry 111 (OID 50848)
1965 -- Name: pg_ts_cfg_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1968 ALTER TABLE ONLY pg_ts_cfg
1969 ADD CONSTRAINT pg_ts_cfg_pkey PRIMARY KEY (ts_name);
1973 -- TOC entry 112 (OID 50855)
1974 -- Name: pg_ts_cfgmap_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1977 ALTER TABLE ONLY pg_ts_cfgmap
1978 ADD CONSTRAINT pg_ts_cfgmap_pkey PRIMARY KEY (ts_name, tok_alias);
1982 -- TOC entry 199 (OID 50676)
1983 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
1986 ALTER TABLE ONLY contents
1987 ADD CONSTRAINT "$1" FOREIGN KEY (pageid) REFERENCES pages(id);
1991 -- TOC entry 203 (OID 50680)
1992 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
1995 ALTER TABLE ONLY hostnames
1996 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2000 -- TOC entry 200 (OID 50684)
2001 -- Name: hosts_hostname_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2004 ALTER TABLE ONLY hosts
2005 ADD CONSTRAINT hosts_hostname_cn FOREIGN KEY (id, canonical_hostname) REFERENCES hostnames(hostid, name) DEFERRABLE;
2009 -- TOC entry 195 (OID 50688)
2010 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2013 ALTER TABLE ONLY pages
2014 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2018 -- TOC entry 204 (OID 50692)
2019 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2022 ALTER TABLE ONLY images
2023 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2027 -- TOC entry 205 (OID 50696)
2028 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2031 ALTER TABLE ONLY files
2032 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2036 -- TOC entry 196 (OID 50700)
2037 -- Name: pages_redirect_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2040 ALTER TABLE ONLY pages
2041 ADD CONSTRAINT pages_redirect_cn FOREIGN KEY (hostid, redirect) REFERENCES pages(hostid, url) DEFERRABLE;
2045 -- TOC entry 206 (OID 50704)
2046 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2049 ALTER TABLE ONLY users
2050 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2054 -- TOC entry 207 (OID 50708)
2055 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2058 ALTER TABLE ONLY usercookies
2059 ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
2063 -- TOC entry 197 (OID 50712)
2064 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
2067 ALTER TABLE ONLY pages
2068 ADD CONSTRAINT "$2" FOREIGN KEY (logged_user) REFERENCES users(id);
2072 -- TOC entry 198 (OID 50716)
2073 -- Name: pages_user_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2076 ALTER TABLE ONLY pages
2077 ADD CONSTRAINT pages_user_cn FOREIGN KEY (hostid, logged_user) REFERENCES users(hostid, id);
2081 -- TOC entry 208 (OID 50720)
2082 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2085 ALTER TABLE ONLY sitemenu
2086 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2090 -- TOC entry 209 (OID 50724)
2091 -- Name: sitemenu_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2094 ALTER TABLE ONLY sitemenu
2095 ADD CONSTRAINT sitemenu_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
2099 -- TOC entry 210 (OID 50728)
2100 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2103 ALTER TABLE ONLY contacts
2104 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2108 -- TOC entry 211 (OID 50732)
2109 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2112 ALTER TABLE ONLY contact_emails
2113 ADD CONSTRAINT "$1" FOREIGN KEY (contactid) REFERENCES contacts(id);
2117 -- TOC entry 201 (OID 50736)
2118 -- Name: hosts_theme_css_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2121 ALTER TABLE ONLY hosts
2122 ADD CONSTRAINT hosts_theme_css_cn FOREIGN KEY (theme_css) REFERENCES themes(theme_css);
2126 -- TOC entry 212 (OID 50740)
2127 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2130 ALTER TABLE ONLY page_emails
2131 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2135 -- TOC entry 213 (OID 50744)
2136 -- Name: page_emails_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2139 ALTER TABLE ONLY page_emails
2140 ADD CONSTRAINT page_emails_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
2144 -- TOC entry 214 (OID 50748)
2145 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2148 ALTER TABLE ONLY mailing_lists
2149 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2153 -- TOC entry 215 (OID 50752)
2154 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2157 ALTER TABLE ONLY links
2158 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2162 -- TOC entry 216 (OID 50756)
2163 -- Name: links_from_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2166 ALTER TABLE ONLY links
2167 ADD CONSTRAINT links_from_cn FOREIGN KEY (hostid, from_url) REFERENCES pages(hostid, url) DEFERRABLE;
2171 -- TOC entry 217 (OID 50760)
2172 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2175 ALTER TABLE ONLY recently_visited
2176 ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
2180 -- TOC entry 218 (OID 50764)
2181 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
2184 ALTER TABLE ONLY recently_visited
2185 ADD CONSTRAINT "$2" FOREIGN KEY (hostid) REFERENCES hosts(id);
2189 -- TOC entry 219 (OID 50768)
2190 -- Name: recently_visited_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2193 ALTER TABLE ONLY recently_visited
2194 ADD CONSTRAINT recently_visited_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
2198 -- TOC entry 220 (OID 50772)
2199 -- Name: recently_visited_userid_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2202 ALTER TABLE ONLY recently_visited
2203 ADD CONSTRAINT recently_visited_userid_cn FOREIGN KEY (hostid, userid) REFERENCES users(hostid, id);
2207 -- TOC entry 222 (OID 50776)
2208 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2211 ALTER TABLE ONLY msg_references
2212 ADD CONSTRAINT "$1" FOREIGN KEY (message_id) REFERENCES messages(id);
2216 -- TOC entry 221 (OID 50780)
2217 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2220 ALTER TABLE ONLY messages
2221 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2225 -- TOC entry 202 (OID 50784)
2226 -- Name: hosts_powered_by_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2229 ALTER TABLE ONLY hosts
2230 ADD CONSTRAINT hosts_powered_by_cn FOREIGN KEY (powered_by) REFERENCES powered_by(id);
2234 -- TOC entry 223 (OID 50788)
2235 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2238 ALTER TABLE ONLY pending_email_changes
2239 ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
2243 -- TOC entry 224 (OID 50980)
2244 -- Name: pages_fti_tr; Type: TRIGGER; Schema: public; Owner: rich
2247 CREATE TRIGGER pages_fti_tr
2248 BEFORE INSERT OR UPDATE ON pages
2250 EXECUTE PROCEDURE tsearch2('title_description_fti', 'title', 'description');
2254 -- TOC entry 225 (OID 50983)
2255 -- Name: contents_fti_tr; Type: TRIGGER; Schema: public; Owner: rich
2258 CREATE TRIGGER contents_fti_tr
2259 BEFORE INSERT OR UPDATE ON contents
2261 EXECUTE PROCEDURE tsearch2('content_fti', 'sectionname', 'content');
2265 -- TOC entry 3 (OID 2200)
2266 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
2269 COMMENT ON SCHEMA public IS 'Standard public namespace';
2273 -- TOC entry 37 (OID 26145)
2274 -- Name: TABLE server_settings; Type: COMMENT; Schema: public; Owner: rich
2277 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.';
2281 -- TOC entry 159 (OID 50940)
2282 -- Name: FUNCTION exectsq(tsvector, tsquery); Type: COMMENT; Schema: public; Owner: postgres
2285 COMMENT ON FUNCTION exectsq(tsvector, tsquery) IS 'boolean operation with text index';
2289 -- TOC entry 161 (OID 50941)
2290 -- Name: FUNCTION rexectsq(tsquery, tsvector); Type: COMMENT; Schema: public; Owner: postgres
2293 COMMENT ON FUNCTION rexectsq(tsquery, tsvector) IS 'boolean operation with text index';
2297 -- PostgreSQL database dump
2300 SET client_encoding = 'UNICODE';
2301 SET check_function_bodies = false;
2303 SET search_path = public, pg_catalog;
2306 -- Data for TOC entry 3 (OID 26171)
2307 -- Name: templates; Type: TABLE DATA; Schema: public; Owner: rich
2310 COPY templates (id, title_regexp, url_regexp, extension, ordering) FROM stdin;
2311 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
2312 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
2313 4 ^(199[0-9]|20[0-9][0-9])$ ^(199[0-9]|20[0-9][0-9])$ calendar 30
2318 -- TOC entry 2 (OID 26169)
2319 -- Name: templates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rich
2322 SELECT pg_catalog.setval('templates_id_seq', 4, true);
2326 -- PostgreSQL database dump
2329 SET client_encoding = 'UNICODE';
2330 SET check_function_bodies = false;
2332 SET search_path = public, pg_catalog;
2335 -- Data for TOC entry 2 (OID 26140)
2336 -- Name: themes; Type: TABLE DATA; Schema: public; Owner: rich
2339 COPY themes (theme_css, name, description) FROM stdin;
2340 /_css/easyweb.css Merjis Easy Web Marketing This is the easy web marketing stylesheet developed by Merjis Ltd. Please see http://www.merjis.com/
2341 /_css/basic.css Basic styles only Only the most essential styles. This is a good starting point if you want to completely restyle pages using site-specific CSS.