From 6b67a66a1ba33f3dc4346f8fffd1f9535ce54d17 Mon Sep 17 00:00:00 2001
From: Jerome Sautret <jerome.sautret@process-one.net>
Date: Fri, 13 Mar 2015 18:29:57 +0100
Subject: Added MySQL support for delete_old_messages (offline) command.

---
 sql/mysql.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'sql/mysql.sql')

diff --git a/sql/mysql.sql b/sql/mysql.sql
index 64f54ba70..8557d0804 100644
--- a/sql/mysql.sql
+++ b/sql/mysql.sql
@@ -79,6 +79,7 @@ CREATE TABLE spool (
 ) ENGINE=InnoDB CHARACTER SET utf8;
 
 CREATE INDEX i_despool USING BTREE ON spool(username);
+CREATE INDEX i_spool_created_at USING BTREE ON spool(created_at);
 
 CREATE TABLE vcard (
     username varchar(250) PRIMARY KEY,
-- 
cgit v1.2.3

