Medplum

// SPDX-FileCopyrightText: Copyright Orangebot, Inc. and Medplum contributors // SPDX-License-Identifier: Apache-2.0 /* * Generated by @medplum/generator * Do not edit manually. */ import type { PoolClient } from 'pg'; const SIMPLE = 'simple'; const ENGLISH = 'english'; export async function run(client: PoolClient): Promise<void> { const fields = [ ['HumanName', 'name', SIMPLE], ['HumanName', 'given', SIMPLE], ['HumanName', 'family', SIMPLE], ['Address', 'address', SIMPLE], ['Address', 'city', SIMPLE], ['Address', 'country', SIMPLE], ['Address', 'postalCode', SIMPLE], ['Address', 'state', SIMPLE], ['Address', 'use', SIMPLE], ['ValueSetElement', 'display', ENGLISH], ]; for (const [table, column, lang] of fields) { await client.query( `CREATE INDEX CONCURRENTLY IF NOT EXISTS "${table}_idx_tsv" ON "${table}" USING gin (to_tsvector('${lang}', "${column}"))` ); } }