summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2019-08-19 15:10:35 +0200
committerYorhel <git@yorhel.nl>2019-08-19 15:10:35 +0200
commitafc254e53b8f81a8d05e47b99a7a9245477e8303 (patch)
tree3fb86c8cda5fa431777d3981e478790166ed14e5 /util
parentfdfc92a0520bb30dbc26ada97223ee075e702b3e (diff)
Add Melonbooks.com links to releases + minor edit form reorg
Diffstat (limited to 'util')
-rw-r--r--util/sql/schema.sql6
-rw-r--r--util/updates/update_20190816.sql2
2 files changed, 6 insertions, 2 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index 591a1d38..9835db46 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -311,7 +311,8 @@ CREATE TABLE releases ( -- dbentry_type=r
l_denpa text NOT NULL DEFAULT '', -- [pub]
l_jlist text NOT NULL DEFAULT '', -- [pub]
l_gyutto integer NOT NULL DEFAULT 0, -- [pub]
- l_digiket integer NOT NULL DEFAULT 0 -- [pub]
+ l_digiket integer NOT NULL DEFAULT 0, -- [pub]
+ l_melon integer NOT NULL DEFAULT 0 -- [pub]
);
-- releases_hist
@@ -342,7 +343,8 @@ CREATE TABLE releases_hist (
l_denpa text NOT NULL DEFAULT '',
l_jlist text NOT NULL DEFAULT '',
l_gyutto integer NOT NULL DEFAULT 0,
- l_digiket integer NOT NULL DEFAULT 0
+ l_digiket integer NOT NULL DEFAULT 0,
+ l_melon integer NOT NULL DEFAULT 0
);
-- releases_lang
diff --git a/util/updates/update_20190816.sql b/util/updates/update_20190816.sql
index e8a39317..a23f7c4d 100644
--- a/util/updates/update_20190816.sql
+++ b/util/updates/update_20190816.sql
@@ -8,6 +8,7 @@ ALTER TABLE releases ADD COLUMN l_denpa text NOT NULL DEFAULT '';
ALTER TABLE releases ADD COLUMN l_jlist text NOT NULL DEFAULT '';
ALTER TABLE releases ADD COLUMN l_gyutto integer NOT NULL DEFAULT 0;
ALTER TABLE releases ADD COLUMN l_digiket integer NOT NULL DEFAULT 0;
+ALTER TABLE releases ADD COLUMN l_melon integer NOT NULL DEFAULT 0;
ALTER TABLE releases_hist ADD COLUMN l_steam integer NOT NULL DEFAULT 0;
ALTER TABLE releases_hist ADD COLUMN l_dlsite text NOT NULL DEFAULT '';
ALTER TABLE releases_hist ADD COLUMN l_dlsiteen text NOT NULL DEFAULT '';
@@ -16,6 +17,7 @@ ALTER TABLE releases_hist ADD COLUMN l_denpa text NOT NULL DEFAULT '';
ALTER TABLE releases_hist ADD COLUMN l_jlist text NOT NULL DEFAULT '';
ALTER TABLE releases_hist ADD COLUMN l_gyutto integer NOT NULL DEFAULT 0;
ALTER TABLE releases_hist ADD COLUMN l_digiket integer NOT NULL DEFAULT 0;
+ALTER TABLE releases_hist ADD COLUMN l_melon integer NOT NULL DEFAULT 0;
\i util/sql/editfunc.sql