13 lines
446 B
SQL
13 lines
446 B
SQL
CREATE TABLE IF NOT EXISTS api_keys (
|
|
id BIGSERIAL PRIMARY KEY,
|
|
key TEXT NOT NULL UNIQUE,
|
|
name TEXT NOT NULL,
|
|
is_active BOOLEAN NOT NULL DEFAULT TRUE,
|
|
created_at TIMESTAMPTZ NOT NULL DEFAULT now()
|
|
);
|
|
|
|
-- Generate a default key (replace with your own or delete after creating real keys)
|
|
INSERT INTO api_keys (key, name)
|
|
VALUES (encode(gen_random_bytes(32), 'hex'), 'default')
|
|
ON CONFLICT DO NOTHING;
|