update Versao
set PatchVersao = 4
where versao = 3
  and subversao = 3;
  



SET TERM ^ ;

EXECUTE BLOCK AS BEGIN
  if (not exists(SELECT * FROM RDB$RELATION_FIELDS F
                 WHERE F.RDB$RELATION_NAME = 'EMPRESAS'
                   AND F.RDB$FIELD_NAME = 'TIPOCONTRIBUINTEIPI')) then
  BEGIN
    EXECUTE STATEMENT 'ALTER TABLE EMPRESAS ADD TIPOCONTRIBUINTEIPI SMALLINT DEFAULT 0 NOT NULL;';
  END

END    ^

SET TERM ; ^