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

[Marcel Korpel]

Signed-off-by: Marcel Korpel <marcel.korpel at 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