diff options
| author | Jerome Sautret <jerome.sautret@process-one.net> | 2015-03-13 18:29:57 +0100 |
|---|---|---|
| committer | Christophe Romain <christophe.romain@process-one.net> | 2015-03-20 10:40:19 +0100 |
| commit | 6b67a66a1ba33f3dc4346f8fffd1f9535ce54d17 (patch) | |
| tree | 863b118f9c9f6f242d5cf350dc865d49965806b4 /sql | |
| parent | Fix mod_offline termination (diff) | |
Added MySQL support for delete_old_messages (offline) command.
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mysql.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/mysql.sql b/sql/mysql.sql index 64f54ba7..8557d080 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, |