mirror of
https://github.com/windmill-labs/windmill.git
synced 2026-08-20 16:02:19 +00:00
7fa924e67e
* fix: remove conversation after_id filter * fix: implement message after_id cursor * fix: use persisted cursor for chat polling Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com> * refactor: simplify message cursor ordering Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com> * refactor: use cte for message cursor Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com> * Update SQLx metadata * fix: use monotonic flow message cursor * Update SQLx metadata * fix: tighten flow message cursor pagination Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com> * Update SQLx metadata --------- Co-authored-by: Claude Opus 4.5 <noreply@anthropic.com> Co-authored-by: windmill-internal-app[bot] <windmill-internal-app[bot]@users.noreply.github.com>
11 lines
401 B
SQL
11 lines
401 B
SQL
DROP INDEX IF EXISTS idx_conversation_message_conversation_created_seq;
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_conversation_message_conversation_time
|
|
ON flow_conversation_message(conversation_id, created_at DESC);
|
|
|
|
ALTER TABLE flow_conversation_message
|
|
DROP CONSTRAINT IF EXISTS flow_conversation_message_created_seq_key;
|
|
|
|
ALTER TABLE flow_conversation_message
|
|
DROP COLUMN IF EXISTS created_seq;
|