From: c00149107 <chenchuanyu@huawei.com>
Date: Tue, 6 Mar 2018 07:35:53 +0000 (+0800)
Subject: Add allotted resource recipe table
X-Git-Tag: 2.0.0-ONAP~25^2
X-Git-Url: https://gerrit.onap.org/r/gitweb?p=so%2Fdocker-config.git;a=commitdiff_plain;h=4f1ed42e92332e9cd82a25b76f341757cb82bb18

Add allotted resource recipe table

Add allotted resource recipe table

Change-Id: I15b81651ad2a97706ff398068ac011173a78cfe8
Issue-ID: SO-456
Signed-off-by: c00149107 <chenchuanyu@huawei.com>
---

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,