Adding 0842, 0843 to help with 0841 deficiencies
authorDan Wells <dbw2@calvin.edu>
Thu, 10 Oct 2013 19:54:40 +0000 (15:54 -0400)
committerDan Wells <dbw2@calvin.edu>
Thu, 10 Oct 2013 20:41:13 +0000 (16:41 -0400)
commitd4b34797cc94fbe2acf54ccaea4ed481ee861f13
treeaa07d80d7ba3b4bf9948156b64f0659f762261c3
parent6530fb4806670765a61dbbdf1d0b5f9040c264c5
Adding 0842, 0843 to help with 0841 deficiencies

A clean backport of 0841 was not possible due to partial schema
differences in the upgrade.  While we may have planned ahead better,
add 0842 just for 2_3 upgraders which ends up being a no-op for
2_4, and adds ON UPDATE CASCADE for 2_5.

Also, for similar but additional reasons, add 0843, which serves two
purposes:
  1) add ON UPDATE CASCADE to the rest for those upgrading 2_5/master
  2) alter config.z3950_index_field_map for those upgrading from 2_4
     and previous (other lines are no-ops in this case)

Signed-off-by: Dan Wells <dbw2@calvin.edu>
Signed-off-by: Remington Steed <rjs7@calvin.edu>
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/030.schema.metabib.sql
Open-ILS/src/sql/Pg/upgrade/0842.schema.redo_config_metabib_field_sequence_2_3_to_2_4.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/0843.schema.redo_config_metabib_field_sequence_2_5.sql [new file with mode: 0644]