[aur-dev] [PATCH] Add a registration time stamp to the "Users" table

[Lukas Fleischer]

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 at cryptocrack.de>
---
 UPGRADING                     | 6 ++++--
 support/schema/aur-schema.sql | 1 +
 2 files changed, 5 insertions(+), 2 deletions(-)

diff --git a/UPGRADING b/UPGRADING
index a668653..9a0f44d 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
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index 1245919..25e828e 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -36,6 +36,7 @@ CREATE TABLE Users (
 	LastLogin BIGINT UNSIGNED NOT NULL DEFAULT 0,
 	LastLoginIPAddress INTEGER UNSIGNED NOT NULL DEFAULT 0,
 	InactivityTS BIGINT UNSIGNED NOT NULL DEFAULT 0,
+	RegistrationTS TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 	PRIMARY KEY (ID),
 	UNIQUE (Username),
 	UNIQUE (Email),
-- 
1.8.4.rc3.500.gc3113b0