CREATE TABLE `actors` (
	`id` integer PRIMARY KEY AUTOINCREMENT,
	`discord_id` text UNIQUE,
	`display_name` text,
	`username` text,
	`avatar` text,
	`created_at` integer NOT NULL,
	`updated_at` integer NOT NULL,
	`deleted_at` integer
);
--> statement-breakpoint
CREATE TABLE `sessions` (
	`id` text PRIMARY KEY,
	`user_id` integer NOT NULL,
	`access_token` text NOT NULL,
	`refresh_token` text NOT NULL,
	`expires_at` integer NOT NULL,
	`created_at` integer NOT NULL,
	`scope` text,
	`token_type` text,
	CONSTRAINT `fk_sessions_user_id_actors_id_fk` FOREIGN KEY (`user_id`) REFERENCES `actors`(`id`)
);
