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 | |
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')
-rw-r--r-- | util/OLD/cleanimg.pl (renamed from util/cleanimg.pl) | 0 | ||||
-rwxr-xr-x | util/OLD/cron_daily.sh (renamed from util/cron_daily.sh) | 0 | ||||
-rw-r--r-- | util/OLD/cron_daily.sql (renamed from util/cron_daily.sql) | 0 | ||||
-rw-r--r-- | util/OLD/relgraph.pl (renamed from util/relgraph.pl) | 0 | ||||
-rw-r--r-- | util/OLD/sitemap.pl (renamed from util/sitemap.pl) | 0 | ||||
-rw-r--r--[-rwxr-xr-x] | util/multi.pl | 7 | ||||
-rw-r--r-- | util/updates/update_1.14.pl | 2 | ||||
-rw-r--r-- | util/updates/update_1.14.sql | 8 |
8 files changed, 13 insertions, 4 deletions
diff --git a/util/cleanimg.pl b/util/OLD/cleanimg.pl index 45032106..45032106 100644 --- a/util/cleanimg.pl +++ b/util/OLD/cleanimg.pl diff --git a/util/cron_daily.sh b/util/OLD/cron_daily.sh index 743a9839..743a9839 100755 --- a/util/cron_daily.sh +++ b/util/OLD/cron_daily.sh diff --git a/util/cron_daily.sql b/util/OLD/cron_daily.sql index c30f30f1..c30f30f1 100644 --- a/util/cron_daily.sql +++ b/util/OLD/cron_daily.sql diff --git a/util/relgraph.pl b/util/OLD/relgraph.pl index a4ae486d..a4ae486d 100644 --- a/util/relgraph.pl +++ b/util/OLD/relgraph.pl diff --git a/util/sitemap.pl b/util/OLD/sitemap.pl index 6fde2f80..6fde2f80 100644 --- a/util/sitemap.pl +++ b/util/OLD/sitemap.pl diff --git a/util/multi.pl b/util/multi.pl index b4b4cad2..4c22bced 100755..100644 --- a/util/multi.pl +++ b/util/multi.pl @@ -26,9 +26,6 @@ # -a Don't do anything, just add the commands specified on # the command line to the shared memory processing queue. - -# TODO: error handling - # # Multi - core namespace for initialisation and global variables # @@ -46,7 +43,9 @@ use DBI; use lib '/www/vndb/lib'; use Multi::Core; use Multi::RG; +use Multi::Image; use Multi::Sitemap; +use Multi::Maintenance; use Multi::IRC; BEGIN { require 'global.pl' } @@ -79,7 +78,9 @@ our $SQL = DBI->connect(@VNDB::DBLOGIN, Multi::Core->spawn(); Multi::RG->spawn(); +Multi::Image->spawn(); Multi::Sitemap->spawn(); +Multi::Maintenance->spawn(); Multi::IRC->spawn( server => 'irc.synirc.net', user => 'Multi_'.$$, 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; |