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
	if (helper.isOneOfClients(['oracle', 'cockroachdb'])) {
8
		// Oracle and Cockroach are already not nullable due to an oversight in
9
		// "20201105B-change-webhook-url-type.ts"
10
		return;
11
	}
12

13
	await helper.changeToType('directus_webhooks', 'url', 'string', {
14
		nullable: false,
15
	});
16
}
17

18
export async function down(knex: Knex): Promise<void> {
19
	const helper = getHelpers(knex).schema;
20

21
	if (helper.isOneOfClients(['oracle', 'cockroachdb'])) {
22
		// Oracle and Cockroach are already not nullable due to an oversight in
23
		// "20201105B-change-webhook-url-type.ts"
24
		return;
25
	}
26

27
	await helper.changeToType('directus_webhooks', 'url', 'string');
28
}
29