aboutsummaryrefslogtreecommitdiff
path: root/src/api/database
diff options
context:
space:
mode:
authorPitu <[email protected]>2021-03-23 22:35:29 +0900
committerPitu <[email protected]>2021-03-23 22:35:29 +0900
commit541bfedb924ba80f126236656713f769c2194ef2 (patch)
tree654876d29f1929b50ff9a19080e87db043bde471 /src/api/database
parentMerge branch 'feature/database_based_settings' of https://github.com/Zephyrru... (diff)
downloadhost.fuwn.me-541bfedb924ba80f126236656713f769c2194ef2.tar.xz
host.fuwn.me-541bfedb924ba80f126236656713f769c2194ef2.zip
wip
Diffstat (limited to 'src/api/database')
-rw-r--r--src/api/database/migrations/20210112011802_addSettingsTable.js10
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');
+};