-- A key claimed through the normal claim-link flow already has its
-- claimant traceable via redemptions -> claim_links (creator_tag, and the
-- Creator Group it belongs to, if any). But a key can also leave circulation
-- outside this system entirely -- handed out manually over email/Discord,
-- for example -- and Key Lair has no record of who received it. This is an
-- admin-editable free-text note for exactly that case, shown only when no
-- system redemption exists for the key; once one does, the real (linked)
-- claimant takes over and this note becomes moot for that key.

ALTER TABLE `keys` ADD COLUMN claimed_by_note VARCHAR(190) NULL AFTER redeemed_at;
