diff options
| author | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-04-26 09:25:45 +0000 |
|---|---|---|
| committer | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-04-26 09:25:45 +0000 |
| commit | 88853c1168a333c7c7b7951b2931852e6df7da55 (patch) | |
| tree | fbad6f17f0820c89ce5dd8da748cf37b56549d14 /util/updates | |
| parent | d2efb163c11a11e02abd7251fdfde3cb54c710ef (diff) | |
Stupid comments - like I can keep track of everything I change...
git-svn-id: svn://vndb.org/vndb@5 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
Diffstat (limited to 'util/updates')
| -rw-r--r-- | util/updates/update_1.14.pl | 2 | ||||
| -rw-r--r-- | util/updates/update_1.14.sql | 8 |
2 files changed, 9 insertions, 1 deletions
diff --git a/util/updates/update_1.14.pl b/util/updates/update_1.14.pl index 9c4e787d..af9840c5 100644 --- a/util/updates/update_1.14.pl +++ b/util/updates/update_1.14.pl @@ -34,7 +34,7 @@ for (0..49) { # rename relation graphs -system('util/relgraph.pl'); +system('util/multi.pl -c "relgraph all"'); # rename cover images diff --git a/util/updates/update_1.14.sql b/util/updates/update_1.14.sql index 70ae8ef0..77f9ee71 100644 --- a/util/updates/update_1.14.sql +++ b/util/updates/update_1.14.sql @@ -17,6 +17,14 @@ DROP FUNCTION get_new_id(text); +-- remove users.p* columns (Why haven't I done so earlier?) +ALTER TABLE users DROP COLUMN pvotes; +ALTER TABLE users DROP COLUMN pfind; +ALTER TABLE users DROP COLUMN plist; +ALTER TABLE users DROP COLUMN pign_nsfw; + + + -- relation graphs get ID numbers CREATE SEQUENCE relgraph_seq; ALTER TABLE vn ALTER COLUMN rgraph DROP NOT NULL; |