From e1fe7fcff0568f6376c3392ddf761b3aa0601587 Mon Sep 17 00:00:00 2001 From: uj426b Date: Thu, 21 Mar 2019 22:02:04 -0400 Subject: Auditing User Operations Push or Delete Policies. Change-Id: I39d5fc01e68e9d711c5dd09790dc34beb68783c3 Issue-ID: POLICY-1421 Signed-off-by: uj426b --- .../install/mysql/data/190202_downgrade_script.sql | 20 ++++++++++++++++ .../install/mysql/data/190202_upgrade_script.sql | 27 ++++++++++++++++++++++ 2 files changed, 47 insertions(+) create mode 100644 packages/base/src/files/install/mysql/data/190202_downgrade_script.sql create mode 100644 packages/base/src/files/install/mysql/data/190202_upgrade_script.sql (limited to 'packages') diff --git a/packages/base/src/files/install/mysql/data/190202_downgrade_script.sql b/packages/base/src/files/install/mysql/data/190202_downgrade_script.sql new file mode 100644 index 000000000..2c0917428 --- /dev/null +++ b/packages/base/src/files/install/mysql/data/190202_downgrade_script.sql @@ -0,0 +1,20 @@ +-- ============LICENSE_START======================================================= +-- ONAP Policy Engine +-- ================================================================================ +-- 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 onap_sdk; +drop table if exists policyAuditlog; \ No newline at end of file diff --git a/packages/base/src/files/install/mysql/data/190202_upgrade_script.sql b/packages/base/src/files/install/mysql/data/190202_upgrade_script.sql new file mode 100644 index 000000000..2b44c331f --- /dev/null +++ b/packages/base/src/files/install/mysql/data/190202_upgrade_script.sql @@ -0,0 +1,27 @@ +-- ============LICENSE_START======================================================= +-- ONAP Policy Engine +-- ================================================================================ +-- 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 onap_sdk; +CREATE TABLE policyAuditlog ( + id int auto_increment NOT NULL, + userName varchar(100) NOT NULL, + policyName varchar(255) NOT NULL, + actions varchar(50) NOT NULL, + dateAndTime datetime NOT NULL, + PRIMARY KEY (id) +); \ No newline at end of file -- cgit 1.2.3-korg