aboutsummaryrefslogtreecommitdiffstats
path: root/extra/sql/bulkload
diff options
context:
space:
mode:
authorxuegao <xg353y@intl.att.com>2019-12-18 11:17:53 +0100
committerxuegao <xg353y@intl.att.com>2019-12-18 11:17:53 +0100
commit62a0b7ca40d7810897fce2d1f8eb47e5647a2bf2 (patch)
treeb54dd8a88ae304ca58c347686df07815f8aab84b /extra/sql/bulkload
parent9047defa7549ebd9a84cef3e10bbfd90f068097b (diff)
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>
Diffstat (limited to 'extra/sql/bulkload')
-rw-r--r--extra/sql/bulkload/create-tables.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/extra/sql/bulkload/create-tables.sql b/extra/sql/bulkload/create-tables.sql
index 85b8f85f9..6e9ff7c86 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;