From 3f223a9dbfd3f79c1a8f01c6a95d14035cddeefe Mon Sep 17 00:00:00 2001 From: Pitu Date: Thu, 25 Mar 2021 02:03:57 +0900 Subject: feat: implement initial values and saving to db logic --- .../migrations/20210112011802_addSettingsTable.js | 24 ++++++++++++++++++++-- 1 file changed, 22 insertions(+), 2 deletions(-) (limited to 'src/api/database/migrations') diff --git a/src/api/database/migrations/20210112011802_addSettingsTable.js b/src/api/database/migrations/20210112011802_addSettingsTable.js index 2708352..3acd845 100644 --- a/src/api/database/migrations/20210112011802_addSettingsTable.js +++ b/src/api/database/migrations/20210112011802_addSettingsTable.js @@ -1,7 +1,27 @@ exports.up = async knex => { await knex.schema.createTable('settings', table => { - table.string('key').unique(); - table.json('value').notNullable(); + table.string('routePrefix'); + table.integer('rateLimitWindow'); + table.integer('rateLimitMax'); + table.string('secret'); + table.string('serviceName'); + table.string('domain'); + table.integer('chunkSize'); + table.integer('maxSize'); + table.boolean('generateZips'); + table.integer('generatedFilenameLength'); + table.integer('generatedAlbumLength'); + table.integer('maxLinksPerAlbum'); + table.string('uploadFolder'); + table.json('blockedExtensions'); + table.boolean('publicMode'); + table.boolean('userAccounts'); + table.string('adminAccount'); + table.string('adminPassword'); + table.string('metaThemeColor'); + table.string('metaDescription'); + table.string('metaKeywords'); + table.string('metaTwitterHandle'); }); }; -- cgit v1.2.3