diff options
| author |   xuegao <xg353y@intl.att.com> | 2020-02-18 14:20:23 +0100 |
|---|---|---|
| committer | xuegao <xg353y@intl.att.com> | 2020-02-26 15:59:25 +0100 |
| commit | 3a26471260e56f7a87533f0147fc63530d6ea08c (patch) | |
| tree | 400059c05ccb58b0e10d3ce1309085a944e394b8 /extra/sql | |
| parent | e0d0fdb5484d2c02669358160a11d6751ada4f3a (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.sql | 3 |
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; |