sql/I18n.sql

diff --git a/sql/I18n.sql b/sql/I18n.sql
index 35414c3..5632736 100644 (file)
--- a/sql/I18n.sql
+++ b/sql/I18n.sql
@@ -1,2 +1,15 @@
 
+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;
+