diff options
author | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-04-29 12:59:28 +0000 |
---|---|---|
committer | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-04-29 12:59:28 +0000 |
commit | 2e533bd16346ec74216415c01a57c7276d608cf8 (patch) | |
tree | 680ac1cb7fe15c65a53c9f0bc6b1e4949481118b /util | |
parent | 04c26425699a3e01d0e2abe52ad9f763396cd940 (diff) |
...another commit...
git-svn-id: svn://vndb.org/vndb@9 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
Diffstat (limited to 'util')
-rw-r--r-- | util/multi.pl | 2 | ||||
-rw-r--r-- | util/updates/update_1.15.sql | 26 |
2 files changed, 28 insertions, 0 deletions
diff --git a/util/multi.pl b/util/multi.pl index 022160ee..3e6e07a7 100644 --- a/util/multi.pl +++ b/util/multi.pl @@ -44,6 +44,7 @@ use Multi::Core; use Multi::RG; use Multi::Image; use Multi::Sitemap; +use Multi::Anime; use Multi::Maintenance; use Multi::IRC; @@ -77,6 +78,7 @@ Multi::Core->spawn(); Multi::RG->spawn(); Multi::Image->spawn(); Multi::Sitemap->spawn(); +Multi::Anime->spawn(); Multi::Maintenance->spawn(); Multi::IRC->spawn() if !$VNDB::DEBUG; diff --git a/util/updates/update_1.15.sql b/util/updates/update_1.15.sql new file mode 100644 index 00000000..2f2f814c --- /dev/null +++ b/util/updates/update_1.15.sql @@ -0,0 +1,26 @@ + + +-- remove the old image hashes +ALTER TABLE vn_rev DROP COLUMN image_old; + + + +-- Add anime relations +CREATE TABLE anime ( + id integer NOT NULL PRIMARY KEY, -- anidb id + year smallint NOT NULL DEFAULT 0, + ann_id integer NOT NULL DEFAULT 0, + nfo_id varchar(200) NOT NULL DEFAULT '', + type smallint NOT NULL DEFAULT 0, -- TV/OVA/etc (global.pl) + title_romaji varchar(250) NOT NULL DEFAULT '', + title_kanji varchar(250) NOT NULL DEFAULT '', + lastfetch bigint NOT NULL DEFAULT 0 -- -1:not found, 0: not fetched, >0: timestamp +) WITHOUT oids; + +CREATE TABLE vn_anime ( + vid integer NOT NULL REFERENCES vn_rev (id) DEFERRABLE INITIALLY DEFERRED, + aid integer NOT NULL REFERENCES anime (id) DEFERRABLE INITIALLY DEFERRED, + PRIMARY KEY(vid, aid) +) WITHOUT oids; + + |