mast / db / migrations / 0002.sql

CREATE VIEW IF NOT EXISTS active_todos AS 
SELECT 
    id,
    ROW_NUMBER() OVER (ORDER BY id) as working_id,
    description,
    project,
    tags,
    due,
    wait,
    priority,
    urgency
FROM todos 
WHERE completed = 0;