diff options
Diffstat (limited to 'src/api/database/migrations')
| -rw-r--r-- | src/api/database/migrations/20210112011802_addSettingsTable.js | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/src/api/database/migrations/20210112011802_addSettingsTable.js b/src/api/database/migrations/20210112011802_addSettingsTable.js new file mode 100644 index 0000000..2708352 --- /dev/null +++ b/src/api/database/migrations/20210112011802_addSettingsTable.js @@ -0,0 +1,10 @@ +exports.up = async knex => { + await knex.schema.createTable('settings', table => { + table.string('key').unique(); + table.json('value').notNullable(); + }); +}; + +exports.down = async knex => { + await knex.schema.dropTableIfExists('settings'); +}; |