src/api/database/migrations/20210112011802_addSettingsTable.js


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

exports.up = async knex => {
	await knex.schema.createTable('settings', table => {
		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');
	});
};

exports.down = async knex => {
	await knex.schema.dropTableIfExists('settings');
};