pub const CREATE_CONVERSATIONS: &str = "
CREATE TABLE IF NOT EXISTS conversations (
id TEXT PRIMARY KEY,
title TEXT,
model TEXT NOT NULL,
provider TEXT NOT NULL,
cwd TEXT NOT NULL DEFAULT '',
created_at TEXT NOT NULL,
updated_at TEXT NOT NULL
)";
pub const CREATE_MESSAGES: &str = "
CREATE TABLE IF NOT EXISTS messages (
id TEXT PRIMARY KEY,
conversation_id TEXT NOT NULL,
role TEXT NOT NULL,
content TEXT NOT NULL,
token_count INTEGER DEFAULT 0,
created_at TEXT NOT NULL,
FOREIGN KEY (conversation_id) REFERENCES conversations(id)
)";
pub const CREATE_TOOL_CALLS: &str = "
CREATE TABLE IF NOT EXISTS tool_calls (
id TEXT PRIMARY KEY,
message_id TEXT NOT NULL,
name TEXT NOT NULL,
input TEXT NOT NULL,
output TEXT,
is_error INTEGER DEFAULT 0,
created_at TEXT NOT NULL,
FOREIGN KEY (message_id) REFERENCES messages(id)
)";