1 1. Add a column to store ownership notification settings:
4 ALTER TABLE Users ADD COLUMN OwnershipNotify TINYINT(1) NOT NULL DEFAULT 1;
7 2. Resize the LastLoginIPAddress column:
10 ALTER TABLE Users MODIFY LastLoginIPAddress VARCHAR(45) NULL DEFAULT NULL;
13 3. Add a new column to store repository information of official providers:
16 ALTER TABLE OfficialProviders ADD COLUMN Repo VARCHAR(64) NOT NULL;
19 4. Add a column to store users' homepages:
22 ALTER TABLE Users ADD COLUMN Homepage TEXT NULL DEFAULT NULL;
25 5. Resize LangPreference to fit Latin American Spanish language code:
28 ALTER TABLE Users MODIFY LangPreference VARCHAR(6);