From 2ab78dd934a88bb29238ca15b586b2ef4f83bcdf Mon Sep 17 00:00:00 2001 From: Jim Hahn Date: Tue, 26 May 2020 13:29:02 -0400 Subject: Create secondary indices Modified the sql script to create the secondary indices. Issue-ID: POLICY-2581 Change-Id: If0bdaa9d8769e99bd47b8780251d96dba172b3e2 Signed-off-by: Jim Hahn --- .../src/main/resources/mysql/sql/createguardtable.sql | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) (limited to 'packages/policy-xacmlpdp-tarball/src/main/resources') 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); -- cgit 1.2.3-korg