--order 502615

      /*
      CHANGE REPORT for Table PLANTPRODUCTSETTINGS
          - Adding column ACTIVE
	  - Adding a new relationship PLANTPRODUCTSETTINGS_WASHINGPR
          WARNING : Create FK statement may fail (existing data may violate the new FK rules: adding a new FK PLANTPRODUCTSETTINGS_WASHINGPR of table PLANTPRODUCTSETTINGS, which references table WASHINGPROCESS).
          - Adding column WASHINGPROCESS_ID
          - Adding index XIF4PLANTPRODUCTSETTINGS
      ACTION is ALTER or modify Table PLANTPRODUCTSETTINGS
      */

ALTER TABLE PLANTPRODUCTSETTINGS ADD (ACTIVE               VARCHAR2(1) DEFAULT 
    'Y' NOT NULL
                                   CONSTRAINT YN_ValidationNew185
                                          CHECK (ACTIVE IN ('Y', 'N')));

ALTER TABLE PLANTPRODUCTSETTINGS ADD (WASHINGPROCESS_ID    NUMBER NULL);

CREATE INDEX XIF4PLANTPRODUCTSETTINGS ON PLANTPRODUCTSETTINGS
(
       WASHINGPROCESS_ID              ASC
);


ALTER TABLE PLANTPRODUCTSETTINGS
       ADD  ( CONSTRAINT PLANTPRODUCTSETTINGS_WASHINGPR
              FOREIGN KEY (WASHINGPROCESS_ID)
                             REFERENCES WASHINGPROCESS ) ;
