summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--UPGRADING6
-rw-r--r--support/schema/aur-schema.sql1
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),