kacaii.dev / senac-brigade-server
wip: currently rewriting the project as a full stack application tangled.org/kacaii.dev/sigo
gleam
fork atom
senac-brigade-server / src / app / domain / notification / sql / update_notification_preferences.sql
at main 11 lines 264 B view raw
kacaii.dev :art: lowercase all sql code
61f7a9ea
1--  Update user notification preference 2update public.user_notification_preference as np 3set 4 enabled = $3, 5 updated_at = current_timestamp 6where 7 np.user_id = $1 8 and np.notification_type = $2 9returning 10 new.notification_type, 11 new.enabled;