diff options
| author | Yorhel <git@yorhel.nl> | 2019-08-19 14:43:58 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2019-08-19 14:43:58 +0200 |
| commit | fdfc92a0520bb30dbc26ada97223ee075e702b3e (patch) | |
| tree | 99e426215c93b876f37765e1910b41ed7079c66d /util | |
| parent | 2c692f6dc640a93e70229795170910f75544fb14 (diff) | |
Add Digiket.com links to releases
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 e14b45e7..591a1d38 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -310,7 +310,8 @@ 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 0, -- [pub] + l_digiket integer NOT NULL DEFAULT 0 -- [pub] ); -- releases_hist @@ -340,7 +341,8 @@ 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 0, + l_digiket integer NOT NULL DEFAULT 0 ); -- releases_lang diff --git a/util/updates/update_20190816.sql b/util/updates/update_20190816.sql index 5cfa69e6..e8a39317 100644 --- a/util/updates/update_20190816.sql +++ b/util/updates/update_20190816.sql @@ -7,6 +7,7 @@ ALTER TABLE releases ADD COLUMN l_gog text NOT NULL DEFAULT ''; 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_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 ''; @@ -14,6 +15,7 @@ ALTER TABLE releases_hist ADD COLUMN l_gog text NOT NULL DEFAULT ''; 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; \i util/sql/editfunc.sql |