+CREATE TABLE powered_by (
+ id serial NOT NULL,
+ name text NOT NULL,
+ url text NOT NULL
+);
+
+
+--
+-- TOC entry 54 (OID 607075)
+-- Name: powered_by; Type: ACL; Schema: public; Owner: rich
+--
+
+REVOKE ALL ON TABLE powered_by FROM PUBLIC;
+GRANT SELECT ON TABLE powered_by TO "www-data";
+
+
+--
+-- TOC entry 55 (OID 607136)
+-- Name: pending_email_changes; Type: TABLE; Schema: public; Owner: rich
+--
+
+CREATE TABLE pending_email_changes (
+ "key" text NOT NULL,
+ change_date date DEFAULT ('now'::text)::date NOT NULL,
+ userid integer NOT NULL,
+ email text NOT NULL
+);
+
+
+--
+-- TOC entry 56 (OID 607136)
+-- Name: pending_email_changes; Type: ACL; Schema: public; Owner: rich
+--
+
+REVOKE ALL ON TABLE pending_email_changes FROM PUBLIC;
+GRANT ALL ON TABLE pending_email_changes TO "www-data";
+
+
+--
+-- TOC entry 57 (OID 618606)
+-- Name: pg_ts_dict; Type: TABLE; Schema: public; Owner: postgres
+--
+
+CREATE TABLE pg_ts_dict (
+ dict_name text NOT NULL,
+ dict_init regprocedure,
+ dict_initoption text,
+ dict_lexize regprocedure NOT NULL,
+ dict_comment text
+);
+
+
+--
+-- TOC entry 58 (OID 618606)
+-- Name: pg_ts_dict; Type: ACL; Schema: public; Owner: postgres
+--
+
+REVOKE ALL ON TABLE pg_ts_dict FROM PUBLIC;
+GRANT SELECT ON TABLE pg_ts_dict TO rich;
+GRANT SELECT ON TABLE pg_ts_dict TO "www-data";
+
+
+--
+-- TOC entry 114 (OID 618613)
+-- Name: lexize(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION lexize(oid, text) RETURNS text[]
+ AS '$libdir/tsearch2', 'lexize'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 115 (OID 618614)
+-- Name: lexize(text, text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION lexize(text, text) RETURNS text[]
+ AS '$libdir/tsearch2', 'lexize_byname'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 116 (OID 618615)
+-- Name: lexize(text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION lexize(text) RETURNS text[]
+ AS '$libdir/tsearch2', 'lexize_bycurrent'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 117 (OID 618616)
+-- Name: set_curdict(integer); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION set_curdict(integer) RETURNS void
+ AS '$libdir/tsearch2', 'set_curdict'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 118 (OID 618617)
+-- Name: set_curdict(text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION set_curdict(text) RETURNS void
+ AS '$libdir/tsearch2', 'set_curdict_byname'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 119 (OID 618618)
+-- Name: dex_init(text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION dex_init(text) RETURNS internal
+ AS '$libdir/tsearch2', 'dex_init'
+ LANGUAGE c;
+
+
+--
+-- TOC entry 120 (OID 618619)
+-- Name: dex_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION dex_lexize(internal, internal, integer) RETURNS internal
+ AS '$libdir/tsearch2', 'dex_lexize'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 121 (OID 618621)
+-- Name: snb_en_init(text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION snb_en_init(text) RETURNS internal
+ AS '$libdir/tsearch2', 'snb_en_init'
+ LANGUAGE c;
+
+
+--
+-- TOC entry 122 (OID 618622)
+-- Name: snb_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION snb_lexize(internal, internal, integer) RETURNS internal
+ AS '$libdir/tsearch2', 'snb_lexize'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 123 (OID 618624)
+-- Name: snb_ru_init(text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION snb_ru_init(text) RETURNS internal
+ AS '$libdir/tsearch2', 'snb_ru_init'
+ LANGUAGE c;
+
+
+--
+-- TOC entry 124 (OID 618626)
+-- Name: spell_init(text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION spell_init(text) RETURNS internal
+ AS '$libdir/tsearch2', 'spell_init'
+ LANGUAGE c;
+
+
+--
+-- TOC entry 125 (OID 618627)
+-- Name: spell_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION spell_lexize(internal, internal, integer) RETURNS internal
+ AS '$libdir/tsearch2', 'spell_lexize'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 126 (OID 618629)
+-- Name: syn_init(text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION syn_init(text) RETURNS internal
+ AS '$libdir/tsearch2', 'syn_init'
+ LANGUAGE c;
+
+
+--
+-- TOC entry 127 (OID 618630)
+-- Name: syn_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION syn_lexize(internal, internal, integer) RETURNS internal
+ AS '$libdir/tsearch2', 'syn_lexize'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 59 (OID 618632)
+-- Name: pg_ts_parser; Type: TABLE; Schema: public; Owner: postgres
+--
+
+CREATE TABLE pg_ts_parser (
+ prs_name text NOT NULL,
+ prs_start regprocedure NOT NULL,
+ prs_nexttoken regprocedure NOT NULL,
+ prs_end regprocedure NOT NULL,
+ prs_headline regprocedure NOT NULL,
+ prs_lextype regprocedure NOT NULL,
+ prs_comment text
+);
+
+
+--
+-- TOC entry 60 (OID 618632)
+-- Name: pg_ts_parser; Type: ACL; Schema: public; Owner: postgres
+--
+
+REVOKE ALL ON TABLE pg_ts_parser FROM PUBLIC;
+GRANT SELECT ON TABLE pg_ts_parser TO rich;
+GRANT SELECT ON TABLE pg_ts_parser TO "www-data";
+
+
+--
+-- TOC entry 5 (OID 618640)
+-- Name: tokentype; Type: TYPE; Schema: public; Owner: postgres
+--
+
+CREATE TYPE tokentype AS (
+ tokid integer,
+ alias text,
+ descr text
+);
+
+
+--
+-- TOC entry 128 (OID 618641)
+-- Name: token_type(integer); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION token_type(integer) RETURNS SETOF tokentype
+ AS '$libdir/tsearch2', 'token_type'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 129 (OID 618642)
+-- Name: token_type(text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION token_type(text) RETURNS SETOF tokentype
+ AS '$libdir/tsearch2', 'token_type_byname'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 130 (OID 618643)
+-- Name: token_type(); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION token_type() RETURNS SETOF tokentype
+ AS '$libdir/tsearch2', 'token_type_current'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 131 (OID 618644)
+-- Name: set_curprs(integer); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION set_curprs(integer) RETURNS void
+ AS '$libdir/tsearch2', 'set_curprs'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 132 (OID 618645)
+-- Name: set_curprs(text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION set_curprs(text) RETURNS void
+ AS '$libdir/tsearch2', 'set_curprs_byname'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 6 (OID 618647)
+-- Name: tokenout; Type: TYPE; Schema: public; Owner: postgres
+--
+
+CREATE TYPE tokenout AS (
+ tokid integer,
+ token text
+);
+
+
+--
+-- TOC entry 133 (OID 618648)
+-- Name: parse(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION parse(oid, text) RETURNS SETOF tokenout
+ AS '$libdir/tsearch2', 'parse'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 134 (OID 618649)
+-- Name: parse(text, text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION parse(text, text) RETURNS SETOF tokenout
+ AS '$libdir/tsearch2', 'parse_byname'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 135 (OID 618650)
+-- Name: parse(text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION parse(text) RETURNS SETOF tokenout
+ AS '$libdir/tsearch2', 'parse_current'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 136 (OID 618651)
+-- Name: prsd_start(internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION prsd_start(internal, integer) RETURNS internal
+ AS '$libdir/tsearch2', 'prsd_start'
+ LANGUAGE c;
+
+
+--
+-- TOC entry 137 (OID 618652)
+-- Name: prsd_getlexeme(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION prsd_getlexeme(internal, internal, internal) RETURNS integer
+ AS '$libdir/tsearch2', 'prsd_getlexeme'
+ LANGUAGE c;
+
+
+--
+-- TOC entry 138 (OID 618653)
+-- Name: prsd_end(internal); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION prsd_end(internal) RETURNS void
+ AS '$libdir/tsearch2', 'prsd_end'
+ LANGUAGE c;
+
+
+--
+-- TOC entry 139 (OID 618654)
+-- Name: prsd_lextype(internal); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION prsd_lextype(internal) RETURNS internal
+ AS '$libdir/tsearch2', 'prsd_lextype'
+ LANGUAGE c;
+
+
+--
+-- TOC entry 140 (OID 618655)
+-- Name: prsd_headline(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION prsd_headline(internal, internal, internal) RETURNS internal
+ AS '$libdir/tsearch2', 'prsd_headline'
+ LANGUAGE c;
+
+
+--
+-- TOC entry 61 (OID 618657)
+-- Name: pg_ts_cfg; Type: TABLE; Schema: public; Owner: postgres
+--
+
+CREATE TABLE pg_ts_cfg (
+ ts_name text NOT NULL,
+ prs_name text NOT NULL,
+ locale text
+);
+
+
+--
+-- TOC entry 62 (OID 618657)
+-- Name: pg_ts_cfg; Type: ACL; Schema: public; Owner: postgres
+--
+
+REVOKE ALL ON TABLE pg_ts_cfg FROM PUBLIC;
+GRANT SELECT ON TABLE pg_ts_cfg TO rich;
+GRANT SELECT ON TABLE pg_ts_cfg TO "www-data";
+
+
+--
+-- TOC entry 63 (OID 618664)
+-- Name: pg_ts_cfgmap; Type: TABLE; Schema: public; Owner: postgres
+--
+
+CREATE TABLE pg_ts_cfgmap (
+ ts_name text NOT NULL,
+ tok_alias text NOT NULL,
+ dict_name text[]
+);
+
+
+--
+-- TOC entry 64 (OID 618664)
+-- Name: pg_ts_cfgmap; Type: ACL; Schema: public; Owner: postgres
+--
+
+REVOKE ALL ON TABLE pg_ts_cfgmap FROM PUBLIC;
+GRANT SELECT ON TABLE pg_ts_cfgmap TO rich;
+GRANT SELECT ON TABLE pg_ts_cfgmap TO "www-data";
+
+
+--
+-- TOC entry 141 (OID 618671)
+-- Name: set_curcfg(integer); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION set_curcfg(integer) RETURNS void
+ AS '$libdir/tsearch2', 'set_curcfg'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 142 (OID 618672)
+-- Name: set_curcfg(text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION set_curcfg(text) RETURNS void
+ AS '$libdir/tsearch2', 'set_curcfg_byname'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 143 (OID 618673)
+-- Name: show_curcfg(); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION show_curcfg() RETURNS oid
+ AS '$libdir/tsearch2', 'show_curcfg'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 144 (OID 618735)
+-- Name: tsvector_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION tsvector_in(cstring) RETURNS tsvector
+ AS '$libdir/tsearch2', 'tsvector_in'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 145 (OID 618736)
+-- Name: tsvector_out(tsvector); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION tsvector_out(tsvector) RETURNS cstring
+ AS '$libdir/tsearch2', 'tsvector_out'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 7 (OID 618734)
+-- Name: tsvector; Type: TYPE; Schema: public; Owner: postgres
+--
+
+CREATE TYPE tsvector (
+ INTERNALLENGTH = variable,
+ INPUT = tsvector_in,
+ OUTPUT = tsvector_out,
+ ALIGNMENT = int4,
+ STORAGE = extended
+);
+
+
+--
+-- TOC entry 146 (OID 618738)
+-- Name: length(tsvector); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION length(tsvector) RETURNS integer
+ AS '$libdir/tsearch2', 'tsvector_length'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 147 (OID 618739)
+-- Name: to_tsvector(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION to_tsvector(oid, text) RETURNS tsvector
+ AS '$libdir/tsearch2', 'to_tsvector'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 148 (OID 618740)
+-- Name: to_tsvector(text, text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION to_tsvector(text, text) RETURNS tsvector
+ AS '$libdir/tsearch2', 'to_tsvector_name'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 149 (OID 618741)
+-- Name: to_tsvector(text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION to_tsvector(text) RETURNS tsvector
+ AS '$libdir/tsearch2', 'to_tsvector_current'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 150 (OID 618742)
+-- Name: strip(tsvector); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION strip(tsvector) RETURNS tsvector
+ AS '$libdir/tsearch2', 'strip'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 151 (OID 618743)
+-- Name: setweight(tsvector, "char"); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION setweight(tsvector, "char") RETURNS tsvector
+ AS '$libdir/tsearch2', 'setweight'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 152 (OID 618744)
+-- Name: concat(tsvector, tsvector); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION concat(tsvector, tsvector) RETURNS tsvector
+ AS '$libdir/tsearch2', 'concat'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 192 (OID 618745)
+-- Name: ||; Type: OPERATOR; Schema: public; Owner: postgres
+--
+
+CREATE OPERATOR || (
+ PROCEDURE = concat,
+ LEFTARG = tsvector,
+ RIGHTARG = tsvector
+);
+
+
+--
+-- TOC entry 153 (OID 618747)
+-- Name: tsquery_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION tsquery_in(cstring) RETURNS tsquery
+ AS '$libdir/tsearch2', 'tsquery_in'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 154 (OID 618748)
+-- Name: tsquery_out(tsquery); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION tsquery_out(tsquery) RETURNS cstring
+ AS '$libdir/tsearch2', 'tsquery_out'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 8 (OID 618746)
+-- Name: tsquery; Type: TYPE; Schema: public; Owner: postgres
+--
+
+CREATE TYPE tsquery (
+ INTERNALLENGTH = variable,
+ INPUT = tsquery_in,
+ OUTPUT = tsquery_out,
+ ALIGNMENT = int4,
+ STORAGE = plain
+);
+
+
+--
+-- TOC entry 155 (OID 618750)
+-- Name: querytree(tsquery); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION querytree(tsquery) RETURNS text
+ AS '$libdir/tsearch2', 'tsquerytree'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 156 (OID 618751)
+-- Name: to_tsquery(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION to_tsquery(oid, text) RETURNS tsquery
+ AS '$libdir/tsearch2', 'to_tsquery'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 157 (OID 618752)
+-- Name: to_tsquery(text, text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION to_tsquery(text, text) RETURNS tsquery
+ AS '$libdir/tsearch2', 'to_tsquery_name'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 158 (OID 618753)
+-- Name: to_tsquery(text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION to_tsquery(text) RETURNS tsquery
+ AS '$libdir/tsearch2', 'to_tsquery_current'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 159 (OID 618754)
+-- Name: exectsq(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION exectsq(tsvector, tsquery) RETURNS boolean
+ AS '$libdir/tsearch2', 'exectsq'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 161 (OID 618755)
+-- Name: rexectsq(tsquery, tsvector); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION rexectsq(tsquery, tsvector) RETURNS boolean
+ AS '$libdir/tsearch2', 'rexectsq'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 194 (OID 618756)
+-- Name: @@; Type: OPERATOR; Schema: public; Owner: postgres
+--
+
+CREATE OPERATOR @@ (
+ PROCEDURE = rexectsq,
+ LEFTARG = tsquery,
+ RIGHTARG = tsvector,
+ COMMUTATOR = @@,
+ RESTRICT = contsel,
+ JOIN = contjoinsel
+);
+
+
+--
+-- TOC entry 193 (OID 618757)
+-- Name: @@; Type: OPERATOR; Schema: public; Owner: postgres
+--
+
+CREATE OPERATOR @@ (
+ PROCEDURE = exectsq,
+ LEFTARG = tsvector,
+ RIGHTARG = tsquery,
+ COMMUTATOR = @@,
+ RESTRICT = contsel,
+ JOIN = contjoinsel
+);
+
+
+--
+-- TOC entry 163 (OID 618758)
+-- Name: tsearch2(); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION tsearch2() RETURNS "trigger"
+ AS '$libdir/tsearch2', 'tsearch2'
+ LANGUAGE c;
+
+
+--
+-- TOC entry 164 (OID 618759)
+-- Name: rank(real[], tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION rank(real[], tsvector, tsquery) RETURNS real
+ AS '$libdir/tsearch2', 'rank'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 165 (OID 618760)
+-- Name: rank(real[], tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION rank(real[], tsvector, tsquery, integer) RETURNS real
+ AS '$libdir/tsearch2', 'rank'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 166 (OID 618761)
+-- Name: rank(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION rank(tsvector, tsquery) RETURNS real
+ AS '$libdir/tsearch2', 'rank_def'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 167 (OID 618762)
+-- Name: rank(tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION rank(tsvector, tsquery, integer) RETURNS real
+ AS '$libdir/tsearch2', 'rank_def'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 168 (OID 618763)
+-- Name: rank_cd(integer, tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION rank_cd(integer, tsvector, tsquery) RETURNS real
+ AS '$libdir/tsearch2', 'rank_cd'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 169 (OID 618764)
+-- Name: rank_cd(integer, tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION rank_cd(integer, tsvector, tsquery, integer) RETURNS real
+ AS '$libdir/tsearch2', 'rank_cd'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 170 (OID 618765)
+-- Name: rank_cd(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION rank_cd(tsvector, tsquery) RETURNS real
+ AS '$libdir/tsearch2', 'rank_cd_def'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 171 (OID 618766)
+-- Name: rank_cd(tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION rank_cd(tsvector, tsquery, integer) RETURNS real
+ AS '$libdir/tsearch2', 'rank_cd_def'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 172 (OID 618767)
+-- Name: headline(oid, text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION headline(oid, text, tsquery, text) RETURNS text
+ AS '$libdir/tsearch2', 'headline'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 173 (OID 618768)
+-- Name: headline(oid, text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION headline(oid, text, tsquery) RETURNS text
+ AS '$libdir/tsearch2', 'headline'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 174 (OID 618769)
+-- Name: headline(text, text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION headline(text, text, tsquery, text) RETURNS text
+ AS '$libdir/tsearch2', 'headline_byname'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 175 (OID 618770)
+-- Name: headline(text, text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION headline(text, text, tsquery) RETURNS text
+ AS '$libdir/tsearch2', 'headline_byname'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 176 (OID 618771)
+-- Name: headline(text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION headline(text, tsquery, text) RETURNS text
+ AS '$libdir/tsearch2', 'headline_current'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 177 (OID 618772)
+-- Name: headline(text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION headline(text, tsquery) RETURNS text
+ AS '$libdir/tsearch2', 'headline_current'
+ LANGUAGE c IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 178 (OID 618774)
+-- Name: gtsvector_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION gtsvector_in(cstring) RETURNS gtsvector
+ AS '$libdir/tsearch2', 'gtsvector_in'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 179 (OID 618775)
+-- Name: gtsvector_out(gtsvector); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION gtsvector_out(gtsvector) RETURNS cstring
+ AS '$libdir/tsearch2', 'gtsvector_out'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 9 (OID 618773)
+-- Name: gtsvector; Type: TYPE; Schema: public; Owner: postgres
+--
+
+CREATE TYPE gtsvector (
+ INTERNALLENGTH = variable,
+ INPUT = gtsvector_in,
+ OUTPUT = gtsvector_out,
+ ALIGNMENT = int4,
+ STORAGE = plain
+);
+
+
+--
+-- TOC entry 180 (OID 618777)
+-- Name: gtsvector_consistent(gtsvector, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION gtsvector_consistent(gtsvector, internal, integer) RETURNS boolean
+ AS '$libdir/tsearch2', 'gtsvector_consistent'
+ LANGUAGE c;
+
+
+--
+-- TOC entry 181 (OID 618778)
+-- Name: gtsvector_compress(internal); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION gtsvector_compress(internal) RETURNS internal
+ AS '$libdir/tsearch2', 'gtsvector_compress'
+ LANGUAGE c;
+
+
+--
+-- TOC entry 182 (OID 618779)
+-- Name: gtsvector_decompress(internal); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION gtsvector_decompress(internal) RETURNS internal
+ AS '$libdir/tsearch2', 'gtsvector_decompress'
+ LANGUAGE c;
+
+
+--
+-- TOC entry 183 (OID 618780)
+-- Name: gtsvector_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION gtsvector_penalty(internal, internal, internal) RETURNS internal
+ AS '$libdir/tsearch2', 'gtsvector_penalty'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 184 (OID 618781)
+-- Name: gtsvector_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION gtsvector_picksplit(internal, internal) RETURNS internal
+ AS '$libdir/tsearch2', 'gtsvector_picksplit'
+ LANGUAGE c;
+
+
+--
+-- TOC entry 185 (OID 618782)
+-- Name: gtsvector_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION gtsvector_union(bytea, internal) RETURNS integer[]
+ AS '$libdir/tsearch2', 'gtsvector_union'
+ LANGUAGE c;
+
+
+--
+-- TOC entry 186 (OID 618783)
+-- Name: gtsvector_same(gtsvector, gtsvector, internal); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION gtsvector_same(gtsvector, gtsvector, internal) RETURNS internal
+ AS '$libdir/tsearch2', 'gtsvector_same'
+ LANGUAGE c;
+
+
+--
+-- TOC entry 195 (OID 618784)
+-- Name: gist_tsvector_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
+--
+
+CREATE OPERATOR CLASS gist_tsvector_ops
+ DEFAULT FOR TYPE tsvector USING gist AS
+ STORAGE gtsvector ,
+ OPERATOR 1 @@(tsvector,tsquery) RECHECK ,
+ FUNCTION 1 gtsvector_consistent(gtsvector,internal,integer) ,
+ FUNCTION 2 gtsvector_union(bytea,internal) ,
+ FUNCTION 3 gtsvector_compress(internal) ,
+ FUNCTION 4 gtsvector_decompress(internal) ,
+ FUNCTION 5 gtsvector_penalty(internal,internal,internal) ,
+ FUNCTION 6 gtsvector_picksplit(internal,internal) ,
+ FUNCTION 7 gtsvector_same(gtsvector,gtsvector,internal);
+
+
+--
+-- TOC entry 10 (OID 618786)
+-- Name: statinfo; Type: TYPE; Schema: public; Owner: postgres
+--
+
+CREATE TYPE statinfo AS (
+ word text,
+ ndoc integer,
+ nentry integer
+);
+
+
+--
+-- TOC entry 187 (OID 618787)
+-- Name: stat(text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION stat(text) RETURNS SETOF statinfo
+ AS '$libdir/tsearch2', 'ts_stat'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 188 (OID 618788)
+-- Name: reset_tsearch(); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION reset_tsearch() RETURNS void
+ AS '$libdir/tsearch2', 'reset_tsearch'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 189 (OID 618789)
+-- Name: get_covers(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION get_covers(tsvector, tsquery) RETURNS text
+ AS '$libdir/tsearch2', 'get_covers'
+ LANGUAGE c STRICT;
+
+
+--
+-- TOC entry 11 (OID 618791)
+-- Name: tsdebug; Type: TYPE; Schema: public; Owner: postgres
+--
+
+CREATE TYPE tsdebug AS (
+ ts_name text,
+ tok_type text,
+ description text,
+ token text,
+ dict_name text[],
+ tsvector tsvector
+);
+
+
+--
+-- TOC entry 190 (OID 618792)
+-- Name: _get_parser_from_curcfg(); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION _get_parser_from_curcfg() RETURNS text
+ AS ' select prs_name from pg_ts_cfg where oid = show_curcfg() '
+ LANGUAGE sql IMMUTABLE STRICT;
+
+
+--
+-- TOC entry 191 (OID 618793)
+-- Name: ts_debug(text); Type: FUNCTION; Schema: public; Owner: postgres
+--
+
+CREATE FUNCTION ts_debug(text) RETURNS SETOF tsdebug
+ AS '
+select
+ m.ts_name,
+ t.alias as tok_type,
+ t.descr as description,
+ p.token,
+ m.dict_name,
+ strip(to_tsvector(p.token)) as tsvector
+from
+ parse( _get_parser_from_curcfg(), $1 ) as p,
+ token_type() as t,
+ pg_ts_cfgmap as m,
+ pg_ts_cfg as c
+where
+ t.tokid=p.tokid and
+ t.alias = m.tok_alias and
+ m.ts_name=c.ts_name and
+ c.oid=show_curcfg()
+'
+ LANGUAGE sql STRICT;
+
+
+--
+-- TOC entry 83 (OID 536388)
+-- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX hostnames_hostid_name_uq ON hostnames USING btree (hostid, name);
+
+
+--
+-- TOC entry 84 (OID 536389)
+-- Name: hostnams_name_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX hostnams_name_uq ON hostnames USING btree (name);
+
+
+--
+-- TOC entry 78 (OID 536419)
+-- Name: pages_url_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX pages_url_uq ON pages USING btree (hostid, url);
+
+
+--
+-- TOC entry 85 (OID 540251)
+-- Name: images_name_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX images_name_uq ON images USING btree (hostid, name);
+
+
+--
+-- TOC entry 87 (OID 540252)
+-- Name: files_name_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX files_name_uq ON files USING btree (hostid, name);
+
+
+--
+-- TOC entry 90 (OID 540831)
+-- Name: users_name_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX users_name_uq ON users USING btree (hostid, name);
+
+
+--
+-- TOC entry 89 (OID 540946)
+-- Name: users_id_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX users_id_uq ON users USING btree (hostid, id);
+
+
+--
+-- TOC entry 92 (OID 540970)
+-- Name: sitemenu_ordering_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX sitemenu_ordering_uq ON sitemenu USING btree (hostid, ordering);
+
+
+--
+-- TOC entry 93 (OID 540971)
+-- Name: sitemenu_url_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX sitemenu_url_uq ON sitemenu USING btree (hostid, url);
+
+
+--
+-- TOC entry 96 (OID 542626)
+-- Name: contact_emails_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX contact_emails_uq ON contact_emails USING btree (contactid, email);
+
+
+--
+-- TOC entry 97 (OID 543505)
+-- Name: themes_theme_css_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX themes_theme_css_uq ON themes USING btree (theme_css);
+
+
+--
+-- TOC entry 98 (OID 543763)
+-- Name: page_emails_email_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX page_emails_email_uq ON page_emails USING btree (hostid, url, email);
+
+
+--
+-- TOC entry 99 (OID 543795)
+-- Name: mailing_lists_email_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX mailing_lists_email_uq ON mailing_lists USING btree (hostid, email);
+
+
+--
+-- TOC entry 94 (OID 543880)
+-- Name: contacts_name_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX contacts_name_uq ON contacts USING btree (hostid, name);
+
+
+--
+-- TOC entry 100 (OID 544454)
+-- Name: links_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX links_uq ON links USING btree (hostid, from_url, to_url);
+
+
+--
+-- TOC entry 101 (OID 547951)
+-- Name: templates_ext_ord_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX templates_ext_ord_uq ON templates USING btree (extension, ordering);
+
+
+--
+-- TOC entry 103 (OID 547952)
+-- Name: templates_title_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX templates_title_uq ON templates USING btree (title_regexp);
+
+
+--
+-- TOC entry 104 (OID 547953)
+-- Name: templates_url_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX templates_url_uq ON templates USING btree (url_regexp);
+
+
+--
+-- TOC entry 105 (OID 551151)
+-- Name: recently_visited_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX recently_visited_uq ON recently_visited USING btree (userid, hostid, url);
+
+
+--
+-- TOC entry 106 (OID 552155)
+-- Name: messages_inet_message_id_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX messages_inet_message_id_uq ON messages USING btree (hostid, inet_message_id);
+
+
+--
+-- TOC entry 77 (OID 552684)
+-- Name: pages_url_ix; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE INDEX pages_url_ix ON pages USING btree (url);
+
+
+--
+-- TOC entry 76 (OID 552685)
+-- Name: pages_redirect_ix; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE INDEX pages_redirect_ix ON pages USING btree (redirect);
+
+
+--
+-- TOC entry 74 (OID 618795)
+-- Name: pages_fti_idx; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE INDEX pages_fti_idx ON pages USING gist (title_description_fti);
+
+
+--
+-- TOC entry 79 (OID 620946)
+-- Name: contents_fti_idx; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE INDEX contents_fti_idx ON contents USING gist (content_fti);
+
+
+--
+-- TOC entry 80 (OID 622207)
+-- Name: contents_pageid_idx; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE INDEX contents_pageid_idx ON contents USING btree (pageid);
+
+
+--
+-- TOC entry 75 (OID 536012)
+-- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY pages
+ ADD CONSTRAINT pages_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 81 (OID 536027)
+-- Name: contents_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY contents
+ ADD CONSTRAINT contents_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 82 (OID 536377)
+-- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY hosts
+ ADD CONSTRAINT hosts_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 86 (OID 537158)
+-- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY images
+ ADD CONSTRAINT images_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 88 (OID 537173)
+-- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY files
+ ADD CONSTRAINT files_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 91 (OID 540825)
+-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY users
+ ADD CONSTRAINT users_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 95 (OID 542611)
+-- Name: contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY contacts
+ ADD CONSTRAINT contacts_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 102 (OID 547945)
+-- Name: templates_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY templates
+ ADD CONSTRAINT templates_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 107 (OID 551681)
+-- Name: messages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY messages
+ ADD CONSTRAINT messages_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 108 (OID 607081)
+-- Name: powered_by_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY powered_by
+ ADD CONSTRAINT powered_by_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 109 (OID 607141)
+-- Name: pending_email_changes_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY pending_email_changes
+ ADD CONSTRAINT pending_email_changes_pkey PRIMARY KEY ("key");
+
+
+--
+-- TOC entry 110 (OID 618611)
+-- Name: pg_ts_dict_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
+--
+
+ALTER TABLE ONLY pg_ts_dict
+ ADD CONSTRAINT pg_ts_dict_pkey PRIMARY KEY (dict_name);
+
+
+--
+-- TOC entry 111 (OID 618637)
+-- Name: pg_ts_parser_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
+--
+
+ALTER TABLE ONLY pg_ts_parser
+ ADD CONSTRAINT pg_ts_parser_pkey PRIMARY KEY (prs_name);
+
+
+--
+-- TOC entry 112 (OID 618662)
+-- Name: pg_ts_cfg_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
+--
+
+ALTER TABLE ONLY pg_ts_cfg
+ ADD CONSTRAINT pg_ts_cfg_pkey PRIMARY KEY (ts_name);
+
+
+--
+-- TOC entry 113 (OID 618669)
+-- Name: pg_ts_cfgmap_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
+--
+
+ALTER TABLE ONLY pg_ts_cfgmap
+ ADD CONSTRAINT pg_ts_cfgmap_pkey PRIMARY KEY (ts_name, tok_alias);
+
+
+--
+-- TOC entry 200 (OID 536029)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY contents
+ ADD CONSTRAINT "$1" FOREIGN KEY (pageid) REFERENCES pages(id);
+
+
+--
+-- TOC entry 204 (OID 536384)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY hostnames
+ ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
+
+
+--
+-- TOC entry 201 (OID 536394)
+-- Name: hosts_hostname_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY hosts
+ ADD CONSTRAINT hosts_hostname_cn FOREIGN KEY (id, canonical_hostname) REFERENCES hostnames(hostid, name) DEFERRABLE;
+
+
+--
+-- TOC entry 196 (OID 536404)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY pages
+ ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
+
+
+--
+-- TOC entry 205 (OID 537160)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY images
+ ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
+
+
+--
+-- TOC entry 206 (OID 537175)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY files
+ ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
+
+
+--
+-- TOC entry 197 (OID 539155)
+-- Name: pages_redirect_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY pages
+ ADD CONSTRAINT pages_redirect_cn FOREIGN KEY (hostid, redirect) REFERENCES pages(hostid, url) DEFERRABLE;
+
+
+--
+-- TOC entry 207 (OID 540827)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY users
+ ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
+
+
+--
+-- TOC entry 208 (OID 540837)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY usercookies
+ ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
+
+
+--
+-- TOC entry 198 (OID 540942)
+-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY pages
+ ADD CONSTRAINT "$2" FOREIGN KEY (logged_user) REFERENCES users(id);
+
+
+--
+-- TOC entry 199 (OID 540947)
+-- Name: pages_user_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY pages
+ ADD CONSTRAINT pages_user_cn FOREIGN KEY (hostid, logged_user) REFERENCES users(hostid, id);
+
+
+--
+-- TOC entry 209 (OID 540966)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY sitemenu
+ ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
+
+
+--
+-- TOC entry 210 (OID 540972)
+-- Name: sitemenu_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY sitemenu
+ ADD CONSTRAINT sitemenu_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
+
+
+--
+-- TOC entry 211 (OID 542613)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY contacts
+ ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
+
+
+--
+-- TOC entry 212 (OID 542622)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY contact_emails
+ ADD CONSTRAINT "$1" FOREIGN KEY (contactid) REFERENCES contacts(id);
+
+
+--
+-- TOC entry 202 (OID 543506)
+-- Name: hosts_theme_css_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY hosts
+ ADD CONSTRAINT hosts_theme_css_cn FOREIGN KEY (theme_css) REFERENCES themes(theme_css);
+
+
+--
+-- TOC entry 213 (OID 543759)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY page_emails
+ ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
+
+
+--
+-- TOC entry 214 (OID 543764)
+-- Name: page_emails_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY page_emails
+ ADD CONSTRAINT page_emails_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
+
+
+--
+-- TOC entry 215 (OID 543791)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY mailing_lists
+ ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
+
+
+--
+-- TOC entry 216 (OID 544450)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY links
+ ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
+
+
+--
+-- TOC entry 217 (OID 544455)
+-- Name: links_from_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY links
+ ADD CONSTRAINT links_from_cn FOREIGN KEY (hostid, from_url) REFERENCES pages(hostid, url) DEFERRABLE;
+
+
+--
+-- TOC entry 218 (OID 551129)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY recently_visited
+ ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
+
+
+--
+-- TOC entry 219 (OID 551133)
+-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY recently_visited
+ ADD CONSTRAINT "$2" FOREIGN KEY (hostid) REFERENCES hosts(id);
+
+
+--
+-- TOC entry 220 (OID 551137)
+-- Name: recently_visited_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY recently_visited
+ ADD CONSTRAINT recently_visited_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
+
+
+--
+-- TOC entry 221 (OID 551141)
+-- Name: recently_visited_userid_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY recently_visited
+ ADD CONSTRAINT recently_visited_userid_cn FOREIGN KEY (hostid, userid) REFERENCES users(hostid, id);
+
+
+--
+-- TOC entry 223 (OID 551690)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY msg_references
+ ADD CONSTRAINT "$1" FOREIGN KEY (message_id) REFERENCES messages(id);
+
+
+--
+-- TOC entry 222 (OID 551694)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY messages
+ ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
+
+
+--
+-- TOC entry 203 (OID 607083)
+-- Name: hosts_powered_by_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY hosts
+ ADD CONSTRAINT hosts_powered_by_cn FOREIGN KEY (powered_by) REFERENCES powered_by(id);
+
+
+--
+-- TOC entry 224 (OID 607143)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY pending_email_changes
+ ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
+
+
+--
+-- TOC entry 225 (OID 618794)
+-- Name: pages_fti_tr; Type: TRIGGER; Schema: public; Owner: rich
+--
+
+CREATE TRIGGER pages_fti_tr
+ BEFORE INSERT OR UPDATE ON pages
+ FOR EACH ROW
+ EXECUTE PROCEDURE tsearch2('title_description_fti', 'title', 'description');
+
+
+--
+-- TOC entry 226 (OID 618796)
+-- Name: contents_fti_tr; Type: TRIGGER; Schema: public; Owner: rich
+--
+
+CREATE TRIGGER contents_fti_tr
+ BEFORE INSERT OR UPDATE ON contents
+ FOR EACH ROW
+ EXECUTE PROCEDURE tsearch2('content_fti', 'sectionname', 'content');
+
+
+--
+-- TOC entry 3 (OID 2200)
+-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
+--
+
+COMMENT ON SCHEMA public IS 'Standard public namespace';
+
+
+--
+-- TOC entry 37 (OID 543592)
+-- Name: TABLE server_settings; Type: COMMENT; Schema: public; Owner: rich
+--
+
+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.';
+
+
+--
+-- TOC entry 160 (OID 618754)
+-- Name: FUNCTION exectsq(tsvector, tsquery); Type: COMMENT; Schema: public; Owner: postgres
+--
+
+COMMENT ON FUNCTION exectsq(tsvector, tsquery) IS 'boolean operation with text index';
+
+
+--
+-- TOC entry 162 (OID 618755)
+-- Name: FUNCTION rexectsq(tsquery, tsvector); Type: COMMENT; Schema: public; Owner: postgres
+--
+
+COMMENT ON FUNCTION rexectsq(tsquery, tsvector) IS 'boolean operation with text index';
+
+
+--
+-- PostgreSQL database dump
+--
+
+SET client_encoding = 'UNICODE';
+SET check_function_bodies = false;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for TOC entry 3 (OID 547939)
+-- Name: templates; Type: TABLE DATA; Schema: public; Owner: rich
+--
+
+COPY templates (id, title_regexp, url_regexp, extension, ordering) FROM stdin;
+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
+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
+4 ^(199[0-9]|20[0-9][0-9])$ ^(199[0-9]|20[0-9][0-9])$ calendar 30
+\.
+
+
+--
+-- TOC entry 2 (OID 547937)
+-- Name: templates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rich
+--
+
+SELECT pg_catalog.setval('templates_id_seq', 4, true);
+
+
+--
+-- PostgreSQL database dump
+--
+
+SET client_encoding = 'UNICODE';
+SET check_function_bodies = false;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for TOC entry 2 (OID 543499)
+-- Name: themes; Type: TABLE DATA; Schema: public; Owner: rich
+--
+
+COPY themes (theme_css, name, description) FROM stdin;
+/_css/easyweb.css Merjis Easy Web Marketing This is the easy web marketing stylesheet developed by Merjis Ltd. Please see http://www.merjis.com/
+/_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.
+\.