summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2020-03-23 10:38:02 +0100
committerYorhel <git@yorhel.nl>2020-03-23 10:38:19 +0100
commitc15ceba222b17b6ca84ef74b7edeebafc4d4668b (patch)
treeca998d18c33ba617e2420301ffb684a6d4fe7a35 /util
parent54b9d057d22f4470a2c0ce39996e2c5dc2b5ab24 (diff)
ExtLinks: A few more shop links for releases
Diffstat (limited to 'util')
-rw-r--r--util/sql/schema.sql12
-rw-r--r--util/updates/2020-03-23-release-extlinks.sql9
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