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 --- Gestor.Application.Migration.Files.20200512_41.SQL | 62 ---------------------- 1 file changed, 62 deletions(-) delete mode 100644 Gestor.Application.Migration.Files.20200512_41.SQL (limited to 'Gestor.Application.Migration.Files.20200512_41.SQL') diff --git a/Gestor.Application.Migration.Files.20200512_41.SQL b/Gestor.Application.Migration.Files.20200512_41.SQL deleted file mode 100644 index b92048a..0000000 --- a/Gestor.Application.Migration.Files.20200512_41.SQL +++ /dev/null @@ -1,62 +0,0 @@ -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