Medplum

// SPDX-FileCopyrightText: Copyright Orangebot, Inc. and Medplum contributors // SPDX-License-Identifier: Apache-2.0 import type { PoolClient } from 'pg'; import { prepareCustomMigrationJobData, runCustomMigration } from '../../workers/post-deploy-migration'; import * as fns from '../migrate-functions'; import type { MigrationActionResult } from '../types'; import type { CustomPostDeployMigration } from './types'; export const migration: CustomPostDeployMigration = { type: 'custom', prepareJobData: (asyncJob) => prepareCustomMigrationJobData(asyncJob), run: async (repo, job, jobData) => runCustomMigration(repo, job, jobData, callback), }; // prettier-ignore async function callback(client: PoolClient, results: MigrationActionResult[]): Promise<void> { await fns.idempotentCreateIndex(client, results, 'Account___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Account___tokens_idx" ON "Account" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Account___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Account___tokensTrgm_idx" ON "Account" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ActivityDefinition___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ActivityDefinition___tokens_idx" ON "ActivityDefinition" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ActivityDefinition___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ActivityDefinition___tokensTrgm_idx" ON "ActivityDefinition" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'AdverseEvent___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "AdverseEvent___tokens_idx" ON "AdverseEvent" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'AdverseEvent___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "AdverseEvent___tokensTrgm_idx" ON "AdverseEvent" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'AllergyIntolerance___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "AllergyIntolerance___tokens_idx" ON "AllergyIntolerance" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'AllergyIntolerance___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "AllergyIntolerance___tokensTrgm_idx" ON "AllergyIntolerance" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Appointment___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Appointment___tokens_idx" ON "Appointment" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Appointment___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Appointment___tokensTrgm_idx" ON "Appointment" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'AppointmentResponse___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "AppointmentResponse___tokens_idx" ON "AppointmentResponse" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'AppointmentResponse___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "AppointmentResponse___tokensTrgm_idx" ON "AppointmentResponse" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'AuditEvent___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "AuditEvent___tokens_idx" ON "AuditEvent" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'AuditEvent___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "AuditEvent___tokensTrgm_idx" ON "AuditEvent" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Basic___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Basic___tokens_idx" ON "Basic" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Basic___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Basic___tokensTrgm_idx" ON "Basic" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Binary___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Binary___tokens_idx" ON "Binary" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Binary___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Binary___tokensTrgm_idx" ON "Binary" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'BiologicallyDerivedProduct___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "BiologicallyDerivedProduct___tokens_idx" ON "BiologicallyDerivedProduct" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'BiologicallyDerivedProduct___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "BiologicallyDerivedProduct___tokensTrgm_idx" ON "BiologicallyDerivedProduct" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'BodyStructure___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "BodyStructure___tokens_idx" ON "BodyStructure" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'BodyStructure___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "BodyStructure___tokensTrgm_idx" ON "BodyStructure" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Bundle___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Bundle___tokens_idx" ON "Bundle" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Bundle___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Bundle___tokensTrgm_idx" ON "Bundle" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'CapabilityStatement___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CapabilityStatement___tokens_idx" ON "CapabilityStatement" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'CapabilityStatement___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CapabilityStatement___tokensTrgm_idx" ON "CapabilityStatement" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'CarePlan___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CarePlan___tokens_idx" ON "CarePlan" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'CarePlan___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CarePlan___tokensTrgm_idx" ON "CarePlan" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'CareTeam___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CareTeam___tokens_idx" ON "CareTeam" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'CareTeam___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CareTeam___tokensTrgm_idx" ON "CareTeam" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'CatalogEntry___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CatalogEntry___tokens_idx" ON "CatalogEntry" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'CatalogEntry___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CatalogEntry___tokensTrgm_idx" ON "CatalogEntry" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ChargeItem___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ChargeItem___tokens_idx" ON "ChargeItem" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ChargeItem___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ChargeItem___tokensTrgm_idx" ON "ChargeItem" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ChargeItemDefinition___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ChargeItemDefinition___tokens_idx" ON "ChargeItemDefinition" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ChargeItemDefinition___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ChargeItemDefinition___tokensTrgm_idx" ON "ChargeItemDefinition" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Claim___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Claim___tokens_idx" ON "Claim" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Claim___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Claim___tokensTrgm_idx" ON "Claim" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ClaimResponse___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ClaimResponse___tokens_idx" ON "ClaimResponse" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ClaimResponse___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ClaimResponse___tokensTrgm_idx" ON "ClaimResponse" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ClinicalImpression___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ClinicalImpression___tokens_idx" ON "ClinicalImpression" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ClinicalImpression___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ClinicalImpression___tokensTrgm_idx" ON "ClinicalImpression" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'CodeSystem___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CodeSystem___tokens_idx" ON "CodeSystem" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'CodeSystem___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CodeSystem___tokensTrgm_idx" ON "CodeSystem" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Communication___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Communication___tokens_idx" ON "Communication" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Communication___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Communication___tokensTrgm_idx" ON "Communication" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'CommunicationRequest___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CommunicationRequest___tokens_idx" ON "CommunicationRequest" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'CommunicationRequest___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CommunicationRequest___tokensTrgm_idx" ON "CommunicationRequest" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'CompartmentDefinition___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CompartmentDefinition___tokens_idx" ON "CompartmentDefinition" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'CompartmentDefinition___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CompartmentDefinition___tokensTrgm_idx" ON "CompartmentDefinition" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Composition___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Composition___tokens_idx" ON "Composition" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Composition___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Composition___tokensTrgm_idx" ON "Composition" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ConceptMap___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ConceptMap___tokens_idx" ON "ConceptMap" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ConceptMap___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ConceptMap___tokensTrgm_idx" ON "ConceptMap" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Condition___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Condition___tokens_idx" ON "Condition" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Condition___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Condition___tokensTrgm_idx" ON "Condition" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Consent___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Consent___tokens_idx" ON "Consent" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Consent___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Consent___tokensTrgm_idx" ON "Consent" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Contract___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Contract___tokens_idx" ON "Contract" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Contract___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Contract___tokensTrgm_idx" ON "Contract" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Coverage___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Coverage___tokens_idx" ON "Coverage" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Coverage___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Coverage___tokensTrgm_idx" ON "Coverage" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'CoverageEligibilityRequest___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CoverageEligibilityRequest___tokens_idx" ON "CoverageEligibilityRequest" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'CoverageEligibilityRequest___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CoverageEligibilityRequest___tokensTrgm_idx" ON "CoverageEligibilityRequest" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'CoverageEligibilityResponse___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CoverageEligibilityResponse___tokens_idx" ON "CoverageEligibilityResponse" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'CoverageEligibilityResponse___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "CoverageEligibilityResponse___tokensTrgm_idx" ON "CoverageEligibilityResponse" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'DetectedIssue___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DetectedIssue___tokens_idx" ON "DetectedIssue" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'DetectedIssue___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DetectedIssue___tokensTrgm_idx" ON "DetectedIssue" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Device___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Device___tokens_idx" ON "Device" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Device___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Device___tokensTrgm_idx" ON "Device" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'DeviceDefinition___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DeviceDefinition___tokens_idx" ON "DeviceDefinition" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'DeviceDefinition___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DeviceDefinition___tokensTrgm_idx" ON "DeviceDefinition" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'DeviceMetric___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DeviceMetric___tokens_idx" ON "DeviceMetric" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'DeviceMetric___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DeviceMetric___tokensTrgm_idx" ON "DeviceMetric" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'DeviceRequest___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DeviceRequest___tokens_idx" ON "DeviceRequest" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'DeviceRequest___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DeviceRequest___tokensTrgm_idx" ON "DeviceRequest" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'DeviceUseStatement___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DeviceUseStatement___tokens_idx" ON "DeviceUseStatement" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'DeviceUseStatement___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DeviceUseStatement___tokensTrgm_idx" ON "DeviceUseStatement" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'DiagnosticReport___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DiagnosticReport___tokens_idx" ON "DiagnosticReport" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'DiagnosticReport___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DiagnosticReport___tokensTrgm_idx" ON "DiagnosticReport" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'DocumentManifest___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DocumentManifest___tokens_idx" ON "DocumentManifest" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'DocumentManifest___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DocumentManifest___tokensTrgm_idx" ON "DocumentManifest" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'DocumentReference___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DocumentReference___tokens_idx" ON "DocumentReference" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'DocumentReference___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DocumentReference___tokensTrgm_idx" ON "DocumentReference" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'EffectEvidenceSynthesis___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "EffectEvidenceSynthesis___tokens_idx" ON "EffectEvidenceSynthesis" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'EffectEvidenceSynthesis___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "EffectEvidenceSynthesis___tokensTrgm_idx" ON "EffectEvidenceSynthesis" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Encounter___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Encounter___tokens_idx" ON "Encounter" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Encounter___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Encounter___tokensTrgm_idx" ON "Encounter" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Endpoint___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Endpoint___tokens_idx" ON "Endpoint" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Endpoint___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Endpoint___tokensTrgm_idx" ON "Endpoint" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'EnrollmentRequest___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "EnrollmentRequest___tokens_idx" ON "EnrollmentRequest" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'EnrollmentRequest___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "EnrollmentRequest___tokensTrgm_idx" ON "EnrollmentRequest" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'EnrollmentResponse___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "EnrollmentResponse___tokens_idx" ON "EnrollmentResponse" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'EnrollmentResponse___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "EnrollmentResponse___tokensTrgm_idx" ON "EnrollmentResponse" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'EpisodeOfCare___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "EpisodeOfCare___tokens_idx" ON "EpisodeOfCare" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'EpisodeOfCare___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "EpisodeOfCare___tokensTrgm_idx" ON "EpisodeOfCare" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'EventDefinition___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "EventDefinition___tokens_idx" ON "EventDefinition" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'EventDefinition___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "EventDefinition___tokensTrgm_idx" ON "EventDefinition" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Evidence___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Evidence___tokens_idx" ON "Evidence" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Evidence___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Evidence___tokensTrgm_idx" ON "Evidence" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'EvidenceVariable___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "EvidenceVariable___tokens_idx" ON "EvidenceVariable" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'EvidenceVariable___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "EvidenceVariable___tokensTrgm_idx" ON "EvidenceVariable" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ExampleScenario___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ExampleScenario___tokens_idx" ON "ExampleScenario" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ExampleScenario___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ExampleScenario___tokensTrgm_idx" ON "ExampleScenario" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ExplanationOfBenefit___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ExplanationOfBenefit___tokens_idx" ON "ExplanationOfBenefit" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ExplanationOfBenefit___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ExplanationOfBenefit___tokensTrgm_idx" ON "ExplanationOfBenefit" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'FamilyMemberHistory___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "FamilyMemberHistory___tokens_idx" ON "FamilyMemberHistory" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'FamilyMemberHistory___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "FamilyMemberHistory___tokensTrgm_idx" ON "FamilyMemberHistory" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Flag___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Flag___tokens_idx" ON "Flag" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Flag___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Flag___tokensTrgm_idx" ON "Flag" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Goal___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Goal___tokens_idx" ON "Goal" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Goal___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Goal___tokensTrgm_idx" ON "Goal" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'GraphDefinition___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "GraphDefinition___tokens_idx" ON "GraphDefinition" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'GraphDefinition___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "GraphDefinition___tokensTrgm_idx" ON "GraphDefinition" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Group___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Group___tokens_idx" ON "Group" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Group___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Group___tokensTrgm_idx" ON "Group" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'GuidanceResponse___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "GuidanceResponse___tokens_idx" ON "GuidanceResponse" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'GuidanceResponse___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "GuidanceResponse___tokensTrgm_idx" ON "GuidanceResponse" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'HealthcareService___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "HealthcareService___tokens_idx" ON "HealthcareService" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'HealthcareService___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "HealthcareService___tokensTrgm_idx" ON "HealthcareService" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ImagingStudy___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ImagingStudy___tokens_idx" ON "ImagingStudy" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ImagingStudy___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ImagingStudy___tokensTrgm_idx" ON "ImagingStudy" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Immunization___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Immunization___tokens_idx" ON "Immunization" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Immunization___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Immunization___tokensTrgm_idx" ON "Immunization" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ImmunizationEvaluation___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ImmunizationEvaluation___tokens_idx" ON "ImmunizationEvaluation" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ImmunizationEvaluation___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ImmunizationEvaluation___tokensTrgm_idx" ON "ImmunizationEvaluation" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ImmunizationRecommendation___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ImmunizationRecommendation___tokens_idx" ON "ImmunizationRecommendation" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ImmunizationRecommendation___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ImmunizationRecommendation___tokensTrgm_idx" ON "ImmunizationRecommendation" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ImplementationGuide___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ImplementationGuide___tokens_idx" ON "ImplementationGuide" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ImplementationGuide___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ImplementationGuide___tokensTrgm_idx" ON "ImplementationGuide" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'InsurancePlan___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "InsurancePlan___tokens_idx" ON "InsurancePlan" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'InsurancePlan___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "InsurancePlan___tokensTrgm_idx" ON "InsurancePlan" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Invoice___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Invoice___tokens_idx" ON "Invoice" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Invoice___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Invoice___tokensTrgm_idx" ON "Invoice" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Library___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Library___tokens_idx" ON "Library" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Library___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Library___tokensTrgm_idx" ON "Library" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Linkage___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Linkage___tokens_idx" ON "Linkage" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Linkage___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Linkage___tokensTrgm_idx" ON "Linkage" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'List___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "List___tokens_idx" ON "List" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'List___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "List___tokensTrgm_idx" ON "List" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Location___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Location___tokens_idx" ON "Location" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Location___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Location___tokensTrgm_idx" ON "Location" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Measure___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Measure___tokens_idx" ON "Measure" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Measure___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Measure___tokensTrgm_idx" ON "Measure" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MeasureReport___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MeasureReport___tokens_idx" ON "MeasureReport" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MeasureReport___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MeasureReport___tokensTrgm_idx" ON "MeasureReport" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Media___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Media___tokens_idx" ON "Media" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Media___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Media___tokensTrgm_idx" ON "Media" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Medication___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Medication___tokens_idx" ON "Medication" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Medication___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Medication___tokensTrgm_idx" ON "Medication" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MedicationAdministration___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicationAdministration___tokens_idx" ON "MedicationAdministration" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MedicationAdministration___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicationAdministration___tokensTrgm_idx" ON "MedicationAdministration" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MedicationDispense___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicationDispense___tokens_idx" ON "MedicationDispense" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MedicationDispense___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicationDispense___tokensTrgm_idx" ON "MedicationDispense" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MedicationKnowledge___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicationKnowledge___tokens_idx" ON "MedicationKnowledge" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MedicationKnowledge___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicationKnowledge___tokensTrgm_idx" ON "MedicationKnowledge" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MedicationRequest___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicationRequest___tokens_idx" ON "MedicationRequest" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MedicationRequest___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicationRequest___tokensTrgm_idx" ON "MedicationRequest" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MedicationStatement___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicationStatement___tokens_idx" ON "MedicationStatement" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MedicationStatement___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicationStatement___tokensTrgm_idx" ON "MedicationStatement" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MedicinalProduct___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicinalProduct___tokens_idx" ON "MedicinalProduct" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MedicinalProduct___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicinalProduct___tokensTrgm_idx" ON "MedicinalProduct" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MPA___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MPA___tokens_idx" ON "MedicinalProductAuthorization" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MPA___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MPA___tokensTrgm_idx" ON "MedicinalProductAuthorization" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MPC___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MPC___tokens_idx" ON "MedicinalProductContraindication" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MPC___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MPC___tokensTrgm_idx" ON "MedicinalProductContraindication" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MedicinalProductIndication___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicinalProductIndication___tokens_idx" ON "MedicinalProductIndication" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MedicinalProductIndication___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicinalProductIndication___tokensTrgm_idx" ON "MedicinalProductIndication" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MedicinalProductIngredient___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicinalProductIngredient___tokens_idx" ON "MedicinalProductIngredient" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MedicinalProductIngredient___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicinalProductIngredient___tokensTrgm_idx" ON "MedicinalProductIngredient" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MedicinalProductInteraction___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicinalProductInteraction___tokens_idx" ON "MedicinalProductInteraction" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MedicinalProductInteraction___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicinalProductInteraction___tokensTrgm_idx" ON "MedicinalProductInteraction" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MedicinalProductManufactured___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicinalProductManufactured___tokens_idx" ON "MedicinalProductManufactured" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MedicinalProductManufactured___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicinalProductManufactured___tokensTrgm_idx" ON "MedicinalProductManufactured" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MedicinalProductPackaged___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicinalProductPackaged___tokens_idx" ON "MedicinalProductPackaged" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MedicinalProductPackaged___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MedicinalProductPackaged___tokensTrgm_idx" ON "MedicinalProductPackaged" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MPP___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MPP___tokens_idx" ON "MedicinalProductPharmaceutical" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MPP___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MPP___tokensTrgm_idx" ON "MedicinalProductPharmaceutical" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MPUE___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MPUE___tokens_idx" ON "MedicinalProductUndesirableEffect" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MPUE___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MPUE___tokensTrgm_idx" ON "MedicinalProductUndesirableEffect" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MessageDefinition___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MessageDefinition___tokens_idx" ON "MessageDefinition" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MessageDefinition___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MessageDefinition___tokensTrgm_idx" ON "MessageDefinition" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MessageHeader___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MessageHeader___tokens_idx" ON "MessageHeader" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MessageHeader___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MessageHeader___tokensTrgm_idx" ON "MessageHeader" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'MolecularSequence___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MolecularSequence___tokens_idx" ON "MolecularSequence" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'MolecularSequence___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "MolecularSequence___tokensTrgm_idx" ON "MolecularSequence" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'NamingSystem___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "NamingSystem___tokens_idx" ON "NamingSystem" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'NamingSystem___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "NamingSystem___tokensTrgm_idx" ON "NamingSystem" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'NutritionOrder___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "NutritionOrder___tokens_idx" ON "NutritionOrder" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'NutritionOrder___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "NutritionOrder___tokensTrgm_idx" ON "NutritionOrder" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Observation___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Observation___tokens_idx" ON "Observation" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Observation___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Observation___tokensTrgm_idx" ON "Observation" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ObservationDefinition___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ObservationDefinition___tokens_idx" ON "ObservationDefinition" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ObservationDefinition___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ObservationDefinition___tokensTrgm_idx" ON "ObservationDefinition" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'OperationDefinition___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "OperationDefinition___tokens_idx" ON "OperationDefinition" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'OperationDefinition___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "OperationDefinition___tokensTrgm_idx" ON "OperationDefinition" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'OperationOutcome___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "OperationOutcome___tokens_idx" ON "OperationOutcome" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'OperationOutcome___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "OperationOutcome___tokensTrgm_idx" ON "OperationOutcome" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Organization___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Organization___tokens_idx" ON "Organization" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Organization___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Organization___tokensTrgm_idx" ON "Organization" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'OrganizationAffiliation___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "OrganizationAffiliation___tokens_idx" ON "OrganizationAffiliation" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'OrganizationAffiliation___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "OrganizationAffiliation___tokensTrgm_idx" ON "OrganizationAffiliation" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Parameters___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Parameters___tokens_idx" ON "Parameters" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Parameters___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Parameters___tokensTrgm_idx" ON "Parameters" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Patient___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Patient___tokens_idx" ON "Patient" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Patient___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Patient___tokensTrgm_idx" ON "Patient" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'PaymentNotice___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "PaymentNotice___tokens_idx" ON "PaymentNotice" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'PaymentNotice___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "PaymentNotice___tokensTrgm_idx" ON "PaymentNotice" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'PaymentReconciliation___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "PaymentReconciliation___tokens_idx" ON "PaymentReconciliation" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'PaymentReconciliation___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "PaymentReconciliation___tokensTrgm_idx" ON "PaymentReconciliation" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Person___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Person___tokens_idx" ON "Person" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Person___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Person___tokensTrgm_idx" ON "Person" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'PlanDefinition___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "PlanDefinition___tokens_idx" ON "PlanDefinition" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'PlanDefinition___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "PlanDefinition___tokensTrgm_idx" ON "PlanDefinition" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Practitioner___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Practitioner___tokens_idx" ON "Practitioner" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Practitioner___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Practitioner___tokensTrgm_idx" ON "Practitioner" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'PractitionerRole___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "PractitionerRole___tokens_idx" ON "PractitionerRole" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'PractitionerRole___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "PractitionerRole___tokensTrgm_idx" ON "PractitionerRole" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Procedure___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Procedure___tokens_idx" ON "Procedure" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Procedure___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Procedure___tokensTrgm_idx" ON "Procedure" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Provenance___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Provenance___tokens_idx" ON "Provenance" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Provenance___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Provenance___tokensTrgm_idx" ON "Provenance" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Questionnaire___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Questionnaire___tokens_idx" ON "Questionnaire" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Questionnaire___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Questionnaire___tokensTrgm_idx" ON "Questionnaire" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'QuestionnaireResponse___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "QuestionnaireResponse___tokens_idx" ON "QuestionnaireResponse" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'QuestionnaireResponse___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "QuestionnaireResponse___tokensTrgm_idx" ON "QuestionnaireResponse" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'RelatedPerson___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "RelatedPerson___tokens_idx" ON "RelatedPerson" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'RelatedPerson___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "RelatedPerson___tokensTrgm_idx" ON "RelatedPerson" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'RequestGroup___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "RequestGroup___tokens_idx" ON "RequestGroup" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'RequestGroup___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "RequestGroup___tokensTrgm_idx" ON "RequestGroup" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ResearchDefinition___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ResearchDefinition___tokens_idx" ON "ResearchDefinition" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ResearchDefinition___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ResearchDefinition___tokensTrgm_idx" ON "ResearchDefinition" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ResearchElementDefinition___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ResearchElementDefinition___tokens_idx" ON "ResearchElementDefinition" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ResearchElementDefinition___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ResearchElementDefinition___tokensTrgm_idx" ON "ResearchElementDefinition" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ResearchStudy___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ResearchStudy___tokens_idx" ON "ResearchStudy" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ResearchStudy___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ResearchStudy___tokensTrgm_idx" ON "ResearchStudy" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ResearchSubject___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ResearchSubject___tokens_idx" ON "ResearchSubject" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ResearchSubject___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ResearchSubject___tokensTrgm_idx" ON "ResearchSubject" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'RiskAssessment___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "RiskAssessment___tokens_idx" ON "RiskAssessment" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'RiskAssessment___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "RiskAssessment___tokensTrgm_idx" ON "RiskAssessment" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'RiskEvidenceSynthesis___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "RiskEvidenceSynthesis___tokens_idx" ON "RiskEvidenceSynthesis" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'RiskEvidenceSynthesis___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "RiskEvidenceSynthesis___tokensTrgm_idx" ON "RiskEvidenceSynthesis" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Schedule___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Schedule___tokens_idx" ON "Schedule" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Schedule___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Schedule___tokensTrgm_idx" ON "Schedule" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'SearchParameter___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SearchParameter___tokens_idx" ON "SearchParameter" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'SearchParameter___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SearchParameter___tokensTrgm_idx" ON "SearchParameter" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ServiceRequest___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ServiceRequest___tokens_idx" ON "ServiceRequest" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ServiceRequest___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ServiceRequest___tokensTrgm_idx" ON "ServiceRequest" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Slot___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Slot___tokens_idx" ON "Slot" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Slot___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Slot___tokensTrgm_idx" ON "Slot" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Specimen___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Specimen___tokens_idx" ON "Specimen" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Specimen___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Specimen___tokensTrgm_idx" ON "Specimen" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'SpecimenDefinition___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SpecimenDefinition___tokens_idx" ON "SpecimenDefinition" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'SpecimenDefinition___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SpecimenDefinition___tokensTrgm_idx" ON "SpecimenDefinition" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'StructureDefinition___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "StructureDefinition___tokens_idx" ON "StructureDefinition" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'StructureDefinition___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "StructureDefinition___tokensTrgm_idx" ON "StructureDefinition" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'StructureMap___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "StructureMap___tokens_idx" ON "StructureMap" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'StructureMap___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "StructureMap___tokensTrgm_idx" ON "StructureMap" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Subscription___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Subscription___tokens_idx" ON "Subscription" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Subscription___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Subscription___tokensTrgm_idx" ON "Subscription" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'SubscriptionStatus___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SubscriptionStatus___tokens_idx" ON "SubscriptionStatus" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'SubscriptionStatus___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SubscriptionStatus___tokensTrgm_idx" ON "SubscriptionStatus" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Substance___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Substance___tokens_idx" ON "Substance" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Substance___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Substance___tokensTrgm_idx" ON "Substance" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'SubstanceNucleicAcid___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SubstanceNucleicAcid___tokens_idx" ON "SubstanceNucleicAcid" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'SubstanceNucleicAcid___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SubstanceNucleicAcid___tokensTrgm_idx" ON "SubstanceNucleicAcid" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'SubstancePolymer___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SubstancePolymer___tokens_idx" ON "SubstancePolymer" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'SubstancePolymer___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SubstancePolymer___tokensTrgm_idx" ON "SubstancePolymer" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'SubstanceProtein___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SubstanceProtein___tokens_idx" ON "SubstanceProtein" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'SubstanceProtein___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SubstanceProtein___tokensTrgm_idx" ON "SubstanceProtein" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'SubstanceReferenceInformation___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SubstanceReferenceInformation___tokens_idx" ON "SubstanceReferenceInformation" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'SubstanceReferenceInformation___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SubstanceReferenceInformation___tokensTrgm_idx" ON "SubstanceReferenceInformation" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'SubstanceSourceMaterial___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SubstanceSourceMaterial___tokens_idx" ON "SubstanceSourceMaterial" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'SubstanceSourceMaterial___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SubstanceSourceMaterial___tokensTrgm_idx" ON "SubstanceSourceMaterial" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'SubstanceSpecification___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SubstanceSpecification___tokens_idx" ON "SubstanceSpecification" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'SubstanceSpecification___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SubstanceSpecification___tokensTrgm_idx" ON "SubstanceSpecification" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'SupplyDelivery___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SupplyDelivery___tokens_idx" ON "SupplyDelivery" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'SupplyDelivery___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SupplyDelivery___tokensTrgm_idx" ON "SupplyDelivery" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'SupplyRequest___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SupplyRequest___tokens_idx" ON "SupplyRequest" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'SupplyRequest___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SupplyRequest___tokensTrgm_idx" ON "SupplyRequest" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Task___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Task___tokens_idx" ON "Task" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Task___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Task___tokensTrgm_idx" ON "Task" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'TerminologyCapabilities___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "TerminologyCapabilities___tokens_idx" ON "TerminologyCapabilities" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'TerminologyCapabilities___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "TerminologyCapabilities___tokensTrgm_idx" ON "TerminologyCapabilities" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'TestReport___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "TestReport___tokens_idx" ON "TestReport" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'TestReport___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "TestReport___tokensTrgm_idx" ON "TestReport" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'TestScript___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "TestScript___tokens_idx" ON "TestScript" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'TestScript___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "TestScript___tokensTrgm_idx" ON "TestScript" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ValueSet___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ValueSet___tokens_idx" ON "ValueSet" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ValueSet___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ValueSet___tokensTrgm_idx" ON "ValueSet" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'VerificationResult___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "VerificationResult___tokens_idx" ON "VerificationResult" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'VerificationResult___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "VerificationResult___tokensTrgm_idx" ON "VerificationResult" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'VisionPrescription___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "VisionPrescription___tokens_idx" ON "VisionPrescription" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'VisionPrescription___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "VisionPrescription___tokensTrgm_idx" ON "VisionPrescription" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Project___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Project___tokens_idx" ON "Project" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Project___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Project___tokensTrgm_idx" ON "Project" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ClientApplication___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ClientApplication___tokens_idx" ON "ClientApplication" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ClientApplication___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ClientApplication___tokensTrgm_idx" ON "ClientApplication" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'User___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "User___tokens_idx" ON "User" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'User___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "User___tokensTrgm_idx" ON "User" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'ProjectMembership___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ProjectMembership___tokens_idx" ON "ProjectMembership" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'ProjectMembership___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ProjectMembership___tokensTrgm_idx" ON "ProjectMembership" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Bot___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Bot___tokens_idx" ON "Bot" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Bot___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Bot___tokensTrgm_idx" ON "Bot" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Login___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Login___tokens_idx" ON "Login" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Login___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Login___tokensTrgm_idx" ON "Login" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'PasswordChangeRequest___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "PasswordChangeRequest___tokens_idx" ON "PasswordChangeRequest" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'PasswordChangeRequest___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "PasswordChangeRequest___tokensTrgm_idx" ON "PasswordChangeRequest" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'UserSecurityRequest___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "UserSecurityRequest___tokens_idx" ON "UserSecurityRequest" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'UserSecurityRequest___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "UserSecurityRequest___tokensTrgm_idx" ON "UserSecurityRequest" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'JsonWebKey___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "JsonWebKey___tokens_idx" ON "JsonWebKey" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'JsonWebKey___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "JsonWebKey___tokensTrgm_idx" ON "JsonWebKey" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'AccessPolicy___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "AccessPolicy___tokens_idx" ON "AccessPolicy" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'AccessPolicy___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "AccessPolicy___tokensTrgm_idx" ON "AccessPolicy" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'UserConfiguration___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "UserConfiguration___tokens_idx" ON "UserConfiguration" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'UserConfiguration___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "UserConfiguration___tokensTrgm_idx" ON "UserConfiguration" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'BulkDataExport___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "BulkDataExport___tokens_idx" ON "BulkDataExport" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'BulkDataExport___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "BulkDataExport___tokensTrgm_idx" ON "BulkDataExport" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'SmartAppLaunch___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SmartAppLaunch___tokens_idx" ON "SmartAppLaunch" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'SmartAppLaunch___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "SmartAppLaunch___tokensTrgm_idx" ON "SmartAppLaunch" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'DomainConfiguration___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DomainConfiguration___tokens_idx" ON "DomainConfiguration" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'DomainConfiguration___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "DomainConfiguration___tokensTrgm_idx" ON "DomainConfiguration" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'AsyncJob___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "AsyncJob___tokens_idx" ON "AsyncJob" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'AsyncJob___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "AsyncJob___tokensTrgm_idx" ON "AsyncJob" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); await fns.idempotentCreateIndex(client, results, 'Agent___tokens_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Agent___tokens_idx" ON "Agent" USING gin ("__tokens")'); await fns.idempotentCreateIndex(client, results, 'Agent___tokensTrgm_idx', 'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Agent___tokensTrgm_idx" ON "Agent" USING gin (token_array_to_text("__tokensText") gin_trgm_ops)'); }