From 2422fb020b79b387ef667d146cf3e0dd7b1faebf Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Sat, 23 Nov 2019 12:00:52 -0500 Subject: Store timestamp and user ID when closing requests Signed-off-by: Lukas Fleischer --- upgrading/4.9.0.txt | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 upgrading/4.9.0.txt (limited to 'upgrading/4.9.0.txt') diff --git a/upgrading/4.9.0.txt b/upgrading/4.9.0.txt new file mode 100644 index 00000000..4c79283e --- /dev/null +++ b/upgrading/4.9.0.txt @@ -0,0 +1,6 @@ +1. Add new columns to store the timestamp and UID when closing requests: + +---- +ALTER TABLE PackageRequests ADD COLUMN ClosedTS BIGINT UNSIGNED NULL DEFAULT NULL; +ALTER TABLE PackageRequests ADD COLUMN ClosedUID INTEGER UNSIGNED NULL DEFAULT NULL; +---- -- cgit v1.2.3-24-g4f1b