blob: fb0a2993a5a6f06f50d54457701d154c98d7f088 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
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;
----
|
