summaryrefslogtreecommitdiff
path: root/Gestor.Application.Migration.Files.20200403_14.SQL
diff options
context:
space:
mode:
Diffstat (limited to 'Gestor.Application.Migration.Files.20200403_14.SQL')
-rw-r--r--Gestor.Application.Migration.Files.20200403_14.SQL29
1 files changed, 0 insertions, 29 deletions
diff --git a/Gestor.Application.Migration.Files.20200403_14.SQL b/Gestor.Application.Migration.Files.20200403_14.SQL
deleted file mode 100644
index 44da860..0000000
--- a/Gestor.Application.Migration.Files.20200403_14.SQL
+++ /dev/null
@@ -1,29 +0,0 @@
-IF COL_LENGTH('[dbo].[resempco]', 'tiporesidencia') IS NULL
-BEGIN
- ALTER TABLE [dbo].[resempco] ADD tiporesidencia NUMERIC(1,0) NULL;
-END
-
-IF COL_LENGTH('[dbo].[resempco]', 'obs') IS NULL
-BEGIN
- ALTER TABLE [dbo].[resempco] ADD obs VARCHAR(MAX) NULL;
-END
-
-IF COL_LENGTH('[dbo].[resempco]', 'datacriacao') IS NULL
-BEGIN
- ALTER TABLE [dbo].[resempco] ADD datacriacao DATETIME2 NULL;
-END
-
-IF COL_LENGTH('[dbo].[resempco]', 'usuariocriacao') IS NULL
-BEGIN
- ALTER TABLE [dbo].[resempco] ADD usuariocriacao BIGINT NULL;
-END
-
-IF COL_LENGTH('[dbo].[resempco]', 'dataalteracao') IS NULL
-BEGIN
- ALTER TABLE [dbo].[resempco] ADD dataalteracao DATETIME2 NULL;
-END
-
-IF COL_LENGTH('[dbo].[resempco]', 'usuarioalteracao') IS NULL
-BEGIN
- ALTER TABLE [dbo].[resempco] ADD usuarioalteracao BIGINT NULL;
-END \ No newline at end of file