sql/I18n.sql

[Pman.Core] / sql / I18n.sql

diff --git a/sql/I18n.sql b/sql/I18n.sql
index 65b1eba..4214172 100644 (file)
--- a/sql/I18n.sql
+++ b/sql/I18n.sql
@@ -1,18 +1,16 @@
 
-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;
 
+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;
-
-
-
-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);