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 "ActivityDefinition" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "AdverseEvent" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "AllergyIntolerance" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query( 'ALTER TABLE "AllergyIntolerance" ALTER COLUMN "lastDate" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); await client.query( 'ALTER TABLE "AllergyIntolerance" ALTER COLUMN "onset" TYPE TIMESTAMP WITH TIME ZONE[] USING \'{}\'::TIMESTAMP WITH TIME ZONE[]' ); await client.query('ALTER TABLE "Appointment" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "AuditEvent" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "Bundle" ALTER COLUMN "timestamp" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "CapabilityStatement" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "ChargeItem" ALTER COLUMN "enteredDate" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "ChargeItemDefinition" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "Claim" ALTER COLUMN "created" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "ClaimResponse" ALTER COLUMN "created" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "ClinicalImpression" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "CodeSystem" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "Communication" ALTER COLUMN "received" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "Communication" ALTER COLUMN "sent" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query( 'ALTER TABLE "CommunicationRequest" ALTER COLUMN "authored" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); await client.query( 'ALTER TABLE "CompartmentDefinition" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); await client.query('ALTER TABLE "Composition" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "ConceptMap" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "Condition" ALTER COLUMN "recordedDate" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "Consent" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "Contract" ALTER COLUMN "issued" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query( 'ALTER TABLE "CoverageEligibilityRequest" ALTER COLUMN "created" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); await client.query( 'ALTER TABLE "CoverageEligibilityResponse" ALTER COLUMN "created" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); await client.query('ALTER TABLE "DeviceRequest" ALTER COLUMN "authoredOn" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "DiagnosticReport" ALTER COLUMN "issued" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "DocumentManifest" ALTER COLUMN "created" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "DocumentReference" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query( 'ALTER TABLE "EffectEvidenceSynthesis" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); await client.query('ALTER TABLE "EventDefinition" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "Evidence" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "EvidenceVariable" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "ExampleScenario" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query( 'ALTER TABLE "ExplanationOfBenefit" ALTER COLUMN "created" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); await client.query('ALTER TABLE "FamilyMemberHistory" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "GraphDefinition" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "ImagingStudy" ALTER COLUMN "started" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query( 'ALTER TABLE "Immunization" ALTER COLUMN "reactionDate" TYPE TIMESTAMP WITH TIME ZONE[] USING \'{}\'::TIMESTAMP WITH TIME ZONE[]' ); await client.query( 'ALTER TABLE "ImmunizationEvaluation" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); await client.query( 'ALTER TABLE "ImmunizationRecommendation" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); await client.query('ALTER TABLE "ImplementationGuide" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "Invoice" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "Library" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "List" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "Measure" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "MeasureReport" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "Medication" ALTER COLUMN "expirationDate" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query( 'ALTER TABLE "MedicationDispense" ALTER COLUMN "whenhandedover" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); await client.query( 'ALTER TABLE "MedicationDispense" ALTER COLUMN "whenprepared" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); await client.query( 'ALTER TABLE "MedicationRequest" ALTER COLUMN "authoredon" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); await client.query( 'ALTER TABLE "MedicationRequest" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE[] USING \'{}\'::TIMESTAMP WITH TIME ZONE[]' ); await client.query('ALTER TABLE "MessageDefinition" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "NamingSystem" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "NutritionOrder" ALTER COLUMN "datetime" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "OperationDefinition" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "PaymentNotice" ALTER COLUMN "created" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query( 'ALTER TABLE "PaymentReconciliation" ALTER COLUMN "created" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); await client.query('ALTER TABLE "PlanDefinition" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "Provenance" ALTER COLUMN "recorded" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "Questionnaire" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query( 'ALTER TABLE "QuestionnaireResponse" ALTER COLUMN "authored" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); await client.query('ALTER TABLE "RequestGroup" ALTER COLUMN "authored" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "ResearchDefinition" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query( 'ALTER TABLE "ResearchElementDefinition" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); await client.query( 'ALTER TABLE "RiskEvidenceSynthesis" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); await client.query('ALTER TABLE "SearchParameter" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "ServiceRequest" ALTER COLUMN "authored" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "Slot" ALTER COLUMN "start" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "StructureDefinition" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "StructureMap" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query( 'ALTER TABLE "Substance" ALTER COLUMN "expiry" TYPE TIMESTAMP WITH TIME ZONE[] USING \'{}\'::TIMESTAMP WITH TIME ZONE[]' ); await client.query('ALTER TABLE "SupplyRequest" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "Task" ALTER COLUMN "authoredOn" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "Task" ALTER COLUMN "modified" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query( 'ALTER TABLE "TerminologyCapabilities" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); await client.query('ALTER TABLE "TestReport" ALTER COLUMN "issued" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "TestScript" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query('ALTER TABLE "ValueSet" ALTER COLUMN "date" TYPE TIMESTAMP WITH TIME ZONE USING NULL'); await client.query( 'ALTER TABLE "VisionPrescription" ALTER COLUMN "datewritten" TYPE TIMESTAMP WITH TIME ZONE USING NULL' ); }