summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-05-22 16:38:40 +0200
committerYorhel <git@yorhel.nl>2009-05-22 16:38:40 +0200
commit3ad040d6d210fcd7415ddbabd4782a92c23c913e (patch)
tree9edecce67e30c48009ff82ad6b8853b32c63535a /util
parent671b015a2e2a425fbaf8b800737902af65027036 (diff)
Voiced field for releases
TODO: filter on /r
Diffstat (limited to 'util')
-rw-r--r--util/dump.sql3
-rw-r--r--util/updates/update_2.4.sql5
2 files changed, 5 insertions, 3 deletions
diff --git a/util/dump.sql b/util/dump.sql
index b33ae540..2155edbb 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -116,7 +116,8 @@ CREATE TABLE releases_rev (
gtin bigint NOT NULL DEFAULT 0,
patch boolean NOT NULL DEFAULT FALSE,
catalog varchar(50) NOT NULL DEFAULT '',
- resolution smallint NOT NULL DEFAULT 0
+ resolution smallint NOT NULL DEFAULT 0,
+ voiced smallint NOT NULL DEFAULT 0
);
-- releases_vn
diff --git a/util/updates/update_2.4.sql b/util/updates/update_2.4.sql
index c784d361..2dbfd1b1 100644
--- a/util/updates/update_2.4.sql
+++ b/util/updates/update_2.4.sql
@@ -33,7 +33,8 @@ SELECT tag_vn_calc();
--- resolution field to releases
-
+-- resolution field
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;