if not exists(select 1 from syscolumns where id = object_id('RC_DEB_HISTORICO_CPL') and name = 'FLAG_CONVENIO')
begin 
ALTER TABLE dbo.RC_DEB_HISTORICO_CPL ADD
	FLAG_CONVENIO int NULL,
	FLAG_ADM_CARTAO int NULL,
	FLAG_CONTRATO_VERBA int NULL
ALTER TABLE dbo.RC_DEB_HISTORICO_CPL ADD CONSTRAINT
	DF_RC_DEB_HISTORICO_CPL_FLAG_CONVENIO DEFAULT 0 FOR FLAG_CONVENIO
ALTER TABLE dbo.RC_DEB_HISTORICO_CPL ADD CONSTRAINT
	DF_RC_DEB_HISTORICO_CPL_FLAG_ADM_CARTAO DEFAULT 0 FOR FLAG_ADM_CARTAO
ALTER TABLE dbo.RC_DEB_HISTORICO_CPL ADD CONSTRAINT
	DF_RC_DEB_HISTORICO_CPL_FLAG_CONTRATO_VERBA DEFAULT 0 FOR FLAG_CONTRATO_VERBA
ALTER TABLE dbo.RC_DEB_HISTORICO_CPL SET (LOCK_ESCALATION = TABLE)
end