migrations/20241005020958_token.sql


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

create table token (
	id text
		not null
		primary key,
	secret text
		not null
		unique,
	login text
		not null,
	issued_at text
		not null,
	last_used_at text
		not null,
	foreign key (login)
		references login (id)
);

create index token_issued_at
on token (issued_at);