From 6b67a66a1ba33f3dc4346f8fffd1f9535ce54d17 Mon Sep 17 00:00:00 2001 From: Jerome Sautret 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') 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