feat: implement initial values and saving to db logic

1 files changed, 22 insertions, 2 deletions

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');
 	});
 };