Maciej Pienczyn
825c79c399
Some checks are pending
NordaBiz Tests / Unit & Integration Tests (push) Waiting to run
NordaBiz Tests / E2E Tests (Playwright) (push) Blocked by required conditions
NordaBiz Tests / Smoke Tests (Production) (push) Blocked by required conditions
NordaBiz Tests / Send Failure Notification (push) Blocked by required conditions
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
21 lines
634 B
SQL
21 lines
634 B
SQL
-- Add user engagement tracking columns
|
|
-- 2026-03-13
|
|
|
|
ALTER TABLE users ADD COLUMN IF NOT EXISTS login_count INTEGER DEFAULT 0;
|
|
ALTER TABLE users ADD COLUMN IF NOT EXISTS last_active_at TIMESTAMP;
|
|
ALTER TABLE users ADD COLUMN IF NOT EXISTS page_views_count INTEGER DEFAULT 0;
|
|
|
|
-- Backfill login_count from audit_logs
|
|
UPDATE users u
|
|
SET login_count = COALESCE(sub.cnt, 0)
|
|
FROM (
|
|
SELECT user_id, COUNT(*) as cnt
|
|
FROM audit_logs
|
|
WHERE action = 'login'
|
|
GROUP BY user_id
|
|
) sub
|
|
WHERE u.id = sub.user_id;
|
|
|
|
-- Backfill last_active_at from last_login
|
|
UPDATE users SET last_active_at = last_login WHERE last_login IS NOT NULL;
|