--todo 9564

/*
      CHANGE REPORT for Table FINISHINGMETHOD
          - Adding column EMBLEMDEFAULT
      ACTION is ALTER or modify Table FINISHINGMETHOD
      */

ALTER TABLE FINISHINGMETHOD ADD (EMBLEMDEFAULT        VARCHAR2(1) DEFAULT 'N' 
    NOT NULL
                                   CONSTRAINT YN_ValidationField9
                                          CHECK (EMBLEMDEFAULT IN ('Y', 'N')));

UPDATE FINISHINGMETHOD FM
SET FM.EMBLEMDEFAULT = 'Y'
WHERE FM.FINISHINGMETHOD_ID = (SELECT MIN(FM2.FINISHINGMETHOD_ID)
                               FROM FINISHINGMETHOD FM2);

commit;