From 68b74a26c9c866c0a5ae2c4f269ad6f56037f5d9 Mon Sep 17 00:00:00 2001 From: Yorhel Date: Sat, 23 May 2009 18:37:01 +0200 Subject: Animation fields for releases --- util/dump.sql | 4 +++- util/updates/update_2.4.sql | 3 +++ 2 files changed, 6 insertions(+), 1 deletion(-) (limited to 'util') 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; -- cgit v1.2.3