Merge pull request #142 from openimis/feature/OTC-619

delcroip · web-flow · commit 581ca3ce2650 · 2022-06-27T17:20:39.000+02:00
OTC-619: Bulk CN Request, if the GePG server throws an error. IMIS fails to delete those requested CN from DB
diff --git a/sql/base/1_schema_tables.sql b/sql/base/1_schema_tables.sql
@@ -690,6 +690,14 @@ CREATE TYPE [dbo].[xWards] AS TABLE(
 )
 GO
 
+CREATE TYPE [dbo].[xBulkControlNumbers] AS TABLE(
+	BillId INT, 
+	ProdId INT,
+	OfficerId INT, 
+	Amount DECIMAL(18,2)
+)
+GO
+
 
 SET ANSI_NULLS ON
 GO
diff --git a/sql/migrations/1_migration_latest.sql b/sql/migrations/1_migration_latest.sql
@@ -9537,3 +9537,14 @@ IF COL_LENGTH(N'tblPremium', N'SourceVersion') IS NULL
 	ALTER TABLE tblPremium ADD SourceVersion NVARCHAR(15) NULL
 GO
 
+--OTC-619
+IF TYPE_ID('xBulkControlNumbers') IS NULL
+BEGIN
+	CREATE TYPE [dbo].[xBulkControlNumbers] AS TABLE(
+	BillId INT, 
+	ProdId INT,
+	OfficerId INT, 
+	Amount DECIMAL(18,2)
+)
+END
+GO
