From b1d035c0b2d921362c0ed8c92b29d52f7e998e54 Mon Sep 17 00:00:00 2001 From: Alexis de Talhouët Date: Mon, 24 Sep 2018 23:33:17 +0200 Subject: Add missing blueprint-processor schema MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Change-Id: Iaad73a01a2a9accfb96c45b0ef39f7c2d4513fd8 Issue-ID: CCSDK-357 Signed-off-by: Alexis de Talhouët Former-commit-id: 906b3a872cb0dbf242b10cec01bdfaa5f26f2118 --- .../main/resources/blueprint-processor.data.dump | 95 ++++++++++++++++++++++ 1 file changed, 95 insertions(+) create mode 100644 installation/sdnc/src/main/resources/blueprint-processor.data.dump diff --git a/installation/sdnc/src/main/resources/blueprint-processor.data.dump b/installation/sdnc/src/main/resources/blueprint-processor.data.dump new file mode 100644 index 00000000..9a4bd3f0 --- /dev/null +++ b/installation/sdnc/src/main/resources/blueprint-processor.data.dump @@ -0,0 +1,95 @@ +-- ----------------------------------------------------- +-- Dropping tables ( One time ) +-- ----------------------------------------------------- + +DROP TABLE sdnctl.CONFIG_RESOURCE_ASSIGNMENT_DATA; +DROP TABLE sdnctl.CONFIG_RESOURCE; +DROP TABLE sdnctl.CONFIG_RESOURCE_RELATION; +DROP TABLE sdnctl.CONFIG_TRANSACTION_LOG + + +-- ----------------------------------------------------- +-- table sdnctl.CONFIG_TRANSACTION_LOG +-- ----------------------------------------------------- +CREATE TABLE IF NOT EXISTS sdnctl.CONFIG_TRANSACTION_LOG ( + config_transaction_log_id VARCHAR(50) NOT NULL, + request_id VARCHAR(50) NULL DEFAULT NULL, + message_type VARCHAR(100) NULL DEFAULT NULL, + creation_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, + message LONGTEXT NULL DEFAULT NULL, + PRIMARY KEY PK_CONFIG_TRANSACTION_LOG (config_transaction_log_id) + ) ENGINE=InnoDB DEFAULT CHARSET=latin1; + + +-- ----------------------------------------------------- +-- table sdnctl.CONFIG_RESOURCE +-- ----------------------------------------------------- +CREATE TABLE IF NOT EXISTS sdnctl.CONFIG_RESOURCE ( + config_resource_id VARCHAR(50) NOT NULL, + resource_id VARCHAR(50) NOT NULL, + resource_type VARCHAR(50) NOT NULL, + service_template_name VARCHAR(50) NULL DEFAULT NULL, + service_template_version VARCHAR(50) NULL DEFAULT NULL, + template_name VARCHAR(50) NOT NULL, + recipe_name VARCHAR(50) NOT NULL, + request_id VARCHAR(50) NOT NULL, + resource_data LONGTEXT NULL DEFAULT NULL, + mask_data LONGTEXT NULL DEFAULT NULL, + created_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, + status VARCHAR(20) NOT NULL, + updated_by VARCHAR(50) NOT NULL, + PRIMARY KEY PK_CONFIG_RESOURCE (config_resource_id), + INDEX IX_CONFIG_RESOURCE (created_date desc) + ) ENGINE=InnoDB DEFAULT CHARSET=latin1; + + +-- ----------------------------------------------------- +-- table sdnctl.CONFIG_RESOURCE_RELATION +-- ----------------------------------------------------- +CREATE TABLE IF NOT EXISTS sdnctl.CONFIG_RESOURCE_RELATION ( + config_resource_relation_id VARCHAR(50) NOT NULL, + resource_id VARCHAR(50) NOT NULL, + related_resource_id VARCHAR(50) NOT NULL, + relation_type VARCHAR(50) NOT NULL DEFAULT 'children', + created_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, + updated_by VARCHAR(50) NOT NULL, + PRIMARY KEY PK_CONFIG_RESOURCE_RELATION (config_resource_relation_id), + INDEX IX_CONFIG_RESOURCE_RELATION (created_date desc), + CONSTRAINT FK_CONFIG_RESOURCE_RELATION_TO_CONFIG_RESOURCE1 + FOREIGN KEY (resource_id) + REFERENCES sdnctl.CONFIG_RESOURCE (config_resource_id) + ON DELETE NO ACTION + ON UPDATE NO ACTION, + CONSTRAINT FK_CONFIG_RESOURCE_RELATION_TO_CONFIG_RESOURCE2 + FOREIGN KEY (related_resource_id) + REFERENCES sdnctl.CONFIG_RESOURCE (config_resource_id) + ON DELETE NO ACTION + ON UPDATE NO ACTION + ) ENGINE=InnoDB DEFAULT CHARSET=latin1; + + +-- ----------------------------------------------------- +-- table sdnctl.CONFIG_RESOURCE_ASSIGNMENT_DATA +-- ----------------------------------------------------- +CREATE TABLE IF NOT EXISTS sdnctl.CONFIG_RESOURCE_ASSIGNMENT_DATA ( + config_resource_assignment_data_id VARCHAR(50) NOT NULL, + config_resource_id VARCHAR(50) NOT NULL, + version INT(11) NOT NULL, + updated_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, + updated_by VARCHAR(50) NOT NULL, + template_key_name VARCHAR(50) NOT NULL, + resource_name VARCHAR(50) NOT NULL, + data_type VARCHAR(100) NOT NULL, + entry_schema VARCHAR(100) NULL DEFAULT NULL, + resource_value LONGTEXT NOT NULL, + source VARCHAR(50) NOT NULL, + status VARCHAR(50) NOT NULL, + message LONGTEXT NOT NULL, + PRIMARY KEY PK_CONFIG_RESOURCE (config_resource_assignment_data_id), + INDEX IX_CONFIG_RESOURCE (updated_date desc), + CONSTRAINT FK_CONFIG_RESOURCE_ASSIGNMENT_DATA + FOREIGN KEY (config_resource_id) + REFERENCES sdnctl.CONFIG_RESOURCE (config_resource_id) + ON DELETE NO ACTION + ON UPDATE NO ACTION + ) ENGINE=InnoDB DEFAULT CHARSET=latin1; \ No newline at end of file -- cgit 1.2.3-korg