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>" => "SQL expression",
31 * "query" => "FROM `table` INNER JOIN `other-table` ..."
35 * If you need to make any change, make sure to increment the DB_UPDATE_VERSION constant value in dbstructure.config.php.
42 "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",
51 "query" => "FROM `post-tag`
52 INNER JOIN `item-uri` ON `item-uri`.id = `post-tag`.`uri-id`
53 LEFT JOIN `tag` ON `post-tag`.`tid` = `tag`.`id`
54 LEFT JOIN `contact` ON `post-tag`.`cid` = `contact`.`id`"