diff options
| author | Yorhel <git@yorhel.nl> | 2019-08-17 11:10:21 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2019-08-17 11:10:21 +0200 |
| commit | 95bc983ab656f529a5f49655592cf5f95971de30 (patch) | |
| tree | eb54f2b2b74f0323fee329f8a362d9adbd63727f /util | |
| parent | 85c81bd7fea2f8bb3d1b08330563f89bd10e8293 (diff) | |
Add GOG.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 2b6ddf95..b9ff6f05 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -306,7 +306,8 @@ CREATE TABLE releases ( -- dbentry_type=r engine varchar(50) NOT NULL DEFAULT '', -- [pub] l_steam integer NOT NULL DEFAULT 0, -- [pub] l_dlsite text NOT NULL DEFAULT '', -- [pub] - l_dlsiteen text NOT NULL DEFAULT '' -- [pub] + l_dlsiteen text NOT NULL DEFAULT '', -- [pub] + l_gog text NOT NULL DEFAULT '' -- [pub] ); -- releases_hist @@ -332,7 +333,8 @@ CREATE TABLE releases_hist ( engine varchar(50) NOT NULL DEFAULT '', l_steam integer NOT NULL DEFAULT 0, l_dlsite text NOT NULL DEFAULT '', - l_dlsiteen text NOT NULL DEFAULT '' + l_dlsiteen text NOT NULL DEFAULT '', + l_gog text NOT NULL DEFAULT '' ); -- releases_lang diff --git a/util/updates/update_20190816.sql b/util/updates/update_20190816.sql index 93dca29b..f61ccea8 100644 --- a/util/updates/update_20190816.sql +++ b/util/updates/update_20190816.sql @@ -3,9 +3,11 @@ ALTER TABLE releases ADD COLUMN l_steam integer NOT NULL DEFAULT 0; ALTER TABLE releases ADD COLUMN l_dlsite text NOT NULL DEFAULT ''; ALTER TABLE releases ADD COLUMN l_dlsiteen text NOT NULL DEFAULT ''; +ALTER TABLE releases ADD COLUMN l_gog text NOT NULL DEFAULT ''; 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 ''; +ALTER TABLE releases_hist ADD COLUMN l_gog text NOT NULL DEFAULT ''; \i util/sql/editfunc.sql |