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 <canyonknight@gmail.com>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>

1 files changed, 10 insertions, 0 deletions

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
 -------------------