1. Add Timezone column to Users: --- ALTER TABLE Users ADD COLUMN Timezone VARCHAR(32) NOT NULL DEFAULT 'UTC'; --- 2. Add LastSSHLogin and LastSSHLoginIPAddress columns to the Users table: --- ALTER TABLE Users ADD COLUMN LastSSHLogin BIGINT UNSIGNED NOT NULL DEFAULT 0, ADD COLUMN LastSSHLoginIPAddress VARCHAR(45) NULL DEFAULT NULL; --- 3. Convert the IPAddress column of the Bans table to VARCHAR(45). If the table contains any active bans, convert them accordingly: ---- ALTER TABLE Bans MODIFY IPAddress VARCHAR(45) NULL DEFAULT NULL; ---- 4. Resize the Passwd column of the Users table: --- ALTER TABLE Users MODIFY Passwd VARCHAR(255) NOT NULL; ---