--todo 9583

DROP INDEX XAK1PICKLISTLINELOCATION;


DROP INDEX XIF2PICKLISTLINELOCATION;

      
      /*
      CHANGE REPORT for Table PICKLISTLINELOCATION
          - change null constraint from NOT NULL to NULL of column STOCKROOMLOCATION_ID
      ACTION is ALTER or modify Table PICKLISTLINELOCATION
      IMPACT ANALYSIS REPORT for ALTER or modify Table PICKLISTLINELOCATION
          - index XAK1PICKLISTLINELOCATION needs to be removed in order to proceed. 
          - index XIF2PICKLISTLINELOCATION needs to be removed in order to proceed. 
      */

ALTER TABLE PICKLISTLINELOCATION MODIFY (STOCKROOMLOCATION_ID NULL);

CREATE UNIQUE INDEX XAK1PICKLISTLINELOCATION ON PICKLISTLINELOCATION
(
       PICKLISTLINE_ID                ASC,
       STOCKROOMLOCATION_ID           ASC
);

CREATE INDEX XIF2PICKLISTLINELOCATION ON PICKLISTLINELOCATION
(
       STOCKROOMLOCATION_ID           ASC
);

