Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.5.0_4.5.1_sqlserver.sql =================================================================== diff -u --- ssts-web/src/main/webapp/dataUpdater/sqls/4.5.0_4.5.1_sqlserver.sql (revision 0) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.5.0_4.5.1_sqlserver.sql (revision 16289) @@ -0,0 +1,2 @@ +update recyclingDamageItem set materialDefinitionId = (select min(m.id) from MaterialDefinition m +where (case when m.specification is null then m.name else (m.name + '[' + m.specification + ']') END) = recyclingDamageItem.materialName) where materialDefinitionId is null; Fisheye: Tag 16289 refers to a dead (removed) revision in file `ssts-web/src/main/webapp/dataUpdater/sqls/4.4.9_4.4.10.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: forgon-core/src/main/java/com/forgon/Constants.java =================================================================== diff -u -r16280 -r16289 --- forgon-core/src/main/java/com/forgon/Constants.java (.../Constants.java) (revision 16280) +++ forgon-core/src/main/java/com/forgon/Constants.java (.../Constants.java) (revision 16289) @@ -19,7 +19,7 @@ "3.3.0","3.3.8", "3.3.9", "3.3.10","3.3.12","3.3.13","3.8.0","3.9.0","3.9.1","3.9.2","4.0.2","4.0.3","4.0.4", "4.0.5","4.0.6","4.0.44","4.0.45","4.1.0","4.1.1","4.1.2","4.1.3","4.1.4","4.1.5","4.1.6","4.1.7","4.1.8","4.1.9","4.2.0","4.2.1","4.2.2", "4.2.3","4.2.4","4.2.5","4.2.6","4.2.7","4.2.8","4.2.9","4.3.0","4.3.1","4.3.2","4.3.3","4.3.4","4.3.5","4.3.6","4.3.7","4.3.8","4.3.9", - "4.4.0","4.4.1","4.4.2","4.4.3","4.4.4","4.4.5","4.4.6","4.4.7","4.4.8","4.4.9","4.4.10"};// 版本列表 + "4.4.0","4.4.1","4.4.2","4.4.3","4.4.4","4.4.5","4.4.6","4.4.7","4.4.8","4.4.9","4.5.0","4.5.1"};// 版本列表 public final static List SOFTWARE_VERSION_LIST = Arrays .asList(SOFTWARE_VERSION_ARRAY); public final static String SOFTWARE_VERSION = SOFTWARE_VERSION_ARRAY[SOFTWARE_VERSION_ARRAY.length - 1];// 软件最新版本 Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.5.0_4.5.1_oracle.sql =================================================================== diff -u --- ssts-web/src/main/webapp/dataUpdater/sqls/4.5.0_4.5.1_oracle.sql (revision 0) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.5.0_4.5.1_oracle.sql (revision 16289) @@ -0,0 +1,2 @@ +update recyclingDamageItem set materialDefinitionId = (select min(m.id) from MaterialDefinition m +where (case when m.specification is null then m.name else (m.name||'['||m.specification||']') END) = recyclingDamageItem.materialName) where materialDefinitionId is null; \ No newline at end of file