git.annexia.org
/
cocanwiki.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Split the 'page' template into two halves to enable pipelining. The
[cocanwiki.git]
/
cocanwiki.sql
diff --git
a/cocanwiki.sql
b/cocanwiki.sql
index
ae9d826
..
753fcb1
100644
(file)
--- a/
cocanwiki.sql
+++ b/
cocanwiki.sql
@@
-655,7
+655,7
@@
GRANT SELECT ON TABLE pg_ts_dict TO "www-data";
--
--
--- TOC entry 11
3
(OID 618613)
+-- TOC entry 11
4
(OID 618613)
-- Name: lexize(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: lexize(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-665,7
+665,7
@@
CREATE FUNCTION lexize(oid, text) RETURNS text[]
--
--
--- TOC entry 11
4
(OID 618614)
+-- TOC entry 11
5
(OID 618614)
-- Name: lexize(text, text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: lexize(text, text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-675,7
+675,7
@@
CREATE FUNCTION lexize(text, text) RETURNS text[]
--
--
--- TOC entry 11
5
(OID 618615)
+-- TOC entry 11
6
(OID 618615)
-- Name: lexize(text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: lexize(text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-685,7
+685,7
@@
CREATE FUNCTION lexize(text) RETURNS text[]
--
--
--- TOC entry 11
6
(OID 618616)
+-- TOC entry 11
7
(OID 618616)
-- Name: set_curdict(integer); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: set_curdict(integer); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-695,7
+695,7
@@
CREATE FUNCTION set_curdict(integer) RETURNS void
--
--
--- TOC entry 11
7
(OID 618617)
+-- TOC entry 11
8
(OID 618617)
-- Name: set_curdict(text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: set_curdict(text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-705,7
+705,7
@@
CREATE FUNCTION set_curdict(text) RETURNS void
--
--
--- TOC entry 11
8
(OID 618618)
+-- TOC entry 11
9
(OID 618618)
-- Name: dex_init(text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: dex_init(text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-715,7
+715,7
@@
CREATE FUNCTION dex_init(text) RETURNS internal
--
--
--- TOC entry 1
19
(OID 618619)
+-- TOC entry 1
20
(OID 618619)
-- Name: dex_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: dex_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-725,7
+725,7
@@
CREATE FUNCTION dex_lexize(internal, internal, integer) RETURNS internal
--
--
--- TOC entry 12
0
(OID 618621)
+-- TOC entry 12
1
(OID 618621)
-- Name: snb_en_init(text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: snb_en_init(text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-735,7
+735,7
@@
CREATE FUNCTION snb_en_init(text) RETURNS internal
--
--
--- TOC entry 12
1
(OID 618622)
+-- TOC entry 12
2
(OID 618622)
-- Name: snb_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: snb_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-745,7
+745,7
@@
CREATE FUNCTION snb_lexize(internal, internal, integer) RETURNS internal
--
--
--- TOC entry 12
2
(OID 618624)
+-- TOC entry 12
3
(OID 618624)
-- Name: snb_ru_init(text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: snb_ru_init(text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-755,7
+755,7
@@
CREATE FUNCTION snb_ru_init(text) RETURNS internal
--
--
--- TOC entry 12
3
(OID 618626)
+-- TOC entry 12
4
(OID 618626)
-- Name: spell_init(text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: spell_init(text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-765,7
+765,7
@@
CREATE FUNCTION spell_init(text) RETURNS internal
--
--
--- TOC entry 12
4
(OID 618627)
+-- TOC entry 12
5
(OID 618627)
-- Name: spell_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: spell_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-775,7
+775,7
@@
CREATE FUNCTION spell_lexize(internal, internal, integer) RETURNS internal
--
--
--- TOC entry 12
5
(OID 618629)
+-- TOC entry 12
6
(OID 618629)
-- Name: syn_init(text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: syn_init(text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-785,7
+785,7
@@
CREATE FUNCTION syn_init(text) RETURNS internal
--
--
--- TOC entry 12
6
(OID 618630)
+-- TOC entry 12
7
(OID 618630)
-- Name: syn_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: syn_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-833,7
+833,7
@@
CREATE TYPE tokentype AS (
--
--
--- TOC entry 12
7
(OID 618641)
+-- TOC entry 12
8
(OID 618641)
-- Name: token_type(integer); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: token_type(integer); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-843,7
+843,7
@@
CREATE FUNCTION token_type(integer) RETURNS SETOF tokentype
--
--
--- TOC entry 12
8
(OID 618642)
+-- TOC entry 12
9
(OID 618642)
-- Name: token_type(text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: token_type(text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-853,7
+853,7
@@
CREATE FUNCTION token_type(text) RETURNS SETOF tokentype
--
--
--- TOC entry 1
29
(OID 618643)
+-- TOC entry 1
30
(OID 618643)
-- Name: token_type(); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: token_type(); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-863,7
+863,7
@@
CREATE FUNCTION token_type() RETURNS SETOF tokentype
--
--
--- TOC entry 13
0
(OID 618644)
+-- TOC entry 13
1
(OID 618644)
-- Name: set_curprs(integer); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: set_curprs(integer); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-873,7
+873,7
@@
CREATE FUNCTION set_curprs(integer) RETURNS void
--
--
--- TOC entry 13
1
(OID 618645)
+-- TOC entry 13
2
(OID 618645)
-- Name: set_curprs(text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: set_curprs(text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-894,7
+894,7
@@
CREATE TYPE tokenout AS (
--
--
--- TOC entry 13
2
(OID 618648)
+-- TOC entry 13
3
(OID 618648)
-- Name: parse(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: parse(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-904,7
+904,7
@@
CREATE FUNCTION parse(oid, text) RETURNS SETOF tokenout
--
--
--- TOC entry 13
3
(OID 618649)
+-- TOC entry 13
4
(OID 618649)
-- Name: parse(text, text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: parse(text, text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-914,7
+914,7
@@
CREATE FUNCTION parse(text, text) RETURNS SETOF tokenout
--
--
--- TOC entry 13
4
(OID 618650)
+-- TOC entry 13
5
(OID 618650)
-- Name: parse(text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: parse(text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-924,7
+924,7
@@
CREATE FUNCTION parse(text) RETURNS SETOF tokenout
--
--
--- TOC entry 13
5
(OID 618651)
+-- TOC entry 13
6
(OID 618651)
-- Name: prsd_start(internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: prsd_start(internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-934,7
+934,7
@@
CREATE FUNCTION prsd_start(internal, integer) RETURNS internal
--
--
--- TOC entry 13
6
(OID 618652)
+-- TOC entry 13
7
(OID 618652)
-- Name: prsd_getlexeme(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: prsd_getlexeme(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-944,7
+944,7
@@
CREATE FUNCTION prsd_getlexeme(internal, internal, internal) RETURNS integer
--
--
--- TOC entry 13
7
(OID 618653)
+-- TOC entry 13
8
(OID 618653)
-- Name: prsd_end(internal); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: prsd_end(internal); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-954,7
+954,7
@@
CREATE FUNCTION prsd_end(internal) RETURNS void
--
--
--- TOC entry 13
8
(OID 618654)
+-- TOC entry 13
9
(OID 618654)
-- Name: prsd_lextype(internal); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: prsd_lextype(internal); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-964,7
+964,7
@@
CREATE FUNCTION prsd_lextype(internal) RETURNS internal
--
--
--- TOC entry 1
39
(OID 618655)
+-- TOC entry 1
40
(OID 618655)
-- Name: prsd_headline(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: prsd_headline(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1018,7
+1018,7
@@
GRANT SELECT ON TABLE pg_ts_cfgmap TO "www-data";
--
--
--- TOC entry 14
0
(OID 618671)
+-- TOC entry 14
1
(OID 618671)
-- Name: set_curcfg(integer); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: set_curcfg(integer); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1028,7
+1028,7
@@
CREATE FUNCTION set_curcfg(integer) RETURNS void
--
--
--- TOC entry 14
1
(OID 618672)
+-- TOC entry 14
2
(OID 618672)
-- Name: set_curcfg(text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: set_curcfg(text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1038,7
+1038,7
@@
CREATE FUNCTION set_curcfg(text) RETURNS void
--
--
--- TOC entry 14
2
(OID 618673)
+-- TOC entry 14
3
(OID 618673)
-- Name: show_curcfg(); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: show_curcfg(); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1048,7
+1048,7
@@
CREATE FUNCTION show_curcfg() RETURNS oid
--
--
--- TOC entry 14
3
(OID 618735)
+-- TOC entry 14
4
(OID 618735)
-- Name: tsvector_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: tsvector_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1058,7
+1058,7
@@
CREATE FUNCTION tsvector_in(cstring) RETURNS tsvector
--
--
--- TOC entry 14
4
(OID 618736)
+-- TOC entry 14
5
(OID 618736)
-- Name: tsvector_out(tsvector); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: tsvector_out(tsvector); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1082,7
+1082,7
@@
CREATE TYPE tsvector (
--
--
--- TOC entry 14
5
(OID 618738)
+-- TOC entry 14
6
(OID 618738)
-- Name: length(tsvector); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: length(tsvector); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1092,7
+1092,7
@@
CREATE FUNCTION length(tsvector) RETURNS integer
--
--
--- TOC entry 14
6
(OID 618739)
+-- TOC entry 14
7
(OID 618739)
-- Name: to_tsvector(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: to_tsvector(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1102,7
+1102,7
@@
CREATE FUNCTION to_tsvector(oid, text) RETURNS tsvector
--
--
--- TOC entry 14
7
(OID 618740)
+-- TOC entry 14
8
(OID 618740)
-- Name: to_tsvector(text, text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: to_tsvector(text, text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1112,7
+1112,7
@@
CREATE FUNCTION to_tsvector(text, text) RETURNS tsvector
--
--
--- TOC entry 14
8
(OID 618741)
+-- TOC entry 14
9
(OID 618741)
-- Name: to_tsvector(text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: to_tsvector(text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1122,7
+1122,7
@@
CREATE FUNCTION to_tsvector(text) RETURNS tsvector
--
--
--- TOC entry 1
49
(OID 618742)
+-- TOC entry 1
50
(OID 618742)
-- Name: strip(tsvector); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: strip(tsvector); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1132,7
+1132,7
@@
CREATE FUNCTION strip(tsvector) RETURNS tsvector
--
--
--- TOC entry 15
0
(OID 618743)
+-- TOC entry 15
1
(OID 618743)
-- Name: setweight(tsvector, "char"); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: setweight(tsvector, "char"); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1142,7
+1142,7
@@
CREATE FUNCTION setweight(tsvector, "char") RETURNS tsvector
--
--
--- TOC entry 15
1
(OID 618744)
+-- TOC entry 15
2
(OID 618744)
-- Name: concat(tsvector, tsvector); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: concat(tsvector, tsvector); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1152,7
+1152,7
@@
CREATE FUNCTION concat(tsvector, tsvector) RETURNS tsvector
--
--
--- TOC entry 19
1
(OID 618745)
+-- TOC entry 19
2
(OID 618745)
-- Name: ||; Type: OPERATOR; Schema: public; Owner: postgres
--
-- Name: ||; Type: OPERATOR; Schema: public; Owner: postgres
--
@@
-1164,7
+1164,7
@@
CREATE OPERATOR || (
--
--
--- TOC entry 15
2
(OID 618747)
+-- TOC entry 15
3
(OID 618747)
-- Name: tsquery_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: tsquery_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1174,7
+1174,7
@@
CREATE FUNCTION tsquery_in(cstring) RETURNS tsquery
--
--
--- TOC entry 15
3
(OID 618748)
+-- TOC entry 15
4
(OID 618748)
-- Name: tsquery_out(tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: tsquery_out(tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1198,7
+1198,7
@@
CREATE TYPE tsquery (
--
--
--- TOC entry 15
4
(OID 618750)
+-- TOC entry 15
5
(OID 618750)
-- Name: querytree(tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: querytree(tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1208,7
+1208,7
@@
CREATE FUNCTION querytree(tsquery) RETURNS text
--
--
--- TOC entry 15
5
(OID 618751)
+-- TOC entry 15
6
(OID 618751)
-- Name: to_tsquery(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: to_tsquery(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1218,7
+1218,7
@@
CREATE FUNCTION to_tsquery(oid, text) RETURNS tsquery
--
--
--- TOC entry 15
6
(OID 618752)
+-- TOC entry 15
7
(OID 618752)
-- Name: to_tsquery(text, text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: to_tsquery(text, text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1228,7
+1228,7
@@
CREATE FUNCTION to_tsquery(text, text) RETURNS tsquery
--
--
--- TOC entry 15
7
(OID 618753)
+-- TOC entry 15
8
(OID 618753)
-- Name: to_tsquery(text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: to_tsquery(text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1238,7
+1238,7
@@
CREATE FUNCTION to_tsquery(text) RETURNS tsquery
--
--
--- TOC entry 15
8
(OID 618754)
+-- TOC entry 15
9
(OID 618754)
-- Name: exectsq(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: exectsq(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1248,7
+1248,7
@@
CREATE FUNCTION exectsq(tsvector, tsquery) RETURNS boolean
--
--
--- TOC entry 16
0
(OID 618755)
+-- TOC entry 16
1
(OID 618755)
-- Name: rexectsq(tsquery, tsvector); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: rexectsq(tsquery, tsvector); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1258,7
+1258,7
@@
CREATE FUNCTION rexectsq(tsquery, tsvector) RETURNS boolean
--
--
--- TOC entry 19
3
(OID 618756)
+-- TOC entry 19
4
(OID 618756)
-- Name: @@; Type: OPERATOR; Schema: public; Owner: postgres
--
-- Name: @@; Type: OPERATOR; Schema: public; Owner: postgres
--
@@
-1273,7
+1273,7
@@
CREATE OPERATOR @@ (
--
--
--- TOC entry 19
2
(OID 618757)
+-- TOC entry 19
3
(OID 618757)
-- Name: @@; Type: OPERATOR; Schema: public; Owner: postgres
--
-- Name: @@; Type: OPERATOR; Schema: public; Owner: postgres
--
@@
-1288,7
+1288,7
@@
CREATE OPERATOR @@ (
--
--
--- TOC entry 16
2
(OID 618758)
+-- TOC entry 16
3
(OID 618758)
-- Name: tsearch2(); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: tsearch2(); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1298,7
+1298,7
@@
CREATE FUNCTION tsearch2() RETURNS "trigger"
--
--
--- TOC entry 16
3
(OID 618759)
+-- TOC entry 16
4
(OID 618759)
-- Name: rank(real[], tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: rank(real[], tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1308,7
+1308,7
@@
CREATE FUNCTION rank(real[], tsvector, tsquery) RETURNS real
--
--
--- TOC entry 16
4
(OID 618760)
+-- TOC entry 16
5
(OID 618760)
-- Name: rank(real[], tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: rank(real[], tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1318,7
+1318,7
@@
CREATE FUNCTION rank(real[], tsvector, tsquery, integer) RETURNS real
--
--
--- TOC entry 16
5
(OID 618761)
+-- TOC entry 16
6
(OID 618761)
-- Name: rank(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: rank(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1328,7
+1328,7
@@
CREATE FUNCTION rank(tsvector, tsquery) RETURNS real
--
--
--- TOC entry 16
6
(OID 618762)
+-- TOC entry 16
7
(OID 618762)
-- Name: rank(tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: rank(tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1338,7
+1338,7
@@
CREATE FUNCTION rank(tsvector, tsquery, integer) RETURNS real
--
--
--- TOC entry 16
7
(OID 618763)
+-- TOC entry 16
8
(OID 618763)
-- Name: rank_cd(integer, tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: rank_cd(integer, tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1348,7
+1348,7
@@
CREATE FUNCTION rank_cd(integer, tsvector, tsquery) RETURNS real
--
--
--- TOC entry 16
8
(OID 618764)
+-- TOC entry 16
9
(OID 618764)
-- Name: rank_cd(integer, tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: rank_cd(integer, tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1358,7
+1358,7
@@
CREATE FUNCTION rank_cd(integer, tsvector, tsquery, integer) RETURNS real
--
--
--- TOC entry 1
69
(OID 618765)
+-- TOC entry 1
70
(OID 618765)
-- Name: rank_cd(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: rank_cd(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1368,7
+1368,7
@@
CREATE FUNCTION rank_cd(tsvector, tsquery) RETURNS real
--
--
--- TOC entry 17
0
(OID 618766)
+-- TOC entry 17
1
(OID 618766)
-- Name: rank_cd(tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: rank_cd(tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1378,7
+1378,7
@@
CREATE FUNCTION rank_cd(tsvector, tsquery, integer) RETURNS real
--
--
--- TOC entry 17
1
(OID 618767)
+-- TOC entry 17
2
(OID 618767)
-- Name: headline(oid, text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: headline(oid, text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1388,7
+1388,7
@@
CREATE FUNCTION headline(oid, text, tsquery, text) RETURNS text
--
--
--- TOC entry 17
2
(OID 618768)
+-- TOC entry 17
3
(OID 618768)
-- Name: headline(oid, text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: headline(oid, text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1398,7
+1398,7
@@
CREATE FUNCTION headline(oid, text, tsquery) RETURNS text
--
--
--- TOC entry 17
3
(OID 618769)
+-- TOC entry 17
4
(OID 618769)
-- Name: headline(text, text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: headline(text, text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1408,7
+1408,7
@@
CREATE FUNCTION headline(text, text, tsquery, text) RETURNS text
--
--
--- TOC entry 17
4
(OID 618770)
+-- TOC entry 17
5
(OID 618770)
-- Name: headline(text, text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: headline(text, text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1418,7
+1418,7
@@
CREATE FUNCTION headline(text, text, tsquery) RETURNS text
--
--
--- TOC entry 17
5
(OID 618771)
+-- TOC entry 17
6
(OID 618771)
-- Name: headline(text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: headline(text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1428,7
+1428,7
@@
CREATE FUNCTION headline(text, tsquery, text) RETURNS text
--
--
--- TOC entry 17
6
(OID 618772)
+-- TOC entry 17
7
(OID 618772)
-- Name: headline(text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: headline(text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1438,7
+1438,7
@@
CREATE FUNCTION headline(text, tsquery) RETURNS text
--
--
--- TOC entry 17
7
(OID 618774)
+-- TOC entry 17
8
(OID 618774)
-- Name: gtsvector_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: gtsvector_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1448,7
+1448,7
@@
CREATE FUNCTION gtsvector_in(cstring) RETURNS gtsvector
--
--
--- TOC entry 17
8
(OID 618775)
+-- TOC entry 17
9
(OID 618775)
-- Name: gtsvector_out(gtsvector); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: gtsvector_out(gtsvector); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1472,7
+1472,7
@@
CREATE TYPE gtsvector (
--
--
--- TOC entry 1
79
(OID 618777)
+-- TOC entry 1
80
(OID 618777)
-- Name: gtsvector_consistent(gtsvector, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: gtsvector_consistent(gtsvector, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1482,7
+1482,7
@@
CREATE FUNCTION gtsvector_consistent(gtsvector, internal, integer) RETURNS boole
--
--
--- TOC entry 18
0
(OID 618778)
+-- TOC entry 18
1
(OID 618778)
-- Name: gtsvector_compress(internal); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: gtsvector_compress(internal); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1492,7
+1492,7
@@
CREATE FUNCTION gtsvector_compress(internal) RETURNS internal
--
--
--- TOC entry 18
1
(OID 618779)
+-- TOC entry 18
2
(OID 618779)
-- Name: gtsvector_decompress(internal); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: gtsvector_decompress(internal); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1502,7
+1502,7
@@
CREATE FUNCTION gtsvector_decompress(internal) RETURNS internal
--
--
--- TOC entry 18
2
(OID 618780)
+-- TOC entry 18
3
(OID 618780)
-- Name: gtsvector_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: gtsvector_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1512,7
+1512,7
@@
CREATE FUNCTION gtsvector_penalty(internal, internal, internal) RETURNS internal
--
--
--- TOC entry 18
3
(OID 618781)
+-- TOC entry 18
4
(OID 618781)
-- Name: gtsvector_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: gtsvector_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1522,7
+1522,7
@@
CREATE FUNCTION gtsvector_picksplit(internal, internal) RETURNS internal
--
--
--- TOC entry 18
4
(OID 618782)
+-- TOC entry 18
5
(OID 618782)
-- Name: gtsvector_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: gtsvector_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1532,7
+1532,7
@@
CREATE FUNCTION gtsvector_union(bytea, internal) RETURNS integer[]
--
--
--- TOC entry 18
5
(OID 618783)
+-- TOC entry 18
6
(OID 618783)
-- Name: gtsvector_same(gtsvector, gtsvector, internal); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: gtsvector_same(gtsvector, gtsvector, internal); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1542,7
+1542,7
@@
CREATE FUNCTION gtsvector_same(gtsvector, gtsvector, internal) RETURNS internal
--
--
--- TOC entry 19
4
(OID 618784)
+-- TOC entry 19
5
(OID 618784)
-- Name: gist_tsvector_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
--
-- Name: gist_tsvector_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
--
@@
-1572,7
+1572,7
@@
CREATE TYPE statinfo AS (
--
--
--- TOC entry 18
6
(OID 618787)
+-- TOC entry 18
7
(OID 618787)
-- Name: stat(text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: stat(text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1582,7
+1582,7
@@
CREATE FUNCTION stat(text) RETURNS SETOF statinfo
--
--
--- TOC entry 18
7
(OID 618788)
+-- TOC entry 18
8
(OID 618788)
-- Name: reset_tsearch(); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: reset_tsearch(); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1592,7
+1592,7
@@
CREATE FUNCTION reset_tsearch() RETURNS void
--
--
--- TOC entry 18
8
(OID 618789)
+-- TOC entry 18
9
(OID 618789)
-- Name: get_covers(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: get_covers(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1617,7
+1617,7
@@
CREATE TYPE tsdebug AS (
--
--
--- TOC entry 1
89
(OID 618792)
+-- TOC entry 1
90
(OID 618792)
-- Name: _get_parser_from_curcfg(); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: _get_parser_from_curcfg(); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1627,7
+1627,7
@@
CREATE FUNCTION _get_parser_from_curcfg() RETURNS text
--
--
--- TOC entry 19
0
(OID 618793)
+-- TOC entry 19
1
(OID 618793)
-- Name: ts_debug(text); Type: FUNCTION; Schema: public; Owner: postgres
--
-- Name: ts_debug(text); Type: FUNCTION; Schema: public; Owner: postgres
--
@@
-1655,7
+1655,7
@@
where
--
--
--- TOC entry 8
2
(OID 536388)
+-- TOC entry 8
3
(OID 536388)
-- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1663,7
+1663,7
@@
CREATE UNIQUE INDEX hostnames_hostid_name_uq ON hostnames USING btree (hostid, n
--
--
--- TOC entry 8
3
(OID 536389)
+-- TOC entry 8
4
(OID 536389)
-- Name: hostnams_name_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: hostnams_name_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1679,7
+1679,7
@@
CREATE UNIQUE INDEX pages_url_uq ON pages USING btree (hostid, url);
--
--
--- TOC entry 8
4
(OID 540251)
+-- TOC entry 8
5
(OID 540251)
-- Name: images_name_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: images_name_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1687,7
+1687,7
@@
CREATE UNIQUE INDEX images_name_uq ON images USING btree (hostid, name);
--
--
--- TOC entry 8
6
(OID 540252)
+-- TOC entry 8
7
(OID 540252)
-- Name: files_name_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: files_name_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1695,7
+1695,7
@@
CREATE UNIQUE INDEX files_name_uq ON files USING btree (hostid, name);
--
--
--- TOC entry
89
(OID 540831)
+-- TOC entry
90
(OID 540831)
-- Name: users_name_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: users_name_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1703,7
+1703,7
@@
CREATE UNIQUE INDEX users_name_uq ON users USING btree (hostid, name);
--
--
--- TOC entry 8
8
(OID 540946)
+-- TOC entry 8
9
(OID 540946)
-- Name: users_id_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: users_id_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1711,7
+1711,7
@@
CREATE UNIQUE INDEX users_id_uq ON users USING btree (hostid, id);
--
--
--- TOC entry 9
1
(OID 540970)
+-- TOC entry 9
2
(OID 540970)
-- Name: sitemenu_ordering_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: sitemenu_ordering_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1719,7
+1719,7
@@
CREATE UNIQUE INDEX sitemenu_ordering_uq ON sitemenu USING btree (hostid, orderi
--
--
--- TOC entry 9
2
(OID 540971)
+-- TOC entry 9
3
(OID 540971)
-- Name: sitemenu_url_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: sitemenu_url_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1727,7
+1727,7
@@
CREATE UNIQUE INDEX sitemenu_url_uq ON sitemenu USING btree (hostid, url);
--
--
--- TOC entry 9
5
(OID 542626)
+-- TOC entry 9
6
(OID 542626)
-- Name: contact_emails_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: contact_emails_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1735,7
+1735,7
@@
CREATE UNIQUE INDEX contact_emails_uq ON contact_emails USING btree (contactid,
--
--
--- TOC entry 9
6
(OID 543505)
+-- TOC entry 9
7
(OID 543505)
-- Name: themes_theme_css_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: themes_theme_css_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1743,7
+1743,7
@@
CREATE UNIQUE INDEX themes_theme_css_uq ON themes USING btree (theme_css);
--
--
--- TOC entry 9
7
(OID 543763)
+-- TOC entry 9
8
(OID 543763)
-- Name: page_emails_email_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: page_emails_email_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1751,7
+1751,7
@@
CREATE UNIQUE INDEX page_emails_email_uq ON page_emails USING btree (hostid, url
--
--
--- TOC entry 9
8
(OID 543795)
+-- TOC entry 9
9
(OID 543795)
-- Name: mailing_lists_email_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: mailing_lists_email_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1759,7
+1759,7
@@
CREATE UNIQUE INDEX mailing_lists_email_uq ON mailing_lists USING btree (hostid,
--
--
--- TOC entry 9
3
(OID 543880)
+-- TOC entry 9
4
(OID 543880)
-- Name: contacts_name_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: contacts_name_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1767,7
+1767,7
@@
CREATE UNIQUE INDEX contacts_name_uq ON contacts USING btree (hostid, name);
--
--
--- TOC entry
99
(OID 544454)
+-- TOC entry
100
(OID 544454)
-- Name: links_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: links_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1775,7
+1775,7
@@
CREATE UNIQUE INDEX links_uq ON links USING btree (hostid, from_url, to_url);
--
--
--- TOC entry 10
0
(OID 547951)
+-- TOC entry 10
1
(OID 547951)
-- Name: templates_ext_ord_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: templates_ext_ord_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1783,7
+1783,7
@@
CREATE UNIQUE INDEX templates_ext_ord_uq ON templates USING btree (extension, or
--
--
--- TOC entry 10
2
(OID 547952)
+-- TOC entry 10
3
(OID 547952)
-- Name: templates_title_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: templates_title_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1791,7
+1791,7
@@
CREATE UNIQUE INDEX templates_title_uq ON templates USING btree (title_regexp);
--
--
--- TOC entry 10
3
(OID 547953)
+-- TOC entry 10
4
(OID 547953)
-- Name: templates_url_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: templates_url_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1799,7
+1799,7
@@
CREATE UNIQUE INDEX templates_url_uq ON templates USING btree (url_regexp);
--
--
--- TOC entry 10
4
(OID 551151)
+-- TOC entry 10
5
(OID 551151)
-- Name: recently_visited_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: recently_visited_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1807,7
+1807,7
@@
CREATE UNIQUE INDEX recently_visited_uq ON recently_visited USING btree (userid,
--
--
--- TOC entry 10
5
(OID 552155)
+-- TOC entry 10
6
(OID 552155)
-- Name: messages_inet_message_id_uq; Type: INDEX; Schema: public; Owner: rich
--
-- Name: messages_inet_message_id_uq; Type: INDEX; Schema: public; Owner: rich
--
@@
-1847,6
+1847,14
@@
CREATE INDEX contents_fti_idx ON contents USING gist (content_fti);
--
--
+-- TOC entry 80 (OID 622207)
+-- Name: contents_pageid_idx; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE INDEX contents_pageid_idx ON contents USING btree (pageid);
+
+
+--
-- TOC entry 75 (OID 536012)
-- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
-- TOC entry 75 (OID 536012)
-- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
@@
-1856,7
+1864,7
@@
ALTER TABLE ONLY pages
--
--
--- TOC entry 8
0
(OID 536027)
+-- TOC entry 8
1
(OID 536027)
-- Name: contents_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
-- Name: contents_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
@@
-1865,7
+1873,7
@@
ALTER TABLE ONLY contents
--
--
--- TOC entry 8
1
(OID 536377)
+-- TOC entry 8
2
(OID 536377)
-- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
-- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
@@
-1874,7
+1882,7
@@
ALTER TABLE ONLY hosts
--
--
--- TOC entry 8
5
(OID 537158)
+-- TOC entry 8
6
(OID 537158)
-- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
-- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
@@
-1883,7
+1891,7
@@
ALTER TABLE ONLY images
--
--
--- TOC entry 8
7
(OID 537173)
+-- TOC entry 8
8
(OID 537173)
-- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
-- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
@@
-1892,7
+1900,7
@@
ALTER TABLE ONLY files
--
--
--- TOC entry 9
0
(OID 540825)
+-- TOC entry 9
1
(OID 540825)
-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
@@
-1901,7
+1909,7
@@
ALTER TABLE ONLY users
--
--
--- TOC entry 9
4
(OID 542611)
+-- TOC entry 9
5
(OID 542611)
-- Name: contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
-- Name: contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
@@
-1910,7
+1918,7
@@
ALTER TABLE ONLY contacts
--
--
--- TOC entry 10
1
(OID 547945)
+-- TOC entry 10
2
(OID 547945)
-- Name: templates_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
-- Name: templates_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
@@
-1919,7
+1927,7
@@
ALTER TABLE ONLY templates
--
--
--- TOC entry 10
6
(OID 551681)
+-- TOC entry 10
7
(OID 551681)
-- Name: messages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
-- Name: messages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
@@
-1928,7
+1936,7
@@
ALTER TABLE ONLY messages
--
--
--- TOC entry 10
7
(OID 607081)
+-- TOC entry 10
8
(OID 607081)
-- Name: powered_by_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
-- Name: powered_by_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
@@
-1937,7
+1945,7
@@
ALTER TABLE ONLY powered_by
--
--
--- TOC entry 10
8
(OID 607141)
+-- TOC entry 10
9
(OID 607141)
-- Name: pending_email_changes_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
-- Name: pending_email_changes_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
@@
-1946,7
+1954,7
@@
ALTER TABLE ONLY pending_email_changes
--
--
--- TOC entry 1
09
(OID 618611)
+-- TOC entry 1
10
(OID 618611)
-- Name: pg_ts_dict_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
-- Name: pg_ts_dict_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
@@
-1955,7
+1963,7
@@
ALTER TABLE ONLY pg_ts_dict
--
--
--- TOC entry 11
0
(OID 618637)
+-- TOC entry 11
1
(OID 618637)
-- Name: pg_ts_parser_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
-- Name: pg_ts_parser_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
@@
-1964,7
+1972,7
@@
ALTER TABLE ONLY pg_ts_parser
--
--
--- TOC entry 11
1
(OID 618662)
+-- TOC entry 11
2
(OID 618662)
-- Name: pg_ts_cfg_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
-- Name: pg_ts_cfg_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
@@
-1973,7
+1981,7
@@
ALTER TABLE ONLY pg_ts_cfg
--
--
--- TOC entry 11
2
(OID 618669)
+-- TOC entry 11
3
(OID 618669)
-- Name: pg_ts_cfgmap_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
-- Name: pg_ts_cfgmap_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
@@
-1982,7
+1990,7
@@
ALTER TABLE ONLY pg_ts_cfgmap
--
--
--- TOC entry
199
(OID 536029)
+-- TOC entry
200
(OID 536029)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-1991,7
+1999,7
@@
ALTER TABLE ONLY contents
--
--
--- TOC entry 20
3
(OID 536384)
+-- TOC entry 20
4
(OID 536384)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2000,7
+2008,7
@@
ALTER TABLE ONLY hostnames
--
--
--- TOC entry 20
0
(OID 536394)
+-- TOC entry 20
1
(OID 536394)
-- Name: hosts_hostname_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: hosts_hostname_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2009,7
+2017,7
@@
ALTER TABLE ONLY hosts
--
--
--- TOC entry 19
5
(OID 536404)
+-- TOC entry 19
6
(OID 536404)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2018,7
+2026,7
@@
ALTER TABLE ONLY pages
--
--
--- TOC entry 20
4
(OID 537160)
+-- TOC entry 20
5
(OID 537160)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2027,7
+2035,7
@@
ALTER TABLE ONLY images
--
--
--- TOC entry 20
5
(OID 537175)
+-- TOC entry 20
6
(OID 537175)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2036,7
+2044,7
@@
ALTER TABLE ONLY files
--
--
--- TOC entry 19
6
(OID 539155)
+-- TOC entry 19
7
(OID 539155)
-- Name: pages_redirect_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: pages_redirect_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2045,7
+2053,7
@@
ALTER TABLE ONLY pages
--
--
--- TOC entry 20
6
(OID 540827)
+-- TOC entry 20
7
(OID 540827)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2054,7
+2062,7
@@
ALTER TABLE ONLY users
--
--
--- TOC entry 20
7
(OID 540837)
+-- TOC entry 20
8
(OID 540837)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2063,7
+2071,7
@@
ALTER TABLE ONLY usercookies
--
--
--- TOC entry 19
7
(OID 540942)
+-- TOC entry 19
8
(OID 540942)
-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2072,7
+2080,7
@@
ALTER TABLE ONLY pages
--
--
--- TOC entry 19
8
(OID 540947)
+-- TOC entry 19
9
(OID 540947)
-- Name: pages_user_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: pages_user_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2081,7
+2089,7
@@
ALTER TABLE ONLY pages
--
--
--- TOC entry 20
8
(OID 540966)
+-- TOC entry 20
9
(OID 540966)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2090,7
+2098,7
@@
ALTER TABLE ONLY sitemenu
--
--
--- TOC entry 2
09
(OID 540972)
+-- TOC entry 2
10
(OID 540972)
-- Name: sitemenu_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: sitemenu_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2099,7
+2107,7
@@
ALTER TABLE ONLY sitemenu
--
--
--- TOC entry 21
0
(OID 542613)
+-- TOC entry 21
1
(OID 542613)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2108,7
+2116,7
@@
ALTER TABLE ONLY contacts
--
--
--- TOC entry 21
1
(OID 542622)
+-- TOC entry 21
2
(OID 542622)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2117,7
+2125,7
@@
ALTER TABLE ONLY contact_emails
--
--
--- TOC entry 20
1
(OID 543506)
+-- TOC entry 20
2
(OID 543506)
-- Name: hosts_theme_css_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: hosts_theme_css_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2126,7
+2134,7
@@
ALTER TABLE ONLY hosts
--
--
--- TOC entry 21
2
(OID 543759)
+-- TOC entry 21
3
(OID 543759)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2135,7
+2143,7
@@
ALTER TABLE ONLY page_emails
--
--
--- TOC entry 21
3
(OID 543764)
+-- TOC entry 21
4
(OID 543764)
-- Name: page_emails_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: page_emails_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2144,7
+2152,7
@@
ALTER TABLE ONLY page_emails
--
--
--- TOC entry 21
4
(OID 543791)
+-- TOC entry 21
5
(OID 543791)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2153,7
+2161,7
@@
ALTER TABLE ONLY mailing_lists
--
--
--- TOC entry 21
5
(OID 544450)
+-- TOC entry 21
6
(OID 544450)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2162,7
+2170,7
@@
ALTER TABLE ONLY links
--
--
--- TOC entry 21
6
(OID 544455)
+-- TOC entry 21
7
(OID 544455)
-- Name: links_from_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: links_from_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2171,7
+2179,7
@@
ALTER TABLE ONLY links
--
--
--- TOC entry 21
7
(OID 551129)
+-- TOC entry 21
8
(OID 551129)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2180,7
+2188,7
@@
ALTER TABLE ONLY recently_visited
--
--
--- TOC entry 21
8
(OID 551133)
+-- TOC entry 21
9
(OID 551133)
-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2189,7
+2197,7
@@
ALTER TABLE ONLY recently_visited
--
--
--- TOC entry 2
19
(OID 551137)
+-- TOC entry 2
20
(OID 551137)
-- Name: recently_visited_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: recently_visited_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2198,7
+2206,7
@@
ALTER TABLE ONLY recently_visited
--
--
--- TOC entry 22
0
(OID 551141)
+-- TOC entry 22
1
(OID 551141)
-- Name: recently_visited_userid_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: recently_visited_userid_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2207,7
+2215,7
@@
ALTER TABLE ONLY recently_visited
--
--
--- TOC entry 22
2
(OID 551690)
+-- TOC entry 22
3
(OID 551690)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2216,7
+2224,7
@@
ALTER TABLE ONLY msg_references
--
--
--- TOC entry 22
1
(OID 551694)
+-- TOC entry 22
2
(OID 551694)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2225,7
+2233,7
@@
ALTER TABLE ONLY messages
--
--
--- TOC entry 20
2
(OID 607083)
+-- TOC entry 20
3
(OID 607083)
-- Name: hosts_powered_by_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: hosts_powered_by_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2234,7
+2242,7
@@
ALTER TABLE ONLY hosts
--
--
--- TOC entry 22
3
(OID 607143)
+-- TOC entry 22
4
(OID 607143)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
@@
-2243,7
+2251,7
@@
ALTER TABLE ONLY pending_email_changes
--
--
--- TOC entry 22
4
(OID 618794)
+-- TOC entry 22
5
(OID 618794)
-- Name: pages_fti_tr; Type: TRIGGER; Schema: public; Owner: rich
--
-- Name: pages_fti_tr; Type: TRIGGER; Schema: public; Owner: rich
--
@@
-2254,7
+2262,7
@@
CREATE TRIGGER pages_fti_tr
--
--
--- TOC entry 22
5
(OID 618796)
+-- TOC entry 22
6
(OID 618796)
-- Name: contents_fti_tr; Type: TRIGGER; Schema: public; Owner: rich
--
-- Name: contents_fti_tr; Type: TRIGGER; Schema: public; Owner: rich
--
@@
-2281,7
+2289,7
@@
COMMENT ON TABLE server_settings IS 'This table contains global settings for the
--
--
--- TOC entry 1
59
(OID 618754)
+-- TOC entry 1
60
(OID 618754)
-- Name: FUNCTION exectsq(tsvector, tsquery); Type: COMMENT; Schema: public; Owner: postgres
--
-- Name: FUNCTION exectsq(tsvector, tsquery); Type: COMMENT; Schema: public; Owner: postgres
--
@@
-2289,7
+2297,7
@@
COMMENT ON FUNCTION exectsq(tsvector, tsquery) IS 'boolean operation with text i
--
--
--- TOC entry 16
1
(OID 618755)
+-- TOC entry 16
2
(OID 618755)
-- Name: FUNCTION rexectsq(tsquery, tsvector); Type: COMMENT; Schema: public; Owner: postgres
--
-- Name: FUNCTION rexectsq(tsquery, tsvector); Type: COMMENT; Schema: public; Owner: postgres
--