aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_channel_log
Parameters
Name
Type
Mode
Definition
BEGIN CASE TG_OP WHEN 'INSERT' THEN PERFORM sp_user_log('settings', 'Channel Add ', 'Add channel "'||NEW.name||'"', ref_id1 => NEW.id); WHEN 'UPDATE' THEN PERFORM sp_user_log('settings', 'Channel Update', 'Update channel "'||NEW.name||'"', ref_id1 => NEW.id); WHEN 'DELETE' THEN PERFORM sp_user_log('settings', 'Channel Delete', 'Delete channel "'||OLD.name||'"', ref_id1 => OLD.id); END CASE; RETURN NULL; END