-- AUDIT-8 (2026-05-23): promote NOC device-lock metadata out of the
-- pipe-encoded ApiToken.name field into proper columns.

ALTER TABLE `ApiToken`
  ADD COLUMN `displayName` VARCHAR(191) NULL,
  ADD COLUMN `countryId` INT NULL,
  ADD COLUMN `deviceName` VARCHAR(191) NULL,
  ADD COLUMN `lockedDeviceId` VARCHAR(191) NULL;