Changeset 13907

Timestamp:

06/06/2024 08:36:00 PM (20 months ago)

Author:

imath

Message:

Make sure BuddyPress can be previewed using WP Playground

Props espellcaste

Fixes #9126
Closes ​https://github.com/buddypress/buddypress/pull/287

Location:

trunk

Files:

• blueprint.json (added)
• src/bp-core/admin/bp-core-admin-schema.php (modified) (3 diffs)
• src/bp-core/bp-core-update.php (modified) (2 diffs)
• src/class-buddypress.php (modified) (1 diff)

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

@@ -92 +92 @@
                 component_action varchar(75) NOT NULL,
                 date_notified datetime NOT NULL,
-                is_new bool NOT NULL DEFAULT 0,
+                is_new tinyint(1) NOT NULL DEFAULT 0,
                 KEY item_id (item_id),
                 KEY secondary_item_id (secondary_item_id),
@@ -135 +135 @@
                 secondary_item_id bigint(20) DEFAULT NULL,
                 date_recorded datetime NOT NULL,
-                hide_sitewide bool DEFAULT 0,
+                hide_sitewide tinyint(1) DEFAULT 0,
                 mptt_left int(11) NOT NULL DEFAULT 0,
                 mptt_right int(11) NOT NULL DEFAULT 0,
@@ -177 +177 @@
                 initiator_user_id bigint(20) NOT NULL,
                 friend_user_id bigint(20) NOT NULL,
-                is_confirmed bool DEFAULT 0,
-                is_limited bool DEFAULT 0,
+                is_confirmed tinyint(1) DEFAULT 0,
+                is_limited tinyint(1) DEFAULT 0,
                 date_created datetime NOT NULL,
                 KEY initiator_user_id (initiator_user_id),

trunk/src/bp-core/bp-core-update.php

@@ -314 +314 @@
         if ( $raw_db_version < 13422 ) {
             bp_update_to_12_0();
+        }
+
+        // Version 14.0.0.
+        if ( $raw_db_version < 13906 ) {
+            bp_update_to_14_0();
         }
     }
@@ -939 +944 @@
 
 /**
+ * 14.0.0 update routine.
+ *
+ * Edit db schema to stop using boolean fields in favor of tinyint ones.
+ * This moves was necessary to support WP Playground.
+ *
+ * @since 14.0.0
+ */
+function bp_update_to_14_0() {
+    global $wpdb;
+    $bp        = buddypress();
+    $bp_prefix = bp_core_get_table_prefix();
+
+    if ( isset( $bp->members->table_name_last_activity ) && $wpdb->get_var( "SHOW TABLES LIKE '%{$bp->members->table_name_last_activity}%'" ) ) {
+        if ( $wpdb->get_var( "SHOW COLUMNS FROM {$bp->members->table_name_last_activity} LIKE 'hide_sitewide'" ) ) {
+            $wpdb->query( "ALTER TABLE {$bp->members->table_name_last_activity} CHANGE hide_sitewide hide_sitewide tinyint(1) DEFAULT 0" );
+        }
+    }
+
+    if ( isset( $bp->friends->table_name ) && $wpdb->get_var( "SHOW TABLES LIKE '%{$bp->friends->table_name}%'" ) ) {
+        if ( $wpdb->get_var( "SHOW COLUMNS FROM {$bp->friends->table_name} LIKE 'is_confirmed'" ) ) {
+            $wpdb->query( "ALTER TABLE {$bp->friends->table_name} CHANGE is_confirmed is_confirmed tinyint(1) DEFAULT 0" );
+        }
+
+        if ( $wpdb->get_var( "SHOW COLUMNS FROM {$bp->friends->table_name} LIKE 'is_limited'" ) ) {
+            $wpdb->query( "ALTER TABLE {$bp->friends->table_name} CHANGE is_limited is_limited tinyint(1) DEFAULT 0" );
+        }
+    }
+
+    if ( isset( $bp->notifications->table_name ) && $wpdb->get_var( "SHOW TABLES LIKE '%{$bp->notifications->table_name}%'" ) ) {
+        if ( $wpdb->get_var( "SHOW COLUMNS FROM {$bp->notifications->table_name} LIKE 'is_new'" ) ) {
+            $wpdb->query( "ALTER TABLE {$bp->notifications->table_name} CHANGE is_new is_new tinyint(1) NOT NULL DEFAULT 0" );
+        }
+    }
+}
+
+/**
  * Updates the component field for new_members type.
  *

trunk/src/class-buddypress.php

@@ -462 +462 @@
 
         $this->version    = '14.0.0-alpha';
-        $this->db_version = 13422;
+        $this->db_version = 13906;
 
         /** Loading */