2 -- PostgreSQL database dump
5 SET client_encoding = 'UNICODE';
6 SET check_function_bodies = false;
8 SET search_path = public, pg_catalog;
11 -- TOC entry 198 (OID 14911565)
12 -- Name: plpgsql_call_handler(); Type: FUNC PROCEDURAL LANGUAGE; Schema: public; Owner: postgres
15 CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
16 AS '$libdir/plpgsql', 'plpgsql_call_handler'
21 -- TOC entry 119 (OID 14911566)
22 -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: public; Owner:
25 CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;
29 -- TOC entry 4 (OID 2200)
30 -- Name: public; Type: ACL; Schema: -; Owner: postgres
33 REVOKE ALL ON SCHEMA public FROM PUBLIC;
34 REVOKE ALL ON SCHEMA public FROM postgres;
35 GRANT ALL ON SCHEMA public TO PUBLIC;
39 -- TOC entry 12 (OID 11524567)
40 -- Name: pg_ts_dict; Type: TABLE; Schema: public; Owner: postgres
43 CREATE TABLE pg_ts_dict (
44 dict_name text NOT NULL,
47 dict_lexize oid NOT NULL,
53 -- TOC entry 13 (OID 11524567)
54 -- Name: pg_ts_dict; Type: ACL; Schema: public; Owner: postgres
57 REVOKE ALL ON TABLE pg_ts_dict FROM PUBLIC;
58 GRANT SELECT ON TABLE pg_ts_dict TO rich;
59 GRANT SELECT ON TABLE pg_ts_dict TO "www-data";
63 -- TOC entry 120 (OID 11524574)
64 -- Name: lexize(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
67 CREATE FUNCTION lexize(oid, text) RETURNS text[]
68 AS '$libdir/tsearch2', 'lexize'
73 -- TOC entry 121 (OID 11524575)
74 -- Name: lexize(text, text); Type: FUNCTION; Schema: public; Owner: postgres
77 CREATE FUNCTION lexize(text, text) RETURNS text[]
78 AS '$libdir/tsearch2', 'lexize_byname'
83 -- TOC entry 122 (OID 11524576)
84 -- Name: lexize(text); Type: FUNCTION; Schema: public; Owner: postgres
87 CREATE FUNCTION lexize(text) RETURNS text[]
88 AS '$libdir/tsearch2', 'lexize_bycurrent'
93 -- TOC entry 123 (OID 11524577)
94 -- Name: set_curdict(integer); Type: FUNCTION; Schema: public; Owner: postgres
97 CREATE FUNCTION set_curdict(integer) RETURNS void
98 AS '$libdir/tsearch2', 'set_curdict'
103 -- TOC entry 124 (OID 11524578)
104 -- Name: set_curdict(text); Type: FUNCTION; Schema: public; Owner: postgres
107 CREATE FUNCTION set_curdict(text) RETURNS void
108 AS '$libdir/tsearch2', 'set_curdict_byname'
113 -- TOC entry 125 (OID 11524579)
114 -- Name: dex_init(internal); Type: FUNCTION; Schema: public; Owner: postgres
117 CREATE FUNCTION dex_init(internal) RETURNS internal
118 AS '$libdir/tsearch2', 'dex_init'
123 -- TOC entry 126 (OID 11524580)
124 -- Name: dex_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
127 CREATE FUNCTION dex_lexize(internal, internal, integer) RETURNS internal
128 AS '$libdir/tsearch2', 'dex_lexize'
133 -- TOC entry 127 (OID 11524582)
134 -- Name: snb_en_init(internal); Type: FUNCTION; Schema: public; Owner: postgres
137 CREATE FUNCTION snb_en_init(internal) RETURNS internal
138 AS '$libdir/tsearch2', 'snb_en_init'
143 -- TOC entry 128 (OID 11524583)
144 -- Name: snb_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
147 CREATE FUNCTION snb_lexize(internal, internal, integer) RETURNS internal
148 AS '$libdir/tsearch2', 'snb_lexize'
153 -- TOC entry 129 (OID 11524585)
154 -- Name: snb_ru_init(internal); Type: FUNCTION; Schema: public; Owner: postgres
157 CREATE FUNCTION snb_ru_init(internal) RETURNS internal
158 AS '$libdir/tsearch2', 'snb_ru_init'
163 -- TOC entry 130 (OID 11524587)
164 -- Name: spell_init(internal); Type: FUNCTION; Schema: public; Owner: postgres
167 CREATE FUNCTION spell_init(internal) RETURNS internal
168 AS '$libdir/tsearch2', 'spell_init'
173 -- TOC entry 131 (OID 11524588)
174 -- Name: spell_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
177 CREATE FUNCTION spell_lexize(internal, internal, integer) RETURNS internal
178 AS '$libdir/tsearch2', 'spell_lexize'
183 -- TOC entry 132 (OID 11524590)
184 -- Name: syn_init(internal); Type: FUNCTION; Schema: public; Owner: postgres
187 CREATE FUNCTION syn_init(internal) RETURNS internal
188 AS '$libdir/tsearch2', 'syn_init'
193 -- TOC entry 133 (OID 11524591)
194 -- Name: syn_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
197 CREATE FUNCTION syn_lexize(internal, internal, integer) RETURNS internal
198 AS '$libdir/tsearch2', 'syn_lexize'
203 -- TOC entry 14 (OID 11524593)
204 -- Name: pg_ts_parser; Type: TABLE; Schema: public; Owner: postgres
207 CREATE TABLE pg_ts_parser (
208 prs_name text NOT NULL,
209 prs_start oid NOT NULL,
210 prs_nexttoken oid NOT NULL,
211 prs_end oid NOT NULL,
212 prs_headline oid NOT NULL,
213 prs_lextype oid NOT NULL,
219 -- TOC entry 15 (OID 11524593)
220 -- Name: pg_ts_parser; Type: ACL; Schema: public; Owner: postgres
223 REVOKE ALL ON TABLE pg_ts_parser FROM PUBLIC;
224 GRANT SELECT ON TABLE pg_ts_parser TO rich;
225 GRANT SELECT ON TABLE pg_ts_parser TO "www-data";
229 -- TOC entry 5 (OID 11524601)
230 -- Name: tokentype; Type: TYPE; Schema: public; Owner: postgres
233 CREATE TYPE tokentype AS (
241 -- TOC entry 134 (OID 11524602)
242 -- Name: token_type(integer); Type: FUNCTION; Schema: public; Owner: postgres
245 CREATE FUNCTION token_type(integer) RETURNS SETOF tokentype
246 AS '$libdir/tsearch2', 'token_type'
251 -- TOC entry 135 (OID 11524603)
252 -- Name: token_type(text); Type: FUNCTION; Schema: public; Owner: postgres
255 CREATE FUNCTION token_type(text) RETURNS SETOF tokentype
256 AS '$libdir/tsearch2', 'token_type_byname'
261 -- TOC entry 136 (OID 11524604)
262 -- Name: token_type(); Type: FUNCTION; Schema: public; Owner: postgres
265 CREATE FUNCTION token_type() RETURNS SETOF tokentype
266 AS '$libdir/tsearch2', 'token_type_current'
271 -- TOC entry 137 (OID 11524605)
272 -- Name: set_curprs(integer); Type: FUNCTION; Schema: public; Owner: postgres
275 CREATE FUNCTION set_curprs(integer) RETURNS void
276 AS '$libdir/tsearch2', 'set_curprs'
281 -- TOC entry 138 (OID 11524606)
282 -- Name: set_curprs(text); Type: FUNCTION; Schema: public; Owner: postgres
285 CREATE FUNCTION set_curprs(text) RETURNS void
286 AS '$libdir/tsearch2', 'set_curprs_byname'
291 -- TOC entry 6 (OID 11524608)
292 -- Name: tokenout; Type: TYPE; Schema: public; Owner: postgres
295 CREATE TYPE tokenout AS (
302 -- TOC entry 139 (OID 11524609)
303 -- Name: parse(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
306 CREATE FUNCTION parse(oid, text) RETURNS SETOF tokenout
307 AS '$libdir/tsearch2', 'parse'
312 -- TOC entry 140 (OID 11524610)
313 -- Name: parse(text, text); Type: FUNCTION; Schema: public; Owner: postgres
316 CREATE FUNCTION parse(text, text) RETURNS SETOF tokenout
317 AS '$libdir/tsearch2', 'parse_byname'
322 -- TOC entry 141 (OID 11524611)
323 -- Name: parse(text); Type: FUNCTION; Schema: public; Owner: postgres
326 CREATE FUNCTION parse(text) RETURNS SETOF tokenout
327 AS '$libdir/tsearch2', 'parse_current'
332 -- TOC entry 142 (OID 11524612)
333 -- Name: prsd_start(internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
336 CREATE FUNCTION prsd_start(internal, integer) RETURNS internal
337 AS '$libdir/tsearch2', 'prsd_start'
342 -- TOC entry 143 (OID 11524613)
343 -- Name: prsd_getlexeme(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
346 CREATE FUNCTION prsd_getlexeme(internal, internal, internal) RETURNS integer
347 AS '$libdir/tsearch2', 'prsd_getlexeme'
352 -- TOC entry 144 (OID 11524614)
353 -- Name: prsd_end(internal); Type: FUNCTION; Schema: public; Owner: postgres
356 CREATE FUNCTION prsd_end(internal) RETURNS void
357 AS '$libdir/tsearch2', 'prsd_end'
362 -- TOC entry 145 (OID 11524615)
363 -- Name: prsd_lextype(internal); Type: FUNCTION; Schema: public; Owner: postgres
366 CREATE FUNCTION prsd_lextype(internal) RETURNS internal
367 AS '$libdir/tsearch2', 'prsd_lextype'
372 -- TOC entry 146 (OID 11524616)
373 -- Name: prsd_headline(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
376 CREATE FUNCTION prsd_headline(internal, internal, internal) RETURNS internal
377 AS '$libdir/tsearch2', 'prsd_headline'
382 -- TOC entry 16 (OID 11524618)
383 -- Name: pg_ts_cfg; Type: TABLE; Schema: public; Owner: postgres
386 CREATE TABLE pg_ts_cfg (
387 ts_name text NOT NULL,
388 prs_name text NOT NULL,
394 -- TOC entry 17 (OID 11524618)
395 -- Name: pg_ts_cfg; Type: ACL; Schema: public; Owner: postgres
398 REVOKE ALL ON TABLE pg_ts_cfg FROM PUBLIC;
399 GRANT SELECT ON TABLE pg_ts_cfg TO rich;
400 GRANT SELECT ON TABLE pg_ts_cfg TO "www-data";
404 -- TOC entry 18 (OID 11524625)
405 -- Name: pg_ts_cfgmap; Type: TABLE; Schema: public; Owner: postgres
408 CREATE TABLE pg_ts_cfgmap (
409 ts_name text NOT NULL,
410 tok_alias text NOT NULL,
416 -- TOC entry 19 (OID 11524625)
417 -- Name: pg_ts_cfgmap; Type: ACL; Schema: public; Owner: postgres
420 REVOKE ALL ON TABLE pg_ts_cfgmap FROM PUBLIC;
421 GRANT SELECT ON TABLE pg_ts_cfgmap TO rich;
422 GRANT SELECT ON TABLE pg_ts_cfgmap TO "www-data";
426 -- TOC entry 147 (OID 11524632)
427 -- Name: set_curcfg(integer); Type: FUNCTION; Schema: public; Owner: postgres
430 CREATE FUNCTION set_curcfg(integer) RETURNS void
431 AS '$libdir/tsearch2', 'set_curcfg'
436 -- TOC entry 148 (OID 11524633)
437 -- Name: set_curcfg(text); Type: FUNCTION; Schema: public; Owner: postgres
440 CREATE FUNCTION set_curcfg(text) RETURNS void
441 AS '$libdir/tsearch2', 'set_curcfg_byname'
446 -- TOC entry 149 (OID 11524634)
447 -- Name: show_curcfg(); Type: FUNCTION; Schema: public; Owner: postgres
450 CREATE FUNCTION show_curcfg() RETURNS oid
451 AS '$libdir/tsearch2', 'show_curcfg'
456 -- TOC entry 150 (OID 11524696)
457 -- Name: tsvector_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
460 CREATE FUNCTION tsvector_in(cstring) RETURNS tsvector
461 AS '$libdir/tsearch2', 'tsvector_in'
466 -- TOC entry 151 (OID 11524697)
467 -- Name: tsvector_out(tsvector); Type: FUNCTION; Schema: public; Owner: postgres
470 CREATE FUNCTION tsvector_out(tsvector) RETURNS cstring
471 AS '$libdir/tsearch2', 'tsvector_out'
476 -- TOC entry 7 (OID 11524695)
477 -- Name: tsvector; Type: TYPE; Schema: public; Owner: postgres
480 CREATE TYPE tsvector (
481 INTERNALLENGTH = variable,
483 OUTPUT = tsvector_out,
490 -- TOC entry 152 (OID 11524699)
491 -- Name: length(tsvector); Type: FUNCTION; Schema: public; Owner: postgres
494 CREATE FUNCTION length(tsvector) RETURNS integer
495 AS '$libdir/tsearch2', 'tsvector_length'
496 LANGUAGE c IMMUTABLE STRICT;
500 -- TOC entry 153 (OID 11524700)
501 -- Name: to_tsvector(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
504 CREATE FUNCTION to_tsvector(oid, text) RETURNS tsvector
505 AS '$libdir/tsearch2', 'to_tsvector'
506 LANGUAGE c IMMUTABLE STRICT;
510 -- TOC entry 154 (OID 11524701)
511 -- Name: to_tsvector(text, text); Type: FUNCTION; Schema: public; Owner: postgres
514 CREATE FUNCTION to_tsvector(text, text) RETURNS tsvector
515 AS '$libdir/tsearch2', 'to_tsvector_name'
516 LANGUAGE c IMMUTABLE STRICT;
520 -- TOC entry 155 (OID 11524702)
521 -- Name: to_tsvector(text); Type: FUNCTION; Schema: public; Owner: postgres
524 CREATE FUNCTION to_tsvector(text) RETURNS tsvector
525 AS '$libdir/tsearch2', 'to_tsvector_current'
526 LANGUAGE c IMMUTABLE STRICT;
530 -- TOC entry 156 (OID 11524703)
531 -- Name: strip(tsvector); Type: FUNCTION; Schema: public; Owner: postgres
534 CREATE FUNCTION strip(tsvector) RETURNS tsvector
535 AS '$libdir/tsearch2', 'strip'
536 LANGUAGE c IMMUTABLE STRICT;
540 -- TOC entry 157 (OID 11524704)
541 -- Name: setweight(tsvector, "char"); Type: FUNCTION; Schema: public; Owner: postgres
544 CREATE FUNCTION setweight(tsvector, "char") RETURNS tsvector
545 AS '$libdir/tsearch2', 'setweight'
546 LANGUAGE c IMMUTABLE STRICT;
550 -- TOC entry 158 (OID 11524705)
551 -- Name: concat(tsvector, tsvector); Type: FUNCTION; Schema: public; Owner: postgres
554 CREATE FUNCTION concat(tsvector, tsvector) RETURNS tsvector
555 AS '$libdir/tsearch2', 'concat'
556 LANGUAGE c IMMUTABLE STRICT;
560 -- TOC entry 200 (OID 11524706)
561 -- Name: ||; Type: OPERATOR; Schema: public; Owner: postgres
572 -- TOC entry 159 (OID 11524708)
573 -- Name: tsquery_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
576 CREATE FUNCTION tsquery_in(cstring) RETURNS tsquery
577 AS '$libdir/tsearch2', 'tsquery_in'
582 -- TOC entry 160 (OID 11524709)
583 -- Name: tsquery_out(tsquery); Type: FUNCTION; Schema: public; Owner: postgres
586 CREATE FUNCTION tsquery_out(tsquery) RETURNS cstring
587 AS '$libdir/tsearch2', 'tsquery_out'
592 -- TOC entry 8 (OID 11524707)
593 -- Name: tsquery; Type: TYPE; Schema: public; Owner: postgres
596 CREATE TYPE tsquery (
597 INTERNALLENGTH = variable,
599 OUTPUT = tsquery_out,
606 -- TOC entry 161 (OID 11524711)
607 -- Name: querytree(tsquery); Type: FUNCTION; Schema: public; Owner: postgres
610 CREATE FUNCTION querytree(tsquery) RETURNS text
611 AS '$libdir/tsearch2', 'tsquerytree'
616 -- TOC entry 162 (OID 11524712)
617 -- Name: to_tsquery(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
620 CREATE FUNCTION to_tsquery(oid, text) RETURNS tsquery
621 AS '$libdir/tsearch2', 'to_tsquery'
622 LANGUAGE c IMMUTABLE STRICT;
626 -- TOC entry 163 (OID 11524713)
627 -- Name: to_tsquery(text, text); Type: FUNCTION; Schema: public; Owner: postgres
630 CREATE FUNCTION to_tsquery(text, text) RETURNS tsquery
631 AS '$libdir/tsearch2', 'to_tsquery_name'
632 LANGUAGE c IMMUTABLE STRICT;
636 -- TOC entry 164 (OID 11524714)
637 -- Name: to_tsquery(text); Type: FUNCTION; Schema: public; Owner: postgres
640 CREATE FUNCTION to_tsquery(text) RETURNS tsquery
641 AS '$libdir/tsearch2', 'to_tsquery_current'
642 LANGUAGE c IMMUTABLE STRICT;
646 -- TOC entry 165 (OID 11524715)
647 -- Name: exectsq(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
650 CREATE FUNCTION exectsq(tsvector, tsquery) RETURNS boolean
651 AS '$libdir/tsearch2', 'exectsq'
652 LANGUAGE c IMMUTABLE STRICT;
656 -- TOC entry 167 (OID 11524716)
657 -- Name: rexectsq(tsquery, tsvector); Type: FUNCTION; Schema: public; Owner: postgres
660 CREATE FUNCTION rexectsq(tsquery, tsvector) RETURNS boolean
661 AS '$libdir/tsearch2', 'rexectsq'
662 LANGUAGE c IMMUTABLE STRICT;
666 -- TOC entry 202 (OID 11524717)
667 -- Name: @@; Type: OPERATOR; Schema: public; Owner: postgres
671 PROCEDURE = rexectsq,
681 -- TOC entry 201 (OID 11524718)
682 -- Name: @@; Type: OPERATOR; Schema: public; Owner: postgres
696 -- TOC entry 169 (OID 11524719)
697 -- Name: tsearch2(); Type: FUNCTION; Schema: public; Owner: postgres
700 CREATE FUNCTION tsearch2() RETURNS "trigger"
701 AS '$libdir/tsearch2', 'tsearch2'
706 -- TOC entry 170 (OID 11524720)
707 -- Name: rank(real[], tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
710 CREATE FUNCTION rank(real[], tsvector, tsquery) RETURNS real
711 AS '$libdir/tsearch2', 'rank'
712 LANGUAGE c IMMUTABLE STRICT;
716 -- TOC entry 171 (OID 11524721)
717 -- Name: rank(real[], tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
720 CREATE FUNCTION rank(real[], tsvector, tsquery, integer) RETURNS real
721 AS '$libdir/tsearch2', 'rank'
722 LANGUAGE c IMMUTABLE STRICT;
726 -- TOC entry 172 (OID 11524722)
727 -- Name: rank(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
730 CREATE FUNCTION rank(tsvector, tsquery) RETURNS real
731 AS '$libdir/tsearch2', 'rank_def'
732 LANGUAGE c IMMUTABLE STRICT;
736 -- TOC entry 173 (OID 11524723)
737 -- Name: rank(tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
740 CREATE FUNCTION rank(tsvector, tsquery, integer) RETURNS real
741 AS '$libdir/tsearch2', 'rank_def'
742 LANGUAGE c IMMUTABLE STRICT;
746 -- TOC entry 174 (OID 11524724)
747 -- Name: rank_cd(integer, tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
750 CREATE FUNCTION rank_cd(integer, tsvector, tsquery) RETURNS real
751 AS '$libdir/tsearch2', 'rank_cd'
752 LANGUAGE c IMMUTABLE STRICT;
756 -- TOC entry 175 (OID 11524725)
757 -- Name: rank_cd(integer, tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
760 CREATE FUNCTION rank_cd(integer, tsvector, tsquery, integer) RETURNS real
761 AS '$libdir/tsearch2', 'rank_cd'
762 LANGUAGE c IMMUTABLE STRICT;
766 -- TOC entry 176 (OID 11524726)
767 -- Name: rank_cd(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
770 CREATE FUNCTION rank_cd(tsvector, tsquery) RETURNS real
771 AS '$libdir/tsearch2', 'rank_cd_def'
772 LANGUAGE c IMMUTABLE STRICT;
776 -- TOC entry 177 (OID 11524727)
777 -- Name: rank_cd(tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: postgres
780 CREATE FUNCTION rank_cd(tsvector, tsquery, integer) RETURNS real
781 AS '$libdir/tsearch2', 'rank_cd_def'
782 LANGUAGE c IMMUTABLE STRICT;
786 -- TOC entry 178 (OID 11524728)
787 -- Name: headline(oid, text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
790 CREATE FUNCTION headline(oid, text, tsquery, text) RETURNS text
791 AS '$libdir/tsearch2', 'headline'
792 LANGUAGE c IMMUTABLE STRICT;
796 -- TOC entry 179 (OID 11524729)
797 -- Name: headline(oid, text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
800 CREATE FUNCTION headline(oid, text, tsquery) RETURNS text
801 AS '$libdir/tsearch2', 'headline'
802 LANGUAGE c IMMUTABLE STRICT;
806 -- TOC entry 180 (OID 11524730)
807 -- Name: headline(text, text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
810 CREATE FUNCTION headline(text, text, tsquery, text) RETURNS text
811 AS '$libdir/tsearch2', 'headline_byname'
812 LANGUAGE c IMMUTABLE STRICT;
816 -- TOC entry 181 (OID 11524731)
817 -- Name: headline(text, text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
820 CREATE FUNCTION headline(text, text, tsquery) RETURNS text
821 AS '$libdir/tsearch2', 'headline_byname'
822 LANGUAGE c IMMUTABLE STRICT;
826 -- TOC entry 182 (OID 11524732)
827 -- Name: headline(text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
830 CREATE FUNCTION headline(text, tsquery, text) RETURNS text
831 AS '$libdir/tsearch2', 'headline_current'
832 LANGUAGE c IMMUTABLE STRICT;
836 -- TOC entry 183 (OID 11524733)
837 -- Name: headline(text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
840 CREATE FUNCTION headline(text, tsquery) RETURNS text
841 AS '$libdir/tsearch2', 'headline_current'
842 LANGUAGE c IMMUTABLE STRICT;
846 -- TOC entry 184 (OID 11524735)
847 -- Name: gtsvector_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
850 CREATE FUNCTION gtsvector_in(cstring) RETURNS gtsvector
851 AS '$libdir/tsearch2', 'gtsvector_in'
856 -- TOC entry 185 (OID 11524736)
857 -- Name: gtsvector_out(gtsvector); Type: FUNCTION; Schema: public; Owner: postgres
860 CREATE FUNCTION gtsvector_out(gtsvector) RETURNS cstring
861 AS '$libdir/tsearch2', 'gtsvector_out'
866 -- TOC entry 9 (OID 11524734)
867 -- Name: gtsvector; Type: TYPE; Schema: public; Owner: postgres
870 CREATE TYPE gtsvector (
871 INTERNALLENGTH = variable,
872 INPUT = gtsvector_in,
873 OUTPUT = gtsvector_out,
880 -- TOC entry 186 (OID 11524738)
881 -- Name: gtsvector_consistent(gtsvector, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
884 CREATE FUNCTION gtsvector_consistent(gtsvector, internal, integer) RETURNS boolean
885 AS '$libdir/tsearch2', 'gtsvector_consistent'
890 -- TOC entry 187 (OID 11524739)
891 -- Name: gtsvector_compress(internal); Type: FUNCTION; Schema: public; Owner: postgres
894 CREATE FUNCTION gtsvector_compress(internal) RETURNS internal
895 AS '$libdir/tsearch2', 'gtsvector_compress'
900 -- TOC entry 188 (OID 11524740)
901 -- Name: gtsvector_decompress(internal); Type: FUNCTION; Schema: public; Owner: postgres
904 CREATE FUNCTION gtsvector_decompress(internal) RETURNS internal
905 AS '$libdir/tsearch2', 'gtsvector_decompress'
910 -- TOC entry 189 (OID 11524741)
911 -- Name: gtsvector_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
914 CREATE FUNCTION gtsvector_penalty(internal, internal, internal) RETURNS internal
915 AS '$libdir/tsearch2', 'gtsvector_penalty'
920 -- TOC entry 190 (OID 11524742)
921 -- Name: gtsvector_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
924 CREATE FUNCTION gtsvector_picksplit(internal, internal) RETURNS internal
925 AS '$libdir/tsearch2', 'gtsvector_picksplit'
930 -- TOC entry 191 (OID 11524743)
931 -- Name: gtsvector_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: postgres
934 CREATE FUNCTION gtsvector_union(bytea, internal) RETURNS integer[]
935 AS '$libdir/tsearch2', 'gtsvector_union'
940 -- TOC entry 192 (OID 11524744)
941 -- Name: gtsvector_same(gtsvector, gtsvector, internal); Type: FUNCTION; Schema: public; Owner: postgres
944 CREATE FUNCTION gtsvector_same(gtsvector, gtsvector, internal) RETURNS internal
945 AS '$libdir/tsearch2', 'gtsvector_same'
950 -- TOC entry 203 (OID 11524745)
951 -- Name: gist_tsvector_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
954 CREATE OPERATOR CLASS gist_tsvector_ops
955 DEFAULT FOR TYPE tsvector USING gist AS
957 OPERATOR 1 @@(tsvector,tsquery) RECHECK ,
958 FUNCTION 1 gtsvector_consistent(gtsvector,internal,integer) ,
959 FUNCTION 2 gtsvector_union(bytea,internal) ,
960 FUNCTION 3 gtsvector_compress(internal) ,
961 FUNCTION 4 gtsvector_decompress(internal) ,
962 FUNCTION 5 gtsvector_penalty(internal,internal,internal) ,
963 FUNCTION 6 gtsvector_picksplit(internal,internal) ,
964 FUNCTION 7 gtsvector_same(gtsvector,gtsvector,internal);
968 -- TOC entry 10 (OID 11524747)
969 -- Name: statinfo; Type: TYPE; Schema: public; Owner: postgres
972 CREATE TYPE statinfo AS (
980 -- TOC entry 193 (OID 11524748)
981 -- Name: stat(text); Type: FUNCTION; Schema: public; Owner: postgres
984 CREATE FUNCTION stat(text) RETURNS SETOF statinfo
985 AS '$libdir/tsearch2', 'ts_stat'
990 -- TOC entry 194 (OID 11524749)
991 -- Name: reset_tsearch(); Type: FUNCTION; Schema: public; Owner: postgres
994 CREATE FUNCTION reset_tsearch() RETURNS void
995 AS '$libdir/tsearch2', 'reset_tsearch'
1000 -- TOC entry 195 (OID 11524750)
1001 -- Name: get_covers(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
1004 CREATE FUNCTION get_covers(tsvector, tsquery) RETURNS text
1005 AS '$libdir/tsearch2', 'get_covers'
1010 -- TOC entry 11 (OID 11524752)
1011 -- Name: tsdebug; Type: TYPE; Schema: public; Owner: postgres
1014 CREATE TYPE tsdebug AS (
1025 -- TOC entry 196 (OID 11524753)
1026 -- Name: _get_parser_from_curcfg(); Type: FUNCTION; Schema: public; Owner: postgres
1029 CREATE FUNCTION _get_parser_from_curcfg() RETURNS text
1030 AS ' select prs_name from pg_ts_cfg where oid = show_curcfg() '
1031 LANGUAGE sql IMMUTABLE STRICT;
1035 -- TOC entry 197 (OID 11524754)
1036 -- Name: ts_debug(text); Type: FUNCTION; Schema: public; Owner: postgres
1039 CREATE FUNCTION ts_debug(text) RETURNS SETOF tsdebug
1043 t.alias as tok_type,
1044 t.descr as description,
1047 strip(to_tsvector(p.token)) as tsvector
1049 parse( _get_parser_from_curcfg(), $1 ) as p,
1055 t.alias = m.tok_alias and
1056 m.ts_name=c.ts_name and
1059 LANGUAGE sql STRICT;
1063 -- TOC entry 20 (OID 11524757)
1064 -- Name: pages; Type: TABLE; Schema: public; Owner: rich
1067 CREATE TABLE pages (
1071 title text NOT NULL,
1072 description text NOT NULL,
1073 creation_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL,
1074 last_modified_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL,
1075 hostid integer NOT NULL,
1079 logged_user integer,
1080 title_description_fti tsvector NOT NULL,
1087 -- TOC entry 21 (OID 11524757)
1088 -- Name: pages; Type: ACL; Schema: public; Owner: rich
1091 REVOKE ALL ON TABLE pages FROM PUBLIC;
1092 GRANT ALL ON TABLE pages TO "www-data";
1096 -- TOC entry 67 (OID 11524757)
1097 -- Name: pages_id_seq; Type: ACL; Schema: public; Owner: rich
1100 REVOKE ALL ON TABLE pages_id_seq FROM PUBLIC;
1101 GRANT ALL ON TABLE pages_id_seq TO "www-data";
1105 -- TOC entry 22 (OID 11524767)
1106 -- Name: contents; Type: TABLE; Schema: public; Owner: rich
1109 CREATE TABLE contents (
1111 pageid integer NOT NULL,
1112 ordering integer NOT NULL,
1114 content text NOT NULL,
1116 content_fti tsvector NOT NULL,
1119 CONSTRAINT "$2" CHECK (((jsgo IS NULL) OR ((divname IS NOT NULL) OR (divclass IS NOT NULL))))
1124 -- TOC entry 23 (OID 11524767)
1125 -- Name: contents; Type: ACL; Schema: public; Owner: rich
1128 REVOKE ALL ON TABLE contents FROM PUBLIC;
1129 GRANT ALL ON TABLE contents TO "www-data";
1133 -- TOC entry 68 (OID 11524767)
1134 -- Name: contents_id_seq; Type: ACL; Schema: public; Owner: rich
1137 REVOKE ALL ON TABLE contents_id_seq FROM PUBLIC;
1138 GRANT ALL ON TABLE contents_id_seq TO "www-data";
1142 -- TOC entry 24 (OID 11524775)
1143 -- Name: hosts; Type: TABLE; Schema: public; Owner: rich
1146 CREATE TABLE hosts (
1148 canonical_hostname text NOT NULL,
1150 edit_anon boolean DEFAULT true NOT NULL,
1151 create_account_anon boolean DEFAULT true NOT NULL,
1153 feedback_email text,
1154 mailing_list boolean DEFAULT false NOT NULL,
1155 is_template boolean DEFAULT false NOT NULL,
1156 search_box boolean DEFAULT true NOT NULL,
1157 view_anon boolean DEFAULT true NOT NULL,
1158 navigation boolean DEFAULT false NOT NULL,
1162 brand_description text,
1164 ie_imagetoolbar_no boolean DEFAULT false NOT NULL,
1165 global_noodp boolean DEFAULT false NOT NULL,
1172 -- TOC entry 25 (OID 11524775)
1173 -- Name: hosts; Type: ACL; Schema: public; Owner: rich
1176 REVOKE ALL ON TABLE hosts FROM PUBLIC;
1177 GRANT ALL ON TABLE hosts TO "www-data";
1181 -- TOC entry 69 (OID 11524775)
1182 -- Name: hosts_id_seq; Type: ACL; Schema: public; Owner: rich
1185 REVOKE ALL ON TABLE hosts_id_seq FROM PUBLIC;
1186 GRANT ALL ON TABLE hosts_id_seq TO "www-data";
1190 -- TOC entry 26 (OID 11524788)
1191 -- Name: hostnames; Type: TABLE; Schema: public; Owner: rich
1194 CREATE TABLE hostnames (
1195 hostid integer NOT NULL,
1201 -- TOC entry 27 (OID 11524788)
1202 -- Name: hostnames; Type: ACL; Schema: public; Owner: rich
1205 REVOKE ALL ON TABLE hostnames FROM PUBLIC;
1206 GRANT ALL ON TABLE hostnames TO "www-data";
1210 -- TOC entry 28 (OID 11524795)
1211 -- Name: images; Type: TABLE; Schema: public; Owner: rich
1214 CREATE TABLE images (
1216 hostid integer NOT NULL,
1219 image bytea NOT NULL,
1220 width integer NOT NULL,
1221 height integer NOT NULL,
1226 mime_type text NOT NULL,
1231 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
1236 -- TOC entry 29 (OID 11524795)
1237 -- Name: images; Type: ACL; Schema: public; Owner: rich
1240 REVOKE ALL ON TABLE images FROM PUBLIC;
1241 GRANT ALL ON TABLE images TO "www-data";
1245 -- TOC entry 70 (OID 11524795)
1246 -- Name: images_id_seq; Type: ACL; Schema: public; Owner: rich
1249 REVOKE ALL ON TABLE images_id_seq FROM PUBLIC;
1250 GRANT ALL ON TABLE images_id_seq TO "www-data";
1254 -- TOC entry 30 (OID 11524804)
1255 -- Name: files; Type: TABLE; Schema: public; Owner: rich
1258 CREATE TABLE files (
1260 hostid integer NOT NULL,
1263 content bytea NOT NULL,
1265 mime_type text NOT NULL,
1266 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
1271 -- TOC entry 31 (OID 11524804)
1272 -- Name: files; Type: ACL; Schema: public; Owner: rich
1275 REVOKE ALL ON TABLE files FROM PUBLIC;
1276 GRANT ALL ON TABLE files TO "www-data";
1280 -- TOC entry 71 (OID 11524804)
1281 -- Name: files_id_seq; Type: ACL; Schema: public; Owner: rich
1284 REVOKE ALL ON TABLE files_id_seq FROM PUBLIC;
1285 GRANT ALL ON TABLE files_id_seq TO "www-data";
1289 -- TOC entry 32 (OID 11524813)
1290 -- Name: users; Type: TABLE; Schema: public; Owner: rich
1293 CREATE TABLE users (
1295 hostid integer NOT NULL,
1297 "password" text NOT NULL,
1299 registration_date date DEFAULT ('now'::text)::date NOT NULL,
1300 can_edit boolean DEFAULT true NOT NULL,
1301 can_manage_users boolean DEFAULT false NOT NULL,
1302 can_manage_contacts boolean DEFAULT false NOT NULL,
1303 can_manage_site boolean DEFAULT false NOT NULL,
1304 can_edit_global_css boolean DEFAULT false NOT NULL,
1305 force_password_change boolean DEFAULT false NOT NULL,
1306 can_import_mail boolean DEFAULT false NOT NULL,
1307 email_notify boolean DEFAULT true NOT NULL,
1309 can_edit_macros boolean DEFAULT false NOT NULL
1314 -- TOC entry 33 (OID 11524813)
1315 -- Name: users; Type: ACL; Schema: public; Owner: rich
1318 REVOKE ALL ON TABLE users FROM PUBLIC;
1319 GRANT ALL ON TABLE users TO "www-data";
1323 -- TOC entry 72 (OID 11524813)
1324 -- Name: users_id_seq; Type: ACL; Schema: public; Owner: rich
1327 REVOKE ALL ON TABLE users_id_seq FROM PUBLIC;
1328 GRANT ALL ON TABLE users_id_seq TO "www-data";
1332 -- TOC entry 34 (OID 11524828)
1333 -- Name: usercookies; Type: TABLE; Schema: public; Owner: rich
1336 CREATE TABLE usercookies (
1337 userid integer NOT NULL,
1338 cookie text NOT NULL
1343 -- TOC entry 35 (OID 11524828)
1344 -- Name: usercookies; Type: ACL; Schema: public; Owner: rich
1347 REVOKE ALL ON TABLE usercookies FROM PUBLIC;
1348 GRANT ALL ON TABLE usercookies TO "www-data";
1352 -- TOC entry 36 (OID 11524833)
1353 -- Name: sitemenu; Type: TABLE; Schema: public; Owner: rich
1356 CREATE TABLE sitemenu (
1357 hostid integer NOT NULL,
1359 label text NOT NULL,
1360 ordering integer NOT NULL
1365 -- TOC entry 37 (OID 11524833)
1366 -- Name: sitemenu; Type: ACL; Schema: public; Owner: rich
1369 REVOKE ALL ON TABLE sitemenu FROM PUBLIC;
1370 GRANT ALL ON TABLE sitemenu TO "www-data";
1374 -- TOC entry 38 (OID 11524840)
1375 -- Name: contacts; Type: TABLE; Schema: public; Owner: rich
1378 CREATE TABLE contacts (
1380 hostid integer NOT NULL,
1382 subject text NOT NULL
1387 -- TOC entry 39 (OID 11524840)
1388 -- Name: contacts; Type: ACL; Schema: public; Owner: rich
1391 REVOKE ALL ON TABLE contacts FROM PUBLIC;
1392 GRANT ALL ON TABLE contacts TO "www-data";
1396 -- TOC entry 73 (OID 11524840)
1397 -- Name: contacts_id_seq; Type: ACL; Schema: public; Owner: rich
1400 REVOKE ALL ON TABLE contacts_id_seq FROM PUBLIC;
1401 GRANT ALL ON TABLE contacts_id_seq TO "www-data";
1405 -- TOC entry 40 (OID 11524846)
1406 -- Name: contact_emails; Type: TABLE; Schema: public; Owner: rich
1409 CREATE TABLE contact_emails (
1410 contactid integer NOT NULL,
1416 -- TOC entry 41 (OID 11524846)
1417 -- Name: contact_emails; Type: ACL; Schema: public; Owner: rich
1420 REVOKE ALL ON TABLE contact_emails FROM PUBLIC;
1421 GRANT ALL ON TABLE contact_emails TO "www-data";
1425 -- TOC entry 42 (OID 11524851)
1426 -- Name: themes; Type: TABLE; Schema: public; Owner: rich
1429 CREATE TABLE themes (
1430 theme_css text NOT NULL,
1432 description text NOT NULL
1437 -- TOC entry 43 (OID 11524851)
1438 -- Name: themes; Type: ACL; Schema: public; Owner: rich
1441 REVOKE ALL ON TABLE themes FROM PUBLIC;
1442 GRANT SELECT ON TABLE themes TO "www-data";
1446 -- TOC entry 44 (OID 11524856)
1447 -- Name: server_settings; Type: TABLE; Schema: public; Owner: rich
1450 CREATE TABLE server_settings (
1451 "version" integer NOT NULL,
1458 -- TOC entry 46 (OID 11524856)
1459 -- Name: server_settings; Type: ACL; Schema: public; Owner: rich
1462 REVOKE ALL ON TABLE server_settings FROM PUBLIC;
1463 GRANT SELECT ON TABLE server_settings TO "www-data";
1467 -- TOC entry 47 (OID 11524861)
1468 -- Name: page_emails; Type: TABLE; Schema: public; Owner: rich
1471 CREATE TABLE page_emails (
1472 hostid integer NOT NULL,
1474 email text NOT NULL,
1475 entry_date date DEFAULT ('now'::text)::date NOT NULL,
1476 last_sent date DEFAULT ('now'::text)::date NOT NULL,
1478 opt_out text NOT NULL
1483 -- TOC entry 48 (OID 11524861)
1484 -- Name: page_emails; Type: ACL; Schema: public; Owner: rich
1487 REVOKE ALL ON TABLE page_emails FROM PUBLIC;
1488 GRANT ALL ON TABLE page_emails TO "www-data";
1492 -- TOC entry 49 (OID 11524868)
1493 -- Name: mailing_lists; Type: TABLE; Schema: public; Owner: rich
1496 CREATE TABLE mailing_lists (
1497 hostid integer NOT NULL,
1498 email text NOT NULL,
1499 entry_date date DEFAULT ('now'::text)::date NOT NULL,
1501 opt_out text NOT NULL,
1507 -- TOC entry 50 (OID 11524868)
1508 -- Name: mailing_lists; Type: ACL; Schema: public; Owner: rich
1511 REVOKE ALL ON TABLE mailing_lists FROM PUBLIC;
1512 GRANT ALL ON TABLE mailing_lists TO "www-data";
1516 -- TOC entry 51 (OID 11524874)
1517 -- Name: links; Type: TABLE; Schema: public; Owner: rich
1520 CREATE TABLE links (
1521 hostid integer NOT NULL,
1522 from_url text NOT NULL,
1523 to_url text NOT NULL,
1524 CONSTRAINT links_not_selfref_cn CHECK ((from_url <> to_url))
1529 -- TOC entry 52 (OID 11524874)
1530 -- Name: links; Type: ACL; Schema: public; Owner: rich
1533 REVOKE ALL ON TABLE links FROM PUBLIC;
1534 GRANT ALL ON TABLE links TO "www-data";
1538 -- TOC entry 53 (OID 11524882)
1539 -- Name: templates; Type: TABLE; Schema: public; Owner: rich
1542 CREATE TABLE templates (
1544 title_regexp text NOT NULL,
1545 url_regexp text NOT NULL,
1546 extension text NOT NULL,
1547 ordering integer NOT NULL
1552 -- TOC entry 54 (OID 11524882)
1553 -- Name: templates; Type: ACL; Schema: public; Owner: rich
1556 REVOKE ALL ON TABLE templates FROM PUBLIC;
1557 GRANT SELECT ON TABLE templates TO "www-data";
1561 -- TOC entry 74 (OID 11524882)
1562 -- Name: templates_id_seq; Type: ACL; Schema: public; Owner: rich
1565 REVOKE ALL ON TABLE templates_id_seq FROM PUBLIC;
1569 -- TOC entry 55 (OID 11524888)
1570 -- Name: recently_visited; Type: TABLE; Schema: public; Owner: rich
1573 CREATE TABLE recently_visited (
1574 userid integer NOT NULL,
1575 hostid integer NOT NULL,
1577 visit_time timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
1582 -- TOC entry 56 (OID 11524888)
1583 -- Name: recently_visited; Type: ACL; Schema: public; Owner: rich
1586 REVOKE ALL ON TABLE recently_visited FROM PUBLIC;
1587 GRANT ALL ON TABLE recently_visited TO "www-data";
1591 -- TOC entry 57 (OID 11524896)
1592 -- Name: messages; Type: TABLE; Schema: public; Owner: rich
1595 CREATE TABLE messages (
1597 subject text NOT NULL,
1598 inet_message_id text NOT NULL,
1599 message_date timestamp with time zone NOT NULL,
1600 hostid integer NOT NULL
1605 -- TOC entry 58 (OID 11524896)
1606 -- Name: messages; Type: ACL; Schema: public; Owner: rich
1609 REVOKE ALL ON TABLE messages FROM PUBLIC;
1610 GRANT ALL ON TABLE messages TO "www-data";
1614 -- TOC entry 75 (OID 11524896)
1615 -- Name: messages_id_seq; Type: ACL; Schema: public; Owner: rich
1618 REVOKE ALL ON TABLE messages_id_seq FROM PUBLIC;
1619 GRANT ALL ON TABLE messages_id_seq TO "www-data";
1623 -- TOC entry 59 (OID 11524902)
1624 -- Name: msg_references; Type: TABLE; Schema: public; Owner: rich
1627 CREATE TABLE msg_references (
1628 message_id integer NOT NULL,
1629 inet_message_id text NOT NULL,
1630 ordering integer NOT NULL
1635 -- TOC entry 60 (OID 11524902)
1636 -- Name: msg_references; Type: ACL; Schema: public; Owner: rich
1639 REVOKE ALL ON TABLE msg_references FROM PUBLIC;
1640 GRANT ALL ON TABLE msg_references TO "www-data";
1644 -- TOC entry 61 (OID 11524909)
1645 -- Name: powered_by; Type: TABLE; Schema: public; Owner: rich
1648 CREATE TABLE powered_by (
1656 -- TOC entry 62 (OID 11524909)
1657 -- Name: powered_by; Type: ACL; Schema: public; Owner: rich
1660 REVOKE ALL ON TABLE powered_by FROM PUBLIC;
1661 GRANT SELECT ON TABLE powered_by TO "www-data";
1665 -- TOC entry 63 (OID 11524915)
1666 -- Name: pending_email_changes; Type: TABLE; Schema: public; Owner: rich
1669 CREATE TABLE pending_email_changes (
1670 "key" text NOT NULL,
1671 change_date date DEFAULT ('now'::text)::date NOT NULL,
1672 userid integer NOT NULL,
1678 -- TOC entry 64 (OID 11524915)
1679 -- Name: pending_email_changes; Type: ACL; Schema: public; Owner: rich
1682 REVOKE ALL ON TABLE pending_email_changes FROM PUBLIC;
1683 GRANT ALL ON TABLE pending_email_changes TO "www-data";
1687 -- TOC entry 199 (OID 14911567)
1688 -- Name: contents_jsgo_check_tg(); Type: FUNCTION; Schema: public; Owner: rich
1691 CREATE FUNCTION contents_jsgo_check_tg() RETURNS "trigger"
1699 if new.jsgo is not null then
1701 select into my_hostid p.hostid
1703 where p.id = new.pageid;
1704 -- Check that (hostid, url) where url = new.jsgo exists.
1705 select into my_count count(p.*)
1707 where p.hostid = my_hostid
1708 and p.url is not null
1709 and p.url = new.jsgo
1710 and p.redirect is null;
1711 if my_count < 1 then
1712 raise exception ''contents.jsgo points to non-existent page (%, %)'',
1713 my_hostid, new.jsgo;
1717 -- Everything is OK. Return the new row unmodified.
1726 -- TOC entry 65 (OID 14911929)
1727 -- Name: macros; Type: TABLE; Schema: public; Owner: rich
1730 CREATE TABLE macros (
1731 hostid integer NOT NULL,
1733 content text NOT NULL
1738 -- TOC entry 66 (OID 14911929)
1739 -- Name: macros; Type: ACL; Schema: public; Owner: rich
1742 REVOKE ALL ON TABLE macros FROM PUBLIC;
1743 GRANT ALL ON TABLE macros TO "www-data";
1747 -- TOC entry 90 (OID 11576669)
1748 -- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich
1751 CREATE UNIQUE INDEX hostnames_hostid_name_uq ON hostnames USING btree (hostid, name);
1755 -- TOC entry 85 (OID 11576670)
1756 -- Name: pages_url_uq; Type: INDEX; Schema: public; Owner: rich
1759 CREATE UNIQUE INDEX pages_url_uq ON pages USING btree (hostid, url);
1763 -- TOC entry 92 (OID 11576671)
1764 -- Name: images_name_uq; Type: INDEX; Schema: public; Owner: rich
1767 CREATE UNIQUE INDEX images_name_uq ON images USING btree (hostid, name);
1771 -- TOC entry 94 (OID 11576672)
1772 -- Name: files_name_uq; Type: INDEX; Schema: public; Owner: rich
1775 CREATE UNIQUE INDEX files_name_uq ON files USING btree (hostid, name);
1779 -- TOC entry 97 (OID 11576673)
1780 -- Name: users_name_uq; Type: INDEX; Schema: public; Owner: rich
1783 CREATE UNIQUE INDEX users_name_uq ON users USING btree (hostid, name);
1787 -- TOC entry 96 (OID 11576674)
1788 -- Name: users_id_uq; Type: INDEX; Schema: public; Owner: rich
1791 CREATE UNIQUE INDEX users_id_uq ON users USING btree (hostid, id);
1795 -- TOC entry 100 (OID 11576675)
1796 -- Name: sitemenu_ordering_uq; Type: INDEX; Schema: public; Owner: rich
1799 CREATE UNIQUE INDEX sitemenu_ordering_uq ON sitemenu USING btree (hostid, ordering);
1803 -- TOC entry 101 (OID 11576676)
1804 -- Name: sitemenu_url_uq; Type: INDEX; Schema: public; Owner: rich
1807 CREATE UNIQUE INDEX sitemenu_url_uq ON sitemenu USING btree (hostid, url);
1811 -- TOC entry 104 (OID 11576677)
1812 -- Name: contact_emails_uq; Type: INDEX; Schema: public; Owner: rich
1815 CREATE UNIQUE INDEX contact_emails_uq ON contact_emails USING btree (contactid, email);
1819 -- TOC entry 105 (OID 11576678)
1820 -- Name: themes_theme_css_uq; Type: INDEX; Schema: public; Owner: rich
1823 CREATE UNIQUE INDEX themes_theme_css_uq ON themes USING btree (theme_css);
1827 -- TOC entry 106 (OID 11576679)
1828 -- Name: page_emails_email_uq; Type: INDEX; Schema: public; Owner: rich
1831 CREATE UNIQUE INDEX page_emails_email_uq ON page_emails USING btree (hostid, url, email);
1835 -- TOC entry 107 (OID 11576680)
1836 -- Name: mailing_lists_email_uq; Type: INDEX; Schema: public; Owner: rich
1839 CREATE UNIQUE INDEX mailing_lists_email_uq ON mailing_lists USING btree (hostid, email);
1843 -- TOC entry 102 (OID 11576681)
1844 -- Name: contacts_name_uq; Type: INDEX; Schema: public; Owner: rich
1847 CREATE UNIQUE INDEX contacts_name_uq ON contacts USING btree (hostid, name);
1851 -- TOC entry 108 (OID 11576682)
1852 -- Name: links_uq; Type: INDEX; Schema: public; Owner: rich
1855 CREATE UNIQUE INDEX links_uq ON links USING btree (hostid, from_url, to_url);
1859 -- TOC entry 109 (OID 11576683)
1860 -- Name: templates_ext_ord_uq; Type: INDEX; Schema: public; Owner: rich
1863 CREATE UNIQUE INDEX templates_ext_ord_uq ON templates USING btree (extension, ordering);
1867 -- TOC entry 111 (OID 11576684)
1868 -- Name: templates_title_uq; Type: INDEX; Schema: public; Owner: rich
1871 CREATE UNIQUE INDEX templates_title_uq ON templates USING btree (title_regexp);
1875 -- TOC entry 112 (OID 11576685)
1876 -- Name: templates_url_uq; Type: INDEX; Schema: public; Owner: rich
1879 CREATE UNIQUE INDEX templates_url_uq ON templates USING btree (url_regexp);
1883 -- TOC entry 113 (OID 11576686)
1884 -- Name: recently_visited_uq; Type: INDEX; Schema: public; Owner: rich
1887 CREATE UNIQUE INDEX recently_visited_uq ON recently_visited USING btree (userid, hostid, url);
1891 -- TOC entry 114 (OID 11576687)
1892 -- Name: messages_inet_message_id_uq; Type: INDEX; Schema: public; Owner: rich
1895 CREATE UNIQUE INDEX messages_inet_message_id_uq ON messages USING btree (hostid, inet_message_id);
1899 -- TOC entry 84 (OID 11576688)
1900 -- Name: pages_url_ix; Type: INDEX; Schema: public; Owner: rich
1903 CREATE INDEX pages_url_ix ON pages USING btree (url);
1907 -- TOC entry 83 (OID 11576689)
1908 -- Name: pages_redirect_ix; Type: INDEX; Schema: public; Owner: rich
1911 CREATE INDEX pages_redirect_ix ON pages USING btree (redirect);
1915 -- TOC entry 80 (OID 11576690)
1916 -- Name: pages_fti_idx; Type: INDEX; Schema: public; Owner: rich
1919 CREATE INDEX pages_fti_idx ON pages USING gist (title_description_fti);
1923 -- TOC entry 86 (OID 11576691)
1924 -- Name: contents_fti_idx; Type: INDEX; Schema: public; Owner: rich
1927 CREATE INDEX contents_fti_idx ON contents USING gist (content_fti);
1931 -- TOC entry 87 (OID 11576692)
1932 -- Name: contents_pageid_idx; Type: INDEX; Schema: public; Owner: rich
1935 CREATE INDEX contents_pageid_idx ON contents USING btree (pageid);
1939 -- TOC entry 91 (OID 11576693)
1940 -- Name: hostnames_name_uq; Type: INDEX; Schema: public; Owner: rich
1943 CREATE UNIQUE INDEX hostnames_name_uq ON hostnames USING btree (name);
1947 -- TOC entry 99 (OID 11576694)
1948 -- Name: usercookies_cookie_idx; Type: INDEX; Schema: public; Owner: rich
1951 CREATE INDEX usercookies_cookie_idx ON usercookies USING btree (cookie);
1955 -- TOC entry 81 (OID 11576695)
1956 -- Name: pages_lc_title; Type: INDEX; Schema: public; Owner: rich
1959 CREATE INDEX pages_lc_title ON pages USING btree (lower(title));
1963 -- TOC entry 76 (OID 11524572)
1964 -- Name: pg_ts_dict_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1967 ALTER TABLE ONLY pg_ts_dict
1968 ADD CONSTRAINT pg_ts_dict_pkey PRIMARY KEY (dict_name);
1972 -- TOC entry 77 (OID 11524598)
1973 -- Name: pg_ts_parser_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1976 ALTER TABLE ONLY pg_ts_parser
1977 ADD CONSTRAINT pg_ts_parser_pkey PRIMARY KEY (prs_name);
1981 -- TOC entry 78 (OID 11524623)
1982 -- Name: pg_ts_cfg_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1985 ALTER TABLE ONLY pg_ts_cfg
1986 ADD CONSTRAINT pg_ts_cfg_pkey PRIMARY KEY (ts_name);
1990 -- TOC entry 79 (OID 11524630)
1991 -- Name: pg_ts_cfgmap_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1994 ALTER TABLE ONLY pg_ts_cfgmap
1995 ADD CONSTRAINT pg_ts_cfgmap_pkey PRIMARY KEY (ts_name, tok_alias);
1999 -- TOC entry 82 (OID 11576696)
2000 -- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
2003 ALTER TABLE ONLY pages
2004 ADD CONSTRAINT pages_pkey PRIMARY KEY (id);
2008 -- TOC entry 88 (OID 11576698)
2009 -- Name: contents_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
2012 ALTER TABLE ONLY contents
2013 ADD CONSTRAINT contents_pkey PRIMARY KEY (id);
2017 -- TOC entry 89 (OID 11576700)
2018 -- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
2021 ALTER TABLE ONLY hosts
2022 ADD CONSTRAINT hosts_pkey PRIMARY KEY (id);
2026 -- TOC entry 93 (OID 11576702)
2027 -- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
2030 ALTER TABLE ONLY images
2031 ADD CONSTRAINT images_pkey PRIMARY KEY (id);
2035 -- TOC entry 95 (OID 11576704)
2036 -- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
2039 ALTER TABLE ONLY files
2040 ADD CONSTRAINT files_pkey PRIMARY KEY (id);
2044 -- TOC entry 98 (OID 11576706)
2045 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
2048 ALTER TABLE ONLY users
2049 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
2053 -- TOC entry 103 (OID 11576708)
2054 -- Name: contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
2057 ALTER TABLE ONLY contacts
2058 ADD CONSTRAINT contacts_pkey PRIMARY KEY (id);
2062 -- TOC entry 110 (OID 11576710)
2063 -- Name: templates_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
2066 ALTER TABLE ONLY templates
2067 ADD CONSTRAINT templates_pkey PRIMARY KEY (id);
2071 -- TOC entry 115 (OID 11576712)
2072 -- Name: messages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
2075 ALTER TABLE ONLY messages
2076 ADD CONSTRAINT messages_pkey PRIMARY KEY (id);
2080 -- TOC entry 116 (OID 11576714)
2081 -- Name: powered_by_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
2084 ALTER TABLE ONLY powered_by
2085 ADD CONSTRAINT powered_by_pkey PRIMARY KEY (id);
2089 -- TOC entry 117 (OID 11576716)
2090 -- Name: pending_email_changes_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
2093 ALTER TABLE ONLY pending_email_changes
2094 ADD CONSTRAINT pending_email_changes_pkey PRIMARY KEY ("key");
2098 -- TOC entry 118 (OID 14911934)
2099 -- Name: macros_hostid_key; Type: CONSTRAINT; Schema: public; Owner: rich
2102 ALTER TABLE ONLY macros
2103 ADD CONSTRAINT macros_hostid_key UNIQUE (hostid, name);
2107 -- TOC entry 208 (OID 11576718)
2108 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2111 ALTER TABLE ONLY contents
2112 ADD CONSTRAINT "$1" FOREIGN KEY (pageid) REFERENCES pages(id);
2116 -- TOC entry 212 (OID 11576722)
2117 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2120 ALTER TABLE ONLY hostnames
2121 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2125 -- TOC entry 209 (OID 11576726)
2126 -- Name: hosts_hostname_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2129 ALTER TABLE ONLY hosts
2130 ADD CONSTRAINT hosts_hostname_cn FOREIGN KEY (id, canonical_hostname) REFERENCES hostnames(hostid, name) DEFERRABLE;
2134 -- TOC entry 204 (OID 11576730)
2135 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2138 ALTER TABLE ONLY pages
2139 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2143 -- TOC entry 213 (OID 11576734)
2144 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2147 ALTER TABLE ONLY images
2148 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2152 -- TOC entry 214 (OID 11576738)
2153 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2156 ALTER TABLE ONLY files
2157 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2161 -- TOC entry 205 (OID 11576742)
2162 -- Name: pages_redirect_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2165 ALTER TABLE ONLY pages
2166 ADD CONSTRAINT pages_redirect_cn FOREIGN KEY (hostid, redirect) REFERENCES pages(hostid, url) DEFERRABLE;
2170 -- TOC entry 215 (OID 11576746)
2171 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2174 ALTER TABLE ONLY users
2175 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2179 -- TOC entry 216 (OID 11576750)
2180 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2183 ALTER TABLE ONLY usercookies
2184 ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
2188 -- TOC entry 206 (OID 11576754)
2189 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
2192 ALTER TABLE ONLY pages
2193 ADD CONSTRAINT "$2" FOREIGN KEY (logged_user) REFERENCES users(id);
2197 -- TOC entry 207 (OID 11576758)
2198 -- Name: pages_user_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2201 ALTER TABLE ONLY pages
2202 ADD CONSTRAINT pages_user_cn FOREIGN KEY (hostid, logged_user) REFERENCES users(hostid, id);
2206 -- TOC entry 217 (OID 11576762)
2207 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2210 ALTER TABLE ONLY sitemenu
2211 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2215 -- TOC entry 218 (OID 11576766)
2216 -- Name: sitemenu_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2219 ALTER TABLE ONLY sitemenu
2220 ADD CONSTRAINT sitemenu_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
2224 -- TOC entry 219 (OID 11576770)
2225 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2228 ALTER TABLE ONLY contacts
2229 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2233 -- TOC entry 220 (OID 11576774)
2234 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2237 ALTER TABLE ONLY contact_emails
2238 ADD CONSTRAINT "$1" FOREIGN KEY (contactid) REFERENCES contacts(id);
2242 -- TOC entry 210 (OID 11576778)
2243 -- Name: hosts_theme_css_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2246 ALTER TABLE ONLY hosts
2247 ADD CONSTRAINT hosts_theme_css_cn FOREIGN KEY (theme_css) REFERENCES themes(theme_css);
2251 -- TOC entry 221 (OID 11576782)
2252 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2255 ALTER TABLE ONLY page_emails
2256 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2260 -- TOC entry 222 (OID 11576786)
2261 -- Name: page_emails_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2264 ALTER TABLE ONLY page_emails
2265 ADD CONSTRAINT page_emails_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
2269 -- TOC entry 223 (OID 11576790)
2270 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2273 ALTER TABLE ONLY mailing_lists
2274 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2278 -- TOC entry 224 (OID 11576794)
2279 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2282 ALTER TABLE ONLY links
2283 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2287 -- TOC entry 225 (OID 11576798)
2288 -- Name: links_from_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2291 ALTER TABLE ONLY links
2292 ADD CONSTRAINT links_from_cn FOREIGN KEY (hostid, from_url) REFERENCES pages(hostid, url) DEFERRABLE;
2296 -- TOC entry 226 (OID 11576802)
2297 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2300 ALTER TABLE ONLY recently_visited
2301 ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
2305 -- TOC entry 227 (OID 11576806)
2306 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
2309 ALTER TABLE ONLY recently_visited
2310 ADD CONSTRAINT "$2" FOREIGN KEY (hostid) REFERENCES hosts(id);
2314 -- TOC entry 228 (OID 11576810)
2315 -- Name: recently_visited_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2318 ALTER TABLE ONLY recently_visited
2319 ADD CONSTRAINT recently_visited_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
2323 -- TOC entry 229 (OID 11576814)
2324 -- Name: recently_visited_userid_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2327 ALTER TABLE ONLY recently_visited
2328 ADD CONSTRAINT recently_visited_userid_cn FOREIGN KEY (hostid, userid) REFERENCES users(hostid, id);
2332 -- TOC entry 231 (OID 11576818)
2333 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2336 ALTER TABLE ONLY msg_references
2337 ADD CONSTRAINT "$1" FOREIGN KEY (message_id) REFERENCES messages(id);
2341 -- TOC entry 230 (OID 11576822)
2342 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2345 ALTER TABLE ONLY messages
2346 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2350 -- TOC entry 211 (OID 11576826)
2351 -- Name: hosts_powered_by_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
2354 ALTER TABLE ONLY hosts
2355 ADD CONSTRAINT hosts_powered_by_cn FOREIGN KEY (powered_by) REFERENCES powered_by(id);
2359 -- TOC entry 232 (OID 11576830)
2360 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2363 ALTER TABLE ONLY pending_email_changes
2364 ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
2368 -- TOC entry 233 (OID 14911936)
2369 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
2372 ALTER TABLE ONLY macros
2373 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
2377 -- TOC entry 234 (OID 11576834)
2378 -- Name: pages_fti_tr; Type: TRIGGER; Schema: public; Owner: rich
2381 CREATE TRIGGER pages_fti_tr
2382 BEFORE INSERT OR UPDATE ON pages
2384 EXECUTE PROCEDURE tsearch2('title_description_fti', 'title', 'description');
2388 -- TOC entry 235 (OID 11576835)
2389 -- Name: contents_fti_tr; Type: TRIGGER; Schema: public; Owner: rich
2392 CREATE TRIGGER contents_fti_tr
2393 BEFORE INSERT OR UPDATE ON contents
2395 EXECUTE PROCEDURE tsearch2('content_fti', 'sectionname', 'content');
2399 -- TOC entry 236 (OID 14911568)
2400 -- Name: contents_jsgo_check_tg; Type: TRIGGER; Schema: public; Owner: rich
2403 CREATE TRIGGER contents_jsgo_check_tg
2404 BEFORE INSERT OR UPDATE ON contents
2406 EXECUTE PROCEDURE contents_jsgo_check_tg();
2410 -- TOC entry 3 (OID 2200)
2411 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
2414 COMMENT ON SCHEMA public IS 'Standard public namespace';
2418 -- TOC entry 166 (OID 11524715)
2419 -- Name: FUNCTION exectsq(tsvector, tsquery); Type: COMMENT; Schema: public; Owner: postgres
2422 COMMENT ON FUNCTION exectsq(tsvector, tsquery) IS 'boolean operation with text index';
2426 -- TOC entry 168 (OID 11524716)
2427 -- Name: FUNCTION rexectsq(tsquery, tsvector); Type: COMMENT; Schema: public; Owner: postgres
2430 COMMENT ON FUNCTION rexectsq(tsquery, tsvector) IS 'boolean operation with text index';
2434 -- TOC entry 45 (OID 11524856)
2435 -- Name: TABLE server_settings; Type: COMMENT; Schema: public; Owner: rich
2438 COMMENT ON TABLE server_settings IS 'This table contains global settings for the server. There should be only one row in this table. If you modify any setting, you must restart the webserver for the change to take effect. The "version" field is intended to be some sort of database version, but is currently unused.';
2442 -- PostgreSQL database dump
2445 SET client_encoding = 'UNICODE';
2446 SET check_function_bodies = false;
2448 SET search_path = public, pg_catalog;
2451 -- Data for TOC entry 3 (OID 11524882)
2452 -- Name: templates; Type: TABLE DATA; Schema: public; Owner: rich
2455 COPY templates (id, title_regexp, url_regexp, extension, ordering) FROM stdin;
2456 1 ^(199[0-9]|20[0-9][0-9])/(0[1-9]|1[0-2])/(0[1-9]|1[0-9]|2[0-9]|3[01])$ ^(199[0-9]|20[0-9][0-9])/(0[1-9]|1[0-2])/(0[1-9]|1[0-9]|2[0-9]|3[01])$ calendar 10
2457 3 ^(199[0-9]|20[0-9][0-9])/(0[1-9]|1[0-2])$ ^(199[0-9]|20[0-9][0-9])/(0[1-9]|1[0-2])$ calendar 20
2458 4 ^(199[0-9]|20[0-9][0-9])$ ^(199[0-9]|20[0-9][0-9])$ calendar 30
2463 -- TOC entry 2 (OID 11524880)
2464 -- Name: templates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rich
2467 SELECT pg_catalog.setval('templates_id_seq', 4, true);
2471 -- PostgreSQL database dump
2474 SET client_encoding = 'UNICODE';
2475 SET check_function_bodies = false;
2477 SET search_path = public, pg_catalog;
2480 -- Data for TOC entry 2 (OID 11524851)
2481 -- Name: themes; Type: TABLE DATA; Schema: public; Owner: rich
2484 COPY themes (theme_css, name, description) FROM stdin;
2485 /_css/easyweb.css Merjis Easy Web Marketing This is the easy web marketing stylesheet developed by Merjis Ltd. Please see http://www.merjis.com/
2486 /_css/basic.css Basic styles only Only the most essential styles. This is a good starting point if you want to completely restyle pages using site-specific CSS.
2491 -- PostgreSQL database dump
2494 SET client_encoding = 'UNICODE';
2495 SET check_function_bodies = false;
2497 SET search_path = public, pg_catalog;
2500 -- Data for TOC entry 3 (OID 11524909)
2501 -- Name: powered_by; Type: TABLE DATA; Schema: public; Owner: rich
2504 COPY powered_by (id, name, url) FROM stdin;
2505 1 Merjis Team Notepad http://www.team-notepad.com
2506 2 Merjis Easy Web Marketing http://www.merjis.com
2511 -- TOC entry 2 (OID 11524907)
2512 -- Name: powered_by_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rich
2515 SELECT pg_catalog.setval('powered_by_id_seq', 2, true);