-- ABS-155712 ORA-00060 deadlocks in Oracle production instance / ABS-163303 ABSSolute ELI - Blocking sessions
alter table MULTIREADSCANBATCHCONTENTS add (IDCODEREAD VARCHAR2(24) default '-' not null);

update MULTIREADSCANBATCHCONTENTS M set M.IDCODEREAD = M.IDCODE;
commit;

drop index XAK1MULTIREADSCANBATCHCONTENTS;

drop index XAK2MULTIREADSCANBATCHCONTENTS;


create unique index XAK1MULTIREADSCANBATCHCONTENTS on MULTIREADSCANBATCHCONTENTS (IDCODEREAD asc, TIMEFRAMEINITIAL asc);

create unique index XAK2MULTIREADSCANBATCHCONTENTS on MULTIREADSCANBATCHCONTENTS (IDCODEREAD asc, TIMEFRAMEFINAL asc);

