diff options
Diffstat (limited to 'crates/atuin-ai/migrations')
| -rw-r--r-- | crates/atuin-ai/migrations/20260413000000_create_ai_sessions.sql | 32 | ||||
| -rw-r--r-- | crates/atuin-ai/migrations/20260417000000_add_session_metadata.sql | 9 |
2 files changed, 0 insertions, 41 deletions
diff --git a/crates/atuin-ai/migrations/20260413000000_create_ai_sessions.sql b/crates/atuin-ai/migrations/20260413000000_create_ai_sessions.sql deleted file mode 100644 index 906a5726..00000000 --- a/crates/atuin-ai/migrations/20260413000000_create_ai_sessions.sql +++ /dev/null @@ -1,32 +0,0 @@ -CREATE TABLE IF NOT EXISTS sessions ( - id TEXT PRIMARY KEY, - head_id TEXT, - server_session_id TEXT, - directory TEXT, - git_root TEXT, - created_at INTEGER NOT NULL, - updated_at INTEGER NOT NULL, - archived_at INTEGER -); - -CREATE INDEX idx_sessions_directory ON sessions(directory); -CREATE INDEX idx_sessions_git_root ON sessions(git_root); -CREATE INDEX idx_sessions_updated_at ON sessions(updated_at); -CREATE INDEX idx_sessions_created_at ON sessions(created_at); - -CREATE TABLE IF NOT EXISTS session_events ( - id TEXT PRIMARY KEY, - session_id TEXT NOT NULL, - parent_id TEXT, - invocation_id TEXT NOT NULL, - event_type TEXT NOT NULL, - event_data TEXT NOT NULL, - created_at INTEGER NOT NULL, - - FOREIGN KEY (session_id) REFERENCES sessions(id) -); - -CREATE INDEX idx_session_events_session_id ON session_events(session_id); -CREATE INDEX idx_session_events_parent_id ON session_events(parent_id); -CREATE INDEX idx_session_events_invocation_id ON session_events(invocation_id); -CREATE INDEX idx_session_events_created_at ON session_events(created_at); diff --git a/crates/atuin-ai/migrations/20260417000000_add_session_metadata.sql b/crates/atuin-ai/migrations/20260417000000_add_session_metadata.sql deleted file mode 100644 index f97dfd1b..00000000 --- a/crates/atuin-ai/migrations/20260417000000_add_session_metadata.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE IF NOT EXISTS session_metadata ( - session_id TEXT NOT NULL, - key TEXT NOT NULL, - value TEXT NOT NULL, - updated_at INTEGER NOT NULL, - - PRIMARY KEY (session_id, key), - FOREIGN KEY (session_id) REFERENCES sessions(id) -); |
