Domovská stránka Prehľadávať Pomoc
Registrovať Prihlásiť sa
linmingxu
/
rlzc-ai
1
0
Fork 0
Súbory Issues 0 Pull requesty 0 Wiki
Strom: 651b2e140b
Branche Tagy
rlzc-ai
/
script
/
sql
/
oracle
/
flowable.sql

flowable.sql 11 KB
História Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157 
  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)
    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),
    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. create table WF_TASK_BACK_NODE
    90. 

  90. (
    91. 

  91.     ID            NUMBER(20) not null
    92. 

  92.         constraint PK_WF_TASK_BACK_NODE
    93. 

  93.         primary key,
    94. 

  94.     NODE_ID       VARCHAR2(255) not null,
    95. 

  95.     NODE_NAME     VARCHAR2(255) not null,
    96. 

  96.     ORDER_NO      NUMBER(20) not null,
    97. 

  97.     INSTANCE_ID   VARCHAR2(255) not null,
    98. 

  98.     TASK_TYPE     VARCHAR2(255) not null,
    99. 

  99.     ASSIGNEE      VARCHAR2(2000) not null,
    100. 

  100.     TENANT_ID     VARCHAR2(20),
    101. 

  101.     CREATE_DEPT   NUMBER(20),
    102. 

  102.     CREATE_BY     NUMBER(20),
    103. 

  103.     CREATE_TIME   DATE,
    104. 

  104.     UPDATE_BY     NUMBER(20),
    105. 

  105.     UPDATE_TIME   DATE
    106. 

  106. );
    107. 

  107. comment on table WF_TASK_BACK_NODE is '节点审批记录'
    108. 

  108. comment on column WF_TASK_BACK_NODE.ID is '主键'
    109. 

  109. comment on column WF_TASK_BACK_NODE.NODE_ID is '节点id'
    110. 

  110. comment on column WF_TASK_BACK_NODE.NODE_NAME is '节点名称'
    111. 

  111. comment on column WF_TASK_BACK_NODE.ORDER_NO is '排序'
    112. 

  112. comment on column WF_TASK_BACK_NODE.SORT_NUM is '排序'
    113. 

  113. comment on column WF_TASK_BACK_NODE.INSTANCE_ID is '流程实例id'
    114. 

  114. comment on column WF_TASK_BACK_NODE.TASK_TYPE is '节点类型'
    115. 

  115. comment on column WF_TASK_BACK_NODE.ASSIGNEE is '审批人'
    116. 

  116. comment on column WF_TASK_BACK_NODE.TENANT_ID is '租户编号'
    117. 

  117. comment on column WF_TASK_BACK_NODE.CREATE_DEPT is '创建部门'
    118. 

  118. comment on column WF_TASK_BACK_NODE.CREATE_BY is '创建者'
    119. 

  119. comment on column WF_TASK_BACK_NODE.CREATE_TIME is '创建时间'
    120. 

  120. comment on column WF_TASK_BACK_NODE.UPDATE_BY is '更新者'
    121. 

  121. comment on column WF_TASK_BACK_NODE.UPDATE_TIME is '更新时间'
    122. 

  122. 

  123. create table WF_DEFINITION_CONFIG
    124. 

  124. (
    125. 

  125.     ID            NUMBER(20) NOT NULL
    126. 

  126.         CONSTRAINT PK_WF_DEFINITION_CONFIG
    127. 

  127.         PRIMARY KEY,
    128. 

  128.     FORM_ID       NUMBER(20) NOT NULL,
    129. 

  129.     DEFINITION_ID VARCHAR2(255) NOT NULL,
    130. 

  130.     PROCESS_KEY   VARCHAR2(255)  NOT NULL,
    131. 

  131.     TENANT_ID     VARCHAR2(20),
    132. 

  132.     CREATE_DEPT   NUMBER(20),
    133. 

  133.     CREATE_BY     NUMBER(20),
    134. 

  134.     CREATE_TIME   DATE,
    135. 

  135.     UPDATE_BY     NUMBER(20),
    136. 

  136.     UPDATE_TIME   DATE,
    137. 

  137.     constraint uni_definition_id
    138. 

  138.         unique (definition_id)
    139. 

  139. );
    140. 

  140. comment on table WF_DEFINITION_CONFIG is '流程定义配置'
    141. 

  141. comment on column WF_DEFINITION_CONFIG.ID is '主键'
    142. 

  142. comment on column WF_DEFINITION_CONFIG.FORM_ID is '表单ID'
    143. 

  143. comment on column WF_DEFINITION_CONFIG.DEFINITION_ID is '流程定义ID'
    144. 

  144. comment on column WF_DEFINITION_CONFIG.PROCESS_KEY is '流程KEY'
    145. 

  145. comment on column WF_DEFINITION_CONFIG.TENANT_ID is '租户编号'
    146. 

  146. comment on column WF_DEFINITION_CONFIG.CREATE_DEPT is '创建部门'
    147. 

  147. comment on column WF_DEFINITION_CONFIG.CREATE_BY is '创建者'
    148. 

  148. comment on column WF_DEFINITION_CONFIG.CREATE_TIME is '创建时间'
    149. 

  149. comment on column WF_DEFINITION_CONFIG.UPDATE_BY is '更新者'
    150. 

  150. comment on column WF_DEFINITION_CONFIG.UPDATE_TIME is '更新时间'
    151. 

  151. 

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

  153. 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, '');
    154. 

  154. 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, '');
    155. 

  155. 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, '');
    156. 

  156. 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, '');
    157. 

  157. 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, '');
    158.