diff options
| author | Omar Roth <omarroth@hotmail.com> | 2019-02-10 12:33:29 -0600 |
|---|---|---|
| committer | Omar Roth <omarroth@hotmail.com> | 2019-02-10 12:33:29 -0600 |
| commit | 3646395f1d8b200ebd33f3c0b65ad6bbaf0c7156 (patch) | |
| tree | cec5669ca5ea6b67758ded23dc8b3c1ed79e5313 /config | |
| parent | 8bbf351d04309680f3d9f425b49490c1d8bf2ecd (diff) | |
| download | invidious-3646395f1d8b200ebd33f3c0b65ad6bbaf0c7156.tar.gz invidious-3646395f1d8b200ebd33f3c0b65ad6bbaf0c7156.tar.bz2 invidious-3646395f1d8b200ebd33f3c0b65ad6bbaf0c7156.zip | |
Store session_ids in separate table
Diffstat (limited to 'config')
| -rw-r--r-- | config/sql/session_ids.sql | 24 | ||||
| -rw-r--r-- | config/sql/users.sql | 1 |
2 files changed, 24 insertions, 1 deletions
diff --git a/config/sql/session_ids.sql b/config/sql/session_ids.sql new file mode 100644 index 00000000..24491405 --- /dev/null +++ b/config/sql/session_ids.sql @@ -0,0 +1,24 @@ +-- Table: public.session_ids + +-- DROP TABLE public.session_ids; + +CREATE TABLE public.session_ids +( + id text NOT NULL, + email text, + issued timestamp with time zone, + CONSTRAINT session_ids_pkey PRIMARY KEY (id) +); + +GRANT ALL ON TABLE public.channel_videos TO kemal; + +-- Index: public.session_ids_id_idx + +-- DROP INDEX public.session_ids_id_idx; + +CREATE INDEX session_ids_id_idx + ON public.session_ids + USING btree + (id COLLATE pg_catalog."default"); + +
\ No newline at end of file diff --git a/config/sql/users.sql b/config/sql/users.sql index f806271c..536508a4 100644 --- a/config/sql/users.sql +++ b/config/sql/users.sql @@ -4,7 +4,6 @@ CREATE TABLE public.users ( - id text[] NOT NULL, updated timestamp with time zone, notifications text[], subscriptions text[], |