--
-- PostgreSQL database dump
--

SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public namespace';


--
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: 
--

CREATE PROCEDURAL LANGUAGE plpgsql;


SET search_path = public, pg_catalog;

--
-- Name: gtsvector_in(cstring); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION gtsvector_in(cstring) RETURNS gtsvector
    AS '$libdir/tsearch2', 'gtsvector_in'
    LANGUAGE c STRICT;


ALTER FUNCTION public.gtsvector_in(cstring) OWNER TO freedb;

--
-- Name: gtsvector_out(gtsvector); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION gtsvector_out(gtsvector) RETURNS cstring
    AS '$libdir/tsearch2', 'gtsvector_out'
    LANGUAGE c STRICT;


ALTER FUNCTION public.gtsvector_out(gtsvector) OWNER TO freedb;

--
-- Name: gtsvector; Type: TYPE; Schema: public; Owner: freedb
--

CREATE TYPE gtsvector (
    INTERNALLENGTH = variable,
    INPUT = gtsvector_in,
    OUTPUT = gtsvector_out,
    ALIGNMENT = int4,
    STORAGE = plain
);


ALTER TYPE public.gtsvector OWNER TO freedb;

--
-- Name: tsquery_in(cstring); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION tsquery_in(cstring) RETURNS tsquery
    AS '$libdir/tsearch2', 'tsquery_in'
    LANGUAGE c STRICT;


ALTER FUNCTION public.tsquery_in(cstring) OWNER TO freedb;

--
-- Name: tsquery_out(tsquery); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION tsquery_out(tsquery) RETURNS cstring
    AS '$libdir/tsearch2', 'tsquery_out'
    LANGUAGE c STRICT;


ALTER FUNCTION public.tsquery_out(tsquery) OWNER TO freedb;

--
-- Name: tsquery; Type: TYPE; Schema: public; Owner: freedb
--

CREATE TYPE tsquery (
    INTERNALLENGTH = variable,
    INPUT = tsquery_in,
    OUTPUT = tsquery_out,
    ALIGNMENT = int4,
    STORAGE = plain
);


ALTER TYPE public.tsquery OWNER TO freedb;

--
-- Name: tsvector_in(cstring); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION tsvector_in(cstring) RETURNS tsvector
    AS '$libdir/tsearch2', 'tsvector_in'
    LANGUAGE c STRICT;


ALTER FUNCTION public.tsvector_in(cstring) OWNER TO freedb;

--
-- Name: tsvector_out(tsvector); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION tsvector_out(tsvector) RETURNS cstring
    AS '$libdir/tsearch2', 'tsvector_out'
    LANGUAGE c STRICT;


ALTER FUNCTION public.tsvector_out(tsvector) OWNER TO freedb;

--
-- Name: tsvector; Type: TYPE; Schema: public; Owner: freedb
--

CREATE TYPE tsvector (
    INTERNALLENGTH = variable,
    INPUT = tsvector_in,
    OUTPUT = tsvector_out,
    ALIGNMENT = int4,
    STORAGE = extended
);


ALTER TYPE public.tsvector OWNER TO freedb;

--
-- Name: statinfo; Type: TYPE; Schema: public; Owner: freedb
--

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


ALTER TYPE public.statinfo OWNER TO freedb;

--
-- Name: tokenout; Type: TYPE; Schema: public; Owner: freedb
--

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


ALTER TYPE public.tokenout OWNER TO freedb;

--
-- Name: tokentype; Type: TYPE; Schema: public; Owner: freedb
--

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


ALTER TYPE public.tokentype OWNER TO freedb;

--
-- Name: tsdebug; Type: TYPE; Schema: public; Owner: freedb
--

CREATE TYPE tsdebug AS (
	ts_name text,
	tok_type text,
	description text,
	token text,
	dict_name text[],
	tsvector tsvector
);


ALTER TYPE public.tsdebug OWNER TO freedb;

--
-- Name: _get_parser_from_curcfg(); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION _get_parser_from_curcfg() RETURNS text
    AS $$ select prs_name from pg_ts_cfg where oid = show_curcfg() $$
    LANGUAGE sql IMMUTABLE STRICT;


ALTER FUNCTION public._get_parser_from_curcfg() OWNER TO freedb;

--
-- Name: concat(tsvector, tsvector); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION concat(tsvector, tsvector) RETURNS tsvector
    AS '$libdir/tsearch2', 'concat'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.concat(tsvector, tsvector) OWNER TO freedb;

--
-- Name: dex_init(internal); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.dex_init(internal) OWNER TO freedb;

--
-- Name: dex_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.dex_lexize(internal, internal, integer) OWNER TO freedb;

--
-- Name: exectsq(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION exectsq(tsvector, tsquery) RETURNS boolean
    AS '$libdir/tsearch2', 'exectsq'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.exectsq(tsvector, tsquery) OWNER TO freedb;

--
-- Name: FUNCTION exectsq(tsvector, tsquery); Type: COMMENT; Schema: public; Owner: freedb
--

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


--
-- Name: get_covers(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.get_covers(tsvector, tsquery) OWNER TO freedb;

--
-- Name: gtsvector_compress(internal); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.gtsvector_compress(internal) OWNER TO freedb;

--
-- Name: gtsvector_consistent(gtsvector, internal, integer); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION gtsvector_consistent(gtsvector, internal, integer) RETURNS boolean
    AS '$libdir/tsearch2', 'gtsvector_consistent'
    LANGUAGE c;


ALTER FUNCTION public.gtsvector_consistent(gtsvector, internal, integer) OWNER TO freedb;

--
-- Name: gtsvector_decompress(internal); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.gtsvector_decompress(internal) OWNER TO freedb;

--
-- Name: gtsvector_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.gtsvector_penalty(internal, internal, internal) OWNER TO freedb;

--
-- Name: gtsvector_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.gtsvector_picksplit(internal, internal) OWNER TO freedb;

--
-- Name: gtsvector_same(gtsvector, gtsvector, internal); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.gtsvector_same(gtsvector, gtsvector, internal) OWNER TO freedb;

--
-- Name: gtsvector_union(internal, internal); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION gtsvector_union(internal, internal) RETURNS integer[]
    AS '$libdir/tsearch2', 'gtsvector_union'
    LANGUAGE c;


ALTER FUNCTION public.gtsvector_union(internal, internal) OWNER TO freedb;

--
-- Name: headline(oid, text, tsquery, text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION headline(oid, text, tsquery, text) RETURNS text
    AS '$libdir/tsearch2', 'headline'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.headline(oid, text, tsquery, text) OWNER TO freedb;

--
-- Name: headline(oid, text, tsquery); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION headline(oid, text, tsquery) RETURNS text
    AS '$libdir/tsearch2', 'headline'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.headline(oid, text, tsquery) OWNER TO freedb;

--
-- Name: headline(text, text, tsquery, text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION headline(text, text, tsquery, text) RETURNS text
    AS '$libdir/tsearch2', 'headline_byname'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.headline(text, text, tsquery, text) OWNER TO freedb;

--
-- Name: headline(text, text, tsquery); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION headline(text, text, tsquery) RETURNS text
    AS '$libdir/tsearch2', 'headline_byname'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.headline(text, text, tsquery) OWNER TO freedb;

--
-- Name: headline(text, tsquery, text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION headline(text, tsquery, text) RETURNS text
    AS '$libdir/tsearch2', 'headline_current'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.headline(text, tsquery, text) OWNER TO freedb;

--
-- Name: headline(text, tsquery); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION headline(text, tsquery) RETURNS text
    AS '$libdir/tsearch2', 'headline_current'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.headline(text, tsquery) OWNER TO freedb;

--
-- Name: length(tsvector); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION length(tsvector) RETURNS integer
    AS '$libdir/tsearch2', 'tsvector_length'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.length(tsvector) OWNER TO freedb;

--
-- Name: lexize(oid, text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION lexize(oid, text) RETURNS text[]
    AS '$libdir/tsearch2', 'lexize'
    LANGUAGE c STRICT;


ALTER FUNCTION public.lexize(oid, text) OWNER TO freedb;

--
-- Name: lexize(text, text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION lexize(text, text) RETURNS text[]
    AS '$libdir/tsearch2', 'lexize_byname'
    LANGUAGE c STRICT;


ALTER FUNCTION public.lexize(text, text) OWNER TO freedb;

--
-- Name: lexize(text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION lexize(text) RETURNS text[]
    AS '$libdir/tsearch2', 'lexize_bycurrent'
    LANGUAGE c STRICT;


ALTER FUNCTION public.lexize(text) OWNER TO freedb;

--
-- Name: parse(oid, text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION parse(oid, text) RETURNS SETOF tokenout
    AS '$libdir/tsearch2', 'parse'
    LANGUAGE c STRICT;


ALTER FUNCTION public.parse(oid, text) OWNER TO freedb;

--
-- Name: parse(text, text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION parse(text, text) RETURNS SETOF tokenout
    AS '$libdir/tsearch2', 'parse_byname'
    LANGUAGE c STRICT;


ALTER FUNCTION public.parse(text, text) OWNER TO freedb;

--
-- Name: parse(text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION parse(text) RETURNS SETOF tokenout
    AS '$libdir/tsearch2', 'parse_current'
    LANGUAGE c STRICT;


ALTER FUNCTION public.parse(text) OWNER TO freedb;

--
-- Name: plpgsql_call_handler(); Type: FUNCTION; Schema: public; Owner: postgres
--

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


ALTER FUNCTION public.plpgsql_call_handler() OWNER TO postgres;

--
-- Name: prsd_end(internal); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.prsd_end(internal) OWNER TO freedb;

--
-- Name: prsd_getlexeme(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.prsd_getlexeme(internal, internal, internal) OWNER TO freedb;

--
-- Name: prsd_headline(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.prsd_headline(internal, internal, internal) OWNER TO freedb;

--
-- Name: prsd_lextype(internal); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.prsd_lextype(internal) OWNER TO freedb;

--
-- Name: prsd_start(internal, integer); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.prsd_start(internal, integer) OWNER TO freedb;

--
-- Name: querytree(tsquery); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.querytree(tsquery) OWNER TO freedb;

--
-- Name: rank(real[], tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION rank(real[], tsvector, tsquery) RETURNS real
    AS '$libdir/tsearch2', 'rank'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.rank(real[], tsvector, tsquery) OWNER TO freedb;

--
-- Name: rank(real[], tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION rank(real[], tsvector, tsquery, integer) RETURNS real
    AS '$libdir/tsearch2', 'rank'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.rank(real[], tsvector, tsquery, integer) OWNER TO freedb;

--
-- Name: rank(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION rank(tsvector, tsquery) RETURNS real
    AS '$libdir/tsearch2', 'rank_def'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.rank(tsvector, tsquery) OWNER TO freedb;

--
-- Name: rank(tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION rank(tsvector, tsquery, integer) RETURNS real
    AS '$libdir/tsearch2', 'rank_def'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.rank(tsvector, tsquery, integer) OWNER TO freedb;

--
-- Name: rank_cd(integer, tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION rank_cd(integer, tsvector, tsquery) RETURNS real
    AS '$libdir/tsearch2', 'rank_cd'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.rank_cd(integer, tsvector, tsquery) OWNER TO freedb;

--
-- Name: rank_cd(integer, tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION rank_cd(integer, tsvector, tsquery, integer) RETURNS real
    AS '$libdir/tsearch2', 'rank_cd'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.rank_cd(integer, tsvector, tsquery, integer) OWNER TO freedb;

--
-- Name: rank_cd(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION rank_cd(tsvector, tsquery) RETURNS real
    AS '$libdir/tsearch2', 'rank_cd_def'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.rank_cd(tsvector, tsquery) OWNER TO freedb;

--
-- Name: rank_cd(tsvector, tsquery, integer); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION rank_cd(tsvector, tsquery, integer) RETURNS real
    AS '$libdir/tsearch2', 'rank_cd_def'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.rank_cd(tsvector, tsquery, integer) OWNER TO freedb;

--
-- Name: reset_tsearch(); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION reset_tsearch() RETURNS void
    AS '$libdir/tsearch2', 'reset_tsearch'
    LANGUAGE c STRICT;


ALTER FUNCTION public.reset_tsearch() OWNER TO freedb;

--
-- Name: rexectsq(tsquery, tsvector); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION rexectsq(tsquery, tsvector) RETURNS boolean
    AS '$libdir/tsearch2', 'rexectsq'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.rexectsq(tsquery, tsvector) OWNER TO freedb;

--
-- Name: FUNCTION rexectsq(tsquery, tsvector); Type: COMMENT; Schema: public; Owner: freedb
--

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


--
-- Name: set_curcfg(integer); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION set_curcfg(integer) RETURNS void
    AS '$libdir/tsearch2', 'set_curcfg'
    LANGUAGE c STRICT;


ALTER FUNCTION public.set_curcfg(integer) OWNER TO freedb;

--
-- Name: set_curcfg(text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION set_curcfg(text) RETURNS void
    AS '$libdir/tsearch2', 'set_curcfg_byname'
    LANGUAGE c STRICT;


ALTER FUNCTION public.set_curcfg(text) OWNER TO freedb;

--
-- Name: set_curdict(integer); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION set_curdict(integer) RETURNS void
    AS '$libdir/tsearch2', 'set_curdict'
    LANGUAGE c STRICT;


ALTER FUNCTION public.set_curdict(integer) OWNER TO freedb;

--
-- Name: set_curdict(text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION set_curdict(text) RETURNS void
    AS '$libdir/tsearch2', 'set_curdict_byname'
    LANGUAGE c STRICT;


ALTER FUNCTION public.set_curdict(text) OWNER TO freedb;

--
-- Name: set_curprs(integer); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION set_curprs(integer) RETURNS void
    AS '$libdir/tsearch2', 'set_curprs'
    LANGUAGE c STRICT;


ALTER FUNCTION public.set_curprs(integer) OWNER TO freedb;

--
-- Name: set_curprs(text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION set_curprs(text) RETURNS void
    AS '$libdir/tsearch2', 'set_curprs_byname'
    LANGUAGE c STRICT;


ALTER FUNCTION public.set_curprs(text) OWNER TO freedb;

--
-- Name: setweight(tsvector, "char"); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION setweight(tsvector, "char") RETURNS tsvector
    AS '$libdir/tsearch2', 'setweight'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.setweight(tsvector, "char") OWNER TO freedb;

--
-- Name: show_curcfg(); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION show_curcfg() RETURNS oid
    AS '$libdir/tsearch2', 'show_curcfg'
    LANGUAGE c STRICT;


ALTER FUNCTION public.show_curcfg() OWNER TO freedb;

--
-- Name: snb_en_init(internal); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.snb_en_init(internal) OWNER TO freedb;

--
-- Name: snb_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.snb_lexize(internal, internal, integer) OWNER TO freedb;

--
-- Name: snb_ru_init(internal); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.snb_ru_init(internal) OWNER TO freedb;

--
-- Name: spell_init(internal); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.spell_init(internal) OWNER TO freedb;

--
-- Name: spell_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.spell_lexize(internal, internal, integer) OWNER TO freedb;

--
-- Name: stat(text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION stat(text) RETURNS SETOF statinfo
    AS '$libdir/tsearch2', 'ts_stat'
    LANGUAGE c STRICT;


ALTER FUNCTION public.stat(text) OWNER TO freedb;

--
-- Name: stat(text, text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION stat(text, text) RETURNS SETOF statinfo
    AS '$libdir/tsearch2', 'ts_stat'
    LANGUAGE c STRICT;


ALTER FUNCTION public.stat(text, text) OWNER TO freedb;

--
-- Name: strip(tsvector); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION strip(tsvector) RETURNS tsvector
    AS '$libdir/tsearch2', 'strip'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.strip(tsvector) OWNER TO freedb;

--
-- Name: syn_init(internal); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.syn_init(internal) OWNER TO freedb;

--
-- Name: syn_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.syn_lexize(internal, internal, integer) OWNER TO freedb;

--
-- Name: to_tsquery(oid, text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION to_tsquery(oid, text) RETURNS tsquery
    AS '$libdir/tsearch2', 'to_tsquery'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.to_tsquery(oid, text) OWNER TO freedb;

--
-- Name: to_tsquery(text, text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION to_tsquery(text, text) RETURNS tsquery
    AS '$libdir/tsearch2', 'to_tsquery_name'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.to_tsquery(text, text) OWNER TO freedb;

--
-- Name: to_tsquery(text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION to_tsquery(text) RETURNS tsquery
    AS '$libdir/tsearch2', 'to_tsquery_current'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.to_tsquery(text) OWNER TO freedb;

--
-- Name: to_tsvector(oid, text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION to_tsvector(oid, text) RETURNS tsvector
    AS '$libdir/tsearch2', 'to_tsvector'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.to_tsvector(oid, text) OWNER TO freedb;

--
-- Name: to_tsvector(text, text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION to_tsvector(text, text) RETURNS tsvector
    AS '$libdir/tsearch2', 'to_tsvector_name'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.to_tsvector(text, text) OWNER TO freedb;

--
-- Name: to_tsvector(text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION to_tsvector(text) RETURNS tsvector
    AS '$libdir/tsearch2', 'to_tsvector_current'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.to_tsvector(text) OWNER TO freedb;

--
-- Name: token_type(integer); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION token_type(integer) RETURNS SETOF tokentype
    AS '$libdir/tsearch2', 'token_type'
    LANGUAGE c STRICT;


ALTER FUNCTION public.token_type(integer) OWNER TO freedb;

--
-- Name: token_type(text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION token_type(text) RETURNS SETOF tokentype
    AS '$libdir/tsearch2', 'token_type_byname'
    LANGUAGE c STRICT;


ALTER FUNCTION public.token_type(text) OWNER TO freedb;

--
-- Name: token_type(); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION token_type() RETURNS SETOF tokentype
    AS '$libdir/tsearch2', 'token_type_current'
    LANGUAGE c STRICT;


ALTER FUNCTION public.token_type() OWNER TO freedb;

--
-- Name: ts_debug(text); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION ts_debug(text) RETURNS SETOF tsdebug
    AS $_$
select 
        m.ts_name,
        t.alias as tok_type,
        t.descr as description,
        p.token,
        m.dict_name,
        strip(to_tsvector(p.token)) as tsvector
from
        parse( _get_parser_from_curcfg(), $1 ) as p,
        token_type() as t,
        pg_ts_cfgmap as m,
        pg_ts_cfg as c
where
        t.tokid=p.tokid and
        t.alias = m.tok_alias and 
        m.ts_name=c.ts_name and 
        c.oid=show_curcfg() 
$_$
    LANGUAGE sql STRICT;


ALTER FUNCTION public.ts_debug(text) OWNER TO freedb;

--
-- Name: tsearch2(); Type: FUNCTION; Schema: public; Owner: freedb
--

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


ALTER FUNCTION public.tsearch2() OWNER TO freedb;

--
-- Name: tsvector_cmp(tsvector, tsvector); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION tsvector_cmp(tsvector, tsvector) RETURNS integer
    AS '$libdir/tsearch2', 'tsvector_cmp'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.tsvector_cmp(tsvector, tsvector) OWNER TO freedb;

--
-- Name: tsvector_eq(tsvector, tsvector); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION tsvector_eq(tsvector, tsvector) RETURNS boolean
    AS '$libdir/tsearch2', 'tsvector_eq'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.tsvector_eq(tsvector, tsvector) OWNER TO freedb;

--
-- Name: tsvector_ge(tsvector, tsvector); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION tsvector_ge(tsvector, tsvector) RETURNS boolean
    AS '$libdir/tsearch2', 'tsvector_ge'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.tsvector_ge(tsvector, tsvector) OWNER TO freedb;

--
-- Name: tsvector_gt(tsvector, tsvector); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION tsvector_gt(tsvector, tsvector) RETURNS boolean
    AS '$libdir/tsearch2', 'tsvector_gt'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.tsvector_gt(tsvector, tsvector) OWNER TO freedb;

--
-- Name: tsvector_le(tsvector, tsvector); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION tsvector_le(tsvector, tsvector) RETURNS boolean
    AS '$libdir/tsearch2', 'tsvector_le'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.tsvector_le(tsvector, tsvector) OWNER TO freedb;

--
-- Name: tsvector_lt(tsvector, tsvector); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION tsvector_lt(tsvector, tsvector) RETURNS boolean
    AS '$libdir/tsearch2', 'tsvector_lt'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.tsvector_lt(tsvector, tsvector) OWNER TO freedb;

--
-- Name: tsvector_ne(tsvector, tsvector); Type: FUNCTION; Schema: public; Owner: freedb
--

CREATE FUNCTION tsvector_ne(tsvector, tsvector) RETURNS boolean
    AS '$libdir/tsearch2', 'tsvector_ne'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.tsvector_ne(tsvector, tsvector) OWNER TO freedb;

--
-- Name: <; Type: OPERATOR; Schema: public; Owner: freedb
--

CREATE OPERATOR < (
    PROCEDURE = tsvector_lt,
    LEFTARG = tsvector,
    RIGHTARG = tsvector,
    COMMUTATOR = >,
    NEGATOR = >=,
    RESTRICT = contsel,
    JOIN = contjoinsel
);


ALTER OPERATOR public.< (tsvector, tsvector) OWNER TO freedb;

--
-- Name: <=; Type: OPERATOR; Schema: public; Owner: freedb
--

CREATE OPERATOR <= (
    PROCEDURE = tsvector_le,
    LEFTARG = tsvector,
    RIGHTARG = tsvector,
    COMMUTATOR = >=,
    NEGATOR = >,
    RESTRICT = contsel,
    JOIN = contjoinsel
);


ALTER OPERATOR public.<= (tsvector, tsvector) OWNER TO freedb;

--
-- Name: <>; Type: OPERATOR; Schema: public; Owner: freedb
--

CREATE OPERATOR <> (
    PROCEDURE = tsvector_ne,
    LEFTARG = tsvector,
    RIGHTARG = tsvector,
    COMMUTATOR = <>,
    NEGATOR = =,
    RESTRICT = neqsel,
    JOIN = neqjoinsel
);


ALTER OPERATOR public.<> (tsvector, tsvector) OWNER TO freedb;

--
-- Name: =; Type: OPERATOR; Schema: public; Owner: freedb
--

CREATE OPERATOR = (
    PROCEDURE = tsvector_eq,
    LEFTARG = tsvector,
    RIGHTARG = tsvector,
    COMMUTATOR = =,
    NEGATOR = <>,
    RESTRICT = eqsel,
    JOIN = eqjoinsel,
    SORT1 = <,
    SORT2 = <,
    LTCMP = <,
    GTCMP = >
);


ALTER OPERATOR public.= (tsvector, tsvector) OWNER TO freedb;

--
-- Name: >; Type: OPERATOR; Schema: public; Owner: freedb
--

CREATE OPERATOR > (
    PROCEDURE = tsvector_gt,
    LEFTARG = tsvector,
    RIGHTARG = tsvector,
    COMMUTATOR = <,
    NEGATOR = <=,
    RESTRICT = contsel,
    JOIN = contjoinsel
);


ALTER OPERATOR public.> (tsvector, tsvector) OWNER TO freedb;

--
-- Name: >=; Type: OPERATOR; Schema: public; Owner: freedb
--

CREATE OPERATOR >= (
    PROCEDURE = tsvector_ge,
    LEFTARG = tsvector,
    RIGHTARG = tsvector,
    COMMUTATOR = <=,
    NEGATOR = <,
    RESTRICT = contsel,
    JOIN = contjoinsel
);


ALTER OPERATOR public.>= (tsvector, tsvector) OWNER TO freedb;

--
-- Name: @@; Type: OPERATOR; Schema: public; Owner: freedb
--

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


ALTER OPERATOR public.@@ (tsvector, tsquery) OWNER TO freedb;

--
-- Name: @@; Type: OPERATOR; Schema: public; Owner: freedb
--

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


ALTER OPERATOR public.@@ (tsquery, tsvector) OWNER TO freedb;

--
-- Name: ||; Type: OPERATOR; Schema: public; Owner: freedb
--

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


ALTER OPERATOR public.|| (tsvector, tsvector) OWNER TO freedb;

--
-- Name: gist_tsvector_ops; Type: OPERATOR CLASS; Schema: public; Owner: freedb
--

CREATE OPERATOR CLASS gist_tsvector_ops
    DEFAULT FOR TYPE tsvector USING gist AS
    STORAGE gtsvector ,
    OPERATOR 1 @@(tsvector,tsquery) RECHECK ,
    FUNCTION 1 gtsvector_consistent(gtsvector,internal,integer) ,
    FUNCTION 2 gtsvector_union(internal,internal) ,
    FUNCTION 3 gtsvector_compress(internal) ,
    FUNCTION 4 gtsvector_decompress(internal) ,
    FUNCTION 5 gtsvector_penalty(internal,internal,internal) ,
    FUNCTION 6 gtsvector_picksplit(internal,internal) ,
    FUNCTION 7 gtsvector_same(gtsvector,gtsvector,internal);


ALTER OPERATOR CLASS public.gist_tsvector_ops USING gist OWNER TO freedb;

--
-- Name: tsvector_ops; Type: OPERATOR CLASS; Schema: public; Owner: freedb
--

CREATE OPERATOR CLASS tsvector_ops
    DEFAULT FOR TYPE tsvector USING btree AS
    OPERATOR 1 <(tsvector,tsvector) ,
    OPERATOR 2 <=(tsvector,tsvector) ,
    OPERATOR 3 =(tsvector,tsvector) ,
    OPERATOR 4 >=(tsvector,tsvector) ,
    OPERATOR 5 >(tsvector,tsvector) ,
    FUNCTION 1 tsvector_cmp(tsvector,tsvector);


ALTER OPERATOR CLASS public.tsvector_ops USING btree OWNER TO freedb;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: artist; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE artist (
    artistid serial NOT NULL,
    artist text NOT NULL,
    idxftiartist tsvector
);
ALTER TABLE ONLY artist ALTER COLUMN artist SET STATISTICS 40;


ALTER TABLE public.artist OWNER TO freedb;

--
-- Name: badfile; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE badfile (
    categoryid integer NOT NULL,
    filename character varying(255),
    problem character varying(255)
);


ALTER TABLE public.badfile OWNER TO freedb;

--
-- Name: category; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE category (
    categoryid serial NOT NULL,
    category text,
    numbercds integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.category OWNER TO freedb;

--
-- Name: cd; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE cd (
    cdid serial NOT NULL,
    cddbid bit(32) NOT NULL,
    categoryid integer NOT NULL,
    title text NOT NULL,
    revision integer NOT NULL,
    genreid integer,
    extd text,
    disclen integer NOT NULL,
    "year" integer,
    submitted_via text,
    "timestamp" timestamp without time zone DEFAULT '2005-12-21 14:42:01.552268'::timestamp without time zone NOT NULL,
    numtracks smallint,
    frame_offsets integer[],
    idxftititle tsvector
);


ALTER TABLE public.cd OWNER TO freedb;

--
-- Name: cd_artist; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE cd_artist (
    cdid integer NOT NULL,
    artistnumber integer NOT NULL,
    artistid integer NOT NULL,
    roleid integer NOT NULL
);


ALTER TABLE public.cd_artist OWNER TO freedb;

--
-- Name: cddbalias; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE cddbalias (
    cdid integer NOT NULL,
    aliasid bit(32) NOT NULL
);


ALTER TABLE public.cddbalias OWNER TO freedb;

--
-- Name: comment; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE "comment" (
    cdid integer NOT NULL,
    commentnumber integer NOT NULL,
    "comment" text
);


ALTER TABLE public."comment" OWNER TO freedb;

--
-- Name: dupartist; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE dupartist (
    cddbid bit(32),
    artistid integer,
    count bigint
);


ALTER TABLE public.dupartist OWNER TO freedb;

--
-- Name: dupartistlist; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE dupartistlist (
    cddbid text,
    title text,
    artist text,
    category text,
    count bigint
);


ALTER TABLE public.dupartistlist OWNER TO freedb;

--
-- Name: dupartistlist2; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE dupartistlist2 (
    cddbid text,
    title text,
    artist text,
    category text,
    count bigint
);


ALTER TABLE public.dupartistlist2 OWNER TO freedb;

--
-- Name: duptitle; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE duptitle (
    cddbid bit(32),
    title text,
    count bigint
);


ALTER TABLE public.duptitle OWNER TO freedb;

--
-- Name: duptitleartist; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE duptitleartist (
    cddbid bit(32),
    title text,
    artistid integer,
    count bigint
);


ALTER TABLE public.duptitleartist OWNER TO freedb;

--
-- Name: duptitleartistlist; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE duptitleartistlist (
    count bigint,
    cddbid text,
    title text,
    artist text,
    category text
);


ALTER TABLE public.duptitleartistlist OWNER TO freedb;

--
-- Name: duptitlelist; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE duptitlelist (
    cddbid text,
    title text,
    artist text,
    category text,
    count bigint
);


ALTER TABLE public.duptitlelist OWNER TO freedb;

--
-- Name: duptitlelist2; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE duptitlelist2 (
    cddbid text,
    title text,
    artist text,
    category text,
    count bigint
);


ALTER TABLE public.duptitlelist2 OWNER TO freedb;

--
-- Name: genre; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE genre (
    genreid serial NOT NULL,
    genre text,
    idxftigenre tsvector
);


ALTER TABLE public.genre OWNER TO freedb;

SET default_with_oids = true;

--
-- Name: pg_ts_cfg; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE pg_ts_cfg (
    ts_name text NOT NULL,
    prs_name text NOT NULL,
    locale text
);


ALTER TABLE public.pg_ts_cfg OWNER TO freedb;

--
-- Name: pg_ts_cfgmap; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE pg_ts_cfgmap (
    ts_name text NOT NULL,
    tok_alias text NOT NULL,
    dict_name text[]
);


ALTER TABLE public.pg_ts_cfgmap OWNER TO freedb;

--
-- Name: pg_ts_dict; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

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


ALTER TABLE public.pg_ts_dict OWNER TO freedb;

--
-- Name: pg_ts_parser; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

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


ALTER TABLE public.pg_ts_parser OWNER TO freedb;

SET default_with_oids = false;

--
-- Name: popartist; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE popartist (
    artistid integer,
    count bigint
);


ALTER TABLE public.popartist OWNER TO freedb;

--
-- Name: poptitle; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE poptitle (
    title text,
    count bigint
);


ALTER TABLE public.poptitle OWNER TO freedb;

--
-- Name: role; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE "role" (
    roleid serial NOT NULL,
    "role" text
);


ALTER TABLE public."role" OWNER TO freedb;

--
-- Name: track; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE track (
    trackid serial NOT NULL,
    cdid integer NOT NULL,
    trackno integer NOT NULL,
    frame_offset integer NOT NULL,
    title text NOT NULL,
    extt text,
    idxftititle tsvector
);


ALTER TABLE public.track OWNER TO freedb;

--
-- Name: track_artist; Type: TABLE; Schema: public; Owner: freedb; Tablespace: 
--

CREATE TABLE track_artist (
    trackid integer NOT NULL,
    artistnumber integer NOT NULL,
    artistid integer NOT NULL,
    roleid integer NOT NULL
);


ALTER TABLE public.track_artist OWNER TO freedb;

--
-- Name: artist_artist_key; Type: CONSTRAINT; Schema: public; Owner: freedb; Tablespace: 
--

ALTER TABLE ONLY artist
    ADD CONSTRAINT artist_artist_key UNIQUE (artist);


--
-- Name: artist_pkey; Type: CONSTRAINT; Schema: public; Owner: freedb; Tablespace: 
--

ALTER TABLE ONLY artist
    ADD CONSTRAINT artist_pkey PRIMARY KEY (artistid);


--
-- Name: category_pkey; Type: CONSTRAINT; Schema: public; Owner: freedb; Tablespace: 
--

ALTER TABLE ONLY category
    ADD CONSTRAINT category_pkey PRIMARY KEY (categoryid);


--
-- Name: cd_pkey; Type: CONSTRAINT; Schema: public; Owner: freedb; Tablespace: 
--

ALTER TABLE ONLY cd
    ADD CONSTRAINT cd_pkey PRIMARY KEY (cdid);


--
-- Name: genre_genre_key; Type: CONSTRAINT; Schema: public; Owner: freedb; Tablespace: 
--

ALTER TABLE ONLY genre
    ADD CONSTRAINT genre_genre_key UNIQUE (genre);


--
-- Name: genre_pkey; Type: CONSTRAINT; Schema: public; Owner: freedb; Tablespace: 
--

ALTER TABLE ONLY genre
    ADD CONSTRAINT genre_pkey PRIMARY KEY (genreid);


--
-- Name: pg_ts_cfg_pkey; Type: CONSTRAINT; Schema: public; Owner: freedb; Tablespace: 
--

ALTER TABLE ONLY pg_ts_cfg
    ADD CONSTRAINT pg_ts_cfg_pkey PRIMARY KEY (ts_name);


--
-- Name: pg_ts_cfgmap_pkey; Type: CONSTRAINT; Schema: public; Owner: freedb; Tablespace: 
--

ALTER TABLE ONLY pg_ts_cfgmap
    ADD CONSTRAINT pg_ts_cfgmap_pkey PRIMARY KEY (ts_name, tok_alias);


--
-- Name: pg_ts_dict_pkey; Type: CONSTRAINT; Schema: public; Owner: freedb; Tablespace: 
--

ALTER TABLE ONLY pg_ts_dict
    ADD CONSTRAINT pg_ts_dict_pkey PRIMARY KEY (dict_name);


--
-- Name: pg_ts_parser_pkey; Type: CONSTRAINT; Schema: public; Owner: freedb; Tablespace: 
--

ALTER TABLE ONLY pg_ts_parser
    ADD CONSTRAINT pg_ts_parser_pkey PRIMARY KEY (prs_name);


--
-- Name: role_pkey; Type: CONSTRAINT; Schema: public; Owner: freedb; Tablespace: 
--

ALTER TABLE ONLY "role"
    ADD CONSTRAINT role_pkey PRIMARY KEY (roleid);


--
-- Name: track_pkey; Type: CONSTRAINT; Schema: public; Owner: freedb; Tablespace: 
--

ALTER TABLE ONLY track
    ADD CONSTRAINT track_pkey PRIMARY KEY (trackid);


--
-- Name: artist_artist_lower; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE INDEX artist_artist_lower ON artist USING btree (lower(artist));


--
-- Name: artist_idxftiartist; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE INDEX artist_idxftiartist ON artist USING gist (idxftiartist);


--
-- Name: cd_artist_artistid; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE INDEX cd_artist_artistid ON cd_artist USING btree (artistid);


--
-- Name: cd_artist_artistid_artistnumber; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE INDEX cd_artist_artistid_artistnumber ON cd_artist USING btree (artistid, artistnumber);


--
-- Name: cd_artist_cd_artistnumber; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE UNIQUE INDEX cd_artist_cd_artistnumber ON cd_artist USING btree (cdid, artistnumber);


--
-- Name: cd_category; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE INDEX cd_category ON cd USING btree (categoryid);


--
-- Name: cd_cddbid_categoryid; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE UNIQUE INDEX cd_cddbid_categoryid ON cd USING btree (cddbid, categoryid);


--
-- Name: cd_idxftititle; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE INDEX cd_idxftititle ON cd USING gist (idxftititle);


--
-- Name: cd_numtracks_disclen; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE INDEX cd_numtracks_disclen ON cd USING btree (numtracks, disclen);


--
-- Name: cd_title_lower; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE INDEX cd_title_lower ON cd USING btree (lower(title));


--
-- Name: cddbalias_cdid; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE INDEX cddbalias_cdid ON cddbalias USING btree (cdid);


--
-- Name: comment_cdid_commentnumber; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE UNIQUE INDEX comment_cdid_commentnumber ON "comment" USING btree (cdid, commentnumber);


--
-- Name: duptitleartist_cddbid; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE INDEX duptitleartist_cddbid ON duptitleartist USING btree (cddbid);


--
-- Name: genre_idxftigenre; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE INDEX genre_idxftigenre ON genre USING gist (idxftigenre);


--
-- Name: popartist_count; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE INDEX popartist_count ON popartist USING btree (count);


--
-- Name: poptitle_count; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE INDEX poptitle_count ON poptitle USING btree (count);


--
-- Name: role_role; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE UNIQUE INDEX role_role ON "role" USING btree ("role");


--
-- Name: track_artist_artistid_artistnumber; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE INDEX track_artist_artistid_artistnumber ON track_artist USING btree (artistid, artistnumber);


--
-- Name: track_artist_trackid_artistnumber; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE UNIQUE INDEX track_artist_trackid_artistnumber ON track_artist USING btree (trackid, artistnumber);


--
-- Name: track_cdid_trackno; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE UNIQUE INDEX track_cdid_trackno ON track USING btree (cdid, trackno);


--
-- Name: track_title_lower; Type: INDEX; Schema: public; Owner: freedb; Tablespace: 
--

CREATE INDEX track_title_lower ON track USING btree (lower(title));


--
-- Name: artist_tsvectorupdate; Type: TRIGGER; Schema: public; Owner: freedb
--

CREATE TRIGGER artist_tsvectorupdate
    BEFORE INSERT OR UPDATE ON artist
    FOR EACH ROW
    EXECUTE PROCEDURE tsearch2('idxftiartist', 'artist');


--
-- Name: cd_tsvectorupdate; Type: TRIGGER; Schema: public; Owner: freedb
--

CREATE TRIGGER cd_tsvectorupdate
    BEFORE INSERT OR UPDATE ON cd
    FOR EACH ROW
    EXECUTE PROCEDURE tsearch2('idxftititle', 'title');


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

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


--
-- PostgreSQL database dump complete
--