summaryrefslogtreecommitdiff
path: root/Gestor.Application.Migration.Files.20200408_31.SQL
diff options
context:
space:
mode:
Diffstat (limited to 'Gestor.Application.Migration.Files.20200408_31.SQL')
-rw-r--r--Gestor.Application.Migration.Files.20200408_31.SQL28
1 files changed, 0 insertions, 28 deletions
diff --git a/Gestor.Application.Migration.Files.20200408_31.SQL b/Gestor.Application.Migration.Files.20200408_31.SQL
deleted file mode 100644
index 4b03778..0000000
--- a/Gestor.Application.Migration.Files.20200408_31.SQL
+++ /dev/null
@@ -1,28 +0,0 @@
-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
-