summaryrefslogtreecommitdiffstats
path: root/config/sql
diff options
context:
space:
mode:
authorOmar Roth <omarroth@hotmail.com>2018-03-31 10:30:17 -0500
committerOmar Roth <omarroth@hotmail.com>2018-03-31 10:30:17 -0500
commitffdf2ea4c57a8c4b0cf99b106eb71dbfa6b1695a (patch)
treef810ea1a610e1eba0de66869be7afcef6b8cda14 /config/sql
parent0e30ddb7281ae233e7f9441ea8195f2a5fb2888d (diff)
downloadinvidious-ffdf2ea4c57a8c4b0cf99b106eb71dbfa6b1695a.tar.gz
invidious-ffdf2ea4c57a8c4b0cf99b106eb71dbfa6b1695a.tar.bz2
invidious-ffdf2ea4c57a8c4b0cf99b106eb71dbfa6b1695a.zip
Add email to user table
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 (