Split old org unit setting type circ.hold_estimate_wait_interval into two:
authorscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 24 May 2010 18:52:02 +0000 (18:52 +0000)
committerscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 24 May 2010 18:52:02 +0000 (18:52 +0000)
commitd94a9edc38d8894bdc163936b4a824bfcfa2c0c7
tree1f2a6585d8fdda6adf47a2e637b98e1b3b009780
parent869188988a04598318e844ef9c96f1b911f5380d
Split old org unit setting type circ.hold_estimate_wait_interval into two:

circ.holds.default_estimated_wait_interval
circ.holds.min_estimated_wait_interval

...with corresponding tweaks to label and description.

Also: change datatype from 'integer' to 'interval'.

For any existing rows in actor.org_unit_setting, pointing to the old
setting type: update them to point to circ.holds.default_estimated_wait_interval.

(Due to a foreign key constraint, the latter update has to happen in the same
transaction as the rename of the old row.)

M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0274.data.org-setting-type-est-wait.sql
M    Open-ILS/src/sql/Pg/950.data.seed-values.sql

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16489 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/950.data.seed-values.sql
Open-ILS/src/sql/Pg/upgrade/0274.data.org-setting-type-est-wait.sql [new file with mode: 0644]