diff options
author | Yorhel <git@yorhel.nl> | 2019-09-02 13:08:26 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-09-02 13:09:00 +0200 |
commit | 3540b91daae0be093f8fb8825c749be3ead1d8bb (patch) | |
tree | 794b2511e1b3d307006cd6790a2a7a9e6ff5e43e /util/sql/schema.sql | |
parent | b30d366002b2c34f4f756292872688c0b94fc16d (diff) |
Allow multiple Gyutto & DMM links per release
To handle https://vndb.org/t12755.37
Diffstat (limited to 'util/sql/schema.sql')
-rw-r--r-- | util/sql/schema.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index 80008067..2983f290 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -296,13 +296,13 @@ CREATE TABLE releases ( -- dbentry_type=r l_gog text NOT NULL DEFAULT '', -- [pub] l_denpa text NOT NULL DEFAULT '', -- [pub] l_jlist text NOT NULL DEFAULT '', -- [pub] - l_gyutto integer NOT NULL DEFAULT 0, -- [pub] + l_gyutto integer[] NOT NULL DEFAULT '{}', -- [pub] l_digiket integer NOT NULL DEFAULT 0, -- [pub] l_melon integer NOT NULL DEFAULT 0, -- [pub] l_mg integer NOT NULL DEFAULT 0, -- [pub] l_getchu integer NOT NULL DEFAULT 0, -- [pub] l_getchudl integer NOT NULL DEFAULT 0, -- [pub] - l_dmm text NOT NULL DEFAULT '', -- [pub] + l_dmm text[] NOT NULL DEFAULT '{}', -- [pub] l_itch text NOT NULL DEFAULT '', -- [pub] l_jastusa text NOT NULL DEFAULT '', -- [pub] l_egs integer NOT NULL DEFAULT 0, -- [pub] @@ -336,13 +336,13 @@ CREATE TABLE releases_hist ( l_gog text NOT NULL DEFAULT '', l_denpa text NOT NULL DEFAULT '', l_jlist text NOT NULL DEFAULT '', - l_gyutto integer NOT NULL DEFAULT 0, + l_gyutto integer[] NOT NULL DEFAULT '{}', l_digiket integer NOT NULL DEFAULT 0, l_melon integer NOT NULL DEFAULT 0, l_mg integer NOT NULL DEFAULT 0, l_getchu integer NOT NULL DEFAULT 0, l_getchudl integer NOT NULL DEFAULT 0, - l_dmm text NOT NULL DEFAULT '', + l_dmm text[] NOT NULL DEFAULT '{}', l_itch text NOT NULL DEFAULT '', l_jastusa text NOT NULL DEFAULT '', l_egs integer NOT NULL DEFAULT 0, |