migrations/20240912145249_message.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

create table message (
	id text
		not null
		primary key,
	channel text
		not null
		references channel (id),
	sender text
		not null
		references login (id),
	body text
		not null,
	sent_at text
		not null
);

create index message_sent_at on message (channel, sent_at);