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);