Startseite Erkunden Hilfe
Registrieren Anmelden
huangxingxing
/
adi_cae_service
1
0
Fork 0
Dateien Issues 0 Pull-Requests 0 Wiki
Struktur: 6cc1236e58
Branches Tags
adi_cae_service
/
dbscript
/
init
/
generate
/
03-functionInit.sql

03-functionInit.sql 7.9 KB
Verlauf Originalformat

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566 
  1. -- 以下为生成的系统功能权限初始化文件,再次生成将覆盖
    2. 

  2. DELETE FROM SYS_FUNCTION;
    3. 

  3. -- 管理系统
    4. 

  4. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00001', '管理系统','获取系统角色列表',true);
    5. 

  5. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00002', '管理系统','获取系统功能列表',true);
    6. 

  6. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00003', '管理系统','获取系统菜单列表',true);
    7. 

  7. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00004', '管理系统','修改系统角色',true);
    8. 

  8. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00005', '管理系统','修改系统功能',true);
    9. 

  9. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00006', '管理系统','修改系统菜单',true);
    10. 

  10. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00007', '管理系统','增加系统角色',true);
    11. 

  11. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00008', '管理系统','删除系统角色',true);
    12. 

  12. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00009', '管理系统','修改系统角色功能',true);
    13. 

  13. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00010', '管理系统','修改系统角色菜单',true);
    14. 

  14. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00020', '管理系统','机构列表',true);
    15. 

  15. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00021', '管理系统','机构增加',true);
    16. 

  16. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00022', '管理系统','机构修改',true);
    17. 

  17. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00023', '管理系统','机构删除',true);
    18. 

  18. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00024', '管理系统','机构详情',true);
    19. 

  19. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00100', '管理系统','用户创建',true);
    20. 

  20. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00101', '管理系统','用户删除',true);
    21. 

  21. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00102', '管理系统','用户信息修改',true);
    22. 

  22. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00103', '管理系统','用户列表',true);
    23. 

  23. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00104', '管理系统','用户权限修改',true);
    24. 

  24. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00105', '管理系统','用户菜单修改',true);
    25. 

  25. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00106', '管理系统','用户详情',true);
    26. 

  26. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('M00107', '管理系统','用户密码重置',true);
    27. 

  27. -- 基础系统
    28. 

  28. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('SYSTEM', '基础系统','系统内部服务',true);
    29. 

  29. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('SYS0001', '基础系统','标准数据',true);
    30. 

  30. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('A00000', '基础系统','获取图片验证码',true);
    31. 

  31. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('A00001', '基础系统','获取短信验证码',true);
    32. 

  32. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('A00002', '基础系统','登录',true);
    33. 

  33. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('A00003', '基础系统','手机注册',true);
    34. 

  34. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('A00004', '基础系统','系统登出',true);
    35. 

  35. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('A00005', '基础系统','更改手机号',true);
    36. 

  36. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('A00006', '基础系统','获取授权码',true);
    37. 

  37. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('A00007', '基础系统','验证授权码',true);
    38. 

  38. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('B00001', '基础系统','个人信息查询',true);
    39. 

  39. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('B00002', '基础系统','修改个人信息',true);
    40. 

  40. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('B00003', '基础系统','修改密码',true);
    41. 

  41. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('B00020', '基础系统','实名认证',true);
    42. 

  42. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('B00021', '基础系统','上传文件',true);
    43. 

  43. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('B00022', '基础系统','下载文件',true);
    44. 

  44. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('B00023', '基础系统','上传文件不验证',true);
    45. 

  45. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('B00026', '基础系统','找回密码',true);
    46. 

  46. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('B00027', '基础系统','获取文件URL',true);
    47. 

  47. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('C00002', '基础系统','获取子账户列表',true);
    48. 

  48. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('C00005', '基础系统','获取统计信息',true);
    49. 

  49. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('C00011', '基础系统','获取积分（可开发票）列表',true);
    50. 

  50. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('C00012', '基础系统','充值积分',true);
    51. 

  51. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('C00013', '基础系统','申请开票',true);
    52. 

  52. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('C00014', '基础系统','查看发票',true);
    53. 

  53. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('C00015', '基础系统','补寄发票',true);
    54. 

  54. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('C00017', '基础系统','新增子账户',true);
    55. 

  55. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('C00018', '基础系统','新增最大账户数',true);
    56. 

  56. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('C00019', '基础系统','子账户操作',true);
    57. 

  57. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('C00020', '基础系统','获取协议',true);
    58. 

  58. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('C00022', '基础系统','获取商品列表',true);
    59. 

  59. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('C00023', '基础系统','获取商品结算价',true);
    60. 

  60. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('IEF001', '基础系统','支付下单',true);
    61. 

  61. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('IEF002', '基础系统','订单查询',true);
    62. 

  62. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('IEF003', '基础系统','支付退款',true);
    63. 

  63. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('IEF004', '基础系统','支付退款查询',true);
    64. 

  64. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('UT0002', '基础系统','版本更新',true);
    65. 

  65. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('X00102', '基础系统','项目上链跑批',true);
    66. 

  66. INSERT INTO SYS_FUNCTION(FUNCTIONID, CLASSNAME, FUNCTIONNAME ,ENABLE)VALUES ('X00104', '基础系统','存证函跑批',true);
    67.