3 SELECT evergreen.upgrade_deps_block_check('1203', :eg_version);
5 ALTER TABLE config.best_hold_order ADD COLUMN owning_lib_to_home_lib_prox INT; -- copy owning lib <-> user home lib prox
7 ALTER table config.best_hold_order DROP CONSTRAINT best_hold_order_check;
9 -- At least one of these columns must contain a non-null value
10 ALTER TABLE config.best_hold_order ADD CHECK ((
13 owning_lib_to_home_lib_prox IS NOT NULL OR
15 priority IS NOT NULL OR
22 INSERT INTO config.best_hold_order (
24 owning_lib_to_home_lib_prox, hprox, approx, pprox, aprox, priority, cut, depth, rtime
26 'Traditional with Holds-chase-home-lib-patrons',
27 1, 2, 3, 4, 5, 6, 7, 8, 9