409 lines
10 KiB
SQL
Executable File
409 lines
10 KiB
SQL
Executable File
|
|
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 JIFileResource_reference_index ON JIFileResource;
|
|
|
|
DROP INDEX JIQuery_dataSource_index ON JIQuery;
|
|
|
|
DROP INDEX idx23_olapClientConnection_idx ON JIOlapUnit;
|
|
|
|
DROP INDEX idx17_reportDataSource_idx ON JIMondrianConnection;
|
|
|
|
DROP INDEX idx16_mondrianSchema_idx ON JIMondrianConnection;
|
|
|
|
DROP INDEX idx20_mondrianConnection_idx ON JIMondrianXMLADefinition;
|
|
|
|
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 idxA1_resource_id_idx on JICustomDatasourceResource;
|
|
|
|
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 constraint FK47FB3CD732282198;
|
|
|
|
alter table JIAccessEvent
|
|
drop constraint FK47FB3CD7F254B53E;
|
|
|
|
alter table JIAwsDatasource
|
|
drop constraint FK6085542387E4472B;
|
|
|
|
alter table JIAzureSqlDatasource
|
|
drop constraint FKAFE22203C001BAEA;
|
|
|
|
alter table JIAzureSqlDatasource
|
|
drop constraint FKAFE2220387E4472B;
|
|
|
|
alter table JIBeanDatasource
|
|
drop constraint FK674BF34A8BF376D;
|
|
|
|
alter table JIContentResource
|
|
drop constraint FKE466FC68A8BF376D;
|
|
|
|
alter table JICustomDatasource
|
|
drop constraint FK2BBCEDF5A8BF376D;
|
|
|
|
alter table JICustomDatasourceProperty
|
|
drop constraint FKB8A66AEA858A89D1;
|
|
|
|
alter table JICustomDatasourceResource
|
|
drop constraint FKDF845123F254B53E;
|
|
|
|
alter table JICustomDatasourceResource
|
|
drop constraint FKDF845123858A89D1;
|
|
|
|
alter table JIDataSnapshotParameter
|
|
drop constraint id_fk_idx;
|
|
|
|
alter table JIDataType
|
|
drop constraint FK533BCC63A8BF376D;
|
|
|
|
alter table JIFTPInfoProperties
|
|
drop constraint FK6BD68B04D5FA3F0A;
|
|
|
|
alter table JIFileResource
|
|
drop constraint FKF75B58895A0C539;
|
|
|
|
alter table JIFileResource
|
|
drop constraint FKF75B5889A8BF376D;
|
|
|
|
alter table JIInputControl
|
|
drop constraint FKCAC6A512B37DB6EB;
|
|
|
|
alter table JIInputControl
|
|
drop constraint FKCAC6A512120E06F7;
|
|
|
|
alter table JIInputControl
|
|
drop constraint FKCAC6A512A8BF376D;
|
|
|
|
alter table JIInputControl
|
|
drop constraint FKCAC6A51262A86F04;
|
|
|
|
alter table JIInputControlQueryColumn
|
|
drop constraint FKE436A5CCE7922149;
|
|
|
|
alter table JIJNDIJdbcDatasource
|
|
drop constraint FK7F9DA248A8BF376D;
|
|
|
|
alter table JIJdbcDatasource
|
|
drop constraint FKC8BDFCBFA8BF376D;
|
|
|
|
alter table JIListOfValues
|
|
drop constraint FK4E86A776A8BF376D;
|
|
|
|
alter table JIListOfValuesItem
|
|
drop constraint FKD37CEBA993F0E1F6;
|
|
|
|
alter table JILogEvent
|
|
drop constraint FK5F32081591865AF;
|
|
|
|
alter table JIMondrianConnection
|
|
drop constraint FK4FF53B19324CFECB;
|
|
|
|
alter table JIMondrianConnection
|
|
drop constraint FK4FF53B191D51BFAD;
|
|
|
|
alter table JIMondrianConnection
|
|
drop constraint FK4FF53B19C495A60B;
|
|
|
|
alter table JIMondrianXMLADefinition
|
|
drop constraint FK313B2AB8A8BF376D;
|
|
|
|
alter table JIMondrianXMLADefinition
|
|
drop constraint FK313B2AB8DC098B1;
|
|
|
|
alter table JIOlapClientConnection
|
|
drop constraint FK3CA3B7D4A8BF376D;
|
|
|
|
alter table JIOlapUnit
|
|
drop constraint FKF034DCCF8F542247;
|
|
|
|
alter table JIOlapUnit
|
|
drop constraint FKF034DCCFA8BF376D;
|
|
|
|
alter table JIQuery
|
|
drop constraint FKCBCB0EC92B329A97;
|
|
|
|
alter table JIQuery
|
|
drop constraint FKCBCB0EC9A8BF376D;
|
|
|
|
alter table JIReportAlertToAddress
|
|
drop constraint FKC4E3713022FA4CBA;
|
|
|
|
alter table JIReportJob
|
|
drop constraint FK156F5F6A4141263C;
|
|
|
|
alter table JIReportJob
|
|
drop constraint FK156F5F6A9EEC902C;
|
|
|
|
alter table JIReportJob
|
|
drop constraint FK156F5F6AE4D73E35;
|
|
|
|
alter table JIReportJob
|
|
drop constraint FK156F5F6AC83ABB38;
|
|
|
|
alter table JIReportJob
|
|
drop constraint FK156F5F6A74D2696E;
|
|
|
|
alter table JIReportJob
|
|
drop constraint FK156F5F6AFF0F459F;
|
|
|
|
alter table JIReportJobCalendarTrigger
|
|
drop constraint FKC374C7D0D2B2EB53;
|
|
|
|
alter table JIReportJobMailRecipient
|
|
drop constraint FKBB6DB6D880001AAE;
|
|
|
|
alter table JIReportJobOutputFormat
|
|
drop constraint FKB42A5CE2C3389A8;
|
|
|
|
alter table JIReportJobParameter
|
|
drop constraint FKEAC52B5F2EC643D;
|
|
|
|
alter table JIReportJobRepoDest
|
|
drop constraint FKEA477EBE3C5B87D0;
|
|
|
|
alter table JIReportJobSimpleTrigger
|
|
drop constraint FKB9337C5CD2B2EB53;
|
|
|
|
alter table JIReportThumbnail
|
|
drop constraint FKFDB3DED932282198;
|
|
|
|
alter table JIReportThumbnail
|
|
drop constraint FKFDB3DED9F254B53E;
|
|
|
|
alter table JIReportUnit
|
|
drop constraint FK98818B77324CFECB;
|
|
|
|
alter table JIReportUnit
|
|
drop constraint FK98818B778C8DF21B;
|
|
|
|
alter table JIReportUnit
|
|
drop constraint FK98818B778FDA11CC;
|
|
|
|
alter table JIReportUnit
|
|
drop constraint FK98818B77A8BF376D;
|
|
|
|
alter table JIReportUnitInputControl
|
|
drop constraint FK5FBE934AA6A48880;
|
|
|
|
alter table JIReportUnitInputControl
|
|
drop constraint FK5FBE934AE7922149;
|
|
|
|
alter table JIReportUnitResource
|
|
drop constraint FK8B1C4CA5A6A48880;
|
|
|
|
alter table JIReportUnitResource
|
|
drop constraint FK8B1C4CA5865B10DA;
|
|
|
|
alter table JIRepositoryCache
|
|
drop constraint FKE7338B19E7C5A6;
|
|
|
|
alter table JIResource
|
|
drop constraint FKD444826DA08E2155;
|
|
|
|
alter table JIResource
|
|
drop constraint FKD444826DA58002DF;
|
|
|
|
alter table JIResourceFolder
|
|
drop constraint FK7F24453BA08E2155;
|
|
|
|
alter table JIRole
|
|
drop constraint FK82724655E415AC2D;
|
|
|
|
alter table JITenant
|
|
drop constraint FKB1D7B2C97803CC2D;
|
|
|
|
alter table JIUser
|
|
drop constraint FK8273B1AAE415AC2D;
|
|
|
|
alter table JIUserRole
|
|
drop constraint FKD8B5C1403C31045;
|
|
|
|
alter table JIUserRole
|
|
drop constraint FKD8B5C14091865AF;
|
|
|
|
alter table JIVirtualDataSourceUriMap
|
|
drop constraint FK4A6CCE01F254B53E;
|
|
|
|
alter table JIVirtualDataSourceUriMap
|
|
drop constraint FK4A6CCE019E600E20;
|
|
|
|
alter table JIVirtualDatasource
|
|
drop constraint FK30E55631A8BF376D;
|
|
|
|
alter table JIXMLAConnection
|
|
drop constraint FK94C688A71D51BFAD;
|
|
|
|
drop table JIAccessEvent;
|
|
|
|
drop table JIAwsDatasource;
|
|
|
|
drop table JIAzureSqlDatasource;
|
|
|
|
drop table JIBeanDatasource;
|
|
|
|
drop table JIContentResource;
|
|
|
|
drop table JICustomDatasource;
|
|
|
|
drop table JICustomDatasourceProperty;
|
|
|
|
drop table JICustomDatasourceResource;
|
|
|
|
drop table JIDataSnapshot;
|
|
|
|
drop table JIDataSnapshotContents;
|
|
|
|
drop table JIDataSnapshotParameter;
|
|
|
|
drop table JIDataType;
|
|
|
|
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 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 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 sequence hibernate_sequence;
|