[aur-dev] [PATCH 2/2] Add upgrade instructions for comment editing feature

Signed-off-by: Marcel Korpel <marcel.korpel@gmail.com> --- upgrading/4.1.0.txt | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 upgrading/4.1.0.txt diff --git a/upgrading/4.1.0.txt b/upgrading/4.1.0.txt new file mode 100644 index 0000000..7862030 --- /dev/null +++ b/upgrading/4.1.0.txt @@ -0,0 +1,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; +---- -- 2.4.5