Add Column
Current Schema
CREATE TABLE favorites (
id INTEGER PRIMARY KEY AUTOINCREMENT,
child_id TEXT NOT NULL REFERENCES children(id),
message_id INTEGER REFERENCES messages(id),
role TEXT NOT NULL CHECK(role IN ('user', 'ai')),
content TEXT NOT NULL,
note TEXT,
source TEXT DEFAULT 'manual',
created_at DATETIME DEFAULT (datetime('now'))
)