15.02.26.sql 2.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
  1. # Update issue_detail view
  2. ALTER VIEW `issue_detail` AS
  3. SELECT
  4. `issue`.`id` AS `id`,
  5. `issue`.`status` AS `status`,
  6. `issue`.`type_id` AS `type_id`,
  7. `issue`.`name` AS `name`,
  8. `issue`.`description` AS `description`,
  9. `issue`.`parent_id` AS `parent_id`,
  10. `issue`.`author_id` AS `author_id`,
  11. `issue`.`owner_id` AS `owner_id`,
  12. `issue`.`priority` AS `priority`,
  13. `issue`.`hours_total` AS `hours_total`,
  14. `issue`.`hours_remaining` AS `hours_remaining`,
  15. `issue`.`hours_spent` AS `hours_spent`,
  16. `issue`.`created_date` AS `created_date`,
  17. `issue`.`closed_date` AS `closed_date`,
  18. `issue`.`deleted_date` AS `deleted_date`,
  19. `issue`.`start_date` AS `start_date`,
  20. `issue`.`due_date` AS `due_date`,
  21. ISNULL(`issue`.`due_date`) AS `has_due_date`,
  22. `issue`.`repeat_cycle` AS `repeat_cycle`,
  23. `issue`.`sprint_id` AS `sprint_id`,
  24. `sprint`.`name` AS `sprint_name`,
  25. `sprint`.`start_date` AS `sprint_start_date`,
  26. `sprint`.`end_date` AS `sprint_end_date`,
  27. `type`.`name` AS `type_name`,
  28. `status`.`name` AS `status_name`,
  29. `status`.`closed` AS `status_closed`,
  30. `priority`.`id` AS `priority_id`,
  31. `priority`.`name` AS `priority_name`,
  32. `author`.`username` AS `author_username`,
  33. `author`.`name` AS `author_name`,
  34. `author`.`email` AS `author_email`,
  35. `author`.`task_color` AS `author_task_color`,
  36. `owner`.`username` AS `owner_username`,
  37. `owner`.`name` AS `owner_name`,
  38. `owner`.`email` AS `owner_email`,
  39. `owner`.`task_color` AS `owner_task_color`,
  40. `parent`.`name` AS `parent_name`
  41. FROM `issue`
  42. LEFT JOIN `user` `author` ON `issue`.`author_id` = `author`.`id`
  43. LEFT JOIN `user` `owner` ON `issue`.`owner_id` = `owner`.`id`
  44. LEFT JOIN `issue_status` `status` ON `issue`.`status` = `status`.`id`
  45. LEFT JOIN `issue_priority` `priority` ON `issue`.`priority` = `priority`.`value`
  46. LEFT JOIN `issue_type` `type` ON `issue`.`type_id` = `type`.`id`
  47. LEFT JOIN `sprint` ON `issue`.`sprint_id` = `sprint`.`id`
  48. LEFT JOIN `issue` `parent` ON `issue`.`parent_id` = `parent`.`id`;
  49. # Update Version
  50. UPDATE `config` SET `value` = '15.02.26' WHERE `attribute` = 'version';