summaryrefslogtreecommitdiffstats
path: root/config/sql
diff options
context:
space:
mode:
Diffstat (limited to 'config/sql')
-rw-r--r--config/sql/users.sql3
1 files changed, 3 insertions, 0 deletions
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 (