Index: ssts-web/src/main/webapp/dataUpdater/sqls/5.0.49_5.0.50.sql =================================================================== diff -u -r40852 -r40870 --- ssts-web/src/main/webapp/dataUpdater/sqls/5.0.49_5.0.50.sql (.../5.0.49_5.0.50.sql) (revision 40852) +++ ssts-web/src/main/webapp/dataUpdater/sqls/5.0.49_5.0.50.sql (.../5.0.49_5.0.50.sql) (revision 40870) @@ -1,2 +1,2 @@ update InstrumentInstance set repairStatus = '使用中' where idCardInstanceId is not null and lastInstrumentRepairId is null and repairStatus = '待使用'; -update TousseMaintain set tousseDefinitionId = (select icd.tousseDefinitionID from IDCardInstance ici join IDCardDefinition icd on icd.id = ici.idCardDefinitionID where ici.id = TousseMaintain.idCardInstanceID) where idCardInstanceID is not null; \ No newline at end of file +update TousseMaintain set tousseDefinitionId = (select icd.tousseDefinitionID from IDCardInstance ici join IDCardDefinition icd on icd.id = ici.idCardDefinitionID where ici.id = TousseMaintain.idCardInstanceID) where idCardInstanceID is not null and tousseDefinitionId is null; \ No newline at end of file