LP#1835085: stamp DB update
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 1190.data.auto_renewal-not-desk_renewal.sql
1 BEGIN;
2
3 SELECT evergreen.upgrade_deps_block_check('1190', :eg_version);
4
5 UPDATE action.circulation SET desk_renewal = FALSE WHERE auto_renewal IS TRUE;
6
7 UPDATE action.aged_circulation SET desk_renewal = FALSE WHERE auto_renewal IS TRUE;
8
9 COMMIT;