1 -- ============LICENSE_START=======================================================
3 -- ================================================================================
4 -- Copyright (C) 2019 AT&T Intellectual Property. All rights reserved.
5 -- ================================================================================
6 -- Licensed under the Apache License, Version 2.0 (the "License");
7 -- you may not use this file except in compliance with the License.
8 -- You may obtain a copy of the License at
10 -- http://www.apache.org/licenses/LICENSE-2.0
12 -- Unless required by applicable law or agreed to in writing, software
13 -- distributed under the License is distributed on an "AS IS" BASIS,
14 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
15 -- See the License for the specific language governing permissions and
16 -- limitations under the License.
17 -- ============LICENSE_END=========================================================
20 CREATE TABLE policyAuditlog (
21 id int auto_increment NOT NULL,
22 userName varchar(100) NOT NULL,
23 policyName varchar(255) NOT NULL,
24 actions varchar(50) NOT NULL,
25 dateAndTime datetime NOT NULL,
29 ALTER TABLE microservicemodels
30 ADD ruleFormation VARCHAR(45) DEFAULT NULL,
31 ADD COLUMN `decisionModel` tinyint(1) DEFAULT NULL;
33 CREATE TABLE `onap_sdk`.`dictionaryData` (
34 `id` int(11) NOT NULL AUTO_INCREMENT,
35 `dictionaryName` varchar(64) NOT NULL,
36 `dictionaryUrl` varchar(64) NOT NULL,
37 `dictionaryDataByName` varchar(64) NOT NULL,
41 INSERT INTO dictionaryData (dictionaryName, dictionaryUrl, dictionaryDataByName)
42 VALUES ('GocVNFType', 'getDictionary/get_GocVnfTypeDataByName', 'gocVnfTypeDictionaryDatas'),
43 ('ServerScope','getDictionary/get_ServerScopeDataByName','gocServerScopeDictionaryDatas'),
44 ('TraversalData', 'getDictionary/get_TraversalDataByName', 'gocTraversalDictionaryDatas');
46 INSERT INTO `onap_sdk`.`fn_user_role` (USER_ID, ROLE_ID, APP_ID) VALUES (1, 16, 1);