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=0c20d1c294fe146e1018f14b07a8d861c29fe527;hp=f92da8d81af9abdd749dcc8cc6b9d269237b1de6;hpb=06e02108525c3e5e8c85de233aef3bb332173c00;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 f92da8d81..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 @@ -27,7 +27,8 @@ CREATE TABLE policyAuditlog ( ); ALTER TABLE microservicemodels -ADD ruleFormation VARCHAR(45) DEFAULT NULL; +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, @@ -42,3 +43,4 @@ VALUES ('GocVNFType', 'getDictionary/get_GocVnfTypeDataByName', 'gocVnfTypeDicti ('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);