projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
a7d65bd
)
sql/I18n.sql
author
john
<john@roojs.com>
Tue, 24 Oct 2017 02:56:53 +0000
(10:56 +0800)
committer
john
<john@roojs.com>
Tue, 24 Oct 2017 02:56:53 +0000
(10:56 +0800)
sql/I18n.sql
patch
|
blob
|
history
diff --git
a/sql/I18n.sql
b/sql/I18n.sql
index
4214172
..
e40f77f
100644
(file)
--- 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)
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 '';
) 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 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);
ALTER TABLE i18n ADD INDEX lookup (ltype, lkey, inlang);
ALTER TABLE i18n ADD INDEX lookup_a (ltype, lkey, inlang, is_active);