Public Access
1
0
Files
leads4less/db/migrations/0009_admin_ops_indexes.sql

9 lines
395 B
SQL

create index if not exists admin_access_audit_action_occurred_at_idx
on public.admin_access_audit (action, occurred_at desc);
create index if not exists admin_access_audit_workspace_occurred_at_idx
on public.admin_access_audit (target_workspace_id, occurred_at desc);
create index if not exists admin_access_audit_actor_email_lower_idx
on public.admin_access_audit (lower(actor_email));