// 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 "Group" ADD COLUMN IF NOT EXISTS "characteristicRange" DOUBLE PRECISION[]');
await client.query(
'CREATE INDEX CONCURRENTLY IF NOT EXISTS "Group_characteristicRange_idx" ON "Group" USING gin ("characteristicRange")'
);
await client.query('ALTER TABLE IF EXISTS "ResearchStudy" ADD COLUMN IF NOT EXISTS "description" TEXT');
await client.query('ALTER TABLE IF EXISTS "ResearchStudy" ADD COLUMN IF NOT EXISTS "eligibility" TEXT');
await client.query('ALTER TABLE IF EXISTS "ResearchStudy" ADD COLUMN IF NOT EXISTS "name" TEXT');
await client.query('ALTER TABLE IF EXISTS "ResearchStudy" ADD COLUMN IF NOT EXISTS "objectiveDescription" TEXT[]');
await client.query('ALTER TABLE IF EXISTS "ResearchStudy" ADD COLUMN IF NOT EXISTS "partOf" TEXT[]');
await client.query(
'ALTER TABLE IF EXISTS "ResearchStudy" ADD COLUMN IF NOT EXISTS "recruitmentActual" DOUBLE PRECISION'
);
await client.query(
'ALTER TABLE IF EXISTS "ResearchStudy" ADD COLUMN IF NOT EXISTS "recruitmentTarget" DOUBLE PRECISION'
);
await client.query('ALTER TABLE IF EXISTS "ResearchStudy" ADD COLUMN IF NOT EXISTS "outcomeMeasureReference" TEXT[]');
await client.query(
'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ResearchStudy_description_idx" ON "ResearchStudy" ("description")'
);
await client.query(
'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ResearchStudy_eligibility_idx" ON "ResearchStudy" ("eligibility")'
);
await client.query('CREATE INDEX CONCURRENTLY IF NOT EXISTS "ResearchStudy_name_idx" ON "ResearchStudy" ("name")');
await client.query(
'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ResearchStudy_objectiveDescription_idx" ON "ResearchStudy" USING gin ("objectiveDescription")'
);
await client.query(
'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ResearchStudy_partOf_idx" ON "ResearchStudy" USING gin ("partOf")'
);
await client.query(
'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ResearchStudy_recruitmentActual_idx" ON "ResearchStudy" ("recruitmentActual")'
);
await client.query(
'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ResearchStudy_recruitmentTarget_idx" ON "ResearchStudy" ("recruitmentTarget")'
);
await client.query(
'CREATE INDEX CONCURRENTLY IF NOT EXISTS "ResearchStudy_outcomeMeasureReference_idx" ON "ResearchStudy" USING gin ("outcomeMeasureReference")'
);
}