From 5660816ea079585c70583a9e470e22c4cf66c022 Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Tue, 19 Mar 2013 14:49:34 +0100 Subject: 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 --- support/schema/aur-schema.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'support') diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index d55cf1a..fab40d6 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), -- cgit v1.2.3-54-g00ecf