--  ============LICENSE_START==========================================
--  ONAP : APPC
--  ===================================================================
--  Copyright (C) 2017-2018 AT&T Intellectual Property. All rights reserved.
--  ===================================================================
--
--  Unless otherwise specified, all software contained herein is licensed
--  under the Apache License, Version 2.0 (the License);
--  you may not use this software 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.
--
--  ECOMP is a trademark and service mark of AT&T Intellectual Property.
--  ============LICENSE_END============================================

--
-- Table structure for table `transactions` for appcctl db
--

DROP TABLE IF EXISTS `transactions`;
CREATE TABLE `transactions` (
    `TIMESTAMP`
    varchar(32) NOT NULL,
    `REQUEST_ID`
    varchar(256) DEFAULT NULL,
    `START_TIME`
    varchar(32) DEFAULT NULL,
    `END_TIME`
    varchar(32) DEFAULT NULL,
    `TARGET_ID`
    varchar(256) DEFAULT NULL,
    `TARGET_TYPE`
    varchar(256) DEFAULT NULL,
    `SUB_COMPONENT`
    varchar(256) DEFAULT NULL,
    `OPERATION`
    varchar(256) DEFAULT NULL,
    `RESULT_CODE`
    varchar(256) DEFAULT NULL,
    `DESCRIPTION`
    text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;