Index: ssts-web/src/main/webapp/dataUpdater/sqls/5.0.6_5.0.7_sqlserver.sql =================================================================== diff -u -r35499 -r35524 --- ssts-web/src/main/webapp/dataUpdater/sqls/5.0.6_5.0.7_sqlserver.sql (.../5.0.6_5.0.7_sqlserver.sql) (revision 35499) +++ ssts-web/src/main/webapp/dataUpdater/sqls/5.0.6_5.0.7_sqlserver.sql (.../5.0.6_5.0.7_sqlserver.sql) (revision 35524) @@ -1,4 +1,5 @@ insert into Storage_TousseInstance (tousseInstanceId, storageLocationId) select tousseInstanceId, storageLocationId from StorageRecord where status = '存入' and not exists (select st.storageLocationId from Storage_TousseInstance st where st.storageLocationId = StorageRecord.storageLocationId); select tousseInstanceId, max(id) storageRecordId into MaxTousseInStorageLocationId from StorageRecord group by tousseInstanceId; update TousseInstance set lastStorageLocationId = (select sr.storageLocationId from MaxTousseInStorageLocationId mis join StorageRecord sr on sr.id = mis.storageRecordId where mis.tousseInstanceId = TousseInstance.id) where exists (select 1 from StorageRecord sr where sr.tousseInstanceId = TousseInstance.id) and lastStorageLocationId is null; -drop table MaxTousseInStorageLocationId; \ No newline at end of file +drop table MaxTousseInStorageLocationId; +update SupplyRoomConfig set loginUserDefaultOpRecipient = 0 where supplyRoomType = 0; \ No newline at end of file Index: ssts-web/src/main/webapp/dataUpdater/sqls/5.0.6_5.0.7_oracle.sql =================================================================== diff -u -r35499 -r35524 --- ssts-web/src/main/webapp/dataUpdater/sqls/5.0.6_5.0.7_oracle.sql (.../5.0.6_5.0.7_oracle.sql) (revision 35499) +++ ssts-web/src/main/webapp/dataUpdater/sqls/5.0.6_5.0.7_oracle.sql (.../5.0.6_5.0.7_oracle.sql) (revision 35524) @@ -4,4 +4,7 @@ execute immediate 'commit'; execute immediate 'update TousseInstance set lastStorageLocationId = (select sr.storageLocationId from MaxTousseInStorageLocationId mis join StorageRecord sr on sr.id = mis.storageRecordId where mis.tousseInstanceId = TousseInstance.id) where exists (select 1 from StorageRecord sr where sr.tousseInstanceId = TousseInstance.id) and lastStorageLocationId is null'; execute immediate 'commit'; -execute immediate 'drop table MaxTousseInStorageLocationId'; \ No newline at end of file +execute immediate 'drop table MaxTousseInStorageLocationId'; +execute immediate 'commit'; +execute immediate 'update SupplyRoomConfig set loginUserDefaultOpRecipient = 0 where supplyRoomType = 0'; +execute immediate 'commit'; \ No newline at end of file