summaryrefslogtreecommitdiff
path: root/Gestor.Application.Migration.Files.20200505_39.SQL
blob: 4b55cf6e3cf4a403619996f3f14c2625c4c6498c (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
IF (NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'averbacao'))
BEGIN
	CREATE TABLE [dbo].[averbacao](
	[idaverbacao] [bigint] IDENTITY(1,1) NOT NULL PRIMARY KEY,
	[idparcela] [bigint] NULL,
	[origem] [varchar](250) NULL,
	[destino] [varchar](250) NULL,
	[movimento] [numeric](20, 2) NULL,
	[premio] [numeric](15, 2) NULL,
	[usuariocriacao] [bigint] NULL,
	[usuarioalteracao] [bigint] NULL,
	[datacriacao] [datetime] NULL,
	[dataalteracao] [datetime] NULL);	
END