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

---
 .../Gestor.Application.Migration.Files.20200311_07.SQL     | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 Codemerx/Gestor.Application.Migration.Files.20200311_07.SQL

(limited to 'Codemerx/Gestor.Application.Migration.Files.20200311_07.SQL')

diff --git a/Codemerx/Gestor.Application.Migration.Files.20200311_07.SQL b/Codemerx/Gestor.Application.Migration.Files.20200311_07.SQL
new file mode 100644
index 0000000..99220f5
--- /dev/null
+++ b/Codemerx/Gestor.Application.Migration.Files.20200311_07.SQL
@@ -0,0 +1,14 @@
+IF EXISTS(SELECT 1 FROM [dbo].[cliente] WHERE [idempresa] IS NULL)
+BEGIN
+	UPDATE [dbo].[cliente] SET [idempresa] = 1 WHERE [idempresa] IS NULL;
+END
+
+IF EXISTS(SELECT 1 FROM [dbo].[parcela] WHERE [idempresa] IS NULL)
+BEGIN
+	UPDATE [dbo].[parcela] SET [idempresa] = 1 WHERE [idempresa] IS NULL;
+END
+
+IF EXISTS(SELECT 1 FROM [dbo].[parcela] WHERE [idempresa] IS NULL)
+BEGIN
+	UPDATE [dbo].[parcela] SET [idempresa] = 1 WHERE [idempresa] IS NULL;
+END
\ No newline at end of file
-- 
cgit v1.2.3

