xo.txt

--
-- PostgreSQL database dump
--

-- Started on 2013-11-22 03:58:45 VET

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- TOC entry 808 (class 2612 OID 16578)
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: j30
--

CREATE PROCEDURAL LANGUAGE plpgsql;


ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO j30;

SET search_path = public, pg_catalog;

--
-- TOC entry 255 (class 1255 OID 17694)
-- Dependencies: 808 3
-- Name: soundex(text); Type: FUNCTION; Schema: public; Owner: j30
--

CREATE FUNCTION soundex(input text) RETURNS text
    LANGUAGE plpgsql IMMUTABLE STRICT COST 500
    AS $$
DECLARE
  soundex text = '';
  char text;
  symbol text;
  last_symbol text = '';
  pos int = 1;
BEGIN
  WHILE length(soundex) < 4 LOOP
    char = upper(substr(input, pos, 1));
    pos = pos + 1;
    CASE char
    WHEN '' THEN
      -- End of input string
      IF soundex = '' THEN
        RETURN '';
      ELSE
        RETURN rpad(soundex, 4, '0');
      END IF;
    WHEN 'B', 'F', 'P', 'V' THEN
      symbol = '1';
    WHEN 'C', 'G', 'J', 'K', 'Q', 'S', 'X', 'Z' THEN
      symbol = '2';
    WHEN 'D', 'T' THEN
      symbol = '3';
    WHEN 'L' THEN
      symbol = '4';
    WHEN 'M', 'N' THEN
      symbol = '5';
    WHEN 'R' THEN
      symbol = '6';
    ELSE
      -- Not a consonant; no output, but next similar consonant will be re-recorded
      symbol = '';
    END CASE;

    IF soundex = '' THEN
      -- First character; only accept strictly English ASCII characters
      IF char ~>=~ 'A' AND char ~<=~ 'Z' THEN
        soundex = char;
        last_symbol = symbol;
      END IF;
    ELSIF last_symbol != symbol THEN
      soundex = soundex || symbol;
      last_symbol = symbol;
    END IF;
  END LOOP;

  RETURN soundex;
END;
$$;


ALTER FUNCTION public.soundex(input text) OWNER TO j30;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 141 (class 1259 OID 16581)
-- Dependencies: 2140 2141 2142 3
-- Name: xfv02_assets; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_assets (
    id integer NOT NULL,
    parent_id bigint DEFAULT 0 NOT NULL,
    lft bigint DEFAULT 0 NOT NULL,
    rgt bigint DEFAULT 0 NOT NULL,
    level integer NOT NULL,
    name character varying(50) NOT NULL,
    title character varying(100) NOT NULL,
    rules character varying(5120) NOT NULL
);


ALTER TABLE public.xfv02_assets OWNER TO j30;

--
-- TOC entry 2895 (class 0 OID 0)
-- Dependencies: 141
-- Name: COLUMN xfv02_assets.id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_assets.id IS 'Primary Key';


--
-- TOC entry 2896 (class 0 OID 0)
-- Dependencies: 141
-- Name: COLUMN xfv02_assets.parent_id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_assets.parent_id IS 'Nested set parent.';


--
-- TOC entry 2897 (class 0 OID 0)
-- Dependencies: 141
-- Name: COLUMN xfv02_assets.lft; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_assets.lft IS 'Nested set lft.';


--
-- TOC entry 2898 (class 0 OID 0)
-- Dependencies: 141
-- Name: COLUMN xfv02_assets.rgt; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_assets.rgt IS 'Nested set rgt.';


--
-- TOC entry 2899 (class 0 OID 0)
-- Dependencies: 141
-- Name: COLUMN xfv02_assets.level; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_assets.level IS 'The cached level in the nested tree.';


--
-- TOC entry 2900 (class 0 OID 0)
-- Dependencies: 141
-- Name: COLUMN xfv02_assets.name; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_assets.name IS 'The unique name for the asset.';


--
-- TOC entry 2901 (class 0 OID 0)
-- Dependencies: 141
-- Name: COLUMN xfv02_assets.title; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_assets.title IS 'The descriptive title for the asset.';


--
-- TOC entry 2902 (class 0 OID 0)
-- Dependencies: 141
-- Name: COLUMN xfv02_assets.rules; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_assets.rules IS 'JSON encoded access control.';


--
-- TOC entry 140 (class 1259 OID 16579)
-- Dependencies: 141 3
-- Name: xfv02_assets_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_assets_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_assets_id_seq OWNER TO j30;

--
-- TOC entry 2903 (class 0 OID 0)
-- Dependencies: 140
-- Name: xfv02_assets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_assets_id_seq OWNED BY xfv02_assets.id;


--
-- TOC entry 142 (class 1259 OID 16597)
-- Dependencies: 3
-- Name: xfv02_associations; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_associations (
    id bigint NOT NULL,
    context character varying(50) NOT NULL,
    key character(32) NOT NULL
);


ALTER TABLE public.xfv02_associations OWNER TO j30;

--
-- TOC entry 2904 (class 0 OID 0)
-- Dependencies: 142
-- Name: COLUMN xfv02_associations.id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_associations.id IS 'A reference to the associated item.';


--
-- TOC entry 2905 (class 0 OID 0)
-- Dependencies: 142
-- Name: COLUMN xfv02_associations.context; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_associations.context IS 'The context of the associated item.';


--
-- TOC entry 2906 (class 0 OID 0)
-- Dependencies: 142
-- Name: COLUMN xfv02_associations.key; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_associations.key IS 'The key for the association computed from an md5 on associated ids.';


--
-- TOC entry 146 (class 1259 OID 16650)
-- Dependencies: 2174 2175 2176 2177 2178 2179 2180 2181 2182 2183 2184 3
-- Name: xfv02_banner_clients; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_banner_clients (
    id integer NOT NULL,
    name character varying(255) DEFAULT ''::character varying NOT NULL,
    contact character varying(255) DEFAULT ''::character varying NOT NULL,
    email character varying(255) DEFAULT ''::character varying NOT NULL,
    extrainfo text NOT NULL,
    state smallint DEFAULT 0 NOT NULL,
    checked_out bigint DEFAULT 0 NOT NULL,
    checked_out_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    metakey text NOT NULL,
    own_prefix smallint DEFAULT 0 NOT NULL,
    metakey_prefix character varying(255) DEFAULT ''::character varying NOT NULL,
    purchase_type smallint DEFAULT (-1) NOT NULL,
    track_clicks smallint DEFAULT (-1) NOT NULL,
    track_impressions smallint DEFAULT (-1) NOT NULL
);


ALTER TABLE public.xfv02_banner_clients OWNER TO j30;

--
-- TOC entry 145 (class 1259 OID 16648)
-- Dependencies: 146 3
-- Name: xfv02_banner_clients_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_banner_clients_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_banner_clients_id_seq OWNER TO j30;

--
-- TOC entry 2907 (class 0 OID 0)
-- Dependencies: 145
-- Name: xfv02_banner_clients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_banner_clients_id_seq OWNED BY xfv02_banner_clients.id;


--
-- TOC entry 147 (class 1259 OID 16672)
-- Dependencies: 2185 3
-- Name: xfv02_banner_tracks; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_banner_tracks (
    track_date timestamp without time zone NOT NULL,
    track_type bigint NOT NULL,
    banner_id bigint NOT NULL,
    count bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.xfv02_banner_tracks OWNER TO j30;

--
-- TOC entry 144 (class 1259 OID 16605)
-- Dependencies: 2144 2145 2146 2147 2148 2149 2150 2151 2152 2153 2154 2155 2156 2157 2158 2159 2160 2161 2162 2163 2164 2165 2166 2167 2168 2169 2170 2171 2172 3
-- Name: xfv02_banners; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_banners (
    id integer NOT NULL,
    cid bigint DEFAULT 0 NOT NULL,
    type bigint DEFAULT 0 NOT NULL,
    name character varying(255) DEFAULT ''::character varying NOT NULL,
    alias character varying(255) DEFAULT ''::character varying NOT NULL,
    imptotal bigint DEFAULT 0 NOT NULL,
    impmade bigint DEFAULT 0 NOT NULL,
    clicks bigint DEFAULT 0 NOT NULL,
    clickurl character varying(200) DEFAULT ''::character varying NOT NULL,
    state smallint DEFAULT 0 NOT NULL,
    catid bigint DEFAULT 0 NOT NULL,
    description text NOT NULL,
    custombannercode character varying(2048) NOT NULL,
    sticky smallint DEFAULT 0 NOT NULL,
    ordering bigint DEFAULT 0 NOT NULL,
    metakey text NOT NULL,
    params text NOT NULL,
    own_prefix smallint DEFAULT 0 NOT NULL,
    metakey_prefix character varying(255) DEFAULT ''::character varying NOT NULL,
    purchase_type smallint DEFAULT (-1) NOT NULL,
    track_clicks smallint DEFAULT (-1) NOT NULL,
    track_impressions smallint DEFAULT (-1) NOT NULL,
    checked_out bigint DEFAULT 0 NOT NULL,
    checked_out_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    publish_up timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    publish_down timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    reset timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    created timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    language character varying(7) DEFAULT ''::character varying NOT NULL,
    created_by bigint DEFAULT 0 NOT NULL,
    created_by_alias character varying(255) DEFAULT ''::character varying NOT NULL,
    modified timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    modified_by bigint DEFAULT 0 NOT NULL,
    version bigint DEFAULT 1 NOT NULL
);


ALTER TABLE public.xfv02_banners OWNER TO j30;

--
-- TOC entry 143 (class 1259 OID 16603)
-- Dependencies: 144 3
-- Name: xfv02_banners_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_banners_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_banners_id_seq OWNER TO j30;

--
-- TOC entry 2908 (class 0 OID 0)
-- Dependencies: 143
-- Name: xfv02_banners_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_banners_id_seq OWNED BY xfv02_banners.id;


--
-- TOC entry 149 (class 1259 OID 16683)
-- Dependencies: 2187 2188 2189 2190 2191 2192 2193 2194 2195 2196 2197 2198 2199 2200 2201 2202 2203 2204 2205 2206 2207 3
-- Name: xfv02_categories; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_categories (
    id integer NOT NULL,
    asset_id bigint DEFAULT 0 NOT NULL,
    parent_id integer DEFAULT 0 NOT NULL,
    lft bigint DEFAULT 0 NOT NULL,
    rgt bigint DEFAULT 0 NOT NULL,
    level integer DEFAULT 0 NOT NULL,
    path character varying(255) DEFAULT ''::character varying NOT NULL,
    extension character varying(50) DEFAULT ''::character varying NOT NULL,
    title character varying(255) NOT NULL,
    alias character varying(255) DEFAULT ''::character varying NOT NULL,
    note character varying(255) DEFAULT ''::character varying NOT NULL,
    description text DEFAULT ''::text NOT NULL,
    published smallint DEFAULT 0 NOT NULL,
    checked_out bigint DEFAULT 0 NOT NULL,
    checked_out_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    access bigint DEFAULT 0 NOT NULL,
    params text NOT NULL,
    metadesc character varying(1024) NOT NULL,
    metakey character varying(1024) NOT NULL,
    metadata character varying(2048) NOT NULL,
    created_user_id integer DEFAULT 0 NOT NULL,
    created_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    modified_user_id integer DEFAULT 0 NOT NULL,
    modified_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    hits integer DEFAULT 0 NOT NULL,
    language character varying(7) DEFAULT ''::character varying NOT NULL,
    version bigint DEFAULT 1 NOT NULL
);


ALTER TABLE public.xfv02_categories OWNER TO j30;

--
-- TOC entry 2909 (class 0 OID 0)
-- Dependencies: 149
-- Name: COLUMN xfv02_categories.asset_id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_categories.asset_id IS 'FK to the #__assets table.';


--
-- TOC entry 2910 (class 0 OID 0)
-- Dependencies: 149
-- Name: COLUMN xfv02_categories.metadesc; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_categories.metadesc IS 'The meta description for the page.';


--
-- TOC entry 2911 (class 0 OID 0)
-- Dependencies: 149
-- Name: COLUMN xfv02_categories.metakey; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_categories.metakey IS 'The meta keywords for the page.';


--
-- TOC entry 2912 (class 0 OID 0)
-- Dependencies: 149
-- Name: COLUMN xfv02_categories.metadata; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_categories.metadata IS 'JSON encoded metadata properties.';


--
-- TOC entry 148 (class 1259 OID 16681)
-- Dependencies: 149 3
-- Name: xfv02_categories_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_categories_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_categories_id_seq OWNER TO j30;

--
-- TOC entry 2913 (class 0 OID 0)
-- Dependencies: 148
-- Name: xfv02_categories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_categories_id_seq OWNED BY xfv02_categories.id;


--
-- TOC entry 151 (class 1259 OID 16722)
-- Dependencies: 2209 2210 2211 2212 2213 2214 2215 2216 2217 2218 2219 2220 2221 2222 2223 2224 2225 2226 2227 2228 2229 2230 2231 2232 2233 2234 2235 2236 2237 2238 2239 2240 3
-- Name: xfv02_contact_details; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_contact_details (
    id integer NOT NULL,
    name character varying(255) DEFAULT ''::character varying NOT NULL,
    alias character varying(255) DEFAULT ''::character varying NOT NULL,
    con_position character varying(255) DEFAULT NULL::character varying,
    address text,
    suburb character varying(100) DEFAULT NULL::character varying,
    state character varying(100) DEFAULT NULL::character varying,
    country character varying(100) DEFAULT NULL::character varying,
    postcode character varying(100) DEFAULT NULL::character varying,
    telephone character varying(255) DEFAULT NULL::character varying,
    fax character varying(255) DEFAULT NULL::character varying,
    misc text,
    image character varying(255) DEFAULT NULL::character varying,
    email_to character varying(255) DEFAULT NULL::character varying,
    default_con smallint DEFAULT 0 NOT NULL,
    published smallint DEFAULT 0 NOT NULL,
    checked_out bigint DEFAULT 0 NOT NULL,
    checked_out_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    ordering bigint DEFAULT 0 NOT NULL,
    params text NOT NULL,
    user_id bigint DEFAULT 0 NOT NULL,
    catid bigint DEFAULT 0 NOT NULL,
    access bigint DEFAULT 0 NOT NULL,
    mobile character varying(255) DEFAULT ''::character varying NOT NULL,
    webpage character varying(255) DEFAULT ''::character varying NOT NULL,
    sortname1 character varying(255) NOT NULL,
    sortname2 character varying(255) NOT NULL,
    sortname3 character varying(255) NOT NULL,
    language character varying(7) DEFAULT ''::character varying NOT NULL,
    created timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    created_by integer DEFAULT 0 NOT NULL,
    created_by_alias character varying(255) DEFAULT ''::character varying NOT NULL,
    modified timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    modified_by integer DEFAULT 0 NOT NULL,
    metakey text NOT NULL,
    metadesc text NOT NULL,
    metadata text NOT NULL,
    featured smallint DEFAULT 0 NOT NULL,
    xreference character varying(50) NOT NULL,
    publish_up timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    publish_down timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    version bigint DEFAULT 1 NOT NULL,
    hits bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.xfv02_contact_details OWNER TO j30;

--
-- TOC entry 2914 (class 0 OID 0)
-- Dependencies: 151
-- Name: COLUMN xfv02_contact_details.featured; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_contact_details.featured IS 'Set if article is featured.';


--
-- TOC entry 2915 (class 0 OID 0)
-- Dependencies: 151
-- Name: COLUMN xfv02_contact_details.xreference; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_contact_details.xreference IS 'A reference to enable linkages to external data sets.';


--
-- TOC entry 150 (class 1259 OID 16720)
-- Dependencies: 3 151
-- Name: xfv02_contact_details_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_contact_details_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_contact_details_id_seq OWNER TO j30;

--
-- TOC entry 2916 (class 0 OID 0)
-- Dependencies: 150
-- Name: xfv02_contact_details_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_contact_details_id_seq OWNED BY xfv02_contact_details.id;


--
-- TOC entry 153 (class 1259 OID 16773)
-- Dependencies: 2242 2243 2244 2245 2246 2247 2248 2249 2250 2251 2252 2253 2254 2255 2256 2257 2258 2259 2260 2261 2262 3
-- Name: xfv02_content; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_content (
    id integer NOT NULL,
    asset_id bigint DEFAULT 0 NOT NULL,
    title character varying(255) DEFAULT ''::character varying NOT NULL,
    alias character varying(255) DEFAULT ''::character varying NOT NULL,
    introtext text NOT NULL,
    fulltext text NOT NULL,
    state smallint DEFAULT 0 NOT NULL,
    catid bigint DEFAULT 0 NOT NULL,
    created timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    created_by bigint DEFAULT 0 NOT NULL,
    created_by_alias character varying(255) DEFAULT ''::character varying NOT NULL,
    modified timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    modified_by bigint DEFAULT 0 NOT NULL,
    checked_out bigint DEFAULT 0 NOT NULL,
    checked_out_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    publish_up timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    publish_down timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    images text NOT NULL,
    urls text NOT NULL,
    attribs character varying(5120) NOT NULL,
    version bigint DEFAULT 1 NOT NULL,
    ordering bigint DEFAULT 0 NOT NULL,
    metakey text NOT NULL,
    metadesc text NOT NULL,
    access bigint DEFAULT 0 NOT NULL,
    hits bigint DEFAULT 0 NOT NULL,
    metadata text NOT NULL,
    featured smallint DEFAULT 0 NOT NULL,
    language character varying(7) DEFAULT ''::character varying NOT NULL,
    xreference character varying(50) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.xfv02_content OWNER TO j30;

--
-- TOC entry 2917 (class 0 OID 0)
-- Dependencies: 153
-- Name: COLUMN xfv02_content.asset_id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_content.asset_id IS 'FK to the #__assets table.';


--
-- TOC entry 2918 (class 0 OID 0)
-- Dependencies: 153
-- Name: COLUMN xfv02_content.featured; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_content.featured IS 'Set if article is featured.';


--
-- TOC entry 2919 (class 0 OID 0)
-- Dependencies: 153
-- Name: COLUMN xfv02_content.language; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_content.language IS 'The language code for the article.';


--
-- TOC entry 2920 (class 0 OID 0)
-- Dependencies: 153
-- Name: COLUMN xfv02_content.xreference; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_content.xreference IS 'A reference to enable linkages to external data sets.';


--
-- TOC entry 154 (class 1259 OID 16811)
-- Dependencies: 2263 2264 3
-- Name: xfv02_content_frontpage; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_content_frontpage (
    content_id bigint DEFAULT 0 NOT NULL,
    ordering bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.xfv02_content_frontpage OWNER TO j30;

--
-- TOC entry 152 (class 1259 OID 16771)
-- Dependencies: 153 3
-- Name: xfv02_content_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_content_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_content_id_seq OWNER TO j30;

--
-- TOC entry 2921 (class 0 OID 0)
-- Dependencies: 152
-- Name: xfv02_content_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_content_id_seq OWNED BY xfv02_content.id;


--
-- TOC entry 155 (class 1259 OID 16818)
-- Dependencies: 2265 2266 2267 2268 3
-- Name: xfv02_content_rating; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_content_rating (
    content_id bigint DEFAULT 0 NOT NULL,
    rating_sum bigint DEFAULT 0 NOT NULL,
    rating_count bigint DEFAULT 0 NOT NULL,
    lastip character varying(50) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.xfv02_content_rating OWNER TO j30;

--
-- TOC entry 157 (class 1259 OID 16829)
-- Dependencies: 2270 2271 2272 2273 2274 3
-- Name: xfv02_content_types; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_content_types (
    type_id integer NOT NULL,
    type_title character varying(255) DEFAULT ''::character varying NOT NULL,
    type_alias character varying(255) DEFAULT ''::character varying NOT NULL,
    "table" character varying(255) DEFAULT ''::character varying NOT NULL,
    rules text NOT NULL,
    field_mappings text NOT NULL,
    router character varying(255) DEFAULT ''::character varying NOT NULL,
    content_history_options character varying(5120) DEFAULT NULL::character varying
);


ALTER TABLE public.xfv02_content_types OWNER TO j30;

--
-- TOC entry 2922 (class 0 OID 0)
-- Dependencies: 157
-- Name: COLUMN xfv02_content_types.content_history_options; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_content_types.content_history_options IS 'JSON string for com_contenthistory options';


--
-- TOC entry 156 (class 1259 OID 16827)
-- Dependencies: 3 157
-- Name: xfv02_content_types_type_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_content_types_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_content_types_type_id_seq OWNER TO j30;

--
-- TOC entry 2923 (class 0 OID 0)
-- Dependencies: 156
-- Name: xfv02_content_types_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_content_types_type_id_seq OWNED BY xfv02_content_types.type_id;


--
-- TOC entry 158 (class 1259 OID 16844)
-- Dependencies: 2275 2276 3
-- Name: xfv02_contentitem_tag_map; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_contentitem_tag_map (
    type_alias character varying(255) DEFAULT ''::character varying NOT NULL,
    core_content_id integer NOT NULL,
    content_item_id integer NOT NULL,
    tag_id integer NOT NULL,
    tag_date timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    type_id integer NOT NULL
);


ALTER TABLE public.xfv02_contentitem_tag_map OWNER TO j30;

--
-- TOC entry 2924 (class 0 OID 0)
-- Dependencies: 158
-- Name: COLUMN xfv02_contentitem_tag_map.core_content_id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_contentitem_tag_map.core_content_id IS 'PK from the core content table';


--
-- TOC entry 2925 (class 0 OID 0)
-- Dependencies: 158
-- Name: COLUMN xfv02_contentitem_tag_map.content_item_id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_contentitem_tag_map.content_item_id IS 'PK from the content type table';


--
-- TOC entry 2926 (class 0 OID 0)
-- Dependencies: 158
-- Name: COLUMN xfv02_contentitem_tag_map.tag_id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_contentitem_tag_map.tag_id IS 'PK from the tag table';


--
-- TOC entry 2927 (class 0 OID 0)
-- Dependencies: 158
-- Name: COLUMN xfv02_contentitem_tag_map.tag_date; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_contentitem_tag_map.tag_date IS 'Date of most recent save for this tag-item';


--
-- TOC entry 2928 (class 0 OID 0)
-- Dependencies: 158
-- Name: COLUMN xfv02_contentitem_tag_map.type_id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_contentitem_tag_map.type_id IS 'PK from the content_type table';


--
-- TOC entry 159 (class 1259 OID 16856)
-- Dependencies: 2277 2278 3
-- Name: xfv02_core_log_searches; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_core_log_searches (
    search_term character varying(128) DEFAULT ''::character varying NOT NULL,
    hits bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.xfv02_core_log_searches OWNER TO j30;

--
-- TOC entry 161 (class 1259 OID 16863)
-- Dependencies: 2280 2281 2282 2283 2284 2285 2286 2287 2288 3
-- Name: xfv02_extensions; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_extensions (
    extension_id integer NOT NULL,
    name character varying(100) NOT NULL,
    type character varying(20) NOT NULL,
    element character varying(100) NOT NULL,
    folder character varying(100) NOT NULL,
    client_id smallint NOT NULL,
    enabled smallint DEFAULT 1 NOT NULL,
    access bigint DEFAULT 1 NOT NULL,
    protected smallint DEFAULT 0 NOT NULL,
    manifest_cache text NOT NULL,
    params text NOT NULL,
    custom_data text DEFAULT ''::text NOT NULL,
    system_data text DEFAULT ''::text NOT NULL,
    checked_out integer DEFAULT 0 NOT NULL,
    checked_out_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    ordering bigint DEFAULT 0,
    state bigint DEFAULT 0
);


ALTER TABLE public.xfv02_extensions OWNER TO j30;

--
-- TOC entry 160 (class 1259 OID 16861)
-- Dependencies: 161 3
-- Name: xfv02_extensions_extension_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_extensions_extension_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_extensions_extension_id_seq OWNER TO j30;

--
-- TOC entry 2929 (class 0 OID 0)
-- Dependencies: 160
-- Name: xfv02_extensions_extension_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_extensions_extension_id_seq OWNED BY xfv02_extensions.extension_id;


--
-- TOC entry 163 (class 1259 OID 16886)
-- Dependencies: 2290 2291 2292 2293 2294 2295 2296 3
-- Name: xfv02_finder_filters; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_filters (
    filter_id integer NOT NULL,
    title character varying(255) NOT NULL,
    alias character varying(255) NOT NULL,
    state smallint DEFAULT 1 NOT NULL,
    created timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    created_by integer NOT NULL,
    created_by_alias character varying(255) NOT NULL,
    modified timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    modified_by integer DEFAULT 0 NOT NULL,
    checked_out integer DEFAULT 0 NOT NULL,
    checked_out_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    map_count integer DEFAULT 0 NOT NULL,
    data text NOT NULL,
    params text
);


ALTER TABLE public.xfv02_finder_filters OWNER TO j30;

--
-- TOC entry 162 (class 1259 OID 16884)
-- Dependencies: 3 163
-- Name: xfv02_finder_filters_filter_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_finder_filters_filter_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_finder_filters_filter_id_seq OWNER TO j30;

--
-- TOC entry 2930 (class 0 OID 0)
-- Dependencies: 162
-- Name: xfv02_finder_filters_filter_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_finder_filters_filter_id_seq OWNED BY xfv02_finder_filters.filter_id;


--
-- TOC entry 165 (class 1259 OID 16904)
-- Dependencies: 2298 2299 2300 2301 2302 2303 2304 2305 2306 2307 2308 2309 2310 2311 3
-- Name: xfv02_finder_links; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_links (
    link_id integer NOT NULL,
    url character varying(255) NOT NULL,
    route character varying(255) NOT NULL,
    title character varying(255) DEFAULT NULL::character varying,
    description character varying(255) DEFAULT NULL::character varying,
    indexdate timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    md5sum character varying(32) DEFAULT NULL::character varying,
    published smallint DEFAULT 1 NOT NULL,
    state integer DEFAULT 1,
    access integer DEFAULT 0,
    language character varying(8) DEFAULT ''::character varying NOT NULL,
    publish_start_date timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    publish_end_date timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    start_date timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    end_date timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    list_price numeric(8,2) DEFAULT 0 NOT NULL,
    sale_price numeric(8,2) DEFAULT 0 NOT NULL,
    type_id bigint NOT NULL,
    object bytea NOT NULL
);


ALTER TABLE public.xfv02_finder_links OWNER TO j30;

--
-- TOC entry 164 (class 1259 OID 16902)
-- Dependencies: 3 165
-- Name: xfv02_finder_links_link_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_finder_links_link_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_finder_links_link_id_seq OWNER TO j30;

--
-- TOC entry 2931 (class 0 OID 0)
-- Dependencies: 164
-- Name: xfv02_finder_links_link_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_finder_links_link_id_seq OWNED BY xfv02_finder_links.link_id;


--
-- TOC entry 166 (class 1259 OID 16933)
-- Dependencies: 3
-- Name: xfv02_finder_links_terms0; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_links_terms0 (
    link_id integer NOT NULL,
    term_id integer NOT NULL,
    weight numeric(8,2) NOT NULL
);


ALTER TABLE public.xfv02_finder_links_terms0 OWNER TO j30;

--
-- TOC entry 167 (class 1259 OID 16940)
-- Dependencies: 3
-- Name: xfv02_finder_links_terms1; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_links_terms1 (
    link_id integer NOT NULL,
    term_id integer NOT NULL,
    weight numeric(8,2) NOT NULL
);


ALTER TABLE public.xfv02_finder_links_terms1 OWNER TO j30;

--
-- TOC entry 168 (class 1259 OID 16947)
-- Dependencies: 3
-- Name: xfv02_finder_links_terms2; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_links_terms2 (
    link_id integer NOT NULL,
    term_id integer NOT NULL,
    weight numeric(8,2) NOT NULL
);


ALTER TABLE public.xfv02_finder_links_terms2 OWNER TO j30;

--
-- TOC entry 169 (class 1259 OID 16954)
-- Dependencies: 3
-- Name: xfv02_finder_links_terms3; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_links_terms3 (
    link_id integer NOT NULL,
    term_id integer NOT NULL,
    weight numeric(8,2) NOT NULL
);


ALTER TABLE public.xfv02_finder_links_terms3 OWNER TO j30;

--
-- TOC entry 170 (class 1259 OID 16961)
-- Dependencies: 3
-- Name: xfv02_finder_links_terms4; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_links_terms4 (
    link_id integer NOT NULL,
    term_id integer NOT NULL,
    weight numeric(8,2) NOT NULL
);


ALTER TABLE public.xfv02_finder_links_terms4 OWNER TO j30;

--
-- TOC entry 171 (class 1259 OID 16968)
-- Dependencies: 3
-- Name: xfv02_finder_links_terms5; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_links_terms5 (
    link_id integer NOT NULL,
    term_id integer NOT NULL,
    weight numeric(8,2) NOT NULL
);


ALTER TABLE public.xfv02_finder_links_terms5 OWNER TO j30;

--
-- TOC entry 172 (class 1259 OID 16975)
-- Dependencies: 3
-- Name: xfv02_finder_links_terms6; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_links_terms6 (
    link_id integer NOT NULL,
    term_id integer NOT NULL,
    weight numeric(8,2) NOT NULL
);


ALTER TABLE public.xfv02_finder_links_terms6 OWNER TO j30;

--
-- TOC entry 173 (class 1259 OID 16982)
-- Dependencies: 3
-- Name: xfv02_finder_links_terms7; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_links_terms7 (
    link_id integer NOT NULL,
    term_id integer NOT NULL,
    weight numeric(8,2) NOT NULL
);


ALTER TABLE public.xfv02_finder_links_terms7 OWNER TO j30;

--
-- TOC entry 174 (class 1259 OID 16989)
-- Dependencies: 3
-- Name: xfv02_finder_links_terms8; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_links_terms8 (
    link_id integer NOT NULL,
    term_id integer NOT NULL,
    weight numeric(8,2) NOT NULL
);


ALTER TABLE public.xfv02_finder_links_terms8 OWNER TO j30;

--
-- TOC entry 175 (class 1259 OID 16996)
-- Dependencies: 3
-- Name: xfv02_finder_links_terms9; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_links_terms9 (
    link_id integer NOT NULL,
    term_id integer NOT NULL,
    weight numeric(8,2) NOT NULL
);


ALTER TABLE public.xfv02_finder_links_terms9 OWNER TO j30;

--
-- TOC entry 176 (class 1259 OID 17003)
-- Dependencies: 3
-- Name: xfv02_finder_links_termsa; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_links_termsa (
    link_id integer NOT NULL,
    term_id integer NOT NULL,
    weight numeric(8,2) NOT NULL
);


ALTER TABLE public.xfv02_finder_links_termsa OWNER TO j30;

--
-- TOC entry 177 (class 1259 OID 17010)
-- Dependencies: 3
-- Name: xfv02_finder_links_termsb; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_links_termsb (
    link_id integer NOT NULL,
    term_id integer NOT NULL,
    weight numeric(8,2) NOT NULL
);


ALTER TABLE public.xfv02_finder_links_termsb OWNER TO j30;

--
-- TOC entry 178 (class 1259 OID 17017)
-- Dependencies: 3
-- Name: xfv02_finder_links_termsc; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_links_termsc (
    link_id integer NOT NULL,
    term_id integer NOT NULL,
    weight numeric(8,2) NOT NULL
);


ALTER TABLE public.xfv02_finder_links_termsc OWNER TO j30;

--
-- TOC entry 179 (class 1259 OID 17024)
-- Dependencies: 3
-- Name: xfv02_finder_links_termsd; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_links_termsd (
    link_id integer NOT NULL,
    term_id integer NOT NULL,
    weight numeric(8,2) NOT NULL
);


ALTER TABLE public.xfv02_finder_links_termsd OWNER TO j30;

--
-- TOC entry 180 (class 1259 OID 17031)
-- Dependencies: 3
-- Name: xfv02_finder_links_termse; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_links_termse (
    link_id integer NOT NULL,
    term_id integer NOT NULL,
    weight numeric(8,2) NOT NULL
);


ALTER TABLE public.xfv02_finder_links_termse OWNER TO j30;

--
-- TOC entry 181 (class 1259 OID 17038)
-- Dependencies: 3
-- Name: xfv02_finder_links_termsf; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_links_termsf (
    link_id integer NOT NULL,
    term_id integer NOT NULL,
    weight numeric(8,2) NOT NULL
);


ALTER TABLE public.xfv02_finder_links_termsf OWNER TO j30;

--
-- TOC entry 183 (class 1259 OID 17047)
-- Dependencies: 2313 2314 2315 2316 3
-- Name: xfv02_finder_taxonomy; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_taxonomy (
    id integer NOT NULL,
    parent_id integer DEFAULT 0 NOT NULL,
    title character varying(255) NOT NULL,
    state smallint DEFAULT 1 NOT NULL,
    access smallint DEFAULT 0 NOT NULL,
    ordering smallint DEFAULT 0 NOT NULL
);


ALTER TABLE public.xfv02_finder_taxonomy OWNER TO j30;

--
-- TOC entry 182 (class 1259 OID 17045)
-- Dependencies: 183 3
-- Name: xfv02_finder_taxonomy_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_finder_taxonomy_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_finder_taxonomy_id_seq OWNER TO j30;

--
-- TOC entry 2932 (class 0 OID 0)
-- Dependencies: 182
-- Name: xfv02_finder_taxonomy_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_finder_taxonomy_id_seq OWNED BY xfv02_finder_taxonomy.id;


--
-- TOC entry 184 (class 1259 OID 17062)
-- Dependencies: 3
-- Name: xfv02_finder_taxonomy_map; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_taxonomy_map (
    link_id integer NOT NULL,
    node_id integer NOT NULL
);


ALTER TABLE public.xfv02_finder_taxonomy_map OWNER TO j30;

--
-- TOC entry 186 (class 1259 OID 17071)
-- Dependencies: 2318 2319 2320 2321 3
-- Name: xfv02_finder_terms; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_terms (
    term_id integer NOT NULL,
    term character varying(75) NOT NULL,
    stem character varying(75) NOT NULL,
    common smallint DEFAULT 0 NOT NULL,
    phrase smallint DEFAULT 0 NOT NULL,
    weight numeric(8,2) DEFAULT 0 NOT NULL,
    soundex character varying(75) NOT NULL,
    links integer DEFAULT 0 NOT NULL,
    language character varying(3) NOT NULL
);


ALTER TABLE public.xfv02_finder_terms OWNER TO j30;

--
-- TOC entry 187 (class 1259 OID 17086)
-- Dependencies: 2322 3
-- Name: xfv02_finder_terms_common; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_terms_common (
    term character varying(75) NOT NULL,
    language character varying(3) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.xfv02_finder_terms_common OWNER TO j30;

--
-- TOC entry 185 (class 1259 OID 17069)
-- Dependencies: 186 3
-- Name: xfv02_finder_terms_term_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_finder_terms_term_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_finder_terms_term_id_seq OWNER TO j30;

--
-- TOC entry 2933 (class 0 OID 0)
-- Dependencies: 185
-- Name: xfv02_finder_terms_term_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_finder_terms_term_id_seq OWNED BY xfv02_finder_terms.term_id;


--
-- TOC entry 188 (class 1259 OID 17092)
-- Dependencies: 2323 2324 2325 2326 3
-- Name: xfv02_finder_tokens; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_tokens (
    term character varying(75) NOT NULL,
    stem character varying(75) NOT NULL,
    common smallint DEFAULT 0 NOT NULL,
    phrase smallint DEFAULT 0 NOT NULL,
    weight numeric(8,2) DEFAULT 1 NOT NULL,
    context smallint DEFAULT 2 NOT NULL,
    language character varying(3) NOT NULL
);


ALTER TABLE public.xfv02_finder_tokens OWNER TO j30;

--
-- TOC entry 189 (class 1259 OID 17101)
-- Dependencies: 2327 2328 2329 3
-- Name: xfv02_finder_tokens_aggregate; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_tokens_aggregate (
    term_id integer NOT NULL,
    map_suffix character varying(1) NOT NULL,
    term character varying(75) NOT NULL,
    stem character varying(75) NOT NULL,
    common smallint DEFAULT 0 NOT NULL,
    phrase smallint DEFAULT 0 NOT NULL,
    term_weight numeric(8,2) NOT NULL,
    context smallint DEFAULT 2 NOT NULL,
    context_weight numeric(8,2) NOT NULL,
    total_weight numeric(8,2) NOT NULL,
    language character varying(3) NOT NULL
);


ALTER TABLE public.xfv02_finder_tokens_aggregate OWNER TO j30;

--
-- TOC entry 191 (class 1259 OID 17111)
-- Dependencies: 3
-- Name: xfv02_finder_types; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_finder_types (
    id integer NOT NULL,
    title character varying(100) NOT NULL,
    mime character varying(100) NOT NULL
);


ALTER TABLE public.xfv02_finder_types OWNER TO j30;

--
-- TOC entry 190 (class 1259 OID 17109)
-- Dependencies: 191 3
-- Name: xfv02_finder_types_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_finder_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_finder_types_id_seq OWNER TO j30;

--
-- TOC entry 2934 (class 0 OID 0)
-- Dependencies: 190
-- Name: xfv02_finder_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_finder_types_id_seq OWNED BY xfv02_finder_types.id;


--
-- TOC entry 193 (class 1259 OID 17121)
-- Dependencies: 2332 2333 2334 2335 3
-- Name: xfv02_languages; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_languages (
    lang_id integer NOT NULL,
    lang_code character varying(7) NOT NULL,
    title character varying(50) NOT NULL,
    title_native character varying(50) NOT NULL,
    sef character varying(50) NOT NULL,
    image character varying(50) NOT NULL,
    description character varying(512) NOT NULL,
    metakey text NOT NULL,
    metadesc text NOT NULL,
    sitename character varying(1024) DEFAULT ''::character varying NOT NULL,
    published bigint DEFAULT 0 NOT NULL,
    access integer DEFAULT 0 NOT NULL,
    ordering bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.xfv02_languages OWNER TO j30;

--
-- TOC entry 192 (class 1259 OID 17119)
-- Dependencies: 3 193
-- Name: xfv02_languages_lang_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_languages_lang_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_languages_lang_id_seq OWNER TO j30;

--
-- TOC entry 2935 (class 0 OID 0)
-- Dependencies: 192
-- Name: xfv02_languages_lang_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_languages_lang_id_seq OWNED BY xfv02_languages.lang_id;


--
-- TOC entry 195 (class 1259 OID 17144)
-- Dependencies: 2337 2338 2339 2340 2341 2342 2343 2344 2345 2346 2347 2348 2349 2350 2351 2352 2353 2354 3
-- Name: xfv02_menu; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_menu (
    id integer NOT NULL,
    menutype character varying(24) NOT NULL,
    title character varying(255) NOT NULL,
    alias character varying(255) NOT NULL,
    note character varying(255) DEFAULT ''::character varying NOT NULL,
    path character varying(1024) DEFAULT ''::character varying NOT NULL,
    link character varying(1024) NOT NULL,
    type character varying(16) NOT NULL,
    published smallint DEFAULT 0 NOT NULL,
    parent_id integer DEFAULT 1 NOT NULL,
    level integer DEFAULT 0 NOT NULL,
    component_id integer DEFAULT 0 NOT NULL,
    checked_out integer DEFAULT 0 NOT NULL,
    checked_out_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    "browserNav" smallint DEFAULT 0 NOT NULL,
    access bigint DEFAULT 0 NOT NULL,
    img character varying(255) DEFAULT ''::character varying NOT NULL,
    template_style_id integer DEFAULT 0 NOT NULL,
    params text DEFAULT ''::text NOT NULL,
    lft bigint DEFAULT 0 NOT NULL,
    rgt bigint DEFAULT 0 NOT NULL,
    home smallint DEFAULT 0 NOT NULL,
    language character varying(7) DEFAULT ''::character varying NOT NULL,
    client_id smallint DEFAULT 0 NOT NULL
);


ALTER TABLE public.xfv02_menu OWNER TO j30;

--
-- TOC entry 2936 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.menutype; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.menutype IS 'The type of menu this item belongs to. FK to #__menu_types.menutype';


--
-- TOC entry 2937 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.title; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.title IS 'The display title of the menu item.';


--
-- TOC entry 2938 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.alias; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.alias IS 'The SEF alias of the menu item.';


--
-- TOC entry 2939 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.path; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.path IS 'The computed path of the menu item based on the alias field.';


--
-- TOC entry 2940 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.link; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.link IS 'The actually link the menu item refers to.';


--
-- TOC entry 2941 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.type; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.type IS 'The type of link: Component, URL, Alias, Separator';


--
-- TOC entry 2942 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.published; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.published IS 'The published state of the menu link.';


--
-- TOC entry 2943 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.parent_id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.parent_id IS 'The parent menu item in the menu tree.';


--
-- TOC entry 2944 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.level; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.level IS 'The relative level in the tree.';


--
-- TOC entry 2945 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.component_id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.component_id IS 'FK to #__extensions.id';


--
-- TOC entry 2946 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.checked_out; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.checked_out IS 'FK to #__users.id';


--
-- TOC entry 2947 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.checked_out_time; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.checked_out_time IS 'The time the menu item was checked out.';


--
-- TOC entry 2948 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu."browserNav"; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu."browserNav" IS 'The click behaviour of the link.';


--
-- TOC entry 2949 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.access; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.access IS 'The access level required to view the menu item.';


--
-- TOC entry 2950 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.img; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.img IS 'The image of the menu item.';


--
-- TOC entry 2951 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.params; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.params IS 'JSON encoded data for the menu item.';


--
-- TOC entry 2952 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.lft; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.lft IS 'Nested set lft.';


--
-- TOC entry 2953 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.rgt; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.rgt IS 'Nested set rgt.';


--
-- TOC entry 2954 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN xfv02_menu.home; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_menu.home IS 'Indicates if this menu item is the home or default page.';


--
-- TOC entry 194 (class 1259 OID 17142)
-- Dependencies: 195 3
-- Name: xfv02_menu_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_menu_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_menu_id_seq OWNER TO j30;

--
-- TOC entry 2955 (class 0 OID 0)
-- Dependencies: 194
-- Name: xfv02_menu_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_menu_id_seq OWNED BY xfv02_menu.id;


--
-- TOC entry 197 (class 1259 OID 17181)
-- Dependencies: 2356 3
-- Name: xfv02_menu_types; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_menu_types (
    id integer NOT NULL,
    menutype character varying(24) NOT NULL,
    title character varying(48) NOT NULL,
    description character varying(255) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.xfv02_menu_types OWNER TO j30;

--
-- TOC entry 196 (class 1259 OID 17179)
-- Dependencies: 3 197
-- Name: xfv02_menu_types_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_menu_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_menu_types_id_seq OWNER TO j30;

--
-- TOC entry 2956 (class 0 OID 0)
-- Dependencies: 196
-- Name: xfv02_menu_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_menu_types_id_seq OWNED BY xfv02_menu_types.id;


--
-- TOC entry 199 (class 1259 OID 17192)
-- Dependencies: 2358 2359 2360 2361 2362 2363 2364 3
-- Name: xfv02_messages; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_messages (
    message_id integer NOT NULL,
    user_id_from bigint DEFAULT 0 NOT NULL,
    user_id_to bigint DEFAULT 0 NOT NULL,
    folder_id smallint DEFAULT 0 NOT NULL,
    date_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    state smallint DEFAULT 0 NOT NULL,
    priority smallint DEFAULT 0 NOT NULL,
    subject character varying(255) DEFAULT ''::character varying NOT NULL,
    message text NOT NULL
);


ALTER TABLE public.xfv02_messages OWNER TO j30;

--
-- TOC entry 200 (class 1259 OID 17209)
-- Dependencies: 2365 2366 2367 3
-- Name: xfv02_messages_cfg; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_messages_cfg (
    user_id bigint DEFAULT 0 NOT NULL,
    cfg_name character varying(100) DEFAULT ''::character varying NOT NULL,
    cfg_value character varying(255) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.xfv02_messages_cfg OWNER TO j30;

--
-- TOC entry 198 (class 1259 OID 17190)
-- Dependencies: 199 3
-- Name: xfv02_messages_message_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_messages_message_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_messages_message_id_seq OWNER TO j30;

--
-- TOC entry 2957 (class 0 OID 0)
-- Dependencies: 198
-- Name: xfv02_messages_message_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_messages_message_id_seq OWNED BY xfv02_messages.message_id;


--
-- TOC entry 202 (class 1259 OID 17219)
-- Dependencies: 2369 2370 2371 2372 2373 2374 2375 2376 2377 2378 2379 2380 2381 2382 2383 3
-- Name: xfv02_modules; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_modules (
    id integer NOT NULL,
    asset_id bigint DEFAULT 0 NOT NULL,
    title character varying(100) DEFAULT ''::character varying NOT NULL,
    note character varying(255) DEFAULT ''::character varying NOT NULL,
    content text DEFAULT ''::text NOT NULL,
    ordering bigint DEFAULT 0 NOT NULL,
    "position" character varying(50) DEFAULT ''::character varying NOT NULL,
    checked_out integer DEFAULT 0 NOT NULL,
    checked_out_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    publish_up timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    publish_down timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    published smallint DEFAULT 0 NOT NULL,
    module character varying(50) DEFAULT NULL::character varying,
    access bigint DEFAULT 0 NOT NULL,
    showtitle smallint DEFAULT 1 NOT NULL,
    params text NOT NULL,
    client_id smallint DEFAULT 0 NOT NULL,
    language character varying(7) NOT NULL
);


ALTER TABLE public.xfv02_modules OWNER TO j30;

--
-- TOC entry 201 (class 1259 OID 17217)
-- Dependencies: 3 202
-- Name: xfv02_modules_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_modules_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_modules_id_seq OWNER TO j30;

--
-- TOC entry 2958 (class 0 OID 0)
-- Dependencies: 201
-- Name: xfv02_modules_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_modules_id_seq OWNED BY xfv02_modules.id;


--
-- TOC entry 203 (class 1259 OID 17246)
-- Dependencies: 2384 2385 3
-- Name: xfv02_modules_menu; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_modules_menu (
    moduleid bigint DEFAULT 0 NOT NULL,
    menuid bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.xfv02_modules_menu OWNER TO j30;

--
-- TOC entry 205 (class 1259 OID 17255)
-- Dependencies: 2386 2388 2389 2390 2391 2392 2393 2394 2395 2396 2397 2398 2399 2400 2401 2402 2403 2404 2405 2406 2407 2408 3
-- Name: xfv02_newsfeeds; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_newsfeeds (
    catid bigint DEFAULT 0 NOT NULL,
    id integer NOT NULL,
    name character varying(100) DEFAULT ''::character varying NOT NULL,
    alias character varying(100) DEFAULT ''::character varying NOT NULL,
    link character varying(200) DEFAULT ''::character varying NOT NULL,
    published smallint DEFAULT 0 NOT NULL,
    numarticles bigint DEFAULT 1 NOT NULL,
    cache_time bigint DEFAULT 3600 NOT NULL,
    checked_out integer DEFAULT 0 NOT NULL,
    checked_out_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    ordering bigint DEFAULT 0 NOT NULL,
    rtl smallint DEFAULT 0 NOT NULL,
    access bigint DEFAULT 0 NOT NULL,
    language character varying(7) DEFAULT ''::character varying NOT NULL,
    params text NOT NULL,
    created timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    created_by integer DEFAULT 0 NOT NULL,
    created_by_alias character varying(255) DEFAULT ''::character varying NOT NULL,
    modified timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    modified_by integer DEFAULT 0 NOT NULL,
    metakey text NOT NULL,
    metadesc text NOT NULL,
    metadata text NOT NULL,
    xreference character varying(50) NOT NULL,
    publish_up timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    publish_down timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    description text NOT NULL,
    version bigint DEFAULT 1 NOT NULL,
    hits bigint DEFAULT 0 NOT NULL,
    images text NOT NULL
);


ALTER TABLE public.xfv02_newsfeeds OWNER TO j30;

--
-- TOC entry 2959 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN xfv02_newsfeeds.xreference; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_newsfeeds.xreference IS 'A reference to enable linkages to external data sets.';


--
-- TOC entry 204 (class 1259 OID 17253)
-- Dependencies: 3 205
-- Name: xfv02_newsfeeds_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_newsfeeds_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_newsfeeds_id_seq OWNER TO j30;

--
-- TOC entry 2960 (class 0 OID 0)
-- Dependencies: 204
-- Name: xfv02_newsfeeds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_newsfeeds_id_seq OWNED BY xfv02_newsfeeds.id;


--
-- TOC entry 207 (class 1259 OID 17295)
-- Dependencies: 3
-- Name: xfv02_overrider; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_overrider (
    id integer NOT NULL,
    constant character varying(255) NOT NULL,
    string text NOT NULL,
    file character varying(255) NOT NULL
);


ALTER TABLE public.xfv02_overrider OWNER TO j30;

--
-- TOC entry 2961 (class 0 OID 0)
-- Dependencies: 207
-- Name: COLUMN xfv02_overrider.id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_overrider.id IS 'Primary Key';


--
-- TOC entry 206 (class 1259 OID 17293)
-- Dependencies: 207 3
-- Name: xfv02_overrider_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_overrider_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_overrider_id_seq OWNER TO j30;

--
-- TOC entry 2962 (class 0 OID 0)
-- Dependencies: 206
-- Name: xfv02_overrider_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_overrider_id_seq OWNED BY xfv02_overrider.id;


--
-- TOC entry 209 (class 1259 OID 17306)
-- Dependencies: 2411 2412 2413 2414 2415 2416 2417 2418 2419 2420 2421 2422 2423 3
-- Name: xfv02_postinstall_messages; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_postinstall_messages (
    postinstall_message_id integer NOT NULL,
    extension_id bigint DEFAULT 700 NOT NULL,
    title_key character varying(255) DEFAULT ''::character varying NOT NULL,
    description_key character varying(255) DEFAULT ''::character varying NOT NULL,
    action_key character varying(255) DEFAULT ''::character varying NOT NULL,
    language_extension character varying(255) DEFAULT 'com_postinstall'::character varying NOT NULL,
    language_client_id smallint DEFAULT 1 NOT NULL,
    type character varying(10) DEFAULT 'link'::character varying NOT NULL,
    action_file character varying(255) DEFAULT ''::character varying,
    action character varying(255) DEFAULT ''::character varying,
    condition_file character varying(255) DEFAULT NULL::character varying,
    condition_method character varying(255) DEFAULT NULL::character varying,
    version_introduced character varying(255) DEFAULT '3.2.0'::character varying NOT NULL,
    enabled smallint DEFAULT 1 NOT NULL
);


ALTER TABLE public.xfv02_postinstall_messages OWNER TO j30;

--
-- TOC entry 2963 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN xfv02_postinstall_messages.extension_id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_postinstall_messages.extension_id IS 'FK to jos_extensions';


--
-- TOC entry 2964 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN xfv02_postinstall_messages.title_key; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_postinstall_messages.title_key IS 'Lang key for the title';


--
-- TOC entry 2965 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN xfv02_postinstall_messages.description_key; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_postinstall_messages.description_key IS 'Lang key for description';


--
-- TOC entry 2966 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN xfv02_postinstall_messages.language_extension; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_postinstall_messages.language_extension IS 'Extension holding lang keys';


--
-- TOC entry 2967 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN xfv02_postinstall_messages.type; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_postinstall_messages.type IS 'Message type - message, link, action';


--
-- TOC entry 2968 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN xfv02_postinstall_messages.action_file; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_postinstall_messages.action_file IS 'RAD URI to the PHP file containing action method';


--
-- TOC entry 2969 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN xfv02_postinstall_messages.action; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_postinstall_messages.action IS 'Action method name or URL';


--
-- TOC entry 2970 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN xfv02_postinstall_messages.condition_file; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_postinstall_messages.condition_file IS 'RAD URI to file holding display condition method';


--
-- TOC entry 2971 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN xfv02_postinstall_messages.condition_method; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_postinstall_messages.condition_method IS 'Display condition method, must return boolean';


--
-- TOC entry 2972 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN xfv02_postinstall_messages.version_introduced; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_postinstall_messages.version_introduced IS 'Version when this message was introduced';


--
-- TOC entry 208 (class 1259 OID 17304)
-- Dependencies: 209 3
-- Name: xfv02_postinstall_messages_postinstall_message_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_postinstall_messages_postinstall_message_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_postinstall_messages_postinstall_message_id_seq OWNER TO j30;

--
-- TOC entry 2973 (class 0 OID 0)
-- Dependencies: 208
-- Name: xfv02_postinstall_messages_postinstall_message_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_postinstall_messages_postinstall_message_id_seq OWNED BY xfv02_postinstall_messages.postinstall_message_id;


--
-- TOC entry 211 (class 1259 OID 17330)
-- Dependencies: 2425 2426 2427 3
-- Name: xfv02_redirect_links; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_redirect_links (
    id integer NOT NULL,
    old_url character varying(255) NOT NULL,
    new_url character varying(255) NOT NULL,
    referer character varying(150) NOT NULL,
    comment character varying(255) NOT NULL,
    hits bigint DEFAULT 0 NOT NULL,
    published smallint NOT NULL,
    created_date timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    modified_date timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL
);


ALTER TABLE public.xfv02_redirect_links OWNER TO j30;

--
-- TOC entry 210 (class 1259 OID 17328)
-- Dependencies: 211 3
-- Name: xfv02_redirect_links_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_redirect_links_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_redirect_links_id_seq OWNER TO j30;

--
-- TOC entry 2974 (class 0 OID 0)
-- Dependencies: 210
-- Name: xfv02_redirect_links_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_redirect_links_id_seq OWNED BY xfv02_redirect_links.id;


--
-- TOC entry 212 (class 1259 OID 17345)
-- Dependencies: 3
-- Name: xfv02_schemas; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_schemas (
    extension_id bigint NOT NULL,
    version_id character varying(20) NOT NULL
);


ALTER TABLE public.xfv02_schemas OWNER TO j30;

--
-- TOC entry 213 (class 1259 OID 17350)
-- Dependencies: 2428 2429 2430 2431 2432 2433 3
-- Name: xfv02_session; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_session (
    session_id character varying(200) DEFAULT ''::character varying NOT NULL,
    client_id smallint DEFAULT 0 NOT NULL,
    guest smallint DEFAULT 1,
    "time" character varying(14) DEFAULT ''::character varying,
    data text,
    userid bigint DEFAULT 0,
    username character varying(150) DEFAULT ''::character varying
);


ALTER TABLE public.xfv02_session OWNER TO j30;

--
-- TOC entry 215 (class 1259 OID 17368)
-- Dependencies: 2434 2436 2437 2438 2439 2440 2441 2442 2443 2444 2445 2446 2447 2448 2449 2450 2451 2452 2453 2454 2455 2456 3
-- Name: xfv02_tags; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_tags (
    id integer NOT NULL,
    parent_id bigint DEFAULT 0 NOT NULL,
    lft bigint DEFAULT 0 NOT NULL,
    rgt bigint DEFAULT 0 NOT NULL,
    level integer DEFAULT 0 NOT NULL,
    path character varying(255) DEFAULT ''::character varying NOT NULL,
    title character varying(255) NOT NULL,
    alias character varying(255) DEFAULT ''::character varying NOT NULL,
    note character varying(255) DEFAULT ''::character varying NOT NULL,
    description text DEFAULT ''::text NOT NULL,
    published smallint DEFAULT 0 NOT NULL,
    checked_out bigint DEFAULT 0 NOT NULL,
    checked_out_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    access bigint DEFAULT 0 NOT NULL,
    params text NOT NULL,
    metadesc character varying(1024) NOT NULL,
    metakey character varying(1024) NOT NULL,
    metadata character varying(2048) NOT NULL,
    created_user_id integer DEFAULT 0 NOT NULL,
    created_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    created_by_alias character varying(255) DEFAULT ''::character varying NOT NULL,
    modified_user_id integer DEFAULT 0 NOT NULL,
    modified_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    images text NOT NULL,
    urls text NOT NULL,
    hits integer DEFAULT 0 NOT NULL,
    language character varying(7) DEFAULT ''::character varying NOT NULL,
    version bigint DEFAULT 1 NOT NULL,
    publish_up timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    publish_down timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL
);


ALTER TABLE public.xfv02_tags OWNER TO j30;

--
-- TOC entry 214 (class 1259 OID 17366)
-- Dependencies: 3 215
-- Name: xfv02_tags_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_tags_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_tags_id_seq OWNER TO j30;

--
-- TOC entry 2975 (class 0 OID 0)
-- Dependencies: 214
-- Name: xfv02_tags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_tags_id_seq OWNED BY xfv02_tags.id;


--
-- TOC entry 217 (class 1259 OID 17408)
-- Dependencies: 2458 2459 2460 2461 3
-- Name: xfv02_template_styles; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_template_styles (
    id integer NOT NULL,
    template character varying(50) DEFAULT ''::character varying NOT NULL,
    client_id smallint DEFAULT 0 NOT NULL,
    home character varying(7) DEFAULT '0'::character varying NOT NULL,
    title character varying(255) DEFAULT ''::character varying NOT NULL,
    params text NOT NULL
);


ALTER TABLE public.xfv02_template_styles OWNER TO j30;

--
-- TOC entry 216 (class 1259 OID 17406)
-- Dependencies: 3 217
-- Name: xfv02_template_styles_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_template_styles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_template_styles_id_seq OWNER TO j30;

--
-- TOC entry 2976 (class 0 OID 0)
-- Dependencies: 216
-- Name: xfv02_template_styles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_template_styles_id_seq OWNED BY xfv02_template_styles.id;


--
-- TOC entry 219 (class 1259 OID 17425)
-- Dependencies: 3
-- Name: xfv02_ucm_base; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_ucm_base (
    ucm_id integer NOT NULL,
    ucm_item_id bigint NOT NULL,
    ucm_type_id bigint NOT NULL,
    ucm_language_id bigint NOT NULL
);


ALTER TABLE public.xfv02_ucm_base OWNER TO j30;

--
-- TOC entry 218 (class 1259 OID 17423)
-- Dependencies: 219 3
-- Name: xfv02_ucm_base_ucm_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_ucm_base_ucm_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_ucm_base_ucm_id_seq OWNER TO j30;

--
-- TOC entry 2977 (class 0 OID 0)
-- Dependencies: 218
-- Name: xfv02_ucm_base_ucm_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_ucm_base_ucm_id_seq OWNED BY xfv02_ucm_base.ucm_id;


--
-- TOC entry 221 (class 1259 OID 17436)
-- Dependencies: 2464 2465 2466 2467 2468 2469 2470 2471 2472 2473 2474 2475 2476 2477 2478 2479 2480 2481 2482 2483 2484 2485 2486 3
-- Name: xfv02_ucm_content; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_ucm_content (
    core_content_id integer NOT NULL,
    core_type_alias character varying(255) DEFAULT ''::character varying NOT NULL,
    core_title character varying(255) NOT NULL,
    core_alias character varying(255) DEFAULT ''::character varying NOT NULL,
    core_body text NOT NULL,
    core_state smallint DEFAULT 0 NOT NULL,
    core_checked_out_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    core_checked_out_user_id bigint DEFAULT 0 NOT NULL,
    core_access bigint DEFAULT 0 NOT NULL,
    core_params text NOT NULL,
    core_featured smallint DEFAULT 0 NOT NULL,
    core_metadata text NOT NULL,
    core_created_user_id bigint DEFAULT 0 NOT NULL,
    core_created_by_alias character varying(255) DEFAULT ''::character varying NOT NULL,
    core_created_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    core_modified_user_id bigint DEFAULT 0 NOT NULL,
    core_modified_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    core_language character varying(7) DEFAULT ''::character varying NOT NULL,
    core_publish_up timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    core_publish_down timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    core_content_item_id bigint DEFAULT 0 NOT NULL,
    asset_id bigint DEFAULT 0 NOT NULL,
    core_images text NOT NULL,
    core_urls text NOT NULL,
    core_hits bigint DEFAULT 0 NOT NULL,
    core_version bigint DEFAULT 1 NOT NULL,
    core_ordering bigint DEFAULT 0 NOT NULL,
    core_metakey text NOT NULL,
    core_metadesc text NOT NULL,
    core_catid bigint DEFAULT 0 NOT NULL,
    core_xreference character varying(50) DEFAULT ''::character varying NOT NULL,
    core_type_id bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.xfv02_ucm_content OWNER TO j30;

--
-- TOC entry 220 (class 1259 OID 17434)
-- Dependencies: 3 221
-- Name: xfv02_ucm_content_core_content_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_ucm_content_core_content_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_ucm_content_core_content_id_seq OWNER TO j30;

--
-- TOC entry 2978 (class 0 OID 0)
-- Dependencies: 220
-- Name: xfv02_ucm_content_core_content_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_ucm_content_core_content_id_seq OWNED BY xfv02_ucm_content.core_content_id;


--
-- TOC entry 223 (class 1259 OID 17484)
-- Dependencies: 2488 2489 2490 2491 2492 2493 3
-- Name: xfv02_ucm_history; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_ucm_history (
    version_id integer NOT NULL,
    ucm_item_id integer NOT NULL,
    ucm_type_id integer NOT NULL,
    version_note character varying(255) DEFAULT ''::character varying NOT NULL,
    save_date timestamp with time zone DEFAULT '1970-01-01 00:00:00-04'::timestamp with time zone NOT NULL,
    editor_user_id integer DEFAULT 0 NOT NULL,
    character_count integer DEFAULT 0 NOT NULL,
    sha1_hash character varying(50) DEFAULT ''::character varying NOT NULL,
    version_data text NOT NULL,
    keep_forever smallint DEFAULT 0 NOT NULL
);


ALTER TABLE public.xfv02_ucm_history OWNER TO j30;

--
-- TOC entry 2979 (class 0 OID 0)
-- Dependencies: 223
-- Name: COLUMN xfv02_ucm_history.version_note; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_ucm_history.version_note IS 'Optional version name';


--
-- TOC entry 2980 (class 0 OID 0)
-- Dependencies: 223
-- Name: COLUMN xfv02_ucm_history.character_count; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_ucm_history.character_count IS 'Number of characters in this version.';


--
-- TOC entry 2981 (class 0 OID 0)
-- Dependencies: 223
-- Name: COLUMN xfv02_ucm_history.sha1_hash; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_ucm_history.sha1_hash IS 'SHA1 hash of the version_data column.';


--
-- TOC entry 2982 (class 0 OID 0)
-- Dependencies: 223
-- Name: COLUMN xfv02_ucm_history.version_data; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_ucm_history.version_data IS 'json-encoded string of version data';


--
-- TOC entry 2983 (class 0 OID 0)
-- Dependencies: 223
-- Name: COLUMN xfv02_ucm_history.keep_forever; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_ucm_history.keep_forever IS '0=auto delete; 1=keep';


--
-- TOC entry 222 (class 1259 OID 17482)
-- Dependencies: 223 3
-- Name: xfv02_ucm_history_version_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_ucm_history_version_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_ucm_history_version_id_seq OWNER TO j30;

--
-- TOC entry 2984 (class 0 OID 0)
-- Dependencies: 222
-- Name: xfv02_ucm_history_version_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_ucm_history_version_id_seq OWNED BY xfv02_ucm_history.version_id;


--
-- TOC entry 227 (class 1259 OID 17523)
-- Dependencies: 2505 2506 2507 2508 3
-- Name: xfv02_update_sites; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_update_sites (
    update_site_id integer NOT NULL,
    name character varying(100) DEFAULT ''::character varying,
    type character varying(20) DEFAULT ''::character varying,
    location text NOT NULL,
    enabled bigint DEFAULT 0,
    last_check_timestamp bigint DEFAULT 0
);


ALTER TABLE public.xfv02_update_sites OWNER TO j30;

--
-- TOC entry 2985 (class 0 OID 0)
-- Dependencies: 227
-- Name: TABLE xfv02_update_sites; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON TABLE xfv02_update_sites IS 'Update Sites';


--
-- TOC entry 228 (class 1259 OID 17536)
-- Dependencies: 2509 2510 3
-- Name: xfv02_update_sites_extensions; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_update_sites_extensions (
    update_site_id bigint DEFAULT 0 NOT NULL,
    extension_id bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.xfv02_update_sites_extensions OWNER TO j30;

--
-- TOC entry 2986 (class 0 OID 0)
-- Dependencies: 228
-- Name: TABLE xfv02_update_sites_extensions; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON TABLE xfv02_update_sites_extensions IS 'Links extensions to update sites';


--
-- TOC entry 226 (class 1259 OID 17521)
-- Dependencies: 227 3
-- Name: xfv02_update_sites_update_site_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_update_sites_update_site_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_update_sites_update_site_id_seq OWNER TO j30;

--
-- TOC entry 2987 (class 0 OID 0)
-- Dependencies: 226
-- Name: xfv02_update_sites_update_site_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_update_sites_update_site_id_seq OWNED BY xfv02_update_sites.update_site_id;


--
-- TOC entry 225 (class 1259 OID 17503)
-- Dependencies: 2495 2496 2497 2498 2499 2500 2501 2502 2503 3
-- Name: xfv02_updates; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_updates (
    update_id integer NOT NULL,
    update_site_id bigint DEFAULT 0,
    extension_id bigint DEFAULT 0,
    name character varying(100) DEFAULT ''::character varying,
    description text NOT NULL,
    element character varying(100) DEFAULT ''::character varying,
    type character varying(20) DEFAULT ''::character varying,
    folder character varying(20) DEFAULT ''::character varying,
    client_id smallint DEFAULT 0,
    version character varying(10) DEFAULT ''::character varying,
    data text DEFAULT ''::text NOT NULL,
    detailsurl text NOT NULL,
    infourl text NOT NULL
);


ALTER TABLE public.xfv02_updates OWNER TO j30;

--
-- TOC entry 2988 (class 0 OID 0)
-- Dependencies: 225
-- Name: TABLE xfv02_updates; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON TABLE xfv02_updates IS 'Available Updates';


--
-- TOC entry 224 (class 1259 OID 17501)
-- Dependencies: 225 3
-- Name: xfv02_updates_update_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_updates_update_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_updates_update_id_seq OWNER TO j30;

--
-- TOC entry 2989 (class 0 OID 0)
-- Dependencies: 224
-- Name: xfv02_updates_update_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_updates_update_id_seq OWNED BY xfv02_updates.update_id;


--
-- TOC entry 235 (class 1259 OID 17597)
-- Dependencies: 3
-- Name: xfv02_user_keys; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_user_keys (
    id integer NOT NULL,
    user_id character varying(255) NOT NULL,
    token character varying(255) NOT NULL,
    series character varying(255) NOT NULL,
    invalid smallint NOT NULL,
    "time" character varying(200) NOT NULL,
    uastring character varying(255) NOT NULL
);


ALTER TABLE public.xfv02_user_keys OWNER TO j30;

--
-- TOC entry 234 (class 1259 OID 17595)
-- Dependencies: 3 235
-- Name: xfv02_user_keys_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_user_keys_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_user_keys_id_seq OWNER TO j30;

--
-- TOC entry 2990 (class 0 OID 0)
-- Dependencies: 234
-- Name: xfv02_user_keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_user_keys_id_seq OWNED BY xfv02_user_keys.id;


--
-- TOC entry 237 (class 1259 OID 17611)
-- Dependencies: 2533 2534 2535 2536 2538 2539 2540 2541 2542 2543 2544 2545 3
-- Name: xfv02_user_notes; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_user_notes (
    id integer NOT NULL,
    user_id integer DEFAULT 0 NOT NULL,
    catid integer DEFAULT 0 NOT NULL,
    subject character varying(100) DEFAULT ''::character varying NOT NULL,
    body text NOT NULL,
    state smallint DEFAULT 0 NOT NULL,
    checked_out integer DEFAULT 0 NOT NULL,
    checked_out_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    created_user_id integer DEFAULT 0 NOT NULL,
    created_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    modified_user_id integer NOT NULL,
    modified_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    review_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    publish_up timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    publish_down timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL
);


ALTER TABLE public.xfv02_user_notes OWNER TO j30;

--
-- TOC entry 236 (class 1259 OID 17609)
-- Dependencies: 237 3
-- Name: xfv02_user_notes_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_user_notes_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_user_notes_id_seq OWNER TO j30;

--
-- TOC entry 2991 (class 0 OID 0)
-- Dependencies: 236
-- Name: xfv02_user_notes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_user_notes_id_seq OWNED BY xfv02_user_notes.id;


--
-- TOC entry 238 (class 1259 OID 17634)
-- Dependencies: 2546 3
-- Name: xfv02_user_profiles; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_user_profiles (
    user_id bigint NOT NULL,
    profile_key character varying(100) NOT NULL,
    profile_value character varying(255) NOT NULL,
    ordering bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.xfv02_user_profiles OWNER TO j30;

--
-- TOC entry 2992 (class 0 OID 0)
-- Dependencies: 238
-- Name: TABLE xfv02_user_profiles; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON TABLE xfv02_user_profiles IS 'Simple user profile storage table';


--
-- TOC entry 231 (class 1259 OID 17560)
-- Dependencies: 2516 2517 3
-- Name: xfv02_user_usergroup_map; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_user_usergroup_map (
    user_id bigint DEFAULT 0 NOT NULL,
    group_id bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.xfv02_user_usergroup_map OWNER TO j30;

--
-- TOC entry 2993 (class 0 OID 0)
-- Dependencies: 231
-- Name: COLUMN xfv02_user_usergroup_map.user_id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_user_usergroup_map.user_id IS 'Foreign Key to #__users.id';


--
-- TOC entry 2994 (class 0 OID 0)
-- Dependencies: 231
-- Name: COLUMN xfv02_user_usergroup_map.group_id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_user_usergroup_map.group_id IS 'Foreign Key to #__usergroups.id';


--
-- TOC entry 230 (class 1259 OID 17545)
-- Dependencies: 2512 2513 2514 2515 3
-- Name: xfv02_usergroups; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_usergroups (
    id integer NOT NULL,
    parent_id bigint DEFAULT 0 NOT NULL,
    lft bigint DEFAULT 0 NOT NULL,
    rgt bigint DEFAULT 0 NOT NULL,
    title character varying(100) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.xfv02_usergroups OWNER TO j30;

--
-- TOC entry 2995 (class 0 OID 0)
-- Dependencies: 230
-- Name: COLUMN xfv02_usergroups.id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_usergroups.id IS 'Primary Key';


--
-- TOC entry 2996 (class 0 OID 0)
-- Dependencies: 230
-- Name: COLUMN xfv02_usergroups.parent_id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_usergroups.parent_id IS 'Adjacency List Reference Id';


--
-- TOC entry 2997 (class 0 OID 0)
-- Dependencies: 230
-- Name: COLUMN xfv02_usergroups.lft; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_usergroups.lft IS 'Nested set lft.';


--
-- TOC entry 2998 (class 0 OID 0)
-- Dependencies: 230
-- Name: COLUMN xfv02_usergroups.rgt; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_usergroups.rgt IS 'Nested set rgt.';


--
-- TOC entry 229 (class 1259 OID 17543)
-- Dependencies: 3 230
-- Name: xfv02_usergroups_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_usergroups_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_usergroups_id_seq OWNER TO j30;

--
-- TOC entry 2999 (class 0 OID 0)
-- Dependencies: 229
-- Name: xfv02_usergroups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_usergroups_id_seq OWNED BY xfv02_usergroups.id;


--
-- TOC entry 233 (class 1259 OID 17569)
-- Dependencies: 2519 2520 2521 2522 2523 2524 2525 2526 2527 2528 2529 2530 2531 3
-- Name: xfv02_users; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_users (
    id integer NOT NULL,
    name character varying(255) DEFAULT ''::character varying NOT NULL,
    username character varying(150) DEFAULT ''::character varying NOT NULL,
    email character varying(100) DEFAULT ''::character varying NOT NULL,
    password character varying(100) DEFAULT ''::character varying NOT NULL,
    block smallint DEFAULT 0 NOT NULL,
    "sendEmail" smallint DEFAULT 0,
    "registerDate" timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    "lastvisitDate" timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    activation character varying(100) DEFAULT ''::character varying NOT NULL,
    params text NOT NULL,
    "lastResetTime" timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    "resetCount" bigint DEFAULT 0 NOT NULL,
    "otpKey" character varying(1000) DEFAULT ''::character varying NOT NULL,
    otep character varying(1000) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.xfv02_users OWNER TO j30;

--
-- TOC entry 3000 (class 0 OID 0)
-- Dependencies: 233
-- Name: COLUMN xfv02_users."lastResetTime"; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_users."lastResetTime" IS 'Date of last password reset';


--
-- TOC entry 3001 (class 0 OID 0)
-- Dependencies: 233
-- Name: COLUMN xfv02_users."resetCount"; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_users."resetCount" IS 'Count of password resets since lastResetTime';


--
-- TOC entry 232 (class 1259 OID 17567)
-- Dependencies: 3 233
-- Name: xfv02_users_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_users_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_users_id_seq OWNER TO j30;

--
-- TOC entry 3002 (class 0 OID 0)
-- Dependencies: 232
-- Name: xfv02_users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_users_id_seq OWNED BY xfv02_users.id;


--
-- TOC entry 240 (class 1259 OID 17642)
-- Dependencies: 2548 2549 3
-- Name: xfv02_viewlevels; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_viewlevels (
    id integer NOT NULL,
    title character varying(100) DEFAULT ''::character varying NOT NULL,
    ordering bigint DEFAULT 0 NOT NULL,
    rules character varying(5120) NOT NULL
);


ALTER TABLE public.xfv02_viewlevels OWNER TO j30;

--
-- TOC entry 3003 (class 0 OID 0)
-- Dependencies: 240
-- Name: COLUMN xfv02_viewlevels.id; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_viewlevels.id IS 'Primary Key';


--
-- TOC entry 3004 (class 0 OID 0)
-- Dependencies: 240
-- Name: COLUMN xfv02_viewlevels.rules; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_viewlevels.rules IS 'JSON encoded access control.';


--
-- TOC entry 239 (class 1259 OID 17640)
-- Dependencies: 3 240
-- Name: xfv02_viewlevels_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_viewlevels_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_viewlevels_id_seq OWNER TO j30;

--
-- TOC entry 3005 (class 0 OID 0)
-- Dependencies: 239
-- Name: xfv02_viewlevels_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_viewlevels_id_seq OWNED BY xfv02_viewlevels.id;


--
-- TOC entry 242 (class 1259 OID 17657)
-- Dependencies: 2551 2552 2553 2554 2555 2556 2557 2558 2559 2560 2561 2562 2563 2564 2565 2566 2567 2568 2569 2570 3
-- Name: xfv02_weblinks; Type: TABLE; Schema: public; Owner: j30; Tablespace: 
--

CREATE TABLE xfv02_weblinks (
    id integer NOT NULL,
    catid bigint DEFAULT 0 NOT NULL,
    title character varying(250) DEFAULT ''::character varying NOT NULL,
    alias character varying(255) DEFAULT ''::character varying NOT NULL,
    url character varying(250) DEFAULT ''::character varying NOT NULL,
    description text NOT NULL,
    hits bigint DEFAULT 0 NOT NULL,
    state smallint DEFAULT 0 NOT NULL,
    checked_out bigint DEFAULT 0 NOT NULL,
    checked_out_time timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    ordering bigint DEFAULT 0 NOT NULL,
    access bigint DEFAULT 1 NOT NULL,
    params text NOT NULL,
    language character varying(7) DEFAULT ''::character varying NOT NULL,
    created timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    created_by integer DEFAULT 0 NOT NULL,
    created_by_alias character varying(255) DEFAULT ''::character varying NOT NULL,
    modified timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    modified_by integer DEFAULT 0 NOT NULL,
    metakey text NOT NULL,
    metadesc text NOT NULL,
    metadata text NOT NULL,
    featured smallint DEFAULT 0 NOT NULL,
    xreference character varying(50) NOT NULL,
    publish_up timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    publish_down timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
    version bigint DEFAULT 1 NOT NULL,
    images text NOT NULL
);


ALTER TABLE public.xfv02_weblinks OWNER TO j30;

--
-- TOC entry 3006 (class 0 OID 0)
-- Dependencies: 242
-- Name: COLUMN xfv02_weblinks.featured; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_weblinks.featured IS 'Set if link is featured.';


--
-- TOC entry 3007 (class 0 OID 0)
-- Dependencies: 242
-- Name: COLUMN xfv02_weblinks.xreference; Type: COMMENT; Schema: public; Owner: j30
--

COMMENT ON COLUMN xfv02_weblinks.xreference IS 'A reference to enable linkages to external data sets.';


--
-- TOC entry 241 (class 1259 OID 17655)
-- Dependencies: 242 3
-- Name: xfv02_weblinks_id_seq; Type: SEQUENCE; Schema: public; Owner: j30
--

CREATE SEQUENCE xfv02_weblinks_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.xfv02_weblinks_id_seq OWNER TO j30;

--
-- TOC entry 3008 (class 0 OID 0)
-- Dependencies: 241
-- Name: xfv02_weblinks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: j30
--

ALTER SEQUENCE xfv02_weblinks_id_seq OWNED BY xfv02_weblinks.id;


--
-- TOC entry 2139 (class 2604 OID 16584)
-- Dependencies: 141 140 141
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_assets ALTER COLUMN id SET DEFAULT nextval('xfv02_assets_id_seq'::regclass);


--
-- TOC entry 2173 (class 2604 OID 16653)
-- Dependencies: 146 145 146
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_banner_clients ALTER COLUMN id SET DEFAULT nextval('xfv02_banner_clients_id_seq'::regclass);


--
-- TOC entry 2143 (class 2604 OID 16608)
-- Dependencies: 144 143 144
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_banners ALTER COLUMN id SET DEFAULT nextval('xfv02_banners_id_seq'::regclass);


--
-- TOC entry 2186 (class 2604 OID 16686)
-- Dependencies: 149 148 149
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_categories ALTER COLUMN id SET DEFAULT nextval('xfv02_categories_id_seq'::regclass);


--
-- TOC entry 2208 (class 2604 OID 16725)
-- Dependencies: 151 150 151
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_contact_details ALTER COLUMN id SET DEFAULT nextval('xfv02_contact_details_id_seq'::regclass);


--
-- TOC entry 2241 (class 2604 OID 16776)
-- Dependencies: 152 153 153
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_content ALTER COLUMN id SET DEFAULT nextval('xfv02_content_id_seq'::regclass);


--
-- TOC entry 2269 (class 2604 OID 16832)
-- Dependencies: 156 157 157
-- Name: type_id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_content_types ALTER COLUMN type_id SET DEFAULT nextval('xfv02_content_types_type_id_seq'::regclass);


--
-- TOC entry 2279 (class 2604 OID 16866)
-- Dependencies: 161 160 161
-- Name: extension_id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_extensions ALTER COLUMN extension_id SET DEFAULT nextval('xfv02_extensions_extension_id_seq'::regclass);


--
-- TOC entry 2289 (class 2604 OID 16889)
-- Dependencies: 163 162 163
-- Name: filter_id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_finder_filters ALTER COLUMN filter_id SET DEFAULT nextval('xfv02_finder_filters_filter_id_seq'::regclass);


--
-- TOC entry 2297 (class 2604 OID 16907)
-- Dependencies: 165 164 165
-- Name: link_id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_finder_links ALTER COLUMN link_id SET DEFAULT nextval('xfv02_finder_links_link_id_seq'::regclass);


--
-- TOC entry 2312 (class 2604 OID 17050)
-- Dependencies: 182 183 183
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_finder_taxonomy ALTER COLUMN id SET DEFAULT nextval('xfv02_finder_taxonomy_id_seq'::regclass);


--
-- TOC entry 2317 (class 2604 OID 17074)
-- Dependencies: 186 185 186
-- Name: term_id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_finder_terms ALTER COLUMN term_id SET DEFAULT nextval('xfv02_finder_terms_term_id_seq'::regclass);


--
-- TOC entry 2330 (class 2604 OID 17114)
-- Dependencies: 191 190 191
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_finder_types ALTER COLUMN id SET DEFAULT nextval('xfv02_finder_types_id_seq'::regclass);


--
-- TOC entry 2331 (class 2604 OID 17124)
-- Dependencies: 192 193 193
-- Name: lang_id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_languages ALTER COLUMN lang_id SET DEFAULT nextval('xfv02_languages_lang_id_seq'::regclass);


--
-- TOC entry 2336 (class 2604 OID 17147)
-- Dependencies: 194 195 195
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_menu ALTER COLUMN id SET DEFAULT nextval('xfv02_menu_id_seq'::regclass);


--
-- TOC entry 2355 (class 2604 OID 17184)
-- Dependencies: 196 197 197
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_menu_types ALTER COLUMN id SET DEFAULT nextval('xfv02_menu_types_id_seq'::regclass);


--
-- TOC entry 2357 (class 2604 OID 17195)
-- Dependencies: 198 199 199
-- Name: message_id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_messages ALTER COLUMN message_id SET DEFAULT nextval('xfv02_messages_message_id_seq'::regclass);


--
-- TOC entry 2368 (class 2604 OID 17222)
-- Dependencies: 201 202 202
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_modules ALTER COLUMN id SET DEFAULT nextval('xfv02_modules_id_seq'::regclass);


--
-- TOC entry 2387 (class 2604 OID 17259)
-- Dependencies: 205 204 205
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_newsfeeds ALTER COLUMN id SET DEFAULT nextval('xfv02_newsfeeds_id_seq'::regclass);


--
-- TOC entry 2409 (class 2604 OID 17298)
-- Dependencies: 206 207 207
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_overrider ALTER COLUMN id SET DEFAULT nextval('xfv02_overrider_id_seq'::regclass);


--
-- TOC entry 2410 (class 2604 OID 17309)
-- Dependencies: 209 208 209
-- Name: postinstall_message_id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_postinstall_messages ALTER COLUMN postinstall_message_id SET DEFAULT nextval('xfv02_postinstall_messages_postinstall_message_id_seq'::regclass);


--
-- TOC entry 2424 (class 2604 OID 17333)
-- Dependencies: 211 210 211
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_redirect_links ALTER COLUMN id SET DEFAULT nextval('xfv02_redirect_links_id_seq'::regclass);


--
-- TOC entry 2435 (class 2604 OID 17371)
-- Dependencies: 215 214 215
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_tags ALTER COLUMN id SET DEFAULT nextval('xfv02_tags_id_seq'::regclass);


--
-- TOC entry 2457 (class 2604 OID 17411)
-- Dependencies: 216 217 217
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_template_styles ALTER COLUMN id SET DEFAULT nextval('xfv02_template_styles_id_seq'::regclass);


--
-- TOC entry 2462 (class 2604 OID 17428)
-- Dependencies: 219 218 219
-- Name: ucm_id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_ucm_base ALTER COLUMN ucm_id SET DEFAULT nextval('xfv02_ucm_base_ucm_id_seq'::regclass);


--
-- TOC entry 2463 (class 2604 OID 17439)
-- Dependencies: 221 220 221
-- Name: core_content_id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_ucm_content ALTER COLUMN core_content_id SET DEFAULT nextval('xfv02_ucm_content_core_content_id_seq'::regclass);


--
-- TOC entry 2487 (class 2604 OID 17487)
-- Dependencies: 222 223 223
-- Name: version_id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_ucm_history ALTER COLUMN version_id SET DEFAULT nextval('xfv02_ucm_history_version_id_seq'::regclass);


--
-- TOC entry 2504 (class 2604 OID 17526)
-- Dependencies: 226 227 227
-- Name: update_site_id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_update_sites ALTER COLUMN update_site_id SET DEFAULT nextval('xfv02_update_sites_update_site_id_seq'::regclass);


--
-- TOC entry 2494 (class 2604 OID 17506)
-- Dependencies: 224 225 225
-- Name: update_id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_updates ALTER COLUMN update_id SET DEFAULT nextval('xfv02_updates_update_id_seq'::regclass);


--
-- TOC entry 2532 (class 2604 OID 17600)
-- Dependencies: 234 235 235
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_user_keys ALTER COLUMN id SET DEFAULT nextval('xfv02_user_keys_id_seq'::regclass);


--
-- TOC entry 2537 (class 2604 OID 17614)
-- Dependencies: 237 236 237
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_user_notes ALTER COLUMN id SET DEFAULT nextval('xfv02_user_notes_id_seq'::regclass);


--
-- TOC entry 2511 (class 2604 OID 17548)
-- Dependencies: 229 230 230
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_usergroups ALTER COLUMN id SET DEFAULT nextval('xfv02_usergroups_id_seq'::regclass);


--
-- TOC entry 2518 (class 2604 OID 17572)
-- Dependencies: 232 233 233
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_users ALTER COLUMN id SET DEFAULT nextval('xfv02_users_id_seq'::regclass);


--
-- TOC entry 2547 (class 2604 OID 17645)
-- Dependencies: 240 239 240
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_viewlevels ALTER COLUMN id SET DEFAULT nextval('xfv02_viewlevels_id_seq'::regclass);


--
-- TOC entry 2550 (class 2604 OID 17660)
-- Dependencies: 241 242 242
-- Name: id; Type: DEFAULT; Schema: public; Owner: j30
--

ALTER TABLE ONLY xfv02_weblinks ALTER COLUMN id SET DEFAULT nextval('xfv02_weblinks_id_seq'::regclass);


--
-- TOC entry 2572 (class 2606 OID 16594)
-- Dependencies: 141 141
-- Name: xfv02_assets_idx_asset_name; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_assets
    ADD CONSTRAINT xfv02_assets_idx_asset_name UNIQUE (name);


--
-- TOC entry 2576 (class 2606 OID 16592)
-- Dependencies: 141 141
-- Name: xfv02_assets_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_assets
    ADD CONSTRAINT xfv02_assets_pkey PRIMARY KEY (id);


--
-- TOC entry 2578 (class 2606 OID 16601)
-- Dependencies: 142 142 142
-- Name: xfv02_associations_idx_context_id; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_associations
    ADD CONSTRAINT xfv02_associations_idx_context_id PRIMARY KEY (context, id);


--
-- TOC entry 2590 (class 2606 OID 16669)
-- Dependencies: 146 146
-- Name: xfv02_banner_clients_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_banner_clients
    ADD CONSTRAINT xfv02_banner_clients_pkey PRIMARY KEY (id);


--
-- TOC entry 2595 (class 2606 OID 16677)
-- Dependencies: 147 147 147 147
-- Name: xfv02_banner_tracks_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_banner_tracks
    ADD CONSTRAINT xfv02_banner_tracks_pkey PRIMARY KEY (track_date, track_type, banner_id);


--
-- TOC entry 2586 (class 2606 OID 16642)
-- Dependencies: 144 144
-- Name: xfv02_banners_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_banners
    ADD CONSTRAINT xfv02_banners_pkey PRIMARY KEY (id);


--
-- TOC entry 2604 (class 2606 OID 16712)
-- Dependencies: 149 149
-- Name: xfv02_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_categories
    ADD CONSTRAINT xfv02_categories_pkey PRIMARY KEY (id);


--
-- TOC entry 2614 (class 2606 OID 16762)
-- Dependencies: 151 151
-- Name: xfv02_contact_details_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_contact_details
    ADD CONSTRAINT xfv02_contact_details_pkey PRIMARY KEY (id);


--
-- TOC entry 2626 (class 2606 OID 16817)
-- Dependencies: 154 154
-- Name: xfv02_content_frontpage_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_content_frontpage
    ADD CONSTRAINT xfv02_content_frontpage_pkey PRIMARY KEY (content_id);


--
-- TOC entry 2624 (class 2606 OID 16802)
-- Dependencies: 153 153
-- Name: xfv02_content_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_content
    ADD CONSTRAINT xfv02_content_pkey PRIMARY KEY (id);


--
-- TOC entry 2628 (class 2606 OID 16826)
-- Dependencies: 155 155
-- Name: xfv02_content_rating_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_content_rating
    ADD CONSTRAINT xfv02_content_rating_pkey PRIMARY KEY (content_id);


--
-- TOC entry 2631 (class 2606 OID 16842)
-- Dependencies: 157 157
-- Name: xfv02_content_types_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_content_types
    ADD CONSTRAINT xfv02_content_types_pkey PRIMARY KEY (type_id);


--
-- TOC entry 2643 (class 2606 OID 16880)
-- Dependencies: 161 161
-- Name: xfv02_extensions_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_extensions
    ADD CONSTRAINT xfv02_extensions_pkey PRIMARY KEY (extension_id);


--
-- TOC entry 2645 (class 2606 OID 16901)
-- Dependencies: 163 163
-- Name: xfv02_finder_filters_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_filters
    ADD CONSTRAINT xfv02_finder_filters_pkey PRIMARY KEY (filter_id);


--
-- TOC entry 2653 (class 2606 OID 16926)
-- Dependencies: 165 165
-- Name: xfv02_finder_links_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_links
    ADD CONSTRAINT xfv02_finder_links_pkey PRIMARY KEY (link_id);


--
-- TOC entry 2657 (class 2606 OID 16937)
-- Dependencies: 166 166 166
-- Name: xfv02_finder_links_terms0_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_links_terms0
    ADD CONSTRAINT xfv02_finder_links_terms0_pkey PRIMARY KEY (link_id, term_id);


--
-- TOC entry 2661 (class 2606 OID 16944)
-- Dependencies: 167 167 167
-- Name: xfv02_finder_links_terms1_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_links_terms1
    ADD CONSTRAINT xfv02_finder_links_terms1_pkey PRIMARY KEY (link_id, term_id);


--
-- TOC entry 2665 (class 2606 OID 16951)
-- Dependencies: 168 168 168
-- Name: xfv02_finder_links_terms2_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_links_terms2
    ADD CONSTRAINT xfv02_finder_links_terms2_pkey PRIMARY KEY (link_id, term_id);


--
-- TOC entry 2669 (class 2606 OID 16958)
-- Dependencies: 169 169 169
-- Name: xfv02_finder_links_terms3_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_links_terms3
    ADD CONSTRAINT xfv02_finder_links_terms3_pkey PRIMARY KEY (link_id, term_id);


--
-- TOC entry 2673 (class 2606 OID 16965)
-- Dependencies: 170 170 170
-- Name: xfv02_finder_links_terms4_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_links_terms4
    ADD CONSTRAINT xfv02_finder_links_terms4_pkey PRIMARY KEY (link_id, term_id);


--
-- TOC entry 2677 (class 2606 OID 16972)
-- Dependencies: 171 171 171
-- Name: xfv02_finder_links_terms5_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_links_terms5
    ADD CONSTRAINT xfv02_finder_links_terms5_pkey PRIMARY KEY (link_id, term_id);


--
-- TOC entry 2681 (class 2606 OID 16979)
-- Dependencies: 172 172 172
-- Name: xfv02_finder_links_terms6_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_links_terms6
    ADD CONSTRAINT xfv02_finder_links_terms6_pkey PRIMARY KEY (link_id, term_id);


--
-- TOC entry 2685 (class 2606 OID 16986)
-- Dependencies: 173 173 173
-- Name: xfv02_finder_links_terms7_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_links_terms7
    ADD CONSTRAINT xfv02_finder_links_terms7_pkey PRIMARY KEY (link_id, term_id);


--
-- TOC entry 2689 (class 2606 OID 16993)
-- Dependencies: 174 174 174
-- Name: xfv02_finder_links_terms8_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_links_terms8
    ADD CONSTRAINT xfv02_finder_links_terms8_pkey PRIMARY KEY (link_id, term_id);


--
-- TOC entry 2693 (class 2606 OID 17000)
-- Dependencies: 175 175 175
-- Name: xfv02_finder_links_terms9_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_links_terms9
    ADD CONSTRAINT xfv02_finder_links_terms9_pkey PRIMARY KEY (link_id, term_id);


--
-- TOC entry 2697 (class 2606 OID 17007)
-- Dependencies: 176 176 176
-- Name: xfv02_finder_links_termsa_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_links_termsa
    ADD CONSTRAINT xfv02_finder_links_termsa_pkey PRIMARY KEY (link_id, term_id);


--
-- TOC entry 2701 (class 2606 OID 17014)
-- Dependencies: 177 177 177
-- Name: xfv02_finder_links_termsb_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_links_termsb
    ADD CONSTRAINT xfv02_finder_links_termsb_pkey PRIMARY KEY (link_id, term_id);


--
-- TOC entry 2705 (class 2606 OID 17021)
-- Dependencies: 178 178 178
-- Name: xfv02_finder_links_termsc_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_links_termsc
    ADD CONSTRAINT xfv02_finder_links_termsc_pkey PRIMARY KEY (link_id, term_id);


--
-- TOC entry 2709 (class 2606 OID 17028)
-- Dependencies: 179 179 179
-- Name: xfv02_finder_links_termsd_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_links_termsd
    ADD CONSTRAINT xfv02_finder_links_termsd_pkey PRIMARY KEY (link_id, term_id);


--
-- TOC entry 2713 (class 2606 OID 17035)
-- Dependencies: 180 180 180
-- Name: xfv02_finder_links_termse_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_links_termse
    ADD CONSTRAINT xfv02_finder_links_termse_pkey PRIMARY KEY (link_id, term_id);


--
-- TOC entry 2717 (class 2606 OID 17042)
-- Dependencies: 181 181 181
-- Name: xfv02_finder_links_termsf_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_links_termsf
    ADD CONSTRAINT xfv02_finder_links_termsf_pkey PRIMARY KEY (link_id, term_id);


--
-- TOC entry 2728 (class 2606 OID 17066)
-- Dependencies: 184 184 184
-- Name: xfv02_finder_taxonomy_map_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_taxonomy_map
    ADD CONSTRAINT xfv02_finder_taxonomy_map_pkey PRIMARY KEY (link_id, node_id);


--
-- TOC entry 2723 (class 2606 OID 17056)
-- Dependencies: 183 183
-- Name: xfv02_finder_taxonomy_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_taxonomy
    ADD CONSTRAINT xfv02_finder_taxonomy_pkey PRIMARY KEY (id);


--
-- TOC entry 2732 (class 2606 OID 17082)
-- Dependencies: 186 186
-- Name: xfv02_finder_terms_idx_term; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_terms
    ADD CONSTRAINT xfv02_finder_terms_idx_term UNIQUE (term);


--
-- TOC entry 2735 (class 2606 OID 17080)
-- Dependencies: 186 186
-- Name: xfv02_finder_terms_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_terms
    ADD CONSTRAINT xfv02_finder_terms_pkey PRIMARY KEY (term_id);


--
-- TOC entry 2743 (class 2606 OID 17116)
-- Dependencies: 191 191
-- Name: xfv02_finder_types_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_types
    ADD CONSTRAINT xfv02_finder_types_pkey PRIMARY KEY (id);


--
-- TOC entry 2745 (class 2606 OID 17118)
-- Dependencies: 191 191
-- Name: xfv02_finder_types_title; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_finder_types
    ADD CONSTRAINT xfv02_finder_types_title UNIQUE (title);


--
-- TOC entry 2748 (class 2606 OID 17137)
-- Dependencies: 193 193
-- Name: xfv02_languages_idx_image; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_languages
    ADD CONSTRAINT xfv02_languages_idx_image UNIQUE (image);


--
-- TOC entry 2750 (class 2606 OID 17139)
-- Dependencies: 193 193
-- Name: xfv02_languages_idx_langcode; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_languages
    ADD CONSTRAINT xfv02_languages_idx_langcode UNIQUE (lang_code);


--
-- TOC entry 2753 (class 2606 OID 17135)
-- Dependencies: 193 193
-- Name: xfv02_languages_idx_sef; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_languages
    ADD CONSTRAINT xfv02_languages_idx_sef UNIQUE (sef);


--
-- TOC entry 2755 (class 2606 OID 17133)
-- Dependencies: 193 193
-- Name: xfv02_languages_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_languages
    ADD CONSTRAINT xfv02_languages_pkey PRIMARY KEY (lang_id);


--
-- TOC entry 2758 (class 2606 OID 17172)
-- Dependencies: 195 195 195 195 195
-- Name: xfv02_menu_idx_client_id_parent_id_alias_language; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_menu
    ADD CONSTRAINT xfv02_menu_idx_client_id_parent_id_alias_language UNIQUE (client_id, parent_id, alias, language);


--
-- TOC entry 2765 (class 2606 OID 17170)
-- Dependencies: 195 195
-- Name: xfv02_menu_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_menu
    ADD CONSTRAINT xfv02_menu_pkey PRIMARY KEY (id);


--
-- TOC entry 2767 (class 2606 OID 17189)
-- Dependencies: 197 197
-- Name: xfv02_menu_types_idx_menutype; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_menu_types
    ADD CONSTRAINT xfv02_menu_types_idx_menutype UNIQUE (menutype);


--
-- TOC entry 2769 (class 2606 OID 17187)
-- Dependencies: 197 197
-- Name: xfv02_menu_types_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_menu_types
    ADD CONSTRAINT xfv02_menu_types_pkey PRIMARY KEY (id);


--
-- TOC entry 2774 (class 2606 OID 17216)
-- Dependencies: 200 200 200
-- Name: xfv02_messages_cfg_idx_user_var_name; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_messages_cfg
    ADD CONSTRAINT xfv02_messages_cfg_idx_user_var_name UNIQUE (user_id, cfg_name);


--
-- TOC entry 2771 (class 2606 OID 17207)
-- Dependencies: 199 199
-- Name: xfv02_messages_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_messages
    ADD CONSTRAINT xfv02_messages_pkey PRIMARY KEY (message_id);


--
-- TOC entry 2781 (class 2606 OID 17252)
-- Dependencies: 203 203 203
-- Name: xfv02_modules_menu_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_modules_menu
    ADD CONSTRAINT xfv02_modules_menu_pkey PRIMARY KEY (moduleid, menuid);


--
-- TOC entry 2778 (class 2606 OID 17242)
-- Dependencies: 202 202
-- Name: xfv02_modules_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_modules
    ADD CONSTRAINT xfv02_modules_pkey PRIMARY KEY (id);


--
-- TOC entry 2790 (class 2606 OID 17285)
-- Dependencies: 205 205
-- Name: xfv02_newsfeeds_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_newsfeeds
    ADD CONSTRAINT xfv02_newsfeeds_pkey PRIMARY KEY (id);


--
-- TOC entry 2792 (class 2606 OID 17303)
-- Dependencies: 207 207
-- Name: xfv02_overrider_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_overrider
    ADD CONSTRAINT xfv02_overrider_pkey PRIMARY KEY (id);


--
-- TOC entry 2794 (class 2606 OID 17327)
-- Dependencies: 209 209
-- Name: xfv02_postinstall_messages_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_postinstall_messages
    ADD CONSTRAINT xfv02_postinstall_messages_pkey PRIMARY KEY (postinstall_message_id);


--
-- TOC entry 2797 (class 2606 OID 17343)
-- Dependencies: 211 211
-- Name: xfv02_redirect_links_idx_link_old; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_redirect_links
    ADD CONSTRAINT xfv02_redirect_links_idx_link_old UNIQUE (old_url);


--
-- TOC entry 2799 (class 2606 OID 17341)
-- Dependencies: 211 211
-- Name: xfv02_redirect_links_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_redirect_links
    ADD CONSTRAINT xfv02_redirect_links_pkey PRIMARY KEY (id);


--
-- TOC entry 2801 (class 2606 OID 17349)
-- Dependencies: 212 212 212
-- Name: xfv02_schemas_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_schemas
    ADD CONSTRAINT xfv02_schemas_pkey PRIMARY KEY (extension_id, version_id);


--
-- TOC entry 2803 (class 2606 OID 17363)
-- Dependencies: 213 213
-- Name: xfv02_session_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_session
    ADD CONSTRAINT xfv02_session_pkey PRIMARY KEY (session_id);


--
-- TOC entry 2814 (class 2606 OID 17398)
-- Dependencies: 215 215
-- Name: xfv02_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_tags
    ADD CONSTRAINT xfv02_tags_pkey PRIMARY KEY (id);


--
-- TOC entry 2818 (class 2606 OID 17420)
-- Dependencies: 217 217
-- Name: xfv02_template_styles_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_template_styles
    ADD CONSTRAINT xfv02_template_styles_pkey PRIMARY KEY (id);


--
-- TOC entry 2638 (class 2606 OID 16850)
-- Dependencies: 158 158 158 158
-- Name: xfv02_uc_ItemnameTagid; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_contentitem_tag_map
    ADD CONSTRAINT "xfv02_uc_ItemnameTagid" UNIQUE (type_alias, content_item_id, tag_id);


--
-- TOC entry 2820 (class 2606 OID 17430)
-- Dependencies: 219 219
-- Name: xfv02_ucm_base_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_ucm_base
    ADD CONSTRAINT xfv02_ucm_base_pkey PRIMARY KEY (ucm_id);


--
-- TOC entry 2836 (class 2606 OID 17469)
-- Dependencies: 221 221 221
-- Name: xfv02_ucm_content_idx_type_alias_item_id; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_ucm_content
    ADD CONSTRAINT xfv02_ucm_content_idx_type_alias_item_id UNIQUE (core_type_alias, core_content_item_id);


--
-- TOC entry 2838 (class 2606 OID 17467)
-- Dependencies: 221 221
-- Name: xfv02_ucm_content_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_ucm_content
    ADD CONSTRAINT xfv02_ucm_content_pkey PRIMARY KEY (core_content_id);


--
-- TOC entry 2843 (class 2606 OID 17498)
-- Dependencies: 223 223
-- Name: xfv02_ucm_history_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_ucm_history
    ADD CONSTRAINT xfv02_ucm_history_pkey PRIMARY KEY (version_id);


--
-- TOC entry 2849 (class 2606 OID 17542)
-- Dependencies: 228 228 228
-- Name: xfv02_update_sites_extensions_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_update_sites_extensions
    ADD CONSTRAINT xfv02_update_sites_extensions_pkey PRIMARY KEY (update_site_id, extension_id);


--
-- TOC entry 2847 (class 2606 OID 17535)
-- Dependencies: 227 227
-- Name: xfv02_update_sites_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_update_sites
    ADD CONSTRAINT xfv02_update_sites_pkey PRIMARY KEY (update_site_id);


--
-- TOC entry 2845 (class 2606 OID 17520)
-- Dependencies: 225 225
-- Name: xfv02_updates_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_updates
    ADD CONSTRAINT xfv02_updates_pkey PRIMARY KEY (update_id);


--
-- TOC entry 2867 (class 2606 OID 17605)
-- Dependencies: 235 235
-- Name: xfv02_user_keys_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_user_keys
    ADD CONSTRAINT xfv02_user_keys_pkey PRIMARY KEY (id);


--
-- TOC entry 2869 (class 2606 OID 17607)
-- Dependencies: 235 235
-- Name: xfv02_user_keys_series; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_user_keys
    ADD CONSTRAINT xfv02_user_keys_series UNIQUE (series);


--
-- TOC entry 2873 (class 2606 OID 17631)
-- Dependencies: 237 237
-- Name: xfv02_user_notes_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_user_notes
    ADD CONSTRAINT xfv02_user_notes_pkey PRIMARY KEY (id);


--
-- TOC entry 2875 (class 2606 OID 17639)
-- Dependencies: 238 238 238
-- Name: xfv02_user_profiles_idx_user_id_profile_key; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_user_profiles
    ADD CONSTRAINT xfv02_user_profiles_idx_user_id_profile_key UNIQUE (user_id, profile_key);


--
-- TOC entry 2858 (class 2606 OID 17566)
-- Dependencies: 231 231 231
-- Name: xfv02_user_usergroup_map_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_user_usergroup_map
    ADD CONSTRAINT xfv02_user_usergroup_map_pkey PRIMARY KEY (user_id, group_id);


--
-- TOC entry 2853 (class 2606 OID 17556)
-- Dependencies: 230 230 230
-- Name: xfv02_usergroups_idx_usergroup_parent_title_lookup; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_usergroups
    ADD CONSTRAINT xfv02_usergroups_idx_usergroup_parent_title_lookup UNIQUE (parent_id, title);


--
-- TOC entry 2856 (class 2606 OID 17554)
-- Dependencies: 230 230
-- Name: xfv02_usergroups_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_usergroups
    ADD CONSTRAINT xfv02_usergroups_pkey PRIMARY KEY (id);


--
-- TOC entry 2863 (class 2606 OID 17590)
-- Dependencies: 233 233
-- Name: xfv02_users_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_users
    ADD CONSTRAINT xfv02_users_pkey PRIMARY KEY (id);


--
-- TOC entry 2877 (class 2606 OID 17654)
-- Dependencies: 240 240
-- Name: xfv02_viewlevels_idx_assetgroup_title_lookup; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_viewlevels
    ADD CONSTRAINT xfv02_viewlevels_idx_assetgroup_title_lookup UNIQUE (title);


--
-- TOC entry 2879 (class 2606 OID 17652)
-- Dependencies: 240 240
-- Name: xfv02_viewlevels_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_viewlevels
    ADD CONSTRAINT xfv02_viewlevels_pkey PRIMARY KEY (id);


--
-- TOC entry 2889 (class 2606 OID 17685)
-- Dependencies: 242 242
-- Name: xfv02_weblinks_pkey; Type: CONSTRAINT; Schema: public; Owner: j30; Tablespace: 
--

ALTER TABLE ONLY xfv02_weblinks
    ADD CONSTRAINT xfv02_weblinks_pkey PRIMARY KEY (id);


--
-- TOC entry 2740 (class 1259 OID 17108)
-- Dependencies: 189
-- Name: _xfv02_finder_tokens_aggregate_keyword_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX _xfv02_finder_tokens_aggregate_keyword_id ON xfv02_finder_tokens_aggregate USING btree (term_id);


--
-- TOC entry 2573 (class 1259 OID 16595)
-- Dependencies: 141 141
-- Name: xfv02_assets_idx_lft_rgt; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_assets_idx_lft_rgt ON xfv02_assets USING btree (lft, rgt);


--
-- TOC entry 2574 (class 1259 OID 16596)
-- Dependencies: 141
-- Name: xfv02_assets_idx_parent_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_assets_idx_parent_id ON xfv02_assets USING btree (parent_id);


--
-- TOC entry 2579 (class 1259 OID 16602)
-- Dependencies: 142
-- Name: xfv02_associations_idx_key; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_associations_idx_key ON xfv02_associations USING btree (key);


--
-- TOC entry 2587 (class 1259 OID 16671)
-- Dependencies: 146
-- Name: xfv02_banner_clients_idx_metakey_prefix; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_banner_clients_idx_metakey_prefix ON xfv02_banner_clients USING btree (metakey_prefix);


--
-- TOC entry 2588 (class 1259 OID 16670)
-- Dependencies: 146
-- Name: xfv02_banner_clients_idx_own_prefix; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_banner_clients_idx_own_prefix ON xfv02_banner_clients USING btree (own_prefix);


--
-- TOC entry 2591 (class 1259 OID 16680)
-- Dependencies: 147
-- Name: xfv02_banner_tracks_idx_banner_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_banner_tracks_idx_banner_id ON xfv02_banner_tracks USING btree (banner_id);


--
-- TOC entry 2592 (class 1259 OID 16678)
-- Dependencies: 147
-- Name: xfv02_banner_tracks_idx_track_date; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_banner_tracks_idx_track_date ON xfv02_banner_tracks USING btree (track_date);


--
-- TOC entry 2593 (class 1259 OID 16679)
-- Dependencies: 147
-- Name: xfv02_banner_tracks_idx_track_type; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_banner_tracks_idx_track_type ON xfv02_banner_tracks USING btree (track_type);


--
-- TOC entry 2580 (class 1259 OID 16646)
-- Dependencies: 144
-- Name: xfv02_banners_idx_banner_catid; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_banners_idx_banner_catid ON xfv02_banners USING btree (catid);


--
-- TOC entry 2581 (class 1259 OID 16647)
-- Dependencies: 144
-- Name: xfv02_banners_idx_language; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_banners_idx_language ON xfv02_banners USING btree (language);


--
-- TOC entry 2582 (class 1259 OID 16645)
-- Dependencies: 144
-- Name: xfv02_banners_idx_metakey_prefix; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_banners_idx_metakey_prefix ON xfv02_banners USING btree (metakey_prefix);


--
-- TOC entry 2583 (class 1259 OID 16644)
-- Dependencies: 144
-- Name: xfv02_banners_idx_own_prefix; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_banners_idx_own_prefix ON xfv02_banners USING btree (own_prefix);


--
-- TOC entry 2584 (class 1259 OID 16643)
-- Dependencies: 144
-- Name: xfv02_banners_idx_state; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_banners_idx_state ON xfv02_banners USING btree (state);


--
-- TOC entry 2596 (class 1259 OID 16713)
-- Dependencies: 149 149 149
-- Name: xfv02_categories_cat_idx; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_categories_cat_idx ON xfv02_categories USING btree (extension, published, access);


--
-- TOC entry 2597 (class 1259 OID 16714)
-- Dependencies: 149
-- Name: xfv02_categories_idx_access; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_categories_idx_access ON xfv02_categories USING btree (access);


--
-- TOC entry 2598 (class 1259 OID 16718)
-- Dependencies: 149
-- Name: xfv02_categories_idx_alias; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_categories_idx_alias ON xfv02_categories USING btree (alias);


--
-- TOC entry 2599 (class 1259 OID 16715)
-- Dependencies: 149
-- Name: xfv02_categories_idx_checkout; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_categories_idx_checkout ON xfv02_categories USING btree (checked_out);


--
-- TOC entry 2600 (class 1259 OID 16719)
-- Dependencies: 149
-- Name: xfv02_categories_idx_language; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_categories_idx_language ON xfv02_categories USING btree (language);


--
-- TOC entry 2601 (class 1259 OID 16717)
-- Dependencies: 149 149
-- Name: xfv02_categories_idx_left_right; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_categories_idx_left_right ON xfv02_categories USING btree (lft, rgt);


--
-- TOC entry 2602 (class 1259 OID 16716)
-- Dependencies: 149
-- Name: xfv02_categories_idx_path; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_categories_idx_path ON xfv02_categories USING btree (path);


--
-- TOC entry 2605 (class 1259 OID 16763)
-- Dependencies: 151
-- Name: xfv02_contact_details_idx_access; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_contact_details_idx_access ON xfv02_contact_details USING btree (access);


--
-- TOC entry 2606 (class 1259 OID 16766)
-- Dependencies: 151
-- Name: xfv02_contact_details_idx_catid; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_contact_details_idx_catid ON xfv02_contact_details USING btree (catid);


--
-- TOC entry 2607 (class 1259 OID 16764)
-- Dependencies: 151
-- Name: xfv02_contact_details_idx_checkout; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_contact_details_idx_checkout ON xfv02_contact_details USING btree (checked_out);


--
-- TOC entry 2608 (class 1259 OID 16767)
-- Dependencies: 151
-- Name: xfv02_contact_details_idx_createdby; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_contact_details_idx_createdby ON xfv02_contact_details USING btree (created_by);


--
-- TOC entry 2609 (class 1259 OID 16768)
-- Dependencies: 151 151
-- Name: xfv02_contact_details_idx_featured_catid; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_contact_details_idx_featured_catid ON xfv02_contact_details USING btree (featured, catid);


--
-- TOC entry 2610 (class 1259 OID 16769)
-- Dependencies: 151
-- Name: xfv02_contact_details_idx_language; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_contact_details_idx_language ON xfv02_contact_details USING btree (language);


--
-- TOC entry 2611 (class 1259 OID 16765)
-- Dependencies: 151
-- Name: xfv02_contact_details_idx_state; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_contact_details_idx_state ON xfv02_contact_details USING btree (published);


--
-- TOC entry 2612 (class 1259 OID 16770)
-- Dependencies: 151
-- Name: xfv02_contact_details_idx_xreference; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_contact_details_idx_xreference ON xfv02_contact_details USING btree (xreference);


--
-- TOC entry 2615 (class 1259 OID 16803)
-- Dependencies: 153
-- Name: xfv02_content_idx_access; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_content_idx_access ON xfv02_content USING btree (access);


--
-- TOC entry 2616 (class 1259 OID 16806)
-- Dependencies: 153
-- Name: xfv02_content_idx_catid; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_content_idx_catid ON xfv02_content USING btree (catid);


--
-- TOC entry 2617 (class 1259 OID 16804)
-- Dependencies: 153
-- Name: xfv02_content_idx_checkout; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_content_idx_checkout ON xfv02_content USING btree (checked_out);


--
-- TOC entry 2618 (class 1259 OID 16807)
-- Dependencies: 153
-- Name: xfv02_content_idx_createdby; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_content_idx_createdby ON xfv02_content USING btree (created_by);


--
-- TOC entry 2619 (class 1259 OID 16808)
-- Dependencies: 153 153
-- Name: xfv02_content_idx_featured_catid; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_content_idx_featured_catid ON xfv02_content USING btree (featured, catid);


--
-- TOC entry 2620 (class 1259 OID 16809)
-- Dependencies: 153
-- Name: xfv02_content_idx_language; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_content_idx_language ON xfv02_content USING btree (language);


--
-- TOC entry 2621 (class 1259 OID 16805)
-- Dependencies: 153
-- Name: xfv02_content_idx_state; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_content_idx_state ON xfv02_content USING btree (state);


--
-- TOC entry 2622 (class 1259 OID 16810)
-- Dependencies: 153
-- Name: xfv02_content_idx_xreference; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_content_idx_xreference ON xfv02_content USING btree (xreference);


--
-- TOC entry 2629 (class 1259 OID 16843)
-- Dependencies: 157
-- Name: xfv02_content_types_idx_alias; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_content_types_idx_alias ON xfv02_content_types USING btree (type_alias);


--
-- TOC entry 2632 (class 1259 OID 16855)
-- Dependencies: 158
-- Name: xfv02_contentitem_tag_map_idx_core_content_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_contentitem_tag_map_idx_core_content_id ON xfv02_contentitem_tag_map USING btree (core_content_id);


--
-- TOC entry 2633 (class 1259 OID 16852)
-- Dependencies: 158 158
-- Name: xfv02_contentitem_tag_map_idx_date_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_contentitem_tag_map_idx_date_id ON xfv02_contentitem_tag_map USING btree (tag_date, tag_id);


--
-- TOC entry 2634 (class 1259 OID 16853)
-- Dependencies: 158
-- Name: xfv02_contentitem_tag_map_idx_tag; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_contentitem_tag_map_idx_tag ON xfv02_contentitem_tag_map USING btree (tag_id);


--
-- TOC entry 2635 (class 1259 OID 16851)
-- Dependencies: 158 158
-- Name: xfv02_contentitem_tag_map_idx_tag_type; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_contentitem_tag_map_idx_tag_type ON xfv02_contentitem_tag_map USING btree (tag_id, type_id);


--
-- TOC entry 2636 (class 1259 OID 16854)
-- Dependencies: 158
-- Name: xfv02_contentitem_tag_map_idx_type; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_contentitem_tag_map_idx_type ON xfv02_contentitem_tag_map USING btree (type_id);


--
-- TOC entry 2639 (class 1259 OID 16881)
-- Dependencies: 161 161
-- Name: xfv02_extensions_element_clientid; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_extensions_element_clientid ON xfv02_extensions USING btree (element, client_id);


--
-- TOC entry 2640 (class 1259 OID 16882)
-- Dependencies: 161 161 161
-- Name: xfv02_extensions_element_folder_clientid; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_extensions_element_folder_clientid ON xfv02_extensions USING btree (element, folder, client_id);


--
-- TOC entry 2641 (class 1259 OID 16883)
-- Dependencies: 161 161 161 161
-- Name: xfv02_extensions_extension; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_extensions_extension ON xfv02_extensions USING btree (type, element, folder, client_id);


--
-- TOC entry 2646 (class 1259 OID 16929)
-- Dependencies: 165
-- Name: xfv02_finder_links_idx_md5; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_idx_md5 ON xfv02_finder_links USING btree (md5sum);


--
-- TOC entry 2647 (class 1259 OID 16931)
-- Dependencies: 165 165 165 165 165 165
-- Name: xfv02_finder_links_idx_published_list; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_idx_published_list ON xfv02_finder_links USING btree (published, state, access, publish_start_date, publish_end_date, list_price);


--
-- TOC entry 2648 (class 1259 OID 16932)
-- Dependencies: 165 165 165 165 165 165
-- Name: xfv02_finder_links_idx_published_sale; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_idx_published_sale ON xfv02_finder_links USING btree (published, state, access, publish_start_date, publish_end_date, sale_price);


--
-- TOC entry 2649 (class 1259 OID 16928)
-- Dependencies: 165
-- Name: xfv02_finder_links_idx_title; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_idx_title ON xfv02_finder_links USING btree (title);


--
-- TOC entry 2650 (class 1259 OID 16927)
-- Dependencies: 165
-- Name: xfv02_finder_links_idx_type; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_idx_type ON xfv02_finder_links USING btree (type_id);


--
-- TOC entry 2651 (class 1259 OID 16930)
-- Dependencies: 165 165
-- Name: xfv02_finder_links_idx_url; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_idx_url ON xfv02_finder_links USING btree (substr((url)::text, 0, 76));


--
-- TOC entry 2654 (class 1259 OID 16939)
-- Dependencies: 166 166 166
-- Name: xfv02_finder_links_terms0_idx_link_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms0_idx_link_term_weight ON xfv02_finder_links_terms0 USING btree (link_id, term_id, weight);


--
-- TOC entry 2655 (class 1259 OID 16938)
-- Dependencies: 166 166
-- Name: xfv02_finder_links_terms0_idx_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms0_idx_term_weight ON xfv02_finder_links_terms0 USING btree (term_id, weight);


--
-- TOC entry 2658 (class 1259 OID 16946)
-- Dependencies: 167 167 167
-- Name: xfv02_finder_links_terms1_idx_link_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms1_idx_link_term_weight ON xfv02_finder_links_terms1 USING btree (link_id, term_id, weight);


--
-- TOC entry 2659 (class 1259 OID 16945)
-- Dependencies: 167 167
-- Name: xfv02_finder_links_terms1_idx_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms1_idx_term_weight ON xfv02_finder_links_terms1 USING btree (term_id, weight);


--
-- TOC entry 2662 (class 1259 OID 16953)
-- Dependencies: 168 168 168
-- Name: xfv02_finder_links_terms2_idx_link_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms2_idx_link_term_weight ON xfv02_finder_links_terms2 USING btree (link_id, term_id, weight);


--
-- TOC entry 2663 (class 1259 OID 16952)
-- Dependencies: 168 168
-- Name: xfv02_finder_links_terms2_idx_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms2_idx_term_weight ON xfv02_finder_links_terms2 USING btree (term_id, weight);


--
-- TOC entry 2666 (class 1259 OID 16960)
-- Dependencies: 169 169 169
-- Name: xfv02_finder_links_terms3_idx_link_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms3_idx_link_term_weight ON xfv02_finder_links_terms3 USING btree (link_id, term_id, weight);


--
-- TOC entry 2667 (class 1259 OID 16959)
-- Dependencies: 169 169
-- Name: xfv02_finder_links_terms3_idx_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms3_idx_term_weight ON xfv02_finder_links_terms3 USING btree (term_id, weight);


--
-- TOC entry 2670 (class 1259 OID 16967)
-- Dependencies: 170 170 170
-- Name: xfv02_finder_links_terms4_idx_link_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms4_idx_link_term_weight ON xfv02_finder_links_terms4 USING btree (link_id, term_id, weight);


--
-- TOC entry 2671 (class 1259 OID 16966)
-- Dependencies: 170 170
-- Name: xfv02_finder_links_terms4_idx_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms4_idx_term_weight ON xfv02_finder_links_terms4 USING btree (term_id, weight);


--
-- TOC entry 2674 (class 1259 OID 16974)
-- Dependencies: 171 171 171
-- Name: xfv02_finder_links_terms5_idx_link_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms5_idx_link_term_weight ON xfv02_finder_links_terms5 USING btree (link_id, term_id, weight);


--
-- TOC entry 2675 (class 1259 OID 16973)
-- Dependencies: 171 171
-- Name: xfv02_finder_links_terms5_idx_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms5_idx_term_weight ON xfv02_finder_links_terms5 USING btree (term_id, weight);


--
-- TOC entry 2678 (class 1259 OID 16981)
-- Dependencies: 172 172 172
-- Name: xfv02_finder_links_terms6_idx_link_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms6_idx_link_term_weight ON xfv02_finder_links_terms6 USING btree (link_id, term_id, weight);


--
-- TOC entry 2679 (class 1259 OID 16980)
-- Dependencies: 172 172
-- Name: xfv02_finder_links_terms6_idx_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms6_idx_term_weight ON xfv02_finder_links_terms6 USING btree (term_id, weight);


--
-- TOC entry 2682 (class 1259 OID 16988)
-- Dependencies: 173 173 173
-- Name: xfv02_finder_links_terms7_idx_link_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms7_idx_link_term_weight ON xfv02_finder_links_terms7 USING btree (link_id, term_id, weight);


--
-- TOC entry 2683 (class 1259 OID 16987)
-- Dependencies: 173 173
-- Name: xfv02_finder_links_terms7_idx_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms7_idx_term_weight ON xfv02_finder_links_terms7 USING btree (term_id, weight);


--
-- TOC entry 2686 (class 1259 OID 16995)
-- Dependencies: 174 174 174
-- Name: xfv02_finder_links_terms8_idx_link_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms8_idx_link_term_weight ON xfv02_finder_links_terms8 USING btree (link_id, term_id, weight);


--
-- TOC entry 2687 (class 1259 OID 16994)
-- Dependencies: 174 174
-- Name: xfv02_finder_links_terms8_idx_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms8_idx_term_weight ON xfv02_finder_links_terms8 USING btree (term_id, weight);


--
-- TOC entry 2690 (class 1259 OID 17002)
-- Dependencies: 175 175 175
-- Name: xfv02_finder_links_terms9_idx_link_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms9_idx_link_term_weight ON xfv02_finder_links_terms9 USING btree (link_id, term_id, weight);


--
-- TOC entry 2691 (class 1259 OID 17001)
-- Dependencies: 175 175
-- Name: xfv02_finder_links_terms9_idx_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_terms9_idx_term_weight ON xfv02_finder_links_terms9 USING btree (term_id, weight);


--
-- TOC entry 2694 (class 1259 OID 17009)
-- Dependencies: 176 176 176
-- Name: xfv02_finder_links_termsa_idx_link_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_termsa_idx_link_term_weight ON xfv02_finder_links_termsa USING btree (link_id, term_id, weight);


--
-- TOC entry 2695 (class 1259 OID 17008)
-- Dependencies: 176 176
-- Name: xfv02_finder_links_termsa_idx_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_termsa_idx_term_weight ON xfv02_finder_links_termsa USING btree (term_id, weight);


--
-- TOC entry 2698 (class 1259 OID 17016)
-- Dependencies: 177 177 177
-- Name: xfv02_finder_links_termsb_idx_link_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_termsb_idx_link_term_weight ON xfv02_finder_links_termsb USING btree (link_id, term_id, weight);


--
-- TOC entry 2699 (class 1259 OID 17015)
-- Dependencies: 177 177
-- Name: xfv02_finder_links_termsb_idx_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_termsb_idx_term_weight ON xfv02_finder_links_termsb USING btree (term_id, weight);


--
-- TOC entry 2702 (class 1259 OID 17023)
-- Dependencies: 178 178 178
-- Name: xfv02_finder_links_termsc_idx_link_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_termsc_idx_link_term_weight ON xfv02_finder_links_termsc USING btree (link_id, term_id, weight);


--
-- TOC entry 2703 (class 1259 OID 17022)
-- Dependencies: 178 178
-- Name: xfv02_finder_links_termsc_idx_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_termsc_idx_term_weight ON xfv02_finder_links_termsc USING btree (term_id, weight);


--
-- TOC entry 2706 (class 1259 OID 17030)
-- Dependencies: 179 179 179
-- Name: xfv02_finder_links_termsd_idx_link_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_termsd_idx_link_term_weight ON xfv02_finder_links_termsd USING btree (link_id, term_id, weight);


--
-- TOC entry 2707 (class 1259 OID 17029)
-- Dependencies: 179 179
-- Name: xfv02_finder_links_termsd_idx_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_termsd_idx_term_weight ON xfv02_finder_links_termsd USING btree (term_id, weight);


--
-- TOC entry 2710 (class 1259 OID 17037)
-- Dependencies: 180 180 180
-- Name: xfv02_finder_links_termse_idx_link_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_termse_idx_link_term_weight ON xfv02_finder_links_termse USING btree (link_id, term_id, weight);


--
-- TOC entry 2711 (class 1259 OID 17036)
-- Dependencies: 180 180
-- Name: xfv02_finder_links_termse_idx_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_termse_idx_term_weight ON xfv02_finder_links_termse USING btree (term_id, weight);


--
-- TOC entry 2714 (class 1259 OID 17044)
-- Dependencies: 181 181 181
-- Name: xfv02_finder_links_termsf_idx_link_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_termsf_idx_link_term_weight ON xfv02_finder_links_termsf USING btree (link_id, term_id, weight);


--
-- TOC entry 2715 (class 1259 OID 17043)
-- Dependencies: 181 181
-- Name: xfv02_finder_links_termsf_idx_term_weight; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_links_termsf_idx_term_weight ON xfv02_finder_links_termsf USING btree (term_id, weight);


--
-- TOC entry 2718 (class 1259 OID 17060)
-- Dependencies: 183
-- Name: xfv02_finder_taxonomy_access; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_taxonomy_access ON xfv02_finder_taxonomy USING btree (access);


--
-- TOC entry 2719 (class 1259 OID 17061)
-- Dependencies: 183 183 183
-- Name: xfv02_finder_taxonomy_idx_parent_published; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_taxonomy_idx_parent_published ON xfv02_finder_taxonomy USING btree (parent_id, state, access);


--
-- TOC entry 2725 (class 1259 OID 17067)
-- Dependencies: 184
-- Name: xfv02_finder_taxonomy_map_link_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_taxonomy_map_link_id ON xfv02_finder_taxonomy_map USING btree (link_id);


--
-- TOC entry 2726 (class 1259 OID 17068)
-- Dependencies: 184
-- Name: xfv02_finder_taxonomy_map_node_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_taxonomy_map_node_id ON xfv02_finder_taxonomy_map USING btree (node_id);


--
-- TOC entry 2720 (class 1259 OID 17059)
-- Dependencies: 183
-- Name: xfv02_finder_taxonomy_ordering; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_taxonomy_ordering ON xfv02_finder_taxonomy USING btree (ordering);


--
-- TOC entry 2721 (class 1259 OID 17057)
-- Dependencies: 183
-- Name: xfv02_finder_taxonomy_parent_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_taxonomy_parent_id ON xfv02_finder_taxonomy USING btree (parent_id);


--
-- TOC entry 2724 (class 1259 OID 17058)
-- Dependencies: 183
-- Name: xfv02_finder_taxonomy_state; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_taxonomy_state ON xfv02_finder_taxonomy USING btree (state);


--
-- TOC entry 2736 (class 1259 OID 17091)
-- Dependencies: 187
-- Name: xfv02_finder_terms_common_idx_lang; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_terms_common_idx_lang ON xfv02_finder_terms_common USING btree (language);


--
-- TOC entry 2737 (class 1259 OID 17090)
-- Dependencies: 187 187
-- Name: xfv02_finder_terms_common_idx_word_lang; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_terms_common_idx_word_lang ON xfv02_finder_terms_common USING btree (term, language);


--
-- TOC entry 2729 (class 1259 OID 17085)
-- Dependencies: 186 186
-- Name: xfv02_finder_terms_idx_soundex_phrase; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_terms_idx_soundex_phrase ON xfv02_finder_terms USING btree (soundex, phrase);


--
-- TOC entry 2730 (class 1259 OID 17084)
-- Dependencies: 186 186
-- Name: xfv02_finder_terms_idx_stem_phrase; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_terms_idx_stem_phrase ON xfv02_finder_terms USING btree (stem, phrase);


--
-- TOC entry 2733 (class 1259 OID 17083)
-- Dependencies: 186 186
-- Name: xfv02_finder_terms_idx_term_phrase; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_terms_idx_term_phrase ON xfv02_finder_terms USING btree (term, phrase);


--
-- TOC entry 2741 (class 1259 OID 17107)
-- Dependencies: 189
-- Name: xfv02_finder_tokens_aggregate_token; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_tokens_aggregate_token ON xfv02_finder_tokens_aggregate USING btree (term);


--
-- TOC entry 2738 (class 1259 OID 17100)
-- Dependencies: 188
-- Name: xfv02_finder_tokens_idx_context; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_tokens_idx_context ON xfv02_finder_tokens USING btree (context);


--
-- TOC entry 2739 (class 1259 OID 17099)
-- Dependencies: 188
-- Name: xfv02_finder_tokens_idx_word; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_finder_tokens_idx_word ON xfv02_finder_tokens USING btree (term);


--
-- TOC entry 2746 (class 1259 OID 17141)
-- Dependencies: 193
-- Name: xfv02_languages_idx_access; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_languages_idx_access ON xfv02_languages USING btree (access);


--
-- TOC entry 2751 (class 1259 OID 17140)
-- Dependencies: 193
-- Name: xfv02_languages_idx_ordering; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_languages_idx_ordering ON xfv02_languages USING btree (ordering);


--
-- TOC entry 2756 (class 1259 OID 17176)
-- Dependencies: 195
-- Name: xfv02_menu_idx_alias; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_menu_idx_alias ON xfv02_menu USING btree (alias);


--
-- TOC entry 2759 (class 1259 OID 17173)
-- Dependencies: 195 195 195 195
-- Name: xfv02_menu_idx_componentid; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_menu_idx_componentid ON xfv02_menu USING btree (component_id, menutype, published, access);


--
-- TOC entry 2760 (class 1259 OID 17178)
-- Dependencies: 195
-- Name: xfv02_menu_idx_language; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_menu_idx_language ON xfv02_menu USING btree (language);


--
-- TOC entry 2761 (class 1259 OID 17175)
-- Dependencies: 195 195
-- Name: xfv02_menu_idx_left_right; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_menu_idx_left_right ON xfv02_menu USING btree (lft, rgt);


--
-- TOC entry 2762 (class 1259 OID 17174)
-- Dependencies: 195
-- Name: xfv02_menu_idx_menutype; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_menu_idx_menutype ON xfv02_menu USING btree (menutype);


--
-- TOC entry 2763 (class 1259 OID 17177)
-- Dependencies: 195
-- Name: xfv02_menu_idx_path; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_menu_idx_path ON xfv02_menu USING btree (path);


--
-- TOC entry 2772 (class 1259 OID 17208)
-- Dependencies: 199 199
-- Name: xfv02_messages_useridto_state; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_messages_useridto_state ON xfv02_messages USING btree (user_id_to, state);


--
-- TOC entry 2775 (class 1259 OID 17245)
-- Dependencies: 202
-- Name: xfv02_modules_idx_language; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_modules_idx_language ON xfv02_modules USING btree (language);


--
-- TOC entry 2776 (class 1259 OID 17244)
-- Dependencies: 202 202
-- Name: xfv02_modules_newsfeeds; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_modules_newsfeeds ON xfv02_modules USING btree (module, published);


--
-- TOC entry 2779 (class 1259 OID 17243)
-- Dependencies: 202 202
-- Name: xfv02_modules_published; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_modules_published ON xfv02_modules USING btree (published, access);


--
-- TOC entry 2782 (class 1259 OID 17286)
-- Dependencies: 205
-- Name: xfv02_newsfeeds_idx_access; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_newsfeeds_idx_access ON xfv02_newsfeeds USING btree (access);


--
-- TOC entry 2783 (class 1259 OID 17289)
-- Dependencies: 205
-- Name: xfv02_newsfeeds_idx_catid; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_newsfeeds_idx_catid ON xfv02_newsfeeds USING btree (catid);


--
-- TOC entry 2784 (class 1259 OID 17287)
-- Dependencies: 205
-- Name: xfv02_newsfeeds_idx_checkout; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_newsfeeds_idx_checkout ON xfv02_newsfeeds USING btree (checked_out);


--
-- TOC entry 2785 (class 1259 OID 17290)
-- Dependencies: 205
-- Name: xfv02_newsfeeds_idx_createdby; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_newsfeeds_idx_createdby ON xfv02_newsfeeds USING btree (created_by);


--
-- TOC entry 2786 (class 1259 OID 17291)
-- Dependencies: 205
-- Name: xfv02_newsfeeds_idx_language; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_newsfeeds_idx_language ON xfv02_newsfeeds USING btree (language);


--
-- TOC entry 2787 (class 1259 OID 17288)
-- Dependencies: 205
-- Name: xfv02_newsfeeds_idx_state; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_newsfeeds_idx_state ON xfv02_newsfeeds USING btree (published);


--
-- TOC entry 2788 (class 1259 OID 17292)
-- Dependencies: 205
-- Name: xfv02_newsfeeds_idx_xreference; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_newsfeeds_idx_xreference ON xfv02_newsfeeds USING btree (xreference);


--
-- TOC entry 2795 (class 1259 OID 17344)
-- Dependencies: 211
-- Name: xfv02_redirect_links_idx_link_modifed; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_redirect_links_idx_link_modifed ON xfv02_redirect_links USING btree (modified_date);


--
-- TOC entry 2804 (class 1259 OID 17365)
-- Dependencies: 213
-- Name: xfv02_session_time; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_session_time ON xfv02_session USING btree ("time");


--
-- TOC entry 2805 (class 1259 OID 17364)
-- Dependencies: 213
-- Name: xfv02_session_userid; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_session_userid ON xfv02_session USING btree (userid);


--
-- TOC entry 2806 (class 1259 OID 17399)
-- Dependencies: 215 215
-- Name: xfv02_tags_cat_idx; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_tags_cat_idx ON xfv02_tags USING btree (published, access);


--
-- TOC entry 2807 (class 1259 OID 17400)
-- Dependencies: 215
-- Name: xfv02_tags_idx_access; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_tags_idx_access ON xfv02_tags USING btree (access);


--
-- TOC entry 2808 (class 1259 OID 17404)
-- Dependencies: 215
-- Name: xfv02_tags_idx_alias; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_tags_idx_alias ON xfv02_tags USING btree (alias);


--
-- TOC entry 2809 (class 1259 OID 17401)
-- Dependencies: 215
-- Name: xfv02_tags_idx_checkout; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_tags_idx_checkout ON xfv02_tags USING btree (checked_out);


--
-- TOC entry 2810 (class 1259 OID 17405)
-- Dependencies: 215
-- Name: xfv02_tags_idx_language; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_tags_idx_language ON xfv02_tags USING btree (language);


--
-- TOC entry 2811 (class 1259 OID 17403)
-- Dependencies: 215 215
-- Name: xfv02_tags_idx_left_right; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_tags_idx_left_right ON xfv02_tags USING btree (lft, rgt);


--
-- TOC entry 2812 (class 1259 OID 17402)
-- Dependencies: 215
-- Name: xfv02_tags_idx_path; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_tags_idx_path ON xfv02_tags USING btree (path);


--
-- TOC entry 2815 (class 1259 OID 17422)
-- Dependencies: 217
-- Name: xfv02_template_styles_idx_home; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_template_styles_idx_home ON xfv02_template_styles USING btree (home);


--
-- TOC entry 2816 (class 1259 OID 17421)
-- Dependencies: 217
-- Name: xfv02_template_styles_idx_template; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_template_styles_idx_template ON xfv02_template_styles USING btree (template);


--
-- TOC entry 2821 (class 1259 OID 17431)
-- Dependencies: 219
-- Name: xfv02_ucm_base_ucm_item_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_ucm_base_ucm_item_id ON xfv02_ucm_base USING btree (ucm_item_id);


--
-- TOC entry 2822 (class 1259 OID 17433)
-- Dependencies: 219
-- Name: xfv02_ucm_base_ucm_language_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_ucm_base_ucm_language_id ON xfv02_ucm_base USING btree (ucm_language_id);


--
-- TOC entry 2823 (class 1259 OID 17432)
-- Dependencies: 219
-- Name: xfv02_ucm_base_ucm_type_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_ucm_base_ucm_type_id ON xfv02_ucm_base USING btree (ucm_type_id);


--
-- TOC entry 2824 (class 1259 OID 17471)
-- Dependencies: 221
-- Name: xfv02_ucm_content_idx_access; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_ucm_content_idx_access ON xfv02_ucm_content USING btree (core_access);


--
-- TOC entry 2825 (class 1259 OID 17472)
-- Dependencies: 221
-- Name: xfv02_ucm_content_idx_alias; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_ucm_content_idx_alias ON xfv02_ucm_content USING btree (core_alias);


--
-- TOC entry 2826 (class 1259 OID 17477)
-- Dependencies: 221
-- Name: xfv02_ucm_content_idx_content_type; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_ucm_content_idx_content_type ON xfv02_ucm_content USING btree (core_type_alias);


--
-- TOC entry 2827 (class 1259 OID 17479)
-- Dependencies: 221
-- Name: xfv02_ucm_content_idx_core_checked_out_user_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_ucm_content_idx_core_checked_out_user_id ON xfv02_ucm_content USING btree (core_checked_out_user_id);


--
-- TOC entry 2828 (class 1259 OID 17480)
-- Dependencies: 221
-- Name: xfv02_ucm_content_idx_core_created_user_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_ucm_content_idx_core_created_user_id ON xfv02_ucm_content USING btree (core_created_user_id);


--
-- TOC entry 2829 (class 1259 OID 17478)
-- Dependencies: 221
-- Name: xfv02_ucm_content_idx_core_modified_user_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_ucm_content_idx_core_modified_user_id ON xfv02_ucm_content USING btree (core_modified_user_id);


--
-- TOC entry 2830 (class 1259 OID 17481)
-- Dependencies: 221
-- Name: xfv02_ucm_content_idx_core_type_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_ucm_content_idx_core_type_id ON xfv02_ucm_content USING btree (core_type_id);


--
-- TOC entry 2831 (class 1259 OID 17476)
-- Dependencies: 221
-- Name: xfv02_ucm_content_idx_created_time; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_ucm_content_idx_created_time ON xfv02_ucm_content USING btree (core_created_time);


--
-- TOC entry 2832 (class 1259 OID 17473)
-- Dependencies: 221
-- Name: xfv02_ucm_content_idx_language; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_ucm_content_idx_language ON xfv02_ucm_content USING btree (core_language);


--
-- TOC entry 2833 (class 1259 OID 17475)
-- Dependencies: 221
-- Name: xfv02_ucm_content_idx_modified_time; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_ucm_content_idx_modified_time ON xfv02_ucm_content USING btree (core_modified_time);


--
-- TOC entry 2834 (class 1259 OID 17474)
-- Dependencies: 221
-- Name: xfv02_ucm_content_idx_title; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_ucm_content_idx_title ON xfv02_ucm_content USING btree (core_title);


--
-- TOC entry 2839 (class 1259 OID 17470)
-- Dependencies: 221 221
-- Name: xfv02_ucm_content_tag_idx; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_ucm_content_tag_idx ON xfv02_ucm_content USING btree (core_state, core_access);


--
-- TOC entry 2840 (class 1259 OID 17500)
-- Dependencies: 223
-- Name: xfv02_ucm_history_idx_save_date; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_ucm_history_idx_save_date ON xfv02_ucm_history USING btree (save_date);


--
-- TOC entry 2841 (class 1259 OID 17499)
-- Dependencies: 223 223
-- Name: xfv02_ucm_history_idx_ucm_item_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_ucm_history_idx_ucm_item_id ON xfv02_ucm_history USING btree (ucm_type_id, ucm_item_id);


--
-- TOC entry 2865 (class 1259 OID 17608)
-- Dependencies: 235
-- Name: xfv02_user_keys_idx_user_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_user_keys_idx_user_id ON xfv02_user_keys USING btree (user_id);


--
-- TOC entry 2870 (class 1259 OID 17633)
-- Dependencies: 237
-- Name: xfv02_user_notes_idx_category_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_user_notes_idx_category_id ON xfv02_user_notes USING btree (catid);


--
-- TOC entry 2871 (class 1259 OID 17632)
-- Dependencies: 237
-- Name: xfv02_user_notes_idx_user_id; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_user_notes_idx_user_id ON xfv02_user_notes USING btree (user_id);


--
-- TOC entry 2850 (class 1259 OID 17558)
-- Dependencies: 230
-- Name: xfv02_usergroups_idx_usergroup_adjacency_lookup; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_usergroups_idx_usergroup_adjacency_lookup ON xfv02_usergroups USING btree (parent_id);


--
-- TOC entry 2851 (class 1259 OID 17559)
-- Dependencies: 230 230
-- Name: xfv02_usergroups_idx_usergroup_nested_set_lookup; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_usergroups_idx_usergroup_nested_set_lookup ON xfv02_usergroups USING btree (lft, rgt);


--
-- TOC entry 2854 (class 1259 OID 17557)
-- Dependencies: 230
-- Name: xfv02_usergroups_idx_usergroup_title_lookup; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_usergroups_idx_usergroup_title_lookup ON xfv02_usergroups USING btree (title);


--
-- TOC entry 2859 (class 1259 OID 17594)
-- Dependencies: 233
-- Name: xfv02_users_email; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_users_email ON xfv02_users USING btree (email);


--
-- TOC entry 2860 (class 1259 OID 17592)
-- Dependencies: 233
-- Name: xfv02_users_idx_block; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_users_idx_block ON xfv02_users USING btree (block);


--
-- TOC entry 2861 (class 1259 OID 17591)
-- Dependencies: 233
-- Name: xfv02_users_idx_name; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_users_idx_name ON xfv02_users USING btree (name);


--
-- TOC entry 2864 (class 1259 OID 17593)
-- Dependencies: 233
-- Name: xfv02_users_username; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_users_username ON xfv02_users USING btree (username);


--
-- TOC entry 2880 (class 1259 OID 17686)
-- Dependencies: 242
-- Name: xfv02_weblinks_idx_access; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_weblinks_idx_access ON xfv02_weblinks USING btree (access);


--
-- TOC entry 2881 (class 1259 OID 17689)
-- Dependencies: 242
-- Name: xfv02_weblinks_idx_catid; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_weblinks_idx_catid ON xfv02_weblinks USING btree (catid);


--
-- TOC entry 2882 (class 1259 OID 17687)
-- Dependencies: 242
-- Name: xfv02_weblinks_idx_checkout; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_weblinks_idx_checkout ON xfv02_weblinks USING btree (checked_out);


--
-- TOC entry 2883 (class 1259 OID 17690)
-- Dependencies: 242
-- Name: xfv02_weblinks_idx_createdby; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_weblinks_idx_createdby ON xfv02_weblinks USING btree (created_by);


--
-- TOC entry 2884 (class 1259 OID 17691)
-- Dependencies: 242 242
-- Name: xfv02_weblinks_idx_featured_catid; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_weblinks_idx_featured_catid ON xfv02_weblinks USING btree (featured, catid);


--
-- TOC entry 2885 (class 1259 OID 17692)
-- Dependencies: 242
-- Name: xfv02_weblinks_idx_language; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_weblinks_idx_language ON xfv02_weblinks USING btree (language);


--
-- TOC entry 2886 (class 1259 OID 17688)
-- Dependencies: 242
-- Name: xfv02_weblinks_idx_state; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_weblinks_idx_state ON xfv02_weblinks USING btree (state);


--
-- TOC entry 2887 (class 1259 OID 17693)
-- Dependencies: 242
-- Name: xfv02_weblinks_idx_xreference; Type: INDEX; Schema: public; Owner: j30; Tablespace: 
--

CREATE INDEX xfv02_weblinks_idx_xreference ON xfv02_weblinks USING btree (xreference);


--
-- TOC entry 2894 (class 0 OID 0)
-- Dependencies: 3
-- 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 postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


-- Completed on 2013-11-22 03:58:46 VET

--
-- PostgreSQL database dump complete
--