15 lines
580 B
MySQL
15 lines
580 B
MySQL
|
-- Migration: Add repetition_period field to tasks table
|
||
|
|
-- This script adds the repetition_period field for recurring tasks
|
||
|
|
|
||
|
|
-- ============================================
|
||
|
|
-- Add repetition_period column
|
||
|
|
-- ============================================
|
||
|
|
ALTER TABLE tasks
|
||
|
|
ADD COLUMN IF NOT EXISTS repetition_period INTERVAL;
|
||
|
|
|
||
|
|
-- ============================================
|
||
|
|
-- Comments for documentation
|
||
|
|
-- ============================================
|
||
|
|
COMMENT ON COLUMN tasks.repetition_period IS 'Period after which task should be repeated (NULL means task is not recurring)';
|
||
|
|
|