summaryrefslogtreecommitdiff
path: root/util/updates
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2014-12-02 11:39:35 +0100
committerYorhel <git@yorhel.nl>2014-12-02 11:39:35 +0100
commit65db0718f4a3e42930dbf660068c1c309d47b08a (patch)
tree2a47031435820efa88e9aa5a804c60faf9ce829d /util/updates
parent42e5a4793fc02ef54805ab5706830bbb2e1bd086 (diff)
Completely drop l_vnn column from VN info
Used to link to a visual-novels.net review or something. Links have been hidden and dead since ages. No need to keep the column around.
Diffstat (limited to 'util/updates')
-rw-r--r--util/updates/update_2.24.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/util/updates/update_2.24.sql b/util/updates/update_2.24.sql
index 6bc33313..011588cf 100644
--- a/util/updates/update_2.24.sql
+++ b/util/updates/update_2.24.sql
@@ -8,3 +8,7 @@ UPDATE sessions SET token = digest(token, 'sha1');
-- No more 'charedit' permission flag
UPDATE users SET perm = (perm & ~8);
+
+
+-- Completely remove l_vnn column
+ALTER TABLE vn_rev DROP COLUMN l_vnn;