summaryrefslogtreecommitdiffstats
path: root/extra/sql/bulkload
diff options
context:
space:
mode:
authornrpandya <neenendra.pandya@att.com>2019-11-21 11:51:18 -0600
committersebdet <sebastien.determe@intl.att.com>2020-01-16 13:26:16 +0100
commit825612628f130b394f9ee1aa1ad2cca41b67bc7f (patch)
tree51b3e3311ba93e878dc2f457ba2e4937dd3053f7 /extra/sql/bulkload
parent62a0b7ca40d7810897fce2d1f8eb47e5647a2bf2 (diff)
Add template and tosca model entities and repositories
Add Control loop template, tosca model and model policy properties hibernate entity classes and crud repositories Issue-ID: CLAMP-555 Change-Id: Ib7f07aca5ad2ddf5caff7c98ea9341bdc147e817 Signed-off-by: nrpandya <neenendra.pandya@att.com>
Diffstat (limited to 'extra/sql/bulkload')
-rw-r--r--extra/sql/bulkload/create-tables.sql130
1 files changed, 129 insertions, 1 deletions
diff --git a/extra/sql/bulkload/create-tables.sql b/extra/sql/bulkload/create-tables.sql
index 6e9ff7c86..c5b52d717 100644
--- a/extra/sql/bulkload/create-tables.sql
+++ b/extra/sql/bulkload/create-tables.sql
@@ -1,4 +1,29 @@
+ create table dictionary (
+ name varchar(255) not null,
+ created_by varchar(255),
+ created_timestamp datetime(6) not null,
+ updated_by varchar(255),
+ updated_timestamp datetime(6) not null,
+ dictionary_second_level integer,
+ dictionary_type varchar(255),
+ primary key (name)
+ ) engine=InnoDB;
+
+ create table dictionary_elements (
+ name varchar(255) not null,
+ created_by varchar(255),
+ created_timestamp datetime(6) not null,
+ updated_by varchar(255),
+ updated_timestamp datetime(6) not null,
+ description varchar(255),
+ short_name varchar(255) not null,
+ subdictionary_id varchar(255) not null,
+ type varchar(255) not null,
+ dictionary_id varchar(255),
+ primary key (name)
+ ) engine=InnoDB;
+
create table hibernate_sequence (
next_val bigint
) engine=InnoDB;
@@ -15,8 +40,25 @@
primary key (id)
) engine=InnoDB;
+ create table loop_templates (
+ name varchar(255) not null,
+ created_by varchar(255),
+ created_timestamp datetime(6) not null,
+ updated_by varchar(255),
+ updated_timestamp datetime(6) not null,
+ blueprint_yaml MEDIUMTEXT not null,
+ maximum_instances_allowed integer,
+ svg_representation MEDIUMTEXT,
+ service_uuid varchar(255),
+ primary key (name)
+ ) engine=InnoDB;
+
create table loops (
name varchar(255) not null,
+ created_by varchar(255),
+ created_timestamp datetime(6) not null,
+ updated_by varchar(255),
+ updated_timestamp datetime(6) not null,
blueprint_yaml MEDIUMTEXT not null,
dcae_blueprint_id varchar(255),
dcae_deployment_id varchar(255),
@@ -24,6 +66,7 @@
global_properties_json json,
last_computed_state varchar(255) not null,
svg_representation MEDIUMTEXT,
+ loop_template_name varchar(255),
service_uuid varchar(255),
primary key (name)
) engine=InnoDB;
@@ -34,13 +77,33 @@
primary key (loop_id, microservicepolicy_id)
) engine=InnoDB;
+ create table micro_service_models (
+ name varchar(255) not null,
+ created_by varchar(255),
+ created_timestamp datetime(6) not null,
+ updated_by varchar(255),
+ updated_timestamp datetime(6) not null,
+ blueprint_yaml varchar(255) not null,
+ policy_type varchar(255) not null,
+ policy_model_type varchar(255),
+ policy_model_version varchar(255),
+ primary key (name)
+ ) engine=InnoDB;
+
create table micro_service_policies (
name varchar(255) not null,
+ created_by varchar(255),
+ created_timestamp datetime(6) not null,
+ updated_by varchar(255),
+ updated_timestamp datetime(6) not null,
+ context varchar(255),
+ device_type_scope varchar(255),
json_representation json not null,
- model_type varchar(255) not null,
+ policy_model_type varchar(255) not null,
policy_tosca MEDIUMTEXT not null,
properties json,
shared bit not null,
+ micro_service_model_id varchar(255),
primary key (name)
) engine=InnoDB;
@@ -49,9 +112,24 @@
configurations_json json,
json_representation json not null,
loop_id varchar(255) not null,
+ policy_model_type varchar(255),
+ policy_model_version varchar(255),
primary key (name)
) engine=InnoDB;
+ create table policy_models (
+ policy_model_type varchar(255) not null,
+ version varchar(255) not null,
+ created_by varchar(255),
+ created_timestamp datetime(6) not null,
+ updated_by varchar(255),
+ updated_timestamp datetime(6) not null,
+ policy_acronym varchar(255),
+ policy_tosca MEDIUMTEXT,
+ policy_variant varchar(255),
+ primary key (policy_model_type, version)
+ ) engine=InnoDB;
+
create table services (
service_uuid varchar(255) not null,
name varchar(255) not null,
@@ -61,11 +139,36 @@
primary key (service_uuid)
) engine=InnoDB;
+ create table templates_microservicemodels (
+ loop_template_name varchar(255) not null,
+ micro_service_model_name varchar(255) not null,
+ flow_order integer not null,
+ primary key (loop_template_name, micro_service_model_name)
+ ) engine=InnoDB;
+
+ alter table dictionary_elements
+ add constraint UK_qxkrvsrhp26m60apfvxphpl3d unique (short_name);
+
+ alter table dictionary_elements
+ add constraint FKn87bpgpm9i56w7uko585rbkgn
+ foreign key (dictionary_id)
+ references dictionary (name);
+
alter table loop_logs
add constraint FK1j0cda46aickcaoxqoo34khg2
foreign key (loop_id)
references loops (name);
+ alter table loop_templates
+ add constraint FKn692dk6281wvp1o95074uacn6
+ foreign key (service_uuid)
+ references services (service_uuid);
+
+ alter table loops
+ add constraint FK844uwy82wt0l66jljkjqembpj
+ foreign key (loop_template_name)
+ references loop_templates (name);
+
alter table loops
add constraint FK4b9wnqopxogwek014i1shqw7w
foreign key (service_uuid)
@@ -81,7 +184,32 @@
foreign key (loop_id)
references loops (name);
+ alter table micro_service_models
+ add constraint FKlkcffpnuavcg65u5o4tr66902
+ foreign key (policy_model_type, policy_model_version)
+ references policy_models (policy_model_type, version);
+
+ alter table micro_service_policies
+ add constraint FK5p7lipy9m2v7d4n3fvlclwse
+ foreign key (micro_service_model_id)
+ references micro_service_models (name);
+
alter table operational_policies
add constraint FK1ddoggk9ni2bnqighv6ecmuwu
foreign key (loop_id)
references loops (name);
+
+ alter table operational_policies
+ add constraint FKlsyhfkoqvkwj78ofepxhoctip
+ foreign key (policy_model_type, policy_model_version)
+ references policy_models (policy_model_type, version);
+
+ alter table templates_microservicemodels
+ add constraint FKq2gqg5q9jrkx8voosn7x5plqo
+ foreign key (loop_template_name)
+ references loop_templates (name);
+
+ alter table templates_microservicemodels
+ add constraint FKphn3m81suxavmj9c4u06cchju
+ foreign key (micro_service_model_name)
+ references micro_service_models (name);