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