Changeset 9695 for trunk/src/bp-core/admin/bp-core-admin-schema.php

Timestamp:

04/04/2015 06:40:21 PM (10 years ago)

Author:

johnjamesjacoby

Message:

Core: Add max index length to meta_key indices for new installations.

• More to do regarding database upgrade paths later
• Fixes notices while running phpunit tests

See #6346.

File:

• trunk/src/bp-core/admin/bp-core-admin-schema.php (modified) (6 diffs)

trunk/src/bp-core/admin/bp-core-admin-schema.php

@@ -121 +121 @@
                 meta_value longtext DEFAULT NULL,
                 KEY notification_id (notification_id),
-                KEY meta_key (meta_key)
+                KEY meta_key (meta_key(191))
             ) {$charset_collate};";
 
@@ -174 +174 @@
                 meta_value longtext DEFAULT NULL,
                 KEY activity_id (activity_id),
-                KEY meta_key (meta_key)
+                KEY meta_key (meta_key(191))
             ) {$charset_collate};";
 
@@ -262 +262 @@
                 meta_value longtext DEFAULT NULL,
                 KEY group_id (group_id),
-                KEY meta_key (meta_key)
+                KEY meta_key (meta_key(191))
             ) {$charset_collate};";
 
@@ -322 +322 @@
                 meta_value longtext DEFAULT NULL,
                 KEY message_id (message_id),
-                KEY meta_key (meta_key)
+                KEY meta_key (meta_key(191))
             ) {$charset_collate};";
 
@@ -399 +399 @@
                 meta_value longtext DEFAULT NULL,
                 KEY object_id (object_id),
-                KEY meta_key (meta_key)
+                KEY meta_key (meta_key(191))
             ) {$charset_collate};";
 
@@ -446 +446 @@
                 meta_value longtext DEFAULT NULL,
                 KEY blog_id (blog_id),
-                KEY meta_key (meta_key)
+                KEY meta_key (meta_key(191))
             ) {$charset_collate};";