summaryrefslogtreecommitdiffstats
path: root/upgrading/2.2.0.txt
blob: 1cdf2b018f490a500a17d5e1775845e734e97c9e (plain)
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;
----