AgentServer/apps/server/drizzle/0021_skill_device_login.sql

CREATE TABLE `skill_device_logins` (
	`id` text PRIMARY KEY NOT NULL,
	`device_code_hash` text NOT NULL,
	`user_code` text NOT NULL,
	`client` text NOT NULL,
	`ip` text NOT NULL,
	`status` text DEFAULT 'pending' NOT NULL,
	`key_name` text,
	`key_days` integer,
	`key_id` text,
	`expires_at` text NOT NULL,
	`last_poll_at` text,
	`created_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX `skill_device_logins_device_code_hash_unique` ON `skill_device_logins` (`device_code_hash`);--> statement-breakpoint
CREATE UNIQUE INDEX `skill_device_logins_user_code_unique` ON `skill_device_logins` (`user_code`);--> statement-breakpoint
ALTER TABLE `skill_publish_keys` ADD `origin` text DEFAULT 'manual' NOT NULL;