From a149597b813bf54fd71a4d1d89afb05029687a25 Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Sat, 3 Nov 2018 09:50:11 +0100 Subject: [PATCH] timestamp on email_change --- database/ndawn.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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; -- -- 2.39.2