NWPU-IPS/sql/ips_update20250701.sql

drop table if exists biz_attribute_identificationt;
create table biz_attribute_identificationt (
  id           bigint(20)      not null auto_increment    comment '编号',
  task_name         varchar(50)      default ''                comment '任务名称',
  algorithm_id      bigint(20)                                 comment '算法',
  model_path        varchar(255)     default ''                comment '模型pth',
  model_pkl_path        varchar(255)     default ''            comment '模型pkl',
  input_path        varchar(255)     default ''                comment '输入路径',
  output_path       varchar(255)     default ''                comment '输出路径',
  algorithm_params  text                                       comment '算法参数',
  status            char(1)          default '0'               comment '状态（0未运行，1运行中，2已完成，3失败）',
  start_time        datetime                                   comment '开始时间',
  end_time          datetime                                   comment '结束时间',
  remark            varchar(255)          default ''           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 comment = '属性识别表';

-- 菜单 SQL
insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('属性识别', '2008', '6', 'identificationt', 'biz/identificationt/index', 1, 0, 'C', '0', '0', 'biz:identificationt:list', 'clipboard', 'admin', sysdate(), '', null, '属性识别菜单');

-- 按钮父菜单ID
SELECT @parentId := LAST_INSERT_ID();

-- 按钮 SQL
insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('属性识别查询', @parentId, '1',  '#', '', 1, 0, 'F', '0', '0', 'biz:identificationt:query',        '#', 'admin', sysdate(), '', null, '');

insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('属性识别新增', @parentId, '2',  '#', '', 1, 0, 'F', '0', '0', 'biz:identificationt:add',          '#', 'admin', sysdate(), '', null, '');

insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('属性识别修改', @parentId, '3',  '#', '', 1, 0, 'F', '0', '0', 'biz:identificationt:edit',         '#', 'admin', sysdate(), '', null, '');

insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('属性识别删除', @parentId, '4',  '#', '', 1, 0, 'F', '0', '0', 'biz:identificationt:remove',       '#', 'admin', sysdate(), '', null, '');

insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('属性识别导出', @parentId, '5',  '#', '', 1, 0, 'F', '0', '0', 'biz:identificationt:export',       '#', 'admin', sysdate(), '', null, '');