lbqms.git - Gitblit

¶Ô±ÈÐÂÎÄ¼þ
			@@ -0,0 +1,253 @@
			-- ----------------------------
			-- 0ãwarm-flow-all.sqlï¼å°åï¼https://gitee.com/dromara/warm-flow/blob/master/sql/mysql/warm-flow-all.sql
			-- ----------------------------
			CREATE TABLE `flow_definition`
			(
			`id` bigint unsigned NOT NULL COMMENT 'ä¸»é®id',
			`flow_code` varchar(40) NOT NULL COMMENT 'æµç¨ç¼ç ',
			`flow_name` varchar(100) NOT NULL COMMENT 'æµç¨åç§°',
			`category` varchar(100) DEFAULT NULL COMMENT 'æµç¨ç±»å«',
			`version` varchar(20) NOT NULL COMMENT 'æµç¨çæ¬',
			`is_publish` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'æ¯å¦åå¸ï¼0æªåå¸ 1å·²åå¸ 9å¤±æï¼',
			`form_custom` char(1) DEFAULT 'N' COMMENT 'å®¡æ¹è¡¨åæ¯å¦èªå®ä¹ï¼Yæ¯ Nå¦ï¼',
			`form_path` varchar(100) DEFAULT NULL COMMENT 'å®¡æ¹è¡¨åè·¯å¾',
			`activity_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'æµç¨æ¿æ´»ç¶æï¼0æèµ· 1æ¿æ´»ï¼',
			`listener_type` varchar(100) DEFAULT NULL COMMENT 'çå¬å¨ç±»å',
			`listener_path` varchar(400) DEFAULT NULL COMMENT 'çå¬å¨è·¯å¾',
			`ext` varchar(500) DEFAULT NULL COMMENT 'ä¸å¡è¯¦æ åä¸å¡è¡¨å¯¹è±¡jsonåç¬¦ä¸²',
			`create_time` datetime DEFAULT NULL COMMENT 'åå»ºæ¶é´',
			`update_time` datetime DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
			`del_flag` char(1) DEFAULT '0' COMMENT 'å é¤æ å¿',
			`tenant_id` varchar(40) DEFAULT NULL COMMENT 'ç§æ·id',
			PRIMARY KEY (`id`) USING BTREE
			) ENGINE = InnoDB COMMENT ='æµç¨å®ä¹è¡¨';

			CREATE TABLE `flow_node`
			(
			`id` bigint unsigned NOT NULL COMMENT 'ä¸»é®id',
			`node_type` tinyint(1) NOT NULL COMMENT 'èç¹ç±»åï¼0å¼å§èç¹ 1ä¸é´èç¹ 2ç»æèç¹ 3äºæ¥ç½å³ 4å¹¶è¡ç½å³ï¼',
			`definition_id` bigint NOT NULL COMMENT 'æµç¨å®ä¹id',
			`node_code` varchar(100) NOT NULL COMMENT 'æµç¨èç¹ç¼ç ',
			`node_name` varchar(100) DEFAULT NULL COMMENT 'æµç¨èç¹åç§°',
			`permission_flag` varchar(200) DEFAULT NULL COMMENT 'æéæ è¯ï¼æéç±»å:æéæ è¯ï¼å¯ä»¥å¤ä¸ªï¼ç¨éå·éå¼)',
			`node_ratio` decimal(6, 3) DEFAULT NULL COMMENT 'æµç¨ç¾ç½²æ¯ä¾å¼',
			`coordinate` varchar(100) DEFAULT NULL COMMENT 'åæ ',
			`skip_any_node` varchar(100) DEFAULT 'N' COMMENT 'æ¯å¦å¯ä»¥éåä»»æèç¹ï¼Yæ¯ Nå¦ï¼å³å°å é¤',
			`any_node_skip` varchar(100) DEFAULT NULL COMMENT 'ä»»æç»ç¹è·³è½¬',
			`listener_type` varchar(100) DEFAULT NULL COMMENT 'çå¬å¨ç±»å',
			`listener_path` varchar(400) DEFAULT NULL COMMENT 'çå¬å¨è·¯å¾',
			`handler_type` varchar(100) DEFAULT NULL COMMENT 'å¤çå¨ç±»å',
			`handler_path` varchar(400) DEFAULT NULL COMMENT 'å¤çå¨è·¯å¾',
			`form_custom` char(1) DEFAULT 'N' COMMENT 'å®¡æ¹è¡¨åæ¯å¦èªå®ä¹ï¼Yæ¯ Nå¦ï¼',
			`form_path` varchar(100) DEFAULT NULL COMMENT 'å®¡æ¹è¡¨åè·¯å¾',
			`version` varchar(20) NOT NULL COMMENT 'çæ¬',
			`create_time` datetime DEFAULT NULL COMMENT 'åå»ºæ¶é´',
			`update_time` datetime DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
			`del_flag` char(1) DEFAULT '0' COMMENT 'å é¤æ å¿',
			`tenant_id` varchar(40) DEFAULT NULL COMMENT 'ç§æ·id',
			PRIMARY KEY (`id`) USING BTREE
			) ENGINE = InnoDB COMMENT ='æµç¨èç¹è¡¨';

			CREATE TABLE `flow_skip`
			(
			`id` bigint unsigned NOT NULL COMMENT 'ä¸»é®id',
			`definition_id` bigint NOT NULL COMMENT 'æµç¨å®ä¹id',
			`now_node_code` varchar(100) NOT NULL COMMENT 'å½åæµç¨èç¹çç¼ç ',
			`now_node_type` tinyint(1) DEFAULT NULL COMMENT 'å½åèç¹ç±»åï¼0å¼å§èç¹ 1ä¸é´èç¹ 2ç»æèç¹ 3äºæ¥ç½å³ 4å¹¶è¡ç½å³ï¼',
			`next_node_code` varchar(100) NOT NULL COMMENT 'ä¸ä¸ä¸ªæµç¨èç¹çç¼ç ',
			`next_node_type` tinyint(1) DEFAULT NULL COMMENT 'ä¸ä¸ä¸ªèç¹ç±»åï¼0å¼å§èç¹ 1ä¸é´èç¹ 2ç»æèç¹ 3äºæ¥ç½å³ 4å¹¶è¡ç½å³ï¼',
			`skip_name` varchar(100) DEFAULT NULL COMMENT 'è·³è½¬åç§°',
			`skip_type` varchar(40) DEFAULT NULL COMMENT 'è·³è½¬ç±»åï¼PASSå®¡æ¹éè¿ REJECTéåï¼',
			`skip_condition` varchar(200) DEFAULT NULL COMMENT 'è·³è½¬æ¡ä»¶',
			`coordinate` varchar(100) DEFAULT NULL COMMENT 'åæ ',
			`create_time` datetime DEFAULT NULL COMMENT 'åå»ºæ¶é´',
			`update_time` datetime DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
			`del_flag` char(1) DEFAULT '0' COMMENT 'å é¤æ å¿',
			`tenant_id` varchar(40) DEFAULT NULL COMMENT 'ç§æ·id',
			PRIMARY KEY (`id`) USING BTREE
			) ENGINE = InnoDB COMMENT ='èç¹è·³è½¬å³èè¡¨';

			CREATE TABLE `flow_instance`
			(
			`id` bigint NOT NULL COMMENT 'ä¸»é®id',
			`definition_id` bigint NOT NULL COMMENT 'å¯¹åºflow_definitionè¡¨çid',
			`business_id` varchar(40) NOT NULL COMMENT 'ä¸å¡id',
			`node_type` tinyint(1) NOT NULL COMMENT 'èç¹ç±»åï¼0å¼å§èç¹ 1ä¸é´èç¹ 2ç»æèç¹ 3äºæ¥ç½å³ 4å¹¶è¡ç½å³ï¼',
			`node_code` varchar(40) NOT NULL COMMENT 'æµç¨èç¹ç¼ç ',
			`node_name` varchar(100) DEFAULT NULL COMMENT 'æµç¨èç¹åç§°',
			`variable` text COMMENT 'ä»»å¡åé',
			`flow_status` varchar(20) NOT NULL COMMENT 'æµç¨ç¶æï¼0å¾æäº¤ 1å®¡æ¹ä¸ 2 å®¡æ¹éè¿ 3èªå¨éè¿ 4ç»æ¢ 5ä½åº 6æ¤é 7åå 8å·²å®æ 9å·²éå 10å¤±æï¼',
			`activity_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'æµç¨æ¿æ´»ç¶æï¼0æèµ· 1æ¿æ´»ï¼',
			`def_json` text COMMENT 'æµç¨å®ä¹json',
			`create_by` varchar(64) DEFAULT '' COMMENT 'åå»ºè',
			`create_time` datetime DEFAULT NULL COMMENT 'åå»ºæ¶é´',
			`update_time` datetime DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
			`ext` varchar(500) DEFAULT NULL COMMENT 'æ©å±åæ®µï¼é¢çç»ä¸å¡ç³»ç»ä½¿ç¨',
			`del_flag` char(1) DEFAULT '0' COMMENT 'å é¤æ å¿',
			`tenant_id` varchar(40) DEFAULT NULL COMMENT 'ç§æ·id',
			PRIMARY KEY (`id`) USING BTREE
			) ENGINE = InnoDB COMMENT ='æµç¨å®ä¾è¡¨';

			CREATE TABLE `flow_task`
			(
			`id` bigint NOT NULL COMMENT 'ä¸»é®id',
			`definition_id` bigint NOT NULL COMMENT 'å¯¹åºflow_definitionè¡¨çid',
			`instance_id` bigint NOT NULL COMMENT 'å¯¹åºflow_instanceè¡¨çid',
			`node_code` varchar(100) NOT NULL COMMENT 'èç¹ç¼ç ',
			`node_name` varchar(100) DEFAULT NULL COMMENT 'èç¹åç§°',
			`node_type` tinyint(1) NOT NULL COMMENT 'èç¹ç±»åï¼0å¼å§èç¹ 1ä¸é´èç¹ 2ç»æèç¹ 3äºæ¥ç½å³ 4å¹¶è¡ç½å³ï¼',
			`form_custom` char(1) DEFAULT 'N' COMMENT 'å®¡æ¹è¡¨åæ¯å¦èªå®ä¹ï¼Yæ¯ Nå¦ï¼',
			`form_path` varchar(100) DEFAULT NULL COMMENT 'å®¡æ¹è¡¨åè·¯å¾',
			`create_time` datetime DEFAULT NULL COMMENT 'åå»ºæ¶é´',
			`update_time` datetime DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
			`del_flag` char(1) DEFAULT '0' COMMENT 'å é¤æ å¿',
			`tenant_id` varchar(40) DEFAULT NULL COMMENT 'ç§æ·id',
			PRIMARY KEY (`id`) USING BTREE
			) ENGINE = InnoDB COMMENT ='å¾åä»»å¡è¡¨';

			CREATE TABLE `flow_his_task`
			(
			`id` bigint(20) unsigned NOT NULL COMMENT 'ä¸»é®id',
			`definition_id` bigint(20) NOT NULL COMMENT 'å¯¹åºflow_definitionè¡¨çid',
			`instance_id` bigint(20) NOT NULL COMMENT 'å¯¹åºflow_instanceè¡¨çid',
			`task_id` bigint(20) NOT NULL COMMENT 'å¯¹åºflow_taskè¡¨çid',
			`node_code` varchar(100) DEFAULT NULL COMMENT 'å¼å§èç¹ç¼ç ',
			`node_name` varchar(100) DEFAULT NULL COMMENT 'å¼å§èç¹åç§°',
			`node_type` tinyint(1) DEFAULT NULL COMMENT 'å¼å§èç¹ç±»åï¼0å¼å§èç¹ 1ä¸é´èç¹ 2ç»æèç¹ 3äºæ¥ç½å³ 4å¹¶è¡ç½å³ï¼',
			`target_node_code` varchar(200) DEFAULT NULL COMMENT 'ç®æ èç¹ç¼ç ',
			`target_node_name` varchar(200) DEFAULT NULL COMMENT 'ç»æèç¹åç§°',
			`approver` varchar(40) DEFAULT NULL COMMENT 'å®¡æ¹è',
			`cooperate_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'åä½æ¹å¼(1å®¡æ¹ 2è½¬å 3å§æ´¾ 4ä¼ç¾ 5ç¥¨ç¾ 6å ç¾ 7åç¾)',
			`collaborator` varchar(40) DEFAULT NULL COMMENT 'åä½äºº',
			`skip_type` varchar(10) NOT NULL COMMENT 'æµè½¬ç±»åï¼PASSéè¿ REJECTéå NONEæ å¨ä½ï¼',
			`flow_status` varchar(20) NOT NULL COMMENT 'æµç¨ç¶æï¼1å®¡æ¹ä¸ 2 å®¡æ¹éè¿ 9å·²éå 10å¤±æï¼',
			`form_custom` char(1) DEFAULT 'N' COMMENT 'å®¡æ¹è¡¨åæ¯å¦èªå®ä¹ï¼Yæ¯ Nå¦ï¼',
			`form_path` varchar(100) DEFAULT NULL COMMENT 'å®¡æ¹è¡¨åè·¯å¾',
			`message` varchar(500) DEFAULT NULL COMMENT 'å®¡æ¹æè§',
			`variable` TEXT DEFAULT NULL COMMENT 'ä»»å¡åé',
			`ext` varchar(500) DEFAULT NULL COMMENT 'ä¸å¡è¯¦æ åä¸å¡è¡¨å¯¹è±¡jsonåç¬¦ä¸²',
			`create_time` datetime DEFAULT NULL COMMENT 'ä»»å¡å¼å§æ¶é´',
			`update_time` datetime DEFAULT NULL COMMENT 'å®¡æ¹å®ææ¶é´',
			`del_flag` char(1) DEFAULT '0' COMMENT 'å é¤æ å¿',
			`tenant_id` varchar(40) DEFAULT NULL COMMENT 'ç§æ·id',
			PRIMARY KEY (`id`) USING BTREE
			) ENGINE = InnoDB COMMENT ='åå²ä»»å¡è®°å½è¡¨';


			CREATE TABLE `flow_user`
			(
			`id` bigint unsigned NOT NULL COMMENT 'ä¸»é®id',
			`type` char(1) NOT NULL COMMENT 'äººåç±»åï¼1å¾åä»»å¡çå®¡æ¹äººæé 2å¾åä»»å¡çè½¬åäººæé 3å¾åä»»å¡çå§æäººæéï¼',
			`processed_by` varchar(80) DEFAULT NULL COMMENT 'æéäºº',
			`associated` bigint NOT NULL COMMENT 'ä»»å¡è¡¨id',
			`create_time` datetime DEFAULT NULL COMMENT 'åå»ºæ¶é´',
			`create_by` varchar(80) DEFAULT NULL COMMENT 'åå»ºäºº',
			`update_time` datetime DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
			`del_flag` char(1) DEFAULT '0' COMMENT 'å é¤æ å¿',
			`tenant_id` varchar(40) DEFAULT NULL COMMENT 'ç§æ·id',
			PRIMARY KEY (`id`) USING BTREE,
			KEY `user_processed_type` (`processed_by`, `type`)
			) ENGINE = InnoDB COMMENT ='æµç¨ç¨æ·è¡¨';

			-- ----------------------------
			-- æµç¨åç±»è¡¨
			-- ----------------------------
			create table flow_category
			(
			category_id bigint(20) not null comment 'æµç¨åç±»ID',
			tenant_id varchar(20) default '000000' comment 'ç§æ·ç¼å·',
			parent_id bigint(20) default 0 comment 'ç¶æµç¨åç±»id',
			ancestors varchar(500) default '' comment 'ç¥çº§åè¡¨',
			category_name varchar(30) not null comment 'æµç¨åç±»åç§°',
			order_num int(4) default 0 comment 'æ¾ç¤ºé¡ºåº',
			del_flag char(1) default '0' comment 'å é¤æ å¿ï¼0ä»£è¡¨åå¨ 1ä»£è¡¨å é¤ï¼',
			create_dept bigint(20) null comment 'åå»ºé¨é¨',
			create_by bigint(20) null comment 'åå»ºè',
			create_time datetime null comment 'åå»ºæ¶é´',
			update_by bigint(20) null comment 'æ´æ°è',
			update_time datetime null comment 'æ´æ°æ¶é´',
			primary key (category_id)
			) engine = innodb comment = 'æµç¨åç±»';

			INSERT INTO flow_category values (100, '000000', 0, '0', 'OAå®¡æ¹', 0, '0', 103, 1, sysdate(), null, null);
			INSERT INTO flow_category values (101, '000000', 100, '0,100', 'åå¤ç®¡ç', 0, '0', 103, 1, sysdate(), null, null);
			INSERT INTO flow_category values (102, '000000', 100, '0,100', 'äººäºç®¡ç', 1, '0', 103, 1, sysdate(), null, null);
			INSERT INTO flow_category values (103, '000000', 101, '0,100,101', 'è¯·å', 0, '0', 103, 1, sysdate(), null, null);
			INSERT INTO flow_category values (104, '000000', 101, '0,100,101', 'åºå·®', 1, '0', 103, 1, sysdate(), null, null);
			INSERT INTO flow_category values (105, '000000', 101, '0,100,101', 'å ç', 2, '0', 103, 1, sysdate(), null, null);
			INSERT INTO flow_category values (106, '000000', 101, '0,100,101', 'æ¢ç', 3, '0', 103, 1, sysdate(), null, null);
			INSERT INTO flow_category values (107, '000000', 101, '0,100,101', 'å¤åº', 4, '0', 103, 1, sysdate(), null, null);
			INSERT INTO flow_category values (108, '000000', 102, '0,100,102', 'è½¬æ£', 1, '0', 103, 1, sysdate(), null, null);
			INSERT INTO flow_category values (109, '000000', 102, '0,100,102', 'ç¦»è', 2, '0', 103, 1, sysdate(), null, null);

			-- ----------------------------
			-- è¯·ååä¿¡æ¯
			-- ----------------------------
			create table test_leave
			(
			id bigint(20) not null comment 'id',
			tenant_id varchar(20) default '000000' comment 'ç§æ·ç¼å·',
			leave_type varchar(255) not null comment 'è¯·åç±»å',
			start_date datetime not null comment 'å¼å§æ¶é´',
			end_date datetime not null comment 'ç»ææ¶é´',
			leave_days int(10) not null comment 'è¯·åå¤©æ°',
			remark varchar(255) null comment 'è¯·ååå ',
			status varchar(255) null comment 'ç¶æ',
			create_dept bigint null comment 'åå»ºé¨é¨',
			create_by bigint null comment 'åå»ºè',
			create_time datetime null comment 'åå»ºæ¶é´',
			update_by bigint null comment 'æ´æ°è',
			update_time datetime null comment 'æ´æ°æ¶é´',
			PRIMARY KEY (id) USING BTREE
			) ENGINE = InnoDB COMMENT = 'è¯·åç³è¯·è¡¨';

			insert into sys_menu values ('11616', 'å·¥ä½æµ', '0', '6', 'workflow', '', '', '1', '0', 'M', '0', '0', '', 'workflow', 103, 1, sysdate(),NULL, NULL, '');
			insert into sys_menu values ('11618', 'æçä»»å¡', '0', '7', 'task', '', '', '1', '0', 'M', '0', '0', '', 'my-task', 103, 1, sysdate(), NULL, NULL, '');
			insert into sys_menu values ('11619', 'æçå¾å', '11618', '2', 'taskWaiting', 'workflow/task/taskWaiting', '', '1', '1', 'C', '0', '0', '', 'waiting', 103, 1, sysdate(), NULL, NULL, '');
			insert into sys_menu values ('11632', 'æçå·²å', '11618', '3', 'taskFinish', 'workflow/task/taskFinish', '', '1', '1', 'C', '0', '0', '', 'finish', 103, 1, sysdate(), NULL, NULL, '');
			insert into sys_menu values ('11633', 'æçæé', '11618', '4', 'taskCopyList', 'workflow/task/taskCopyList', '', '1', '1', 'C', '0', '0', '', 'my-copy', 103, 1, sysdate(), NULL, NULL, '');
			insert into sys_menu values ('11620', 'æµç¨å®ä¹', '11616', '3', 'processDefinition', 'workflow/processDefinition/index', '', '1', '1', 'C', '0', '0', '', 'process-definition', 103, 1, sysdate(), NULL, NULL, '');
			insert into sys_menu values ('11621', 'æµç¨å®ä¾', '11630', '1', 'processInstance', 'workflow/processInstance/index', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, sysdate(), NULL, NULL, '');
			insert into sys_menu values ('11622', 'æµç¨åç±»', '11616', '1', 'category', 'workflow/category/index', '', '1', '0', 'C', '0', '0', 'workflow:category:list', 'category', 103, 1, sysdate(), NULL, NULL, '');
			insert into sys_menu values ('11629', 'æåèµ·ç', '11618', '1', 'myDocument', 'workflow/task/myDocument', '', '1', '1', 'C', '0', '0', '', 'guide', 103, 1, sysdate(), NULL, NULL, '');
			insert into sys_menu values ('11630', 'æµç¨çæ§', '11616', '4', 'monitor', '', '', '1', '0', 'M', '0', '0', '', 'monitor', 103, 1, sysdate(), NULL, NULL, '');
			insert into sys_menu values ('11631', 'å¾åä»»å¡', '11630', '2', 'allTaskWaiting', 'workflow/task/allTaskWaiting', '', '1', '1', 'C', '0', '0', '', 'waiting', 103, 1, sysdate(), NULL, NULL, '');
			-- æµç¨åç±»ç®¡çç¸å³æé®
			insert into sys_menu values ('11623', 'æµç¨åç±»æ¥è¯¢', '11622', '1', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:query', '#', 103, 1,sysdate(), null, null, '');
			insert into sys_menu values ('11624', 'æµç¨åç±»æ°å¢', '11622', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:add', '#', 103, 1,sysdate(), null, null, '');
			insert into sys_menu values ('11625', 'æµç¨åç±»ä¿®æ¹', '11622', '3', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:edit', '#', 103, 1,sysdate(), null, null, '');
			insert into sys_menu values ('11626', 'æµç¨åç±»å é¤', '11622', '4', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:remove', '#', 103,1, sysdate(), null, null, '');
			insert into sys_menu values ('11627', 'æµç¨åç±»å¯¼åº', '11622', '5', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:export', '#', 103,1, sysdate(), null, null, '');
			-- è¯·åæµè¯ç¸å³æé®
			insert into sys_menu VALUES (11638, 'è¯·åç³è¯·', 5, 1, 'leave', 'workflow/leave/index', '', 1, 0, 'C', '0', '0', 'workflow:leave:list', '#', 103, 1, sysdate(), NULL, NULL, 'è¯·åç³è¯·èå');
			insert into sys_menu VALUES (11639, 'è¯·åç³è¯·æ¥è¯¢', 11638, 1, '#', '', '', 1, 0, 'F', '0', '0', 'workflow:leave:query', '#', 103, 1, sysdate(), NULL, NULL, '');
			insert into sys_menu VALUES (11640, 'è¯·åç³è¯·æ°å¢', 11638, 2, '#', '', '', 1, 0, 'F', '0', '0', 'workflow:leave:add', '#', 103, 1, sysdate(), NULL, NULL, '');
			insert into sys_menu VALUES (11641, 'è¯·åç³è¯·ä¿®æ¹', 11638, 3, '#', '', '', 1, 0, 'F', '0', '0', 'workflow:leave:edit', '#', 103, 1, sysdate(), NULL, NULL, '');
			insert into sys_menu VALUES (11642, 'è¯·åç³è¯·å é¤', 11638, 4, '#', '', '', 1, 0, 'F', '0', '0', 'workflow:leave:remove', '#', 103, 1, sysdate(), NULL, NULL, '');
			insert into sys_menu VALUES (11643, 'è¯·åç³è¯·å¯¼åº', 11638, 5, '#', '', '', 1, 0, 'F', '0', '0', 'workflow:leave:export', '#', 103, 1, sysdate(), NULL, NULL, '');

			INSERT INTO sys_dict_type VALUES (13, '000000', 'ä¸å¡ç¶æ', 'wf_business_status', 103, 1, sysdate(), NULL, NULL, 'ä¸å¡ç¶æåè¡¨');
			INSERT INTO sys_dict_type VALUES (14, '000000', 'è¡¨åç±»å', 'wf_form_type', 103, 1, sysdate(), NULL, NULL, 'è¡¨åç±»ååè¡¨');
			INSERT INTO sys_dict_type VALUES (15, '000000', 'ä»»å¡ç¶æ', 'wf_task_status', 103, 1, sysdate(), NULL, NULL, 'ä»»å¡ç¶æ');
			INSERT INTO sys_dict_data VALUES (39, '000000', 1, 'å·²æ¤é', 'cancel', 'wf_business_status', '', 'danger', 'N', 103, 1, sysdate(), NULL, NULL,'å·²æ¤é');
			INSERT INTO sys_dict_data VALUES (40, '000000', 2, 'èç¨¿', 'draft', 'wf_business_status', '', 'info', 'N', 103, 1, sysdate(), NULL, NULL, 'èç¨¿');
			INSERT INTO sys_dict_data VALUES (41, '000000', 3, 'å¾å®¡æ ¸', 'waiting', 'wf_business_status', '', 'primary', 'N', 103, 1, sysdate(), NULL, NULL,'å¾å®¡æ ¸');
			INSERT INTO sys_dict_data VALUES (42, '000000', 4, 'å·²å®æ', 'finish', 'wf_business_status', '', 'success', 'N', 103, 1, sysdate(), NULL, NULL,'å·²å®æ');
			INSERT INTO sys_dict_data VALUES (43, '000000', 5, 'å·²ä½åº', 'invalid', 'wf_business_status', '', 'danger', 'N', 103, 1, sysdate(), NULL, NULL,'å·²ä½åº');
			INSERT INTO sys_dict_data VALUES (44, '000000', 6, 'å·²éå', 'back', 'wf_business_status', '', 'danger', 'N', 103, 1, sysdate(), NULL, NULL,'å·²éå');
			INSERT INTO sys_dict_data VALUES (45, '000000', 7, 'å·²ç»æ¢', 'termination', 'wf_business_status', '', 'danger', 'N', 103, 1, sysdate(), NULL,NULL, 'å·²ç»æ¢');
			INSERT INTO sys_dict_data VALUES (46, '000000', 1, 'èªå®ä¹è¡¨å', 'static', 'wf_form_type', '', 'success', 'N', 103, 1, sysdate(), NULL, NULL,'èªå®ä¹è¡¨å');
			INSERT INTO sys_dict_data VALUES (47, '000000', 2, 'å¨æè¡¨å', 'dynamic', 'wf_form_type', '', 'primary', 'N', 103, 1, sysdate(), NULL, NULL,'å¨æè¡¨å');
			INSERT INTO sys_dict_data VALUES (48, '000000', 1, 'æ¤é', 'cancel', 'wf_task_status', '', 'danger', 'N', 103, 1, sysdate(), NULL, NULL, 'æ¤é');
			INSERT INTO sys_dict_data VALUES (49, '000000', 2, 'éè¿', 'pass', 'wf_task_status', '', 'success', 'N', 103, 1, sysdate(), NULL, NULL, 'éè¿');
			INSERT INTO sys_dict_data VALUES (50, '000000', 3, 'å¾å®¡æ ¸', 'waiting', 'wf_task_status', '', 'primary', 'N', 103, 1, sysdate(), NULL, NULL, 'å¾å®¡æ ¸');
			INSERT INTO sys_dict_data VALUES (51, '000000', 4, 'ä½åº', 'invalid', 'wf_task_status', '', 'danger', 'N', 103, 1, sysdate(), NULL, NULL, 'ä½åº');
			INSERT INTO sys_dict_data VALUES (52, '000000', 5, 'éå', 'back', 'wf_task_status', '', 'danger', 'N', 103, 1, sysdate(), NULL, NULL, 'éå');
			INSERT INTO sys_dict_data VALUES (53, '000000', 6, 'ç»æ¢', 'termination', 'wf_task_status', '', 'danger', 'N', 103, 1, sysdate(), NULL, NULL, 'ç»æ¢');
			INSERT INTO sys_dict_data VALUES (54, '000000', 7, 'è½¬å', 'transfer', 'wf_task_status', '', 'primary', 'N', 103, 1, sysdate(), NULL, NULL, 'è½¬å');
			INSERT INTO sys_dict_data VALUES (55, '000000', 8, 'å§æ', 'depute', 'wf_task_status', '', 'primary', 'N', 103, 1, sysdate(), NULL, NULL, 'å§æ');
			INSERT INTO sys_dict_data VALUES (56, '000000', 9, 'æé', 'copy', 'wf_task_status', '', 'primary', 'N', 103, 1, sysdate(), NULL, NULL, 'æé');
			INSERT INTO sys_dict_data VALUES (57, '000000', 10, 'å ç¾', 'sign', 'wf_task_status', '', 'primary', 'N', 103, 1, sysdate(), NULL, NULL, 'å ç¾');
			INSERT INTO sys_dict_data VALUES (58, '000000', 11, 'åç¾', 'sign_off', 'wf_task_status', '', 'danger', 'N', 103, 1, sysdate(), NULL, NULL, 'åç¾');
			INSERT INTO sys_dict_data VALUES (59, '000000', 11, 'è¶æ¶', 'timeout', 'wf_task_status', '', 'danger', 'N', 103, 1, sysdate(), NULL, NULL, 'è¶æ¶');