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
|