15.06.02.sql 627 B

123456789101112131415161718192021
  1. # Update issue update detail view
  2. ALTER VIEW `issue_update_detail` AS (
  3. select
  4. `i`.`id` AS `id`,
  5. `i`.`issue_id` AS `issue_id`,
  6. `i`.`user_id` AS `user_id`,
  7. `i`.`created_date` AS `created_date`,
  8. `u`.`username` AS `user_username`,
  9. `u`.`name` AS `user_name`,
  10. `u`.`email` AS `user_email`,
  11. `i`.`comment_id` AS `comment_id`,
  12. `c`.`text` AS `comment_text`,
  13. `i`.`notify` AS `notify`
  14. from `issue_update` `i`
  15. inner join `user` `u` on `i`.`user_id` = `u`.`id`
  16. left join `issue_comment` `c` on `i`.`comment_id` = `c`.`id`
  17. );
  18. # Update Version
  19. UPDATE `config` SET `value` = '15.06.12' WHERE `attribute` = 'version';