diff options
| author | Lukas Fleischer <lfleischer@archlinux.org> | 2017-01-25 08:37:48 +0100 |
|---|---|---|
| committer | Lukas Fleischer <lfleischer@archlinux.org> | 2017-01-25 18:42:34 +0100 |
| commit | 70db022aa8287c57a2ee03328ae893ba8b83b192 (patch) | |
| tree | 9576426d39b9f6b2240cdf936b79bae29df1300b /schema | |
| parent | f8916d7e9bda129a57143d769f7eb1f596614c80 (diff) | |
| download | aur-70db022aa8287c57a2ee03328ae893ba8b83b192.tar.gz aur-70db022aa8287c57a2ee03328ae893ba8b83b192.tar.xz | |
Store banned IP addresses as plain text
Inspired by commit 32c8d0c (Store last login address as plain text,
2016-03-13).
Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/aur-schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql index b0663eb5..99f90834 100644 --- a/schema/aur-schema.sql +++ b/schema/aur-schema.sql @@ -376,7 +376,7 @@ CREATE TABLE IF NOT EXISTS TU_Votes ( -- Malicious user banning -- CREATE TABLE Bans ( - IPAddress INTEGER UNSIGNED NOT NULL DEFAULT 0, + IPAddress VARCHAR(45) NULL DEFAULT NULL, BanTS TIMESTAMP NOT NULL, PRIMARY KEY (IPAddress) ) ENGINE = InnoDB; |