diff options
author | Yorhel <git@yorhel.nl> | 2020-03-23 10:38:02 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2020-03-23 10:38:19 +0100 |
commit | c15ceba222b17b6ca84ef74b7edeebafc4d4668b (patch) | |
tree | ca998d18c33ba617e2420301ffb684a6d4fe7a35 /util | |
parent | 54b9d057d22f4470a2c0ce39996e2c5dc2b5ab24 (diff) |
ExtLinks: A few more shop links for releases
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/schema.sql | 12 | ||||
-rw-r--r-- | util/updates/2020-03-23-release-extlinks.sql | 9 |
2 files changed, 19 insertions, 2 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index ae10a3d9..b9c8bc1e 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -339,7 +339,11 @@ CREATE TABLE releases ( -- dbentry_type=r l_itch text NOT NULL DEFAULT '', -- [pub] l_jastusa text NOT NULL DEFAULT '', -- [pub] l_egs integer NOT NULL DEFAULT 0, -- [pub] - l_erotrail integer NOT NULL DEFAULT 0 -- [pub] + l_erotrail integer NOT NULL DEFAULT 0, -- [pub] + l_toranoana bigint NOT NULL DEFAULT 0, -- [pub] + l_melonjp integer NOT NULL DEFAULT 0, -- [pub] + l_gamejolt integer NOT NULL DEFAULT 0, -- [pub] + l_nutaku text NOT NULL DEFAULT '' -- [pub] ); -- releases_hist @@ -379,7 +383,11 @@ CREATE TABLE releases_hist ( l_itch text NOT NULL DEFAULT '', l_jastusa text NOT NULL DEFAULT '', l_egs integer NOT NULL DEFAULT 0, - l_erotrail integer NOT NULL DEFAULT 0 + l_erotrail integer NOT NULL DEFAULT 0, + l_toranoana bigint NOT NULL DEFAULT 0, + l_melonjp integer NOT NULL DEFAULT 0, + l_gamejolt integer NOT NULL DEFAULT 0, + l_nutaku text NOT NULL DEFAULT '' ); -- releases_lang diff --git a/util/updates/2020-03-23-release-extlinks.sql b/util/updates/2020-03-23-release-extlinks.sql new file mode 100644 index 00000000..54d1e89e --- /dev/null +++ b/util/updates/2020-03-23-release-extlinks.sql @@ -0,0 +1,9 @@ +ALTER TABLE releases ADD COLUMN l_toranoana bigint NOT NULL DEFAULT 0; +ALTER TABLE releases_hist ADD COLUMN l_toranoana bigint NOT NULL DEFAULT 0; +ALTER TABLE releases ADD COLUMN l_melonjp integer NOT NULL DEFAULT 0; +ALTER TABLE releases_hist ADD COLUMN l_melonjp integer NOT NULL DEFAULT 0; +ALTER TABLE releases ADD COLUMN l_gamejolt integer NOT NULL DEFAULT 0; +ALTER TABLE releases_hist ADD COLUMN l_gamejolt integer NOT NULL DEFAULT 0; +ALTER TABLE releases ADD COLUMN l_nutaku text NOT NULL DEFAULT ''; +ALTER TABLE releases_hist ADD COLUMN l_nutaku text NOT NULL DEFAULT ''; +\i util/sql/editfunc.sql |