PHP7 fix

[Pman.Core] / sql / I18n.sql

diff --git a/sql/I18n.sql b/sql/I18n.sql
index 65b1eba..e40f77f 100644 (file)
--- a/sql/I18n.sql
+++ b/sql/I18n.sql
@@ -1,18 +1,17 @@
 
-CREATE TABLE `i18n` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `ltype` varchar(1) NOT NULL DEFAULT '',
-  `lkey` varchar(8) NOT NULL DEFAULT '',
-  `inlang` varchar(8) NOT NULL DEFAULT '',
-  `lval` varchar(64) NOT NULL DEFAULT '',
-  `is_active` int(1) NOT NULL DEFAULT '1',
-  PRIMARY KEY (`id`),
-  KEY `lookup` (`ltype`,`lkey`,`inlang`)
-) ENGINE=InnoDB;
-
 
-ALTER TABLE i18n ADD COLUMN is_active int(1) NOT NULL DEFAULT 1;
+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 '';
+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;
 
-call mysql_change_engine('i18n');
\ No newline at end of file
+ALTER TABLE i18n ADD INDEX lookup (ltype, lkey, inlang);
+ALTER TABLE i18n ADD INDEX lookup_a (ltype, lkey, inlang, is_active);