if not exists (select column_name FROM INFORMATION_SCHEMA.COLUMNS where Table_Name='syn_puntoIntegracion'  and column_name = 'tablaLocal' )
begin  
	alter table [syn_puntoIntegracion] add [tablaLocal] varchar(200) NULL DEFAULT ''
end
go

if not exists (select column_name FROM INFORMATION_SCHEMA.COLUMNS where Table_Name='syn_puntoIntegracion'  and column_name = 'condicion' )
begin  
	alter table [syn_puntoIntegracion] add [condicion] varchar(200) NULL DEFAULT ''
end
go

if not exists (select column_name FROM INFORMATION_SCHEMA.COLUMNS where Table_Name='syn_puntoIntegracion'  and column_name = 'urlConsumir' )
begin  
	alter table [syn_puntoIntegracion] add [urlConsumir] varchar(500) NULL DEFAULT ''
end
go

if not exists (select column_name FROM INFORMATION_SCHEMA.COLUMNS where Table_Name='syn_puntoIntegracion'  and column_name = 'id_puntoIntegracion' )
begin  
	alter table [syn_puntoIntegracion] add [id_puntoIntegracion] int NULL DEFAULT 0 FOREIGN KEY (id_puntoIntegracion) REFERENCES syn_puntoIntegracion(id)
end
go

if not exists (select column_name FROM INFORMATION_SCHEMA.COLUMNS where Table_Name='syn_puntoIntegracion'  and column_name = 'id_sistemaIntegrar' )
begin  
	alter table [syn_puntoIntegracion] add [id_sistemaIntegrar] int NULL DEFAULT 0 FOREIGN KEY (id_sistemaIntegrar) REFERENCES syn_sistemaIntegrar(id)
end
go
