migrations/20240831024047_login.sql


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

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

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