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(`CREATE TABLE IF NOT EXISTS "Agent" ( "id" UUID NOT NULL PRIMARY KEY, "content" TEXT NOT NULL, "lastUpdated" TIMESTAMP WITH TIME ZONE NOT NULL, "deleted" BOOLEAN NOT NULL DEFAULT FALSE, "projectId" UUID NOT NULL, "compartments" UUID[] NOT NULL, "_profile" TEXT[], "_security" TEXT[], "_source" TEXT, "_tag" TEXT[], "name" TEXT, "status" TEXT )`); await client.query('CREATE INDEX ON "Agent" ("lastUpdated")'); await client.query('CREATE INDEX ON "Agent" ("projectId")'); await client.query('CREATE INDEX ON "Agent" USING GIN("compartments")'); await client.query('CREATE INDEX ON "Agent" USING GIN("_profile")'); await client.query('CREATE INDEX ON "Agent" USING GIN("_security")'); await client.query('CREATE INDEX ON "Agent" ("_source")'); await client.query('CREATE INDEX ON "Agent" USING GIN("_tag")'); await client.query(`CREATE TABLE IF NOT EXISTS "Agent_History" ( "versionId" UUID NOT NULL PRIMARY KEY, "id" UUID NOT NULL, "content" TEXT NOT NULL, "lastUpdated" TIMESTAMP WITH TIME ZONE NOT NULL )`); await client.query('CREATE INDEX ON "Agent_History" ("id")'); await client.query('CREATE INDEX ON "Agent_History" ("lastUpdated")'); await client.query(`CREATE TABLE IF NOT EXISTS "Agent_Token" ( "resourceId" UUID NOT NULL, "index" INTEGER NOT NULL, "code" TEXT NOT NULL, "system" TEXT, "value" TEXT )`); await client.query('CREATE INDEX ON "Agent_Token" ("resourceId")'); await client.query('CREATE INDEX ON "Agent_Token" ("code")'); await client.query('CREATE INDEX ON "Agent_Token" ("system")'); await client.query('CREATE INDEX ON "Agent_Token" ("value")'); }