diff options
Diffstat (limited to 'database.go')
| -rw-r--r-- | database.go | 4 |
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, |
