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.20200219_02.SQL | 116 +++++++++++++++++++++ 1 file changed, 116 insertions(+) create mode 100644 Codemerx/Gestor.Application.Migration.Files.20200219_02.SQL (limited to 'Codemerx/Gestor.Application.Migration.Files.20200219_02.SQL') diff --git a/Codemerx/Gestor.Application.Migration.Files.20200219_02.SQL b/Codemerx/Gestor.Application.Migration.Files.20200219_02.SQL new file mode 100644 index 0000000..27f9797 --- /dev/null +++ b/Codemerx/Gestor.Application.Migration.Files.20200219_02.SQL @@ -0,0 +1,116 @@ +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 1) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (1, N'RESIDÊNCIA',0.0738,0,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 2) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (2, N'EMPRESA',0.0738,0,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 3) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (3, N'CONDOMÍNIO',0.0738,0,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 4) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (4, N'RISCOS DIVERSOS',0.0738,1,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 5) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (5, N'AUTOMOVEL',0.0738,0,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 6) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (6, N'VIDA INDIVIDUAL',0.0738,1,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 7) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (7, N'VG/APC',0.0738,1,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 8) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (8, N'TRANSPORTES',0.0738,1,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 14) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (14, N'DPVAT',0.0738,0,0); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 15) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (15, N'FIANÇA LOCATÍCIA',0.0738,0,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 18) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (18, N'IMOBILIÁRIO',0.0738,1,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 20) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (20, N'GRANIZO',0.0738,0,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 23) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (23, N'SEGURO VIAGEM',0.0738,0,0); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 24) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (24, N'SEGURO DE EVENTOS',0.0738,0,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 25) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (25, N'AGRÍCOLA',0.0738,1,0); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 28) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (28, N'RC PROFISSIONAL',0.0738,0,0); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 30) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (30, N'RC AMBIENTAL',0.0738,0,0); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 31) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (31, N'ACIDENTES PESSOAIS',0.0738,0,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 32) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (32, N'RESP. CIVIL GERAL',0.0738,0,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 33) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (33, N'MULTIRISCO RURAL',0.0738,0,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 34) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (34, N'ANIMAIS',0.0738,0,0); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 37) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (37, N'RESP. CIVIL ÔNIBUS',0.0738,0,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 38) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (38, N'SEGURO GARANTIA',0.0738,0,0); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 39) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (39, N'RISCOS DE ENGENHARIA',0.0738,0,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 41) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (41, N'ACIDENTES PESSOAIS COLETIVOS',0.0738,0,1); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 44) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (44, N'PENHOR RURAL',0.0738,0,0); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 49) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (49, N'RCTR-C',0.0738,1,0); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 54) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (54, N'BENFEITORIA RURAL',0.0738,0,0); +END +IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 56) +BEGIN + INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (56, N'RC PRESTAÇÃO DE SERVIÇO',0.0738,0,1); +END \ No newline at end of file -- cgit v1.2.3