16.11.23.sql 521 B

123456789101112131415
  1. # Update issue_type to support roles
  2. ALTER TABLE `issue_type`
  3. ADD COLUMN `role` ENUM('task','project','bug') DEFAULT 'task' NOT NULL,
  4. ADD INDEX `issue_type_role` (`role`);
  5. UPDATE issue_type
  6. JOIN config ON config.value = issue_type.id AND config.attribute = 'issue_type.project'
  7. SET issue_type.role = 'project';
  8. UPDATE issue_type
  9. JOIN config ON config.value = issue_type.id AND config.attribute = 'issue_type.bug'
  10. SET issue_type.role = 'bug';
  11. UPDATE `config` SET `value` = '16.11.23' WHERE `attribute` = 'version';