From bbb9c357d80797db89c2323dde0e0bd4047a2bf4 Mon Sep 17 00:00:00 2001 From: c00149107 Date: Fri, 19 Jan 2018 14:37:00 +0800 Subject: [PATCH] Add Category info For Service and Resource Add Category info For Service and Resource,Its used for generic workflow Change-Id: I073b8ac5503b462664b3806834a0aca9892c40b9 Issue-ID: SO-379 Signed-off-by: c00149107 --- .../db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql b/volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql index ca002fb..1a3ae46 100644 --- a/volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql +++ b/volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql @@ -210,6 +210,8 @@ NEUTRON_NETWORK_TYPE varchar(20), DESCRIPTION varchar(1200), ORCHESTRATION_MODE varchar(20), + RESOURCE_CATEGORY varchar(20), + RESOURCE_SUB_CATEGORY varchar(20), HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null, AIC_VERSION_MIN varchar(20) default 2.5 not null, AIC_VERSION_MAX varchar(20) default 2.5, @@ -237,6 +239,7 @@ TOSCA_CSAR_ARTIFACT_UUID varchar(200), CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP, MODEL_INVARIANT_UUID varchar(200) default 'MANUAL_RECORD' not null, + SERVICE_CATEGORY varchar(20), SERVICE_TYPE varchar(20), SERVICE_ROLE varchar(20), primary key (MODEL_UUID) @@ -381,6 +384,8 @@ ORCHESTRATION_MODE varchar(20) not null, AIC_VERSION_MIN varchar(20), AIC_VERSION_MAX varchar(20), + RESOURCE_CATEGORY varchar(20), + RESOURCE_SUB_CATEGORY varchar(20), HEAT_TEMPLATE_ARTIFACT_UUID varchar(200), CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP, primary key (MODEL_UUID) -- 2.16.6