Create the following new tables in MySQL sdnctl database.

1. New table name: multistep_flow_reference

Description: This table determines if a request is process as multistep flow.

Details: 

• Sequence type values can include ‘dt_multi’, ‘runtime_multi’
• Category values match the asdc_reference.file_category or request_artifacts.category

CREATE TABLE `multistep_flow_reference` (

  `MULTISTEP_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,

  `ACTION` varchar(50) NOT NULL,

  `ACTION-LEVEL` varchar(50) DEFAULT NULL,

  `VNF_TYPE` varchar(50) DEFAULT NULL,

  `SEQUENCE_TYPE` varchar(50) DEFAULT NULL,

  `CATEGORY` varchar(50) DEFAULT NULL,

  `GENERATION_NODE` varchar(50) DEFAULT NULL,

  `EXECUTION_NODE` varchar(50) DEFAULT NULL,

  `CREATOR` varchar(50) DEFAULT NULL,

  `UPDATED_DATE` datetime, DEFAULT NULL,

  UNIQUE KEY ` MULTISTEP_FLOW_REFERENCE_ID` (`MULTISTEP_FLOW_REFERENCE_ID`)

);

 

1. New table name: process_flow_reference

Description: This table contains details by action and vnf-type for processing a request.

 

Details:

CREATE TABLE `process_flow_reference` (

  `PROCESS_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,

  `ACTION` varchar(50) NOT NULL,

  `ACTION_LEVEL` varchar(50) DEFAULT NULL,

  `PROTOCOL` varchar(50) DEFAULT NULL,

  `EXECUTION_DG` varchar(50) NOT NULL,

  `UPDATED_DATE` datetime, DEFAULT NULL,

  PRIMARY KEY (`PROCESS_FLOW_REFERENCE_ID`),

  UNIQUE KEY `PROCESS_FLOW_REFERENCE_ID` (`PROCESS_FLOW_REFERENCE_ID`)

);

1. New table name: protocol_reference

Description: This table contains details by action and vnf-type for processing a request.

 

Details:

CREATE TABLE `protocol_reference` (

  `PROTOCOL_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,

  `ACTION` varchar(50) NOT NULL,

  `ACTION_LEVEL` varchar(50) NOT NULL,

  `VNF_TYPE` varchar(50) DEFAULT NULL,

  `PROTOCOL` varchar(50) DEFAULT NULL,

  `TEMPLATE` varchar(50) DEFAULT NULL,

  `UPDATED_DATE` datetime, DEFAULT NULL,

  PRIMARY KEY (`PROTOCOL_ REFERENCE_ID`),

  UNIQUE KEY ` PROTOCOL_REFERENCE_ID` (`PROTOCOL_REFERENCE_ID`)

);

 

1. New table name: request_artifacts

Description: This table contains artifacts that are created for a request, such as a sequence flow.

 

Details:

CREATE TABLE `request_artifacts` (

  `REQUEST_ARTIFACTS_ID` int(11) NOT NULL AUTO_INCREMENT,

  `REQUEST_ID` varchar(50) NOT NULL,

  `ACTION` varchar(50) NOT NULL,

  `ACTION_LEVEL` varchar(50) DEFAULT NULL,

  `VNF_TYPE` varchar(50) DEFAULT NULL,

  `CATEGORY` varchar(50) NOT NULL,

  `ARTIFACT_CONTENT` longtext,

  `UPDATED_DATE` datetime, DEFAULT NULL,

  PRIMARY KEY (`REQUEST_ARTIFACTS_ID`),

  UNIQUE KEY `REQUEST_ARTIFACTS_ID` (`REQUEST_ARTIFACTS_ID`)

);