directus

1
import type { Knex } from 'knex';
2
import { getDefaultIndexName } from '../../utils/get-default-index-name.js';
3

4
const indexName = getDefaultIndexName('foreign', 'directus_settings', 'storage_default_folder');
5

6
export async function up(knex: Knex): Promise<void> {
7
	await knex.schema.alterTable('directus_settings', (table) => {
8
		table
9
			.uuid('storage_default_folder')
10
			.references('id')
11
			.inTable('directus_folders')
12
			.withKeyName(indexName)
13
			.onDelete('SET NULL');
14
	});
15
}
16

17
export async function down(knex: Knex): Promise<void> {
18
	await knex.schema.alterTable('directus_files', (table) => {
19
		table.dropForeign(['storage_default_folder'], indexName);
20
		table.dropColumn('storage_default_folder');
21
	});
22
}
23