[TikiWiki-commits] [Git][tikiwiki/tiki][30.x] [BP][FIX][DB][ENH] Score: add missing indexes to object score history

MAGENE Sem Joel pushed to branch 30.x at Tiki Wiki CMS Groupware / Tiki


Commits:
7a206d7e by MAGENE Sem Joel at 2026-08-20T17:44:16+00:00
[BP][FIX][DB][ENH] Score: add missing indexes to object score history
---
* [FIX][DB][ENH] Score: add missing indexes to object score history
---
* [FIX][DB][ENH] Score: add missing indexes to object score history

See merge request tikiwiki/tiki!11010

(cherry picked from commit 5d698f1821b4f3de9acd7dbd41353b6e4e3301d8)

See merge request tikiwiki/tiki!11020

- - - - -


2 changed files:

- db/tiki.sql
- + installer/schema/20260820_add_tiki_object_scores_indexes_tiki.sql


Changes:

=====================================
db/tiki.sql
=====================================
@@ -3146,7 +3146,11 @@ CREATE TABLE `tiki_object_scores` (
   `pointsAssigned` INT NOT NULL,
   `pointsBalance` INT NOT NULL,
   `date` INT NOT NULL,
-  `reversalOf` INT UNSIGNED
+  `reversalOf` INT UNSIGNED,
+  KEY `recipient_latest` (`recipientObjectType`(32), `recipientObjectId`(191), `id`),
+  KEY `recipient_rule` (`recipientObjectType`(32), `recipientObjectId`(128), `ruleId`(80)),
+  KEY `trigger_event` (`triggerObjectType`(32), `triggerObjectId`(64), `triggerUser`(64), `triggerEvent`(64), `id`),
+  KEY `trigger_rule` (`triggerObjectType`(24), `triggerObjectId`(64), `ruleId`(48), `recipientObjectType`(24), `recipientObjectId`(64), `reversalOf`, `id`)
 ) ENGINE=MyISAM;
 
 DROP TABLE IF EXISTS `tiki_file_handlers`;


=====================================
installer/schema/20260820_add_tiki_object_scores_indexes_tiki.sql
=====================================
@@ -0,0 +1,5 @@
+ALTER TABLE `tiki_object_scores`
+  ADD KEY `recipient_latest` (`recipientObjectType`(32), `recipientObjectId`(191), `id`),
+  ADD KEY `recipient_rule` (`recipientObjectType`(32), `recipientObjectId`(128), `ruleId`(80)),
+  ADD KEY `trigger_event` (`triggerObjectType`(32), `triggerObjectId`(64), `triggerUser`(64), `triggerEvent`(64), `id`),
+  ADD KEY `trigger_rule` (`triggerObjectType`(24), `triggerObjectId`(64), `ruleId`(48), `recipientObjectType`(24), `recipientObjectId`(64), `reversalOf`, `id`);



View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/7a206d7e8563442a9fca948aa5fcb0dc2f40d355

-- 
View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/7a206d7e8563442a9fca948aa5fcb0dc2f40d355
You're receiving this email because of your account on gitlab.com. Manage all notifications: https://gitlab.com/-/profile/notifications | Help: https://gitlab.com/help

_______________________________________________
TikiWiki-cvs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-cvs