]> git.evergreen-ils.org Git - working/Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.workstation-settings.UNDO.sql
LP#1750894 Cascade settings batch retrieve func
[working/Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / ZZZZ.schema.workstation-settings.UNDO.sql
1 BEGIN;
2
3 DROP FUNCTION actor.get_setting(TEXT, INT, INT, INT);
4 DROP FUNCTION actor.get_setting_batch(TEXT[], INT, INT, INT);
5
6 DROP TRIGGER IF EXISTS check_setting_is_usr_or_ws ON actor.workstation_setting;
7 DROP TRIGGER IF EXISTS check_setting_is_usr_or_ws ON actor.usr_setting;
8 DROP FUNCTION IF EXISTS config.setting_is_user_or_ws();
9 DROP TABLE actor.workstation_setting;
10 DROP TABLE config.workstation_setting_type;
11
12 COMMIT;
13
14
15