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;