1 1. Add a timestamp for comment editing/deletion and an ID of the last user
5 ALTER TABLE PackageComments
6 ADD COLUMN EditedTS BIGINT UNSIGNED NULL DEFAULT NULL,
7 ADD COLUMN EditedUsersID INTEGER UNSIGNED NULL DEFAULT NULL,
8 ADD FOREIGN KEY (EditedUsersID) REFERENCES Users(ID) ON DELETE SET NULL;
11 2. Add fields to store the ID and comment of the last user who flagged a
15 ALTER TABLE PackageBases
16 ADD COLUMN FlaggerUID INTEGER UNSIGNED NULL DEFAULT NULL,
17 ADD COLUMN FlaggerComment VARCHAR(255) NOT NULL,
18 ADD FOREIGN KEY (FlaggerUID) REFERENCES Users(ID) ON DELETE SET NULL;
21 3. Add field to store the state of a user's email address:
25 ADD COLUMN HideEmail TINYINT UNSIGNED NOT NULL DEFAULT 0;