summaryrefslogtreecommitdiffstats
path: root/upgrading
diff options
context:
space:
mode:
Diffstat (limited to 'upgrading')
-rw-r--r--upgrading/4.1.0.txt9
1 files changed, 9 insertions, 0 deletions
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;
+----