diff options
Diffstat (limited to 'internal/storage/db.go')
| -rw-r--r-- | internal/storage/db.go | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/internal/storage/db.go b/internal/storage/db.go index fb754f5..b6af2c8 100644 --- a/internal/storage/db.go +++ b/internal/storage/db.go @@ -66,8 +66,10 @@ func (s *DB) migrate() error { ); CREATE INDEX IF NOT EXISTS idx_tasks_state ON tasks(state); + CREATE INDEX IF NOT EXISTS idx_tasks_parent_task_id ON tasks(parent_task_id); CREATE INDEX IF NOT EXISTS idx_executions_status ON executions(status); CREATE INDEX IF NOT EXISTS idx_executions_task_id ON executions(task_id); + CREATE INDEX IF NOT EXISTS idx_executions_start_time ON executions(start_time); ` if _, err := s.db.Exec(schema); err != nil { return err |