CREATE TABLE `device_tokens` (`id` integer PRIMARY KEY AUTOINCREMENT,`person_id` integer NOT NULL,`token` text NOT NULL,`platform` text NOT NULL,`created_at` datetime,`last_seen` datetime);

CREATE UNIQUE INDEX `idx_device_tokens_token` ON `device_tokens`(`token`);

CREATE INDEX `idx_device_tokens_person_id` ON `device_tokens`(`person_id`);