diff options
| author |   c00149107 <chenchuanyu@huawei.com> | 2018-03-06 15:35:53 +0800 |
|---|---|---|
| committer | c00149107 <chenchuanyu@huawei.com> | 2018-03-06 15:35:53 +0800 |
| commit | 4f1ed42e92332e9cd82a25b76f341757cb82bb18 (patch) | |
| tree | eed323d75aeff1d8ba03aee2c34cabedb2a04851 | |
| parent | bbb9c357d80797db89c2323dde0e0bd4047a2bf4 (diff) | |
Add allotted resource recipe table
Add allotted resource recipe table
Change-Id: I15b81651ad2a97706ff398068ac011173a78cfe8
Issue-ID: SO-456
Signed-off-by: c00149107 <chenchuanyu@huawei.com>
| -rw-r--r-- | volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql | 16 |
1 files changed, 16 insertions, 0 deletions
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, |