Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.77_4.9.78.sql =================================================================== diff -u -r31523 -r31637 --- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.77_4.9.78.sql (.../4.9.77_4.9.78.sql) (revision 31523) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.77_4.9.78.sql (.../4.9.77_4.9.78.sql) (revision 31637) @@ -1 +1,2 @@ -update TousseDefinition set isSterile='是' where isSterile is null or isSterile=''; \ No newline at end of file +update TousseDefinition set isSterile='是' where (isSterile is null or isSterile='') and tousseType<>'消毒物品'; +update TousseDefinition set isSterile='否' where (isSterile is null or isSterile='') and tousseType='消毒物品'; \ No newline at end of file