-- ÐÞ¸Ä¹ÜÀí²Ëµ¥µÄ¸¸ÀàÐÍ£¬¿ØÖÆ¸øÈýÔ±ÊÚÈ¨Ê±£¬²»ÄÜ¿´µ½ÒµÎñ¹¦ÄÜ£¬¸øÆÕÍ¨ÓÃ»§ÊÚÈ¨Ê±²»ÄÜ¿´µ½ÏµÍ³ÅäÖÃ¹ÜÀí¹¦ÄÜ
UPDATE PLFUNCTION p SET p.PLPARENTID ='systemManagmentNode' WHERE p.PLNAME IN ('ÏµÍ³ÅäÖÃ', '¹æÔò¹ÜÀí', '¶ÔÏó½¨Ä£') AND p.PLPARENTID ='modelManagmentNode'; 

-- ÐÞ¸ÄÈÕÖ¾±í£¬Ôö¼ÓPLDESCRIPTIONÃèÊö×Ö¶Î£¬½«PLRESULT²ð·ÖÎªÁ½¸ö×Ö¶Î£¬²Ù×÷½á¹û´çPLRESULT£¬ÈÕÖ¾ÃèÊö´æPLDESCRIPTION¡£
ALTER TABLE PLLOG ADD PLCONTENT VARCHAR2(1000);

-- ÐÞ¸Ä½ÇÉ«È¨ÏÞÐÅÏ¢µÄÈ¨ÏÞÀàÐÍ£¬RIGHTTYPE×Ö¶ÎÖµ£º1-¹¦ÄÜÈ¨ÏÞ£¬2-UIÈ¨ÏÞ
-- 0¡¢ÏÈ½«È¨ÏÞÉèÖÃÈ«²¿ÉèÖÃÎª2
UPDATE PLROLERIGHT SET PLRIGHTTYPE=2
-- 1¡¢¹¦ÄÜÈ¨ÏÞµÄÈ¨ÏÞÀàÐÍÖµ
UPDATE PLROLERIGHT SET PLRIGHTTYPE=1 WHERE PLFUNCOID IN (SELECT PLOID FROM PLFUNCTION);
-- 2¡¢ÐÞ¸ÄUIÈ¨ÏÞµÄÈ¨ÏÞÀàÐÍÖµ
UPDATE PLROLERIGHT SET PLRIGHTTYPE=2 WHERE PLFUNCOID NOT IN (SELECT PLOID FROM PLFUNCTION);

-- ÐÞ¸Ä³¬¼¶¹ÜÀíÔ±ÕËºÅÃÜÂë
UPDATE PLUSER set PLPASSWORD='ptbnYXdQMrY=' where PLUSERNAME IN ('admin','developer','root');