22 lines
1.8 KiB
MySQL
22 lines
1.8 KiB
MySQL
|
-- ----------------------------- 2024-09-02 add by zhangs------------begin
|
||
|
|
INSERT INTO t_core_email_config (ID,TEMPLATEID,CONFIGNAME,REMARK,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME) VALUES
|
||
|
|
('TASK_CANCEL_TIP_TEMPLATE','TASK_CANCEL_TIP_TEMPLATE','试验取消提醒',NULL,NULL,'zhangs','张胜','2024-06-17 16:17:55','RT','湖北融通高科先进材料股份有限公司',NULL,NULL,NULL,'0',NULL,NULL,NULL);
|
||
|
|
|
||
|
|
INSERT INTO t_core_email_template (ID,TEMPLATENAME,REMARK,EMAILSUBJECT,EMAILBODY,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME) VALUES
|
||
|
|
('TASK_CANCEL_TIP_TEMPLATE','试验取消提醒','试验取消提醒','试验取消提醒',' 委托单:[{folderno}]下的试验:[{testname}]已取消，取消原因：[{reason}]。',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
|
||
|
|
-- ----------------------------- 2024-09-02 add by zhangs------------end
|
||
|
|
|
||
|
|
|
||
|
|
-- ----------------------------- 2024-09-18 add by zhangs------------begin
|
||
|
|
ALTER TABLE t_lims_task ADD RESULTTOMOMTIME datetime NULL COMMENT '推送结果数据到MOM时间';
|
||
|
|
-- ----------------------------- 2024-09-18 add by zhangs------------end
|
||
|
|
|
||
|
|
-- ----------------------------- 2024-09-20 add by zhangs------------begin
|
||
|
|
INSERT INTO t_core_admin_choose_config (ID,NAME,TITLE,CATEGORY,URL,WIDTH) VALUES
|
||
|
|
(2024092016121,'批次选择','批次选择','sendSampleBatchNoChoose','/secure/basemodule/business/test/orders/page//choose-sendSampleBatchNo-list','80%');
|
||
|
|
CREATE INDEX t_lims_test_matrix_ORDTASKID_IDX USING BTREE ON t_lims_test_matrix (ORDTASKID);
|
||
|
|
-- ----------------------------- 2024-09-20 add by zhangs------------end
|
||
|
|
|
||
|
|
|
||
|
|
|