*/
return [
+ "application-view" => [
+ "fields" => [
+ "id" => ["application", "id"],
+ "uid" => ["application-token", "uid"],
+ "name" => ["application", "name"],
+ "redirect_uri" => ["application", "redirect_uri"],
+ "website" => ["application", "website"],
+ "client_id" => ["application", "client_id"],
+ "client_secret" => ["application", "client_secret"],
+ "code" => ["application-token", "code"],
+ "access_token" => ["application-token", "access_token"],
+ "created_at" => ["application-token", "created_at"],
+ "scopes" => ["application-token", "scopes"],
+ "read" => ["application-token", "read"],
+ "write" => ["application-token", "write"],
+ "follow" => ["application-token", "follow"],
+ "push" => ["application-token", "push"],
+ ],
+ "query" => "FROM `application-token`
+ INNER JOIN `application` ON `application-token`.`application-id` = `application`.`id`"
+ ],
"post-user-view" => [
"fields" => [
"id" => ["post-user", "id"],
"parent-author-link" => ["parent-post-author", "url"],
"parent-author-name" => ["parent-post-author", "name"],
"parent-author-network" => ["parent-post-author", "network"],
+ "parent-author-blocked" => ["parent-post-author", "blocked"],
+ "parent-author-hidden" => ["parent-post-author", "hidden"],
],
"query" => "FROM `post-user`
STRAIGHT_JOIN `post-thread-user` ON `post-thread-user`.`uri-id` = `post-user`.`parent-uri-id` AND `post-thread-user`.`uid` = `post-user`.`uid`