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

Timestamp:

03/01/2015 05:22:59 PM (10 years ago)

Author:

johnjamesjacoby

Message:

Notifications: Introduce notification metadata table.

• Bump DB version
• Introduce DB upgrade function & routine for 2.3.0
• Add metadata table to Notifications installation function
• Add metadata CRUD functions to Notifications component

See #6257.

File:

• trunk/src/bp-core/admin/bp-core-admin-schema.php (modified) (1 diff)

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

@@ -113 +113 @@
                 KEY component_action (component_action),
                 KEY useritem (user_id,is_new)
+            ) {$charset_collate};";
+
+    $sql[] = "CREATE TABLE {$bp_prefix}bp_notifications_meta (
+                id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
+                notification_id bigint(20) NOT NULL,
+                meta_key varchar(255) DEFAULT NULL,
+                meta_value longtext DEFAULT NULL,
+                KEY notification_id (notification_id),
+                KEY meta_key (meta_key)
             ) {$charset_collate};";