4.1.0.txt 567 Bytes
Newer Older
1
2
3
4
5
6
7
8
9
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;
----
10

11
12
2. Add fields to store the ID and comment of the last user who flagged a
package out-of-date:
13
14
15

----
ALTER TABLE PackageBases
16
17
	ADD COLUMN FlaggerUID BIGINT UNSIGNED NULL DEFAULT NULL,
	ADD COLUMN FlaggerComment VARCHAR(255) NOT NULL;
18
----