1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
IF (NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'titular'))
BEGIN
CREATE TABLE [dbo].[titular](
[IDTITULAR] [bigint] IDENTITY(1,1) NOT NULL PRIMARY KEY,
[idvida] [bigint] NULL,
[plano] [varchar](120) NULL,
[nome] [varchar](120) NULL,
[nascimento] [date] NULL,
[CGCCPF] [varchar](18) NULL,
[certificado] [varchar](30) NULL,
[matricula] [varchar](30) NULL,
[capital] [numeric](12, 2) NULL,
[premio] [numeric](8, 2) NULL,
[usuariocriacao] [bigint] NULL,
[usuarioalteracao] [bigint] NULL,
[datacriacao] [datetime] NULL,
[dataalteracao] [datetime] NULL,
[idtitularcopiado] [bigint] NULL,
[saida] [date] NULL,
[obs] [varchar](max) NULL,
[RG] [varchar](13) NULL,
[emissao] [date] NULL,
[rguf] [varchar](2) NULL,
[entrada] [date] NULL);
END
|
