X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=packages%2Fbase%2Fsrc%2Ffiles%2Finstall%2Fmysql%2Fdata%2F190202_upgrade_script.sql;h=c36a6f404c4ed6f9cc83da10a749f49a09c942d8;hb=ab62e8c4f67413364038938174ca7b05c0ab5cc1;hp=2b44c331f566de0a6b298dedce3ea3badebb57b6;hpb=1b1640ae538cfdb3667fd3222dc4dec469b0e3f7;p=policy%2Fengine.git

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
index 2b44c331f..c36a6f404 100644
--- a/packages/base/src/files/install/mysql/data/190202_upgrade_script.sql
+++ b/packages/base/src/files/install/mysql/data/190202_upgrade_script.sql
@@ -24,4 +24,23 @@ CREATE TABLE policyAuditlog (
     actions varchar(50) NOT NULL,
     dateAndTime datetime NOT NULL,
     PRIMARY KEY (id)
-);
\ No newline at end of file
+);
+
+ALTER TABLE microservicemodels
+ADD ruleFormation VARCHAR(45) DEFAULT NULL,
+ADD COLUMN `decisionModel` tinyint(1) DEFAULT NULL;
+
+CREATE TABLE `onap_sdk`.`dictionaryData` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `dictionaryName` varchar(64) NOT NULL,
+ `dictionaryUrl` varchar(64) NOT NULL,
+ `dictionaryDataByName` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`) 
+ );
+ 
+INSERT INTO dictionaryData (dictionaryName, dictionaryUrl, dictionaryDataByName)
+VALUES ('GocVNFType', 'getDictionary/get_GocVnfTypeDataByName', 'gocVnfTypeDictionaryDatas'),
+('ServerScope','getDictionary/get_ServerScopeDataByName','gocServerScopeDictionaryDatas'),
+('TraversalData', 'getDictionary/get_TraversalDataByName', 'gocTraversalDictionaryDatas'); 
+
+INSERT INTO `onap_sdk`.`fn_user_role` (USER_ID, ROLE_ID, APP_ID) VALUES (1, 16, 1);