LP#1410369: Schema and supporting IDL entries
authorMike Rylander <mrylander@gmail.com>
Mon, 16 Feb 2015 17:54:40 +0000 (12:54 -0500)
committerGalen Charlton <gmc@esilibrary.com>
Wed, 18 Feb 2015 21:51:05 +0000 (21:51 +0000)
commite2aef7eadd237810708d5c4dadad66b1009a5067
treedae533cce917c21616b4cf2a8b68b50c18efdf2f
parent9238334caad810f09e53466e65a634a58e332931
LP#1410369: Schema and supporting IDL entries

This commit adds the table actor.usr_message,
a trigger to populate actor.usr_message as rows
get adding to actor.usr_note (or get updated to make
non-public notes become public), and new columns in
action.event_definition for specifying how to generate
user messages from A/T events.

It also copies over existing public user notes as
new, "read" user messages, as the current display
of the old user notes will be removed from TPac.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Open-ILS/examples/fm_IDL.xml
Open-ILS/src/sql/Pg/005.schema.actors.sql
Open-ILS/src/sql/Pg/400.schema.action_trigger.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.message-center.sql [new file with mode: 0644]