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.20200406_24.SQL | 38 ++++++++++++++++++++++ 1 file changed, 38 insertions(+) create mode 100644 Codemerx/Gestor.Application.Migration.Files.20200406_24.SQL (limited to 'Codemerx/Gestor.Application.Migration.Files.20200406_24.SQL') diff --git a/Codemerx/Gestor.Application.Migration.Files.20200406_24.SQL b/Codemerx/Gestor.Application.Migration.Files.20200406_24.SQL new file mode 100644 index 0000000..393e57c --- /dev/null +++ b/Codemerx/Gestor.Application.Migration.Files.20200406_24.SQL @@ -0,0 +1,38 @@ +IF (NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'controlelog')) +BEGIN + +CREATE TABLE [dbo].[controlelog]( +[idcontrolelog] [bigint] IDENTITY(1,1) NOT NULL PRIMARY KEY, +[bdname] [varchar](255) NULL, +[tabela] [varchar](255) NULL); + +DECLARE @banco VARCHAR(255) = (SELECT DB_NAME()); + +INSERT INTO [dbo].[controlelog] VALUES (@banco, N'oldbacklog'); + +CREATE TABLE [dbo].[actionlog]( +[IDACTION] [bigint] IDENTITY(1,1) NOT NULL PRIMARY KEY, +[IDEMPRESA] [bigint] NULL, +[FORM] [varchar](30) NULL, +[DESCRICAO] [varchar](50) NULL, +[ACAO] [varchar](200) NULL, +[IDNAME] [varchar](30) NULL, +[ID] [bigint] NULL, +[IDUSUARIO] [bigint] NULL, +[DATA] [datetime] NULL, +[historico] [VARCHAR](MAX) NULL, +[maquina] [VARCHAR](100) NULL); + +CREATE TABLE [dbo].[oldbacklog]( +[IDBACKLOG] [bigint] IDENTITY(1,1) NOT NULL PRIMARY KEY, +[IDEMPRESA] [bigint] NULL, +[FORM] [varchar](30) NULL, +[DESCRICAO] [varchar](50) NULL, +[HISTORICO] [text] NULL, +[IDNAME] [varchar](30) NULL, +[ID] [bigint] NULL, +[INCLUINDO] [numeric](1, 0) NULL, +[IDUSUARIO] [bigint] NULL, +[DATA] [datetime] NULL); + +END \ No newline at end of file -- cgit v1.2.3