Add a missing index on the "message" table
Closes #26 (closed)
Applied to erine.email SaaS:
MariaDB [spameater]> select sql_no_cache id from message where messageId='<4d3a21f6f87af281f10c24b3e2ba5935@xxx>';
+----+
| id |
+----+
| 1 |
+----+
1 row in set (0.791 sec)
MariaDB [spameater]> create index `message_idx1` on `message` (`messageId`);
Query OK, 0 rows affected (5.120 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [spameater]> select sql_no_cache id from message where messageId='<4d3a21f6f87af281f10c24b3e2ba5935@xxx>';
+----+
| id |
+----+
| 1 |
+----+
1 row in set (0.000 sec)