From 8900e404e79b68e0a21767edb92bcf83848c3509 Mon Sep 17 00:00:00 2001 From: john Date: Tue, 24 Oct 2017 10:56:53 +0800 Subject: [PATCH] sql/I18n.sql --- sql/I18n.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/sql/I18n.sql b/sql/I18n.sql index 4214172b..e40f77fd 100644 --- a/sql/I18n.sql +++ b/sql/I18n.sql @@ -3,7 +3,7 @@ CREATE TABLE i18n ( id int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) - + ) ENGINE=InnoDB; ALTER TABLE i18n ADD COLUMN ltype varchar(1) NOT NULL DEFAULT ''; @@ -11,6 +11,7 @@ ALTER TABLE i18n ADD COLUMN lkey varchar(8) NOT NULL DEFAULT ''; ALTER TABLE i18n ADD COLUMN inlang varchar(8) NOT NULL DEFAULT ''; 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 COLUMN is_prefer int(2) NOT NULL DEFAULT 0; + ALTER TABLE i18n ADD INDEX lookup (ltype, lkey, inlang); ALTER TABLE i18n ADD INDEX lookup_a (ltype, lkey, inlang, is_active); -- 2.39.2