[TikiWiki-commits] [Git][tikiwiki/tiki][tiki-fix-warnings] [FIX] tiki-check.php: getDbKeyDefinitions() updated to original format

Sammy Ndabo pushed to branch tiki-fix-warnings at Tiki Wiki CMS Groupware / Tiki


Commits:
850954bb by Sammy Ndabo at 2025-11-10T18:03:38+03:00
[FIX] tiki-check.php: getDbKeyDefinitions() updated to original format

- - - - -


1 changed file:

- tiki-check.php


Changes:

=====================================
tiki-check.php
=====================================
@@ -3856,17 +3856,17 @@ function check_db_mismatches()
 function getDbKeyDefinitions($tableName)
 {
     $query = <<<SQL
-    SELECT
-        INDEX_NAME,
+    SELECT 
+        INDEX_NAME, 
         TABLE_NAME,
         GROUP_CONCAT(COLUMN_NAME ORDER BY SEQ_IN_INDEX) AS INDEX_COLUMNS,
-    CASE
+    CASE 
         WHEN NON_UNIQUE = 0 AND INDEX_NAME = 'PRIMARY'
-            THEN 'PRIMARY'
+            THEN 'PRIMARY' 
         WHEN NON_UNIQUE = 0
             THEN 'UNIQUE'
-        ELSE 'INDEX'
-    END AS INDEX_TYPE
+        ELSE 'INDEX' 
+    END AS INDEX_TYPE 
     FROM information_schema.statistics
     WHERE TABLE_SCHEMA = database() AND TABLE_NAME = "$tableName"
     GROUP BY INDEX_NAME, NON_UNIQUE;



View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/850954bbdf6f39eb3a5b39eb37409c34cf91bfad

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