summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-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 9c054672..a04471fb 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 fab40d63..0d04f12f 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;