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

Timestamp:

10/24/2011 02:00:04 PM (14 years ago)

Author:

djpaul

Message:

First pass of Akismet support for the Activity component. See #3660

File:

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

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

@@ -49 +49 @@
 
     $sql[] = "CREATE TABLE {$bp_prefix}bp_activity (
-                id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
+                id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                 user_id bigint(20) NOT NULL,
                 component varchar(75) NOT NULL,
@@ -62 +62 @@
                 mptt_left int(11) NOT NULL DEFAULT 0,
                 mptt_right int(11) NOT NULL DEFAULT 0,
+                is_spam tinyint(1) NOT NULL DEFAULT 0,
                 KEY date_recorded (date_recorded),
                 KEY user_id (user_id),
@@ -70 +71 @@
                 KEY mptt_left (mptt_left),
                 KEY mptt_right (mptt_right),
-                KEY hide_sitewide (hide_sitewide)
-               ) {$charset_collate};";
+                KEY hide_sitewide (hide_sitewide),
+                KEY is_spam (is_spam)
+            ) {$charset_collate};";
 
     $sql[] = "CREATE TABLE {$bp_prefix}bp_activity_meta (