1
CREATE TABLE `auth_events` (
2
	`id` text PRIMARY KEY NOT NULL,
3
	`event_type` text NOT NULL,
4
	`created_at_ms` integer NOT NULL,
5
	`data_json` text NOT NULL
6
);
7
--> statement-breakpoint
8
CREATE INDEX `auth_events_created_idx` ON `auth_events` (`created_at_ms`);--> statement-breakpoint
9
CREATE INDEX `auth_events_type_created_idx` ON `auth_events` (`event_type`,`created_at_ms`);--> statement-breakpoint
10
CREATE TABLE `pats` (
11
	`id` text PRIMARY KEY NOT NULL,
12
	`name` text NOT NULL,
13
	`token_digest` text NOT NULL,
14
	`scopes_json` text NOT NULL,
15
	`created_at_ms` integer NOT NULL,
16
	`expires_at_ms` integer,
17
	`revoked_at_ms` integer,
18
	`last_used_at_ms` integer
19
);
20
--> statement-breakpoint
21
CREATE INDEX `pats_active_idx` ON `pats` (`revoked_at_ms`,`expires_at_ms`);--> statement-breakpoint
22
CREATE INDEX `pats_created_idx` ON `pats` (`created_at_ms`);--> statement-breakpoint
23
CREATE TABLE `sessions` (
24
	`id` text PRIMARY KEY NOT NULL,
25
	`created_at_ms` integer NOT NULL,
26
	`expires_at_ms` integer NOT NULL,
27
	`revoked_at_ms` integer,
28
	`last_used_at_ms` integer
29
);
30
--> statement-breakpoint
31
CREATE INDEX `sessions_expires_idx` ON `sessions` (`expires_at_ms`);--> statement-breakpoint
32
CREATE INDEX `sessions_revoked_idx` ON `sessions` (`revoked_at_ms`);--> statement-breakpoint
33
ALTER TABLE `meta` DROP COLUMN `updated_at_ms`;