update20230426.sql 1.8 KB

12345678910111213141516171819202122
  1. use kgraph;
  2. DROP TABLE
  3. IF
  4. EXISTS t_extract_result;
  5. CREATE TABLE t_extract_result (
  6. id BIGINT ( 20 ) NOT NULL auto_increment COMMENT '编号',
  7. sub_task_id BIGINT ( 20 ) NOT NULL COMMENT '子任务id',
  8. sentence VARCHAR ( 512 ) COMMENT '分句结果',
  9. result VARCHAR ( 512 ) COMMENT '抽取结果路径',
  10. create_by VARCHAR ( 64 ) DEFAULT '' COMMENT '创建者',
  11. create_time datetime COMMENT '创建时间',
  12. update_by VARCHAR ( 64 ) DEFAULT '' COMMENT '更新者',
  13. update_time datetime COMMENT '更新时间',
  14. PRIMARY KEY ( id )
  15. ) ENGINE = INNODB auto_increment = 1 COMMENT = '抽取结果信息';
  16. 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', '');
  17. 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);
  18. 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');
  19. commit;