diff options
Diffstat (limited to 'util/updates/2022-02-19-vnt-sorttitle.sql')
-rw-r--r-- | util/updates/2022-02-19-vnt-sorttitle.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/util/updates/2022-02-19-vnt-sorttitle.sql b/util/updates/2022-02-19-vnt-sorttitle.sql new file mode 100644 index 00000000..ea075343 --- /dev/null +++ b/util/updates/2022-02-19-vnt-sorttitle.sql @@ -0,0 +1,2 @@ +DROP VIEW vnt; +CREATE VIEW vnt AS SELECT v.*, COALESCE(vo.latin, vo.title) AS title, COALESCE(vo.latin, vo.title) AS sorttitle, CASE WHEN vo.latin IS NULL THEN '' ELSE vo.title END AS alttitle FROM vn v JOIN vn_titles vo ON vo.id = v.id AND vo.lang = v.olang; |