Jeffrey Smith
e02b13dc12
All checks were successful
CI/CD / e2e-smoke (push) Has been skipped
CI/CD / detect-changes (push) Successful in 4s
CI/CD / test-runners (push) Has been skipped
CI/CD / test-frontend (push) Successful in 6s
CI/CD / test-go-pg (push) Successful in 2m48s
CI/CD / build-and-deploy (push) Successful in 25s
CI/CD / test-sqlite (push) Successful in 2m55s
Co-authored-by: Jeffrey Smith <jasafpro@gmail.com> Co-committed-by: Jeffrey Smith <jasafpro@gmail.com>
23 lines
772 B
SQL
23 lines
772 B
SQL
-- ==========================================
|
|
-- Armature — 009 Multi-Replica HA
|
|
-- ==========================================
|
|
-- Note: migration 008 was merged into 007 during pre-1.0 schema consolidation.
|
|
|
|
CREATE TABLE IF NOT EXISTS ws_tickets (
|
|
id TEXT PRIMARY KEY,
|
|
user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
|
|
expires_at TIMESTAMPTZ NOT NULL
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_ws_tickets_expires ON ws_tickets(expires_at);
|
|
|
|
CREATE TABLE IF NOT EXISTS rate_limit_counters (
|
|
key TEXT NOT NULL,
|
|
window_start TIMESTAMPTZ NOT NULL,
|
|
tokens REAL NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (key, window_start)
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_rate_limit_counters_window
|
|
ON rate_limit_counters(window_start);
|