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 --- src/scripts/update_updated.sql | 2 -- 1 file changed, 2 deletions(-) delete mode 100644 src/scripts/update_updated.sql (limited to 'src/scripts/update_updated.sql') diff --git a/src/scripts/update_updated.sql b/src/scripts/update_updated.sql deleted file mode 100644 index 39b29210..00000000 --- a/src/scripts/update_updated.sql +++ /dev/null @@ -1,2 +0,0 @@ -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