From 6e75dd1bfd8c1a4625c9c61a60883d28ca88fff7 Mon Sep 17 00:00:00 2001 From: "andre.schmid" Date: Thu, 29 Jul 2021 10:14:19 +0100 Subject: Handle VSP package upload for multi-model MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Change-Id: Iceca3f160eaeb1a6431fc3c5bbab92847e95ae4d Issue-ID: SDC-3667 Signed-off-by: André Schmid --- openecomp-be/tools/install/database/init_schemas.cql | 20 +++++++++++++++++++- .../upgrade-scripts/20210729-dox.package_details.cql | 2 ++ 2 files changed, 21 insertions(+), 1 deletion(-) create mode 100644 openecomp-be/tools/install/database/upgrade-scripts/20210729-dox.package_details.cql (limited to 'openecomp-be/tools') diff --git a/openecomp-be/tools/install/database/init_schemas.cql b/openecomp-be/tools/install/database/init_schemas.cql index 0569a12f65..7e3bc0a0b2 100644 --- a/openecomp-be/tools/install/database/init_schemas.cql +++ b/openecomp-be/tools/install/database/init_schemas.cql @@ -4,7 +4,25 @@ CREATE TYPE IF NOT EXISTS user_candidate_version (version frozen, user CREATE TABLE IF NOT EXISTS version_info (entity_type text, entity_id text, active_version frozen, status text, candidate frozen, viewable_versions set>, latest_final_version frozen, PRIMARY KEY (entity_type, entity_id)); CREATE TABLE IF NOT EXISTS version_info_deleted (entity_type text, entity_id text, active_version frozen, status text, candidate frozen, viewable_versions set>, latest_final_version frozen, PRIMARY KEY (entity_type, entity_id)); CREATE TABLE IF NOT EXISTS unique_value (type text, value text, PRIMARY KEY ((type, value))); -CREATE TABLE IF NOT EXISTS package_details (VSP_ID text, version text,DISPLAY_NAME text,vsp_name text,vsp_description text,VENDOR_NAME text,CATEGORY text,SUB_CATEGORY text,VENDOR_RELEASE text,PACKAGE_CHECKSUM text,PACKAGE_TYPE text, RESOURCE_TYPE text, TRANSLATE_CONTENT blob,PRIMARY KEY ((VSP_ID, version))); +CREATE TABLE IF NOT EXISTS package_details +( + VSP_ID text, + version text, + version_id text, + DISPLAY_NAME text, + vsp_name text, + vsp_description text, + VENDOR_NAME text, + CATEGORY text, + SUB_CATEGORY text, + VENDOR_RELEASE text, + PACKAGE_CHECKSUM text, + PACKAGE_TYPE text, + RESOURCE_TYPE text, + models set, + TRANSLATE_CONTENT blob, + PRIMARY KEY ((VSP_ID, version)) +); CREATE TABLE IF NOT EXISTS vsp_enriched_service_template (vsp_id text, version frozen, base_name text static, name text, content_data blob, PRIMARY KEY ((vsp_id, version), name)); CREATE TABLE IF NOT EXISTS vsp_enriched_service_artifact (vsp_id text, version frozen, name text, content_data blob, PRIMARY KEY ((vsp_id, version), name)); CREATE TABLE IF NOT EXISTS application_config (namespace text, key text, value text, PRIMARY KEY (namespace, key)); diff --git a/openecomp-be/tools/install/database/upgrade-scripts/20210729-dox.package_details.cql b/openecomp-be/tools/install/database/upgrade-scripts/20210729-dox.package_details.cql new file mode 100644 index 0000000000..9836fa7616 --- /dev/null +++ b/openecomp-be/tools/install/database/upgrade-scripts/20210729-dox.package_details.cql @@ -0,0 +1,2 @@ +ALTER TABLE dox.package_details ADD models set; +ALTER TABLE dox.package_details ADD version_id text; \ No newline at end of file -- cgit 1.2.3-korg