From 541bfedb924ba80f126236656713f769c2194ef2 Mon Sep 17 00:00:00 2001 From: Pitu Date: Tue, 23 Mar 2021 22:35:29 +0900 Subject: wip --- src/api/database/migrations/20210112011802_addSettingsTable.js | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 src/api/database/migrations/20210112011802_addSettingsTable.js (limited to 'src/api/database') 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'); +}; -- cgit v1.2.3