summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
Diffstat (limited to 'util')
-rw-r--r--util/updates/update_2.3.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/util/updates/update_2.3.sql b/util/updates/update_2.3.sql
index 9ae226df..ce8ce966 100644
--- a/util/updates/update_2.3.sql
+++ b/util/updates/update_2.3.sql
@@ -33,8 +33,8 @@ CREATE TABLE tags_vn (
tag integer NOT NULL REFERENCES tags (id) DEFERRABLE INITIALLY DEFERRED,
vid integer NOT NULL REFERENCES vn (id) DEFERRABLE INITIALLY DEFERRED,
uid integer NOT NULL REFERENCES users (id) DEFERRABLE INITIALLY DEFERRED,
- vote smallint NOT NULL DEFAULT 3, -- -3..3 (0 isn't actually used...)
- spoiler boolean NOT NULL DEFAULT FALSE,
+ vote smallint NOT NULL DEFAULT 3 CHECK (vote >= -3 AND vote <= 3 AND vote <> 0),
+ spoiler smallint CHECK(spoiler >= 0 AND spoiler <= 2),
PRIMARY KEY(tag, vid, uid)
) WITHOUT OIDS;