+--
+-- VIEW category-view
+--
+DROP VIEW IF EXISTS `category-view`;
+CREATE VIEW `category-view` AS SELECT
+ `post-category`.`uri-id` AS `uri-id`,
+ `post-category`.`uid` AS `uid`,
+ `item-uri`.`uri` AS `uri`,
+ `item-uri`.`guid` AS `guid`,
+ `post-category`.`type` AS `type`,
+ `post-category`.`tid` AS `tid`,
+ `tag`.`name` AS `name`,
+ `tag`.`url` AS `url`
+ FROM `post-category`
+ INNER JOIN `item-uri` ON `item-uri`.id = `post-category`.`uri-id`
+ LEFT JOIN `tag` ON `post-category`.`tid` = `tag`.`id`;
+