From de2392fed016f80d4c0e10328c204f1e94ef54dd Mon Sep 17 00:00:00 2001 From: canyonknight Date: Tue, 19 Mar 2013 20:17:58 -0400 Subject: Add "Bans" table to database schema The "Bans" table creates a DB structure for the ability to ban IP addresses. It takes an IP address converted by ip2long(). The table will eventually be able to be populated directly through the web interface by Trusted Users and Developers. Signed-off-by: canyonknight Signed-off-by: Lukas Fleischer --- UPGRADING | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'UPGRADING') diff --git a/UPGRADING b/UPGRADING index 9c05467..a04471f 100644 --- a/UPGRADING +++ b/UPGRADING @@ -11,6 +11,16 @@ ALTER TABLE Users ADD COLUMN LastLoginIPAddress INTEGER UNSIGNED NOT NULL DEFAULT 0; ---- +2. Add a new "Bans" table: + +---- +CREATE TABLE Bans ( + IPAddress INTEGER UNSIGNED NOT NULL DEFAULT 0, + BanTS TIMESTAMP NOT NULL, + PRIMARY KEY (IPAddress) +) ENGINE = InnoDB; +---- + From 2.0.0 to 2.1.0 ------------------- -- cgit v1.2.3-54-g00ecf