; DROP INDEX IDX_BY_ASSETVERID_PROPID; DROP INDEX IDX_BY_USERID_SYSPERM; alter table OR_ASSETTYPE drop constraint FK_ASSETTYPE_REF_AV; alter table OR_ASSETTYPE drop constraint FK_ASSETTYPE_REF_ASSETTYPE; alter table OR_ASSETVERSION drop constraint FK_ASSETVERSION_REF_ASSET; alter table OR_ASSETVERSION drop constraint FK_
CREATE INDEX IDX_BY_USERID_ASSETPERM ON OR_ASSET_PERMISSION (USERID); CREATE INDEX IDX_BY_ASSETID_VERSION ON OR_ASSETVERSION (ASSET_ID, VERSION); CREATE INDEX IDX_BY_AUDITENTRYID_ASSET ON OR_AUDITASSETCHANGE (AUDITENTRY_ID);
ID as LOCK5_1_0_, av.DELETED as DELETED1_0_, av.PURGED as PURGED1_0_, av.ASSET_ID as ASSET8_1_0_, av.DELETED_TIME as DELETED9_1_0_, av.ASSETTYPE_ID as ASSETTYPE10_1_0_ FROM OR_ASSETVERSION
ae.AUDITENTRY_ID IN \n (\n SELECT DISTINCT ac.AUDITENTRY_ID\n FROM OR_AUDITASSETCHANGE ac, OR_ASSETVERSION av, OR_ASSET a\n WHERE av.ASSETVERSION_ID = ac.ASSETVERSION_ID AND a.ASSET_UUID IN () \n AND av.ASSET_ID = a.ASSET_ID\n AND a.NAMESPACE = ?\n
