From 1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1 Mon Sep 17 00:00:00 2001
From: Lucas Faria Mendes <lucas.fariamo08@gmail.com>
Date: Mon, 30 Mar 2026 10:38:18 -0300
Subject: chore: location

---
 ...tor.Application.Migration.Files.20200512_41.SQL | 62 ++++++++++++++++++++++
 1 file changed, 62 insertions(+)
 create mode 100644 Codemerx/Gestor.Application.Migration.Files.20200512_41.SQL

(limited to 'Codemerx/Gestor.Application.Migration.Files.20200512_41.SQL')

diff --git a/Codemerx/Gestor.Application.Migration.Files.20200512_41.SQL b/Codemerx/Gestor.Application.Migration.Files.20200512_41.SQL
new file mode 100644
index 0000000..b92048a
--- /dev/null
+++ b/Codemerx/Gestor.Application.Migration.Files.20200512_41.SQL
@@ -0,0 +1,62 @@
+IF (NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'mensagempadrao'))
+BEGIN
+
+	CREATE TABLE [dbo].[mensagempadrao] (
+		[id] int NOT NULL PRIMARY KEY,
+		[conteudo] nvarchar(max) NULL,
+		[titulo] nvarchar(255) NULL,
+		[filter] nvarchar(max) NULL,
+		[field] nvarchar(100) NULL);
+
+END
+
+IF (NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'mensagem'))
+BEGIN
+
+	CREATE TABLE [dbo].[mensagem] (
+		[id] bigint  IDENTITY(1,1) NOT NULL PRIMARY KEY,
+		[conteudo] nvarchar(max) NULL,
+		[titulo] nvarchar(255) NULL,
+		[envio] datetime2 NULL,
+		[lido] bit NULL,
+		[idcliente] bigint NULL,
+		[idusuario] int NULL,
+		[idpadrao] int NULL);
+
+END
+
+IF (NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'Device'))
+BEGIN
+
+	CREATE TABLE [dbo].[Device] (
+		[Id] bigint  IDENTITY(1,1) NOT NULL PRIMARY KEY,
+		[DeviceId] nvarchar(255) NULL,
+		[IdCliente] bigint NULL);
+
+END
+
+IF (NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'logconvite'))
+BEGIN
+
+	CREATE TABLE [dbo].[logconvite] (
+		[id] int IDENTITY(1,1) NOT NULL,
+		[idcliente] bigint  NULL,
+		[email] nvarchar(250) NULL,
+		[sent] bit  NULL,
+		[idusuario] bigint  NULL,
+		[data] datetime2  NULL);
+
+END
+
+IF (NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'mensagemenviada'))
+BEGIN
+
+	CREATE TABLE [dbo].[mensagemenviada] (
+		[id] int  IDENTITY(1,1) NOT NULL PRIMARY KEY,
+		[resposta] nvarchar(max) NULL,
+		[idusuario] int NULL,
+		[idpadrao] int NULL,
+		[data] datetime2 NULL);
+
+
+END
\ No newline at end of file
-- 
cgit v1.2.3