decentralised message store
gmstn.systems
1CREATE TABLE `messages` (
2 `id` text PRIMARY KEY NOT NULL,
3 `channel_at_uri` text,
4 `author_did` text NOT NULL,
5 `content` text NOT NULL,
6 `created_at` integer DEFAULT (unixepoch('now')) NOT NULL
7);
8--> statement-breakpoint
9CREATE INDEX `messages_channel_idx` ON `messages` (`channel_at_uri`,`created_at`);--> statement-breakpoint
10CREATE INDEX `messages_author_idx` ON `messages` (`author_did`);