d8d-remix-tailwind-postcss-antd/migrations/20240101000000_create_admin_user.js

/** @type {import('knex').Knex} */

export async function up(knex) {
  await knex.schema.createTable("users", (table) => {
    table.increments("id").primary();
    table.string("username").notNullable().unique();
    table.string("password").notNullable();
    table.boolean("is_admin").notNullable().defaultTo(false);
    table.timestamps(true, true);
  });
}

export async function down(knex) {
  await knex.schema.dropTable("users");
}