summaryrefslogtreecommitdiffstats
path: root/upgrading
diff options
context:
space:
mode:
authorLukas Fleischer <lfleischer@archlinux.org>2019-11-23 18:00:52 +0100
committerLukas Fleischer <lfleischer@archlinux.org>2019-11-23 18:30:46 +0100
commit2422fb020b79b387ef667d146cf3e0dd7b1faebf (patch)
tree4cfc7ab7f9e81ee1f6aa49dc6106a0e6960c5797 /upgrading
parent4b97789bab8dae01987ffa4cdeb1e1257c95834f (diff)
downloadaur-2422fb020b79b387ef667d146cf3e0dd7b1faebf.tar.gz
aur-2422fb020b79b387ef667d146cf3e0dd7b1faebf.tar.xz
Store timestamp and user ID when closing requests
Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'upgrading')
-rw-r--r--upgrading/4.9.0.txt6
1 files changed, 6 insertions, 0 deletions
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;
+----