CREATE TABLE `ScannerSessionLock` (
  `id` VARCHAR(191) NOT NULL,
  `lockKey` VARCHAR(191) NOT NULL,
  `sessionId` VARCHAR(191) NOT NULL,
  `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE INDEX `ScannerSessionLock_lockKey_key`(`lockKey`),
  INDEX `ScannerSessionLock_sessionId_idx`(`sessionId`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE `ScannerSessionLock` ADD CONSTRAINT `ScannerSessionLock_sessionId_fkey` FOREIGN KEY (`sessionId`) REFERENCES `ScannerSession`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;