diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/dump.sql | 4 | ||||
-rw-r--r-- | util/updates/update_2.4.sql | 3 |
2 files changed, 6 insertions, 1 deletions
diff --git a/util/dump.sql b/util/dump.sql index 7bf59f8c..5d13e027 100644 --- a/util/dump.sql +++ b/util/dump.sql @@ -119,7 +119,9 @@ CREATE TABLE releases_rev ( resolution smallint NOT NULL DEFAULT 0, voiced smallint NOT NULL DEFAULT 0, freeware boolean NOT NULL DEFAULT FALSE, - doujin boolean NOT NULL DEFAULT FALSE + doujin boolean NOT NULL DEFAULT FALSE, + ani_story smallint NOT NULL DEFAULT 0, + ani_ero smallint NOT NULL DEFAULT 0 ); -- releases_vn diff --git a/util/updates/update_2.4.sql b/util/updates/update_2.4.sql index bb50c672..46ca0586 100644 --- a/util/updates/update_2.4.sql +++ b/util/updates/update_2.4.sql @@ -40,4 +40,7 @@ ALTER TABLE releases_rev ADD COLUMN voiced smallint NOT NULL DEFAULT 0; -- freeware / doujin ALTER TABLE releases_rev ADD COLUMN freeware boolean NOT NULL DEFAULT FALSE; ALTER TABLE releases_rev ADD COLUMN doujin boolean NOT NULL DEFAULT FALSE; +-- animated +ALTER TABLE releases_rev ADD COLUMN ani_story smallint NOT NULL DEFAULT 0; +ALTER TABLE releases_rev ADD COLUMN ani_ero smallint NOT NULL DEFAULT 0; |