
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'EST_ORC_CPL_FALTA' AND COLUMN_NAME = 'STS_ORC_FALTA')
BEGIN

ALTER TABLE dbo.EST_ORC_CPL_FALTA
   ADD STS_ORC_FALTA  INT  NOT NULL  DEFAULT( 0 )
      , MOTIVO_FALTA  VARCHAR( 200 )  NOT NULL  DEFAULT( '' )
      , DT_HR_ALT_FALTA  DATETIME  NULL
      , STS_ANALISE  INT  NOT NULL  DEFAULT( 0 )
      , MOTIVO_ANALISE  VARCHAR( 200 )  NOT NULL  DEFAULT( '' )
      , DT_HR_ALT_ANALISE  DATETIME  NULL
      , CD_USU_FALTA  INT  NULL  
      , CD_USU_ANALISE  INT  NULL 

END