From: Michael Andreen <harv@ruin.nu>
Date: Sat, 3 Nov 2018 08:50:11 +0000 (+0100)
Subject: timestamp on email_change
X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=commitdiff_plain;h=a149597b813bf54fd71a4d1d89afb05029687a25

timestamp on email_change
---

diff --git a/database/ndawn.sql b/database/ndawn.sql
index 54ede3a..2da8987 100644
--- a/database/ndawn.sql
+++ b/database/ndawn.sql
@@ -1462,10 +1462,10 @@ CREATE TABLE email_change (
     id text DEFAULT md5(((now() + (random() * '100 years'::interval)))::text) NOT NULL,
     uid integer NOT NULL,
     email text NOT NULL,
-    confirmed boolean DEFAULT false NOT NULL
+    confirmed boolean DEFAULT false NOT NULL,
+    time timestamptz DEFAULT now()
 );
 
-
 ALTER TABLE email_change OWNER TO ndawn;
 
 --