summaryrefslogtreecommitdiff
path: root/database.go
diff options
context:
space:
mode:
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,