X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=classes%2FGroup_inbox.php;h=274f2b8f40fc1123770beab1e9503b76fd679e47;hb=746e658f3e398948fe8c3f047e2b35ef6aa7ebd5;hp=2a0787e387dc8ea087060dfc447cf661121d0e74;hpb=4e2acd153b4e3208e24464478098fac458a13590;p=quix0rs-gnu-social.git diff --git a/classes/Group_inbox.php b/classes/Group_inbox.php index 2a0787e387..274f2b8f40 100644 --- a/classes/Group_inbox.php +++ b/classes/Group_inbox.php @@ -1,9 +1,9 @@ 'Many-many table listing notices posted to a given group, or which groups a given notice was posted to.', + 'fields' => array( + 'group_id' => array('type' => 'int', 'not null' => true, 'description' => 'group receiving the message'), + 'notice_id' => array('type' => 'int', 'not null' => true, 'description' => 'notice received'), + 'created' => array('type' => 'datetime', 'not null' => true, 'description' => 'date the notice was created'), + ), + 'primary key' => array('group_id', 'notice_id'), + 'foreign keys' => array( + 'group_inbox_group_id_fkey' => array('user_group', array('group_id' => 'id')), + 'group_inbox_notice_id_fkey' => array('notice', array('notice_id' => 'id')), + ), + 'indexes' => array( + 'group_inbox_created_idx' => array('created'), + 'group_inbox_notice_id_idx' => array('notice_id'), + 'group_inbox_group_id_created_notice_id_idx' => array('group_id', 'created', 'notice_id'), + ), + ); } }