Moheeb Zara
5d153b4d68
In-app notification center (Phase 5, migration 051):
- notifications.read_at + partial unread index. /me Notifications is now
an inbox: unread styling, click to expand the message + mark read,
"mark all as read", unread count. markNotificationsRead is a service-
client write scoped to the caller's own member_id. Always-on channel:
email-muted ('skipped') notifications still appear in-app.
Consolidate /profile into /me:
- Delete app/(app)/profile/*; /me is the single member page. Port the
conflict-of-interest privileged-role nudge + last-disclosed date into
/me's profile editor. Remove the "My profile" sidebar + command-palette
entries; rename the /me nav label to "My membership". Repoint the
recruitment empty-state link to /me.
Theme realign:
- Revert the rounded-lg cards introduced in the prior /me visual pass to
rounded (the app norm, matching the former /profile). Route /me section
headers through the SectionTitle primitive.
Regression guard:
- integration/auth-embed.test.ts runs the auth layout's
space_members.select('*, spaces(*)') embed through PostgREST and fails
on PGRST201, so a future junction table cannot silently break auth again.
24 lines
1.3 KiB
SQL
24 lines
1.3 KiB
SQL
-- =============================================================================
|
|
-- 051: in-app notification center read state (Product spine Phase 5)
|
|
-- =============================================================================
|
|
-- The notifications outbox doubles as the member's in-app inbox on /me. Add a
|
|
-- per-row read marker so the inbox can show unread/read state and an unread
|
|
-- count. read_at IS NULL means unread; the member self-serve mark-read action
|
|
-- (service client, scoped to the caller's own member_id) sets it. This is the
|
|
-- always-on channel: a notification whose EMAIL was muted ('skipped' by the
|
|
-- dispatcher per the member's preferences) still appears here as unread.
|
|
--
|
|
-- No RLS change: notifications already has SELECT = admin/board/treasurer and
|
|
-- NO client write policy; the member's read + mark-read both go through
|
|
-- validated service-client actions (same convention as the rest of the
|
|
-- notification self-view).
|
|
--
|
|
-- Idempotent: ADD COLUMN / CREATE INDEX IF NOT EXISTS. Apply as-is.
|
|
-- =============================================================================
|
|
|
|
ALTER TABLE public.notifications ADD COLUMN IF NOT EXISTS read_at timestamptz;
|
|
|
|
-- Partial index for the per-member unread count / unread list.
|
|
CREATE INDEX IF NOT EXISTS idx_notifications_unread
|
|
ON public.notifications (space_id, member_id) WHERE read_at IS NULL;
|