directus

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

3
export async function up(knex: Knex): Promise<void> {
4
	await knex.schema.alterTable('directus_settings', (table) => {
5
		table.boolean('public_registration').notNullable().defaultTo(false);
6
		table.boolean('public_registration_verify_email').notNullable().defaultTo(true);
7
		table.uuid('public_registration_role').nullable();
8
		table.foreign('public_registration_role').references('directus_roles.id').onDelete('SET NULL');
9
		table.json('public_registration_email_filter').nullable();
10
	});
11
}
12

13
export async function down(knex: Knex): Promise<void> {
14
	await knex.schema.alterTable('directus_settings', (table) => {
15
		table.dropColumns(
16
			'public_registration',
17
			'public_registration_verify_email',
18
			'public_registration_role',
19
			'public_registration_email_filter',
20
		);
21
	});
22
}
23