drop INDEX idx19_mondrianConnectionId_idx ON JIMondrianConnectionGrant;
drop INDEX idx18_accessGrant_idx ON JIMondrianConnectionGrant;
drop INDEX idx17_reportDataSource_idx ON JIMondrianConnection;
drop INDEX idx16_mondrianSchema_idx ON JIMondrianConnection;
drop INDEX JIQuery_dataSource_index ON JIQuery;
drop INDEX idx5_adhocStateId_idx ON JIAdhocReportUnit;
drop INDEX idx33_resource_id_idx ON JIReportUnitResource;
drop INDEX idx32_report_unit_id_idx ON JIReportUnitResource;
drop INDEX idx31_report_unit_id_idx ON JIReportUnitInputControl;
drop INDEX idx30_input_ctrl_id_idx ON JIReportUnitInputControl;
drop INDEX idx29_reportDataSource_idx ON JIReportUnit;
drop INDEX JIReportUnit_query_index ON JIReportUnit;
drop INDEX JIReportUnit_mainReport_index ON JIReportUnit;
drop INDEX idxA1_resource_id_idx on JICustomDatasourceResource;
drop INDEX idx13_ref_id_idx ON JIDomainDatasourceDSRef;
drop INDEX idx12_bundle_id_idx ON JIDomainDatasourceBundle;
drop INDEX idx15_input_ctrl_id_idx ON JIInputControlQueryColumn;
drop INDEX JIInputControl_list_query_idx ON JIInputControl;
drop INDEX JIInputCtrl_list_of_values_idx ON JIInputControl;
drop INDEX JIInputControl_data_type_index ON JIInputControl;
drop INDEX idx23_olapClientConnection_idx ON JIOlapUnit;
drop INDEX JIFileResource_reference_index ON JIFileResource;
drop INDEX idx20_mondrianConnection_idx ON JIMondrianXMLADefinition;
drop INDEX ProfilingRecord_parent_id_idx ON ProfilingRecord;
drop INDEX JIReportOptions_report_id_idx ON JIReportOptions;
drop INDEX idx8_audit_event_id_idx ON JIAuditEventPropertyArchive;
drop INDEX idx7_audit_event_id_idx ON JIAuditEventProperty;
drop INDEX idxA2_resource_id_idx on JIDashboardModelResource;
drop INDEX idx11_security_id_idx ON JIDomainDatasource;
drop INDEX idx10_schema_id_idx ON JIDomainDatasource;
drop INDEX idx9_resource_id_idx ON JIDashboardResource;
drop INDEX JIDashboard_adhocStateId_index ON JIDashboard;
drop INDEX idx6_state_id_idx ON JIAdhocStateProperty;
drop INDEX idxA3_report_id_idx on JIAdhocDataViewBasedReports;
drop INDEX idx4_resource_id_idx ON JIAdhocDataViewResource;
drop INDEX idx3_input_ctrl_id_idx ON JIAdhocDataViewInputControl;
drop INDEX idx2_reportDataSource_idx ON JIAdhocDataView;
drop INDEX idx1_adhocStateId_idx ON JIAdhocDataView;
drop INDEX JIUser_tenantId_index ON JIUser;
drop INDEX JITenant_parentId_index ON JITenant;
drop INDEX JIUserRole_userId_index ON JIUserRole;
drop INDEX JIUserRole_roleId_index ON JIUserRole;
drop INDEX JIRole_tenantId_index ON JIRole;
drop INDEX idx22_recipientobjid_idx ON JIObjectPermission;
drop INDEX idx21_recipientobjclass_idx ON JIObjectPermission;
drop INDEX uri_index ON JIObjectPermission;
drop INDEX idx36_resource_id_idx ON JIVirtualDataSourceUriMap;
drop INDEX JIResource_parent_folder_index ON JIResource;
drop INDEX JIResource_childrenFolder_idx ON JIResource;
drop INDEX idx28_resource_id_idx ON JIReportThumbnail;
drop INDEX JIResourceFolder_version_index ON JIResourceFolder;
drop INDEX idx35_parent_folder_idx ON JIResourceFolder;
drop INDEX idx34_item_reference_idx ON JIRepositoryCache;
drop INDEX idx14_repodest_id_idx ON JIFTPInfoProperties;
drop INDEX idx27_destination_id_idx ON JIReportJobMailRecipient;
drop INDEX idx24_alert_id_idx ON JIReportAlertToAddress;
drop INDEX JIReportJob_owner_index ON JIReportJob;
drop INDEX idx26_mail_notification_idx ON JIReportJob;
drop INDEX JIReportJob_job_trigger_index ON JIReportJob;
drop INDEX idx25_content_destination_idx ON JIReportJob;
drop INDEX JIReportJob_alert_index ON JIReportJob;
drop INDEX JILogEvent_userId_index ON JILogEvent;
alter table JIAccessEvent drop foreign key FK47FB3CD732282198;
alter table JIAccessEvent drop foreign key FK47FB3CD7F254B53E;
alter table JIAdhocDataView drop foreign key FK200A2AC9A8BF376D;
alter table JIAdhocDataView drop foreign key FK200A2AC9324CFECB;
alter table JIAdhocDataView drop foreign key FK200A2AC931211827;
alter table JIAdhocDataViewBasedReports drop foreign key FKFFD9AFF5B22FF3B2;
alter table JIAdhocDataViewBasedReports drop foreign key FKFFD9AFF5830BA6DB;
alter table JIAdhocDataViewInputControl drop foreign key FKA248C79CB22FF3B2;
alter table JIAdhocDataViewInputControl drop foreign key FKA248C79CE7922149;
alter table JIAdhocDataViewResource drop foreign key FK98179F7B22FF3B2;
alter table JIAdhocDataViewResource drop foreign key FK98179F7865B10DA;
alter table JIAdhocReportUnit drop foreign key FK68AE6BB2981B13F0;
alter table JIAdhocReportUnit drop foreign key FK68AE6BB231211827;
alter table JIAdhocStateProperty drop foreign key FK2C7E3C6C298B519D;
alter table JIAuditEventProperty drop foreign key FK3429FE136F667020;
alter table JIAuditEventPropertyArchive drop foreign key FKD2940F2F637AC28A;
alter table JIAwsDatasource drop foreign key FK6085542387E4472B;
alter table JIAzureSqlDatasource drop foreign key FKAFE22203C001BAEA;
alter table JIAzureSqlDatasource drop foreign key FKAFE2220387E4472B;
alter table JIBeanDatasource drop foreign key FK674BF34A8BF376D;
alter table JIContentResource drop foreign key FKE466FC68A8BF376D;
alter table JICustomDatasource drop foreign key FK2BBCEDF5A8BF376D;
alter table JICustomDatasourceProperty drop foreign key FKB8A66AEA858A89D1;
alter table JICustomDatasourceResource drop foreign key FKDF845123858A89D1;
alter table JICustomDatasourceResource drop foreign key FKDF845123F254B53E;
alter table JIDashboard drop foreign key FKEC09F815A8BF376D;
alter table JIDashboard drop foreign key FKEC09F81531211827;
alter table JIDashboardFrameProperty drop foreign key FK679EF04DFA08F0B4;
alter table JIDashboardModel drop foreign key FK8BB7D814A8BF376D;
alter table JIDashboardModelResource drop foreign key FK273EAC4230711005;
alter table JIDashboardModelResource drop foreign key FK273EAC42F254B53E;
alter table JIDashboardResource drop foreign key FK37B53B43326276AC;
alter table JIDashboardResource drop foreign key FK37B53B43F254B53E;
alter table JIDataDefinerUnit drop foreign key FK1EC11AF2981B13F0;
alter table JIDataSnapshotParameter drop foreign key id_fk_idx;
alter table JIDataType drop foreign key FK533BCC63A8BF376D;
alter table JIDomainDatasource drop foreign key FK59F8EB88A8BF376D;
alter table JIDomainDatasource drop foreign key FK59F8EB88992A3868;
alter table JIDomainDatasource drop foreign key FK59F8EB8833A6D267;
alter table JIDomainDatasourceBundle drop foreign key FKE9F0422AE494DFE6;
alter table JIDomainDatasourceBundle drop foreign key FKE9F0422ACB906E03;
alter table JIDomainDatasourceDSRef drop foreign key FKFDA42FCCB906E03;
alter table JIDomainDatasourceDSRef drop foreign key FKFDA42FC7106B699;
alter table JIFTPInfoProperties drop foreign key FK6BD68B04D5FA3F0A;
alter table JIFileResource drop foreign key FKF75B5889A8BF376D;
alter table JIFileResource drop foreign key FKF75B58895A0C539;
alter table JIInputControl drop foreign key FKCAC6A512120E06F7;
alter table JIInputControl drop foreign key FKCAC6A512A8BF376D;
alter table JIInputControl drop foreign key FKCAC6A51262A86F04;
alter table JIInputControl drop foreign key FKCAC6A512B37DB6EB;
alter table JIInputControlQueryColumn drop foreign key FKE436A5CCE7922149;
alter table JIJNDIJdbcDatasource drop foreign key FK7F9DA248A8BF376D;
alter table JIJdbcDatasource drop foreign key FKC8BDFCBFA8BF376D;
alter table JIListOfValues drop foreign key FK4E86A776A8BF376D;
alter table JIListOfValuesItem drop foreign key FKD37CEBA993F0E1F6;
alter table JILogEvent drop foreign key FK5F32081591865AF;
alter table JIMondrianConnection drop foreign key FK4FF53B191D51BFAD;
alter table JIMondrianConnection drop foreign key FK4FF53B19324CFECB;
alter table JIMondrianConnection drop foreign key FK4FF53B19C495A60B;
alter table JIMondrianConnectionGrant drop foreign key FK3DDE9D8346D80AD2;
alter table JIMondrianConnectionGrant drop foreign key FK3DDE9D83FFAC5026;
alter table JIMondrianXMLADefinition drop foreign key FK313B2AB8A8BF376D;
alter table JIMondrianXMLADefinition drop foreign key FK313B2AB8801D6C37;
alter table JIOlapClientConnection drop foreign key FK3CA3B7D4A8BF376D;
alter table JIOlapUnit drop foreign key FKF034DCCFA8BF376D;
alter table JIOlapUnit drop foreign key FKF034DCCF8F542247;
alter table JIQuery drop foreign key FKCBCB0EC9A8BF376D;
alter table JIQuery drop foreign key FKCBCB0EC92B329A97;
alter table JIReportAlertToAddress drop foreign key FKC4E3713022FA4CBA;
alter table JIReportJob drop foreign key FK156F5F6AE4D73E35;
alter table JIReportJob drop foreign key FK156F5F6AC83ABB38;
alter table JIReportJob drop foreign key FK156F5F6A9EEC902C;
alter table JIReportJob drop foreign key FK156F5F6A74D2696E;
alter table JIReportJob drop foreign key FK156F5F6AFF0F459F;
alter table JIReportJob drop foreign key FK156F5F6A4141263C;
alter table JIReportJobCalendarTrigger drop foreign key FKC374C7D0D2B2EB53;
alter table JIReportJobMailRecipient drop foreign key FKBB6DB6D880001AAE;
alter table JIReportJobOutputFormat drop foreign key FKB42A5CE2C3389A8;
alter table JIReportJobParameter drop foreign key FKEAC52B5F2EC643D;
alter table JIReportJobRepoDest drop foreign key FKEA477EBE3C5B87D0;
alter table JIReportJobSimpleTrigger drop foreign key FKB9337C5CD2B2EB53;
alter table JIReportOptions drop foreign key resource_id;
alter table JIReportOptions drop foreign key report_fk;
alter table JIReportOptionsInput drop foreign key options_fk;
alter table JIReportThumbnail drop foreign key FKFDB3DED932282198;
alter table JIReportThumbnail drop foreign key FKFDB3DED9F254B53E;
alter table JIReportUnit drop foreign key FK98818B77A8BF376D;
alter table JIReportUnit drop foreign key FK98818B778FDA11CC;
alter table JIReportUnit drop foreign key FK98818B77324CFECB;
alter table JIReportUnit drop foreign key FK98818B778C8DF21B;
alter table JIReportUnitInputControl drop foreign key FK5FBE934AE7922149;
alter table JIReportUnitInputControl drop foreign key FK5FBE934AA6A48880;
alter table JIReportUnitResource drop foreign key FK8B1C4CA5A6A48880;
alter table JIReportUnitResource drop foreign key FK8B1C4CA5865B10DA;
alter table JIRepositoryCache drop foreign key FKE7338B19E7C5A6;
alter table JIResource drop foreign key FKD444826DA58002DF;
alter table JIResource drop foreign key FKD444826DA08E2155;
alter table JIResourceFolder drop foreign key FK7F24453BA08E2155;
alter table JIRole drop foreign key FK82724655E415AC2D;
alter table JITenant drop foreign key FKB1D7B2C97803CC2D;
alter table JIUser drop foreign key FK8273B1AAE415AC2D;
alter table JIUserRole drop foreign key FKD8B5C1403C31045;
alter table JIUserRole drop foreign key FKD8B5C14091865AF;
alter table JIVirtualDataSourceUriMap drop foreign key FK4A6CCE019E600E20;
alter table JIVirtualDataSourceUriMap drop foreign key FK4A6CCE01F254B53E;
alter table JIVirtualDatasource drop foreign key FK30E55631A8BF376D;
alter table JIXMLAConnection drop foreign key FK94C688A71D51BFAD;
alter table ProfilingRecord drop foreign key FK92D5BBF7DACDD6DA;
drop table JIAccessEvent;
drop table JIAdhocDataView;
drop table JIAdhocDataViewBasedReports;
drop table JIAdhocDataViewInputControl;
drop table JIAdhocDataViewResource;
drop table JIAdhocReportUnit;
drop table JIAdhocState;
drop table JIAdhocStateProperty;
drop table JIAuditEvent;
drop table JIAuditEventArchive;
drop table JIAuditEventProperty;
drop table JIAuditEventPropertyArchive;
drop table JIAwsDatasource;
drop table JIAzureSqlDatasource;
drop table JIBeanDatasource;
drop table JIContentResource;
drop table JICustomDatasource;
drop table JICustomDatasourceProperty;
drop table JICustomDatasourceResource;
drop table JIDashboard;
drop table JIDashboardFrameProperty;
drop table JIDashboardModel;
drop table JIDashboardModelResource;
drop table JIDashboardResource;
drop table JIDataDefinerUnit;
drop table JIDataSnapshot;
drop table JIDataSnapshotContents;
drop table JIDataSnapshotParameter;
drop table JIDataType;
drop table JIDomainDatasource;
drop table JIDomainDatasourceBundle;
drop table JIDomainDatasourceDSRef;
drop table JIFTPInfoProperties;
drop table JIFileResource;
drop table JIInputControl;
drop table JIInputControlQueryColumn;
drop table JIJNDIJdbcDatasource;
drop table JIJdbcDatasource;
drop table JIListOfValues;
drop table JIListOfValuesItem;
drop table JILogEvent;
drop table JIMondrianConnection;
drop table JIMondrianConnectionGrant;
drop table JIMondrianXMLADefinition;
drop table JIObjectPermission;
drop table JIOlapClientConnection;
drop table JIOlapUnit;
drop table JIProfileAttribute;
drop table JIQuery;
drop table JIReportAlertToAddress;
drop table JIReportJob;
drop table JIReportJobAlert;
drop table JIReportJobCalendarTrigger;
drop table JIReportJobMail;
drop table JIReportJobMailRecipient;
drop table JIReportJobOutputFormat;
drop table JIReportJobParameter;
drop table JIReportJobRepoDest;
drop table JIReportJobSimpleTrigger;
drop table JIReportJobTrigger;
drop table JIReportMonitoringFact;
drop table JIReportOptions;
drop table JIReportOptionsInput;
drop table JIReportThumbnail;
drop table JIReportUnit;
drop table JIReportUnitInputControl;
drop table JIReportUnitResource;
drop table JIRepositoryCache;
drop table JIResource;
drop table JIResourceFolder;
drop table JIRole;
drop table JITenant;
drop table JIUser;
drop table JIUserRole;
drop table JIVirtualDataSourceUriMap;
drop table JIVirtualDatasource;
drop table JIXMLAConnection;
drop table ProfilingRecord;
DROP TABLE QRTZ_FIRED_TRIGGERS;
DROP TABLE QRTZ_PAUSED_TRIGGER_GRPS;
DROP TABLE QRTZ_SCHEDULER_STATE;
DROP TABLE QRTZ_LOCKS;
DROP TABLE QRTZ_SIMPLE_TRIGGERS;
DROP TABLE QRTZ_SIMPROP_TRIGGERS;
DROP TABLE QRTZ_CRON_TRIGGERS;
DROP TABLE QRTZ_BLOB_TRIGGERS;
DROP TABLE QRTZ_TRIGGERS;
DROP TABLE QRTZ_JOB_DETAILS;
DROP TABLE QRTZ_CALENDARS;