| 1 | -- Issues became work items (g1t #57): cards kept about one are about a |
| 2 | -- work item now, and a draft of one is a draft work item. |
| 3 | UPDATE messages SET card = json_set(card, '$.kind', 'work_item') |
| 4 | WHERE kind = 'card' AND json_valid(card) AND json_extract(card, '$.kind') = 'issue'; |
| 5 | |
| 6 | UPDATE messages SET card = json_set(card, '$.kind', 'draft_work_item') |
| 7 | WHERE kind = 'card' AND json_valid(card) AND json_extract(card, '$.kind') = 'draft_issue'; |