projects
/
Pman.Core
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
sql/I18n.sql
[Pman.Core]
/
sql
/
I18n.sql
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 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);