Move jsonRepresentation
Move the storage of jsonRepresentation to OperationalPolicy level
Issue-ID: CLAMP-582
Change-Id: Id555ebc1f2f04468f7bf0ffd813de7732bcee97f
Signed-off-by: xuegao <xg353y@intl.att.com>
diff --git a/extra/sql/bulkload/create-tables.sql b/extra/sql/bulkload/create-tables.sql
index 85b8f85..6e9ff7c 100644
--- a/extra/sql/bulkload/create-tables.sql
+++ b/extra/sql/bulkload/create-tables.sql
@@ -23,7 +23,6 @@
dcae_deployment_status_url varchar(255),
global_properties_json json,
last_computed_state varchar(255) not null,
- operational_policy_schema json,
svg_representation MEDIUMTEXT,
service_uuid varchar(255),
primary key (name)
@@ -48,6 +47,7 @@
create table operational_policies (
name varchar(255) not null,
configurations_json json,
+ json_representation json not null,
loop_id varchar(255) not null,
primary key (name)
) engine=InnoDB;