Skip to main content
Glama
medplum

Medplum

Official
by medplum
OverviewSchemaRelated ServersScoreDiscussions
TypeScript
Hybrid
v30.ts•102 kB
// 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'; export async function run(client: PoolClient): Promise<void> { await client.query('ALTER TABLE "Account" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Account" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Account" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Account" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Account" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Account" USING GIN("_security")'); await client.query('CREATE INDEX ON "Account" ("_source")'); await client.query('CREATE INDEX ON "Account" USING GIN("_tag")'); await client.query('ALTER TABLE "ActivityDefinition" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ActivityDefinition" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ActivityDefinition" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ActivityDefinition" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ActivityDefinition" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ActivityDefinition" USING GIN("_security")'); await client.query('CREATE INDEX ON "ActivityDefinition" ("_source")'); await client.query('CREATE INDEX ON "ActivityDefinition" USING GIN("_tag")'); await client.query('ALTER TABLE "AdverseEvent" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "AdverseEvent" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "AdverseEvent" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "AdverseEvent" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "AdverseEvent" USING GIN("_profile")'); await client.query('CREATE INDEX ON "AdverseEvent" USING GIN("_security")'); await client.query('CREATE INDEX ON "AdverseEvent" ("_source")'); await client.query('CREATE INDEX ON "AdverseEvent" USING GIN("_tag")'); await client.query('ALTER TABLE "AllergyIntolerance" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "AllergyIntolerance" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "AllergyIntolerance" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "AllergyIntolerance" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "AllergyIntolerance" USING GIN("_profile")'); await client.query('CREATE INDEX ON "AllergyIntolerance" USING GIN("_security")'); await client.query('CREATE INDEX ON "AllergyIntolerance" ("_source")'); await client.query('CREATE INDEX ON "AllergyIntolerance" USING GIN("_tag")'); await client.query('ALTER TABLE "Appointment" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Appointment" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Appointment" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Appointment" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Appointment" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Appointment" USING GIN("_security")'); await client.query('CREATE INDEX ON "Appointment" ("_source")'); await client.query('CREATE INDEX ON "Appointment" USING GIN("_tag")'); await client.query('ALTER TABLE "AppointmentResponse" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "AppointmentResponse" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "AppointmentResponse" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "AppointmentResponse" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "AppointmentResponse" USING GIN("_profile")'); await client.query('CREATE INDEX ON "AppointmentResponse" USING GIN("_security")'); await client.query('CREATE INDEX ON "AppointmentResponse" ("_source")'); await client.query('CREATE INDEX ON "AppointmentResponse" USING GIN("_tag")'); await client.query('ALTER TABLE "AuditEvent" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "AuditEvent" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "AuditEvent" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "AuditEvent" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "AuditEvent" USING GIN("_profile")'); await client.query('CREATE INDEX ON "AuditEvent" USING GIN("_security")'); await client.query('CREATE INDEX ON "AuditEvent" ("_source")'); await client.query('CREATE INDEX ON "AuditEvent" USING GIN("_tag")'); await client.query('ALTER TABLE "Basic" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Basic" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Basic" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Basic" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Basic" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Basic" USING GIN("_security")'); await client.query('CREATE INDEX ON "Basic" ("_source")'); await client.query('CREATE INDEX ON "Basic" USING GIN("_tag")'); await client.query('ALTER TABLE "Binary" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Binary" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Binary" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Binary" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Binary" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Binary" USING GIN("_security")'); await client.query('CREATE INDEX ON "Binary" ("_source")'); await client.query('CREATE INDEX ON "Binary" USING GIN("_tag")'); await client.query('ALTER TABLE "BiologicallyDerivedProduct" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "BiologicallyDerivedProduct" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "BiologicallyDerivedProduct" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "BiologicallyDerivedProduct" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "BiologicallyDerivedProduct" USING GIN("_profile")'); await client.query('CREATE INDEX ON "BiologicallyDerivedProduct" USING GIN("_security")'); await client.query('CREATE INDEX ON "BiologicallyDerivedProduct" ("_source")'); await client.query('CREATE INDEX ON "BiologicallyDerivedProduct" USING GIN("_tag")'); await client.query('ALTER TABLE "BodyStructure" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "BodyStructure" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "BodyStructure" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "BodyStructure" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "BodyStructure" USING GIN("_profile")'); await client.query('CREATE INDEX ON "BodyStructure" USING GIN("_security")'); await client.query('CREATE INDEX ON "BodyStructure" ("_source")'); await client.query('CREATE INDEX ON "BodyStructure" USING GIN("_tag")'); await client.query('ALTER TABLE "Bundle" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Bundle" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Bundle" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Bundle" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Bundle" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Bundle" USING GIN("_security")'); await client.query('CREATE INDEX ON "Bundle" ("_source")'); await client.query('CREATE INDEX ON "Bundle" USING GIN("_tag")'); await client.query('ALTER TABLE "CapabilityStatement" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "CapabilityStatement" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "CapabilityStatement" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "CapabilityStatement" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "CapabilityStatement" USING GIN("_profile")'); await client.query('CREATE INDEX ON "CapabilityStatement" USING GIN("_security")'); await client.query('CREATE INDEX ON "CapabilityStatement" ("_source")'); await client.query('CREATE INDEX ON "CapabilityStatement" USING GIN("_tag")'); await client.query('ALTER TABLE "CarePlan" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "CarePlan" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "CarePlan" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "CarePlan" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "CarePlan" USING GIN("_profile")'); await client.query('CREATE INDEX ON "CarePlan" USING GIN("_security")'); await client.query('CREATE INDEX ON "CarePlan" ("_source")'); await client.query('CREATE INDEX ON "CarePlan" USING GIN("_tag")'); await client.query('ALTER TABLE "CareTeam" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "CareTeam" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "CareTeam" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "CareTeam" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "CareTeam" USING GIN("_profile")'); await client.query('CREATE INDEX ON "CareTeam" USING GIN("_security")'); await client.query('CREATE INDEX ON "CareTeam" ("_source")'); await client.query('CREATE INDEX ON "CareTeam" USING GIN("_tag")'); await client.query('ALTER TABLE "CatalogEntry" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "CatalogEntry" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "CatalogEntry" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "CatalogEntry" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "CatalogEntry" USING GIN("_profile")'); await client.query('CREATE INDEX ON "CatalogEntry" USING GIN("_security")'); await client.query('CREATE INDEX ON "CatalogEntry" ("_source")'); await client.query('CREATE INDEX ON "CatalogEntry" USING GIN("_tag")'); await client.query('ALTER TABLE "ChargeItem" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ChargeItem" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ChargeItem" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ChargeItem" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ChargeItem" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ChargeItem" USING GIN("_security")'); await client.query('CREATE INDEX ON "ChargeItem" ("_source")'); await client.query('CREATE INDEX ON "ChargeItem" USING GIN("_tag")'); await client.query('ALTER TABLE "ChargeItemDefinition" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ChargeItemDefinition" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ChargeItemDefinition" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ChargeItemDefinition" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ChargeItemDefinition" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ChargeItemDefinition" USING GIN("_security")'); await client.query('CREATE INDEX ON "ChargeItemDefinition" ("_source")'); await client.query('CREATE INDEX ON "ChargeItemDefinition" USING GIN("_tag")'); await client.query('ALTER TABLE "Claim" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Claim" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Claim" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Claim" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Claim" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Claim" USING GIN("_security")'); await client.query('CREATE INDEX ON "Claim" ("_source")'); await client.query('CREATE INDEX ON "Claim" USING GIN("_tag")'); await client.query('ALTER TABLE "ClaimResponse" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ClaimResponse" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ClaimResponse" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ClaimResponse" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ClaimResponse" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ClaimResponse" USING GIN("_security")'); await client.query('CREATE INDEX ON "ClaimResponse" ("_source")'); await client.query('CREATE INDEX ON "ClaimResponse" USING GIN("_tag")'); await client.query('ALTER TABLE "ClinicalImpression" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ClinicalImpression" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ClinicalImpression" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ClinicalImpression" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ClinicalImpression" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ClinicalImpression" USING GIN("_security")'); await client.query('CREATE INDEX ON "ClinicalImpression" ("_source")'); await client.query('CREATE INDEX ON "ClinicalImpression" USING GIN("_tag")'); await client.query('ALTER TABLE "CodeSystem" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "CodeSystem" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "CodeSystem" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "CodeSystem" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "CodeSystem" USING GIN("_profile")'); await client.query('CREATE INDEX ON "CodeSystem" USING GIN("_security")'); await client.query('CREATE INDEX ON "CodeSystem" ("_source")'); await client.query('CREATE INDEX ON "CodeSystem" USING GIN("_tag")'); await client.query('ALTER TABLE "Communication" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Communication" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Communication" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Communication" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Communication" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Communication" USING GIN("_security")'); await client.query('CREATE INDEX ON "Communication" ("_source")'); await client.query('CREATE INDEX ON "Communication" USING GIN("_tag")'); await client.query('ALTER TABLE "CommunicationRequest" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "CommunicationRequest" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "CommunicationRequest" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "CommunicationRequest" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "CommunicationRequest" USING GIN("_profile")'); await client.query('CREATE INDEX ON "CommunicationRequest" USING GIN("_security")'); await client.query('CREATE INDEX ON "CommunicationRequest" ("_source")'); await client.query('CREATE INDEX ON "CommunicationRequest" USING GIN("_tag")'); await client.query('ALTER TABLE "CompartmentDefinition" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "CompartmentDefinition" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "CompartmentDefinition" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "CompartmentDefinition" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "CompartmentDefinition" USING GIN("_profile")'); await client.query('CREATE INDEX ON "CompartmentDefinition" USING GIN("_security")'); await client.query('CREATE INDEX ON "CompartmentDefinition" ("_source")'); await client.query('CREATE INDEX ON "CompartmentDefinition" USING GIN("_tag")'); await client.query('ALTER TABLE "Composition" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Composition" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Composition" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Composition" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Composition" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Composition" USING GIN("_security")'); await client.query('CREATE INDEX ON "Composition" ("_source")'); await client.query('CREATE INDEX ON "Composition" USING GIN("_tag")'); await client.query('ALTER TABLE "ConceptMap" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ConceptMap" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ConceptMap" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ConceptMap" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ConceptMap" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ConceptMap" USING GIN("_security")'); await client.query('CREATE INDEX ON "ConceptMap" ("_source")'); await client.query('CREATE INDEX ON "ConceptMap" USING GIN("_tag")'); await client.query('ALTER TABLE "Condition" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Condition" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Condition" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Condition" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Condition" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Condition" USING GIN("_security")'); await client.query('CREATE INDEX ON "Condition" ("_source")'); await client.query('CREATE INDEX ON "Condition" USING GIN("_tag")'); await client.query('ALTER TABLE "Consent" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Consent" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Consent" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Consent" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Consent" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Consent" USING GIN("_security")'); await client.query('CREATE INDEX ON "Consent" ("_source")'); await client.query('CREATE INDEX ON "Consent" USING GIN("_tag")'); await client.query('ALTER TABLE "Contract" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Contract" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Contract" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Contract" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Contract" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Contract" USING GIN("_security")'); await client.query('CREATE INDEX ON "Contract" ("_source")'); await client.query('CREATE INDEX ON "Contract" USING GIN("_tag")'); await client.query('ALTER TABLE "Coverage" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Coverage" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Coverage" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Coverage" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Coverage" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Coverage" USING GIN("_security")'); await client.query('CREATE INDEX ON "Coverage" ("_source")'); await client.query('CREATE INDEX ON "Coverage" USING GIN("_tag")'); await client.query('ALTER TABLE "CoverageEligibilityRequest" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "CoverageEligibilityRequest" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "CoverageEligibilityRequest" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "CoverageEligibilityRequest" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "CoverageEligibilityRequest" USING GIN("_profile")'); await client.query('CREATE INDEX ON "CoverageEligibilityRequest" USING GIN("_security")'); await client.query('CREATE INDEX ON "CoverageEligibilityRequest" ("_source")'); await client.query('CREATE INDEX ON "CoverageEligibilityRequest" USING GIN("_tag")'); await client.query('ALTER TABLE "CoverageEligibilityResponse" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "CoverageEligibilityResponse" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "CoverageEligibilityResponse" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "CoverageEligibilityResponse" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "CoverageEligibilityResponse" USING GIN("_profile")'); await client.query('CREATE INDEX ON "CoverageEligibilityResponse" USING GIN("_security")'); await client.query('CREATE INDEX ON "CoverageEligibilityResponse" ("_source")'); await client.query('CREATE INDEX ON "CoverageEligibilityResponse" USING GIN("_tag")'); await client.query('ALTER TABLE "DetectedIssue" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "DetectedIssue" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "DetectedIssue" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "DetectedIssue" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "DetectedIssue" USING GIN("_profile")'); await client.query('CREATE INDEX ON "DetectedIssue" USING GIN("_security")'); await client.query('CREATE INDEX ON "DetectedIssue" ("_source")'); await client.query('CREATE INDEX ON "DetectedIssue" USING GIN("_tag")'); await client.query('ALTER TABLE "Device" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Device" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Device" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Device" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Device" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Device" USING GIN("_security")'); await client.query('CREATE INDEX ON "Device" ("_source")'); await client.query('CREATE INDEX ON "Device" USING GIN("_tag")'); await client.query('ALTER TABLE "DeviceDefinition" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "DeviceDefinition" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "DeviceDefinition" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "DeviceDefinition" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "DeviceDefinition" USING GIN("_profile")'); await client.query('CREATE INDEX ON "DeviceDefinition" USING GIN("_security")'); await client.query('CREATE INDEX ON "DeviceDefinition" ("_source")'); await client.query('CREATE INDEX ON "DeviceDefinition" USING GIN("_tag")'); await client.query('ALTER TABLE "DeviceMetric" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "DeviceMetric" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "DeviceMetric" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "DeviceMetric" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "DeviceMetric" USING GIN("_profile")'); await client.query('CREATE INDEX ON "DeviceMetric" USING GIN("_security")'); await client.query('CREATE INDEX ON "DeviceMetric" ("_source")'); await client.query('CREATE INDEX ON "DeviceMetric" USING GIN("_tag")'); await client.query('ALTER TABLE "DeviceRequest" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "DeviceRequest" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "DeviceRequest" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "DeviceRequest" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "DeviceRequest" USING GIN("_profile")'); await client.query('CREATE INDEX ON "DeviceRequest" USING GIN("_security")'); await client.query('CREATE INDEX ON "DeviceRequest" ("_source")'); await client.query('CREATE INDEX ON "DeviceRequest" USING GIN("_tag")'); await client.query('ALTER TABLE "DeviceUseStatement" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "DeviceUseStatement" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "DeviceUseStatement" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "DeviceUseStatement" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "DeviceUseStatement" USING GIN("_profile")'); await client.query('CREATE INDEX ON "DeviceUseStatement" USING GIN("_security")'); await client.query('CREATE INDEX ON "DeviceUseStatement" ("_source")'); await client.query('CREATE INDEX ON "DeviceUseStatement" USING GIN("_tag")'); await client.query('ALTER TABLE "DiagnosticReport" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "DiagnosticReport" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "DiagnosticReport" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "DiagnosticReport" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "DiagnosticReport" USING GIN("_profile")'); await client.query('CREATE INDEX ON "DiagnosticReport" USING GIN("_security")'); await client.query('CREATE INDEX ON "DiagnosticReport" ("_source")'); await client.query('CREATE INDEX ON "DiagnosticReport" USING GIN("_tag")'); await client.query('ALTER TABLE "DocumentManifest" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "DocumentManifest" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "DocumentManifest" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "DocumentManifest" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "DocumentManifest" USING GIN("_profile")'); await client.query('CREATE INDEX ON "DocumentManifest" USING GIN("_security")'); await client.query('CREATE INDEX ON "DocumentManifest" ("_source")'); await client.query('CREATE INDEX ON "DocumentManifest" USING GIN("_tag")'); await client.query('ALTER TABLE "DocumentReference" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "DocumentReference" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "DocumentReference" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "DocumentReference" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "DocumentReference" USING GIN("_profile")'); await client.query('CREATE INDEX ON "DocumentReference" USING GIN("_security")'); await client.query('CREATE INDEX ON "DocumentReference" ("_source")'); await client.query('CREATE INDEX ON "DocumentReference" USING GIN("_tag")'); await client.query('ALTER TABLE "EffectEvidenceSynthesis" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "EffectEvidenceSynthesis" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "EffectEvidenceSynthesis" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "EffectEvidenceSynthesis" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "EffectEvidenceSynthesis" USING GIN("_profile")'); await client.query('CREATE INDEX ON "EffectEvidenceSynthesis" USING GIN("_security")'); await client.query('CREATE INDEX ON "EffectEvidenceSynthesis" ("_source")'); await client.query('CREATE INDEX ON "EffectEvidenceSynthesis" USING GIN("_tag")'); await client.query('ALTER TABLE "Encounter" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Encounter" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Encounter" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Encounter" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Encounter" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Encounter" USING GIN("_security")'); await client.query('CREATE INDEX ON "Encounter" ("_source")'); await client.query('CREATE INDEX ON "Encounter" USING GIN("_tag")'); await client.query('ALTER TABLE "Endpoint" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Endpoint" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Endpoint" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Endpoint" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Endpoint" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Endpoint" USING GIN("_security")'); await client.query('CREATE INDEX ON "Endpoint" ("_source")'); await client.query('CREATE INDEX ON "Endpoint" USING GIN("_tag")'); await client.query('ALTER TABLE "EnrollmentRequest" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "EnrollmentRequest" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "EnrollmentRequest" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "EnrollmentRequest" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "EnrollmentRequest" USING GIN("_profile")'); await client.query('CREATE INDEX ON "EnrollmentRequest" USING GIN("_security")'); await client.query('CREATE INDEX ON "EnrollmentRequest" ("_source")'); await client.query('CREATE INDEX ON "EnrollmentRequest" USING GIN("_tag")'); await client.query('ALTER TABLE "EnrollmentResponse" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "EnrollmentResponse" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "EnrollmentResponse" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "EnrollmentResponse" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "EnrollmentResponse" USING GIN("_profile")'); await client.query('CREATE INDEX ON "EnrollmentResponse" USING GIN("_security")'); await client.query('CREATE INDEX ON "EnrollmentResponse" ("_source")'); await client.query('CREATE INDEX ON "EnrollmentResponse" USING GIN("_tag")'); await client.query('ALTER TABLE "EpisodeOfCare" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "EpisodeOfCare" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "EpisodeOfCare" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "EpisodeOfCare" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "EpisodeOfCare" USING GIN("_profile")'); await client.query('CREATE INDEX ON "EpisodeOfCare" USING GIN("_security")'); await client.query('CREATE INDEX ON "EpisodeOfCare" ("_source")'); await client.query('CREATE INDEX ON "EpisodeOfCare" USING GIN("_tag")'); await client.query('ALTER TABLE "EventDefinition" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "EventDefinition" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "EventDefinition" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "EventDefinition" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "EventDefinition" USING GIN("_profile")'); await client.query('CREATE INDEX ON "EventDefinition" USING GIN("_security")'); await client.query('CREATE INDEX ON "EventDefinition" ("_source")'); await client.query('CREATE INDEX ON "EventDefinition" USING GIN("_tag")'); await client.query('ALTER TABLE "Evidence" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Evidence" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Evidence" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Evidence" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Evidence" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Evidence" USING GIN("_security")'); await client.query('CREATE INDEX ON "Evidence" ("_source")'); await client.query('CREATE INDEX ON "Evidence" USING GIN("_tag")'); await client.query('ALTER TABLE "EvidenceVariable" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "EvidenceVariable" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "EvidenceVariable" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "EvidenceVariable" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "EvidenceVariable" USING GIN("_profile")'); await client.query('CREATE INDEX ON "EvidenceVariable" USING GIN("_security")'); await client.query('CREATE INDEX ON "EvidenceVariable" ("_source")'); await client.query('CREATE INDEX ON "EvidenceVariable" USING GIN("_tag")'); await client.query('ALTER TABLE "ExampleScenario" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ExampleScenario" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ExampleScenario" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ExampleScenario" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ExampleScenario" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ExampleScenario" USING GIN("_security")'); await client.query('CREATE INDEX ON "ExampleScenario" ("_source")'); await client.query('CREATE INDEX ON "ExampleScenario" USING GIN("_tag")'); await client.query('ALTER TABLE "ExplanationOfBenefit" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ExplanationOfBenefit" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ExplanationOfBenefit" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ExplanationOfBenefit" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ExplanationOfBenefit" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ExplanationOfBenefit" USING GIN("_security")'); await client.query('CREATE INDEX ON "ExplanationOfBenefit" ("_source")'); await client.query('CREATE INDEX ON "ExplanationOfBenefit" USING GIN("_tag")'); await client.query('ALTER TABLE "FamilyMemberHistory" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "FamilyMemberHistory" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "FamilyMemberHistory" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "FamilyMemberHistory" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "FamilyMemberHistory" USING GIN("_profile")'); await client.query('CREATE INDEX ON "FamilyMemberHistory" USING GIN("_security")'); await client.query('CREATE INDEX ON "FamilyMemberHistory" ("_source")'); await client.query('CREATE INDEX ON "FamilyMemberHistory" USING GIN("_tag")'); await client.query('ALTER TABLE "Flag" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Flag" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Flag" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Flag" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Flag" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Flag" USING GIN("_security")'); await client.query('CREATE INDEX ON "Flag" ("_source")'); await client.query('CREATE INDEX ON "Flag" USING GIN("_tag")'); await client.query('ALTER TABLE "Goal" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Goal" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Goal" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Goal" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Goal" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Goal" USING GIN("_security")'); await client.query('CREATE INDEX ON "Goal" ("_source")'); await client.query('CREATE INDEX ON "Goal" USING GIN("_tag")'); await client.query('ALTER TABLE "GraphDefinition" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "GraphDefinition" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "GraphDefinition" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "GraphDefinition" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "GraphDefinition" USING GIN("_profile")'); await client.query('CREATE INDEX ON "GraphDefinition" USING GIN("_security")'); await client.query('CREATE INDEX ON "GraphDefinition" ("_source")'); await client.query('CREATE INDEX ON "GraphDefinition" USING GIN("_tag")'); await client.query('ALTER TABLE "Group" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Group" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Group" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Group" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Group" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Group" USING GIN("_security")'); await client.query('CREATE INDEX ON "Group" ("_source")'); await client.query('CREATE INDEX ON "Group" USING GIN("_tag")'); await client.query('ALTER TABLE "GuidanceResponse" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "GuidanceResponse" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "GuidanceResponse" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "GuidanceResponse" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "GuidanceResponse" USING GIN("_profile")'); await client.query('CREATE INDEX ON "GuidanceResponse" USING GIN("_security")'); await client.query('CREATE INDEX ON "GuidanceResponse" ("_source")'); await client.query('CREATE INDEX ON "GuidanceResponse" USING GIN("_tag")'); await client.query('ALTER TABLE "HealthcareService" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "HealthcareService" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "HealthcareService" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "HealthcareService" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "HealthcareService" USING GIN("_profile")'); await client.query('CREATE INDEX ON "HealthcareService" USING GIN("_security")'); await client.query('CREATE INDEX ON "HealthcareService" ("_source")'); await client.query('CREATE INDEX ON "HealthcareService" USING GIN("_tag")'); await client.query('ALTER TABLE "ImagingStudy" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ImagingStudy" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ImagingStudy" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ImagingStudy" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ImagingStudy" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ImagingStudy" USING GIN("_security")'); await client.query('CREATE INDEX ON "ImagingStudy" ("_source")'); await client.query('CREATE INDEX ON "ImagingStudy" USING GIN("_tag")'); await client.query('ALTER TABLE "Immunization" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Immunization" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Immunization" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Immunization" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Immunization" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Immunization" USING GIN("_security")'); await client.query('CREATE INDEX ON "Immunization" ("_source")'); await client.query('CREATE INDEX ON "Immunization" USING GIN("_tag")'); await client.query('ALTER TABLE "ImmunizationEvaluation" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ImmunizationEvaluation" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ImmunizationEvaluation" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ImmunizationEvaluation" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ImmunizationEvaluation" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ImmunizationEvaluation" USING GIN("_security")'); await client.query('CREATE INDEX ON "ImmunizationEvaluation" ("_source")'); await client.query('CREATE INDEX ON "ImmunizationEvaluation" USING GIN("_tag")'); await client.query('ALTER TABLE "ImmunizationRecommendation" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ImmunizationRecommendation" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ImmunizationRecommendation" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ImmunizationRecommendation" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ImmunizationRecommendation" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ImmunizationRecommendation" USING GIN("_security")'); await client.query('CREATE INDEX ON "ImmunizationRecommendation" ("_source")'); await client.query('CREATE INDEX ON "ImmunizationRecommendation" USING GIN("_tag")'); await client.query('ALTER TABLE "ImplementationGuide" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ImplementationGuide" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ImplementationGuide" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ImplementationGuide" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ImplementationGuide" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ImplementationGuide" USING GIN("_security")'); await client.query('CREATE INDEX ON "ImplementationGuide" ("_source")'); await client.query('CREATE INDEX ON "ImplementationGuide" USING GIN("_tag")'); await client.query('ALTER TABLE "InsurancePlan" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "InsurancePlan" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "InsurancePlan" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "InsurancePlan" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "InsurancePlan" USING GIN("_profile")'); await client.query('CREATE INDEX ON "InsurancePlan" USING GIN("_security")'); await client.query('CREATE INDEX ON "InsurancePlan" ("_source")'); await client.query('CREATE INDEX ON "InsurancePlan" USING GIN("_tag")'); await client.query('ALTER TABLE "Invoice" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Invoice" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Invoice" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Invoice" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Invoice" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Invoice" USING GIN("_security")'); await client.query('CREATE INDEX ON "Invoice" ("_source")'); await client.query('CREATE INDEX ON "Invoice" USING GIN("_tag")'); await client.query('ALTER TABLE "Library" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Library" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Library" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Library" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Library" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Library" USING GIN("_security")'); await client.query('CREATE INDEX ON "Library" ("_source")'); await client.query('CREATE INDEX ON "Library" USING GIN("_tag")'); await client.query('ALTER TABLE "Linkage" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Linkage" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Linkage" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Linkage" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Linkage" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Linkage" USING GIN("_security")'); await client.query('CREATE INDEX ON "Linkage" ("_source")'); await client.query('CREATE INDEX ON "Linkage" USING GIN("_tag")'); await client.query('ALTER TABLE "List" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "List" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "List" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "List" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "List" USING GIN("_profile")'); await client.query('CREATE INDEX ON "List" USING GIN("_security")'); await client.query('CREATE INDEX ON "List" ("_source")'); await client.query('CREATE INDEX ON "List" USING GIN("_tag")'); await client.query('ALTER TABLE "Location" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Location" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Location" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Location" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Location" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Location" USING GIN("_security")'); await client.query('CREATE INDEX ON "Location" ("_source")'); await client.query('CREATE INDEX ON "Location" USING GIN("_tag")'); await client.query('ALTER TABLE "Measure" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Measure" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Measure" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Measure" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Measure" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Measure" USING GIN("_security")'); await client.query('CREATE INDEX ON "Measure" ("_source")'); await client.query('CREATE INDEX ON "Measure" USING GIN("_tag")'); await client.query('ALTER TABLE "MeasureReport" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MeasureReport" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MeasureReport" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MeasureReport" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MeasureReport" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MeasureReport" USING GIN("_security")'); await client.query('CREATE INDEX ON "MeasureReport" ("_source")'); await client.query('CREATE INDEX ON "MeasureReport" USING GIN("_tag")'); await client.query('ALTER TABLE "Media" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Media" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Media" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Media" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Media" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Media" USING GIN("_security")'); await client.query('CREATE INDEX ON "Media" ("_source")'); await client.query('CREATE INDEX ON "Media" USING GIN("_tag")'); await client.query('ALTER TABLE "Medication" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Medication" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Medication" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Medication" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Medication" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Medication" USING GIN("_security")'); await client.query('CREATE INDEX ON "Medication" ("_source")'); await client.query('CREATE INDEX ON "Medication" USING GIN("_tag")'); await client.query('ALTER TABLE "MedicationAdministration" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MedicationAdministration" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MedicationAdministration" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MedicationAdministration" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MedicationAdministration" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MedicationAdministration" USING GIN("_security")'); await client.query('CREATE INDEX ON "MedicationAdministration" ("_source")'); await client.query('CREATE INDEX ON "MedicationAdministration" USING GIN("_tag")'); await client.query('ALTER TABLE "MedicationDispense" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MedicationDispense" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MedicationDispense" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MedicationDispense" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MedicationDispense" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MedicationDispense" USING GIN("_security")'); await client.query('CREATE INDEX ON "MedicationDispense" ("_source")'); await client.query('CREATE INDEX ON "MedicationDispense" USING GIN("_tag")'); await client.query('ALTER TABLE "MedicationKnowledge" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MedicationKnowledge" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MedicationKnowledge" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MedicationKnowledge" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MedicationKnowledge" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MedicationKnowledge" USING GIN("_security")'); await client.query('CREATE INDEX ON "MedicationKnowledge" ("_source")'); await client.query('CREATE INDEX ON "MedicationKnowledge" USING GIN("_tag")'); await client.query('ALTER TABLE "MedicationRequest" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MedicationRequest" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MedicationRequest" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MedicationRequest" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MedicationRequest" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MedicationRequest" USING GIN("_security")'); await client.query('CREATE INDEX ON "MedicationRequest" ("_source")'); await client.query('CREATE INDEX ON "MedicationRequest" USING GIN("_tag")'); await client.query('ALTER TABLE "MedicationStatement" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MedicationStatement" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MedicationStatement" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MedicationStatement" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MedicationStatement" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MedicationStatement" USING GIN("_security")'); await client.query('CREATE INDEX ON "MedicationStatement" ("_source")'); await client.query('CREATE INDEX ON "MedicationStatement" USING GIN("_tag")'); await client.query('ALTER TABLE "MedicinalProduct" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MedicinalProduct" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MedicinalProduct" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MedicinalProduct" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MedicinalProduct" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MedicinalProduct" USING GIN("_security")'); await client.query('CREATE INDEX ON "MedicinalProduct" ("_source")'); await client.query('CREATE INDEX ON "MedicinalProduct" USING GIN("_tag")'); await client.query('ALTER TABLE "MedicinalProductAuthorization" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductAuthorization" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductAuthorization" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MedicinalProductAuthorization" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MedicinalProductAuthorization" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MedicinalProductAuthorization" USING GIN("_security")'); await client.query('CREATE INDEX ON "MedicinalProductAuthorization" ("_source")'); await client.query('CREATE INDEX ON "MedicinalProductAuthorization" USING GIN("_tag")'); await client.query('ALTER TABLE "MedicinalProductContraindication" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductContraindication" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductContraindication" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MedicinalProductContraindication" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MedicinalProductContraindication" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MedicinalProductContraindication" USING GIN("_security")'); await client.query('CREATE INDEX ON "MedicinalProductContraindication" ("_source")'); await client.query('CREATE INDEX ON "MedicinalProductContraindication" USING GIN("_tag")'); await client.query('ALTER TABLE "MedicinalProductIndication" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductIndication" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductIndication" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MedicinalProductIndication" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MedicinalProductIndication" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MedicinalProductIndication" USING GIN("_security")'); await client.query('CREATE INDEX ON "MedicinalProductIndication" ("_source")'); await client.query('CREATE INDEX ON "MedicinalProductIndication" USING GIN("_tag")'); await client.query('ALTER TABLE "MedicinalProductIngredient" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductIngredient" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductIngredient" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MedicinalProductIngredient" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MedicinalProductIngredient" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MedicinalProductIngredient" USING GIN("_security")'); await client.query('CREATE INDEX ON "MedicinalProductIngredient" ("_source")'); await client.query('CREATE INDEX ON "MedicinalProductIngredient" USING GIN("_tag")'); await client.query('ALTER TABLE "MedicinalProductInteraction" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductInteraction" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductInteraction" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MedicinalProductInteraction" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MedicinalProductInteraction" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MedicinalProductInteraction" USING GIN("_security")'); await client.query('CREATE INDEX ON "MedicinalProductInteraction" ("_source")'); await client.query('CREATE INDEX ON "MedicinalProductInteraction" USING GIN("_tag")'); await client.query('ALTER TABLE "MedicinalProductManufactured" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductManufactured" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductManufactured" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MedicinalProductManufactured" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MedicinalProductManufactured" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MedicinalProductManufactured" USING GIN("_security")'); await client.query('CREATE INDEX ON "MedicinalProductManufactured" ("_source")'); await client.query('CREATE INDEX ON "MedicinalProductManufactured" USING GIN("_tag")'); await client.query('ALTER TABLE "MedicinalProductPackaged" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductPackaged" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductPackaged" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MedicinalProductPackaged" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MedicinalProductPackaged" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MedicinalProductPackaged" USING GIN("_security")'); await client.query('CREATE INDEX ON "MedicinalProductPackaged" ("_source")'); await client.query('CREATE INDEX ON "MedicinalProductPackaged" USING GIN("_tag")'); await client.query('ALTER TABLE "MedicinalProductPharmaceutical" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductPharmaceutical" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductPharmaceutical" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MedicinalProductPharmaceutical" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MedicinalProductPharmaceutical" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MedicinalProductPharmaceutical" USING GIN("_security")'); await client.query('CREATE INDEX ON "MedicinalProductPharmaceutical" ("_source")'); await client.query('CREATE INDEX ON "MedicinalProductPharmaceutical" USING GIN("_tag")'); await client.query('ALTER TABLE "MedicinalProductUndesirableEffect" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductUndesirableEffect" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MedicinalProductUndesirableEffect" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MedicinalProductUndesirableEffect" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MedicinalProductUndesirableEffect" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MedicinalProductUndesirableEffect" USING GIN("_security")'); await client.query('CREATE INDEX ON "MedicinalProductUndesirableEffect" ("_source")'); await client.query('CREATE INDEX ON "MedicinalProductUndesirableEffect" USING GIN("_tag")'); await client.query('ALTER TABLE "MessageDefinition" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MessageDefinition" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MessageDefinition" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MessageDefinition" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MessageDefinition" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MessageDefinition" USING GIN("_security")'); await client.query('CREATE INDEX ON "MessageDefinition" ("_source")'); await client.query('CREATE INDEX ON "MessageDefinition" USING GIN("_tag")'); await client.query('ALTER TABLE "MessageHeader" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MessageHeader" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MessageHeader" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MessageHeader" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MessageHeader" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MessageHeader" USING GIN("_security")'); await client.query('CREATE INDEX ON "MessageHeader" ("_source")'); await client.query('CREATE INDEX ON "MessageHeader" USING GIN("_tag")'); await client.query('ALTER TABLE "MolecularSequence" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "MolecularSequence" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "MolecularSequence" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "MolecularSequence" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "MolecularSequence" USING GIN("_profile")'); await client.query('CREATE INDEX ON "MolecularSequence" USING GIN("_security")'); await client.query('CREATE INDEX ON "MolecularSequence" ("_source")'); await client.query('CREATE INDEX ON "MolecularSequence" USING GIN("_tag")'); await client.query('ALTER TABLE "NamingSystem" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "NamingSystem" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "NamingSystem" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "NamingSystem" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "NamingSystem" USING GIN("_profile")'); await client.query('CREATE INDEX ON "NamingSystem" USING GIN("_security")'); await client.query('CREATE INDEX ON "NamingSystem" ("_source")'); await client.query('CREATE INDEX ON "NamingSystem" USING GIN("_tag")'); await client.query('ALTER TABLE "NutritionOrder" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "NutritionOrder" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "NutritionOrder" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "NutritionOrder" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "NutritionOrder" USING GIN("_profile")'); await client.query('CREATE INDEX ON "NutritionOrder" USING GIN("_security")'); await client.query('CREATE INDEX ON "NutritionOrder" ("_source")'); await client.query('CREATE INDEX ON "NutritionOrder" USING GIN("_tag")'); await client.query('ALTER TABLE "Observation" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Observation" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Observation" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Observation" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Observation" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Observation" USING GIN("_security")'); await client.query('CREATE INDEX ON "Observation" ("_source")'); await client.query('CREATE INDEX ON "Observation" USING GIN("_tag")'); await client.query('ALTER TABLE "ObservationDefinition" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ObservationDefinition" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ObservationDefinition" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ObservationDefinition" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ObservationDefinition" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ObservationDefinition" USING GIN("_security")'); await client.query('CREATE INDEX ON "ObservationDefinition" ("_source")'); await client.query('CREATE INDEX ON "ObservationDefinition" USING GIN("_tag")'); await client.query('ALTER TABLE "OperationDefinition" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "OperationDefinition" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "OperationDefinition" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "OperationDefinition" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "OperationDefinition" USING GIN("_profile")'); await client.query('CREATE INDEX ON "OperationDefinition" USING GIN("_security")'); await client.query('CREATE INDEX ON "OperationDefinition" ("_source")'); await client.query('CREATE INDEX ON "OperationDefinition" USING GIN("_tag")'); await client.query('ALTER TABLE "OperationOutcome" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "OperationOutcome" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "OperationOutcome" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "OperationOutcome" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "OperationOutcome" USING GIN("_profile")'); await client.query('CREATE INDEX ON "OperationOutcome" USING GIN("_security")'); await client.query('CREATE INDEX ON "OperationOutcome" ("_source")'); await client.query('CREATE INDEX ON "OperationOutcome" USING GIN("_tag")'); await client.query('ALTER TABLE "Organization" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Organization" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Organization" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Organization" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Organization" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Organization" USING GIN("_security")'); await client.query('CREATE INDEX ON "Organization" ("_source")'); await client.query('CREATE INDEX ON "Organization" USING GIN("_tag")'); await client.query('ALTER TABLE "OrganizationAffiliation" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "OrganizationAffiliation" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "OrganizationAffiliation" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "OrganizationAffiliation" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "OrganizationAffiliation" USING GIN("_profile")'); await client.query('CREATE INDEX ON "OrganizationAffiliation" USING GIN("_security")'); await client.query('CREATE INDEX ON "OrganizationAffiliation" ("_source")'); await client.query('CREATE INDEX ON "OrganizationAffiliation" USING GIN("_tag")'); await client.query('ALTER TABLE "Parameters" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Parameters" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Parameters" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Parameters" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Parameters" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Parameters" USING GIN("_security")'); await client.query('CREATE INDEX ON "Parameters" ("_source")'); await client.query('CREATE INDEX ON "Parameters" USING GIN("_tag")'); await client.query('ALTER TABLE "Patient" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Patient" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Patient" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Patient" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Patient" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Patient" USING GIN("_security")'); await client.query('CREATE INDEX ON "Patient" ("_source")'); await client.query('CREATE INDEX ON "Patient" USING GIN("_tag")'); await client.query('ALTER TABLE "PaymentNotice" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "PaymentNotice" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "PaymentNotice" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "PaymentNotice" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "PaymentNotice" USING GIN("_profile")'); await client.query('CREATE INDEX ON "PaymentNotice" USING GIN("_security")'); await client.query('CREATE INDEX ON "PaymentNotice" ("_source")'); await client.query('CREATE INDEX ON "PaymentNotice" USING GIN("_tag")'); await client.query('ALTER TABLE "PaymentReconciliation" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "PaymentReconciliation" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "PaymentReconciliation" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "PaymentReconciliation" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "PaymentReconciliation" USING GIN("_profile")'); await client.query('CREATE INDEX ON "PaymentReconciliation" USING GIN("_security")'); await client.query('CREATE INDEX ON "PaymentReconciliation" ("_source")'); await client.query('CREATE INDEX ON "PaymentReconciliation" USING GIN("_tag")'); await client.query('ALTER TABLE "Person" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Person" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Person" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Person" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Person" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Person" USING GIN("_security")'); await client.query('CREATE INDEX ON "Person" ("_source")'); await client.query('CREATE INDEX ON "Person" USING GIN("_tag")'); await client.query('ALTER TABLE "PlanDefinition" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "PlanDefinition" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "PlanDefinition" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "PlanDefinition" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "PlanDefinition" USING GIN("_profile")'); await client.query('CREATE INDEX ON "PlanDefinition" USING GIN("_security")'); await client.query('CREATE INDEX ON "PlanDefinition" ("_source")'); await client.query('CREATE INDEX ON "PlanDefinition" USING GIN("_tag")'); await client.query('ALTER TABLE "Practitioner" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Practitioner" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Practitioner" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Practitioner" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Practitioner" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Practitioner" USING GIN("_security")'); await client.query('CREATE INDEX ON "Practitioner" ("_source")'); await client.query('CREATE INDEX ON "Practitioner" USING GIN("_tag")'); await client.query('ALTER TABLE "PractitionerRole" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "PractitionerRole" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "PractitionerRole" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "PractitionerRole" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "PractitionerRole" USING GIN("_profile")'); await client.query('CREATE INDEX ON "PractitionerRole" USING GIN("_security")'); await client.query('CREATE INDEX ON "PractitionerRole" ("_source")'); await client.query('CREATE INDEX ON "PractitionerRole" USING GIN("_tag")'); await client.query('ALTER TABLE "Procedure" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Procedure" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Procedure" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Procedure" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Procedure" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Procedure" USING GIN("_security")'); await client.query('CREATE INDEX ON "Procedure" ("_source")'); await client.query('CREATE INDEX ON "Procedure" USING GIN("_tag")'); await client.query('ALTER TABLE "Provenance" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Provenance" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Provenance" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Provenance" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Provenance" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Provenance" USING GIN("_security")'); await client.query('CREATE INDEX ON "Provenance" ("_source")'); await client.query('CREATE INDEX ON "Provenance" USING GIN("_tag")'); await client.query('ALTER TABLE "Questionnaire" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Questionnaire" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Questionnaire" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Questionnaire" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Questionnaire" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Questionnaire" USING GIN("_security")'); await client.query('CREATE INDEX ON "Questionnaire" ("_source")'); await client.query('CREATE INDEX ON "Questionnaire" USING GIN("_tag")'); await client.query('ALTER TABLE "QuestionnaireResponse" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "QuestionnaireResponse" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "QuestionnaireResponse" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "QuestionnaireResponse" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "QuestionnaireResponse" USING GIN("_profile")'); await client.query('CREATE INDEX ON "QuestionnaireResponse" USING GIN("_security")'); await client.query('CREATE INDEX ON "QuestionnaireResponse" ("_source")'); await client.query('CREATE INDEX ON "QuestionnaireResponse" USING GIN("_tag")'); await client.query('ALTER TABLE "RelatedPerson" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "RelatedPerson" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "RelatedPerson" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "RelatedPerson" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "RelatedPerson" USING GIN("_profile")'); await client.query('CREATE INDEX ON "RelatedPerson" USING GIN("_security")'); await client.query('CREATE INDEX ON "RelatedPerson" ("_source")'); await client.query('CREATE INDEX ON "RelatedPerson" USING GIN("_tag")'); await client.query('ALTER TABLE "RequestGroup" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "RequestGroup" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "RequestGroup" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "RequestGroup" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "RequestGroup" USING GIN("_profile")'); await client.query('CREATE INDEX ON "RequestGroup" USING GIN("_security")'); await client.query('CREATE INDEX ON "RequestGroup" ("_source")'); await client.query('CREATE INDEX ON "RequestGroup" USING GIN("_tag")'); await client.query('ALTER TABLE "ResearchDefinition" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ResearchDefinition" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ResearchDefinition" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ResearchDefinition" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ResearchDefinition" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ResearchDefinition" USING GIN("_security")'); await client.query('CREATE INDEX ON "ResearchDefinition" ("_source")'); await client.query('CREATE INDEX ON "ResearchDefinition" USING GIN("_tag")'); await client.query('ALTER TABLE "ResearchElementDefinition" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ResearchElementDefinition" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ResearchElementDefinition" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ResearchElementDefinition" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ResearchElementDefinition" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ResearchElementDefinition" USING GIN("_security")'); await client.query('CREATE INDEX ON "ResearchElementDefinition" ("_source")'); await client.query('CREATE INDEX ON "ResearchElementDefinition" USING GIN("_tag")'); await client.query('ALTER TABLE "ResearchStudy" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ResearchStudy" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ResearchStudy" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ResearchStudy" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ResearchStudy" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ResearchStudy" USING GIN("_security")'); await client.query('CREATE INDEX ON "ResearchStudy" ("_source")'); await client.query('CREATE INDEX ON "ResearchStudy" USING GIN("_tag")'); await client.query('ALTER TABLE "ResearchSubject" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ResearchSubject" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ResearchSubject" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ResearchSubject" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ResearchSubject" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ResearchSubject" USING GIN("_security")'); await client.query('CREATE INDEX ON "ResearchSubject" ("_source")'); await client.query('CREATE INDEX ON "ResearchSubject" USING GIN("_tag")'); await client.query('ALTER TABLE "RiskAssessment" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "RiskAssessment" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "RiskAssessment" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "RiskAssessment" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "RiskAssessment" USING GIN("_profile")'); await client.query('CREATE INDEX ON "RiskAssessment" USING GIN("_security")'); await client.query('CREATE INDEX ON "RiskAssessment" ("_source")'); await client.query('CREATE INDEX ON "RiskAssessment" USING GIN("_tag")'); await client.query('ALTER TABLE "RiskEvidenceSynthesis" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "RiskEvidenceSynthesis" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "RiskEvidenceSynthesis" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "RiskEvidenceSynthesis" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "RiskEvidenceSynthesis" USING GIN("_profile")'); await client.query('CREATE INDEX ON "RiskEvidenceSynthesis" USING GIN("_security")'); await client.query('CREATE INDEX ON "RiskEvidenceSynthesis" ("_source")'); await client.query('CREATE INDEX ON "RiskEvidenceSynthesis" USING GIN("_tag")'); await client.query('ALTER TABLE "Schedule" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Schedule" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Schedule" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Schedule" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Schedule" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Schedule" USING GIN("_security")'); await client.query('CREATE INDEX ON "Schedule" ("_source")'); await client.query('CREATE INDEX ON "Schedule" USING GIN("_tag")'); await client.query('ALTER TABLE "SearchParameter" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "SearchParameter" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "SearchParameter" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "SearchParameter" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "SearchParameter" USING GIN("_profile")'); await client.query('CREATE INDEX ON "SearchParameter" USING GIN("_security")'); await client.query('CREATE INDEX ON "SearchParameter" ("_source")'); await client.query('CREATE INDEX ON "SearchParameter" USING GIN("_tag")'); await client.query('ALTER TABLE "ServiceRequest" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ServiceRequest" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ServiceRequest" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ServiceRequest" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ServiceRequest" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ServiceRequest" USING GIN("_security")'); await client.query('CREATE INDEX ON "ServiceRequest" ("_source")'); await client.query('CREATE INDEX ON "ServiceRequest" USING GIN("_tag")'); await client.query('ALTER TABLE "Slot" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Slot" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Slot" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Slot" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Slot" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Slot" USING GIN("_security")'); await client.query('CREATE INDEX ON "Slot" ("_source")'); await client.query('CREATE INDEX ON "Slot" USING GIN("_tag")'); await client.query('ALTER TABLE "Specimen" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Specimen" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Specimen" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Specimen" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Specimen" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Specimen" USING GIN("_security")'); await client.query('CREATE INDEX ON "Specimen" ("_source")'); await client.query('CREATE INDEX ON "Specimen" USING GIN("_tag")'); await client.query('ALTER TABLE "SpecimenDefinition" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "SpecimenDefinition" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "SpecimenDefinition" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "SpecimenDefinition" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "SpecimenDefinition" USING GIN("_profile")'); await client.query('CREATE INDEX ON "SpecimenDefinition" USING GIN("_security")'); await client.query('CREATE INDEX ON "SpecimenDefinition" ("_source")'); await client.query('CREATE INDEX ON "SpecimenDefinition" USING GIN("_tag")'); await client.query('ALTER TABLE "StructureDefinition" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "StructureDefinition" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "StructureDefinition" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "StructureDefinition" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "StructureDefinition" USING GIN("_profile")'); await client.query('CREATE INDEX ON "StructureDefinition" USING GIN("_security")'); await client.query('CREATE INDEX ON "StructureDefinition" ("_source")'); await client.query('CREATE INDEX ON "StructureDefinition" USING GIN("_tag")'); await client.query('ALTER TABLE "StructureMap" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "StructureMap" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "StructureMap" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "StructureMap" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "StructureMap" USING GIN("_profile")'); await client.query('CREATE INDEX ON "StructureMap" USING GIN("_security")'); await client.query('CREATE INDEX ON "StructureMap" ("_source")'); await client.query('CREATE INDEX ON "StructureMap" USING GIN("_tag")'); await client.query('ALTER TABLE "Subscription" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Subscription" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Subscription" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Subscription" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Subscription" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Subscription" USING GIN("_security")'); await client.query('CREATE INDEX ON "Subscription" ("_source")'); await client.query('CREATE INDEX ON "Subscription" USING GIN("_tag")'); await client.query('ALTER TABLE "Substance" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Substance" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Substance" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Substance" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Substance" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Substance" USING GIN("_security")'); await client.query('CREATE INDEX ON "Substance" ("_source")'); await client.query('CREATE INDEX ON "Substance" USING GIN("_tag")'); await client.query('ALTER TABLE "SubstanceNucleicAcid" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "SubstanceNucleicAcid" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "SubstanceNucleicAcid" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "SubstanceNucleicAcid" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "SubstanceNucleicAcid" USING GIN("_profile")'); await client.query('CREATE INDEX ON "SubstanceNucleicAcid" USING GIN("_security")'); await client.query('CREATE INDEX ON "SubstanceNucleicAcid" ("_source")'); await client.query('CREATE INDEX ON "SubstanceNucleicAcid" USING GIN("_tag")'); await client.query('ALTER TABLE "SubstancePolymer" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "SubstancePolymer" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "SubstancePolymer" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "SubstancePolymer" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "SubstancePolymer" USING GIN("_profile")'); await client.query('CREATE INDEX ON "SubstancePolymer" USING GIN("_security")'); await client.query('CREATE INDEX ON "SubstancePolymer" ("_source")'); await client.query('CREATE INDEX ON "SubstancePolymer" USING GIN("_tag")'); await client.query('ALTER TABLE "SubstanceProtein" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "SubstanceProtein" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "SubstanceProtein" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "SubstanceProtein" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "SubstanceProtein" USING GIN("_profile")'); await client.query('CREATE INDEX ON "SubstanceProtein" USING GIN("_security")'); await client.query('CREATE INDEX ON "SubstanceProtein" ("_source")'); await client.query('CREATE INDEX ON "SubstanceProtein" USING GIN("_tag")'); await client.query('ALTER TABLE "SubstanceReferenceInformation" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "SubstanceReferenceInformation" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "SubstanceReferenceInformation" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "SubstanceReferenceInformation" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "SubstanceReferenceInformation" USING GIN("_profile")'); await client.query('CREATE INDEX ON "SubstanceReferenceInformation" USING GIN("_security")'); await client.query('CREATE INDEX ON "SubstanceReferenceInformation" ("_source")'); await client.query('CREATE INDEX ON "SubstanceReferenceInformation" USING GIN("_tag")'); await client.query('ALTER TABLE "SubstanceSourceMaterial" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "SubstanceSourceMaterial" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "SubstanceSourceMaterial" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "SubstanceSourceMaterial" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "SubstanceSourceMaterial" USING GIN("_profile")'); await client.query('CREATE INDEX ON "SubstanceSourceMaterial" USING GIN("_security")'); await client.query('CREATE INDEX ON "SubstanceSourceMaterial" ("_source")'); await client.query('CREATE INDEX ON "SubstanceSourceMaterial" USING GIN("_tag")'); await client.query('ALTER TABLE "SubstanceSpecification" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "SubstanceSpecification" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "SubstanceSpecification" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "SubstanceSpecification" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "SubstanceSpecification" USING GIN("_profile")'); await client.query('CREATE INDEX ON "SubstanceSpecification" USING GIN("_security")'); await client.query('CREATE INDEX ON "SubstanceSpecification" ("_source")'); await client.query('CREATE INDEX ON "SubstanceSpecification" USING GIN("_tag")'); await client.query('ALTER TABLE "SupplyDelivery" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "SupplyDelivery" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "SupplyDelivery" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "SupplyDelivery" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "SupplyDelivery" USING GIN("_profile")'); await client.query('CREATE INDEX ON "SupplyDelivery" USING GIN("_security")'); await client.query('CREATE INDEX ON "SupplyDelivery" ("_source")'); await client.query('CREATE INDEX ON "SupplyDelivery" USING GIN("_tag")'); await client.query('ALTER TABLE "SupplyRequest" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "SupplyRequest" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "SupplyRequest" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "SupplyRequest" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "SupplyRequest" USING GIN("_profile")'); await client.query('CREATE INDEX ON "SupplyRequest" USING GIN("_security")'); await client.query('CREATE INDEX ON "SupplyRequest" ("_source")'); await client.query('CREATE INDEX ON "SupplyRequest" USING GIN("_tag")'); await client.query('ALTER TABLE "Task" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Task" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Task" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Task" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Task" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Task" USING GIN("_security")'); await client.query('CREATE INDEX ON "Task" ("_source")'); await client.query('CREATE INDEX ON "Task" USING GIN("_tag")'); await client.query('ALTER TABLE "TerminologyCapabilities" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "TerminologyCapabilities" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "TerminologyCapabilities" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "TerminologyCapabilities" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "TerminologyCapabilities" USING GIN("_profile")'); await client.query('CREATE INDEX ON "TerminologyCapabilities" USING GIN("_security")'); await client.query('CREATE INDEX ON "TerminologyCapabilities" ("_source")'); await client.query('CREATE INDEX ON "TerminologyCapabilities" USING GIN("_tag")'); await client.query('ALTER TABLE "TestReport" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "TestReport" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "TestReport" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "TestReport" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "TestReport" USING GIN("_profile")'); await client.query('CREATE INDEX ON "TestReport" USING GIN("_security")'); await client.query('CREATE INDEX ON "TestReport" ("_source")'); await client.query('CREATE INDEX ON "TestReport" USING GIN("_tag")'); await client.query('ALTER TABLE "TestScript" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "TestScript" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "TestScript" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "TestScript" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "TestScript" USING GIN("_profile")'); await client.query('CREATE INDEX ON "TestScript" USING GIN("_security")'); await client.query('CREATE INDEX ON "TestScript" ("_source")'); await client.query('CREATE INDEX ON "TestScript" USING GIN("_tag")'); await client.query('ALTER TABLE "ValueSet" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ValueSet" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ValueSet" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ValueSet" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ValueSet" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ValueSet" USING GIN("_security")'); await client.query('CREATE INDEX ON "ValueSet" ("_source")'); await client.query('CREATE INDEX ON "ValueSet" USING GIN("_tag")'); await client.query('ALTER TABLE "VerificationResult" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "VerificationResult" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "VerificationResult" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "VerificationResult" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "VerificationResult" USING GIN("_profile")'); await client.query('CREATE INDEX ON "VerificationResult" USING GIN("_security")'); await client.query('CREATE INDEX ON "VerificationResult" ("_source")'); await client.query('CREATE INDEX ON "VerificationResult" USING GIN("_tag")'); await client.query('ALTER TABLE "VisionPrescription" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "VisionPrescription" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "VisionPrescription" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "VisionPrescription" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "VisionPrescription" USING GIN("_profile")'); await client.query('CREATE INDEX ON "VisionPrescription" USING GIN("_security")'); await client.query('CREATE INDEX ON "VisionPrescription" ("_source")'); await client.query('CREATE INDEX ON "VisionPrescription" USING GIN("_tag")'); await client.query('ALTER TABLE "Project" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Project" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Project" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Project" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Project" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Project" USING GIN("_security")'); await client.query('CREATE INDEX ON "Project" ("_source")'); await client.query('CREATE INDEX ON "Project" USING GIN("_tag")'); await client.query('ALTER TABLE "ClientApplication" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ClientApplication" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ClientApplication" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ClientApplication" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ClientApplication" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ClientApplication" USING GIN("_security")'); await client.query('CREATE INDEX ON "ClientApplication" ("_source")'); await client.query('CREATE INDEX ON "ClientApplication" USING GIN("_tag")'); await client.query('ALTER TABLE "User" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "User" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "User" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "User" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "User" USING GIN("_profile")'); await client.query('CREATE INDEX ON "User" USING GIN("_security")'); await client.query('CREATE INDEX ON "User" ("_source")'); await client.query('CREATE INDEX ON "User" USING GIN("_tag")'); await client.query('ALTER TABLE "ProjectMembership" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "ProjectMembership" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "ProjectMembership" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "ProjectMembership" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "ProjectMembership" USING GIN("_profile")'); await client.query('CREATE INDEX ON "ProjectMembership" USING GIN("_security")'); await client.query('CREATE INDEX ON "ProjectMembership" ("_source")'); await client.query('CREATE INDEX ON "ProjectMembership" USING GIN("_tag")'); await client.query('ALTER TABLE "Bot" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Bot" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Bot" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Bot" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Bot" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Bot" USING GIN("_security")'); await client.query('CREATE INDEX ON "Bot" ("_source")'); await client.query('CREATE INDEX ON "Bot" USING GIN("_tag")'); await client.query('ALTER TABLE "Login" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "Login" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "Login" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "Login" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "Login" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Login" USING GIN("_security")'); await client.query('CREATE INDEX ON "Login" ("_source")'); await client.query('CREATE INDEX ON "Login" USING GIN("_tag")'); await client.query('ALTER TABLE "PasswordChangeRequest" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "PasswordChangeRequest" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "PasswordChangeRequest" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "PasswordChangeRequest" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "PasswordChangeRequest" USING GIN("_profile")'); await client.query('CREATE INDEX ON "PasswordChangeRequest" USING GIN("_security")'); await client.query('CREATE INDEX ON "PasswordChangeRequest" ("_source")'); await client.query('CREATE INDEX ON "PasswordChangeRequest" USING GIN("_tag")'); await client.query('ALTER TABLE "JsonWebKey" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "JsonWebKey" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "JsonWebKey" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "JsonWebKey" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "JsonWebKey" USING GIN("_profile")'); await client.query('CREATE INDEX ON "JsonWebKey" USING GIN("_security")'); await client.query('CREATE INDEX ON "JsonWebKey" ("_source")'); await client.query('CREATE INDEX ON "JsonWebKey" USING GIN("_tag")'); await client.query('ALTER TABLE "AccessPolicy" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "AccessPolicy" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "AccessPolicy" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "AccessPolicy" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "AccessPolicy" USING GIN("_profile")'); await client.query('CREATE INDEX ON "AccessPolicy" USING GIN("_security")'); await client.query('CREATE INDEX ON "AccessPolicy" ("_source")'); await client.query('CREATE INDEX ON "AccessPolicy" USING GIN("_tag")'); await client.query('ALTER TABLE "UserConfiguration" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "UserConfiguration" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "UserConfiguration" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "UserConfiguration" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "UserConfiguration" USING GIN("_profile")'); await client.query('CREATE INDEX ON "UserConfiguration" USING GIN("_security")'); await client.query('CREATE INDEX ON "UserConfiguration" ("_source")'); await client.query('CREATE INDEX ON "UserConfiguration" USING GIN("_tag")'); await client.query('ALTER TABLE "BulkDataExport" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "BulkDataExport" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "BulkDataExport" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "BulkDataExport" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "BulkDataExport" USING GIN("_profile")'); await client.query('CREATE INDEX ON "BulkDataExport" USING GIN("_security")'); await client.query('CREATE INDEX ON "BulkDataExport" ("_source")'); await client.query('CREATE INDEX ON "BulkDataExport" USING GIN("_tag")'); await client.query('ALTER TABLE "SmartAppLaunch" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "SmartAppLaunch" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "SmartAppLaunch" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "SmartAppLaunch" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "SmartAppLaunch" USING GIN("_profile")'); await client.query('CREATE INDEX ON "SmartAppLaunch" USING GIN("_security")'); await client.query('CREATE INDEX ON "SmartAppLaunch" ("_source")'); await client.query('CREATE INDEX ON "SmartAppLaunch" USING GIN("_tag")'); await client.query('ALTER TABLE "DomainConfiguration" ADD COLUMN "_profile" TEXT[]'); await client.query('ALTER TABLE "DomainConfiguration" ADD COLUMN "_security" TEXT[]'); await client.query('ALTER TABLE "DomainConfiguration" ADD COLUMN "_source" TEXT'); await client.query('ALTER TABLE "DomainConfiguration" ADD COLUMN "_tag" TEXT[]'); await client.query('CREATE INDEX ON "DomainConfiguration" USING GIN("_profile")'); await client.query('CREATE INDEX ON "DomainConfiguration" USING GIN("_security")'); await client.query('CREATE INDEX ON "DomainConfiguration" ("_source")'); await client.query('CREATE INDEX ON "DomainConfiguration" USING GIN("_tag")'); }

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/medplum/medplum'

If you have feedback or need assistance with the MCP directory API, please join our Discord server