Index: ssts-web/src/main/webapp/dataUpdater/sqls/5.0.52_5.0.53.sql =================================================================== diff -u -r41415 -r41430 --- ssts-web/src/main/webapp/dataUpdater/sqls/5.0.52_5.0.53.sql (.../5.0.52_5.0.53.sql) (revision 41415) +++ ssts-web/src/main/webapp/dataUpdater/sqls/5.0.52_5.0.53.sql (.../5.0.52_5.0.53.sql) (revision 41430) @@ -1 +1 @@ -update DepartmentAppTemplate set orderNum = (select count(*) from DepartmentAppTemplate po where po.id <= DepartmentAppTemplate.id); \ No newline at end of file +update DepartmentAppTemplate set orderNum = (select count(*) from DepartmentAppTemplate po where po.id <= DepartmentAppTemplate.id) where orderNum is null; \ No newline at end of file