Errors creating the identityiq database

[fugitiva (Sara La Madrid)]

Dear community,

When i run

im getting those error

this is my ddl

CREATE DATABASE IF NOT EXISTS iiqDevelopment CHARACTER SET utf8mb4;
use iiqDevelopment;

CREATE DATABASE IF NOT EXISTS identityiqPlugin CHARACTER SET utf8mb4;

CREATE TABLE QRTZ221_JOB_DETAILS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    JOB_NAME  VARCHAR(200) NOT NULL,
    JOB_GROUP VARCHAR(200) NOT NULL,
    DESCRIPTION VARCHAR(250) NULL,
    JOB_CLASS_NAME   VARCHAR(250) NOT NULL,
    IS_DURABLE VARCHAR(1) NOT NULL,
    IS_NONCONCURRENT VARCHAR(1) NOT NULL,
    IS_UPDATE_DATA VARCHAR(1) NOT NULL,
    REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
    JOB_DATA BLOB NULL,
    PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)
) ENGINE=InnoDB;

CREATE TABLE QRTZ221_TRIGGERS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    JOB_NAME  VARCHAR(200) NOT NULL,
    JOB_GROUP VARCHAR(200) NOT NULL,
    DESCRIPTION VARCHAR(250) NULL,
    NEXT_FIRE_TIME BIGINT NULL,
    PREV_FIRE_TIME BIGINT NULL,
    PRIORITY INTEGER NULL,
    TRIGGER_STATE VARCHAR(16) NOT NULL,
    TRIGGER_TYPE VARCHAR(8) NOT NULL,
    START_TIME BIGINT NOT NULL,
    END_TIME BIGINT NULL,
    CALENDAR_NAME VARCHAR(200) NULL,
    MISFIRE_INSTR SMALLINT NULL,
    JOB_DATA BLOB NULL,
    PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
    FOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)
        REFERENCES QRTZ221_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP)
) ENGINE=InnoDB;

CREATE TABLE QRTZ221_SIMPLE_TRIGGERS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    REPEAT_COUNT BIGINT NOT NULL,
    REPEAT_INTERVAL BIGINT NOT NULL,
    TIMES_TRIGGERED BIGINT NOT NULL,
    PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
    FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
        REFERENCES QRTZ221_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
) ENGINE=InnoDB;

CREATE TABLE QRTZ221_CRON_TRIGGERS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    CRON_EXPRESSION VARCHAR(200) NOT NULL,
    TIME_ZONE_ID VARCHAR(80),
    PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
    FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
        REFERENCES QRTZ221_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
) ENGINE=InnoDB;

CREATE TABLE QRTZ221_SIMPROP_TRIGGERS
  (          
    SCHED_NAME VARCHAR(120) NOT NULL,
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    STR_PROP_1 VARCHAR(512) NULL,
    STR_PROP_2 VARCHAR(512) NULL,
    STR_PROP_3 VARCHAR(512) NULL,
    INT_PROP_1 INT NULL,
    INT_PROP_2 INT NULL,
    LONG_PROP_1 BIGINT NULL,
    LONG_PROP_2 BIGINT NULL,
    DEC_PROP_1 NUMERIC(13,4) NULL,
    DEC_PROP_2 NUMERIC(13,4) NULL,
    BOOL_PROP_1 VARCHAR(1) NULL,
    BOOL_PROP_2 VARCHAR(1) NULL,
    PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
    FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) 
    REFERENCES QRTZ221_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
) ENGINE=InnoDB;

CREATE TABLE QRTZ221_BLOB_TRIGGERS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    BLOB_DATA BLOB NULL,
    PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
    FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
        REFERENCES QRTZ221_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
) ENGINE=InnoDB;

CREATE TABLE QRTZ221_CALENDARS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    CALENDAR_NAME  VARCHAR(200) NOT NULL,
    CALENDAR BLOB NOT NULL,
    PRIMARY KEY (SCHED_NAME,CALENDAR_NAME)
) ENGINE=InnoDB;

CREATE TABLE QRTZ221_PAUSED_TRIGGER_GRPS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    TRIGGER_GROUP  VARCHAR(200) NOT NULL, 
    PRIMARY KEY (SCHED_NAME,TRIGGER_GROUP)
) ENGINE=InnoDB;

CREATE TABLE QRTZ221_FIRED_TRIGGERS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    ENTRY_ID VARCHAR(95) NOT NULL,
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    INSTANCE_NAME VARCHAR(200) NOT NULL,
    FIRED_TIME BIGINT NOT NULL,
    SCHED_TIME BIGINT NOT NULL,
    PRIORITY INTEGER NOT NULL,
    STATE VARCHAR(16) NOT NULL,
    JOB_NAME VARCHAR(200) NULL,
    JOB_GROUP VARCHAR(200) NULL,
    IS_NONCONCURRENT VARCHAR(1) NULL,
    REQUESTS_RECOVERY VARCHAR(1) NULL,
    PRIMARY KEY (SCHED_NAME,ENTRY_ID)
) ENGINE=InnoDB;

CREATE TABLE QRTZ221_SCHEDULER_STATE
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    INSTANCE_NAME VARCHAR(200) NOT NULL,
    LAST_CHECKIN_TIME BIGINT NOT NULL,
    CHECKIN_INTERVAL BIGINT NOT NULL,
    PRIMARY KEY (SCHED_NAME,INSTANCE_NAME)
) ENGINE=InnoDB;

CREATE TABLE QRTZ221_LOCKS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    LOCK_NAME  VARCHAR(40) NOT NULL, 
    PRIMARY KEY (SCHED_NAME,LOCK_NAME)
) ENGINE=InnoDB;

INSERT INTO QRTZ221_LOCKS VALUES('QuartzScheduler', "TRIGGER_ACCESS");
INSERT INTO QRTZ221_LOCKS VALUES('QuartzScheduler', "JOB_ACCESS");
INSERT INTO QRTZ221_LOCKS VALUES('QuartzScheduler', "CALENDAR_ACCESS");
INSERT INTO QRTZ221_LOCKS VALUES('QuartzScheduler', "STATE_ACCESS");
INSERT INTO QRTZ221_LOCKS VALUES('QuartzScheduler', "MISFIRE_ACCESS");

create index idx_qrtz_j_req_recovery on QRTZ221_JOB_DETAILS(SCHED_NAME,REQUESTS_RECOVERY);
create index idx_qrtz_j_grp on QRTZ221_JOB_DETAILS(SCHED_NAME,JOB_GROUP);
create index idx_qrtz_t_j on QRTZ221_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP);
create index idx_qrtz_t_jg on QRTZ221_TRIGGERS(SCHED_NAME,JOB_GROUP);
create index idx_qrtz_t_c on QRTZ221_TRIGGERS(SCHED_NAME,CALENDAR_NAME);
create index idx_qrtz_t_g on QRTZ221_TRIGGERS(SCHED_NAME,TRIGGER_GROUP);
create index idx_qrtz_t_state on QRTZ221_TRIGGERS(SCHED_NAME,TRIGGER_STATE);
create index idx_qrtz_t_n_state on QRTZ221_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE);
create index idx_qrtz_t_n_g_state on QRTZ221_TRIGGERS(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE);
create index idx_qrtz_t_next_fire_time on QRTZ221_TRIGGERS(SCHED_NAME,NEXT_FIRE_TIME);
create index idx_qrtz_t_nft_st on QRTZ221_TRIGGERS(SCHED_NAME,TRIGGER_STATE,NEXT_FIRE_TIME);
create index idx_qrtz_t_nft_misfire on QRTZ221_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME);
create index idx_qrtz_t_nft_st_misfire on QRTZ221_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_STATE);
create index idx_qrtz_t_nft_st_misfire_grp on QRTZ221_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_GROUP,TRIGGER_STATE);
create index idx_qrtz_ft_trig_inst_name on QRTZ221_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME);
create index idx_qrtz_ft_inst_job_req_rcvry on QRTZ221_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME,REQUESTS_RECOVERY);
create index idx_qrtz_ft_j_g on QRTZ221_FIRED_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP);
create index idx_qrtz_ft_jg on QRTZ221_FIRED_TRIGGERS(SCHED_NAME,JOB_GROUP);
create index idx_qrtz_ft_t_g on QRTZ221_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP);
create index idx_qrtz_ft_tg on QRTZ221_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_GROUP);
-- End Quartz configuration

    create table iiqDevelopment.spt_account_group (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(128),
        description varchar(1024),
        native_identity varchar(322),
        reference_attribute varchar(128),
        member_attribute varchar(128),
        last_refresh bigint,
        last_target_aggregation bigint,
        uncorrelated bit,
        attributes longtext,
        key1 varchar(128),
        key2 varchar(128),
        key3 varchar(128),
        key4 varchar(128),
        owner varchar(32),
        assigned_scope varchar(32),
        application varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_account_group_inheritance (
       account_group varchar(32) not null,
        idx integer not null,
        inherits_from varchar(32) not null,
        primary key (account_group, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_account_group_perms (
       accountgroup varchar(32) not null,
        idx integer not null,
        target varchar(255),
        rights varchar(4000),
        annotation varchar(255),
        primary key (accountgroup, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_account_group_target_perms (
       accountgroup varchar(32) not null,
        idx integer not null,
        target varchar(255),
        rights varchar(4000),
        annotation varchar(255),
        primary key (accountgroup, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_activity_constraint (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(2000),
        description varchar(4000),
        violation_owner_type varchar(255),
        compensating_control longtext,
        disabled bit,
        weight integer,
        remediation_advice longtext,
        violation_summary longtext,
        identity_filters longtext,
        activity_filters longtext,
        time_periods longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        policy varchar(32),
        violation_owner varchar(32),
        violation_owner_rule varchar(32),
        idx integer,
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_activity_data_source (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(128) not null,
        description varchar(1024),
        collector varchar(255),
        type varchar(255),
        configuration longtext,
        last_refresh bigint,
        targets longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        correlation_rule varchar(32),
        transformation_rule varchar(32),
        application varchar(32),
        idx integer,
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_activity_time_periods (
       application_activity varchar(32) not null,
        idx integer not null,
        time_period varchar(32) not null,
        primary key (application_activity, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_alert (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        extended1 varchar(255),
        attributes longtext,
        alert_date bigint,
        native_id varchar(255),
        target_id varchar(255),
        target_type varchar(255),
        target_display_name varchar(255),
        last_processed bigint,
        display_name varchar(128),
        name varchar(255),
        type varchar(255),
        source varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_alert_action (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        alert_def longtext,
        action_type varchar(255),
        result_id varchar(255),
        result longtext,
        alert varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_alert_definition (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        match_config longtext,
        disabled bit,
        name varchar(128) not null,
        description varchar(1024),
        display_name varchar(128),
        action_config longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_app_dependencies (
       application varchar(32) not null,
        idx integer not null,
        dependency varchar(32) not null,
        primary key (application, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_application (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        extended1 varchar(450),
        extended2 varchar(450),
        extended3 varchar(450),
        extended4 varchar(450),
        name varchar(128) not null,
        proxied_name varchar(128),
        app_cluster varchar(255),
        icon varchar(255),
        connector varchar(255),
        type varchar(255),
        features_string varchar(512),
        aggregation_types varchar(128),
        profile_class varchar(255),
        authentication_resource bit,
        case_insensitive bit,
        authoritative bit,
        maintenance_expiration bigint,
        logical bit,
        supports_provisioning bit,
        supports_authenticate bit,
        supports_account_only bit,
        supports_additional_accounts bit,
        no_aggregation bit,
        sync_provisioning bit,
        attributes longtext,
        templates longtext,
        provisioning_forms longtext,
        provisioning_config longtext,
        manages_other_apps bit not null,
        managed_attr_customize_rule varchar(32),
        owner varchar(32),
        assigned_scope varchar(32),
        proxy varchar(32),
        correlation_rule varchar(32),
        creation_rule varchar(32),
        manager_correlation_rule varchar(32),
        customization_rule varchar(32),
        account_correlation_config varchar(32),
        scorecard varchar(32),
        target_source varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_application_remediators (
       application varchar(32) not null,
        idx integer not null,
        elt varchar(32) not null,
        primary key (application, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_application_activity (
       id varchar(32) not null,
        time_stamp bigint,
        source_application varchar(128),
        action varchar(255),
        result varchar(255),
        data_source varchar(128),
        instance varchar(128),
        username varchar(128),
        target varchar(128),
        info varchar(512),
        identity_id varchar(128),
        identity_name varchar(128),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_application_schema (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        owner varchar(32),
        assigned_scope varchar(32),
        assigned_scope_path varchar(450),
        name varchar(128),
        object_type varchar(255),
        aggregation_type varchar(128),
        native_object_type varchar(255),
        identity_attribute varchar(255),
        display_attribute varchar(255),
        instance_attribute varchar(255),
        description_attribute varchar(255),
        group_attribute varchar(255),
        hierarchy_attribute varchar(255),
        reference_attribute varchar(255),
        include_permissions bit,
        index_permissions bit,
        child_hierarchy bit,
        perm_remed_mod_type varchar(255),
        cloud_access_mgmt_type varchar(255),
        config longtext,
        features_string varchar(512),
        association_schema_name varchar(255),
        creation_rule varchar(32),
        customization_rule varchar(32),
        correlation_rule varchar(32),
        refresh_rule varchar(32),
        application varchar(32),
        idx integer,
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_application_scorecard (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        incomplete bit,
        composite_score integer,
        attributes longtext,
        items longtext,
        application_id varchar(32),
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_app_secondary_owners (
       application varchar(32) not null,
        idx integer not null,
        elt varchar(32) not null,
        primary key (application, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_arch_cert_item_apps (
       arch_cert_item_id varchar(32) not null,
        idx integer not null,
        application_name varchar(255),
        primary key (arch_cert_item_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_attachment (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(256),
        description varchar(256),
        content longblob,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_audit_config (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(128) not null,
        disabled bit,
        classes longtext,
        resources longtext,
        attributes longtext,
        actions longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_audit_event (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        interface varchar(128),
        source varchar(128),
        action varchar(128),
        target varchar(255),
        application varchar(128),
        account_name varchar(256),
        instance varchar(128),
        attribute_name varchar(128),
        attribute_value varchar(450),
        tracking_id varchar(128),
        attributes longtext,
        string1 varchar(450),
        string2 varchar(450),
        string3 varchar(450),
        string4 varchar(450),
        server_host varchar(128),
        client_host varchar(128),
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_authentication_answer (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        identity_id varchar(32),
        question_id varchar(32),
        answer varchar(512),
        owner varchar(32),
        idx integer,
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_authentication_question (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        question varchar(1024),
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_batch_request (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        file_name varchar(255),
        header varchar(4000),
        run_date bigint,
        completed_date bigint,
        record_count integer,
        completed_count integer,
        error_count integer,
        invalid_count integer,
        message varchar(4000),
        error_message longtext,
        file_contents longtext,
        status varchar(255),
        run_config longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_batch_request_item (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        request_data varchar(4000),
        status varchar(255),
        message varchar(4000),
        error_message longtext,
        result varchar(255),
        identity_request_id varchar(255),
        target_identity_id varchar(255),
        batch_request_id varchar(32),
        owner varchar(32),
        assigned_scope varchar(32),
        idx integer,
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_bulk_id_join (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        join_id varchar(128),
        join_property varchar(128),
        user_id varchar(128),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_bundle (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        extended1 varchar(450),
        extended2 varchar(450),
        extended3 varchar(450),
        extended4 varchar(450),
        name varchar(128) not null,
        display_name varchar(128),
        displayable_name varchar(128),
        disabled bit,
        risk_score_weight integer,
        activity_config longtext,
        mining_statistics longtext,
        attributes longtext,
        type varchar(128),
        selector longtext,
        provisioning_plan longtext,
        templates longtext,
        provisioning_forms longtext,
        or_profiles bit,
        activation_date bigint,
        deactivation_date bigint,
        pending_delete bit,
        owner varchar(32),
        assigned_scope varchar(32),
        join_rule varchar(32),
        pending_workflow varchar(32),
        role_index varchar(32),
        scorecard varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_bundle_archive (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(128),
        source_id varchar(128),
        version integer,
        creator varchar(128),
        archive longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_bundle_children (
       bundle varchar(32) not null,
        idx integer not null,
        child varchar(32) not null,
        primary key (bundle, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_bundle_permits (
       bundle varchar(32) not null,
        idx integer not null,
        child varchar(32) not null,
        primary key (bundle, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_bundle_requirements (
       bundle varchar(32) not null,
        idx integer not null,
        child varchar(32) not null,
        primary key (bundle, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_capability (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(128) not null,
        description varchar(1024),
        display_name varchar(128),
        applies_to_analyzer bit,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_capability_children (
       capability_id varchar(32) not null,
        idx integer not null,
        child_id varchar(32) not null,
        primary key (capability_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_capability_rights (
       capability_id varchar(32) not null,
        idx integer not null,
        right_id varchar(32) not null,
        primary key (capability_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_category (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(128) not null,
        targets longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_cert_action_assoc (
       parent_id varchar(32) not null,
        idx integer not null,
        child_id varchar(32) not null,
        primary key (parent_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_certification (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        attributes longtext,
        iiqlock varchar(128),
        name varchar(256),
        short_name varchar(255),
        description varchar(1024),
        creator varchar(255),
        complete bit,
        complete_hierarchy bit,
        signed bigint,
        approver_rule varchar(512),
        finished bigint,
        expiration bigint,
        automatic_closing_date bigint,
        application_id varchar(255),
        manager varchar(255),
        group_definition varchar(512),
        group_definition_id varchar(128),
        group_definition_name varchar(255),
        comments longtext,
        error longtext,
        entities_to_refresh longtext,
        commands longtext,
        activated bigint,
        total_entities integer,
        excluded_entities integer,
        completed_entities integer,
        delegated_entities integer,
        percent_complete integer,
        certified_entities integer,
        cert_req_entities integer,
        overdue_entities integer,
        total_items integer,
        excluded_items integer,
        completed_items integer,
        delegated_items integer,
        item_percent_complete integer,
        certified_items integer,
        cert_req_items integer,
        overdue_items integer,
        remediations_kicked_off integer,
        remediations_completed integer,
        total_violations integer not null,
        violations_allowed integer not null,
        violations_remediated integer not null,
        violations_acknowledged integer not null,
        total_roles integer not null,
        roles_approved integer not null,
        roles_allowed integer not null,
        roles_remediated integer not null,
        total_exceptions integer not null,
        exceptions_approved integer not null,
        exceptions_allowed integer not null,
        exceptions_remediated integer not null,
        total_grp_perms integer not null,
        grp_perms_approved integer not null,
        grp_perms_remediated integer not null,
        total_grp_memberships integer not null,
        grp_memberships_approved integer not null,
        grp_memberships_remediated integer not null,
        total_accounts integer not null,
        accounts_approved integer not null,
        accounts_allowed integer not null,
        accounts_remediated integer not null,
        total_profiles integer not null,
        profiles_approved integer not null,
        profiles_remediated integer not null,
        total_scopes integer not null,
        scopes_approved integer not null,
        scopes_remediated integer not null,
        total_capabilities integer not null,
        capabilities_approved integer not null,
        capabilities_remediated integer not null,
        total_permits integer not null,
        permits_approved integer not null,
        permits_remediated integer not null,
        total_requirements integer not null,
        requirements_approved integer not null,
        requirements_remediated integer not null,
        total_hierarchies integer not null,
        hierarchies_approved integer not null,
        hierarchies_remediated integer not null,
        type varchar(255),
        task_schedule_id varchar(255),
        trigger_id varchar(128),
        certification_definition_id varchar(128),
        phase varchar(255),
        next_phase_transition bigint,
        phase_config longtext,
        process_revokes_immediately bit,
        next_remediation_scan bigint,
        entitlement_granularity varchar(255),
        bulk_reassignment bit,
        continuous bit,
        continuous_config longtext,
        next_cert_required_scan bigint,
        next_overdue_scan bigint,
        exclude_inactive bit,
        immutable bit,
        electronically_signed bit,
        self_cert_reassignment bit,
        owner varchar(32),
        assigned_scope varchar(32),
        parent varchar(32),
        idx integer,
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_certification_def_tags (
       cert_def_id varchar(32) not null,
        idx integer not null,
        elt varchar(32) not null,
        primary key (cert_def_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_certification_groups (
       certification_id varchar(32) not null,
        idx integer not null,
        group_id varchar(32) not null,
        primary key (certification_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_certification_tags (
       certification_id varchar(32) not null,
        idx integer not null,
        elt varchar(32) not null,
        primary key (certification_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_certification_action (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        owner_name varchar(255),
        email_template varchar(255),
        comments longtext,
        expiration datetime(6),
        work_item varchar(255),
        completion_state varchar(255),
        completion_comments longtext,
        completion_user varchar(128),
        actor_name varchar(128),
        actor_display_name varchar(128),
        acting_work_item varchar(255),
        description varchar(1024),
        status varchar(255),
        decision_date bigint,
        decision_certification_id varchar(128),
        reviewed bit,
        bulk_certified bit,
        mitigation_expiration bigint,
        remediation_action varchar(255),
        remediation_details longtext,
        additional_actions longtext,
        revoke_account bit,
        ready_for_remediation bit,
        remediation_kicked_off bit,
        remediation_completed bit,
        auto_decision bit,
        owner varchar(32),
        assigned_scope varchar(32),
        source_action varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_certification_archive (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(256),
        certification_id varchar(255),
        certification_group_id varchar(255),
        signed bigint,
        expiration bigint,
        creator varchar(128),
        comments longtext,
        archive longtext,
        immutable bit,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_certification_challenge (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        owner_name varchar(255),
        email_template varchar(255),
        comments longtext,
        expiration datetime(6),
        work_item varchar(255),
        completion_state varchar(255),
        completion_comments longtext,
        completion_user varchar(128),
        actor_name varchar(128),
        actor_display_name varchar(128),
        acting_work_item varchar(255),
        description varchar(1024),
        challenged bit,
        decision varchar(255),
        decision_comments longtext,
        decider_name varchar(255),
        challenge_decision_expired bit,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_certification_definition (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(255) not null,
        description varchar(1024),
        attributes longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_certification_delegation (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        owner_name varchar(255),
        email_template varchar(255),
        comments longtext,
        expiration datetime(6),
        work_item varchar(255),
        completion_state varchar(255),
        completion_comments longtext,
        completion_user varchar(128),
        actor_name varchar(128),
        actor_display_name varchar(128),
        acting_work_item varchar(255),
        description varchar(1024),
        review_required bit,
        revoked bit,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_certification_entity (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        completed bigint,
        summary_status varchar(255),
        continuous_state varchar(255),
        last_decision bigint,
        next_continuous_state_change bigint,
        overdue_date bigint,
        has_differences bit,
        action_required bit,
        target_display_name varchar(255),
        target_name varchar(255),
        target_id varchar(255),
        custom1 varchar(450),
        custom2 varchar(450),
        custom_map longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        action varchar(32),
        delegation varchar(32),
        type varchar(255),
        bulk_certified bit,
        attributes longtext,
        identity_id varchar(450),
        firstname varchar(255),
        lastname varchar(255),
        composite_score integer,
        snapshot_id varchar(255),
        differences longtext,
        new_user bit,
        account_group varchar(450),
        application varchar(255),
        native_identity varchar(322),
        reference_attribute varchar(255),
        schema_object_type varchar(255),
        certification_id varchar(32),
        pending_certification varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_certification_group (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(256),
        type varchar(255),
        status varchar(255),
        attributes longtext,
        total_certifications integer,
        percent_complete integer,
        completed_certifications integer,
        certification_definition varchar(32),
        messages longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_certification_item (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        completed bigint,
        summary_status varchar(255),
        continuous_state varchar(255),
        last_decision bigint,
        next_continuous_state_change bigint,
        overdue_date bigint,
        has_differences bit,
        action_required bit,
        target_display_name varchar(255),
        target_name varchar(255),
        target_id varchar(255),
        custom1 varchar(450),
        custom2 varchar(450),
        custom_map longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        action varchar(32),
        delegation varchar(32),
        bundle varchar(255),
        type varchar(255),
        sub_type varchar(255),
        bundle_assignment_id varchar(128),
        certification_entity_id varchar(32),
        needs_refresh bit,
        exception_application varchar(128),
        exception_attribute_name varchar(255),
        exception_attribute_value varchar(2048),
        exception_permission_target varchar(255),
        exception_permission_right varchar(255),
        policy_violation longtext,
        violation_summary varchar(256),
        wake_up_date bigint,
        reminders_sent integer,
        needs_continuous_flush bit,
        phase varchar(255),
        next_phase_transition bigint,
        finished_date bigint,
        recommend_value varchar(100),
        attributes longtext,
        extended1 varchar(450),
        extended2 varchar(450),
        extended3 varchar(450),
        extended4 varchar(450),
        extended5 varchar(450),
        exception_entitlements varchar(32),
        challenge varchar(32),
        idx integer,
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_certifiers (
       certification_id varchar(32) not null,
        idx integer not null,
        certifier varchar(255),
        primary key (certification_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_cert_item_applications (
       certification_item_id varchar(32) not null,
        idx integer not null,
        application_name varchar(255),
        primary key (certification_item_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_cert_item_classifications (
       certification_item varchar(32),
        classification_name varchar(255)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_child_certification_ids (
       certification_archive_id varchar(32) not null,
        idx integer not null,
        child_id varchar(255),
        primary key (certification_archive_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_classification (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        name varchar(128) not null,
        display_name varchar(128),
        displayable_name varchar(128),
        attributes longtext,
        origin varchar(128),
        type varchar(128),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_cloud_access3way (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        cloud_access_group varchar(32),
        cloud_access_role varchar(32),
        cloud_access_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_cloud_access_group (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        name varchar(450) not null,
        uri varchar(450),
        display_name varchar(450),
        cloud_type varchar(80),
        event_time_stamp bigint,
        application_id varchar(32),
        object_type varchar(255),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_cloud_access_role (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        name varchar(450) not null,
        uri varchar(450),
        display_name varchar(450),
        cloud_type varchar(80),
        event_time_stamp bigint,
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_cloud_access_scope (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        name varchar(450) not null,
        uri varchar(450),
        display_name varchar(450),
        cloud_type varchar(80),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_configuration (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(128) not null,
        description varchar(1024),
        attributes longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_correlation_config (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(128) not null,
        description varchar(256),
        attribute_assignments longtext,
        direct_assignments longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_custom (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(128),
        description varchar(1024),
        attributes longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_database_version (
       name varchar(255) not null,
        system_version varchar(128),
        schema_version varchar(128),
        primary key (name)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_deleted_object (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        owner varchar(32),
        assigned_scope_path varchar(450),
        uuid varchar(128),
        name varchar(128),
        native_identity varchar(322) not null,
        last_refresh bigint,
        object_type varchar(128),
        application varchar(32),
        attributes longtext,
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_dictionary (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(128),
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_dictionary_term (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        value varchar(128) not null,
        dictionary_id varchar(32),
        owner varchar(32),
        assigned_scope varchar(32),
        idx integer,
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_dynamic_scope (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(128) not null,
        description varchar(1024),
        selector longtext,
        allow_all bit,
        population_request_authority longtext,
        managed_attr_request_control varchar(32),
        managed_attr_remove_control varchar(32),
        owner varchar(32),
        assigned_scope varchar(32),
        role_request_control varchar(32),
        application_request_control varchar(32),
        role_remove_control varchar(32),
        application_remove_control varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_dynamic_scope_exclusions (
       dynamic_scope_id varchar(32) not null,
        idx integer not null,
        identity_id varchar(32) not null,
        primary key (dynamic_scope_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_dynamic_scope_inclusions (
       dynamic_scope_id varchar(32) not null,
        idx integer not null,
        identity_id varchar(32) not null,
        primary key (dynamic_scope_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_email_template (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(128) not null,
        description varchar(1024),
        from_address varchar(255),
        to_address varchar(255),
        cc_address varchar(255),
        bcc_address varchar(255),
        subject varchar(255),
        body longtext,
        signature longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_email_template_properties (
       id varchar(32) not null,
        name varchar(78) not null,
        value varchar(255),
        primary key (id, name)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_entitlement_group (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(128),
        application varchar(32),
        instance varchar(128),
        native_identity varchar(322),
        display_name varchar(128),
        account_only bit not null,
        attributes longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        identity_id varchar(32),
        idx integer,
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_entitlement_snapshot (
       id varchar(32) not null,
        application varchar(255),
        instance varchar(128),
        native_identity varchar(322),
        display_name varchar(450),
        account_only bit not null,
        attributes longtext,
        certification_item_id varchar(32),
        idx integer,
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_file_bucket (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        file_index integer,
        parent_id varchar(32),
        data longblob,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_form (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(128) not null,
        description varchar(4000),
        hidden bit,
        type varchar(255),
        application varchar(32),
        sections longtext,
        buttons longtext,
        attributes longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_full_text_index (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        name varchar(128) not null,
        description varchar(1024),
        iiqlock varchar(128),
        last_refresh bigint,
        attributes longtext,
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_generic_constraint (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(2000),
        description varchar(4000),
        violation_owner_type varchar(255),
        compensating_control longtext,
        disabled bit,
        weight integer,
        remediation_advice longtext,
        violation_summary longtext,
        arguments longtext,
        selectors longtext,
        owner varchar(32),
        assigned_scope varchar(32),
        policy varchar(32),
        violation_owner varchar(32),
        violation_owner_rule varchar(32),
        idx integer,
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_group_definition (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(255),
        description varchar(1024),
        filter longtext,
        last_refresh bigint,
        null_group bit,
        indexed bit,
        private bit,
        factory varchar(32),
        group_index varchar(32),
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_group_factory (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        name varchar(255),
        description varchar(1024),
        factory_attribute varchar(255),
        enabled bit,
        last_refresh bigint,
        owner varchar(32),
        assigned_scope varchar(32),
        group_owner_rule varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_group_index (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        incomplete bit,
        composite_score integer,
        attributes longtext,
        items longtext,
        business_role_score integer,
        raw_business_role_score integer,
        entitlement_score integer,
        raw_entitlement_score integer,
        policy_score integer,
        raw_policy_score integer,
        certification_score integer,
        total_violations integer,
        total_remediations integer,
        total_delegations integer,
        total_mitigations integer,
        total_approvals integer,
        definition varchar(32),
        name varchar(255),
        member_count integer,
        band_count integer,
        band1 integer,
        band2 integer,
        band3 integer,
        band4 integer,
        band5 integer,
        band6 integer,
        band7 integer,
        band8 integer,
        band9 integer,
        band10 integer,
        certifications_due integer,
        certifications_on_time integer,
        owner varchar(32),
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_group_permissions (
       entitlement_group_id varchar(32) not null,
        idx integer not null,
        target varchar(255),
        annotation varchar(255),
        rights varchar(4000),
        attributes longtext,
        primary key (entitlement_group_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_identity (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        assigned_scope_path varchar(450),
        extended1 varchar(450),
        extended2 varchar(450),
        extended3 varchar(450),
        extended4 varchar(450),
        extended5 varchar(450),
        extended6 varchar(450),
        extended7 varchar(450),
        extended8 varchar(450),
        extended9 varchar(450),
        extended10 varchar(450),
		opco varchar(10),
		accountName varchar(450),
		validFrom varchar(450),
		validTo varchar(450),
		phoneNumber varchar(450),
		companyCode varchar(450),
		department varchar(450),
		title varchar(450),
		location varchar(450),
		graceDate varchar(450),
		status varchar(32),
		lifecycleState varchar(32),
        name varchar(128) not null,
        description varchar(1024),
        protected bit,
        needs_refresh bit,
        iiqlock varchar(128),
        attributes longtext,
        display_name varchar(128),
        firstname varchar(128),
        lastname varchar(128),
        email varchar(128),
        manager_status bit,
        inactive bit,
        last_login bigint,
        last_refresh bigint,
        password varchar(450),
        password_expiration bigint,
        password_history varchar(2000),
        bundle_summary varchar(2000),
        assigned_role_summary varchar(2000),
        correlated bit,
        correlated_overridden bit,
        type varchar(128),
        software_version varchar(128),
        auth_lock_start bigint,
        failed_auth_question_attempts integer,
        failed_login_attempts integer,
        controls_assigned_scope bit,
        certifications longtext,
        activity_config longtext,
        preferences longtext,
        attribute_meta_data longtext,
        workgroup bit,
        owner varchar(32),
        assigned_scope varchar(32),
        extended_identity1 varchar(32),
        extended_identity2 varchar(32),
        extended_identity3 varchar(32),
        extended_identity4 varchar(32),
        extended_identity5 varchar(32),
        manager varchar(32),
        administrator varchar(32),
        scorecard varchar(32),
        uipreferences varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_identity_archive (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        owner varchar(32),
        assigned_scope_path varchar(450),
        name varchar(128),
        source_id varchar(128),
        version integer,
        creator varchar(128),
        archive longtext,
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_identity_assigned_roles (
       identity_id varchar(32) not null,
        idx integer not null,
        bundle varchar(32) not null,
        primary key (identity_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_identity_bundles (
       identity_id varchar(32) not null,
        idx integer not null,
        bundle varchar(32) not null,
        primary key (identity_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_identity_capabilities (
       identity_id varchar(32) not null,
        idx integer not null,
        capability_id varchar(32) not null,
        primary key (identity_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_identity_controlled_scopes (
       identity_id varchar(32) not null,
        idx integer not null,
        scope_id varchar(32) not null,
        primary key (identity_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_identity_entitlement (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        owner varchar(32),
        start_date bigint,
        end_date bigint,
        attributes longtext,
        name varchar(255),
        value varchar(450),
        annotation varchar(450),
        display_name varchar(255),
        native_identity varchar(450),
        instance varchar(128),
        application varchar(32),
        identity_id varchar(32) not null,
        aggregation_state varchar(255),
        source varchar(64),
        assigned bit,
        allowed bit,
        granted_by_role bit,
        assigner varchar(128),
        assignment_id varchar(64),
        assignment_note varchar(1024),
        type varchar(255),
        request_item varchar(32),
        pending_request_item varchar(32),
        certification_item varchar(32),
        pending_certification_item varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_identity_external_attr (
       id varchar(32) not null,
        object_id varchar(64),
        attribute_name varchar(64),
        value varchar(322),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_identity_history_item (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        owner varchar(32),
        identity_id varchar(32),
        type varchar(255),
        certifiable_descriptor longtext,
        action longtext,
        certification_link longtext,
        comments longtext,
        certification_type varchar(255),
        status varchar(255),
        actor varchar(128),
        entry_date bigint,
        application varchar(128),
        instance varchar(128),
        account varchar(128),
        native_identity varchar(322),
        attribute varchar(450),
        value varchar(450),
        policy varchar(255),
        constraint_name varchar(2000),
        role varchar(255),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_identity_request (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        owner varchar(32),
        assigned_scope_path varchar(450),
        name varchar(255),
        state varchar(255),
        type varchar(255),
        source varchar(255),
        target_id varchar(128),
        target_display_name varchar(255),
        target_class varchar(255),
        requester_display_name varchar(255),
        requester_id varchar(128),
        end_date bigint,
        verified bigint,
        priority varchar(128),
        completion_status varchar(128),
        execution_status varchar(128),
        has_messages bit not null,
        external_ticket_id varchar(128),
        attributes longtext,
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_identity_request_item (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        owner varchar(32),
        start_date bigint,
        end_date bigint,
        attributes longtext,
        name varchar(255),
        value varchar(450),
        annotation varchar(450),
        display_name varchar(255),
        native_identity varchar(450),
        instance varchar(128),
        application varchar(255),
        owner_name varchar(128),
        approver_name varchar(128),
        operation varchar(128),
        retries integer,
        provisioning_engine varchar(255),
        approval_state varchar(128),
        provisioning_state varchar(128),
        compilation_status varchar(128),
        expansion_cause varchar(128),
        identity_request_id varchar(32),
        idx integer,
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_identity_role_metadata (
       identity_id varchar(32) not null,
        idx integer not null,
        role_metadata_id varchar(32) not null,
        primary key (identity_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_identity_snapshot (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        owner varchar(32),
        assigned_scope_path varchar(450),
        name varchar(128),
        identity_id varchar(255),
        identity_name varchar(255),
        summary varchar(2000),
        differences varchar(2000),
        applications varchar(2000),
        scorecard longtext,
        attributes longtext,
        bundles longtext,
        exceptions longtext,
        links longtext,
        violations longtext,
        assigned_roles longtext,
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_identity_trigger (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        owner varchar(32),
        assigned_scope_path varchar(450),
        name varchar(256),
        description varchar(1024),
        disabled bit,
        type varchar(255),
        rule_id varchar(32),
        attribute_name varchar(256),
        old_value_filter varchar(256),
        new_value_filter varchar(256),
        selector longtext,
        handler varchar(256),
        parameters longtext,
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_identity_workgroups (
       identity_id varchar(32) not null,
        idx integer not null,
        workgroup varchar(32) not null,
        primary key (identity_id, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_integration_config (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        owner varchar(32),
        assigned_scope_path varchar(450),
        name varchar(128) not null,
        description varchar(4000),
        executor varchar(255),
        exec_style varchar(255),
        role_sync_style varchar(255),
        template bit,
        maintenance_expiration bigint,
        signature longtext,
        attributes longtext,
        resources longtext,
        application_id varchar(32),
        role_sync_filter longtext,
        container_id varchar(32),
        assigned_scope varchar(32),
        plan_initializer varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_jasper_files (
       result varchar(32) not null,
        idx integer not null,
        elt varchar(32) not null,
        primary key (result, idx)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_jasper_page_bucket (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        owner varchar(32),
        assigned_scope_path varchar(450),
        bucket_number integer,
        handler_id varchar(128),
        xml longtext,
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_jasper_result (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        owner varchar(32),
        assigned_scope_path varchar(450),
        handler_id varchar(128),
        print_xml longtext,
        page_count integer,
        pages_per_bucket integer,
        handler_page_count integer,
        attributes longtext,
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_jasper_template (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        owner varchar(32),
        assigned_scope_path varchar(450),
        name varchar(128) not null,
        design_xml longtext,
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_link (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        owner varchar(32),
        assigned_scope_path varchar(450),
        key1 varchar(450),
        key2 varchar(255),
        key3 varchar(255),
        key4 varchar(255),
        extended1 varchar(450),
        extended2 varchar(450),
        extended3 varchar(450),
        extended4 varchar(450),
        extended5 varchar(450),
		opco varchar(10)
        uuid varchar(128),
        display_name varchar(128),
        instance varchar(128),
        native_identity varchar(322) not null,
        last_refresh bigint,
        last_target_aggregation bigint,
        manually_correlated bit,
        entitlements bit not null,
        identity_id varchar(32),
        application varchar(32),
        iiq_disabled bit,
        iiq_locked bit,
        attributes longtext,
        password_history varchar(2000),
        component_ids varchar(256),
        attribute_meta_data longtext,
        assigned_scope varchar(32),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_link_external_attr (
       id varchar(32) not null,
        object_id varchar(64),
        attribute_name varchar(64),
        value varchar(322),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_localized_attribute (
       id varchar(32) not null,
        created bigint,
        modified bigint,
        owner varchar(32),
        name varchar(255),
        locale varchar(128),
        attribute varchar(128),
        value varchar(1024),
        target_class varchar(255),
        target_name varchar(255),
        target_id varchar(255),
        primary key (id)
    ) engine=InnoDB;

    create table iiqDevelopment.spt_managed_attribute (
       id varchar(32) not null,
        created bigin

[sunnyajmera]

What version of the IIQ you are trying to install? Have you customized anything in the script.

Check in your script if length of any column is too big, probably over 32k. This is a problem for MySQL. if you have columns that do not need the full width, you could reduce the size by defining them with less than the default of 450 characters,

[fugitiva (Sara La Madrid)]

8.3 p3 but the coumns has 450 already some of them. Should I reduce that?

[fugitiva (Sara La Madrid)]

Its complaining about lastname

[sunnyajmera]

I dont think so, let me try your script in my env to see.

[fugitiva (Sara La Madrid)]

it was mssing a comma in a table