upgrading/2.2.0.txt


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

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