diff options
| author | Omar Roth <omarroth@hotmail.com> | 2018-03-29 21:41:05 -0500 |
|---|---|---|
| committer | Omar Roth <omarroth@hotmail.com> | 2018-03-29 21:41:05 -0500 |
| commit | 6c4cfbe39dc90c2014ae0755fe1a2bfaa255dbe6 (patch) | |
| tree | 77247323e793eed364769595334ead760516f660 /config/sql/users.sql | |
| parent | 4a7fc4ea697b238098145cad20b21dee7c04bbd3 (diff) | |
| download | invidious-6c4cfbe39dc90c2014ae0755fe1a2bfaa255dbe6.tar.gz invidious-6c4cfbe39dc90c2014ae0755fe1a2bfaa255dbe6.tar.bz2 invidious-6c4cfbe39dc90c2014ae0755fe1a2bfaa255dbe6.zip | |
Add users table
Diffstat (limited to 'config/sql/users.sql')
| -rw-r--r-- | config/sql/users.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/config/sql/users.sql b/config/sql/users.sql new file mode 100644 index 00000000..dde3b924 --- /dev/null +++ b/config/sql/users.sql @@ -0,0 +1,17 @@ +-- Table: public.users + +-- DROP TABLE public.users; + +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" +) +WITH ( + OIDS = FALSE +) +TABLESPACE pg_default; + +GRANT ALL ON TABLE public.users TO kemal; |