summaryrefslogtreecommitdiff
path: root/Decompiler/Gestor.Application.Migration.Files.20230208_219.SQL
diff options
context:
space:
mode:
Diffstat (limited to 'Decompiler/Gestor.Application.Migration.Files.20230208_219.SQL')
-rw-r--r--Decompiler/Gestor.Application.Migration.Files.20230208_219.SQL4
1 files changed, 4 insertions, 0 deletions
diff --git a/Decompiler/Gestor.Application.Migration.Files.20230208_219.SQL b/Decompiler/Gestor.Application.Migration.Files.20230208_219.SQL
new file mode 100644
index 0000000..0fc72f8
--- /dev/null
+++ b/Decompiler/Gestor.Application.Migration.Files.20230208_219.SQL
@@ -0,0 +1,4 @@
+IF ((SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'clitelefone' AND COLUMN_NAME = 'TIPO') = 'numeric')
+BEGIN
+ALTER TABLE [dbo].[clitelefone] ALTER COLUMN TIPO INT;
+END \ No newline at end of file