summaryrefslogtreecommitdiffstats
path: root/extra/sql/bulkload/create-tables.sql
diff options
context:
space:
mode:
authorsebdet <sebastien.determe@intl.att.com>2020-02-17 15:31:28 -0800
committersebdet <sebastien.determe@intl.att.com>2020-02-25 01:04:12 -0800
commit4e8e11afced0693e24074fd6bb8d5b2cace98ab6 (patch)
treec177c0cccbe404a818188e954ce65848b2fb6d8c /extra/sql/bulkload/create-tables.sql
parent3b7f669088d5867056578b275bf4314af3a439c6 (diff)
Operational policy modification
policyModel added to Operational policy object so that a user in the UI can add op policies, guard or whatever Issue-ID: CLAMP-647 Change-Id: I57521bc1c3afaf5ca5a2acf5c59823df06fd4cd9 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
Diffstat (limited to 'extra/sql/bulkload/create-tables.sql')
-rw-r--r--extra/sql/bulkload/create-tables.sql9
1 files changed, 7 insertions, 2 deletions
diff --git a/extra/sql/bulkload/create-tables.sql b/extra/sql/bulkload/create-tables.sql
index 50c8d42ca..522086c93 100644
--- a/extra/sql/bulkload/create-tables.sql
+++ b/extra/sql/bulkload/create-tables.sql
@@ -124,10 +124,10 @@
dcae_deployment_id varchar(255),
dcae_deployment_status_url varchar(255),
device_type_scope varchar(255),
- policy_model_type varchar(255) not null,
- policy_tosca MEDIUMTEXT not null,
shared bit not null,
loop_element_model_id varchar(255),
+ policy_model_type varchar(255),
+ policy_model_version varchar(255),
primary key (name)
) engine=InnoDB;
@@ -233,6 +233,11 @@
foreign key (loop_element_model_id)
references loop_element_models (name);
+ alter table micro_service_policies
+ add constraint FKn17j9ufmyhqicb6cvr1dbjvkt
+ foreign key (policy_model_type, policy_model_version)
+ references policy_models (policy_model_type, version);
+
alter table operational_policies
add constraint FKi9kh7my40737xeuaye9xwbnko
foreign key (loop_element_model_id)