diff options
| author | Yorhel <git@yorhel.nl> | 2019-08-19 19:39:21 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2019-08-19 19:39:21 +0200 |
| commit | 72627af4b3f41eae720d03b908a59ca91af14e2a (patch) | |
| tree | 62cd14edd0066d1e9f7784f0f9892570c6aad5e1 /util | |
| parent | 6e48c37af6b6d17c9004b03d18562f323da0f700 (diff) | |
Add Getchu links to releases
Diffstat (limited to 'util')
| -rw-r--r-- | util/sql/schema.sql | 8 | ||||
| -rw-r--r-- | util/updates/update_20190816.sql | 4 |
2 files changed, 10 insertions, 2 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index f6312639..455dce18 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -313,7 +313,9 @@ CREATE TABLE releases ( -- dbentry_type=r l_gyutto integer NOT NULL DEFAULT 0, -- [pub] l_digiket integer NOT NULL DEFAULT 0, -- [pub] l_melon integer NOT NULL DEFAULT 0, -- [pub] - l_mg integer NOT NULL DEFAULT 0 -- [pub] + l_mg integer NOT NULL DEFAULT 0, -- [pub] + l_getchu integer NOT NULL DEFAULT 0, -- [pub] + l_getchudl integer NOT NULL DEFAULT 0 -- [pub] ); -- releases_hist @@ -346,7 +348,9 @@ CREATE TABLE releases_hist ( l_gyutto integer NOT NULL DEFAULT 0, l_digiket integer NOT NULL DEFAULT 0, l_melon integer NOT NULL DEFAULT 0, - l_mg integer NOT NULL DEFAULT 0 + l_mg integer NOT NULL DEFAULT 0, + l_getchu integer NOT NULL DEFAULT 0, + l_getchudl integer NOT NULL DEFAULT 0 ); -- releases_lang diff --git a/util/updates/update_20190816.sql b/util/updates/update_20190816.sql index 4b5301e9..e4f76eb1 100644 --- a/util/updates/update_20190816.sql +++ b/util/updates/update_20190816.sql @@ -10,6 +10,8 @@ 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 ADD COLUMN l_mg integer NOT NULL DEFAULT 0; +ALTER TABLE releases ADD COLUMN l_getchu integer NOT NULL DEFAULT 0; +ALTER TABLE releases ADD COLUMN l_getchudl 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 ''; @@ -20,6 +22,8 @@ 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; ALTER TABLE releases_hist ADD COLUMN l_mg integer NOT NULL DEFAULT 0; +ALTER TABLE releases_hist ADD COLUMN l_getchu integer NOT NULL DEFAULT 0; +ALTER TABLE releases_hist ADD COLUMN l_getchudl integer NOT NULL DEFAULT 0; \i util/sql/editfunc.sql |