Index: trunk/admin/install/inportal_schema.sql =================================================================== diff -u -r3648 -r3869 --- trunk/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 3648) +++ trunk/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 3869) @@ -533,7 +533,9 @@ Description varchar(255) default NULL, FileType int(11) NOT NULL default '0', PRIMARY KEY (FileId), - KEY theme (ThemeId) + KEY theme (ThemeId), + KEY FileName (FileName), + KEY FilePath (FilePath) ) # -------------------------------------------------------- Index: trunk/admin/install/upgrades/inportal_upgrade_v1.1.7.sql =================================================================== diff -u --- trunk/admin/install/upgrades/inportal_upgrade_v1.1.7.sql (revision 0) +++ trunk/admin/install/upgrades/inportal_upgrade_v1.1.7.sql (revision 3869) @@ -0,0 +1,4 @@ +ALTER TABLE ThemeFiles ADD INDEX (FileName); +ALTER TABLE ThemeFiles ADD INDEX (FilePath); + +UPDATE Modules SET Version = '1.1.7' WHERE Name = 'In-Portal'; \ No newline at end of file Index: trunk/admin/install/inportal_data.sql =================================================================== diff -u -r3635 -r3869 --- trunk/admin/install/inportal_data.sql (.../inportal_data.sql) (revision 3635) +++ trunk/admin/install/inportal_data.sql (.../inportal_data.sql) (revision 3869) @@ -224,7 +224,7 @@ INSERT INTO ItemTypes VALUES (1, 'In-Portal', 'c', 'Category', 'Name', 'CreatedById', NULL, NULL, 'la_ItemTab_Categories', 1, 'admin/category/addcategory.php', 'clsCategory', 'Category'); INSERT INTO ItemTypes VALUES (6, 'In-Portal', 'u', 'PortalUser', 'Login', 'PortalUserId', NULL, NULL, '', 0, '', 'clsPortalUser', 'User'); -INSERT INTO Modules (Name, Path, Var, Version, Loaded, LoadOrder, TemplatePath, RootCat, BuildDate) VALUES ('In-Portal', 'kernel/', 'm', '1.1.6', 1, 0, '', 0, '1054738405'); +INSERT INTO Modules (Name, Path, Var, Version, Loaded, LoadOrder, TemplatePath, RootCat, BuildDate) VALUES ('In-Portal', 'kernel/', 'm', '1.1.7', 1, 0, '', 0, '1054738405'); INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('CATEGORY.VIEW', 'lu_PermName_Category.View_desc', 'lu_PermName_Category.View_error', 'In-Portal'); INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('CATEGORY.ADD', 'lu_PermName_Category.Add_desc', 'lu_PermName_Category.Add_error', 'In-Portal');