12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758 |
- <?php
- defined('GNUSOCIAL') || die();
- class Group_inbox extends Managed_DataObject
- {
-
-
- public $__table = 'group_inbox';
- public $group_id;
- public $notice_id;
- public $created;
-
-
- public static function schemaDef()
- {
- return array(
- 'description' => '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', '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'),
- ),
- );
- }
- }
|