steid

steid/migrations/20260804093031_create_users.sql

351 BCode·Blame·Raw

e51b80cfeat: sqlite migrations for the identity schema1mo	1	-- Users reference their personal organisation, so orgs must exist first. This is the
	2	-- foreign key our use cases order their writes around.
	3	create table users (
	4	id text primary key,
	5	email text not null unique collate nocase,
	6	password_hash text not null,
	7	personal_org_id text not null references orgs (id)
	8	);