16 lines
610 B
SQL
16 lines
610 B
SQL
-- Additional indexes for conversations
|
|
CREATE INDEX IF NOT EXISTS idx_conversations_started_at ON conversations(started_at);
|
|
CREATE INDEX IF NOT EXISTS idx_conversations_ended_at ON conversations(ended_at);
|
|
|
|
-- Create conversation_state table for workflow state
|
|
CREATE TABLE IF NOT EXISTS conversation_state (
|
|
session_id VARCHAR(255) PRIMARY KEY REFERENCES sessions(id) ON DELETE CASCADE,
|
|
workflow VARCHAR(255),
|
|
step VARCHAR(255),
|
|
context JSONB DEFAULT '{}'::jsonb,
|
|
created_at TIMESTAMP NOT NULL DEFAULT NOW(),
|
|
updated_at TIMESTAMP NOT NULL DEFAULT NOW(),
|
|
expires_at TIMESTAMP
|
|
);
|
|
|