17 lines
764 B
MySQL
17 lines
764 B
MySQL
|
-- Migration: Add repetition_date field to tasks table
|
||
|
|
-- This script adds the repetition_date field for pattern-based recurring tasks
|
||
|
|
-- Format examples: "2 week" (2nd day of week), "15 month" (15th day of month), "02-01 year" (Feb 1st)
|
||
|
|
|
||
|
|
-- ============================================
|
||
|
|
-- Add repetition_date column
|
||
|
|
-- ============================================
|
||
|
|
ALTER TABLE tasks
|
||
|
|
ADD COLUMN IF NOT EXISTS repetition_date TEXT;
|
||
|
|
|
||
|
|
-- ============================================
|
||
|
|
-- Comments for documentation
|
||
|
|
-- ============================================
|
||
|
|
COMMENT ON COLUMN tasks.repetition_date IS 'Pattern-based repetition: "N week" (day of week 1-7), "N month" (day of month 1-31), "MM-DD year" (specific date). Mutually exclusive with repetition_period.';
|
||
|
|
|
||
|
|
|