diff options
author | Singal, Kapil (ks220y) <ks220y@att.com> | 2018-09-04 13:19:51 -0400 |
---|---|---|
committer | Singal, Kapil (ks220y) <ks220y@att.com> | 2018-09-04 13:19:51 -0400 |
commit | 7dc239c5f08a2fb1425054cc85d7868400aecf06 (patch) | |
tree | eb05dbc47e742512196a8e6f31aa3e4f65969d4d /blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/sql/schema.sql | |
parent | c5abb16c82343925fe3ae7d350e9ef0fbfa7f89c (diff) |
SDN Controller Blueprints Data Adaptor
Creating SDN Controller Blueprints Data Adaptor Junit Tests
Change-Id: Icc825e46b5b128049ddcd4adc3fdc1037d0bee55
Issue-ID: CCSDK-511
Signed-off-by: Singal, Kapil (ks220y) <ks220y@att.com>
Diffstat (limited to 'blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/sql/schema.sql')
-rw-r--r-- | blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/sql/schema.sql | 46 |
1 files changed, 46 insertions, 0 deletions
diff --git a/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/sql/schema.sql b/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/sql/schema.sql new file mode 100644 index 000000000..15d22e242 --- /dev/null +++ b/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/sql/schema.sql @@ -0,0 +1,46 @@ + +CREATE TABLE IF NOT EXISTS CONFIG_RESOURCE ( + config_resource_id VARCHAR(50) PRIMARY KEY, + 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 +); + +CREATE TABLE IF NOT EXISTS CONFIG_RESOURCE_ASSIGNMENT_DATA ( + config_resource_assignment_data_id VARCHAR(50) PRIMARY KEY, + 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 +); + +CREATE TABLE IF NOT EXISTS CONFIG_TRANSACTION_LOG ( + config_transaction_log_id VARCHAR(50) PRIMARY KEY, + 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 +); + +CREATE TABLE IF NOT EXISTS CONFIG_PROPERTY_MAP ( + reference_key VARCHAR(100) NOT NULL, + reference_value VARCHAR(250) NOT NULL +); + |