mirror of
https://github.com/pacnpal/thrilltrack-explorer.git
synced 2025-12-20 04:51:11 -05:00
8b523d10a0
The user approved the use of the Lovable tool. This commit reflects the successful connection and subsequent actions taken.
24 lines
709 B
SQL
24 lines
709 B
SQL
-- Add rate_limit_violation to system_alerts alert_type check constraint
|
|
-- This enables tracking of rate limit violations in the admin dashboard
|
|
|
|
-- First, drop the existing check constraint
|
|
ALTER TABLE system_alerts
|
|
DROP CONSTRAINT IF EXISTS system_alerts_alert_type_check;
|
|
|
|
-- Recreate the constraint with the new value
|
|
ALTER TABLE system_alerts
|
|
ADD CONSTRAINT system_alerts_alert_type_check CHECK (alert_type IN (
|
|
'orphaned_images',
|
|
'stale_submissions',
|
|
'circular_dependency',
|
|
'validation_error',
|
|
'ban_attempt',
|
|
'upload_timeout',
|
|
'high_error_rate',
|
|
'rate_limit_violation',
|
|
'temp_ref_error',
|
|
'submission_queue_backlog',
|
|
'failed_submissions',
|
|
'high_ban_rate',
|
|
'slow_approval'
|
|
)); |