summaryrefslogtreecommitdiff
path: root/Gestor.Application.Migration.Files.20200817_59.SQL
diff options
context:
space:
mode:
Diffstat (limited to 'Gestor.Application.Migration.Files.20200817_59.SQL')
-rw-r--r--Gestor.Application.Migration.Files.20200817_59.SQL9
1 files changed, 9 insertions, 0 deletions
diff --git a/Gestor.Application.Migration.Files.20200817_59.SQL b/Gestor.Application.Migration.Files.20200817_59.SQL
new file mode 100644
index 0000000..4f46df2
--- /dev/null
+++ b/Gestor.Application.Migration.Files.20200817_59.SQL
@@ -0,0 +1,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 \ No newline at end of file