directus

1
import type { Knex } from 'knex';
2
import { getHelpers } from '../helpers/index.js';
3

4
export async function up(knex: Knex): Promise<void> {
5
	const helper = getHelpers(knex).schema;
6

7
	await knex.schema.alterTable('directus_relations', (table) => {
8
		table.dropColumns('many_primary', 'one_primary');
9
		table.string('one_deselect_action').defaultTo('nullify');
10
	});
11

12
	await knex('directus_relations').update({ one_deselect_action: 'nullify' });
13

14
	await helper.changeToType('directus_relations', 'sort_field', 'string', {
15
		length: 64,
16
	});
17

18
	await helper.changeToType('directus_relations', 'one_deselect_action', 'string', {
19
		nullable: false,
20
		default: 'nullify',
21
	});
22
}
23

24
export async function down(knex: Knex): Promise<void> {
25
	const helper = getHelpers(knex).schema;
26

27
	await helper.changeToType('directus_relations', 'sort_field', 'string', {
28
		length: 255,
29
	});
30

31
	await knex.schema.alterTable('directus_relations', (table) => {
32
		table.dropColumn('one_deselect_action');
33
		table.string('many_primary', 64);
34
		table.string('one_primary', 64);
35
	});
36
}
37