diff options
author | Yorhel <git@yorhel.nl> | 2009-05-23 18:37:01 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-05-23 18:37:47 +0200 |
commit | 68b74a26c9c866c0a5ae2c4f269ad6f56037f5d9 (patch) | |
tree | 4cd82a9669e326498cf3b884c35569a56db19d47 /util | |
parent | e01567fb9703c18f20a3c3f3fcecfdb5bc680701 (diff) |
Animation fields for releases
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; |