BEGIN TRY
  BEGIN TRAN;

  ------------------------------------------------------------
  -- venEncabezado
  ------------------------------------------------------------
  IF OBJECT_ID('dbo.venEncabezado','U') IS NULL
    RAISERROR('No existe la tabla dbo.venEncabezado.', 16, 1);

  IF COL_LENGTH('dbo.venEncabezado','urlAwsXml') IS NULL
    EXEC(N'ALTER TABLE dbo.venEncabezado ADD urlAwsXml VARCHAR(MAX) NULL;');

  IF COL_LENGTH('dbo.venEncabezado','urlAwsPdf417') IS NULL
    EXEC(N'ALTER TABLE dbo.venEncabezado ADD urlAwsPdf417 VARCHAR(MAX) NULL;');

  -- DEFAULT '' si falta
  IF COL_LENGTH('dbo.venEncabezado','urlAwsXml') IS NOT NULL
     AND NOT EXISTS (
        SELECT 1
        FROM sys.default_constraints dc
        JOIN sys.columns c ON c.object_id = dc.parent_object_id AND c.column_id = dc.parent_column_id
        WHERE dc.parent_object_id = OBJECT_ID('dbo.venEncabezado')
          AND c.name = 'urlAwsXml'
     )
    EXEC(N'ALTER TABLE dbo.venEncabezado
           ADD CONSTRAINT DF_venEncabezado_urlAwsXml DEFAULT('''' ) FOR urlAwsXml;');

  IF COL_LENGTH('dbo.venEncabezado','urlAwsPdf417') IS NOT NULL
     AND NOT EXISTS (
        SELECT 1
        FROM sys.default_constraints dc
        JOIN sys.columns c ON c.object_id = dc.parent_object_id AND c.column_id = dc.parent_column_id
        WHERE dc.parent_object_id = OBJECT_ID('dbo.venEncabezado')
          AND c.name = 'urlAwsPdf417'
     )
    EXEC(N'ALTER TABLE dbo.venEncabezado
           ADD CONSTRAINT DF_venEncabezado_urlAwsPdf417 DEFAULT('''' ) FOR urlAwsPdf417;');

  ------------------------------------------------------------
  -- cyvEncabezado
  ------------------------------------------------------------
  IF OBJECT_ID('dbo.cyvEncabezado','U') IS NULL
    RAISERROR('No existe la tabla dbo.cyvEncabezado.', 16, 1);

  IF COL_LENGTH('dbo.cyvEncabezado','urlAwsXml') IS NULL
    EXEC(N'ALTER TABLE dbo.cyvEncabezado ADD urlAwsXml VARCHAR(MAX) NULL;');

  IF COL_LENGTH('dbo.cyvEncabezado','urlAwsPdf417') IS NULL
    EXEC(N'ALTER TABLE dbo.cyvEncabezado ADD urlAwsPdf417 VARCHAR(MAX) NULL;');

  -- DEFAULT '' si falta
  IF COL_LENGTH('dbo.cyvEncabezado','urlAwsXml') IS NOT NULL
     AND NOT EXISTS (
        SELECT 1
        FROM sys.default_constraints dc
        JOIN sys.columns c ON c.object_id = dc.parent_object_id AND c.column_id = dc.parent_column_id
        WHERE dc.parent_object_id = OBJECT_ID('dbo.cyvEncabezado')
          AND c.name = 'urlAwsXml'
     )
    EXEC(N'ALTER TABLE dbo.cyvEncabezado
           ADD CONSTRAINT DF_cyvEncabezado_urlAwsXml DEFAULT('''' ) FOR urlAwsXml;');

  IF COL_LENGTH('dbo.cyvEncabezado','urlAwsPdf417') IS NOT NULL
     AND NOT EXISTS (
        SELECT 1
        FROM sys.default_constraints dc
        JOIN sys.columns c ON c.object_id = dc.parent_object_id AND c.column_id = dc.parent_column_id
        WHERE dc.parent_object_id = OBJECT_ID('dbo.cyvEncabezado')
          AND c.name = 'urlAwsPdf417'
     )
    EXEC(N'ALTER TABLE dbo.cyvEncabezado
           ADD CONSTRAINT DF_cyvEncabezado_urlAwsPdf417 DEFAULT('''' ) FOR urlAwsPdf417;');

  COMMIT TRAN;
END TRY
BEGIN CATCH
  IF @@TRANCOUNT > 0 ROLLBACK TRAN;
  DECLARE @ErrMsg NVARCHAR(4000)=ERROR_MESSAGE(),
          @ErrNum INT=ERROR_NUMBER(),
          @ErrLine INT=ERROR_LINE();
  RAISERROR('Fallo al agregar/normalizar urlAws*: %s (Nro %d, Línea %d)', 16, 1, @ErrMsg, @ErrNum, @ErrLine);
END CATCH;
