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('ALTER TABLE IF EXISTS "Account" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "ActivityDefinition" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "ActivityDefinition" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "ActivityDefinition" DROP COLUMN IF EXISTS "topic"'); await client.query('ALTER TABLE IF EXISTS "ActivityDefinition" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "ActivityDefinition" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "AdverseEvent" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "AdverseEvent" DROP COLUMN IF EXISTS "event"'); await client.query('ALTER TABLE IF EXISTS "AdverseEvent" DROP COLUMN IF EXISTS "seriousness"'); await client.query('ALTER TABLE IF EXISTS "AdverseEvent" DROP COLUMN IF EXISTS "severity"'); await client.query('ALTER TABLE IF EXISTS "AllergyIntolerance" DROP COLUMN IF EXISTS "clinicalStatus"'); await client.query('ALTER TABLE IF EXISTS "AllergyIntolerance" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "AllergyIntolerance" DROP COLUMN IF EXISTS "manifestation"'); await client.query('ALTER TABLE IF EXISTS "AllergyIntolerance" DROP COLUMN IF EXISTS "route"'); await client.query('ALTER TABLE IF EXISTS "AllergyIntolerance" DROP COLUMN IF EXISTS "verificationStatus"'); await client.query('ALTER TABLE IF EXISTS "Appointment" DROP COLUMN IF EXISTS "appointmentType"'); await client.query('ALTER TABLE IF EXISTS "Appointment" DROP COLUMN IF EXISTS "reasonCode"'); await client.query('ALTER TABLE IF EXISTS "Appointment" DROP COLUMN IF EXISTS "serviceCategory"'); await client.query('ALTER TABLE IF EXISTS "Appointment" DROP COLUMN IF EXISTS "serviceType"'); await client.query('ALTER TABLE IF EXISTS "Appointment" DROP COLUMN IF EXISTS "specialty"'); await client.query('ALTER TABLE IF EXISTS "AuditEvent" DROP COLUMN IF EXISTS "agentRole"'); await client.query('ALTER TABLE IF EXISTS "AuditEvent" DROP COLUMN IF EXISTS "entityRole"'); await client.query('ALTER TABLE IF EXISTS "AuditEvent" DROP COLUMN IF EXISTS "entityType"'); await client.query('ALTER TABLE IF EXISTS "AuditEvent" DROP COLUMN IF EXISTS "subtype"'); await client.query('ALTER TABLE IF EXISTS "AuditEvent" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "Basic" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "BodyStructure" DROP COLUMN IF EXISTS "location"'); await client.query('ALTER TABLE IF EXISTS "BodyStructure" DROP COLUMN IF EXISTS "morphology"'); await client.query('ALTER TABLE IF EXISTS "CapabilityStatement" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "CapabilityStatement" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "CapabilityStatement" DROP COLUMN IF EXISTS "securityService"'); await client.query('ALTER TABLE IF EXISTS "CapabilityStatement" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "CapabilityStatement" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "CarePlan" DROP COLUMN IF EXISTS "activityCode"'); await client.query('ALTER TABLE IF EXISTS "CarePlan" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "CareTeam" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "ChargeItem" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "ChargeItem" DROP COLUMN IF EXISTS "performerFunction"'); await client.query('ALTER TABLE IF EXISTS "ChargeItemDefinition" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "ChargeItemDefinition" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "ChargeItemDefinition" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "ChargeItemDefinition" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "Claim" DROP COLUMN IF EXISTS "priority"'); await client.query('ALTER TABLE IF EXISTS "ClinicalImpression" DROP COLUMN IF EXISTS "findingCode"'); await client.query('ALTER TABLE IF EXISTS "CodeSystem" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "CodeSystem" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "CodeSystem" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "CodeSystem" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "Communication" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "Communication" DROP COLUMN IF EXISTS "medium"'); await client.query('ALTER TABLE IF EXISTS "CommunicationRequest" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "CommunicationRequest" DROP COLUMN IF EXISTS "groupIdentifier"'); await client.query('ALTER TABLE IF EXISTS "CommunicationRequest" DROP COLUMN IF EXISTS "medium"'); await client.query('ALTER TABLE IF EXISTS "CompartmentDefinition" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "CompartmentDefinition" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "CompartmentDefinition" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "Composition" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "Composition" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "Composition" DROP COLUMN IF EXISTS "context"'); await client.query('ALTER TABLE IF EXISTS "Composition" DROP COLUMN IF EXISTS "section"'); await client.query('ALTER TABLE IF EXISTS "ConceptMap" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "ConceptMap" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "ConceptMap" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "ConceptMap" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "Condition" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "Condition" DROP COLUMN IF EXISTS "bodySite"'); await client.query('ALTER TABLE IF EXISTS "Condition" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "Condition" DROP COLUMN IF EXISTS "clinicalStatus"'); await client.query('ALTER TABLE IF EXISTS "Condition" DROP COLUMN IF EXISTS "evidence"'); await client.query('ALTER TABLE IF EXISTS "Condition" DROP COLUMN IF EXISTS "severity"'); await client.query('ALTER TABLE IF EXISTS "Condition" DROP COLUMN IF EXISTS "stage"'); await client.query('ALTER TABLE IF EXISTS "Condition" DROP COLUMN IF EXISTS "verificationStatus"'); await client.query('ALTER TABLE IF EXISTS "Consent" DROP COLUMN IF EXISTS "action"'); await client.query('ALTER TABLE IF EXISTS "Consent" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "Consent" DROP COLUMN IF EXISTS "purpose"'); await client.query('ALTER TABLE IF EXISTS "Consent" DROP COLUMN IF EXISTS "scope"'); await client.query('ALTER TABLE IF EXISTS "Consent" DROP COLUMN IF EXISTS "securityLabel"'); await client.query('ALTER TABLE IF EXISTS "Coverage" DROP COLUMN IF EXISTS "classType"'); await client.query('ALTER TABLE IF EXISTS "Coverage" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "DetectedIssue" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "Device" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "DeviceDefinition" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "DeviceDefinition" DROP COLUMN IF EXISTS "classification"'); await client.query('ALTER TABLE IF EXISTS "DeviceMetric" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "DeviceRequest" DROP COLUMN IF EXISTS "groupIdentifier"'); await client.query('ALTER TABLE IF EXISTS "DiagnosticReport" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "DiagnosticReport" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "DiagnosticReport" DROP COLUMN IF EXISTS "conclusion"'); await client.query('ALTER TABLE IF EXISTS "DocumentManifest" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "DocumentManifest" DROP COLUMN IF EXISTS "relatedId"'); await client.query('ALTER TABLE IF EXISTS "DocumentReference" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "DocumentReference" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "DocumentReference" DROP COLUMN IF EXISTS "event"'); await client.query('ALTER TABLE IF EXISTS "DocumentReference" DROP COLUMN IF EXISTS "facility"'); await client.query('ALTER TABLE IF EXISTS "DocumentReference" DROP COLUMN IF EXISTS "format"'); await client.query('ALTER TABLE IF EXISTS "DocumentReference" DROP COLUMN IF EXISTS "securityLabel"'); await client.query('ALTER TABLE IF EXISTS "DocumentReference" DROP COLUMN IF EXISTS "setting"'); await client.query('ALTER TABLE IF EXISTS "DocumentReference" DROP COLUMN IF EXISTS "relationship"'); await client.query('ALTER TABLE IF EXISTS "EffectEvidenceSynthesis" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "EffectEvidenceSynthesis" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "EffectEvidenceSynthesis" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "EffectEvidenceSynthesis" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "Encounter" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "Encounter" DROP COLUMN IF EXISTS "class"'); await client.query('ALTER TABLE IF EXISTS "Encounter" DROP COLUMN IF EXISTS "participantType"'); await client.query('ALTER TABLE IF EXISTS "Encounter" DROP COLUMN IF EXISTS "reasonCode"'); await client.query('ALTER TABLE IF EXISTS "Encounter" DROP COLUMN IF EXISTS "specialArrangement"'); await client.query('ALTER TABLE IF EXISTS "Endpoint" DROP COLUMN IF EXISTS "connectionType"'); await client.query('ALTER TABLE IF EXISTS "Endpoint" DROP COLUMN IF EXISTS "payloadType"'); await client.query('ALTER TABLE IF EXISTS "EpisodeOfCare" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "EventDefinition" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "EventDefinition" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "EventDefinition" DROP COLUMN IF EXISTS "topic"'); await client.query('ALTER TABLE IF EXISTS "EventDefinition" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "EventDefinition" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "Evidence" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "Evidence" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "Evidence" DROP COLUMN IF EXISTS "topic"'); await client.query('ALTER TABLE IF EXISTS "Evidence" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "Evidence" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "EvidenceVariable" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "EvidenceVariable" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "EvidenceVariable" DROP COLUMN IF EXISTS "topic"'); await client.query('ALTER TABLE IF EXISTS "EvidenceVariable" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "EvidenceVariable" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "ExampleScenario" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "ExampleScenario" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "ExampleScenario" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "ExampleScenario" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "FamilyMemberHistory" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "FamilyMemberHistory" DROP COLUMN IF EXISTS "relationship"'); await client.query('ALTER TABLE IF EXISTS "FamilyMemberHistory" DROP COLUMN IF EXISTS "sex"'); await client.query('ALTER TABLE IF EXISTS "Goal" DROP COLUMN IF EXISTS "achievementStatus"'); await client.query('ALTER TABLE IF EXISTS "Goal" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "GraphDefinition" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "GraphDefinition" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "GraphDefinition" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "GraphDefinition" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "Group" DROP COLUMN IF EXISTS "characteristic"'); await client.query('ALTER TABLE IF EXISTS "Group" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "Group" DROP COLUMN IF EXISTS "characteristicValue"'); await client.query('ALTER TABLE IF EXISTS "GuidanceResponse" DROP COLUMN IF EXISTS "request"'); await client.query('ALTER TABLE IF EXISTS "HealthcareService" DROP COLUMN IF EXISTS "characteristic"'); await client.query('ALTER TABLE IF EXISTS "HealthcareService" DROP COLUMN IF EXISTS "program"'); await client.query('ALTER TABLE IF EXISTS "HealthcareService" DROP COLUMN IF EXISTS "serviceCategory"'); await client.query('ALTER TABLE IF EXISTS "HealthcareService" DROP COLUMN IF EXISTS "serviceType"'); await client.query('ALTER TABLE IF EXISTS "HealthcareService" DROP COLUMN IF EXISTS "specialty"'); await client.query('ALTER TABLE IF EXISTS "ImagingStudy" DROP COLUMN IF EXISTS "bodysite"'); await client.query('ALTER TABLE IF EXISTS "ImagingStudy" DROP COLUMN IF EXISTS "dicomClass"'); await client.query('ALTER TABLE IF EXISTS "ImagingStudy" DROP COLUMN IF EXISTS "modality"'); await client.query('ALTER TABLE IF EXISTS "ImagingStudy" DROP COLUMN IF EXISTS "reason"'); await client.query('ALTER TABLE IF EXISTS "Immunization" DROP COLUMN IF EXISTS "reasonCode"'); await client.query('ALTER TABLE IF EXISTS "Immunization" DROP COLUMN IF EXISTS "statusReason"'); await client.query('ALTER TABLE IF EXISTS "Immunization" DROP COLUMN IF EXISTS "targetDisease"'); await client.query('ALTER TABLE IF EXISTS "Immunization" DROP COLUMN IF EXISTS "vaccineCode"'); await client.query('ALTER TABLE IF EXISTS "ImmunizationEvaluation" DROP COLUMN IF EXISTS "doseStatus"'); await client.query('ALTER TABLE IF EXISTS "ImmunizationEvaluation" DROP COLUMN IF EXISTS "targetDisease"'); await client.query('ALTER TABLE IF EXISTS "ImmunizationRecommendation" DROP COLUMN IF EXISTS "status"'); await client.query('ALTER TABLE IF EXISTS "ImmunizationRecommendation" DROP COLUMN IF EXISTS "targetDisease"'); await client.query('ALTER TABLE IF EXISTS "ImmunizationRecommendation" DROP COLUMN IF EXISTS "vaccineType"'); await client.query('ALTER TABLE IF EXISTS "ImplementationGuide" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "ImplementationGuide" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "ImplementationGuide" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "ImplementationGuide" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "InsurancePlan" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "Invoice" DROP COLUMN IF EXISTS "participantRole"'); await client.query('ALTER TABLE IF EXISTS "Invoice" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "Library" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "Library" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "Library" DROP COLUMN IF EXISTS "topic"'); await client.query('ALTER TABLE IF EXISTS "Library" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "Library" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "Library" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "List" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "List" DROP COLUMN IF EXISTS "emptyReason"'); await client.query('ALTER TABLE IF EXISTS "Location" DROP COLUMN IF EXISTS "operationalStatus"'); await client.query('ALTER TABLE IF EXISTS "Location" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "Measure" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "Measure" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "Measure" DROP COLUMN IF EXISTS "topic"'); await client.query('ALTER TABLE IF EXISTS "Measure" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "Measure" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "Media" DROP COLUMN IF EXISTS "modality"'); await client.query('ALTER TABLE IF EXISTS "Media" DROP COLUMN IF EXISTS "site"'); await client.query('ALTER TABLE IF EXISTS "Media" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "Media" DROP COLUMN IF EXISTS "view"'); await client.query('ALTER TABLE IF EXISTS "Medication" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "Medication" DROP COLUMN IF EXISTS "form"'); await client.query('ALTER TABLE IF EXISTS "MedicationAdministration" DROP COLUMN IF EXISTS "reasonGiven"'); await client.query('ALTER TABLE IF EXISTS "MedicationAdministration" DROP COLUMN IF EXISTS "reasonNotGiven"'); await client.query('ALTER TABLE IF EXISTS "MedicationDispense" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "MedicationKnowledge" DROP COLUMN IF EXISTS "classification"'); await client.query('ALTER TABLE IF EXISTS "MedicationKnowledge" DROP COLUMN IF EXISTS "classificationType"'); await client.query('ALTER TABLE IF EXISTS "MedicationKnowledge" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "MedicationKnowledge" DROP COLUMN IF EXISTS "doseform"'); await client.query('ALTER TABLE IF EXISTS "MedicationKnowledge" DROP COLUMN IF EXISTS "monitoringProgramType"'); await client.query('ALTER TABLE IF EXISTS "MedicationKnowledge" DROP COLUMN IF EXISTS "monographType"'); await client.query('ALTER TABLE IF EXISTS "MedicationRequest" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "MedicationRequest" DROP COLUMN IF EXISTS "intendedPerformertype"'); await client.query('ALTER TABLE IF EXISTS "MedicationStatement" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "MedicinalProduct" DROP COLUMN IF EXISTS "nameLanguage"'); await client.query('ALTER TABLE IF EXISTS "MedicinalProductAuthorization" DROP COLUMN IF EXISTS "country"'); await client.query('ALTER TABLE IF EXISTS "MedicinalProductAuthorization" DROP COLUMN IF EXISTS "status"'); await client.query('ALTER TABLE IF EXISTS "MedicinalProductPharmaceutical" DROP COLUMN IF EXISTS "route"'); await client.query('ALTER TABLE IF EXISTS "MedicinalProductPharmaceutical" DROP COLUMN IF EXISTS "targetSpecies"'); await client.query('ALTER TABLE IF EXISTS "MessageDefinition" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "MessageDefinition" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "MessageDefinition" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "MessageDefinition" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "MessageDefinition" DROP COLUMN IF EXISTS "event"'); await client.query('ALTER TABLE IF EXISTS "MessageHeader" DROP COLUMN IF EXISTS "event"'); await client.query('ALTER TABLE IF EXISTS "MolecularSequence" DROP COLUMN IF EXISTS "chromosome"'); await client.query('ALTER TABLE IF EXISTS "MolecularSequence" DROP COLUMN IF EXISTS "referenceseqid"'); await client.query('ALTER TABLE IF EXISTS "MolecularSequence" DROP COLUMN IF EXISTS "chromosomeVariantCoordinate"'); await client.query('ALTER TABLE IF EXISTS "MolecularSequence" DROP COLUMN IF EXISTS "chromosomeWindowCoordinate"'); await client.query( 'ALTER TABLE IF EXISTS "MolecularSequence" DROP COLUMN IF EXISTS "referenceseqidVariantCoordinate"' ); await client.query( 'ALTER TABLE IF EXISTS "MolecularSequence" DROP COLUMN IF EXISTS "referenceseqidWindowCoordinate"' ); await client.query('ALTER TABLE IF EXISTS "NamingSystem" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "NamingSystem" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "NamingSystem" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "NamingSystem" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "NamingSystem" DROP COLUMN IF EXISTS "telecom"'); await client.query('ALTER TABLE IF EXISTS "NamingSystem" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "NutritionOrder" DROP COLUMN IF EXISTS "additive"'); await client.query('ALTER TABLE IF EXISTS "NutritionOrder" DROP COLUMN IF EXISTS "formula"'); await client.query('ALTER TABLE IF EXISTS "NutritionOrder" DROP COLUMN IF EXISTS "oraldiet"'); await client.query('ALTER TABLE IF EXISTS "NutritionOrder" DROP COLUMN IF EXISTS "supplement"'); await client.query('ALTER TABLE IF EXISTS "Observation" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "Observation" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "Observation" DROP COLUMN IF EXISTS "comboCode"'); await client.query('ALTER TABLE IF EXISTS "Observation" DROP COLUMN IF EXISTS "comboDataAbsentReason"'); await client.query('ALTER TABLE IF EXISTS "Observation" DROP COLUMN IF EXISTS "componentCode"'); await client.query('ALTER TABLE IF EXISTS "Observation" DROP COLUMN IF EXISTS "componentDataAbsentReason"'); await client.query('ALTER TABLE IF EXISTS "Observation" DROP COLUMN IF EXISTS "dataAbsentReason"'); await client.query('ALTER TABLE IF EXISTS "Observation" DROP COLUMN IF EXISTS "method"'); await client.query('ALTER TABLE IF EXISTS "Observation" DROP COLUMN IF EXISTS "codeValueConcept"'); await client.query('ALTER TABLE IF EXISTS "Observation" DROP COLUMN IF EXISTS "codeValueDate"'); await client.query('ALTER TABLE IF EXISTS "Observation" DROP COLUMN IF EXISTS "codeValueQuantity"'); await client.query('ALTER TABLE IF EXISTS "Observation" DROP COLUMN IF EXISTS "codeValueString"'); await client.query('ALTER TABLE IF EXISTS "Observation" DROP COLUMN IF EXISTS "comboCodeValueConcept"'); await client.query('ALTER TABLE IF EXISTS "Observation" DROP COLUMN IF EXISTS "comboCodeValueQuantity"'); await client.query('ALTER TABLE IF EXISTS "Observation" DROP COLUMN IF EXISTS "componentCodeValueConcept"'); await client.query('ALTER TABLE IF EXISTS "Observation" DROP COLUMN IF EXISTS "componentCodeValueQuantity"'); await client.query('ALTER TABLE IF EXISTS "ObservationDefinition" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "OperationDefinition" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "OperationDefinition" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "OperationDefinition" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "OperationDefinition" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "Organization" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "OrganizationAffiliation" DROP COLUMN IF EXISTS "role"'); await client.query('ALTER TABLE IF EXISTS "OrganizationAffiliation" DROP COLUMN IF EXISTS "specialty"'); await client.query('ALTER TABLE IF EXISTS "Patient" DROP COLUMN IF EXISTS "language"'); await client.query('ALTER TABLE IF EXISTS "PaymentNotice" DROP COLUMN IF EXISTS "paymentStatus"'); await client.query('ALTER TABLE IF EXISTS "PlanDefinition" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "PlanDefinition" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "PlanDefinition" DROP COLUMN IF EXISTS "topic"'); await client.query('ALTER TABLE IF EXISTS "PlanDefinition" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "PlanDefinition" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "PlanDefinition" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "Practitioner" DROP COLUMN IF EXISTS "communication"'); await client.query('ALTER TABLE IF EXISTS "PractitionerRole" DROP COLUMN IF EXISTS "role"'); await client.query('ALTER TABLE IF EXISTS "PractitionerRole" DROP COLUMN IF EXISTS "specialty"'); await client.query('ALTER TABLE IF EXISTS "Procedure" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "Procedure" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "Procedure" DROP COLUMN IF EXISTS "reasonCode"'); await client.query('ALTER TABLE IF EXISTS "Provenance" DROP COLUMN IF EXISTS "agentRole"'); await client.query('ALTER TABLE IF EXISTS "Provenance" DROP COLUMN IF EXISTS "agentType"'); await client.query('ALTER TABLE IF EXISTS "Provenance" DROP COLUMN IF EXISTS "signatureType"'); await client.query('ALTER TABLE IF EXISTS "Questionnaire" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "Questionnaire" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "Questionnaire" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "Questionnaire" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "Questionnaire" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "RelatedPerson" DROP COLUMN IF EXISTS "relationship"'); await client.query('ALTER TABLE IF EXISTS "RequestGroup" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "RequestGroup" DROP COLUMN IF EXISTS "groupIdentifier"'); await client.query('ALTER TABLE IF EXISTS "ResearchDefinition" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "ResearchDefinition" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "ResearchDefinition" DROP COLUMN IF EXISTS "topic"'); await client.query('ALTER TABLE IF EXISTS "ResearchDefinition" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "ResearchDefinition" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "ResearchElementDefinition" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "ResearchElementDefinition" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "ResearchElementDefinition" DROP COLUMN IF EXISTS "topic"'); await client.query('ALTER TABLE IF EXISTS "ResearchElementDefinition" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "ResearchElementDefinition" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "ResearchStudy" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "ResearchStudy" DROP COLUMN IF EXISTS "focus"'); await client.query('ALTER TABLE IF EXISTS "ResearchStudy" DROP COLUMN IF EXISTS "keyword"'); await client.query('ALTER TABLE IF EXISTS "ResearchStudy" DROP COLUMN IF EXISTS "location"'); await client.query('ALTER TABLE IF EXISTS "RiskAssessment" DROP COLUMN IF EXISTS "method"'); await client.query('ALTER TABLE IF EXISTS "RiskAssessment" DROP COLUMN IF EXISTS "risk"'); await client.query('ALTER TABLE IF EXISTS "RiskEvidenceSynthesis" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "RiskEvidenceSynthesis" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "RiskEvidenceSynthesis" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "RiskEvidenceSynthesis" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "Schedule" DROP COLUMN IF EXISTS "serviceCategory"'); await client.query('ALTER TABLE IF EXISTS "Schedule" DROP COLUMN IF EXISTS "serviceType"'); await client.query('ALTER TABLE IF EXISTS "Schedule" DROP COLUMN IF EXISTS "specialty"'); await client.query('ALTER TABLE IF EXISTS "SearchParameter" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "SearchParameter" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "SearchParameter" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "SearchParameter" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "ServiceRequest" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "ServiceRequest" DROP COLUMN IF EXISTS "bodySite"'); await client.query('ALTER TABLE IF EXISTS "ServiceRequest" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "ServiceRequest" DROP COLUMN IF EXISTS "performerType"'); await client.query('ALTER TABLE IF EXISTS "ServiceRequest" DROP COLUMN IF EXISTS "requisition"'); await client.query('ALTER TABLE IF EXISTS "Slot" DROP COLUMN IF EXISTS "appointmentType"'); await client.query('ALTER TABLE IF EXISTS "Slot" DROP COLUMN IF EXISTS "serviceCategory"'); await client.query('ALTER TABLE IF EXISTS "Slot" DROP COLUMN IF EXISTS "serviceType"'); await client.query('ALTER TABLE IF EXISTS "Slot" DROP COLUMN IF EXISTS "specialty"'); await client.query('ALTER TABLE IF EXISTS "Specimen" DROP COLUMN IF EXISTS "accession"'); await client.query('ALTER TABLE IF EXISTS "Specimen" DROP COLUMN IF EXISTS "bodysite"'); await client.query('ALTER TABLE IF EXISTS "Specimen" DROP COLUMN IF EXISTS "container"'); await client.query('ALTER TABLE IF EXISTS "Specimen" DROP COLUMN IF EXISTS "containerId"'); await client.query('ALTER TABLE IF EXISTS "Specimen" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "SpecimenDefinition" DROP COLUMN IF EXISTS "container"'); await client.query('ALTER TABLE IF EXISTS "SpecimenDefinition" DROP COLUMN IF EXISTS "type"'); await client.query('ALTER TABLE IF EXISTS "StructureDefinition" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "StructureDefinition" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "StructureDefinition" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "StructureDefinition" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "StructureDefinition" DROP COLUMN IF EXISTS "keyword"'); await client.query('ALTER TABLE IF EXISTS "StructureMap" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "StructureMap" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "StructureMap" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "StructureMap" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "Subscription" DROP COLUMN IF EXISTS "contact"'); await client.query('ALTER TABLE IF EXISTS "Substance" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "Substance" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "Substance" DROP COLUMN IF EXISTS "containerIdentifier"'); await client.query('ALTER TABLE IF EXISTS "SubstanceSpecification" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "SupplyRequest" DROP COLUMN IF EXISTS "category"'); await client.query('ALTER TABLE IF EXISTS "Task" DROP COLUMN IF EXISTS "businessStatus"'); await client.query('ALTER TABLE IF EXISTS "Task" DROP COLUMN IF EXISTS "code"'); await client.query('ALTER TABLE IF EXISTS "Task" DROP COLUMN IF EXISTS "groupIdentifier"'); await client.query('ALTER TABLE IF EXISTS "Task" DROP COLUMN IF EXISTS "performer"'); await client.query('ALTER TABLE IF EXISTS "TerminologyCapabilities" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "TerminologyCapabilities" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "TerminologyCapabilities" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "TerminologyCapabilities" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "TestScript" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "TestScript" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "TestScript" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "TestScript" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "ValueSet" DROP COLUMN IF EXISTS "contextType"'); await client.query('ALTER TABLE IF EXISTS "ValueSet" DROP COLUMN IF EXISTS "jurisdiction"'); await client.query('ALTER TABLE IF EXISTS "ValueSet" DROP COLUMN IF EXISTS "contextTypeQuantity"'); await client.query('ALTER TABLE IF EXISTS "ValueSet" DROP COLUMN IF EXISTS "contextTypeValue"'); await client.query('ALTER TABLE IF EXISTS "UserSecurityRequest_Token" DROP COLUMN IF EXISTS "index"'); await client.query('ALTER TABLE IF EXISTS "AsyncJob" DROP COLUMN IF EXISTS "status"'); await client.query('ALTER TABLE IF EXISTS "AsyncJob" DROP COLUMN IF EXISTS "user"'); await client.query('ALTER TABLE IF EXISTS "ContactPoint" DROP COLUMN IF EXISTS "id"'); await client.query('ALTER TABLE IF EXISTS "ContactPoint" DROP COLUMN IF EXISTS "index"'); await client.query('ALTER TABLE IF EXISTS "ContactPoint" DROP COLUMN IF EXISTS "content"'); await client.query('ALTER TABLE IF EXISTS "Identifier" DROP COLUMN IF EXISTS "id"'); await client.query('ALTER TABLE IF EXISTS "Identifier" DROP COLUMN IF EXISTS "index"'); await client.query('ALTER TABLE IF EXISTS "Identifier" DROP COLUMN IF EXISTS "content"'); await client.query('ALTER TABLE IF EXISTS "ValueSetElement" DROP COLUMN IF EXISTS "valueSet"'); await client.query('ALTER TABLE IF EXISTS "ValueSetElement" DROP COLUMN IF EXISTS "index"'); }