blob: 439562f781af183e7be4ae1132701003daae2c37 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
1. Add a timestamp for comment editing/deletion and an ID of the last user
who edited a comment:
----
ALTER TABLE PackageComments
ADD COLUMN EditedTS BIGINT UNSIGNED NULL DEFAULT NULL,
ADD COLUMN EditedUsersID INTEGER UNSIGNED NULL DEFAULT NULL,
ADD FOREIGN KEY (EditedUsersID) REFERENCES Users(ID) ON DELETE SET NULL;
----
2. Add fields to store the ID and comment of the last user who flagged a
package out-of-date:
----
ALTER TABLE PackageBases
ADD COLUMN FlaggerUID INTEGER UNSIGNED NULL DEFAULT NULL,
ADD COLUMN FlaggerComment VARCHAR(255) NOT NULL,
ADD FOREIGN KEY (FlaggerUID) REFERENCES Users(ID) ON DELETE SET NULL;
----
|