an atproto based link aggregator
1CREATE TABLE `accounts` (
2 `did` text PRIMARY KEY NOT NULL,
3 `handle` text,
4 `active` integer DEFAULT 1 NOT NULL,
5 `status` text,
6 `seq` integer DEFAULT 0 NOT NULL,
7 `updated_at` text NOT NULL
8);
9--> statement-breakpoint
10CREATE TABLE `comments` (
11 `uri` text PRIMARY KEY NOT NULL,
12 `cid` text NOT NULL,
13 `author_did` text NOT NULL,
14 `rkey` text NOT NULL,
15 `post_uri` text NOT NULL,
16 `post_cid` text NOT NULL,
17 `parent_uri` text,
18 `parent_cid` text,
19 `text` text NOT NULL,
20 `created_at` text NOT NULL,
21 `indexed_at` text NOT NULL,
22 `vote_count` integer DEFAULT 0 NOT NULL,
23 `is_hidden` integer DEFAULT 0 NOT NULL
24);
25--> statement-breakpoint
26CREATE TABLE `ingestion_cursor` (
27 `id` integer PRIMARY KEY DEFAULT 1 NOT NULL,
28 `cursor_us` integer NOT NULL,
29 `updated_at` text NOT NULL
30);
31--> statement-breakpoint
32CREATE TABLE `posts` (
33 `uri` text PRIMARY KEY NOT NULL,
34 `cid` text NOT NULL,
35 `author_did` text NOT NULL,
36 `rkey` text NOT NULL,
37 `url` text,
38 `title` text NOT NULL,
39 `text` text,
40 `created_at` text NOT NULL,
41 `indexed_at` text NOT NULL,
42 `vote_count` integer DEFAULT 0 NOT NULL,
43 `is_hidden` integer DEFAULT 0 NOT NULL
44);