diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/updates/update_2.3.sql | 4 |
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; |