X-Git-Url: http://git.annexia.org/?a=blobdiff_plain;f=cocanwiki.sql;h=58616ef85d3fd4d19882a660dcc02569ae920916;hb=beee5bf06fd433c105fda1386b3e288768221216;hp=7f5b718108737b78dc6bd4d19f4087129cffae06;hpb=c5f822d1ca81042a8c0be2955668b0abebf1b11c;p=cocanwiki.git diff --git a/cocanwiki.sql b/cocanwiki.sql index 7f5b718..58616ef 100644 --- a/cocanwiki.sql +++ b/cocanwiki.sql @@ -18,7 +18,7 @@ GRANT ALL ON SCHEMA public TO PUBLIC; SET search_path = public, pg_catalog; -- --- TOC entry 5 (OID 536004) +-- TOC entry 12 (OID 536004) -- Name: pages; Type: TABLE; Schema: public; Owner: rich -- @@ -34,12 +34,13 @@ CREATE TABLE pages ( logged_ip text, redirect text, css text, - logged_user integer + logged_user integer, + title_description_fti tsvector NOT NULL ); -- --- TOC entry 6 (OID 536004) +-- TOC entry 13 (OID 536004) -- Name: pages; Type: ACL; Schema: public; Owner: rich -- @@ -48,7 +49,7 @@ GRANT ALL ON TABLE pages TO "www-data"; -- --- TOC entry 50 (OID 536004) +-- TOC entry 65 (OID 536004) -- Name: pages_id_seq; Type: ACL; Schema: public; Owner: rich -- @@ -57,7 +58,7 @@ GRANT ALL ON TABLE pages_id_seq TO "www-data"; -- --- TOC entry 7 (OID 536021) +-- TOC entry 14 (OID 536021) -- Name: contents; Type: TABLE; Schema: public; Owner: rich -- @@ -67,12 +68,13 @@ CREATE TABLE contents ( ordering integer NOT NULL, sectionname text, content text NOT NULL, - divname text + divname text, + content_fti tsvector NOT NULL ); -- --- TOC entry 8 (OID 536021) +-- TOC entry 15 (OID 536021) -- Name: contents; Type: ACL; Schema: public; Owner: rich -- @@ -81,7 +83,7 @@ GRANT ALL ON TABLE contents TO "www-data"; -- --- TOC entry 51 (OID 536021) +-- TOC entry 66 (OID 536021) -- Name: contents_id_seq; Type: ACL; Schema: public; Owner: rich -- @@ -90,7 +92,7 @@ GRANT ALL ON TABLE contents_id_seq TO "www-data"; -- --- TOC entry 9 (OID 536371) +-- TOC entry 16 (OID 536371) -- Name: hosts; Type: TABLE; Schema: public; Owner: rich -- @@ -107,12 +109,15 @@ CREATE TABLE hosts ( search_box boolean DEFAULT true NOT NULL, view_anon boolean DEFAULT true NOT NULL, navigation boolean DEFAULT false NOT NULL, - powered_by integer + powered_by integer, + brand text, + brand_tagline text, + brand_description text ); -- --- TOC entry 10 (OID 536371) +-- TOC entry 17 (OID 536371) -- Name: hosts; Type: ACL; Schema: public; Owner: rich -- @@ -121,7 +126,7 @@ GRANT ALL ON TABLE hosts TO "www-data"; -- --- TOC entry 52 (OID 536371) +-- TOC entry 67 (OID 536371) -- Name: hosts_id_seq; Type: ACL; Schema: public; Owner: rich -- @@ -130,7 +135,7 @@ GRANT ALL ON TABLE hosts_id_seq TO "www-data"; -- --- TOC entry 11 (OID 536379) +-- TOC entry 18 (OID 536379) -- Name: hostnames; Type: TABLE; Schema: public; Owner: rich -- @@ -141,7 +146,7 @@ CREATE TABLE hostnames ( -- --- TOC entry 12 (OID 536379) +-- TOC entry 19 (OID 536379) -- Name: hostnames; Type: ACL; Schema: public; Owner: rich -- @@ -150,7 +155,7 @@ GRANT ALL ON TABLE hostnames TO "www-data"; -- --- TOC entry 13 (OID 537151) +-- TOC entry 20 (OID 537151) -- Name: images; Type: TABLE; Schema: public; Owner: rich -- @@ -176,7 +181,7 @@ CREATE TABLE images ( -- --- TOC entry 14 (OID 537151) +-- TOC entry 21 (OID 537151) -- Name: images; Type: ACL; Schema: public; Owner: rich -- @@ -185,7 +190,7 @@ GRANT ALL ON TABLE images TO "www-data"; -- --- TOC entry 53 (OID 537151) +-- TOC entry 68 (OID 537151) -- Name: images_id_seq; Type: ACL; Schema: public; Owner: rich -- @@ -194,7 +199,7 @@ GRANT ALL ON TABLE images_id_seq TO "www-data"; -- --- TOC entry 15 (OID 537166) +-- TOC entry 22 (OID 537166) -- Name: files; Type: TABLE; Schema: public; Owner: rich -- @@ -211,7 +216,7 @@ CREATE TABLE files ( -- --- TOC entry 16 (OID 537166) +-- TOC entry 23 (OID 537166) -- Name: files; Type: ACL; Schema: public; Owner: rich -- @@ -220,7 +225,7 @@ GRANT ALL ON TABLE files TO "www-data"; -- --- TOC entry 54 (OID 537166) +-- TOC entry 69 (OID 537166) -- Name: files_id_seq; Type: ACL; Schema: public; Owner: rich -- @@ -229,7 +234,7 @@ GRANT ALL ON TABLE files_id_seq TO "www-data"; -- --- TOC entry 17 (OID 540816) +-- TOC entry 24 (OID 540816) -- Name: users; Type: TABLE; Schema: public; Owner: rich -- @@ -248,13 +253,12 @@ CREATE TABLE users ( force_password_change boolean DEFAULT false NOT NULL, can_import_mail boolean DEFAULT false NOT NULL, email_notify boolean DEFAULT true NOT NULL, - invite text, - diff_sidebyside boolean DEFAULT false NOT NULL + invite text ); -- --- TOC entry 18 (OID 540816) +-- TOC entry 25 (OID 540816) -- Name: users; Type: ACL; Schema: public; Owner: rich -- @@ -263,7 +267,7 @@ GRANT ALL ON TABLE users TO "www-data"; -- --- TOC entry 55 (OID 540816) +-- TOC entry 70 (OID 540816) -- Name: users_id_seq; Type: ACL; Schema: public; Owner: rich -- @@ -272,7 +276,7 @@ GRANT ALL ON TABLE users_id_seq TO "www-data"; -- --- TOC entry 19 (OID 540832) +-- TOC entry 26 (OID 540832) -- Name: usercookies; Type: TABLE; Schema: public; Owner: rich -- @@ -283,7 +287,7 @@ CREATE TABLE usercookies ( -- --- TOC entry 20 (OID 540832) +-- TOC entry 27 (OID 540832) -- Name: usercookies; Type: ACL; Schema: public; Owner: rich -- @@ -292,7 +296,7 @@ GRANT ALL ON TABLE usercookies TO "www-data"; -- --- TOC entry 21 (OID 540961) +-- TOC entry 28 (OID 540961) -- Name: sitemenu; Type: TABLE; Schema: public; Owner: rich -- @@ -305,7 +309,7 @@ CREATE TABLE sitemenu ( -- --- TOC entry 22 (OID 540961) +-- TOC entry 29 (OID 540961) -- Name: sitemenu; Type: ACL; Schema: public; Owner: rich -- @@ -314,7 +318,7 @@ GRANT ALL ON TABLE sitemenu TO "www-data"; -- --- TOC entry 23 (OID 542605) +-- TOC entry 30 (OID 542605) -- Name: contacts; Type: TABLE; Schema: public; Owner: rich -- @@ -327,7 +331,7 @@ CREATE TABLE contacts ( -- --- TOC entry 24 (OID 542605) +-- TOC entry 31 (OID 542605) -- Name: contacts; Type: ACL; Schema: public; Owner: rich -- @@ -336,7 +340,7 @@ GRANT ALL ON TABLE contacts TO "www-data"; -- --- TOC entry 56 (OID 542605) +-- TOC entry 71 (OID 542605) -- Name: contacts_id_seq; Type: ACL; Schema: public; Owner: rich -- @@ -345,7 +349,7 @@ GRANT ALL ON TABLE contacts_id_seq TO "www-data"; -- --- TOC entry 25 (OID 542617) +-- TOC entry 32 (OID 542617) -- Name: contact_emails; Type: TABLE; Schema: public; Owner: rich -- @@ -356,7 +360,7 @@ CREATE TABLE contact_emails ( -- --- TOC entry 26 (OID 542617) +-- TOC entry 33 (OID 542617) -- Name: contact_emails; Type: ACL; Schema: public; Owner: rich -- @@ -365,7 +369,7 @@ GRANT ALL ON TABLE contact_emails TO "www-data"; -- --- TOC entry 27 (OID 543499) +-- TOC entry 34 (OID 543499) -- Name: themes; Type: TABLE; Schema: public; Owner: rich -- @@ -377,7 +381,7 @@ CREATE TABLE themes ( -- --- TOC entry 28 (OID 543499) +-- TOC entry 35 (OID 543499) -- Name: themes; Type: ACL; Schema: public; Owner: rich -- @@ -386,7 +390,7 @@ GRANT SELECT ON TABLE themes TO "www-data"; -- --- TOC entry 29 (OID 543592) +-- TOC entry 36 (OID 543592) -- Name: server_settings; Type: TABLE; Schema: public; Owner: rich -- @@ -398,7 +402,7 @@ CREATE TABLE server_settings ( -- --- TOC entry 31 (OID 543592) +-- TOC entry 38 (OID 543592) -- Name: server_settings; Type: ACL; Schema: public; Owner: rich -- @@ -407,7 +411,7 @@ GRANT SELECT ON TABLE server_settings TO "www-data"; -- --- TOC entry 32 (OID 543754) +-- TOC entry 39 (OID 543754) -- Name: page_emails; Type: TABLE; Schema: public; Owner: rich -- @@ -423,7 +427,7 @@ CREATE TABLE page_emails ( -- --- TOC entry 33 (OID 543754) +-- TOC entry 40 (OID 543754) -- Name: page_emails; Type: ACL; Schema: public; Owner: rich -- @@ -432,7 +436,7 @@ GRANT ALL ON TABLE page_emails TO "www-data"; -- --- TOC entry 34 (OID 543785) +-- TOC entry 41 (OID 543785) -- Name: mailing_lists; Type: TABLE; Schema: public; Owner: rich -- @@ -447,7 +451,7 @@ CREATE TABLE mailing_lists ( -- --- TOC entry 35 (OID 543785) +-- TOC entry 42 (OID 543785) -- Name: mailing_lists; Type: ACL; Schema: public; Owner: rich -- @@ -456,7 +460,7 @@ GRANT ALL ON TABLE mailing_lists TO "www-data"; -- --- TOC entry 36 (OID 544445) +-- TOC entry 43 (OID 544445) -- Name: links; Type: TABLE; Schema: public; Owner: rich -- @@ -469,7 +473,7 @@ CREATE TABLE links ( -- --- TOC entry 37 (OID 544445) +-- TOC entry 44 (OID 544445) -- Name: links; Type: ACL; Schema: public; Owner: rich -- @@ -478,7 +482,7 @@ GRANT ALL ON TABLE links TO "www-data"; -- --- TOC entry 38 (OID 547939) +-- TOC entry 45 (OID 547939) -- Name: templates; Type: TABLE; Schema: public; Owner: rich -- @@ -492,7 +496,7 @@ CREATE TABLE templates ( -- --- TOC entry 39 (OID 547939) +-- TOC entry 46 (OID 547939) -- Name: templates; Type: ACL; Schema: public; Owner: rich -- @@ -501,7 +505,7 @@ GRANT SELECT ON TABLE templates TO "www-data"; -- --- TOC entry 57 (OID 547939) +-- TOC entry 72 (OID 547939) -- Name: templates_id_seq; Type: ACL; Schema: public; Owner: rich -- @@ -509,7 +513,7 @@ REVOKE ALL ON TABLE templates_id_seq FROM PUBLIC; -- --- TOC entry 40 (OID 551123) +-- TOC entry 47 (OID 551123) -- Name: recently_visited; Type: TABLE; Schema: public; Owner: rich -- @@ -522,7 +526,7 @@ CREATE TABLE recently_visited ( -- --- TOC entry 41 (OID 551123) +-- TOC entry 48 (OID 551123) -- Name: recently_visited; Type: ACL; Schema: public; Owner: rich -- @@ -531,7 +535,7 @@ GRANT ALL ON TABLE recently_visited TO "www-data"; -- --- TOC entry 42 (OID 551675) +-- TOC entry 49 (OID 551675) -- Name: messages; Type: TABLE; Schema: public; Owner: rich -- @@ -545,7 +549,7 @@ CREATE TABLE messages ( -- --- TOC entry 43 (OID 551675) +-- TOC entry 50 (OID 551675) -- Name: messages; Type: ACL; Schema: public; Owner: rich -- @@ -554,7 +558,7 @@ GRANT ALL ON TABLE messages TO "www-data"; -- --- TOC entry 58 (OID 551675) +-- TOC entry 73 (OID 551675) -- Name: messages_id_seq; Type: ACL; Schema: public; Owner: rich -- @@ -563,7 +567,7 @@ GRANT ALL ON TABLE messages_id_seq TO "www-data"; -- --- TOC entry 44 (OID 551685) +-- TOC entry 51 (OID 551685) -- Name: msg_references; Type: TABLE; Schema: public; Owner: rich -- @@ -575,7 +579,7 @@ CREATE TABLE msg_references ( -- --- TOC entry 45 (OID 551685) +-- TOC entry 52 (OID 551685) -- Name: msg_references; Type: ACL; Schema: public; Owner: rich -- @@ -584,7 +588,7 @@ GRANT ALL ON TABLE msg_references TO "www-data"; -- --- TOC entry 46 (OID 607075) +-- TOC entry 53 (OID 607075) -- Name: powered_by; Type: TABLE; Schema: public; Owner: rich -- @@ -596,7 +600,7 @@ CREATE TABLE powered_by ( -- --- TOC entry 47 (OID 607075) +-- TOC entry 54 (OID 607075) -- Name: powered_by; Type: ACL; Schema: public; Owner: rich -- @@ -605,7 +609,7 @@ GRANT SELECT ON TABLE powered_by TO "www-data"; -- --- TOC entry 48 (OID 607136) +-- TOC entry 55 (OID 607136) -- Name: pending_email_changes; Type: TABLE; Schema: public; Owner: rich -- @@ -618,7 +622,7 @@ CREATE TABLE pending_email_changes ( -- --- TOC entry 49 (OID 607136) +-- TOC entry 56 (OID 607136) -- Name: pending_email_changes; Type: ACL; Schema: public; Owner: rich -- @@ -627,23 +631,1039 @@ GRANT ALL ON TABLE pending_email_changes TO "www-data"; -- --- TOC entry 65 (OID 536388) --- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich +-- 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 116 (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 117 (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 118 (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 119 (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 120 (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 121 (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 122 (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 123 (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 124 (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 125 (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 126 (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 127 (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 128 (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 129 (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 130 (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 131 (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 132 (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 133 (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 134 (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 135 (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 136 (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 137 (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 138 (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 139 (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 140 (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 141 (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 142 (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 143 (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 144 (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 145 (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 146 (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 147 (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 148 (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 149 (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 150 (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 151 (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 152 (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 153 (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 154 (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 194 (OID 618745) +-- Name: ||; Type: OPERATOR; Schema: public; Owner: postgres +-- + +CREATE OPERATOR || ( + PROCEDURE = concat, + LEFTARG = tsvector, + RIGHTARG = tsvector +); + + +-- +-- TOC entry 155 (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 156 (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 157 (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 158 (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 159 (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 160 (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 161 (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 163 (OID 618755) +-- Name: rexectsq(tsquery, tsvector); Type: FUNCTION; Schema: public; Owner: postgres -- -CREATE UNIQUE INDEX hostnames_hostid_name_uq ON hostnames USING btree (hostid, name); +CREATE FUNCTION rexectsq(tsquery, tsvector) RETURNS boolean + AS '$libdir/tsearch2', 'rexectsq' + LANGUAGE c IMMUTABLE STRICT; + + +-- +-- TOC entry 196 (OID 618756) +-- Name: @@; Type: OPERATOR; Schema: public; Owner: postgres +-- + +CREATE OPERATOR @@ ( + PROCEDURE = rexectsq, + LEFTARG = tsquery, + RIGHTARG = tsvector, + COMMUTATOR = @@, + RESTRICT = contsel, + JOIN = contjoinsel +); + + +-- +-- TOC entry 195 (OID 618757) +-- Name: @@; Type: OPERATOR; Schema: public; Owner: postgres +-- + +CREATE OPERATOR @@ ( + PROCEDURE = exectsq, + LEFTARG = tsvector, + RIGHTARG = tsquery, + COMMUTATOR = @@, + RESTRICT = contsel, + JOIN = contjoinsel +); + + +-- +-- TOC entry 165 (OID 618758) +-- Name: tsearch2(); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION tsearch2() RETURNS "trigger" + AS '$libdir/tsearch2', 'tsearch2' + LANGUAGE c; + + +-- +-- TOC entry 166 (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 167 (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 168 (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 169 (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 170 (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 171 (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 172 (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 173 (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 174 (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 175 (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 176 (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 177 (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 178 (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 179 (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 180 (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 181 (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 182 (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 183 (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 184 (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 185 (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 186 (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 187 (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 188 (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 197 (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 189 (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 190 (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 191 (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 192 (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 193 (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 66 (OID 536389) --- Name: hostnams_name_uq; Type: INDEX; Schema: public; Owner: rich +-- TOC entry 84 (OID 536388) +-- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich -- -CREATE UNIQUE INDEX hostnams_name_uq ON hostnames USING btree (name); +CREATE UNIQUE INDEX hostnames_hostid_name_uq ON hostnames USING btree (hostid, name); -- --- TOC entry 62 (OID 536419) +-- TOC entry 79 (OID 536419) -- Name: pages_url_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -651,7 +1671,7 @@ CREATE UNIQUE INDEX pages_url_uq ON pages USING btree (hostid, url); -- --- TOC entry 67 (OID 540251) +-- TOC entry 86 (OID 540251) -- Name: images_name_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -659,7 +1679,7 @@ CREATE UNIQUE INDEX images_name_uq ON images USING btree (hostid, name); -- --- TOC entry 69 (OID 540252) +-- TOC entry 88 (OID 540252) -- Name: files_name_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -667,7 +1687,7 @@ CREATE UNIQUE INDEX files_name_uq ON files USING btree (hostid, name); -- --- TOC entry 72 (OID 540831) +-- TOC entry 91 (OID 540831) -- Name: users_name_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -675,7 +1695,7 @@ CREATE UNIQUE INDEX users_name_uq ON users USING btree (hostid, name); -- --- TOC entry 71 (OID 540946) +-- TOC entry 90 (OID 540946) -- Name: users_id_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -683,7 +1703,7 @@ CREATE UNIQUE INDEX users_id_uq ON users USING btree (hostid, id); -- --- TOC entry 74 (OID 540970) +-- TOC entry 94 (OID 540970) -- Name: sitemenu_ordering_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -691,7 +1711,7 @@ CREATE UNIQUE INDEX sitemenu_ordering_uq ON sitemenu USING btree (hostid, orderi -- --- TOC entry 75 (OID 540971) +-- TOC entry 95 (OID 540971) -- Name: sitemenu_url_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -699,7 +1719,7 @@ CREATE UNIQUE INDEX sitemenu_url_uq ON sitemenu USING btree (hostid, url); -- --- TOC entry 78 (OID 542626) +-- TOC entry 98 (OID 542626) -- Name: contact_emails_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -707,7 +1727,7 @@ CREATE UNIQUE INDEX contact_emails_uq ON contact_emails USING btree (contactid, -- --- TOC entry 79 (OID 543505) +-- TOC entry 99 (OID 543505) -- Name: themes_theme_css_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -715,7 +1735,7 @@ CREATE UNIQUE INDEX themes_theme_css_uq ON themes USING btree (theme_css); -- --- TOC entry 80 (OID 543763) +-- TOC entry 100 (OID 543763) -- Name: page_emails_email_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -723,7 +1743,7 @@ CREATE UNIQUE INDEX page_emails_email_uq ON page_emails USING btree (hostid, url -- --- TOC entry 81 (OID 543795) +-- TOC entry 101 (OID 543795) -- Name: mailing_lists_email_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -731,7 +1751,7 @@ CREATE UNIQUE INDEX mailing_lists_email_uq ON mailing_lists USING btree (hostid, -- --- TOC entry 76 (OID 543880) +-- TOC entry 96 (OID 543880) -- Name: contacts_name_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -739,7 +1759,7 @@ CREATE UNIQUE INDEX contacts_name_uq ON contacts USING btree (hostid, name); -- --- TOC entry 82 (OID 544454) +-- TOC entry 102 (OID 544454) -- Name: links_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -747,7 +1767,7 @@ CREATE UNIQUE INDEX links_uq ON links USING btree (hostid, from_url, to_url); -- --- TOC entry 83 (OID 547951) +-- TOC entry 103 (OID 547951) -- Name: templates_ext_ord_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -755,7 +1775,7 @@ CREATE UNIQUE INDEX templates_ext_ord_uq ON templates USING btree (extension, or -- --- TOC entry 85 (OID 547952) +-- TOC entry 105 (OID 547952) -- Name: templates_title_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -763,7 +1783,7 @@ CREATE UNIQUE INDEX templates_title_uq ON templates USING btree (title_regexp); -- --- TOC entry 86 (OID 547953) +-- TOC entry 106 (OID 547953) -- Name: templates_url_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -771,7 +1791,7 @@ CREATE UNIQUE INDEX templates_url_uq ON templates USING btree (url_regexp); -- --- TOC entry 87 (OID 551151) +-- TOC entry 107 (OID 551151) -- Name: recently_visited_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -779,7 +1799,7 @@ CREATE UNIQUE INDEX recently_visited_uq ON recently_visited USING btree (userid, -- --- TOC entry 88 (OID 552155) +-- TOC entry 108 (OID 552155) -- Name: messages_inet_message_id_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -787,7 +1807,7 @@ CREATE UNIQUE INDEX messages_inet_message_id_uq ON messages USING btree (hostid, -- --- TOC entry 61 (OID 552684) +-- TOC entry 78 (OID 552684) -- Name: pages_url_ix; Type: INDEX; Schema: public; Owner: rich -- @@ -795,7 +1815,7 @@ CREATE INDEX pages_url_ix ON pages USING btree (url); -- --- TOC entry 60 (OID 552685) +-- TOC entry 77 (OID 552685) -- Name: pages_redirect_ix; Type: INDEX; Schema: public; Owner: rich -- @@ -803,7 +1823,55 @@ CREATE INDEX pages_redirect_ix ON pages USING btree (redirect); -- --- TOC entry 59 (OID 536012) +-- 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 80 (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 81 (OID 622207) +-- Name: contents_pageid_idx; Type: INDEX; Schema: public; Owner: rich +-- + +CREATE INDEX contents_pageid_idx ON contents USING btree (pageid); + + +-- +-- TOC entry 85 (OID 622519) +-- Name: hostnames_name_uq; Type: INDEX; Schema: public; Owner: rich +-- + +CREATE UNIQUE INDEX hostnames_name_uq ON hostnames USING btree (name); + + +-- +-- TOC entry 93 (OID 622520) +-- Name: usercookies_cookie_idx; Type: INDEX; Schema: public; Owner: rich +-- + +CREATE INDEX usercookies_cookie_idx ON usercookies USING btree (cookie); + + +-- +-- TOC entry 75 (OID 623111) +-- 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 536012) -- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich -- @@ -812,7 +1880,7 @@ ALTER TABLE ONLY pages -- --- TOC entry 63 (OID 536027) +-- TOC entry 82 (OID 536027) -- Name: contents_pkey; Type: CONSTRAINT; Schema: public; Owner: rich -- @@ -821,7 +1889,7 @@ ALTER TABLE ONLY contents -- --- TOC entry 64 (OID 536377) +-- TOC entry 83 (OID 536377) -- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich -- @@ -830,7 +1898,7 @@ ALTER TABLE ONLY hosts -- --- TOC entry 68 (OID 537158) +-- TOC entry 87 (OID 537158) -- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: rich -- @@ -839,7 +1907,7 @@ ALTER TABLE ONLY images -- --- TOC entry 70 (OID 537173) +-- TOC entry 89 (OID 537173) -- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: rich -- @@ -848,7 +1916,7 @@ ALTER TABLE ONLY files -- --- TOC entry 73 (OID 540825) +-- TOC entry 92 (OID 540825) -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: rich -- @@ -857,7 +1925,7 @@ ALTER TABLE ONLY users -- --- TOC entry 77 (OID 542611) +-- TOC entry 97 (OID 542611) -- Name: contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich -- @@ -866,7 +1934,7 @@ ALTER TABLE ONLY contacts -- --- TOC entry 84 (OID 547945) +-- TOC entry 104 (OID 547945) -- Name: templates_pkey; Type: CONSTRAINT; Schema: public; Owner: rich -- @@ -875,7 +1943,7 @@ ALTER TABLE ONLY templates -- --- TOC entry 89 (OID 551681) +-- TOC entry 109 (OID 551681) -- Name: messages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich -- @@ -884,7 +1952,7 @@ ALTER TABLE ONLY messages -- --- TOC entry 90 (OID 607081) +-- TOC entry 110 (OID 607081) -- Name: powered_by_pkey; Type: CONSTRAINT; Schema: public; Owner: rich -- @@ -893,7 +1961,7 @@ ALTER TABLE ONLY powered_by -- --- TOC entry 91 (OID 607141) +-- TOC entry 111 (OID 607141) -- Name: pending_email_changes_pkey; Type: CONSTRAINT; Schema: public; Owner: rich -- @@ -902,7 +1970,43 @@ ALTER TABLE ONLY pending_email_changes -- --- TOC entry 96 (OID 536029) +-- TOC entry 112 (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 113 (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 114 (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 115 (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 202 (OID 536029) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -911,7 +2015,7 @@ ALTER TABLE ONLY contents -- --- TOC entry 100 (OID 536384) +-- TOC entry 206 (OID 536384) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -920,7 +2024,7 @@ ALTER TABLE ONLY hostnames -- --- TOC entry 97 (OID 536394) +-- TOC entry 203 (OID 536394) -- Name: hosts_hostname_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -929,7 +2033,7 @@ ALTER TABLE ONLY hosts -- --- TOC entry 92 (OID 536404) +-- TOC entry 198 (OID 536404) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -938,7 +2042,7 @@ ALTER TABLE ONLY pages -- --- TOC entry 101 (OID 537160) +-- TOC entry 207 (OID 537160) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -947,7 +2051,7 @@ ALTER TABLE ONLY images -- --- TOC entry 102 (OID 537175) +-- TOC entry 208 (OID 537175) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -956,7 +2060,7 @@ ALTER TABLE ONLY files -- --- TOC entry 93 (OID 539155) +-- TOC entry 199 (OID 539155) -- Name: pages_redirect_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -965,7 +2069,7 @@ ALTER TABLE ONLY pages -- --- TOC entry 103 (OID 540827) +-- TOC entry 209 (OID 540827) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -974,7 +2078,7 @@ ALTER TABLE ONLY users -- --- TOC entry 104 (OID 540837) +-- TOC entry 210 (OID 540837) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -983,7 +2087,7 @@ ALTER TABLE ONLY usercookies -- --- TOC entry 94 (OID 540942) +-- TOC entry 200 (OID 540942) -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -992,7 +2096,7 @@ ALTER TABLE ONLY pages -- --- TOC entry 95 (OID 540947) +-- TOC entry 201 (OID 540947) -- Name: pages_user_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1001,7 +2105,7 @@ ALTER TABLE ONLY pages -- --- TOC entry 105 (OID 540966) +-- TOC entry 211 (OID 540966) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1010,7 +2114,7 @@ ALTER TABLE ONLY sitemenu -- --- TOC entry 106 (OID 540972) +-- TOC entry 212 (OID 540972) -- Name: sitemenu_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1019,7 +2123,7 @@ ALTER TABLE ONLY sitemenu -- --- TOC entry 107 (OID 542613) +-- TOC entry 213 (OID 542613) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1028,7 +2132,7 @@ ALTER TABLE ONLY contacts -- --- TOC entry 108 (OID 542622) +-- TOC entry 214 (OID 542622) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1037,7 +2141,7 @@ ALTER TABLE ONLY contact_emails -- --- TOC entry 98 (OID 543506) +-- TOC entry 204 (OID 543506) -- Name: hosts_theme_css_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1046,7 +2150,7 @@ ALTER TABLE ONLY hosts -- --- TOC entry 109 (OID 543759) +-- TOC entry 215 (OID 543759) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1055,7 +2159,7 @@ ALTER TABLE ONLY page_emails -- --- TOC entry 110 (OID 543764) +-- TOC entry 216 (OID 543764) -- Name: page_emails_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1064,7 +2168,7 @@ ALTER TABLE ONLY page_emails -- --- TOC entry 111 (OID 543791) +-- TOC entry 217 (OID 543791) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1073,7 +2177,7 @@ ALTER TABLE ONLY mailing_lists -- --- TOC entry 112 (OID 544450) +-- TOC entry 218 (OID 544450) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1082,7 +2186,7 @@ ALTER TABLE ONLY links -- --- TOC entry 113 (OID 544455) +-- TOC entry 219 (OID 544455) -- Name: links_from_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1091,7 +2195,7 @@ ALTER TABLE ONLY links -- --- TOC entry 114 (OID 551129) +-- TOC entry 220 (OID 551129) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1100,7 +2204,7 @@ ALTER TABLE ONLY recently_visited -- --- TOC entry 115 (OID 551133) +-- TOC entry 221 (OID 551133) -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1109,7 +2213,7 @@ ALTER TABLE ONLY recently_visited -- --- TOC entry 116 (OID 551137) +-- TOC entry 222 (OID 551137) -- Name: recently_visited_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1118,7 +2222,7 @@ ALTER TABLE ONLY recently_visited -- --- TOC entry 117 (OID 551141) +-- TOC entry 223 (OID 551141) -- Name: recently_visited_userid_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1127,7 +2231,7 @@ ALTER TABLE ONLY recently_visited -- --- TOC entry 119 (OID 551690) +-- TOC entry 225 (OID 551690) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1136,7 +2240,7 @@ ALTER TABLE ONLY msg_references -- --- TOC entry 118 (OID 551694) +-- TOC entry 224 (OID 551694) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1145,7 +2249,7 @@ ALTER TABLE ONLY messages -- --- TOC entry 99 (OID 607083) +-- TOC entry 205 (OID 607083) -- Name: hosts_powered_by_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1154,7 +2258,7 @@ ALTER TABLE ONLY hosts -- --- TOC entry 120 (OID 607143) +-- TOC entry 226 (OID 607143) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -1163,6 +2267,28 @@ ALTER TABLE ONLY pending_email_changes -- +-- TOC entry 227 (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 228 (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 -- @@ -1171,7 +2297,7 @@ COMMENT ON SCHEMA public IS 'Standard public namespace'; -- --- TOC entry 30 (OID 543592) +-- TOC entry 37 (OID 543592) -- Name: TABLE server_settings; Type: COMMENT; Schema: public; Owner: rich -- @@ -1179,6 +2305,22 @@ COMMENT ON TABLE server_settings IS 'This table contains global settings for the -- +-- TOC entry 162 (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 164 (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 --