diff options
Diffstat (limited to 'ms/blueprintsprocessor/application/src/main/resources/sql')
-rw-r--r-- | ms/blueprintsprocessor/application/src/main/resources/sql/schema-local.sql | 24 | ||||
-rw-r--r-- | ms/blueprintsprocessor/application/src/main/resources/sql/schema.sql | 22 |
2 files changed, 45 insertions, 1 deletions
diff --git a/ms/blueprintsprocessor/application/src/main/resources/sql/schema-local.sql b/ms/blueprintsprocessor/application/src/main/resources/sql/schema-local.sql index 05df4200a..794a3b42a 100644 --- a/ms/blueprintsprocessor/application/src/main/resources/sql/schema-local.sql +++ b/ms/blueprintsprocessor/application/src/main/resources/sql/schema-local.sql @@ -80,4 +80,26 @@ CREATE TABLE IF NOT EXISTS sdnctl.RESOURCE_DICTIONARY ( updated_by VARCHAR(100) NOT NULL, primary key PK_RESOURCE_DICTIONARY (name), INDEX IX_RESOURCE_DICTIONARY (name) -) ENGINE=InnoDB;
\ No newline at end of file +) ENGINE=InnoDB; + +-- ----------------------------------------------------- +-- table BLUEPRINT_WORKFLOW_AUDIT_STATUS +-- ----------------------------------------------------- +CREATE TABLE IF NOT EXISTS sdnctl.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; 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; |