Index: trunk/admin/install/inportal_schema.sql
===================================================================
diff -u -r5110 -r5185
--- trunk/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 5110)
+++ trunk/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 5185)
@@ -15,15 +15,25 @@
 
 CREATE TABLE Category (
   CategoryId int(11) NOT NULL auto_increment,
-  Type int(11) NOT NULL default '0',
+  `Type` int(11) NOT NULL default '0',
   ParentId int(11) NOT NULL default '0',
   Name varchar(255) NOT NULL default '',
-  Filename varchar(255) NOT NULL,
+  l1_Name varchar(255) NOT NULL default '',
+  l2_Name varchar(255) NOT NULL default '',
+  l3_Name varchar(255) NOT NULL default '',
+  l4_Name varchar(255) NOT NULL default '',
+  l5_Name varchar(255) NOT NULL default '',
+  Filename varchar(255) NOT NULL default '',
   AutomaticFilename tinyint(3) unsigned NOT NULL default '1',
   Description text NOT NULL,
+  l1_Description text NOT NULL,
+  l2_Description text NOT NULL,
+  l3_Description text NOT NULL,
+  l4_Description text NOT NULL,
+  l5_Description text NOT NULL,
   CreatedOn int(11) NOT NULL default '0',
   EditorsPick tinyint(4) NOT NULL default '0',
-  Status tinyint(4) NOT NULL default '0',
+  `Status` tinyint(4) NOT NULL default '0',
   Pop tinyint(4) default NULL,
   Priority int(11) NOT NULL default '0',
   MetaKeywords varchar(255) default NULL,
@@ -44,13 +54,23 @@
   CachedCategoryTemplate varchar(255) NOT NULL default '',
   CachedItemTemplate varchar(255) NOT NULL default '',
   PRIMARY KEY  (CategoryId),
-  KEY ParentId (ParentId),
   UNIQUE KEY ResourceId (ResourceId),
+  KEY ParentId (ParentId),
   KEY Modified (Modified),
   KEY Priority (Priority),
   KEY sorting (Name,Priority),
-  KEY Filename (Filename(5))
-)
+  KEY Filename (Filename(5)),
+  KEY l1_Name (l1_Name(5)),
+  KEY l2_Name (l2_Name(5)),
+  KEY l3_Name (l3_Name(5)),
+  KEY l4_Name (l4_Name(5)),
+  KEY l5_Name (l5_Name(5)),
+  KEY l1_Description (l1_Description(5)),
+  KEY l2_Description (l2_Description(5)),
+  KEY l3_Description (l3_Description(5)),
+  KEY l4_Description (l4_Description(5)),
+  KEY l5_Description (l5_Description(5))
+) 
 
 # --------------------------------------------------------
 
