From: Alan Knowles Date: Sun, 13 Feb 2011 13:01:18 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=5b164d5cb9f62e201d30e7d92c783013ba0085eb DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index b581a6cf..de5734b2 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -240,9 +240,9 @@ CREATE TABLE `i18n` ( `inlang` varchar(8) NOT NULL, `lval` varchar(64) NOT NULL, PRIMARY KEY (`id`), - INDEX `lookup`(`ltype`, `lkey`, `inlang`) + ) ; - +ALTER TABLE i18n ADD INDEX `lookup`(`ltype`, `lkey`, `inlang`); DROP FUNCTION IF EXISTS i18n_translate;