Altered all PhoneNumber fields to NVARCHAR(50)

malinowskikam · malinowskikam · commit d38d8fe230ee · 2022-04-12T16:59:29.000+02:00
diff --git a/sql/base/1_schema_tables.sql b/sql/base/1_schema_tables.sql
@@ -261,7 +261,7 @@ CREATE TYPE [dbo].[xOfficers] AS TABLE(
 	[VEOLastName] [nvarchar](100) NULL,
 	[VEOOtherNames] [nvarchar](100) NULL,
 	[VEODOB] [date] NULL,
-	[VEOPhone] [nvarchar](25) NULL,
+	[VEOPhone] [nvarchar](50) NULL,
 	[ValidityFrom] [datetime] NULL,
 	[ValidityTo] [datetime] NULL,
 	[LegacyID] [int] NULL,
@@ -1151,7 +1151,7 @@ CREATE TABLE [dbo].[tblFeedbackPrompt](
 	[FeedbackPromptDate] [date] NOT NULL,
 	[ClaimID] [int] NULL,
 	[OfficerID] [int] NULL,
-	[PhoneNumber] [nvarchar](25) NULL,
+	[PhoneNumber] [nvarchar](50) NULL,
 	[SMSStatus] [tinyint] NULL,
 	[ValidityFrom] [datetime] NULL,
 	[ValidityTo] [datetime] NULL,
@@ -1566,7 +1566,7 @@ CREATE TABLE [dbo].[tblOfficer](
 	[VEOLastName] [nvarchar](100) NULL,
 	[VEOOtherNames] [nvarchar](100) NULL,
 	[VEODOB] [date] NULL,
-	[VEOPhone] [nvarchar](25) NULL,
+	[VEOPhone] [nvarchar](50) NULL,
 	[ValidityFrom] [datetime] NOT NULL,
 	[ValidityTo] [datetime] NULL,
 	[LegacyID] [int] NULL,
@@ -1656,7 +1656,7 @@ CREATE TABLE [dbo].[tblPayment](
 	[ReceivedAmount] [decimal](18, 2) NULL,
 	[OfficerCode] [nvarchar](50) NULL,
 	[PhoneNumber] [nvarchar](50) NULL,
-	[PayerPhoneNumber] [nvarchar](15) NULL,
+	[PayerPhoneNumber] [nvarchar](50) NULL,
 	[RequestDate] [datetime] NULL,
 	[ReceivedDate] [datetime] NULL,
 	[PaymentStatus] [int] NULL,
@@ -1882,7 +1882,7 @@ CREATE TABLE [dbo].[tblPolicyRenewals](
 	[RenewalPromptDate] [date] NOT NULL,
 	[RenewalDate] [date] NOT NULL,
 	[NewOfficerID] [int] NULL,
-	[PhoneNumber] [nvarchar](25) NULL,
+	[PhoneNumber] [nvarchar](50) NULL,
 	[SMSStatus] [tinyint] NOT NULL,
 	[InsureeID] [int] NOT NULL,
 	[PolicyID] [int] NOT NULL,
diff --git a/sql/migrations/1_migration_latest.sql b/sql/migrations/1_migration_latest.sql
@@ -9388,3 +9388,20 @@ IF (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'tblProduct' AND
 ALTER TABLE tblProduct
 ALTER COLUMN MemberCount Int NOT NULL
 GO
+
+--OTC-578
+IF COL_LENGTH(N'tblPayment', N'PayerPhoneNumber') IS NOT NULL
+	ALTER TABLE tblPayment ALTER COLUMN PayerPhoneNumber NVARCHAR(50)
+GO
+
+IF COL_LENGTH(N'tblOfficer', N'VEOPhone') IS NOT NULL
+	ALTER TABLE tblOfficer ALTER COLUMN VEOPhone NVARCHAR(50)
+GO
+
+IF COL_LENGTH(N'tblFeedbackPrompt', N'PhoneNumber') IS NOT NULL
+	ALTER TABLE tblFeedbackPrompt ALTER COLUMN PhoneNumber NVARCHAR(50)
+GO
+
+IF COL_LENGTH(N'tblPolicyRenewals', N'PhoneNumber') IS NOT NULL
+	ALTER TABLE tblPolicyRenewals ALTER COLUMN PhoneNumber NVARCHAR(50)
+GO
