summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-05-23 11:03:02 +0200
committerYorhel <git@yorhel.nl>2009-05-23 11:04:02 +0200
commitfbd24e0c11ccd0fae499a38b4c1ab7b971a42094 (patch)
tree9503820417275bc6799b1c8546a3b2952fedf4bc /util
parentdbe40977ddbc77863f68e0ae61eca6b3e3e1335f (diff)
Added freeware and doujin information to releases
TODO: - update d3 - filters on /r
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 2155edbb..7bf59f8c 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -117,7 +117,9 @@ CREATE TABLE releases_rev (
patch boolean NOT NULL DEFAULT FALSE,
catalog varchar(50) NOT NULL DEFAULT '',
resolution smallint NOT NULL DEFAULT 0,
- voiced smallint NOT NULL DEFAULT 0
+ voiced smallint NOT NULL DEFAULT 0,
+ freeware boolean NOT NULL DEFAULT FALSE,
+ doujin boolean NOT NULL DEFAULT FALSE
);
-- releases_vn
diff --git a/util/updates/update_2.4.sql b/util/updates/update_2.4.sql
index 2dbfd1b1..bb50c672 100644
--- a/util/updates/update_2.4.sql
+++ b/util/updates/update_2.4.sql
@@ -37,4 +37,7 @@ SELECT tag_vn_calc();
ALTER TABLE releases_rev ADD COLUMN resolution smallint NOT NULL DEFAULT 0;
-- voiced
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;