3 * @copyright Copyright (C) 2020, Friendica
5 * @license GNU AGPL version 3 or any later version
7 * This program is free software: you can redistribute it and/or modify
8 * it under the terms of the GNU Affero General Public License as
9 * published by the Free Software Foundation, either version 3 of the
10 * License, or (at your option) any later version.
12 * This program is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU Affero General Public License for more details.
17 * You should have received a copy of the GNU Affero General Public License
18 * along with this program. If not, see <https://www.gnu.org/licenses/>.
20 * Main view structure configuration file.
22 * Here are described all the view Friendica needs to work.
24 * Syntax (braces indicate optionale values):
27 * "<field name>" => "`table`.`field`",
28 * "<field name>" => "`other-table`.`field`",
29 * "<field name>" => "SQL expression",
32 * "query" => "FROM `table` INNER JOIN `other-table` ..."
36 * If you need to make any change, make sure to increment the DB_UPDATE_VERSION constant value in dbstructure.config.php.
42 "fields" => ["uri-id" => "`post-tag`.`uri-id`",
43 "uri" => "`item-uri`.`uri`",
44 "guid" => "`item-uri`.`guid`",
45 "type" => "`post-tag`.`type`",
46 "tid" => "`post-tag`.`tid`",
47 "cid" => "`post-tag`.`cid`",
48 "name" => "CASE `cid` WHEN 0 THEN `tag`.`name` ELSE `contact`.`name` END",
49 "url" => "CASE `cid` WHEN 0 THEN `tag`.`url` ELSE `contact`.`url` END"],
50 "query" => "FROM `post-tag`
51 INNER JOIN `item-uri` ON `item-uri`.id = `post-tag`.`uri-id`
52 LEFT JOIN `tag` ON `post-tag`.`tid` = `tag`.`id`
53 LEFT JOIN `contact` ON `post-tag`.`cid` = `contact`.`id`"