openstatus.dev
Openstatus
www.openstatus.dev
1CREATE TABLE `account` (
2 `user_id` integer NOT NULL,
3 `type` text NOT NULL,
4 `provider` text NOT NULL,
5 `provider_account_id` text NOT NULL,
6 `refresh_token` text,
7 `access_token` text,
8 `expires_at` integer,
9 `token_type` text,
10 `scope` text,
11 `id_token` text,
12 `session_state` text,
13 PRIMARY KEY(`provider`, `provider_account_id`),
14 FOREIGN KEY (`user_id`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE cascade
15);
16--> statement-breakpoint
17CREATE TABLE `session` (
18 `session_token` text PRIMARY KEY NOT NULL,
19 `user_id` integer NOT NULL,
20 `expires` integer NOT NULL,
21 FOREIGN KEY (`user_id`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE cascade
22);
23--> statement-breakpoint
24CREATE TABLE `verification_token` (
25 `identifier` text NOT NULL,
26 `token` text NOT NULL,
27 `expires` integer NOT NULL,
28 PRIMARY KEY(`identifier`, `token`)
29);
30--> statement-breakpoint
31ALTER TABLE user ADD `name` text;--> statement-breakpoint
32ALTER TABLE user ADD `emailVerified` integer;