diff options
Diffstat (limited to 'util/updates/update_1.17.sql')
-rw-r--r-- | util/updates/update_1.17.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/util/updates/update_1.17.sql b/util/updates/update_1.17.sql index bba26069..c38d2e65 100644 --- a/util/updates/update_1.17.sql +++ b/util/updates/update_1.17.sql @@ -8,3 +8,10 @@ ALTER TABLE vn_rev DROP COLUMN l_cisv; ALTER TABLE vn_rev ADD COLUMN l_encubed varchar(100) NOT NULL DEFAULT ''; ALTER TABLE vn_rev ADD COLUMN l_renai varchar(100) NOT NULL DEFAULT ''; + +-- time and place categories have only one level now +UPDATE vn_categories + SET lvl = 1 + WHERE cat IN('tfu', 'tpa', 'tpr', 'lea', 'lfa', 'lsp'); +-- AND vid IN(SELECT latest FROM vn); + |