diff options
author | Yorhel <git@yorhel.nl> | 2020-02-23 11:24:47 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2020-02-23 11:24:49 +0100 |
commit | 23f621da300b907055fdebbf9b0aeb9cc7dcb876 (patch) | |
tree | 0d0c656c17efcb5bce9adec5708035299ed971c3 /util | |
parent | ef967d168848d7110841f3e31e50e5a5c3bd1ac6 (diff) |
dbdump: Add vn.c_popularity, c_rating and c_votecount to the dumps
My policy is to not dump cached tables and columns that can be derived
from other included data, but these stats aren't really a cache from the
perspective of a DB dump user, since they're based on votes that are not
available to the public.
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/schema.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index eafa4428..28048f5e 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -810,9 +810,9 @@ CREATE TABLE vn ( -- dbentry_type=v c_languages language[] NOT NULL DEFAULT '{}', c_olang language[] NOT NULL DEFAULT '{}', c_platforms platform[] NOT NULL DEFAULT '{}', - c_popularity real, - c_rating real, - c_votecount integer NOT NULL DEFAULT 0, + c_popularity real, -- [pub] + c_rating real, -- [pub] + c_votecount integer NOT NULL DEFAULT 0, -- [pub] c_search text, l_wikidata integer -- [pub] ); |