diff options
author | Yorhel <git@yorhel.nl> | 2009-01-10 11:48:12 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-01-10 11:50:59 +0100 |
commit | f213a6d848534146d8b6105f73ae52ebe8271ca1 (patch) | |
tree | 14a80cde3b3b2ae80115a6703848483869b10d46 /util/dump.sql | |
parent | 614d693c4995a0de58379ce8c0780454b5f6db61 (diff) |
Limit account creation to one account a day per IP
This would at least annoy the people who'll try to manipulate
the rankings, and will make finding duplicate users a bit easier.
(Not that it's really a problem at the moment)
Diffstat (limited to 'util/dump.sql')
-rw-r--r-- | util/dump.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/util/dump.sql b/util/dump.sql index afbbc622..f23d6d62 100644 --- a/util/dump.sql +++ b/util/dump.sql @@ -187,7 +187,8 @@ CREATE TABLE users ( c_votes integer NOT NULL DEFAULT 0, c_changes integer NOT NULL DEFAULT 0, skin varchar(128) NOT NULL DEFAULT '', - customcss text NOT NULL DEFAULT '' + customcss text NOT NULL DEFAULT '', + ip inet NOT NULL DEFAULT '0.0.0.0' ); -- vn |