Index: trunk/admin/install/inportal_schema.sql =================================================================== diff -u -N -r5505 -r6093 --- trunk/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 5505) +++ trunk/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 6093) @@ -39,6 +39,11 @@ 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, @@ -50,9 +55,7 @@ Modified int(11) NOT NULL default '0', ModifiedById int(11) NOT NULL default '0', CategoryTemplate varchar(255) NOT NULL default '', - ItemTemplate varchar(255) NOT NULL default '', CachedCategoryTemplate varchar(255) NOT NULL default '', - CachedItemTemplate varchar(255) NOT NULL default '', PRIMARY KEY (CategoryId), UNIQUE KEY ResourceId (ResourceId), KEY ParentId (ParentId), @@ -80,8 +83,7 @@ `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`), + UNIQUE KEY `CategoryId` (`CategoryId`,`ItemResourceId`), KEY `PrimaryCat` (`PrimaryCat`), KEY `ItemPrefix` (`ItemPrefix`), KEY `Filename` (`Filename`(4))