[TikiWiki-commits] [Git][tikiwiki/tiki][tiki-fix-database-update-tiki-comments] [FIX] tiki_comments: change UNIQUE key to regular key for no_repeats index

Sammy Ndabo pushed to branch tiki-fix-database-update-tiki-comments at Tiki Wiki CMS Groupware / Tiki


Commits:
bdc4f525 by Sammy Ndabo at 2026-02-02T16:58:29+02:00
[FIX] tiki_comments: change UNIQUE key to regular key for no_repeats index

- - - - -


1 changed file:

- installer/schema/20251104_update_messageid_from_tiki_comments_tiki.sql


Changes:

=====================================
installer/schema/20251104_update_messageid_from_tiki_comments_tiki.sql
=====================================
@@ -3,5 +3,5 @@ ALTER TABLE `tiki_comments`
     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 `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/bdc4f525cba92d712230e65c920e9a2a642456b7

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