directus

1
import type { Knex } from 'knex';
2

3
export async function up(knex: Knex): Promise<void> {
4
	await knex.schema.createTable('directus_notifications', (table) => {
5
		table.increments();
6
		table.timestamp('timestamp').notNullable();
7
		table.string('status').defaultTo('inbox');
8
		table.uuid('recipient').notNullable().references('id').inTable('directus_users').onDelete('CASCADE');
9
		table.uuid('sender').notNullable().references('id').inTable('directus_users');
10
		table.string('subject').notNullable();
11
		table.text('message');
12
		table.string('collection', 64);
13
		table.string('item');
14
	});
15

16
	await knex.schema.alterTable('directus_users', (table) => {
17
		table.boolean('email_notifications').defaultTo(true);
18
	});
19

20
	await knex('directus_users').update({ email_notifications: true });
21
}
22

23
export async function down(knex: Knex): Promise<void> {
24
	await knex.schema.dropTable('directus_notifications');
25

26
	await knex.schema.alterTable('directus_users', (table) => {
27
		table.dropColumn('email_notifications');
28
	});
29
}
30