Ti.ddlmZddlZGddeZy)) MigrationNc\eZdZdZdZdej ddfdZdej ddfdZy)V1InitialSchemarzInitial schemaconnreturnNc|jd|jd|jd|jdy)Na CREATE TABLE IF NOT EXISTS chat_sessions ( id TEXT PRIMARY KEY, canvas_id TEXT, created_at TEXT DEFAULT (STRFTIME('%Y-%m-%dT%H:%M:%fZ', 'now')), updated_at TEXT DEFAULT (STRFTIME('%Y-%m-%dT%H:%M:%fZ', 'now')), title TEXT, model TEXT, provider TEXT, FOREIGN KEY (canvas_id) REFERENCES canvases(id) ) zx CREATE INDEX IF NOT EXISTS idx_chat_sessions_updated_at ON chat_sessions(updated_at DESC, id DESC) a CREATE TABLE IF NOT EXISTS chat_messages ( id INTEGER PRIMARY KEY AUTOINCREMENT, session_id TEXT, role TEXT, message TEXT, created_at TEXT DEFAULT (STRFTIME('%Y-%m-%dT%H:%M:%fZ', 'now')), updated_at TEXT DEFAULT (STRFTIME('%Y-%m-%dT%H:%M:%fZ', 'now')), FOREIGN KEY (session_id) REFERENCES chat_sessions(id) ) zr CREATE INDEX IF NOT EXISTS idx_chat_messages_session_id_id ON chat_messages(session_id, id); executeselfrs _/home/jay/workspace/tools/ai-image-gen/jaaz-app/server/services/migrations/v1_initial_schema.pyupzV1InitialSchema.upsL         cH|jd|jdy)Nz"DROP TABLE IF EXISTS chat_messagesz"DROP TABLE IF EXISTS chat_sessionsr r s rdownzV1InitialSchema.down,s 9: 9:r) __name__ __module__ __qualname__version descriptionsqlite3 Connectionrrrrrrs?G"K" w))" d" H;++;;rr)rrrrrrrs*;i*;r