Bug #1006466 - action.hold_request.hold_type needs constraint - 2.4.0 (master)
authorKyle Tomita <ktomita@catalystitservices.com>
Fri, 1 Feb 2013 16:56:23 +0000 (08:56 -0800)
committerKyle Tomita <ktomita@catalystitservices.com>
Fri, 1 Feb 2013 16:56:23 +0000 (08:56 -0800)
commit62d6cdafd72c7a983f92567b05a561453505cf19
treead037c8b57e93f455cac24e300331642dacdf4af
parentfbded261a9e82a9135e9e346ceee6cfa3c6e087a
Bug #1006466 - action.hold_request.hold_type needs constraint - 2.4.0 (master)

Script XXXX.action.hold_request.hold_type-foreign-key-constraint.sql
adds the config.hold_type table to use as the constaint and adds the
foreign key relationship to ahr.

The script also includes code to remove the table and constraint.
Along with code to capitalize hold_type's in ahr and a command to
give the hold_types in ahr that are not in config.hold_type.

Signed-off-by: Kyle Tomita <ktomita@catalystitservices.com>
Open-ILS/src/sql/Pg/upgrade/XXXX.action.hold_request.hold_type-foreign-key-constraint.sql [new file with mode: 0644]