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 a field to store the ID of the last user who flagged a package
15 ALTER TABLE PackageBases
16 ADD COLUMN FlaggerUID BIGINT UNSIGNED NULL DEFAULT NULL;