lbqms.git - Gitblit

¶Ô±ÈÐÂÎÄ¼þ
			@@ -0,0 +1,175 @@
			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('11617', 'æ¨¡åç®¡ç', '11616', '2', 'model', 'workflow/model/index', '', '1', '1', 'C', '0', '0', 'workflow:model:list', 'model', 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, '');
			-- è¯·ååä¿¡æ¯
			create table test_leave
			(
			id bigint not null 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 'è¯·ååå ',
			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 'æ´æ°æ¶é´',
			tenant_id varchar(20) null comment 'ç§æ·ç¼å·',
			PRIMARY KEY (id) USING BTREE
			) ENGINE = InnoDB COMMENT = 'è¯·åç³è¯·è¡¨';

			-- æµç¨åç±»ä¿¡æ¯è¡¨
			create table wf_category
			(
			id bigint not null comment 'ä¸»é®'
			primary key,
			category_name varchar(255) null comment 'åç±»åç§°',
			category_code varchar(255) null comment 'åç±»ç¼ç ',
			parent_id bigint null comment 'ç¶çº§id',
			sort_num int(19) null comment 'æåº',
			tenant_id varchar(20) 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 'æ´æ°æ¶é´',
			constraint uni_category_code
			unique (category_code)
			) engine=innodb comment= 'æµç¨åç±»';
			INSERT INTO wf_category values (1, 'OA', 'OA', 0, 0, '000000', 103, 1, sysdate(), 1, sysdate());

			create table wf_task_back_node
			(
			id bigint not null
			primary key,
			node_id varchar(255) not null comment 'èç¹id',
			node_name varchar(255) not null comment 'èç¹åç§°',
			order_no int not null comment 'æåº',
			instance_id varchar(255) null comment 'æµç¨å®ä¾id',
			task_type varchar(255) not null comment 'èç¹ç±»å',
			assignee varchar(2000) not null comment 'å®¡æ¹äºº',
			tenant_id varchar(20) 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 'æ´æ°æ¶é´'
			)
			comment 'èç¹å®¡æ¹è®°å½';

			create table wf_definition_config
			(
			id bigint not null comment 'ä¸»é®'
			primary key,
			table_name varchar(255) not null comment 'è¡¨å',
			definition_id varchar(255) not null comment 'æµç¨å®ä¹ID',
			process_key varchar(255) not null comment 'æµç¨KEY',
			version int(10) not 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 'æ´æ°æ¶é´',
			remark varchar(500) default '' null comment 'å¤æ³¨',
			tenant_id varchar(20) null comment 'ç§æ·ç¼å·',
			constraint uni_definition_id
			unique (definition_id)
			)
			comment 'æµç¨å®ä¹éç½®';

			create table wf_form_manage
			(
			id bigint not null comment 'ä¸»é®'
			primary key,
			form_name varchar(255) not null comment 'è¡¨ååç§°',
			form_type varchar(255) not null comment 'è¡¨åç±»å',
			router varchar(255) not null comment 'è·¯ç±å°å/è¡¨åID',
			remark varchar(500) null comment 'å¤æ³¨',
			tenant_id varchar(20) 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 'æ´æ°æ¶é´'
			)
			comment 'è¡¨åç®¡ç';

			insert into wf_form_manage(id, form_name, form_type, router, remark, tenant_id, create_dept, create_by, create_time, update_by, update_time) VALUES (1, 'è¯·åç³è¯·', 'static', '/demo/leaveEdit/index', NULL, '000000', 103, 1, sysdate(), 1, sysdate());

			create table wf_node_config
			(
			id bigint not null comment 'ä¸»é®'
			primary key,
			form_id bigint null comment 'è¡¨åid',
			form_type varchar(255) null comment 'è¡¨åç±»å',
			node_name varchar(255) not null comment 'èç¹åç§°',
			node_id varchar(255) not null comment 'èç¹id',
			definition_id varchar(255) not null comment 'æµç¨å®ä¹id',
			apply_user_task char(1) default '0' comment 'æ¯å¦ä¸ºç³è¯·äººèç¹ ï¼0æ¯ 1å¦ï¼',
			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 'æ´æ°æ¶é´',
			tenant_id varchar(20) null comment 'ç§æ·ç¼å·'
			)
			comment 'èç¹éç½®';


			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, 'è¯·åç³è¯·èå');
			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, '');
			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, '');
			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, '');
			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, '');
			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, '');

			INSERT INTO sys_dict_type(dict_id, tenant_id, dict_name, dict_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (13, '000000', 'ä¸å¡ç¶æ', 'wf_business_status', 103, 1, sysdate(), NULL, NULL, 'ä¸å¡ç¶æåè¡¨');
			INSERT INTO sys_dict_type(dict_id, tenant_id, dict_name, dict_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (14, '000000', 'è¡¨åç±»å', 'wf_form_type', 103, 1, sysdate(), NULL, NULL, 'è¡¨åç±»ååè¡¨');

			INSERT INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (39, '000000', 1, 'å·²æ¤é', 'cancel', 'wf_business_status', '', 'danger', 'N', 103, 1, sysdate(), NULL, NULL, 'å·²æ¤é');
			INSERT INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (40, '000000', 2, 'èç¨¿', 'draft', 'wf_business_status', '', 'info', 'N', 103, 1, sysdate(), NULL, NULL, 'èç¨¿');
			INSERT INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (41, '000000', 3, 'å¾å®¡æ ¸', 'waiting', 'wf_business_status', '', 'primary', 'N', 103, 1,sysdate(), NULL, NULL, 'å¾å®¡æ ¸');
			INSERT INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (42, '000000', 4, 'å·²å®æ', 'finish', 'wf_business_status', '', 'success', 'N', 103, 1, sysdate(), NULL, NULL, 'å·²å®æ');
			INSERT INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (43, '000000', 5, 'å·²ä½åº', 'invalid', 'wf_business_status', '', 'danger', 'N', 103, 1, sysdate(), NULL, NULL, 'å·²ä½åº');
			INSERT INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (44, '000000', 6, 'å·²éå', 'back', 'wf_business_status', '', 'danger', 'N', 103, 1, sysdate(), NULL, NULL, 'å·²éå');
			INSERT INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (45, '000000', 7, 'å·²ç»æ¢', 'termination', 'wf_business_status', '', 'danger', 'N', 103, 1,sysdate(), NULL, NULL, 'å·²ç»æ¢');
			INSERT INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (46, '000000', 1, 'èªå®ä¹è¡¨å', 'static', 'wf_form_type', '', 'success', 'N', 103, 1, sysdate(), NULL, NULL, 'èªå®ä¹è¡¨å');
			INSERT INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (47, '000000', 2, 'å¨æè¡¨å', 'dynamic', 'wf_form_type', '', 'primary', 'N', 103, 1, sysdate(), NULL, NULL, 'å¨æè¡¨å');

			-- è¡¨åç®¡ç SQL
			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(11628, 'è¡¨åç®¡ç', '11616', '5', 'formManage', 'workflow/formManage/index', 1, 0, 'C', '0', '0', 'workflow:formManage:list', 'tree-table', 103, 1, sysdate(), null, null, 'è¡¨åç®¡çèå');

			-- è¡¨åç®¡çæé® SQL
			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(11644, 'è¡¨åç®¡çæ¥è¯¢', 11628, '1', '#', '', 1, 0, 'F', '0', '0', 'workflow:formManage:query', '', 103, 1, sysdate(), null, null, '');

			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(11645, 'è¡¨åç®¡çæ°å¢', 11628, '2', '#', '', 1, 0, 'F', '0', '0', 'workflow:formManage:add', '', 103, 1, sysdate(), null, null, '');

			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(11646, 'è¡¨åç®¡çä¿®æ¹', 11628, '3', '#', '', 1, 0, 'F', '0', '0', 'workflow:formManage:edit', '', 103, 1, sysdate(), null, null, '');

			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(11647, 'è¡¨åç®¡çå é¤', 11628, '4', '#', '', 1, 0, 'F', '0', '0', 'workflow:formManage:remove', '', 103, 1, sysdate(), null, null, '');

			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(11648, 'è¡¨åç®¡çå¯¼åº', 11628, '5', '#', '', 1, 0, 'F', '0', '0', 'workflow:formManage:export', 'tree-table', 103, 1, sysdate(), null, null, '');