summaryrefslogtreecommitdiff
path: root/Gestor.Application.Migration.Files.20200403_19.SQL
diff options
context:
space:
mode:
Diffstat (limited to 'Gestor.Application.Migration.Files.20200403_19.SQL')
-rw-r--r--Gestor.Application.Migration.Files.20200403_19.SQL14
1 files changed, 14 insertions, 0 deletions
diff --git a/Gestor.Application.Migration.Files.20200403_19.SQL b/Gestor.Application.Migration.Files.20200403_19.SQL
new file mode 100644
index 0000000..2cd86f2
--- /dev/null
+++ b/Gestor.Application.Migration.Files.20200403_19.SQL
@@ -0,0 +1,14 @@
+IF COL_LENGTH('[dbo].[clitelefone]', 'padrao') IS NULL
+BEGIN
+ ALTER TABLE [dbo].[clitelefone] ADD padrao CHAR(1) NULL;
+END
+
+IF COL_LENGTH('[dbo].[clitelefone]', 'operadora') IS NULL
+BEGIN
+ ALTER TABLE [dbo].[clitelefone] ADD operadora NUMERIC(5,0) NULL;
+END
+
+IF COL_LENGTH('[dbo].[clitelefone]', 'ramal') IS NULL
+BEGIN
+ ALTER TABLE [dbo].[clitelefone] ADD ramal VARCHAR(5) NULL;
+END \ No newline at end of file