@devries-cameron20 / t3code Mirror · read-only
Fork 0

The best way to control Claude Code, Codex and more from any computer or phone

Mirrored from https://github.com/Camo67/t3code.git

Synced Nov 21, 06:00 UTC

main
sql 51 lines 1.58 KB
Raw
1 CREATE TABLE `account` (
2 `id` text PRIMARY KEY,
3 `account_id` text NOT NULL,
4 `provider_id` text NOT NULL,
5 `user_id` text NOT NULL,
6 `access_token` text,
7 `refresh_token` text,
8 `id_token` text,
9 `access_token_expires_at` integer,
10 `refresh_token_expires_at` integer,
11 `scope` text,
12 `password` text,
13 `created_at` integer NOT NULL,
14 `updated_at` integer NOT NULL,
15 CONSTRAINT `fk_account_user_id_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `user`(`id`) ON DELETE CASCADE
16 );
17 --> statement-breakpoint
18 CREATE TABLE `session` (
19 `id` text PRIMARY KEY,
20 `expires_at` integer NOT NULL,
21 `token` text NOT NULL UNIQUE,
22 `created_at` integer NOT NULL,
23 `updated_at` integer NOT NULL,
24 `ip_address` text,
25 `user_agent` text,
26 `user_id` text NOT NULL,
27 CONSTRAINT `fk_session_user_id_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `user`(`id`) ON DELETE CASCADE
28 );
29 --> statement-breakpoint
30 CREATE TABLE `user` (
31 `id` text PRIMARY KEY,
32 `name` text NOT NULL,
33 `email` text NOT NULL UNIQUE,
34 `email_verified` integer DEFAULT false NOT NULL,
35 `image` text,
36 `created_at` integer NOT NULL,
37 `updated_at` integer NOT NULL
38 );
39 --> statement-breakpoint
40 CREATE TABLE `verification` (
41 `id` text PRIMARY KEY,
42 `identifier` text NOT NULL,
43 `value` text NOT NULL,
44 `expires_at` integer NOT NULL,
45 `created_at` integer NOT NULL,
46 `updated_at` integer NOT NULL
47 );
48 --> statement-breakpoint
49 CREATE INDEX `account_userId_idx` ON `account` (`user_id`);--> statement-breakpoint
50 CREATE INDEX `session_userId_idx` ON `session` (`user_id`);--> statement-breakpoint
51 CREATE INDEX `verification_identifier_idx` ON `verification` (`identifier`);