--ABS-101306/ABS-105913

-----------------------SOILCOUNT
DROP INDEX XAK1SOILCOUNT;

CREATE UNIQUE INDEX XAK1SOILCOUNT ON SOILCOUNT
(DISTRIBUTIONPOINT_LINK_ID ASC, COUNTDATE ASC, PROCESSBUSINESSUNIT_ID ASC, BAGTAG_ID ASC, REFERENCENUMBER ASC);

DROP INDEX XIF3SOILCOUNT;

ALTER TABLE SOILCOUNT DROP CONSTRAINT FK_SOILCOUNT_BU;

ALTER TABLE SOILCOUNT DROP COLUMN INTERNALPROCESSINGBU_ID;




