diff options
Diffstat (limited to 'util/updates/wip-vn-titles.sql')
-rw-r--r-- | util/updates/wip-vn-titles.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/util/updates/wip-vn-titles.sql b/util/updates/wip-vn-titles.sql index b8162ea7..58dd31a2 100644 --- a/util/updates/wip-vn-titles.sql +++ b/util/updates/wip-vn-titles.sql @@ -35,6 +35,8 @@ ALTER TABLE vn RENAME COLUMN title TO old_title; CREATE VIEW vnt AS SELECT v.*, COALESCE(vo.latin, vo.title) AS title, 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; +ALTER TABLE users ADD COLUMN title_langs jsonb, ADD COLUMN alttitle_langs jsonb; + COMMIT; \i sql/func.sql \i sql/editfunc.sql |