From: Alan Knowles Date: Thu, 10 Feb 2011 05:59:25 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=3b1dbfdccdfe4aebb3de5385ad0aba1e0d27363d DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 8dd21064..6549c30e 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -281,4 +281,6 @@ CREATE TABLE `translations` ( tkey varchar(32) NOT NULL, tval longtext NOT NULL, PRIMARY KEY (`id`) -); \ No newline at end of file +); + +ALTER TABLE translations ADD INDEX qlookup (module, tfile, tlang, tkey);