source: cats/ISOcat/trunk/mod-ISOcat-access-data/dbms/ISOcat-schema-empty.sql @ 2159

--
-- PostgreSQL database dump
--

-- Started on 2012-07-04 13:22:28

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 552 (class 2612 OID 16386)
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: -
--

--CREATE PROCEDURAL LANGUAGE plpgsql;


SET search_path = public, pg_catalog;

--
-- TOC entry 326 (class 1247 OID 358980)
-- Dependencies: 6
-- Name: access_rights_enum; Type: TYPE; Schema: public; Owner: -
--

CREATE TYPE access_rights_enum AS ENUM (
    'r',
    'ru',
    'rud'
);


--
-- TOC entry 328 (class 1247 OID 358985)
-- Dependencies: 6
-- Name: administration_status_enum; Type: TYPE; Schema: public; Owner: -
--

CREATE TYPE administration_status_enum AS ENUM (
    'private',
    'submission',
    'pre-evaluation',
    'evaluation',
    'rejected-TDG',
    'accepted-TDG',
    'pre-validation',
    'validation',
    'accepted',
    'rejected-DCRB',
    'external',
    'finished'
);


--
-- TOC entry 330 (class 1247 OID 358999)
-- Dependencies: 6
-- Name: check_result_enum; Type: TYPE; Schema: public; Owner: -
--

CREATE TYPE check_result_enum AS ENUM (
    'unchecked',
    'fatal',
    'error',
    'warning',
    'ok'
);


--
-- TOC entry 332 (class 1247 OID 359006)
-- Dependencies: 6
-- Name: lock_type_enum; Type: TYPE; Schema: public; Owner: -
--

CREATE TYPE lock_type_enum AS ENUM (
    'data category'
);


--
-- TOC entry 334 (class 1247 OID 359009)
-- Dependencies: 6
-- Name: member_status_enum; Type: TYPE; Schema: public; Owner: -
--

CREATE TYPE member_status_enum AS ENUM (
    'invite',
    'invited',
    'accepted',
    'declined'
);


--
-- TOC entry 336 (class 1247 OID 359015)
-- Dependencies: 6
-- Name: member_type_enum; Type: TYPE; Schema: public; Owner: -
--

CREATE TYPE member_type_enum AS ENUM (
    'member',
    'chair'
);


--
-- TOC entry 338 (class 1247 OID 359019)
-- Dependencies: 6
-- Name: message_status_enum; Type: TYPE; Schema: public; Owner: -
--

CREATE TYPE message_status_enum AS ENUM (
    'valid',
    'read',
    'obsolete',
    'deleted'
);


--
-- TOC entry 340 (class 1247 OID 359025)
-- Dependencies: 6
-- Name: message_type_enum; Type: TYPE; Schema: public; Owner: -
--

CREATE TYPE message_type_enum AS ENUM (
    'message',
    'invitation',
    'request',
    'news',
    'broadcast'
);


--
-- TOC entry 342 (class 1247 OID 359032)
-- Dependencies: 6
-- Name: name_status_enum; Type: TYPE; Schema: public; Owner: -
--

CREATE TYPE name_status_enum AS ENUM (
    'standardized name',
    'preferred name',
    'admitted name',
    'deprecated name',
    'superseded name'
);


--
-- TOC entry 344 (class 1247 OID 359039)
-- Dependencies: 6
-- Name: name_type_enum; Type: TYPE; Schema: public; Owner: -
--

CREATE TYPE name_type_enum AS ENUM (
    'name section',
    'data element name'
);


--
-- TOC entry 346 (class 1247 OID 359043)
-- Dependencies: 6
-- Name: owner_type_enum; Type: TYPE; Schema: public; Owner: -
--

CREATE TYPE owner_type_enum AS ENUM (
    'data category',
    'language section',
    'linguistic section',
    'text',
    'change request'
);


--
-- TOC entry 348 (class 1247 OID 359050)
-- Dependencies: 6
-- Name: registration_status_enum; Type: TYPE; Schema: public; Owner: -
--

CREATE TYPE registration_status_enum AS ENUM (
    'private',
    'candidate',
    'standard',
    'deprecated',
    'superseded'
);


--
-- TOC entry 350 (class 1247 OID 359057)
-- Dependencies: 6
-- Name: text_type_enum; Type: TYPE; Schema: public; Owner: -
--

CREATE TYPE text_type_enum AS ENUM (
    'text',
    'explanatory comment',
    'unresolved issue',
    'change',
    'explanation',
    'linguistic explanation',
    'definition',
    'example',
    'linguistic example',
    'note',
    'administration note'
);


--
-- TOC entry 352 (class 1247 OID 359070)
-- Dependencies: 6
-- Name: user_type_enum; Type: TYPE; Schema: public; Owner: -
--

CREATE TYPE user_type_enum AS ENUM (
    'basic',
    'expert',
    'admin'
);


--
-- TOC entry 19 (class 1255 OID 359074)
-- Dependencies: 6
-- Name: concat(text, text); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION concat(text, text) RETURNS text
    LANGUAGE sql IMMUTABLE
    AS $_$
SELECT CASE WHEN $1 = '' THEN $2 ELSE $1 || ' ' || $2 END
$_$;


--
-- TOC entry 20 (class 1255 OID 359075)
-- Dependencies: 552 6
-- Name: dc_profiles(integer); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION dc_profiles(dcid integer) RETURNS SETOF integer
    LANGUAGE plpgsql
    AS $$
DECLARE
    profile RECORD;
    path RECORD;
BEGIN
    FOR profile IN SELECT DISTINCT link_profile_members.profile FROM link_profile_members WHERE link_profile_members.dc = dcid LOOP
       FOR path IN SELECT * FROM profile_path(profile.profile) LOOP
          RETURN NEXT path.profile_path;
       END LOOP;
    END LOOP;
END;
$$;


--
-- TOC entry 21 (class 1255 OID 359076)
-- Dependencies: 6 552
-- Name: dc_super_cycle(integer[], integer); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION dc_super_cycle(path integer[], super integer) RETURNS boolean
    LANGUAGE plpgsql
    AS $$
DECLARE
    isa RECORD;
BEGIN
    IF
        (path @> ARRAY[super])
    THEN
        RAISE NOTICE 'dc_super_cycle(path[%],super[%]) found a cycle',path,super;
        RETURN true;
    ELSE
        SELECT
                  *
        FROM
                  link_simple_data_category_super
        WHERE
                  dc = super
        INTO
                  isa
        ;
        IF
           isa IS NULL
        THEN
           RETURN false;
        ELSE
           RETURN dc_super_cycle(path || super,isa.super);
        END IF;
    END IF;
END;
$$;


--
-- TOC entry 22 (class 1255 OID 359077)
-- Dependencies: 552 6
-- Name: dcs_self_or_descendants(integer); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION dcs_self_or_descendants(dcs integer) RETURNS SETOF integer
    LANGUAGE plpgsql
    AS $$
DECLARE
    child RECORD;
    descendant RECORD;
BEGIN
    FOR child IN SELECT * FROM core_data_category_selection WHERE parent=dcs LOOP
       FOR descendant IN SELECT * FROM dcs_self_or_descendants(child.id) LOOP
          RETURN NEXT descendant.dcs_self_or_descendants;
       END LOOP;
    END LOOP;
    RETURN NEXT dcs;
END;
$$;


--
-- TOC entry 23 (class 1255 OID 359078)
-- Dependencies: 6 552
-- Name: delete_generic_name(); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION delete_generic_name() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
    DECLARE
        id integer;
        tp owner_type_enum;
    BEGIN

        IF (TG_OP = 'DELETE') THEN
        
            IF (TG_TABLE_NAME = 'core_data_category') THEN

                tp = 'data category';
            
            ELSIF (TG_TABLE_NAME = 'core_language_section') THEN
            
                tp = 'language section';

            END IF;
            
            id = OLD.id;
            
            DELETE FROM
                generic_name
             WHERE
                generic_name.owner = id
              AND
                generic_name.owner_type = tp
              ;

        END IF;

        RETURN NULL;

    END;
$$;


--
-- TOC entry 24 (class 1255 OID 359079)
-- Dependencies: 6 552
-- Name: delete_generic_text(); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION delete_generic_text() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
    DECLARE
        id integer;
        tp owner_type_enum;
    BEGIN

        IF (TG_OP = 'DELETE') THEN
        
            IF (TG_TABLE_NAME = 'core_data_category') THEN

                tp = 'data category';
            
            ELSIF (TG_TABLE_NAME = 'core_language_section') THEN
            
                tp = 'language section';

            ELSIF (TG_TABLE_NAME = 'core_linguistic_section') THEN
            
                tp = 'linguistic section';

            ELSIF (TG_TABLE_NAME = 'generic_text') THEN
            
                tp = 'text';

            END IF;
            
            id = OLD.id;
            
            DELETE FROM
                generic_text
             WHERE
                 generic_text.owner = id
              AND
                 generic_text.owner_type = tp
              ;

        END IF;

        RETURN NULL;

    END;
$$;


--
-- TOC entry 25 (class 1255 OID 359080)
-- Dependencies: 6 552
-- Name: get_dc_identifier(integer); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION get_dc_identifier(dcid integer) RETURNS character varying
    LANGUAGE plpgsql
    AS $$
DECLARE
        dc RECORD;
BEGIN
        SELECT
                *
        INTO
                dc
        FROM
                core_data_category
        WHERE
                core_data_category.id = dcid
        ;
        RETURN dc.identifier;
END;
$$;


--
-- TOC entry 26 (class 1255 OID 359081)
-- Dependencies: 552 6
-- Name: get_dc_name(integer); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION get_dc_name(dcid integer) RETURNS character varying
    LANGUAGE plpgsql
    AS $$
DECLARE
        datcat RECORD;
BEGIN
        SELECT
                core_data_category.id AS dc,
                COALESCE(get_dc_name_status_language(dcid,'preferred name','en'), get_dc_name_status_language(dcid,'standardized name','en'), get_dc_name_status_language(dcid,'admitted name','en'), identifier, 'ERROR') AS name
        INTO
                datcat
        FROM
                core_data_category
        WHERE
                core_data_category.id = dcid
        ;
        RETURN datcat.name;
END;
$$;


--
-- TOC entry 27 (class 1255 OID 359082)
-- Dependencies: 552 6
-- Name: get_dc_name_status(integer, character varying); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION get_dc_name_status(dcid integer, dcstatus character varying) RETURNS character varying
    LANGUAGE plpgsql
    AS $$
DECLARE
        dc RECORD;
BEGIN
        SELECT
                *
        INTO
                dc
        FROM
                view_dc_name
        WHERE
                view_dc_name.id = dcid
          AND
                view_dc_name.status = dcstatus::name_status_enum
          AND
                view_dc_name.name IS NOT NULL
          AND
                view_dc_name.name != ''
        ;
        RETURN dc.name;
END;
$$;


--
-- TOC entry 28 (class 1255 OID 359083)
-- Dependencies: 552 6
-- Name: get_dc_name_status_language(integer, character varying, character varying); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION get_dc_name_status_language(dcid integer, dcstatus character varying, lang character varying) RETURNS character varying
    LANGUAGE plpgsql
    AS $$
DECLARE
        dc RECORD;
BEGIN
        SELECT
                *
        INTO
                dc
        FROM
                view_dc_name
        WHERE
                view_dc_name.id = dcid
          AND
                view_dc_name.status = dcstatus::name_status_enum
          AND
                view_dc_name.name IS NOT NULL
          AND
                view_dc_name.name != ''
          AND
                view_dc_name.tag = lang
        ;
        RETURN dc.name;
END;
$$;


--
-- TOC entry 29 (class 1255 OID 359084)
-- Dependencies: 6 552
-- Name: get_dc_type(integer); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION get_dc_type(dc integer) RETURNS character varying
    LANGUAGE plpgsql
    AS $$
DECLARE
        datcat RECORD;
BEGIN
        SELECT
                id
        FROM
                core_simple_data_category
        WHERE
                id =  dc
        INTO
                datcat
        ;
        IF
                datcat IS NULL
        THEN
                SELECT
                        id
                FROM
                        core_container_data_category
                WHERE
                        id =  dc
                INTO
                        datcat
                ;
                IF
                        datcat IS NULL
                THEN
                        SELECT
                                id
                        FROM
                                core_closed_data_category
                        WHERE
                                id = dc
                        INTO
                                datcat
                        ;
                        IF
                                datcat IS NULL
                        THEN
                                SELECT
                                        id
                                FROM
                                        core_constrained_data_category
                                WHERE
                                        id = dc
                                INTO
                                        datcat
                                ;
                                IF
                                        datcat IS NULL
                                THEN
                                        SELECT
                                                id
                                        FROM
                                                core_open_data_category
                                        WHERE
                                                id = dc
                                        INTO
                                                datcat
                                        ;
                                        IF
                                                datcat IS NULL
                                        THEN
                                                RETURN 'unknown';
                                        ELSE
                                                RETURN 'open';
                                        END IF;
                                ELSE
                                        RETURN 'constrained';
                                END IF;
                        ELSE
                                RETURN 'closed';
                        END IF;
                ELSE
                        RETURN 'container';
                END IF;
        ELSE
                RETURN 'simple';
        END IF;
END;
$$;


--
-- TOC entry 30 (class 1255 OID 359085)
-- Dependencies: 552 6
-- Name: merge_accounts(integer, integer); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION merge_accounts(keep integer, remove integer) RETURNS integer
    LANGUAGE plpgsql
    AS $$
DECLARE
BEGIN
        -- owned DCs
        UPDATE core_data_category SET owner = keep WHERE owner = remove;
        -- owned DCSs
        UPDATE core_data_category_selection SET owner = keep WHERE owner = remove;
        -- owned groups
        UPDATE core_adhoc_group SET owner = keep WHERE owner = remove;
        -- owned submissions
        UPDATE core_submission_group SET owner = keep WHERE owner = remove;
        -- shared DCs
        DELETE FROM
                link_dc_access
        USING
                link_dc_access AS checker
        WHERE
                link_dc_access.dc = checker.dc
        AND
                checker.account = keep
        AND
                link_dc_access.account = remove
        ;
        UPDATE link_dc_access SET account = keep WHERE account = remove;
        -- shared DCSs
        DELETE FROM
                link_dcs_access
        USING
                link_dcs_access AS checker
        WHERE
                link_dcs_access.dcs = checker.dcs
        AND
                checker.account = keep
        AND
                link_dcs_access.account = remove
        ;
        UPDATE link_dcs_access SET account = keep WHERE account = remove;
        -- votes
        UPDATE core_change_request_vote SET judge = keep WHERE judge = remove;
        -- DC status changes
        UPDATE core_dc_status_log SET "user" = keep WHERE "user" = remove;
        -- messages send
        UPDATE core_message SET "from" = keep WHERE "from" = remove;
        -- messages received
        UPDATE core_message SET "to" = keep WHERE "to" = remove;
        -- texts
        UPDATE generic_text SET "user" = keep WHERE "user" = remove;
        -- group memberships
        DELETE FROM
                link_group_members
        USING
                link_group_members AS checker
        WHERE
                link_group_members."group" = checker."group"
        AND
                checker.member= keep
        AND
                link_group_members.member = remove
        ;
        UPDATE link_group_members SET member = keep WHERE member = remove;

        -- SYNTAX residu
        UPDATE link_data_category_selection_users SET "user" = keep WHERE "user" = remove;

        -- delete owner
        DELETE FROM core_owner WHERE id = remove;
        -- delete account
        DELETE FROM core_account WHERE id = remove;
        RETURN keep;
END;
$$;


--
-- TOC entry 31 (class 1255 OID 359086)
-- Dependencies: 6 552
-- Name: pid(integer); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION pid(dcid integer) RETURNS character varying
    LANGUAGE plpgsql
    AS $$
DECLARE
    dc RECORD;
BEGIN
    SELECT
       *
    INTO
       dc
    FROM
       core_data_category
    WHERE
       id =  dcid
    ;
    IF 
       dc.registration_status = 2 
    THEN
        RETURN 'http://www.isocat.org/datcat/ISO-DC-' || dc.id;
    ELSE
        RETURN 'http://www.isocat.org/datcat/DC-' || dc.id;
    END IF;
END;
$$;


--
-- TOC entry 32 (class 1255 OID 359087)
-- Dependencies: 6 552
-- Name: prevent_super_cycle(); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION prevent_super_cycle() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
    DECLARE
    BEGIN
    
    IF (dc_super_cycle(ARRAY[NEW.dc],NEW.super))
    THEN
        RAISE EXCEPTION 'Making DC[%] the super of simple DC[%] would create a cycle, so the insert was canceled!', NEW.super, NEW.dc;
    END IF;

        RETURN NEW;

    END;
$$;


--
-- TOC entry 33 (class 1255 OID 359088)
-- Dependencies: 552 6
-- Name: profile_ancestors(integer); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION profile_ancestors(prof integer) RETURNS SETOF integer
    LANGUAGE plpgsql
    AS $$
DECLARE
    parent RECORD;
    ancestor RECORD;
BEGIN
    SELECT
       *
    INTO
       parent
    FROM
       core_profile
    WHERE
       id =  prof;
    IF 
       parent.parent IS NOT NULL
    THEN
       FOR ancestor IN SELECT * FROM profile_ancestors(parent.parent) LOOP
          RETURN NEXT ancestor.profile_ancestors;
       END LOOP;
       RETURN NEXT parent.parent;
    END IF;
END;
$$;


--
-- TOC entry 34 (class 1255 OID 359089)
-- Dependencies: 552 6
-- Name: profile_path(integer); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION profile_path(prof integer) RETURNS SETOF integer
    LANGUAGE plpgsql
    AS $$
DECLARE
    parent RECORD;
    ancestor RECORD;
BEGIN
    SELECT
       *
    INTO
       parent
    FROM
       core_profile
    WHERE
       id =  prof
    ;
    IF 
       parent.parent IS NOT NULL
    THEN
       FOR ancestor IN SELECT * FROM profile_path(parent.parent) LOOP
          RETURN NEXT ancestor.profile_path;
       END LOOP;
    END IF;
    RETURN NEXT prof;
END;
$$;


--
-- TOC entry 35 (class 1255 OID 359090)
-- Dependencies: 552 6
-- Name: profile_self_or_descendants(integer); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION profile_self_or_descendants(prof integer) RETURNS SETOF integer
    LANGUAGE plpgsql
    AS $$
DECLARE
    child RECORD;
    descendant RECORD;
BEGIN
    FOR child IN SELECT * FROM core_profile WHERE parent=prof LOOP
       FOR descendant IN SELECT * FROM profile_self_or_descendants(child.id) LOOP
          RETURN NEXT descendant.profile_self_or_descendants;
       END LOOP;
    END LOOP;
    RETURN NEXT prof;
END;
$$;


--
-- TOC entry 36 (class 1255 OID 359091)
-- Dependencies: 6 552
-- Name: update_search_identifier(); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION update_search_identifier() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
    DECLARE
        lang RECORD;
    BEGIN

        -- update the language independent search vector
        NEW.search = to_tsvector('simple',NEW.identifier);

        -- update the language specific search vector
        NEW.search_language = to_tsvector('english',NEW.identifier);

        RETURN NEW;

    END;
$$;


--
-- TOC entry 37 (class 1255 OID 359092)
-- Dependencies: 6 552
-- Name: update_search_name(); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION update_search_name() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
    DECLARE
        lang RECORD;
    BEGIN

        SELECT
                *
        INTO
                lang
        FROM
                core_language
        WHERE
                id = NEW.language
        ;

        -- update the language independent search vector
        NEW.search = to_tsvector('simple',NEW.name);

        -- update the language specific search vector
        NEW.search_language = to_tsvector(CAST(lang.search AS regconfig),NEW.name);

        RETURN NEW;

    END;
$$;


--
-- TOC entry 38 (class 1255 OID 359093)
-- Dependencies: 552 6
-- Name: update_search_text(); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION update_search_text() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
    DECLARE
        lang RECORD;
    BEGIN

        SELECT
                *
        INTO
                lang
        FROM
                core_language
        WHERE
                id = NEW.language
        ;

        -- update the language independent search vector
        NEW.search = to_tsvector('simple',NEW.text);

        -- update the language specific search vector
        NEW.search_language = to_tsvector(CAST(lang.search AS regconfig),NEW.text);

        RETURN NEW;

    END;
$$;


--
-- TOC entry 39 (class 1255 OID 359094)
-- Dependencies: 552 6
-- Name: user_name(integer); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION user_name(uid integer) RETURNS character varying
    LANGUAGE plpgsql
    AS $$
DECLARE
    profile RECORD;
    ancestor RECORD;
BEGIN
    SELECT
       *
    INTO
       profile
    FROM
       core_user
    WHERE
       id =  uid
    ;
    IF
        profile.last_name IS NOT NULL AND TRIM(profile.last_name) != ''
    THEN
            IF 
               profile.first_name IS NOT NULL AND TRIM(profile.first_name) != '' 
            THEN
                RETURN TRIM(profile.last_name) || ', ' || TRIM(profile.first_name);
            ELSE
                RETURN TRIM(profile.last_name);
            END IF;
    ELSE
        RETURN profile.login;
    END IF;
END;
$$;


--
-- TOC entry 40 (class 1255 OID 359095)
-- Dependencies: 6
-- Name: xpath_list(text, text); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION xpath_list(text, text) RETURNS text
    LANGUAGE sql IMMUTABLE STRICT
    AS $_$SELECT xpath_list($1,$2,',')$_$;


--
-- TOC entry 41 (class 1255 OID 359096)
-- Dependencies: 6
-- Name: xpath_nodeset(text, text); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION xpath_nodeset(text, text) RETURNS text
    LANGUAGE sql IMMUTABLE STRICT
    AS $_$SELECT xpath_nodeset($1,$2,'','')$_$;


--
-- TOC entry 42 (class 1255 OID 359097)
-- Dependencies: 6
-- Name: xpath_nodeset(text, text, text); Type: FUNCTION; Schema: public; Owner: -
--

CREATE FUNCTION xpath_nodeset(text, text, text) RETURNS text
    LANGUAGE sql IMMUTABLE STRICT
    AS $_$SELECT xpath_nodeset($1,$2,'',$3)$_$;


--
-- TOC entry 553 (class 1255 OID 359098)
-- Dependencies: 19 6
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
--

CREATE AGGREGATE concat(text) (
    SFUNC = public.concat,
    STYPE = text,
    INITCOND = ''
);


SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 1740 (class 1259 OID 359099)
-- Dependencies: 6
-- Name: core_account; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_account (
    id integer NOT NULL
);


--
-- TOC entry 2585 (class 0 OID 0)
-- Dependencies: 1740
-- Name: TABLE core_account; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_account IS 'The core data table for accounts';


--
-- TOC entry 1741 (class 1259 OID 359102)
-- Dependencies: 1740 6
-- Name: core_account_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2586 (class 0 OID 0)
-- Dependencies: 1741
-- Name: core_account_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_account_id_seq OWNED BY core_account.id;


--
-- TOC entry 1742 (class 1259 OID 359104)
-- Dependencies: 6
-- Name: core_adhoc_group; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_adhoc_group (
    id integer NOT NULL,
    owner integer NOT NULL,
    description character varying,
    name character varying NOT NULL
);


--
-- TOC entry 2587 (class 0 OID 0)
-- Dependencies: 1742
-- Name: TABLE core_adhoc_group; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_adhoc_group IS 'The core table for adhoc groups.';


--
-- TOC entry 1743 (class 1259 OID 359110)
-- Dependencies: 2137 328 6
-- Name: core_change_request; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_change_request (
    id integer NOT NULL,
    name character varying NOT NULL,
    tdg integer NOT NULL,
    submission_group integer NOT NULL,
    decision_group_tdg integer,
    forum integer,
    forum_group integer,
    decision_group_dcrb integer,
    dcs integer NOT NULL,
    status administration_status_enum DEFAULT 'submission'::administration_status_enum NOT NULL,
    start timestamp with time zone,
    stop timestamp with time zone
);


--
-- TOC entry 2588 (class 0 OID 0)
-- Dependencies: 1743
-- Name: TABLE core_change_request; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_change_request IS 'The core data table for change requests.';


--
-- TOC entry 1744 (class 1259 OID 359117)
-- Dependencies: 1743 6
-- Name: core_change_request_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2589 (class 0 OID 0)
-- Dependencies: 1744
-- Name: core_change_request_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_change_request_id_seq OWNED BY core_change_request.id;


--
-- TOC entry 1745 (class 1259 OID 359119)
-- Dependencies: 2139 328 6
-- Name: core_change_request_vote; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_change_request_vote (
    id integer NOT NULL,
    cr integer NOT NULL,
    judge integer NOT NULL,
    dc integer NOT NULL,
    accept boolean,
    status administration_status_enum NOT NULL,
    "when" timestamp with time zone DEFAULT ('now'::text)::timestamp with time zone NOT NULL
);


--
-- TOC entry 1746 (class 1259 OID 359123)
-- Dependencies: 1745 6
-- Name: core_change_request_vote_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2590 (class 0 OID 0)
-- Dependencies: 1746
-- Name: core_change_request_vote_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_change_request_vote_id_seq OWNED BY core_change_request_vote.id;


--
-- TOC entry 1747 (class 1259 OID 359125)
-- Dependencies: 6
-- Name: core_closed_data_category; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_closed_data_category (
    id integer NOT NULL
);


--
-- TOC entry 2591 (class 0 OID 0)
-- Dependencies: 1747
-- Name: TABLE core_closed_data_category; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_closed_data_category IS 'The core data table for closed Data Categories.';


--
-- TOC entry 1748 (class 1259 OID 359128)
-- Dependencies: 6
-- Name: core_closed_linguistic_section; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_closed_linguistic_section (
    id integer NOT NULL,
    cd integer,
    dc integer NOT NULL
);


--
-- TOC entry 2592 (class 0 OID 0)
-- Dependencies: 1748
-- Name: TABLE core_closed_linguistic_section; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_closed_linguistic_section IS 'The core data table for closed linguistic sections.';


--
-- TOC entry 2593 (class 0 OID 0)
-- Dependencies: 1748
-- Name: COLUMN core_closed_linguistic_section.cd; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_closed_linguistic_section.cd IS 'The value domain of this closed linguistic section.';


--
-- TOC entry 1749 (class 1259 OID 359131)
-- Dependencies: 6
-- Name: core_complex_data_category; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_complex_data_category (
    id integer NOT NULL
);


--
-- TOC entry 2594 (class 0 OID 0)
-- Dependencies: 1749
-- Name: TABLE core_complex_data_category; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_complex_data_category IS 'The core data table for complex Data Categories.';


--
-- TOC entry 2595 (class 0 OID 0)
-- Dependencies: 1749
-- Name: COLUMN core_complex_data_category.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_complex_data_category.id IS 'The id of this complex Data Category.';


--
-- TOC entry 1750 (class 1259 OID 359134)
-- Dependencies: 2141 6
-- Name: core_conceptual_domain; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_conceptual_domain (
    id integer NOT NULL,
    data_type integer DEFAULT 1 NOT NULL
);


--
-- TOC entry 2596 (class 0 OID 0)
-- Dependencies: 1750
-- Name: TABLE core_conceptual_domain; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_conceptual_domain IS 'The core data table for conceptual domains.';


--
-- TOC entry 2597 (class 0 OID 0)
-- Dependencies: 1750
-- Name: COLUMN core_conceptual_domain.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_conceptual_domain.id IS 'The id of this conceptual domain.';


--
-- TOC entry 2598 (class 0 OID 0)
-- Dependencies: 1750
-- Name: COLUMN core_conceptual_domain.data_type; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_conceptual_domain.data_type IS 'The data type of this conceptual domain.';


--
-- TOC entry 1751 (class 1259 OID 359138)
-- Dependencies: 6 1750
-- Name: core_conceptual_domain_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2599 (class 0 OID 0)
-- Dependencies: 1751
-- Name: core_conceptual_domain_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_conceptual_domain_id_seq OWNED BY core_conceptual_domain.id;


--
-- TOC entry 1752 (class 1259 OID 359140)
-- Dependencies: 6
-- Name: core_conceptual_domain_rule; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_conceptual_domain_rule (
    id integer NOT NULL,
    rule_type integer NOT NULL
);


--
-- TOC entry 2600 (class 0 OID 0)
-- Dependencies: 1752
-- Name: TABLE core_conceptual_domain_rule; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_conceptual_domain_rule IS 'A constrained conceptual domain consists of rules in a specific rule language.';


--
-- TOC entry 1753 (class 1259 OID 359143)
-- Dependencies: 6
-- Name: core_constrained_data_category; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_constrained_data_category (
    id integer NOT NULL
);


--
-- TOC entry 2601 (class 0 OID 0)
-- Dependencies: 1753
-- Name: TABLE core_constrained_data_category; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_constrained_data_category IS 'The core data table for constrained Data Categories.';


--
-- TOC entry 2602 (class 0 OID 0)
-- Dependencies: 1753
-- Name: COLUMN core_constrained_data_category.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_constrained_data_category.id IS 'The id of this constained Data Category.';


--
-- TOC entry 1754 (class 1259 OID 359146)
-- Dependencies: 6
-- Name: core_constrained_linguistic_section; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_constrained_linguistic_section (
    id integer NOT NULL,
    dc integer NOT NULL
);


--
-- TOC entry 2603 (class 0 OID 0)
-- Dependencies: 1754
-- Name: TABLE core_constrained_linguistic_section; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_constrained_linguistic_section IS 'The core data table for the constrained linguistic sections.';


--
-- TOC entry 1755 (class 1259 OID 359149)
-- Dependencies: 6
-- Name: core_container_data_category; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_container_data_category (
    id integer NOT NULL
);


--
-- TOC entry 1756 (class 1259 OID 359152)
-- Dependencies: 2143 2144 2145 2146 2147 2148 2149 2150 328 348 330 6
-- Name: core_data_category; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_data_category (
    id integer NOT NULL,
    owner integer NOT NULL,
    administration_status administration_status_enum DEFAULT 'private'::administration_status_enum NOT NULL,
    registration_status registration_status_enum DEFAULT 'private'::registration_status_enum NOT NULL,
    origin character varying,
    effective_date date,
    until_date date,
    identifier character varying NOT NULL,
    version character varying DEFAULT '1:0'::character varying NOT NULL,
    previous integer,
    private boolean DEFAULT true NOT NULL,
    "check" check_result_enum DEFAULT 'unchecked'::check_result_enum NOT NULL,
    justification character varying,
    search tsvector,
    search_language tsvector,
    next integer,
    branch character varying DEFAULT '0'::character varying NOT NULL,
    revision integer DEFAULT 1 NOT NULL,
    sidebranches integer DEFAULT 0 NOT NULL,
    pid character varying,
    name character varying,
    type character varying
);


--
-- TOC entry 2604 (class 0 OID 0)
-- Dependencies: 1756
-- Name: TABLE core_data_category; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_data_category IS 'The core data table for Data Categories.';


--
-- TOC entry 2605 (class 0 OID 0)
-- Dependencies: 1756
-- Name: COLUMN core_data_category.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_category.id IS 'The id of this Data Category.';


--
-- TOC entry 2606 (class 0 OID 0)
-- Dependencies: 1756
-- Name: COLUMN core_data_category.owner; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_category.owner IS 'The owner of this Data Category.';


--
-- TOC entry 2607 (class 0 OID 0)
-- Dependencies: 1756
-- Name: COLUMN core_data_category.administration_status; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_category.administration_status IS 'The administration status of this Data Category.';


--
-- TOC entry 2608 (class 0 OID 0)
-- Dependencies: 1756
-- Name: COLUMN core_data_category.registration_status; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_category.registration_status IS 'The registration status of this Data Category.';


--
-- TOC entry 2609 (class 0 OID 0)
-- Dependencies: 1756
-- Name: COLUMN core_data_category.origin; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_category.origin IS 'The origin of this Data Category.';


--
-- TOC entry 2610 (class 0 OID 0)
-- Dependencies: 1756
-- Name: COLUMN core_data_category.effective_date; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_category.effective_date IS 'The date this Data Category will become available to users.';


--
-- TOC entry 2611 (class 0 OID 0)
-- Dependencies: 1756
-- Name: COLUMN core_data_category.until_date; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_category.until_date IS 'The date this Data Category is no longer effective.';


--
-- TOC entry 2612 (class 0 OID 0)
-- Dependencies: 1756
-- Name: COLUMN core_data_category.identifier; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_category.identifier IS 'The human readable identifier of the Data Category.';


--
-- TOC entry 2613 (class 0 OID 0)
-- Dependencies: 1756
-- Name: COLUMN core_data_category.version; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_category.version IS 'The version of the Data Category.';


--
-- TOC entry 2614 (class 0 OID 0)
-- Dependencies: 1756
-- Name: COLUMN core_data_category.previous; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_category.previous IS 'The id of the previous version of this Data Category.';


--
-- TOC entry 2615 (class 0 OID 0)
-- Dependencies: 1756
-- Name: COLUMN core_data_category.private; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_category.private IS 'The private flag of this Data Category.';


--
-- TOC entry 2616 (class 0 OID 0)
-- Dependencies: 1756
-- Name: COLUMN core_data_category.justification; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_category.justification IS 'The justification for this Data Category.';


--
-- TOC entry 1757 (class 1259 OID 359166)
-- Dependencies: 6 1756
-- Name: core_data_category_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2617 (class 0 OID 0)
-- Dependencies: 1757
-- Name: core_data_category_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_data_category_id_seq OWNED BY core_data_category.id;


--
-- TOC entry 1758 (class 1259 OID 359168)
-- Dependencies: 2152 6
-- Name: core_data_category_selection; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_data_category_selection (
    id integer NOT NULL,
    name character varying NOT NULL,
    owner integer NOT NULL,
    parent integer,
    private boolean DEFAULT true NOT NULL
);


--
-- TOC entry 2618 (class 0 OID 0)
-- Dependencies: 1758
-- Name: TABLE core_data_category_selection; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_data_category_selection IS 'The core data table for Data Category Selections.';


--
-- TOC entry 2619 (class 0 OID 0)
-- Dependencies: 1758
-- Name: COLUMN core_data_category_selection.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_category_selection.id IS 'The id of this Data Category Selection.';


--
-- TOC entry 2620 (class 0 OID 0)
-- Dependencies: 1758
-- Name: COLUMN core_data_category_selection.name; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_category_selection.name IS 'The name of this Data Category Selection.';


--
-- TOC entry 2621 (class 0 OID 0)
-- Dependencies: 1758
-- Name: COLUMN core_data_category_selection.owner; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_category_selection.owner IS 'The owner of this Data Category Selection.';


--
-- TOC entry 2622 (class 0 OID 0)
-- Dependencies: 1758
-- Name: COLUMN core_data_category_selection.parent; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_category_selection.parent IS 'The parent Data Category Selection of this Data Category Selection.';


--
-- TOC entry 2623 (class 0 OID 0)
-- Dependencies: 1758
-- Name: COLUMN core_data_category_selection.private; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_category_selection.private IS 'The private flag of this Data Category Selection.';


--
-- TOC entry 1759 (class 1259 OID 359175)
-- Dependencies: 6 1758
-- Name: core_data_category_selection_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2624 (class 0 OID 0)
-- Dependencies: 1759
-- Name: core_data_category_selection_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_data_category_selection_id_seq OWNED BY core_data_category_selection.id;


--
-- TOC entry 1760 (class 1259 OID 359177)
-- Dependencies: 6
-- Name: core_data_type; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_data_type (
    id integer NOT NULL,
    data_type character varying NOT NULL,
    super integer
);


--
-- TOC entry 2625 (class 0 OID 0)
-- Dependencies: 1760
-- Name: TABLE core_data_type; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_data_type IS 'The core data table for data types.';


--
-- TOC entry 2626 (class 0 OID 0)
-- Dependencies: 1760
-- Name: COLUMN core_data_type.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_type.id IS 'The id of this data type.';


--
-- TOC entry 2627 (class 0 OID 0)
-- Dependencies: 1760
-- Name: COLUMN core_data_type.data_type; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_type.data_type IS 'The data type.';


--
-- TOC entry 2628 (class 0 OID 0)
-- Dependencies: 1760
-- Name: COLUMN core_data_type.super; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_data_type.super IS 'The super data type of this data type.';


--
-- TOC entry 1761 (class 1259 OID 359183)
-- Dependencies: 6 1760
-- Name: core_data_type_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2629 (class 0 OID 0)
-- Dependencies: 1761
-- Name: core_data_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_data_type_id_seq OWNED BY core_data_type.id;


--
-- TOC entry 1762 (class 1259 OID 359185)
-- Dependencies: 2155 6 348 328
-- Name: core_dc_status_log; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_dc_status_log (
    id integer NOT NULL,
    dc integer NOT NULL,
    administration_status administration_status_enum NOT NULL,
    registration_status registration_status_enum NOT NULL,
    comment character varying,
    "user" integer,
    "timestamp" timestamp with time zone DEFAULT '2010-07-05 13:11:02.959+02'::timestamp with time zone NOT NULL
);


--
-- TOC entry 1763 (class 1259 OID 359192)
-- Dependencies: 2157 6
-- Name: core_dcr_board; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_dcr_board (
    id integer NOT NULL,
    name character varying DEFAULT 'DCR Board'::character varying NOT NULL,
    description character varying
);


--
-- TOC entry 1764 (class 1259 OID 359199)
-- Dependencies: 6
-- Name: core_decision_group; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_decision_group (
    id integer NOT NULL,
    owner integer NOT NULL,
    decision_date date,
    dc integer NOT NULL
);


--
-- TOC entry 2630 (class 0 OID 0)
-- Dependencies: 1764
-- Name: TABLE core_decision_group; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_decision_group IS 'The core data table for Decision Groups.';


--
-- TOC entry 2631 (class 0 OID 0)
-- Dependencies: 1764
-- Name: COLUMN core_decision_group.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_decision_group.id IS 'The id of this Decision Group.';


--
-- TOC entry 2632 (class 0 OID 0)
-- Dependencies: 1764
-- Name: COLUMN core_decision_group.owner; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_decision_group.owner IS 'The owner of this Descision Group.';


--
-- TOC entry 2633 (class 0 OID 0)
-- Dependencies: 1764
-- Name: COLUMN core_decision_group.decision_date; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_decision_group.decision_date IS 'The date this Decision Group reached a decision.';


--
-- TOC entry 2634 (class 0 OID 0)
-- Dependencies: 1764
-- Name: COLUMN core_decision_group.dc; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_decision_group.dc IS 'The Data Category this Decision Group decides upon.';


--
-- TOC entry 1765 (class 1259 OID 359202)
-- Dependencies: 2158 6
-- Name: core_group; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_group (
    id integer NOT NULL,
    forum_public integer,
    forum_private integer,
    forum_group integer,
    sync boolean DEFAULT true NOT NULL
);


--
-- TOC entry 1766 (class 1259 OID 359206)
-- Dependencies: 2159 2160 6
-- Name: core_language; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_language (
    id integer NOT NULL,
    name character varying NOT NULL,
    tag character varying,
    search character varying DEFAULT 'simple'::character varying NOT NULL,
    direction character varying DEFAULT 'ltr'::character varying NOT NULL,
    tags character varying
);


--
-- TOC entry 2635 (class 0 OID 0)
-- Dependencies: 1766
-- Name: TABLE core_language; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_language IS 'The core data table for languages.';


--
-- TOC entry 2636 (class 0 OID 0)
-- Dependencies: 1766
-- Name: COLUMN core_language.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_language.id IS 'The id of this language.';


--
-- TOC entry 2637 (class 0 OID 0)
-- Dependencies: 1766
-- Name: COLUMN core_language.name; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_language.name IS 'The full name of this language.';


--
-- TOC entry 2638 (class 0 OID 0)
-- Dependencies: 1766
-- Name: COLUMN core_language.tag; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_language.tag IS 'The tag for this language as used by the xml:lang attribute (see IETF RFC 3066).';


--
-- TOC entry 1767 (class 1259 OID 359214)
-- Dependencies: 1766 6
-- Name: core_language_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2639 (class 0 OID 0)
-- Dependencies: 1767
-- Name: core_language_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_language_id_seq OWNED BY core_language.id;


--
-- TOC entry 1768 (class 1259 OID 359216)
-- Dependencies: 2162 6
-- Name: core_language_section; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_language_section (
    id integer NOT NULL,
    dc integer NOT NULL,
    language integer DEFAULT 1 NOT NULL
);


--
-- TOC entry 2640 (class 0 OID 0)
-- Dependencies: 1768
-- Name: TABLE core_language_section; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_language_section IS 'The core data table for language sections.';


--
-- TOC entry 2641 (class 0 OID 0)
-- Dependencies: 1768
-- Name: COLUMN core_language_section.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_language_section.id IS 'The id of the language section.';


--
-- TOC entry 2642 (class 0 OID 0)
-- Dependencies: 1768
-- Name: COLUMN core_language_section.dc; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_language_section.dc IS 'The Data Category of this language section.';


--
-- TOC entry 2643 (class 0 OID 0)
-- Dependencies: 1768
-- Name: COLUMN core_language_section.language; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_language_section.language IS 'The language of this language section.';


--
-- TOC entry 1769 (class 1259 OID 359220)
-- Dependencies: 6 1768
-- Name: core_language_section_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2644 (class 0 OID 0)
-- Dependencies: 1769
-- Name: core_language_section_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_language_section_id_seq OWNED BY core_language_section.id;


--
-- TOC entry 1770 (class 1259 OID 359222)
-- Dependencies: 2164 6
-- Name: core_linguistic_section; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_linguistic_section (
    id integer NOT NULL,
    language integer DEFAULT 1 NOT NULL
);


--
-- TOC entry 2645 (class 0 OID 0)
-- Dependencies: 1770
-- Name: TABLE core_linguistic_section; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_linguistic_section IS 'The core data table for linguistic sections.';


--
-- TOC entry 2646 (class 0 OID 0)
-- Dependencies: 1770
-- Name: COLUMN core_linguistic_section.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_linguistic_section.id IS 'The id of this linguistic section.';


--
-- TOC entry 2647 (class 0 OID 0)
-- Dependencies: 1770
-- Name: COLUMN core_linguistic_section.language; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_linguistic_section.language IS 'The language of this linguistic section.';


--
-- TOC entry 1771 (class 1259 OID 359226)
-- Dependencies: 6 1770
-- Name: core_linguistic_section_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2648 (class 0 OID 0)
-- Dependencies: 1771
-- Name: core_linguistic_section_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_linguistic_section_id_seq OWNED BY core_linguistic_section.id;


--
-- TOC entry 1772 (class 1259 OID 359228)
-- Dependencies: 2166 2167 2168 2169 338 6 340
-- Name: core_message; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_message (
    id integer NOT NULL,
    "from" integer NOT NULL,
    "to" integer,
    message character varying NOT NULL,
    created timestamp with time zone DEFAULT ('now'::text)::timestamp with time zone NOT NULL,
    read timestamp with time zone,
    status message_status_enum DEFAULT 'valid'::message_status_enum NOT NULL,
    type message_type_enum DEFAULT 'message'::message_type_enum NOT NULL,
    subject character varying DEFAULT '(no subject)'::character varying NOT NULL,
    action character varying,
    token character varying
);


--
-- TOC entry 1773 (class 1259 OID 359238)
-- Dependencies: 1772 6
-- Name: core_message_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2649 (class 0 OID 0)
-- Dependencies: 1773
-- Name: core_message_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_message_id_seq OWNED BY core_message.id;


--
-- TOC entry 1774 (class 1259 OID 359240)
-- Dependencies: 6
-- Name: core_open_conceptual_domain; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_open_conceptual_domain (
    id integer NOT NULL
);


--
-- TOC entry 2650 (class 0 OID 0)
-- Dependencies: 1774
-- Name: TABLE core_open_conceptual_domain; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_open_conceptual_domain IS 'The core data table for open conceptual domains.';


--
-- TOC entry 1775 (class 1259 OID 359243)
-- Dependencies: 6
-- Name: core_open_data_category; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_open_data_category (
    id integer NOT NULL
);


--
-- TOC entry 2651 (class 0 OID 0)
-- Dependencies: 1775
-- Name: TABLE core_open_data_category; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_open_data_category IS 'The core data table for open Data Categories.';


--
-- TOC entry 1776 (class 1259 OID 359246)
-- Dependencies: 6
-- Name: core_owner; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_owner (
    id integer NOT NULL
);


--
-- TOC entry 2652 (class 0 OID 0)
-- Dependencies: 1776
-- Name: TABLE core_owner; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_owner IS 'The core data table for owners.';


--
-- TOC entry 2653 (class 0 OID 0)
-- Dependencies: 1776
-- Name: COLUMN core_owner.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_owner.id IS 'The id of this owner.';


--
-- TOC entry 1777 (class 1259 OID 359249)
-- Dependencies: 6
-- Name: core_profile; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_profile (
    id integer NOT NULL,
    name character varying NOT NULL,
    tdg integer,
    parent integer,
    "order" integer
);


--
-- TOC entry 2654 (class 0 OID 0)
-- Dependencies: 1777
-- Name: TABLE core_profile; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_profile IS 'The core data table for profiles.';


--
-- TOC entry 2655 (class 0 OID 0)
-- Dependencies: 1777
-- Name: COLUMN core_profile.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_profile.id IS 'The id of this profile.';


--
-- TOC entry 2656 (class 0 OID 0)
-- Dependencies: 1777
-- Name: COLUMN core_profile.name; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_profile.name IS 'The name of this profile.';


--
-- TOC entry 2657 (class 0 OID 0)
-- Dependencies: 1777
-- Name: COLUMN core_profile.tdg; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_profile.tdg IS 'The Thematic Domain Group this profile belongs to.';


--
-- TOC entry 2658 (class 0 OID 0)
-- Dependencies: 1777
-- Name: COLUMN core_profile.parent; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_profile.parent IS 'The parent profile of this profile.';


--
-- TOC entry 1778 (class 1259 OID 359255)
-- Dependencies: 6 1777
-- Name: core_profile_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2659 (class 0 OID 0)
-- Dependencies: 1778
-- Name: core_profile_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_profile_id_seq OWNED BY core_profile.id;


--
-- TOC entry 1779 (class 1259 OID 359257)
-- Dependencies: 6
-- Name: core_profile_value_domain; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_profile_value_domain (
    id integer NOT NULL,
    profile integer NOT NULL
);


--
-- TOC entry 2660 (class 0 OID 0)
-- Dependencies: 1779
-- Name: TABLE core_profile_value_domain; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_profile_value_domain IS 'The core data table for profile value domains.';


--
-- TOC entry 2661 (class 0 OID 0)
-- Dependencies: 1779
-- Name: COLUMN core_profile_value_domain.profile; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_profile_value_domain.profile IS 'The profile of this profile value domain.';


--
-- TOC entry 1780 (class 1259 OID 359260)
-- Dependencies: 6
-- Name: core_registration_authority; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_registration_authority (
    id integer NOT NULL,
    registration_authority character varying NOT NULL
);


--
-- TOC entry 2662 (class 0 OID 0)
-- Dependencies: 1780
-- Name: TABLE core_registration_authority; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_registration_authority IS 'The core data table for registration authorities.';


--
-- TOC entry 2663 (class 0 OID 0)
-- Dependencies: 1780
-- Name: COLUMN core_registration_authority.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_registration_authority.id IS 'The id of the registration authority.';


--
-- TOC entry 2664 (class 0 OID 0)
-- Dependencies: 1780
-- Name: COLUMN core_registration_authority.registration_authority; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_registration_authority.registration_authority IS 'The name of the registration authority.';


--
-- TOC entry 1781 (class 1259 OID 359266)
-- Dependencies: 1780 6
-- Name: core_registration_authority_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2665 (class 0 OID 0)
-- Dependencies: 1781
-- Name: core_registration_authority_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_registration_authority_id_seq OWNED BY core_registration_authority.id;


--
-- TOC entry 1782 (class 1259 OID 359268)
-- Dependencies: 2173 6
-- Name: core_registration_group; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_registration_group (
    id integer NOT NULL,
    dc integer NOT NULL,
    registration_authority integer DEFAULT 1 NOT NULL
);


--
-- TOC entry 2666 (class 0 OID 0)
-- Dependencies: 1782
-- Name: TABLE core_registration_group; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_registration_group IS 'The core data table for Registration Groups.';


--
-- TOC entry 2667 (class 0 OID 0)
-- Dependencies: 1782
-- Name: COLUMN core_registration_group.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_registration_group.id IS 'The id of this Registration Group.';


--
-- TOC entry 2668 (class 0 OID 0)
-- Dependencies: 1782
-- Name: COLUMN core_registration_group.dc; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_registration_group.dc IS 'The Data Category this Registration Group registers.';


--
-- TOC entry 2669 (class 0 OID 0)
-- Dependencies: 1782
-- Name: COLUMN core_registration_group.registration_authority; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_registration_group.registration_authority IS 'The Registration Authority of this registration group.';


--
-- TOC entry 1783 (class 1259 OID 359272)
-- Dependencies: 6
-- Name: core_rule; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_rule (
    id integer NOT NULL,
    rule character varying NOT NULL,
    cd integer NOT NULL
);


--
-- TOC entry 2670 (class 0 OID 0)
-- Dependencies: 1783
-- Name: TABLE core_rule; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_rule IS 'The rules in the constrained conceptual domains.';


--
-- TOC entry 1784 (class 1259 OID 359278)
-- Dependencies: 6 1783
-- Name: core_rule_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2671 (class 0 OID 0)
-- Dependencies: 1784
-- Name: core_rule_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_rule_id_seq OWNED BY core_rule.id;


--
-- TOC entry 1785 (class 1259 OID 359280)
-- Dependencies: 6
-- Name: core_rule_type; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_rule_type (
    id integer NOT NULL,
    rule_type character varying NOT NULL,
    xml boolean
);


--
-- TOC entry 1786 (class 1259 OID 359286)
-- Dependencies: 6 1785
-- Name: core_rule_type_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2672 (class 0 OID 0)
-- Dependencies: 1786
-- Name: core_rule_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_rule_type_id_seq OWNED BY core_rule_type.id;


--
-- TOC entry 1787 (class 1259 OID 359288)
-- Dependencies: 6
-- Name: core_selected_complex_data_category; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_selected_complex_data_category (
    id integer NOT NULL,
    dc integer NOT NULL
);


--
-- TOC entry 2673 (class 0 OID 0)
-- Dependencies: 1787
-- Name: TABLE core_selected_complex_data_category; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_selected_complex_data_category IS 'The core data table for selected complex Data Categories.';


--
-- TOC entry 1788 (class 1259 OID 359291)
-- Dependencies: 6
-- Name: core_selected_container_data_category; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_selected_container_data_category (
    id integer NOT NULL,
    dc integer NOT NULL
);


--
-- TOC entry 1789 (class 1259 OID 359294)
-- Dependencies: 6
-- Name: core_selected_data_category; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_selected_data_category (
    id integer NOT NULL,
    dcs integer NOT NULL
);


--
-- TOC entry 2674 (class 0 OID 0)
-- Dependencies: 1789
-- Name: TABLE core_selected_data_category; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_selected_data_category IS 'The core data table for selected Data Categories.';


--
-- TOC entry 2675 (class 0 OID 0)
-- Dependencies: 1789
-- Name: COLUMN core_selected_data_category.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_selected_data_category.id IS 'The id of this selected Data Category.';


--
-- TOC entry 2676 (class 0 OID 0)
-- Dependencies: 1789
-- Name: COLUMN core_selected_data_category.dcs; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_selected_data_category.dcs IS 'The Data Category Selection this Data Category belongs to.';


--
-- TOC entry 1790 (class 1259 OID 359297)
-- Dependencies: 6 1789
-- Name: core_selected_data_category_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2677 (class 0 OID 0)
-- Dependencies: 1790
-- Name: core_selected_data_category_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_selected_data_category_id_seq OWNED BY core_selected_data_category.id;


--
-- TOC entry 1791 (class 1259 OID 359299)
-- Dependencies: 6
-- Name: core_selected_simple_data_category; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_selected_simple_data_category (
    id integer NOT NULL,
    dc integer NOT NULL
);


--
-- TOC entry 2678 (class 0 OID 0)
-- Dependencies: 1791
-- Name: TABLE core_selected_simple_data_category; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_selected_simple_data_category IS 'The core data table for selected simple Data Categories.';


--
-- TOC entry 1792 (class 1259 OID 359302)
-- Dependencies: 2177 6
-- Name: core_session; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_session (
    id integer NOT NULL,
    "user" integer NOT NULL,
    first_access timestamp with time zone DEFAULT ('now'::text)::timestamp with time zone NOT NULL,
    last_access timestamp with time zone
);


--
-- TOC entry 1793 (class 1259 OID 359306)
-- Dependencies: 6 1792
-- Name: core_session_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2679 (class 0 OID 0)
-- Dependencies: 1793
-- Name: core_session_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_session_id_seq OWNED BY core_session.id;


--
-- TOC entry 1794 (class 1259 OID 359308)
-- Dependencies: 6
-- Name: core_simple_data_category; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_simple_data_category (
    id integer NOT NULL
);


--
-- TOC entry 2680 (class 0 OID 0)
-- Dependencies: 1794
-- Name: TABLE core_simple_data_category; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_simple_data_category IS 'The core data table for simple Data Categories.';


--
-- TOC entry 1795 (class 1259 OID 359311)
-- Dependencies: 6 1762
-- Name: core_status_log_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2681 (class 0 OID 0)
-- Dependencies: 1795
-- Name: core_status_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE core_status_log_id_seq OWNED BY core_dc_status_log.id;


--
-- TOC entry 1796 (class 1259 OID 359313)
-- Dependencies: 6
-- Name: core_submission_group; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_submission_group (
    id integer NOT NULL,
    dc integer NOT NULL,
    owner integer NOT NULL,
    submission_date date
);


--
-- TOC entry 2682 (class 0 OID 0)
-- Dependencies: 1796
-- Name: TABLE core_submission_group; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_submission_group IS 'The core data table for Submission Groups.';


--
-- TOC entry 2683 (class 0 OID 0)
-- Dependencies: 1796
-- Name: COLUMN core_submission_group.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_submission_group.id IS 'The id of this Submission Group.';


--
-- TOC entry 2684 (class 0 OID 0)
-- Dependencies: 1796
-- Name: COLUMN core_submission_group.dc; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_submission_group.dc IS 'The Data Category this Submission Group submitted.';


--
-- TOC entry 2685 (class 0 OID 0)
-- Dependencies: 1796
-- Name: COLUMN core_submission_group.owner; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_submission_group.owner IS 'The owner of this Submission Group.';


--
-- TOC entry 2686 (class 0 OID 0)
-- Dependencies: 1796
-- Name: COLUMN core_submission_group.submission_date; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_submission_group.submission_date IS 'The date this Submission Group submitted the Data Category.';


--
-- TOC entry 1797 (class 1259 OID 359316)
-- Dependencies: 6
-- Name: core_thematic_domain_group; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_thematic_domain_group (
    id integer NOT NULL,
    name character varying NOT NULL,
    description character varying,
    "order" integer NOT NULL,
    status character varying,
    activity character varying
);


--
-- TOC entry 2687 (class 0 OID 0)
-- Dependencies: 1797
-- Name: TABLE core_thematic_domain_group; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_thematic_domain_group IS 'The core data table for Thematic Domain Groups.';


--
-- TOC entry 2688 (class 0 OID 0)
-- Dependencies: 1797
-- Name: COLUMN core_thematic_domain_group.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_thematic_domain_group.id IS 'The id of this Thematic Domain Group.';


--
-- TOC entry 2689 (class 0 OID 0)
-- Dependencies: 1797
-- Name: COLUMN core_thematic_domain_group.name; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_thematic_domain_group.name IS 'The name of this Thematic Domain Group.';


--
-- TOC entry 1798 (class 1259 OID 359322)
-- Dependencies: 2179 2180 2181 2182 6 352
-- Name: core_user; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_user (
    id integer NOT NULL,
    login character varying NOT NULL,
    last_name character varying,
    email character varying NOT NULL,
    organization character varying,
    phone character varying,
    post character varying,
    access_count integer DEFAULT 0 NOT NULL,
    first_access date,
    last_access date,
    password character varying NOT NULL,
    type user_type_enum DEFAULT 'basic'::user_type_enum NOT NULL,
    first_name character varying,
    disclaimer boolean DEFAULT false NOT NULL,
    sync boolean DEFAULT true NOT NULL,
    forum integer,
    shib_principal character varying
);


--
-- TOC entry 2690 (class 0 OID 0)
-- Dependencies: 1798
-- Name: TABLE core_user; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_user IS 'The core data table for users.';


--
-- TOC entry 2691 (class 0 OID 0)
-- Dependencies: 1798
-- Name: COLUMN core_user.login; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_user.login IS 'The login of this user.';


--
-- TOC entry 2692 (class 0 OID 0)
-- Dependencies: 1798
-- Name: COLUMN core_user.last_name; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_user.last_name IS 'The last name of this user.';


--
-- TOC entry 2693 (class 0 OID 0)
-- Dependencies: 1798
-- Name: COLUMN core_user.email; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_user.email IS 'The email address of this user.';


--
-- TOC entry 2694 (class 0 OID 0)
-- Dependencies: 1798
-- Name: COLUMN core_user.organization; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_user.organization IS 'The organization this user is a member of.';


--
-- TOC entry 2695 (class 0 OID 0)
-- Dependencies: 1798
-- Name: COLUMN core_user.phone; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_user.phone IS 'The phone number of this user.';


--
-- TOC entry 2696 (class 0 OID 0)
-- Dependencies: 1798
-- Name: COLUMN core_user.post; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_user.post IS 'The postal address of this user.';


--
-- TOC entry 2697 (class 0 OID 0)
-- Dependencies: 1798
-- Name: COLUMN core_user.access_count; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_user.access_count IS 'The access count of this user.';


--
-- TOC entry 2698 (class 0 OID 0)
-- Dependencies: 1798
-- Name: COLUMN core_user.first_access; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_user.first_access IS 'The date of the first access of this user.';


--
-- TOC entry 2699 (class 0 OID 0)
-- Dependencies: 1798
-- Name: COLUMN core_user.last_access; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_user.last_access IS 'The date of the last access of this user.';


--
-- TOC entry 2700 (class 0 OID 0)
-- Dependencies: 1798
-- Name: COLUMN core_user.password; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN core_user.password IS 'The password of this user.';


--
-- TOC entry 1799 (class 1259 OID 359332)
-- Dependencies: 6
-- Name: core_value_domain; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE core_value_domain (
    id integer NOT NULL
);


--
-- TOC entry 2701 (class 0 OID 0)
-- Dependencies: 1799
-- Name: TABLE core_value_domain; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE core_value_domain IS 'The core data table for value domains.';


--
-- TOC entry 1800 (class 1259 OID 359335)
-- Dependencies: 2183 332 6
-- Name: generic_lock; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE generic_lock (
    id integer NOT NULL,
    session integer NOT NULL,
    type lock_type_enum NOT NULL,
    lock integer NOT NULL,
    first_access timestamp with time zone DEFAULT ('now'::text)::timestamp with time zone NOT NULL,
    last_access timestamp with time zone
);


--
-- TOC entry 1801 (class 1259 OID 359339)
-- Dependencies: 1800 6
-- Name: generic_lock_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2702 (class 0 OID 0)
-- Dependencies: 1801
-- Name: generic_lock_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE generic_lock_id_seq OWNED BY generic_lock.id;


--
-- TOC entry 1802 (class 1259 OID 359341)
-- Dependencies: 2185 346 6 342 344
-- Name: generic_name; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE generic_name (
    id integer NOT NULL,
    owner integer NOT NULL,
    name_type name_type_enum NOT NULL,
    source character varying,
    status name_status_enum,
    name character varying NOT NULL,
    owner_type owner_type_enum NOT NULL,
    search tsvector,
    search_language tsvector,
    language integer DEFAULT 1 NOT NULL
);


--
-- TOC entry 2703 (class 0 OID 0)
-- Dependencies: 1802
-- Name: TABLE generic_name; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE generic_name IS 'The generic data table for names.';


--
-- TOC entry 2704 (class 0 OID 0)
-- Dependencies: 1802
-- Name: COLUMN generic_name.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN generic_name.id IS 'The id of this name.';


--
-- TOC entry 2705 (class 0 OID 0)
-- Dependencies: 1802
-- Name: COLUMN generic_name.owner; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN generic_name.owner IS 'The owner of this name.';


--
-- TOC entry 2706 (class 0 OID 0)
-- Dependencies: 1802
-- Name: COLUMN generic_name.name_type; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN generic_name.name_type IS 'The type of this name.';


--
-- TOC entry 2707 (class 0 OID 0)
-- Dependencies: 1802
-- Name: COLUMN generic_name.source; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN generic_name.source IS 'The source of this name.';


--
-- TOC entry 2708 (class 0 OID 0)
-- Dependencies: 1802
-- Name: COLUMN generic_name.status; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN generic_name.status IS 'The status of this name.';


--
-- TOC entry 2709 (class 0 OID 0)
-- Dependencies: 1802
-- Name: COLUMN generic_name.name; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN generic_name.name IS 'The actual name.';


--
-- TOC entry 1803 (class 1259 OID 359348)
-- Dependencies: 1802 6
-- Name: generic_name_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2710 (class 0 OID 0)
-- Dependencies: 1803
-- Name: generic_name_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE generic_name_id_seq OWNED BY generic_name.id;


--
-- TOC entry 1804 (class 1259 OID 359350)
-- Dependencies: 2187 2188 2189 2190 6 350 346
-- Name: generic_text; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE generic_text (
    id integer NOT NULL,
    owner integer NOT NULL,
    owner_type owner_type_enum NOT NULL,
    language integer DEFAULT 1 NOT NULL,
    date date DEFAULT ('now'::text)::date NOT NULL,
    source character varying,
    text character varying NOT NULL,
    text_type text_type_enum DEFAULT 'text'::text_type_enum NOT NULL,
    "user" integer,
    "timestamp" timestamp with time zone DEFAULT ('now'::text)::timestamp with time zone NOT NULL,
    search tsvector,
    search_language tsvector
);


--
-- TOC entry 2711 (class 0 OID 0)
-- Dependencies: 1804
-- Name: TABLE generic_text; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE generic_text IS 'The generic data table for texts.';


--
-- TOC entry 2712 (class 0 OID 0)
-- Dependencies: 1804
-- Name: COLUMN generic_text.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN generic_text.id IS 'The id of this text.';


--
-- TOC entry 2713 (class 0 OID 0)
-- Dependencies: 1804
-- Name: COLUMN generic_text.owner; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN generic_text.owner IS 'The owner of this text.';


--
-- TOC entry 2714 (class 0 OID 0)
-- Dependencies: 1804
-- Name: COLUMN generic_text.owner_type; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN generic_text.owner_type IS 'The type of the owner.';


--
-- TOC entry 2715 (class 0 OID 0)
-- Dependencies: 1804
-- Name: COLUMN generic_text.language; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN generic_text.language IS 'The language used by this text.';


--
-- TOC entry 2716 (class 0 OID 0)
-- Dependencies: 1804
-- Name: COLUMN generic_text.date; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN generic_text.date IS 'When was this text entered.';


--
-- TOC entry 2717 (class 0 OID 0)
-- Dependencies: 1804
-- Name: COLUMN generic_text.source; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN generic_text.source IS 'The source of this text.';


--
-- TOC entry 2718 (class 0 OID 0)
-- Dependencies: 1804
-- Name: COLUMN generic_text.text; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN generic_text.text IS 'The actual text.';


--
-- TOC entry 2719 (class 0 OID 0)
-- Dependencies: 1804
-- Name: COLUMN generic_text.text_type; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN generic_text.text_type IS 'The type of this text.';


--
-- TOC entry 2720 (class 0 OID 0)
-- Dependencies: 1804
-- Name: COLUMN generic_text."user"; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN generic_text."user" IS 'The user who wrote this text.';


--
-- TOC entry 1805 (class 1259 OID 359360)
-- Dependencies: 6 1804
-- Name: generic_text_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- TOC entry 2721 (class 0 OID 0)
-- Dependencies: 1805
-- Name: generic_text_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE generic_text_id_seq OWNED BY generic_text.id;


--
-- TOC entry 1806 (class 1259 OID 359362)
-- Dependencies: 6
-- Name: link_closed_data_category_conceptual_domains; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE link_closed_data_category_conceptual_domains (
    dc integer NOT NULL,
    cd integer NOT NULL
);


--
-- TOC entry 2722 (class 0 OID 0)
-- Dependencies: 1806
-- Name: TABLE link_closed_data_category_conceptual_domains; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE link_closed_data_category_conceptual_domains IS 'The link table between closed Data Categories and profile value domains.';


--
-- TOC entry 2723 (class 0 OID 0)
-- Dependencies: 1806
-- Name: COLUMN link_closed_data_category_conceptual_domains.dc; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_closed_data_category_conceptual_domains.dc IS 'The closed Data Category.';


--
-- TOC entry 2724 (class 0 OID 0)
-- Dependencies: 1806
-- Name: COLUMN link_closed_data_category_conceptual_domains.cd; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_closed_data_category_conceptual_domains.cd IS 'The profile value domain.';


--
-- TOC entry 1807 (class 1259 OID 359365)
-- Dependencies: 6
-- Name: link_constrained_data_category_conceptual_domains; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE link_constrained_data_category_conceptual_domains (
    dc integer NOT NULL,
    cd integer NOT NULL
);


--
-- TOC entry 2725 (class 0 OID 0)
-- Dependencies: 1807
-- Name: TABLE link_constrained_data_category_conceptual_domains; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE link_constrained_data_category_conceptual_domains IS 'The link table between constrained Data Categories and schema specific domains.';


--
-- TOC entry 2726 (class 0 OID 0)
-- Dependencies: 1807
-- Name: COLUMN link_constrained_data_category_conceptual_domains.dc; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_constrained_data_category_conceptual_domains.dc IS 'The constrained Data Category.';


--
-- TOC entry 2727 (class 0 OID 0)
-- Dependencies: 1807
-- Name: COLUMN link_constrained_data_category_conceptual_domains.cd; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_constrained_data_category_conceptual_domains.cd IS 'The Schema Specifc Domain.';


--
-- TOC entry 1808 (class 1259 OID 359368)
-- Dependencies: 6
-- Name: link_constrained_linguistic_section_conceptual_domains; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE link_constrained_linguistic_section_conceptual_domains (
    ls integer NOT NULL,
    cd integer NOT NULL
);


--
-- TOC entry 1809 (class 1259 OID 359371)
-- Dependencies: 6
-- Name: link_data_category_selection_users; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE link_data_category_selection_users (
    dcs integer NOT NULL,
    "user" integer NOT NULL
);


--
-- TOC entry 2728 (class 0 OID 0)
-- Dependencies: 1809
-- Name: TABLE link_data_category_selection_users; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE link_data_category_selection_users IS 'The link table between Data Category Selection and its users.';


--
-- TOC entry 2729 (class 0 OID 0)
-- Dependencies: 1809
-- Name: COLUMN link_data_category_selection_users.dcs; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_data_category_selection_users.dcs IS 'The Data Category Selection.';


--
-- TOC entry 2730 (class 0 OID 0)
-- Dependencies: 1809
-- Name: COLUMN link_data_category_selection_users."user"; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_data_category_selection_users."user" IS 'The user.';


--
-- TOC entry 1810 (class 1259 OID 359374)
-- Dependencies: 2192 6 326
-- Name: link_dc_access; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE link_dc_access (
    dc integer NOT NULL,
    account integer NOT NULL,
    rights access_rights_enum DEFAULT 'r'::access_rights_enum NOT NULL
);


--
-- TOC entry 1811 (class 1259 OID 359378)
-- Dependencies: 2193 2194 6 326 326
-- Name: link_dcs_access; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE link_dcs_access (
    dcs integer NOT NULL,
    account integer NOT NULL,
    rights access_rights_enum DEFAULT 'r'::access_rights_enum NOT NULL,
    propagate access_rights_enum DEFAULT 'r'::access_rights_enum NOT NULL
);


--
-- TOC entry 1812 (class 1259 OID 359383)
-- Dependencies: 2195 2196 336 6 334
-- Name: link_group_members; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE link_group_members (
    "group" integer NOT NULL,
    member integer NOT NULL,
    role member_type_enum DEFAULT 'member'::member_type_enum NOT NULL,
    status member_status_enum DEFAULT 'invite'::member_status_enum NOT NULL
);


--
-- TOC entry 1813 (class 1259 OID 359388)
-- Dependencies: 6
-- Name: link_open_data_category_conceptual_domain; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE link_open_data_category_conceptual_domain (
    dc integer NOT NULL,
    cd integer NOT NULL
);


--
-- TOC entry 2731 (class 0 OID 0)
-- Dependencies: 1813
-- Name: TABLE link_open_data_category_conceptual_domain; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE link_open_data_category_conceptual_domain IS 'The link table between open Data Categories and a open conceptual domain.';


--
-- TOC entry 2732 (class 0 OID 0)
-- Dependencies: 1813
-- Name: COLUMN link_open_data_category_conceptual_domain.dc; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_open_data_category_conceptual_domain.dc IS 'The open data category.';


--
-- TOC entry 2733 (class 0 OID 0)
-- Dependencies: 1813
-- Name: COLUMN link_open_data_category_conceptual_domain.cd; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_open_data_category_conceptual_domain.cd IS 'The open conceptual domain.';


--
-- TOC entry 1814 (class 1259 OID 359391)
-- Dependencies: 6
-- Name: link_profile_members; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE link_profile_members (
    profile integer NOT NULL,
    dc integer NOT NULL
);


--
-- TOC entry 2734 (class 0 OID 0)
-- Dependencies: 1814
-- Name: TABLE link_profile_members; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE link_profile_members IS 'The link table between Profile and Data Category.';


--
-- TOC entry 2735 (class 0 OID 0)
-- Dependencies: 1814
-- Name: COLUMN link_profile_members.profile; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_profile_members.profile IS 'The profile of this Data Category.';


--
-- TOC entry 2736 (class 0 OID 0)
-- Dependencies: 1814
-- Name: COLUMN link_profile_members.dc; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_profile_members.dc IS 'The Data Category which is a member of this profile.';


--
-- TOC entry 1815 (class 1259 OID 359394)
-- Dependencies: 6
-- Name: link_selected_data_category_picklist; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE link_selected_data_category_picklist (
    cdc integer NOT NULL,
    sdc integer NOT NULL
);


--
-- TOC entry 2737 (class 0 OID 0)
-- Dependencies: 1815
-- Name: TABLE link_selected_data_category_picklist; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE link_selected_data_category_picklist IS 'The link table between selected complex Data Categories and the selected simple Data Categories in its picklist.';


--
-- TOC entry 2738 (class 0 OID 0)
-- Dependencies: 1815
-- Name: COLUMN link_selected_data_category_picklist.cdc; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_selected_data_category_picklist.cdc IS 'The selected complex Data Category.';


--
-- TOC entry 2739 (class 0 OID 0)
-- Dependencies: 1815
-- Name: COLUMN link_selected_data_category_picklist.sdc; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_selected_data_category_picklist.sdc IS 'The selected simple Data Category.';


--
-- TOC entry 1816 (class 1259 OID 359397)
-- Dependencies: 6
-- Name: link_selected_data_category_profiles; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE link_selected_data_category_profiles (
    dc integer NOT NULL,
    profile integer NOT NULL
);


--
-- TOC entry 2740 (class 0 OID 0)
-- Dependencies: 1816
-- Name: TABLE link_selected_data_category_profiles; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE link_selected_data_category_profiles IS 'The link table between selected Data Categories and profiles.';


--
-- TOC entry 2741 (class 0 OID 0)
-- Dependencies: 1816
-- Name: COLUMN link_selected_data_category_profiles.dc; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_selected_data_category_profiles.dc IS 'The selected Data Category.';


--
-- TOC entry 2742 (class 0 OID 0)
-- Dependencies: 1816
-- Name: COLUMN link_selected_data_category_profiles.profile; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_selected_data_category_profiles.profile IS 'The profile.';


--
-- TOC entry 1817 (class 1259 OID 359400)
-- Dependencies: 6
-- Name: link_simple_data_category_super; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE link_simple_data_category_super (
    dc integer NOT NULL,
    super integer NOT NULL
);


--
-- TOC entry 2743 (class 0 OID 0)
-- Dependencies: 1817
-- Name: TABLE link_simple_data_category_super; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE link_simple_data_category_super IS 'The link table between simple Data Category and a more generic simple Data Category.';


--
-- TOC entry 2744 (class 0 OID 0)
-- Dependencies: 1817
-- Name: COLUMN link_simple_data_category_super.dc; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_simple_data_category_super.dc IS 'The simple Data Category.';


--
-- TOC entry 2745 (class 0 OID 0)
-- Dependencies: 1817
-- Name: COLUMN link_simple_data_category_super.super; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_simple_data_category_super.super IS 'The more generic simple Data Category.';


--
-- TOC entry 1818 (class 1259 OID 359403)
-- Dependencies: 6
-- Name: link_value_domain_values; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE link_value_domain_values (
    cd integer NOT NULL,
    dc integer NOT NULL
);


--
-- TOC entry 2746 (class 0 OID 0)
-- Dependencies: 1818
-- Name: TABLE link_value_domain_values; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE link_value_domain_values IS 'The link table between Value Domain and the simple Data Categories which are its values.';


--
-- TOC entry 2747 (class 0 OID 0)
-- Dependencies: 1818
-- Name: COLUMN link_value_domain_values.cd; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_value_domain_values.cd IS 'The value domain.';


--
-- TOC entry 2748 (class 0 OID 0)
-- Dependencies: 1818
-- Name: COLUMN link_value_domain_values.dc; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN link_value_domain_values.dc IS 'The simple Data Category.';


--
-- TOC entry 1836 (class 1259 OID 360530)
-- Dependencies: 6
-- Name: search_exact; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE search_exact (
    id integer,
    private boolean,
    rank numeric
);


--
-- TOC entry 1835 (class 1259 OID 360524)
-- Dependencies: 6
-- Name: search_like; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE search_like (
    id integer,
    private boolean,
    rank numeric
);


--
-- TOC entry 1819 (class 1259 OID 359406)
-- Dependencies: 1926 6
-- Name: view_cd_type; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_cd_type AS
    SELECT core_conceptual_domain.id, cd_type.type FROM (core_conceptual_domain JOIN ((SELECT core_open_conceptual_domain.id, 'open' AS type FROM core_open_conceptual_domain UNION SELECT core_conceptual_domain_rule.id, 'constrained' AS type FROM core_conceptual_domain_rule) UNION SELECT core_value_domain.id, 'closed' AS type FROM core_value_domain) cd_type ON ((cd_type.id = core_conceptual_domain.id)));


--
-- TOC entry 1820 (class 1259 OID 359410)
-- Dependencies: 1927 6 336
-- Name: view_cr_decision_group_dcrb; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_cr_decision_group_dcrb AS
    SELECT core_change_request.id AS cr, link_group_members.member, link_group_members.role FROM (core_change_request JOIN link_group_members ON ((link_group_members."group" = core_change_request.decision_group_dcrb)));


--
-- TOC entry 1821 (class 1259 OID 359414)
-- Dependencies: 1928 6 336
-- Name: view_cr_decision_group_tdg; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_cr_decision_group_tdg AS
    SELECT core_change_request.id AS cr, link_group_members.member, link_group_members.role FROM (core_change_request JOIN link_group_members ON ((link_group_members."group" = core_change_request.decision_group_tdg)));


--
-- TOC entry 1822 (class 1259 OID 359418)
-- Dependencies: 1929 6 336
-- Name: view_cr_submission_group; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_cr_submission_group AS
    SELECT core_change_request.id AS cr, link_group_members.member, link_group_members.role FROM (core_change_request JOIN link_group_members ON ((link_group_members."group" = core_change_request.submission_group)));


--
-- TOC entry 1823 (class 1259 OID 359422)
-- Dependencies: 1930 6
-- Name: view_dc_type; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_dc_type AS
    SELECT core_data_category.id, dc_type.type FROM (core_data_category LEFT JOIN ((((SELECT open.id, 'open' AS type FROM (SELECT core_open_data_category.id FROM core_open_data_category EXCEPT SELECT core_constrained_data_category.id FROM core_constrained_data_category) open UNION SELECT core_constrained_data_category.id, 'constrained' AS type FROM core_constrained_data_category) UNION SELECT core_closed_data_category.id, 'closed' AS type FROM core_closed_data_category) UNION SELECT core_simple_data_category.id, 'simple' AS type FROM core_simple_data_category) UNION SELECT core_container_data_category.id, 'container' AS type FROM core_container_data_category) dc_type ON ((dc_type.id = core_data_category.id)));


--
-- TOC entry 1824 (class 1259 OID 359427)
-- Dependencies: 1931 6
-- Name: view_owner; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_owner AS
    SELECT core_owner.id, COALESCE(core_thematic_domain_group.name, user_name(core_user.id), NULL::character varying) AS name FROM ((core_owner LEFT JOIN core_thematic_domain_group ON ((core_thematic_domain_group.id = core_owner.id))) LEFT JOIN core_user ON ((core_user.id = core_owner.id)));


--
-- TOC entry 1825 (class 1259 OID 359431)
-- Dependencies: 1932 6 348 328 330
-- Name: view_data_category; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_data_category AS
    SELECT core_data_category.id, core_data_category.pid, core_data_category.name, view_owner.id AS owner_id, view_owner.name AS owner, core_data_category.identifier, core_data_category.version, core_data_category.branch, core_data_category.revision, core_data_category.sidebranches, core_data_category.administration_status, core_data_category.registration_status, core_data_category.justification, core_data_category.origin, core_data_category.effective_date, core_data_category.until_date, core_data_category.previous, core_data_category.next, core_data_category.private, view_dc_type.type, core_data_category."check", link_simple_data_category_super.super FROM (((core_data_category JOIN view_owner ON ((view_owner.id = core_data_category.owner))) JOIN view_dc_type ON ((view_dc_type.id = core_data_category.id))) LEFT JOIN link_simple_data_category_super ON ((link_simple_data_category_super.dc = core_data_category.id)));


--
-- TOC entry 1837 (class 1259 OID 360961)
-- Dependencies: 1942 326 326 6
-- Name: view_dcs_access; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_dcs_access AS
    SELECT access.dcs, access.account, access.type, max(access.rights) AS rights, max(access.propagate) AS propagate FROM ((SELECT link_dcs_access.dcs, link_dcs_access.account, link_dcs_access.rights, link_dcs_access.propagate, 'user' AS type FROM (link_dcs_access JOIN core_user ON ((link_dcs_access.account = core_user.id))) UNION SELECT link_dcs_access.dcs, link_dcs_access.account, link_dcs_access.rights, link_dcs_access.propagate, 'group' AS type FROM (link_dcs_access JOIN core_group ON ((link_dcs_access.account = core_group.id)))) UNION SELECT link_dcs_access.dcs, link_group_members.member, link_dcs_access.rights, link_dcs_access.propagate, 'user' AS type FROM ((link_group_members JOIN core_group ON ((link_group_members."group" = core_group.id))) JOIN link_dcs_access ON ((link_dcs_access.account = core_group.id))) WHERE (link_group_members.status = 'accepted'::member_status_enum)) access GROUP BY access.dcs, access.account, access.type;


--
-- TOC entry 1826 (class 1259 OID 359441)
-- Dependencies: 1933 6
-- Name: view_dcs_dc; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_dcs_dc AS
    SELECT dcs.dcs, dcs.dc, core_data_category.owner FROM ((SELECT core_selected_data_category.dcs, COALESCE(core_selected_container_data_category.dc, core_selected_complex_data_category.dc, core_selected_simple_data_category.dc, NULL::integer) AS dc FROM (((core_selected_data_category LEFT JOIN core_selected_container_data_category ON ((core_selected_container_data_category.id = core_selected_data_category.id))) LEFT JOIN core_selected_complex_data_category ON ((core_selected_complex_data_category.id = core_selected_data_category.id))) LEFT JOIN core_selected_simple_data_category ON ((core_selected_simple_data_category.id = core_selected_data_category.id)))) dcs JOIN core_data_category ON ((core_data_category.id = dcs.dc)));


--
-- TOC entry 1838 (class 1259 OID 360966)
-- Dependencies: 1943 326 6
-- Name: view_dc_access; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_dc_access AS
    SELECT access.dc, access.account, access.type, max(access.rights) AS rights FROM (((SELECT link_dc_access.dc, link_dc_access.account, link_dc_access.rights, 'user' AS type FROM (link_dc_access JOIN core_user ON ((link_dc_access.account = core_user.id))) UNION SELECT link_dc_access.dc, link_dc_access.account, link_dc_access.rights, 'group' AS type FROM (link_dc_access JOIN core_group ON ((link_dc_access.account = core_group.id)))) UNION SELECT link_dc_access.dc, link_group_members.member AS account, link_dc_access.rights, 'user' AS type FROM ((link_group_members JOIN core_group ON ((link_group_members."group" = core_group.id))) JOIN link_dc_access ON ((link_dc_access.account = core_group.id))) WHERE ((link_group_members.status)::text = 'accepted'::text)) UNION SELECT oig.dc, view_dcs_access.account, view_dcs_access.propagate, view_dcs_access.type FROM (view_dcs_access JOIN (SELECT DISTINCT view_dcs_dc.dcs, view_dcs_dc.dc FROM ((view_dcs_dc JOIN link_dcs_access ON (((link_dcs_access.dcs = view_dcs_dc.dcs) AND (link_dcs_access.propagate IS NOT NULL)))) JOIN link_group_members ON (((link_group_members.member = view_dcs_dc.owner) AND (link_group_members."group" = link_dcs_access.account)))) WHERE ((link_group_members.status)::text = 'accepted'::text)) oig ON ((oig.dcs = view_dcs_access.dcs)))) access GROUP BY access.dc, access.account, access.type;


--
-- TOC entry 1827 (class 1259 OID 359451)
-- Dependencies: 1934 342 6
-- Name: view_dc_name; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_dc_name AS
    SELECT core_data_category.id, generic_name.name, generic_name.status, generic_name.source, core_language.name AS language, core_language.tag FROM (((core_data_category JOIN core_language_section ON ((core_language_section.dc = core_data_category.id))) JOIN core_language ON ((core_language.id = core_language_section.language))) JOIN generic_name ON ((generic_name.owner = core_language_section.id))) WHERE (generic_name.owner_type = 'language section'::owner_type_enum) ORDER BY generic_name.id;


--
-- TOC entry 1828 (class 1259 OID 359456)
-- Dependencies: 1935 6
-- Name: view_dc_profiles; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_dc_profiles AS
    SELECT link_profile_members.dc AS id, concat(DISTINCT ((link_profile_members.profile)::character varying)::text) AS profiles FROM link_profile_members GROUP BY link_profile_members.dc;


--
-- TOC entry 1829 (class 1259 OID 359460)
-- Dependencies: 1936 330 6 348 328
-- Name: view_dcs; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_dcs AS
    SELECT dcs.dcs, dcs.dc, core_data_category.pid, core_data_category.name, view_owner.id AS owner_id, view_owner.name AS owner, core_data_category.identifier, core_data_category.version, core_data_category.branch, core_data_category.revision, core_data_category.sidebranches, core_data_category.administration_status, core_data_category.registration_status, core_data_category.justification, core_data_category.origin, core_data_category.effective_date, core_data_category.until_date, core_data_category.previous, core_data_category.next, core_data_category.private, view_dc_type.type, core_data_category."check", link_simple_data_category_super.super FROM (((((SELECT core_selected_data_category.dcs, COALESCE(core_selected_complex_data_category.dc, core_selected_simple_data_category.dc, core_selected_container_data_category.dc, NULL::integer) AS dc FROM (((core_selected_data_category LEFT JOIN core_selected_container_data_category ON ((core_selected_container_data_category.id = core_selected_data_category.id))) LEFT JOIN core_selected_complex_data_category ON ((core_selected_complex_data_category.id = core_selected_data_category.id))) LEFT JOIN core_selected_simple_data_category ON ((core_selected_simple_data_category.id = core_selected_data_category.id)))) dcs JOIN core_data_category ON ((core_data_category.id = dcs.dc))) JOIN view_owner ON ((view_owner.id = core_data_category.owner))) JOIN view_dc_type ON ((view_dc_type.id = core_data_category.id))) LEFT JOIN link_simple_data_category_super ON ((link_simple_data_category_super.dc = core_data_category.id)));


--
-- TOC entry 1839 (class 1259 OID 360971)
-- Dependencies: 1944 326 6 326
-- Name: view_link_dcs_access; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_link_dcs_access AS
    SELECT link_dcs_access.dcs, link_dcs_access.account, link_dcs_access.rights, link_dcs_access.propagate, core_data_category_selection.name FROM (link_dcs_access JOIN core_data_category_selection ON ((link_dcs_access.dcs = core_data_category_selection.id)));


--
-- TOC entry 1830 (class 1259 OID 359469)
-- Dependencies: 1937 340 338 6
-- Name: view_message; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_message AS
    SELECT core_message.id, core_message."from", core_message."to", core_message.subject, core_message.message, core_message.created, core_message.read, core_message.type, core_message.status FROM core_message;


--
-- TOC entry 1831 (class 1259 OID 359473)
-- Dependencies: 1938 342 344 6 346
-- Name: view_name; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_name AS
    SELECT generic_name.id, generic_name.owner, generic_name.name_type, generic_name.source, generic_name.status, generic_name.name, generic_name.owner_type FROM generic_name;


--
-- TOC entry 1832 (class 1259 OID 359477)
-- Dependencies: 1939 348 6 328 330
-- Name: view_profile; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_profile AS
    SELECT link_profile_members.profile, link_profile_members.dc, core_data_category.pid, core_data_category.name, view_owner.id AS owner_id, view_owner.name AS owner, core_data_category.identifier, core_data_category.version, core_data_category.administration_status, core_data_category.registration_status, core_data_category.justification, core_data_category.origin, core_data_category.effective_date, core_data_category.until_date, core_data_category.previous, core_data_category.private, view_dc_type.type, core_data_category."check", link_simple_data_category_super.super FROM ((((link_profile_members JOIN core_data_category ON ((core_data_category.id = link_profile_members.dc))) JOIN view_owner ON ((view_owner.id = core_data_category.owner))) JOIN view_dc_type ON ((view_dc_type.id = core_data_category.id))) LEFT JOIN link_simple_data_category_super ON ((link_simple_data_category_super.dc = core_data_category.id)));


--
-- TOC entry 1833 (class 1259 OID 359482)
-- Dependencies: 1940 6 350 346
-- Name: view_text; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_text AS
    SELECT generic_text.id, generic_text.owner, generic_text.owner_type, generic_text.language, generic_text.date, generic_text."timestamp", generic_text.source, generic_text.text, generic_text.text_type, generic_text."user" FROM generic_text;


--
-- TOC entry 1834 (class 1259 OID 359486)
-- Dependencies: 1941 352 6
-- Name: view_user; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_user AS
    SELECT core_user.id, core_user.login, core_user.last_name, core_user.email, core_user.organization, core_user.phone, core_user.post, core_user.access_count, core_user.first_access, core_user.last_access, core_user.password, core_user.type, core_user.first_name, core_user.disclaimer, core_user.sync, core_user.forum, core_user.shib_principal, user_name(core_user.id) AS name FROM core_user;


--
-- TOC entry 2136 (class 2604 OID 359490)
-- Dependencies: 1741 1740
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_account ALTER COLUMN id SET DEFAULT nextval('core_account_id_seq'::regclass);


--
-- TOC entry 2138 (class 2604 OID 359491)
-- Dependencies: 1744 1743
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_change_request ALTER COLUMN id SET DEFAULT nextval('core_change_request_id_seq'::regclass);


--
-- TOC entry 2140 (class 2604 OID 359492)
-- Dependencies: 1746 1745
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_change_request_vote ALTER COLUMN id SET DEFAULT nextval('core_change_request_vote_id_seq'::regclass);


--
-- TOC entry 2142 (class 2604 OID 359493)
-- Dependencies: 1751 1750
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_conceptual_domain ALTER COLUMN id SET DEFAULT nextval('core_conceptual_domain_id_seq'::regclass);


--
-- TOC entry 2151 (class 2604 OID 359494)
-- Dependencies: 1757 1756
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_data_category ALTER COLUMN id SET DEFAULT nextval('core_data_category_id_seq'::regclass);


--
-- TOC entry 2153 (class 2604 OID 359495)
-- Dependencies: 1759 1758
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_data_category_selection ALTER COLUMN id SET DEFAULT nextval('core_data_category_selection_id_seq'::regclass);


--
-- TOC entry 2154 (class 2604 OID 359496)
-- Dependencies: 1761 1760
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_data_type ALTER COLUMN id SET DEFAULT nextval('core_data_type_id_seq'::regclass);


--
-- TOC entry 2156 (class 2604 OID 359497)
-- Dependencies: 1795 1762
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_dc_status_log ALTER COLUMN id SET DEFAULT nextval('core_status_log_id_seq'::regclass);


--
-- TOC entry 2161 (class 2604 OID 359498)
-- Dependencies: 1767 1766
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_language ALTER COLUMN id SET DEFAULT nextval('core_language_id_seq'::regclass);


--
-- TOC entry 2163 (class 2604 OID 359499)
-- Dependencies: 1769 1768
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_language_section ALTER COLUMN id SET DEFAULT nextval('core_language_section_id_seq'::regclass);


--
-- TOC entry 2165 (class 2604 OID 359500)
-- Dependencies: 1771 1770
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_linguistic_section ALTER COLUMN id SET DEFAULT nextval('core_linguistic_section_id_seq'::regclass);


--
-- TOC entry 2170 (class 2604 OID 359501)
-- Dependencies: 1773 1772
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_message ALTER COLUMN id SET DEFAULT nextval('core_message_id_seq'::regclass);


--
-- TOC entry 2171 (class 2604 OID 359502)
-- Dependencies: 1778 1777
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_profile ALTER COLUMN id SET DEFAULT nextval('core_profile_id_seq'::regclass);


--
-- TOC entry 2172 (class 2604 OID 359503)
-- Dependencies: 1781 1780
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_registration_authority ALTER COLUMN id SET DEFAULT nextval('core_registration_authority_id_seq'::regclass);


--
-- TOC entry 2174 (class 2604 OID 359504)
-- Dependencies: 1784 1783
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_rule ALTER COLUMN id SET DEFAULT nextval('core_rule_id_seq'::regclass);


--
-- TOC entry 2175 (class 2604 OID 359505)
-- Dependencies: 1786 1785
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_rule_type ALTER COLUMN id SET DEFAULT nextval('core_rule_type_id_seq'::regclass);


--
-- TOC entry 2176 (class 2604 OID 359506)
-- Dependencies: 1790 1789
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_selected_data_category ALTER COLUMN id SET DEFAULT nextval('core_selected_data_category_id_seq'::regclass);


--
-- TOC entry 2178 (class 2604 OID 359507)
-- Dependencies: 1793 1792
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE core_session ALTER COLUMN id SET DEFAULT nextval('core_session_id_seq'::regclass);


--
-- TOC entry 2184 (class 2604 OID 359508)
-- Dependencies: 1801 1800
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE generic_lock ALTER COLUMN id SET DEFAULT nextval('generic_lock_id_seq'::regclass);


--
-- TOC entry 2186 (class 2604 OID 359509)
-- Dependencies: 1803 1802
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE generic_name ALTER COLUMN id SET DEFAULT nextval('generic_name_id_seq'::regclass);


--
-- TOC entry 2191 (class 2604 OID 359510)
-- Dependencies: 1805 1804
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE generic_text ALTER COLUMN id SET DEFAULT nextval('generic_text_id_seq'::regclass);