kgraph_backgrand/sql/update20230426.sql

use kgraph;

DROP TABLE
IF
	EXISTS t_extract_result;
CREATE TABLE t_extract_result (
	id BIGINT ( 20 ) NOT NULL auto_increment COMMENT '编号',
	sub_task_id BIGINT ( 20 ) NOT NULL COMMENT '子任务id',
	sentence VARCHAR ( 512 ) COMMENT '分句结果',
	result VARCHAR ( 512 ) COMMENT '抽取结果路径',
	create_by VARCHAR ( 64 ) DEFAULT '' COMMENT '创建者',
	create_time datetime COMMENT '创建时间',
	update_by VARCHAR ( 64 ) DEFAULT '' COMMENT '更新者',
	update_time datetime COMMENT '更新时间',
PRIMARY KEY ( id )
) ENGINE = INNODB auto_increment = 1 COMMENT = '抽取结果信息';

INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2376, '离线数据分析', 2056, 3, 'offline/analysis', 'maintenance/offLineDataAnalysis/index', NULL, 1, 0, 'C', '0', '0', '', 'component', 'admin', '2023-04-24 03:02:19', 'admin', '2023-04-27 01:54:10', '');
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 (132, 0, 'resultPath', 'D:\\20230410\\server', 'kg_algorithm', NULL, 'default', 'N', '0', 'admin', '2023-04-27 02:51:02', 'admin', '2023-04-27 08:13:21', NULL);
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 (133, 0, 'questionUrl', 'questionUrl', 'kg_algorithm', NULL, 'default', 'N', '0', 'admin', '2023-04-27 12:02:36', '', NULL, 'http://localhost:9998/question');

commit;