summaryrefslogtreecommitdiff
path: root/Codemerx/Gestor.Application.Migration.Files.20230619_223.SQL
diff options
context:
space:
mode:
Diffstat (limited to 'Codemerx/Gestor.Application.Migration.Files.20230619_223.SQL')
-rw-r--r--Codemerx/Gestor.Application.Migration.Files.20230619_223.SQL8
1 files changed, 8 insertions, 0 deletions
diff --git a/Codemerx/Gestor.Application.Migration.Files.20230619_223.SQL b/Codemerx/Gestor.Application.Migration.Files.20230619_223.SQL
new file mode 100644
index 0000000..1238ef1
--- /dev/null
+++ b/Codemerx/Gestor.Application.Migration.Files.20230619_223.SQL
@@ -0,0 +1,8 @@
+IF ((SELECT character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'perfil' AND COLUMN_NAME = 'ceppernoite') <= 9 )
+BEGIN
+ALTER TABLE perfil ALTER COLUMN ceppernoite VARCHAR(10) NULL;
+END
+IF ((SELECT character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'perfil' AND COLUMN_NAME = 'cepcirculacao') <= 9 )
+BEGIN
+ALTER TABLE perfil ALTER COLUMN cepcirculacao VARCHAR(10) NULL;
+END \ No newline at end of file