12 lines
528 B
MySQL
12 lines
528 B
MySQL
|
-- AP2.0f — work_cycle (Zeitbox/Sprint) + actions.work_cycle_id
|
||
|
|
|
||
|
|
ALTER TABLE roadmap_items DROP CONSTRAINT IF EXISTS roadmap_items_item_type_check;
|
||
|
|
ALTER TABLE roadmap_items ADD CONSTRAINT roadmap_items_item_type_check
|
||
|
|
CHECK (item_type IN ('milestone', 'review_gate', 'maturity_stage', 'work_cycle'));
|
||
|
|
|
||
|
|
ALTER TABLE actions
|
||
|
|
ADD COLUMN work_cycle_id UUID NULL REFERENCES roadmap_items(id) ON DELETE SET NULL;
|
||
|
|
|
||
|
|
CREATE INDEX idx_actions_work_cycle ON actions(tenant_id, work_cycle_id)
|
||
|
|
WHERE work_cycle_id IS NOT NULL;
|