diff options
Diffstat (limited to 'volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql')
| -rw-r--r-- | volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql | 161 |
1 files changed, 132 insertions, 29 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 38e7117..3816374 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 @@ -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) |