summaryrefslogtreecommitdiff
path: root/database.go
diff options
context:
space:
mode:
authorhorus2019-04-21 14:16:43 +0200
committerhorus2019-04-21 14:16:43 +0200
commit3f5eaaaaedee0ef41719fa2f6a8e02446484d785 (patch)
tree859ed3722f4c0390e068f5fc858019e6ea1bb6a7 /database.go
parent07a008424cd432b8e62c396423c7235f8a93c373 (diff)
downloadghrss-3f5eaaaaedee0ef41719fa2f6a8e02446484d785.tar.gz
Changes database view.
Diffstat (limited to 'database.go')
-rw-r--r--database.go4
1 files changed, 2 insertions, 2 deletions
diff --git a/database.go b/database.go
index c6434ff..99fa2a7 100644
--- a/database.go
+++ b/database.go
@@ -54,12 +54,12 @@ CREATE TABLE IF NOT EXISTS entry (
) CHARSET=utf8;
`,
`
- CREATE OR REPLACE VIEW view_entry AS
+ CREATE OR REPLACE VIEW entry_view AS
SELECT
entry.id,
title,
synopsis,
- owner.name,
+ owner.name AS owner,
platform.name AS platform,
platform.url AS platform_url,
CONCAT( platform.url, entry.url) AS url,