diff options
| author | Yorhel <git@yorhel.nl> | 2019-08-19 14:17:33 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2019-08-19 14:17:33 +0200 |
| commit | 2c692f6dc640a93e70229795170910f75544fb14 (patch) | |
| tree | 93955312386675dfeef5253d1b225be55febbd31 /util | |
| parent | 62a8f88edcfb1339a89f30cef2c9a05f7e495e7d (diff) | |
Add Gyutto.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 4e7c1c9f..e14b45e7 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -309,7 +309,8 @@ CREATE TABLE releases ( -- dbentry_type=r l_dlsiteen text NOT NULL DEFAULT '', -- [pub] l_gog text NOT NULL DEFAULT '', -- [pub] l_denpa text NOT NULL DEFAULT '', -- [pub] - l_jlist text NOT NULL DEFAULT '' -- [pub] + l_jlist text NOT NULL DEFAULT '', -- [pub] + l_gyutto integer NOT NULL DEFAULT 0 -- [pub] ); -- releases_hist @@ -338,7 +339,8 @@ CREATE TABLE releases_hist ( l_dlsiteen text NOT NULL DEFAULT '', l_gog text NOT NULL DEFAULT '', l_denpa text NOT NULL DEFAULT '', - l_jlist text NOT NULL DEFAULT '' + l_jlist text NOT NULL DEFAULT '', + l_gyutto integer NOT NULL DEFAULT 0 ); -- releases_lang diff --git a/util/updates/update_20190816.sql b/util/updates/update_20190816.sql index 37ca37d2..5cfa69e6 100644 --- a/util/updates/update_20190816.sql +++ b/util/updates/update_20190816.sql @@ -6,12 +6,14 @@ 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 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_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 ''; 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; \i util/sql/editfunc.sql |