Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.48_4.9.49.sql =================================================================== diff -u -r28953 -r28955 --- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.48_4.9.49.sql (.../4.9.48_4.9.49.sql) (revision 28953) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.48_4.9.49.sql (.../4.9.48_4.9.49.sql) (revision 28955) @@ -1 +1 @@ -update DepartmentAppTemplate set maintenanceDepartId = (select id from OrgUnit where orgUnitCoding = (select po.orgUnitCoding from SupplyRoomConfig po where po.supplyRoomType = 1 and sequence = (select min(sequence) from SupplyRoomConfig where supplyRoomType = 1))) where maintenanceDepartId is null \ No newline at end of file +update DepartmentAppTemplate set maintenanceDepartId = (select id from OrgUnit where orgUnitCoding = (select po.orgUnitCoding from SupplyRoomConfig po where po.supplyRoomType = 1 and sequence = (select min(sequence) from SupplyRoomConfig where supplyRoomType = 1))) where maintenanceDepartId is null; \ No newline at end of file