migrations/20240904153315_channel.sql


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

create table channel (
	id text
		not null
		primary key,
	name text
		not null
		unique
);

create table channel_member (
	channel text
		not null
		references channel,
	login text
		not null
		references login,
	primary key (channel, login)
);

create index channel_member_login on channel_member (login);