aboutsummaryrefslogtreecommitdiff
path: root/src/scripts
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2018-03-16 11:35:08 +0300
committerGravatar Vitaly Takmazov2018-03-16 11:35:08 +0300
commit223e8ec7742855ac83da445c40656aea3bec7e9b (patch)
treeeafe323999559ebe7e4492e665b458abcfe7fe6f /src/scripts
parent9ef168a03b75aeca0c2f7dda9ce87d4014c703a9 (diff)
gradle: remove tests from root project
Diffstat (limited to 'src/scripts')
-rw-r--r--src/scripts/update_updated.sql2
1 files changed, 0 insertions, 2 deletions
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