mary.my.id
Statusphere, but in atcute and SvelteKit
atproto
svelte
sveltekit
drizzle
atcute
typescript
1CREATE TABLE `identity` (
2 `did` text PRIMARY KEY NOT NULL,
3 `handle` text NOT NULL,
4 `is_active` integer NOT NULL,
5 `status` text NOT NULL,
6 `updated_at` integer NOT NULL
7);
8--> statement-breakpoint
9CREATE TABLE `oauth_session` (
10 `did` text PRIMARY KEY NOT NULL,
11 `session` text NOT NULL,
12 `updated_at` integer NOT NULL
13);
14--> statement-breakpoint
15CREATE INDEX `oauth_session_updated_at_idx` ON `oauth_session` (`updated_at`);--> statement-breakpoint
16CREATE TABLE `oauth_state` (
17 `key` text PRIMARY KEY NOT NULL,
18 `state` text NOT NULL,
19 `expires_at` integer NOT NULL
20);
21--> statement-breakpoint
22CREATE INDEX `oauth_state_expires_at_idx` ON `oauth_state` (`expires_at`);--> statement-breakpoint
23CREATE TABLE `profile` (
24 `did` text PRIMARY KEY NOT NULL,
25 `record` text NOT NULL,
26 `indexed_at` integer NOT NULL
27);
28--> statement-breakpoint
29CREATE TABLE `status` (
30 `uri` text PRIMARY KEY NOT NULL,
31 `author_did` text NOT NULL,
32 `rkey` text NOT NULL,
33 `record` text NOT NULL,
34 `sort_at` integer NOT NULL,
35 `indexed_at` integer NOT NULL
36);
37--> statement-breakpoint
38CREATE INDEX `status_sort_at_idx` ON `status` (`sort_at`);