From ffdf2ea4c57a8c4b0cf99b106eb71dbfa6b1695a Mon Sep 17 00:00:00 2001
From: Omar Roth <omarroth@hotmail.com>
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

