Codemerx/Gestor.Application.Migration.Files.20200817_59.SQL


1
2
3
4
5
6
7
8
9

IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'ArquivoParaAssinatura') AND COL_LENGTH('[dbo].[ArquivoParaAssinatura]', 'Enviado') IS NULL
BEGIN
  ALTER TABLE [dbo].[ArquivoParaAssinatura] ADD Enviado DATETIME2 NULL;
END

IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'ArquivoParaAssinatura') AND COL_LENGTH('[dbo].[ArquivoParaAssinatura]', 'UsuarioId') IS NULL
BEGIN
  ALTER TABLE [dbo].[ArquivoParaAssinatura] ADD UsuarioId BIGINT NULL;
END