--
--



--
-- TOC entry 198 (OID 14911565)
-- Name: plpgsql_call_handler(); Type: FUNC PROCEDURAL LANGUAGE; Schema: public; Owner: postgres
--

CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
    AS '$libdir/plpgsql', 'plpgsql_call_handler'
    LANGUAGE c;


--
-- TOC entry 119 (OID 14911566)
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: public; Owner: 
--

CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;


--
-- TOC entry 4 (OID 2200)
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- TOC entry 12 (OID 11524567)
-- Name: pg_ts_dict; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE pg_ts_dict (
    dict_name text NOT NULL,
    dict_init oid,
    dict_initoption text,
    dict_lexize oid NOT NULL,
    dict_comment text
);


--
-- TOC entry 13 (OID 11524567)
-- 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 120 (OID 11524574)
-- 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 121 (OID 11524575)
-- 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 122 (OID 11524576)
-- 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 123 (OID 11524577)
-- 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 124 (OID 11524578)
-- 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 125 (OID 11524579)
-- Name: dex_init(internal); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION dex_init(internal) RETURNS internal
    AS '$libdir/tsearch2', 'dex_init'
    LANGUAGE c;


--
-- TOC entry 126 (OID 11524580)
-- 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 127 (OID 11524582)
-- Name: snb_en_init(internal); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION snb_en_init(internal) RETURNS internal
    AS '$libdir/tsearch2', 'snb_en_init'
    LANGUAGE c;


--
-- TOC entry 128 (OID 11524583)
-- 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 129 (OID 11524585)
-- Name: snb_ru_init(internal); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION snb_ru_init(internal) RETURNS internal
    AS '$libdir/tsearch2', 'snb_ru_init'
    LANGUAGE c;


--
-- TOC entry 130 (OID 11524587)
-- Name: spell_init(internal); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION spell_init(internal) RETURNS internal
    AS '$libdir/tsearch2', 'spell_init'
    LANGUAGE c;


--
-- TOC entry 131 (OID 11524588)
-- 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 132 (OID 11524590)
-- Name: syn_init(internal); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION syn_init(internal) RETURNS internal
    AS '$libdir/tsearch2', 'syn_init'
    LANGUAGE c;


--
-- TOC entry 133 (OID 11524591)
-- 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 14 (OID 11524593)
-- Name: pg_ts_parser; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE pg_ts_parser (
    prs_name text NOT NULL,
    prs_start oid NOT NULL,
    prs_nexttoken oid NOT NULL,
    prs_end oid NOT NULL,
    prs_headline oid NOT NULL,
    prs_lextype oid NOT NULL,
    prs_comment text
);


--
-- TOC entry 15 (OID 11524593)
-- 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 11524601)
-- Name: tokentype; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE tokentype AS (
	tokid integer,
	alias text,
	descr text
);


--
-- TOC entry 134 (OID 11524602)
-- 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 135 (OID 11524603)
-- 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 136 (OID 11524604)
-- 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 137 (OID 11524605)
-- 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 138 (OID 11524606)
-- 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 11524608)
-- Name: tokenout; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE tokenout AS (
	tokid integer,
	token text
);


--
-- TOC entry 139 (OID 11524609)
-- 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 140 (OID 11524610)
-- 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 141 (OID 11524611)
-- 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 142 (OID 11524612)
-- 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 143 (OID 11524613)
-- 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 144 (OID 11524614)
-- 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 145 (OID 11524615)
-- 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 146 (OID 11524616)
-- 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 16 (OID 11524618)
-- 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 17 (OID 11524618)
-- 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 18 (OID 11524625)
-- 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 19 (OID 11524625)
-- 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 147 (OID 11524632)
-- 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 148 (OID 11524633)
-- 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 149 (OID 11524634)
-- 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 150 (OID 11524696)
-- 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 151 (OID 11524697)
-- 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 11524695)
-- 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 152 (OID 11524699)
-- 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 153 (OID 11524700)
-- 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 154 (OID 11524701)
-- 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 155 (OID 11524702)
-- 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 156 (OID 11524703)
-- 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 157 (OID 11524704)
-- 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 158 (OID 11524705)
-- 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 200 (OID 11524706)
-- Name: ||; Type: OPERATOR; Schema: public; Owner: postgres
--

CREATE OPERATOR || (
    PROCEDURE = concat,
    LEFTARG = tsvector,
    RIGHTARG = tsvector
);


--
-- TOC entry 159 (OID 11524708)
-- 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 160 (OID 11524709)
-- 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 11524707)
-- 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 161 (OID 11524711)
-- Name: querytree(tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION querytree(tsquery) RETURNS text
    AS '$libdir/tsearch2', 'tsquerytree'
    LANGUAGE c STRICT;


--
-- TOC entry 162 (OID 11524712)
-- 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 163 (OID 11524713)
-- 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 164 (OID 11524714)
-- 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 165 (OID 11524715)
-- 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 167 (OID 11524716)
-- 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 202 (OID 11524717)
-- Name: @@; Type: OPERATOR; Schema: public; Owner: postgres
--

CREATE OPERATOR @@ (
    PROCEDURE = rexectsq,
    LEFTARG = tsquery,
    RIGHTARG = tsvector,
    COMMUTATOR = @@,
    RESTRICT = contsel,
    JOIN = contjoinsel
);


--
-- TOC entry 201 (OID 11524718)
-- Name: @@; Type: OPERATOR; Schema: public; Owner: postgres
--

CREATE OPERATOR @@ (
    PROCEDURE = exectsq,
    LEFTARG = tsvector,
    RIGHTARG = tsquery,
    COMMUTATOR = @@,
    RESTRICT = contsel,
    JOIN = contjoinsel
);


--
-- TOC entry 169 (OID 11524719)
-- Name: tsearch2(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION tsearch2() RETURNS "trigger"
    AS '$libdir/tsearch2', 'tsearch2'
    LANGUAGE c;


--
-- TOC entry 170 (OID 11524720)
-- 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 171 (OID 11524721)
-- 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 172 (OID 11524722)
-- 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 173 (OID 11524723)
-- 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 174 (OID 11524724)
-- 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 175 (OID 11524725)
-- 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 176 (OID 11524726)
-- 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 177 (OID 11524727)
-- 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 178 (OID 11524728)
-- 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 179 (OID 11524729)
-- 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 180 (OID 11524730)
-- 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 181 (OID 11524731)
-- 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 182 (OID 11524732)
-- 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 183 (OID 11524733)
-- 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 184 (OID 11524735)
-- 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 185 (OID 11524736)
-- 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 11524734)
-- 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 186 (OID 11524738)
-- 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 187 (OID 11524739)
-- 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 188 (OID 11524740)
-- 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 189 (OID 11524741)
-- 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 190 (OID 11524742)
-- 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 191 (OID 11524743)
-- 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 192 (OID 11524744)
-- 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 203 (OID 11524745)
-- 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 11524747)
-- Name: statinfo; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE statinfo AS (
	word text,
	ndoc integer,
	nentry integer
);


--
-- TOC entry 193 (OID 11524748)
-- 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 194 (OID 11524749)
-- 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 195 (OID 11524750)
-- 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 11524752)
-- 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 196 (OID 11524753)
-- 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 197 (OID 11524754)
-- 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 20 (OID 11524757)
-- Name: pages; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE pages (
    id serial NOT NULL,
    url text,
    url_deleted text,
    title text NOT NULL,
    description text NOT NULL,
    creation_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL,
    last_modified_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL,
    hostid integer NOT NULL,
    logged_ip text,
    redirect text,
    css text,
    logged_user integer,
    title_description_fti tsvector NOT NULL
);


--
-- TOC entry 21 (OID 11524757)
-- Name: pages; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE pages FROM PUBLIC;
GRANT ALL ON TABLE pages TO "www-data";


--
-- TOC entry 67 (OID 11524757)
-- Name: pages_id_seq; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE pages_id_seq FROM PUBLIC;
GRANT ALL ON TABLE pages_id_seq TO "www-data";


--
-- TOC entry 22 (OID 11524767)
-- Name: contents; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE contents (
    id serial NOT NULL,
    pageid integer NOT NULL,
    ordering integer NOT NULL,
    sectionname text,
    content text NOT NULL,
    divname text,
    content_fti tsvector NOT NULL,
    jsgo text,
    CONSTRAINT "$2" CHECK (((jsgo IS NULL) OR (divname IS NOT NULL)))
);


--
-- TOC entry 23 (OID 11524767)
-- Name: contents; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE contents FROM PUBLIC;
GRANT ALL ON TABLE contents TO "www-data";


--
-- TOC entry 68 (OID 11524767)
-- Name: contents_id_seq; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE contents_id_seq FROM PUBLIC;
GRANT ALL ON TABLE contents_id_seq TO "www-data";


--
-- TOC entry 24 (OID 11524775)
-- Name: hosts; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE hosts (
    id serial NOT NULL,
    canonical_hostname text NOT NULL,
    css text,
    edit_anon boolean DEFAULT true NOT NULL,
    create_account_anon boolean DEFAULT true NOT NULL,
    theme_css text,
    feedback_email text,
    mailing_list boolean DEFAULT false NOT NULL,
    is_template boolean DEFAULT false NOT NULL,
    search_box boolean DEFAULT true NOT NULL,
    view_anon boolean DEFAULT true NOT NULL,
    navigation boolean DEFAULT false NOT NULL,
    powered_by integer,
    brand text,
    brand_tagline text,
    brand_description text,
    pagebug text
);


--
-- TOC entry 25 (OID 11524775)
-- Name: hosts; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE hosts FROM PUBLIC;
GRANT ALL ON TABLE hosts TO "www-data";


--
-- TOC entry 69 (OID 11524775)
-- Name: hosts_id_seq; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE hosts_id_seq FROM PUBLIC;
GRANT ALL ON TABLE hosts_id_seq TO "www-data";


--
-- TOC entry 26 (OID 11524788)
-- Name: hostnames; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE hostnames (
    hostid integer NOT NULL,
    name text NOT NULL
);


--
-- TOC entry 27 (OID 11524788)
-- Name: hostnames; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE hostnames FROM PUBLIC;
GRANT ALL ON TABLE hostnames TO "www-data";


--
-- TOC entry 28 (OID 11524795)
-- Name: images; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE images (
    id serial NOT NULL,
    hostid integer NOT NULL,
    name text,
    name_deleted text,
    image bytea NOT NULL,
    width integer NOT NULL,
    height integer NOT NULL,
    alt text NOT NULL,
    title text,
    longdesc text,
    "class" text,
    mime_type text NOT NULL,
    thumbnail bytea,
    tn_width integer,
    tn_height integer,
    tn_mime_type text,
    upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
);


--
-- TOC entry 29 (OID 11524795)
-- Name: images; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE images FROM PUBLIC;
GRANT ALL ON TABLE images TO "www-data";


--
-- TOC entry 70 (OID 11524795)
-- Name: images_id_seq; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE images_id_seq FROM PUBLIC;
GRANT ALL ON TABLE images_id_seq TO "www-data";


--
-- TOC entry 30 (OID 11524804)
-- Name: files; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE files (
    id serial NOT NULL,
    hostid integer NOT NULL,
    name text,
    name_deleted text,
    content bytea NOT NULL,
    title text,
    mime_type text NOT NULL,
    upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
);


--
-- TOC entry 31 (OID 11524804)
-- Name: files; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE files FROM PUBLIC;
GRANT ALL ON TABLE files TO "www-data";


--
-- TOC entry 71 (OID 11524804)
-- Name: files_id_seq; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE files_id_seq FROM PUBLIC;
GRANT ALL ON TABLE files_id_seq TO "www-data";


--
-- TOC entry 33 (OID 11524813)
-- Name: users; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE users FROM PUBLIC;
GRANT ALL ON TABLE users TO "www-data";


--
-- TOC entry 72 (OID 11524813)
-- Name: users_id_seq; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE users_id_seq FROM PUBLIC;
GRANT ALL ON TABLE users_id_seq TO "www-data";


--
-- TOC entry 35 (OID 11524828)
-- Name: usercookies; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE usercookies FROM PUBLIC;
GRANT ALL ON TABLE usercookies TO "www-data";


--
-- TOC entry 36 (OID 11524833)
-- Name: sitemenu; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE sitemenu (
    hostid integer NOT NULL,
    url text NOT NULL,
    label text NOT NULL,
    ordering integer NOT NULL
);


--
-- TOC entry 37 (OID 11524833)
-- Name: sitemenu; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE sitemenu FROM PUBLIC;
GRANT ALL ON TABLE sitemenu TO "www-data";


--
-- TOC entry 38 (OID 11524840)
-- Name: contacts; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE contacts (
    id serial NOT NULL,
    hostid integer NOT NULL,
    name text NOT NULL,
    subject text NOT NULL
);


--
-- TOC entry 39 (OID 11524840)
-- Name: contacts; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE contacts FROM PUBLIC;
GRANT ALL ON TABLE contacts TO "www-data";


--
-- TOC entry 73 (OID 11524840)
-- Name: contacts_id_seq; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE contacts_id_seq FROM PUBLIC;
GRANT ALL ON TABLE contacts_id_seq TO "www-data";


--
-- TOC entry 40 (OID 11524846)
-- Name: contact_emails; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE contact_emails (
    contactid integer NOT NULL,
    email text NOT NULL
);


--
-- TOC entry 41 (OID 11524846)
-- Name: contact_emails; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE contact_emails FROM PUBLIC;
GRANT ALL ON TABLE contact_emails TO "www-data";


--
-- TOC entry 42 (OID 11524851)
-- Name: themes; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE themes (
    theme_css text NOT NULL,
    name text NOT NULL,
    description text NOT NULL
);


--
-- TOC entry 43 (OID 11524851)
-- Name: themes; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE themes FROM PUBLIC;
GRANT SELECT ON TABLE themes TO "www-data";


--
-- TOC entry 44 (OID 11524856)
-- Name: server_settings; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE server_settings (
    "version" integer NOT NULL,
    stats_page text,
    crash_email text
);


--
-- TOC entry 46 (OID 11524856)
-- Name: server_settings; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE server_settings FROM PUBLIC;
GRANT SELECT ON TABLE server_settings TO "www-data";


--
-- TOC entry 47 (OID 11524861)
-- Name: page_emails; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE page_emails (
    hostid integer NOT NULL,
    url text NOT NULL,
    email text NOT NULL,
    entry_date date DEFAULT ('now'::text)::date NOT NULL,
    last_sent date DEFAULT ('now'::text)::date NOT NULL,
    pending text,
    opt_out text NOT NULL
);


--
-- TOC entry 48 (OID 11524861)
-- Name: page_emails; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE page_emails FROM PUBLIC;
GRANT ALL ON TABLE page_emails TO "www-data";


--
-- TOC entry 49 (OID 11524868)
-- Name: mailing_lists; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE mailing_lists (
    hostid integer NOT NULL,
    email text NOT NULL,
    entry_date date DEFAULT ('now'::text)::date NOT NULL,
    pending text,
    opt_out text NOT NULL,
    name text NOT NULL
);


--
-- TOC entry 50 (OID 11524868)
-- Name: mailing_lists; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE mailing_lists FROM PUBLIC;
GRANT ALL ON TABLE mailing_lists TO "www-data";


--
-- TOC entry 51 (OID 11524874)
-- Name: links; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE links (
    hostid integer NOT NULL,
    from_url text NOT NULL,
    to_url text NOT NULL,
    CONSTRAINT links_not_selfref_cn CHECK ((from_url <> to_url))
);


--
-- TOC entry 52 (OID 11524874)
-- Name: links; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE links FROM PUBLIC;
GRANT ALL ON TABLE links TO "www-data";


--
-- TOC entry 53 (OID 11524882)
-- Name: templates; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE templates (
    id serial NOT NULL,
    title_regexp text NOT NULL,
    url_regexp text NOT NULL,
    extension text NOT NULL,
    ordering integer NOT NULL
);


--
-- TOC entry 54 (OID 11524882)
-- Name: templates; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE templates FROM PUBLIC;
GRANT SELECT ON TABLE templates TO "www-data";


--
-- TOC entry 74 (OID 11524882)
-- Name: templates_id_seq; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE templates_id_seq FROM PUBLIC;


--
-- TOC entry 55 (OID 11524888)
-- Name: recently_visited; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE recently_visited (
    userid integer NOT NULL,
    hostid integer NOT NULL,
    url text NOT NULL,
    visit_time timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
);


--
-- TOC entry 56 (OID 11524888)
-- Name: recently_visited; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE recently_visited FROM PUBLIC;
GRANT ALL ON TABLE recently_visited TO "www-data";


--
-- TOC entry 57 (OID 11524896)
-- Name: messages; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE messages (
    id serial NOT NULL,
    subject text NOT NULL,
    inet_message_id text NOT NULL,
    message_date timestamp with time zone NOT NULL,
    hostid integer NOT NULL
);


--
-- TOC entry 58 (OID 11524896)
-- Name: messages; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE messages FROM PUBLIC;
GRANT ALL ON TABLE messages TO "www-data";


--
-- TOC entry 75 (OID 11524896)
-- Name: messages_id_seq; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE messages_id_seq FROM PUBLIC;
GRANT ALL ON TABLE messages_id_seq TO "www-data";


--
-- TOC entry 59 (OID 11524902)
-- Name: msg_references; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE msg_references (
    message_id integer NOT NULL,
    inet_message_id text NOT NULL,
    ordering integer NOT NULL
);


--
-- TOC entry 60 (OID 11524902)
-- Name: msg_references; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE msg_references FROM PUBLIC;
GRANT ALL ON TABLE msg_references TO "www-data";


--
-- TOC entry 61 (OID 11524909)
-- Name: powered_by; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE powered_by (
    id serial NOT NULL,
    name text NOT NULL,
    url text NOT NULL
);


--
-- TOC entry 62 (OID 11524909)
-- 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 64 (OID 11524915)
-- 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 199 (OID 14911567)
-- Name: contents_jsgo_check_tg(); Type: FUNCTION; Schema: public; Owner: rich
--

CREATE FUNCTION contents_jsgo_check_tg() RETURNS "trigger"
    AS '

declare
	my_hostid integer;
	my_count integer;

begin
	if new.jsgo is not null then
		-- Get the hostid
		select into my_hostid p.hostid
		  from pages p
		 where p.id = new.pageid;
		-- Check that (hostid, url) where url = new.jsgo exists.
		select into my_count count(p.*)
		  from pages p
		 where p.hostid = my_hostid
                   and p.url is not null
		   and p.url = new.jsgo
                   and p.redirect is null;
		if my_count < 1 then
			raise exception ''contents.jsgo points to non-existent page (%, %)'',
			  my_hostid, new.jsgo;
		end if;
	end if;

	-- Everything is OK.  Return the new row unmodified.
	return new;
end;

'
    LANGUAGE plpgsql;


--
-- TOC entry 65 (OID 14911929)
-- Name: macros; Type: TABLE; Schema: public; Owner: rich
--

CREATE TABLE macros (
    hostid integer NOT NULL,
    name text NOT NULL,
    content text NOT NULL
);


--
-- TOC entry 66 (OID 14911929)
-- Name: macros; Type: ACL; Schema: public; Owner: rich
--

REVOKE ALL ON TABLE macros FROM PUBLIC;
GRANT ALL ON TABLE macros TO "www-data";


--
-- TOC entry 90 (OID 11576669)
-- 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 85 (OID 11576670)
-- Name: pages_url_uq; Type: INDEX; Schema: public; Owner: rich
--

CREATE UNIQUE INDEX pages_url_uq ON pages USING btree (hostid, url);


--
-- TOC entry 92 (OID 11576671)
-- Name: images_name_uq; Type: INDEX; Schema: public; Owner: rich
--

CREATE UNIQUE INDEX images_name_uq ON images USING btree (hostid, name);


--
-- TOC entry 94 (OID 11576672)
-- Name: files_name_uq; Type: INDEX; Schema: public; Owner: rich
--

CREATE UNIQUE INDEX files_name_uq ON files USING btree (hostid, name);


--
-- TOC entry 100 (OID 11576675)
-- Name: sitemenu_ordering_uq; Type: INDEX; Schema: public; Owner: rich
--

CREATE UNIQUE INDEX sitemenu_ordering_uq ON sitemenu USING btree (hostid, ordering);


--
-- TOC entry 101 (OID 11576676)
-- Name: sitemenu_url_uq; Type: INDEX; Schema: public; Owner: rich
--

CREATE UNIQUE INDEX sitemenu_url_uq ON sitemenu USING btree (hostid, url);


--
-- TOC entry 104 (OID 11576677)
-- 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 105 (OID 11576678)
-- 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 106 (OID 11576679)
-- 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 107 (OID 11576680)
-- 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 102 (OID 11576681)
-- Name: contacts_name_uq; Type: INDEX; Schema: public; Owner: rich
--

CREATE UNIQUE INDEX contacts_name_uq ON contacts USING btree (hostid, name);


--
-- TOC entry 108 (OID 11576682)
-- 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 109 (OID 11576683)
-- 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 111 (OID 11576684)
-- Name: templates_title_uq; Type: INDEX; Schema: public; Owner: rich
--

CREATE UNIQUE INDEX templates_title_uq ON templates USING btree (title_regexp);


--
-- TOC entry 112 (OID 11576685)
-- Name: templates_url_uq; Type: INDEX; Schema: public; Owner: rich
--

CREATE UNIQUE INDEX templates_url_uq ON templates USING btree (url_regexp);


--
-- TOC entry 113 (OID 11576686)
-- 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 114 (OID 11576687)
-- 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 84 (OID 11576688)
-- Name: pages_url_ix; Type: INDEX; Schema: public; Owner: rich
--

CREATE INDEX pages_url_ix ON pages USING btree (url);


--
-- TOC entry 83 (OID 11576689)
-- Name: pages_redirect_ix; Type: INDEX; Schema: public; Owner: rich
--

CREATE INDEX pages_redirect_ix ON pages USING btree (redirect);


--
-- TOC entry 80 (OID 11576690)
-- Name: pages_fti_idx; Type: INDEX; Schema: public; Owner: rich
--

CREATE INDEX pages_fti_idx ON pages USING gist (title_description_fti);


--
-- TOC entry 86 (OID 11576691)
-- Name: contents_fti_idx; Type: INDEX; Schema: public; Owner: rich
--

CREATE INDEX contents_fti_idx ON contents USING gist (content_fti);


--
-- TOC entry 87 (OID 11576692)
-- Name: contents_pageid_idx; Type: INDEX; Schema: public; Owner: rich
--

CREATE INDEX contents_pageid_idx ON contents USING btree (pageid);


--
-- TOC entry 91 (OID 11576693)
-- Name: hostnames_name_uq; Type: INDEX; Schema: public; Owner: rich
--

CREATE UNIQUE INDEX hostnames_name_uq ON hostnames USING btree (name);


--
-- TOC entry 81 (OID 11576695)
-- Name: pages_lc_title; Type: INDEX; Schema: public; Owner: rich
--

CREATE INDEX pages_lc_title ON pages USING btree (lower(title));


--
-- TOC entry 76 (OID 11524572)
-- 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 77 (OID 11524598)
-- 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 78 (OID 11524623)
-- 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 79 (OID 11524630)
-- 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 82 (OID 11576696)
-- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY pages
    ADD CONSTRAINT pages_pkey PRIMARY KEY (id);


--
-- TOC entry 88 (OID 11576698)
-- Name: contents_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY contents
    ADD CONSTRAINT contents_pkey PRIMARY KEY (id);


--
-- TOC entry 89 (OID 11576700)
-- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY hosts
    ADD CONSTRAINT hosts_pkey PRIMARY KEY (id);


--
-- TOC entry 93 (OID 11576702)
-- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY images
    ADD CONSTRAINT images_pkey PRIMARY KEY (id);


--
-- TOC entry 95 (OID 11576704)
-- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY files
    ADD CONSTRAINT files_pkey PRIMARY KEY (id);


--
-- TOC entry 103 (OID 11576708)
-- Name: contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY contacts
    ADD CONSTRAINT contacts_pkey PRIMARY KEY (id);


--
-- TOC entry 110 (OID 11576710)
-- Name: templates_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY templates
    ADD CONSTRAINT templates_pkey PRIMARY KEY (id);


--
-- TOC entry 115 (OID 11576712)
-- Name: messages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY messages
    ADD CONSTRAINT messages_pkey PRIMARY KEY (id);


--
-- TOC entry 116 (OID 11576714)
-- 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 118 (OID 14911934)
-- Name: macros_hostid_key; Type: CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY macros
    ADD CONSTRAINT macros_hostid_key UNIQUE (hostid, name);


--
-- TOC entry 208 (OID 11576718)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY contents
    ADD CONSTRAINT "$1" FOREIGN KEY (pageid) REFERENCES pages(id);


--
-- TOC entry 212 (OID 11576722)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY hostnames
    ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);


--
-- TOC entry 209 (OID 11576726)
-- 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 204 (OID 11576730)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY pages
    ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);


--
-- TOC entry 213 (OID 11576734)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY images
    ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);


--
-- TOC entry 214 (OID 11576738)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY files
    ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);


--
-- TOC entry 205 (OID 11576742)
-- 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 206 (OID 11576754)
-- 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 207 (OID 11576758)
-- 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 217 (OID 11576762)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY sitemenu
    ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);


--
-- TOC entry 218 (OID 11576766)
-- 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 219 (OID 11576770)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY contacts
    ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);


--
-- TOC entry 220 (OID 11576774)
-- 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 210 (OID 11576778)
-- 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 221 (OID 11576782)
-- 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 222 (OID 11576786)
-- 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 223 (OID 11576790)
-- 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 224 (OID 11576794)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY links
    ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);


--
-- TOC entry 225 (OID 11576798)
-- 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 226 (OID 11576802)
-- 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 227 (OID 11576806)
-- 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 228 (OID 11576810)
-- 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 229 (OID 11576814)
-- 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 231 (OID 11576818)
-- 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 230 (OID 11576822)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY messages
    ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);


--
-- TOC entry 211 (OID 11576826)
-- 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 233 (OID 14911936)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--

ALTER TABLE ONLY macros
    ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);


--
-- TOC entry 236 (OID 14911568)
-- Name: contents_jsgo_check_tg; Type: TRIGGER; Schema: public; Owner: rich
--

CREATE TRIGGER contents_jsgo_check_tg
    BEFORE INSERT OR UPDATE ON contents
    FOR EACH ROW
    EXECUTE PROCEDURE contents_jsgo_check_tg();


--
-- TOC entry 3 (OID 2200)
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public namespace';


--
-- TOC entry 166 (OID 11524715)
-- 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 168 (OID 11524716)
-- Name: FUNCTION rexectsq(tsquery, tsvector); Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON FUNCTION rexectsq(tsquery, tsvector) IS 'boolean operation with text index';


--
-- TOC entry 45 (OID 11524856)
-- 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.';


--
--



--
-- Data for TOC entry 3 (OID 11524882)
-- 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
\.



--
--



--
-- Data for TOC entry 2 (OID 11524851)
-- 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.
\.


