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

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


Commits:
b7fe3a96 by MAGENE Sem Joel at 2026-08-20T18:06:54+00:00
[BP][FIX][DB][ENH] Score: add missing indexes to object score history
---
* [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

(cherry picked from commit 7a206d7e8563442a9fca948aa5fcb0dc2f40d355)

See merge request tikiwiki/tiki!11021

- - - - -


2 changed files:

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


Changes:

=====================================
db/tiki.sql
=====================================
@@ -3132,7 +3132,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/b7fe3a9600615a8569c0384adc2363d773ea62df

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