aboutsummaryrefslogtreecommitdiffstats
path: root/extra/sql
diff options
context:
space:
mode:
authorxuegao <xg353y@intl.att.com>2020-02-18 14:20:23 +0100
committerxuegao <xg353y@intl.att.com>2020-02-26 15:59:25 +0100
commit3a26471260e56f7a87533f0147fc63530d6ea08c (patch)
tree400059c05ccb58b0e10d3ce1309085a944e394b8 /extra/sql
parente0d0fdb5484d2c02669358160a11d6751ada4f3a (diff)
Create get Pdp Groups flow
Create a camel flow to get the list of Pdp Groups info from Policy. Create a scheduler to trigger the camel flow regularly and store the Pdp Groups info into DB. Issue-ID: CLAMP-644, CLAMP-649 Change-Id: I6427202cc0186cd85428d5d25b28a8622e4d7ca4 Signed-off-by: xuegao <xg353y@intl.att.com>
Diffstat (limited to 'extra/sql')
-rw-r--r--extra/sql/bulkload/create-tables.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/extra/sql/bulkload/create-tables.sql b/extra/sql/bulkload/create-tables.sql
index 522086c93..2a7f4c1cc 100644
--- a/extra/sql/bulkload/create-tables.sql
+++ b/extra/sql/bulkload/create-tables.sql
@@ -119,6 +119,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,6 +141,7 @@
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),
@@ -156,6 +158,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;