diff options
author | Yorhel <git@yorhel.nl> | 2019-12-20 13:06:54 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-12-20 13:06:56 +0100 |
commit | be4a058f9c78a1b73dd6ac848c5becb62c2199ca (patch) | |
tree | d333e9f4a598c9539417cdcd78d9d8619dcc3122 /util/sql/schema.sql | |
parent | 52ed55d9ee83b5dfdb3c9fc7d4f607b232c9447b (diff) |
Keep track of poll vote dates
That'd make it much easier to find fake accounts.
Diffstat (limited to 'util/sql/schema.sql')
-rw-r--r-- | util/sql/schema.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index e644ecc3..aa380aa4 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -645,6 +645,7 @@ CREATE TABLE threads_poll_votes ( tid integer NOT NULL, uid integer NOT NULL, optid integer NOT NULL, + date timestamptz DEFAULT NOW(), PRIMARY KEY (tid, uid, optid) ); |