2 create table hibernate_sequence (
6 insert into hibernate_sequence values ( 1 );
8 create table loop_logs (
10 log_instant datetime(6) not null,
11 log_type varchar(255) not null,
12 message varchar(255) not null,
13 loop_id varchar(255) not null,
18 name varchar(255) not null,
19 blueprint_yaml MEDIUMTEXT not null,
20 dcae_blueprint_id varchar(255),
21 dcae_deployment_id varchar(255),
22 dcae_deployment_status_url varchar(255),
23 global_properties_json json,
24 last_computed_state varchar(255) not null,
25 model_properties_json json,
26 svg_representation MEDIUMTEXT,
30 create table loops_microservicepolicies (
31 loop_id varchar(255) not null,
32 microservicepolicy_id varchar(255) not null,
33 primary key (loop_id, microservicepolicy_id)
36 create table micro_service_policies (
37 name varchar(255) not null,
38 json_representation json not null,
39 model_type varchar(255) not null,
40 policy_tosca MEDIUMTEXT not null,
46 create table operational_policies (
47 name varchar(255) not null,
48 configurations_json json,
49 loop_id varchar(255) not null,
54 add constraint FK1j0cda46aickcaoxqoo34khg2
56 references loops (name);
58 alter table loops_microservicepolicies
59 add constraint FKem7tp1cdlpwe28av7ef91j1yl
60 foreign key (microservicepolicy_id)
61 references micro_service_policies (name);
63 alter table loops_microservicepolicies
64 add constraint FKsvx91jekgdkfh34iaxtjfgebt
66 references loops (name);
68 alter table operational_policies
69 add constraint FK1ddoggk9ni2bnqighv6ecmuwu
71 references loops (name);