"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`"
"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`
"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-thread-user`
INNER JOIN `post-user` ON `post-user`.`id` = `post-thread-user`.`post-user-id`
"target-type" => ["post-content", "target-type"],
"target" => ["post-content", "target"],
"resource-id" => ["post-content", "resource-id"],
+ "contact-id" => ["post", "author-id"],
+ "contact-link" => ["author", "url"],
+ "contact-addr" => ["author", "addr"],
+ "contact-name" => ["author", "name"],
+ "contact-nick" => ["author", "nick"],
+ "contact-avatar" => ["author", "thumb"],
+ "contact-network" => ["author", "network"],
+ "contact-blocked" => ["author", "blocked"],
+ "contact-hidden" => ["author", "hidden"],
+ "contact-readonly" => ["author", "readonly"],
+ "contact-archive" => ["author", "archive"],
+ "contact-pending" => ["author", "pending"],
+ "contact-rel" => ["author", "rel"],
+ "contact-uid" => ["author", "uid"],
+ "contact-contact-type" => ["author", "contact-type"],
+ "writable" => "IF (`post`.`network` IN ('apub', 'dfrn', 'dspr', 'stat'), true, `author`.`writable`)",
+ "self" => "false",
+ "cid" => ["author", "id"],
+ "alias" => ["author", "alias"],
+ "photo" => ["author", "photo"],
+ "name-date" => ["author", "name-date"],
+ "uri-date" => ["author", "uri-date"],
+ "avatar-date" => ["author", "avatar-date"],
+ "thumb" => ["author", "thumb"],
+ "dfrn-id" => ["author", "dfrn-id"],
"author-id" => ["post", "author-id"],
"author-link" => ["author", "url"],
"author-addr" => ["author", "addr"],
"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`
STRAIGHT_JOIN `post-thread` ON `post-thread`.`uri-id` = `post`.`parent-uri-id`
"target-type" => ["post-content", "target-type"],
"target" => ["post-content", "target"],
"resource-id" => ["post-content", "resource-id"],
+ "contact-id" => ["post-thread", "author-id"],
+ "contact-link" => ["author", "url"],
+ "contact-addr" => ["author", "addr"],
+ "contact-name" => ["author", "name"],
+ "contact-nick" => ["author", "nick"],
+ "contact-avatar" => ["author", "thumb"],
+ "contact-network" => ["author", "network"],
+ "contact-blocked" => ["author", "blocked"],
+ "contact-hidden" => ["author", "hidden"],
+ "contact-readonly" => ["author", "readonly"],
+ "contact-archive" => ["author", "archive"],
+ "contact-pending" => ["author", "pending"],
+ "contact-rel" => ["author", "rel"],
+ "contact-uid" => ["author", "uid"],
+ "contact-contact-type" => ["author", "contact-type"],
+ "writable" => "IF (`post`.`network` IN ('apub', 'dfrn', 'dspr', 'stat'), true, `author`.`writable`)",
+ "self" => "false",
+ "cid" => ["author", "id"],
+ "alias" => ["author", "alias"],
+ "photo" => ["author", "photo"],
+ "name-date" => ["author", "name-date"],
+ "uri-date" => ["author", "uri-date"],
+ "avatar-date" => ["author", "avatar-date"],
+ "thumb" => ["author", "thumb"],
+ "dfrn-id" => ["author", "dfrn-id"],
"author-id" => ["post-thread", "author-id"],
"author-link" => ["author", "url"],
"author-addr" => ["author", "addr"],
"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-thread`
INNER JOIN `post` ON `post`.`uri-id` = `post-thread`.`uri-id`
"photo" => ["contact", "photo"],
"thumb" => ["contact", "thumb"],
"micro" => ["contact", "micro"],
+ "header" => ["contact", "header"],
"site-pubkey" => ["contact", "site-pubkey"],
"issued-id" => ["contact", "issued-id"],
"dfrn-id" => ["contact", "dfrn-id"],