[TikiWiki-commits] [Git][tikiwiki/tiki][tiki-fix-database-update-tiki-comments] [FIX] tiki_comments: optimize database update case of populated tiki_comments table

Alvin Bauma pushed to branch tiki-fix-database-update-tiki-comments at Tiki Wiki CMS Groupware / Tiki


Commits:
8618061e by Sammy Ndabo at 2025-11-16T23:37:00+03:00
[FIX] tiki_comments: optimize database update case of populated tiki_comments table

- - - - -


1 changed file:

- installer/schema/20251104_update_messageid_from_tiki_comments_tiki.sql


Changes:

=====================================
installer/schema/20251104_update_messageid_from_tiki_comments_tiki.sql
=====================================
@@ -1,2 +1,7 @@
-ALTER TABLE `tiki_comments` MODIFY `message_id` TEXT default NULL;
-ALTER TABLE `tiki_comments` MODIFY `in_reply_to` varchar(255) default NULL;
\ No newline at end of file
+ALTER TABLE `tiki_comments`
+    DROP INDEX `threaded`,
+    DROP INDEX `no_repeats`,
+    MODIFY `message_id` TEXT default NULL,
+    MODIFY `in_reply_to` varchar(255) default NULL,
+    ADD UNIQUE KEY `no_repeats` (`parentId`,`userName`(40),`title`(43),`commentDate`,`message_id`(40),`in_reply_to`(40)),
+    ADD KEY `threaded` (`message_id`(89),`in_reply_to`(88),`parentId`);



View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/8618061e6ff2c222577d5884a32aeae4421bffeb

-- 
View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/8618061e6ff2c222577d5884a32aeae4421bffeb
You're receiving this email because of your account on gitlab.com.

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