diff options
| author | horus | 2019-04-21 14:16:43 +0200 |
|---|---|---|
| committer | horus | 2019-04-21 14:16:43 +0200 |
| commit | 3f5eaaaaedee0ef41719fa2f6a8e02446484d785 (patch) | |
| tree | 859ed3722f4c0390e068f5fc858019e6ea1bb6a7 /database.go | |
| parent | 07a008424cd432b8e62c396423c7235f8a93c373 (diff) | |
| download | ghrss-3f5eaaaaedee0ef41719fa2f6a8e02446484d785.tar.gz | |
Changes database view.
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, |
