summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authoryorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b>2008-06-21 12:49:51 +0000
committeryorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b>2008-06-21 12:49:51 +0000
commit43adf6c1681cf62f2cfbfa90d75053a1d7da5d23 (patch)
tree0b663579038bfb1a702d939a4048008e0a0fd17c /util
parent5fae2ac0d0a85712bcf0611c99c5f7cf39421dc5 (diff)
Time and Place categories are now boolean, and small vnpage cleanup
git-svn-id: svn://vndb.org/vndb@32 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
Diffstat (limited to 'util')
-rw-r--r--util/updates/update_1.17.sql7
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);
+