diff options
Diffstat (limited to 'upgrading/4.1.0.txt')
| -rw-r--r-- | upgrading/4.1.0.txt | 9 |
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; +---- |