summaryrefslogtreecommitdiff
path: root/Gestor.Application.Migration.Files.20230208_219.SQL
diff options
context:
space:
mode:
authorLucas Faria Mendes <lucas.fariamo08@gmail.com>2026-03-30 13:35:25 +0000
committerLucas Faria Mendes <lucas.fariamo08@gmail.com>2026-03-30 13:35:25 +0000
commit674ca83ba9243a9e95a7568c797668dab6aee26a (patch)
tree4a905b3fb1d827665a34d63f67bc5559f8e7235b /Gestor.Application.Migration.Files.20230208_219.SQL
downloadgestor-674ca83ba9243a9e95a7568c797668dab6aee26a.tar.gz
gestor-674ca83ba9243a9e95a7568c797668dab6aee26a.zip
feat: upload files
Diffstat (limited to 'Gestor.Application.Migration.Files.20230208_219.SQL')
-rw-r--r--Gestor.Application.Migration.Files.20230208_219.SQL4
1 files changed, 4 insertions, 0 deletions
diff --git a/Gestor.Application.Migration.Files.20230208_219.SQL b/Gestor.Application.Migration.Files.20230208_219.SQL
new file mode 100644
index 0000000..0fc72f8
--- /dev/null
+++ b/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