This is the template project that's checked out and configured when you run the bando-up command from ljsthw-bandolier. This is where the code really lives.
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
bandolier-template/migrations/20210407193844_initial.cjs

19 lines
564 B

exports.up = async (knex) => {
// enable the WAL in sqlite3
await knex.raw('PRAGMA journal_mode=WAL;');
return knex.schema.createTable('user', (table) => {
table.timestamps(true, true);
table.increments('id');
table.string('initials').notNullable();
table.string('full_name').notNullable();
table.string('password').notNullable();
table.boolean('admin').defaultTo(false);
table.string('email').notNullable().unique();
table.index('email');
});
};
exports.down = function(knex) {
return knex.schema.dropTable('user');
};