Merge pull request #250 from Zephyrrus/feature/system_status_page

Feature/system status page

3 files changed, 19 insertions, 1 deletions

diff --git a/src/api/database/migrations/20190221225812_initialMigration.js b/src/api/database/migrations/20190221225812_initialMigration.js
index a27a08a..a6dcbe4 100644
--- a/src/api/database/migrations/20190221225812_initialMigration.js
+++ b/src/api/database/migrations/20190221225812_initialMigration.js
@@ -80,6 +80,7 @@ exports.up = async knex => {
 		table.timestamp('createdAt');
 	});
 };
+
 exports.down = async knex => {
 	await knex.schema.dropTableIfExists('users');
 	await knex.schema.dropTableIfExists('albums');
diff --git a/src/api/database/migrations/20201227023216_addUniques.js b/src/api/database/migrations/20201227023216_addUniques.js
index 14f9e7f..8292f15 100644
--- a/src/api/database/migrations/20201227023216_addUniques.js
+++ b/src/api/database/migrations/20201227023216_addUniques.js
@@ -28,6 +28,7 @@ exports.up = async knex => {
 		table.unique(['fileId', 'tagId']);
 	});
 };
-exports.down = async knex => {
+
+exports.down = async () => {
 	// Nothing
 };
diff --git a/src/api/database/migrations/20210105222742_addStatisticsTable.js b/src/api/database/migrations/20210105222742_addStatisticsTable.js
new file mode 100644
index 0000000..d920ac1
--- /dev/null
+++ b/src/api/database/migrations/20210105222742_addStatisticsTable.js
@@ -0,0 +1,16 @@
+
+exports.up = async knex => {
+	await knex.schema.createTable('statistics', table => {
+		table.increments();
+		table.integer('batchId');
+		table.string('type');
+		table.json('data');
+		table.timestamp('createdAt');
+
+		table.unique(['batchId', 'type']);
+	});
+};
+
+exports.down = async knex => {
+	await knex.schema.dropTableIfExists('statistics');
+};