1 files changed, 16 insertions, 0 deletions
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');
+};