BangSo/packages/db/prisma/migrations/0005_bot_pinned/migration.sql

7 lines
234 B
MySQL
Raw Permalink Normal View History

2026-09-01 16:51:19 +00:00
ALTER TABLE "bots" ADD COLUMN "pinned" BOOLEAN NOT NULL DEFAULT false;
DROP INDEX "bots_workspaceId_userId_idx";
CREATE INDEX "bots_workspaceId_userId_pinned_updatedAt_idx"
ON "bots"("workspaceId", "userId", "pinned", "updatedAt");