monacousa-portal/supabase/migrations
Matt 549ace87c6
Build and Push Docker Images / build-portal (push) Successful in 1m54s Details
Build and Push Docker Images / build-infra (docker/db, monacousa-db) (push) Successful in 59s Details
Build and Push Docker Images / build-infra (docker/kong, monacousa-kong) (push) Successful in 23s Details
Build and Push Docker Images / build-infra (docker/migrate, monacousa-migrate) (push) Successful in 59s Details
Fix board members 0-count, bulk email 0-recipients, 502 on cold start, and duplicate statuses
- Board members: switch to supabaseAdmin to bypass dues_payments RLS on members_with_dues view
- Bulk email: query members_with_dues view with status_name instead of nonexistent status column on members table
- 502 error: skip setupCheckHandle DB query for login/signup/public/static routes, increase cache TTL to 5min
- Duplicate statuses: add migration 026 to deduplicate Active/active entries, add defensive dedup in admin members loader

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-10 20:17:37 +01:00
..
001_initial_schema.sql Initial production deployment setup 2026-01-25 02:19:49 +01:00
002_admin_integrations_settings.sql Initial production deployment setup 2026-01-25 02:19:49 +01:00
003_storage_buckets_and_audit.sql Initial production deployment setup 2026-01-25 02:19:49 +01:00
004_user_notification_preferences.sql Initial production deployment setup 2026-01-25 02:19:49 +01:00
005_fix_avatars_storage_policy.sql Initial production deployment setup 2026-01-25 02:19:49 +01:00
006_document_folders.sql Initial production deployment setup 2026-01-25 02:19:49 +01:00
007_dues_reminders.sql Initial production deployment setup 2026-01-25 02:19:49 +01:00
008_s3_public_endpoint.sql Initial production deployment setup 2026-01-25 02:19:49 +01:00
009_dual_avatar_urls.sql Initial production deployment setup 2026-01-25 02:19:49 +01:00
010_storage_service_role_policies.sql Initial production deployment setup 2026-01-25 02:19:49 +01:00
011_fix_service_role_rls.sql Initial production deployment setup 2026-01-25 02:19:49 +01:00
012_dual_document_urls.sql Initial production deployment setup 2026-01-25 02:19:49 +01:00
013_email_background_images.sql Initial production deployment setup 2026-01-25 02:19:49 +01:00
014_event_reminders.sql Initial production deployment setup 2026-01-25 02:19:49 +01:00
015_fix_email_template_styling.sql Initial production deployment setup 2026-01-25 02:19:49 +01:00
016_onboarding_payment_tracking.sql Initial production deployment setup 2026-01-25 02:19:49 +01:00
017_fix_rls_role_escalation.sql Phase 1: Full implementation — security, bugs, utilities, UI/UX, consolidation 2026-02-06 07:55:19 +01:00
018_atomic_member_id_generation.sql Implement complete feature & security overhaul (21 items, 3 phases) 2026-02-10 18:03:46 +01:00
019_fix_admin_role_assignment.sql Implement complete feature & security overhaul (21 items, 3 phases) 2026-02-10 18:03:46 +01:00
020_approval_email_templates.sql Implement complete feature & security overhaul (21 items, 3 phases) 2026-02-10 18:03:46 +01:00
021_rsvp_deadlines.sql Implement complete feature & security overhaul (21 items, 3 phases) 2026-02-10 18:03:46 +01:00
022_directory_privacy.sql Implement complete feature & security overhaul (21 items, 3 phases) 2026-02-10 18:03:46 +01:00
023_document_search.sql Implement complete feature & security overhaul (21 items, 3 phases) 2026-02-10 18:03:46 +01:00
024_cron_execution_logs.sql Implement complete feature & security overhaul (21 items, 3 phases) 2026-02-10 18:03:46 +01:00
025_bulk_emails.sql Implement complete feature & security overhaul (21 items, 3 phases) 2026-02-10 18:03:46 +01:00
026_fix_duplicate_statuses.sql Fix board members 0-count, bulk email 0-recipients, 502 on cold start, and duplicate statuses 2026-02-10 20:17:37 +01:00