projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 08f8938) | patch
LP#838525 DoB as date SQL upgrade repairs user/berick/lp838525-dob-as-date-sql-repairs
authorBill Erickson <berickxx@gmail.com>
Mon, 12 Oct 2015 15:12:07 +0000 (11:12 -0400)
committerBill Erickson <berickxx@gmail.com>
Tue, 13 Oct 2015 18:47:42 +0000 (14:47 -0400)
commit818a75fa2a7a931f533e4bc5d70bebaeafaf6c09
tree10db84b48f503fe9bd877c3ac2c77ccdc9fd0200tree
parent08f8938c4e32855ee0e25f34e11fc140a40d5c38commit | diff
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>
Open-ILS/src/sql/Pg/upgrade/0945.schema.dob-as-date.sql diff | blob | history
Evergreen ILS