[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:
6498559d by Sammy Ndabo at 2026-02-02T20:22:03+02:00
[FIX] tiki_comments: change UNIQUE key to regular key for no_repeats index

- - - - -


1 changed file:

- db/tiki.sql


Changes:

=====================================
db/tiki.sql
=====================================
@@ -724,7 +724,7 @@ CREATE TABLE `tiki_comments` (
   `approved` char(1) NOT NULL default 'y',
   `locked` char(1) NOT NULL default 'n',
   PRIMARY KEY (`threadId`),
-  UNIQUE KEY `no_repeats` (`parentId`, `userName`(20), `title`(30), `commentDate`, `message_id`(30), `in_reply_to`(30)),
+  KEY `no_repeats` (`parentId`, `userName`(20), `title`(30), `commentDate`, `message_id`(30), `in_reply_to`(30)),
   KEY `title` (`title`(191)),
   KEY `data` (`data`(191)),
   KEY `hits` (hits),
@@ -4321,4 +4321,4 @@ CREATE TABLE `tiki_password_reset_tokens` (
   UNIQUE KEY `token` (`token`),
   KEY `user` (`user`),
   KEY `expires` (`expires`)
-) ENGINE=MyISAM;
\ No newline at end of file
+) ENGINE=MyISAM;



View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/6498559da056136ac7fc80af1ddf9066abfb3817

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