Draft of op policy

[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 29e0fac..aef3a7e 100644 (file)
--- a/extra/sql/bulkload/create-tables.sql
+++ b/extra/sql/bulkload/create-tables.sql
@@ -7,9 +7,10 @@
 
     create table loop_logs (
        id bigint not null,
+        log_component varchar(255) not null,
         log_instant datetime(6) not null,
         log_type varchar(255) not null,
-        message varchar(255) not null,
+        message MEDIUMTEXT not null,
         loop_id varchar(255) not null,
         primary key (id)
     ) engine=InnoDB;
@@ -23,6 +24,7 @@
         global_properties_json json,
         last_computed_state varchar(255) not null,
         model_properties_json json,
+        operational_policy_schema json not null,
         svg_representation MEDIUMTEXT,
         primary key (name)
     ) engine=InnoDB;
@@ -35,7 +37,6 @@
 
     create table micro_service_policies (
        name varchar(255) not null,
-        blueprint_name varchar(255) not null,
         json_representation json not null,
         model_type varchar(255) not null,
         policy_tosca MEDIUMTEXT not null,