For Migration Up: knex migrate:latest --knexfile config/knexfile.ts
xxxxxxxxxx
import Knex from 'knex';
export function up(knex: Knex): Knex.SchemaBuilder {
return knex.schema.createTable('users', (t) => {
t.increments('id');
t.string('name').notNullable();
t.string('email').notNullable();
t.string('password');
t.unique(['email']);
// t.foreign('user_id').references('id').inTable('users');
});
}
export function down(knex: Knex): Knex.SchemaBuilder {
return knex.schema.dropTable('users');
}
xxxxxxxxxx
$ knex migrate:make migration_name
# or for .ts
$ knex migrate:make migration_name -x ts