صفحهٔ اصلی گشت‌و‌گذار راهنما
ثبت نام ورود
linmingxu
/
rlzc-ai
1
0
انشعاب 0
پرونده‌ها مشکلات 0 درخواست واکشی 0 ویکی
درخت: c9cceb9e2d
شاخه‌ها تگ‌ها
rlzc-ai
/
script
/
sql
/
oracle
/
flowable.sql

flowable.sql 8.0 KB
تاريخچه خام

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394 
  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. -- 请假单信息
    23. 

  23. create table TEST_LEAVE
    24. 

  24. (
    25. 

  25.     ID          NUMBER(20) not null
    26. 

  26.         constraint PK_TEST_LEAVE
    27. 

  27.         primary key,
    28. 

  28.     LEAVE_TYPE  VARCHAR2(255),
    29. 

  29.     START_DATE  DATE,
    30. 

  30.     END_DATE    DATE,
    31. 

  31.     LEAVE_DAYS  NUMBER(10),
    32. 

  32.     REMARK      VARCHAR2(255),
    33. 

  33.     CREATE_DEPT NUMBER(20),
    34. 

  34.     CREATE_BY   NUMBER(20),
    35. 

  35.     CREATE_TIME DATE,
    36. 

  36.     UPDATE_BY   NUMBER(20),
    37. 

  37.     UPDATE_TIME DATE,
    38. 

  38.     TENANT_ID   VARCHAR2(20) default '000000'
    39. 

  39. );
    40. 

  40. 

  41. comment on table TEST_LEAVE is '请假申请表'
    42. 

  42. comment on column TEST_LEAVE.ID is '主键'
    43. 

  43. comment on column TEST_LEAVE.LEAVE_TYPE is '请假类型'
    44. 

  44. comment on column TEST_LEAVE.START_DATE is '开始时间'
    45. 

  45. comment on column TEST_LEAVE.END_DATE is '结束时间'
    46. 

  46. comment on column TEST_LEAVE.LEAVE_DAYS is '请假天数'
    47. 

  47. comment on column TEST_LEAVE.REMARK is '请假原因'
    48. 

  48. comment on column TEST_LEAVE.CREATE_DEPT is '创建部门'
    49. 

  49. comment on column TEST_LEAVE.CREATE_BY is '创建者'
    50. 

  50. comment on column TEST_LEAVE.CREATE_TIME is '创建时间'
    51. 

  51. comment on column TEST_LEAVE.UPDATE_BY is '更新者'
    52. 

  52. comment on column TEST_LEAVE.UPDATE_TIME is '更新时间'
    53. 

  53. comment on column TEST_LEAVE.TENANT_ID is '租户编号'
    54. 

  54. 

  55. -- 流程分类信息表
    56. 

  56. create table WF_CATEGORY
    57. 

  57. (
    58. 

  58.     ID            NUMBER(20) not null
    59. 

  59.         constraint PK_WF_CATEGORY
    60. 

  60.         primary key,
    61. 

  61.     CATEGORY_NAME VARCHAR2(255),
    62. 

  62.     CATEGORY_CODE VARCHAR2(255)
    63. 

  63.         constraint UNI_CATEGORY_CODE
    64. 

  64.         unique,
    65. 

  65.     PARENT_ID     NUMBER(20),
    66. 

  66.     SORT_NUM      NUMBER(10),
    67. 

  67.     TENANT_ID     VARCHAR2(20) default '000000'
    68. 

  68.     CREATE_DEPT   NUMBER(20),
    69. 

  69.     CREATE_BY     NUMBER(20),
    70. 

  70.     CREATE_TIME   DATE,
    71. 

  71.     UPDATE_BY     NUMBER(20),
    72. 

  72.     UPDATE_TIME   DATE
    73. 

  73. );
    74. 

  74. 

  75. comment on table WF_CATEGORY is '流程分类'
    76. 

  76. comment on column WF_CATEGORY.ID is '主键'
    77. 

  77. comment on column WF_CATEGORY.CATEGORY_NAME is '分类名称'
    78. 

  78. comment on column WF_CATEGORY.CATEGORY_CODE is '分类编码'
    79. 

  79. comment on column WF_CATEGORY.PARENT_ID is '父级id'
    80. 

  80. comment on column WF_CATEGORY.SORT_NUM is '排序'
    81. 

  81. comment on column WF_CATEGORY.TENANT_ID is '租户编号'
    82. 

  82. comment on column WF_CATEGORY.CREATE_DEPT is '创建部门'
    83. 

  83. comment on column WF_CATEGORY.CREATE_BY is '创建者'
    84. 

  84. comment on column WF_CATEGORY.CREATE_TIME is '创建时间'
    85. 

  85. comment on column WF_CATEGORY.UPDATE_BY is '更新者'
    86. 

  86. comment on column WF_CATEGORY.UPDATE_TIME is '更新时间'
    87. 

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

  88. 

  89. 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, '请假申请菜单');
    90. 

  90. 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, '');
    91. 

  91. 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, '');
    92. 

  92. 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, '');
    93. 

  93. 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, '');
    94. 

  94. 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, '');
    95.