--Order 20014317

alter table MULTIREADSCANBATCHCONTENTS
  drop constraint YN_VALIDATIONFIELD92;
alter table MULTIREADSCANBATCHCONTENTS
  drop constraint YN_VALIDATIONFIELD93;
alter table MULTIREADSCANBATCHCONTENTS
  drop constraint YN_VALIDATIONFIELD94;

-- replace index
drop index XIE1MULTIREADSCANCONTENTBATCH;
create index XIE1MULTIREADSCANCONTENTBATCH on MULTIREADSCANBATCHCONTENTS (MULTIREADSCANBATCH_ID, SUBBATCHNUMBER, IDCODE);

create index XIE2MULTIREADSCANCONTENTBATCH on MULTIREADSCANBATCHCONTENTS (MULTIREADSCANBATCH_ID, SUBBATCHNUMBER, UNIQUEITEM_ID);
