]> git.evergreen-ils.org Git - working/Evergreen.git/commit
LP#838525 DoB as date SQL upgrade repairs
authorBill Erickson <berickxx@gmail.com>
Mon, 12 Oct 2015 15:12:07 +0000 (11:12 -0400)
committerJason Stephenson <jstephenson@mvlc.org>
Thu, 22 Oct 2015 19:17:59 +0000 (15:17 -0400)
commit01b02553359a0c8b2cbd2d8fabc06c6d626b2f08
tree10db84b48f503fe9bd877c3ac2c77ccdc9fd0200
parent08f8938c4e32855ee0e25f34e11fc140a40d5c38
LP#838525 DoB as date SQL upgrade repairs

1. Modify auditor.actor_usr_history DoB column in the same manner
   as actor.usr to ensure consistent date truncation.

2. let update_auditors() recreate auditor.actor_usr_lifecycle for us.

3. Wrap the whole shebang in a PLPGSQL "DO" block so we can easily test
for the presence of optional reporter views that depend on actor.usr, so
they can be recreated as needed.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Jason Stephenson <jstephenson@mvlc.org>
Open-ILS/src/sql/Pg/upgrade/0945.schema.dob-as-date.sql