projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
748bdd7
)
sql/I18n.sql
author
edward
<edward@roojs.com>
Thu, 20 Oct 2016 05:02:44 +0000
(13:02 +0800)
committer
edward
<edward@roojs.com>
Thu, 20 Oct 2016 05:02:44 +0000
(13:02 +0800)
sql/I18n.sql
patch
|
blob
|
history
diff --git
a/sql/I18n.sql
b/sql/I18n.sql
index
54153ba
..
4214172
100644
(file)
--- a/
sql/I18n.sql
+++ b/
sql/I18n.sql
@@
-13,3
+13,4
@@
ALTER TABLE i18n ADD COLUMN lval varchar(64) NOT NULL DEFAULT '';
ALTER TABLE i18n ADD COLUMN is_active int(1) NOT NULL DEFAULT 1;
ALTER TABLE i18n ADD INDEX lookup (ltype, lkey, inlang);
+ALTER TABLE i18n ADD INDEX lookup_a (ltype, lkey, inlang, is_active);