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 "Account" ALTER COLUMN "patient" TYPE TEXT[] USING array["patient"]::TEXT[]'); await client.query('ALTER TABLE "Account" ALTER COLUMN "period" TYPE DATE USING "period"::DATE'); await client.query( 'ALTER TABLE "ActivityDefinition" ALTER COLUMN "composedOf" TYPE TEXT[] USING array["composedOf"]::TEXT[]' ); await client.query( 'ALTER TABLE "ActivityDefinition" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]' ); await client.query( 'ALTER TABLE "ActivityDefinition" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "ActivityDefinition" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "ActivityDefinition" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "ActivityDefinition" ALTER COLUMN "dependsOn" TYPE TEXT[] USING array["dependsOn"]::TEXT[]' ); await client.query( 'ALTER TABLE "ActivityDefinition" ALTER COLUMN "derivedFrom" TYPE TEXT[] USING array["derivedFrom"]::TEXT[]' ); await client.query('ALTER TABLE "ActivityDefinition" ALTER COLUMN "effective" TYPE DATE USING "effective"::DATE'); await client.query( 'ALTER TABLE "ActivityDefinition" ALTER COLUMN "predecessor" TYPE TEXT[] USING array["predecessor"]::TEXT[]' ); await client.query( 'ALTER TABLE "ActivityDefinition" ALTER COLUMN "successor" TYPE TEXT[] USING array["successor"]::TEXT[]' ); await client.query( 'ALTER TABLE "ActivityDefinition" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "ActivityDefinition" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "AdverseEvent" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "AdverseEvent" ALTER COLUMN "resultingcondition" TYPE TEXT[] USING array["resultingcondition"]::TEXT[]' ); await client.query( 'ALTER TABLE "AdverseEvent" ALTER COLUMN "substance" TYPE TEXT[] USING array["substance"]::TEXT[]' ); await client.query('ALTER TABLE "AllergyIntolerance" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "AllergyIntolerance" ALTER COLUMN "lastDate" TYPE DATE USING "lastDate"::DATE'); await client.query( 'ALTER TABLE "AllergyIntolerance" ALTER COLUMN "manifestation" TYPE TEXT[] USING array["manifestation"]::TEXT[]' ); await client.query('ALTER TABLE "AllergyIntolerance" ALTER COLUMN "onset" TYPE DATE[] USING array["onset"]::DATE[]'); await client.query('ALTER TABLE "AllergyIntolerance" ALTER COLUMN "route" TYPE TEXT[] USING array["route"]::TEXT[]'); await client.query( 'ALTER TABLE "AllergyIntolerance" ALTER COLUMN "severity" TYPE TEXT[] USING array["severity"]::TEXT[]' ); await client.query('ALTER TABLE "Appointment" ALTER COLUMN "actor" TYPE TEXT[] USING array["actor"]::TEXT[]'); await client.query('ALTER TABLE "Appointment" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "Appointment" ALTER COLUMN "location" TYPE TEXT[] USING array["location"]::TEXT[]'); await client.query( 'ALTER TABLE "Appointment" ALTER COLUMN "partStatus" TYPE TEXT[] USING array["partStatus"]::TEXT[]' ); await client.query('ALTER TABLE "Appointment" ALTER COLUMN "patient" TYPE TEXT[] USING array["patient"]::TEXT[]'); await client.query( 'ALTER TABLE "Appointment" ALTER COLUMN "practitioner" TYPE TEXT[] USING array["practitioner"]::TEXT[]' ); await client.query( 'ALTER TABLE "Appointment" ALTER COLUMN "supportingInfo" TYPE TEXT[] USING array["supportingInfo"]::TEXT[]' ); await client.query('ALTER TABLE "AuditEvent" ALTER COLUMN "address" TYPE TEXT[] USING array["address"]::TEXT[]'); await client.query('ALTER TABLE "AuditEvent" ALTER COLUMN "agentName" TYPE TEXT[] USING array["agentName"]::TEXT[]'); await client.query('ALTER TABLE "AuditEvent" ALTER COLUMN "agentRole" TYPE TEXT[] USING array["agentRole"]::TEXT[]'); await client.query('ALTER TABLE "AuditEvent" ALTER COLUMN "altid" TYPE TEXT[] USING array["altid"]::TEXT[]'); await client.query('ALTER TABLE "AuditEvent" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "AuditEvent" ALTER COLUMN "entityName" TYPE TEXT[] USING array["entityName"]::TEXT[]' ); await client.query( 'ALTER TABLE "AuditEvent" ALTER COLUMN "entityRole" TYPE TEXT[] USING array["entityRole"]::TEXT[]' ); await client.query( 'ALTER TABLE "AuditEvent" ALTER COLUMN "entityType" TYPE TEXT[] USING array["entityType"]::TEXT[]' ); await client.query('ALTER TABLE "AuditEvent" ALTER COLUMN "patient" TYPE TEXT[] USING array["patient"]::TEXT[]'); await client.query('ALTER TABLE "AuditEvent" ALTER COLUMN "policy" TYPE TEXT[] USING array["policy"]::TEXT[]'); await client.query('ALTER TABLE "Basic" ALTER COLUMN "created" TYPE DATE USING "created"::DATE'); await client.query('ALTER TABLE "Bundle" ALTER COLUMN "timestamp" TYPE DATE USING "timestamp"::DATE'); await client.query( 'ALTER TABLE "CapabilityStatement" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]' ); await client.query( 'ALTER TABLE "CapabilityStatement" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "CapabilityStatement" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "CapabilityStatement" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "CapabilityStatement" ALTER COLUMN "guide" TYPE TEXT[] USING array["guide"]::TEXT[]'); await client.query('ALTER TABLE "CapabilityStatement" ALTER COLUMN "mode" TYPE TEXT[] USING array["mode"]::TEXT[]'); await client.query( 'ALTER TABLE "CapabilityStatement" ALTER COLUMN "resource" TYPE TEXT[] USING array["resource"]::TEXT[]' ); await client.query( 'ALTER TABLE "CapabilityStatement" ALTER COLUMN "resourceProfile" TYPE TEXT[] USING array["resourceProfile"]::TEXT[]' ); await client.query( 'ALTER TABLE "CapabilityStatement" ALTER COLUMN "securityService" TYPE TEXT[] USING array["securityService"]::TEXT[]' ); await client.query( 'ALTER TABLE "CapabilityStatement" ALTER COLUMN "supportedProfile" TYPE TEXT[] USING array["supportedProfile"]::TEXT[]' ); await client.query( 'ALTER TABLE "CapabilityStatement" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "CapabilityStatement" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "CarePlan" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "CarePlan" ALTER COLUMN "activityCode" TYPE TEXT[] USING array["activityCode"]::TEXT[]' ); await client.query( 'ALTER TABLE "CarePlan" ALTER COLUMN "activityDate" TYPE TEXT[] USING array["activityDate"]::TEXT[]' ); await client.query( 'ALTER TABLE "CarePlan" ALTER COLUMN "activityReference" TYPE TEXT[] USING array["activityReference"]::TEXT[]' ); await client.query('ALTER TABLE "CarePlan" ALTER COLUMN "condition" TYPE TEXT[] USING array["condition"]::TEXT[]'); await client.query('ALTER TABLE "CarePlan" ALTER COLUMN "performer" TYPE TEXT[] USING array["performer"]::TEXT[]'); await client.query('ALTER TABLE "CareTeam" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "ChargeItem" ALTER COLUMN "enteredDate" TYPE DATE USING "enteredDate"::DATE'); await client.query( 'ALTER TABLE "ChargeItem" ALTER COLUMN "factorOverride" TYPE DOUBLE PRECISION USING "factorOverride"::DOUBLE PRECISION' ); await client.query( 'ALTER TABLE "ChargeItem" ALTER COLUMN "performerActor" TYPE TEXT[] USING array["performerActor"]::TEXT[]' ); await client.query( 'ALTER TABLE "ChargeItem" ALTER COLUMN "performerFunction" TYPE TEXT[] USING array["performerFunction"]::TEXT[]' ); await client.query( 'ALTER TABLE "ChargeItem" ALTER COLUMN "priceOverride" TYPE DOUBLE PRECISION USING "priceOverride"::DOUBLE PRECISION' ); await client.query( 'ALTER TABLE "ChargeItem" ALTER COLUMN "quantity" TYPE DOUBLE PRECISION USING "quantity"::DOUBLE PRECISION' ); await client.query( 'ALTER TABLE "ChargeItemDefinition" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]' ); await client.query( 'ALTER TABLE "ChargeItemDefinition" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "ChargeItemDefinition" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "ChargeItemDefinition" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "ChargeItemDefinition" ALTER COLUMN "effective" TYPE DATE USING "effective"::DATE'); await client.query( 'ALTER TABLE "ChargeItemDefinition" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "ChargeItemDefinition" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "Claim" ALTER COLUMN "created" TYPE DATE USING "created"::DATE'); await client.query('ALTER TABLE "Claim" ALTER COLUMN "detailUdi" TYPE TEXT[] USING array["detailUdi"]::TEXT[]'); await client.query('ALTER TABLE "Claim" ALTER COLUMN "encounter" TYPE TEXT[] USING array["encounter"]::TEXT[]'); await client.query('ALTER TABLE "Claim" ALTER COLUMN "itemUdi" TYPE TEXT[] USING array["itemUdi"]::TEXT[]'); await client.query('ALTER TABLE "Claim" ALTER COLUMN "procedureUdi" TYPE TEXT[] USING array["procedureUdi"]::TEXT[]'); await client.query('ALTER TABLE "Claim" ALTER COLUMN "subdetailUdi" TYPE TEXT[] USING array["subdetailUdi"]::TEXT[]'); await client.query('ALTER TABLE "ClaimResponse" ALTER COLUMN "created" TYPE DATE USING "created"::DATE'); await client.query('ALTER TABLE "ClaimResponse" ALTER COLUMN "paymentDate" TYPE DATE USING "paymentDate"::DATE'); await client.query('ALTER TABLE "ClinicalImpression" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "ClinicalImpression" ALTER COLUMN "findingCode" TYPE TEXT[] USING array["findingCode"]::TEXT[]' ); await client.query( 'ALTER TABLE "ClinicalImpression" ALTER COLUMN "findingRef" TYPE TEXT[] USING array["findingRef"]::TEXT[]' ); await client.query('ALTER TABLE "CodeSystem" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]'); await client.query( 'ALTER TABLE "CodeSystem" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "CodeSystem" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "CodeSystem" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "CodeSystem" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "CodeSystem" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "CodeSystem" ALTER COLUMN "code" TYPE TEXT[] USING array["code"]::TEXT[]'); await client.query('ALTER TABLE "CodeSystem" ALTER COLUMN "language" TYPE TEXT[] USING array["language"]::TEXT[]'); await client.query('ALTER TABLE "Communication" ALTER COLUMN "received" TYPE DATE USING "received"::DATE'); await client.query('ALTER TABLE "Communication" ALTER COLUMN "sent" TYPE DATE USING "sent"::DATE'); await client.query('ALTER TABLE "CommunicationRequest" ALTER COLUMN "authored" TYPE DATE USING "authored"::DATE'); await client.query( 'ALTER TABLE "CompartmentDefinition" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]' ); await client.query( 'ALTER TABLE "CompartmentDefinition" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "CompartmentDefinition" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "CompartmentDefinition" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "CompartmentDefinition" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "CompartmentDefinition" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "Composition" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "Composition" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]'); await client.query('ALTER TABLE "Composition" ALTER COLUMN "entry" TYPE TEXT[] USING array["entry"]::TEXT[]'); await client.query('ALTER TABLE "Composition" ALTER COLUMN "period" TYPE DATE[] USING array["period"]::DATE[]'); await client.query('ALTER TABLE "Composition" ALTER COLUMN "relatedId" TYPE TEXT[] USING array["relatedId"]::TEXT[]'); await client.query( 'ALTER TABLE "Composition" ALTER COLUMN "relatedRef" TYPE TEXT[] USING array["relatedRef"]::TEXT[]' ); await client.query('ALTER TABLE "ConceptMap" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]'); await client.query( 'ALTER TABLE "ConceptMap" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "ConceptMap" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "ConceptMap" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "ConceptMap" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "ConceptMap" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "ConceptMap" ALTER COLUMN "dependson" TYPE TEXT[] USING array["dependson"]::TEXT[]'); await client.query('ALTER TABLE "ConceptMap" ALTER COLUMN "other" TYPE TEXT[] USING array["other"]::TEXT[]'); await client.query('ALTER TABLE "ConceptMap" ALTER COLUMN "product" TYPE TEXT[] USING array["product"]::TEXT[]'); await client.query( 'ALTER TABLE "ConceptMap" ALTER COLUMN "sourceCode" TYPE TEXT[] USING array["sourceCode"]::TEXT[]' ); await client.query( 'ALTER TABLE "ConceptMap" ALTER COLUMN "sourceSystem" TYPE TEXT[] USING array["sourceSystem"]::TEXT[]' ); await client.query( 'ALTER TABLE "ConceptMap" ALTER COLUMN "targetCode" TYPE TEXT[] USING array["targetCode"]::TEXT[]' ); await client.query( 'ALTER TABLE "ConceptMap" ALTER COLUMN "targetSystem" TYPE TEXT[] USING array["targetSystem"]::TEXT[]' ); await client.query( 'ALTER TABLE "Condition" ALTER COLUMN "evidenceDetail" TYPE TEXT[] USING array["evidenceDetail"]::TEXT[]' ); await client.query('ALTER TABLE "Condition" ALTER COLUMN "recordedDate" TYPE DATE USING "recordedDate"::DATE'); await client.query('ALTER TABLE "Consent" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "Consent" ALTER COLUMN "action" TYPE TEXT[] USING array["action"]::TEXT[]'); await client.query('ALTER TABLE "Consent" ALTER COLUMN "actor" TYPE TEXT[] USING array["actor"]::TEXT[]'); await client.query('ALTER TABLE "Consent" ALTER COLUMN "consentor" TYPE TEXT[] USING array["consentor"]::TEXT[]'); await client.query('ALTER TABLE "Consent" ALTER COLUMN "data" TYPE TEXT[] USING array["data"]::TEXT[]'); await client.query('ALTER TABLE "Consent" ALTER COLUMN "period" TYPE DATE USING "period"::DATE'); await client.query('ALTER TABLE "Consent" ALTER COLUMN "purpose" TYPE TEXT[] USING array["purpose"]::TEXT[]'); await client.query( 'ALTER TABLE "Consent" ALTER COLUMN "securityLabel" TYPE TEXT[] USING array["securityLabel"]::TEXT[]' ); await client.query('ALTER TABLE "Contract" ALTER COLUMN "issued" TYPE DATE USING "issued"::DATE'); await client.query('ALTER TABLE "Contract" ALTER COLUMN "patient" TYPE TEXT[] USING array["patient"]::TEXT[]'); await client.query('ALTER TABLE "Coverage" ALTER COLUMN "classType" TYPE TEXT[] USING array["classType"]::TEXT[]'); await client.query('ALTER TABLE "Coverage" ALTER COLUMN "classValue" TYPE TEXT[] USING array["classValue"]::TEXT[]'); await client.query('ALTER TABLE "CoverageEligibilityRequest" ALTER COLUMN "created" TYPE DATE USING "created"::DATE'); await client.query( 'ALTER TABLE "CoverageEligibilityResponse" ALTER COLUMN "created" TYPE DATE USING "created"::DATE' ); await client.query('ALTER TABLE "Device" ALTER COLUMN "udiDi" TYPE TEXT[] USING array["udiDi"]::TEXT[]'); await client.query('ALTER TABLE "DeviceRequest" ALTER COLUMN "authoredOn" TYPE DATE USING "authoredOn"::DATE'); await client.query( 'ALTER TABLE "DiagnosticReport" ALTER COLUMN "conclusion" TYPE TEXT[] USING array["conclusion"]::TEXT[]' ); await client.query('ALTER TABLE "DiagnosticReport" ALTER COLUMN "issued" TYPE DATE USING "issued"::DATE'); await client.query('ALTER TABLE "DocumentManifest" ALTER COLUMN "created" TYPE DATE USING "created"::DATE'); await client.query('ALTER TABLE "DocumentManifest" ALTER COLUMN "item" TYPE TEXT[] USING array["item"]::TEXT[]'); await client.query( 'ALTER TABLE "DocumentManifest" ALTER COLUMN "relatedId" TYPE TEXT[] USING array["relatedId"]::TEXT[]' ); await client.query( 'ALTER TABLE "DocumentManifest" ALTER COLUMN "relatedRef" TYPE TEXT[] USING array["relatedRef"]::TEXT[]' ); await client.query( 'ALTER TABLE "DocumentReference" ALTER COLUMN "encounter" TYPE TEXT[] USING array["encounter"]::TEXT[]' ); await client.query( 'ALTER TABLE "DocumentReference" ALTER COLUMN "contenttype" TYPE TEXT[] USING array["contenttype"]::TEXT[]' ); await client.query('ALTER TABLE "DocumentReference" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "DocumentReference" ALTER COLUMN "event" TYPE TEXT[] USING array["event"]::TEXT[]'); await client.query('ALTER TABLE "DocumentReference" ALTER COLUMN "format" TYPE TEXT[] USING array["format"]::TEXT[]'); await client.query( 'ALTER TABLE "DocumentReference" ALTER COLUMN "language" TYPE TEXT[] USING array["language"]::TEXT[]' ); await client.query( 'ALTER TABLE "DocumentReference" ALTER COLUMN "location" TYPE TEXT[] USING array["location"]::TEXT[]' ); await client.query('ALTER TABLE "DocumentReference" ALTER COLUMN "period" TYPE DATE USING "period"::DATE'); await client.query( 'ALTER TABLE "DocumentReference" ALTER COLUMN "related" TYPE TEXT[] USING array["related"]::TEXT[]' ); await client.query( 'ALTER TABLE "DocumentReference" ALTER COLUMN "relatesto" TYPE TEXT[] USING array["relatesto"]::TEXT[]' ); await client.query( 'ALTER TABLE "DocumentReference" ALTER COLUMN "relation" TYPE TEXT[] USING array["relation"]::TEXT[]' ); await client.query( 'ALTER TABLE "DocumentReference" ALTER COLUMN "relationship" TYPE TEXT[] USING array["relationship"]::TEXT[]' ); await client.query( 'ALTER TABLE "EffectEvidenceSynthesis" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]' ); await client.query( 'ALTER TABLE "EffectEvidenceSynthesis" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "EffectEvidenceSynthesis" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "EffectEvidenceSynthesis" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "EffectEvidenceSynthesis" ALTER COLUMN "effective" TYPE DATE USING "effective"::DATE' ); await client.query( 'ALTER TABLE "EffectEvidenceSynthesis" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "EffectEvidenceSynthesis" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "Encounter" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "Encounter" ALTER COLUMN "length" TYPE DOUBLE PRECISION USING "length"::DOUBLE PRECISION' ); await client.query( 'ALTER TABLE "Encounter" ALTER COLUMN "locationPeriod" TYPE DATE[] USING array["locationPeriod"]::DATE[]' ); await client.query( 'ALTER TABLE "Encounter" ALTER COLUMN "participantType" TYPE TEXT[] USING array["participantType"]::TEXT[]' ); await client.query( 'ALTER TABLE "Encounter" ALTER COLUMN "practitioner" TYPE TEXT[] USING array["practitioner"]::TEXT[]' ); await client.query( 'ALTER TABLE "Encounter" ALTER COLUMN "specialArrangement" TYPE TEXT[] USING array["specialArrangement"]::TEXT[]' ); await client.query('ALTER TABLE "EpisodeOfCare" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "EpisodeOfCare" ALTER COLUMN "condition" TYPE TEXT[] USING array["condition"]::TEXT[]' ); await client.query( 'ALTER TABLE "EpisodeOfCare" ALTER COLUMN "incomingReferral" TYPE TEXT[] USING array["incomingReferral"]::TEXT[]' ); await client.query( 'ALTER TABLE "EventDefinition" ALTER COLUMN "composedOf" TYPE TEXT[] USING array["composedOf"]::TEXT[]' ); await client.query('ALTER TABLE "EventDefinition" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]'); await client.query( 'ALTER TABLE "EventDefinition" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "EventDefinition" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "EventDefinition" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "EventDefinition" ALTER COLUMN "dependsOn" TYPE TEXT[] USING array["dependsOn"]::TEXT[]' ); await client.query( 'ALTER TABLE "EventDefinition" ALTER COLUMN "derivedFrom" TYPE TEXT[] USING array["derivedFrom"]::TEXT[]' ); await client.query('ALTER TABLE "EventDefinition" ALTER COLUMN "effective" TYPE DATE USING "effective"::DATE'); await client.query( 'ALTER TABLE "EventDefinition" ALTER COLUMN "predecessor" TYPE TEXT[] USING array["predecessor"]::TEXT[]' ); await client.query( 'ALTER TABLE "EventDefinition" ALTER COLUMN "successor" TYPE TEXT[] USING array["successor"]::TEXT[]' ); await client.query( 'ALTER TABLE "EventDefinition" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "EventDefinition" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "Evidence" ALTER COLUMN "composedOf" TYPE TEXT[] USING array["composedOf"]::TEXT[]'); await client.query('ALTER TABLE "Evidence" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]'); await client.query( 'ALTER TABLE "Evidence" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "Evidence" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "Evidence" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "Evidence" ALTER COLUMN "dependsOn" TYPE TEXT[] USING array["dependsOn"]::TEXT[]'); await client.query( 'ALTER TABLE "Evidence" ALTER COLUMN "derivedFrom" TYPE TEXT[] USING array["derivedFrom"]::TEXT[]' ); await client.query('ALTER TABLE "Evidence" ALTER COLUMN "effective" TYPE DATE USING "effective"::DATE'); await client.query( 'ALTER TABLE "Evidence" ALTER COLUMN "predecessor" TYPE TEXT[] USING array["predecessor"]::TEXT[]' ); await client.query('ALTER TABLE "Evidence" ALTER COLUMN "successor" TYPE TEXT[] USING array["successor"]::TEXT[]'); await client.query( 'ALTER TABLE "Evidence" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "Evidence" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query( 'ALTER TABLE "EvidenceVariable" ALTER COLUMN "composedOf" TYPE TEXT[] USING array["composedOf"]::TEXT[]' ); await client.query( 'ALTER TABLE "EvidenceVariable" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]' ); await client.query( 'ALTER TABLE "EvidenceVariable" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "EvidenceVariable" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "EvidenceVariable" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "EvidenceVariable" ALTER COLUMN "dependsOn" TYPE TEXT[] USING array["dependsOn"]::TEXT[]' ); await client.query( 'ALTER TABLE "EvidenceVariable" ALTER COLUMN "derivedFrom" TYPE TEXT[] USING array["derivedFrom"]::TEXT[]' ); await client.query('ALTER TABLE "EvidenceVariable" ALTER COLUMN "effective" TYPE DATE USING "effective"::DATE'); await client.query( 'ALTER TABLE "EvidenceVariable" ALTER COLUMN "predecessor" TYPE TEXT[] USING array["predecessor"]::TEXT[]' ); await client.query( 'ALTER TABLE "EvidenceVariable" ALTER COLUMN "successor" TYPE TEXT[] USING array["successor"]::TEXT[]' ); await client.query( 'ALTER TABLE "EvidenceVariable" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "EvidenceVariable" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "ExampleScenario" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]'); await client.query( 'ALTER TABLE "ExampleScenario" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "ExampleScenario" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "ExampleScenario" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "ExampleScenario" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "ExampleScenario" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query( 'ALTER TABLE "ExplanationOfBenefit" ALTER COLUMN "coverage" TYPE TEXT[] USING array["coverage"]::TEXT[]' ); await client.query('ALTER TABLE "ExplanationOfBenefit" ALTER COLUMN "created" TYPE DATE USING "created"::DATE'); await client.query( 'ALTER TABLE "ExplanationOfBenefit" ALTER COLUMN "detailUdi" TYPE TEXT[] USING array["detailUdi"]::TEXT[]' ); await client.query( 'ALTER TABLE "ExplanationOfBenefit" ALTER COLUMN "encounter" TYPE TEXT[] USING array["encounter"]::TEXT[]' ); await client.query( 'ALTER TABLE "ExplanationOfBenefit" ALTER COLUMN "itemUdi" TYPE TEXT[] USING array["itemUdi"]::TEXT[]' ); await client.query( 'ALTER TABLE "ExplanationOfBenefit" ALTER COLUMN "procedureUdi" TYPE TEXT[] USING array["procedureUdi"]::TEXT[]' ); await client.query( 'ALTER TABLE "ExplanationOfBenefit" ALTER COLUMN "subdetailUdi" TYPE TEXT[] USING array["subdetailUdi"]::TEXT[]' ); await client.query('ALTER TABLE "FamilyMemberHistory" ALTER COLUMN "code" TYPE TEXT[] USING array["code"]::TEXT[]'); await client.query('ALTER TABLE "FamilyMemberHistory" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "Flag" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "Goal" ALTER COLUMN "targetDate" TYPE TEXT[] USING array["targetDate"]::TEXT[]'); await client.query('ALTER TABLE "GraphDefinition" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]'); await client.query( 'ALTER TABLE "GraphDefinition" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "GraphDefinition" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "GraphDefinition" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "GraphDefinition" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "GraphDefinition" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "Group" ALTER COLUMN "actual" TYPE BOOLEAN USING "actual"::BOOLEAN'); await client.query('ALTER TABLE "Group" ALTER COLUMN "exclude" TYPE BOOLEAN[] USING array["exclude"]::BOOLEAN[]'); await client.query('ALTER TABLE "Group" ALTER COLUMN "value" TYPE TEXT[] USING array["value"]::TEXT[]'); await client.query( 'ALTER TABLE "Group" ALTER COLUMN "characteristicValue" TYPE TEXT[] USING array["characteristicValue"]::TEXT[]' ); await client.query( 'ALTER TABLE "HealthcareService" ALTER COLUMN "serviceCategory" TYPE TEXT[] USING array["serviceCategory"]::TEXT[]' ); await client.query( 'ALTER TABLE "HealthcareService" ALTER COLUMN "serviceType" TYPE TEXT[] USING array["serviceType"]::TEXT[]' ); await client.query('ALTER TABLE "ImagingStudy" ALTER COLUMN "basedon" TYPE TEXT[] USING array["basedon"]::TEXT[]'); await client.query('ALTER TABLE "ImagingStudy" ALTER COLUMN "bodysite" TYPE TEXT[] USING array["bodysite"]::TEXT[]'); await client.query( 'ALTER TABLE "ImagingStudy" ALTER COLUMN "dicomClass" TYPE TEXT[] USING array["dicomClass"]::TEXT[]' ); await client.query('ALTER TABLE "ImagingStudy" ALTER COLUMN "instance" TYPE TEXT[] USING array["instance"]::TEXT[]'); await client.query( 'ALTER TABLE "ImagingStudy" ALTER COLUMN "performer" TYPE TEXT[] USING array["performer"]::TEXT[]' ); await client.query('ALTER TABLE "ImagingStudy" ALTER COLUMN "reason" TYPE TEXT[] USING array["reason"]::TEXT[]'); await client.query('ALTER TABLE "ImagingStudy" ALTER COLUMN "started" TYPE DATE USING "started"::DATE'); await client.query( 'ALTER TABLE "Immunization" ALTER COLUMN "reactionDate" TYPE DATE[] USING array["reactionDate"]::DATE[]' ); await client.query('ALTER TABLE "Immunization" ALTER COLUMN "series" TYPE TEXT[] USING array["series"]::TEXT[]'); await client.query( 'ALTER TABLE "Immunization" ALTER COLUMN "targetDisease" TYPE TEXT[] USING array["targetDisease"]::TEXT[]' ); await client.query('ALTER TABLE "ImmunizationEvaluation" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "ImmunizationRecommendation" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "ImmunizationRecommendation" ALTER COLUMN "information" TYPE TEXT[] USING array["information"]::TEXT[]' ); await client.query( 'ALTER TABLE "ImmunizationRecommendation" ALTER COLUMN "status" TYPE TEXT[] USING array["status"]::TEXT[]' ); await client.query( 'ALTER TABLE "ImmunizationRecommendation" ALTER COLUMN "support" TYPE TEXT[] USING array["support"]::TEXT[]' ); await client.query( 'ALTER TABLE "ImmunizationRecommendation" ALTER COLUMN "targetDisease" TYPE TEXT[] USING array["targetDisease"]::TEXT[]' ); await client.query( 'ALTER TABLE "ImmunizationRecommendation" ALTER COLUMN "vaccineType" TYPE TEXT[] USING array["vaccineType"]::TEXT[]' ); await client.query( 'ALTER TABLE "ImplementationGuide" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]' ); await client.query( 'ALTER TABLE "ImplementationGuide" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "ImplementationGuide" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "ImplementationGuide" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "ImplementationGuide" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "ImplementationGuide" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query( 'ALTER TABLE "ImplementationGuide" ALTER COLUMN "experimental" TYPE BOOLEAN USING "experimental"::BOOLEAN' ); await client.query( 'ALTER TABLE "ImplementationGuide" ALTER COLUMN "resource" TYPE TEXT[] USING array["resource"]::TEXT[]' ); await client.query('ALTER TABLE "Invoice" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "Invoice" ALTER COLUMN "participantRole" TYPE TEXT[] USING array["participantRole"]::TEXT[]' ); await client.query( 'ALTER TABLE "Invoice" ALTER COLUMN "totalgross" TYPE DOUBLE PRECISION USING "totalgross"::DOUBLE PRECISION' ); await client.query( 'ALTER TABLE "Invoice" ALTER COLUMN "totalnet" TYPE DOUBLE PRECISION USING "totalnet"::DOUBLE PRECISION' ); await client.query('ALTER TABLE "Library" ALTER COLUMN "composedOf" TYPE TEXT[] USING array["composedOf"]::TEXT[]'); await client.query('ALTER TABLE "Library" ALTER COLUMN "contentType" TYPE TEXT[] USING array["contentType"]::TEXT[]'); await client.query('ALTER TABLE "Library" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]'); await client.query( 'ALTER TABLE "Library" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query('ALTER TABLE "Library" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]'); await client.query('ALTER TABLE "Library" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "Library" ALTER COLUMN "dependsOn" TYPE TEXT[] USING array["dependsOn"]::TEXT[]'); await client.query('ALTER TABLE "Library" ALTER COLUMN "derivedFrom" TYPE TEXT[] USING array["derivedFrom"]::TEXT[]'); await client.query('ALTER TABLE "Library" ALTER COLUMN "effective" TYPE DATE USING "effective"::DATE'); await client.query('ALTER TABLE "Library" ALTER COLUMN "predecessor" TYPE TEXT[] USING array["predecessor"]::TEXT[]'); await client.query('ALTER TABLE "Library" ALTER COLUMN "successor" TYPE TEXT[] USING array["successor"]::TEXT[]'); await client.query( 'ALTER TABLE "Library" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "Library" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "Linkage" ALTER COLUMN "source" TYPE TEXT[] USING array["source"]::TEXT[]'); await client.query('ALTER TABLE "List" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "List" ALTER COLUMN "item" TYPE TEXT[] USING array["item"]::TEXT[]'); await client.query('ALTER TABLE "List" ALTER COLUMN "notes" TYPE TEXT[] USING array["notes"]::TEXT[]'); await client.query('ALTER TABLE "Measure" ALTER COLUMN "composedOf" TYPE TEXT[] USING array["composedOf"]::TEXT[]'); await client.query('ALTER TABLE "Measure" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]'); await client.query( 'ALTER TABLE "Measure" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query('ALTER TABLE "Measure" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]'); await client.query('ALTER TABLE "Measure" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "Measure" ALTER COLUMN "dependsOn" TYPE TEXT[] USING array["dependsOn"]::TEXT[]'); await client.query('ALTER TABLE "Measure" ALTER COLUMN "derivedFrom" TYPE TEXT[] USING array["derivedFrom"]::TEXT[]'); await client.query('ALTER TABLE "Measure" ALTER COLUMN "effective" TYPE DATE USING "effective"::DATE'); await client.query('ALTER TABLE "Measure" ALTER COLUMN "predecessor" TYPE TEXT[] USING array["predecessor"]::TEXT[]'); await client.query('ALTER TABLE "Measure" ALTER COLUMN "successor" TYPE TEXT[] USING array["successor"]::TEXT[]'); await client.query( 'ALTER TABLE "Measure" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "Measure" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "MeasureReport" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "MeasureReport" ALTER COLUMN "period" TYPE DATE USING "period"::DATE'); await client.query('ALTER TABLE "Medication" ALTER COLUMN "expirationDate" TYPE DATE USING "expirationDate"::DATE'); await client.query( 'ALTER TABLE "Medication" ALTER COLUMN "ingredientCode" TYPE TEXT[] USING array["ingredientCode"]::TEXT[]' ); await client.query( 'ALTER TABLE "MedicationAdministration" ALTER COLUMN "reasonGiven" TYPE TEXT[] USING array["reasonGiven"]::TEXT[]' ); await client.query( 'ALTER TABLE "MedicationAdministration" ALTER COLUMN "reasonNotGiven" TYPE TEXT[] USING array["reasonNotGiven"]::TEXT[]' ); await client.query( 'ALTER TABLE "MedicationDispense" ALTER COLUMN "prescription" TYPE TEXT[] USING array["prescription"]::TEXT[]' ); await client.query( 'ALTER TABLE "MedicationDispense" ALTER COLUMN "responsibleparty" TYPE TEXT[] USING array["responsibleparty"]::TEXT[]' ); await client.query( 'ALTER TABLE "MedicationDispense" ALTER COLUMN "whenhandedover" TYPE DATE USING "whenhandedover"::DATE' ); await client.query( 'ALTER TABLE "MedicationDispense" ALTER COLUMN "whenprepared" TYPE DATE USING "whenprepared"::DATE' ); await client.query( 'ALTER TABLE "MedicationKnowledge" ALTER COLUMN "classification" TYPE TEXT[] USING array["classification"]::TEXT[]' ); await client.query( 'ALTER TABLE "MedicationKnowledge" ALTER COLUMN "classificationType" TYPE TEXT[] USING array["classificationType"]::TEXT[]' ); await client.query( 'ALTER TABLE "MedicationKnowledge" ALTER COLUMN "ingredientCode" TYPE TEXT[] USING array["ingredientCode"]::TEXT[]' ); await client.query( 'ALTER TABLE "MedicationKnowledge" ALTER COLUMN "monitoringProgramName" TYPE TEXT[] USING array["monitoringProgramName"]::TEXT[]' ); await client.query( 'ALTER TABLE "MedicationKnowledge" ALTER COLUMN "monitoringProgramType" TYPE TEXT[] USING array["monitoringProgramType"]::TEXT[]' ); await client.query( 'ALTER TABLE "MedicationKnowledge" ALTER COLUMN "monographType" TYPE TEXT[] USING array["monographType"]::TEXT[]' ); await client.query( 'ALTER TABLE "MedicationKnowledge" ALTER COLUMN "sourceCost" TYPE TEXT[] USING array["sourceCost"]::TEXT[]' ); await client.query('ALTER TABLE "MedicationRequest" ALTER COLUMN "authoredon" TYPE DATE USING "authoredon"::DATE'); await client.query('ALTER TABLE "MedicationRequest" ALTER COLUMN "date" TYPE DATE[] USING array["date"]::DATE[]'); await client.query( 'ALTER TABLE "MedicinalProduct" ALTER COLUMN "nameLanguage" TYPE TEXT[] USING array["nameLanguage"]::TEXT[]' ); await client.query( 'ALTER TABLE "MedicinalProductPharmaceutical" ALTER COLUMN "route" TYPE TEXT[] USING array["route"]::TEXT[]' ); await client.query( 'ALTER TABLE "MedicinalProductPharmaceutical" ALTER COLUMN "targetSpecies" TYPE TEXT[] USING array["targetSpecies"]::TEXT[]' ); await client.query( 'ALTER TABLE "MessageDefinition" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]' ); await client.query( 'ALTER TABLE "MessageDefinition" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "MessageDefinition" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "MessageDefinition" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "MessageDefinition" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "MessageDefinition" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query( 'ALTER TABLE "MessageHeader" ALTER COLUMN "destinationUri" TYPE TEXT[] USING array["destinationUri"]::TEXT[]' ); await client.query('ALTER TABLE "MessageHeader" ALTER COLUMN "receiver" TYPE TEXT[] USING array["receiver"]::TEXT[]'); await client.query('ALTER TABLE "MessageHeader" ALTER COLUMN "target" TYPE TEXT[] USING array["target"]::TEXT[]'); await client.query( 'ALTER TABLE "MolecularSequence" ALTER COLUMN "variantEnd" TYPE DOUBLE PRECISION[] USING array["variantEnd"]::DOUBLE PRECISION[]' ); await client.query( 'ALTER TABLE "MolecularSequence" ALTER COLUMN "variantStart" TYPE DOUBLE PRECISION[] USING array["variantStart"]::DOUBLE PRECISION[]' ); await client.query( 'ALTER TABLE "MolecularSequence" ALTER COLUMN "windowEnd" TYPE DOUBLE PRECISION USING "windowEnd"::DOUBLE PRECISION' ); await client.query( 'ALTER TABLE "MolecularSequence" ALTER COLUMN "windowStart" TYPE DOUBLE PRECISION USING "windowStart"::DOUBLE PRECISION' ); await client.query( 'ALTER TABLE "MolecularSequence" ALTER COLUMN "chromosomeVariantCoordinate" TYPE TEXT[] USING array["chromosomeVariantCoordinate"]::TEXT[]' ); await client.query( 'ALTER TABLE "MolecularSequence" ALTER COLUMN "referenceseqidVariantCoordinate" TYPE TEXT[] USING array["referenceseqidVariantCoordinate"]::TEXT[]' ); await client.query('ALTER TABLE "NamingSystem" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]'); await client.query( 'ALTER TABLE "NamingSystem" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "NamingSystem" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "NamingSystem" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "NamingSystem" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "NamingSystem" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "NamingSystem" ALTER COLUMN "idType" TYPE TEXT[] USING array["idType"]::TEXT[]'); await client.query('ALTER TABLE "NamingSystem" ALTER COLUMN "period" TYPE DATE[] USING array["period"]::DATE[]'); await client.query('ALTER TABLE "NamingSystem" ALTER COLUMN "telecom" TYPE TEXT[] USING array["telecom"]::TEXT[]'); await client.query('ALTER TABLE "NamingSystem" ALTER COLUMN "value" TYPE TEXT[] USING array["value"]::TEXT[]'); await client.query('ALTER TABLE "NutritionOrder" ALTER COLUMN "datetime" TYPE DATE USING "datetime"::DATE'); await client.query( 'ALTER TABLE "NutritionOrder" ALTER COLUMN "oraldiet" TYPE TEXT[] USING array["oraldiet"]::TEXT[]' ); await client.query( 'ALTER TABLE "Observation" ALTER COLUMN "componentCode" TYPE TEXT[] USING array["componentCode"]::TEXT[]' ); await client.query( 'ALTER TABLE "Observation" ALTER COLUMN "componentDataAbsentReason" TYPE TEXT[] USING array["componentDataAbsentReason"]::TEXT[]' ); await client.query( 'ALTER TABLE "Observation" ALTER COLUMN "componentValueConcept" TYPE TEXT[] USING array["componentValueConcept"]::TEXT[]' ); await client.query( 'ALTER TABLE "Observation" ALTER COLUMN "componentValueQuantity" TYPE TEXT[] USING array["componentValueQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "Observation" ALTER COLUMN "comboCodeValueConcept" TYPE TEXT[] USING array["comboCodeValueConcept"]::TEXT[]' ); await client.query( 'ALTER TABLE "Observation" ALTER COLUMN "comboCodeValueQuantity" TYPE TEXT[] USING array["comboCodeValueQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "Observation" ALTER COLUMN "componentCodeValueConcept" TYPE TEXT[] USING array["componentCodeValueConcept"]::TEXT[]' ); await client.query( 'ALTER TABLE "Observation" ALTER COLUMN "componentCodeValueQuantity" TYPE TEXT[] USING array["componentCodeValueQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "OperationDefinition" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]' ); await client.query( 'ALTER TABLE "OperationDefinition" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "OperationDefinition" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "OperationDefinition" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "OperationDefinition" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "OperationDefinition" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query( 'ALTER TABLE "OperationDefinition" ALTER COLUMN "instance" TYPE BOOLEAN USING "instance"::BOOLEAN' ); await client.query('ALTER TABLE "OperationDefinition" ALTER COLUMN "system" TYPE BOOLEAN USING "system"::BOOLEAN'); await client.query('ALTER TABLE "OperationDefinition" ALTER COLUMN "type" TYPE BOOLEAN USING "type"::BOOLEAN'); await client.query('ALTER TABLE "OrganizationAffiliation" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "OrganizationAffiliation" ALTER COLUMN "role" TYPE TEXT[] USING array["role"]::TEXT[]' ); await client.query( 'ALTER TABLE "OrganizationAffiliation" ALTER COLUMN "service" TYPE TEXT[] USING array["service"]::TEXT[]' ); await client.query('ALTER TABLE "Patient" ALTER COLUMN "birthdate" TYPE DATE USING "birthdate"::DATE'); await client.query('ALTER TABLE "Patient" ALTER COLUMN "language" TYPE TEXT[] USING array["language"]::TEXT[]'); await client.query('ALTER TABLE "Patient" ALTER COLUMN "phonetic" TYPE TEXT[] USING array["phonetic"]::TEXT[]'); await client.query('ALTER TABLE "PaymentNotice" ALTER COLUMN "created" TYPE DATE USING "created"::DATE'); await client.query('ALTER TABLE "PaymentReconciliation" ALTER COLUMN "created" TYPE DATE USING "created"::DATE'); await client.query('ALTER TABLE "Person" ALTER COLUMN "birthdate" TYPE DATE USING "birthdate"::DATE'); await client.query('ALTER TABLE "Person" ALTER COLUMN "phonetic" TYPE TEXT[] USING array["phonetic"]::TEXT[]'); await client.query('ALTER TABLE "Person" ALTER COLUMN "patient" TYPE TEXT[] USING array["patient"]::TEXT[]'); await client.query( 'ALTER TABLE "Person" ALTER COLUMN "practitioner" TYPE TEXT[] USING array["practitioner"]::TEXT[]' ); await client.query( 'ALTER TABLE "Person" ALTER COLUMN "relatedperson" TYPE TEXT[] USING array["relatedperson"]::TEXT[]' ); await client.query( 'ALTER TABLE "PlanDefinition" ALTER COLUMN "composedOf" TYPE TEXT[] USING array["composedOf"]::TEXT[]' ); await client.query('ALTER TABLE "PlanDefinition" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]'); await client.query( 'ALTER TABLE "PlanDefinition" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "PlanDefinition" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "PlanDefinition" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "PlanDefinition" ALTER COLUMN "definition" TYPE TEXT[] USING array["definition"]::TEXT[]' ); await client.query( 'ALTER TABLE "PlanDefinition" ALTER COLUMN "dependsOn" TYPE TEXT[] USING array["dependsOn"]::TEXT[]' ); await client.query( 'ALTER TABLE "PlanDefinition" ALTER COLUMN "derivedFrom" TYPE TEXT[] USING array["derivedFrom"]::TEXT[]' ); await client.query('ALTER TABLE "PlanDefinition" ALTER COLUMN "effective" TYPE DATE USING "effective"::DATE'); await client.query( 'ALTER TABLE "PlanDefinition" ALTER COLUMN "predecessor" TYPE TEXT[] USING array["predecessor"]::TEXT[]' ); await client.query( 'ALTER TABLE "PlanDefinition" ALTER COLUMN "successor" TYPE TEXT[] USING array["successor"]::TEXT[]' ); await client.query( 'ALTER TABLE "PlanDefinition" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "PlanDefinition" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "Practitioner" ALTER COLUMN "phonetic" TYPE TEXT[] USING array["phonetic"]::TEXT[]'); await client.query('ALTER TABLE "PractitionerRole" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "PractitionerRole" ALTER COLUMN "role" TYPE TEXT[] USING array["role"]::TEXT[]'); await client.query( 'ALTER TABLE "PractitionerRole" ALTER COLUMN "service" TYPE TEXT[] USING array["service"]::TEXT[]' ); await client.query('ALTER TABLE "Provenance" ALTER COLUMN "agentRole" TYPE TEXT[] USING array["agentRole"]::TEXT[]'); await client.query('ALTER TABLE "Provenance" ALTER COLUMN "agentType" TYPE TEXT[] USING array["agentType"]::TEXT[]'); await client.query('ALTER TABLE "Provenance" ALTER COLUMN "patient" TYPE TEXT[] USING array["patient"]::TEXT[]'); await client.query('ALTER TABLE "Provenance" ALTER COLUMN "recorded" TYPE DATE USING "recorded"::DATE'); await client.query( 'ALTER TABLE "Provenance" ALTER COLUMN "signatureType" TYPE TEXT[] USING array["signatureType"]::TEXT[]' ); await client.query('ALTER TABLE "Questionnaire" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]'); await client.query( 'ALTER TABLE "Questionnaire" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "Questionnaire" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "Questionnaire" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "Questionnaire" ALTER COLUMN "definition" TYPE TEXT[] USING array["definition"]::TEXT[]' ); await client.query('ALTER TABLE "Questionnaire" ALTER COLUMN "effective" TYPE DATE USING "effective"::DATE'); await client.query( 'ALTER TABLE "Questionnaire" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "Questionnaire" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "QuestionnaireResponse" ALTER COLUMN "authored" TYPE DATE USING "authored"::DATE'); await client.query('ALTER TABLE "RelatedPerson" ALTER COLUMN "birthdate" TYPE DATE USING "birthdate"::DATE'); await client.query('ALTER TABLE "RelatedPerson" ALTER COLUMN "phonetic" TYPE TEXT[] USING array["phonetic"]::TEXT[]'); await client.query('ALTER TABLE "RequestGroup" ALTER COLUMN "authored" TYPE DATE USING "authored"::DATE'); await client.query( 'ALTER TABLE "RequestGroup" ALTER COLUMN "participant" TYPE TEXT[] USING array["participant"]::TEXT[]' ); await client.query( 'ALTER TABLE "ResearchDefinition" ALTER COLUMN "composedOf" TYPE TEXT[] USING array["composedOf"]::TEXT[]' ); await client.query( 'ALTER TABLE "ResearchDefinition" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]' ); await client.query( 'ALTER TABLE "ResearchDefinition" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "ResearchDefinition" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "ResearchDefinition" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "ResearchDefinition" ALTER COLUMN "dependsOn" TYPE TEXT[] USING array["dependsOn"]::TEXT[]' ); await client.query( 'ALTER TABLE "ResearchDefinition" ALTER COLUMN "derivedFrom" TYPE TEXT[] USING array["derivedFrom"]::TEXT[]' ); await client.query('ALTER TABLE "ResearchDefinition" ALTER COLUMN "effective" TYPE DATE USING "effective"::DATE'); await client.query( 'ALTER TABLE "ResearchDefinition" ALTER COLUMN "predecessor" TYPE TEXT[] USING array["predecessor"]::TEXT[]' ); await client.query( 'ALTER TABLE "ResearchDefinition" ALTER COLUMN "successor" TYPE TEXT[] USING array["successor"]::TEXT[]' ); await client.query( 'ALTER TABLE "ResearchDefinition" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "ResearchDefinition" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query( 'ALTER TABLE "ResearchElementDefinition" ALTER COLUMN "composedOf" TYPE TEXT[] USING array["composedOf"]::TEXT[]' ); await client.query( 'ALTER TABLE "ResearchElementDefinition" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]' ); await client.query( 'ALTER TABLE "ResearchElementDefinition" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "ResearchElementDefinition" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "ResearchElementDefinition" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "ResearchElementDefinition" ALTER COLUMN "dependsOn" TYPE TEXT[] USING array["dependsOn"]::TEXT[]' ); await client.query( 'ALTER TABLE "ResearchElementDefinition" ALTER COLUMN "derivedFrom" TYPE TEXT[] USING array["derivedFrom"]::TEXT[]' ); await client.query( 'ALTER TABLE "ResearchElementDefinition" ALTER COLUMN "effective" TYPE DATE USING "effective"::DATE' ); await client.query( 'ALTER TABLE "ResearchElementDefinition" ALTER COLUMN "predecessor" TYPE TEXT[] USING array["predecessor"]::TEXT[]' ); await client.query( 'ALTER TABLE "ResearchElementDefinition" ALTER COLUMN "successor" TYPE TEXT[] USING array["successor"]::TEXT[]' ); await client.query( 'ALTER TABLE "ResearchElementDefinition" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "ResearchElementDefinition" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "ResearchStudy" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "ResearchStudy" ALTER COLUMN "partof" TYPE TEXT[] USING array["partof"]::TEXT[]'); await client.query('ALTER TABLE "ResearchSubject" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "RiskAssessment" ALTER COLUMN "probability" TYPE TEXT[] USING array["probability"]::TEXT[]' ); await client.query('ALTER TABLE "RiskAssessment" ALTER COLUMN "risk" TYPE TEXT[] USING array["risk"]::TEXT[]'); await client.query( 'ALTER TABLE "RiskEvidenceSynthesis" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]' ); await client.query( 'ALTER TABLE "RiskEvidenceSynthesis" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "RiskEvidenceSynthesis" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "RiskEvidenceSynthesis" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "RiskEvidenceSynthesis" ALTER COLUMN "effective" TYPE DATE USING "effective"::DATE'); await client.query( 'ALTER TABLE "RiskEvidenceSynthesis" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "RiskEvidenceSynthesis" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "Schedule" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "SearchParameter" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]'); await client.query( 'ALTER TABLE "SearchParameter" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "SearchParameter" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "SearchParameter" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "SearchParameter" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "SearchParameter" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "ServiceRequest" ALTER COLUMN "authored" TYPE DATE USING "authored"::DATE'); await client.query('ALTER TABLE "Slot" ALTER COLUMN "start" TYPE DATE USING "start"::DATE'); await client.query( 'ALTER TABLE "Specimen" ALTER COLUMN "containerId" TYPE TEXT[] USING array["containerId"]::TEXT[]' ); await client.query( 'ALTER TABLE "SpecimenDefinition" ALTER COLUMN "container" TYPE TEXT[] USING array["container"]::TEXT[]' ); await client.query( 'ALTER TABLE "StructureDefinition" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "StructureDefinition" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "StructureDefinition" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "StructureDefinition" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "StructureDefinition" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query( 'ALTER TABLE "StructureDefinition" ALTER COLUMN "abstract" TYPE BOOLEAN USING "abstract"::BOOLEAN' ); await client.query( 'ALTER TABLE "StructureDefinition" ALTER COLUMN "basePath" TYPE TEXT[] USING array["basePath"]::TEXT[]' ); await client.query( 'ALTER TABLE "StructureDefinition" ALTER COLUMN "experimental" TYPE BOOLEAN USING "experimental"::BOOLEAN' ); await client.query( 'ALTER TABLE "StructureDefinition" ALTER COLUMN "extContext" TYPE TEXT[] USING array["extContext"]::TEXT[]' ); await client.query('ALTER TABLE "StructureDefinition" ALTER COLUMN "path" TYPE TEXT[] USING array["path"]::TEXT[]'); await client.query( 'ALTER TABLE "StructureDefinition" ALTER COLUMN "valueset" TYPE TEXT[] USING array["valueset"]::TEXT[]' ); await client.query('ALTER TABLE "StructureMap" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]'); await client.query( 'ALTER TABLE "StructureMap" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "StructureMap" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "StructureMap" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "StructureMap" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "StructureMap" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query( 'ALTER TABLE "Substance" ALTER COLUMN "containerIdentifier" TYPE TEXT[] USING array["containerIdentifier"]::TEXT[]' ); await client.query('ALTER TABLE "Substance" ALTER COLUMN "expiry" TYPE DATE[] USING array["expiry"]::DATE[]'); await client.query( 'ALTER TABLE "Substance" ALTER COLUMN "quantity" TYPE DOUBLE PRECISION[] USING array["quantity"]::DOUBLE PRECISION[]' ); await client.query( 'ALTER TABLE "Substance" ALTER COLUMN "substanceReference" TYPE TEXT[] USING array["substanceReference"]::TEXT[]' ); await client.query('ALTER TABLE "SupplyRequest" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query('ALTER TABLE "Task" ALTER COLUMN "authoredOn" TYPE DATE USING "authoredOn"::DATE'); await client.query('ALTER TABLE "Task" ALTER COLUMN "modified" TYPE DATE USING "modified"::DATE'); await client.query('ALTER TABLE "Task" ALTER COLUMN "performer" TYPE TEXT[] USING array["performer"]::TEXT[]'); await client.query('ALTER TABLE "Task" ALTER COLUMN "period" TYPE DATE USING "period"::DATE'); await client.query( 'ALTER TABLE "TerminologyCapabilities" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]' ); await client.query( 'ALTER TABLE "TerminologyCapabilities" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "TerminologyCapabilities" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "TerminologyCapabilities" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "TerminologyCapabilities" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "TerminologyCapabilities" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "TestReport" ALTER COLUMN "issued" TYPE DATE USING "issued"::DATE'); await client.query('ALTER TABLE "TestScript" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]'); await client.query( 'ALTER TABLE "TestScript" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "TestScript" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "TestScript" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "TestScript" ALTER COLUMN "testscriptCapability" TYPE TEXT[] USING array["testscriptCapability"]::TEXT[]' ); await client.query( 'ALTER TABLE "TestScript" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "TestScript" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "ValueSet" ALTER COLUMN "context" TYPE TEXT[] USING array["context"]::TEXT[]'); await client.query( 'ALTER TABLE "ValueSet" ALTER COLUMN "contextQuantity" TYPE TEXT[] USING array["contextQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "ValueSet" ALTER COLUMN "contextType" TYPE TEXT[] USING array["contextType"]::TEXT[]' ); await client.query('ALTER TABLE "ValueSet" ALTER COLUMN "date" TYPE DATE USING "date"::DATE'); await client.query( 'ALTER TABLE "ValueSet" ALTER COLUMN "contextTypeQuantity" TYPE TEXT[] USING array["contextTypeQuantity"]::TEXT[]' ); await client.query( 'ALTER TABLE "ValueSet" ALTER COLUMN "contextTypeValue" TYPE TEXT[] USING array["contextTypeValue"]::TEXT[]' ); await client.query('ALTER TABLE "ValueSet" ALTER COLUMN "code" TYPE TEXT[] USING array["code"]::TEXT[]'); await client.query('ALTER TABLE "ValueSet" ALTER COLUMN "reference" TYPE TEXT[] USING array["reference"]::TEXT[]'); await client.query('ALTER TABLE "VisionPrescription" ALTER COLUMN "datewritten" TYPE DATE USING "datewritten"::DATE'); }