Uploaded image for project: 'Portal'
  1. Portal
  2. PORTAL-174

missing DB statement in DML script

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Highest Highest
    • Beijing Release
    • Beijing Release
    • None
    • None
    • Portal Sprint 3, Portal Sprint 4

      in Beijing release, introduced a new function_cd "menu_acc_admin", but only fn_menu table got updated.  need to update other 3 tables in DML scripts.

      1.Insert into fn_menu(MENU_ID,LABEL,PARENT_ID,SORT_ORDER,ACTION,FUNCTION_CD,ACTIVE_YN,MENU_SET_CD,SEPARATOR_YN,IMAGE_SRC)

                                     values(6,'Roles',1,45,'root.roles','menu_acc_admin','N','APP','N','icon-people-groupcollaboration');

      2.Insert into fn_menu(MENU_ID,LABEL,PARENT_ID,SORT_ORDER,ACTION,FUNCTION_CD,ACTIVE_YN,MENU_SET_CD,SEPARATOR_YN,IMAGE_SRC)

                                     values(7,'Users',1,50,'root.users','menu_acc_admin','Y','APP','N','icon-people-groupcollaboration');

      3.Insert into fn_function(FUNCTION_CD,FUNCTION_NAME) values(‘menu_acc_admin’,’ Admin Acc Menu’);

      4.Insert into ep_function(APP_ID,FUNCTION_CD,FUNCTION_NAME) values(1,’menu_acc_admin’,’Admin Acc Menu’);

      5.Insert into ep_app_role_function(ID,APP_ID,ROLE_ID,FUNCTION_CD,ROLE_APP_ID) values(16,1,1,’menu|menu_acc_admin|*’,’’);

       

      6.Insert into ep_app_role_function(ID,APP_ID,ROLE_ID,FUNCTION_CD,ROLE_APP_ID) values(17,1,999,’menu|menu_acc_admin|*’,’’);

        

            hb123f hb123f
            shi shi
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: