summaryrefslogtreecommitdiff
path: root/util/updates
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/updates
parentdbe40977ddbc77863f68e0ae61eca6b3e3e1335f (diff)
Added freeware and doujin information to releases
TODO: - update d3 - filters on /r
Diffstat (limited to 'util/updates')
-rw-r--r--util/updates/update_2.4.sql3
1 files changed, 3 insertions, 0 deletions
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;