CREATE TABLE `auth_events` (
	`id` text PRIMARY KEY NOT NULL,
	`event_type` text NOT NULL,
	`created_at_ms` integer NOT NULL,
	`data_json` text NOT NULL
);
--> statement-breakpoint
CREATE INDEX `auth_events_created_idx` ON `auth_events` (`created_at_ms`);--> statement-breakpoint
CREATE INDEX `auth_events_type_created_idx` ON `auth_events` (`event_type`,`created_at_ms`);--> statement-breakpoint
CREATE TABLE `pats` (
	`id` text PRIMARY KEY NOT NULL,
	`name` text NOT NULL,
	`token_digest` text NOT NULL,
	`scopes_json` text NOT NULL,
	`created_at_ms` integer NOT NULL,
	`expires_at_ms` integer,
	`revoked_at_ms` integer,
	`last_used_at_ms` integer
);
--> statement-breakpoint
CREATE INDEX `pats_active_idx` ON `pats` (`revoked_at_ms`,`expires_at_ms`);--> statement-breakpoint
CREATE INDEX `pats_created_idx` ON `pats` (`created_at_ms`);--> statement-breakpoint
CREATE TABLE `sessions` (
	`id` text PRIMARY KEY NOT NULL,
	`created_at_ms` integer NOT NULL,
	`expires_at_ms` integer NOT NULL,
	`revoked_at_ms` integer,
	`last_used_at_ms` integer
);
--> statement-breakpoint
CREATE INDEX `sessions_expires_idx` ON `sessions` (`expires_at_ms`);--> statement-breakpoint
CREATE INDEX `sessions_revoked_idx` ON `sessions` (`revoked_at_ms`);--> statement-breakpoint
ALTER TABLE `meta` DROP COLUMN `updated_at_ms`;