From 9c55cb729bc28c86ca03f0e30e5ff19b4a0a8ea4 Mon Sep 17 00:00:00 2001 From: Frank Date: Sun, 4 Jan 2026 22:46:21 -0500 Subject: zen: add index --- packages/console/core/src/schema/billing.sql.ts | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'packages/console/core/src') diff --git a/packages/console/core/src/schema/billing.sql.ts b/packages/console/core/src/schema/billing.sql.ts index 6d1520d15..17cdd871d 100644 --- a/packages/console/core/src/schema/billing.sql.ts +++ b/packages/console/core/src/schema/billing.sql.ts @@ -1,4 +1,4 @@ -import { bigint, boolean, int, mysqlTable, uniqueIndex, varchar } from "drizzle-orm/mysql-core" +import { bigint, boolean, index, int, mysqlTable, uniqueIndex, varchar } from "drizzle-orm/mysql-core" import { timestamps, ulid, utc, workspaceColumns } from "../drizzle/types" import { workspaceIndexes } from "./workspace.sql" @@ -55,5 +55,5 @@ export const UsageTable = mysqlTable( cost: bigint("cost", { mode: "number" }).notNull(), keyID: ulid("key_id"), }, - (table) => [...workspaceIndexes(table)], + (table) => [...workspaceIndexes(table), index("usage_time_created").on(table.workspaceID, table.timeCreated)], ) -- cgit v1.2.3