Skip to content

TaskView is a self-hosted project and task management platform focused on clarity, ownership, and control. TaskView is built for teams that want a transparent, self-hosted alternative to SaaS task managers.

348 B
Raw Blame
ALTER TABLE tasks.tasks
    ADD COLUMN IF NOT EXISTS sprint_id INTEGER REFERENCES tasks.sprints(id) ON DELETE SET NULL,
    ADD COLUMN IF NOT EXISTS estimate_value NUMERIC(10, 2);
    -- estimate_value: task estimate in story points (unitless).

CREATE INDEX IF NOT EXISTS idx_tasks_sprint_id ON tasks.tasks(sprint_id) WHERE sprint_id IS NOT NULL;