-- Could not auto-generate a down migration.
-- Please write an appropriate down migration for the SQL below:
-- CREATE OR REPLACE FUNCTION public.increment_alerting_count()
-- RETURNS trigger
-- LANGUAGE plpgsql
-- AS $function$
-- BEGIN
--     IF NEW.reason = 'relative' THEN
--         UPDATE alert
--         SET alerting_relative_count = alerting_relative_count + 1
--         WHERE id = NEW.alert_id;
--     ELSIF NEW.reason IN ('agent', 'connect') THEN
--         UPDATE alert
--         SET alerting_connect_count = alerting_connect_count + 1
--         WHERE id = NEW.alert_id;
--     ELSIF NEW.reason = 'around' THEN
--         UPDATE alert
--         SET alerting_around_count = alerting_around_count + 1
--         WHERE id = NEW.alert_id;
--     ELSIF NEW.reason = 'self' THEN
--         -- Do nothing for 'self'
--         NULL;
--     END IF;
--     RETURN NEW;
-- END;
-- $function$;
--
-- CREATE TRIGGER update_alerting_counts
-- AFTER INSERT ON alerting
-- FOR EACH ROW
-- EXECUTE FUNCTION public.increment_alerting_count();