Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.71_4.9.72.sql =================================================================== diff -u -r30937 -r30982 --- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.71_4.9.72.sql (.../4.9.71_4.9.72.sql) (revision 30937) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.71_4.9.72.sql (.../4.9.71_4.9.72.sql) (revision 30982) @@ -1 +1,2 @@ -update Container set departCode = (select handlerDepartCode from TousseDefinition td where td.id = (select tousseDefinitionID from IDCardDefinition where id = Container.idCardDefinitionId)), departName = (select handlerDepartName from TousseDefinition td where td.id = (select tousseDefinitionID from IDCardDefinition where id = Container.idCardDefinitionId)) where idCardDefinitionId is not null; \ No newline at end of file +update Container set departCode = (select handlerDepartCode from TousseDefinition td where td.id = (select tousseDefinitionID from IDCardDefinition where id = Container.idCardDefinitionId)) where idCardDefinitionId is not null and departCode <> (select handlerDepartCode from TousseDefinition td where td.id = (select tousseDefinitionID from IDCardDefinition where id = Container.idCardDefinitionId)); +update Container set departName = (select handlerDepartName from TousseDefinition td where td.id = (select tousseDefinitionID from IDCardDefinition where id = Container.idCardDefinitionId)) where idCardDefinitionId is not null and departName <> (select handlerDepartName from TousseDefinition td where td.id = (select tousseDefinitionID from IDCardDefinition where id = Container.idCardDefinitionId)); \ No newline at end of file