From 1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1 Mon Sep 17 00:00:00 2001 From: Lucas Faria Mendes Date: Mon, 30 Mar 2026 10:38:18 -0300 Subject: chore: location --- ...tor.Application.Migration.Files.20200408_32.SQL | 34 ++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100644 Codemerx/Gestor.Application.Migration.Files.20200408_32.SQL (limited to 'Codemerx/Gestor.Application.Migration.Files.20200408_32.SQL') diff --git a/Codemerx/Gestor.Application.Migration.Files.20200408_32.SQL b/Codemerx/Gestor.Application.Migration.Files.20200408_32.SQL new file mode 100644 index 0000000..027e5a0 --- /dev/null +++ b/Codemerx/Gestor.Application.Migration.Files.20200408_32.SQL @@ -0,0 +1,34 @@ + +IF (NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'beneficiario')) +BEGIN + +CREATE TABLE [dbo].[beneficiario]( + [IDBENEFICIARIO] [bigint] IDENTITY(1,1) NOT NULL PRIMARY KEY, + [idtitular] [bigint] NULL, + [idparentesco] [bigint] NULL, + [nome] [varchar](120) NULL, + [CEP] [varchar](10) NULL, + [ENDERECO] [varchar](60) NULL, + [NUMERO] [varchar](5) NULL, + [CIDADE] [varchar](30) NULL, + [UF] [varchar](2) NULL, + [BAIRRO] [varchar](60) NULL, + [CGCCPF] [varchar](18) NULL, + [RG] [varchar](13) NULL, + [emissao] [date] NULL, + [rguf] [varchar](2) NULL, + [beneficio] [numeric](6, 2) NULL, + [usuariocriacao] [bigint] NULL, + [usuarioalteracao] [bigint] NULL, + [datacriacao] [datetime] NULL, + [dataalteracao] [datetime] NULL, + [complemento] [varchar](30) NULL, + [saida] [date] NULL, + [obs] [varchar](max) NULL, + [idprofissao] [bigint] NULL, + [iditem] [bigint] NULL, + [entrada] [date] NULL, + [porcentagem] [numeric](6, 2) NULL, + [dtnasc] [date] NULL); + +END \ No newline at end of file -- cgit v1.2.3