Skip to content

Commit 7c15aaf

Browse files
only21milclaude
andcommitted
fix(server): leave migration 074 as shipped
Migration 074 called the trigger helper directly; only migration 77 needs the shared recreateMessageSearchTriggers. Co-Authored-By: Claude Opus 5.5 <[email protected]>
1 parent 386e0ff commit 7c15aaf

1 file changed

Lines changed: 10 additions & 2 deletions

File tree

Lines changed: 10 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,10 +1,18 @@
11
import * as Effect from "effect/Effect";
22
import * as SqlClient from "effect/sql/SqlClient";
33

4-
import { recreateMessageSearchTriggers } from "../../orchestration-v2/messageSearchIndex.ts";
4+
import { createMessageSearchTriggers } from "../../orchestration-v2/messageSearchIndex.ts";
55

66
export default Effect.gen(function* () {
77
const sql = yield* SqlClient.SqlClient;
8+
const index = yield* sql`
9+
SELECT 1 FROM sqlite_master WHERE name = 'orchestration_v2_message_search'
10+
`;
11+
if (index.length === 0) return;
12+
813
// Legacy placeholders stay indexed until rebuild; FTS deletes can overflow last_insert_rowid at commit.
9-
yield* recreateMessageSearchTriggers(sql);
14+
yield* sql`DROP TRIGGER orchestration_v2_message_search_insert`;
15+
yield* sql`DROP TRIGGER orchestration_v2_message_search_update`;
16+
yield* sql`DROP TRIGGER orchestration_v2_message_search_delete`;
17+
yield* createMessageSearchTriggers(sql);
1018
});

0 commit comments

Comments
 (0)