From 225aa1499e37faf9d38257caabbadc68d78b427e Mon Sep 17 00:00:00 2001 From: Lucas Faria Mendes Date: Mon, 30 Mar 2026 12:29:41 -0300 Subject: decompiler.com --- ...tor.Application.Migration.Files.20200527_49.SQL | 39 ++++++++++++++++++++++ 1 file changed, 39 insertions(+) create mode 100644 Decompiler/Gestor.Application.Migration.Files.20200527_49.SQL (limited to 'Decompiler/Gestor.Application.Migration.Files.20200527_49.SQL') diff --git a/Decompiler/Gestor.Application.Migration.Files.20200527_49.SQL b/Decompiler/Gestor.Application.Migration.Files.20200527_49.SQL new file mode 100644 index 0000000..f39021c --- /dev/null +++ b/Decompiler/Gestor.Application.Migration.Files.20200527_49.SQL @@ -0,0 +1,39 @@ +IF NOT EXISTS(SELECT 1 FROM [dbo].[controledbad]) +BEGIN + DECLARE @banco VARCHAR(255) = (SELECT DB_NAME()); + INSERT INTO [dbo].[controledbad] (bdname, tabela) VALUES (@banco, N'Arquivos'); + + CREATE TABLE [dbo].[Arquivos]( + [IDARQUIVODIGITAL] [bigint] IDENTITY(1,1) NOT NULL PRIMARY KEY, + [IDCLIENTE] [bigint] NULL, + [IDDOCUMENTO] [bigint] NULL, + [IDATENDIMENTO] [bigint] NULL, + [IDITEM] [bigint] NULL, + [IDPARCELA] [bigint] NULL, + [IDSINISTRO] [bigint] NULL, + [IDVENCTOALEATORIO] [bigint] NULL, + [IDMALADIRETA] [bigint] NULL, + [IDFORNECEDOR] [bigint] NULL, + [IDCIASEG] [bigint] NULL, + [IDORCCLI] [bigint] NULL, + [IDORCAMEN] [bigint] NULL, + [IDORCITEM] [bigint] NULL, + [IDVENDEDOR] [bigint] NULL, + [IDEXTRATO] [bigint] NULL, + [IDLANCAMEN] [bigint] NULL, + [IDEMPRESA] [bigint] NULL, + [IDSOCIO] [bigint] NULL, + [DESCRICAO] [varchar](300) NULL, + [IMGBLOB] [varbinary](max) NULL, + [EXTENSION] [varchar](5) NULL, + [USUARIOCRIACAO] [bigint] NULL, + [USUARIOALTERACAO] [bigint] NULL, + [DATACRIACAO] [datetime] NULL, + [DATAALTERACAO] [datetime] NULL, + [idrecibofiscal] [bigint] NULL, + [idprojeto] [bigint] NULL, + [idagsproduto] [bigint] NULL, + [excluido] [varchar](1) NULL, + [idnota] [bigint] NULL, + [idguiaremessa] [bigint] NULL); +END \ No newline at end of file -- cgit v1.2.3