Spaces:
Runtime error
Runtime error
File size: 570 Bytes
db43121 071c003 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | -- Usage Logs (API Rate Limiting)
CREATE TABLE usage_logs (
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
ip_address TEXT NOT NULL,
action_type TEXT NOT NULL,
created_at TIMESTAMPTZ DEFAULT now()
);
-- Hızlı IP tabanlı sorgular için index
CREATE INDEX idx_usage_logs_ip_date ON usage_logs(ip_address, created_at);
ALTER TABLE usage_logs ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Enable insert access for all users" ON usage_logs FOR INSERT WITH CHECK (true);
CREATE POLICY "Enable read access for all users" ON usage_logs FOR SELECT USING (true);
|