12 lines
534 B
MySQL
12 lines
534 B
MySQL
|
-- P7: Technische Schuld — item_kind / action_kind tech_debt
|
||
|
|
|
||
|
|
ALTER TABLE actions DROP CONSTRAINT IF EXISTS actions_action_kind_check;
|
||
|
|
ALTER TABLE actions
|
||
|
|
ADD CONSTRAINT actions_action_kind_check
|
||
|
|
CHECK (action_kind IN ('delivery', 'planning', 'review', 'bug', 'issue', 'tech_debt'));
|
||
|
|
|
||
|
|
ALTER TABLE backlog_items DROP CONSTRAINT IF EXISTS backlog_items_item_kind_check;
|
||
|
|
ALTER TABLE backlog_items
|
||
|
|
ADD CONSTRAINT backlog_items_item_kind_check
|
||
|
|
CHECK (item_kind IN ('story', 'bug', 'issue', 'epic', 'tech_debt'));
|