compor-academy/server/migrations/003_user_account_status.sql

alter table users
  add column if not exists is_active boolean not null default true;

create index if not exists users_active_index on users (is_active);