20240220234826_add_rate_buckets.sql
1CREATE TABLE IF NOT EXISTS rate_buckets (
2 user_id INT NOT NULL,
3 rate_limit_name VARCHAR(255) NOT NULL,
4 token_count INT NOT NULL,
5 last_refill TIMESTAMP WITHOUT TIME ZONE NOT NULL,
6 PRIMARY KEY (user_id, rate_limit_name),
7 CONSTRAINT fk_user
8 FOREIGN KEY (user_id) REFERENCES users(id)
9);
10
11CREATE INDEX idx_user_id_rate_limit ON rate_buckets (user_id, rate_limit_name);