Returns: void
Language: PLPGSQL
BEGIN IF EXISTS( SELECT proname FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_proc p ON pronamespace = n.oid WHERE nspname = 'public' AND proname='lo_manage' ) THEN CREATE TRIGGER T_ICONS_SMALL_ICON BEFORE UPDATE OR DELETE ON ICONS FOR EACH ROW EXECUTE PROCEDURE lo_manage(SMALL_ICON); CREATE TRIGGER T_ICONS_LARGE_ICON BEFORE UPDATE OR DELETE ON ICONS FOR EACH ROW EXECUTE PROCEDURE lo_manage(LARGE_ICON); CREATE TRIGGER T_CONTENT_TYPES_SMALL_ICON BEFORE UPDATE OR DELETE ON CONTENT_TYPES FOR EACH ROW EXECUTE PROCEDURE lo_manage(SMALL_ICON); CREATE TRIGGER T_CONTENT_TYPES_LARGE_ICON BEFORE UPDATE OR DELETE ON CONTENT_TYPES FOR EACH ROW EXECUTE PROCEDURE lo_manage(LARGE_ICON); CREATE TRIGGER T_USERS_IMAGE BEFORE UPDATE OR DELETE ON USERS FOR EACH ROW EXECUTE PROCEDURE lo_manage(IMAGE); CREATE TRIGGER T_ITEMS_BINARY_DATA BEFORE UPDATE OR DELETE ON ITEMS FOR EACH ROW EXECUTE PROCEDURE lo_manage(BINARY_DATA); CREATE TRIGGER T_SYSTEM_SETTINGS_BINARY_DATA BEFORE UPDATE OR DELETE ON SYSTEM_SETTINGS FOR EACH ROW EXECUTE PROCEDURE lo_manage(BINARY_DATA); CREATE TRIGGER T_APP_CALENDAR_EVENT_TYPES_ICON BEFORE UPDATE OR DELETE ON APP_CALENDAR_EVENT_TYPES FOR EACH ROW EXECUTE PROCEDURE lo_manage(ICON); CREATE TRIGGER T_APP_FM_BINARY_FIELD_VALUES_BINARY_DATA BEFORE UPDATE OR DELETE ON APP_FM_BINARY_FIELD_VALUES FOR EACH ROW EXECUTE PROCEDURE lo_manage(BINARY_DATA); CREATE TRIGGER T_APP_CALENDAR_LOCATIONS_IMAGE BEFORE UPDATE OR DELETE ON APP_CALENDAR_LOCATIONS FOR EACH ROW EXECUTE PROCEDURE lo_manage(IMAGE); END IF;END;
