From 4f1ed42e92332e9cd82a25b76f341757cb82bb18 Mon Sep 17 00:00:00 2001 From: c00149107 Date: Tue, 6 Mar 2018 15:35:53 +0800 Subject: Add allotted resource recipe table Add allotted resource recipe table Change-Id: I15b81651ad2a97706ff398068ac011173a78cfe8 Issue-ID: SO-456 Signed-off-by: c00149107 --- .../db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'volumes') 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 1a3ae46..585a50d 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 @@ -30,6 +30,8 @@ drop table if exists ALLOTTED_RESOURCE; drop table if exists ALLOTTED_RESOURCE_CUSTOMIZATION; + + drop table if exists AR_RECIPE; drop table if exists HEAT_ENVIRONMENT; @@ -111,6 +113,20 @@ primary key (MODEL_CUSTOMIZATION_UUID) ); + create table AR_RECIPE ( + id integer not null auto_increment, + MODEL_NAME varchar(20) not null, + ACTION varchar(20) not null, + VERSION_STR varchar(20) not null, + SERVICE_TYPE varchar(45), + DESCRIPTION varchar(1200), + ORCHESTRATION_URI varchar(256) not null, + AR_PARAM_XSD varchar(2048), + RECIPE_TIMEOUT integer, + CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP, + primary key (id) + ); + create table HEAT_ENVIRONMENT ( ARTIFACT_UUID varchar(200) not null, NAME varchar(100) not null, -- cgit 1.2.3-korg