summaryrefslogtreecommitdiffstats
path: root/UPGRADING
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2013-08-28 16:37:56 +0200
committerLukas Fleischer <archlinux@cryptocrack.de>2013-08-28 16:37:56 +0200
commitd225366f31aae250981f9f5bf8e43e633c631c73 (patch)
tree3db259c25d12ccf42bf930f1478ca64d781e294f /UPGRADING
parent2276171b2987c42ce9658e9cac469f2714939a33 (diff)
downloadaur-d225366f31aae250981f9f5bf8e43e633c631c73.tar.gz
aur-d225366f31aae250981f9f5bf8e43e633c631c73.tar.xz
Add a registration time stamp to the "Users" table
This allows for easily detecting old accounts that registered and never used the confirmation e-mail to set an initial password. Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'UPGRADING')
-rw-r--r--UPGRADING6
1 files changed, 4 insertions, 2 deletions
diff --git a/UPGRADING b/UPGRADING
index a6686538..9a0f44d4 100644
--- a/UPGRADING
+++ b/UPGRADING
@@ -4,10 +4,12 @@ Upgrading
From 2.2.0 to 2.3.0
-------------------
-1. Add an inactivity time stamp to the "Users" table:
+1. Add registration and inactivity time stamps to the "Users" table:
----
-ALTER TABLE Users ADD COLUMN InactivityTS BIGINT NOT NULL DEFAULT 0;
+ALTER TABLE Users
+ ADD COLUMN RegistrationTS TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ ADD COLUMN InactivityTS BIGINT NOT NULL DEFAULT 0;
----
2. Add fields to store the total number of TUs and the quorum to the