]> git.evergreen-ils.org Git - Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/0083.schema.action_trigger.event_definition.opt_in.sql
LP#1842940: Improve Alert
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 0083.schema.action_trigger.event_definition.opt_in.sql
1 BEGIN;
2
3 INSERT INTO config.upgrade_log (version) VALUES ('0083');
4
5 ALTER TABLE action_trigger.event_definition ADD COLUMN usr_field TEXT;
6 ALTER TABLE action_trigger.event_definition ADD COLUMN opt_in_setting TEXT REFERENCES config.usr_setting_type (name) DEFERRABLE INITIALLY DEFERRED;
7
8 COMMIT;
9