summaryrefslogtreecommitdiffstats
path: root/support/schema
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2013-03-19 14:49:34 +0100
committerLukas Fleischer <archlinux@cryptocrack.de>2013-03-21 22:26:46 +0100
commit5660816ea079585c70583a9e470e22c4cf66c022 (patch)
tree298c188eeef5d53a2dcd266eab4607f11bb8c63d /support/schema
parentde39a712b040d4ce51dc4eb2f4e2ef74a7a9013c (diff)
downloadaur-5660816ea079585c70583a9e470e22c4cf66c022.tar.gz
aur-5660816ea079585c70583a9e470e22c4cf66c022.tar.xz
Save last login IP address
Save the IP address used for the last login in the "Users" table. This makes it a bit easier to create IP ban lists for spammers without looking at web server logs. Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'support/schema')
-rw-r--r--support/schema/aur-schema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index d55cf1af..fab40d63 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -34,6 +34,7 @@ CREATE TABLE Users (
PGPKey VARCHAR(40) NULL DEFAULT NULL,
LastVoted BIGINT UNSIGNED NOT NULL DEFAULT 0,
LastLogin BIGINT UNSIGNED NOT NULL DEFAULT 0,
+ LastLoginIPAddress INTEGER UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (ID),
UNIQUE (Username),
UNIQUE (Email),