summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
Diffstat (limited to 'util')
-rw-r--r--util/dump.sql4
-rw-r--r--util/updates/update_2.4.sql3
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;