Index: trunk/admin/install/inportal_schema.sql
===================================================================
diff -u -N -r5231 -r5505
--- trunk/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 5231)
+++ trunk/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 5505)
@@ -70,17 +70,21 @@
   KEY l3_Description (l3_Description(5)),
   KEY l4_Description (l4_Description(5)),
   KEY l5_Description (l5_Description(5))
-) 
+)
 
 # --------------------------------------------------------
 
 CREATE TABLE CategoryItems (
-  CategoryId int(11) NOT NULL default '0',
-  ItemResourceId int(11) NOT NULL default '0',
-  PrimaryCat tinyint(4) NOT NULL default '0',
-  KEY CategoryId (CategoryId),
-  KEY ItemResourceId (ItemResourceId),
-  KEY PrimaryCat (PrimaryCat)
+  `CategoryId` int(11) NOT NULL default '0',
+  `ItemResourceId` int(11) NOT NULL default '0',
+  `PrimaryCat` tinyint(4) NOT NULL default '0',
+  `ItemPrefix` varchar(50) NOT NULL default '',
+  `Filename` varchar(255) NOT NULL default '',
+  KEY `CategoryId` (`CategoryId`),
+  KEY `ItemResourceId` (`ItemResourceId`),
+  KEY `PrimaryCat` (`PrimaryCat`),
+  KEY `ItemPrefix` (`ItemPrefix`),
+  KEY `Filename` (`Filename`(4))
 )
 
 # --------------------------------------------------------
