TroodonEnjoyer
bc83af8e00
Build & Auto-Repair / build (push) Has been cancelled
Hardened db.ts — added statement_timeout: 30000, idle_in_transaction_session_timeout: 10000, created transaction() helper (BEGIN/COMMIT/ROLLBACK). Multi-step API routes wrapped in transactions — Events POST, Conversations POST use atomic blocks. Fixed leads pagination — status filter pushed into SQL WHERE (no client-side filtering after LIMIT/OFFSET), added SELECT COUNT(*) for total. Rewrote dashboard — SQL aggregations (COUNT + GROUP BY + date_trunc) replace loading all leads into memory. Optimized conversations GET — merged duplicate correlated subqueries into single LEFT JOIN LATERAL. Created migration 021_performance_indexes.sql — 8 missing indexes + set_session_user_context() function caching current_user_hierarchy_level() as session variable (avoids per-query RLS join). Fixed build error — duplicate const other in conversations route. Also fixed a TypeScript never error in dashboard breakdown map. Verified — npx tsc --noEmit clean, npm test (13 pass, 7 integration skip gracefully), npx next build succeeds.
87 lines
2.8 KiB
PL/PgSQL
87 lines
2.8 KiB
PL/PgSQL
-- ============================================================================
|
|
-- CRM Database — Full Migration Runner
|
|
-- ============================================================================
|
|
-- Usage: psql -U postgres -d crm -f run_all.sql
|
|
-- ============================================================================
|
|
|
|
BEGIN;
|
|
\set ON_ERROR_STOP on
|
|
|
|
\echo '=== Running 001_schema.sql (Tables + Constraints + Functions + Views) ==='
|
|
\i 001_schema.sql
|
|
|
|
\echo '=== Running 002_seed.sql (RBAC + Test Accounts + Reference Data) ==='
|
|
\i 002_seed.sql
|
|
|
|
\echo '=== Running 003_chat.sql (Chat Tables) ==='
|
|
\i 003_chat.sql
|
|
|
|
\echo '=== Running 004_avatar_url.sql (Avatar URL Column) ==='
|
|
\i 004_avatar_url.sql
|
|
|
|
\echo '=== Running 005_last_read_at.sql (Last Read At Column) ==='
|
|
\i 005_last_read_at.sql
|
|
|
|
\echo '=== Running 006_test_leads.sql (Test Lead Data) ==='
|
|
\i 006_test_leads.sql
|
|
|
|
\echo '=== Running 007_ai_features.sql (AI Features) ==='
|
|
\i 007_ai_features.sql
|
|
|
|
\echo '=== Running 008_notifications.sql (Notifications + Preferences) ==='
|
|
\i 008_notifications.sql
|
|
|
|
\echo '=== Running 009_settings.sql (Company Settings + User Preferences) ==='
|
|
\i 009_settings.sql
|
|
|
|
\echo '=== Running 010_chat_notifications.sql (Chat Notifications) ==='
|
|
\i 010_chat_notifications.sql
|
|
|
|
\echo '=== Running 010_facebook_accounts.sql (Facebook Accounts) ==='
|
|
\i 010_facebook_accounts.sql
|
|
|
|
\echo '=== Running 011_calendar_events.sql (Calendar Events) ==='
|
|
\i 011_calendar_events.sql
|
|
|
|
\echo '=== Running 012_invites.sql (Invites) ==='
|
|
\i 012_invites.sql
|
|
|
|
\echo '=== Running 012_sent_emails.sql (Sent Email Log) ==='
|
|
\i 012_sent_emails.sql
|
|
|
|
\echo '=== Running 013_security_upgrade.sql (Security Architecture) ==='
|
|
\i 013_security_upgrade.sql
|
|
|
|
\echo '=== Running 013_rls_calendar.sql (Calendar RLS) ==='
|
|
\i 013_rls_calendar.sql
|
|
|
|
\echo '=== Running 014_bug_reports.sql (Bug Reporting System) ==='
|
|
\i 014_bug_reports.sql
|
|
|
|
\echo '=== Running 014_notifications_context.sql (Notifications Context) ==='
|
|
\i 014_notifications_context.sql
|
|
|
|
\echo '=== Running 015_rls_calendar_participant.sql (Calendar RLS Participant Fix) ==='
|
|
\i 015_rls_calendar_participant.sql
|
|
|
|
\echo '=== Running 016_participant_notes.sql (Participant Notes Column) ==='
|
|
\i 016_participant_notes.sql
|
|
|
|
\echo '=== Running 017_calendar_developer.sql (Calendar Developer Assignment) ==='
|
|
\i 017_calendar_developer.sql
|
|
|
|
\echo '=== Running 018_website_creation_type.sql (Website Creation Event Type) ==='
|
|
\i 018_website_creation_type.sql
|
|
|
|
\echo '=== Running 019_allow_null_start_time.sql (Allow Null Start Time) ==='
|
|
\i 019_allow_null_start_time.sql
|
|
|
|
\echo '=== Running 020_fixes.sql (password_change_required + audit trigger fix) ==='
|
|
\i 020_fixes.sql
|
|
|
|
\echo '=== Running 021_performance_indexes.sql (Performance Indexes + RLS Cache) ==='
|
|
\i 021_performance_indexes.sql
|
|
|
|
\echo '=== Migration Complete ==='
|
|
COMMIT;
|