summaryrefslogtreecommitdiff
path: root/util
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
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')
-rw-r--r--util/dump.sql3
-rw-r--r--util/updates/update_2.2.sql6
2 files changed, 8 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
diff --git a/util/updates/update_2.2.sql b/util/updates/update_2.2.sql
index c3419b2d..d16c4bf0 100644
--- a/util/updates/update_2.2.sql
+++ b/util/updates/update_2.2.sql
@@ -28,3 +28,9 @@ $$ LANGUAGE plpgsql;
SELECT update_vnpopularity();
+
+
+-- store the IP address used to register
+ALTER TABLE users ADD COLUMN ip inet NOT NULL DEFAULT '0.0.0.0';
+
+