Method addColumnIndex

api/src/services/fields.ts:1022–1052

(
		collection: string,
		field: Field | RawField,
		options?: { attemptConcurrentIndex?: boolean; knex?: Knex; existing?: Column | null },
	)

	}

	public async addColumnIndex(
		collection: string,
		field: Field | RawField,
		options?: { attemptConcurrentIndex?: boolean; knex?: Knex; existing?: Column | null },
	): Promise<void> {
		const attemptConcurrentIndex = Boolean(options?.attemptConcurrentIndex);
		const knex = options?.knex ?? this.knex;
		const existing = options?.existing ?? null;

		// Don't attempt to index a DB column for alias / corrupt fields
		if (field.type === 'alias' || field.type === 'unknown') return;

		// primary key will already have unique/index constraints
		if (field.schema?.is_primary_key || existing?.is_primary_key) return;

		const helpers = getHelpers(knex);

		if (field.schema?.is_unique === true && (!existing || existing.is_unique == false)) {
			await helpers.schema.createIndex(collection, field.field, {
				unique: true,
				attemptConcurrentIndex,
			});
		}

		if (field.schema?.is_indexed === true && (!existing || existing.is_indexed === false)) {
			await helpers.schema.createIndex(collection, field.field, {
				unique: false,
				attemptConcurrentIndex,
			});
		}
	}
}