diff options
author | Yorhel <git@yorhel.nl> | 2019-08-19 15:10:35 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-08-19 15:10:35 +0200 |
commit | afc254e53b8f81a8d05e47b99a7a9245477e8303 (patch) | |
tree | 3fb86c8cda5fa431777d3981e478790166ed14e5 /util | |
parent | fdfc92a0520bb30dbc26ada97223ee075e702b3e (diff) |
Add Melonbooks.com links to releases + minor edit form reorg
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/schema.sql | 6 | ||||
-rw-r--r-- | util/updates/update_20190816.sql | 2 |
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 |