static function setUpColumns($columns)
{
$columns->userId = User::columns()->id;
$columns->identityId = Identity::columns()->id;
$columns->addedAt = Column::INTEGER + Column::UNSIGNED;
$columns->priority = Column::INTEGER + Column::SIZE_1B;
}
static function setUpColumns($columns)
{
$columns->id = Column::AUTO_ID;
$columns->userId = User::columns()->id;
$columns->created = Column::INTEGER + Column::NOT_NULL;
$columns->title = Column::STRING + Column::NOT_NULL;
$columns->imagesCount = Column::INTEGER + Column::NOT_NULL;
$columns->updated = Column::INTEGER + Column::NOT_NULL;
}
public function getUsersByIdentityId($identityId)
{
$users = User::statement()->innerJoin('? ON ? = ? AND ? = ?', UserIdentity::table(), UserIdentity::columns()->userId, User::columns()->id, UserIdentity::columns()->identityId, $identityId)->query()->fetchAll();
return $users;
}
