app/src/db/migrations/20200519140119_005-settings-table.js
const stamps = require('../stamps');
const PREFIX = require('../../forms/attestations/minesoperatorscreening/constants').PREFIX;
exports.up = function(knex) {
return Promise.resolve()
.then(() => knex.schema.createTable(`${PREFIX}_settings`, table => {
table.string('name').primary();
table.boolean('enabled').notNullable().defaultTo(true);
table.jsonb('config');
stamps(knex, table);
}));
};
exports.down = function(knex) {
return Promise.resolve()
.then(() => knex.schema.dropTableIfExists(`${PREFIX}_settings`));
};