CREATE TABLE `device_links` (`id` blob,`code_hash` blob NOT NULL,`account_id` blob NOT NULL,`device_public` blob NOT NULL,`sealed` blob,`expires_at` datetime NOT NULL,PRIMARY KEY (`id`));
2
3
CREATE INDEX `idx_device_links_expires_at` ON `device_links`(`expires_at`);
4
5
CREATE INDEX `idx_device_links_account_id` ON `device_links`(`account_id`);
6
7
CREATE UNIQUE INDEX `idx_device_links_code_hash` ON `device_links`(`code_hash`);
amadan