CREATE TABLE `agents` (`id` integer PRIMARY KEY AUTOINCREMENT,`name` text NOT NULL,`operator_person_id` integer NOT NULL,`token_hash` text NOT NULL,`created_at` datetime,`revoked_at` datetime);

CREATE UNIQUE INDEX `idx_agents_token_hash` ON `agents`(`token_hash`);

CREATE INDEX `idx_agents_operator_person_id` ON `agents`(`operator_person_id`);