Merge "update docs flow"

[clamp.git] / extra / sql / bulkload / create-tables.sql

diff --git a/extra/sql/bulkload/create-tables.sql b/extra/sql/bulkload/create-tables.sql
index 522086c..111a405 100644 (file)
--- a/extra/sql/bulkload/create-tables.sql
+++ b/extra/sql/bulkload/create-tables.sql
@@ -68,7 +68,6 @@
         blueprint_yaml MEDIUMTEXT,
         dcae_blueprint_id varchar(255),
         maximum_instances_allowed integer,
-        svg_representation MEDIUMTEXT,
         unique_blueprint boolean default false,
         service_uuid varchar(255),
         primary key (name)
@@ -91,7 +90,6 @@
         dcae_deployment_status_url varchar(255),
         global_properties_json json,
         last_computed_state varchar(255) not null,
-        svg_representation MEDIUMTEXT,
         loop_template_name varchar(255) not null,
         service_uuid varchar(255),
         primary key (name)
@@ -119,6 +117,7 @@
         configurations_json json,
         json_representation json not null,
         pdp_group varchar(255),
+        pdp_sub_group varchar(255),
         context varchar(255),
         dcae_blueprint_id varchar(255),
         dcae_deployment_id varchar(255),
@@ -140,10 +139,11 @@
         configurations_json json,
         json_representation json not null,
         pdp_group varchar(255),
+        pdp_sub_group varchar(255),
         loop_element_model_id varchar(255),
-        loop_id varchar(255) not null,
         policy_model_type varchar(255),
         policy_model_version varchar(255),
+        loop_id varchar(255) not null,
         primary key (name)
     ) engine=InnoDB;
 
@@ -156,6 +156,7 @@
         updated_timestamp datetime(6) not null,
         policy_acronym varchar(255),
         policy_tosca MEDIUMTEXT,
+        policy_pdp_group json,
         primary key (policy_model_type, version)
     ) engine=InnoDB;
 
@@ -243,12 +244,12 @@
        foreign key (loop_element_model_id) 
        references loop_element_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 operational_policies 
+       add constraint FK1ddoggk9ni2bnqighv6ecmuwu 
+       foreign key (loop_id) 
+       references loops (name);