diff options
| author | Omar Roth <omarroth@hotmail.com> | 2018-03-29 22:27:51 -0500 |
|---|---|---|
| committer | Omar Roth <omarroth@hotmail.com> | 2018-03-29 22:27:51 -0500 |
| commit | 0aa8ad9a7cc8581269cb5d5b44827951ee2369c3 (patch) | |
| tree | b37da3803612883a689bf07fbd90feea8372ae83 /config/sql | |
| parent | 6c4cfbe39dc90c2014ae0755fe1a2bfaa255dbe6 (diff) | |
| download | invidious-0aa8ad9a7cc8581269cb5d5b44827951ee2369c3.tar.gz invidious-0aa8ad9a7cc8581269cb5d5b44827951ee2369c3.tar.bz2 invidious-0aa8ad9a7cc8581269cb5d5b44827951ee2369c3.zip | |
Make user id unique
Diffstat (limited to 'config/sql')
| -rw-r--r-- | config/sql/users.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/config/sql/users.sql b/config/sql/users.sql index dde3b924..e46cd744 100644 --- a/config/sql/users.sql +++ b/config/sql/users.sql @@ -7,7 +7,8 @@ CREATE TABLE public.users id text COLLATE pg_catalog."default" NOT NULL, updated timestamp with time zone, notifications integer, - subscriptions text[] COLLATE pg_catalog."default" + subscriptions text[] COLLATE pg_catalog."default", + CONSTRAINT users_id_key UNIQUE (id) ) WITH ( OIDS = FALSE |