Fix sorting by pubdate for records migrated to 2.1 user/dbs/fix_pubdate_sort_migrated_recs
authorDan Scott <dscott@laurentian.ca>
Sun, 22 Jan 2012 19:29:16 +0000 (14:29 -0500)
committerDan Scott <dscott@laurentian.ca>
Sun, 22 Jan 2012 19:33:54 +0000 (14:33 -0500)
commite43bae87b1aacf771a2a3f7366c4b66b574966d1
tree882f5a7d936dbead7e7a160fbc4073539235908e
parent56fa348c351da2e4d1a9af9903c91a4b7ab8f33b
Fix sorting by pubdate for records migrated to 2.1

The 'pubdate' attribute is necessary for sorting by publication date to
work correctly. It was not populated in the 2.0-2.1 upgrade script, so
populate it now based on the 'date1' attribute.

Signed-off-by: Dan Scott <dscott@laurentian.ca>
Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql
Open-ILS/src/sql/Pg/version-upgrade/2.1.1-2.1.2-upgrade-db.sql [new file with mode: 0644]