src/api/database/migrations/20210105222742_addStatisticsTable.js


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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');
};