public $group_id; // int(4) primary_key not_null
public $profile_id; // int(4) primary_key not_null
public $is_admin; // tinyint(1)
- public $uri; // varchar(255)
+ public $uri; // varchar(191) not 255 because utf8mb4 takes more space
public $created; // datetime() not_null
public $modified; // timestamp() not_null default_CURRENT_TIMESTAMP
'group_id' => array('type' => 'int', 'not null' => true, 'description' => 'foreign key to user_group'),
'profile_id' => array('type' => 'int', 'not null' => true, 'description' => 'foreign key to profile table'),
'is_admin' => array('type' => 'int', 'size' => 'tiny', 'default' => 0, 'description' => 'is this user an admin?'),
- 'uri' => array('type' => 'varchar', 'length' => 255, 'description' => 'universal identifier'),
+ 'uri' => array('type' => 'varchar', 'length' => 191, 'description' => 'universal identifier'),
'created' => array('type' => 'datetime', 'not null' => true, 'description' => 'date this record was created'),
'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'),
),
$member->group_id = $group_id;
$member->profile_id = $profile_id;
$member->created = common_sql_now();
- $member->uri = self::newURI($profile_id, $group_id, $member->created);
+ $member->uri = self::newUri(Profile::getByID($profile_id),
+ User_group::getByID($group_id),
+ $member->created);
$result = $member->insert();
$act = new Activity();
- $act->id = $this->getURI();
+ $act->id = $this->getUri();
$act->actor = $member->asActivityObject();
$act->verb = ActivityVerb::JOIN;
mail_notify_group_join($this->getGroup(), $this->getMember());
}
- function getURI()
+ function getUri()
{
- if (!empty($this->uri)) {
- return $this->uri;
- } else {
- return self::newURI($this->profile_id, $this->group_id, $this->created);
- }
- }
-
- static function newURI($profile_id, $group_id, $created)
- {
- return TagURI::mint('join:%d:%d:%s',
- $profile_id,
- $group_id,
- common_date_iso8601($created));
+ return $this->uri ?: self::newUri($this->getMember(), $this->getGroup()->getProfile(), $this->created);
}
}