synching up SO configuration

[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
index b825361..a6a7dc5 100644 (file)
--- 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
@@ -27,10 +27,6 @@
         drop 
         foreign key FK_iff1ayhb1hrp5jhea3vvikuni;
 
-    alter table VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM 
-        drop 
-        foreign key FK_6tdyg2ib5eguh4k2qgofh4fj7;
-
     drop table if exists ALLOTTED_RESOURCE;
 
     drop table if exists ALLOTTED_RESOURCE_CUSTOMIZATION;
@@ -95,7 +91,7 @@
         TOSCA_NODE_TYPE varchar(255),
         SUBCATEGORY varchar(255),
         DESCRIPTION varchar(255),
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         primary key (MODEL_UUID)
     );
 
@@ -111,7 +107,7 @@
         NF_NAMING_CODE varchar(255),
         MIN_INSTANCES integer,
         MAX_INSTANCES integer,
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         primary key (MODEL_CUSTOMIZATION_UUID)
     );
 
@@ -121,7 +117,7 @@
         VERSION varchar(20) not null,
         DESCRIPTION varchar(1200),
         BODY longtext not null,
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD',
         primary key (ARTIFACT_UUID)
     );
@@ -132,7 +128,7 @@
         NAME varchar(255),
         VERSION varchar(255),
         BODY varchar(255),
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         ARTIFACT_CHECKSUM varchar(255),
         primary key (ARTIFACT_UUID)
     );
@@ -151,7 +147,7 @@
         BODY longtext not null,
         TIMEOUT_MINUTES integer,
         DESCRIPTION varchar(1200),
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD' not null,
         primary key (ARTIFACT_UUID)
     );
@@ -174,7 +170,7 @@
         MODEL_VERSION varchar(20),
         MODEL_CUSTOMIZATION_ID varchar(40),
         MODEL_CUSTOMIZATION_NAME varchar(40),
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         primary key (id)
     );
 
@@ -187,7 +183,7 @@
         ORCHESTRATION_URI varchar(256) not null,
         MODEL_PARAM_XSD varchar(2048),
         RECIPE_TIMEOUT integer,
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         primary key (id)
     );
 
@@ -201,7 +197,7 @@
         ORCHESTRATION_URI varchar(256) not null,
         NETWORK_PARAM_XSD varchar(2048),
         RECIPE_TIMEOUT integer,
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         primary key (id)
     );
 
@@ -217,7 +213,7 @@
         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,
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         primary key (MODEL_UUID)
     );
 
@@ -229,7 +225,7 @@
         NETWORK_TYPE varchar(255),
         NETWORK_SCOPE varchar(255),
         NETWORK_ROLE varchar(255),
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         primary key (MODEL_CUSTOMIZATION_UUID)
     );
 
@@ -239,7 +235,7 @@
         MODEL_VERSION varchar(20) not null,
         DESCRIPTION varchar(1200),
         TOSCA_CSAR_ARTIFACT_UUID varchar(200),
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         MODEL_INVARIANT_UUID varchar(200) default 'MANUAL_RECORD' not null,
         SERVICE_TYPE varchar(20),
         SERVICE_ROLE varchar(20),
@@ -251,7 +247,7 @@
         SERVICE_MODEL_UUID varchar(200) not null,
         ACTION varchar(40) not null,
         ORCHESTRATION_URI varchar(256) not null,
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         VERSION_STR varchar(20),
         DESCRIPTION varchar(1200),
         SERVICE_PARAM_XSD varchar(2048),
@@ -263,21 +259,21 @@
     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,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         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,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         primary key (SERVICE_MODEL_UUID, NETWORK_MODEL_CUSTOMIZATION_UUID)
     );
 
     create table SERVICE_TO_RESOURCE_CUSTOMIZATIONS (
         MODEL_TYPE varchar(20) not null,
         RESOURCE_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         SERVICE_MODEL_UUID varchar(200) not null,
         primary key (MODEL_TYPE, RESOURCE_MODEL_CUSTOMIZATION_UUID)
     );
@@ -297,7 +293,7 @@
         ARTIFACT_CHECKSUM varchar(200) not null,
         URL varchar(200) not null,
         DESCRIPTION varchar(1200),
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         primary key (ARTIFACT_UUID)
     );
 
@@ -311,7 +307,7 @@
         IS_BASE integer not null,
         HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null,
         VOL_HEAT_TEMPLATE_ARTIFACT_UUID varchar(200),
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         primary key (MODEL_UUID)
     );
 
@@ -319,7 +315,7 @@
         MODEL_CUSTOMIZATION_UUID varchar(200) not null,
         VF_MODULE_MODEL_UUID varchar(200) not null,
         VOL_ENVIRONMENT_ARTIFACT_UUID varchar(200),
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         HEAT_ENVIRONMENT_ARTIFACT_UUID varchar(200),
         MIN_INSTANCES integer,
         MAX_INSTANCES integer,
@@ -340,7 +336,7 @@
         COMPONENT_TYPE varchar(20) not null,
         HEAT_TEMPLATE_ID integer,
         HEAT_ENVIRONMENT_ID integer,
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         primary key (VNF_ID, COMPONENT_TYPE)
     );
 
@@ -356,7 +352,7 @@
         ORCHESTRATION_URI varchar(256) not null,
         VNF_COMPONENT_PARAM_XSD varchar(2048),
         RECIPE_TIMEOUT integer,
-        CREATION_TIMESTAMP datetime,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         primary key (id)
     );
 
@@ -371,7 +367,7 @@
         ORCHESTRATION_URI varchar(256) not null,
         VNF_PARAM_XSD varchar(2048),
         RECIPE_TIMEOUT integer,
-        CREATION_TIMESTAMP datetime,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         primary key (id)
     );
 
@@ -386,7 +382,7 @@
         AIC_VERSION_MIN varchar(20),
         AIC_VERSION_MAX varchar(20),
         HEAT_TEMPLATE_ARTIFACT_UUID varchar(200),
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         primary key (MODEL_UUID)
     );
 
@@ -401,15 +397,14 @@
         NF_ROLE varchar(200),
         NF_NAMING_CODE varchar(200),
         VNF_RESOURCE_MODEL_UUID varchar(200) not null,
-        CREATION_TIMESTAMP datetime not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         primary key (MODEL_CUSTOMIZATION_UUID)
     );
 
     create table VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM (
         VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
         VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
-        CREATION_TIMESTAMP datetime not null,
-        VNF_RESOURCE_MODEL_UUID varchar(200) not null,
+        CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
         primary key (VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID, VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID)
     );
 
@@ -465,8 +460,3 @@
         add constraint FK_iff1ayhb1hrp5jhea3vvikuni 
         foreign key (VNF_RESOURCE_MODEL_UUID) 
         references VNF_RESOURCE (MODEL_UUID);
-
-    alter table VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM 
-        add constraint FK_6tdyg2ib5eguh4k2qgofh4fj7 
-        foreign key (VNF_RESOURCE_MODEL_UUID) 
-        references VNF_RESOURCE_CUSTOMIZATION (MODEL_CUSTOMIZATION_UUID);