diff options
-rw-r--r-- | installation/sdnc/src/main/resources/blueprint-processor.data.dump | 95 |
1 files changed, 95 insertions, 0 deletions
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 |