From 223e8ec7742855ac83da445c40656aea3bec7e9b Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Fri, 16 Mar 2018 11:35:08 +0300
Subject: gradle: remove tests from root project

---
 contrib/scripts/update_updated.sql | 2 ++
 1 file changed, 2 insertions(+)
 create mode 100644 contrib/scripts/update_updated.sql

(limited to 'contrib/scripts/update_updated.sql')

diff --git a/contrib/scripts/update_updated.sql b/contrib/scripts/update_updated.sql
new file mode 100644
index 00000000..39b29210
--- /dev/null
+++ b/contrib/scripts/update_updated.sql
@@ -0,0 +1,2 @@
+UPDATE messages, (SELECT messages.`message_id` midd, MAX(COALESCE(replies.ts, messages.ts)) lastt  FROM messages LEFT JOIN replies ON messages.`message_id`=replies.`message_id` GROUP BY messages.`message_id`) res
+SET messages.updated = res.lastt WHERE messages.`message_id` = res.midd ;
\ No newline at end of file
-- 
cgit v1.2.3

