Migrate Alfresco 5.0 to 5.2 + MySQL to PostgreSQL ($59) · Snippets

Vagrantfile:

# -*- mode: ruby -*-
# vi: set ft=ruby :

Vagrant.configure("2") do |config|
  # Every Vagrant development environment requires a box. You can search for
  # boxes at https://vagrantcloud.com/search.
  config.vm.box = "centos/7"

  # Create a public network, which generally matched to bridged network.
  # Bridged networks make the machine appear as another physical device on
  # your network.
  config.vm.network "public_network"

  # Provider-specific configuration so you can fine-tune various
  # backing providers for Vagrant. These expose provider-specific options.
  # Example for VirtualBox:
  config.vm.provider "virtualbox" do |vb|
    # Customize the amount of memory on the VM:
    vb.memory = "16384"
    vb.cpus = 8
  end
end

mysql-user.sql:

DROP USER ''@'localhost';
DROP USER ''@'localhost.localdomain';
CREATE USER 'alfresco'@'%' IDENTIFIED BY 'alfresco';
GRANT ALL ON alfresco.* TO 'alfresco'@'%' IDENTIFIED BY 'alfresco' WITH GRANT OPTION;
FLUSH PRIVILEGES;
SELECT user, host FROM mysql.user;
SHOW GRANTS FOR 'alfresco'@'%';

mysql-autoincrement.sql:

use information_schema
SELECT TABLE_NAME,AUTO_INCREMENT
  FROM TABLES
  WHERE TABLE_SCHEMA='alfresco'
    AND TABLE_NAME NOT LIKE 'jbpm_%';

pg_schema_table.sql (Clean Alfresco 5.2, PostgreSQL)

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: act_evt_log; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_evt_log (
    log_nr_ integer NOT NULL,
    type_ character varying(64),
    proc_def_id_ character varying(64),
    proc_inst_id_ character varying(64),
    execution_id_ character varying(64),
    task_id_ character varying(64),
    time_stamp_ timestamp without time zone NOT NULL,
    user_id_ character varying(255),
    data_ bytea,
    lock_owner_ character varying(255),
    lock_time_ timestamp without time zone,
    is_processed_ smallint DEFAULT 0
);


ALTER TABLE act_evt_log OWNER TO alfresco;

--
-- Name: act_evt_log_log_nr__seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE act_evt_log_log_nr__seq OWNER TO alfresco;

--
-- Name: act_evt_log_log_nr__seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: alfresco
--

ALTER SEQUENCE act_evt_log_log_nr__seq OWNED BY act_evt_log.log_nr_;


--
-- Name: act_ge_bytearray; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_ge_bytearray (
    id_ character varying(64) NOT NULL,
    rev_ integer,
    name_ character varying(255),
    deployment_id_ character varying(64),
    bytes_ bytea,
    generated_ boolean
);


ALTER TABLE act_ge_bytearray OWNER TO alfresco;

--
-- Name: act_ge_property; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_ge_property (
    name_ character varying(64) NOT NULL,
    value_ character varying(300),
    rev_ integer
);


ALTER TABLE act_ge_property OWNER TO alfresco;

--
-- Name: act_hi_actinst; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_hi_actinst (
    id_ character varying(64) NOT NULL,
    proc_def_id_ character varying(64) NOT NULL,
    proc_inst_id_ character varying(64) NOT NULL,
    execution_id_ character varying(64) NOT NULL,
    act_id_ character varying(255) NOT NULL,
    task_id_ character varying(64),
    call_proc_inst_id_ character varying(64),
    act_name_ character varying(255),
    act_type_ character varying(255) NOT NULL,
    assignee_ character varying(255),
    start_time_ timestamp without time zone NOT NULL,
    end_time_ timestamp without time zone,
    duration_ bigint,
    tenant_id_ character varying(255) DEFAULT ''::character varying
);


ALTER TABLE act_hi_actinst OWNER TO alfresco;

--
-- Name: act_hi_attachment; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_hi_attachment (
    id_ character varying(64) NOT NULL,
    rev_ integer,
    user_id_ character varying(255),
    name_ character varying(255),
    description_ character varying(4000),
    type_ character varying(255),
    task_id_ character varying(64),
    proc_inst_id_ character varying(64),
    url_ character varying(4000),
    content_id_ character varying(64),
    time_ timestamp without time zone
);


ALTER TABLE act_hi_attachment OWNER TO alfresco;

--
-- Name: act_hi_comment; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_hi_comment (
    id_ character varying(64) NOT NULL,
    type_ character varying(255),
    time_ timestamp without time zone NOT NULL,
    user_id_ character varying(255),
    task_id_ character varying(64),
    proc_inst_id_ character varying(64),
    action_ character varying(255),
    message_ character varying(4000),
    full_msg_ bytea
);


ALTER TABLE act_hi_comment OWNER TO alfresco;

--
-- Name: act_hi_detail; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_hi_detail (
    id_ character varying(64) NOT NULL,
    type_ character varying(255) NOT NULL,
    proc_inst_id_ character varying(64),
    execution_id_ character varying(64),
    task_id_ character varying(64),
    act_inst_id_ character varying(64),
    name_ character varying(255) NOT NULL,
    var_type_ character varying(64),
    rev_ integer,
    time_ timestamp without time zone NOT NULL,
    bytearray_id_ character varying(64),
    double_ double precision,
    long_ bigint,
    text_ character varying(4000),
    text2_ character varying(4000)
);


ALTER TABLE act_hi_detail OWNER TO alfresco;

--
-- Name: act_hi_identitylink; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_hi_identitylink (
    id_ character varying(64) NOT NULL,
    group_id_ character varying(255),
    type_ character varying(255),
    user_id_ character varying(255),
    task_id_ character varying(64),
    proc_inst_id_ character varying(64)
);


ALTER TABLE act_hi_identitylink OWNER TO alfresco;

--
-- Name: act_hi_procinst; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_hi_procinst (
    id_ character varying(64) NOT NULL,
    proc_inst_id_ character varying(64) NOT NULL,
    business_key_ character varying(255),
    proc_def_id_ character varying(64) NOT NULL,
    start_time_ timestamp without time zone NOT NULL,
    end_time_ timestamp without time zone,
    duration_ bigint,
    start_user_id_ character varying(255),
    start_act_id_ character varying(255),
    end_act_id_ character varying(255),
    super_process_instance_id_ character varying(64),
    delete_reason_ character varying(4000),
    tenant_id_ character varying(255) DEFAULT ''::character varying,
    name_ character varying(255)
);


ALTER TABLE act_hi_procinst OWNER TO alfresco;

--
-- Name: act_hi_taskinst; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_hi_taskinst (
    id_ character varying(64) NOT NULL,
    proc_def_id_ character varying(64),
    task_def_key_ character varying(255),
    proc_inst_id_ character varying(64),
    execution_id_ character varying(64),
    name_ character varying(255),
    parent_task_id_ character varying(64),
    description_ character varying(4000),
    owner_ character varying(255),
    assignee_ character varying(255),
    start_time_ timestamp without time zone NOT NULL,
    claim_time_ timestamp without time zone,
    end_time_ timestamp without time zone,
    duration_ bigint,
    delete_reason_ character varying(4000),
    priority_ integer,
    due_date_ timestamp without time zone,
    form_key_ character varying(255),
    category_ character varying(255),
    tenant_id_ character varying(255) DEFAULT ''::character varying
);


ALTER TABLE act_hi_taskinst OWNER TO alfresco;

--
-- Name: act_hi_varinst; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_hi_varinst (
    id_ character varying(64) NOT NULL,
    proc_inst_id_ character varying(64),
    execution_id_ character varying(64),
    task_id_ character varying(64),
    name_ character varying(255) NOT NULL,
    var_type_ character varying(100),
    rev_ integer,
    bytearray_id_ character varying(64),
    double_ double precision,
    long_ bigint,
    text_ character varying(4000),
    text2_ character varying(4000),
    create_time_ timestamp without time zone,
    last_updated_time_ timestamp without time zone
);


ALTER TABLE act_hi_varinst OWNER TO alfresco;

--
-- Name: act_id_group; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_id_group (
    id_ character varying(64) NOT NULL,
    rev_ integer,
    name_ character varying(255),
    type_ character varying(255)
);


ALTER TABLE act_id_group OWNER TO alfresco;

--
-- Name: act_id_info; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_id_info (
    id_ character varying(64) NOT NULL,
    rev_ integer,
    user_id_ character varying(64),
    type_ character varying(64),
    key_ character varying(255),
    value_ character varying(255),
    password_ bytea,
    parent_id_ character varying(255)
);


ALTER TABLE act_id_info OWNER TO alfresco;

--
-- Name: act_id_membership; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_id_membership (
    user_id_ character varying(64) NOT NULL,
    group_id_ character varying(64) NOT NULL
);


ALTER TABLE act_id_membership OWNER TO alfresco;

--
-- Name: act_id_user; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_id_user (
    id_ character varying(64) NOT NULL,
    rev_ integer,
    first_ character varying(255),
    last_ character varying(255),
    email_ character varying(255),
    pwd_ character varying(255),
    picture_id_ character varying(64)
);


ALTER TABLE act_id_user OWNER TO alfresco;

--
-- Name: act_procdef_info; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_procdef_info (
    id_ character varying(64) NOT NULL,
    proc_def_id_ character varying(64) NOT NULL,
    rev_ integer,
    info_json_id_ character varying(64)
);


ALTER TABLE act_procdef_info OWNER TO alfresco;

--
-- Name: act_re_deployment; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_re_deployment (
    id_ character varying(64) NOT NULL,
    name_ character varying(255),
    category_ character varying(255),
    tenant_id_ character varying(255) DEFAULT ''::character varying,
    deploy_time_ timestamp without time zone
);


ALTER TABLE act_re_deployment OWNER TO alfresco;

--
-- Name: act_re_model; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_re_model (
    id_ character varying(64) NOT NULL,
    rev_ integer,
    name_ character varying(255),
    key_ character varying(255),
    category_ character varying(255),
    create_time_ timestamp without time zone,
    last_update_time_ timestamp without time zone,
    version_ integer,
    meta_info_ character varying(4000),
    deployment_id_ character varying(64),
    editor_source_value_id_ character varying(64),
    editor_source_extra_value_id_ character varying(64),
    tenant_id_ character varying(255) DEFAULT ''::character varying
);


ALTER TABLE act_re_model OWNER TO alfresco;

--
-- Name: act_re_procdef; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_re_procdef (
    id_ character varying(64) NOT NULL,
    rev_ integer,
    category_ character varying(255),
    name_ character varying(255),
    key_ character varying(255) NOT NULL,
    version_ integer NOT NULL,
    deployment_id_ character varying(64),
    resource_name_ character varying(4000),
    dgrm_resource_name_ character varying(4000),
    description_ character varying(4000),
    has_start_form_key_ boolean,
    has_graphical_notation_ boolean,
    suspension_state_ integer,
    tenant_id_ character varying(255) DEFAULT ''::character varying
);


ALTER TABLE act_re_procdef OWNER TO alfresco;

--
-- Name: act_ru_event_subscr; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_ru_event_subscr (
    id_ character varying(64) NOT NULL,
    rev_ integer,
    event_type_ character varying(255) NOT NULL,
    event_name_ character varying(255),
    execution_id_ character varying(64),
    proc_inst_id_ character varying(64),
    activity_id_ character varying(64),
    configuration_ character varying(255),
    created_ timestamp without time zone NOT NULL,
    proc_def_id_ character varying(64),
    tenant_id_ character varying(255) DEFAULT ''::character varying
);


ALTER TABLE act_ru_event_subscr OWNER TO alfresco;

--
-- Name: act_ru_execution; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_ru_execution (
    id_ character varying(64) NOT NULL,
    rev_ integer,
    proc_inst_id_ character varying(64),
    business_key_ character varying(255),
    parent_id_ character varying(64),
    proc_def_id_ character varying(64),
    super_exec_ character varying(64),
    act_id_ character varying(255),
    is_active_ boolean,
    is_concurrent_ boolean,
    is_scope_ boolean,
    is_event_scope_ boolean,
    suspension_state_ integer,
    cached_ent_state_ integer,
    tenant_id_ character varying(255) DEFAULT ''::character varying,
    name_ character varying(255),
    lock_time_ timestamp without time zone
);


ALTER TABLE act_ru_execution OWNER TO alfresco;

--
-- Name: act_ru_identitylink; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_ru_identitylink (
    id_ character varying(64) NOT NULL,
    rev_ integer,
    group_id_ character varying(255),
    type_ character varying(255),
    user_id_ character varying(255),
    task_id_ character varying(64),
    proc_inst_id_ character varying(64),
    proc_def_id_ character varying(64)
);


ALTER TABLE act_ru_identitylink OWNER TO alfresco;

--
-- Name: act_ru_job; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_ru_job (
    id_ character varying(64) NOT NULL,
    rev_ integer,
    type_ character varying(255) NOT NULL,
    lock_exp_time_ timestamp without time zone,
    lock_owner_ character varying(255),
    exclusive_ boolean,
    execution_id_ character varying(64),
    process_instance_id_ character varying(64),
    proc_def_id_ character varying(64),
    retries_ integer,
    exception_stack_id_ character varying(64),
    exception_msg_ character varying(4000),
    duedate_ timestamp without time zone,
    repeat_ character varying(255),
    handler_type_ character varying(255),
    handler_cfg_ character varying(4000),
    tenant_id_ character varying(255) DEFAULT ''::character varying
);


ALTER TABLE act_ru_job OWNER TO alfresco;

--
-- Name: act_ru_task; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_ru_task (
    id_ character varying(64) NOT NULL,
    rev_ integer,
    execution_id_ character varying(64),
    proc_inst_id_ character varying(64),
    proc_def_id_ character varying(64),
    name_ character varying(255),
    parent_task_id_ character varying(64),
    description_ character varying(4000),
    task_def_key_ character varying(255),
    owner_ character varying(255),
    assignee_ character varying(255),
    delegation_ character varying(64),
    priority_ integer,
    create_time_ timestamp without time zone,
    due_date_ timestamp without time zone,
    category_ character varying(255),
    suspension_state_ integer,
    tenant_id_ character varying(255) DEFAULT ''::character varying,
    form_key_ character varying(255)
);


ALTER TABLE act_ru_task OWNER TO alfresco;

--
-- Name: act_ru_variable; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE act_ru_variable (
    id_ character varying(64) NOT NULL,
    rev_ integer,
    type_ character varying(255) NOT NULL,
    name_ character varying(255) NOT NULL,
    execution_id_ character varying(64),
    proc_inst_id_ character varying(64),
    task_id_ character varying(64),
    bytearray_id_ character varying(64),
    double_ double precision,
    long_ bigint,
    text_ character varying(4000),
    text2_ character varying(4000)
);


ALTER TABLE act_ru_variable OWNER TO alfresco;

--
-- Name: alf_access_control_entry; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_access_control_entry (
    id bigint NOT NULL,
    version bigint NOT NULL,
    permission_id bigint NOT NULL,
    authority_id bigint NOT NULL,
    allowed boolean NOT NULL,
    applies integer NOT NULL,
    context_id bigint
);


ALTER TABLE alf_access_control_entry OWNER TO alfresco;

--
-- Name: alf_access_control_entry_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_access_control_entry_seq OWNER TO alfresco;

--
-- Name: alf_access_control_list; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_access_control_list (
    id bigint NOT NULL,
    version bigint NOT NULL,
    acl_id character varying(36) NOT NULL,
    latest boolean NOT NULL,
    acl_version bigint NOT NULL,
    inherits boolean NOT NULL,
    inherits_from bigint,
    type integer NOT NULL,
    inherited_acl bigint,
    is_versioned boolean NOT NULL,
    requires_version boolean NOT NULL,
    acl_change_set bigint
);


ALTER TABLE alf_access_control_list OWNER TO alfresco;

--
-- Name: alf_access_control_list_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_access_control_list_seq OWNER TO alfresco;

--
-- Name: alf_ace_context; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_ace_context (
    id bigint NOT NULL,
    version bigint NOT NULL,
    class_context character varying(1024),
    property_context character varying(1024),
    kvp_context character varying(1024)
);


ALTER TABLE alf_ace_context OWNER TO alfresco;

--
-- Name: alf_ace_context_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_ace_context_seq OWNER TO alfresco;

--
-- Name: alf_acl_change_set; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_acl_change_set (
    id bigint NOT NULL,
    commit_time_ms bigint
);


ALTER TABLE alf_acl_change_set OWNER TO alfresco;

--
-- Name: alf_acl_change_set_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_acl_change_set_seq OWNER TO alfresco;

--
-- Name: alf_acl_member; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_acl_member (
    id bigint NOT NULL,
    version bigint NOT NULL,
    acl_id bigint NOT NULL,
    ace_id bigint NOT NULL,
    pos integer NOT NULL
);


ALTER TABLE alf_acl_member OWNER TO alfresco;

--
-- Name: alf_acl_member_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_acl_member_seq OWNER TO alfresco;

--
-- Name: alf_activity_feed; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_activity_feed (
    id bigint NOT NULL,
    post_id bigint,
    post_date timestamp without time zone NOT NULL,
    activity_summary character varying(1024),
    feed_user_id character varying(255),
    activity_type character varying(255) NOT NULL,
    site_network character varying(255),
    app_tool character varying(36),
    post_user_id character varying(255) NOT NULL,
    feed_date timestamp without time zone NOT NULL
);


ALTER TABLE alf_activity_feed OWNER TO alfresco;

--
-- Name: alf_activity_feed_control; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_activity_feed_control (
    id bigint NOT NULL,
    feed_user_id character varying(255) NOT NULL,
    site_network character varying(255),
    app_tool character varying(36),
    last_modified timestamp without time zone NOT NULL
);


ALTER TABLE alf_activity_feed_control OWNER TO alfresco;

--
-- Name: alf_activity_feed_control_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_activity_feed_control_seq OWNER TO alfresco;

--
-- Name: alf_activity_feed_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_activity_feed_seq OWNER TO alfresco;

--
-- Name: alf_activity_post; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_activity_post (
    sequence_id bigint NOT NULL,
    post_date timestamp without time zone NOT NULL,
    status character varying(10) NOT NULL,
    activity_data character varying(1024) NOT NULL,
    post_user_id character varying(255) NOT NULL,
    job_task_node integer NOT NULL,
    site_network character varying(255),
    app_tool character varying(36),
    activity_type character varying(255) NOT NULL,
    last_modified timestamp without time zone NOT NULL
);


ALTER TABLE alf_activity_post OWNER TO alfresco;

--
-- Name: alf_activity_post_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_activity_post_seq OWNER TO alfresco;

--
-- Name: alf_applied_patch; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_applied_patch (
    id character varying(64) NOT NULL,
    description character varying(1024),
    fixes_from_schema integer,
    fixes_to_schema integer,
    applied_to_schema integer,
    target_schema integer,
    applied_on_date timestamp without time zone,
    applied_to_server character varying(64),
    was_executed boolean,
    succeeded boolean,
    report character varying(1024)
);


ALTER TABLE alf_applied_patch OWNER TO alfresco;

--
-- Name: alf_audit_app; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_audit_app (
    id bigint NOT NULL,
    version integer NOT NULL,
    app_name_id bigint NOT NULL,
    audit_model_id bigint NOT NULL,
    disabled_paths_id bigint NOT NULL
);


ALTER TABLE alf_audit_app OWNER TO alfresco;

--
-- Name: alf_audit_app_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_audit_app_seq OWNER TO alfresco;

--
-- Name: alf_audit_entry; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_audit_entry (
    id bigint NOT NULL,
    audit_app_id bigint NOT NULL,
    audit_time bigint NOT NULL,
    audit_user_id bigint,
    audit_values_id bigint
);


ALTER TABLE alf_audit_entry OWNER TO alfresco;

--
-- Name: alf_audit_entry_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_audit_entry_seq OWNER TO alfresco;

--
-- Name: alf_audit_model; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_audit_model (
    id bigint NOT NULL,
    content_data_id bigint NOT NULL,
    content_crc bigint NOT NULL
);


ALTER TABLE alf_audit_model OWNER TO alfresco;

--
-- Name: alf_audit_model_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_audit_model_seq OWNER TO alfresco;

--
-- Name: alf_auth_status; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_auth_status (
    id bigint NOT NULL,
    username character varying(100) NOT NULL,
    deleted boolean NOT NULL,
    authorized boolean NOT NULL,
    checksum bytea NOT NULL,
    authaction character varying(10) NOT NULL
);


ALTER TABLE alf_auth_status OWNER TO alfresco;

--
-- Name: alf_auth_status_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_auth_status_seq OWNER TO alfresco;

--
-- Name: alf_authority; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_authority (
    id bigint NOT NULL,
    version bigint NOT NULL,
    authority character varying(100),
    crc bigint
);


ALTER TABLE alf_authority OWNER TO alfresco;

--
-- Name: alf_authority_alias; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_authority_alias (
    id bigint NOT NULL,
    version bigint NOT NULL,
    auth_id bigint NOT NULL,
    alias_id bigint NOT NULL
);


ALTER TABLE alf_authority_alias OWNER TO alfresco;

--
-- Name: alf_authority_alias_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_authority_alias_seq OWNER TO alfresco;

--
-- Name: alf_authority_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_authority_seq OWNER TO alfresco;

--
-- Name: alf_child_assoc; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_child_assoc (
    id bigint NOT NULL,
    version bigint NOT NULL,
    parent_node_id bigint NOT NULL,
    type_qname_id bigint NOT NULL,
    child_node_name_crc bigint NOT NULL,
    child_node_name character varying(50) NOT NULL,
    child_node_id bigint NOT NULL,
    qname_ns_id bigint NOT NULL,
    qname_localname character varying(255) NOT NULL,
    qname_crc bigint NOT NULL,
    is_primary boolean,
    assoc_index integer
);


ALTER TABLE alf_child_assoc OWNER TO alfresco;

--
-- Name: alf_child_assoc_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_child_assoc_seq OWNER TO alfresco;

--
-- Name: alf_content_data; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_content_data (
    id bigint NOT NULL,
    version bigint NOT NULL,
    content_url_id bigint,
    content_mimetype_id bigint,
    content_encoding_id bigint,
    content_locale_id bigint
);


ALTER TABLE alf_content_data OWNER TO alfresco;

--
-- Name: alf_content_data_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_content_data_seq OWNER TO alfresco;

--
-- Name: alf_content_url; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_content_url (
    id bigint NOT NULL,
    content_url character varying(255) NOT NULL,
    content_url_short character varying(12) NOT NULL,
    content_url_crc bigint NOT NULL,
    content_size bigint NOT NULL,
    orphan_time bigint
);


ALTER TABLE alf_content_url OWNER TO alfresco;

--
-- Name: alf_content_url_enc_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_content_url_enc_seq OWNER TO alfresco;

--
-- Name: alf_content_url_encryption; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_content_url_encryption (
    id bigint NOT NULL,
    content_url_id bigint NOT NULL,
    algorithm character varying(10) NOT NULL,
    key_size integer NOT NULL,
    encrypted_key bytea NOT NULL,
    master_keystore_id character varying(20) NOT NULL,
    master_key_alias character varying(15) NOT NULL,
    unencrypted_file_size bigint
);


ALTER TABLE alf_content_url_encryption OWNER TO alfresco;

--
-- Name: alf_content_url_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_content_url_seq OWNER TO alfresco;

--
-- Name: alf_encoding; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_encoding (
    id bigint NOT NULL,
    version bigint NOT NULL,
    encoding_str character varying(100) NOT NULL
);


ALTER TABLE alf_encoding OWNER TO alfresco;

--
-- Name: alf_encoding_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_encoding_seq OWNER TO alfresco;

--
-- Name: alf_locale; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_locale (
    id bigint NOT NULL,
    version bigint NOT NULL,
    locale_str character varying(20) NOT NULL
);


ALTER TABLE alf_locale OWNER TO alfresco;

--
-- Name: alf_locale_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_locale_seq OWNER TO alfresco;

--
-- Name: alf_lock; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_lock (
    id bigint NOT NULL,
    version bigint NOT NULL,
    shared_resource_id bigint NOT NULL,
    excl_resource_id bigint NOT NULL,
    lock_token character varying(36) NOT NULL,
    start_time bigint NOT NULL,
    expiry_time bigint NOT NULL
);


ALTER TABLE alf_lock OWNER TO alfresco;

--
-- Name: alf_lock_resource; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_lock_resource (
    id bigint NOT NULL,
    version bigint NOT NULL,
    qname_ns_id bigint NOT NULL,
    qname_localname character varying(255) NOT NULL
);


ALTER TABLE alf_lock_resource OWNER TO alfresco;

--
-- Name: alf_lock_resource_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_lock_resource_seq OWNER TO alfresco;

--
-- Name: alf_lock_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_lock_seq OWNER TO alfresco;

--
-- Name: alf_mimetype; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_mimetype (
    id bigint NOT NULL,
    version bigint NOT NULL,
    mimetype_str character varying(100) NOT NULL
);


ALTER TABLE alf_mimetype OWNER TO alfresco;

--
-- Name: alf_mimetype_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_mimetype_seq OWNER TO alfresco;

--
-- Name: alf_namespace; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_namespace (
    id bigint NOT NULL,
    version bigint NOT NULL,
    uri character varying(100) NOT NULL
);


ALTER TABLE alf_namespace OWNER TO alfresco;

--
-- Name: alf_namespace_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_namespace_seq OWNER TO alfresco;

--
-- Name: alf_node; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_node (
    id bigint NOT NULL,
    version bigint NOT NULL,
    store_id bigint NOT NULL,
    uuid character varying(36) NOT NULL,
    transaction_id bigint NOT NULL,
    type_qname_id bigint NOT NULL,
    locale_id bigint NOT NULL,
    acl_id bigint,
    audit_creator character varying(255),
    audit_created character varying(30),
    audit_modifier character varying(255),
    audit_modified character varying(30),
    audit_accessed character varying(30)
);


ALTER TABLE alf_node OWNER TO alfresco;

--
-- Name: alf_node_aspects; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_node_aspects (
    node_id bigint NOT NULL,
    qname_id bigint NOT NULL
);


ALTER TABLE alf_node_aspects OWNER TO alfresco;

--
-- Name: alf_node_assoc; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_node_assoc (
    id bigint NOT NULL,
    version bigint NOT NULL,
    source_node_id bigint NOT NULL,
    target_node_id bigint NOT NULL,
    type_qname_id bigint NOT NULL,
    assoc_index bigint NOT NULL
);


ALTER TABLE alf_node_assoc OWNER TO alfresco;

--
-- Name: alf_node_assoc_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_node_assoc_seq OWNER TO alfresco;

--
-- Name: alf_node_properties; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_node_properties (
    node_id bigint NOT NULL,
    actual_type_n integer NOT NULL,
    persisted_type_n integer NOT NULL,
    boolean_value boolean,
    long_value bigint,
    float_value real,
    double_value double precision,
    string_value character varying(1024),
    serializable_value bytea,
    qname_id bigint NOT NULL,
    list_index integer NOT NULL,
    locale_id bigint NOT NULL
);


ALTER TABLE alf_node_properties OWNER TO alfresco;

--
-- Name: alf_node_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_node_seq OWNER TO alfresco;

--
-- Name: alf_permission; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_permission (
    id bigint NOT NULL,
    version bigint NOT NULL,
    type_qname_id bigint NOT NULL,
    name character varying(100) NOT NULL
);


ALTER TABLE alf_permission OWNER TO alfresco;

--
-- Name: alf_permission_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_permission_seq OWNER TO alfresco;

--
-- Name: alf_prop_class; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_prop_class (
    id bigint NOT NULL,
    java_class_name character varying(255) NOT NULL,
    java_class_name_short character varying(32) NOT NULL,
    java_class_name_crc bigint NOT NULL
);


ALTER TABLE alf_prop_class OWNER TO alfresco;

--
-- Name: alf_prop_class_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_prop_class_seq OWNER TO alfresco;

--
-- Name: alf_prop_date_value; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_prop_date_value (
    date_value bigint NOT NULL,
    full_year integer NOT NULL,
    half_of_year smallint NOT NULL,
    quarter_of_year smallint NOT NULL,
    month_of_year smallint NOT NULL,
    week_of_year smallint NOT NULL,
    week_of_month smallint NOT NULL,
    day_of_year integer NOT NULL,
    day_of_month smallint NOT NULL,
    day_of_week smallint NOT NULL
);


ALTER TABLE alf_prop_date_value OWNER TO alfresco;

--
-- Name: alf_prop_double_value; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_prop_double_value (
    id bigint NOT NULL,
    double_value double precision NOT NULL
);


ALTER TABLE alf_prop_double_value OWNER TO alfresco;

--
-- Name: alf_prop_double_value_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_prop_double_value_seq OWNER TO alfresco;

--
-- Name: alf_prop_link; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_prop_link (
    root_prop_id bigint NOT NULL,
    prop_index bigint NOT NULL,
    contained_in bigint NOT NULL,
    key_prop_id bigint NOT NULL,
    value_prop_id bigint NOT NULL
);


ALTER TABLE alf_prop_link OWNER TO alfresco;

--
-- Name: alf_prop_root; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_prop_root (
    id bigint NOT NULL,
    version integer NOT NULL
);


ALTER TABLE alf_prop_root OWNER TO alfresco;

--
-- Name: alf_prop_root_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_prop_root_seq OWNER TO alfresco;

--
-- Name: alf_prop_serializable_value; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_prop_serializable_value (
    id bigint NOT NULL,
    serializable_value bytea NOT NULL
);


ALTER TABLE alf_prop_serializable_value OWNER TO alfresco;

--
-- Name: alf_prop_serializable_value_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_prop_serializable_value_seq OWNER TO alfresco;

--
-- Name: alf_prop_string_value; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_prop_string_value (
    id bigint NOT NULL,
    string_value character varying(1024) NOT NULL,
    string_end_lower character varying(16) NOT NULL,
    string_crc bigint NOT NULL
);


ALTER TABLE alf_prop_string_value OWNER TO alfresco;

--
-- Name: alf_prop_string_value_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_prop_string_value_seq OWNER TO alfresco;

--
-- Name: alf_prop_unique_ctx; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_prop_unique_ctx (
    id bigint NOT NULL,
    version integer NOT NULL,
    value1_prop_id bigint NOT NULL,
    value2_prop_id bigint NOT NULL,
    value3_prop_id bigint NOT NULL,
    prop1_id bigint
);


ALTER TABLE alf_prop_unique_ctx OWNER TO alfresco;

--
-- Name: alf_prop_unique_ctx_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_prop_unique_ctx_seq OWNER TO alfresco;

--
-- Name: alf_prop_value; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_prop_value (
    id bigint NOT NULL,
    actual_type_id bigint NOT NULL,
    persisted_type smallint NOT NULL,
    long_value bigint NOT NULL
);


ALTER TABLE alf_prop_value OWNER TO alfresco;

--
-- Name: alf_prop_value_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_prop_value_seq OWNER TO alfresco;

--
-- Name: alf_qname; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_qname (
    id bigint NOT NULL,
    version bigint NOT NULL,
    ns_id bigint NOT NULL,
    local_name character varying(200) NOT NULL
);


ALTER TABLE alf_qname OWNER TO alfresco;

--
-- Name: alf_qname_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_qname_seq OWNER TO alfresco;

--
-- Name: alf_server; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_server (
    id bigint NOT NULL,
    version bigint NOT NULL,
    ip_address character varying(39) NOT NULL
);


ALTER TABLE alf_server OWNER TO alfresco;

--
-- Name: alf_server_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_server_seq OWNER TO alfresco;

--
-- Name: alf_store; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_store (
    id bigint NOT NULL,
    version bigint NOT NULL,
    protocol character varying(50) NOT NULL,
    identifier character varying(100) NOT NULL,
    root_node_id bigint
);


ALTER TABLE alf_store OWNER TO alfresco;

--
-- Name: alf_store_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_store_seq OWNER TO alfresco;

--
-- Name: alf_subscriptions; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_subscriptions (
    user_node_id bigint NOT NULL,
    node_id bigint NOT NULL
);


ALTER TABLE alf_subscriptions OWNER TO alfresco;

--
-- Name: alf_tenant; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_tenant (
    tenant_domain character varying(75) NOT NULL,
    version bigint NOT NULL,
    enabled boolean NOT NULL,
    tenant_name character varying(75),
    content_root character varying(255),
    db_url character varying(255)
);


ALTER TABLE alf_tenant OWNER TO alfresco;

--
-- Name: alf_transaction; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_transaction (
    id bigint NOT NULL,
    version bigint NOT NULL,
    server_id bigint,
    change_txn_id character varying(56) NOT NULL,
    commit_time_ms bigint
);


ALTER TABLE alf_transaction OWNER TO alfresco;

--
-- Name: alf_transaction_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_transaction_seq OWNER TO alfresco;

--
-- Name: alf_usage_delta; Type: TABLE; Schema: public; Owner: alfresco; Tablespace:
--

CREATE TABLE alf_usage_delta (
    id bigint NOT NULL,
    version bigint NOT NULL,
    node_id bigint NOT NULL,
    delta_size bigint NOT NULL
);


ALTER TABLE alf_usage_delta OWNER TO alfresco;

--
-- Name: alf_usage_delta_seq; Type: SEQUENCE; Schema: public; Owner: alfresco
--

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


ALTER TABLE alf_usage_delta_seq OWNER TO alfresco;

--
-- Name: log_nr_; Type: DEFAULT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_evt_log ALTER COLUMN log_nr_ SET DEFAULT nextval('act_evt_log_log_nr__seq'::regclass);




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

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


--
-- PostgreSQL database dump complete
--

pg_schema_fk-idx.sql (Clean Alfresco 5.2, PostgreSQL)

--
-- Name: act_evt_log_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_evt_log
    ADD CONSTRAINT act_evt_log_pkey PRIMARY KEY (log_nr_);


--
-- Name: act_ge_bytearray_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_ge_bytearray
    ADD CONSTRAINT act_ge_bytearray_pkey PRIMARY KEY (id_);


--
-- Name: act_ge_property_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_ge_property
    ADD CONSTRAINT act_ge_property_pkey PRIMARY KEY (name_);


--
-- Name: act_hi_actinst_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_hi_actinst
    ADD CONSTRAINT act_hi_actinst_pkey PRIMARY KEY (id_);


--
-- Name: act_hi_attachment_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_hi_attachment
    ADD CONSTRAINT act_hi_attachment_pkey PRIMARY KEY (id_);


--
-- Name: act_hi_comment_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_hi_comment
    ADD CONSTRAINT act_hi_comment_pkey PRIMARY KEY (id_);


--
-- Name: act_hi_detail_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_hi_detail
    ADD CONSTRAINT act_hi_detail_pkey PRIMARY KEY (id_);


--
-- Name: act_hi_identitylink_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_hi_identitylink
    ADD CONSTRAINT act_hi_identitylink_pkey PRIMARY KEY (id_);


--
-- Name: act_hi_procinst_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_hi_procinst
    ADD CONSTRAINT act_hi_procinst_pkey PRIMARY KEY (id_);


--
-- Name: act_hi_procinst_proc_inst_id__key; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_hi_procinst
    ADD CONSTRAINT act_hi_procinst_proc_inst_id__key UNIQUE (proc_inst_id_);


--
-- Name: act_hi_taskinst_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_hi_taskinst
    ADD CONSTRAINT act_hi_taskinst_pkey PRIMARY KEY (id_);


--
-- Name: act_hi_varinst_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_hi_varinst
    ADD CONSTRAINT act_hi_varinst_pkey PRIMARY KEY (id_);


--
-- Name: act_id_group_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_id_group
    ADD CONSTRAINT act_id_group_pkey PRIMARY KEY (id_);


--
-- Name: act_id_info_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_id_info
    ADD CONSTRAINT act_id_info_pkey PRIMARY KEY (id_);


--
-- Name: act_id_membership_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_id_membership
    ADD CONSTRAINT act_id_membership_pkey PRIMARY KEY (user_id_, group_id_);


--
-- Name: act_id_user_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_id_user
    ADD CONSTRAINT act_id_user_pkey PRIMARY KEY (id_);


--
-- Name: act_procdef_info_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_procdef_info
    ADD CONSTRAINT act_procdef_info_pkey PRIMARY KEY (id_);


--
-- Name: act_re_deployment_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_re_deployment
    ADD CONSTRAINT act_re_deployment_pkey PRIMARY KEY (id_);


--
-- Name: act_re_model_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_re_model
    ADD CONSTRAINT act_re_model_pkey PRIMARY KEY (id_);


--
-- Name: act_re_procdef_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_re_procdef
    ADD CONSTRAINT act_re_procdef_pkey PRIMARY KEY (id_);


--
-- Name: act_ru_event_subscr_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_ru_event_subscr
    ADD CONSTRAINT act_ru_event_subscr_pkey PRIMARY KEY (id_);


--
-- Name: act_ru_execution_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_ru_execution
    ADD CONSTRAINT act_ru_execution_pkey PRIMARY KEY (id_);


--
-- Name: act_ru_identitylink_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_ru_identitylink
    ADD CONSTRAINT act_ru_identitylink_pkey PRIMARY KEY (id_);


--
-- Name: act_ru_job_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_ru_job
    ADD CONSTRAINT act_ru_job_pkey PRIMARY KEY (id_);


--
-- Name: act_ru_task_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_ru_task
    ADD CONSTRAINT act_ru_task_pkey PRIMARY KEY (id_);


--
-- Name: act_ru_variable_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_ru_variable
    ADD CONSTRAINT act_ru_variable_pkey PRIMARY KEY (id_);


--
-- Name: act_uniq_info_procdef; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_procdef_info
    ADD CONSTRAINT act_uniq_info_procdef UNIQUE (proc_def_id_);


--
-- Name: act_uniq_procdef; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY act_re_procdef
    ADD CONSTRAINT act_uniq_procdef UNIQUE (key_, version_, tenant_id_);


--
-- Name: alf_access_control_entry_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_access_control_entry
    ADD CONSTRAINT alf_access_control_entry_pkey PRIMARY KEY (id);


--
-- Name: alf_access_control_list_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_access_control_list
    ADD CONSTRAINT alf_access_control_list_pkey PRIMARY KEY (id);


--
-- Name: alf_ace_context_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_ace_context
    ADD CONSTRAINT alf_ace_context_pkey PRIMARY KEY (id);


--
-- Name: alf_acl_change_set_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_acl_change_set
    ADD CONSTRAINT alf_acl_change_set_pkey PRIMARY KEY (id);


--
-- Name: alf_acl_member_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_acl_member
    ADD CONSTRAINT alf_acl_member_pkey PRIMARY KEY (id);


--
-- Name: alf_activity_feed_control_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_activity_feed_control
    ADD CONSTRAINT alf_activity_feed_control_pkey PRIMARY KEY (id);


--
-- Name: alf_activity_feed_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_activity_feed
    ADD CONSTRAINT alf_activity_feed_pkey PRIMARY KEY (id);


--
-- Name: alf_activity_post_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_activity_post
    ADD CONSTRAINT alf_activity_post_pkey PRIMARY KEY (sequence_id);


--
-- Name: alf_applied_patch_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_applied_patch
    ADD CONSTRAINT alf_applied_patch_pkey PRIMARY KEY (id);


--
-- Name: alf_audit_app_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_audit_app
    ADD CONSTRAINT alf_audit_app_pkey PRIMARY KEY (id);


--
-- Name: alf_audit_entry_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_audit_entry
    ADD CONSTRAINT alf_audit_entry_pkey PRIMARY KEY (id);


--
-- Name: alf_audit_model_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_audit_model
    ADD CONSTRAINT alf_audit_model_pkey PRIMARY KEY (id);


--
-- Name: alf_auth_status_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_auth_status
    ADD CONSTRAINT alf_auth_status_pkey PRIMARY KEY (id);


--
-- Name: alf_authority_alias_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_authority_alias
    ADD CONSTRAINT alf_authority_alias_pkey PRIMARY KEY (id);


--
-- Name: alf_authority_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_authority
    ADD CONSTRAINT alf_authority_pkey PRIMARY KEY (id);


--
-- Name: alf_child_assoc_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_child_assoc
    ADD CONSTRAINT alf_child_assoc_pkey PRIMARY KEY (id);


--
-- Name: alf_content_data_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_content_data
    ADD CONSTRAINT alf_content_data_pkey PRIMARY KEY (id);


--
-- Name: alf_content_url_encryption_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_content_url_encryption
    ADD CONSTRAINT alf_content_url_encryption_pkey PRIMARY KEY (id);


--
-- Name: alf_content_url_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_content_url
    ADD CONSTRAINT alf_content_url_pkey PRIMARY KEY (id);


--
-- Name: alf_encoding_encoding_str_key; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_encoding
    ADD CONSTRAINT alf_encoding_encoding_str_key UNIQUE (encoding_str);


--
-- Name: alf_encoding_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_encoding
    ADD CONSTRAINT alf_encoding_pkey PRIMARY KEY (id);


--
-- Name: alf_locale_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_locale
    ADD CONSTRAINT alf_locale_pkey PRIMARY KEY (id);


--
-- Name: alf_lock_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_lock
    ADD CONSTRAINT alf_lock_pkey PRIMARY KEY (id);


--
-- Name: alf_lock_resource_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_lock_resource
    ADD CONSTRAINT alf_lock_resource_pkey PRIMARY KEY (id);


--
-- Name: alf_mimetype_mimetype_str_key; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_mimetype
    ADD CONSTRAINT alf_mimetype_mimetype_str_key UNIQUE (mimetype_str);


--
-- Name: alf_mimetype_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_mimetype
    ADD CONSTRAINT alf_mimetype_pkey PRIMARY KEY (id);


--
-- Name: alf_namespace_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_namespace
    ADD CONSTRAINT alf_namespace_pkey PRIMARY KEY (id);


--
-- Name: alf_node_aspects_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_node_aspects
    ADD CONSTRAINT alf_node_aspects_pkey PRIMARY KEY (node_id, qname_id);


--
-- Name: alf_node_assoc_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_node_assoc
    ADD CONSTRAINT alf_node_assoc_pkey PRIMARY KEY (id);


--
-- Name: alf_node_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_node
    ADD CONSTRAINT alf_node_pkey PRIMARY KEY (id);


--
-- Name: alf_node_properties_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_node_properties
    ADD CONSTRAINT alf_node_properties_pkey PRIMARY KEY (node_id, qname_id, list_index, locale_id);


--
-- Name: alf_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_permission
    ADD CONSTRAINT alf_permission_pkey PRIMARY KEY (id);


--
-- Name: alf_prop_class_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_prop_class
    ADD CONSTRAINT alf_prop_class_pkey PRIMARY KEY (id);


--
-- Name: alf_prop_date_value_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_prop_date_value
    ADD CONSTRAINT alf_prop_date_value_pkey PRIMARY KEY (date_value);


--
-- Name: alf_prop_double_value_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_prop_double_value
    ADD CONSTRAINT alf_prop_double_value_pkey PRIMARY KEY (id);


--
-- Name: alf_prop_link_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_prop_link
    ADD CONSTRAINT alf_prop_link_pkey PRIMARY KEY (root_prop_id, contained_in, prop_index);


--
-- Name: alf_prop_root_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_prop_root
    ADD CONSTRAINT alf_prop_root_pkey PRIMARY KEY (id);


--
-- Name: alf_prop_serializable_value_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_prop_serializable_value
    ADD CONSTRAINT alf_prop_serializable_value_pkey PRIMARY KEY (id);


--
-- Name: alf_prop_string_value_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_prop_string_value
    ADD CONSTRAINT alf_prop_string_value_pkey PRIMARY KEY (id);


--
-- Name: alf_prop_unique_ctx_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_prop_unique_ctx
    ADD CONSTRAINT alf_prop_unique_ctx_pkey PRIMARY KEY (id);


--
-- Name: alf_prop_value_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_prop_value
    ADD CONSTRAINT alf_prop_value_pkey PRIMARY KEY (id);


--
-- Name: alf_qname_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_qname
    ADD CONSTRAINT alf_qname_pkey PRIMARY KEY (id);


--
-- Name: alf_server_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_server
    ADD CONSTRAINT alf_server_pkey PRIMARY KEY (id);


--
-- Name: alf_store_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_store
    ADD CONSTRAINT alf_store_pkey PRIMARY KEY (id);


--
-- Name: alf_subscriptions_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_subscriptions
    ADD CONSTRAINT alf_subscriptions_pkey PRIMARY KEY (user_node_id, node_id);


--
-- Name: alf_tenant_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_tenant
    ADD CONSTRAINT alf_tenant_pkey PRIMARY KEY (tenant_domain);


--
-- Name: alf_transaction_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_transaction
    ADD CONSTRAINT alf_transaction_pkey PRIMARY KEY (id);


--
-- Name: alf_usage_delta_pkey; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_usage_delta
    ADD CONSTRAINT alf_usage_delta_pkey PRIMARY KEY (id);


--
-- Name: idx_alf_aud_app_an; Type: CONSTRAINT; Schema: public; Owner: alfresco; Tablespace:
--

ALTER TABLE ONLY alf_audit_app
    ADD CONSTRAINT idx_alf_aud_app_an UNIQUE (app_name_id);


--
-- Name: acl_id; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX acl_id ON alf_access_control_list USING btree (acl_id, latest, acl_version);


--
-- Name: aclm_acl_id; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX aclm_acl_id ON alf_acl_member USING btree (acl_id, ace_id, pos);


--
-- Name: act_idx_athrz_procedef; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_athrz_procedef ON act_ru_identitylink USING btree (proc_def_id_);


--
-- Name: act_idx_bytear_depl; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_bytear_depl ON act_ge_bytearray USING btree (deployment_id_);


--
-- Name: act_idx_event_subscr; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_event_subscr ON act_ru_event_subscr USING btree (execution_id_);


--
-- Name: act_idx_event_subscr_config_; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_event_subscr_config_ ON act_ru_event_subscr USING btree (configuration_);


--
-- Name: act_idx_exe_parent; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_exe_parent ON act_ru_execution USING btree (parent_id_);


--
-- Name: act_idx_exe_procdef; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_exe_procdef ON act_ru_execution USING btree (proc_def_id_);


--
-- Name: act_idx_exe_procinst; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_exe_procinst ON act_ru_execution USING btree (proc_inst_id_);


--
-- Name: act_idx_exe_super; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_exe_super ON act_ru_execution USING btree (super_exec_);


--
-- Name: act_idx_exec_buskey; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_exec_buskey ON act_ru_execution USING btree (business_key_);


--
-- Name: act_idx_hi_act_inst_end; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_act_inst_end ON act_hi_actinst USING btree (end_time_);


--
-- Name: act_idx_hi_act_inst_exec; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_act_inst_exec ON act_hi_actinst USING btree (execution_id_, act_id_);


--
-- Name: act_idx_hi_act_inst_procinst; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_act_inst_procinst ON act_hi_actinst USING btree (proc_inst_id_, act_id_);


--
-- Name: act_idx_hi_act_inst_start; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_act_inst_start ON act_hi_actinst USING btree (start_time_);


--
-- Name: act_idx_hi_detail_act_inst; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_detail_act_inst ON act_hi_detail USING btree (act_inst_id_);


--
-- Name: act_idx_hi_detail_name; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_detail_name ON act_hi_detail USING btree (name_);


--
-- Name: act_idx_hi_detail_proc_inst; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_detail_proc_inst ON act_hi_detail USING btree (proc_inst_id_);


--
-- Name: act_idx_hi_detail_task_id; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_detail_task_id ON act_hi_detail USING btree (task_id_);


--
-- Name: act_idx_hi_detail_time; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_detail_time ON act_hi_detail USING btree (time_);


--
-- Name: act_idx_hi_ident_lnk_procinst; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_ident_lnk_procinst ON act_hi_identitylink USING btree (proc_inst_id_);


--
-- Name: act_idx_hi_ident_lnk_task; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_ident_lnk_task ON act_hi_identitylink USING btree (task_id_);


--
-- Name: act_idx_hi_ident_lnk_user; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_ident_lnk_user ON act_hi_identitylink USING btree (user_id_);


--
-- Name: act_idx_hi_pro_i_buskey; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_pro_i_buskey ON act_hi_procinst USING btree (business_key_);


--
-- Name: act_idx_hi_pro_inst_end; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_pro_inst_end ON act_hi_procinst USING btree (end_time_);


--
-- Name: act_idx_hi_procvar_name_type; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_procvar_name_type ON act_hi_varinst USING btree (name_, var_type_);


--
-- Name: act_idx_hi_procvar_proc_inst; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_procvar_proc_inst ON act_hi_varinst USING btree (proc_inst_id_);


--
-- Name: act_idx_hi_procvar_task_id; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_procvar_task_id ON act_hi_varinst USING btree (task_id_);


--
-- Name: act_idx_hi_task_inst_procinst; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_hi_task_inst_procinst ON act_hi_taskinst USING btree (proc_inst_id_);


--
-- Name: act_idx_ident_lnk_group; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_ident_lnk_group ON act_ru_identitylink USING btree (group_id_);


--
-- Name: act_idx_ident_lnk_user; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_ident_lnk_user ON act_ru_identitylink USING btree (user_id_);


--
-- Name: act_idx_idl_procinst; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_idl_procinst ON act_ru_identitylink USING btree (proc_inst_id_);


--
-- Name: act_idx_job_exception; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_job_exception ON act_ru_job USING btree (exception_stack_id_);


--
-- Name: act_idx_memb_group; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_memb_group ON act_id_membership USING btree (group_id_);


--
-- Name: act_idx_memb_user; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_memb_user ON act_id_membership USING btree (user_id_);


--
-- Name: act_idx_model_deployment; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_model_deployment ON act_re_model USING btree (deployment_id_);


--
-- Name: act_idx_model_source; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_model_source ON act_re_model USING btree (editor_source_value_id_);


--
-- Name: act_idx_model_source_extra; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_model_source_extra ON act_re_model USING btree (editor_source_extra_value_id_);


--
-- Name: act_idx_procdef_info_json; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_procdef_info_json ON act_procdef_info USING btree (info_json_id_);


--
-- Name: act_idx_procdef_info_proc; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_procdef_info_proc ON act_procdef_info USING btree (proc_def_id_);


--
-- Name: act_idx_task_create; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_task_create ON act_ru_task USING btree (create_time_);


--
-- Name: act_idx_task_exec; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_task_exec ON act_ru_task USING btree (execution_id_);


--
-- Name: act_idx_task_procdef; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_task_procdef ON act_ru_task USING btree (proc_def_id_);


--
-- Name: act_idx_task_procinst; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_task_procinst ON act_ru_task USING btree (proc_inst_id_);


--
-- Name: act_idx_tskass_task; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_tskass_task ON act_ru_identitylink USING btree (task_id_);


--
-- Name: act_idx_var_bytearray; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_var_bytearray ON act_ru_variable USING btree (bytearray_id_);


--
-- Name: act_idx_var_exe; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_var_exe ON act_ru_variable USING btree (execution_id_);


--
-- Name: act_idx_var_procinst; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_var_procinst ON act_ru_variable USING btree (proc_inst_id_);


--
-- Name: act_idx_variable_task_id; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX act_idx_variable_task_id ON act_ru_variable USING btree (task_id_);


--
-- Name: auth_id; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX auth_id ON alf_authority_alias USING btree (auth_id, alias_id);


--
-- Name: authority; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX authority ON alf_authority USING btree (authority, crc);


--
-- Name: feed_feeduserid_idx; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX feed_feeduserid_idx ON alf_activity_feed USING btree (feed_user_id);


--
-- Name: feed_postdate_idx; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX feed_postdate_idx ON alf_activity_feed USING btree (post_date);


--
-- Name: feed_postuserid_idx; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX feed_postuserid_idx ON alf_activity_feed USING btree (post_user_id);


--
-- Name: feed_sitenetwork_idx; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX feed_sitenetwork_idx ON alf_activity_feed USING btree (site_network);


--
-- Name: feedctrl_feeduserid_idx; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX feedctrl_feeduserid_idx ON alf_activity_feed_control USING btree (feed_user_id);


--
-- Name: fk_alf_ace_auth; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_ace_auth ON alf_access_control_entry USING btree (authority_id);


--
-- Name: fk_alf_ace_ctx; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_ace_ctx ON alf_access_control_entry USING btree (context_id);


--
-- Name: fk_alf_ace_perm; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_ace_perm ON alf_access_control_entry USING btree (permission_id);


--
-- Name: fk_alf_acl_acs; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_acl_acs ON alf_access_control_list USING btree (acl_change_set);


--
-- Name: fk_alf_aclm_ace; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_aclm_ace ON alf_acl_member USING btree (ace_id);


--
-- Name: fk_alf_aclm_acl; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_aclm_acl ON alf_acl_member USING btree (acl_id);


--
-- Name: fk_alf_aud_app_dis; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_aud_app_dis ON alf_audit_app USING btree (disabled_paths_id);


--
-- Name: fk_alf_aud_app_mod; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_aud_app_mod ON alf_audit_app USING btree (audit_model_id);


--
-- Name: fk_alf_aud_ent_app; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_aud_ent_app ON alf_audit_entry USING btree (audit_app_id);


--
-- Name: fk_alf_aud_ent_pro; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_aud_ent_pro ON alf_audit_entry USING btree (audit_values_id);


--
-- Name: fk_alf_aud_ent_use; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_aud_ent_use ON alf_audit_entry USING btree (audit_user_id);


--
-- Name: fk_alf_aud_mod_cd; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_aud_mod_cd ON alf_audit_model USING btree (content_data_id);


--
-- Name: fk_alf_autha_ali; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_autha_ali ON alf_authority_alias USING btree (alias_id);


--
-- Name: fk_alf_autha_aut; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_autha_aut ON alf_authority_alias USING btree (auth_id);


--
-- Name: fk_alf_cass_cnode; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_cass_cnode ON alf_child_assoc USING btree (child_node_id);


--
-- Name: fk_alf_cass_qnns; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_cass_qnns ON alf_child_assoc USING btree (qname_ns_id);


--
-- Name: fk_alf_cass_tqn; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_cass_tqn ON alf_child_assoc USING btree (type_qname_id);


--
-- Name: fk_alf_cont_enc; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_cont_enc ON alf_content_data USING btree (content_encoding_id);


--
-- Name: fk_alf_cont_loc; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_cont_loc ON alf_content_data USING btree (content_locale_id);


--
-- Name: fk_alf_cont_mim; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_cont_mim ON alf_content_data USING btree (content_mimetype_id);


--
-- Name: fk_alf_cont_url; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_cont_url ON alf_content_data USING btree (content_url_id);


--
-- Name: fk_alf_lock_excl; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_lock_excl ON alf_lock USING btree (excl_resource_id);


--
-- Name: fk_alf_nasp_n; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_nasp_n ON alf_node_aspects USING btree (node_id);


--
-- Name: fk_alf_nasp_qn; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_nasp_qn ON alf_node_aspects USING btree (qname_id);


--
-- Name: fk_alf_nass_snode; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_nass_snode ON alf_node_assoc USING btree (source_node_id, type_qname_id, assoc_index);


--
-- Name: fk_alf_nass_tnode; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_nass_tnode ON alf_node_assoc USING btree (target_node_id, type_qname_id);


--
-- Name: fk_alf_nass_tqn; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_nass_tqn ON alf_node_assoc USING btree (type_qname_id);


--
-- Name: fk_alf_node_acl; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_node_acl ON alf_node USING btree (acl_id);


--
-- Name: fk_alf_node_loc; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_node_loc ON alf_node USING btree (locale_id);


--
-- Name: fk_alf_node_store; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_node_store ON alf_node USING btree (store_id);


--
-- Name: fk_alf_nprop_loc; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_nprop_loc ON alf_node_properties USING btree (locale_id);


--
-- Name: fk_alf_nprop_n; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_nprop_n ON alf_node_properties USING btree (node_id);


--
-- Name: fk_alf_nprop_qn; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_nprop_qn ON alf_node_properties USING btree (qname_id);


--
-- Name: fk_alf_perm_tqn; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_perm_tqn ON alf_permission USING btree (type_qname_id);


--
-- Name: fk_alf_propln_key; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_propln_key ON alf_prop_link USING btree (key_prop_id);


--
-- Name: fk_alf_propln_val; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_propln_val ON alf_prop_link USING btree (value_prop_id);


--
-- Name: fk_alf_propuctx_p1; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_propuctx_p1 ON alf_prop_unique_ctx USING btree (prop1_id);


--
-- Name: fk_alf_propuctx_v2; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_propuctx_v2 ON alf_prop_unique_ctx USING btree (value2_prop_id);


--
-- Name: fk_alf_propuctx_v3; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_propuctx_v3 ON alf_prop_unique_ctx USING btree (value3_prop_id);


--
-- Name: fk_alf_store_root; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_store_root ON alf_store USING btree (root_node_id);


--
-- Name: fk_alf_sub_node; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_sub_node ON alf_subscriptions USING btree (node_id);


--
-- Name: fk_alf_txn_svr; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_txn_svr ON alf_transaction USING btree (server_id);


--
-- Name: fk_alf_usaged_n; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX fk_alf_usaged_n ON alf_usage_delta USING btree (node_id);


--
-- Name: idx_alf_acl_inh; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_acl_inh ON alf_access_control_list USING btree (inherits, inherits_from);


--
-- Name: idx_alf_acs_ctms; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_acs_ctms ON alf_acl_change_set USING btree (commit_time_ms);


--
-- Name: idx_alf_aud_ent_tm; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_aud_ent_tm ON alf_audit_entry USING btree (audit_time);


--
-- Name: idx_alf_aud_mod_cr; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX idx_alf_aud_mod_cr ON alf_audit_model USING btree (content_crc);


--
-- Name: idx_alf_auth_action; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_auth_action ON alf_auth_status USING btree (authaction);


--
-- Name: idx_alf_auth_aut; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_auth_aut ON alf_authority USING btree (authority);


--
-- Name: idx_alf_auth_deleted; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_auth_deleted ON alf_auth_status USING btree (deleted);


--
-- Name: idx_alf_auth_usr_stat; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX idx_alf_auth_usr_stat ON alf_auth_status USING btree (username, authorized);


--
-- Name: idx_alf_cass_pnode; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_cass_pnode ON alf_child_assoc USING btree (parent_node_id, assoc_index, id);


--
-- Name: idx_alf_cass_pri; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_cass_pri ON alf_child_assoc USING btree (parent_node_id, is_primary, child_node_id);


--
-- Name: idx_alf_cass_qncrc; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_cass_qncrc ON alf_child_assoc USING btree (qname_crc, type_qname_id, parent_node_id);


--
-- Name: idx_alf_cont_enc_mka; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_cont_enc_mka ON alf_content_url_encryption USING btree (master_key_alias);


--
-- Name: idx_alf_cont_enc_url; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX idx_alf_cont_enc_url ON alf_content_url_encryption USING btree (content_url_id);


--
-- Name: idx_alf_conturl_cr; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX idx_alf_conturl_cr ON alf_content_url USING btree (content_url_short, content_url_crc);


--
-- Name: idx_alf_conturl_ot; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_conturl_ot ON alf_content_url USING btree (orphan_time);


--
-- Name: idx_alf_conturl_sz; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_conturl_sz ON alf_content_url USING btree (content_size, id);


--
-- Name: idx_alf_lock_key; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX idx_alf_lock_key ON alf_lock USING btree (shared_resource_id, excl_resource_id);


--
-- Name: idx_alf_lockr_key; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX idx_alf_lockr_key ON alf_lock_resource USING btree (qname_ns_id, qname_localname);


--
-- Name: idx_alf_node_cor; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_node_cor ON alf_node USING btree (audit_creator, store_id, type_qname_id, id);


--
-- Name: idx_alf_node_crd; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_node_crd ON alf_node USING btree (audit_created, store_id, type_qname_id, id);


--
-- Name: idx_alf_node_mdq; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_node_mdq ON alf_node USING btree (store_id, type_qname_id, id);


--
-- Name: idx_alf_node_mod; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_node_mod ON alf_node USING btree (audit_modified, store_id, type_qname_id, id);


--
-- Name: idx_alf_node_mor; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_node_mor ON alf_node USING btree (audit_modifier, store_id, type_qname_id, id);


--
-- Name: idx_alf_node_tqn; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_node_tqn ON alf_node USING btree (type_qname_id, store_id, id);


--
-- Name: idx_alf_node_txn_type; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_node_txn_type ON alf_node USING btree (transaction_id, type_qname_id);


--
-- Name: idx_alf_nprop_b; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_nprop_b ON alf_node_properties USING btree (qname_id, boolean_value, node_id);


--
-- Name: idx_alf_nprop_d; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_nprop_d ON alf_node_properties USING btree (qname_id, double_value, node_id);


--
-- Name: idx_alf_nprop_f; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_nprop_f ON alf_node_properties USING btree (qname_id, float_value, node_id);


--
-- Name: idx_alf_nprop_l; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_nprop_l ON alf_node_properties USING btree (qname_id, long_value, node_id);


--
-- Name: idx_alf_nprop_s; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_nprop_s ON alf_node_properties USING btree (qname_id, string_value, node_id);


--
-- Name: idx_alf_propc_clas; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_propc_clas ON alf_prop_class USING btree (java_class_name);


--
-- Name: idx_alf_propc_crc; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX idx_alf_propc_crc ON alf_prop_class USING btree (java_class_name_crc, java_class_name_short);


--
-- Name: idx_alf_propd_val; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX idx_alf_propd_val ON alf_prop_double_value USING btree (double_value);


--
-- Name: idx_alf_propdt_dt; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_propdt_dt ON alf_prop_date_value USING btree (full_year, month_of_year, day_of_month);


--
-- Name: idx_alf_propln_for; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_propln_for ON alf_prop_link USING btree (root_prop_id, key_prop_id, value_prop_id);


--
-- Name: idx_alf_props_crc; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX idx_alf_props_crc ON alf_prop_string_value USING btree (string_end_lower, string_crc);


--
-- Name: idx_alf_props_str; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_props_str ON alf_prop_string_value USING btree (string_value);


--
-- Name: idx_alf_propuctx; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX idx_alf_propuctx ON alf_prop_unique_ctx USING btree (value1_prop_id, value2_prop_id, value3_prop_id);


--
-- Name: idx_alf_propv_act; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX idx_alf_propv_act ON alf_prop_value USING btree (actual_type_id, long_value);


--
-- Name: idx_alf_propv_per; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_propv_per ON alf_prop_value USING btree (persisted_type, long_value);


--
-- Name: idx_alf_txn_ctms; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX idx_alf_txn_ctms ON alf_transaction USING btree (commit_time_ms, id);


--
-- Name: ip_address; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX ip_address ON alf_server USING btree (ip_address);


--
-- Name: locale_str; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX locale_str ON alf_locale USING btree (locale_str);


--
-- Name: ns_id; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX ns_id ON alf_qname USING btree (ns_id, local_name);


--
-- Name: parent_node_id; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX parent_node_id ON alf_child_assoc USING btree (parent_node_id, type_qname_id, child_node_name_crc, child_node_name);


--
-- Name: permission_id; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX permission_id ON alf_access_control_entry USING btree (permission_id, authority_id, allowed, applies);


--
-- Name: post_jobtasknode_idx; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX post_jobtasknode_idx ON alf_activity_post USING btree (job_task_node);


--
-- Name: post_status_idx; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE INDEX post_status_idx ON alf_activity_post USING btree (status);


--
-- Name: protocol; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX protocol ON alf_store USING btree (protocol, identifier);


--
-- Name: source_node_id; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX source_node_id ON alf_node_assoc USING btree (source_node_id, target_node_id, type_qname_id);


--
-- Name: store_id; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX store_id ON alf_node USING btree (store_id, uuid);


--
-- Name: type_qname_id; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX type_qname_id ON alf_permission USING btree (type_qname_id, name);


--
-- Name: uri; Type: INDEX; Schema: public; Owner: alfresco; Tablespace:
--

CREATE UNIQUE INDEX uri ON alf_namespace USING btree (uri);


--
-- Name: act_fk_athrz_procedef; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_ru_identitylink
    ADD CONSTRAINT act_fk_athrz_procedef FOREIGN KEY (proc_def_id_) REFERENCES act_re_procdef(id_);


--
-- Name: act_fk_bytearr_depl; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_ge_bytearray
    ADD CONSTRAINT act_fk_bytearr_depl FOREIGN KEY (deployment_id_) REFERENCES act_re_deployment(id_);


--
-- Name: act_fk_event_exec; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_ru_event_subscr
    ADD CONSTRAINT act_fk_event_exec FOREIGN KEY (execution_id_) REFERENCES act_ru_execution(id_);


--
-- Name: act_fk_exe_parent; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_ru_execution
    ADD CONSTRAINT act_fk_exe_parent FOREIGN KEY (parent_id_) REFERENCES act_ru_execution(id_);


--
-- Name: act_fk_exe_procdef; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_ru_execution
    ADD CONSTRAINT act_fk_exe_procdef FOREIGN KEY (proc_def_id_) REFERENCES act_re_procdef(id_);


--
-- Name: act_fk_exe_procinst; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_ru_execution
    ADD CONSTRAINT act_fk_exe_procinst FOREIGN KEY (proc_inst_id_) REFERENCES act_ru_execution(id_);


--
-- Name: act_fk_exe_super; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_ru_execution
    ADD CONSTRAINT act_fk_exe_super FOREIGN KEY (super_exec_) REFERENCES act_ru_execution(id_);


--
-- Name: act_fk_idl_procinst; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_ru_identitylink
    ADD CONSTRAINT act_fk_idl_procinst FOREIGN KEY (proc_inst_id_) REFERENCES act_ru_execution(id_);


--
-- Name: act_fk_info_json_ba; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_procdef_info
    ADD CONSTRAINT act_fk_info_json_ba FOREIGN KEY (info_json_id_) REFERENCES act_ge_bytearray(id_);


--
-- Name: act_fk_info_procdef; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_procdef_info
    ADD CONSTRAINT act_fk_info_procdef FOREIGN KEY (proc_def_id_) REFERENCES act_re_procdef(id_);


--
-- Name: act_fk_job_exception; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_ru_job
    ADD CONSTRAINT act_fk_job_exception FOREIGN KEY (exception_stack_id_) REFERENCES act_ge_bytearray(id_);


--
-- Name: act_fk_memb_group; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_id_membership
    ADD CONSTRAINT act_fk_memb_group FOREIGN KEY (group_id_) REFERENCES act_id_group(id_);


--
-- Name: act_fk_memb_user; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_id_membership
    ADD CONSTRAINT act_fk_memb_user FOREIGN KEY (user_id_) REFERENCES act_id_user(id_);


--
-- Name: act_fk_model_deployment; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_re_model
    ADD CONSTRAINT act_fk_model_deployment FOREIGN KEY (deployment_id_) REFERENCES act_re_deployment(id_);


--
-- Name: act_fk_model_source; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_re_model
    ADD CONSTRAINT act_fk_model_source FOREIGN KEY (editor_source_value_id_) REFERENCES act_ge_bytearray(id_);


--
-- Name: act_fk_model_source_extra; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_re_model
    ADD CONSTRAINT act_fk_model_source_extra FOREIGN KEY (editor_source_extra_value_id_) REFERENCES act_ge_bytearray(id_);


--
-- Name: act_fk_task_exe; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_ru_task
    ADD CONSTRAINT act_fk_task_exe FOREIGN KEY (execution_id_) REFERENCES act_ru_execution(id_);


--
-- Name: act_fk_task_procdef; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_ru_task
    ADD CONSTRAINT act_fk_task_procdef FOREIGN KEY (proc_def_id_) REFERENCES act_re_procdef(id_);


--
-- Name: act_fk_task_procinst; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_ru_task
    ADD CONSTRAINT act_fk_task_procinst FOREIGN KEY (proc_inst_id_) REFERENCES act_ru_execution(id_);


--
-- Name: act_fk_tskass_task; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_ru_identitylink
    ADD CONSTRAINT act_fk_tskass_task FOREIGN KEY (task_id_) REFERENCES act_ru_task(id_);


--
-- Name: act_fk_var_bytearray; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_ru_variable
    ADD CONSTRAINT act_fk_var_bytearray FOREIGN KEY (bytearray_id_) REFERENCES act_ge_bytearray(id_);


--
-- Name: act_fk_var_exe; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_ru_variable
    ADD CONSTRAINT act_fk_var_exe FOREIGN KEY (execution_id_) REFERENCES act_ru_execution(id_);


--
-- Name: act_fk_var_procinst; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY act_ru_variable
    ADD CONSTRAINT act_fk_var_procinst FOREIGN KEY (proc_inst_id_) REFERENCES act_ru_execution(id_);


--
-- Name: fk_alf_ace_auth; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_access_control_entry
    ADD CONSTRAINT fk_alf_ace_auth FOREIGN KEY (authority_id) REFERENCES alf_authority(id);


--
-- Name: fk_alf_ace_ctx; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_access_control_entry
    ADD CONSTRAINT fk_alf_ace_ctx FOREIGN KEY (context_id) REFERENCES alf_ace_context(id);


--
-- Name: fk_alf_ace_perm; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_access_control_entry
    ADD CONSTRAINT fk_alf_ace_perm FOREIGN KEY (permission_id) REFERENCES alf_permission(id);


--
-- Name: fk_alf_acl_acs; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_access_control_list
    ADD CONSTRAINT fk_alf_acl_acs FOREIGN KEY (acl_change_set) REFERENCES alf_acl_change_set(id);


--
-- Name: fk_alf_aclm_ace; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_acl_member
    ADD CONSTRAINT fk_alf_aclm_ace FOREIGN KEY (ace_id) REFERENCES alf_access_control_entry(id);


--
-- Name: fk_alf_aclm_acl; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_acl_member
    ADD CONSTRAINT fk_alf_aclm_acl FOREIGN KEY (acl_id) REFERENCES alf_access_control_list(id);


--
-- Name: fk_alf_aud_app_an; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_audit_app
    ADD CONSTRAINT fk_alf_aud_app_an FOREIGN KEY (app_name_id) REFERENCES alf_prop_value(id);


--
-- Name: fk_alf_aud_app_dis; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_audit_app
    ADD CONSTRAINT fk_alf_aud_app_dis FOREIGN KEY (disabled_paths_id) REFERENCES alf_prop_root(id);


--
-- Name: fk_alf_aud_app_mod; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_audit_app
    ADD CONSTRAINT fk_alf_aud_app_mod FOREIGN KEY (audit_model_id) REFERENCES alf_audit_model(id) ON DELETE CASCADE;


--
-- Name: fk_alf_aud_ent_app; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_audit_entry
    ADD CONSTRAINT fk_alf_aud_ent_app FOREIGN KEY (audit_app_id) REFERENCES alf_audit_app(id) ON DELETE CASCADE;


--
-- Name: fk_alf_aud_ent_pro; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_audit_entry
    ADD CONSTRAINT fk_alf_aud_ent_pro FOREIGN KEY (audit_values_id) REFERENCES alf_prop_root(id);


--
-- Name: fk_alf_aud_ent_use; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_audit_entry
    ADD CONSTRAINT fk_alf_aud_ent_use FOREIGN KEY (audit_user_id) REFERENCES alf_prop_value(id);


--
-- Name: fk_alf_aud_mod_cd; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_audit_model
    ADD CONSTRAINT fk_alf_aud_mod_cd FOREIGN KEY (content_data_id) REFERENCES alf_content_data(id);


--
-- Name: fk_alf_autha_ali; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_authority_alias
    ADD CONSTRAINT fk_alf_autha_ali FOREIGN KEY (alias_id) REFERENCES alf_authority(id);


--
-- Name: fk_alf_autha_aut; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_authority_alias
    ADD CONSTRAINT fk_alf_autha_aut FOREIGN KEY (auth_id) REFERENCES alf_authority(id);


--
-- Name: fk_alf_cass_cnode; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_child_assoc
    ADD CONSTRAINT fk_alf_cass_cnode FOREIGN KEY (child_node_id) REFERENCES alf_node(id);


--
-- Name: fk_alf_cass_pnode; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_child_assoc
    ADD CONSTRAINT fk_alf_cass_pnode FOREIGN KEY (parent_node_id) REFERENCES alf_node(id);


--
-- Name: fk_alf_cass_qnns; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_child_assoc
    ADD CONSTRAINT fk_alf_cass_qnns FOREIGN KEY (qname_ns_id) REFERENCES alf_namespace(id);


--
-- Name: fk_alf_cass_tqn; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_child_assoc
    ADD CONSTRAINT fk_alf_cass_tqn FOREIGN KEY (type_qname_id) REFERENCES alf_qname(id);


--
-- Name: fk_alf_cont_enc; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_content_data
    ADD CONSTRAINT fk_alf_cont_enc FOREIGN KEY (content_encoding_id) REFERENCES alf_encoding(id);


--
-- Name: fk_alf_cont_enc_url; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_content_url_encryption
    ADD CONSTRAINT fk_alf_cont_enc_url FOREIGN KEY (content_url_id) REFERENCES alf_content_url(id) ON DELETE CASCADE;


--
-- Name: fk_alf_cont_loc; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_content_data
    ADD CONSTRAINT fk_alf_cont_loc FOREIGN KEY (content_locale_id) REFERENCES alf_locale(id);


--
-- Name: fk_alf_cont_mim; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_content_data
    ADD CONSTRAINT fk_alf_cont_mim FOREIGN KEY (content_mimetype_id) REFERENCES alf_mimetype(id);


--
-- Name: fk_alf_cont_url; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_content_data
    ADD CONSTRAINT fk_alf_cont_url FOREIGN KEY (content_url_id) REFERENCES alf_content_url(id);


--
-- Name: fk_alf_lock_excl; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_lock
    ADD CONSTRAINT fk_alf_lock_excl FOREIGN KEY (excl_resource_id) REFERENCES alf_lock_resource(id);


--
-- Name: fk_alf_lock_shared; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_lock
    ADD CONSTRAINT fk_alf_lock_shared FOREIGN KEY (shared_resource_id) REFERENCES alf_lock_resource(id);


--
-- Name: fk_alf_lockr_ns; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_lock_resource
    ADD CONSTRAINT fk_alf_lockr_ns FOREIGN KEY (qname_ns_id) REFERENCES alf_namespace(id);


--
-- Name: fk_alf_nasp_n; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_node_aspects
    ADD CONSTRAINT fk_alf_nasp_n FOREIGN KEY (node_id) REFERENCES alf_node(id);


--
-- Name: fk_alf_nasp_qn; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_node_aspects
    ADD CONSTRAINT fk_alf_nasp_qn FOREIGN KEY (qname_id) REFERENCES alf_qname(id);


--
-- Name: fk_alf_nass_snode; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_node_assoc
    ADD CONSTRAINT fk_alf_nass_snode FOREIGN KEY (source_node_id) REFERENCES alf_node(id);


--
-- Name: fk_alf_nass_tnode; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_node_assoc
    ADD CONSTRAINT fk_alf_nass_tnode FOREIGN KEY (target_node_id) REFERENCES alf_node(id);


--
-- Name: fk_alf_nass_tqn; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_node_assoc
    ADD CONSTRAINT fk_alf_nass_tqn FOREIGN KEY (type_qname_id) REFERENCES alf_qname(id);


--
-- Name: fk_alf_node_acl; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_node
    ADD CONSTRAINT fk_alf_node_acl FOREIGN KEY (acl_id) REFERENCES alf_access_control_list(id);


--
-- Name: fk_alf_node_loc; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_node
    ADD CONSTRAINT fk_alf_node_loc FOREIGN KEY (locale_id) REFERENCES alf_locale(id);


--
-- Name: fk_alf_node_store; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_node
    ADD CONSTRAINT fk_alf_node_store FOREIGN KEY (store_id) REFERENCES alf_store(id);


--
-- Name: fk_alf_node_tqn; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_node
    ADD CONSTRAINT fk_alf_node_tqn FOREIGN KEY (type_qname_id) REFERENCES alf_qname(id);


--
-- Name: fk_alf_node_txn; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_node
    ADD CONSTRAINT fk_alf_node_txn FOREIGN KEY (transaction_id) REFERENCES alf_transaction(id);


--
-- Name: fk_alf_nprop_loc; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_node_properties
    ADD CONSTRAINT fk_alf_nprop_loc FOREIGN KEY (locale_id) REFERENCES alf_locale(id);


--
-- Name: fk_alf_nprop_n; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_node_properties
    ADD CONSTRAINT fk_alf_nprop_n FOREIGN KEY (node_id) REFERENCES alf_node(id);


--
-- Name: fk_alf_nprop_qn; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_node_properties
    ADD CONSTRAINT fk_alf_nprop_qn FOREIGN KEY (qname_id) REFERENCES alf_qname(id);


--
-- Name: fk_alf_perm_tqn; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_permission
    ADD CONSTRAINT fk_alf_perm_tqn FOREIGN KEY (type_qname_id) REFERENCES alf_qname(id);


--
-- Name: fk_alf_propln_key; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_prop_link
    ADD CONSTRAINT fk_alf_propln_key FOREIGN KEY (key_prop_id) REFERENCES alf_prop_value(id) ON DELETE CASCADE;


--
-- Name: fk_alf_propln_root; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_prop_link
    ADD CONSTRAINT fk_alf_propln_root FOREIGN KEY (root_prop_id) REFERENCES alf_prop_root(id) ON DELETE CASCADE;


--
-- Name: fk_alf_propln_val; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_prop_link
    ADD CONSTRAINT fk_alf_propln_val FOREIGN KEY (value_prop_id) REFERENCES alf_prop_value(id) ON DELETE CASCADE;


--
-- Name: fk_alf_propuctx_p1; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_prop_unique_ctx
    ADD CONSTRAINT fk_alf_propuctx_p1 FOREIGN KEY (prop1_id) REFERENCES alf_prop_root(id);


--
-- Name: fk_alf_propuctx_v1; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_prop_unique_ctx
    ADD CONSTRAINT fk_alf_propuctx_v1 FOREIGN KEY (value1_prop_id) REFERENCES alf_prop_value(id) ON DELETE CASCADE;


--
-- Name: fk_alf_propuctx_v2; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_prop_unique_ctx
    ADD CONSTRAINT fk_alf_propuctx_v2 FOREIGN KEY (value2_prop_id) REFERENCES alf_prop_value(id) ON DELETE CASCADE;


--
-- Name: fk_alf_propuctx_v3; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_prop_unique_ctx
    ADD CONSTRAINT fk_alf_propuctx_v3 FOREIGN KEY (value3_prop_id) REFERENCES alf_prop_value(id) ON DELETE CASCADE;


--
-- Name: fk_alf_qname_ns; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_qname
    ADD CONSTRAINT fk_alf_qname_ns FOREIGN KEY (ns_id) REFERENCES alf_namespace(id);


--
-- Name: fk_alf_store_root; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_store
    ADD CONSTRAINT fk_alf_store_root FOREIGN KEY (root_node_id) REFERENCES alf_node(id);


--
-- Name: fk_alf_sub_node; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_subscriptions
    ADD CONSTRAINT fk_alf_sub_node FOREIGN KEY (node_id) REFERENCES alf_node(id) ON DELETE CASCADE;


--
-- Name: fk_alf_sub_user; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_subscriptions
    ADD CONSTRAINT fk_alf_sub_user FOREIGN KEY (user_node_id) REFERENCES alf_node(id) ON DELETE CASCADE;


--
-- Name: fk_alf_txn_svr; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_transaction
    ADD CONSTRAINT fk_alf_txn_svr FOREIGN KEY (server_id) REFERENCES alf_server(id);


--
-- Name: fk_alf_usaged_n; Type: FK CONSTRAINT; Schema: public; Owner: alfresco
--

ALTER TABLE ONLY alf_usage_delta
    ADD CONSTRAINT fk_alf_usaged_n FOREIGN KEY (node_id) REFERENCES alf_node(id);