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 "period" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ActivityDefinition" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ActivityDefinition" ALTER COLUMN "effective" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "AdverseEvent" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "AllergyIntolerance" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "AllergyIntolerance" ALTER COLUMN "lastDate" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "AllergyIntolerance" ALTER COLUMN "onset" TYPE TIMESTAMPTZ[]'); await client.query('ALTER TABLE "Appointment" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "AuditEvent" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Bundle" ALTER COLUMN "timestamp" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "CapabilityStatement" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "CarePlan" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "CarePlan" ALTER COLUMN "activityDate" TYPE TIMESTAMPTZ[]'); await client.query('ALTER TABLE "CareTeam" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ChargeItem" ALTER COLUMN "enteredDate" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ChargeItem" ALTER COLUMN "occurrence" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ChargeItemDefinition" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ChargeItemDefinition" ALTER COLUMN "effective" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Claim" ALTER COLUMN "created" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ClaimResponse" ALTER COLUMN "created" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ClinicalImpression" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "CodeSystem" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Communication" ALTER COLUMN "received" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Communication" ALTER COLUMN "sent" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "CommunicationRequest" ALTER COLUMN "authored" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "CommunicationRequest" ALTER COLUMN "occurrence" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "CompartmentDefinition" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Composition" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Composition" ALTER COLUMN "period" TYPE TIMESTAMPTZ[]'); await client.query('ALTER TABLE "ConceptMap" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Condition" ALTER COLUMN "abatementDate" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Condition" ALTER COLUMN "onsetDate" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Condition" ALTER COLUMN "recordedDate" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Consent" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Consent" ALTER COLUMN "period" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Contract" ALTER COLUMN "issued" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "CoverageEligibilityRequest" ALTER COLUMN "created" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "CoverageEligibilityResponse" ALTER COLUMN "created" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "DetectedIssue" ALTER COLUMN "identified" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "DeviceRequest" ALTER COLUMN "authoredOn" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "DeviceRequest" ALTER COLUMN "eventDate" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "DiagnosticReport" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "DiagnosticReport" ALTER COLUMN "issued" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "DocumentManifest" ALTER COLUMN "created" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "DocumentReference" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "DocumentReference" ALTER COLUMN "period" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "EffectEvidenceSynthesis" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "EffectEvidenceSynthesis" ALTER COLUMN "effective" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Encounter" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Encounter" ALTER COLUMN "locationPeriod" TYPE TIMESTAMPTZ[]'); await client.query('ALTER TABLE "EpisodeOfCare" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "EventDefinition" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "EventDefinition" ALTER COLUMN "effective" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Evidence" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Evidence" ALTER COLUMN "effective" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "EvidenceVariable" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "EvidenceVariable" ALTER COLUMN "effective" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ExampleScenario" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ExplanationOfBenefit" ALTER COLUMN "created" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "FamilyMemberHistory" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Flag" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Goal" ALTER COLUMN "targetDate" TYPE DATE[]'); await client.query('ALTER TABLE "GraphDefinition" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ImagingStudy" ALTER COLUMN "started" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Immunization" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Immunization" ALTER COLUMN "reactionDate" TYPE TIMESTAMPTZ[]'); await client.query('ALTER TABLE "ImmunizationEvaluation" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ImmunizationRecommendation" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ImplementationGuide" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Invoice" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Library" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Library" ALTER COLUMN "effective" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "List" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Measure" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Measure" ALTER COLUMN "effective" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "MeasureReport" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "MeasureReport" ALTER COLUMN "period" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Media" ALTER COLUMN "created" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Medication" ALTER COLUMN "expirationDate" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "MedicationAdministration" ALTER COLUMN "effectiveTime" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "MedicationDispense" ALTER COLUMN "whenhandedover" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "MedicationDispense" ALTER COLUMN "whenprepared" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "MedicationRequest" ALTER COLUMN "authoredon" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "MedicationRequest" ALTER COLUMN "date" TYPE TIMESTAMPTZ[]'); await client.query('ALTER TABLE "MedicationStatement" ALTER COLUMN "effective" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "MessageDefinition" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "NamingSystem" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "NamingSystem" ALTER COLUMN "period" TYPE TIMESTAMPTZ[]'); await client.query('ALTER TABLE "NutritionOrder" ALTER COLUMN "datetime" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Observation" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Observation" ALTER COLUMN "valueDate" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "OperationDefinition" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "OrganizationAffiliation" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Patient" ALTER COLUMN "deathDate" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "PaymentNotice" ALTER COLUMN "created" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "PaymentReconciliation" ALTER COLUMN "created" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "PlanDefinition" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "PlanDefinition" ALTER COLUMN "effective" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "PractitionerRole" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Procedure" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Provenance" ALTER COLUMN "recorded" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Provenance" ALTER COLUMN "when" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Questionnaire" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Questionnaire" ALTER COLUMN "effective" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "QuestionnaireResponse" ALTER COLUMN "authored" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "RequestGroup" ALTER COLUMN "authored" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ResearchDefinition" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ResearchDefinition" ALTER COLUMN "effective" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ResearchElementDefinition" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ResearchElementDefinition" ALTER COLUMN "effective" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ResearchStudy" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ResearchSubject" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "RiskAssessment" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "RiskEvidenceSynthesis" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "RiskEvidenceSynthesis" ALTER COLUMN "effective" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Schedule" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "SearchParameter" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ServiceRequest" ALTER COLUMN "authored" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ServiceRequest" ALTER COLUMN "occurrence" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Slot" ALTER COLUMN "start" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Specimen" ALTER COLUMN "collected" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "StructureDefinition" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "StructureMap" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Substance" ALTER COLUMN "expiry" TYPE TIMESTAMPTZ[]'); await client.query('ALTER TABLE "SupplyRequest" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Task" ALTER COLUMN "authoredOn" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Task" ALTER COLUMN "modified" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "Task" ALTER COLUMN "period" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "TerminologyCapabilities" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "TestReport" ALTER COLUMN "issued" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "TestScript" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "ValueSet" ALTER COLUMN "date" TYPE TIMESTAMPTZ'); await client.query('ALTER TABLE "VisionPrescription" ALTER COLUMN "datewritten" TYPE TIMESTAMPTZ'); }