diff options
author | 2019-06-03 15:13:03 -0500 | |
---|---|---|
committer | 2019-06-18 08:07:29 -0500 | |
commit | a9bbc763a628ebf601825d080c107ede3894b726 (patch) | |
tree | 0f348edcf40fb27f993245f816e8a333a4f6f476 /packages/policy-xacmlpdp-tarball/src/main/resources/mysql/sql/createguardtable.sql | |
parent | 2af8ab7ce69fba12631dd4bc51acb2cd892dc7c0 (diff) |
Create the operationshistory table from pdpx
Added create table sql statement to the policy-pdpx.sh to create the operationshistory table during
xacml-pdp installation
Added changes per Jorge's review
1) Added sql file with create table statement
2) Added bash script to execute sql file
3) modified policy-pdpx.sh to execute new bash script
4) other changes
Change-Id: Iaae63dc65db1ff9181de12928e072f04c87e50e7
Issue-ID: POLICY-1827
Signed-off-by: Michael Mokry <michael.mokry@att.com>
Diffstat (limited to 'packages/policy-xacmlpdp-tarball/src/main/resources/mysql/sql/createguardtable.sql')
-rw-r--r-- | packages/policy-xacmlpdp-tarball/src/main/resources/mysql/sql/createguardtable.sql | 32 |
1 files changed, 32 insertions, 0 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 new file mode 100644 index 00000000..4d11dec0 --- /dev/null +++ b/packages/policy-xacmlpdp-tarball/src/main/resources/mysql/sql/createguardtable.sql @@ -0,0 +1,32 @@ +-- ============LICENSE_START======================================================= +-- Copyright (C) 2019 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. +-- You may obtain a copy of the License at +-- +-- http://www.apache.org/licenses/LICENSE-2.0 +-- +-- Unless required by applicable law or agreed to in writing, software +-- distributed under the License is distributed on an "AS IS" BASIS, +-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +-- See the License for the specific language governing permissions and +-- limitations under the License. +-- ============LICENSE_END========================================================= + +use operationshistory; + +create table if not exists operationshistory ( + id int(11) not null auto_increment, + closedLoopName varchar(255) not null, + requestId varchar(50), + actor varchar(50) not null, + operation varchar(50) not null, + target varchar(50) not null, + starttime timestamp not null, + outcome varchar(50) not null, + message varchar(255), + subrequestId varchar(50), + endtime timestamp not null default current_timestamp, + PRIMARY KEY (id) +);
\ No newline at end of file |