Changeset 3346 for trunk/bp-core/admin/bp-core-schema.php

Timestamp:

11/03/2010 11:14:43 PM (14 years ago)

Author:

boonebgorges

Message:

Adds meta functions for xprofile field groups, fields, and individual data items. Fixes #671

File:

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

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

@@ -228 +228 @@
                 KEY is_required (is_required)
                ) {$charset_collate};";
-
+        
     $sql[] = "CREATE TABLE {$wpdb->base_prefix}bp_xprofile_data (
                 id bigint(20) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
@@ -239 +239 @@
                ) {$charset_collate};";
 
+    $sql[] = "CREATE TABLE {$wpdb->base_prefix}bp_xprofile_meta (
+                id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
+                object_id bigint(20) NOT NULL,
+                object_type varchar(150) NOT NULL,
+                meta_key varchar(255) DEFAULT NULL,
+                meta_value longtext DEFAULT NULL,
+                KEY object_id (object_id),
+                KEY meta_key (meta_key)
+               ) {$charset_collate};";
+
     dbDelta( $sql );