lizhuang
/
DOAS-BACKEND
Suivre 1
Ajouter aux favoris 0
Bifurcation 0
Code Tickets 0 Demandes d'ajout 0 Versions 0 Wiki Activité
Digital Office Automation System Backend
Vous ne pouvez pas sélectionner plus de 25 sujets Les noms de sujets doivent commencer par une lettre ou un nombre, peuvent contenir des tirets ('-') et peuvent comporter jusqu'à 35 caractères.
1 Commit
1 Branche
Branche: main
Branches Tags
${ item.name }
Créer la branche ${ searchTerm }
de 'main'
${ noResults }
DOAS-BACKEND/script/sql/update/update-activiti20220701-act...

update-activiti20220701-activiti20220802.sql 7.3KB
Brut Lien permanent Vue normale Historique

初始提交
il y a 1 jour
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849 
  1. CREATE TABLE `act_business_rule` (

  2.  `id` BIGINT(20) NOT NULL COMMENT 'id',

  3.  `bean_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '全类名',

  4.  `method` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '方法名',

  5.  `param` VARCHAR(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '参数',

  6.  `remark` VARCHAR(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',

  7.  `create_time` DATETIME NOT NULL COMMENT '创建时间',

  8.  `update_time` DATETIME NOT NULL COMMENT '更新时间',

  9.  `create_by` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人',

  10.  `update_by` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '更新人',

  11.  PRIMARY KEY (`id`) USING BTREE

  12. ) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='业务规则';

  13. INSERT INTO `act_business_rule` (`id`, `bean_name`, `method`, `param`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`) VALUES(1471758168763731969,'workflowRuleUserComponent','queryUserById','[{\"paramType\":\"Long\",\"param\":\"userId\",\"remark\":\"用户id\",\"orderNo\":1}]','按id查询人员','2021-12-17 16:24:26','2022-07-15 21:54:29','admin','admin');

  14. INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES(1543513641015955457,'工作流程分类','act_category','0','admin','2022-07-03 16:35:04','admin','2022-07-03 16:35:04','工作流程分类');

  15. INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES(1543513861028171778,'0','OA','oa','act_category','','primary','N','0','admin','2022-07-03 16:35:56','admin','2022-07-03 17:15:54',NULL);

  16. INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES(1543513955815247873,'1','财务','finance','act_category','','primary','N','0','admin','2022-07-03 16:36:19','admin','2022-07-03 16:36:19',NULL);

  17. 

  18. ALTER TABLE act_node_assignee ADD auto_complete TINYINT(1) NOT NULL DEFAULT 0 COMMENT '自动审批,0不自动办理,1自动办理,当前节点自动办理';

  19. 

  20. alter table act_node_assignee rename column full_class_id to business_rule_id;

  21. 

  22. DROP TABLE IF EXISTS `sys_report_view`;

  23. CREATE TABLE `sys_report_view`  (

  24.                                     `id` bigint(20) NOT NULL COMMENT 'id',

  25.                                     `report_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '报表id',

  26.                                     `report_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报表名称',

  27.                                     `create_time` datetime(0) NOT NULL COMMENT '创建时间',

  28.                                     `update_time` datetime(0) NOT NULL COMMENT '修改时间',

  29.                                     `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人',

  30.                                     `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '更新人',

  31.                                     `order_no` int(10) NULL DEFAULT NULL COMMENT '排序',

  32.                                     PRIMARY KEY (`id`) USING BTREE

  33. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '报表查看' ROW_FORMAT = Dynamic;

  34. 

  35. -- ----------------------------

  36. -- Records of sys_report_view

  37. -- ----------------------------

  38. INSERT INTO `sys_report_view` VALUES (1556998684639973378, '716974933112426496', '操作日志', '2022-08-09 21:39:49', '2022-08-09 21:40:51', 'admin', 'admin', 1);

  39. 

  40. 

  41. delete from sys_menu where menu_id in (1538090530318184449,1556235156136067072,1556235156136067073,1556235156136067074,1556235156136067075,1556235156136067076,1556235156136067077);

  42. 

  43. INSERT INTO `ruoyi-activiti6`.`sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1538090530318184449, '设计报表', 1538090311987884033, 1, 'jmreport', 'jmreport/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2022-06-18 17:25:33', 'admin', '2022-08-06 19:42:27', '');

  44. INSERT INTO `ruoyi-activiti6`.`sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1556235156136067072, '报表查看', 1538090311987884033, 2, 'reportView', 'jmreport/view', NULL, 1, 0, 'C', '0', '0', 'report:reportView:list', '#', 'admin', '2022-08-07 19:53:34', 'admin', '2022-08-07 19:55:51', '报表查看菜单');

  45. INSERT INTO `ruoyi-activiti6`.`sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1556235156136067073, '报表查看查询', 1556235156136067072, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'report:reportView:query', '#', 'admin', '2022-08-07 19:53:34', '', NULL, '');

  46. INSERT INTO `ruoyi-activiti6`.`sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1556235156136067074, '报表查看新增', 1556235156136067072, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'report:reportView:add', '#', 'admin', '2022-08-07 19:53:34', '', NULL, '');

  47. INSERT INTO `ruoyi-activiti6`.`sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1556235156136067075, '报表查看修改', 1556235156136067072, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'report:reportView:edit', '#', 'admin', '2022-08-07 19:53:34', '', NULL, '');

  48. INSERT INTO `ruoyi-activiti6`.`sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1556235156136067076, '报表查看删除', 1556235156136067072, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'report:reportView:remove', '#', 'admin', '2022-08-07 19:53:34', '', NULL, '');

  49. INSERT INTO `ruoyi-activiti6`.`sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1556235156136067077, '报表查看导出', 1556235156136067072, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'report:reportView:export', '#', 'admin', '2022-08-07 19:53:34', '', NULL, '');