Home Explore Help
Sign In
chenc
/
sen-yu-service
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 0076f214ab
Branches Tags
sen-yu-service
/
jeecg-boot
/
jeecg-boot-module-activiti
/
db
/
update.sql

update.sql 6.8 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778 
  1. /*扩展表*/
    2. 

  2. create table act_z_process
    3. 

  3. (
    4. 

  4.     id             varchar(255) not null
    5. 

  5.         primary key,
    6. 

  6.     create_by      varchar(255) null,
    7. 

  7.     create_time    datetime     null,
    8. 

  8.     del_flag       int          null,
    9. 

  9.     update_by      varchar(255) null,
    10. 

  10.     update_time    datetime     null,
    11. 

  11.     category_id    varchar(255) null comment '所属分类',
    12. 

  12.     deployment_id  varchar(255) null comment '部署id',
    13. 

  13.     description    varchar(255) null comment '描述/备注',
    14. 

  14.     diagram_name   varchar(255) null comment '流程图片名',
    15. 

  15.     latest         bit          null comment '最新版本',
    16. 

  16.     name           varchar(255) null comment '流程名称',
    17. 

  17.     process_key    varchar(255) null comment '流程标识名称',
    18. 

  18.     status         int          null comment '流程状态 部署后默认1激活',
    19. 

  19.     version        int          null comment '版本',
    20. 

  20.     business_table varchar(255) null comment '关联业务表名',
    21. 

  21.     route_name     varchar(255) null comment '关联前端表单路由名',
    22. 

  22.     roles          varchar(255) null comment '授权的角色'
    23. 

  23. ) comment '流程定义扩展表';
    24. 

  24. create table act_z_business
    25. 

  25. (
    26. 

  26.     id           varchar(255)  not null
    27. 

  27.         primary key,
    28. 

  28.     create_by    varchar(255)  null,
    29. 

  29.     create_time  datetime      null,
    30. 

  30.     del_flag     int           null,
    31. 

  31.     update_by    varchar(255)  null,
    32. 

  32.     update_time  datetime      null,
    33. 

  33.     proc_def_id  varchar(255)  null comment '流程定义id',
    34. 

  34.     proc_inst_id varchar(255)  null comment '流程实例id',
    35. 

  35.     result       int default 0 null comment '结果状态 0未提交默认 1处理中 2通过 3驳回',
    36. 

  36.     status       int default 0 null comment '状态 0草稿默认 1处理中 2结束',
    37. 

  37.     table_id     varchar(255)  null comment '关联表id',
    38. 

  38.     title        varchar(255)  null comment '申请标题',
    39. 

  39.     user_id      varchar(255)  null comment '创建用户id',
    40. 

  40.     apply_time   datetime      null comment '提交申请时间',
    41. 

  41.     is_history   bit           null comment '历史标记',
    42. 

  42.     table_name   varchar(255)  null comment '数据表名'
    43. 

  43. ) comment '流程业务扩展表';
    44. 

  44. create table act_z_node
    45. 

  45. (
    46. 

  46.     id          varchar(255) not null
    47. 

  47.         primary key,
    48. 

  48.     create_by   varchar(255) null,
    49. 

  49.     create_time datetime     null,
    50. 

  50.     del_flag    int          null,
    51. 

  51.     update_by   varchar(255) null,
    52. 

  52.     update_time datetime     null,
    53. 

  53.     node_id     varchar(255) null comment '节点id',
    54. 

  54.     type        varchar(255) null comment '节点关联类型 0角色 1用户 2部门',
    55. 

  55.     relate_id   varchar(255) null comment '关联其他表id'
    56. 

  56. ) comment '流程节点扩展表';
    57. 

  57. 

  58. 

  59. 

  60. 

  61. 

  62. /*菜单  添加完菜单后需配置菜单权限*/
    63. 

  63. INSERT INTO sys_permission (id, parent_id, name, url, component, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_route, is_leaf, keep_alive, hidden, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
    64. 

  64. VALUES ('1238331160370012162', null, '工作流', '/activiti', 'layouts/RouteView', null, null, 0, null, '1', 1.1, 0, 'cluster', 1, 0, 0, 0, null, 'admin', '2020-03-13 13:08:50', null, null, 0, 0, '1', 0);
    65. 

  65. INSERT INTO sys_permission (id, parent_id, name, url, component, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_route, is_leaf, keep_alive, hidden, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
    66. 

  66.  VALUES ('1238331682929958913', '1238331160370012162', '流程模型', '/activiti/ModelList', 'activiti/ModelList', null, null, 1, null, '1', 2, 0, 'bars', 1, 1, 0, 0, null, 'admin', '2020-03-13 13:10:55', null, null, 0, 0, '1', 0);
    67. 

  67. INSERT INTO sys_permission (id, parent_id, name, url, component, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_route, is_leaf, keep_alive, hidden, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
    68. 

  68.  VALUES ('1238331682929958914', '1238331160370012162', '已发布模型', '/activiti/ProcessModelList', 'activiti/ProcessModelList', null, null, 1, null, '1', 3, 0, 'bars', 1, 1, 0, 0, null, 'admin', '2020-03-13 13:10:55', null, null, 0, 0, '1', 0);
    69. 

  69. INSERT INTO sys_permission (id, parent_id, name, url, component, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_route, is_leaf, keep_alive, hidden, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
    70. 

  70.  VALUES ('1238331682929958915', '1238331160370012162', '我的申请', '/activiti/applyList', 'activiti/applyList', null, null, 1, null, '1', 4, 0, 'bars', 1, 1, 0, 0, null, 'admin', '2020-03-13 13:10:55', null, null, 0, 0, '1', 0);
    71. 

  71. INSERT INTO sys_permission (id, parent_id, name, url, component, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_route, is_leaf, keep_alive, hidden, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
    72. 

  72.  VALUES ('1238331682929958916', '1238331160370012162', '我的待办', '/activiti/todoManage', 'activiti/todoManage', null, null, 1, null, '1', 5, 0, 'bars', 1, 1, 0, 0, null, 'admin', '2020-03-13 13:10:55', null, null, 0, 0, '1', 0);
    73. 

  73. INSERT INTO sys_permission (id, parent_id, name, url, component, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_route, is_leaf, keep_alive, hidden, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
    74. 

  74.  VALUES ('1238331682929958917', '1238331160370012162', '我的已办', '/activiti/doneManage', 'activiti/doneManage', null, null, 1, null, '1', 6, 0, 'bars', 1, 1, 0, 0, null, 'admin', '2020-03-13 13:10:55', null, null, 0, 0, '1', 0);
    75. 

  75. INSERT INTO sys_permission (id, parent_id, name, url, component, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_route, is_leaf, keep_alive, hidden, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
    76. 

  76.  VALUES ('1238331682929958918', '1238331160370012162', '进行中的流程', '/activiti/processInsManage', 'activiti/processInsManage', null, null, 1, null, '1', 7, 0, 'bars', 1, 1, 0, 0, null, 'admin', '2020-03-13 13:10:55', null, null, 0, 0, '1', 0);
    77. 

  77. INSERT INTO sys_permission (id, parent_id, name, url, component, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_route, is_leaf, keep_alive, hidden, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
    78. 

  78.  VALUES ('1238331682929958919', '1238331160370012162', '已结束流程', '/activiti/processFinishManage', 'activiti/processFinishManage', null, null, 1, null, '1', 8, 0, 'bars', 1, 1, 0, 0, null, 'admin', '2020-03-13 13:10:55', null, null, 0, 0, '1', 0);
    79.