Add ability to deploy mso 1.1 in K8s

[oom.git] / kubernetes / config / docker / init / src / config / mso / mariadb / docker-entrypoint-initdb.d / db-sql-scripts / main-schemas / MySQL-Catalog-schema.sql

diff --git a/kubernetes/config/docker/init/src/config/mso/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql b/kubernetes/config/docker/init/src/config/mso/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql
old mode 100755 (executable)
new mode 100644 (file)
index 38e7117..3816374
--- a/kubernetes/config/docker/init/src/config/mso/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql
+++ b/kubernetes/config/docker/init/src/config/mso/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql
@@ -7,10 +7,16 @@
         drop 
         foreign key FK_8sxvm215cw3tjfh3wni2y3myx;
 
+    alter table MODEL_RECIPE 
+        drop 
+        foreign key FK_c23r0puyqug6n44jg39dutm1c;
+
     alter table SERVICE_RECIPE 
         drop 
         foreign key FK_kv13yx013qtqkn94d5gkwbu3s;
 
+    drop table if exists ALLOTTED_RESOURCE_CUSTOMIZATION;
+
     drop table if exists HEAT_ENVIRONMENT;
 
     drop table if exists HEAT_FILES;
@@ -21,14 +27,24 @@
 
     drop table if exists HEAT_TEMPLATE_PARAMS;
 
+    drop table if exists MODEL;
+
+    drop table if exists MODEL_RECIPE;
+
     drop table if exists NETWORK_RECIPE;
 
     drop table if exists NETWORK_RESOURCE;
 
+    drop table if exists NETWORK_RESOURCE_CUSTOMIZATION;
+
     drop table if exists SERVICE;
 
     drop table if exists SERVICE_RECIPE;
 
+    drop table if exists SERVICE_TO_ALLOTTED_RESOURCES;
+
+    drop table if exists SERVICE_TO_NETWORKS;
+
     drop table if exists VF_MODULE;
 
     drop table if exists VF_MODULE_TO_HEAT_FILES;
@@ -41,30 +57,44 @@
 
     drop table if exists VNF_RESOURCE;
 
+    create table ALLOTTED_RESOURCE_CUSTOMIZATION (
+        MODEL_CUSTOMIZATION_UUID varchar(200) not null,
+        MODEL_VERSION varchar(20) not null,
+        MODEL_UUID varchar(200) not null,
+        MODEL_NAME varchar(200) not null,
+        MODEL_INSTANCE_NAME varchar(200) not null,
+        CREATION_TIMESTAMP datetime not null,
+        DESCRIPTION varchar(200) default null,
+        MODEL_INVARIANT_UUID varchar(200) not null,
+        primary key (MODEL_CUSTOMIZATION_UUID)
+    );
+
     create table HEAT_ENVIRONMENT (
         id integer not null auto_increment,
         NAME varchar(100) not null,
         VERSION varchar(20) not null,
         ASDC_RESOURCE_NAME varchar(100) default 'MANUAL RECORD' not null,
+        ASDC_UUID varchar(200) default 'MANUAL RECORD' not null,
         DESCRIPTION varchar(1200),
         ENVIRONMENT longtext not null,
         CREATION_TIMESTAMP datetime not null,
-        ASDC_UUID varchar(200) default 'MANUAL RECORD',
         ASDC_LABEL varchar(200),
+        ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD' not null,
         primary key (id)
     );
 
     create table HEAT_FILES (
         id integer not null auto_increment,
+        DESCRIPTION varchar(1200) default null,
         FILE_NAME varchar(200) not null,
         ASDC_RESOURCE_NAME varchar(100) not null,
         VERSION varchar(20) not null,
-        VNF_RESOURCE_ID integer,
-        DESCRIPTION varchar(1200),
+        ASDC_UUID varchar(200) default 'MANUAL RECORD',
         FILE_BODY longtext not null,
+        VNF_RESOURCE_ID integer default null,
         CREATION_TIMESTAMP datetime not null,
-        ASDC_UUID varchar(200),
         ASDC_LABEL varchar(200),
+        ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD' not null,
         primary key (id)
     );
 
@@ -80,12 +110,13 @@
         TEMPLATE_NAME varchar(200) not null,
         VERSION varchar(20) not null,
         ASDC_RESOURCE_NAME varchar(100) default 'MANUAL RECORD' not null,
+        ASDC_UUID varchar(200) default 'MANUAL RECORD' not null,
         TEMPLATE_PATH varchar(100),
         TEMPLATE_BODY longtext not null,
         TIMEOUT_MINUTES integer,
-        ASDC_UUID varchar(200) default 'MANUAL RECORD' not null,
         DESCRIPTION varchar(1200),
         ASDC_LABEL varchar(200),
+        ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD' not null,
         CREATION_TIMESTAMP datetime not null,
         CHILD_TEMPLATE_ID integer,
         primary key (id)
@@ -101,16 +132,42 @@
         primary key (id)
     );
 
+    create table MODEL (
+        id integer not null auto_increment,
+        MODEL_TYPE varchar(20) not null,
+        MODEL_VERSION_ID varchar(40) not null,
+        MODEL_INVARIANT_ID varchar(40),
+        MODEL_NAME varchar(40) not null,
+        MODEL_VERSION varchar(20),
+        MODEL_CUSTOMIZATION_ID varchar(40),
+        MODEL_CUSTOMIZATION_NAME varchar(40),
+        CREATION_TIMESTAMP datetime not null,
+        primary key (id)
+    );
+
+    create table MODEL_RECIPE (
+        id integer not null auto_increment,
+        MODEL_ID integer not null,
+        ACTION varchar(20) not null,
+        SCHEMA_VERSION varchar(20),
+        DESCRIPTION varchar(1200),
+        ORCHESTRATION_URI varchar(256) not null,
+        MODEL_PARAM_XSD varchar(2048),
+        RECIPE_TIMEOUT integer,
+        CREATION_TIMESTAMP datetime not null,
+        primary key (id)
+    );
+
     create table NETWORK_RECIPE (
         id integer not null auto_increment,
         NETWORK_TYPE 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,
         NETWORK_PARAM_XSD varchar(2048),
         RECIPE_TIMEOUT integer,
+        SERVICE_TYPE varchar(45) default null,
         CREATION_TIMESTAMP datetime not null,
         primary key (id)
     );
@@ -122,19 +179,31 @@
         ORCHESTRATION_MODE varchar(20),
         DESCRIPTION varchar(1200),
         TEMPLATE_ID integer,
+        NEUTRON_NETWORK_TYPE varchar(20) default null,
         CREATION_TIMESTAMP datetime not null,
-        AIC_VERSION_MIN varchar(20) default 2.5,
-        AIC_VERSION_MAX varchar(20) default 2.5,
-        NEUTRON_NETWORK_TYPE varchar(20),
+        AIC_VERSION_MIN varchar(20) not null,
+        AIC_VERSION_MAX varchar(20) default null,
         primary key (id)
     );
 
+    create table NETWORK_RESOURCE_CUSTOMIZATION (
+        MODEL_CUSTOMIZATION_UUID varchar(200) not null,
+        NETWORK_RESOURCE_ID integer default null,
+        MODEL_UUID varchar(200) not null,
+        MODEL_NAME varchar(200) not null,
+        MODEL_INSTANCE_NAME varchar(200) not null,
+        MODEL_VERSION varchar(20) not null,
+        MODEL_INVARIANT_UUID varchar(200) not null,
+        CREATION_TIMESTAMP datetime not null,
+        primary key (MODEL_CUSTOMIZATION_UUID, NETWORK_RESOURCE_ID)
+    );
+
     create table SERVICE (
         id integer not null auto_increment,
+        SERVICE_NAME_VERSION_ID varchar(50) default 'MANUAL_RECORD' not null,
         SERVICE_NAME varchar(40),
-        VERSION_STR varchar(20),
+        VERSION_STR varchar(20) not null,
         DESCRIPTION varchar(1200),
-        SERVICE_NAME_VERSION_ID varchar(50),
         SERVICE_VERSION varchar(10),
         HTTP_METHOD varchar(50),
         CREATION_TIMESTAMP datetime not null,
@@ -146,7 +215,7 @@
         id integer not null auto_increment,
         SERVICE_ID integer not null,
         ACTION varchar(40) not null,
-        VERSION_STR varchar(20),
+        VERSION_STR varchar(20) default null,
         DESCRIPTION varchar(1200),
         ORCHESTRATION_URI varchar(256) not null,
         SERVICE_PARAM_XSD varchar(2048),
@@ -156,22 +225,41 @@
         primary key (id)
     );
 
+    create table SERVICE_TO_ALLOTTED_RESOURCES (
+        SERVICE_MODEL_UUID varchar(200) not null,
+        AR_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
+        CREATION_TIMESTAMP datetime not null,
+        primary key (SERVICE_MODEL_UUID, AR_MODEL_CUSTOMIZATION_UUID)
+    );
+
+    create table SERVICE_TO_NETWORKS (
+        SERVICE_MODEL_UUID varchar(200) not null,
+        NETWORK_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
+        CREATION_TIMESTAMP datetime not null,
+        primary key (SERVICE_MODEL_UUID, NETWORK_MODEL_CUSTOMIZATION_UUID)
+    );
+
     create table VF_MODULE (
         id integer not null auto_increment,
+        ASDC_UUID varchar(200) default null,
+        VOL_ENVIRONMENT_ID integer default null,
         TYPE varchar(200) not null,
         ASDC_SERVICE_MODEL_VERSION varchar(20) not null,
+        MODEL_CUSTOMIZATION_UUID varchar(200),
         MODEL_NAME varchar(200) not null,
         MODEL_VERSION varchar(20) not null,
-        ASDC_UUID varchar(255),
-        VOL_ENVIRONMENT_ID integer,
-        TEMPLATE_ID integer,
-        IS_BASE integer not null,
         CREATION_TIMESTAMP datetime not null,
-        DESCRIPTION varchar(255),
-        VOL_TEMPLATE_ID integer,
+        DESCRIPTION varchar(255) default null,
+        VOL_TEMPLATE_ID integer default null,
+        TEMPLATE_ID integer default null,
         VNF_RESOURCE_ID integer not null,
+        IS_BASE integer not null,
         ENVIRONMENT_ID integer,
-        MODEL_INVARIANT_UUID varchar(255),
+        MODEL_INVARIANT_UUID varchar(200) default null,
+        MIN_INSTANCES integer default 0,
+        MAX_INSTANCES integer default null,
+        INITIAL_COUNT integer default 0,
+        LABEL varchar(200) default null,
         primary key (id)
     );
 
@@ -193,10 +281,10 @@
     create table VNF_COMPONENTS_RECIPE (
         id integer not null auto_increment,
         VNF_TYPE varchar(200),
-        VF_MODULE_ID varchar(100),
         VNF_COMPONENT_TYPE varchar(45) not null,
+        VF_MODULE_ID varchar(100),
         ACTION varchar(20) not null,
-        SERVICE_TYPE varchar(45),
+        SERVICE_TYPE varchar(45) default null,
         VERSION varchar(20),
         DESCRIPTION varchar(1200),
         ORCHESTRATION_URI varchar(256) not null,
@@ -212,7 +300,7 @@
         ACTION varchar(20) not null,
         VERSION_STR varchar(20) not null,
         VNF_TYPE varchar(200),
-        SERVICE_TYPE varchar(45),
+        SERVICE_TYPE varchar(45) default null,
         DESCRIPTION varchar(1200),
         ORCHESTRATION_URI varchar(256) not null,
         VNF_PARAM_XSD varchar(2048),
@@ -225,6 +313,8 @@
         id integer not null auto_increment,
         VNF_TYPE varchar(200) not null,
         ASDC_SERVICE_MODEL_VERSION varchar(20) not null,
+        SERVICE_MODEL_INVARIANT_UUID varchar(200),
+        MODEL_CUSTOMIZATION_NAME varchar(200),
         ORCHESTRATION_MODE varchar(20) not null,
         DESCRIPTION varchar(1200),
         TEMPLATE_ID integer,
@@ -235,30 +325,38 @@
         AIC_VERSION_MAX varchar(20),
         MODEL_INVARIANT_UUID varchar(200),
         MODEL_VERSION varchar(20) not null,
-        MODEL_CUSTOMIZATION_NAME varchar(200),
         MODEL_NAME varchar(200),
-        SERVICE_MODEL_INVARIANT_UUID varchar(200),
+        MODEL_CUSTOMIZATION_UUID varchar(255),
         primary key (id)
     );
 
     alter table HEAT_ENVIRONMENT 
-        add constraint UK_a4jkta7hgpa99brceaxasnfqp  unique (NAME, VERSION, ASDC_RESOURCE_NAME);
+        add constraint UK_5wd9texshmrbg5ou83a5p70uk  unique (NAME, VERSION, ASDC_RESOURCE_NAME, ASDC_UUID);
 
     alter table HEAT_FILES 
-        add constraint UK_m23vfqc1tdvj7d6f0jjo4cl7e  unique (FILE_NAME, ASDC_RESOURCE_NAME, VERSION);
+        add constraint UK_d3ctpcskoryvei0o24ib3dhj2  unique (FILE_NAME, ASDC_RESOURCE_NAME, VERSION, ASDC_UUID);
 
     alter table HEAT_TEMPLATE 
-        add constraint UK_k1tq7vblss8ykiwhiltnkg6no  unique (TEMPLATE_NAME, VERSION, ASDC_RESOURCE_NAME);
+        add constraint UK_rpbyrb4spcnldds0evbyvucvi  unique (TEMPLATE_NAME, VERSION, ASDC_RESOURCE_NAME, ASDC_UUID);
 
     alter table HEAT_TEMPLATE_PARAMS 
         add constraint UK_pj3cwbmewecf0joqv2mvmbvw3  unique (HEAT_TEMPLATE_ID, PARAM_NAME);
 
+    alter table MODEL 
+        add constraint UK_rra00f1rk6eyy7g00k9raxh2v  unique (MODEL_TYPE, MODEL_VERSION_ID);
+
+    alter table MODEL_RECIPE 
+        add constraint UK_b4g8j9wtqrkxfycyi3ursk7gb  unique (MODEL_ID, ACTION);
+
     alter table NETWORK_RECIPE 
         add constraint UK_rl4f296i0p8lyokxveaiwkayi  unique (NETWORK_TYPE, ACTION, VERSION_STR);
 
     alter table NETWORK_RESOURCE 
         add constraint UK_i4hpdnu3rmdsit3m6fw1ynguq  unique (NETWORK_TYPE, VERSION_STR);
 
+    alter table SERVICE 
+        add constraint UK_iopodavyy29kj79umla8oarak  unique (SERVICE_NAME_VERSION_ID, SERVICE_NAME);
+
     alter table SERVICE_RECIPE 
         add constraint UK_7fav5dkux2v8g9d2i5ymudlgc  unique (SERVICE_ID, ACTION);
 
@@ -266,13 +364,13 @@
         add constraint UK_o3bvdqspginaxlp4gxqohd44l  unique (TYPE, ASDC_SERVICE_MODEL_VERSION);
 
     alter table VNF_COMPONENTS_RECIPE 
-        add constraint UK_4dpdwddaaclhc11wxsb7h59ma  unique (VNF_TYPE, VF_MODULE_ID, VNF_COMPONENT_TYPE, ACTION, SERVICE_TYPE, VERSION);
+        add constraint UK_4dpdwddaaclhc11wxsb7h59ma  unique (VNF_TYPE, VNF_COMPONENT_TYPE, VF_MODULE_ID, ACTION, SERVICE_TYPE, VERSION);
 
     alter table VNF_RECIPE 
         add constraint UK_f3tvqau498vrifq3cr8qnigkr  unique (VF_MODULE_ID, ACTION, VERSION_STR);
 
     alter table VNF_RESOURCE 
-        add constraint UK_k10a0w7h4t0lnbynd3inkg67k  unique (VNF_TYPE, ASDC_SERVICE_MODEL_VERSION);
+        add constraint UK_peslcm0k3yojkrj6cvdv1rttb  unique (VNF_TYPE, ASDC_SERVICE_MODEL_VERSION, SERVICE_MODEL_INVARIANT_UUID);
 
     alter table HEAT_TEMPLATE 
         add constraint FK_ek5sot1q07taorbdmkvnveu98 
@@ -284,6 +382,11 @@
         foreign key (HEAT_TEMPLATE_ID) 
         references HEAT_TEMPLATE (id);
 
+    alter table MODEL_RECIPE 
+        add constraint FK_c23r0puyqug6n44jg39dutm1c 
+        foreign key (MODEL_ID) 
+        references MODEL (id);
+
     alter table SERVICE_RECIPE 
         add constraint FK_kv13yx013qtqkn94d5gkwbu3s 
         foreign key (SERVICE_ID)