1 files changed, 8 insertions, 0 deletions
diff --git a/Gestor.Application.Migration.Files.20230619_223.SQL b/Gestor.Application.Migration.Files.20230619_223.SQL
new file mode 100644
index 0000000..1238ef1
--- /dev/null
+++ b/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