LP#1663663: seed data upgrade script
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / XXXX.data.fix_full_overlay_vmp.sql
1 BEGIN;
2
3 -- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
4 UPDATE vandelay.merge_profile
5 SET preserve_spec = '901c',
6     replace_spec = NULL
7 WHERE id = 2
8 AND   name = oils_i18n_gettext(2, 'Full Overlay', 'vmp', 'name')
9 AND   preserve_spec IS NULL
10 AND   add_spec IS NULL
11 AND   strip_spec IS NULL
12 AND   replace_spec = '901c';
13
14 COMMIT;