From 674ca83ba9243a9e95a7568c797668dab6aee26a Mon Sep 17 00:00:00 2001 From: Lucas Faria Mendes Date: Mon, 30 Mar 2026 10:35:25 -0300 Subject: feat: upload files --- ...or.Application.Migration.Files.20220329_196.SQL | 24 ++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 Gestor.Application.Migration.Files.20220329_196.SQL (limited to 'Gestor.Application.Migration.Files.20220329_196.SQL') diff --git a/Gestor.Application.Migration.Files.20220329_196.SQL b/Gestor.Application.Migration.Files.20220329_196.SQL new file mode 100644 index 0000000..ddd6f15 --- /dev/null +++ b/Gestor.Application.Migration.Files.20220329_196.SQL @@ -0,0 +1,24 @@ +IF NOT EXISTS (SELECT 1 FROM [dbo].[ciaseg] WHERE [idciaseg] = 894) +BEGIN + INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[CGCCPF],[ATIVO],[TOLERANCIA]) VALUES (894, N'OPERADORA UNICENTRAL DE PLANOS DE SAUDE LTDA', '02.888.465/0001-56', 0, 2); +END +--IF NOT EXISTS (SELECT 1 FROM [dbo].[ciaseg] WHERE [idciaseg] = 895) +--BEGIN +-- INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[CGCCPF],[ATIVO],[TOLERANCIA]) VALUES (895, N'BEPLUS SAUDE CORRETORA DE SEGUROS LTDA', '12.402.717/0001-49', 0, 2); +--END +--IF NOT EXISTS (SELECT 1 FROM [dbo].[ciaseg] WHERE [idciaseg] = 896) +--BEGIN +-- INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[CGCCPF],[ATIVO],[TOLERANCIA]) VALUES (896, N'HEBROM CORRETORA DE SEGUROS LTDA', '08.179.439/0001-35', 0, 2); +--END +--IF NOT EXISTS (SELECT 1 FROM [dbo].[ciaseg] WHERE [idciaseg] = 898) +--BEGIN +-- INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[CGCCPF],[ATIVO],[TOLERANCIA]) VALUES (898, N'RAMED 4YOU CORRETORA DE SEGUROS LTDA', '36.454.780/0001-97', 0, 2); +--END +--IF NOT EXISTS (SELECT 1 FROM [dbo].[ciaseg] WHERE [idciaseg] = 899) +--BEGIN +-- INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[CGCCPF],[ATIVO],[TOLERANCIA]) VALUES (899, N'DINASTY CORRETORA DE SEGUROS UNIPESSOAL LTDA', '40.514.996/0001-78', 0, 2); +--END +--IF NOT EXISTS (SELECT 1 FROM [dbo].[ciaseg] WHERE [idciaseg] = 900) +--BEGIN +-- INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[CGCCPF],[ATIVO],[TOLERANCIA]) VALUES (900, N'RAMED MIX CORRETORA DE SEGUROS LTDA', '12.346.564.0001-60', 0, 2); +--END \ No newline at end of file -- cgit v1.2.3