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

Timestamp:

09/13/2016 06:21:10 PM (8 years ago)

Author:

dcavins

Message:

Add query support for hierarchical groups.

Adds a new column to the groups table, parent_id, and support for
querying by parent_id via groups_get_groups() and
bp_has_groups().

Does not add any front-facing hierarchy functionality—that is left for
now to plugins.

Props dcavins, boonebgorges, r-a-y, djpaul, mercime.

See #3961.

File:

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

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

@@ -203 +203 @@
                 description longtext NOT NULL,
                 status varchar(10) NOT NULL DEFAULT 'public',
+                parent_id bigint(20) NOT NULL DEFAULT 0,
                 enable_forum tinyint(1) NOT NULL DEFAULT '1',
                 date_created datetime NOT NULL,
                 KEY creator_id (creator_id),
-                KEY status (status)
+                KEY status (status),
+                KEY parent_id (parent_id)
             ) {$charset_collate};";