Files
llmapikey/supabase/migrations/0002_api_keys_store_raw_key.up.sql
tiennm99 3eda216dc6 feat(keys): store raw OpenRouter key and make it retrievable
Persist the raw key (migration 0002 adds openrouter_key) so users can copy it
again from the dashboard instead of a one-time-only reveal; admin console shows
the full key. Retain openrouter_key_hash for revocation. Keys remain in the
unexposed llmapikey schema (deny-all RLS, server-only direct connection).

- activate() stores the raw key; dashboard + generate-key return the full key.
- key-display warning updated (no longer shown-once).
- admin table renders the full key.
2026-06-14 14:10:46 +07:00

7 lines
419 B
SQL

-- Store the raw OpenRouter key so users can retrieve it later (no more
-- shown-once-only). The key still lives only in the unexposed `llmapikey`
-- schema (deny-all RLS, reached solely by the server-side direct connection).
-- `openrouter_key_hash` is retained — it is OpenRouter's delete handle for
-- revocation, not a hash of the key.
alter table llmapikey.api_keys add column if not exists openrouter_key text;