From 3f5eaaaaedee0ef41719fa2f6a8e02446484d785 Mon Sep 17 00:00:00 2001 From: horus Date: Sun, 21 Apr 2019 14:16:43 +0200 Subject: Changes database view. --- database.go | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'database.go') 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, -- cgit v1.2.3