20250304185826_lock-column-users-table.ts

import { Knex } from 'knex';

export async function up(knex: Knex): Promise<void> {
  await knex.schema.alterTable('users', (table) => {
    table.boolean('locked').defaultTo(false).notNullable();
  });
  await knex('users').update({ locked: false });
}

export async function down(knex: Knex): Promise<void> {
  await knex.schema.alterTable('users', (table) => {
    table.dropColumn('locked');
  });
}