all repos — stealth-developers @ cebb512f739021bf604c24a233edccfd2862d236

pkgs/db/drizzle/20260525174422_youthful_bedlam/migration.sql (view raw)

 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
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`)
);