summaryrefslogtreecommitdiff
path: root/util/updates/2022-02-19-vnt-sorttitle.sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/updates/2022-02-19-vnt-sorttitle.sql')
-rw-r--r--util/updates/2022-02-19-vnt-sorttitle.sql2
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;