16.11.30.sql 933 B

12345678910111213141516171819202122232425262728
  1. ALTER VIEW `issue_comment_detail` AS (
  2. SELECT
  3. `c`.`id` AS `id`,
  4. `c`.`issue_id` AS `issue_id`,
  5. `c`.`user_id` AS `user_id`,
  6. `c`.`text` AS `text`,
  7. `c`.`file_id` AS `file_id`,
  8. `c`.`created_date` AS `created_date`,
  9. `u`.`username` AS `user_username`,
  10. `u`.`email` AS `user_email`,
  11. `u`.`name` AS `user_name`,
  12. `u`.`role` AS `user_role`,
  13. `u`.`task_color` AS `user_task_color`,
  14. `f`.`filename` AS `file_filename`,
  15. `f`.`filesize` AS `file_filesize`,
  16. `f`.`content_type` AS `file_content_type`,
  17. `f`.`downloads` AS `file_downloads`,
  18. `f`.`created_date` AS `file_created_date`,
  19. `f`.`deleted_date` AS `file_deleted_date`,
  20. `i`.`deleted_date` AS `issue_deleted_date`
  21. FROM `issue_comment` `c`
  22. JOIN `user` `u` ON `c`.`user_id` = `u`.`id`
  23. LEFT JOIN `issue_file` `f` ON `c`.`file_id` = `f`.`id`
  24. JOIN `issue` `i` ON `i`.`id` = `c`.`issue_id`
  25. );
  26. UPDATE `config` SET `value` = '16.11.30' WHERE `attribute` = 'version';