-- Este scripot no se debe lanzar en el proceso de migración
-- Simplemente es para arreglar los errores introducidos por los postload
UPDATE tssseg0001.dbo.Polizas set PolFPrxRen = '1753-01-01 00:00:00' WHERE PolFPrxRen IS NULL;
UPDATE tssseg0001.dbo.Polizas set PolFecBaja = '1753-01-01 00:00:00' WHERE PolFecBaja IS NULL;
UPDATE tssseg0001.dbo.Polizas set PolReemANumID = 0 WHERE PolReemANumID IS NULL;
UPDATE tssseg0001.dbo.Polizas set PolCol1ID = '' WHERE PolCol1ID IS NULL;
UPDATE tssseg0001.dbo.Polizas set PolCol2ID = '' WHERE PolCol2ID IS NULL;
UPDATE tssseg0001.dbo.Polizas set PolCol3ID = '' WHERE PolCol3ID IS NULL;
UPDATE tssseg0001.dbo.Polizas set PolBID = -9 WHERE PolBID IS NULL;

UPDATE tssseg0001.dbo.Clientes set CliDBPri = 0 WHERE CliDBPri IS NULL;
UPDATE tssseg0001.dbo.Clientes set CliTip1ID = '' WHERE CliTip1ID IS NULL;
UPDATE tssseg0001.dbo.Clientes set CliCol1ID = '' WHERE CliCol1ID IS NULL;
UPDATE tssseg0001.dbo.Clientes set CliCol2ID = '' WHERE CliCol2ID IS NULL;
UPDATE tssseg0001.dbo.Clientes set CliCol3ID = '' WHERE CliCol3ID IS NULL;

UPDATE tssseg0001.dbo.Colaboradores set EmpDvID = 0 WHERE EmpDvID IS NULL;

UPDATE tssseg0001.dbo.Recibos set RecBID = -9 WHERE RecBID IS NULL;

UPDATE tssseg0001.dbo.Siniestros set CauSinID = '' WHERE CauSinID IS NULL;
UPDATE tssseg0001.dbo.Siniestros set EstSinID = '' WHERE EstSinID IS NULL;


