Medplum

// SPDX-FileCopyrightText: Copyright Orangebot, Inc. and Medplum contributors // SPDX-License-Identifier: Apache-2.0 /* * Generated by @medplum/generator * Do not edit manually. */ import type { PoolClient } from 'pg'; export async function run(client: PoolClient): Promise<void> { await client.query('CREATE INDEX ON "Account" ("lastUpdated")'); await client.query('CREATE INDEX ON "Account" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Account_History" ("id")'); await client.query('CREATE INDEX ON "Account_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ActivityDefinition" ("lastUpdated")'); await client.query('CREATE INDEX ON "ActivityDefinition" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ActivityDefinition_History" ("id")'); await client.query('CREATE INDEX ON "ActivityDefinition_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "AdverseEvent" ("lastUpdated")'); await client.query('CREATE INDEX ON "AdverseEvent" USING GIN("compartments")'); await client.query('CREATE INDEX ON "AdverseEvent_History" ("id")'); await client.query('CREATE INDEX ON "AdverseEvent_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "AllergyIntolerance" ("lastUpdated")'); await client.query('CREATE INDEX ON "AllergyIntolerance" USING GIN("compartments")'); await client.query('CREATE INDEX ON "AllergyIntolerance_History" ("id")'); await client.query('CREATE INDEX ON "AllergyIntolerance_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Appointment" ("lastUpdated")'); await client.query('CREATE INDEX ON "Appointment" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Appointment_History" ("id")'); await client.query('CREATE INDEX ON "Appointment_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "AppointmentResponse" ("lastUpdated")'); await client.query('CREATE INDEX ON "AppointmentResponse" USING GIN("compartments")'); await client.query('CREATE INDEX ON "AppointmentResponse_History" ("id")'); await client.query('CREATE INDEX ON "AppointmentResponse_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "AuditEvent" ("lastUpdated")'); await client.query('CREATE INDEX ON "AuditEvent" USING GIN("compartments")'); await client.query('CREATE INDEX ON "AuditEvent_History" ("id")'); await client.query('CREATE INDEX ON "AuditEvent_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Basic" ("lastUpdated")'); await client.query('CREATE INDEX ON "Basic" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Basic_History" ("id")'); await client.query('CREATE INDEX ON "Basic_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Binary" ("lastUpdated")'); await client.query('CREATE INDEX ON "Binary" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Binary_History" ("id")'); await client.query('CREATE INDEX ON "Binary_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "BiologicallyDerivedProduct" ("lastUpdated")'); await client.query('CREATE INDEX ON "BiologicallyDerivedProduct" USING GIN("compartments")'); await client.query('CREATE INDEX ON "BiologicallyDerivedProduct_History" ("id")'); await client.query('CREATE INDEX ON "BiologicallyDerivedProduct_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "BodyStructure" ("lastUpdated")'); await client.query('CREATE INDEX ON "BodyStructure" USING GIN("compartments")'); await client.query('CREATE INDEX ON "BodyStructure_History" ("id")'); await client.query('CREATE INDEX ON "BodyStructure_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Bundle" ("lastUpdated")'); await client.query('CREATE INDEX ON "Bundle" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Bundle_History" ("id")'); await client.query('CREATE INDEX ON "Bundle_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "CapabilityStatement" ("lastUpdated")'); await client.query('CREATE INDEX ON "CapabilityStatement" USING GIN("compartments")'); await client.query('CREATE INDEX ON "CapabilityStatement_History" ("id")'); await client.query('CREATE INDEX ON "CapabilityStatement_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "CarePlan" ("lastUpdated")'); await client.query('CREATE INDEX ON "CarePlan" USING GIN("compartments")'); await client.query('CREATE INDEX ON "CarePlan_History" ("id")'); await client.query('CREATE INDEX ON "CarePlan_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "CareTeam" ("lastUpdated")'); await client.query('CREATE INDEX ON "CareTeam" USING GIN("compartments")'); await client.query('CREATE INDEX ON "CareTeam_History" ("id")'); await client.query('CREATE INDEX ON "CareTeam_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "CatalogEntry" ("lastUpdated")'); await client.query('CREATE INDEX ON "CatalogEntry" USING GIN("compartments")'); await client.query('CREATE INDEX ON "CatalogEntry_History" ("id")'); await client.query('CREATE INDEX ON "CatalogEntry_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ChargeItem" ("lastUpdated")'); await client.query('CREATE INDEX ON "ChargeItem" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ChargeItem_History" ("id")'); await client.query('CREATE INDEX ON "ChargeItem_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ChargeItemDefinition" ("lastUpdated")'); await client.query('CREATE INDEX ON "ChargeItemDefinition" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ChargeItemDefinition_History" ("id")'); await client.query('CREATE INDEX ON "ChargeItemDefinition_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Claim" ("lastUpdated")'); await client.query('CREATE INDEX ON "Claim" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Claim_History" ("id")'); await client.query('CREATE INDEX ON "Claim_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ClaimResponse" ("lastUpdated")'); await client.query('CREATE INDEX ON "ClaimResponse" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ClaimResponse_History" ("id")'); await client.query('CREATE INDEX ON "ClaimResponse_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ClinicalImpression" ("lastUpdated")'); await client.query('CREATE INDEX ON "ClinicalImpression" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ClinicalImpression_History" ("id")'); await client.query('CREATE INDEX ON "ClinicalImpression_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "CodeSystem" ("lastUpdated")'); await client.query('CREATE INDEX ON "CodeSystem" USING GIN("compartments")'); await client.query('CREATE INDEX ON "CodeSystem_History" ("id")'); await client.query('CREATE INDEX ON "CodeSystem_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Communication" ("lastUpdated")'); await client.query('CREATE INDEX ON "Communication" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Communication_History" ("id")'); await client.query('CREATE INDEX ON "Communication_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "CommunicationRequest" ("lastUpdated")'); await client.query('CREATE INDEX ON "CommunicationRequest" USING GIN("compartments")'); await client.query('CREATE INDEX ON "CommunicationRequest_History" ("id")'); await client.query('CREATE INDEX ON "CommunicationRequest_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "CompartmentDefinition" ("lastUpdated")'); await client.query('CREATE INDEX ON "CompartmentDefinition" USING GIN("compartments")'); await client.query('CREATE INDEX ON "CompartmentDefinition_History" ("id")'); await client.query('CREATE INDEX ON "CompartmentDefinition_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Composition" ("lastUpdated")'); await client.query('CREATE INDEX ON "Composition" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Composition_History" ("id")'); await client.query('CREATE INDEX ON "Composition_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ConceptMap" ("lastUpdated")'); await client.query('CREATE INDEX ON "ConceptMap" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ConceptMap_History" ("id")'); await client.query('CREATE INDEX ON "ConceptMap_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Condition" ("lastUpdated")'); await client.query('CREATE INDEX ON "Condition" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Condition_History" ("id")'); await client.query('CREATE INDEX ON "Condition_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Consent" ("lastUpdated")'); await client.query('CREATE INDEX ON "Consent" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Consent_History" ("id")'); await client.query('CREATE INDEX ON "Consent_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Contract" ("lastUpdated")'); await client.query('CREATE INDEX ON "Contract" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Contract_History" ("id")'); await client.query('CREATE INDEX ON "Contract_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Coverage" ("lastUpdated")'); await client.query('CREATE INDEX ON "Coverage" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Coverage_History" ("id")'); await client.query('CREATE INDEX ON "Coverage_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "CoverageEligibilityRequest" ("lastUpdated")'); await client.query('CREATE INDEX ON "CoverageEligibilityRequest" USING GIN("compartments")'); await client.query('CREATE INDEX ON "CoverageEligibilityRequest_History" ("id")'); await client.query('CREATE INDEX ON "CoverageEligibilityRequest_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "CoverageEligibilityResponse" ("lastUpdated")'); await client.query('CREATE INDEX ON "CoverageEligibilityResponse" USING GIN("compartments")'); await client.query('CREATE INDEX ON "CoverageEligibilityResponse_History" ("id")'); await client.query('CREATE INDEX ON "CoverageEligibilityResponse_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "DetectedIssue" ("lastUpdated")'); await client.query('CREATE INDEX ON "DetectedIssue" USING GIN("compartments")'); await client.query('CREATE INDEX ON "DetectedIssue_History" ("id")'); await client.query('CREATE INDEX ON "DetectedIssue_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Device" ("lastUpdated")'); await client.query('CREATE INDEX ON "Device" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Device_History" ("id")'); await client.query('CREATE INDEX ON "Device_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "DeviceDefinition" ("lastUpdated")'); await client.query('CREATE INDEX ON "DeviceDefinition" USING GIN("compartments")'); await client.query('CREATE INDEX ON "DeviceDefinition_History" ("id")'); await client.query('CREATE INDEX ON "DeviceDefinition_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "DeviceMetric" ("lastUpdated")'); await client.query('CREATE INDEX ON "DeviceMetric" USING GIN("compartments")'); await client.query('CREATE INDEX ON "DeviceMetric_History" ("id")'); await client.query('CREATE INDEX ON "DeviceMetric_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "DeviceRequest" ("lastUpdated")'); await client.query('CREATE INDEX ON "DeviceRequest" USING GIN("compartments")'); await client.query('CREATE INDEX ON "DeviceRequest_History" ("id")'); await client.query('CREATE INDEX ON "DeviceRequest_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "DeviceUseStatement" ("lastUpdated")'); await client.query('CREATE INDEX ON "DeviceUseStatement" USING GIN("compartments")'); await client.query('CREATE INDEX ON "DeviceUseStatement_History" ("id")'); await client.query('CREATE INDEX ON "DeviceUseStatement_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "DiagnosticReport" ("lastUpdated")'); await client.query('CREATE INDEX ON "DiagnosticReport" USING GIN("compartments")'); await client.query('CREATE INDEX ON "DiagnosticReport_History" ("id")'); await client.query('CREATE INDEX ON "DiagnosticReport_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "DocumentManifest" ("lastUpdated")'); await client.query('CREATE INDEX ON "DocumentManifest" USING GIN("compartments")'); await client.query('CREATE INDEX ON "DocumentManifest_History" ("id")'); await client.query('CREATE INDEX ON "DocumentManifest_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "DocumentReference" ("lastUpdated")'); await client.query('CREATE INDEX ON "DocumentReference" USING GIN("compartments")'); await client.query('CREATE INDEX ON "DocumentReference_History" ("id")'); await client.query('CREATE INDEX ON "DocumentReference_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "EffectEvidenceSynthesis" ("lastUpdated")'); await client.query('CREATE INDEX ON "EffectEvidenceSynthesis" USING GIN("compartments")'); await client.query('CREATE INDEX ON "EffectEvidenceSynthesis_History" ("id")'); await client.query('CREATE INDEX ON "EffectEvidenceSynthesis_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Encounter" ("lastUpdated")'); await client.query('CREATE INDEX ON "Encounter" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Encounter_History" ("id")'); await client.query('CREATE INDEX ON "Encounter_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Endpoint" ("lastUpdated")'); await client.query('CREATE INDEX ON "Endpoint" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Endpoint_History" ("id")'); await client.query('CREATE INDEX ON "Endpoint_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "EnrollmentRequest" ("lastUpdated")'); await client.query('CREATE INDEX ON "EnrollmentRequest" USING GIN("compartments")'); await client.query('CREATE INDEX ON "EnrollmentRequest_History" ("id")'); await client.query('CREATE INDEX ON "EnrollmentRequest_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "EnrollmentResponse" ("lastUpdated")'); await client.query('CREATE INDEX ON "EnrollmentResponse" USING GIN("compartments")'); await client.query('CREATE INDEX ON "EnrollmentResponse_History" ("id")'); await client.query('CREATE INDEX ON "EnrollmentResponse_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "EpisodeOfCare" ("lastUpdated")'); await client.query('CREATE INDEX ON "EpisodeOfCare" USING GIN("compartments")'); await client.query('CREATE INDEX ON "EpisodeOfCare_History" ("id")'); await client.query('CREATE INDEX ON "EpisodeOfCare_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "EventDefinition" ("lastUpdated")'); await client.query('CREATE INDEX ON "EventDefinition" USING GIN("compartments")'); await client.query('CREATE INDEX ON "EventDefinition_History" ("id")'); await client.query('CREATE INDEX ON "EventDefinition_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Evidence" ("lastUpdated")'); await client.query('CREATE INDEX ON "Evidence" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Evidence_History" ("id")'); await client.query('CREATE INDEX ON "Evidence_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "EvidenceVariable" ("lastUpdated")'); await client.query('CREATE INDEX ON "EvidenceVariable" USING GIN("compartments")'); await client.query('CREATE INDEX ON "EvidenceVariable_History" ("id")'); await client.query('CREATE INDEX ON "EvidenceVariable_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ExampleScenario" ("lastUpdated")'); await client.query('CREATE INDEX ON "ExampleScenario" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ExampleScenario_History" ("id")'); await client.query('CREATE INDEX ON "ExampleScenario_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ExplanationOfBenefit" ("lastUpdated")'); await client.query('CREATE INDEX ON "ExplanationOfBenefit" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ExplanationOfBenefit_History" ("id")'); await client.query('CREATE INDEX ON "ExplanationOfBenefit_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "FamilyMemberHistory" ("lastUpdated")'); await client.query('CREATE INDEX ON "FamilyMemberHistory" USING GIN("compartments")'); await client.query('CREATE INDEX ON "FamilyMemberHistory_History" ("id")'); await client.query('CREATE INDEX ON "FamilyMemberHistory_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Flag" ("lastUpdated")'); await client.query('CREATE INDEX ON "Flag" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Flag_History" ("id")'); await client.query('CREATE INDEX ON "Flag_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Goal" ("lastUpdated")'); await client.query('CREATE INDEX ON "Goal" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Goal_History" ("id")'); await client.query('CREATE INDEX ON "Goal_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "GraphDefinition" ("lastUpdated")'); await client.query('CREATE INDEX ON "GraphDefinition" USING GIN("compartments")'); await client.query('CREATE INDEX ON "GraphDefinition_History" ("id")'); await client.query('CREATE INDEX ON "GraphDefinition_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Group" ("lastUpdated")'); await client.query('CREATE INDEX ON "Group" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Group_History" ("id")'); await client.query('CREATE INDEX ON "Group_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "GuidanceResponse" ("lastUpdated")'); await client.query('CREATE INDEX ON "GuidanceResponse" USING GIN("compartments")'); await client.query('CREATE INDEX ON "GuidanceResponse_History" ("id")'); await client.query('CREATE INDEX ON "GuidanceResponse_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "HealthcareService" ("lastUpdated")'); await client.query('CREATE INDEX ON "HealthcareService" USING GIN("compartments")'); await client.query('CREATE INDEX ON "HealthcareService_History" ("id")'); await client.query('CREATE INDEX ON "HealthcareService_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ImagingStudy" ("lastUpdated")'); await client.query('CREATE INDEX ON "ImagingStudy" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ImagingStudy_History" ("id")'); await client.query('CREATE INDEX ON "ImagingStudy_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Immunization" ("lastUpdated")'); await client.query('CREATE INDEX ON "Immunization" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Immunization_History" ("id")'); await client.query('CREATE INDEX ON "Immunization_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ImmunizationEvaluation" ("lastUpdated")'); await client.query('CREATE INDEX ON "ImmunizationEvaluation" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ImmunizationEvaluation_History" ("id")'); await client.query('CREATE INDEX ON "ImmunizationEvaluation_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ImmunizationRecommendation" ("lastUpdated")'); await client.query('CREATE INDEX ON "ImmunizationRecommendation" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ImmunizationRecommendation_History" ("id")'); await client.query('CREATE INDEX ON "ImmunizationRecommendation_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ImplementationGuide" ("lastUpdated")'); await client.query('CREATE INDEX ON "ImplementationGuide" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ImplementationGuide_History" ("id")'); await client.query('CREATE INDEX ON "ImplementationGuide_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "InsurancePlan" ("lastUpdated")'); await client.query('CREATE INDEX ON "InsurancePlan" USING GIN("compartments")'); await client.query('CREATE INDEX ON "InsurancePlan_History" ("id")'); await client.query('CREATE INDEX ON "InsurancePlan_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Invoice" ("lastUpdated")'); await client.query('CREATE INDEX ON "Invoice" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Invoice_History" ("id")'); await client.query('CREATE INDEX ON "Invoice_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Library" ("lastUpdated")'); await client.query('CREATE INDEX ON "Library" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Library_History" ("id")'); await client.query('CREATE INDEX ON "Library_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Linkage" ("lastUpdated")'); await client.query('CREATE INDEX ON "Linkage" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Linkage_History" ("id")'); await client.query('CREATE INDEX ON "Linkage_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "List" ("lastUpdated")'); await client.query('CREATE INDEX ON "List" USING GIN("compartments")'); await client.query('CREATE INDEX ON "List_History" ("id")'); await client.query('CREATE INDEX ON "List_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Location" ("lastUpdated")'); await client.query('CREATE INDEX ON "Location" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Location_History" ("id")'); await client.query('CREATE INDEX ON "Location_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Measure" ("lastUpdated")'); await client.query('CREATE INDEX ON "Measure" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Measure_History" ("id")'); await client.query('CREATE INDEX ON "Measure_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MeasureReport" ("lastUpdated")'); await client.query('CREATE INDEX ON "MeasureReport" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MeasureReport_History" ("id")'); await client.query('CREATE INDEX ON "MeasureReport_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Media" ("lastUpdated")'); await client.query('CREATE INDEX ON "Media" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Media_History" ("id")'); await client.query('CREATE INDEX ON "Media_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Medication" ("lastUpdated")'); await client.query('CREATE INDEX ON "Medication" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Medication_History" ("id")'); await client.query('CREATE INDEX ON "Medication_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicationAdministration" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicationAdministration" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MedicationAdministration_History" ("id")'); await client.query('CREATE INDEX ON "MedicationAdministration_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicationDispense" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicationDispense" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MedicationDispense_History" ("id")'); await client.query('CREATE INDEX ON "MedicationDispense_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicationKnowledge" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicationKnowledge" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MedicationKnowledge_History" ("id")'); await client.query('CREATE INDEX ON "MedicationKnowledge_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicationRequest" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicationRequest" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MedicationRequest_History" ("id")'); await client.query('CREATE INDEX ON "MedicationRequest_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicationStatement" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicationStatement" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MedicationStatement_History" ("id")'); await client.query('CREATE INDEX ON "MedicationStatement_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProduct" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProduct" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MedicinalProduct_History" ("id")'); await client.query('CREATE INDEX ON "MedicinalProduct_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductAuthorization" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductAuthorization" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MedicinalProductAuthorization_History" ("id")'); await client.query('CREATE INDEX ON "MedicinalProductAuthorization_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductContraindication" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductContraindication" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MedicinalProductContraindication_History" ("id")'); await client.query('CREATE INDEX ON "MedicinalProductContraindication_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductIndication" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductIndication" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MedicinalProductIndication_History" ("id")'); await client.query('CREATE INDEX ON "MedicinalProductIndication_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductIngredient" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductIngredient" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MedicinalProductIngredient_History" ("id")'); await client.query('CREATE INDEX ON "MedicinalProductIngredient_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductInteraction" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductInteraction" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MedicinalProductInteraction_History" ("id")'); await client.query('CREATE INDEX ON "MedicinalProductInteraction_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductManufactured" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductManufactured" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MedicinalProductManufactured_History" ("id")'); await client.query('CREATE INDEX ON "MedicinalProductManufactured_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductPackaged" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductPackaged" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MedicinalProductPackaged_History" ("id")'); await client.query('CREATE INDEX ON "MedicinalProductPackaged_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductPharmaceutical" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductPharmaceutical" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MedicinalProductPharmaceutical_History" ("id")'); await client.query('CREATE INDEX ON "MedicinalProductPharmaceutical_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductUndesirableEffect" ("lastUpdated")'); await client.query('CREATE INDEX ON "MedicinalProductUndesirableEffect" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MedicinalProductUndesirableEffect_History" ("id")'); await client.query('CREATE INDEX ON "MedicinalProductUndesirableEffect_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MessageDefinition" ("lastUpdated")'); await client.query('CREATE INDEX ON "MessageDefinition" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MessageDefinition_History" ("id")'); await client.query('CREATE INDEX ON "MessageDefinition_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MessageHeader" ("lastUpdated")'); await client.query('CREATE INDEX ON "MessageHeader" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MessageHeader_History" ("id")'); await client.query('CREATE INDEX ON "MessageHeader_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "MolecularSequence" ("lastUpdated")'); await client.query('CREATE INDEX ON "MolecularSequence" USING GIN("compartments")'); await client.query('CREATE INDEX ON "MolecularSequence_History" ("id")'); await client.query('CREATE INDEX ON "MolecularSequence_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "NamingSystem" ("lastUpdated")'); await client.query('CREATE INDEX ON "NamingSystem" USING GIN("compartments")'); await client.query('CREATE INDEX ON "NamingSystem_History" ("id")'); await client.query('CREATE INDEX ON "NamingSystem_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "NutritionOrder" ("lastUpdated")'); await client.query('CREATE INDEX ON "NutritionOrder" USING GIN("compartments")'); await client.query('CREATE INDEX ON "NutritionOrder_History" ("id")'); await client.query('CREATE INDEX ON "NutritionOrder_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Observation" ("lastUpdated")'); await client.query('CREATE INDEX ON "Observation" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Observation_History" ("id")'); await client.query('CREATE INDEX ON "Observation_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ObservationDefinition" ("lastUpdated")'); await client.query('CREATE INDEX ON "ObservationDefinition" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ObservationDefinition_History" ("id")'); await client.query('CREATE INDEX ON "ObservationDefinition_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "OperationDefinition" ("lastUpdated")'); await client.query('CREATE INDEX ON "OperationDefinition" USING GIN("compartments")'); await client.query('CREATE INDEX ON "OperationDefinition_History" ("id")'); await client.query('CREATE INDEX ON "OperationDefinition_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "OperationOutcome" ("lastUpdated")'); await client.query('CREATE INDEX ON "OperationOutcome" USING GIN("compartments")'); await client.query('CREATE INDEX ON "OperationOutcome_History" ("id")'); await client.query('CREATE INDEX ON "OperationOutcome_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Organization" ("lastUpdated")'); await client.query('CREATE INDEX ON "Organization" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Organization_History" ("id")'); await client.query('CREATE INDEX ON "Organization_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "OrganizationAffiliation" ("lastUpdated")'); await client.query('CREATE INDEX ON "OrganizationAffiliation" USING GIN("compartments")'); await client.query('CREATE INDEX ON "OrganizationAffiliation_History" ("id")'); await client.query('CREATE INDEX ON "OrganizationAffiliation_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Parameters" ("lastUpdated")'); await client.query('CREATE INDEX ON "Parameters" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Parameters_History" ("id")'); await client.query('CREATE INDEX ON "Parameters_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Patient" ("lastUpdated")'); await client.query('CREATE INDEX ON "Patient" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Patient_History" ("id")'); await client.query('CREATE INDEX ON "Patient_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "PaymentNotice" ("lastUpdated")'); await client.query('CREATE INDEX ON "PaymentNotice" USING GIN("compartments")'); await client.query('CREATE INDEX ON "PaymentNotice_History" ("id")'); await client.query('CREATE INDEX ON "PaymentNotice_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "PaymentReconciliation" ("lastUpdated")'); await client.query('CREATE INDEX ON "PaymentReconciliation" USING GIN("compartments")'); await client.query('CREATE INDEX ON "PaymentReconciliation_History" ("id")'); await client.query('CREATE INDEX ON "PaymentReconciliation_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Person" ("lastUpdated")'); await client.query('CREATE INDEX ON "Person" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Person_History" ("id")'); await client.query('CREATE INDEX ON "Person_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "PlanDefinition" ("lastUpdated")'); await client.query('CREATE INDEX ON "PlanDefinition" USING GIN("compartments")'); await client.query('CREATE INDEX ON "PlanDefinition_History" ("id")'); await client.query('CREATE INDEX ON "PlanDefinition_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Practitioner" ("lastUpdated")'); await client.query('CREATE INDEX ON "Practitioner" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Practitioner_History" ("id")'); await client.query('CREATE INDEX ON "Practitioner_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "PractitionerRole" ("lastUpdated")'); await client.query('CREATE INDEX ON "PractitionerRole" USING GIN("compartments")'); await client.query('CREATE INDEX ON "PractitionerRole_History" ("id")'); await client.query('CREATE INDEX ON "PractitionerRole_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Procedure" ("lastUpdated")'); await client.query('CREATE INDEX ON "Procedure" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Procedure_History" ("id")'); await client.query('CREATE INDEX ON "Procedure_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Provenance" ("lastUpdated")'); await client.query('CREATE INDEX ON "Provenance" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Provenance_History" ("id")'); await client.query('CREATE INDEX ON "Provenance_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Questionnaire" ("lastUpdated")'); await client.query('CREATE INDEX ON "Questionnaire" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Questionnaire_History" ("id")'); await client.query('CREATE INDEX ON "Questionnaire_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "QuestionnaireResponse" ("lastUpdated")'); await client.query('CREATE INDEX ON "QuestionnaireResponse" USING GIN("compartments")'); await client.query('CREATE INDEX ON "QuestionnaireResponse_History" ("id")'); await client.query('CREATE INDEX ON "QuestionnaireResponse_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "RelatedPerson" ("lastUpdated")'); await client.query('CREATE INDEX ON "RelatedPerson" USING GIN("compartments")'); await client.query('CREATE INDEX ON "RelatedPerson_History" ("id")'); await client.query('CREATE INDEX ON "RelatedPerson_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "RequestGroup" ("lastUpdated")'); await client.query('CREATE INDEX ON "RequestGroup" USING GIN("compartments")'); await client.query('CREATE INDEX ON "RequestGroup_History" ("id")'); await client.query('CREATE INDEX ON "RequestGroup_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ResearchDefinition" ("lastUpdated")'); await client.query('CREATE INDEX ON "ResearchDefinition" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ResearchDefinition_History" ("id")'); await client.query('CREATE INDEX ON "ResearchDefinition_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ResearchElementDefinition" ("lastUpdated")'); await client.query('CREATE INDEX ON "ResearchElementDefinition" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ResearchElementDefinition_History" ("id")'); await client.query('CREATE INDEX ON "ResearchElementDefinition_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ResearchStudy" ("lastUpdated")'); await client.query('CREATE INDEX ON "ResearchStudy" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ResearchStudy_History" ("id")'); await client.query('CREATE INDEX ON "ResearchStudy_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ResearchSubject" ("lastUpdated")'); await client.query('CREATE INDEX ON "ResearchSubject" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ResearchSubject_History" ("id")'); await client.query('CREATE INDEX ON "ResearchSubject_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "RiskAssessment" ("lastUpdated")'); await client.query('CREATE INDEX ON "RiskAssessment" USING GIN("compartments")'); await client.query('CREATE INDEX ON "RiskAssessment_History" ("id")'); await client.query('CREATE INDEX ON "RiskAssessment_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "RiskEvidenceSynthesis" ("lastUpdated")'); await client.query('CREATE INDEX ON "RiskEvidenceSynthesis" USING GIN("compartments")'); await client.query('CREATE INDEX ON "RiskEvidenceSynthesis_History" ("id")'); await client.query('CREATE INDEX ON "RiskEvidenceSynthesis_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Schedule" ("lastUpdated")'); await client.query('CREATE INDEX ON "Schedule" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Schedule_History" ("id")'); await client.query('CREATE INDEX ON "Schedule_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "SearchParameter" ("lastUpdated")'); await client.query('CREATE INDEX ON "SearchParameter" USING GIN("compartments")'); await client.query('CREATE INDEX ON "SearchParameter_History" ("id")'); await client.query('CREATE INDEX ON "SearchParameter_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ServiceRequest" ("lastUpdated")'); await client.query('CREATE INDEX ON "ServiceRequest" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ServiceRequest_History" ("id")'); await client.query('CREATE INDEX ON "ServiceRequest_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Slot" ("lastUpdated")'); await client.query('CREATE INDEX ON "Slot" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Slot_History" ("id")'); await client.query('CREATE INDEX ON "Slot_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Specimen" ("lastUpdated")'); await client.query('CREATE INDEX ON "Specimen" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Specimen_History" ("id")'); await client.query('CREATE INDEX ON "Specimen_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "SpecimenDefinition" ("lastUpdated")'); await client.query('CREATE INDEX ON "SpecimenDefinition" USING GIN("compartments")'); await client.query('CREATE INDEX ON "SpecimenDefinition_History" ("id")'); await client.query('CREATE INDEX ON "SpecimenDefinition_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "StructureDefinition" ("lastUpdated")'); await client.query('CREATE INDEX ON "StructureDefinition" USING GIN("compartments")'); await client.query('CREATE INDEX ON "StructureDefinition_History" ("id")'); await client.query('CREATE INDEX ON "StructureDefinition_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "StructureMap" ("lastUpdated")'); await client.query('CREATE INDEX ON "StructureMap" USING GIN("compartments")'); await client.query('CREATE INDEX ON "StructureMap_History" ("id")'); await client.query('CREATE INDEX ON "StructureMap_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Subscription" ("lastUpdated")'); await client.query('CREATE INDEX ON "Subscription" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Subscription_History" ("id")'); await client.query('CREATE INDEX ON "Subscription_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Substance" ("lastUpdated")'); await client.query('CREATE INDEX ON "Substance" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Substance_History" ("id")'); await client.query('CREATE INDEX ON "Substance_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "SubstanceNucleicAcid" ("lastUpdated")'); await client.query('CREATE INDEX ON "SubstanceNucleicAcid" USING GIN("compartments")'); await client.query('CREATE INDEX ON "SubstanceNucleicAcid_History" ("id")'); await client.query('CREATE INDEX ON "SubstanceNucleicAcid_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "SubstancePolymer" ("lastUpdated")'); await client.query('CREATE INDEX ON "SubstancePolymer" USING GIN("compartments")'); await client.query('CREATE INDEX ON "SubstancePolymer_History" ("id")'); await client.query('CREATE INDEX ON "SubstancePolymer_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "SubstanceProtein" ("lastUpdated")'); await client.query('CREATE INDEX ON "SubstanceProtein" USING GIN("compartments")'); await client.query('CREATE INDEX ON "SubstanceProtein_History" ("id")'); await client.query('CREATE INDEX ON "SubstanceProtein_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "SubstanceReferenceInformation" ("lastUpdated")'); await client.query('CREATE INDEX ON "SubstanceReferenceInformation" USING GIN("compartments")'); await client.query('CREATE INDEX ON "SubstanceReferenceInformation_History" ("id")'); await client.query('CREATE INDEX ON "SubstanceReferenceInformation_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "SubstanceSourceMaterial" ("lastUpdated")'); await client.query('CREATE INDEX ON "SubstanceSourceMaterial" USING GIN("compartments")'); await client.query('CREATE INDEX ON "SubstanceSourceMaterial_History" ("id")'); await client.query('CREATE INDEX ON "SubstanceSourceMaterial_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "SubstanceSpecification" ("lastUpdated")'); await client.query('CREATE INDEX ON "SubstanceSpecification" USING GIN("compartments")'); await client.query('CREATE INDEX ON "SubstanceSpecification_History" ("id")'); await client.query('CREATE INDEX ON "SubstanceSpecification_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "SupplyDelivery" ("lastUpdated")'); await client.query('CREATE INDEX ON "SupplyDelivery" USING GIN("compartments")'); await client.query('CREATE INDEX ON "SupplyDelivery_History" ("id")'); await client.query('CREATE INDEX ON "SupplyDelivery_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "SupplyRequest" ("lastUpdated")'); await client.query('CREATE INDEX ON "SupplyRequest" USING GIN("compartments")'); await client.query('CREATE INDEX ON "SupplyRequest_History" ("id")'); await client.query('CREATE INDEX ON "SupplyRequest_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Task" ("lastUpdated")'); await client.query('CREATE INDEX ON "Task" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Task_History" ("id")'); await client.query('CREATE INDEX ON "Task_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "TerminologyCapabilities" ("lastUpdated")'); await client.query('CREATE INDEX ON "TerminologyCapabilities" USING GIN("compartments")'); await client.query('CREATE INDEX ON "TerminologyCapabilities_History" ("id")'); await client.query('CREATE INDEX ON "TerminologyCapabilities_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "TestReport" ("lastUpdated")'); await client.query('CREATE INDEX ON "TestReport" USING GIN("compartments")'); await client.query('CREATE INDEX ON "TestReport_History" ("id")'); await client.query('CREATE INDEX ON "TestReport_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "TestScript" ("lastUpdated")'); await client.query('CREATE INDEX ON "TestScript" USING GIN("compartments")'); await client.query('CREATE INDEX ON "TestScript_History" ("id")'); await client.query('CREATE INDEX ON "TestScript_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ValueSet" ("lastUpdated")'); await client.query('CREATE INDEX ON "ValueSet" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ValueSet_History" ("id")'); await client.query('CREATE INDEX ON "ValueSet_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "VerificationResult" ("lastUpdated")'); await client.query('CREATE INDEX ON "VerificationResult" USING GIN("compartments")'); await client.query('CREATE INDEX ON "VerificationResult_History" ("id")'); await client.query('CREATE INDEX ON "VerificationResult_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "VisionPrescription" ("lastUpdated")'); await client.query('CREATE INDEX ON "VisionPrescription" USING GIN("compartments")'); await client.query('CREATE INDEX ON "VisionPrescription_History" ("id")'); await client.query('CREATE INDEX ON "VisionPrescription_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Project" ("lastUpdated")'); await client.query('CREATE INDEX ON "Project" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Project_History" ("id")'); await client.query('CREATE INDEX ON "Project_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ClientApplication" ("lastUpdated")'); await client.query('CREATE INDEX ON "ClientApplication" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ClientApplication_History" ("id")'); await client.query('CREATE INDEX ON "ClientApplication_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "User" ("lastUpdated")'); await client.query('CREATE INDEX ON "User" USING GIN("compartments")'); await client.query('CREATE INDEX ON "User_History" ("id")'); await client.query('CREATE INDEX ON "User_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "ProjectMembership" ("lastUpdated")'); await client.query('CREATE INDEX ON "ProjectMembership" USING GIN("compartments")'); await client.query('CREATE INDEX ON "ProjectMembership_History" ("id")'); await client.query('CREATE INDEX ON "ProjectMembership_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Bot" ("lastUpdated")'); await client.query('CREATE INDEX ON "Bot" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Bot_History" ("id")'); await client.query('CREATE INDEX ON "Bot_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "Login" ("lastUpdated")'); await client.query('CREATE INDEX ON "Login" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Login_History" ("id")'); await client.query('CREATE INDEX ON "Login_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "PasswordChangeRequest" ("lastUpdated")'); await client.query('CREATE INDEX ON "PasswordChangeRequest" USING GIN("compartments")'); await client.query('CREATE INDEX ON "PasswordChangeRequest_History" ("id")'); await client.query('CREATE INDEX ON "PasswordChangeRequest_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "JsonWebKey" ("lastUpdated")'); await client.query('CREATE INDEX ON "JsonWebKey" USING GIN("compartments")'); await client.query('CREATE INDEX ON "JsonWebKey_History" ("id")'); await client.query('CREATE INDEX ON "JsonWebKey_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "AccessPolicy" ("lastUpdated")'); await client.query('CREATE INDEX ON "AccessPolicy" USING GIN("compartments")'); await client.query('CREATE INDEX ON "AccessPolicy_History" ("id")'); await client.query('CREATE INDEX ON "AccessPolicy_History" ("lastUpdated")'); await client.query('CREATE INDEX ON "UserConfiguration" ("lastUpdated")'); await client.query('CREATE INDEX ON "UserConfiguration" USING GIN("compartments")'); await client.query('CREATE INDEX ON "UserConfiguration_History" ("id")'); await client.query('CREATE INDEX ON "UserConfiguration_History" ("lastUpdated")'); // A few manually curated indexes based on current query traffic. // These should be extended to all search columns in the future. await client.query('CREATE INDEX ON "Communication" USING GIN("basedOn")'); await client.query('CREATE INDEX ON "DiagnosticReport" USING GIN("basedOn")'); await client.query('CREATE INDEX ON "Media" USING GIN("basedOn")'); await client.query('CREATE INDEX ON "Observation" USING GIN("basedOn")'); await client.query('CREATE INDEX ON "Specimen" ("patient")'); await client.query('CREATE INDEX ON "Specimen" ("subject")'); }