1
PRAGMA foreign_keys=OFF;--> statement-breakpoint
2
CREATE TABLE `__new_oauth_access_tokens` (
3
	`id` text PRIMARY KEY NOT NULL,
4
	`token` text NOT NULL,
5
	`client_id` text NOT NULL,
6
	`session_id` text,
7
	`user_id` text,
8
	`reference_id` text,
9
	`refresh_id` text,
10
	`expires_at` integer NOT NULL,
11
	`created_at` integer NOT NULL,
12
	`scopes` text NOT NULL,
13
	FOREIGN KEY (`client_id`) REFERENCES `oauth_clients`(`client_id`) ON UPDATE no action ON DELETE cascade,
14
	FOREIGN KEY (`session_id`) REFERENCES `sessions`(`id`) ON UPDATE no action ON DELETE set null,
15
	FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON UPDATE no action ON DELETE cascade,
16
	FOREIGN KEY (`refresh_id`) REFERENCES `oauth_refresh_tokens`(`id`) ON UPDATE no action ON DELETE cascade
17
);
18
--> statement-breakpoint
19
INSERT INTO `__new_oauth_access_tokens`("id", "token", "client_id", "session_id", "user_id", "reference_id", "refresh_id", "expires_at", "created_at", "scopes") SELECT "id", "token", "client_id", "session_id", "user_id", "reference_id", "refresh_id", "expires_at", "created_at", "scopes" FROM `oauth_access_tokens`;--> statement-breakpoint
20
DROP TABLE `oauth_access_tokens`;--> statement-breakpoint
21
ALTER TABLE `__new_oauth_access_tokens` RENAME TO `oauth_access_tokens`;--> statement-breakpoint
22
PRAGMA foreign_keys=ON;--> statement-breakpoint
23
CREATE UNIQUE INDEX `oauth_access_tokens_token_unique` ON `oauth_access_tokens` (`token`);--> statement-breakpoint
24
CREATE INDEX `oauthAccessTokens_clientId_idx` ON `oauth_access_tokens` (`client_id`);--> statement-breakpoint
25
CREATE INDEX `oauthAccessTokens_sessionId_idx` ON `oauth_access_tokens` (`session_id`);--> statement-breakpoint
26
CREATE INDEX `oauthAccessTokens_userId_idx` ON `oauth_access_tokens` (`user_id`);--> statement-breakpoint
27
CREATE INDEX `oauthAccessTokens_refreshId_idx` ON `oauth_access_tokens` (`refresh_id`);--> statement-breakpoint
28
CREATE TABLE `__new_oauth_consents` (
29
	`id` text PRIMARY KEY NOT NULL,
30
	`client_id` text NOT NULL,
31
	`user_id` text,
32
	`reference_id` text,
33
	`scopes` text NOT NULL,
34
	`created_at` integer NOT NULL,
35
	`updated_at` integer NOT NULL,
36
	FOREIGN KEY (`client_id`) REFERENCES `oauth_clients`(`client_id`) ON UPDATE no action ON DELETE cascade,
37
	FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON UPDATE no action ON DELETE cascade
38
);
39
--> statement-breakpoint
40
INSERT INTO `__new_oauth_consents`("id", "client_id", "user_id", "reference_id", "scopes", "created_at", "updated_at") SELECT "id", "client_id", "user_id", "reference_id", "scopes", "created_at", "updated_at" FROM `oauth_consents`;--> statement-breakpoint
41
DROP TABLE `oauth_consents`;--> statement-breakpoint
42
ALTER TABLE `__new_oauth_consents` RENAME TO `oauth_consents`;--> statement-breakpoint
43
CREATE INDEX `oauthConsents_clientId_idx` ON `oauth_consents` (`client_id`);--> statement-breakpoint
44
CREATE INDEX `oauthConsents_userId_idx` ON `oauth_consents` (`user_id`);--> statement-breakpoint
45
CREATE TABLE `__new_oauth_refresh_tokens` (
46
	`id` text PRIMARY KEY NOT NULL,
47
	`token` text NOT NULL,
48
	`client_id` text NOT NULL,
49
	`session_id` text,
50
	`user_id` text NOT NULL,
51
	`reference_id` text,
52
	`expires_at` integer NOT NULL,
53
	`created_at` integer NOT NULL,
54
	`revoked` integer,
55
	`auth_time` integer,
56
	`scopes` text NOT NULL,
57
	FOREIGN KEY (`client_id`) REFERENCES `oauth_clients`(`client_id`) ON UPDATE no action ON DELETE cascade,
58
	FOREIGN KEY (`session_id`) REFERENCES `sessions`(`id`) ON UPDATE no action ON DELETE set null,
59
	FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON UPDATE no action ON DELETE cascade
60
);
61
--> statement-breakpoint
62
INSERT INTO `__new_oauth_refresh_tokens`("id", "token", "client_id", "session_id", "user_id", "reference_id", "expires_at", "created_at", "revoked", "auth_time", "scopes") SELECT "id", "token", "client_id", "session_id", "user_id", "reference_id", "expires_at", "created_at", "revoked", "auth_time", "scopes" FROM `oauth_refresh_tokens`;--> statement-breakpoint
63
DROP TABLE `oauth_refresh_tokens`;--> statement-breakpoint
64
ALTER TABLE `__new_oauth_refresh_tokens` RENAME TO `oauth_refresh_tokens`;--> statement-breakpoint
65
CREATE UNIQUE INDEX `oauth_refresh_tokens_token_unique` ON `oauth_refresh_tokens` (`token`);--> statement-breakpoint
66
CREATE INDEX `oauthRefreshTokens_clientId_idx` ON `oauth_refresh_tokens` (`client_id`);--> statement-breakpoint
67
CREATE INDEX `oauthRefreshTokens_sessionId_idx` ON `oauth_refresh_tokens` (`session_id`);--> statement-breakpoint
68
CREATE INDEX `oauthRefreshTokens_userId_idx` ON `oauth_refresh_tokens` (`user_id`);