--order 502631      
      /*
      CHANGE REPORT for Table AUTOMATICFLAG
          - Adding column DELETABLE
          - Adding column TRANSFERABLE
      ACTION is ALTER or modify Table AUTOMATICFLAG
      */

ALTER TABLE AUTOMATICFLAG ADD (DELETABLE            VARCHAR2(1) DEFAULT 'N' NOT 
    NULL
                                   CONSTRAINT YN_ValidationNew186
                                          CHECK (DELETABLE IN ('Y', 'N')));


ALTER TABLE AUTOMATICFLAG ADD (TRANSFERABLE         VARCHAR2(1) DEFAULT 'N' NOT 
    NULL
                                   CONSTRAINT YN_ValidationNew187
                                          CHECK (TRANSFERABLE IN ('Y', 'N')));

update automaticflag a set a.deletable = 'N' , a.transferable = 'Y'
where a.automaticflag_id in (1,6,8,13,18);

commit;

update automaticflag a set a.deletable = 'Y' , a.transferable = 'Y'
where a.automaticflag_id in (2,3,11,16,17,19);

commit;

update automaticflag a set a.deletable = 'N' , a.transferable = 'N'
where a.automaticflag_id in (4,5,7,9,10,12,14,15);

commit;

      
      /*
      CHANGE REPORT for Table FLAG
          - Adding column TRANSFER
      ACTION is ALTER or modify Table FLAG
      */

ALTER TABLE FLAG ADD (TRANSFER             NUMBER DEFAULT 0 NOT NULL
                                   CONSTRAINT Transfer_valid
                                          CHECK (TRANSFER IN (0, 1, 2, 3)));

