Index: trunk/admin/install/upgrades/inportal_upgrade_v1.1.9.sql =================================================================== diff -u -r4330 -r4603 --- trunk/admin/install/upgrades/inportal_upgrade_v1.1.9.sql (.../inportal_upgrade_v1.1.9.sql) (revision 4330) +++ trunk/admin/install/upgrades/inportal_upgrade_v1.1.9.sql (.../inportal_upgrade_v1.1.9.sql) (revision 4603) @@ -1,4 +1,7 @@ INSERT INTO Events (Event, Enabled, FromUserId, Module, Description, Type) VALUES ('COMMON.FOOTER', 1, 0, 'In-Portal', 'la_event_common.footer', 1); ALTER TABLE CustomField ADD IsSystem TINYINT UNSIGNED NOT NULL; +ALTER TABLE CategoryCustomData ADD INDEX (ResourceId); +ALTER TABLE PortalUserCustomData ADD INDEX (ResourceId); + UPDATE Modules SET Version = '1.1.9' WHERE Name = 'In-Portal'; \ No newline at end of file