Home Explore Help
Sign In
super_service
/
superdesk_superservice
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
superdesk_su...
/
sql
/
huangxiaotian
/
权限模块
/
一二级功能划分并更新.sql

一二级功能划分并更新.sql 11 KB
Permalink History Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980 
  1. UPDATE `tb_app_function` SET `ID`='2', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='2', `PERMS`='pc:system' WHERE (`ID`='2');
    2. 

  2. UPDATE `tb_app_function` SET `ID`='6', `RIGHT_TYPE`='1', `PARENTCODE`='2', `TREECODE`='6', `PERMS`='pc:system:user' WHERE (`ID`='6');
    3. 

  3. UPDATE `tb_app_function` SET `ID`='7', `RIGHT_TYPE`='1', `PARENTCODE`='2', `TREECODE`='7', `PERMS`='pc:system:role' WHERE (`ID`='7');
    4. 

  4. UPDATE `tb_app_function` SET `ID`='8', `RIGHT_TYPE`='1', `PARENTCODE`='2', `TREECODE`='8', `PERMS`='pc:system:menu' WHERE (`ID`='8');
    5. 

  5. UPDATE `tb_app_function` SET `ID`='10', `RIGHT_TYPE`='1', `PARENTCODE`='2', `TREECODE`='10', `PERMS`='pc:system:function' WHERE (`ID`='10');
    6. 

  6. UPDATE `tb_app_function` SET `ID`='19', `RIGHT_TYPE`='1', `PARENTCODE`='161', `TREECODE`='19', `PERMS`='pc:basics:dictionary' WHERE (`ID`='19');
    7. 

  7. UPDATE `tb_app_function` SET `ID`='91', `RIGHT_TYPE`='1', `PARENTCODE`='154', `TREECODE`='91', `PERMS`='pc:setting:wechat' WHERE (`ID`='91');
    8. 

  8. UPDATE `tb_app_function` SET `ID`='139', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='139', `PERMS`='pc:organization' WHERE (`ID`='139');
    9. 

  9. UPDATE `tb_app_function` SET `ID`='140', `RIGHT_TYPE`='1', `PARENTCODE`='139', `TREECODE`='140', `PERMS`='pc:organization:project' WHERE (`ID`='140');
    10. 

  10. UPDATE `tb_app_function` SET `ID`='141', `RIGHT_TYPE`='1', `PARENTCODE`='139', `TREECODE`='141', `PERMS`='pc:organization:build' WHERE (`ID`='141');
    11. 

  11. UPDATE `tb_app_function` SET `ID`='143', `RIGHT_TYPE`='1', `PARENTCODE`='139', `TREECODE`='143', `PERMS`='pc:organization:company' WHERE (`ID`='143');
    12. 

  12. UPDATE `tb_app_function` SET `ID`='144', `RIGHT_TYPE`='1', `PARENTCODE`='139', `TREECODE`='144', `PERMS`='pc:organization:dept' WHERE (`ID`='144');
    13. 

  13. UPDATE `tb_app_function` SET `ID`='154', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='154', `PERMS`='pc:setting' WHERE (`ID`='154');
    14. 

  14. UPDATE `tb_app_function` SET `ID`='155', `RIGHT_TYPE`='1', `PARENTCODE`='154', `TREECODE`='155', `PERMS`='pc:setting:service' WHERE (`ID`='155');
    15. 

  15. UPDATE `tb_app_function` SET `ID`='156', `RIGHT_TYPE`='1', `PARENTCODE`='154', `TREECODE`='156', `PERMS`='pc:setting:project' WHERE (`ID`='156');
    16. 

  16. UPDATE `tb_app_function` SET `ID`='160', `RIGHT_TYPE`='1', `PARENTCODE`='139', `TREECODE`='160', `PERMS`='pc:organization:enterprise-data' WHERE (`ID`='160');
    17. 

  17. UPDATE `tb_app_function` SET `ID`='161', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='161', `PERMS`='pc:basics' WHERE (`ID`='161');
    18. 

  18. UPDATE `tb_app_function` SET `ID`='165', `RIGHT_TYPE`='1', `PARENTCODE`='139', `TREECODE`='165', `PERMS`='pc:organization:floor' WHERE (`ID`='165');
    19. 

  19. UPDATE `tb_app_function` SET `ID`='167', `RIGHT_TYPE`='1', `PARENTCODE`='139', `TREECODE`='167', `PERMS`='pc:organization:enterprise' WHERE (`ID`='167');
    20. 

  20. UPDATE `tb_app_function` SET `ID`='168', `RIGHT_TYPE`='1', `PARENTCODE`='173', `TREECODE`='168', `PERMS`='pc:consume:template' WHERE (`ID`='168');
    21. 

  21. UPDATE `tb_app_function` SET `ID`='169', `RIGHT_TYPE`='1', `PARENTCODE`='173', `TREECODE`='169', `PERMS`='pc:consume:push' WHERE (`ID`='169');
    22. 

  22. UPDATE `tb_app_function` SET `ID`='170', `RIGHT_TYPE`='1', `PARENTCODE`='173', `TREECODE`='170', `PERMS`='pc:consume:history' WHERE (`ID`='170');
    23. 

  23. UPDATE `tb_app_function` SET `ID`='173', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='173', `PERMS`='pc:consume' WHERE (`ID`='173');
    24. 

  24. UPDATE `tb_app_function` SET `ID`='174', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='174', `PERMS`='pc:notice' WHERE (`ID`='174');
    25. 

  25. UPDATE `tb_app_function` SET `ID`='175', `RIGHT_TYPE`='1', `PARENTCODE`='174', `TREECODE`='175', `PERMS`='pc:notice:publish' WHERE (`ID`='175');
    26. 

  26. UPDATE `tb_app_function` SET `ID`='178', `RIGHT_TYPE`='1', `PARENTCODE`='196', `TREECODE`='178', `PERMS`=NULL WHERE (`ID`='178');
    27. 

  27. UPDATE `tb_app_function` SET `ID`='179', `RIGHT_TYPE`='1', `PARENTCODE`='196', `TREECODE`='179', `PERMS`=NULL WHERE (`ID`='179');
    28. 

  28. UPDATE `tb_app_function` SET `ID`='180', `RIGHT_TYPE`='1', `PARENTCODE`='174', `TREECODE`='180', `PERMS`='pc:notice:list' WHERE (`ID`='180');
    29. 

  29. UPDATE `tb_app_function` SET `ID`='181', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='181', `PERMS`=NULL WHERE (`ID`='181');
    30. 

  30. UPDATE `tb_app_function` SET `ID`='182', `RIGHT_TYPE`='1', `PARENTCODE`='181', `TREECODE`='182', `PERMS`=NULL WHERE (`ID`='182');
    31. 

  31. UPDATE `tb_app_function` SET `ID`='183', `RIGHT_TYPE`='1', `PARENTCODE`='181', `TREECODE`='183', `PERMS`=NULL WHERE (`ID`='183');
    32. 

  32. UPDATE `tb_app_function` SET `ID`='184', `RIGHT_TYPE`='1', `PARENTCODE`='181', `TREECODE`='184', `PERMS`=NULL WHERE (`ID`='184');
    33. 

  33. UPDATE `tb_app_function` SET `ID`='185', `RIGHT_TYPE`='1', `PARENTCODE`='181', `TREECODE`='185', `PERMS`=NULL WHERE (`ID`='185');
    34. 

  34. UPDATE `tb_app_function` SET `ID`='186', `RIGHT_TYPE`='1', `PARENTCODE`='161', `TREECODE`='186', `PERMS`='pc:basics:wxtemplate' WHERE (`ID`='186');
    35. 

  35. UPDATE `tb_app_function` SET `ID`='187', `RIGHT_TYPE`='1', `PARENTCODE`='161', `TREECODE`='187', `PERMS`='pc:basics:email' WHERE (`ID`='187');
    36. 

  36. UPDATE `tb_app_function` SET `ID`='188', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='188', `PERMS`='pc:repair' WHERE (`ID`='188');
    37. 

  37. UPDATE `tb_app_function` SET `ID`='189', `RIGHT_TYPE`='1', `PARENTCODE`='188', `TREECODE`='189', `PERMS`='pc:repair:launch' WHERE (`ID`='189');
    38. 

  38. UPDATE `tb_app_function` SET `ID`='190', `RIGHT_TYPE`='1', `PARENTCODE`='188', `TREECODE`='190', `PERMS`='pc:repair:evaluate' WHERE (`ID`='190');
    39. 

  39. UPDATE `tb_app_function` SET `ID`='191', `RIGHT_TYPE`='1', `PARENTCODE`='188', `TREECODE`='191', `PERMS`='pc:repair:list' WHERE (`ID`='191');
    40. 

  40. UPDATE `tb_app_function` SET `ID`='192', `RIGHT_TYPE`='1', `PARENTCODE`='195', `TREECODE`='192', `PERMS`='pc:enter:list' WHERE (`ID`='192');
    41. 

  41. UPDATE `tb_app_function` SET `ID`='193', `RIGHT_TYPE`='1', `PARENTCODE`='195', `TREECODE`='193', `PERMS`='pc:enter:config' WHERE (`ID`='193');
    42. 

  42. UPDATE `tb_app_function` SET `ID`='195', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='195', `PERMS`='pc:enter' WHERE (`ID`='195');
    43. 

  43. UPDATE `tb_app_function` SET `ID`='196', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='196', `PERMS`=NULL WHERE (`ID`='196');
    44. 

  44. UPDATE `tb_app_function` SET `ID`='197', `RIGHT_TYPE`='1', `PARENTCODE`='196', `TREECODE`='197', `PERMS`=NULL WHERE (`ID`='197');
    45. 

  45. UPDATE `tb_app_function` SET `ID`='198', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='198', `PERMS`=NULL WHERE (`ID`='198');
    46. 

  46. UPDATE `tb_app_function` SET `ID`='199', `RIGHT_TYPE`='1', `PARENTCODE`='198', `TREECODE`='199', `PERMS`=NULL WHERE (`ID`='199');
    47. 

  47. UPDATE `tb_app_function` SET `ID`='200', `RIGHT_TYPE`='1', `PARENTCODE`='198', `TREECODE`='200', `PERMS`=NULL WHERE (`ID`='200');
    48. 

  48. UPDATE `tb_app_function` SET `ID`='201', `RIGHT_TYPE`='1', `PARENTCODE`='198', `TREECODE`='201', `PERMS`=NULL WHERE (`ID`='201');
    49. 

  49. UPDATE `tb_app_function` SET `ID`='202', `RIGHT_TYPE`='1', `PARENTCODE`='198', `TREECODE`='202', `PERMS`=NULL WHERE (`ID`='202');
    50. 

  50. UPDATE `tb_app_function` SET `ID`='203', `RIGHT_TYPE`='1', `PARENTCODE`='198', `TREECODE`='203', `PERMS`=NULL WHERE (`ID`='203');
    51. 

  51. UPDATE `tb_app_function` SET `ID`='204', `RIGHT_TYPE`='1', `PARENTCODE`='198', `TREECODE`='204', `PERMS`=NULL WHERE (`ID`='204');
    52. 

  52. UPDATE `tb_app_function` SET `ID`='205', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='205', `PERMS`=NULL WHERE (`ID`='205');
    53. 

  53. UPDATE `tb_app_function` SET `ID`='206', `RIGHT_TYPE`='1', `PARENTCODE`='205', `TREECODE`='206', `PERMS`=NULL WHERE (`ID`='206');
    54. 

  54. UPDATE `tb_app_function` SET `ID`='207', `RIGHT_TYPE`='1', `PARENTCODE`='205', `TREECODE`='207', `PERMS`=NULL WHERE (`ID`='207');
    55. 

  55. UPDATE `tb_app_function` SET `ID`='208', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='208', `PERMS`=NULL WHERE (`ID`='208');
    56. 

  56. UPDATE `tb_app_function` SET `ID`='209', `RIGHT_TYPE`='1', `PARENTCODE`='208', `TREECODE`='209', `PERMS`=NULL WHERE (`ID`='209');
    57. 

  57. UPDATE `tb_app_function` SET `ID`='210', `RIGHT_TYPE`='1', `PARENTCODE`='208', `TREECODE`='210', `PERMS`=NULL WHERE (`ID`='210');
    58. 

  58. UPDATE `tb_app_function` SET `ID`='211', `RIGHT_TYPE`='1', `PARENTCODE`='208', `TREECODE`='211', `PERMS`=NULL WHERE (`ID`='211');
    59. 

  59. UPDATE `tb_app_function` SET `ID`='219', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='219', `PERMS`='pc:emigration' WHERE (`ID`='219');
    60. 

  60. UPDATE `tb_app_function` SET `ID`='221', `RIGHT_TYPE`='1', `PARENTCODE`='219', `TREECODE`='221', `PERMS`='pc:emigration:list' WHERE (`ID`='221');
    61. 

  61. UPDATE `tb_app_function` SET `ID`='222', `RIGHT_TYPE`='1', `PARENTCODE`='219', `TREECODE`='222', `PERMS`='pc:emigration:config' WHERE (`ID`='222');
    62. 

  62. UPDATE `tb_app_function` SET `ID`='223', `RIGHT_TYPE`='1', `PARENTCODE`='225', `TREECODE`='223', `PERMS`='pc:release:history' WHERE (`ID`='223');
    63. 

  63. UPDATE `tb_app_function` SET `ID`='224', `RIGHT_TYPE`='1', `PARENTCODE`='225', `TREECODE`='224', `PERMS`='pc:release:approval' WHERE (`ID`='224');
    64. 

  64. UPDATE `tb_app_function` SET `ID`='225', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='225', `PERMS`='pc:release' WHERE (`ID`='225');
    65. 

  65. UPDATE `tb_app_function` SET `ID`='226', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='226', `PERMS`=NULL WHERE (`ID`='226');
    66. 

  66. UPDATE `tb_app_function` SET `ID`='227', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='227', `PERMS`=NULL WHERE (`ID`='227');
    67. 

  67. UPDATE `tb_app_function` SET `ID`='228', `RIGHT_TYPE`='2', `PARENTCODE`='191', `TREECODE`='228', `PERMS`='pc:repair:list:approve' WHERE (`ID`='228');
    68. 

  68. UPDATE `tb_app_function` SET `ID`='229', `RIGHT_TYPE`='1', `PARENTCODE`='154', `TREECODE`='229', `PERMS`='pc:setting:custom' WHERE (`ID`='229');
    69. 

  69. UPDATE `tb_app_function` SET `ID`='230', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='230', `PERMS`=NULL WHERE (`ID`='230');
    70. 

  70. UPDATE `tb_app_function` SET `ID`='231', `RIGHT_TYPE`='1', `PARENTCODE`='230', `TREECODE`='231', `PERMS`=NULL WHERE (`ID`='231');
    71. 

  71. UPDATE `tb_app_function` SET `ID`='234', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='234', `PERMS`='pc:washcar' WHERE (`ID`='234');
    72. 

  72. UPDATE `tb_app_function` SET `ID`='235', `RIGHT_TYPE`='1', `PARENTCODE`='234', `TREECODE`='235', `PERMS`='pc:washcar:list' WHERE (`ID`='235');
    73. 

  73. UPDATE `tb_app_function` SET `ID`='236', `RIGHT_TYPE`='0', `PARENTCODE`='0', `TREECODE`='236', `PERMS`=NULL WHERE (`ID`='236');
    74. 

  74. UPDATE `tb_app_function` SET `ID`='237', `RIGHT_TYPE`='1', `PARENTCODE`='236', `TREECODE`='237', `PERMS`=NULL WHERE (`ID`='237');
    75. 

  75. UPDATE `tb_app_function` SET `ID`='238', `RIGHT_TYPE`='2', `PARENTCODE`='237', `TREECODE`='238', `PERMS`=NULL WHERE (`ID`='238');
    76. 

  76. UPDATE `tb_app_function` SET `ID`='240', `RIGHT_TYPE`='1', `PARENTCODE`='154', `TREECODE`='240', `PERMS`='pc:setting:module' WHERE (`ID`='240');
    77. 

  77. UPDATE `tb_app_function` SET `ID`='241', `RIGHT_TYPE`='1', `PARENTCODE`='139', `TREECODE`='241', `PERMS`='pc:organization:enterprise-account' WHERE (`ID`='241');
    78. 

  78. UPDATE `tb_app_function` SET `ID`='242', `RIGHT_TYPE`='2', `PARENTCODE`='192', `TREECODE`='242', `PERMS`='pc:enter:list:approve' WHERE (`ID`='242');
    79. 

  79. UPDATE `tb_app_function` SET `ID`='243', `RIGHT_TYPE`='2', `PARENTCODE`='221', `TREECODE`='243', `PERMS`='pc:emigration:list:approve' WHERE (`ID`='243');
    80. 

  80. UPDATE `tb_app_function` SET `ID`='244', `RIGHT_TYPE`='2', `PARENTCODE`='180', `TREECODE`='244', `PERMS`='pc:notice:list:approve' WHERE (`ID`='244');
    81.