Index: branches/unlabeled/unlabeled-1.63.2/admin/install/inportal_schema.sql
===================================================================
diff -u -r6939 -r6946
--- branches/unlabeled/unlabeled-1.63.2/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 6939)
+++ branches/unlabeled/unlabeled-1.63.2/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 6946)
@@ -13,84 +13,6 @@
 
 # --------------------------------------------------------
 
-CREATE TABLE Category (
-  CategoryId int(11) NOT NULL auto_increment,
-  `Type` int(11) NOT NULL default '0',
-  ParentId int(11) NOT NULL default '0',
-  Name varchar(255) NOT NULL default '',
-  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',
-  Pop tinyint(4) default NULL,
-  Priority int(11) NOT NULL default '0',
-  MetaKeywords varchar(255) default NULL,
-  CachedDescendantCatsQty int(11) default NULL,
-  CachedNavbar text NOT NULL,
-  l1_CachedNavbar text NOT NULL,
-  l2_CachedNavbar text NOT NULL,
-  l3_CachedNavbar text NOT NULL,
-  l4_CachedNavbar text NOT NULL,
-  l5_CachedNavbar text NOT NULL,
-  CreatedById int(11) NOT NULL default '0',
-  ResourceId int(11) default NULL,
-  ParentPath text NOT NULL,
-  NamedParentPath text NOT NULL,
-  MetaDescription varchar(255) default NULL,
-  HotItem int(11) NOT NULL default '2',
-  NewItem int(11) NOT NULL default '2',
-  PopItem int(11) NOT NULL default '2',
-  Modified int(11) NOT NULL default '0',
-  ModifiedById int(11) NOT NULL default '0',
-  CategoryTemplate varchar(255) NOT NULL default '',
-  CachedCategoryTemplate varchar(255) NOT NULL default '',
-  PRIMARY KEY  (CategoryId),
-  UNIQUE KEY ResourceId (ResourceId),
-  KEY ParentId (ParentId),
-  KEY Modified (Modified),
-  KEY Priority (Priority),
-  KEY sorting (Name,Priority),
-  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))
-)
-
-# --------------------------------------------------------
-
-CREATE TABLE CategoryItems (
-  `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 '',
-  UNIQUE KEY `CategoryId` (`CategoryId`,`ItemResourceId`),
-  KEY `PrimaryCat` (`PrimaryCat`),
-  KEY `ItemPrefix` (`ItemPrefix`),
-  KEY `Filename` (`Filename`(4))
-)
-
-# --------------------------------------------------------
-
 CREATE TABLE CountCache (
   ListType int(11) NOT NULL default '0',
   ItemType int(11) NOT NULL default '-1',