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

luci pushed to branch master at Tiki Wiki CMS Groupware / Tiki


Commits:
5d698f18 by MAGENE Sem Joel at 2026-08-20T11:47:22+00:00
[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

- - - - -


2 changed files:

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


Changes:

=====================================
db/tiki.sql
=====================================
@@ -3129,7 +3129,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/5d698f1821b4f3de9acd7dbd41353b6e4e3301d8

-- 
View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/5d698f1821b4f3de9acd7dbd41353b6e4e3301d8
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