summaryrefslogtreecommitdiff
path: root/util/dump.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-01-10 11:48:12 +0100
committerYorhel <git@yorhel.nl>2009-01-10 11:50:59 +0100
commitf213a6d848534146d8b6105f73ae52ebe8271ca1 (patch)
tree14a80cde3b3b2ae80115a6703848483869b10d46 /util/dump.sql
parent614d693c4995a0de58379ce8c0780454b5f6db61 (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.sql3
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