summaryrefslogtreecommitdiff
path: root/Gestor.Application.Migration.Files.20220321_194.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.20220321_194.SQL
downloadgestor-674ca83ba9243a9e95a7568c797668dab6aee26a.tar.gz
gestor-674ca83ba9243a9e95a7568c797668dab6aee26a.zip
feat: upload files
Diffstat (limited to 'Gestor.Application.Migration.Files.20220321_194.SQL')
-rw-r--r--Gestor.Application.Migration.Files.20220321_194.SQL7
1 files changed, 7 insertions, 0 deletions
diff --git a/Gestor.Application.Migration.Files.20220321_194.SQL b/Gestor.Application.Migration.Files.20220321_194.SQL
new file mode 100644
index 0000000..fce2aa4
--- /dev/null
+++ b/Gestor.Application.Migration.Files.20220321_194.SQL
@@ -0,0 +1,7 @@
+IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'Usuario')
+BEGIN
+ IF COL_LENGTH('usuario','cgccpf') < 18
+ BEGIN
+ ALTER TABLE [dbo].[Usuario] ALTER COLUMN CgcCpf NVARCHAR(18) NULL;
+ END
+END \ No newline at end of file