Jason Woltje
92de2f282f
All checks were successful
ci/woodpecker/push/api Pipeline was successful
Root cause: migration 20260129235248_add_link_storage_fields dropped the personalities table and FormalityLevel enum, but migration 20260208000000_add_missing_tables later references personalities in a FK constraint, causing ERROR: relation "personalities" does not exist on any fresh database deployment. Fix 1 — 20260208000000_add_missing_tables: Recreate FormalityLevel enum and personalities table (with current schema structure) at the top of the migration, before the FK constraint. Fix 2 — New migration 20260215100000_fix_schema_drift: - Create missing instances table (Federation module, never migrated) - Recreate knowledge_links unique index (dropped, never recreated) - Add 7 missing @@unique([id, workspaceId]) composite indexes - Add missing agent_tasks.agent_type index Verified: all 27 migrations apply cleanly on a fresh PostgreSQL 17 database with pgvector. Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
50 lines
2.3 KiB
SQL
50 lines
2.3 KiB
SQL
-- Fix schema drift: tables, indexes, and constraints defined in schema.prisma
|
|
-- but never created (or dropped and never recreated) by prior migrations.
|
|
|
|
-- ============================================
|
|
-- CreateTable: instances (Federation module)
|
|
-- Never created in any prior migration
|
|
-- ============================================
|
|
CREATE TABLE "instances" (
|
|
"id" UUID NOT NULL,
|
|
"instance_id" TEXT NOT NULL,
|
|
"name" TEXT NOT NULL,
|
|
"url" TEXT NOT NULL,
|
|
"public_key" TEXT NOT NULL,
|
|
"private_key" TEXT NOT NULL,
|
|
"capabilities" JSONB NOT NULL DEFAULT '{}',
|
|
"metadata" JSONB NOT NULL DEFAULT '{}',
|
|
"created_at" TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updated_at" TIMESTAMPTZ NOT NULL,
|
|
|
|
CONSTRAINT "instances_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
CREATE UNIQUE INDEX "instances_instance_id_key" ON "instances"("instance_id");
|
|
|
|
-- ============================================
|
|
-- Recreate dropped unique index on knowledge_links
|
|
-- Created in 20260129220645_add_knowledge_module, dropped in
|
|
-- 20260129235248_add_link_storage_fields, never recreated.
|
|
-- ============================================
|
|
CREATE UNIQUE INDEX "knowledge_links_source_id_target_id_key" ON "knowledge_links"("source_id", "target_id");
|
|
|
|
-- ============================================
|
|
-- Missing @@unique([id, workspaceId]) composite indexes
|
|
-- Defined in schema.prisma but never created in migrations.
|
|
-- (agent_tasks and runner_jobs already have these.)
|
|
-- ============================================
|
|
CREATE UNIQUE INDEX "tasks_id_workspace_id_key" ON "tasks"("id", "workspace_id");
|
|
CREATE UNIQUE INDEX "events_id_workspace_id_key" ON "events"("id", "workspace_id");
|
|
CREATE UNIQUE INDEX "projects_id_workspace_id_key" ON "projects"("id", "workspace_id");
|
|
CREATE UNIQUE INDEX "activity_logs_id_workspace_id_key" ON "activity_logs"("id", "workspace_id");
|
|
CREATE UNIQUE INDEX "domains_id_workspace_id_key" ON "domains"("id", "workspace_id");
|
|
CREATE UNIQUE INDEX "ideas_id_workspace_id_key" ON "ideas"("id", "workspace_id");
|
|
CREATE UNIQUE INDEX "user_layouts_id_workspace_id_key" ON "user_layouts"("id", "workspace_id");
|
|
|
|
-- ============================================
|
|
-- Missing index on agent_tasks.agent_type
|
|
-- Defined as @@index([agentType]) in schema.prisma
|
|
-- ============================================
|
|
CREATE INDEX "agent_tasks_agent_type_idx" ON "agent_tasks"("agent_type");
|