summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorcanyonknight <canyonknight@gmail.com>2013-03-19 20:17:58 -0400
committerLukas Fleischer <archlinux@cryptocrack.de>2013-03-24 22:12:08 +0100
commitde2392fed016f80d4c0e10328c204f1e94ef54dd (patch)
treec5d82bdddbe480aa6b2e1c43aa20c6b8f40dee3b
parent4fc1b9a0ca2cb19d3e6f1fbdaa9470bf2a95a499 (diff)
downloadaurweb-de2392fed016f80d4c0e10328c204f1e94ef54dd.tar.xz
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>
-rw-r--r--UPGRADING10
-rw-r--r--support/schema/aur-schema.sql8
2 files changed, 18 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
-------------------
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index fab40d6..0d04f12 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -213,3 +213,11 @@ CREATE TABLE IF NOT EXISTS TU_Votes (
FOREIGN KEY (VoteID) REFERENCES TU_VoteInfo(ID) ON DELETE CASCADE,
FOREIGN KEY (UserID) REFERENCES Users(ID) ON DELETE CASCADE
) ENGINE = InnoDB;
+
+-- Malicious user banning
+--
+CREATE TABLE Bans (
+ IPAddress INTEGER UNSIGNED NOT NULL DEFAULT 0,
+ BanTS TIMESTAMP NOT NULL,
+ PRIMARY KEY (IPAddress)
+) ENGINE = InnoDB;