summaryrefslogtreecommitdiff
path: root/Codemerx/Gestor.Application.Migration.Files.20200403_21.SQL
blob: df4427aa7ff780a57bc5687d8dde33b8232559db (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
IF COL_LENGTH('[dbo].[vendedorparcela]', 'cri_data') IS NULL
BEGIN
  ALTER TABLE [dbo].[vendedorparcela] ADD cri_data DATETIME2 NULL;
END

IF COL_LENGTH('[dbo].[vendedorparcela]', 'usuariocriacao') IS NULL
BEGIN
  ALTER TABLE [dbo].[vendedorparcela] ADD usuariocriacao BIGINT NULL;
END

IF COL_LENGTH('[dbo].[vendedorparcela]', 'atu_data') IS NULL
BEGIN
  ALTER TABLE [dbo].[vendedorparcela] ADD atu_data DATETIME2 NULL;
END

IF COL_LENGTH('[dbo].[vendedorparcela]', 'usuarioalteracao') IS NULL
BEGIN
  ALTER TABLE [dbo].[vendedorparcela] ADD usuarioalteracao BIGINT NULL;
END