-- ----------------------------- 2024-04-08 add by zhangs------------begin
ALTER TABLE t_lims_equipt ADD EQUIPTCODELANDIAN varchar(100) NULL COMMENT '蓝电设备编号';
CALL INSERTI18N('T_LIMS_EQUIPT.EQUIPTCODELANDIAN', '蓝电设备编号', '蓝电设备编号', 'zh-CN', '蓝电设备编号');
-- ----------------------------- 2024-04-08 add by zhangs------------end

-- ----------------------------- 2024-04-11 add by zhangs------------begin
ALTER TABLE t_lims_task ADD CREATEBYHANGUP varchar(1) NULL COMMENT '由挂测生成的试验';
update t_lims_task set CREATEBYHANGUP=0;

INSERT INTO t_core_schedule_task (ID,TASKNAME,SERVICENAME,METHODNAME,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME,`TYPE`,IFEXECUTABLESERVICENAME,IFEXECUTABLEMETHODNAME) VALUES
('scheduleAcqLanDianResult','蓝电数据定时获取','com.sunwayworld.basemodule.business.test.task.landian.service.LimsLandianresultService','scheduleAcqLanDianResult',NULL,NULL,NULL,NULL,NULL,NULL,'service',NULL,NULL);

INSERT INTO t_core_schedule_task_config (ID,CONFIGNAME,TASKID,PARAM,CRON,TIMES,REMARK,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME,ACTIVATEDFLAG,ACTIVATEDBYID,ACTIVATEDBYNAME,ACTIVATEDTIME,UID,STARTTIME,ENDTIME) VALUES
('20240400001',NULL,'scheduleAcqLanDianResult',NULL,'0 0/2 * * * ?',0,NULL,NULL,'zhangs','张胜','2024-04-11 17:33:44','RT','湖北融通高科先进材料股份有限公司','0',NULL,NULL,NULL,'20240400001',NULL,NULL);
ALTER TABLE t_lims_order ADD LANDIANACQSTATUS varchar(30) NULL COMMENT '蓝电数据采集状态';

INSERT INTO t_core_menu (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES
('20240408001','结果录入(扣电室)','/secure/basemodule/business/test/folders/page/edit-list?pageType=resultInputKouDian','1001',8,'结果录入(扣电室)',NULL,NULL,NULL,'026.svg','029.png',NULL);
-- ----------------------------- 2024-04-11 add by zhangs------------end

-- ----------------------------- 2024-04-12 add by zhangs------------begin
-- T_LIMS_TM_ANALYST highLimit lowLimit
-- T_LIMS_SPECIMEN_ITEM shorUpper shorLower meanValue pValue cov
-- T_LIMS_TASK highLimit lowLimit meanValue pValue cov calMean calPValue calCov
-- T_LIMS_MATERIAL_METHOD highLimit  lowLimit
ALTER TABLE t_lims_tm_analyst MODIFY COLUMN HIGHLIMIT varchar(36) NULL COMMENT '检出高限';
ALTER TABLE t_lims_tm_analyst MODIFY COLUMN LOWLIMIT varchar(36) NULL COMMENT '检出低限';
ALTER TABLE t_lims_task MODIFY COLUMN HIGHLIMIT varchar(36) NULL;
ALTER TABLE t_lims_task MODIFY COLUMN LOWLIMIT varchar(36) NULL;
ALTER TABLE t_lims_material_method MODIFY COLUMN LOWLIMIT varchar(36) NULL;
ALTER TABLE t_lims_material_method MODIFY COLUMN HIGHLIMIT varchar(36) NULL;
ALTER TABLE t_lims_specimen ADD REMARK varchar(520) NULL COMMENT '备注';
-- ----------------------------- 2024-04-12 add by zhangs------------end
-- ----------------------------- 2024-04-24 add by gaozq------------begin
create index t_lims_order_batchnoindex
    on lims_lhxny_dev.t_lims_order (SENDSAMPLEBATCHNO);
-- ----------------------------- 2024-04-24 add by gaozq------------end

-- ----------------------------- 2024-04-24 add by zhangs------------begin
update t_core_menu set MENUNAME='扣电数据审核',MENUINITNAME='扣电数据审核' where id=20240408001;
-- ----------------------------- 2024-04-24 add by zhangs------------end

-- ----------------------------- 2024-04-25 add by zhangs------------begin
ALTER TABLE t_lims_landianresult ADD CHANNELNO varchar(100) NULL COMMENT '通道号';
ALTER TABLE t_lims_landianresult ADD TESTID bigint NULL COMMENT '测试ID';
CALL INSERTI18N('T_LIMS_LANDIANRESULT.CHANNELNO', '通道编号', '通道编号', 'zh-CN', '通道编号');
-- ----------------------------- 2024-04-25 add by zhangs------------end