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.20200219_01.SQL | 192 --------------------- 1 file changed, 192 deletions(-) delete mode 100644 Gestor.Application.Migration.Files.20200219_01.SQL (limited to 'Gestor.Application.Migration.Files.20200219_01.SQL') diff --git a/Gestor.Application.Migration.Files.20200219_01.SQL b/Gestor.Application.Migration.Files.20200219_01.SQL deleted file mode 100644 index 0511b35..0000000 --- a/Gestor.Application.Migration.Files.20200219_01.SQL +++ /dev/null @@ -1,192 +0,0 @@ -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 112) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (112, N'CAPEMISA CAPITALIZAÇÃO S/A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 131) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (131, N'CHUBB DO BRASIL CIA DE SEGUROS', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 14) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (14, N'ALFA SEGURADORA S.A.', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 182) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (182, N'COMPANHIA EXCELSIOR DE SEGUROS', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 19) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (19, N'ALLIANZ SEGUROS S.A.', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 192) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (192, N'CONFIANÇA CIA DE SEGUROS', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 216) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (216, N'ESSOR SEGUROS S.A.', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 228) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (228, N'FAIRFAX BRASIL SEGUROS CORPORATIVOS S.A.', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 244) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (244, N'GENERALI BRASIL SEGUROS S.A.', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 245) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (245, N'GENTE SEGURADORA S.A.', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 259) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (259, N'HDI SEGUROS S.A.', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 276) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (276, N'INDIANA SEGUROS S/A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 285) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (285, N'INVESTPREV SEGURADORA S.A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 292) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (292, N'ITAU SEGUROS S/A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 310) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (310, N'LIBERTY SEGUROS S/A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 311) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (311, N'LIDERANÇA CAPITALIZAÇÃO S/A', 0, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 328) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (328, N'MAPFRE SEGUROS GERAIS S/A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 331) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (331, N'MARITIMA SEGUROS S/A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 338) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (338, N'MBM SEGURADORA S/A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 341) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (341, N'METLIFE VIDA E PREVIDÊNCIA S/A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 348) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (348, N'MITSUI SUMITOMO SEGUROS S/A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 372) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (372, N'NOBRE SEGURADORA DO BRASIL S/A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 4) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (4, N'ACE SEGURADORA S.A.', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 400) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (400, N'PORTO SEGURO CIA DE SEGUROS GERAIS', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 42) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (42, N'ARGO SEGUROS BRASIL S.A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 480) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (480, N'SULAMÉRICA CIA NACIONAL DE SEGUROS', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 491) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (491, N'SWISS RE CORPORATE SOLUTIONS BRASIL SE S', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 501) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (501, N'TOKIO MARINE SEGURADORA S.A.', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 522) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (522, N'UNIMED SEGURADORA S/A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 543) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (543, N'YASUDA SEGUROS S.A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 548) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (548, N'ZURICH MINAS BRASIL SEGUROS S/A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 557) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (557, N'SUHAI SEGUROS S.A.', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 559) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (559, N'SANCOR SEGUROS DO BRASIL S.A.', 1, 2); -END ---IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 560) ---BEGIN --- INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (560, N'AGROBRASIL - CORRETORA DE SEGUROS LTDA - ME ', 1, 2); ---END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 561) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (561, N'RSA SEGUROS', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 562) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (562, N'YASUDA MARITIMA SEGUROS S.A.', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 578) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (578, N'NOTRE DAME INTERMÉDICA', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 595) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (595, N'SOMPO SEGUROS', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 600) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (600, N'ASSIST CARD SEGURO VIAGEM', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 603) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (603, N'AXA SEGUROS', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 639) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (639, N'ALIRO SEGUROS S.A.', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 642) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (642, N'SURA SEGUROS S/A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 647) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (647, N'PREVISUL SEGURADORA', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 695) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (695, N'ARUANA SEGURADORA', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 70) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (70, N'AZUL COMPANHIA DE SEGUROS GERAIS', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 9) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (9, N'AIG SEGUROS BRASIL S.A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 92) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (92, N'BRADESCO SEGUROS S.A', 1, 2); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[ciaseg] WHERE [IDCIASEG] = 614) -BEGIN - INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[ATIVO],[TOLERANCIA]) VALUES (614, N'TOO SEGUROS S.A.', 1, 2); -END \ No newline at end of file -- cgit v1.2.3