ALTER TABLE PARAMCOMPENSACAO ADD (
  DTVIGENCIA DATE DEFAULT '01/01/2017' NOT NULL, 
  IDCORRIGEMINPOR VARCHAR2(30) DEFAULT 'PERIODO' NOT NULL, 
  QTEFETMINDIASEG DOUBLE PRECISION DEFAULT NULL NULL, 
  QTEFETMINDIATER DOUBLE PRECISION DEFAULT NULL NULL, 
  QTEFETMINDIAQUA DOUBLE PRECISION DEFAULT NULL NULL, 
  QTEFETMINDIAQUI DOUBLE PRECISION DEFAULT NULL NULL, 
  QTEFETMINDIASEX DOUBLE PRECISION DEFAULT NULL NULL, 
  QTEFETMINDIASAB DOUBLE PRECISION DEFAULT NULL NULL, 
  QTEFETMINDIADOM DOUBLE PRECISION DEFAULT NULL NULL, 
  QTEFETMINDIANUTIL DOUBLE PRECISION DEFAULT NULL NULL, 
  NRDIASPERIODO NUMBER(10) DEFAULT 30 NOT NULL, 
  IDGERANFSEPARADA VARCHAR2(1) DEFAULT 'S' NOT NULL
)
/
ALTER TABLE PARAMCOMPENSACAO MODIFY (
  QTEFETMINIPERIOD DOUBLE PRECISION DEFAULT NULL NULL
)
/
ALTER TABLE PARAMCOMPENSACAO ADD CONSTRAINT CKC_IDCORRIGEMINPOR CHECK (IDCORRIGEMINPOR IN ('PERIODO', 'DIA'))
/
ALTER TABLE PARAMCOMPENSACAO ADD CONSTRAINT CKC_IDGERANFSEPARADA CHECK (IDGERANFSEPARADA IN ('S', 'N'))