diff options
Diffstat (limited to 'blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/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 +); + |