blob: cc11324483c874ddfb63438bcce1836e76a3caa6 (
plain)
1
2
3
4
5
6
7
8
9
10
|
-- Recurrence support for doot-native tasks: a recurring task generates a
-- brand-new row per iteration (see Store.CreateNextIteration), linked by
-- recurrence_series_id. recurrence_freq empty means "not recurring."
ALTER TABLE native_tasks ADD COLUMN recurrence_freq TEXT DEFAULT '';
ALTER TABLE native_tasks ADD COLUMN recurrence_interval INTEGER DEFAULT 1;
ALTER TABLE native_tasks ADD COLUMN recurrence_weekdays TEXT DEFAULT '';
ALTER TABLE native_tasks ADD COLUMN recurrence_series_id TEXT DEFAULT '';
ALTER TABLE native_tasks ADD COLUMN next_occurrence_override TEXT DEFAULT '';
CREATE INDEX IF NOT EXISTS idx_native_tasks_recurrence_series ON native_tasks(recurrence_series_id);
|
