16.11.25.sql 718 B

12345678910111213141516171819202122232425
  1. # Merge group- and type-based backlog into single per-sprint lists
  2. SET SESSION group_concat_max_len = 8192;
  3. CREATE TEMPORARY TABLE issue_backlog_converting
  4. SELECT sprint_id, REPLACE(GROUP_CONCAT(issues), '],[', ',')
  5. FROM issue_backlog
  6. GROUP BY sprint_id;
  7. TRUNCATE issue_backlog;
  8. ALTER TABLE issue_backlog
  9. DROP COLUMN user_id,
  10. DROP COLUMN type_id,
  11. DROP INDEX issue_backlog_user_id,
  12. DROP INDEX issue_backlog_type_id,
  13. DROP FOREIGN KEY issue_backlog_type_id,
  14. DROP FOREIGN KEY issue_backlog_user_id;
  15. INSERT INTO issue_backlog (sprint_id, issues)
  16. SELECT * FROM issue_backlog_converting;
  17. DROP TEMPORARY TABLE issue_backlog_converting;
  18. UPDATE `config` SET `value` = '16.11.25' WHERE `attribute` = 'version';