17.03.17.sql 2.4 KB

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