CCSDK-3434 CBA workflow status store

Change-Id: Iaeac6fa534c569bbc152e6c8a78c2dd23b6c4b1a
Signed-off-by: Kavitha P <pkavitha@aarnanetworks.com>
Issue-ID: CCSDK-3434

1 files changed, 22 insertions, 0 deletions

diff --git a/ms/blueprintsprocessor/application/src/main/resources/sql/schema.sql b/ms/blueprintsprocessor/application/src/main/resources/sql/schema.sql
index 6dcd2af89..851adcf6c 100644
--- a/ms/blueprintsprocessor/application/src/main/resources/sql/schema.sql
+++ b/ms/blueprintsprocessor/application/src/main/resources/sql/schema.sql
@@ -77,3 +77,25 @@ CREATE TABLE IF NOT EXISTS configurator.RESOURCE_DICTIONARY (
   primary key PK_RESOURCE_DICTIONARY (name),
   INDEX IX_RESOURCE_DICTIONARY (name)
 ) ENGINE=InnoDB;
+
+-- -----------------------------------------------------
+-- table BLUEPRINT_WORKFLOW_AUDIT_STATUS
+-- -----------------------------------------------------
+CREATE TABLE IF NOT EXISTS configurator.BLUEPRINT_WORKFLOW_AUDIT_STATUS (
+  workflow_audit_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY,
+  workflow_task_content longtext NOT NULL,
+  originator_Id varchar(255) NOT NULL,
+  request_Id varchar(255) NOT NULL,
+  subRequest_Id varchar(255) NOT NULL,
+  workflow_name varchar(255) NOT NULL,
+  status varchar(255) NULL,
+  start_time datetime NULL,
+  end_time datetime NULL,
+  updated_date datetime NULL,
+  updated_by varchar(255) NULL,
+  blueprint_version varchar(255) NOT NULL,
+  blueprint_name varchar(255) NOT  NULL,
+  request_mode varchar(255) NULL,
+  workflow_response_content longtext  NULL,
+  blueprint_uuid varchar(255) NULL
+) AUTO_INCREMENT = 1000 ENGINE=InnoDB;