From ffdf2ea4c57a8c4b0cf99b106eb71dbfa6b1695a Mon Sep 17 00:00:00 2001 From: Omar Roth Date: Sat, 31 Mar 2018 10:30:17 -0500 Subject: Add email to user table --- config/sql/users.sql | 3 +++ 1 file changed, 3 insertions(+) (limited to 'config/sql/users.sql') diff --git a/config/sql/users.sql b/config/sql/users.sql index e46cd744..fc4adef5 100644 --- a/config/sql/users.sql +++ b/config/sql/users.sql @@ -8,6 +8,9 @@ CREATE TABLE public.users updated timestamp with time zone, notifications integer, subscriptions text[] COLLATE pg_catalog."default", + notifications_viewed timestamp with time zone, + email text COLLATE pg_catalog."default" NOT NULL, + CONSTRAINT users_email_key UNIQUE (email), CONSTRAINT users_id_key UNIQUE (id) ) WITH ( -- cgit v1.2.3