/*ORDER 502354*/      
      /*
      CHANGE REPORT for Table FLAG
          - Adding a new relationship FLAG_REASONCODE_ID
          WARNING : Create FK statement may fail (existing data may violate the new FK rules: adding a new FK FLAG_REASONCODE_ID of table FLAG, which references table REASONCODE).
          - Adding column REASONCODE_ID
      ACTION is ALTER or modify Table FLAG
      */


ALTER TABLE FLAG ADD (DEFAULTREASONCODE_ID NUMBER NULL);


CREATE INDEX XIF1FLAG ON FLAG
(
       DEFAULTREASONCODE_ID                  ASC
);



ALTER TABLE FLAG
       ADD  ( CONSTRAINT FLAG_DEFAULTREASONCODE_ID
              FOREIGN KEY (DEFAULTREASONCODE_ID)
                             REFERENCES REASONCODE ) ;

