7 lines
342 B
SQL
7 lines
342 B
SQL
-- Add rate limiting columns to api_keys table
|
|
ALTER TABLE api_keys
|
|
ADD COLUMN IF NOT EXISTS rate_limit_count INTEGER,
|
|
ADD COLUMN IF NOT EXISTS rate_limit_period VARCHAR(20), -- 'minute', 'hour', 'day'
|
|
ADD COLUMN IF NOT EXISTS usage_count INTEGER DEFAULT 0,
|
|
ADD COLUMN IF NOT EXISTS usage_reset_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP;
|