summaryrefslogtreecommitdiff
path: root/util/updates/update_1.15.sql
blob: 2f2f814c3169c4a54bedbb2a259b4f128853ad2c (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
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;