X-Git-Url: https://gerrit.onap.org/r/gitweb?p=portal.git;a=blobdiff_plain;f=ecomp-portal-DB-os%2FPortalDMLMySql_3_3_OS.sql;h=abeb42ef3ea76583ae8942df711953209cdcdc63;hp=b163ae28632e84d02d5187c3fa803c0bf57518c9;hb=f951915573eebe953317fe3d077857a80b422a6f;hpb=ce34d843f7e16ecddc839ee9976b4652bfdde571 diff --git a/ecomp-portal-DB-os/PortalDMLMySql_3_3_OS.sql b/ecomp-portal-DB-os/PortalDMLMySql_3_3_OS.sql index b163ae28..abeb42ef 100644 --- a/ecomp-portal-DB-os/PortalDMLMySql_3_3_OS.sql +++ b/ecomp-portal-DB-os/PortalDMLMySql_3_3_OS.sql @@ -15,6 +15,11 @@ UPDATE fn_menu SET function_cd = 'menu_acc_admin' WHERE label = 'Users'; +--- update fn_menu for Onboarding Page +UPDATE fn_menu +SET function_cd = 'menu_acc_admin' +WHERE label = 'Application Onboarding'; + -- fn_user Insert into fn_user (USER_ID, ORG_ID, MANAGER_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME,PHONE,FAX,CELLULAR,EMAIL,ADDRESS_ID,ALERT_METHOD_CD,HRID,ORG_USER_ID,ORG_CODE,LOGIN_ID,LOGIN_PWD,LAST_LOGIN_DATE,ACTIVE_YN,CREATED_ID,CREATED_DATE,MODIFIED_ID,MODIFIED_DATE,IS_INTERNAL_YN,ADDRESS_LINE_1,ADDRESS_LINE_2,CITY,STATE_CD,ZIP_CODE,COUNTRY_CD,LOCATION_CLLI,ORG_MANAGER_USERID,COMPANY,DEPARTMENT_NAME,JOB_TITLE,TIMEZONE,DEPARTMENT,BUSINESS_UNIT,BUSINESS_UNIT_NAME,COST_CENTER,FIN_LOC_CODE,SILO_STATUS,is_system_user,language_id) values (1,NULL,NULL,'Demo',NULL,'User',NULL,NULL,NULL,'demo@onap.org',NULL,NULL,NULL,'demo',NULL,'demo','4Gl6WL1bmwviYm+XZa6pS1vC0qKXWtn9wcZWdLx61L0=','2016-10-20 15:11:16','Y',NULL,'2016-10-14 21:00:00',1,'2016-10-20 15:11:16','N',NULL,NULL,NULL,'NJ',NULL,'US',NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,'N',1);