Halaman utama Jelajahi Bantuan
Daftar Masuk
linmingxu
/
rlzc-ai
1
0
Fork 0
Berkas Masalah 0 Permintaan Tarik 0 Wiki
Pohon: df5cbaaea8
Ranting Tag
rlzc-ai
/
script
/
sql
/
flowable.sql

flowable.sql 7.8 KB
Riwayat Mentahan

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667 
  1. insert into sys_menu values('11616', '工作流'  , '0',    '6', 'workflow',          '',                                 '', '1', '0', 'M', '0', '0', '',                       'tree-table', 103, 1, sysdate(), NULL, NULL, '');
    2. 

  2. insert into sys_menu values('11617', '模型管理', '11616', '2', 'model',             'workflow/model/index',             '', '1', '1', 'C', '0', '0', 'workflow:model:list',    'tree-table', 103, 1, sysdate(), NULL, NULL, '');
    3. 

  3. insert into sys_menu values('11618', '我的任务', '0', '7', 'task',              '',                                 '', '1', '0', 'M', '0', '0', '',                       'tree-table', 103, 1, sysdate(), NULL, NULL, '');
    4. 

  4. insert into sys_menu values('11619', '我的待办', '11618', '2', 'taskWaiting',       'workflow/task/taskWaiting',              '', '1', '1', 'C', '0', '0', '',                       'tree-table', 103, 1, sysdate(), NULL, NULL, '');
    5. 

  5. insert into sys_menu values('11632', '我的已办', '11618', '3', 'taskFinish',       'workflow/task/taskFinish',              '', '1', '1', 'C', '0', '0', '',                       'tree-table', 103, 1, sysdate(), NULL, NULL, '');
    6. 

  6. insert into sys_menu values('11633', '我的抄送', '11618', '4', 'taskCopyList',       'workflow/task/taskCopyList',              '', '1', '1', 'C', '0', '0', '',                       'tree-table', 103, 1, sysdate(), NULL, NULL, '');
    7. 

  7. insert into sys_menu values('11620', '流程定义', '11616', '3', 'processDefinition', 'workflow/processDefinition/index', '', '1', '1', 'C', '0', '0', '',                       'tree-table', 103, 1, sysdate(), NULL, NULL, '');
    8. 

  8. insert into sys_menu values('11621', '流程实例', '11630', '1', 'processInstance',   'workflow/processInstance/index',   '', '1', '1', 'C', '0', '0', '',                       'tree-table', 103, 1, sysdate(), NULL, NULL, '');
    9. 

  9. insert into sys_menu values('11622', '流程分类', '11616', '1', 'category',          'workflow/category/index',          '', '1', '0', 'C', '0', '0', 'workflow:category:list', 'tree-table', 103, 1, sysdate(), NULL, NULL, '');
    10. 

  10. insert into sys_menu values('11629', '我发起的', '11618', '1', 'myDocument',        'workflow/task/myDocument',         '', '1', '1', 'C', '0', '0', '',                       'tree-table', 103, 1, sysdate(), NULL, NULL, '');
    11. 

  11. insert into sys_menu values('11630', '流程监控', '11616', '4', 'monitor',           '',                                 '', '1', '0', 'M', '0', '0', '',                       'tree-table', 103, 1, sysdate(), NULL, NULL, '');
    12. 

  12. insert into sys_menu values('11631', '待办任务', '11630', '2', 'allTaskWaiting',    'workflow/task/allTaskWaiting',     '', '1', '1', 'C', '0', '0', '',                       'tree-table', 103, 1, sysdate(), NULL, NULL, '');
    13. 

  13. 

  14. 

  15. -- 流程分类管理相关按钮
    16. 

  16. insert into sys_menu values ('11623', '流程分类查询', '11622', '1', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:query', '#', 103, 1, sysdate(), null, null, '');
    17. 

  17. insert into sys_menu values ('11624', '流程分类新增', '11622', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:add',   '#', 103, 1, sysdate(), null, null, '');
    18. 

  18. insert into sys_menu values ('11625', '流程分类修改', '11622', '3', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:edit',  '#', 103, 1, sysdate(), null, null, '');
    19. 

  19. insert into sys_menu values ('11626', '流程分类删除', '11622', '4', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:remove','#', 103, 1, sysdate(), null, null, '');
    20. 

  20. insert into sys_menu values ('11627', '流程分类导出', '11622', '5', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:export','#', 103, 1, sysdate(), null, null, '');
    21. 

  21. -- 请假单信息
    22. 

  22. DROP TABLE if EXISTS test_leave;
    23. 

  23. create table test_leave
    24. 

  24. (
    25. 

  25.     id          bigint                       not null comment '主键',
    26. 

  26.     leave_type  varchar(255)                 not null comment '请假类型',
    27. 

  27.     start_date   datetime                     not null comment '开始时间',
    28. 

  28.     end_date     datetime                     not null comment '结束时间',
    29. 

  29.     leave_days  int(10)                      not null comment '请假天数',
    30. 

  30.     remark      varchar(255)                 null comment '请假原因',
    31. 

  31.     create_dept bigint                       null comment '创建部门',
    32. 

  32.     create_by   bigint                       null comment '创建者',
    33. 

  33.     create_time datetime                     null comment '创建时间',
    34. 

  34.     update_by   bigint                       null comment '更新者',
    35. 

  35.     update_time datetime                     null comment '更新时间',
    36. 

  36.     tenant_id   varchar(20) default '000000' null comment '租户编号',
    37. 

  37.     PRIMARY KEY (id) USING BTREE
    38. 

  38. ) ENGINE = InnoDB COMMENT = '请假申请表';
    39. 

  39. 

  40. -- 流程分类信息表
    41. 

  41. DROP TABLE if EXISTS wf_category;
    42. 

  42. create table wf_category
    43. 

  43. (
    44. 

  44.     id            bigint                       not null comment '主键'
    45. 

  45.         primary key,
    46. 

  46.     category_name varchar(255)                 null comment '分类名称',
    47. 

  47.     category_code varchar(255)                 null comment '分类编码',
    48. 

  48.     parent_id     bigint                       null comment '父级id',
    49. 

  49.     sort_num      int(19)                      null comment '排序',
    50. 

  50.     tenant_id     varchar(20) default '000000' null comment '租户编号',
    51. 

  51.     create_dept   bigint                       null comment '创建部门',
    52. 

  52.     create_by     bigint                       null comment '创建者',
    53. 

  53.     create_time   datetime                     null comment '创建时间',
    54. 

  54.     update_by     bigint                       null comment '更新者',
    55. 

  55.     update_time   datetime                     null comment '更新时间',
    56. 

  56.     constraint uni_category_code
    57. 

  57.         unique (category_code)
    58. 

  58. ) engine=innodb comment= '流程分类';
    59. 

  59. INSERT INTO wf_category values (1, 'OA', 'OA', 0, 0, '000000', 103, 1, sysdate(), 1, sysdate());
    60. 

  60. 

  61. 

  62. INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11638, '请假申请', 5, 1, 'leave', 'workflow/leave/index', 1, 0, 'C', '0', '0', 'demo:leave:list', '#', 103, 1, sysdate(), NULL, NULL, '请假申请菜单');
    63. 

  63. INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11639, '请假申请查询', 11638, 1, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:query', '#', 103, 1, sysdate(), NULL, NULL, '');
    64. 

  64. INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11640, '请假申请新增', 11638, 2, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:add', '#', 103, 1, sysdate(), NULL, NULL, '');
    65. 

  65. INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11641, '请假申请修改', 11638, 3, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:edit', '#', 103, 1, sysdate(), NULL, NULL, '');
    66. 

  66. INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11642, '请假申请删除', 11638, 4, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:remove', '#', 103, 1, sysdate(), NULL, NULL, '');
    67. 

  67. INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11643, '请假申请导出', 11638, 5, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:export', '#', 103, 1, sysdate(), NULL, NULL, '');
    68.