-- ABS-143030/ABS-147934

ALTER TABLE PLANT
   DROP CONSTRAINT KEYWORDFILEFORMAT_VALID1_1;
  
ALTER TABLE PLANT
   ADD CONSTRAINT KEYWORDFILEFORMAT_VALID1_1
  CHECK (KEYWORDFILEFORMAT BETWEEN 0 AND 3);
  
ALTER TABLE PLANTPDFEXPORT
   ADD CONSTRAINT CHK_PLANTPDFEXPORT_KEYWORDFILEFORMAT
  CHECK (KEYWORDFILEFORMAT BETWEEN 0 AND 3);

COMMENT ON COLUMN PLANTPDFEXPORT.KEYWORDFILEFORMAT
  IS  '0 = Not applicable / No keyword file
     1 = Saperion
     2 = D3
         3 = Saperion 2 (Name + Legacynr)';
     
COMMENT ON COLUMN PLANT.KEYWORDFILEFORMAT
  IS  '0 = Not applicable / No keyword file
     1 = Saperion
     2 = D3
         3 = Saperion 2 (Name + Legacynr)';