bcgov/common-forms-toolkit

View on GitHub
app/src/db/migrations/20200519140119_005-settings-table.js

Summary

Maintainability
A
1 hr
Test Coverage
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`));
};