diff options
author | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-06-21 12:49:51 +0000 |
---|---|---|
committer | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-06-21 12:49:51 +0000 |
commit | 43adf6c1681cf62f2cfbfa90d75053a1d7da5d23 (patch) | |
tree | 0b663579038bfb1a702d939a4048008e0a0fd17c /util | |
parent | 5fae2ac0d0a85712bcf0611c99c5f7cf39421dc5 (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.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); + |