Add allotted resource recipe table

[so/docker-config.git] / volumes / mariadb / docker-entrypoint-initdb.d / db-sql-scripts / main-schemas / MySQL-Catalog-schema.sql

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..585a50d 100644 (file)
--- 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,
@@ -210,6 +226,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 +255,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 +400,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)