1. Add new "Users" table login IP address column: ---- 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; ----