@jpgilldev / steid

steid/migrations/20260804093031_create_users.sql
351 BRaw
1-- Users reference their personal organisation, so orgs must exist first. This is the
2-- foreign key our use cases order their writes around.
3create 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);