+--
+-- VIEW collection-view
+--
+DROP VIEW IF EXISTS `collection-view`;
+CREATE VIEW `collection-view` AS SELECT
+ `post-collection`.`uri-id` AS `uri-id`,
+ `post-collection`.`type` AS `type`,
+ `post`.`author-id` AS `cid`,
+ `post`.`received` AS `received`,
+ `post`.`created` AS `created`
+ FROM `post-collection`
+ INNER JOIN `post` ON `post-collection`.`uri-id` = `post`.`uri-id`;
+