baileytownsend.dev
PDS Admin tool make it easier to moderate your PDS with labels
1CREATE TABLE `labeler_cursors` (
2 `labeler_id` text,
3 `cursor` integer NOT NULL
4);
5--> statement-breakpoint
6CREATE UNIQUE INDEX `labeler_cursors_labeler_id_unique` ON `labeler_cursors` (`labeler_id`);--> statement-breakpoint
7CREATE TABLE `labels_applied` (
8 `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
9 `did` text NOT NULL,
10 `label` text NOT NULL,
11 `action` text NOT NULL,
12 `negated` integer DEFAULT false NOT NULL,
13 `date_applied` integer NOT NULL,
14 FOREIGN KEY (`did`) REFERENCES `watched_repos`(`did`) ON UPDATE no action ON DELETE no action
15);
16--> statement-breakpoint
17CREATE TABLE `watched_repos` (
18 `did` text PRIMARY KEY NOT NULL,
19 `pds_host` text NOT NULL,
20 `active` integer NOT NULL,
21 `date_first_seen` integer NOT NULL
22);
23--> statement-breakpoint
24CREATE UNIQUE INDEX `watched_repos_did_unique` ON `watched_repos` (`did`);