Index: branches/unlabeled/unlabeled-1.61.2/admin/install/inportal_schema.sql =================================================================== diff -u -r5634 -r6015 --- branches/unlabeled/unlabeled-1.61.2/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 5634) +++ branches/unlabeled/unlabeled-1.61.2/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 6015) @@ -55,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), @@ -85,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))