--
-- 6.0.0 to 6.1.0
--
-- This is a placeholder file for the js-upgrade-samedb.sh/bat script
--

    create table JICustomDatasourceResource (
        ds_id int8 not null,
        resource_id int8 not null,
        name varchar(100) not null,
        primary key (ds_id, name)
    );

    alter table JICustomDatasourceResource
        add constraint FKDF845123858A89D1
        foreign key (ds_id)
        references JICustomDatasource;

    alter table JICustomDatasourceResource
        add constraint FKDF845123F254B53E
        foreign key (resource_id)
        references JIResource;

ALTER TABLE JIProfileAttribute ADD COLUMN description varchar(255);
ALTER TABLE JIProfileAttribute ALTER COLUMN attrValue TYPE varchar(2000);
ALTER TABLE JIProfileAttribute ALTER COLUMN attrValue DROP NOT NULL;
ALTER TABLE JIProfileAttribute ADD COLUMN owner varchar(255);

ALTER TABLE JICustomDatasourceProperty ALTER COLUMN name TYPE varchar(200);
ALTER TABLE JICustomDatasourceProperty ALTER COLUMN name SET NOT NULL;

ALTER TABLE JICustomDatasourceResource ALTER COLUMN name TYPE varchar(200);
ALTER TABLE JICustomDatasourceResource ALTER COLUMN name SET NOT NULL;

ALTER TABLE JIResource ALTER COLUMN name TYPE varchar(200);
ALTER TABLE JIResource ALTER COLUMN name SET NOT NULL;
ALTER TABLE JIResource ALTER COLUMN label TYPE varchar(200);
ALTER TABLE JIResource ALTER COLUMN label SET NOT NULL;

ALTER TABLE JIResourceFolder ALTER COLUMN name TYPE varchar(200);
ALTER TABLE JIResourceFolder ALTER COLUMN name SET NOT NULL;
ALTER TABLE JIResourceFolder ALTER COLUMN label TYPE varchar(200);
ALTER TABLE JIResourceFolder ALTER COLUMN label SET NOT NULL;

ALTER TABLE JIVirtualDataSourceUriMap ALTER COLUMN data_source_name TYPE varchar(200);
ALTER TABLE JIVirtualDataSourceUriMap ALTER COLUMN data_source_name SET NOT NULL;

ALTER TABLE JIDomainDatasourceDSRef ALTER COLUMN alias TYPE varchar(200);
ALTER TABLE JIDomainDatasourceDSRef ALTER COLUMN alias SET NOT NULL;

--
-- create indexes for foreign keys
--    

    create index idx1_adhocStateId_idx on JIAdhocDataView (adhocStateId);
    create index idx2_reportDataSource_idx on JIAdhocDataView (reportDataSource);
    create index idx3_input_ctrl_id_idx on JIAdhocDataViewInputControl (input_control_id);
    create index idx4_resource_id_idx on JIAdhocDataViewResource (resource_id);
    create index idx5_adhocStateId_idx on JIAdhocReportUnit (adhocStateId);
    create index idx6_state_id_idx on JIAdhocStateProperty (state_id);
    create index idx7_audit_event_id_idx on JIAuditEventProperty (audit_event_id);
    create index idx8_audit_event_id_idx on JIAuditEventPropertyArchive (audit_event_id);
    create index JIDashboard_adhocStateId_index on JIDashboard (adhocStateId);
    create index idx9_resource_id_idx on JIDashboardResource (resource_id);
    create index idx10_schema_id_idx on JIDomainDatasource (schema_id);
    create index idx11_security_id_idx on JIDomainDatasource (security_id);
    create index idx12_bundle_id_idx on JIDomainDatasourceBundle (bundle_id);
    create index idx13_ref_id_idx on JIDomainDatasourceDSRef (ref_id);
    create index idx14_repodest_id_idx on JIFTPInfoProperties (repodest_id);
    create index JIFileResource_reference_index on JIFileResource (reference);
    create index JIInputControl_data_type_index on JIInputControl (data_type);
    create index JIInputCtrl_list_of_values_idx on JIInputControl (list_of_values);
    create index JIInputControl_list_query_idx on JIInputControl (list_query);
    create index idx15_input_ctrl_id_idx on JIInputControlQueryColumn (input_control_id);
    create index JILogEvent_userId_index on JILogEvent (userId);
    create index idx16_mondrianSchema_idx on JIMondrianConnection (mondrianSchema);
    create index idx17_reportDataSource_idx on JIMondrianConnection (reportDataSource);
    create index idx18_accessGrant_idx on JIMondrianConnectionGrant (accessGrant);
    create index idx19_mondrianConnectionId_idx on JIMondrianConnectionGrant (mondrianConnectionId);
    create index idx21_recipientobjclass_idx on JIObjectPermission (recipientobjectclass);
    create index idx22_recipientobjid_idx on JIObjectPermission (recipientobjectid);
    create index idx23_olapClientConnection_idx on JIOlapUnit (olapClientConnection);
    create index JIQuery_dataSource_index on JIQuery (dataSource);
    create index idx24_alert_id_idx on JIReportAlertToAddress (alert_id);
    create index JIReportJob_alert_index on JIReportJob (alert);
    create index idx25_content_destination_idx on JIReportJob (content_destination);
    create index JIReportJob_job_trigger_index on JIReportJob (job_trigger);
    create index idx26_mail_notification_idx on JIReportJob (mail_notification);
    create index JIReportJob_owner_index on JIReportJob (owner);
    create index idx27_destination_id_idx on JIReportJobMailRecipient (destination_id);
    create index JIReportOptions_report_id_idx on JIReportOptions (report_id);
    create index idx28_resource_id_idx on JIReportThumbnail (resource_id);
    create index JIReportUnit_mainReport_index on JIReportUnit (mainReport);
    create index JIReportUnit_query_index on JIReportUnit (query);
    create index idx29_reportDataSource_idx on JIReportUnit (reportDataSource);
    create index idx30_input_ctrl_id_idx on JIReportUnitInputControl (input_control_id);
    create index idx31_report_unit_id_idx on JIReportUnitInputControl (report_unit_id);
    create index idx32_report_unit_id_idx on JIReportUnitResource (report_unit_id);
    create index idx33_resource_id_idx on JIReportUnitResource (resource_id);
    create index idx34_item_reference_idx on JIRepositoryCache (item_reference);
    create index JIResource_childrenFolder_idx on JIResource (childrenFolder);
    create index JIResource_parent_folder_index on JIResource (parent_folder);
    create index idx35_parent_folder_idx on JIResourceFolder (parent_folder);
    create index JIResourceFolder_version_index on JIResourceFolder (version);
    create index JIRole_tenantId_index on JIRole (tenantId);
    create index JITenant_parentId_index on JITenant (parentId);
    create index JIUser_tenantId_index on JIUser (tenantId);
    create index JIUserRole_roleId_index on JIUserRole (roleId);
    create index JIUserRole_userId_index on JIUserRole (userId);
    create index idx36_resource_id_idx on JIVirtualDataSourceUriMap (resource_id);
    create index ProfilingRecord_parent_id_idx on ProfilingRecord (parent_id);
-- 
-- additional indexes
--

create index idx20_mondrianConnection_idx on JIMondrianXMLADefinition (mondrianConnection);
create index idxA1_resource_id_idx on JICustomDatasourceResource (resource_id);
create index idxA2_resource_id_idx on JIDashboardModelResource (resource_id);
create index idxA3_report_id_idx on JIAdhocDataViewBasedReports (report_id);