summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--packages/policy-xacmlpdp-tarball/src/main/resources/mysql/sql/createguardtable.sql10
1 files changed, 8 insertions, 2 deletions
diff --git a/packages/policy-xacmlpdp-tarball/src/main/resources/mysql/sql/createguardtable.sql b/packages/policy-xacmlpdp-tarball/src/main/resources/mysql/sql/createguardtable.sql
index 4d11dec0..f2d01fbf 100644
--- a/packages/policy-xacmlpdp-tarball/src/main/resources/mysql/sql/createguardtable.sql
+++ b/packages/policy-xacmlpdp-tarball/src/main/resources/mysql/sql/createguardtable.sql
@@ -1,5 +1,5 @@
-- ============LICENSE_START=======================================================
--- Copyright (C) 2019 AT&T Intellectual Property. All rights reserved.
+-- Copyright (C) 2019-2020 AT&T Intellectual Property. All rights reserved.
-- ================================================================================
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
@@ -29,4 +29,10 @@ create table if not exists operationshistory (
subrequestId varchar(50),
endtime timestamp not null default current_timestamp,
PRIMARY KEY (id)
-); \ No newline at end of file
+);
+
+create index if not exists operationshistory_clreqid_index on
+ operationshistory(closedLoopName, requestId);
+
+create index if not exists operationshistory_target_index on
+ operationshistory(target, operation, actor);