Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.78_4.9.79.sql =================================================================== diff -u -r36731 -r36736 --- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.78_4.9.79.sql (.../4.9.78_4.9.79.sql) (revision 36731) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.78_4.9.79.sql (.../4.9.78_4.9.79.sql) (revision 36736) @@ -1 +1 @@ -insert into SS_ROLE_OPERATION(ROLE_ID, OPERATION_ID) select id, (select max(id) from SS_OPERATION where operationId = 'SSTS_UpdateAppDepartAndSettleAccountsDepart') from SS_ROLES where name <> 'ROLE_ADMINISTRATOR_0'; \ No newline at end of file +insert into SS_ROLE_OPERATION(ROLE_ID, OPERATION_ID) select id, (select max(id) from SS_OPERATION where operationId = 'SSTS_UpdateAppDepartAndSettleAccountsDepart') from SS_ROLES where exists (select id from SS_OPERATION where operationId='SSTS_UpdateAppDepartAndSettleAccountsDepart') and id not in (select ROLE_ID from SS_ROLE_OPERATION where OPERATION_ID = (select max(id) from SS_OPERATION where operationId = 'SSTS_UpdateAppDepartAndSettleAccountsDepart')); \ No newline at end of file Index: ssts-web/src/main/webapp/dataUpdater/sqls/5.0.14_5.0.15.sql =================================================================== diff -u -r36731 -r36736 --- ssts-web/src/main/webapp/dataUpdater/sqls/5.0.14_5.0.15.sql (.../5.0.14_5.0.15.sql) (revision 36731) +++ ssts-web/src/main/webapp/dataUpdater/sqls/5.0.14_5.0.15.sql (.../5.0.14_5.0.15.sql) (revision 36736) @@ -1 +1 @@ -insert into SS_ROLE_OPERATION(ROLE_ID, OPERATION_ID) select id, (select max(id) from SS_OPERATION where operationId = 'SSTS_borrow_returnTousse') from SS_ROLES where name <> 'ROLE_ADMINISTRATOR_0'; \ No newline at end of file +insert into SS_ROLE_OPERATION(ROLE_ID, OPERATION_ID) select id, (select max(id) from SS_OPERATION where operationId = 'SSTS_borrow_returnTousse') from SS_ROLES where exists (select id from SS_OPERATION where operationId='SSTS_borrow_returnTousse') and id not in (select ROLE_ID from SS_ROLE_OPERATION where OPERATION_ID = (select max(id) from SS_OPERATION where operationId = 'SSTS_borrow_returnTousse')); \ No newline at end of file